Full Text
City of Redmond, WA Cash Flow Summary - General Fund 2017-2018 Revenue BTD Expenditure BTD BTD On-going Budget Revenue Budget Expenditures Balance Balance Begin Bal. - - - - - 10,450,958 January 4,704,000 5,177,538 7,561,947 6,501,489 (1,323,951) 9,127,007 February 10,296,592 9,730,359 15,123,894 13,570,156 (3,839,798) 6,611,160 March 15,393,971 17,839,902 22,685,842 20,458,888 (2,618,986) 7,831,972 April 20,728,472 23,146,097 30,247,789 28,049,978 (4,903,881) 5,547,077 May 33,435,103 35,999,612 37,809,736 35,086,706 912,906 11,363,864 June 40,926,537 45,240,967 45,371,683 42,321,260 2,919,707 13,370,665 July 47,745,145 48,598,296 52,933,630 49,613,394 (1,015,098) 9,435,860 August 52,738,819 53,735,762 60,495,577 56,670,544 (2,934,782) 7,516,176 September 56,999,506 58,184,962 68,057,525 64,012,721 (5,827,759) 4,623,199 October 63,569,755 67,187,215 75,619,472 71,407,936 (4,220,722) 6,230,236 November 76,110,844 79,645,154 83,181,419 79,193,914 451,240 10,902,198 December 83,779,928 85,557,182 90,743,366 87,746,523 (2,189,341) 8,261,617 January 88,169,664 93,070,656 98,305,313 94,566,878 (1,496,222) 8,954,736 February 95,167,453 98,916,853 105,867,260 101,526,780 (2,609,927) 7,841,031 March 101,085,322 104,359,936 113,429,208 108,474,988 (4,115,052) 6,335,906 April 106,193,836 109,762,935 120,991,155 115,525,157 (5,762,221) 4,688,737 May 118,624,256 123,750,110 128,553,102 122,868,934 881,175 11,332,133 June 128,591,291 133,153,333 136,115,049 130,120,057 3,033,276 13,484,234 July 133,549,011 139,050,749 143,676,996 137,575,834 1,474,914 11,925,872 August 138,417,162 145,117,841 151,238,943 145,771,518 (653,677) 9,797,281 September 142,946,724 150,162,550 158,800,891 152,877,761 (2,715,211) 7,735,747 October 150,945,370 159,601,199 166,362,838 159,868,256 (267,058) 10,183,900 November 161,521,820 172,983,883 173,924,785 166,689,657 6,294,225 16,745,183 December 171,035,774 182,494,809 181,486,732 175,720,975 6,773,833 17,224,791 BTD = Biennium To Date The "on-going balance" column combines the beginning balance with the results from the previous months. Notes: Please see page 16 for explanations of negative trends, budget variances and other observations This report and the City's full budgets and financial reports are available on our web site at: www.redmond.gov This is a preliminary report prior to audit however all amounts are expected to be accurate. (20,000,000) (15,000,000) (10,000,000) (5,000,000) - 5,000,000 10,000,000 Cash Flows Without Beginning Balance 07/08 Biennium 09/10 Biennium 11/12 Biennium 13/14 Biennium 15/16 Biennium 17/18 Budget 17/18 Biennium ---PAGE BREAK--- City of Redmond, WA Revenue Summary - General Fund 2017-2018 General Fund Biennial Budget Actual Over / (Under) % January 4,704,000 5,177,538 10.07% February 10,296,592 9,730,359 -5.50% March 15,393,971 17,839,902 15.89% April 20,728,472 23,146,097 11.66% May 33,435,103 35,999,612 7.67% June 40,926,537 45,240,967 10.54% July 47,745,145 48,598,296 1.79% August 52,738,819 53,735,761 1.89% September 56,999,506 58,184,962 2.08% October 63,569,755 67,187,215 5.69% November 76,110,844 79,645,154 4.64% December 83,779,928 85,557,182 2.12% January 88,169,664 93,070,656 5.56% February 95,167,453 98,916,853 3.94% March 101,085,322 104,359,936 3.24% April 106,193,836 109,762,935 3.36% May 118,624,256 123,750,110 4.32% June 128,591,291 133,153,333 3.55% July 133,549,011 139,050,749 4.12% August 138,417,162 145,117,841 4.84% September 142,946,724 150,162,550 5.05% October 150,945,370 159,601,199 5.73% November 161,521,820 172,983,883 7.10% December 171,035,774 182,494,809 6.70% Percent collected to date 106.7% Normalized: adjusted for one-time sales tax revenue Property Tax Biennial Budget Actual Over / (Under) % January - - #DIV/0! February 33,292 31,098 -6.59% March 161,648 254,935 57.71% April 553,082 808,380 46.16% May 7,462,383 8,881,044 19.01% June 9,646,785 9,833,003 1.93% July 9,727,926 9,918,465 1.96% August 9,753,663 9,945,149 1.96% September 9,807,923 9,999,934 1.96% October 10,182,338 10,312,265 1.28% November 17,549,233 17,895,202 1.97% December 18,752,280 18,782,971 0.16% January 18,752,280 18,782,970 0.16% February 18,722,345 18,810,124 0.47% March 18,905,362 19,031,646 0.67% April 19,396,005 19,585,915 0.98% May 26,712,037 27,886,801 4.40% June 28,851,672 28,943,096 0.32% July 28,943,746 29,025,881 0.28% August 28,981,772 29,049,972 0.24% September 29,056,640 29,113,705 0.20% October 29,373,722 29,308,426 -0.22% November 36,669,680 37,407,884 2.01% December 38,391,175 38,204,681 -0.49% Percent collected to date 99.5% The charts on pages 2 through 6 illustrate General Fund revenues. It is within the General Fund that general taxes are accounted for. The blue (shaded) background is the current budget. The dark black solid line is the actual experience this biennium. The purple line is the most recent biennia while the blue, gray, orange, green and red lines are past years for reference. 22.45% of Total Budget- GF Property taxes are paid twice a year (in May and November). Most property taxes are accounted for in the General Fund however property taxes are also found in Funds 012, 035, 036, and 037. - 20,000,000 40,000,000 60,000,000 80,000,000 100,000,000 120,000,000 140,000,000 160,000,000 180,000,000 200,000,000 1 3 5 7 9 11 13 15 17 19 21 23 17/18 Budget 05/06 Biennium 07/08 Biennium 09/10 Biennium 11/12 Biennium 13/14 Biennium 15/16 Biennium 17/18 Actuals Total General Fund - 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 30,000,000 35,000,000 40,000,000 45,000,000 1 3 5 7 9 11 13 15 17 19 21 23 17/18 Budget 05/06 Biennium 07/08 Biennium 09/10 Biennium 11/12 Biennium 13/14 Biennium 15/16 Biennium 17/18 Actuals Property Tax 21% of Fund Page 2 ---PAGE BREAK--- City of Redmond, WA Revenue Summary - General Fund 2017-2018 Sales Tax Biennial Budget Actual Over / (Under) % January 1,712,955 1,633,561 -4.63% - February 3,445,975 3,258,923 -5.43% - March 5,331,621 5,321,194 -0.20% - April 7,224,260 7,046,783 -2.46% May 9,623,804 9,282,243 -3.55% June 11,657,243 11,704,603 0.41% July 14,028,908 12,335,553 -12.07% August 16,570,794 15,177,325 -8.41% September 18,534,167 17,712,344 -4.43% October 20,406,806 20,129,139 -1.36% November 22,315,142 22,656,820 1.53% December 24,935,879 24,916,572 -0.08% January 26,713,482 27,176,294 1.73% February 28,874,531 29,782,697 3.15% March 31,046,665 31,395,712 1.12% April 32,963,403 33,224,916 0.79% May 34,969,993 35,831,953 2.46% June 37,368,375 38,045,423 1.81% July 39,454,252 40,705,430 3.17% August 41,666,429 44,547,810 6.92% September 43,669,003 47,513,529 8.80% October 45,579,677 50,584,323 10.98% November 47,304,593 53,407,715 12.90% December 49,936,930 59,123,260 18.40% Percent collected to date 118.4% Normalized: adjusted for one-time sales tax revenue Utility / Other Taxes Biennial Budget Actual Over / (Under) % January 749,675 1,465,067 95.43% February 1,370,291 2,479,628 80.96% March 2,489,625 3,411,175 37.02% April 3,540,464 4,662,764 31.70% May 4,610,892 5,489,795 19.06% June 5,303,553 6,187,254 16.66% July 6,433,578 7,393,731 14.92% August 7,371,841 8,105,412 9.95% September 8,163,145 8,791,975 7.70% October 9,271,902 10,007,414 7.93% November 10,025,984 10,712,627 6.85% December 11,513,382 11,484,717 -0.25% January 12,195,859 12,750,242 4.55% February 13,094,310 13,726,136 4.83% March 14,375,666 14,569,747 1.35% April 15,584,798 15,802,882 1.40% May 16,412,330 16,692,488 1.71% June 17,636,442 17,387,284 -1.41% July 18,702,801 18,511,361 -1.02% August 19,459,272 19,146,404 -1.61% September 20,281,407 19,824,127 -2.25% October 21,490,101 20,980,516 -2.37% November 22,173,148 21,589,592 -2.63% December 23,946,157 22,392,078 -6.49% Percent collected to date 93.5% The total sales tax rate is 9.5% of the value of the sale of which 0.85% comes to the city for general government purposes and 0.01% for criminal justice. (most of the rest goes to other jurisdictions including 68% to the state). "Normalized" refers to taxes received not related to tax audits. Sales tax is the largest single revenue source in the General Fund. It is collected by the state and sent to the city about two months after the actual sales transaction. These amounts are net of $2.5 million in tax on new construction accounted for in the CIP. The utility tax rate is 6% of the gross revenues of electricity, telephone, cell phone, garbage and natural gas companies. The rate on cable television companies is Other taxes include admissions and gambling taxes. 29.20% of Total Budget- GF 14.00% of Total Budget- GF - 10,000,000 20,000,000 30,000,000 40,000,000 50,000,000 60,000,000 70,000,000 1 3 5 7 9 11 13 15 17 19 21 23 17/18 Budget 05/06 Biennium 07/08 Biennium 07/08 Biennium "normalized" 09/10 Biennium 11/12 Biennium "normalized" 11/12 Biennium 13/14 Biennium 15/16 Biennium 17/18 Actuals Sales Tax - 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 30,000,000 1 3 5 7 9 11 13 15 17 19 21 23 17/18 Budget 05/06 Biennium 07/08 Biennium 09/10 Biennium 11/12 Biennium 13/14 Biennium 15/16 Biennium 17/18 Actuals Utility and Other Taxes 32% of Fund 12% of Fund Page 4 ---PAGE BREAK--- City of Redmond, WA Revenue Summary - General Fund 2017-2018 Licenses & Permits Biennial Budget Actual Over / (Under) % January 1,689,104 1,378,912 -18.36% February 4,405,196 2,691,896 -38.89% March 4,937,330 5,466,064 10.71% April 5,619,944 6,372,424 13.39% May 6,258,941 6,925,496 10.65% June 6,863,044 7,846,034 14.32% July 7,527,481 8,566,560 13.80% August 8,128,594 9,478,174 16.60% September 8,674,284 9,865,156 13.73% October 9,298,909 10,709,771 15.17% November 9,699,381 11,543,352 19.01% December 10,256,248 11,765,641 14.72% January 11,629,562 15,162,535 30.38% February 14,714,922 16,763,967 13.92% March 15,332,719 17,516,902 14.25% April 16,004,648 18,538,681 15.83% May 16,904,074 19,803,264 17.15% June 17,715,997 20,975,762 18.40% July 18,388,330 22,256,958 21.04% August 18,849,717 23,137,191 22.75% September 19,307,673 23,661,804 22.55% October 19,979,851 24,400,940 22.13% November 20,567,999 25,087,786 21.97% December 21,459,794 25,591,401 19.25% Percent collected to date 119.3% Intergovernmental Biennial Budget Actual Over / (Under) % January 244,776 253,007 3.36% February 368,072 318,895 -13.36% March 1,032,835 1,746,550 69.10% April 1,621,613 1,983,822 22.34% May 3,199,535 2,645,849 -17.31% June 4,840,178 6,291,884 29.99% July 6,721,589 6,491,943 -3.42% August 6,862,508 6,592,797 -3.93% September 7,121,919 6,860,696 -3.67% October 8,964,621 10,498,967 17.12% November 11,184,835 10,760,715 -3.79% December 12,301,131 11,933,529 -2.99% January 12,464,544 12,152,176 -2.51% February 13,018,952 12,232,557 -6.04% March 13,840,745 13,614,376 -1.64% April 14,201,351 13,784,899 -2.93% May 15,414,597 14,085,292 -8.62% June 18,659,917 17,759,412 -4.83% July 19,008,047 18,000,934 -5.30% August 19,950,049 18,153,059 -9.01% September 20,272,046 18,463,987 -8.92% October 23,250,623 22,169,998 -4.65% November 23,443,575 22,807,839 -2.71% December 25,365,541 24,043,959 -5.21% Percent collected to date 94.8% Business license rates are $45.00 per employee within the business. The estimates for business license are $9.2 million for the biennium. The permits are largely development related and are estimated to be almost $12.2 million for the biennium. Intergovernmental revenues include contract payments by Fire District 34 for city service to that area (which is 57% of the total), state support for criminal justice efforts, state shared revenues for liquor taxes and liquor profits, and gas tax. The city accounts for King County EMS levy payments for basic life support in this account as well as a variety of smaller intergovernmental contract payments to the City. 12.55% of Total Budget- GF 14.83% of Total Budget- GF - 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 30,000,000 1 3 5 7 9 11 13 15 17 19 21 23 17/18 Budget 05/06 Biennium 07/08 Biennium 09/10 Biennium 11/12 Biennium 13/14 Biennium 15/16 Biennium 17/18 Actuals Licenses & Permits - 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 30,000,000 1 3 5 7 9 11 13 15 17 19 21 23 17/18 Budget 05/06 Biennium 07/08 Biennium 09/10 Biennium 11/12 Biennium 13/14 Biennium 15/16 Biennium 17/18 Actuals Intergovernmental 14% of Fund 13% of Fund Page 5 ---PAGE BREAK--- City of Redmond, WA Revenue Summary - General Fund 2017-2018 Charges for Service Biennial Budget Actual Over / (Under) % January 299,268 371,560 24.16% February 688,118 785,477 14.15% March 1,103,428 1,242,636 12.62% April 1,508,671 1,714,826 13.66% May 1,906,816 2,109,648 10.64% June 2,334,148 2,583,689 10.69% July 2,734,098 3,012,074 10.17% August 3,078,981 3,470,032 12.70% September 3,510,066 3,915,185 11.54% October 3,970,079 4,345,973 9.47% November 4,316,309 4,776,348 10.66% December 4,681,438 5,161,319 10.25% January 5,058,451 5,525,216 9.23% February 5,383,968 5,937,169 10.27% March 5,834,784 6,356,672 8.94% April 6,116,645 6,795,887 11.10% May 6,623,086 7,224,195 9.08% June 7,027,015 7,678,273 9.27% July 7,391,705 8,064,573 9.10% August 7,825,239 8,493,447 8.54% September 8,247,603 8,934,103 8.32% October 8,640,244 9,361,533 8.35% November 9,004,621 9,763,598 8.43% December 9,435,291 10,147,903 7.55% Percent collected to date 107.6% Fines & Forfeits Biennial Budget Actual Over / (Under) % January 29,681 26,686 -10.09% February 71,593 55,770 -22.10% March 113,490 188,721 66.29% April 189,824 270,523 42.51% May 241,323 305,033 26.40% June 274,992 359,131 30.60% July 338,604 395,866 16.91% August 430,332 442,858 2.91% September 475,479 475,742 0.06% October 526,368 557,700 5.95% November 571,816 597,728 4.53% December 627,197 636,853 1.54% January 652,280 688,978 5.63% February 707,752 770,564 8.87% March 758,407 868,703 14.54% April 809,610 917,487 13.32% May 864,545 971,456 12.37% June 911,465 1,017,607 11.65% July 959,887 1,059,881 10.42% August 1,004,273 1,105,453 10.07% September 1,047,720 1,146,792 9.46% October 1,097,220 1,189,718 8.43% November 1,125,899 1,221,006 8.45% December 1,182,000 1,247,026 5.50% Percent collected to date 105.5% Fines and forfeits collected by the district court on behalf of city for violations of city codes (traffic infractions and misdemeanors). The City accounted for this net of the amount sent to the state until October of 2007 when we began accounting for the full revenue. Charges for service include development services and chargebacks for city overhead to other (self-sustaining) funds. 5.52% of Total Budget- GF 0.69% of Total Budget- GF - 2,000,000 4,000,000 6,000,000 8,000,000 10,000,000 12,000,000 1 3 5 7 9 11 13 15 17 19 21 23 17/18 Budget 05/06 Biennium 07/08 Biennium 09/10 Biennium 11/12 Biennium 13/14 Biennium 15/16 Biennium 17/18 Actuals Charge for Service - 500,000 1,000,000 1,500,000 2,000,000 2,500,000 1 3 5 7 9 11 13 15 17 19 21 23 17/18 Budget 05/06 Biennium 07/08 Biennium 09/10 Biennium 11/12 Biennium 13/14 Biennium 15/16 Biennium 17/18 Actuals Fines & Forfeits 6% of Fund 1% of Fund Page 6 ---PAGE BREAK--- City of Redmond, WA Revenue Summary - General Fund 2017-2018 Miscellaneous Biennial Budget Actual Over / (Under) % January 2,911 48,746 1574.53% February 64,124 108,671 69.47% March 129,367 208,628 61.27% April 222,064 286,574 29.05% May 276,082 360,504 30.58% June 341,862 435,369 27.35% July 406,080 484,103 19.21% August 460,416 524,014 13.81% September 480,271 563,930 17.42% October 541,542 625,986 15.59% November 593,896 702,361 18.26% December 672,803 875,581 30.14% January 662,391 832,243 25.64% February 704,794 893,639 26.79% March 751,491 1,006,179 33.89% April 796,125 1,112,269 39.71% May 841,385 1,254,661 49.12% June 877,971 1,346,476 53.36% July 882,256 1,425,731 61.60% August 915,855 1,484,505 62.09% September 950,700 1,504,504 58.25% October 1,180,597 1,605,746 36.01% November 1,226,144 1,698,492 38.52% December 1,318,886 1,744,500 32.27% Percent collected to date 132.3% Miscellaneous revenues includes interest earnings on cash, rental revenues and other smaller revenues that do not fit into one of the above categories. 0.77% of Total Budget- GF (1,000,000) (500,000) - 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 1 3 5 7 9 11 13 15 17 19 21 23 17/18 Budget 05/06 Biennium 07/08 Biennium 09/10 Biennium 11/12 Biennium 13/14 Biennium 15/16 Biennium 17/18 Actuals Miscellaneous 1% of Fund Page 7 ---PAGE BREAK--- City of Redmond, WA Expenditure Report 2017-2018 Total General Fund Biennial Budget Actual Over / (Under) % January 7,561,947 6,501,489 -14.02% February 15,123,894 13,570,156 -10.27% March 22,685,842 20,458,888 -9.82% April 30,247,789 28,049,978 -7.27% May 37,809,736 35,086,706 -7.20% June 45,371,683 42,321,260 -6.72% July 52,933,630 49,613,394 -6.27% August 60,495,577 56,670,544 -6.32% September 68,057,525 64,012,721 -5.94% October 75,619,472 71,407,936 -5.57% November 83,181,419 79,193,914 -4.79% December 90,743,366 87,746,523 -3.30% January 98,305,313 94,566,878 -3.80% February 105,867,260 101,526,780 -4.10% March 113,429,208 108,474,988 -4.37% April 120,991,155 115,525,157 -4.52% May 128,553,102 122,868,934 -4.42% June 136,115,049 130,120,057 -4.40% July 143,676,996 137,575,834 -4.25% August 151,238,943 145,771,518 -3.62% September 158,800,891 152,877,761 -3.73% October 166,362,838 159,868,256 -3.90% November 173,924,785 166,689,657 -4.16% December 181,486,732 175,720,975 -3.18% % spent 96.82% Non-Departmental Biennial Budget Actual Over / (Under) % January 1,149,506 849,710 -26.08% February 2,299,011 1,966,776 -14.45% March 3,448,517 2,948,702 -14.49% April 4,598,023 3,892,765 -15.34% May 5,747,529 4,812,722 -16.26% June 6,897,034 5,732,479 -16.88% July 8,046,540 6,656,758 -17.27% August 9,196,046 7,660,254 -16.70% September 10,345,551 8,542,641 -17.43% October 11,495,057 9,702,253 -15.60% November 12,644,563 10,802,033 -14.57% December 13,794,068 13,299,365 -3.59% January 14,943,574 13,773,832 -7.83% February 16,093,080 14,584,148 -9.38% March 17,242,586 15,419,849 -10.57% April 18,392,091 16,253,202 -11.63% May 19,541,597 17,073,764 -12.63% June 20,691,103 17,873,520 -13.62% July 21,840,608 18,691,373 -14.42% August 22,990,114 20,438,509 -11.10% September 24,139,620 21,428,591 -11.23% October 25,289,125 22,424,105 -11.33% November 26,438,631 22,316,271 -15.59% December 27,588,137 24,421,724 -11.48% % spent 88.52% The General Fund accounts for services as described in each of the charts below. The blue (shaded) background is the current budget. The dark black solid line is the actual experience this year. The purple line is the last biennium with previous biennia in blue, gray, orange, green and red. Non-departmental includes insurance payments, transfers to capital improvement funds, payment to the district court, and other smaller general city payments. 15.20% of Total Fund - 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 30,000,000 1 3 5 7 9 11 13 15 17 19 21 23 17/18 Budget 05/06 Biennium 07/08 Biennium 09/10 Biennium 11/12 Biennium 13/14 Biennium 15/16 Biennium 17/18 Actuals Non-Department - 20,000,000 40,000,000 60,000,000 80,000,000 100,000,000 120,000,000 140,000,000 160,000,000 180,000,000 200,000,000 1 3 5 7 9 11 13 15 17 19 21 23 17/18 Budget 05/06 Biennium 07/08 Biennium 09/10 Biennium 11/12 Biennium 13/14 Biennium 15/16 Biennium 17/18 Actuals Total General Fund 14% of Fund Page 7 ---PAGE BREAK--- City of Redmond, WA Expenditure Report 2017-2018 Legislative Biennial Budget Actual Over / (Under) % January 14,318 9,160 -36.02% February 28,636 18,909 -33.97% March 42,954 30,144 -29.82% April 57,271 42,124 -26.45% May 71,589 52,679 -26.42% June 85,907 62,858 -26.83% July 100,225 74,815 -25.35% August 114,543 84,252 -26.45% September 128,861 115,677 -10.23% October 143,178 125,539 -12.32% November 157,496 134,934 -14.33% December 171,814 149,431 -13.03% January 186,132 159,105 -14.52% February 200,450 171,118 -14.63% March 214,768 182,282 -15.13% April 229,085 193,568 -15.50% May 243,403 205,261 -15.67% June 257,721 215,545 -16.36% July 272,039 227,064 -16.53% August 286,357 241,160 -15.78% September 300,675 252,366 -16.07% October 314,992 263,170 -16.45% November 329,310 271,959 -17.42% December 343,628 290,572 -15.44% % spent 84.56% Executive Biennial Budget Actual Over / (Under) % January 325,179 349,756 7.56% February 650,359 598,950 -7.90% March 975,538 879,808 -9.81% April 1,300,718 1,099,844 -15.44% May 1,625,897 1,388,522 -14.60% June 1,951,077 1,822,804 -6.57% July 2,276,256 2,085,071 -8.40% August 2,601,436 2,443,719 -6.06% September 2,926,615 2,817,535 -3.73% October 3,251,795 3,085,131 -5.13% November 3,576,974 3,417,869 -4.45% December 3,902,154 3,710,702 -4.91% January 4,227,333 4,037,047 -4.50% February 4,552,512 4,432,945 -2.63% March 4,877,692 4,768,405 -2.24% April 5,202,871 4,982,532 -4.23% May 5,528,051 5,239,464 -5.22% June 5,853,230 5,515,421 -5.77% July 6,178,410 5,823,633 -5.74% August 6,503,589 6,142,937 -5.55% September 6,828,769 6,399,838 -6.28% October 7,153,948 6,739,820 -5.79% November 7,479,128 7,017,387 -6.17% December 7,804,307 7,355,628 -5.75% % spent 94.25% Legislative budget is the budget for the City Council and related expenses. Executive budget provides for the mayor's office, city communications, customer service and transportation demand management (TDM). 4.30% of Total Fund 0.19% of Total Fund - 50,000 100,000 150,000 200,000 250,000 300,000 350,000 400,000 1 3 5 7 9 11 13 15 17 19 21 23 17/18 Budget 05/06 Biennium 07/08 Biennium 09/10 Biennium 11/12 Biennium 13/14 Biennium 15/16 Biennium 17/16 Actuals Legislative - 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 7,000,000 8,000,000 9,000,000 1 3 5 7 9 11 13 15 17 19 21 23 17/18 Budget 05/06 Biennium 07/08 Biennium 09/10 Biennium 11/12 Biennium 13/14 Biennium 15/16 Biennium 17/18 Actuals Executive 4% of Fund 0.17% of Fund Page 8 ---PAGE BREAK--- City of Redmond, WA Expenditure Report 2017-2018 Human Resources Biennial Budget Actual Over / (Under) % January 130,712 107,310 -17.90% February 261,423 228,900 -12.44% March 392,135 345,290 -11.95% April 522,847 456,983 -12.60% May 653,559 577,062 -11.70% June 784,270 697,021 -11.12% July 914,982 847,217 -7.41% August 1,045,694 973,836 -6.87% September 1,176,405 1,101,540 -6.36% October 1,307,117 1,223,529 -6.39% November 1,437,829 1,352,902 -5.91% December 1,568,541 1,512,036 -3.60% January 1,699,252 1,661,080 -2.25% February 1,829,964 1,785,150 -2.45% March 1,960,676 1,921,775 -1.98% April 2,091,387 2,064,769 -1.27% May 2,222,099 2,189,805 -1.45% June 2,352,811 2,335,656 -0.73% July 2,483,522 2,460,529 -0.93% August 2,614,234 2,599,676 -0.56% September 2,744,946 2,720,479 -0.89% October 2,875,658 2,854,950 -0.72% November 3,006,369 2,983,730 -0.75% December 3,137,081 3,136,754 -0.01% % spent 99.99% Finance -2.12% Biennial Budget Actual Over / (Under) % January 296,996 257,634 -13.25% February 593,991 512,815 -13.67% March 890,987 782,791 -12.14% April 1,187,983 1,087,922 -8.42% May 1,484,979 1,385,104 -6.73% June 1,781,974 1,681,019 -5.67% July 2,078,970 2,002,951 -3.66% August 2,375,966 2,305,170 -2.98% September 2,672,961 2,616,376 -2.12% October 2,969,957 2,756,015 -7.20% November 3,266,953 3,108,372 -4.85% December 3,563,949 3,375,464 -5.29% January 3,860,944 3,666,777 -5.03% February 4,157,940 3,927,126 -5.55% March 4,454,936 4,203,272 -5.65% April 4,751,931 4,538,248 -4.50% May 5,048,927 4,850,384 -3.93% June 5,345,923 5,167,297 -3.34% July 5,642,918 5,490,053 -2.71% August 5,939,914 5,778,796 -2.71% September 6,236,910 6,042,696 -3.11% October 6,533,906 6,327,878 -3.15% November 6,830,901 6,625,069 -3.01% December 7,127,897 6,916,886 -2.96% % spent 97.04% Human Resources accounts for the personnel, recruitments and related functions. Finance Department provides for accounting, payroll processing, purchasing / payments, financial planning, treasury within the finance discipline. 3.93% of Total Fund 1.73% of Total Fund - 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 1 3 5 7 9 11 13 15 17 19 21 23 17/18 Budget 05/06 Biennium 07/08 Biennium 09/10 Biennium 11/12 Biennium 13/14 Biennium 15/16 Biennium 17/18 Actuals Human Resources - 2,000,000 4,000,000 6,000,000 8,000,000 10,000,000 12,000,000 14,000,000 16,000,000 18,000,000 1 3 5 7 9 11 13 15 17 19 21 23 17/18 Budget 05/06 Biennium 07/08 Biennium 09/10 Biennium 11/12 Biennium 13/14 Biennium 15/16 Biennium 17/18 Actuals Finance 2% of Fund 4% of Fund Page 9 ---PAGE BREAK--- City of Redmond, WA Expenditure Report 2017-2018 Technology & Information Services Biennial Budget Actual Over / (Under) % January 546,497 357,167 -34.64% February 1,092,993 1,113,884 1.91% March 1,639,490 1,668,524 1.77% April 2,185,986 2,346,996 7.37% May 2,732,483 2,928,927 7.19% June 3,278,980 3,505,234 6.90% July 3,825,476 4,084,478 6.77% August 4,371,973 4,634,099 6.00% September 4,918,469 5,244,655 6.63% October 5,464,966 5,820,265 6.50% November 6,011,462 5,891,834 -1.99% December 6,557,959 6,416,581 -2.16% January 7,104,456 6,961,590 -2.01% February 7,650,952 7,497,979 -2.00% March 8,197,449 8,031,990 -2.02% April 8,743,945 8,611,224 -1.52% May 9,290,442 9,267,801 -0.24% June 9,836,939 9,776,729 -0.61% July 10,383,435 10,329,907 -0.52% August 10,929,932 10,866,920 -0.58% September 11,476,428 11,354,959 -1.06% October 12,022,925 11,916,312 -0.89% November 12,569,421 12,450,400 -0.95% December 13,115,918 12,990,154 -0.96% % spent 99.04% Public Works Biennial Budget Actual Over / (Under) % January 803,719 689,929 -14.16% February 1,607,439 1,492,796 -7.13% March 2,411,158 2,260,118 -6.26% April 3,214,878 2,947,109 -8.33% May 4,018,597 3,667,722 -8.73% June 4,822,317 4,529,061 -6.08% July 5,626,036 5,301,825 -5.76% August 6,429,755 5,987,939 -6.87% September 7,233,475 6,691,261 -7.50% October 8,037,194 7,593,298 -5.52% November 8,840,914 8,536,001 -3.45% December 9,644,633 9,260,289 -3.99% January 10,448,352 10,076,216 -3.56% February 11,252,072 10,798,441 -4.03% March 12,055,791 11,537,614 -4.30% April 12,859,511 12,217,681 -4.99% May 13,663,230 12,984,142 -4.97% June 14,466,950 13,690,539 -5.37% July 15,270,669 14,393,771 -5.74% August 16,074,388 15,162,756 -5.67% September 16,878,108 15,899,303 -5.80% October 17,681,827 16,743,678 -5.31% November 18,485,547 17,618,885 -4.69% December 19,289,266 18,643,464 -3.35% % spent 96.65% Public Works within the General Fund accounts for maintenance, street maintenance, traffic systems, construction inspection as well as department oversight. 10.63% of Total Fund 7.23% of Total Fund Technology & Information Service Department includes general fund interfund transfers to 520 fund (TIS), City Clerk and Print Shop. City Clerk (GF) supports the Mayor and City Council, oversees the Hearing Examiner function, coordinates City elections and monitors state legislative actions. Effective April 1, 2017, Finance and Information Services Department is seperated into Finance Department and TIS Department.City Clerk and Print Shop fall under TIS Department. - 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 1 3 5 7 9 11 13 15 17 19 21 23 17/18 Budget 05/06 Biennium 07/08 Biennium 09/10 Biennium 11/12 Biennium 13/14 Biennium 15/16 Biennium 17/18 Actuals Public Works - 2,000,000 4,000,000 6,000,000 8,000,000 10,000,000 12,000,000 14,000,000 1 3 5 7 9 11 13 15 17 19 21 23 17/18 Budget 15/16 Biennium 17/18 Actuals Technology & Information Services 7% of Fund 11% of Fund Page 10 ---PAGE BREAK--- City of Redmond, WA Expenditure Report 2017-2018 Parks Biennial Budget Actual Over / (Under) % January 562,325 420,390 -25.24% February 1,124,650 849,052 -24.51% March 1,686,975 1,354,385 -19.72% April 2,249,300 1,950,781 -13.27% May 2,811,624 2,536,668 -9.78% June 3,373,949 3,105,362 -7.96% July 3,936,274 3,748,485 -4.77% August 4,498,599 4,359,111 -3.10% September 5,060,924 4,985,645 -1.49% October 5,623,249 5,492,942 -2.32% November 6,185,574 6,000,067 -3.00% December 6,747,899 6,460,259 -4.26% January 7,310,223 6,907,883 -5.50% February 7,872,548 7,362,491 -6.48% March 8,434,873 7,978,003 -5.42% April 8,997,198 8,553,096 -4.94% May 9,559,523 9,137,287 -4.42% June 10,121,848 9,795,818 -3.22% July 10,684,173 10,461,014 -2.09% August 11,246,498 11,139,034 -0.96% September 11,808,822 11,720,030 -0.75% October 12,371,147 12,226,938 -1.17% November 12,933,472 12,698,156 -1.82% December 13,495,797 13,171,972 -2.40% % spent 97.60% Fire Biennial Budget Actual Over / (Under) % January 1,612,249 1,438,031 -10.81% February 3,224,497 2,837,066 -12.02% March 4,836,746 4,320,320 -10.68% April 6,448,995 5,901,525 -8.49% May 8,061,243 7,375,912 -8.50% June 9,673,492 8,794,449 -9.09% July 11,285,741 10,407,914 -7.78% August 12,897,989 11,940,101 -7.43% September 14,510,238 13,534,443 -6.72% October 16,122,487 15,298,696 -5.11% November 17,734,735 17,152,087 -3.29% December 19,346,984 18,687,417 -3.41% January 20,959,233 20,276,125 -3.26% February 22,571,481 21,805,634 -3.39% March 24,183,730 23,280,114 -3.74% April 25,795,979 24,931,868 -3.35% May 27,408,227 26,589,199 -2.99% June 29,020,476 28,257,603 -2.63% July 30,632,725 30,095,693 -1.75% August 32,244,973 31,796,204 -1.39% September 33,857,222 33,428,314 -1.27% October 35,469,471 34,973,515 -1.40% November 37,081,719 36,940,970 -0.38% December 38,693,968 38,690,517 -0.01% % spent 99.99% Parks within the General Fund provide for the senior center, some maintenance and some recreation activities (as well as department oversight). The parks planning function is also in this account. The Fire Department basic services are provided for in this account. In addition, "advanced life support" is accounted for in Fund 122 and Fire Services Levy activity is found in Fund 035. 7.44% of Total Fund 21.32% of Total Fund - 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 30,000,000 35,000,000 40,000,000 45,000,000 1 3 5 7 9 11 13 15 17 19 21 23 17/18 Budget 05/06 Biennium 07/08 Biennium 09/10 Biennium 11/12 Biennium 13/14 Biennium 15/16 Biennium 17/18 Actuals Fire - 2,000,000 4,000,000 6,000,000 8,000,000 10,000,000 12,000,000 14,000,000 16,000,000 1 3 5 7 9 11 13 15 17 19 21 23 17/18 Budget 05/06 Biennium 07/08 Biennium 09/10 Biennium 11/12 Biennium 13/14 Biennium 15/16 Biennium 17/18 Actuals Parks 7% of Fund 22% of Fund Page 11 ---PAGE BREAK--- City of Redmond, WA Expenditure Report 2017-2018 Police Biennial Budget Actual Over / (Under) % January 1,416,797 1,373,662 -3.04% February 2,833,593 2,624,441 -7.38% March 4,250,390 3,868,773 -8.98% April 5,667,187 5,593,597 -1.30% May 7,083,984 6,960,848 -1.74% June 8,500,780 8,391,796 -1.28% July 9,917,577 9,725,865 -1.93% August 11,334,374 10,988,187 -3.05% September 12,751,170 12,345,654 -3.18% October 14,167,967 13,652,860 -3.64% November 15,584,764 15,214,639 -2.37% December 17,001,561 16,452,828 -3.23% January 18,418,357 17,918,584 -2.71% February 19,835,154 19,313,476 -2.63% March 21,251,951 20,621,367 -2.97% April 22,668,747 21,867,260 -3.54% May 24,085,544 23,298,421 -3.27% June 25,502,341 24,684,085 -3.21% July 26,919,137 26,012,929 -3.37% August 28,335,934 27,298,085 -3.66% September 29,752,731 28,628,970 -3.78% October 31,169,528 29,918,785 -4.01% November 32,586,324 31,556,693 -3.16% December 34,003,121 33,074,789 -2.73% % spent 97.27% Planning Biennial Budget Actual Over / (Under) % January 710,526 655,232 -7.78% February 1,421,051 1,330,488 -6.37% March 2,131,577 2,010,237 -5.69% April 2,842,102 2,734,892 -3.77% May 3,552,628 3,400,542 -4.28% June 4,263,153 3,999,178 -6.19% July 4,973,679 4,678,016 -5.94% August 5,684,204 5,293,876 -6.87% September 6,394,730 6,017,294 -5.90% October 7,105,255 6,657,408 -6.30% November 7,815,781 7,583,175 -2.98% December 8,526,306 8,422,150 -1.22% January 9,236,832 9,128,639 -1.17% February 9,947,357 9,848,273 -1.00% March 10,657,883 10,530,316 -1.20% April 11,368,408 11,311,709 -0.50% May 12,078,934 12,033,407 -0.38% June 12,789,459 12,807,844 0.14% July 13,499,985 13,589,869 0.67% August 14,210,510 14,307,441 0.68% September 14,921,036 15,002,214 0.54% October 15,631,561 15,479,106 -0.98% November 16,342,087 16,210,138 -0.81% December 17,052,612 17,028,517 -0.14% % spent 99.86% The Police Department services are provided for within this account. Other activity occurs in other funds (Fund 126 - Drug Enforcement and Fund 036 - Police Services Levy Funds). The Planning Department is largely accounted for in this budget which includes the permit center, long-range and short-range planning, and plan reviews. 18.74% of Total Fund 9.40% of Total Fund - 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 30,000,000 35,000,000 40,000,000 1 3 5 7 9 11 13 15 17 19 21 23 17/18 Budget 05/06 Biennium 07/08 Biennium 09/10 Biennium 11/12 Biennium 13/14 Biennium 15/16 Biennium 17/18 Actuals Police - 2,000,000 4,000,000 6,000,000 8,000,000 10,000,000 12,000,000 14,000,000 16,000,000 18,000,000 1 3 5 7 9 11 13 15 17 19 21 23 17/18 Budget 05/06 Biennium 07/08 Biennium 09/10 Biennium 11/12 Biennium 13/14 Biennium 15/16 Biennium 17/18 Actuals Planning 19% of Fund 10% of Fund Page 12 ---PAGE BREAK--- City of Redmond, WA Summary - Operating Funds 2017-2018 Recreation Activity Fund (Fund 110) Biennial Budget Actual Over / (Under) % January 147,347 154,699 4.99% February 341,040 290,045 -14.95% March 568,191 478,114 -15.85% April 799,875 644,283 -19.45% May 1,008,524 842,541 -16.46% June 1,294,298 1,043,217 -19.40% July 1,648,081 1,381,971 -16.15% August 2,127,194 1,772,243 -16.69% September 2,462,160 1,984,826 -19.39% October 2,695,890 2,134,980 -20.81% November 2,926,453 2,332,642 -20.29% December 3,182,789 2,661,740 -16.37% January 3,353,438 2,802,902 -16.42% February 3,559,674 3,007,996 -15.50% March 3,805,407 3,210,733 -15.63% April 4,038,015 3,415,606 -15.41% May 4,271,180 3,599,806 -15.72% June 4,543,483 3,805,511 -16.24% July 4,933,614 4,122,479 -16.44% August 5,396,928 4,594,400 -14.87% September 5,763,285 4,809,804 -16.54% October 6,041,628 4,950,497 -18.06% November 6,296,422 5,110,583 -18.83% December 6,556,171 5,387,708 -17.82% BTD Status 82.18% Arts Activity Fund (Fund 011) Biennial Budget Actual Over / (Under) % January 18,344 8,759 -52.25% February 53,182 16,176 -69.58% March 69,447 28,176 -59.43% April 99,561 41,780 -58.04% May 123,737 50,493 -59.19% June 157,771 60,204 -61.84% July 220,532 101,751 -53.86% August 282,562 154,843 -45.20% September 326,726 215,555 -34.03% October 357,290 220,502 -38.28% November 394,414 232,766 -40.98% December 451,547 257,190 -43.04% January 473,691 261,871 -44.72% February 520,435 271,832 -47.77% March 549,798 283,968 -48.35% April 573,856 295,575 -48.49% May 598,449 306,279 -48.82% June 635,220 326,791 -48.55% July 685,325 368,033 -46.30% August 742,631 416,970 -43.85% September 788,349 474,626 -39.79% October 824,347 495,547 -39.89% November 849,844 538,265 -36.66% December 883,326 577,809 -34.59% BTD Status 65.41% These charts include a lighter solid (green) revenue line for the fund. The dashed line is the revenue without beginning fund balance. The Recreation Activity fund is a self sustaining (by fees collected) for recreation activities. The Arts Activity Fund accounts for salaries and benefits that support the arts programs within the City. Revenues are primarily a $1.50 per capita transfer from the General Fund - 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 7,000,000 1 3 5 7 9 11 13 15 17 19 21 23 Budget 15/16 Biennium Total Revenue New Revenue Actual Expenditures Recreation Activity - 100,000 200,000 300,000 400,000 500,000 600,000 700,000 800,000 900,000 1,000,000 1 3 5 7 9 11 13 15 17 19 21 23 Budget 15/16 Biennium Series4 New Revenue Actual Expenditures Arts Activity Revenue in this (other funds) section include beginning fund balances. Page 13 ---PAGE BREAK--- City of Redmond, WA Summary - Operating Funds 2017-2018 Parks M&O Fund (Fund 012) Biennial Budget Actual Over / (Under) % January 107,156 95,541 -10.84% February 239,658 185,019 -22.80% March 397,129 275,495 -30.63% April 557,205 375,916 -32.54% May 726,234 485,216 -33.19% June 919,303 587,254 -36.12% July 1,121,723 692,943 -38.23% August 1,326,928 814,800 -38.60% September 1,524,236 976,183 -35.96% October 1,690,717 1,125,742 -33.42% November 1,835,759 1,285,794 -29.96% December 2,076,913 1,411,546 -32.04% January 2,206,061 1,766,277 -19.94% February 2,358,596 1,927,828 -18.26% March 2,539,712 2,077,795 -18.19% April 2,722,191 2,199,333 -19.21% May 2,922,997 2,324,904 -20.46% June 3,112,054 2,441,294 -21.55% July 3,300,640 2,554,422 -22.61% August 3,495,475 2,681,110 -23.30% September 3,682,843 2,801,917 -23.92% October 3,872,068 2,925,435 -24.45% November 4,027,012 3,041,560 -24.47% December 4,267,701 3,285,040 -23.03% BTD Status 76.97% Water / Wastewater O&M Fund (Fund 401) Biennial Budget Actual Over / (Under) % January 2,955,013 3,122,780 5.68% February 6,438,417 6,395,274 -0.67% March 10,218,115 8,805,971 -13.82% April 13,345,853 11,549,307 -13.46% May 17,181,089 15,820,679 -7.92% June 21,104,198 17,601,663 -16.60% July 24,483,174 20,955,452 -14.41% August 28,162,278 23,939,638 -14.99% September 31,943,562 26,516,217 -16.99% October 34,537,933 27,944,660 -19.09% November 37,756,403 32,037,106 -15.15% December 43,249,575 34,448,311 -20.35% January 46,818,509 39,021,394 -16.65% February 51,380,163 41,566,572 -19.10% March 55,287,563 44,579,910 -19.37% April 57,870,150 47,470,746 -17.97% May 61,651,038 50,534,986 -18.03% June 65,317,335 55,360,796 -15.24% July 68,554,350 57,064,225 -16.76% August 72,289,828 61,203,514 -15.34% September 76,112,333 64,341,408 -15.47% October 79,140,209 67,867,119 -14.24% November 82,664,433 70,288,750 -14.97% December 89,390,099 73,084,589 -18.24% BTD Status 81.76% The Water / Wastewater O&M Fund accounts for the operations of the city's water and wastewater utilities. A transfer from these revenues is made to support the capital improvements necessary to maintain and develop related facilities. These improvements are accounted for in Fund 403. The Parks M&O Fund accounts for voter approved special operating levies to support the maintenance of the City's park system. - 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 4,000,000 4,500,000 1 3 5 7 9 11 13 15 17 19 21 23 Budget 15/16 Biennium Total Revenue New Revenue Actual Expenditures Parks M&O - 10,000,000 20,000,000 30,000,000 40,000,000 50,000,000 60,000,000 70,000,000 80,000,000 90,000,000 100,000,000 1 3 5 7 9 11 13 15 17 19 21 23 Budget 15/16 Biennium Series4 New Revenue Actual Expenditures Water / Wastewater O&M Revenue in this (other funds) section include beginning fund balances. Page 14 ---PAGE BREAK--- City of Redmond, WA Summary - Operating Funds 2017-2018 Stormwater O&M Fund (Fund 405) Biennial Budget Actual Over / (Under) % January 783,299 880,256 12.38% February 1,935,849 1,819,831 -5.99% March 3,359,601 2,776,210 -17.36% April 4,373,916 8,137,329 86.04% May 5,374,206 9,089,796 69.14% June 6,481,923 5,802,304 -10.48% July 7,235,477 6,817,279 -5.78% August 8,172,191 7,786,820 -4.72% September 9,105,690 8,727,409 -4.15% October 9,949,897 9,786,304 -1.64% November 10,864,411 11,034,165 1.56% December 12,225,142 11,839,559 -3.15% January 13,517,284 13,012,439 -3.73% February 15,200,070 13,996,130 -7.92% March 16,265,624 15,009,488 -7.72% April 17,281,800 15,948,677 -7.71% May 18,430,163 17,167,388 -6.85% June 19,542,204 18,184,869 -6.95% July 20,388,348 19,193,457 -5.86% August 21,369,720 20,164,708 -5.64% September 27,540,851 21,240,307 -22.88% October 28,510,971 22,244,393 -21.98% November 29,668,456 23,343,804 -21.32% December 33,706,365 24,643,850 -26.89% BTD Status 73.11% Technology & Information Services Fund (520) Biennial Budget Actual Over / (Under) % January 620,643 412,584 -38.28% February 1,241,287 1,085,068 -12.59% March 1,861,930 1,556,947 -16.38% April 2,482,573 1,907,028 -23.18% May 3,103,216 2,651,874 -14.54% June 3,723,860 3,312,702 -11.04% July 4,344,503 3,754,386 -13.58% August 4,965,146 4,157,002 -16.28% September 5,585,789 4,464,722 -20.07% October 6,206,433 4,983,847 -19.70% November 6,827,076 5,468,828 -19.90% December 7,447,719 5,775,427 -22.45% January 8,068,362 6,839,964 -15.22% February 8,689,006 7,245,037 -16.62% March 9,309,649 7,662,049 -17.70% April 9,930,292 8,044,565 -18.99% May 10,550,935 8,496,367 -19.47% June 11,171,579 8,987,705 -19.55% July 11,792,222 9,503,814 -19.41% August 12,412,865 10,003,622 -19.41% September 13,033,508 10,355,805 -20.54% October 13,654,152 10,732,878 -21.39% November 14,274,795 11,167,757 -21.77% December 14,895,438 11,650,915 -21.78% % spent 78.22% The Stormwater O&M Fund accounts for the operations and maintenance activities related to managing surface and storm water. Information Technology (Fund 520) provides for applications support, service desk, GIS and Network Services. City Clerk (GF) supports the Mayor and City Council, oversees the Hearing Examiner function, coordinates City elections and monitors state legislative actions. - 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 30,000,000 35,000,000 40,000,000 1 3 5 7 9 11 13 15 17 19 21 23 Budget 15/16 Biennium Total Revenue New Revenue Actual Expenditures Stormwater O&M - 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 30,000,000 35,000,000 40,000,000 1 3 5 7 9 11 13 15 17 19 21 23 Budget 15/16 Biennium Total Revenue New Revenue Actual Expenditures Technology & Information Services Revenue in this (other funds) section include beginning fund balances. Page 15 ---PAGE BREAK--- Beginning Balance Revenues Expenditure Budget Expenditures Ending Balance % Expended Arts Activity 303,139 589,599 883,326 577,809 314,928 65.41% Business Tax 1,317,099 10,834,047 11,602,099 10,939,250 1,211,896 94.29% Capital Replacement Reserve 2,933,328 3,458,280 6,388,142 2,084,680 4,306,928 32.63% Community Events 84,293 914,148 968,514 943,239 55,202 97.39% Fire Equipment Reserve 1,907,147 894,948 2,825,548 90,295 2,711,800 3.20% Fire Levy Fund 993,160 5,118,232 5,942,773 5,598,222 513,170 94.20% General Govt'l Major Maint 1,015,236 17,622,659 18,637,895 17,835,871 802,024 95.70% General Fund 10,450,958 178,466,886 181,486,732 175,720,975 13,196,869 96.82% Human Services Grants 23,090 2,349,193 2,350,947 2,335,729 36,554 99.35% Operating Reserve 7,184,282 639,245 7,903,527 622,795 7,200,732 7.88% Parks Levy Fund 620,862 525,109 1,319,458 587,256 558,716 44.51% Parks Maint. & Operations 1,313,315 2,776,979 4,267,701 3,285,040 805,253 76.97% Parks Maintenance 40,004 4,762,264 4,773,082 3,596,243 1,206,025 75.34% Police Levy Fund 4,332,063 4,917,463 9,107,670 4,993,960 4,255,566 54.83% Real Property Fund 1,987,226 162,436 2,237,226 1,642,368 507,294 73.41% Transportation Maint. Prjt 3,853,765 2,284,936 6,138,701 5,450,325 688,376 88.79% TOTAL GENERAL GOV'T 38,358,967 236,316,424 266,833,341 236,304,057 38,371,334 88.56% Advanced Life Support 822,663 14,016,622 15,706,190 13,625,578 1,213,707 86.75% Cable Access Fund 910,308 17,951 910,308 382,767 545,491 42.05% Drug Enforcement 133,933 37,762 141,133 46,227 125,468 32.75% Fire Donations 214,206 149,575 345,392 79,667 284,114 23.07% Fleet Maintenance 6,078,264 5,370,406 11,137,496 9,653,971 1,794,699 86.68% General Gov't Capital 1,271,808 8,670,578 8,722,290 6,989,356 2,953,030 80.13% Information Technology 2,054,204 12,885,016 14,895,438 11,650,915 3,288,305 78.22% Insurance 1,361,651 2,173,770 3,557,262 2,477,849 1,057,572 69.66% Medical Self Insurance 9,303,895 24,897,092 30,256,723 24,215,644 9,985,343 80.03% Development Review 1,113,675 5,687,244 6,640,007 2,809,656 3,991,263 42.31% Non-Voted Bonds 2,190,199 10,866,965 13,445,884 11,236,363 1,820,801 83.57% Novelty Hill Water Projects 7,379,159 1,579,311 8,958,470 1,119,542 7,838,929 12.50% Novelty Hill Utility 6,027,060 15,605,279 20,130,397 13,552,622 8,079,717 67.32% Novelty Hill Wastewater Projects 7,850,095 1,712,256 540,000 1,199 9,561,151 0.22% Operating Grants 758,641 3,297,230 4,074,455 3,388,506 667,364 83.16% Parks Capital Projects 7,490,270 15,799,354 23,289,624 19,973,967 3,315,657 85.76% Real Estate Excise Tax 7,541,816 14,909,939 19,171,816 17,580,000 4,871,755 91.70% Recreational Activity 588,014 5,083,887 6,556,171 5,387,708 284,193 82.18% Solid Waste Recycling 667,858 2,015,716 2,583,553 1,719,217 964,357 66.54% Stormwater Capital 23,722,806 17,264,632 30,299,689 18,816,725 22,170,714 62.10% Stormwater Management 6,528,334 30,342,944 33,706,365 24,643,850 12,227,427 73.11% Tourism Hotel/Motel 642,720 1,014,759 1,657,972 853,197 804,282 51.46% Transportation Capital Projects 21,459,069 27,134,545 57,617,436 30,743,283 17,850,331 53.36% Wastewater Construction 8,442,714 7,619,211 6,960,543 3,215,123 12,846,802 46.19% Water Capital 14,785,900 8,294,623 9,573,115 6,624,891 16,455,632 69.20% Water / Sewer Utility 14,867,222 77,508,881 89,390,099 73,084,589 19,291,514 81.76% Worker's Compensation 537,778 3,783,318 4,197,634 4,099,410 221,685 97.66% 193,103,229 554,055,289 691,298,803 544,275,880 202,882,638 78.73% GRAND TOTAL FUND City of Redmond, WA All Funds Recap December-18 (Note - Biennial Budget) Page 15 ---PAGE BREAK--- Notes and explanations: A brief recap of highlighted items from the previous page: Negative Budget Amounts There are no funds with negative budget amounts. Negative Ending Balances There are no funds with negative Ending Balances. Page 16 ---PAGE BREAK--- Beginning Balance Revenues Expenditure Budget* Expenditures Ending Balance % Expended Parks Maintenance 40,004 4,762,264 4,773,082 3,596,243 1,206,025 75.34% Transportation Maint. Prjt 3,853,765 2,284,936 6,138,701 5,450,325 688,376 88.79% General Govt'l Major Maint 1,015,236 17,622,659 18,637,895 17,835,871 802,024 95.70% General Gov't Capital 1,271,808 8,670,578 8,722,290 6,989,356 2,953,030 80.13% Novelty Hill Water Pjts 7,379,159 1,579,311 8,958,470 1,119,542 7,838,929 12.50% Novelty Hill Wastewtr Pjts 7,850,095 1,712,256 540,000 1,199 9,561,151 0.22% Parks Capital Pjts 7,490,270 18,947,128 23,289,624 19,973,967 6,463,431 85.76% Stormwater Capital 23,722,806 17,264,632 30,299,689 18,816,725 22,170,714 62.10% Transportation Capital Pjts 21,459,069 27,134,545 57,617,436 30,743,283 17,850,331 53.36% Wastewater Construction 8,442,714 7,619,211 6,960,543 3,215,123 12,846,802 46.19% Water Capital 14,785,900 8,294,623 9,573,115 6,624,891 16,455,632 69.20% 97,310,826 115,892,143 175,510,845 114,366,525 98,836,444 65.16% Notes and explanations: City of Redmond, WA Capital Funds Recap December-18 (Note - Biennial Budget) FUND GRAND TOTAL Page 17