The URL can be used to link to this page

Home My WebLink About201405, May.pdf AD DATE: TO: CC: FROM: SUBJECT At the e Revenue credit ($9 building down sid funds ($ operating General page 9 of The attac projectio question DMINISTRAT DEPART Jun Do Me De Ad Ha : Ma nd of May, s sources th 94k); utility permits & d de, the reven 104k below g purposes) government f report for f ched report ons for the y s or any sug TIVE SERVIC TMENT M E ne 25, 2014 n Persson, C embers of th nis Law, Ma ministrators i Nguyen, Sr ay 2014 Fina general gov hat are high taxes ($128 development nue sources w, restricted and fines/p t expenditur further expe provides mo year. Please ggestions abo CES E M O Council Presi he Renton Ci yor s r. Finance An ancial Status vernmental her than ex k); state sha t service fee that are un d to drug e enalties ($36 res showed enditure ove ore detailed e do not hes out the repo R A N ident ity Council nalyst s Report revenues s xpected are: ared revenue es ($567k) an nderperform nforcement 69k below). a favorable er‐spent exp discussion o sitate to con ort. D U M how $1.4 m : sales tax ( e ($196k); re nd other mi ming the year only and i e variance o lanations. of each reve ntact me at M million or 2. ($77k); sales eal estate ex scellaneous r to date bu is not avail of $1.4 millio enue source x6952 shou 9% over bu s tax annex xcise tax ($6 ($164k). O dget are: se able for ge on or 2.9%. and our upd uld you have udget. xation 676k); n the eizure eneral See dated e any This page is intentionally left blank B O P S S C N A F E N G T T C C L G R E B A B I F P C I F S I R C O O T O C E C C C D E P F C H P F C P P R H N L M P S T D N T T 1 General Govern Beginning Fund Balanc OPERATING REVENUES Property Tax Sales Tax Sales Tax ‐ Annexatio n Criminal Justice Sales Natural Gas Use Tax Admission Tax Franchise Fees Electricity Tax Natural Gas Utility Ta Garbage/Solid Waste TV Cable Telephone Cellular Phone City Utilities Leasehold Excise Tax Gambling Excise Tax Real Estate Excise Ta x Less: CIP REET EMS Levy Business License Fee Animal Licenses and S Building Permits & De ntergovt'l (Grants, St Fire District 25 and 40 Public Safety Culture and Recreatio nterfund/Interdept‐S Fines and Penalties Photo Enforcement Seizure Funds ‐ Federa nterests and Other E Rents, Leases, and Co Contributions and Do Other Miscellaneous Other Financing Sourc Total Operating Reve n OPERATING EXPENDIT Council Executive City Attorney Court Services Community and Eco D Development Service Economic Developme Planning Finance City Clerk1 Human Resources Police Jail Services Fire Community Services A Parks Parks Planning & Natu Recreation Human Services Neighborhoods, Res o Library Museum Public Works Admin Street Maintenance Transportation Debt Service Non‐Departmental a n Total Operating Expen Total Ending Fund Bala 1Hearing Examiner is Summary of Sou nmental Funds ce S n Credit s Tax x x s Spec Events Permits evelopment Svc Fees ate Shared, etc) 0 Contracts on Services a l/State/Local arnings oncessions nations ces (Transfer‐In, etc) nues URES Dvlpmnt Admin s ent Admin ural Resources urces, & Events nd Other nditures ance reported under City C urces and Uses 11,057,551$ 1$ 33,466,364 1 18,564,670 2,208,492 1,924,470 272,530 311,054 1,262,188 5,211,111 1,669,967 330,607 1,423,664 1,056,420 2,183,853 3,806,281 158,849 1,691,209 2,811,902 (943,792) 885,781 444,680 91,835 3,552,369 4,593,185 6,155,621 485,899 1,494,165 3,311,715 1,046,246 1,976,203 37,941 342,424 822,428 124,082 564,571 5,118,188 108,457,170 4 278,768 1,377,109 1,706,320 2,074,980 942,071 3,090,735 529,043 1,495,066 2,221,882 997,434 937,412 25,004,580 1 3,489,616 24,173,315 1 434,558 4,004,054 577,934 4,982,229 1,193,871 701,673 278,604 216,887 470,051 3,755,640 4,615,160 9,752,337 4,637,555 103,938,882 3 15,575,840$ 1$ Clerk 2012 Annual Actual Y 11,057,551 15,5$ 17,258,526 32,4 7,524,996 20,4 900,851 2,4 767,525 2,0 190,803 2 154,705 3 599,927 1,3 2,367,351 5,1 1,031,633 1,5 120,394 3 556,315 1,4 422,975 9 1,014,806 2,0 1,494,304 3,9 36,481 1 675,662 1,3 943,666 4,1 (186,403) (7 221,445 9 209,503 5 47,153 1,214,955 4,0 1,372,909 3,8 3,001,928 5,7 196,835 6 502,444 1,4 1,288,224 3,4 366,674 1,1 869,725 1,6 17,904 39,929 4 392,552 7 63,791 226,937 6 143,912 2 46,051,336 105,5 115,568 2 545,056 1,2 700,106 1,9 860,008 2,0 399,357 1,0 1,203,634 3,2 229,561 4 621,541 1,5 813,293 2,2 311,113 1,0 372,608 9 10,528,062 24,9 1,165,684 3,8 10,741,041 24,4 180,559 4 1,489,760 4,0 223,491 8 1,750,284 4,8 478,640 1,1 235,954 7 61,106 90,015 2 197,642 4 1,525,151 3,8 1,806,575 4,4 856,385 8,0 1,375,197 5,4 38,877,391 103,6 18,231,496 17,4$ AnnualTD Actual Month 575,840 15,575,8$ 485,690 16,765,5 416,372 8,361,8 418,789 989,4 091,174 840,7 263,660 131,5 327,258 152,7 312,727 627,3 155,789 2,331,6 550,900 931,8 397,596 163,9 481,779 585,4 917,021 375,3 050,312 741,6 964,989 1,556,0 164,637 40,9 319,585 575,8 131,665 1,108,0 700,000) (213,0 916,361 229,0 503,766 284,4 99,411 46,7 001,625 1,616,6 863,974 1,583,5 726,895 2,794,3 680,581 298,4 494,580 457,4 464,913 1,464,4 137,140 411,4 629,524 861,0 50,639 29,1 423,609 41,0 734,530 372,0 84,320 30,6 684,187 293,0 299,527 13,3 545,527 46,893,8 289,911 121,0 240,910 528,3 922,225 724,4 003,104 795,2 047,860 428,8 243,702 1,319,2 467,511 175,4 510,707 603,2 274,147 775,5 020,822 581,5 904,182 357,2 946,784 10,373,6 814,042 1,271,3 444,372 10,518,4 452,146 187,5 024,756 1,515,9 829,250 258,9 846,970 1,698,2 162,330 431,0 770,841 288,0 ‐ ‐ 209,387 87,1 426,312 202,0 814,132 1,600,7 476,854 1,819,3 048,508 835,6 475,340 2,385,2 667,105 39,883,6 454,262 22,586,0$ 2013 Actual YTD Actu hly Fin 840 17,454,261$ 551 35,240,495 849 20,196,000 496 2,236,262 766 2,000,000 501 300,000 751 308,000 348 1,260,000 661 5,409,000 874 1,500,520 924 300,000 437 1,529,365 314 952,500 619 2,077,000 075 3,791,465 988 145,000 843 1,600,000 012 2,900,000 085) (550,000) 090 900,000 482 533,067 780 90,000 609 3,705,701 507 4,188,188 338 5,877,463 452 774,535 448 1,525,863 495 3,332,794 427 1,108,500 044 1,950,000 106 180,693 099 745,300 078 756,464 611 96,100 015 516,630 343 ‐ 848 107,476,905 071 309,907 321 1,359,996 478 1,863,395 263 2,094,010 857 1,012,142 207 3,040,435 487 644,063 248 2,261,206 564 2,334,758 575 1,125,927 200 1,002,994 682 25,925,197 352 4,500,000 427 25,219,873 590 493,982 905 4,311,514 947 880,373 203 5,111,272 038 1,221,989 076 979,716 ‐‐ 136 226,683 081 456,340 743 4,488,268 302 4,539,752 676 8,340,863 254 7,881,844 684 111,626,501 004 13,304,665$ al Annual Budget ancial 17,454,261$ 17$ 18,180,258 18 8,489,733 8 913,563 1 801,013 180,330 148,355 600,550 2,451,741 2 914,748 117,131 600,994 385,302 861,586 1,488,226 1 34,725 665,076 1,333,821 2 (381,218) 225,392 277,641 43,501 1,390,140 1 1,819,598 1 2,899,636 2 328,867 490,060 1,388,664 1 396,697 936,011 103,859 78,835 371,503 43,531 222,382 ‐ 48,802,249 50 128,959 557,592 731,578 849,947 421,256 1,211,026 1 261,778 921,326 825,083 498,004 397,478 10,848,189 10 1,567,439 1 11,028,108 10 205,095 1,614,058 1 301,827 1,793,244 1 471,784 348,656 ‐ 94,204 203,500 1,853,405 1 1,810,444 1 917,058 6,350,814 6 46,211,853 44 20,044,657$ 22$ 2014 YTD Budget YT Repor $ 7,454,261 8,201,961 21,7 8,566,897 77, 1,007,797 94,2 904,495 103,4 165,650 (14,6 154,406 6,0 646,666 46, 2,405,672 (46,0 986,048 71,3 236,948 119,8 609,004 8,0 410,273 24,9 741,952 (119,6 1,572,889 84,6 43,738 9,0 660,879 (4, 2,010,091 676,2 (381,218) 225,392 245,693 (31,9 45,534 2,0 1,956,991 566,8 1,912,102 92,5 2,899,636 280,547 (48,3 490,907 8 1,410,821 22, 438,603 41,9 525,332 (410,6 (470) (104,3 57,032 (21,8 364,229 (7,2 41,698 (1,8 386,611 164,2 8,617 8,6 0,233,421 1,431, 133,956 (4,9 517,214 40,3 713,626 17,9 830,863 19,0 418,279 2,9 1,163,496 47,5 230,384 31,3 747,714 173,6 852,555 (27,4 516,105 (18, 365,419 32,0 0,820,669 27,5 1,567,439 0,587,000 441, 196,067 9,0 1,483,776 130,2 270,042 31,7 1,601,422 191,8 453,886 17,8 307,785 40,8 ‐ 84,860 9,3 160,270 43,2 1,791,574 61,8 1,771,639 38,8 917,058 6,350,814 4,853,913 1,357,9 2,833,769 2,789,$ Favorable V D Actual rt May % ‐ 0.0% 703 0.1% 164 0.9% 234 10.3% 482 12.9% 680)‐8.1% 052 4.1% 115 7.7% 069)‐1.9% 300 7.8% 817 102.3% 009 1.3% 972 6.5% 633)‐13.9% 664 5.7% 013 26.0% 197)‐0.6% 270 50.7% ‐ 0.0% (0) 0.0% 948)‐11.5% 033 4.7% 851 40.8% 504 5.1% ‐ 0.0% 319)‐14.7% 847 0.2% 157 1.6% 906 10.6% 679)‐43.9% 329)‐100.5% 803)‐27.7% 274)‐2.0% 833)‐4.2% 229 73.9% 617 100.0% 171 2.9% 997)‐3.9% 378 7.2% 953 2.5% 083 2.2% 977 0.7% 530 3.9% 394 12.0% 612 18.8% 472)‐3.3% 101)‐3.6% 059 8.1% 521 0.3% ‐ 0.0% 108 4.0% 028 4.4% 282 8.1% 785 10.5% 822 10.7% 898 3.8% 871 11.7% ‐ 0.0% 344 9.9% 230 21.2% 830 3.3% 805 2.1% ‐ 0.0% ‐ 0.0% 941 2.9% 112 13.9% e (Unfavorable) ariance 2014 Page 1 of 36 Monthly Financial Report May 2014 OVERVIEW This financial overview reflects the City’s overall financial position for the fiscal year through May 31, 2014. Except as noted, year‐to‐date budgeted (adjusted) revenues and operating expenditures are generally based on the collection/disbursement patterns for the same period of the preceding two years. The table on the previous page summarizes the general governmental fund revenues and expenditures. Revenues Taxes The combined collection of property, sales/use, utility, gambling, admissions, and real estate excise taxes represents 76% of all resources supporting general governmental activities. The following section provides detail information on property, sales, utility, and other taxes. Property Tax May’s collection is $10.7 million, making the total year‐to‐date collection $18.2 million or 51.7% of the total budget. In comparison to the previous year, the City collected $1.4 million or 9% more. Compared to the budget, the City is above projections by $22k. The variance from the monthly budget is due the timing of collections. The City is projecting property tax to meet the budget at year‐end. Sales Tax May 2014 sales tax receipts totalled $1.8 million. Compared with the same month last year, it is $28k or 2% more. Compared to the projected current month’s budget, it is $3k below. The year‐ to‐date collection of $8.6 million is $205k or 2% more than the prior year and is also $77k or 1% more than budgeted. 2014’s monthly budgets are generally based on 2006 through 2013 collections. The City is projecting sales tax to meet the budget at year‐end. 2013 2014 2014 Actual Budget Actual $ % $ % Jan 154,945$ 162,468$ (101,807)$ (256,752)$ ‐166% (264,275)$ ‐163% Feb 25,020 59,096 176,551 151,531 606% 117,455 199% Mar 917,901 960,884 1,626,283 708,382 77% 665,398 69% Apr 9,887,324 10,632,911 5,808,865 (4,078,459) ‐41% (4,824,046) ‐45% May 5,780,361 6,364,899 10,692,069 4,911,708 85% 4,327,171 68% Jun 88,480 70,363 Jul 100,047 292,155 Aug 58,101 3,718 Sep 548,071 584,469 Oct 10,140,892 10,620,057 Nov 4,341,474 5,057,587 Dec 443,072 431,888 YTD Total 16,765,551$ 18,180,258$ 18,201,961$ 1,436,409$ 9%21,703$ 0% Annual Total 32,485,690$ 35,240,495$ Property Tax Revenues Year to Date through May 2014 vs. 2013 2014 vs. Budget Month 2013 2014 2014 Actual Budget Actual $ % $ % Jan 1,620,555$ 1,607,453$ 1,607,045$ (13,510)$ ‐1% (408)$ 0% Feb 1,962,886 2,047,494 2,079,673 116,787 6% 32,179 2% Mar 1,536,397 1,523,208 1,562,210 25,814 2% 39,002 3% Apr 1,509,953 1,548,879 1,558,271 48,318 3% 9,393 1% May 1,732,058 1,762,699 1,759,697 27,639 2% (3,002) 0% Jun 1,552,807 1,584,050 ‐ Jul 1,647,860 1,599,650 ‐ Aug 1,833,347 1,718,742 ‐ Sep 1,741,262 1,633,772 ‐ Oct 1,790,411 1,728,992 ‐ Nov 1,802,768 1,740,835 ‐ Dec 1,686,069 1,700,227 ‐ YTD Total 8,361,849$ 8,489,733$ 8,566,897$ 205,048$ 2% 77,164$ 1% Annual Total 20,416,372$ 20,196,000$ 2014 vs. Budget2014 vs. 2013 Month Year to Date through May Local Retail Sales Tax Revenues Page 2 of 36 Monthly Financial Report May 2014 The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business sectors: Utility tax May utility tax revenues are $1.4 million, which is $41k or 3% higher than the same month last year and is also ahead of the budget by $18k or 1%. The year‐ to‐date collection is $7.1 million, which is $311k or 5% higher than the prior year and is also $128k or 2% higher than the budget. The City is projecting utility tax revenues to be very close to the budget at year‐end. The table below breaks out Utility Tax by source. The variance for Garbage/Solid Waste (not City Utilities) is due to a one‐ time correction (under reporting during September 2013 through December 2013) receipted in February. The variance for Cellular utilities is due to the timing of our revenue collection. As of May, we are only recording 4 months of revenue, compared to 5 months in prior years. 2013 2014 2014 Actual Budget Actual $ % $ % Jan 1,277,860$ 1,372,593$ 1,373,119$ 95,259$ 7% 526$ 0% Feb 1,462,236 1,490,351 1,524,563 62,327 4% 34,213 2% Mar 1,193,129 1,310,634 1,631,438 438,309 37% 320,804 24% Apr 1,545,257 1,463,692 1,218,999 (326,258) ‐21% (244,693) ‐17% May 1,338,923 1,362,789 1,380,317 41,394 3% 17,529 1% Jun 1,189,847 1,151,072 Jul 1,259,713 1,298,235 Aug 1,280,207 1,218,858 Sep 1,433,293 1,366,340 Oct 1,072,773 1,103,445 Nov 1,244,671 1,222,957 Dec 1,484,137 1,498,886 YTD Total 6,817,405$ 7,000,058$ 7,128,436$ 311,031$ 5%128,378$ 2% Annual Total 15,782,047$ 15,859,850$ 2014 vs. Budget2014 vs. 2013 Year to Date through May Utility Tax Revenues Month Sales Tax by Sector 2013 2014 Bgt YTD Act Change 2014/2013 2014 Act vs Bgt New Construction 1,164,414$ 887,400$ 835,137$ (329,277)$ ‐28%$ (52,263)‐6% Auto Sales 1,480,509 1,586,440 1,628,574 148,065 10% 42,134 3% General Retail 2,763,209 2,823,012 2,734,069 (29,140) ‐1% (88,942)‐3% Manufacturing 519,960 603,283 878,273 358,314 69% 274,991 46% Wholesale 484,264 499,883 408,990 (75,274) ‐16% (90,893)‐18% Service 1,727,905 1,869,527 1,830,131 102,226 6% (39,397)‐2% Other 221,588 220,188 251,722 30,134 14% 31,534 14% YTD Total 8,361,849$ 8,489,733$ 8,566,897$ 205,048$ 2%77,164$ 1% Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue. Utility Tax by Type 2013 2014 Bgt YTD Act Change 2014/2013 2014 Act vs Bgt Electrical 2,331,661$ 2,451,741$ 2,405,672$ 74,011$ 3%$ (46,069)‐2% Natural Gas 1,063,375 1,095,078 1,151,698 88,323 8% 56,620 5% Cell 741,619 861,586 741,952 333 0% (119,633)‐14% Phone 375,314 385,302 410,273 34,959 9% 24,972 6% Cable 585,437 600,994 609,004 23,567 4% 8,009 1% Garbage/Solid Waste 163,924 117,131 236,948 73,024 45% 119,817 102% City Utilities 1,556,075 1,488,226 1,572,889 16,814 1% 84,664 6% YTD Total 6,817,405$ 7,000,058$ 7,128,436$ 311,031$ 5%128,378$ 2% Annual Total 15,782,047$ 15,859,850$ YTD as % of 43% 44% Page 3 of 36 Monthly Financial Report May 2014 Other Taxes Real Estate Excise Tax The City collected $263k in Real Estate Excise Tax revenues (REET) for May. This is $23k or 8% less than the same month last year and is also $43k or 14% less than the current month’s budget. The year‐to‐date collection is $2 million, which is $902k or 81% more than the prior year and is also $676k or 51% above the budget. The higher than expected variance is due to 5 large transactions in February, March and April which accounts for $847k of the total REET collected. The monthly budget is based on a normalized annual distribution (2012 only). The City is projecting REET to exceed the budget at year‐end. Gambling Tax May’s Gambling Tax collections totalled $138k, which is $41k or 42% above the same month last year and is also $33k or 31% above the current month’s budget. The year‐to‐date total of $661k is $85k or 15% above the year before but is $4k or 1% below budget. The overall lower activity is due to 2 establishments filing for bankruptcy. Pull tabs overall had an 11% increase, bingo increased by 2%, and card‐rooms are seeing 3% higher in activities when compared to the prior year. Franchise Fees Franchise Fees are due quarterly in January, April, July, and October. Due to the timing of when the payment was received, the City recorded January’s payment in February ($323k). The year‐to‐date total of $647k is $20k or 3% higher than the prior year and is also $47k or 8% above the projected year‐to‐date budget. The City is projecting Franchise Fees to meet budget at year‐end. 2013 2014 2014 Actual Budget Actual $ % $ % Jan 134,099$ 109,119$ 162,143$ 28,044$ 21% 53,024$ 49% Feb 262,229 301,209 448,452 186,223 71% 147,243 49% Mar 228,077 248,682 227,629 (448) 0% (21,053) ‐8% Apr 197,659 369,133 909,120 711,461 360% 539,987 146% May 285,948 305,678 262,746 (23,202) ‐8% (42,932) ‐14% Jun 347,890 373,661 Jul 263,807 197,109 Aug 294,056 244,646 Sep 254,318 191,805 Oct 272,776 288,478 Nov 342,535 164,476 Dec 1,248,272 106,004 YTD Total 1,108,012$ 1,333,821$ 2,010,091$ 902,079$ 81%676,270$ 51% Annual Total 4,131,665$ 2,900,000$ Real Estate Excise Tax Revenues Year to Date through May Month 2014 vs. Budget2014 vs. 2013 2013 2014 2014 Actual Budget Actual $ % $ % Jan 133,504$ 164,456$ 131,776$ (1,728)$ ‐1% (32,679)$ ‐20% Feb 73,730 115,620 133,109 59,379 81% 17,489 15% Mar 111,294 111,371 153,695 42,401 38% 42,324 38% Apr 159,655 168,010 103,980 (55,675) ‐35% (64,030) ‐38% May 97,660 105,619 138,319 40,659 42% 32,700 31% Jun 60,074 99,613 ‐ Jul 89,157 133,068 ‐ Aug 99,930 130,972 ‐ Sep 116,204 148,130 ‐ Oct 112,141 106,090 ‐ Nov 114,909 155,314 ‐ Dec 151,327 161,736 ‐ YTD Total 575,843$ 665,076$ 660,879$ 85,036$ 15% (4,197)$ ‐1% Annual Total 1,319,585$ 1,600,000$ Year to Date through May 2014 vs. 2013 2014 vs. Budget Gambling Tax Revenue Month 2013 2014 2014 Actual Budget Actual $ % $ % Jan 314,269$ 300,776$ ‐$ (314,269)$ ‐100% (300,776)$ ‐100% Feb 200 98 323,121 322,921 161461% 323,023 330063% Apr 311,986 299,239 323,544 11,558 4% 24,305 8% Jul 315,694 303,760 ‐ Oct 321,202 308,381 ‐ Dec 48,484 47,308 ‐ YTD Total 627,348$ 600,550$ 646,666$ 20,210$ 3% 46,552$ 8% Annual Total 1,312,727$ 1,260,000$ Month 2014 vs. 2013 2014 vs. Budget Franchise Fees Revenue Year to Date through Ma y Page 4 of 36 Monthly Financial Report May 2014 Admission Tax Admission Tax returns are due quarterly in January, April, July, and October of each year. April 2014 collections represent activities conducted during the 1st quarter of 2014. The year‐to‐ date collection of $154k is $1.7k or 1% more than the prior year and is also $7k or 4% more than the budget. Licenses and Permits Building Permits and Development Service Fees Building Permits and Development Service Fee revenues totalled $350k in May. The year‐to‐date development fees revenue of $2 million is $340k or 21% more than the year before and is also $567k or 41% higher than budget. The higher than expected fees are due to collecting more in general building permits, electrical permits, and plan check fees. The City is projecting Building Permits and Development Service Fees to exceed the budget at year‐end. Business Licenses Business Licenses totalled $15k for May, which is $18k or 55% below the same month last year and is also $5k or 25% below the current month’s budget. The year‐to‐date Business Licenses revenue of $246k is $39k or 14% below the prior year and is also $32k or 12% lower than the budget. The City is projecting business licenses to be under the budget at year‐end. 2013 2014 2014 Actual Budget Actual $ % $ % Jan 82,440$ 75,206$ 80,243$ (2,196)$ ‐3% 5,038$ 7% Feb ‐ 451 ‐ Apr 70,311 72,698 74,163 3,852 5% 1,464 2% Jul 87,473 81,342 ‐ Aug 76 37 ‐ Oct 85,616 77,019 ‐ Nov 1,192 575 ‐ Dec 149 672 ‐ YTD Total 152,751$ 148,355$ 154,406$ 1,655$ 1% 6,502$ 4% Annual Total 327,258$ 308,000$ 2014 vs. Budget Admission Tax Revenue Year to Date through May Month 2014 vs. 2013 2013 2014 2014 Actual Budget Actual $ % $ % Jan 327,584$ 251,556$ 432,890$ 105,306$ 32% 181,335$ 72% Feb 230,039 215,688 412,317 182,278 79% 196,629 91% Mar 305,085 286,301 388,190 83,105 27% 101,889 36% Apr 367,165 315,718 374,004 6,839 2% 58,286 18% May 386,735 320,878 349,590 (37,145) ‐10% 28,712 9% Jun 293,386 278,431 Jul 314,991 307,931 Aug 340,270 351,856 Sep 254,799 214,610 Oct 440,169 432,077 Nov 393,258 338,737 Dec 348,144 391,919 YTD Total 1,616,609$ 1,390,140$ 1,956,991$ 340,382$ 21%566,851$ 41% Annual Total 4,001,625$ 3,705,701$ Building Permits and Development Service Fees Year to Date through May 2014 vs. Budget2014 vs. 2013 Month 2013 2014 2014 Actual Budget Actual $ % $ % Jan 95,381$ 103,448$ 103,064$ 7,683$ 8% (384)$ 0% Feb 40,658 36,482 25,013 (15,645) ‐38% (11,469) ‐31% Mar 12,441 9,762 5,421 (7,020) ‐56% (4,340) ‐44% Apr 102,648 107,716 97,104 (5,544) ‐5% (10,612) ‐10% May 33,354 20,233 15,091 (18,263) ‐55% (5,142) ‐25% Jun 5,701 5,102 ‐ Jul 52,586 84,946 ‐ Aug 29,210 24,595 ‐ Sep 4,236 4,178 ‐ Oct 109,998 117,828 ‐ Nov 13,342 14,515 ‐ Dec 4,211 4,262 ‐ YTD Total 284,482$ 277,641$ 245,693$ (38,790)$ ‐14% (31,948)$ ‐12% Annual Total 503,766$ 533,067$ 2014 vs. 2013 Year to Date through May 2014 vs. Budget Business Licenses Month Page 5 of 36 Monthly Financial Report May 2014 Intergovernmental These revenue sources include federal (direct and indirect) grants, state grants, state shared revenues, local grants, and entitlements. State shared revenues and Fire Districts’ 25 and 40 contracts compose 85% of the total revenues in this category. The year‐to‐date total Intergovernmental revenue is $5.7 million or 47% of the budget. The change in federal grants is due to the collection for CDBG grants in 2014. State Shared Revenues State Shared Revenue collections totalled $1.9 million since the start of the year. Compared to the prior year, State Shared Revenues are above by $194k or 11%. Compared to the projected budget, the City is collecting $196k or 11% more. The higher than expected collection is due to collecting more than anticipated Criminal Justice Sales Tax, the low budget of Criminal Justice’s High Crime and collecting more than anticipated Liquor Profits. Charges for Services These revenue sources consist of general government, public safety, plan review and inspection, culture and recreation, and interfund/interdepartmental sales and services. Recreation and interfund/interdepartmental sales and services constitute 63% of the total revenue in this category. The year‐to‐date total charges for services are $3 million or 42% of the budget. The following sections provide detail information for Public Safety, Recreation, and Interfund Services. Public Safety Services Public Safety Services totalled $281k since the start of the year. These services include private security, adult probation services, monitoring of prisoners, and intergovernmental public safety services (non‐grants). Compared to the prior year, the City is collecting $18k or 6% less. Compared to the year‐to‐date budget, the City is $48k or 15% less. The large April variance is due to a private security police provided for a large one‐time Intergovernmental 2013 2014 Bgt YTD Act Change 2014/2013 2014 Act vs Bgt Fire District #25 565,310$ 594,325$ 594,325$ 29,014$ 5% $ ‐ 0% Fire District #40 2,229,028 2,305,311 2,305,311 76,284 3%‐ 0% State Shared Revenue 1,743,346 1,741,072 1,937,057 193,712 11% 195,986 11% Federal Grants 509,586 778,872 778,872 269,286 53%‐ 0% State Grants 41,516 22,404 22,404 (19,112) ‐46%‐ 0% Other Grants/Intgovt 15,034 78,263 78,263 63,229 421%‐ 0% ARRA Grants 114,792 0 ‐ (114,792) 0%‐ 0% Total Rev YTD 5,218,611$ 5,520,246$ 5,716,232$ 497,621$ 10%195,986$ 4% Total Rev Annual 11,682,043$ 12,065,651$ YTD % 45% 46% 47% Note: Includes CJ Sales Tax and FD25 & FD40 contracts 2013 2014 2014 Actual Budget Actual $ % $ % Crim Just Sales Tax 840,766$ 801,013$ 904,495$ 63,729$ 8% 103,482$ 13% Judicial Contribution 11,398 11,250 11,342 (56) 0% 92 1% Crim Just ‐ High Crime 102,994 ‐ 127,155 24,161 23% 127,155 100% Crim Just ‐ Pop 10,797 ‐ 11,897 1,100 10% 11,897 100% Crim Just ‐ Spec Prog 40,452 43,527 44,030 3,577 9% 503 1% State DUI 8,515 9,080 8,694 180 2% (386) ‐4% Liquor Profits 211,723 124,448 212,414 691 0% 87,965 71% Liquor Excise Tax ‐ 248,924 92,598 92,598 100% (156,326) ‐63% Fuel Tax 516,701 502,829 524,433 7,732 1% 21,604 4% YTD Total 1,743,346$ 1,741,072$ 1,937,057$ 193,712$ 11% 195,986$ 11% Annual Total 4,701,889$ 4,515,500$ Year to Date through May State Shared Revenues 2014 vs. 2013 Revenue 2014 vs. Budget 2013 2014 2014 Actual Budget Actual $ % $ % Jan 32,322$ 31,574$ 117,639$ 85,317$ 264% 86,066$ 273% Feb 117,056 100,863 45,139 (71,918) ‐61% (55,725) ‐55% Mar 37,079 48,095 44,028 6,949 19% (4,067) ‐8% Apr 64,009 87,936 38,202 (25,806) ‐40% (49,734) ‐57% May 47,985 60,400 35,540 (12,446) ‐26% (24,860) ‐41% Jun 36,945 45,438 ‐ Jul 69,340 82,484 ‐ Aug 42,753 51,456 ‐ Sep 48,986 56,443 ‐ Oct 81,116 78,627 ‐ Nov 49,703 54,931 ‐ Dec 53,287 76,290 ‐ YTD Total 298,452$ 328,867$ 280,547$ (17,904)$ ‐6% (48,319)$ ‐15% Annual Total 680,581$ 774,535$ Month 2014 vs. 2013 Year to Date through May Public Safety Services 2014 vs. Budget Page 6 of 36 Monthly Financial Report May 2014 private business event in 2013. The City is projecting Public Safety Services to be under the budget by year‐end. Recreation Recreation revenues totalled $107k for the current month. Compared to the same month the prior year, the City collected $11k or 12% more. Compared to the projected monthly budget, the City collected $13k or 11% less. The year‐to‐date collection of $491k is $33k or 7% higher than the year before and is right on target with the year‐to‐date budget. The City is projecting Recreation revenues to be very close with the budget at year‐ end. Interfund Services The year‐to‐date collections for Interfund Services revenues are $1.4 million. Compared to the prior year, the revenues are under by $54k or 4%. Compared to the projected budget, the revenues are above by $22k or 2%. 2014’s monthly budgets are based on 1/12th of the annual budget. The majority of these revenues are related to indirect cost allocations, which are internal administrative costs. The remaining costs consist of Development Services division’s inspection fees, Parks Planning and Natural Resources division’s capital investment program reimbursements, Transportation division’s capital investment program reimbursements, and Maintenance division’s street maintenance reimbursements. 2013 2014 2014 Actual Budget Actual $ % $ % Jan 60,546$ 62,601$ 69,522$ 8,976$ 15% 6,921$ 11% Feb 51,160 56,408 68,873 17,713 35% 12,465 22% Mar 79,491 94,074 66,458 (13,033) ‐16% (27,616) ‐29% Apr 170,541 157,142 179,282 8,742 5% 22,140 14% May 95,710 119,835 106,771 11,061 12% (13,064) ‐11% Jun 150,284 152,865 ‐ Jul 345,126 309,124 ‐ Aug 205,821 238,859 ‐ Sep 123,550 118,153 ‐ Oct 83,685 86,617 ‐ Nov 65,656 67,145 ‐ Dec 63,010 63,040 ‐ YTD Total 457,448$ 490,060$ 490,907$ 33,459$ 7% 847$ 0% Annual Total 1,494,580$ 1,525,863$ Recreation Year to Date through May 2014 vs. Budget2014 vs. 2013 Month 2013 2014 2014 Actual Budget Actual $ % $ % Jan 265,873$ 277,733$ 301,808$ 35,935$ 14% 24,075$ 9% Feb 292,362 277,733 257,027 (35,335) ‐12% (20,706) ‐7% Mar 317,998 277,733 287,465 (30,533) ‐10% 9,732 4% Apr 288,610 277,733 295,489 6,879 2% 17,756 6% May 299,652 277,733 269,032 (30,619) ‐10% (8,700) ‐3% Jun 287,569 277,733 ‐ Jul 282,466 277,733 ‐ Aug 352,945 277,733 ‐ Sep 274,525 277,733 ‐ Oct 352,421 277,733 ‐ Nov 286,300 277,733 ‐ Dec 164,190 277,733 ‐ YTD Total 1,464,495$ 1,388,664$ 1,410,821$ (53,674)$ ‐4% 22,157$ 2% Annual Total 3,464,913$ 3,332,794$ 2014 vs. Budget Month Interfund Services Year to Date through May 2014 vs. 2013 Page 7 of 36 Monthly Financial Report May 2014 Fines and Penalties These revenue sources contain civil (penalties, infractions, and parking), criminal (traffic, non‐ traffic, and costs), and non‐court fines, forfeitures, and penalties. The table below breaks down these fines by type. The year‐to‐ date total fines and penalties is $964k. This is $309k or 24% lower than a year ago and is also $369k or 28% below the budget. Included in the Fines and Penalties revenue budget is $2 million from the Photo Enforcement program. The monthly budget is based on the prior year’s revenue. The year‐ to‐date collections from this program equates to $525k. The budget shortfall is due to temporary shutting down 4 intersection cameras in construction areas (expected until September) and lower activity (driver behaviour changes). The associated costs includes the equipment provided by American Traffic Solutions, Inc. (ATS), dedicated 2 FTEs in the Court Services Department to process the increased caseload and 1.1 FTEs in the Police Department for support services. This staff time, along with a 90% pro tem budget and interpreter costs amounts to $362k for personnel costs. The total costs for the program equates to $842k which is represented in the table. April and May expenditures do not include the monthly equipment rental costs paid to ATS, these costs will be included in June. 2013 2014 2014 Actual Budget Actual $ % $ % Jan 153,064$ 182,703$ 136,762$ (16,302)$ ‐11% (45,941)$ ‐25% Feb 247,166 251,253 151,470 (95,696) ‐39% (99,783) ‐40% Mar 275,222 276,820 203,482 (71,740) ‐26% (73,338) ‐26% Apr 318,235 312,315 263,785 (54,451) ‐17% (48,530) ‐16% May 278,783 309,616 208,436 (70,347) ‐25% (101,180) ‐33% Jun 269,334 307,008 Jul 236,571 269,780 Aug 171,565 178,125 Sep 154,604 169,913 Oct 191,919 249,230 Nov 189,412 230,005 Dec 280,787 321,732 YTD Total 1,272,471$ 1,332,708$ 963,935$ (308,535)$ ‐24% (368,773)$ ‐28% Annual Total 2,766,663$ 3,058,500$ Month 2014 vs. Budget2014 vs. 2013 Year to Date through May Fines and Penalties by Month Favorable Budget Actual Budget Actual (Unfavorable) 1 Jan 180,582$ 61,721$ 73,624$ 30,160$ 31,561$ Feb 165,453 68,045 73,336 51,174 16,871 Mar 161,059 103,922 73,278 79,750 24,172 Apr 214,411 166,547 71,661 30,160 136,388 May 214,507 125,097 73,575 30,160 94,937 Jun 207,265 ‐ 71,358 ‐ ‐ Jul 184,107 ‐ 71,451 ‐ ‐ Aug 93,843 ‐ 71,108 ‐ ‐ Sep 71,053 ‐ 58,646 ‐ ‐ Oct 159,611 ‐ 63,603 ‐ ‐ Nov 135,380 ‐ 64,079 ‐ ‐ Dec 162,729 ‐ 76,245 ‐ ‐ YTD Total 936,011$ 525,332$ 365,474$ 221,404$ 303,929$ Annual Total 1,950,000$ 841,964$ 1Actuals of Revenues and Expenses Photo Enforcement Program Year to Date through May Month Revenues Expenses Year to Date through May 2013 2014 2014 Actual Budget Actual $ % $ % Civil Penalties 3,079$ 5,275$ 2,854$ (225)$ ‐7% (2,421)$ ‐46% Civil Infraction Penalties 227,031 216,792 243,686 16,655 7% 26,894 12% Civil Parking Infraction Penalties 59,149 58,289 77,697 18,549 31% 19,408 33% Photo Enforcement Program 861,044 936,011 525,332 (335,712) ‐39% (410,679) ‐44% Criminal Traffic Misdemeanor Fines 41,689 40,281 35,825 (5,864) ‐14% (4,456) ‐11% Criminal Non‐Traffic Fines 10,902 14,198 18,842 7,940 73% 4,644 33% Criminal Costs 49,808 45,575 50,883 1,074 2% 5,307 12% Non‐Court Fines, Forfeitures and Penalties 19,769 16,286 8,816 (10,953) ‐55% (7,471) ‐46% YTD Total 1,272,471$ 1,332,708$ 963,935$ (308,535)$ ‐24% (368,773)$ ‐28% Annual Total 2,766,663$ 3,058,500$ Revenue 2014 vs. Budget Fines and Penalties by Type 2014 vs. 2013 Page 8 of 36 Monthly Financial Report May 2014 Miscellaneous This revenue source reflects the collection of interest and other earnings, rents, leases, and concessions, contributions, and donations from private sources, and other miscellaneous revenues. Interest and other earnings along with rents, leases, and concessions constitute 65% of the total revenue in this category. The year‐to‐date total miscellaneous is $647k. Compared to last year, the revenues are above by $32k or 5%. Compared to the projected year‐to‐date budget, the revenues are under by $36k or 5%. The table below page breaks out miscellaneous revenues by type. Other miscellaneous revenues are higher than the prior year and budget due to higher than expected utility late payment penalties and miscellaneous reimbursements for Fire. Seizure funds are lower than the budget due to the timing of activity. EXPENSES Overall the City has expended 40% of its budgeted general governmental expenditures at the end of May. This is $1.4 million or 2.9% below year‐to‐date budgeted expenditures. See below for summary of unfavorable items for general governmental departments. Council department is over the year‐to‐date budget by $5k or 3.9%. This is due to an annual membership payment made to National League Online. The budget for this was included in the Carry Forward amendment. We anticipate at year‐end the department will be within budget. Administrative Services department is over the year‐to‐date by $46k or 3.4%. This is mainly due to the timing of payments related to Springbrook merchant account fees and elections/voter registration costs compared to the prior years. We will monitor this item to determine if a budget adjustment is needed. 2013 2014 2014 Actual Budget Actual $ % $ % Jan 179,743$ 180,999$ 243,963$ 64,220$ 36% 62,964$ 35% Feb 76,397 59,215 99,547 23,149 30% 40,331 68% Mar 147,909 148,337 126,132 (21,777) ‐15% (22,204) ‐15% Apr 92,872 93,691 70,094 (22,778) ‐25% (23,597) ‐25% May 118,719 201,575 107,650 (11,069) ‐9% (93,925) ‐47% Jun 123,441 122,135 Jul 128,246 115,614 Aug 122,652 124,685 Sep 92,799 87,377 Oct 82,288 81,590 Nov 63,945 80,793 Dec 399,005 673,545 YTD Total 615,640$ 683,818$ 647,386$ 31,745$ 5% (36,432)$ ‐5% Annual Total 1,628,017$ 1,969,557$ Year to Date through May Month 2014 vs. Budget2014 vs. 2013 Miscellaneous Revenues by Month 2013 2014 2014 Actual Budget Actual $ % $ % Interests and Other Earnings 41,099$ 78,835$ 57,032$ 15,932$ 39% (21,803)$ ‐28% Rents, Leases, and Concessions 372,078 371,503 364,229 (7,849) ‐2% (7,274) ‐2% Contributions/Donations from Private Sources 30,611 43,531 41,698 11,087 36% (1,833) ‐4% Other 142,746 86,089 184,896 42,150 30% 98,807 115% Seizure Funds ‐ Federal/State/Local1 29,106 103,859 (470) (29,576) ‐102% (104,329) ‐100% YTD Total 615,640$ 683,818$ 647,386$ 31,745$ 5% (36,432)$ ‐5% Annual Total 1,628,017$ 1,969,557$ 1Seizure Funds are categorized in Miscellaneous for 2013 and on. 2014 vs. Budget Miscellaneous Revenues by Type Year to Date through May Revenue 2014 vs. 2013 Page 9 of 36 Monthly Financial Report May 2014 ENTERPRISE FUNDS The table below gives an analysis of all City Enterprise funds. Displayed are the year‐to‐date revenues and expenditures for each enterprise. Included in each fund are the capital revenues and expenditures. Airport Golf Course Solid Waste Utility Water Utility Wastewater Utility Surface Water Utility Metro REVENUES: Licenses and permits ‐ ‐ ‐ ‐ 29,785 23,925 ‐ Grants / intergovernmental 670,646 ‐ 117,144 ‐ ‐ 797,565 ‐ Charges for services 61,826 618,707 7,310,123 6,105,806 3,948,527 4,197,267 6,311,056 Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐ Fines and penalties 2,493 ‐ ‐ ‐ 143 ‐ ‐ Rents, leases, and misc fees 982,613 91,589 32,065 59,395 ‐ ‐ ‐ Interest and other misc 2,447 624 3,067 109,697 361,679 287,327 3,405 TOTAL REVENUES 1,720,025 710,920 7,462,399 6,274,898 4,340,134 5,306,084 6,314,461 EXPENSES: Utility billing ‐ ‐ 51,209 48,144 37,056 59,957 ‐ Utility systems ‐ ‐ 5,842,627 2,039,630 1,212,166 1,336,492 ‐ Utility maintenance ‐ ‐ 112,580 1,943,374 535,443 911,527 6,069,368 Transportation 1,332,442 ‐ ‐ ‐ ‐ ‐ ‐ Golf ‐ 801,342 ‐ ‐ ‐ ‐ ‐ TOTAL EXPENSES 1,332,442 801,342 6,006,416 4,031,148 1,784,665 2,307,976 6,069,368 AMOUNT AVAILABLE FOR DEBT SERVICE 387,583 (90,422) 1,455,983 2,243,750 2,555,469 2,998,108 245,093 DEBT SERVICE: Principal ‐ ‐ ‐ ‐ ‐ ‐ ‐ Interest ‐ 1,625 ‐ 302 121 181 ‐ TOTAL DEBT SERVICE ‐ 1,625 ‐ 302 121 181 ‐ CAPITAL PROJECTS 414,518 74,366 ‐ 473,240 1,025,927 929,354 ‐ TRANSFERS IN/(OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐ CHANGE IN FUND BALANCE (26,935) (166,413) 1,455,983 1,770,208 1,529,421 2,068,573 245,093 BEGINNING FUND BALANCE, Jan 1 1,669,564 319,161 1,344,883 12,350,952 5,528,366 7,510,285 2,603,562 ENDING FUND BALANCE, May 31 1,642,629 152,748 2,800,866 14,121,160 7,057,787 9,578,858 2,848,655 Page 10 of 36 Monthly Financial Report May 2014 INTERNAL SERVICE FUNDS The table below gives an analysis of all City Internal Service Funds. Displayed are the year‐to‐date revenues and expenditures for each internal service. Included in each fund are the capital revenues and expenditures. Equipment Rental Information Technology Facilities Communications Insurance Healthcare Retiree Healthcare REVENUES: Technology Fee ‐ 65,005 ‐ ‐ ‐ ‐ ‐ Grants / intergovernmental ‐ ‐ ‐ ‐ ‐ ‐ 44,426 Charges for services Equipment rental m&o 1,158,692 1,257,066 ‐ ‐ ‐ ‐ ‐ Print and mail ‐ 46,840 ‐ 168,216 ‐ ‐ ‐ Communications ‐ 3,090 ‐ 221,759 ‐ ‐ ‐ Facilities ‐ ‐ 1,773,168 ‐ ‐ ‐ ‐ Data cards and cell phones ‐ 58,509 ‐ ‐ ‐ ‐ ‐ IT service co ntracts ‐ 182,818 ‐ ‐ ‐ ‐ ‐ Interest and other misc 5,176 2,832 1,668 474 18,514 8,093 9,179 Internal service fund misc: Vehicle / equipment capital recovery 633,971 56,244 ‐ ‐ ‐ ‐ ‐ Insurance premiums ‐ ‐ ‐ ‐ 679,751 ‐ ‐ Worker's comp/unemployment ‐ ‐ ‐ ‐ 657,892 ‐ ‐ Benefit premiums ‐ ‐ ‐ ‐ ‐ 4,758,031 711,457 Other misc ‐ 2 1,286 ‐ ‐ 132,297 ‐ Interfund Loan ‐ ‐ ‐ ‐ 139,931 ‐ ‐ Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐ Disposal of capital assets 21,043 ‐ ‐ ‐ ‐ ‐ ‐ Insurance recoveries ‐ ‐ ‐ ‐ 54,521 ‐ ‐ TOTAL REVENUES 1,818,882 1,672,406 1,776,121 390,449 1,550,609 4,898,421 765,062 EXPENSES: Communications 211,159 Equipment rental 918,069 Facilities 1,500,270 Healthcare 5,625,573 Information technology 1,337,459 Print and mail 135,527 Retiree healthcare 458,835 Risk management Ri sk management 1,107,563 Unemployment 55,733 Worker's compensation 697,484 TOTAL EXPENSES 918,069 1,337,459 1,500,270 346,686 1,860,780 5,625,573 458,835 AMOUNT AVAILABLE FOR CAPITAL 900,813 334,947 275,851 43,763 (310,171) (727,152) 306,227 CAPITAL PROJECTS 453,280 183,293 39,687 ‐ ‐ ‐ ‐ TRANSFERS IN ‐ ‐ ‐ ‐ 3,600,000 ‐ ‐ TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐ CHANGE IN FUND BALANCE 447,533 151,654 236,164 43,763 3,289,829 (727,152) 306,227 BEGINNING FUND BALANCE, Jan 1 3,935,088 2,216,612 1,167,714 347,771 7,630,077 6,934,304 7,207,703 ENDING FUND BALANCE, May 31 4,382,621 2,368,266 1,403,878 391,534 10,919,906 6,207,152 7,513,930 Page 11 of 36 Monthly Financial Report May 2014 FUND BALANCE Page 13 shows the ending fund balance as of May 2014. The City’s fund balance is a combination of current deficit/surplus of funds which have accrued from unexpended operating budgets, unanticipated excess revenues, and from balances accumulated from prior years. The prior year’s balances (or beginning balance) include funds identified as being reserved for specific purposes or required to meet the current year’s appropriations. These balances also provide financial stability to the City’s operation during uncertain times and provide a layer of security to bondholders. At the end of May, the City has $22.8 million reported in the combined general governmental fund balance of the current year’s operating budget, which is approximately 20% of budgeted operating expenditures. This is an increase of $5.4 million from the year’s beginning balance. May’s ending fund balance is over the anticipated General Governmental Fund Balance of $20 million by $2.8 million or 13.9%. Although the ending fund balance is above projections, it is consistent with the prior years’ trends. CONTACT INFORMATION This report is prepared by the Finance Division of the Administrative Services Department. For additional financial information, please also review our website: http://www.rentonwa.gov/. For any questions about the report, please feel free to contact us at hnguyen@rentonwa.gov or JDThomas@Rentonwa.gov. Page 12 of 36 Monthly Financial Report May 2014 City of Renton All Funds ‐ Revenue, Expenditures and Fund Balances Cash Basis through May 31, 2014 Funds Balance 01/01/2014 Budgeted Revenue Revenue 05/31/14 Total Funds Available Budgeted Expenditure Expenditure 05/31/14 Ending Balance GENERAL GOVERNMENT FUNDS:17,454,261 107,476,905 50,233,421 67,687,682 111,626,502 44,853,913 22,833,769 000 General 12,515,053 77,540,984 35,656,597 48,171,650 81,920,905 36,322,467 11,849,183 001 Community Services 2,124,598 11,706,752 5,205,675 7,330,273 11,693,059 3,832,876 3,497,397 003 Street 1,667,393 9,028,020 4,325,897 5,993,290 9,028,020 3,563,213 2,430,076 004 Community Dev Block Grant (229,834) 548,203 304,785 74,951 308,172 103,069 (28,118) 005 Museum 52,979 226,683 113,378 166,357 226,683 84,860 81,497 009 Farmers Market 98,826 60,400 13,601 112,427 83,322 25,738 86,689 011 Fire Health & Wellness 55,094 25,000 10,451 65,545 25,000 4,153 61,392 031 Park Memorial 478 ‐ ‐ 478 478 478 ‐ 201 Ltd GO Bonds Gen Govt Debt 833,717 1,749,705 876,005 1,709,722 1,749,705 ‐ 1,709,722 215 Gen Govt Misc Debt Service 335,957 6,591,158 3,727,032 4,062,989 6,591,158 917,058 3,145,931 SPECIAL REVENUE FUNDS: 102 Arterial Street 192,689 633,000 247,160 439,849 810,000 ‐ 439,849 108 Leased City Properties 549,887 833,071 249,027 798,914 853,626 280,688 518,226 110 Hotel Motel 185,606 265,000 76,974 262,580 315,693 84,819 177,761 125 1% For Art 97,771 15,000 117 97,888 50,000 7,050 90,838 127 Cable Communication 284,632 85,674 64,983 349,615 85,674 19,930 329,685 135 Springbrook Wetlands Bank 667,613 ‐ 835 668,448 ‐ ‐ 668,448 CAPITAL PROJECT FUNDS (CIP): 303 Community Dev Mitigation 934,618 60,000 75,027 1,009,645 ‐ ‐ 1,009,645 304 Fire Mitigation 646,165 50,000 95,404 741,569 ‐ ‐ 741,569 305 Transportation Mitigation 486,185 40,000 194,407 680,592 200,000 ‐ 680,592 316 Municipal Facilities CIP 5,083,524 3,070,672 855,641 5,939,165 7,921,548 1,467,151 4,472,014 317 Transportation CIP 2,687,303 18,857,104 1,636,366 4,323,669 20,835,072 5,762,849 (1,439,180) 318 So Lake WA Infrastructure Proj 9,012 ‐ 11 9,023 9,012 ‐ 9,023 326 Housing Opportunity 84,599 1,000,000 1,000,093 1,084,692 75,000 ‐ 1,084,692 336 New Library Development 19,571,748 450,000 474,372 20,046,120 20,021,748 814,469 19,231,651 ENTERPRISE FUNDS: 402 Airport 191,466 1,505,636 1,047,470 1,238,936 1,496,624 666,994 571,942 403 Solid Waste Utility 1,344,883 16,419,820 7,462,399 8,807,282 16,508,948 6,006,416 2,800,866 404 Golf Course 33,445 2,487,449 710,564 744,009 2,522,025 823,798 (79,789) 422 Airport Capital 1,478,098 15,878,548 672,556 2,150,654 17,331,646 1,079,965 1,070,689 424 Golf Course Capital 285,716 50,000 21,187 306,903 193,894 74,366 232,537 INTERNAL SERVICE FUNDS: 501 Equipment Repair/Replacement 3,935,088 4,361,968 1,818,882 5,753,970 4,829,709 1,371,349 4,382,621 502 Insurance 7,630,077 7,344,062 5,150,609 12,780,686 3,188,983 1,860,780 10,919,906 503 Information Services 2,216,612 4,010,222 1,672,406 3,889,018 5,358,145 1,520,752 2,368,266 504 Facilities 1,167,714 4,105,749 1,776,121 2,943,835 4,505,641 1,539,957 1,403,878 505 Communications 347,771 896,374 390,449 738,220 917,403 346,686 391,534 512 Insurance, Healthcare 6,934,304 11,622,068 4,898,421 11,832,725 12,062,456 5,625,573 6,207,152 522 Insurance, Leoff1 Retirees HC 7,207,703 1,735,684 765,062 7,972,765 1,738,162 458,835 7,513,930 FIDUCIARY FUNDS: 611 Firemen's Pension 4,790,247 300,000 145,985 4,936,232 225,475 74,396 4,861,836 Funds Balance 01/01/2014 Budgeted Revenue Revenue 05/31/14 Total Funds Available Budgeted Expenditure Expenditure 05/31/14 Ending Balance ENTERPRISE FUNDS: COMBINED UTILITIES 27,993,165 62,804,226 22,235,578 50,228,743 68,486,436 16,622,282 33,606,461 405 Water Utility 8,523,106 13,765,149 6,197,958 14,721,064 11,453,942 3,276,707 11,444,357 406 Waste Water Utility 2,578,193 7,263,934 3,993,605 6,571,798 5,544,029 1,758,238 4,813,560 407 Surface Water Utility 4,342,360 4,867,612 4,227,657 8,570,017 6,996,129 2,044,294 6,525,723 416 King County Metro 2,603,562 15,202,336 6,314,461 8,918,023 15,202,336 6,069,368 2,848,655 425 Water Utility Construction 3,811,904 4,385,000 76,920 3,888,824 7,771,000 1,227,983 2,660,841 426 Waste Water Construction 2,950,173 4,900,000 346,530 3,296,703 7,055,000 1,052,475 2,244,228 427 Surface Water Construction 3,167,925 12,420,195 1,078,427 4,246,352 14,464,000 1,193,217 3,053,135 471 Waterworks Rate Stabilization 15,942 ‐ 20 15,962 ‐ ‐ 15,962 Note: Waterworks Utility Funds are managed as a system and are designated by the dotted lines. Page 13 of 36 City of Renton General Government Financial Position 2014 Budget Year General Government Summary Revenues Expenditures $ Difference over (under) w/beginning balance 17,454,261 January 5,710,991 8,047,088 (2,336,097) 15,118,164 February 12,530,792 15,890,655 (3,359,862) 14,094,399 March 19,541,262 23,627,952 (4,086,690) 13,367,571 April 32,250,423 32,119,009 131,414 17,585,675 May 50,233,421 44,853,913 5,379,508 22,833,769 June July August September October November December (9,000,000) (8,000,000) (7,000,000) (6,000,000) (5,000,000) (4,000,000) (3,000,000) (2,000,000) (1,000,000) ‐ 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 7,000,000 ‐ 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 110,000,000 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Change in Fund Balance Rev/Exp Revenues Expenditures Change in Fund Balance Page 14 of 36 City of Renton Monthly Revenue Analysis ‐ 2014 Budget Year General Government Budget YTD Actual Annual % over (under) Jan 5,848,043 5,710,991 ‐2.34% Feb 11,902,762 12,530,792 5.28% Mar 17,726,513 19,541,262 10.24% Apr 34,984,794 32,250,423 ‐7.82% May 48,802,249 50,233,421 2.93% Jun 54,105,548 Jul 60,607,580 Aug 65,982,074 Sep 71,508,663 Oct 88,476,347 Nov 100,518,179 Dec 107,476,905 Percent of budget 46.74% Property Tax Budget YTD Actual Annual % over (under) Jan 162,468 (101,807) ‐162.66% Feb 221,564 74,744 ‐66.27% Mar 1,182,448 1,701,026 43.86% Apr 11,815,359 7,509,891 ‐36.44% May 18,180,258 18,201,961 0.12% Jun 18,250,621 Jul 18,542,776 Aug 18,546,494 Sep 19,130,963 Oct 29,751,020 Nov 34,808,607 Dec 35,240,495 Percent of budget 51.65% $‐ $10 $20 $30 $40 $50 $60 $70 $80 $90 $100 $110 Millions Total Revenue General Government Budget Actual Last Year $(3) $‐ $3 $6 $9 $12 $15 $18 $21 $24 $27 $30 $33 $36 Millions Property Tax Budget Actual Last Year Page 15 of 36 City of Renton Monthly Revenue Analysis ‐ 2014 Budget Year Sales Tax Budget YTD Actual Annual % over (under) Jan 1,780,130 1,796,358 0.91% Feb 4,049,868 4,122,324 1.79% Mar 5,735,971 5,867,541 2.29% Apr 7,449,682 7,607,062 2.11% May 9,403,295 9,574,693 1.82% Jun 11,160,683 Jul 12,941,079 Aug 14,856,274 Sep 16,674,205 Oct 18,600,929 Nov 20,542,214 Dec 22,432,262 Percent of budget 42.68% Note: Excludes CJ Sales Tax and Natural Gas Use Tax. Utility Tax Budget YTD Actual Annual % over (under) Jan 1,372,593 1,373,119 0.04% Feb 2,862,943 2,897,682 1.21% Mar 4,173,577 4,529,120 8.52% Apr 5,637,269 5,748,119 1.97% May 7,000,058 7,128,436 1.83% Jun 8,151,130 Jul 9,449,365 Aug 10,668,223 Sep 12,034,563 Oct 13,138,008 Nov 14,360,964 Dec 15,859,850 Percent of budget 44.95% Note: Includes Natural Gas Use Tax. $‐ $3 $6 $9 $12 $15 $18 $21 $24 Millions Sales Tax Budget Actual Last Year $‐ $2 $4 $6 $8 $10 $12 $14 $16 Millions Utility Tax Budget Actual Last Year Page 16 of 36 City of Renton Monthly Revenue Analysis ‐ 2014 Budget Year Licenses & Permits Budget YTD Actual Annual % over (under) Jan 283,179 404,067 42.69% Feb 483,298 718,566 48.68% Mar 687,979 929,709 35.14% Apr 1,005,116 1,321,521 31.48% May 1,238,954 1,615,047 30.36% Jun 1,452,511 Jul 1,758,517 Aug 2,047,093 Sep 2,213,029 Oct 2,636,671 Nov 2,886,417 Dec 3,129,504 Percent of budget 51.61% Note: Franchise Fees Intergovt'l Budget YTD Actual Annual % over (under) Jan 801,032 846,109 5.63% Feb 1,641,056 1,714,034 4.45% Mar 2,013,994 2,206,902 9.58% Apr 3,092,667 3,273,493 5.85% May 5,520,246 5,716,232 3.55% Jun 6,127,583 Jul 6,846,446 Aug 7,438,545 Sep 7,915,288 Oct 8,973,681 Nov 11,401,563 Dec 12,065,651 Percent of budget 47.38% Note: Includes CJ Sales Tax and FD25 & FD40 contracts $‐ $1 $2 $3 $4 $5 $6 $7 $8 $9 $10 $11 $12 Millions Intergovernmental Budget Actual Last Year $‐ $0.50 $1.00 $1.50 $2.00 $2.50 $3.00 $3.50 Millions Licenses & Permits Budget Actual Last Year Page 17 of 36 City of Renton Monthly Revenue Analysis ‐ 2014 Budget Year Charges for Services Budget YTD Actual Annual % over (under) Jan 466,134 669,010 43.52% Feb 1,002,386 1,198,034 19.52% Mar 1,548,420 1,831,413 18.28% Apr 2,214,131 2,482,936 12.14% May 2,816,212 3,017,160 7.14% Jun 3,402,473 Jul 4,200,894 Aug 4,887,074 Sep 5,421,972 Oct 6,024,642 Nov 6,558,687 Dec 7,158,086 Percent of budget 42.15% Note: Excludes FD25 & FD40 contracts Fines & Forfeits Budget YTD Actual Annual % over (under) Jan 182,703 136,762 ‐25.15% Feb 433,957 288,232 ‐33.58% Mar 710,777 491,714 ‐30.82% Apr 1,023,092 755,499 ‐26.16% May 1,332,708 963,935 ‐27.67% Jun 1,639,716 Jul 1,909,496 Aug 2,087,621 Sep 2,257,534 Oct 2,506,763 Nov 2,736,768 Dec 3,058,500 Percent of budget 31.52% $‐ $1 $2 $3 $4 $5 $6 $7 $8 Millions Charges for Services Budget Actual Last Year $‐ $0.50 $1.00 $1.50 $2.00 $2.50 $3.00 $3.50 Millions Fines & Forfeits Budget Actual Last Year Page 18 of 36 City of Renton Monthly Revenue Analysis ‐ 2014 Budget Year Other Taxes Budget YTD Actual Annual % over (under) Jan 618,804 343,410 ‐44.50% Feb 967,476 1,173,666 21.31% Mar 1,284,796 1,511,820 17.67% Apr 2,265,235 3,008,720 32.82% May 2,626,701 3,359,954 27.92% Jun 3,114,878 Jul 4,037,441 Aug 4,404,498 Sep 4,727,481 Oct 5,629,416 Nov 5,926,947 Dec 6,563,000 Percent of budget 51.20% Misc Budget YTD Actual Annual % over (under) Jan 180,999 243,963 34.79% Feb 240,215 343,510 43.00% Mar 388,551 469,642 20.87% Apr 482,243 539,736 11.92% May 683,818 647,386 ‐5.33% Jun 805,952 Jul 921,566 Aug 1,046,251 Sep 1,133,629 Oct 1,215,219 Nov 1,296,012 Dec 1,969,557 Percent of budget 32.87% $‐ $0.20 $0.40 $0.60 $0.80 $1.00 $1.20 $1.40 $1.60 $1.80 $2.00 Millions Miscellaneous Budget Actual Last Year $‐ $1 $2 $3 $4 $5 $6 $7 $8 Millions Other Taxes Budget Actual Last Year Page 19 of 36 City of Renton Monthly Revenue Analysis ‐ 2014 Budget Year Other Financing Budget YTD Actual Annual % over (under) Jan ‐ ‐ N/A Feb ‐ ‐ N/A Mar ‐ 2,375 100.00% Apr ‐ 3,447 100.00% May ‐ 8,617 100.00% Jun ‐ Jul ‐ Aug ‐ Sep ‐ Oct ‐ Nov ‐ Dec ‐ Percent of budget 100.00% $0 $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 Other Financing Sources Budget Actual Last Year Page 20 of 36 City of Renton Monthly Revenue Analysis ‐ 2014 Budget Year REET Budget YTD Actual Annual % over (under) Jan 94,134 162,143 72.25% Feb 278,168 610,596 119.51% Mar 438,277 838,225 91.25% Apr 577,013 1,747,345 202.83% May 777,722 2,010,091 158.46% Jun 1,021,902 Jul 1,207,067 Aug 1,413,460 Sep 1,591,955 Oct 1,783,413 Nov 2,023,852 Dec 2,900,000 Percent of budget 69.31% Bldg Permits & Devlpmt Svc Fees Budget YTD Actual Annual % over (under) Jan 251,556 432,890 72.09% Feb 467,244 845,207 80.89% Mar 753,544 1,233,397 63.68% Apr 1,069,262 1,607,401 50.33% May 1,390,140 1,956,991 40.78% Jun 1,668,571 Jul 1,976,502 Aug 2,328,357 Sep 2,542,968 Oct 2,975,045 Nov 3,313,782 Dec 3,705,701 Percent of budget 52.81% $‐ $0.50 $1.00 $1.50 $2.00 $2.50 $3.00 $3.50 $4.00 $4.50 Millions Real Estate Excise Tax Budget Actual Last Year $‐ $0.50 $1.00 $1.50 $2.00 $2.50 $3.00 $3.50 $4.00 Millions Building Permits and Development Service Fees Budget Actual Last Year Page 21 of 36 City of Renton Monthly Expenditure Analysis ‐ 2014 Budget Year General Government Budget YTD Actual Annual % over (under) Jan 7,656,884 8,047,088 5.10% Feb 16,346,895 15,890,655 ‐2.79% Mar 24,067,020 23,627,952 ‐1.82% Apr 32,912,955 32,119,009 ‐2.41% May 46,211,853 44,853,913 ‐2.94% Jun 54,927,418 Jul 64,644,477 Aug 73,936,346 Sep 83,251,821 Oct 92,225,305 Nov 101,392,393 Dec 111,626,501 Percent of budget expended 40.18% Legislative Budget YTD Actual Annual % over (under) Jan 24,713 23,569 ‐4.63% Feb 50,791 55,960 10.18% Mar 77,175 84,100 8.97% Apr 103,348 108,911 5.38% May 128,959 133,956 3.88% Jun 154,624 Jul 180,383 Aug 205,498 Sep 231,042 Oct 256,847 Nov 282,568 Dec 309,907 Percent of budget expended 43.22% $‐ $10 $20 $30 $40 $50 $60 $70 $80 $90 $100 $110 $120 Millions Total Expenditures General Government Budget Actual Last Year $‐ $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 Legislative Budget Actual Last Year Page 22 of 36 City of Renton Monthly Expenditure Analysis ‐ 2014 Budget Year Executive Budget YTD Actual Annual % over (under) Jan 80,412 76,257 ‐5.17% Feb 197,216 186,396 ‐5.49% Mar 316,702 296,472 ‐6.39% Apr 439,720 407,807 ‐7.26% May 557,592 517,214 ‐7.24% Jun 661,840 Jul 776,168 Aug 891,836 Sep 997,727 Oct 1,110,465 Nov 1,222,415 Dec 1,359,996 Percent of budget expended 38.03% City Attorney Budget YTD Actual Annual % over (under) Jan 143,108 135,206 ‐5.52% Feb 289,153 276,371 ‐4.42% Mar 435,055 419,299 ‐3.62% Apr 589,689 562,501 ‐4.61% May 731,578 713,626 ‐2.45% Jun 882,055 Jul 1,024,858 Aug 1,170,538 Sep 1,323,502 Oct 1,482,556 Nov 1,626,768 Dec 1,863,395 Percent of budget expended 38.30% $‐ $0.30 $0.60 $0.90 $1.20 $1.50 Millions Executive Budget Actual Last Year $‐ $0.40 $0.80 $1.20 $1.60 $2.00 Millions City Attorney Budget Actual Last Year Page 23 of 36 City of Renton Monthly Expenditure Analysis ‐ 2014 Budget Year Court Services Budget YTD Actual Annual % over (under) Jan 163,940 159,512 ‐2.70% Feb 331,204 323,167 ‐2.43% Mar 499,924 487,984 ‐2.39% Apr 676,750 660,115 ‐2.46% May 849,947 830,863 ‐2.25% Jun 1,039,155 Jul 1,215,215 Aug 1,385,662 Sep 1,555,116 Oct 1,726,270 Nov 1,897,359 Dec 2,094,010 Percent of budget expended 39.68% CED Admin Budget YTD Actual Annual % over (under) Jan 83,847 83,232 ‐0.73% Feb 167,836 166,457 ‐0.82% Mar 252,105 249,681 ‐0.96% Apr 338,988 333,812 ‐1.53% May 421,256 418,279 ‐0.71% Jun 504,064 Jul 586,980 Aug 669,788 Sep 752,773 Oct 835,539 Nov 918,100 Dec 1,012,142 Percent of budget expended 41.33% $‐ $0.20 $0.40 $0.60 $0.80 $1.00 $1.20 $1.40 $1.60 $1.80 $2.00 $2.20 Millions Court Services Budget Actual Last Year $‐ $0.20 $0.40 $0.60 $0.80 $1.00 $1.20 Millions Community & Economic Development Admin Budget Actual Last Year Page 24 of 36 City of Renton Monthly Expenditure Analysis ‐ 2014 Budget Year Development Services Budget YTD Actual Annual % over (under) Jan 245,147 216,780 ‐11.57% Feb 475,540 437,105 ‐8.08% Mar 710,754 683,399 ‐3.85% Apr 967,749 931,956 ‐3.70% May 1,211,026 1,163,496 ‐3.92% Jun 1,463,648 Jul 1,721,037 Aug 1,995,920 Sep 2,250,357 Oct 2,519,009 Nov 2,776,952 Dec 3,040,435 Percent of budget expended 38.27% Economic Development Budget YTD Actual Annual % over (under) Jan 79,265 36,443 ‐54.02% Feb 121,101 80,671 ‐33.39% Mar 166,928 136,650 ‐18.14% Apr 216,402 186,131 ‐13.99% May 261,778 230,384 ‐11.99% Jun 312,460 Jul 365,766 Aug 423,762 Sep 475,562 Oct 526,555 Nov 583,152 Dec 644,063 Percent of budget expended 35.77% $‐ $0.50 $1.00 $1.50 $2.00 $2.50 $3.00 $3.50 Millions Development Services Budget Actual Last Year $‐ $0.10 $0.20 $0.30 $0.40 $0.50 $0.60 $0.70 Millions Economic Development Budget Actual Last Year Page 25 of 36 City of Renton Monthly Expenditure Analysis ‐ 2014 Budget Year Planning Budget YTD Actual Annual % over (under) Jan 176,776 123,910 ‐29.91% Feb 364,981 264,152 ‐27.63% Mar 549,854 426,860 ‐22.37% Apr 735,514 584,673 ‐20.51% May 921,326 747,714 ‐18.84% Jun 1,108,350 Jul 1,296,003 Aug 1,501,983 Sep 1,703,471 Oct 1,879,353 Nov 2,062,499 Dec 2,261,206 Percent of budget expended 33.07% Finance Budget YTD Actual Annual % over (under) Jan 153,798 161,643 5.10% Feb 309,673 331,528 7.06% Mar 474,196 505,966 6.70% Apr 647,301 678,686 4.85% May 825,083 852,555 3.33% Jun 1,006,594 Jul 1,192,630 Aug 1,381,616 Sep 1,546,956 Oct 1,701,753 Nov 1,852,570 Dec 2,334,758 Percent of budget expended 36.52% $‐ $0.40 $0.80 $1.20 $1.60 $2.00 $2.40 Millions Finance Budget Actual Last Year $‐ $0.50 $1.00 $1.50 $2.00 $2.50 Millions Planning Budget Actual Last Year Page 26 of 36 City of Renton Monthly Expenditure Analysis ‐ 2014 Budget Year City Clerk Budget YTD Actual Annual % over (under) Jan 64,003 62,855 ‐1.79% Feb 132,897 183,252 37.89% Mar 216,913 380,731 75.52% Apr 292,782 446,560 52.52% May 498,004 516,105 3.63% Jun 563,065 Jul 745,933 Aug 827,964 Sep 901,085 Oct 973,200 Nov 1,046,567 Dec 1,125,927 Percent of budget expended 45.84% Includes Hearing Examiner Human Resources Budget YTD Actual Annual % over (under) Jan 72,706 63,751 ‐12.32% Feb 152,715 131,247 ‐14.06% Mar 239,432 203,164 ‐15.15% Apr 320,251 294,344 ‐8.09% May 397,478 365,419 ‐8.07% Jun 489,534 Jul 572,574 Aug 658,226 Sep 739,793 Oct 822,360 Nov 907,045 Dec 1,002,994 Percent of budget expended 36.43% $‐ $0.20 $0.40 $0.60 $0.80 $1.00 Millions Human Resources Budget Actual Last Year $‐ $0.20 $0.40 $0.60 $0.80 $1.00 $1.20 Millions City Clerk Budget Actual Last Year Page 27 of 36 City of Renton Monthly Expenditure Analysis ‐ 2014 Budget Year Police Budget YTD Actual Annual % over (under) Jan 2,445,788 2,620,270 7.13% Feb 4,883,369 4,935,606 1.07% Mar 7,300,805 7,538,512 3.26% Apr 9,820,439 9,787,131 ‐0.34% May 12,415,628 12,388,107 ‐0.22% Jun 15,133,723 Jul 17,838,638 Aug 20,173,278 Sep 22,849,319 Oct 25,195,504 Nov 27,818,990 Dec 30,425,197 Percent of budget expended 40.72% Fire & Emergency Services Budget YTD Actual Annual % over (under) Jan 2,041,819 2,561,083 25.43% Feb 4,847,480 4,745,812 ‐2.10% Mar 6,854,096 6,727,201 ‐1.85% Apr 8,855,803 8,701,872 ‐1.74% May 11,028,108 10,587,000 ‐4.00% Jun 13,014,291 Jul 15,006,605 Aug 17,030,818 Sep 19,036,886 Oct 21,071,064 Nov 23,133,937 Dec 25,219,873 Percent of budget expended 41.98% $‐ $3 $6 $9 $12 $15 $18 $21 $24 $27 $30 $33 Millions Police Budget Actual Last Year $‐ $3 $6 $9 $12 $15 $18 $21 $24 $27 Millions Fire & Emergency Services Budget Actual Last Year Page 28 of 36 City of Renton Monthly Expenditure Analysis ‐ 2014 Budget Year Community Services Admin Budget YTD Actual Annual % over (under) Jan 42,394 36,113 ‐14.82% Feb 82,537 75,787 ‐8.18% Mar 122,781 120,240 ‐2.07% Apr 164,144 158,781 ‐3.27% May 205,095 196,067 ‐4.40% Jun 245,774 Jul 286,244 Aug 326,379 Sep 366,052 Oct 405,523 Nov 447,189 Dec 493,982 Percent of budget expended 39.69% Parks Budget YTD Actual Annual % over (under) Jan 292,322 271,473 ‐7.13% Feb 598,427 555,521 ‐7.17% Mar 920,103 856,188 ‐6.95% Apr 1,273,822 1,154,945 ‐9.33% May 1,614,058 1,483,776 ‐8.07% Jun 1,979,168 Jul 2,366,921 Aug 2,777,634 Sep 3,184,127 Oct 3,574,538 Nov 3,939,495 Dec 4,311,514 Percent of budget expended 34.41% $‐ $0.50 $1.00 $1.50 $2.00 $2.50 $3.00 $3.50 $4.00 $4.50 Millions Parks Budget Actual Last Year $0 $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 $400,000 $450,000 $500,000 Community Services Admin Budget Actual Last Year Page 29 of 36 City of Renton Monthly Expenditure Analysis ‐ 2014 Budget Year Parks Planning and Natural Resources Budget YTD Actual Annual % over (under) Jan 49,228 43,855 ‐10.91% Feb 101,030 90,409 ‐10.51% Mar 166,883 148,948 ‐10.75% Apr 229,214 201,429 ‐12.12% May 301,827 270,042 ‐10.53% Jun 366,732 Jul 431,978 Aug 495,631 Sep 564,205 Oct 636,195 Nov 702,081 Dec 880,373 Percent of budget expended 30.67% Recreation Budget YTD Actual Annual % over (under) Jan 317,480 278,944 ‐12.14% Feb 677,093 603,208 ‐10.91% Mar 1,041,360 928,117 ‐10.87% Apr 1,429,365 1,262,485 ‐11.68% May 1,793,244 1,601,422 ‐10.70% Jun 2,188,393 Jul 2,809,941 Aug 3,479,188 Sep 3,980,445 Oct 4,344,574 Nov 4,701,254 Dec 5,111,272 Percent of budget expended 31.33% $‐ $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 $800,000 $900,000 Parks Planning and Natural Resources Budget Actual Last Year $0.00 $0.50 $1.00 $1.50 $2.00 $2.50 $3.00 $3.50 $4.00 $4.50 $5.00 $5.50 Millions Recreation Budget Actual Last Year Page 30 of 36 City of Renton Monthly Expenditure Analysis ‐ 2014 Budget Year Human Services Budget YTD Actual Annual % over (under) Jan 54,337 47,594 ‐12.41% Feb 134,179 143,610 7.03% Mar 251,034 249,760 ‐0.51% Apr 389,020 385,688 ‐0.86% May 471,784 453,886 ‐3.79% Jun 540,831 Jul 679,987 Aug 748,949 Sep 802,062 Oct 950,120 Nov 1,027,713 Dec 1,221,989 Percent of budget expended 37.14% Neighborhoods , Resources, and Events Budget YTD Actual Annual % over (under) Jan 68,622 57,193 ‐16.66% Feb 131,885 146,776 11.29% Mar 210,347 200,847 ‐4.52% Apr 280,168 257,492 ‐8.09% May 348,656 307,785 ‐11.72% Jun 436,118 Jul 544,155 Aug 631,090 Sep 711,521 Oct 785,130 Nov 890,176 Dec 979,716 Percent of budget expended 31.42% $‐ $0.20 $0.40 $0.60 $0.80 $1.00 $1.20 $1.40 Millions Human Services Budget Actual Last Year $‐ $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 $800,000 $900,000 $1,000,000 Neighborhoods, Resources, and Events Budget Actual Last Year Page 31 of 36 City of Renton Monthly Expenditure Analysis ‐ 2014 Budget Year Museum Fund Budget YTD Actual Annual % over (under) Jan 18,447 16,819 ‐8.82% Feb 37,132 33,387 ‐10.09% Mar 55,837 49,955 ‐10.53% Apr 75,357 66,789 ‐11.37% May 94,204 84,860 ‐9.92% Jun 113,251 Jul 131,932 Aug 150,895 Sep 169,970 Oct 189,000 Nov 208,138 Dec 226,683 Percent of budget expended 37.44% Public Works Admin Budget YTD Actual Annual % over (under) Jan 40,644 31,793 ‐21.78% Feb 81,126 63,574 ‐21.64% Mar 121,691 95,355 ‐21.64% Apr 164,065 127,778 ‐22.12% May 203,500 160,270 ‐21.24% Jun 241,286 Jul 277,486 Aug 314,166 Sep 350,422 Oct 385,541 Nov 420,605 Dec 456,340 Percent of budget expended 35.12% $‐ $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 $400,000 $450,000 $500,000 Public Works Admin Budget Actual Last Year $‐ $30,000 $60,000 $90,000 $120,000 $150,000 $180,000 $210,000 $240,000 Museum Fund Budget Actual Last Year Page 32 of 36 City of Renton Monthly Expenditure Analysis ‐ 2014 Budget Year Street Maintenance Budget YTD Actual Annual % over (under) Jan 348,761 311,026 ‐10.82% Feb 744,828 658,352 ‐11.61% Mar 1,110,350 980,862 ‐11.66% Apr 1,489,239 1,423,475 ‐4.42% May 1,853,405 1,791,574 ‐3.34% Jun 2,241,891 Jul 2,607,657 Aug 2,962,105 Sep 3,328,647 Oct 3,699,390 Nov 4,070,992 Dec 4,488,268 Percent of budget expended 39.92% Transportation Budget YTD Actual Annual % over (under) Jan 299,741 278,181 ‐7.19% Feb 664,652 632,259 ‐4.87% Mar 1,036,278 921,240 ‐11.10% Apr 1,468,622 1,450,448 ‐1.24% May 1,810,444 1,771,639 ‐2.14% Jun 2,129,219 Jul 2,522,140 Aug 2,918,281 Sep 3,263,752 Oct 3,635,898 Nov 3,985,013 Dec 4,539,752 Percent of budget expended 39.03% $‐ $0.50 $1.00 $1.50 $2.00 $2.50 $3.00 $3.50 $4.00 $4.50 Millions Street Maintenance Budget Actual Last Year $0.0 $0.5 $1.0 $1.5 $2.0 $2.5 $3.0 $3.5 $4.0 $4.5 $5.0 Millions Transportation Budget Actual Last Year Page 33 of 36 City of Renton Monthly Expenditure Analysis ‐ 2014 Budget Year Debt Service Budget YTD Actual Annual % over (under) Jan 51,520 51,520 0.00% Feb 302,837 302,837 0.00% Mar 303,355 303,355 0.00% Apr 916,538 916,538 0.00% May 917,058 917,058 0.00% Jun 4,170,432 Jul 4,865,503 Aug 5,560,575 Sep 6,255,647 Oct 6,950,719 Nov 7,645,791 Dec 8,340,863 Percent of budget expended 10.99% Non‐ Departmental Other City Budget YTD Actual Annual % over (under) Jan 298,065 298,065 0.00% Feb 467,210 467,210 0.00% Mar 633,063 633,063 0.00% Apr 1,028,664 1,028,664 0.00% May 6,350,814 6,350,814 0.00% Jun 3,940,922 Jul 4,597,742 Aug 5,254,563 Sep 5,911,383 Oct 6,568,203 Nov 7,225,024 Dec 7,881,844 Percent of budget expended 80.58% $‐ $1.00 $2.00 $3.00 $4.00 $5.00 $6.00 $7.00 $8.00 Millions Non‐Departmental Other City Services Budget Actual Last Year $‐ $1 $2 $3 $4 $5 $6 $7 $8 $9 Millions Debt Service Budget Actual Last Year Page 34 of 36 City of Renton Monthly Enterprise Fund Financial Report ‐ 2014 Budget Year Utilities Budget Revenue Expense Jan 4,282,421 6,606,636 3,795,307 Feb 9,839,723 11,939,236 8,329,760 Mar 17,394,389 17,397,529 13,080,021 Apr 23,769,707 23,768,876 17,635,562 May 30,978,426 29,697,956 22,628,698 Jun 39,309,642 Jul 47,343,798 Aug 54,078,194 Sep 61,661,742 Oct 67,509,352 Nov 73,767,095 Dec 84,995,384 Percent of budget expended 23.43% Note: Operations and Capital Airport Budget Revenue Expense Jan 211,065 292,698 108,595 Feb 433,615 639,757 472,632 Mar 878,150 1,015,941 1,226,930 Apr 1,081,496 1,499,014 1,410,992 May 2,139,080 1,720,026 1,746,960 Jun 3,390,971 Jul 5,546,997 Aug 11,430,266 Sep 12,053,858 Oct 17,677,109 Nov 17,970,642 Dec 18,828,270 Percent of budget expended 9.28% Note: Operations and Capital $0 $10 $20 $30 $40 $50 $60 $70 $80 $90 Millions Utilities Budget Revenue Expense $‐ $2.00 $4.00 $6.00 $8.00 $10.00 $12.00 $14.00 $16.00 $18.00 $20.00 Millions Airport Budget Revenue Expense Page 35 of 36 City of Renton Monthly Enterprise Fund Financial Report ‐ 2014 Budget Year Golf Course Budget Revenue Expense Jan 148,339 83,199 128,950 Feb 311,204 157,539 295,744 Mar 506,698 276,011 463,052 Apr 746,715 478,430 653,009 May 929,343 731,751 898,163 Jun 1,151,882 Jul 1,346,835 Aug 1,533,049 Sep 1,729,746 Oct 1,916,501 Nov 2,077,100 Dec 2,715,919 Percent of budget expended 33.07% Note: Operations and Capital $‐ $0.30 $0.60 $0.90 $1.20 $1.50 $1.80 $2.10 $2.40 $2.70 $3.00 Millions Golf Course Budget Revenue Expense Page 36 of 36