Full Text
City of Redmond, WA Cash Flow Summary - General Fund 2019-2020 Revenue BTD Expenditure BTD BTD On-going Budget Revenue Budget Expenditures Balance Balance Begin Bal. - - - - 8,904,104 January 5,470,592 6,998,784 8,266,624 6,832,912 165,872 9,069,976 February 10,984,523 16,533,247 - March 18,097,749 24,799,871 - April 23,398,144 33,066,495 - May 39,538,848 41,333,119 - June 47,216,051 49,599,742 - July 51,770,809 57,866,366 - August 57,066,312 66,132,990 - September 61,949,563 74,399,613 - October 70,089,365 82,666,237 - November 83,955,570 90,932,861 - December 90,653,368 99,199,485 - January 96,807,563 107,466,108 - February 104,771,555 115,732,732 - March 110,977,042 123,999,356 - April 117,081,262 132,265,979 - May 131,217,032 140,532,603 - June 142,560,895 148,799,227 - July 148,335,724 157,065,850 - August 153,817,895 165,332,474 - September 158,696,906 173,599,098 - October 168,180,782 181,865,722 - November 181,583,191 190,132,345 - December 189,494,865 198,398,969 - 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 17/18 Biennium 19/20 Budget 19/20 BTD Balance 1 ---PAGE BREAK--- City of Redmond, WA Revenue Summary - General Fund 2019-2020 General Fund Biennial Budget Actual Over / (Under) % January 5,470,592 6,998,784 27.93% February 10,984,523 March 18,097,749 April 23,398,144 May 39,538,848 June 47,216,051 July 51,770,809 August 57,066,312 September 61,949,563 October 70,089,365 November 83,955,570 December 90,653,368 January 96,807,563 February 104,771,555 March 110,977,042 April 117,081,262 May 131,217,032 June 142,560,895 July 148,335,724 August 153,817,895 September 158,696,906 October 168,180,782 November 181,583,191 December 189,494,865 Percent collected to date 3.7% Property Tax Biennial Budget Actual Over / (Under) % January - - #DIV/0! February 31,259 March 186,709 April 668,617 May 9,284,325 June 10,501,825 July 10,594,529 August 10,621,435 September 10,677,292 October 11,072,590 November 19,370,012 December 20,282,880 January 20,282,880 February 20,204,252 March 20,421,198 April 21,093,558 May 29,957,404 June 31,235,756 July 31,340,477 August 31,377,254 September 31,469,183 October 31,784,218 November 40,434,535 December 41,313,377 Percent collected to date #N/A 21.80% 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. 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. - 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 19/20 Budget 19/20 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 19/20 Budget 19/20 Actuals Property Tax 0% of Fund 2 ---PAGE BREAK--- City of Redmond, WA Revenue Summary - General Fund 2019-2020 Sales Tax Biennial Budget Actual Over / (Under) % January 1,829,851 3,565,829 94.87% - February 3,749,048 - March 5,703,153 - April 7,300,906 May 9,325,626 June 11,761,936 July 13,363,867 August 15,934,402 September 18,365,581 October 20,484,745 November 22,840,167 December 25,752,067 January 27,783,780 February 30,721,511 March 32,884,230 April 35,108,657 May 37,448,852 June 40,191,882 July 42,881,954 August 46,045,240 September 48,519,295 October 51,093,003 November 53,626,036 December 57,707,905 Percent collected to date 6.2% Utility / Other Taxes Biennial Budget Actual Over / (Under) % January 1,433,370 1,164,848 -18.73% February 1,918,142 March 3,293,103 April 4,364,934 May 5,643,269 June 6,449,688 July 7,533,193 August 8,545,973 September 9,434,715 October 10,655,757 November 11,354,431 December 12,560,941 January 13,766,702 February 14,829,260 March 15,943,728 April 17,180,764 May 17,948,754 June 19,403,182 July 20,651,518 August 21,469,023 September 22,314,885 October 23,569,511 November 24,138,202 December 24,994,923 Percent collected to date 4.7% 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. 30.45% of Total Budget- GF 13.19% 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 19/20 Budget 19/20 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 19/20 Budget 19/20 Actuals Utility and Other Taxes 48% of Fund 16% of Fund 3 ---PAGE BREAK--- City of Redmond, WA Revenue Summary - General Fund 2019-2020 Licenses & Permits Biennial Budget Actual Over / (Under) % January 1,624,493 1,431,492 -11.88% February 4,169,050 March 5,713,270 April 6,495,068 May 7,286,020 June 8,205,947 July 9,022,069 August 9,801,940 September 10,516,781 October 11,320,636 November 11,927,889 December 12,409,108 January 14,855,639 February 17,651,289 March 18,450,572 April 19,372,273 May 20,620,783 June 21,764,094 July 22,827,255 August 23,552,431 September 24,093,909 October 24,807,826 November 25,540,182 December 26,408,980 Percent collected to date 5.4% Intergovernmental Biennial Budget Actual Over / (Under) % January 365,242 197,435 -45.94% February 453,282 March 1,932,649 April 2,511,708 May 5,421,148 June 7,075,439 July 7,487,788 August 7,675,610 September 7,982,961 October 10,915,349 November 12,284,300 December 12,927,086 January 13,150,485 February 13,989,975 March 15,287,535 April 15,721,001 May 16,077,094 June 20,268,761 July 20,516,557 August 20,657,614 September 20,989,365 October 25,070,008 November 25,483,175 December 26,170,675 Percent collected to date 0.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. 13.94% of Total Budget- GF 13.81% 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 19/20 Budget 19/20 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 19/20 Budget 19/20 Actuals Intergovernmental 7% of Fund 18% of Fund 4 ---PAGE BREAK--- City of Redmond, WA Revenue Summary - General Fund 2019-2020 Charges for Service Biennial Budget Actual Over / (Under) % January 336,903 378,500 12.35% February 691,352 March 1,072,460 April 1,496,432 May 1,882,032 June 2,333,981 July 2,727,166 August 3,140,836 September 3,564,613 October 4,034,734 November 4,425,365 December 4,711,163 January 5,084,258 February 5,452,879 March 5,858,010 April 6,271,590 May 6,663,268 June 7,070,723 July 7,424,597 August 7,830,815 September 8,246,557 October 8,641,293 November 9,016,225 December 9,401,823 Percent collected to date 4.0% Fines & Forfeits Biennial Budget Actual Over / (Under) % January 42,904 33,383 -22.19% February 87,144 March 159,928 April 251,205 May 300,190 June 349,084 July 401,777 August 547,009 September 585,551 October 655,842 November 697,441 December 746,674 January 799,115 February 864,566 March 941,464 April 997,548 May 1,066,808 June 1,122,641 July 1,171,086 August 1,223,196 September 1,266,841 October 1,318,462 November 1,352,451 December 1,389,664 Percent collected to date 2.4% 4.96% of Total Budget- GF 0.73% of Total Budget- GF 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. - 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 10,000,000 1 3 5 7 9 11 13 15 17 19 21 23 19/20 Budget 19/20 Actuals Charge for Service - 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 1,600,000 1 3 5 7 9 11 13 15 17 19 21 23 19/20 Budget 19/20 Actuals Fines & Forfeits 5% of Fund 0% of Fund 5 ---PAGE BREAK--- City of Redmond, WA Revenue Summary - General Fund 2019-2020 Miscellaneous Biennial Budget Actual Over / (Under) % January 104,031 227,296 118.49% February 239,144 March 365,348 April 507,314 May 661,704 June 802,309 July 876,476 August 984,836 September 900,482 October 1,028,583 November 1,150,262 December 1,348,491 January 1,172,082 February 1,244,070 March 1,359,876 April 1,488,617 May 1,645,706 June 1,759,296 July 1,713,929 August 1,782,647 September 1,845,130 October 1,957,833 November 2,060,561 December 2,107,518 Percent collected to date 10.8% 1.11% of Total Budget- GF Miscellaneous revenues includes interest earnings on cash, rental revenues and other smaller revenues that do not fit into one of the above categories. - 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 19/20 Budget 19/20 Actuals Miscellaneous 5% of Fund 6 ---PAGE BREAK--- City of Redmond, WA Expenditure Summary - General Fund 2019-2020 Total General Fund Biennial Budget Actual Over / (Under) % January 8,266,624 6,832,912 -17.34% February 16,533,247 March 24,799,871 April 33,066,495 May 41,333,119 June 49,599,742 July 57,866,366 August 66,132,990 September 74,399,613 October 82,666,237 November 90,932,861 December 99,199,485 January 107,466,108 February 115,732,732 March 123,999,356 April 132,265,979 May 140,532,603 June 148,799,227 July 157,065,850 August 165,332,474 September 173,599,098 October 181,865,722 November 190,132,345 December 198,398,969 % spent 3.44% Non-Departmental Biennial Budget Actual Over / (Under) % January 1,225,288 881,845 -28.03% February 2,450,575 March 3,675,863 April 4,901,150 May 6,126,438 June 7,351,725 July 8,577,013 August 9,802,300 September 11,027,588 October 12,252,875 November 13,478,163 December 14,703,450 January 15,928,738 February 17,154,025 March 18,379,313 April 19,604,601 May 20,829,888 June 22,055,176 July 23,280,463 August 24,505,751 September 25,731,038 October 26,956,326 November 28,181,613 December 29,406,901 % spent 3.00% 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% of Total Fund - 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 30,000,000 35,000,000 1 3 5 7 9 11 13 15 17 19 21 23 19/20 Budget 19/20 Actuals Non-Department - 50,000,000 100,000,000 150,000,000 200,000,000 250,000,000 1 3 5 7 9 11 13 15 17 19 21 23 19/20 Budget 19/20 Actuals Total General Fund 7% of Fund 7 ---PAGE BREAK--- City of Redmond, WA Expenditure Summary - General Fund 2019-2020 Legislative Biennial Budget Actual Over / (Under) % January 18,491 14,194 -23.24% February 36,982 March 55,473 April 73,965 May 92,456 June 110,947 July 129,438 August 147,929 September 166,420 October 184,911 November 203,403 December 221,894 January 240,385 February 258,876 March 277,367 April 295,858 May 314,350 June 332,841 July 351,332 August 369,823 September 388,314 October 406,805 November 425,296 December 443,788 % spent 3.20% Executive Biennial Budget Actual Over / (Under) % January 289,589 298,783 3.17% February 579,178 March 868,768 April 1,158,357 May 1,447,946 June 1,737,535 July 2,027,125 August 2,316,714 September 2,606,303 October 2,895,892 November 3,185,482 December 3,475,071 January 3,764,660 February 4,054,249 March 4,343,838 April 4,633,428 May 4,923,017 June 5,212,606 July 5,502,195 August 5,791,785 September 6,081,374 October 6,370,963 November 6,660,552 December 6,950,141 % spent 4.30% Legislative budget is the budget for the City Council and related expenses. Executive budget provides for the mayor's office, city communications, city clerk's office, customer service and transportation demand management (TDM). 4% of Total Fund 0.22% of Total Fund - 50,000 100,000 150,000 200,000 250,000 300,000 350,000 400,000 450,000 500,000 1 3 5 7 9 11 13 15 17 19 21 23 19/20 Budget 19/20 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 1 3 5 7 9 11 13 15 17 19 21 23 19/20 Budget 19/20 Actuals Executive 5% of Fund 0.39% of Fund 8 ---PAGE BREAK--- City of Redmond, WA Expenditure Summary - General Fund 2019-2020 Human Resources Biennial Budget Actual Over / (Under) % January 171,125 112,364 -34.34% February 342,250 March 513,375 April 684,500 May 855,625 June 1,026,750 July 1,197,875 August 1,369,000 September 1,540,125 October 1,711,250 November 1,882,375 December 2,053,500 January 2,224,625 February 2,395,750 March 2,566,875 April 2,737,999 May 2,909,124 June 3,080,249 July 3,251,374 August 3,422,499 September 3,593,624 October 3,764,749 November 3,935,874 December 4,106,999 % spent 2.74% Finance -100.00% Biennial Budget Actual Over / (Under) % January 329,644 278,786 -15.43% February 659,289 March 988,933 April 1,318,577 May 1,648,222 June 1,977,866 July 2,307,510 August 2,637,155 September 2,966,799 October 3,296,443 November 3,626,088 December 3,955,732 January 4,285,377 February 4,615,021 March 4,944,665 April 5,274,310 May 5,603,954 June 5,933,598 July 6,263,243 August 6,592,887 September 6,922,531 October 7,252,176 November 7,581,820 December 7,911,464 % spent 3.52% 2% of Total Fund 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. 4% of Total Fund - 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 19/20 Budget 19/20 Actuals Human Resources - 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 19/20 Budget 19/20 Actuals Finance 2% of Fund 4% of Fund 9 ---PAGE BREAK--- City of Redmond, WA Expenditure Summary - General Fund 2019-2020 Technology & Information Services Biennial Budget Actual Over / (Under) % January 506,918 273,386 -46.07% February 1,013,836 March 1,520,754 April 2,027,671 May 2,534,589 June 3,041,507 July 3,548,425 August 4,055,343 September 4,562,261 October 5,069,179 November 5,576,096 December 6,083,014 January 6,589,932 February 7,096,850 March 7,603,768 April 8,110,686 May 8,617,604 June 9,124,521 July 9,631,439 August 10,138,357 September 10,645,275 October 11,152,193 November 11,659,111 December 12,166,029 % spent 2.25% Public Works Biennial Budget Actual Over / (Under) % January 587,592 603,764 2.75% February 1,175,184 March 1,762,777 April 2,350,369 May 2,937,961 June 3,525,553 July 4,113,146 August 4,700,738 September 5,288,330 October 5,875,922 November 6,463,515 December 7,051,107 January 7,638,699 February 8,226,291 March 8,813,883 April 9,401,476 May 9,989,068 June 10,576,660 July 11,164,252 August 11,751,845 September 12,339,437 October 12,927,029 November 13,514,621 December 14,102,214 % spent 4.28% Technology & Information Service Department includes general fund interfund transfers to 520 fund (TIS), and Print Shop. Public Works within the General Fund accounts for maintenance, street maintenance, traffic systems, construction inspection as well as department oversight. 7% of Total Fund 6% of Total Fund - 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 19/20 Budget 19/20 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 19/20 Budget 19/20 Actuals Technology & Information Services 7% of Fund 10% of Fund 10 ---PAGE BREAK--- City of Redmond, WA Expenditure Summary - General Fund 2019-2020 Parks Biennial Budget Actual Over / (Under) % January 952,173 603,214 -36.65% February 1,904,347 March 2,856,520 April 3,808,693 May 4,760,867 June 5,713,040 July 6,665,213 August 7,617,387 September 8,569,560 October 9,521,733 November 10,473,907 December 11,426,080 January 12,378,253 February 13,330,427 March 14,282,600 April 15,234,773 May 16,186,947 June 17,139,120 July 18,091,293 August 19,043,467 September 19,995,640 October 20,947,813 November 21,899,987 December 22,852,160 % spent 2.64% Fire Biennial Budget Actual Over / (Under) % January 1,789,513 1,555,462 -13.08% February 3,579,026 March 5,368,538 April 7,158,051 May 8,947,564 June 10,737,077 July 12,526,590 August 14,316,103 September 16,105,615 October 17,895,128 November 19,684,641 December 21,474,154 January 23,263,667 February 25,053,179 March 26,842,692 April 28,632,205 May 30,421,718 June 32,211,231 July 34,000,744 August 35,790,256 September 37,579,769 October 39,369,282 November 41,158,795 December 42,948,308 % spent 3.62% 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. 12% of Total Fund 22% 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 50,000,000 1 3 5 7 9 11 13 15 17 19 21 23 19/20 Budget 19/20 Actuals Fire - 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 19/20 Budget 19/20 Actuals Parks 9% of Fund 22% of Fund 11 ---PAGE BREAK--- City of Redmond, WA Expenditure Summary - General Fund 2019-2020 Police Biennial Budget Actual Over / (Under) % January 1,505,267 1,351,849 -10.19% February 3,010,534 March 4,515,801 April 6,021,068 May 7,526,335 June 9,031,602 July 10,536,869 August 12,042,136 September 13,547,403 October 15,052,670 November 16,557,937 December 18,063,204 January 19,568,471 February 21,073,738 March 22,579,005 April 24,084,272 May 25,589,539 June 27,094,806 July 28,600,073 August 30,105,340 September 31,610,607 October 33,115,875 November 34,621,142 December 36,126,409 % spent 3.74% Planning Biennial Budget Actual Over / (Under) % January 891,023 859,264 -3.56% February 1,782,046 March 2,673,070 April 3,564,093 May 4,455,116 June 5,346,139 July 6,237,163 August 7,128,186 September 8,019,209 October 8,910,232 November 9,801,255 December 10,692,279 January 11,583,302 February 12,474,325 March 13,365,348 April 14,256,371 May 15,147,395 June 16,038,418 July 16,929,441 August 17,820,464 September 18,711,488 October 19,602,511 November 20,493,534 December 21,384,557 % spent 4.02% 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% of Total Fund 11% 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 19/20 Budget 19/20 Actuals Police - 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 19/20 Budget 19/20 Actuals Planning 20% of Fund 14% of Fund 12 ---PAGE BREAK--- City of Redmond, WA Other Funds Summary - General Fund 2017-2018 Recreation Activity Fund (Fund 110) Biennial Budget Actual Over / (Under) % January 153,966 130,296 -15.37% February 319,144 March 518,982 April 708,918 May 913,530 June 1,133,566 July 1,466,411 August 1,873,520 September 2,151,128 October 2,337,693 November 2,539,543 December 2,793,287 January 2,947,012 February 3,144,390 March 3,357,376 April 3,574,913 May 3,772,607 June 4,005,236 July 4,365,633 August 4,780,915 September 5,073,690 October 5,291,165 November 5,490,367 December 5,728,157 BTD Status 2.27% Arts Activity Fund (Fund 011) Biennial Budget Actual Over / (Under) % January 16,902 14,726 -12.87% February 35,968 March 49,754 April 70,866 May 93,333 June 127,931 July 199,911 August 265,196 September 327,413 October 349,670 November 378,075 December 417,790 January 431,186 February 462,304 March 483,076 April 504,905 May 519,052 June 549,883 July 588,218 August 636,635 September 682,547 October 704,893 November 747,146 December 793,530 BTD Status 1.86% 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 19/20 Budget 19/20 Actual Revevue 19/20 Actual Revenue with BFB 19/20 Actual Expenditures Recreation Activity - 100,000 200,000 300,000 400,000 500,000 600,000 700,000 800,000 900,000 1 3 5 7 9 11 13 15 17 19 21 23 19/20 Budget 19/20 Actual Revenue 19/20 Actual Revenue with BFB 19/20 Actual Expenditures Arts Activity 13 ---PAGE BREAK--- City of Redmond, WA Other Funds Summary - General Fund 2017-2018 Parks M&O Fund (Fund 012) Biennial Budget Actual Over / (Under) % January 134,333 121,638 -9.45% February 264,990 March 399,143 April 548,315 May 704,538 June 866,019 July 1,042,552 August 1,253,238 September 1,470,983 October 1,657,724 November 1,855,806 December 2,155,862 January 2,453,789 February 2,657,240 March 2,844,745 April 3,016,626 May 3,228,191 June 3,399,246 July 3,579,569 August 3,764,264 September 3,939,148 October 4,117,728 November 4,274,651 December 4,518,116 BTD Status 2.69% Water / Wastewater O&M Fund (Fund 401) Biennial Budget Actual Over / (Under) % January 3,495,998 3,261,469 -6.71% February 7,018,076 March 10,178,113 April 13,238,393 May 17,421,682 June 20,505,850 July 23,737,309 August 27,374,293 September 30,906,880 October 33,232,877 November 36,909,624 December 40,874,441 January 45,947,007 February 50,727,501 March 54,552,809 April 57,276,411 May 61,329,427 June 65,421,070 July 68,568,179 August 72,668,614 September 76,406,853 October 79,851,112 November 83,022,120 December 87,575,289 BTD Status 3.72% 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 5,000,000 1 3 5 7 9 11 13 15 17 19 21 23 19/20 Budget 19/20 Actual Revenue 19/20 Actual Revenue with BFB 19/20 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 19/20 Budget 19/20 Actual Revenue 19/20 Actual Revenue with BFB 19/20 Actual Expenditures Water / Wastewater O&M 14 ---PAGE BREAK--- City of Redmond, WA Other Funds Summary - General Fund 2017-2018 Stormwater O&M Fund (Fund 405) Biennial Budget Actual Over / (Under) % January 826,293 1,088,316 31.71% February 2,169,454 March 3,325,220 April 5,632,758 May 6,515,349 June 6,193,431 July 7,073,964 August 7,941,429 September 8,802,187 October 9,553,723 November 10,511,772 December 11,458,128 January 12,832,742 February 14,260,732 March 15,162,403 April 16,034,746 May 17,056,404 June 18,012,051 July 18,986,630 August 19,875,996 September 24,794,840 October 25,666,603 November 26,707,818 December 31,912,958 BTD Status 3.41% Technology & Information Services Fund (520) Biennial Budget Actual Over / (Under) % January 724,396 986,445 11.40% February 1,448,792 March 2,173,188 April 2,897,584 May 3,621,980 June 4,346,376 July 5,070,772 August 5,795,168 September 6,519,564 October 7,243,960 November 7,968,356 December 8,692,752 January 9,417,148 February 10,141,544 March 10,865,940 April 11,590,336 May 12,314,732 June 13,039,128 July 13,763,524 August 14,487,920 September 15,212,316 October 15,936,712 November 16,661,108 December 17,385,504 % spent 5.67% 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. The Stormwater O&M Fund accounts for the operations and maintenance activities related to managing surface and storm water. - 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 30,000,000 35,000,000 1 3 5 7 9 11 13 15 17 19 21 23 19/20 Budget 19/20 Actual Revenue 19/20 Actual Revenue with BFB 19/20 Actual Expenditures Stormwater O&M - 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 20,000,000 1 3 5 7 9 11 13 15 17 19 21 23 19/20 Budget 19/20 Actual Revenue 19/20 Actual Revenue with BFB 19/20 Actual Expenditures Technology & Information Services 15 ---PAGE BREAK--- Beginning Balance Revenues Expenditure Budget Expenditures Ending Balance % Expended Arts Activity 272,670 13,042 793,530 14,726 270,986 1.86% Business Tax 1,257,586 978,000 12,400,003 230,648 2,004,938 1.86% Capital Replacement Reserve 2,577,619 83,333 4,577,619 112,780 2,548,172 2.46% Community Events 119,820 25,881 1,353,513 18,921 126,780 1.40% Fire Equipment Reserve 2,723,250 37,020 3,611,734 4,147 2,756,124 0.11% Fire Levy Fund 367,351 - 6,758,100 191,368 175,984 2.83% General Govt'l Major Maint 1,608,482 129,299 7,800,591 105,861 1,631,921 1.36% General Fund 8,904,104 6,998,784 198,398,969 6,832,912 9,069,976 3.44% Human Services Grants 104,459 98,464 2,537,786 1,728 201,194 0.07% Operating Reserve 7,786,273 33,712 8,675,365 1,720 7,818,266 0.02% Parks Levy Fund 634,568 - 1,388,913 28,000 606,568 2.02% Parks Maint. & Operations 1,490,759 11,430 4,518,116 121,638 1,380,550 2.69% Parks Maintenance 61,003 85,357 12,998,732 9,785 136,575 0.08% Police Levy Fund 3,851,635 - 8,943,285 197,874 3,653,761 2.21% Real Property Fund 569,062 7,564 571,689 354 576,272 0.06% Transportation Maint. Prjt 2,878,407 137,258 10,669,850 58,084 2,957,582 0.54% TOTAL GENERAL GOV'T 35,207,049 8,639,144 285,997,795 7,930,544 35,915,648 2.77% Advanced Life Support 1,325,560 590 17,354,006 580,601 745,549 3.35% Cable Access Fund 842,146 808 862,187 5,193 837,760 0.60% Drug Enforcement 126,056 190 126,056 - 126,246 Fire Donations 301,882 906 451,485 - 302,788 Fleet Maintenance 5,013,736 216,806 10,502,978 92,624 5,137,917 0.88% General Gov't Capital 4,478,291 15,803 2,352,222 70 4,494,025 0.00% Information Technology 2,408,851 338,602 17,385,504 986,445 1,761,008 5.67% Insurance 1,148,417 91,095 3,507,936 18,327 1,221,184 0.52% Medical Self Insurance 9,042,351 1,125,134 36,606,038 1,380,822 8,786,663 3.77% Development Review 1,947,060 1,289,285 15,901,233 327,777 2,908,568 2.06% Non-Voted Bonds 2,252,093 140,334 11,565,451 - 2,392,427 Novelty Hill Water Projects 10,222,615 70,408 740,000 7,619 10,285,405 1.03% Novelty Hill Utility 3,541,607 108,237 19,470,685 723,689 2,926,154 3.72% Novelty Hill Wastewater Projects 10,963,063 78,402 - - 11,041,465 N/A Operating Grants 516,844 99,709 3,580,561 60,982 555,571 1.70% Parks Capital Projects 6,712,692 120,815 8,627,926 8,505 6,825,003 0.10% Real Estate Excise Tax 4,386,884 7,422 14,416,884 - 4,394,306 Recreational Activity 425,357 113,486 5,728,157 130,296 408,547 2.27% Solid Waste Recycling 840,059 83,672 2,834,067 53,286 870,445 1.88% Stormwater Capital 27,625,945 290,336 30,568,941 164,020 27,752,261 0.54% Stormwater Management 3,539,733 1,197,291 31,912,958 1,088,316 3,648,708 3.41% Tourism Hotel/Motel 822,012 41,709 1,996,843 10,084 853,637 0.51% Transportation Capital Projects 17,139,941 1,026,659 42,652,660 54,874 18,111,726 0.13% Wastewater Construction 15,206,224 157,182 20,263,282 24,627 15,338,779 0.12% Water Capital 14,918,202 301,336 9,097,395 21,674 15,197,864 0.24% Water / Sewer Utility 8,164,025 2,690,041 87,575,289 3,261,469 7,592,596 3.72% Worker's Compensation 246,000 128,082 3,867,939 65,460 308,622 1.69% 189,364,695 18,373,485 685,946,478 16,997,307 190,740,873 2.48% GRAND TOTAL FUND City of Redmond, WA All Funds Recap January-19 (Note - Biennial Budget) 16 ---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. 17 ---PAGE BREAK--- Beginning Balance Revenues Expenditure Budget* Expenditures Ending Balance % Expended Parks Maintenance 61,003 85,357 12,998,732 9,785 136,575 0.08% Transportation Maint. Prjt 2,878,407 137,258 10,669,850 58,084 2,957,582 0.54% General Govt'l Major Maint 1,608,482 129,299 7,800,591 105,861 1,631,921 1.36% General Gov't Capital 4,478,291 15,803 2,352,222 70 4,494,025 0.00% Novelty Hill Water Pjts 10,222,615 70,408 740,000 7,619 10,285,405 1.03% Novelty Hill Wastewtr Pjts 10,963,063 78,402 - - 11,041,465 N/A Parks Capital Pjts 6,712,692 120,815 8,627,926 8,505 6,825,003 0.10% Stormwater Capital 27,625,945 290,336 30,568,941 164,020 27,752,261 0.54% Transportation Capital Pjts 17,139,941 1,026,659 42,652,660 54,874 18,111,726 0.13% Wastewater Construction 15,206,224 157,182 20,263,282 24,627 15,338,779 0.12% Water Capital 14,918,202 301,336 9,097,395 21,674 15,197,864 0.24% 111,814,866 2,412,858 145,771,599 455,118 113,772,606 0.31% None Notes and explanations: City of Redmond, WA Capital Funds Recap January-19 (Note - Biennial Budget) FUND GRAND TOTAL 18