HomeMy WebLinkAbout201808, August
h:\finance\financial reporting\monthly reports\2018 reports\cover 0818.docx
ADMINISTRATIVE SERVICES
M E M O R A N D U M
DATE: September 24, 2018
TO: Ed Prince, Council President
Members of Renton City Council
CC: Denis Law, Mayor
Bob Harrison, Chief Administrative Officer
FROM: Jan Hawn, ASD Administrator
STAFF CONTACT: Marc Gordon, Sr. Finance Analyst
SUBJECT: August 2018 Financial Status Report
At the end of August, general governmental revenues show $6.7M or 10.3% over budget.
Revenue source(s) that are higher than expected are: sales tax ($1.2M); sales tax
annexation credit ($228K); criminal justice sales tax ($190K); utility taxes ($702K);
gambling taxes ($620K); business & occupation taxes ($3.9M); public safety ($331K); and
interest & other earnings ($313K). On the down side, the revenue source(s) that are
underperforming the year to date budget are: business licensing ($60K); building permits
& development service fees ($447K below); and fines/penalties ($248K below).
General government expenditures showed a favorable variance of $3.2M or 5.0%. See
page 10 of report for further expenditure over-spent/savings explanations.
The attached report provides more detailed discussion of each revenue source and our
updated projections for the year. Please do not hesitate to contact me at x6937 should
you have any questions or any suggestions about the report.
Ed Prince, Council President
Members of Renton City Council
Page 2 of 2
September 24, 2018
h:\finance\financial reporting\monthly reports\2018 reports\cover 0818.docx
This page is intentionally left blank
Page | 1
Preliminary as of 09/25/2018
General Governmental Funds
$%
Beginning Fund Balance 19,962,845$ 19,962,845$ 26,563,785$ 26,563,785$ 33,284,838$ 33,284,838$ 33,284,838$ - 0.0%
OPERATING REVENUES
Property Tax 37,038,480 19,831,817 24,356,562 12,978,317 19,397,308 10,366,119 10,370,747 4,628 0.0%
Sales Tax 26,353,246 17,026,474 26,331,634 17,498,892 26,683,440 17,436,826 18,629,578 1,192,752 6.8%
Sales Tax - Annexation Credit 3,114,762 2,017,574 3,123,230 2,075,363 2,120,300 1,391,193 1,619,553 228,360 16.4%
Criminal Justice Sales Tax 2,701,787 1,766,874 2,808,564 1,824,013 2,782,404 1,813,187 2,002,996 189,810 10.5%
Natural Gas Use Tax 184,638 140,029 180,456 124,252 228,000 156,988 107,799 (49,189) -31.3%
Admission Tax 262,506 201,603 223,157 176,798 320,000 249,325 177,613 (71,712) -28.8%
Franchise Fees 1,406,092 1,047,459 1,562,100 1,144,972 1,330,000 982,394 1,142,521 160,127 16.3%
Electricity Tax 5,440,139 3,681,969 5,721,366 3,879,254 5,476,959 3,710,298 3,553,880 (156,417) -4.2%
Natural Gas Utility Tax 1,327,937 986,171 1,630,375 1,239,512 1,350,900 1,016,348 1,430,868 414,520 40.8%
Garbage/Solid Waste 717,148 462,068 627,254 403,111 680,000 437,608 492,831 55,222 12.6%
TV Cable 1,619,364 1,051,609 1,651,405 1,083,446 1,662,115 1,084,977 1,004,744 (80,233) -7.4%
Telephone 859,868 598,082 866,519 583,788 729,131 499,157 551,728 52,571 10.5%
Cellular Phone 1,541,204 1,046,848 1,481,298 1,009,511 1,536,267 1,045,199 853,856 (191,343) -18.3%
City Utilities 4,206,473 2,812,790 4,840,530 3,271,104 4,000,752 2,690,411 3,346,865 656,455 24.4%
Utility Tax Audit 111,227 111,227 - - - - - - 0.0%
Leasehold Excise Tax 173,769 99,207 173,396 131,503 179,000 118,955 130,789 11,835 9.9%
Gambling Excise Tax 2,500,604 1,690,672 2,695,368 1,750,312 2,000,000 1,324,482 1,944,235 619,754 46.8%
Real Estate Excise Tax 5,529,296 4,230,285 5,607,035 4,857,035 4,420,000 3,360,851 4,261,042 900,191 26.8%
Less: CIP REET (2,115,143) (2,115,143) (4,857,035) (4,857,035) (4,420,000) (3,360,851) (4,261,042) (900,191) 26.8%
EMS Levy 479,597 479,597 - - - - - - 0.0%
B&O Taxes 6,375,322 5,623,988 9,633,034 7,745,219 7,636,000 5,536,100 9,471,014 3,934,914 71.1%
Less: CIP B&O Taxes (2,000,000) (2,000,000) (2,473,974) (2,473,974) (1,379,314) (1,000,003) (1,379,314) (379,311) 37.9%
Business License Fees 1,926,510 1,581,624 1,480,730 1,102,900 1,311,894 1,016,172 956,551 (59,621) -5.9%
Less: CIP Business License Fees (1,587,627) (1,309,525) (614,796) (486,201) (623,186) (508,109) (356,629) 151,481 -29.8%
Animal Licenses and Spec Events Permits 102,905 70,186 140,391 105,184 94,174 66,553 89,917 23,364 35.1%
Building Permits & Development Svc Fees 5,293,563 3,668,283 4,907,983 3,313,654 5,451,699 3,731,695 3,284,409 (447,286) -12.0%
Intergovt'l (Grants, State Shared, etc)3,998,953 2,576,559 4,285,806 2,409,107 4,448,582 2,425,698 2,551,559 125,861 5.2%
Fire District 25 and 40 Contracts 3,517,779 3,517,779 341,939 341,939 357,660 357,660 357,660 - 0.0%
Public Safety 994,179 619,935 837,728 568,388 617,635 400,648 732,145 331,498 82.7%
Culture and Recreation 1,632,903 1,371,745 1,722,323 1,433,468 1,760,923 1,472,260 1,323,042 (149,218) -10.1%
Interfund/Interdept-Services 3,377,663 2,207,485 3,916,334 2,625,752 4,361,086 2,907,391 2,597,384 (310,006) -10.7%
Fines and Penalties 901,592 554,632 822,450 492,299 830,082 494,636 557,469 62,833 12.7%
Photo Enforcement 1,959,071 1,287,076 2,124,399 1,393,203 3,216,405 2,111,161 1,800,732 (310,429) -14.7%
Seizure Funds - Federal/State/Local 987,293 776,237 176,503 159,974 - - 245,888 245,888 100.0%
Interests and Other Earnings 1,058,880 473,805 1,155,371 565,841 875,300 410,975 724,746 313,771 76.3%
Rents, Leases, and Concessions 642,192 505,330 634,897 504,182 623,195 492,623 527,728 35,105 7.1%
Contributions and Donations 96,582 66,563 177,919 104,075 164,505 102,261 148,340 46,079 45.1%
Other Miscellaneous 956,131 613,025 954,680 665,357 702,998 462,198 463,031 833 0.2%
Other Financing Sources (Transfer-In, etc)2,129,561 6,075 283,213 98,866 152,142 13,000 13,000 - 0.0%
Total Operating Revenues 125,816,444 79,378,013 109,530,146 69,843,380 101,078,355 64,816,385 71,469,278 6,652,893 10.3%
OPERATING EXPENDITURES
Council 358,550 242,571 362,101 245,568 374,666 253,784 251,165 2,619 1.0%
Executive 1,778,206 1,165,850 1,954,748 1,290,543 2,046,962 1,346,961 1,355,859 (8,899) -0.7%
Emergency Management*370,832 258,124 569,333 370,942 628,191 420,323 397,472 22,851 5.4%
City Attorney 1,983,834 1,341,723 2,088,718 1,384,646 2,267,734 1,518,134 1,467,657 50,477 3.3%
Court Services 2,075,763 1,363,339 2,174,217 1,429,897 2,250,644 1,479,202 1,495,645 (16,443) -1.1%
Community and Eco Dvlpmnt Admin 1,161,330 767,998 1,351,830 893,461 1,344,262 888,696 897,301 (8,604) -1.0%
Development Services 2,859,410 1,850,577 3,023,728 2,066,905 3,446,946 2,295,263 1,958,078 337,185 14.7%
Economic Development 1,004,411 620,177 949,467 580,426 1,671,873 1,027,319 454,699 572,620 55.7%
Planning 2,716,214 1,797,371 2,815,148 1,787,262 3,580,743 2,320,523 1,971,940 348,583 15.0%
Finance 3,046,824 1,825,174 3,132,609 1,817,314 3,660,725 2,157,827 1,957,768 200,059 9.3%
City Clerk 914,251 726,986 1,119,376 751,477 1,359,565 988,415 920,872 67,543 6.8%
Human Resources 1,193,016 786,540 1,221,841 800,394 1,395,877 917,307 838,119 79,188 8.6%
Police 28,891,879 18,719,878 30,987,047 20,420,879 33,819,728 22,106,772 21,177,791 928,981 4.2%
Jail Services 4,704,978 3,136,577 4,807,443 3,203,926 5,968,750 3,981,126 3,981,126 - 0.0%
Fire*25,349,755 19,449,611 - - - - - - 0.0%
Community Services Admin 585,983 366,838 554,951 336,379 532,039 327,923 340,151 (12,228) -3.7%
Parks 4,489,736 2,923,962 4,864,643 3,054,123 5,367,552 3,454,207 3,242,364 211,843 6.1%
Parks Planning & Natural Resources 952,980 556,494 1,059,058 667,579 1,373,998 835,905 716,763 119,142 14.3%
Recreation 5,917,167 3,985,098 6,214,589 4,110,715 6,531,525 4,360,567 4,165,100 195,468 4.5%
Human Services 1,241,169 732,476 1,634,387 879,654 1,441,591 808,203 900,340 (92,138) -11.4%
Neighborhoods, Resources, & Events - - - - - - - - 0.0%
Museum 229,543 151,132 235,712 155,172 241,246 158,827 163,495 (4,668) -2.9%
Public Works Admin 398,796 267,579 406,781 271,835 417,024 279,239 278,939 301 0.1%
Street Maintenance 5,041,509 3,327,137 5,603,141 3,780,074 5,887,710 3,931,101 3,605,733 325,368 8.3%
Transportation 5,966,281 3,412,556 5,368,887 3,395,218 5,805,521 3,486,730 3,645,151 (158,421) -4.5%
Debt Service 6,099,166 1,441,996 6,063,576 1,361,480 5,703,244 1,277,094 1,277,094 - 0.0%
Non-Departmental and Other 9,883,923 3,063,984 14,245,763 2,160,209 4,778,864 2,039,684 2,039,684 - 0.0%
Total Operating Expenditures 119,215,504 74,281,749 102,809,093 57,216,081 101,896,981 62,661,133 59,500,307 3,160,826 5.0%
Total Ending Fund Balance 26,563,785$ 25,059,109$ 33,284,838$ 39,191,084$ 32,466,212$ 35,440,090$ 45,253,809$ 9,813,719$ 27.7%
*Emergency Management was moved to Executive due to formation of RRFA
Favorable (Unfavorable)
16 17 018 Variance
Annual Actual YTD Actual Annual Budget YTD Budget YTD ActualSummary of Sources and Uses Annual Actual YTD Actual
Monthly Financial Report August 2018
Monthly Financial Report August 2018
Page | 2
Preliminary as of 09/25/2018
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through August 31, 2018. Except as noted, year-to-
date budgeted 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 75% of all resources
supporting general governmental activities. The following section provides detail information on property, sales, utility, and other taxes.
Property Tax
Current Month Actual: $84K
YTD Actual: $10.4M
Budgeted YTD: $10.4M
Prior Year Same Month: $108K
Prior Year YTD: $13.0M
Year-to-Year Variance: $(-2.6M), -20%
Actual-to-Budget YTD Variance: $5K, .0%
Narrative: The negative amount for January is due to
the timing of recording January’s receipts in
February. February’s activity corrected the negative
January balance. The total property tax levy is $5
million less in 2018, which is why the year-to-year
comparison skews low.
Sales Tax
Current Month Actual: $2.6M
YTD Actual: $18.6M
Budgeted YTD: $17.4M
Prior Year Same Month: $2.4M
Prior Year YTD: $17.5M
Year-to-Year Monthly Variance: $152K, 6%
Year-to-Year YTD Variance: $196K, 8%
Actual-to-Budget Monthly Variance: $196K, 8%
Actual-to-Budget YTD Variance: $1.2M, 7%
Narrative: New Construction and Service are the
sectors generating and collecting more than
anticipated. 2018’s monthly budgets are generally
based on 2013 through 2017 collections.
17 018 018
Actual Budget Actual $%$%
Jan 55,429$ 31,649$ (12,745)$ (68,174)$ -123%(44,394)$ -140%
Feb 195,332 161,273 106,364 (88,967) -46%(54,909) -34%
Mar 902,965 687,696 665,471 (237,493) -26%(22,225) -3%
Apr 7,035,332 4,704,879 6,908,633 (126,700) -2%2,203,754 47%
May 4,489,476 4,548,312 2,419,925 (2,069,551) -46%(2,128,388) -47%
Jun 128,834 84,239 108,842 (19,992) -16%24,602 29%
Jul 69,600 40,053 90,072 20,471 29%50,018 125%
Aug 101,349 108,016 84,185 (17,164) -17%(23,831) -22%
Sep 442,694 316,388
Oct 4,057,893 3,251,619
Nov 6,733,813 5,371,847
Dec 143,844 91,336
YTD Total 12,978,317$ 10,366,119$ 10,370,747$ (2,607,570)$ -20%4,628$ 0.0%
Annual Total 24,356,562$ 19,397,308$
Property Tax Revenues
Year to Date through August
018 vs. 17 018 vs. Budget
Month
17 018 018
Actual Budget Actual $%$%
Jan 2,092,821$ 2,096,932$ 2,217,949$ 125,128$ 6%121,017$ 6%
Feb 2,473,715 2,495,067 2,839,044 365,329 15%343,977 14%
Mar 1,945,278 1,990,954 2,099,180 153,902 8%108,226 5%
Apr 1,871,345 1,956,740 2,009,648 138,303 7%52,908 3%
May 2,381,981 2,327,614 2,506,478 124,497 5%178,863 8%
Jun 2,075,555 2,050,822 1,997,751 (77,804) -4%(53,071) -3%
Jul 2,236,477 2,140,543 2,385,665 149,188 7%245,122 11%
Aug 2,421,720 2,378,153 2,573,863 152,143 6%195,710 8%
Sep 2,162,766 2,236,561 -
Oct 2,273,788 2,332,820 -
Nov 2,347,924 2,426,685 -
Dec 2,048,264 2,250,548 -
YTD Total 17,498,892$ 17,436,826$ 18,629,578$ 1,130,686$ 6%1,192,752$ 7%
Annual Total 26,331,634$ 26,683,440$
018 vs. Budget018 vs. 17
Month
Year to Date through August
Local Retail Sales Tax Revenues
Monthly Financial Report August 2018
Page | 3
Preliminary as of 09/25/2018
The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business sectors:
Utility tax
Current Month Actual: $1.2M
YTD Actual: $11.3M
Budgeted YTD: $9.5M
Prior Year Same Month: $1.2M
Prior Year YTD: $11.6M
Year-to-Year Monthly Variance: $18K, 2%
Year-to-Year YTD Variance: $(-251K), -2%
Actual-to-Budget Monthly Variance: $48K, 4%
Actual-to-Budget YTD Variance: $702K, 7%
Narrative: The large January variance with the
budget is due to the timing of when 2018
Cell/Phone/Garbage taxes were recorded. The
monthly budgets are based on 2016/2017 activity.
The table below breaks out Utility Tax by source. As mentioned last month, the large variance with electrical and natural gas was due to
an error in recording these revenues and has corrected itself in June.
Sales Tax by Sector 17 018 Bgt YTD Act Change 018 /17 018 Act vs Bgt
New Construction 2,828,855$ 2,408,028$ 3,001,576$ 172,722$ 6% $ 593,548 25%
Auto Sales 3,168,239 3,256,095 3,375,697 207,457 7% 119,602 4%
General Retail 5,077,816 5,264,211 5,160,892 83,076 2% (103,320)-2%
Manufacturing 1,001,529 1,266,108 1,177,338 175,809 18% (88,771)-7%
Wholesale 1,002,949 939,132 989,807 (13,142) -1% 50,675 5%
Service 3,901,077 3,842,172 4,476,311 575,234 15% 634,139 17%
Other 518,428 461,080 447,958 (70,470) -14% (13,122)-3%
YTD Total 17,498,892$ 17,436,826$ 18,629,578$ 1,130,686$ 6%1,192,752$ 7%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
17 018 018
Actual Budget Actual $%$%
Jan 1,698,721$ 1,472,870$ 1,395,386$ (303,335)$ -18%(77,484)$ -5%
Feb 1,360,589 1,413,168 1,617,972 257,383 19%204,804 14%
Mar 1,197,548 1,249,534 1,579,191 381,643 32%329,657 26%
Apr 1,797,449 1,493,002 1,463,336 (334,113) -19%(29,665) -2%
May 1,464,438 1,341,860 1,414,956 (49,482) -3%73,096 5%
Jun 1,351,607 1,173,122 1,269,602 (82,005) -6%96,480 8%
Jul 1,538,390 1,342,347 1,398,960 (139,430) -9%56,613 4%
Aug 1,185,237 1,155,083 1,203,168 17,931 2%48,086 4%
Sep 1,261,199 1,224,457
Oct 1,428,438 1,322,247
Nov 1,267,897 1,143,031
Dec 1,447,690 1,333,404
YTD Total 11,593,978$ 10,640,985$ 11,342,571$ (251,407)$ -2%701,586$ 7%
Annual Total 16,999,203$ 15,664,124$
018 vs. Budget018 vs. 17
Year to Date through August
Utility Tax Revenues
Month
Utility Tax by Type 17 018 Bgt YTD Act Change 018 /17 018 Act vs Bgt
Electrical 3,879,254$ 3,710,298$ 3,553,880$ (325,374)$ -8% $ (156,417)-4%
Natural Gas 1,363,764 1,173,336 1,538,667 174,903 13% 365,331 31%
Cell 1,009,511 1,045,199 853,856 (155,655) -15% (191,343)-18%
Phone 583,788 499,157 551,728 (32,060) -5% 52,571 11%
Cable 1,083,446 1,084,977 1,004,744 (78,702) -7% (80,233)-7%
Garbage/Solid Waste 403,111 437,608 492,831 89,720 22% 55,222 13%
City Utilities 3,271,104 2,690,411 3,346,865 75,761 2% 656,455 24%
Utility Tax Audit - - - - N/A - N/A
YTD Total 11,593,978$ 10,640,985$ 11,342,571$ (251,407)$ -2%701,586$ 7%
Annual Total 16,999,203$ 15,664,124$
YTD as % of 68%68%
Monthly Financial Report August 2018
Page | 4
Preliminary as of 09/25/2018
Other Taxes
Real Estate Excise Tax
Current Month Actual: $407K
YTD Actual: $4.3M
Budgeted YTD: $3.4M
Prior Year Same Month: $672K
Prior Year YTD: $4.9M
Year-to-Year Monthly Variance: $(-265K), -39%
Year-to-Year TYD Variance: $(-596K), -12%
Actual-to-Budget Monthly Variance: $(-100K), 20%
Actual-to-Budget YTD Variance: $900K, 27%
Narrative: The higher than expected variance is
due to 10 large transactions in December and
January which accounts for $708K of the total REET
collected.
Gambling Tax
Current Month Actual: $226K
YTD Actual: $1.9M
Budgeted YTD: $1.3M
Prior Year Same Month: $217K
Prior Year YTD: $1.8M
Year-to-Year Monthly Variance: $9K, 4%
Year-to-Year YTD Variance: $194K, 11%
Actual-to-Budget Monthly Variance: $19K, 9%
Actual-to-Budget YTD Variance: $620K, 47%
Narrative: Gambling tax revenue continues to
outperform budgeted expectations, which can
primarily be attributable to current economic
conditions.
Franchise Fees
Current Month Actual: $15K
YTD Actual: $1.1M
Budgeted YTD: $982K
Prior Year Same Month: $8K
Prior Year YTD: $1.1M
Year-to-Year Monthly Variance: $7K, 97%
Year-to-Year YTD Variance: $(-2K), -0.2%
Actual-to-Budget Monthly Variance: $12K, 340%
Actual-to-Budget YTD Variance: $160K, 16%
Narrative: Franchise fee revenue is performing
slightly better than expected and right on track
with prior year receipts.
17 018 018
Actual Budget Actual $%$%
Jan 220,536$ 157,924$ 210,929$ (9,607)$ -4%53,004$ 34%
Feb 200,622 157,269 255,285 54,663 27%98,016 62%
Mar 180,839 144,763 245,283 64,444 36%100,520 69%
Apr 219,422 160,397 275,795 56,373 26%115,399 72%
May 248,673 172,020 222,540 (26,133) -11%50,520 29%
Jun 232,889 160,867 252,663 19,775 8%91,796 57%
Jul 230,342 163,457 255,351 25,009 11%91,894 56%
Aug 216,990 207,784 226,388 9,398 4%18,605 9%
Sep 205,141 156,872 -
Oct 215,122 176,050 -
Nov 259,744 170,551 -
Dec 265,048 172,045 -
YTD Total 1,750,312$ 1,324,482$ 1,944,235$ 193,923$ 11%619,754$ 47%
Annual Total 2,695,368$ 2,000,000$
018 vs. 17
Gambling Tax Revenue
Month
Year to Date through August
018 vs. Budget
17 018 018
Actual Budget Actual $%$%
Jan 380,870$ 326,648$ 371,458$ (9,411)$ -2%44,810$ 14%
Feb 6,300 2,823 16,600 10,300 163%13,777 488%
Mar 9,100 4,078 15,792 6,692 74%11,714 287%
Apr 369,626 324,886 37,420 (332,207) -90%(287,467) -88%
May 7,688 3,445 340,622 332,934 4331%337,177 9788%
Jun 21,325 9,555 1,050 (20,275) -95%(8,505) -89%
Jul 342,363 307,508 344,386 2,023 1%36,878 12%
Aug 7,700 3,450 15,193 7,493 97%11,743 340%
Sep 8,750 6,161 -
Oct 375,128 324,373 -
Nov 10,500 4,705 -
Dec 22,750 12,367 -
YTD Total 1,144,972$ 982,394$ 1,142,521$ (2,451)$ -0.2%160,127$ 16%
Annual Total 1,562,100$ 1,330,000$
Franchise Fees Revenue
Year to Date through August
Month
018 vs. 17 018 vs. Budget
17 018 018
Actual Budget Actual $%$%
Jan 1,028,456$ 786,056$ 840,316$ (188,139)$ -18%54,260$ 7%
Feb 337,024 210,018 366,011 28,987 9%155,993 74%
Mar 708,868 391,942 291,045 (417,824) -59%(100,897) -26%
Apr 385,517 266,812 405,746 20,230 5%138,934 52%
May 386,087 300,651 607,431 221,344 57%306,780 102%
Jun 747,549 458,002 496,917 (250,632) -34%38,915 8%
Jul 591,137 440,175 846,631 255,494 43%406,456 92%
Aug 672,396 507,194 406,944 (265,453) -39%(100,250) -20%
Sep 633,804 431,443
Oct 359,891 308,343
Nov 775,249 398,534
Dec 585,757 (79,171)
YTD Total 4,857,035$ 3,360,851$ 4,261,042$ (595,993)$ -12%900,191$ 27%
Annual Total 7,211,736$ 4,420,000$
*Total REET (GF & CIP)
Month
018 vs. Budget018 vs. 17
Real Estate Excise Tax (REET) Revenues*
Year to Date through August
Monthly Financial Report August 2018
Page | 5
Preliminary as of 09/25/2018
Admission Tax
Current Month Actual: $63K
YTD Actual: $178K
Budgeted YTD: $249K
Prior Year Same Month: $2K
Prior Year YTD: $177K
Year-to-Year YTD Variance: $1K, 0.5%
Actual-to-Budget YTD Variance: $(-72K), -29%
Narrative: Admission Tax returns are due quarterly in
January, April, July, and October of each year. January
2018 collections represent activities conducted during
the 4th quarter of 2017. 2nd Quarter admissions
received in August amounted to $63K
Business & Occupation Tax
Current Month Actual: $451K
YTD Actual: $9.5M
Budgeted YTD: $5.5M
Prior Year Same Month: $399K
Prior Year YTD: $7.7M
Year-to-Year Monthly Variance: $52K, 13%
Year-to-Year YTD Variance: $1.7M, 22%
Actual-to-Budget Monthly Variance: $260K, 136%
Actual-to-Budget YTD Variance: $3.9M, 71%
Narrative: Businesses with gross receipts of $500K or
more per year, earned within the City of Renton, are
now required to file and pay Business and Occupation
(B&O) tax, in lieu of the Business License registration
fee. A large taxpayer hit the maximum threshold and
had a significant payment in April. As a result, this
should flatten out in future months.
Licenses and Permits
Business Licenses
Current Month Actual: $16K
YTD Actual: $957K
Budgeted YTD: $1.0M
Prior Year Same Month: $125K
Prior Year YTD: $1.1M
Year-to-Year Monthly Variance: $(-109K), -87%
Year-to-Year YTD Variance: $(-146K), -13%
Actual-to-Budget Monthly Variance: $(-80K), -84%
Actual-to-Budget YTD Variance: $(-60K), -6%
Narrative: The variance with the budget and prior
year is due to two things: 1) the City adopting Ordinance 5866 which changed the reporting period from quarterly to annually with a due
date of January, and 2) removing the per employee tax. The reduction in revenue collected from the per employee tax is offset by the
increase in B&O (above). The City projects a decrease in overall Business Licenses.
17 018 018
Actual Budget Actual $%$%
Jan 60,741$ 90,356$ 56,598$ (4,143)$ -7%(33,759)$ -37%
Feb 2,788 2,733 1,473 (1,315) -47%(1,260) -46%
Mar - - 112 112 100%112 100%
Apr 58,566 80,156 54,560 (4,006) -7%(25,597) -32%
May 1,279 842 1,911 633 50%1,069 127%
Jun 785 517 - (785) -100%(517) -100%
Jul 51,061 73,680 - (51,061) -100%(73,680) -100%
Aug 1,578 1,040 62,959 61,381 3890%61,919 5955%
Sep - 341 - -
Oct 1,705 39,955 -
Nov - 956 - -
Dec 44,655 29,423 -
YTD Total 176,798$ 249,325$ 177,613$ 815$ 0.5%(71,712)$ -29%
Annual Total 223,157$ 320,000$
018 vs. Budget
Admission Tax Revenue
Year to Date through August
Month
018 vs. 17
17 018 018
Actual Budget Actual $%$%
Jan 432,319$ 1,527,200$ 1,301,574$ 869,256$ 201%(225,626)$ -15%
Feb 794,093 190,900 1,013,630 219,536 28%822,730 431%
Mar 13,228 190,900 48,278 35,050 265%(142,622) -75%
Apr 4,626,880 1,527,200 5,430,049 803,168 17%3,902,849 256%
May 316,791 190,900 212,741 (104,050) -33%21,841 11%
Jun 23,491 190,900 172,687 149,196 635%(18,213) -10%
Jul 1,139,041 1,527,200 840,839 (298,202) -26%(686,361) -45%
Aug 399,375 190,900 451,217 51,841 13%260,317 136%
Sep 169,792 190,900 -
Oct 981,417 1,527,200 -
Nov 320,706 190,900 -
Dec 415,901 190,900 -
YTD Total 7,745,219$ 5,536,100$ 9,471,014$ 1,725,796$ 22%3,934,914$ 71%
Annual Total 9,633,034$ 7,636,000$
*Total Business & Occupation Taxes (GF & CIP)
Business & Occupation Taxes*
Year to Date through August
Month
018 vs. 17 018 vs. Budget
17 018 018
Actual Budget Actual $%$%
Jan 229,270$ 277,687 574,453$ 345,183$ 151%296,767$ 107%
Feb 157,504 157,567 208,947 51,443 33%51,379 33%
Mar 53,131 33,461 41,777 (11,354) -21%8,316 25%
Apr 157,983 145,552 34,897 (123,086) -78%(110,655) -76%
May 126,086 97,341 33,623 (92,463) -73%(63,718) -65%
Jun 36,375 27,014 30,721 (5,653) -16%3,708 14%
Jul 217,718 181,851 16,354 (201,364) -92%(165,497) -91%
Aug 124,833 95,699 15,778 (109,054) -87%(79,921) -84%
Sep 57,640 34,647 -
Oct 187,368 160,619 -
Nov 88,975 73,242 -
Dec 43,847 27,214 -
YTD Total 1,102,900$ 1,016,172$ 956,551$ (146,349)$ -13%(59,621)$ -6%
Annual Total 1,480,730$ 1,311,894$
*Total Business License (GF & CIP)
Business Licenses*
Month
018 vs. 17
Year to Date through August
018 vs. Budget
Monthly Financial Report August 2018
Page | 6
Preliminary as of 09/25/2018
Building Permits and Development Service Fees
Current Month Actual: $411K
YTD Actual: $3.3M
Budgeted YTD: $3.7M
Prior Year Same Month: $433K
Prior Year YTD: $3.3M
Year-to-Year Monthly Variance: $(-22K), -5%
Year-to-Year YTD Variance: $(-29K), -1%
Actual-to-Budget Monthly Variance: $(-33K), -7%
Actual-to-Budget YTD Variance: $(-447K), -12%
Narrative: The large budget variance in January is
due to large payments for building permits and plan
review (Southport Developer and Group Health)
receipted in January 2016 (monthly budgets is
based on 2016/2017 activity, which accounts for
almost half of the year-to-date variance. In addition to this, building permits have been trending behind for May and June accounting for
about $260K of the variance.
Intergovernmental
These revenue sources include federal
(direct and indirect) grants, state grants,
state shared revenues, local grants, and
entitlements. State shared revenues 94% of
the total revenues in this category. The
year-to-date total Intergovernmental
revenue is $4.8M or 63% of the budget.
State Shared Revenues
YTD Total: $4.1
Year-to-Year YTD Variance: $221K, 6%
Actual-to-Budget YTD Variance: $318K, 8%
Narrative: The higher than expected
collection is due to collecting more
than anticipated Criminal Justice’s
Sales Tax and marijuana
enforcement. This large increase
was the result of a “catch-up”
payment from the state in March. In
the future, the cities shared revenue
distribution will be approximately
double the normal bi-monthly
distribution (through June 2019).
17 018 018
Actual Budget Actual $%$%
Jan 399,548$ 567,204$ 314,626$ (84,921)$ -21%(252,577)$ -45%
Feb 277,296 369,165 280,745 3,449 1%(88,420) -24%
Mar 503,290 581,137 588,527 85,237 17%7,389 1%
Apr 265,749 321,507 403,892 138,143 52%82,385 26%
May 558,773 499,771 436,943 (121,831) -22%(62,829) -13%
Jun 611,441 560,415 363,521 (247,920) -41%(196,894) -35%
Jul 264,515 388,411 484,920 220,405 83%96,510 25%
Aug 433,043 444,085 411,236 (21,807) -5%(32,849) -7%
Sep 445,562 441,521
Oct 338,298 436,655
Nov 479,017 414,816
Dec 331,450 427,013
YTD Total 3,313,654$ 3,731,695$ 3,284,409$ (29,245)$ -1%(447,286)$ -12%
Annual Total 4,907,983$ 5,451,699$
Building Permits and Development Service Fees
Year to Date through August
018 vs. Budget018 vs. 17
Month
Intergovernmental 17 018 Bgt YTD Act Change 018 /17 018 Act vs Bgt
Fire District #25 -$ -$ -$ -$ N/A $ - N/A
Fire District #40 341,939 357,660 357,660 15,721 5%- 0%
State Shared Revenue 3,903,242 3,805,796 4,123,843 220,601 6%318,047 8%
Federal Grants 81,719 226,186 106,473 24,754 30%(119,713) -53%
State Grants 30,032 59,851 22,679 (7,353) -24%(37,172) -62%
Other Grants/Intgovt 218,127 147,052 140,493 (77,633) -36%(6,558) -4%
ARRA Grants - - - - N/A - N/A
Total Rev YTD 4,575,058$ 4,596,544$ 4,751,148$ 176,090$ 4%154,604$ 3%
Total Rev Annual 7,436,309$ 7,588,646$
YTD %62%61%63%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
17 018 018
Actual Budget Actual $%$%
Crim Just Sales Tax 1,824,013$ 1,813,187$ 2,002,996$ 178,984$ 10%189,810$ 10%
Judicial Contribution 5,570 - 11,025 5,455 98%11,025 100%
Crim Just - High Crime 204,154 195,347 210,584 6,429 3%15,237 8%
Crim Just - Pop 21,331 18,405 22,168 837 4%3,763 20%
Crim Just - Spec Prog 77,480 68,311 80,183 2,703 3%11,873 17%
State DUI 11,541 13,158 11,387 (153) -1%(1,770) -13%
Marijuana Enforcement 23,772 - - (23,772) 0%- N/A
Liquor Profits 427,768 425,244 425,526 (2,242) -1%282 0%
Liquor Excise Tax 356,200 332,449 378,373 22,173 6%45,924 14%
Fuel Tax 951,413 939,697 981,602 30,188 3%41,905 4%
YTD Total 3,903,242$ 3,805,796$ 4,123,843$ 220,601$ 6%318,047$ 8%
Annual Total 6,145,527$ 5,942,169$
018 vs. Budget
State Shared Revenues
018 vs. 17
Revenue
Year to Date through August
Monthly Financial Report August 2018
Page | 7
Preliminary as of 09/25/2018
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 67% of the total
revenue in this category. The year-to-date total charges for services are $5.9M or 67% of the budget. The following sections provide detail
information for Public Safety, Recreation, and Interfund Services.
Public Safety Services
YTD Total: $732K
Year-to-Year YTD Variance: $164K, 29%
Actual-to-Budget YTD Variance: $331K, 83%
Narrative: The variance with the prior year is due
to collecting large reimbursements for the School
Resource Officer program.
Recreation
Current Month Actual: $314K
YTD Total: $1.3M
Budgeted YTD: $1.5M
Prior Year Same Month: $382K
Prior Year YTD Total: $1.4M
Year-to-Year Monthly Variance: $(-69K), -18%
Year-to-Year YTD Variance: $(-110K), -8%
Actual-to-Budget Monthly Variance: $(-71K), -18%
Actual-to-Budget YTD Variance: $(-149K), -10%
Narrative: The total year-to-year variance is
primarily related to aquatic center fees ($106K less
than PY YTD) and community center self-sustaining
program fees being behind prior year figures. The
budget to actual variance is primarily being driven
by aquatic center fees and community center activity fees (non-instructor).
17 018 018
Actual Budget Actual $%$%
Jan 64,424$ 57,002$ 224,932$ 160,509$ 249%167,930$ 295%
Feb 68,705 56,753 60,888 (7,817) -11%4,136 7%
Mar 148,707 69,703 82,789 (65,918) -44%13,086 19%
Apr 61,399 37,896 58,572 (2,827) -5%20,676 55%
May 63,815 37,767 77,233 13,418 21%39,467 105%
Jun 43,374 75,004 84,800 41,426 96%9,796 13%
Jul 59,850 31,948 92,695 32,845 55%60,748 190%
Aug 58,114 34,576 50,236 (7,878) -14%15,660 45%
Sep 53,908 40,957 -
Oct 52,056 71,643 -
Nov 77,748 49,060 -
Dec 85,628 55,327 -
YTD Total 568,388$ 400,648$ 732,145$ 163,757$ 29%331,498$ 83%
Annual Total 837,728$ 617,635$
Year to Date through August
Public Safety Services
018 vs. 17 018 vs. Budget
Month
17 018 018
Actual Budget Actual $%$%
Jan 152,350$ 165,916$ 138,388$ (13,962)$ -9%(27,528)$ -17%
Feb 38,452 45,377 51,694 13,243 34%6,317 14%
Mar 65,420 66,147 55,300 (10,121) -15%(10,847) -16%
Apr 74,806 98,371 70,321 (4,486) -6%(28,050) -29%
May 84,381 82,203 82,814 (1,568) -2%611 1%
Jun 153,304 206,297 191,108 37,804 25%(15,189) -7%
Jul 482,458 423,801 419,790 (62,669) -13%(4,011) -1%
Aug 382,296 384,147 313,627 (68,669) -18%(70,520) -18%
Sep 135,476 127,601 -
Oct 49,113 49,764 -
Nov 58,320 66,466 -
Dec 45,946 44,831 -
YTD Total 1,433,468$ 1,472,260$ 1,323,042$ (110,426)$ -8%(149,218)$ -10%
Annual Total 1,722,323$ 1,760,923$
Recreation
Year to Date through August
018 vs. Budget018 vs. 17
Month
Monthly Financial Report August 2018
Page | 8
Preliminary as of 09/25/2018
Interfund Services
YTD Total: $2.6M
Year-to-Year YTD Variance: $(-28K), -1%
Actual-to-Budget YTD Variance: $(-310K), -11%
Narrative: 2018’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.
Fines and Penalties
YTD Total: $2.4M
Year-to-Year YTD Variance: $473K, 25%
Actual-to-Budget YTD Variance: $(-248K), -10%
Narrative: 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 primary
driver of the negative variance is the photo
enforcement program, however, this variance is
trending in the positive direction and has been
reduced by half from July to August.
17 018 018
Actual Budget Actual $%$%
Jan 330,774$ 363,424$ 341,804$ 11,030$ 3%(21,619)$ -6%
Feb 319,851 363,424 344,339 24,488 8%(19,084) -5%
Mar 377,192 363,424 378,470 1,278 0%15,046 4%
Apr 332,180 363,424 332,894 714 0%(30,530) -8%
May 332,543 363,424 328,765 (3,778) -1%(34,659) -10%
Jun 322,435 363,424 320,735 (1,699) -1%(42,689) -12%
Jul 314,856 363,424 236,427 (78,430) -25%(126,997) -35%
Aug 295,921 363,424 313,949 18,028 6%(49,474) -14%
Sep 350,908 363,424 -
Oct 321,038 363,424 -
Nov 316,488 363,424 -
Dec 302,147 363,424 -
YTD Total 2,625,752$ 2,907,391$ 2,597,384$ (28,368)$ -1%(310,006)$ -11%
Annual Total 3,916,334$ 4,361,086$
Interfund Services
Year to Date through August
018 vs. 17 018 vs. Budget
Month
17 018 018
Actual Budget Actual $%$%
Jan 134,957$ 206,614$ 141,625$ 6,668$ 5%(64,989)$ -31%
Feb 217,056 309,853 224,814 7,759 4%(85,039) -27%
Mar 212,186 331,630 312,111 99,925 47%(19,518) -6%
Apr 242,816 340,209 137,934 (104,882) -43%(202,275) -59%
May 229,877 312,735 230,762 885 0%(81,973) -26%
Jun 302,666 401,048 235,311 (67,354) -22%(165,737) -41%
Jul 247,260 328,975 451,443 204,183 83%122,468 37%
Aug 298,685 374,734 624,200 325,516 109%249,466 67%
Sep 220,425 291,346
Oct 274,245 363,684
Nov 240,739 361,754
Dec 325,938 423,905
YTD Total 1,885,502$ 2,605,798$ 2,358,201$ 472,699$ 25%(247,597)$ -10%
Annual Total 2,946,849$ 4,046,487$
018 vs. Budget018 vs. 17
Year to Date through August
Fines and Penalties by Month
Month
Year to Date through August
17 018 018
Actual Budget Actual $%$%
Civil Penalties 1,463$ 3,234$ 1,067$ (396)$ -27%(2,167)$ -67%
Civil Infraction Penalties 196,958 190,652 239,662 42,704 22%49,011 26%
Civil Parking Infraction Penalties 106,999 142,469 120,230 13,231 12%(22,239) -16%
Photo Enforcement Program 1,393,203 2,111,161 1,800,732 407,529 29%(310,429) -15%
Criminal Traffic Misdemeanor Fines 52,529 47,865 50,283 (2,246) -4%2,418 5%
Criminal Non-Traffic Fines 56,310 39,213 56,350 41 0%17,137 44%
Criminal Costs 52,244 55,685 65,940 13,696 26%10,255 18%
Non-Court Fines, Forfeitures and Penalties 25,796 15,518 23,936 (1,860) -7%8,418 54%
YTD Total 1,885,502$ 2,605,798$ 2,358,201$ 472,699$ 25%(247,597)$ -10%
Annual Total 2,946,849$ 4,046,487$
Revenue
018 vs. Budget
Fines and Penalties by Type
018 vs. 17
Monthly Financial Report August 2018
Page | 9
Preliminary as of 09/25/2018
Included in the Fines and Penalties revenue budget is
$2.1M 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 $1.8M.
The associated costs includes the equipment provided by
American Traffic Solutions, Inc. (ATS), dedicated 1 FTE 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 50% pro tem budget
and interpreter costs amounts to $329K for personnel
costs. The total costs for the program equates to $1.5M
which is represented in the table. Due to the timing of
when the invoice was received, January 2018’s equipment
rental cost was recorded in February.
Miscellaneous
YTD Total: $1.8M
Year-to-Year YTD Variance: $245K, 16%
Actual-to-Budget YTD Variance: $634K, 53%
Narrative: 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. Though the year was
started due to a large variance in Seizure Funds
collected in 2017 and a lack there of in 2018, in May
2018 $227K in Seizure Funds were collected
resulting in a large positive variance. Seizure Funds
are restricted to drug enforcement only and are not
available for general operating purposes. The large
variance in August is being driven by an uptick in
contributions.
17 018 018
Actual Budget Actual $%$%
Jan 363,997$ 226,534$ 262,690$ (101,308)$ -28%36,156$ 16%
Feb 148,988 119,730 150,608 1,620 1%30,878 26%
Mar 150,954 115,624 178,170 27,216 18%62,546 54%
Apr 188,887 124,097 152,700 (36,186) -19%28,604 23%
May 152,678 121,318 386,715 234,037 153%265,397 219%
Jun 179,152 145,245 193,674 14,522 8%48,429 33%
Jul 193,718 171,837 221,279 27,561 14%49,442 29%
Aug 198,576 163,060 275,725 77,148 39%112,665 69%
Sep 151,310 134,049
Oct 156,212 121,675
Nov 125,698 96,289
Dec 468,107 379,164
YTD Total 1,576,951$ 1,187,445$ 1,821,561$ 244,610$ 16%634,116$ 53%
Annual Total 2,478,278$ 1,918,622$
Year to Date through August
Month
018 vs. Budget018 vs. 17
Miscellaneous Revenues by Month
17 018 018
Actual Budget Actual $%$%
Interests and Other Earnings 565,841$ 410,975$ 724,746$ 158,905$ 28%313,771$ 76%
Rents, Leases, and Concessions 504,182 492,623 527,728 23,546 5%35,105 7%
Contributions/Donations from Private Sources 104,075 102,261 148,340 44,265 43%46,079 45%
Other 242,879 181,586 174,859 (68,020) -28%(6,727) -4%
Seizure Funds - Federal/State/Local 159,974 - 245,888 85,914 54%245,888 100%
YTD Total 1,576,951$ 1,187,445$ 1,821,561$ 244,610$ 16%634,116$ 53%
Annual Total 2,478,278$ 1,918,622$
018 vs. Budget
Miscellaneous Revenues by Type
Year to Date through August
Revenue
018 vs. 17
Favorable
8 Budget 8 Actual 8 Budget 8 Actual (Unfavorable)1
Jan 204,207$ 136,853$ 124,941$ 27,432$ 109,421$
Feb 250,698 154,588 124,941 95,186 59,402
Mar 261,123 179,033 124,941 95,195 83,838
Apr 259,635 122,862 124,941 95,195 27,667
May 250,855 171,477 124,941 95,189 76,288
Jun 326,983 155,145 124,941 95,186 59,959
Jul 258,813 385,533 124,941 27,432 358,101
Aug 298,847 495,241 124,941 117,185 378,056
Sep 218,520 - 124,941 - -
Oct 299,333 - 124,941 - -
Nov 291,494 - 124,941 - -
Dec 295,896 - 124,941 - -
YTD Total 2,111,161$ 1,800,732$ 999,531$ 648,001$ 1,152,731$
Annual Total 3,216,405$ 1,499,297$
1Actuals of Revenues and Expenses
ExpensesRevenues
Photo Enforcement Program
Year to Date through August
Month
Monthly Financial Report August 2018
Page | 10
Preliminary as of 09/25/2018
EXPENSES
Overall, the City has expended 58.4% of its budgeted general governmental expenditures at the end of August. This is $3.2M or 5.0%
below year-to-date budgeted expenditures. See below for summary of unfavorable items for general governmental departments.
Court Services department is over the year-to-date budget by $16K or 1.1%. This is due to over spending on contracted services ($13K),
other attorney fees ($6K), witness fees ($4K), and security ($10K). We will monitor this to determine if a budget adjustment is needed at
year-end.
Museum is over the year-to-date budget by $5K or 2.9%. This is due to over spending on intermittent salaries and wages of $3K and
associated intermittent benefits of $1K.
Transportation, Executive department, Community and Economic Development, Community Services Admin and Human Services are all
reflecting a negative variance on their respective expenditures; however, after taking a deeper dive into the specific costs associated with
these variances, these are primarily related to timing differences that are skewing the variance calculation.
Monthly Financial Report August 2018
Page | 11
Preliminary as of 09/25/2018
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 funds are the capital revenues and expenditures.
Airport Golf Course Solid Waste
Utility Water Utility Wastewater
Utility
Surface
Water Utility Metro
REVENUES:
Licenses and permits - - - - 60,300 42,150 -
Grants / intergovernmental 52,887 5,259 83,779 - - 928,992 -
Charges for services 174,319 1,407,246 11,136,204 11,558,112 7,150,841 7,952,792 11,171,588
Interdepartmental services - - - - - - -
Fines and penalties 316 - - - 270 - -
Rents, leases, and misc fees 2,135,657 304,148 7,675 136,842 - - -
Interest and other misc 30,811 3,006 21,095 1,154,356 1,075,528 372,161 40,689
TOTAL REVENUES 2,393,990 1,719,659 11,248,753 12,849,310 8,286,939 9,296,095 11,212,277
EXPENSES:
Utility billing - - 27,708 109,019 88,785 136,069 -
Utility systems - - 12,409,700 2,777,621 2,389,520 2,468,174 -
Utility maintenance - - 239,843 3,871,813 1,486,136 2,047,219 10,970,636
Transportation 1,235,380 - - - - - -
Golf - 1,413,312 - - - - -
TOTAL EXPENSES 1,235,380 1,413,312 12,677,251 6,758,453 3,964,441 4,651,462 10,970,636
AMOUNT AVAILABLE FOR DEBT
SERVICE 1,158,610 306,347 (1,428,498) 6,090,857 4,322,498 4,644,633 241,641
DEBT SERVICE:
Principal - - - 345,818 - - -
Interest - - - 118,819 50,707 405,178 -
TOTAL DEBT SERVICE - - - 464,637 50,707 405,178 -
CAPITAL PROJECTS 22,122 - - 1,784,437 1,813,743 1,871,523 -
TRANSFERS IN/(OUT)- - - (846) - (993) -
CHANGE IN FUND BALANCE 1,136,488 306,347 (1,428,498) 3,840,937 2,458,048 2,366,939 241,641
BEGINNING FUND BALANCE, Jan 1 3,459,189 5,267 3,000,312 33,913,567 17,410,002 13,934,705 5,089,769
ENDING FUND BALANCE, Aug 31 4,595,677 311,614 1,571,814 37,754,504 19,868,050 16,301,644 5,331,410
Monthly Financial Report August 2018
Page | 12
Preliminary as of 09/25/2018
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 - 181,077 - - - - -
Grants / intergovernmental - - - - - - 45,754
Charges for services
Equipment rental m&o 1,808,694 2,888,598 - - - - -
Print and mail - - - 296,342 - - -
Communications - 409,756 - 444,197 - - -
Facilities - - 3,228,705 - - - -
Data cards and cell phones - - - - - - -
IT service contracts - - - - - - -
Interest and other misc 51,267 26,897 11,742 4,748 132,743 35,372 93,587
Internal service fund misc:
Vehicle / equipment capital recovery 1,388,165 140,533 - - - - -
Insurance premiums - - - - 1,153,116 - -
Worker's comp/unemployment - - - - 945,986 - -
Benefit premiums - - - - - 6,242,138 1,749,788
Other misc 252 10 1 - - 629,425 -
Interfund Loan - - - - - - -
Capital contributions - - - - - - -
Disposal of capital assets 33,568 - - - - - -
Insurance recoveries - - - - 265,557 - -
TOTAL REVENUES 3,281,946 3,646,871 3,240,447 745,287 2,497,402 6,906,935 1,889,129
EXPENSES:
Communications 415,871
Equipment rental 1,681,450
Facilities 3,268,980
Healthcare 6,934,508
Information technology 3,380,843
Print and mail 279,701
Retiree healthcare 502,874
Risk management:
Risk management 1,545,245
Unemployment 45,887
Worker's compensation 774,230
TOTAL EXPENSES 1,681,450 3,380,843 3,268,980 695,572 2,365,362 6,934,508 502,874
AMOUNT AVAILABLE FOR CAPITAL 1,600,496 266,028 (28,533) 49,715 132,040 (27,573) 1,386,255
CAPITAL PROJECTS 1,943,040 345,154 48,451 - - - -
TRANSFERS IN - 30,123 2,456 - - - -
TRANSFERS (OUT)(3,190) - - - - - -
CHANGE IN FUND BALANCE (345,734) (49,003) (74,528) 49,715 132,040 (27,573) 1,386,255
BEGINNING FUND BALANCE, Jan 1 6,882,620 3,737,060 1,530,747 608,145 17,731,130 4,617,488 11,887,344
ENDING FUND BALANCE, Aug 31 6,536,886 3,688,057 1,456,220 657,860 17,863,170 4,589,915 13,273,599
Monthly Financial Report August 2018
Page | 13
Preliminary as of 09/25/2018
FUND BALANCE
Page 14 shows the ending fund balance as of August 2018. 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 August, the City has $45.3M reported in the combined general governmental fund balance of the current year’s operating
budget, which is approximately 44.4% of budgeted operating expenditures. This is an increase of $12.0M from the year’s beginning
balance. August’s ending fund balance is over the anticipated General Governmental Fund Balance of $35.4M by $9.8M or 27.7%.
Although the ending fund balance is above projections, it is consistent with the prior years’ trends. At this time last year, the fund balance
was 24.3% above the projected year-to-date budget, however, the overage in fund balance for the month of August compared to this time
last year is very similar ($9.8M for 2018 vs $7.7M for 2017).
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
mgordon@rentonwa.gov or JDThomas@Rentonwa.gov.
Monthly Financial Report August 2018
Page | 14
Preliminary as of 09/25/2018
City of Renton
All Funds - Revenue, Expenditures and Fund Balances
Cash Basis through August 31, 2018
Funds
Balance
01/01/018
Budgeted
Revenue
Revenue
08/31/18
Total Funds
Available
Budgeted
Expenditure
Expenditure
08/31/18 Ending Balance
GENERAL GOVERNMENT FUNDS:33,284,838 101,078,356 71,469,278 104,754,116 101,896,981 59,500,307 45,253,809
000 General 22,708,066 69,377,185 53,168,873 75,876,939 69,540,779 42,197,860 33,679,079
001 Community Services 4,840,993 13,614,554 8,264,861 13,105,854 13,708,109 8,398,926 4,706,928
003 Street 3,143,904 11,288,240 6,856,121 10,000,025 11,693,231 7,250,884 2,749,141
004 Community Dev Block Grant 54,286 873,366 50,069 104,355 913,367 146,597 (42,242)
005 Museum 70,992 239,129 119,953 190,945 241,246 163,495 27,450
009 Farmers Market 105,323 89,663 47,640 152,963 97,005 65,451 87,512
201 Ltd GO Bonds Gen Govt Debt 863,732 - 6,446 870,178 - 127 870,052
215 Gen Govt Misc Debt Service 1,497,542 5,596,219 2,955,314 4,452,856 5,703,244 1,276,967 3,175,889
SPECIAL REVENUE FUNDS:2,093,053 1,950,224 1,606,695 3,699,748 2,114,392 782,155 2,917,593
102 Arterial Street 108,438 670,000 464,289 572,727 670,000 - 572,727
108 Leased City Properties 611,055 967,550 736,545 1,347,600 983,406 596,015 751,585
110 Hotel Motel 461,434 200,000 318,366 779,800 309,629 157,349 622,451
125 1% For Art 103,109 15,000 772 103,881 53,683 - 103,881
127 Cable Communication 472,489 97,674 84,204 556,693 97,674 28,791 527,902
135 Springbrook Wetlands Bank 336,528 - 2,519 339,047 - - 339,047
CAPITAL PROJECT FUNDS (CIP):36,295,483 24,993,230 13,518,200 49,813,683 46,832,686 7,975,811 41,837,872
303 Community Services Mitigation 1,909,355 86,500 319,277 2,228,632 - - 2,228,632
304 Fire Mitigation 936,972 99,000 495,590 1,432,562 142,975 - 1,432,562
305 Transportation Mitigation 810,962 632,400 2,428,593 3,239,555 505,000 - 3,239,555
316 Municipal Facilities CIP 19,671,696 7,320,407 7,022,550 26,694,246 24,331,580 4,237,182 22,457,064
317 Transportation CIP 5,808,539 16,854,923 2,967,108 8,775,647 21,522,131 3,592,150 5,183,497
326 Housing Opportunity 2,548,975 - 19,123 2,568,098 - - 2,568,098
336 New Library Development 451,093 - 3,325 454,418 - 12 454,406
346 New Family First Center Dvlpmnt 4,157,891 - 262,634 4,420,525 331,000 146,467 4,274,058
ENTERPRISE FUNDS:76,812,811 86,313,733 57,053,693 133,866,504 133,581,645 48,131,788 85,734,716
4X2 Airport Operating & CIP 3,459,189 3,637,862 2,393,990 5,853,179 6,209,762 1,257,502 4,595,677
403 Solid Waste Utility 3,000,312 19,505,718 11,248,754 14,249,066 19,368,508 12,677,251 1,571,815
4X4 Golf Operating & CIP 5,267 2,287,213 1,766,326 1,771,593 2,287,585 1,459,980 311,613
4X5 Water Operating & CIP 33,913,567 17,420,439 12,849,311 46,762,878 42,826,090 9,008,373 37,754,505
4X6 Waste Water Operating & CIP 17,410,002 10,103,577 8,286,939 25,696,941 21,691,422 5,828,891 19,868,050
416 King County Metro 5,089,769 17,505,693 11,212,277 16,302,046 17,505,693 10,970,636 5,331,410
4X7 Surface Water Operating & CIP 13,934,705 15,853,231 9,296,096 23,230,801 23,692,585 6,929,155 16,301,646
INTERNAL SERVICE FUNDS:46,994,534 30,843,875 22,240,595 69,235,129 34,910,223 21,169,424 48,065,705
501 Equipment Repair/Replacement 6,882,620 6,306,622 3,281,947 10,164,567 8,064,462 3,627,680 6,536,887
502 Insurance 17,731,130 3,307,514 2,497,402 20,228,532 3,315,116 2,365,362 17,863,170
503 Information Services 3,737,060 5,673,080 3,676,993 7,414,053 7,386,392 3,725,997 3,688,056
504 Facilities 1,530,747 5,004,802 3,242,903 4,773,650 5,365,113 3,317,431 1,456,219
505 Communications 608,145 1,102,300 745,287 1,353,432 1,106,329 695,572 657,860
512 Insurance, Healthcare 4,617,488 8,191,708 6,906,934 11,524,422 8,578,084 6,934,508 4,589,914
522 Insurance, Leoff1 Retirees HC 11,887,344 1,257,849 1,889,129 13,776,473 1,094,727 502,874 13,273,599
FIDUCIARY FUNDS:5,832,897 468,000 183,125 6,016,022 200,475 129,801 5,886,221
611 Firemen's Pension 5,832,897 468,000 183,125 6,016,022 200,475 129,801 5,886,221
TOTAL FUNDS 201,313,616 245,647,418 166,071,586 367,385,202 319,536,402 137,689,286 229,695,916
City of Renton
General Government Financial Position
2018 Budget Year
General Government Summary General Government Summary - Budgeted
Revenues Expenditures
$ Difference
over (under)
w/beginning
balance
33,284,838
January 8,189,596 6,868,916 1,320,680 34,605,518
February 16,348,402 14,082,847 2,265,555 35,550,393
March 23,642,627 21,729,189 1,913,438 35,198,276
April 41,909,125 28,695,484 13,213,641 46,498,479
May 51,384,537 36,202,262 15,182,276 48,467,114
June 57,592,687 43,674,562 13,918,125 47,202,963
July 64,087,891 51,789,364 12,298,527 45,583,365
August 71,469,278 59,500,307 11,968,971 45,253,809
September
October
November
December
(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
8,000,000
9,000,000
10,000,000
11,000,000
12,000,000
13,000,000
14,000,000
15,000,000
16,000,000
17,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
City of Renton
Monthly Revenue Analysis - 2018 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,927,790 8,189,596 3.30%
Feb 14,511,384 16,348,402 12.66%
Mar 21,056,246 23,642,627 12.28%
Apr 33,162,580 41,909,125 26.37%
May 43,859,696 51,384,537 17.16%
Jun 50,133,091 57,592,687 14.88%
Jul 58,026,170 64,087,891 10.45%
Aug 64,816,461 71,469,278 10.26%
Sep 71,251,325
Oct 82,277,825
Nov 93,708,548
Dec 101,078,355
Percent of budget 70.71%
Property Tax Budget
YTD
Actual
Annual %
over (under)
Jan 31,649 (12,745) -140.27%
Feb 192,923 93,620 -51.47%
Mar 880,619 759,091 -13.80%
Apr 5,585,498 7,667,724 37.28%
May 10,133,810 10,087,649 -0.46%
Jun 10,218,049 10,196,490 -0.21%
Jul 10,258,103 10,286,562 0.28%
Aug 10,366,119 10,370,747 0.04%
Sep 10,682,507
Oct 13,934,125
Nov 19,305,972
Dec 19,397,308
Percent of budget 53.46%
$-
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
$120
$130
Millions
Total Revenue
General Government
Budget
Actual
Last Year
$(3)
$-
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
$36
$39
Millions Property Tax
Budget
Actual
Last Year
City of Renton
Monthly Revenue Analysis - 2018 Budget Year
Sales Tax Budget
YTD
Actual
Annual %
over (under)
Jan 2,260,736 2,481,092 9.75%
Feb 4,948,626 5,657,031 14.32%
Mar 7,092,465 8,004,696 12.86%
Apr 9,200,855 10,252,667 11.43%
May 11,717,901 13,054,786 11.41%
Jun 13,938,141 15,289,603 9.70%
Jul 16,253,766 17,675,268 8.75%
Aug 18,828,019 20,249,131 7.55%
Sep 21,239,052
Oct 23,758,560
Nov 26,381,491
Dec 28,803,740
Percent of budget 70.30%
Note: Excludes CJ Sales Tax and Natural Gas Use Tax.
Utility Tax Budget
YTD
Actual
Annual %
over (under)
Jan 1,472,870 1,395,386 -5.26%
Feb 2,886,038 3,013,358 4.41%
Mar 4,135,571 4,592,549 11.05%
Apr 5,628,573 6,055,885 7.59%
May 6,970,433 7,470,841 7.18%
Jun 8,143,555 8,740,443 7.33%
Jul 9,485,903 10,139,403 6.89%
Aug 10,640,985
Sep 11,865,442
Oct 13,187,689
Nov 14,330,720
Dec 15,664,124
Percent of budget 72.41%
Note: Includes Natural Gas Use Tax.
$-
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
Millions Sales Tax
Budget
Actual
Last Year
$-
$2
$4
$6
$8
$10
$12
$14
$16
Millions Utility Tax
Budget
Actual
Last Year
City of Renton
Monthly Revenue Analysis - 2018 Budget Year
Licenses &
Permits Budget
YTD
Actual
Annual %
over (under)
Jan 557,333 528,042 -5.26%
Feb 905,781 862,852 -4.74%
Mar 1,389,734 1,387,152 -0.19%
Apr 1,687,685 1,713,974 1.56%
May 2,112,005 2,043,697 -3.23%
Jun 2,486,234 2,300,379 -7.48%
Jul 2,878,222 2,707,591 -5.93%
Aug 3,285,243 3,043,817 -7.35%
Sep 3,652,920
Oct 4,043,793
Nov 4,367,374
Dec 4,636,213
Percent of budget 65.65%
Note: GF only
Intergovt'l Budget
YTD
Actual
Annual %
over (under)
Jan 596,547 601,356 0.81%
Feb 1,229,636 1,241,708 0.98%
Mar 1,807,433 1,932,260 6.91%
Apr 2,354,778 2,510,510 6.61%
May 2,771,429 2,960,813 6.83%
Jun 3,384,888 3,643,008 7.63%
Jul 3,938,155 4,242,922 7.74%
Aug 4,596,620 4,912,215 6.87%
Sep 5,203,230
Oct 5,795,911
Nov 6,304,743
Dec 7,588,646
Percent of budget 64.73%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
$-
$1
$2
$3
$4
$5
$6
$7
$8
Millions
Intergovernmental
Budget
Actual
Last Year
$-
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
Millions Licenses & Permits
Budget
Actual
Last Year
City of Renton
Monthly Revenue Analysis - 2018 Budget Year
Charges for
Services Budget
YTD
Actual
Annual %
over (under)
Jan 736,564 851,592 15.62%
Feb 1,322,090 1,451,288 9.77%
Mar 1,971,621 2,138,586 8.47%
Apr 2,606,664 2,756,537 5.75%
May 3,288,813 3,419,632 3.98%
Jun 4,176,312 4,174,120 -0.05%
Jul 5,129,315 5,053,517 -1.48%
Aug 6,081,978 5,871,176 -3.47%
Sep 6,744,386
Oct 7,386,036
Nov 8,043,187
Dec 8,785,388
Percent of budget 66.83%
Note: Excludes FD25 & FD40 contracts
Fines &
Forfeits Budget
YTD
Actual
Annual %
over (under)
Jan 206,614 141,625 -31.45%
Feb 516,467 366,439 -29.05%
Mar 848,097 678,550 -19.99%
Apr 1,188,305 816,484 -31.29%
May 1,501,041 1,047,246 -30.23%
Jun 1,902,089 1,282,558 -32.57%
Jul 2,231,064 1,734,001 -22.28%
Aug 2,605,798 2,358,201 -9.50%
Sep 2,897,143
Oct 3,260,828
Nov 3,622,582
Dec 4,046,487
Percent of budget 58.28%
$-
$1
$2
$3
$4
$5
$6
$7
$8
$9
Millions Charges for Services
Budget
Actual
Last Year
$-
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
Millions Fines & Forfeits
Budget
Actual
Last Year
City of Renton
Monthly Revenue Analysis - 2018 Budget Year
Other Taxes Budget
YTD
Actual
Annual %
over (under)
Jan 1,826,266 1,940,559 6.26%
Feb 2,150,560 3,235,809 50.46%
Mar 2,455,818 3,545,274 44.36%
Apr 4,311,237 9,378,175 117.53%
May 4,643,962 10,155,990 118.69%
Jun 5,018,275 10,628,530 111.80%
Jul 6,814,257 10,689,792 56.87%
Aug 7,211,253 11,486,859 59.29%
Sep 7,531,044
Oct 9,340,928
Nov 9,673,557
Dec 10,085,686
Percent of budget 113.89%
Misc Budget
YTD
Actual
Annual %
over (under)
Jan 226,534 262,690 15.96%
Feb 346,264 413,298 19.36%
Mar 461,888 591,468 28.05%
Apr 585,985 744,168 26.99%
May 707,303 1,130,883 59.89%
Jun 852,548 1,324,557 55.36%
Jul 1,024,385 1,545,836 50.90%
Aug 1,187,445 1,821,561 53.40%
Sep 1,321,494
Oct 1,443,169
Nov 1,539,458
Dec 1,918,622
Percent of budget 94.94%
$-
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
Millions Miscellaneous
Budget
Actual
Last Year
$-
$1
$2
$3
$4
$5
$6
$7
$8
$9
$10
$11
$12
$13
$14
Millions Other Taxes
Budget
Actual
Last Year
City of Renton
Monthly Revenue Analysis - 2018 Budget Year
Other
Financing Budget
YTD
Actual
Annual %
over (under)
Jan 12,679 - 0.00%
Feb 13,000 13,000 0.00%
Mar 13,000 13,000 0.00%
Apr 13,000 13,000 0.00%
May 13,000 13,000 0.00%
Jun 13,000 13,000 0.00%
Jul 13,000 13,000 0.00%
Aug 13,000 13,000 0.00%
Sep 114,107
Oct 126,785
Nov 139,464
Dec 152,142
Percent of budget 8.54%
REET Budget
YTD
Actual
Annual %
over (under)
Jan 786,056 840,316 6.90%
Feb 996,074 1,206,327 21.11%
Mar 1,388,016 1,497,372 7.88%
Apr 1,654,828 1,903,118 15.00%
May 1,955,479 2,510,550 28.39%
Jun 2,413,482 3,007,467 24.61%
Jul 2,853,657 3,854,099 35.06%
Aug 3,360,851 4,261,042 26.78%
Sep 3,792,293
Oct 4,100,637
Nov 4,499,171
Dec 4,420,000
Percent of budget 96.40%
$-
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
$5.50
$6.00
$6.50
$7.00
$7.50
$8.00
Millions
Real Estate Excise Tax
Budget
Actual
Last Year
$0
$0
$0
$0
$0
$0
$0
MillionsOther Financing Sources
Budget
Actual
Last Year
City of Renton
Monthly Revenue Analysis - 2018 Budget Year
Bldg Permits
& Devlpmt Svc
Fees Budget
YTD
Actual
Annual %
over (under)
Jan 567,204 314,626 -44.53%
Feb 936,369 595,371 -36.42%
Mar 1,517,506 1,183,898 -21.98%
Apr 1,839,013 1,587,790 -13.66%
May 2,338,784 2,024,732 -13.43%
Jun 2,899,199 2,388,253 -17.62%
Jul 3,287,609 2,873,173 -12.61%
Aug 3,731,695 3,284,409 -11.99%
Sep 4,173,216
Oct 4,609,871
Nov 5,024,686
Dec 5,451,699
Percent of budget 60.25%
B & O Tax Budget
YTD
Actual
Annual %
over (under)
Jan 1,527,200 1,301,574 -14.77%
Feb 1,718,100 2,315,204 34.75%
Mar 1,909,000 2,363,482 23.81%
Apr 3,436,200 7,793,531 126.81%
May 3,627,100 8,006,272 120.73%
Jun 3,818,000 8,178,959 114.22%
Jul 5,345,200 9,019,798 68.75%
Aug 5,536,100 9,471,014 71.08%
Sep 5,727,000
Oct 7,254,200
Nov 7,445,100
Dec 7,636,000
Percent of budget 124.03%
$-
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
Millions Building Permits and Development Service
Fees
Budget
Actual
Last Year
$-
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
$5.50
$6.00
$6.50
$7.00
$7.50
$8.00
$8.50
$9.00
$9.50
$10.00
$10.50
Millions Business & Occupation Tax
Budget
Actual
Last Year
City of Renton
Monthly Expenditure Analysis - 2018 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,326,351 6,868,916 -6.24%
Feb 14,797,553 14,082,847 -4.83%
Mar 22,457,491 21,729,189 -3.24%
Apr 29,820,619 28,695,484 -3.77%
May 37,758,388 36,202,262 -4.12%
Jun 45,713,739 43,674,562 -4.46%
Jul 54,336,822 51,789,364 -4.69%
Aug 62,661,133 59,500,307 -5.04%
Sep 75,062,414
Oct 83,633,547
Nov 91,792,833
Dec 101,896,981
Percent of budget expended 58.39%
Legislative Budget
YTD
Actual
Annual %
over (under)
Jan 36,796 38,187 3.78%
Feb 67,098 68,247 1.71%
Mar 102,377 98,763 -3.53%
Apr 133,436 131,800 -1.23%
May 163,576 162,362 -0.74%
Jun 194,460 191,630 -1.46%
Jul 224,009 221,457 -1.14%
Aug 253,784 251,165 -1.03%
Sep 283,711
Oct 313,912
Nov 343,921
Dec 374,666
Percent of budget expended 67.04%
$-
$20
$40
$60
$80
$100
$120
Millions
Total Expenditures
General Government
Budget
Actual
Last Year
$-
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
$400,000
Legislative
Budget
Actual
Last Year
City of Renton
Monthly Expenditure Analysis - 2018 Budget Year
Executive Budget
YTD
Actual
Annual %
over (under)
Jan 221,352 216,805 -2.05%
Feb 368,780 370,213 0.39%
Mar 535,836 545,152 1.74%
Apr 684,707 699,202 2.12%
May 843,698 846,929 0.38%
Jun 1,016,843 1,019,144 0.23%
Jul 1,167,925 1,173,506 0.48%
Aug 1,346,961 1,355,859 0.66%
Sep 1,513,208
Oct 1,677,989
Nov 1,826,370
Dec 2,046,962
Percent of budget expended 66.24%
Emergency
Management Budget
YTD
Actual
Annual %
over (under)
Jan 40,141 46,027 14.66%
Feb 84,100 92,381 9.85%
Mar 139,488 143,430 2.83%
Apr 192,211 189,109 -1.61%
May 241,243 241,268 0.01%
Jun 291,079 290,880 -0.07%
Jul 341,927 343,115 0.35%
Aug 420,323 397,472 -5.44%
Sep 475,750
Oct 528,258
Nov 579,455
Dec 628,191
Percent of budget expended 63.27%
$-
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
$2.40
Millions Executive
Budget
Actual
Last Year
$-
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
Emergency Management
Budget
Actual
Last Year
City of Renton
Monthly Expenditure Analysis - 2018 Budget Year
City Attorney Budget
YTD
Actual
Annual %
over (under)
Jan 181,299 177,424 -2.14%
Feb 367,733 359,168 -2.33%
Mar 560,714 542,881 -3.18%
Apr 760,231 728,768 -4.14%
May 948,912 912,104 -3.88%
Jun 1,137,476 1,097,367 -3.53%
Jul 1,327,735 1,281,888 -3.45%
Aug 1,518,134 1,467,657 -3.32%
Sep 1,710,502
Oct 1,899,635
Nov 2,087,929
Dec 2,267,734
Percent of budget expended 64.72%
Court Services Budget
YTD
Actual
Annual %
over (under)
Jan 176,384 182,051 3.21%
Feb 359,319 371,810 3.48%
Mar 546,315 561,465 2.77%
Apr 734,460 749,786 2.09%
May 920,481 936,015 1.69%
Jun 1,108,912 1,124,445 1.40%
Jul 1,293,945 1,308,186 1.10%
Aug 1,479,202 1,495,645 1.11%
Sep 1,674,344
Oct 1,861,659
Nov 2,050,602
Dec 2,250,644
Percent of budget expended 66.45%
$-
$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.40
$0.80
$1.20
$1.60
$2.00
$2.40
Millions City Attorney
Budget
Actual
Last Year
City of Renton
Monthly Expenditure Analysis - 2018 Budget Year
CED Admin Budget
YTD
Actual
Annual %
over (under)
Jan 109,523 111,659 1.95%
Feb 219,526 223,634 1.87%
Mar 329,528 335,635 1.85%
Apr 439,743 449,552 2.23%
May 550,170 561,505 2.06%
Jun 665,842 673,328 1.12%
Jul 777,227 785,314 1.04%
Aug 888,696 897,301 0.97%
Sep 1,000,092
Oct 1,110,844
Nov 1,221,394
Dec 1,344,262
Percent of budget expended 66.75%
Development
Services Budget
YTD
Actual
Annual %
over (under)
Jan 264,534 239,592 -9.43%
Feb 556,675 474,218 -14.81%
Mar 837,976 704,870 -15.88%
Apr 1,122,798 938,343 -16.43%
May 1,411,145 1,182,919 -16.17%
Jun 1,706,788 1,444,178 -15.39%
Jul 1,999,686 1,703,575 -14.81%
Aug 2,295,263 1,958,078 -14.69%
Sep 2,610,625
Oct 2,908,222
Nov 3,230,941
Dec 3,446,946
Percent of budget expended 56.81%
$-
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
Millions
Community & Economic
Development Admin
Budget
Actual
Last Year
$-
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions
Development Services
Budget
Actual
Last Year
City of Renton
Monthly Expenditure Analysis - 2018 Budget Year
Economic
Development Budget
YTD
Actual
Annual %
over (under)
Jan 83,088 54,919 -33.90%
Feb 176,786 142,952 -19.14%
Mar 263,098 191,708 -27.13%
Apr 408,967 236,753 -42.11%
May 602,284 288,153 -52.16%
Jun 767,566 347,114 -54.78%
Jul 901,182 404,143 -55.15%
Aug 1,027,319 454,699 -55.74%
Sep 1,180,119
Oct 1,356,648
Nov 1,493,484
Dec 1,671,873
Percent of budget expended 27.20%
Planning Budget
YTD
Actual
Annual %
over (under)
Jan 275,164 230,023 -16.41%
Feb 557,855 479,452 -14.05%
Mar 849,006 743,111 -12.47%
Apr 1,134,716 981,781 -13.48%
May 1,437,433 1,217,342 -15.31%
Jun 1,735,366 1,462,823 -15.71%
Jul 2,022,188 1,714,367 -15.22%
Aug 2,320,523 1,971,940 -15.02%
Sep 2,619,476
Oct 2,906,654
Nov 3,190,797
Dec 3,580,743
Percent of budget expended 55.07%
$-
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
Millions
Economic Development
Budget
Actual
Last Year
$-
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
Millions
Planning
Budget
Actual
Last Year
City of Renton
Monthly Expenditure Analysis - 2018 Budget Year
Finance Budget
YTD
Actual
Annual %
over (under)
Jan 247,466 215,045 -13.10%
Feb 509,222 446,774 -12.26%
Mar 754,095 674,895 -10.50%
Apr 1,016,230 910,304 -10.42%
May 1,279,092 1,172,940 -8.30%
Jun 1,563,543 1,409,917 -9.83%
Jul 1,846,099 1,720,649 -6.80%
Aug 2,157,827 1,957,768 -9.27%
Sep 2,413,530
Oct 2,676,985
Nov 2,933,444
Dec 3,660,725
Percent of budget expended 53.48%
City Clerk Budget
YTD
Actual
Annual %
over (under)
Jan 86,384 73,376 -15.06%
Feb 328,209 154,002 -53.08%
Mar 421,047 493,757 17.27%
Apr 516,953 572,896 10.82%
May 613,842 682,037 11.11%
Jun 713,074 765,641 7.37%
Jul 816,413 845,406 3.55%
Aug 988,415 920,872 -6.83%
Sep 1,009,569
Oct 1,105,988
Nov 1,209,533
Dec 1,359,565
Percent of budget expended 67.73%
Includes Hearing Examiner
$-
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
Millions City Clerk
Budget
Actual
Last Year
$-
$0.40
$0.80
$1.20
$1.60
$2.00
$2.40
$2.80
$3.20
$3.60
$4.00
Millions Finance
Budget
Actual
Last Year
City of Renton
Monthly Expenditure Analysis - 2018 Budget Year
Human
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 102,634 93,068 -9.32%
Feb 208,536 196,272 -5.88%
Mar 330,862 299,021 -9.62%
Apr 457,074 416,778 -8.82%
May 568,827 520,504 -8.50%
Jun 680,424 621,117 -8.72%
Jul 794,574 734,589 -7.55%
Aug 917,307 838,119 -8.63%
Sep 1,033,849
Oct 1,158,702
Nov 1,271,446
Dec 1,395,877
Percent of budget expended 60.04%
Police Budget
YTD
Actual
Annual %
over (under)
Jan 3,316,808 3,128,806 -5.67%
Feb 6,284,441 6,112,773 -2.73%
Mar 9,768,766 9,490,170 -2.85%
Apr 12,785,960 12,493,987 -2.28%
May 16,197,840 15,900,505 -1.84%
Jun 19,255,973 18,843,188 -2.14%
Jul 22,972,666 22,164,057 -3.52%
Aug 26,087,897 25,158,916 -3.56%
Sep 29,577,322
Oct 32,673,902
Nov 35,936,640
Dec 39,788,478
Percent of budget expended 63.23%
$-
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
Millions Human Resources
Budget
Actual
Last Year
$-
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
$36
Millions Police
Budget
Actual
Last Year
City of Renton
Monthly Expenditure Analysis - 2018 Budget Year
Community
Services Admin Budget
YTD
Actual
Annual %
over (under)
Jan 45,023 39,217 -12.90%
Feb 92,353 85,085 -7.87%
Mar 132,149 128,636 -2.66%
Apr 170,514 173,564 1.79%
May 212,599 217,983 2.53%
Jun 250,135 262,197 4.82%
Jul 288,979 298,799 3.40%
Aug 327,923 340,151 3.73%
Sep 366,027
Oct 404,645
Nov 442,821
Dec 532,039
Percent of budget expended 63.93%
Parks Budget
YTD
Actual
Annual %
over (under)
Jan 357,747 317,964 -11.12%
Feb 727,300 663,798 -8.73%
Mar 1,131,707 1,030,518 -8.94%
Apr 1,561,761 1,447,411 -7.32%
May 1,979,358 1,838,214 -7.13%
Jun 2,431,494 2,280,676 -6.20%
Jul 2,928,704 2,762,883 -5.66%
Aug 3,454,207 3,272,566 -5.26%
Sep 4,002,595
Oct 4,466,477
Nov 4,890,983
Dec 5,405,614
Percent of budget expended 60.54%
$-
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
Millions Parks
Budget
Actual
Last Year
$0
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
Community Services Admin
Budget
Actual
Last Year
City of Renton
Monthly Expenditure Analysis - 2018 Budget Year
Parks Planning
and Natural
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 68,223 57,925 -15.09%
Feb 166,223 124,297 -25.22%
Mar 252,457 197,223 -21.88%
Apr 342,051 290,483 -15.08%
May 457,569 379,727 -17.01%
Jun 584,447 491,882 -15.84%
Jul 693,286 604,217 -12.85%
Aug 835,905 716,763 -14.25%
Sep 965,136
Oct 1,074,970
Nov 1,198,627
Dec 1,373,998
Percent of budget expended 52.17%
Recreation Budget
YTD
Actual
Annual %
over (under)
Jan 424,079 394,586 -6.95%
Feb 893,455 897,444 0.45%
Mar 1,376,394 1,326,626 -3.62%
Apr 1,869,666 1,767,262 -5.48%
May 2,334,676 2,202,345 -5.67%
Jun 2,849,954 2,670,323 -6.30%
Jul 3,589,025 3,345,277 -6.79%
Aug 4,360,567 4,134,897 -5.18%
Sep 5,025,881
Oct 5,514,515
Nov 5,995,720
Dec 6,493,463
Percent of budget expended 63.68%
$-
$200,000
$400,000
$600,000
$800,000
$1,000,000
$1,200,000
$1,400,000
$1,600,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
$6.00
$6.50
$7.00
Millions Recreation
Budget
Actual
Last Year
City of Renton
Monthly Expenditure Analysis - 2018 Budget Year
Human Services Budget
YTD
Actual
Annual %
over (under)
Jan 90,222 55,197 -38.82%
Feb 192,818 184,247 -4.44%
Mar 263,399 243,570 -7.53%
Apr 365,819 339,032 -7.32%
May 496,257 560,102 12.87%
Jun 557,968 616,401 10.47%
Jul 685,922 829,262 20.90%
Aug 808,203 900,340 11.40%
Sep 870,635
Oct 1,044,313
Nov 1,160,522
Dec 1,441,591
Percent of budget expended 62.45%
Neighborhoods,
Resources, and
Events Budget
YTD
Actual
Annual %
over (under)
Jan - - N/A
Feb - - N/A
Mar - - N/A
Apr - - N/A
May - - N/A
Jun - - N/A
Jul - - N/A
Aug - - N/A
Sep -
Oct -
Nov -
Dec -
Percent of budget expended N/A
$-
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
Millions Human Services
Budget
Actual
Last Year
$-
$200,000
$400,000
$600,000
$800,000
$1,000,000
$1,200,000
Neighborhoods, Resources, and Events
Budget
Actual
Last Year
City of Renton
Monthly Expenditure Analysis - 2018 Budget Year
Museum Fund Budget
YTD
Actual
Annual %
over (under)
Jan 19,943 19,889 -0.27%
Feb 39,991 40,634 1.61%
Mar 59,393 60,984 2.68%
Apr 79,159 81,439 2.88%
May 98,532 102,003 3.52%
Jun 118,175 122,512 3.67%
Jul 138,557 143,077 3.26%
Aug 158,827 163,495 2.94%
Sep 179,495
Oct 200,268
Nov 220,924
Dec 241,246
Percent of budget expended 67.77%
Public Works
Admin Budget
YTD
Actual
Annual %
over (under)
Jan 34,486 34,521 0.10%
Feb 69,669 69,361 -0.44%
Mar 104,789 104,253 -0.51%
Apr 139,642 140,203 0.40%
May 174,360 175,219 0.49%
Jun 209,285 210,071 0.38%
Jul 244,157 248,162 1.64%
Aug 279,239 278,939 -0.11%
Sep 314,679
Oct 348,881
Nov 383,025
Dec 417,024
Percent of budget expended 66.89%
$-
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
$400,000
$450,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
City of Renton
Monthly Expenditure Analysis - 2018 Budget Year
Street
Maintenance Budget
YTD
Actual
Annual %
over (under)
Jan 447,488 428,817 -4.17%
Feb 954,625 859,296 -9.99%
Mar 1,449,328 1,354,087 -6.57%
Apr 1,985,639 1,808,825 -8.90%
May 2,486,690 2,245,930 -9.68%
Jun 2,971,378 2,712,839 -8.70%
Jul 3,449,731 3,166,956 -8.20%
Aug 3,931,101 3,605,733 -8.28%
Sep 4,431,705
Oct 4,919,562
Nov 5,386,040
Dec 5,887,710
Percent of budget expended 61.24%
Transportation Budget
YTD
Actual
Annual %
over (under)
Jan 349,888 366,141 4.65%
Feb 724,525 818,473 12.97%
Mar 1,160,912 1,370,577 18.06%
Apr 1,600,064 1,829,389 14.33%
May 2,143,162 2,259,514 5.43%
Jun 2,586,186 2,699,517 4.38%
Jul 3,043,717 3,201,311 5.18%
Aug 3,486,730 3,645,151 4.54%
Sep 3,942,584
Oct 4,745,428
Nov 5,129,615
Dec 5,805,521
Percent of budget expended 62.79%
$-
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
$7.00
Millions Street Maintenance
Budget
Actual
Last Year
$0.0
$1.0
$2.0
$3.0
$4.0
$5.0
$6.0
Millions Transportation
Budget
Actual
Last Year
City of Renton
Monthly Expenditure Analysis - 2018 Budget Year
Debt Service Budget
YTD
Actual
Annual %
over (under)
Jan 37,996 37,996 0.00%
Feb 288,313 288,313 0.00%
Mar 290,010 290,010 0.00%
Apr 290,010 290,010 0.00%
May 290,010 290,010 0.00%
Jun 777,530 777,530 0.00%
Jul 1,026,776 1,026,776 0.00%
Aug 1,277,094 1,277,094 0.00%
Sep 4,277,433
Oct 4,752,703
Nov 5,227,974
Dec 5,703,244
Percent of budget expended 22.39%
Non-
Departmental
Other City Budget
YTD
Actual
Annual %
over (under)
Jan 309,681 309,681 0.00%
Feb 560,003 560,003 0.00%
Mar 797,846 797,846 0.00%
Apr 1,028,809 1,028,809 0.00%
May 1,306,632 1,306,632 0.00%
Jun 1,539,841 1,539,841 0.00%
Jul 1,762,393 1,762,393 0.00%
Aug 2,039,684 2,039,684 0.00%
Sep 3,584,148
Oct 3,982,387
Nov 4,380,625
Dec 4,778,864
Percent of budget expended 42.68%
$-
$2.00
$4.00
$6.00
$8.00
$10.00
$12.00
$14.00
$16.00
Millions Non-Departmental Other City Services
Budget
Actual
Last Year
$-
$1
$2
$3
$4
$5
$6
$7
Millions Debt Service
Budget
Actual
Last Year
City of Renton
Monthly Enterprise Fund Financial Report - 2018 Budget Year
Utilities Budget Revenue Expense
Jan - 4,980,942 3,338,103
Feb - 11,208,449 9,275,111
Mar - 19,199,517 15,056,895
Apr - 25,237,476 20,384,128
May - 31,307,224 27,050,704
Jun - 38,732,187 33,020,015
Jul - 45,716,350 38,064,135
Aug - 52,893,255 45,412,468
Sep -
Oct -
Nov -
Dec -
Percent of budget expended 100.00%
Note: Operations and Capital
Airport Budget Revenue Expense
Jan - 237,743 123,513
Feb - 489,156 267,530
Mar - 739,253 442,543
Apr - 1,014,841 611,773
May - 1,249,585 762,052
Jun - 1,478,450 919,610
Jul - 2,138,986 1,087,367
Aug - 2,393,990 1,257,502
Sep -
Oct -
Nov -
Dec -
Percent of budget expended 100.00%
Note: Operations and Capital
$0
$10
$20
$30
$40
$50
$60
Millions Utilities
Budget
Revenue
Expense
$-
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
Millions Airport
Budget
Revenue
Expense
City of Renton
Monthly Enterprise Fund Financial Report - 2018 Budget Year
Golf Course Budget Revenue Expense
Jan - 66,977 144,831
Feb - 138,056 313,308
Mar - 293,466 480,261
Apr - 503,971 669,183
May - 745,952 876,008
Jun - 1,131,733 1,066,048
Jul - 1,469,591 1,268,159
Aug - 1,766,326 1,459,980
Sep -
Oct -
Nov -
Dec -
Percent of budget expended 100.00%
Note: Operations and Capital
$-
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
Millions Golf Course
Budget
Revenue
Expense