HomeMy WebLinkAbout201801, January
h:\finance\financial reporting\monthly reports\2018 reports\cover 0118.docx
ADMINISTRATIVE SERVICES
M E M O R A N D U M
DATE: March 21, 2018
TO: Ed Prince, Council President
Members of Renton City Council
CC: Denis Law, Mayor
Jay Covington, Chief Administrative Officer
FROM: Jan Hawn, ASD Administrator
STAFF CONTACT: Hai Nguyen, Sr. Finance Analyst
SUBJECT: January 2018 Financial Status Report
At the end of January, general governmental revenues show $268K or 3.4% over budget.
Revenue source(s) that are higher than expected are: sales tax ($121K); business license
($220K); and public safety ($168K). On the down side, the revenue source(s) that are
underperforming the year to date budget is building permits & development service fees
($253K below).
General government expenditures showed a favorable variance of $280K or 3.9%. 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 x6952 should
you have any questions or any suggestions about the report.
Ed Prince, Council President
Members of Renton City Council
Page 2 of 2
March 21, 2018
h:\finance\financial reporting\monthly reports\2018 reports\cover 0118.docx
This page is intentionally left blank
General Governmental Funds
$%
Beginning Fund Balance 19,962,845$ 19,962,845$ 26,563,785$ 26,563,785$ 20,936,323$ 20,936,323$ 33,284,838$ 12,348,515 59.0%
OPERATING REVENUES
Property Tax 37,038,480 44,745 24,356,562 55,429 19,397,308 31,649 (12,745) (44,394) ‐140.3%
Sales Tax 26,353,246 1,978,530 26,331,634 2,092,821 26,683,440 2,096,932 2,217,949 121,017 5.8%
Sales Tax ‐ Annexation Credit 3,114,762 234,180 3,123,230 247,737 2,120,300 163,804 263,143 99,339 60.6%
Criminal Justice Sales Tax 2,701,787 204,149 2,808,564 213,532 2,782,404 210,904 231,017 20,113 9.5%
Natural Gas Use Tax 184,638 23,504 180,456 15,569 228,000 19,671 14,578 (5,093) ‐25.9%
Admission Tax 262,506 76,393 223,157 60,741 320,000 90,356 56,598 (33,759) ‐37.4%
Franchise Fees 1,406,092 348,118 1,562,100 380,870 1,330,000 326,648 371,458 44,810 13.7%
Electricity Tax 5,440,139 509,539 5,721,366 561,650 5,476,959 525,633 557,035 31,401 6.0%
Natural Gas Utility Tax 1,327,937 187,353 1,630,375 222,337 1,350,900 187,083 216,102 29,019 15.5%
Garbage/Solid Waste 717,148 50,860 627,254 52,200 680,000 52,127 54,608 2,480 4.8%
TV Cable 1,619,364 139,333 1,651,405 140,113 1,662,115 142,007 142,274 268 0.2%
Telephone 859,868 64,249 866,519 109,120 729,131 73,222 63,229 (9,993) ‐13.6%
Cellular Phone 1,541,204 98,316 1,481,298 224,795 1,536,267 164,230 79,178 (85,051) ‐51.8%
City Utilities 4,206,473 325,580 4,840,530 372,938 4,000,752 308,897 268,383 (40,515) ‐13.1%
Utility Tax Audit 111,227 111,227 ‐ ‐ ‐ ‐ ‐ ‐ 0.0%
Leasehold Excise Tax 173,769 ‐ 173,396 ‐ 179,000 ‐ ‐ ‐ 0.0%
Gambling Excise Tax 2,500,604 189,749 2,695,368 220,536 2,000,000 157,924 210,929 53,004 33.6%
Real Estate Excise Tax 6,121,830 1,204,479 7,211,736 1,028,456 4,420,000 786,056 840,316 54,260 6.9%
Less: CIP REET (2,707,676) (602,240) (6,461,736) (1,028,456) (4,420,000) (786,056) (840,316) (54,260) 6.9%
EMS Levy 479,597 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 0.0%
B&O Taxes 6,375,322 ‐ 9,633,034 432,319 7,636,000 1,527,200 1,301,574 (225,626) ‐14.8%
Less: CIP B&O Taxes (2,000,000) ‐ (2,473,974) ‐ (1,379,314) (275,863) ‐ 275,863 ‐100.0%
Business License Fees 1,926,510 559,894 1,480,730 229,270 1,311,894 277,687 574,453 296,767 106.9%
Less: CIP Business License Fees (1,587,627) (463,802) (614,796) (136,952) (623,186) (169,986) (246,261) (76,274) 44.9%
Animal Licenses and Spec Events Permits 102,905 6,640 140,391 7,190 94,174 6,828 9,592 2,764 40.5%
Building Permits & Development Svc Fees 5,293,563 661,363 4,907,983 399,548 5,451,699 567,204 314,626 (252,577) ‐44.5%
Intergovt'l (Grants, State Shared, etc)3,998,953 385,671 4,285,806 391,146 3,735,614 384,766 370,339 (14,427) ‐3.7%
Fire District 25 and 40 Contracts 3,517,779 ‐ 341,939 ‐ 357,660 ‐ ‐ ‐ 0.0%
Public Safety 994,179 104,644 837,728 64,424 617,635 57,002 224,932 167,930 294.6%
Culture and Recreation 1,632,903 163,783 1,722,323 152,350 1,755,923 165,445 138,388 (27,057) ‐16.4%
Interfund/Interdept‐Services 3,377,663 272,841 3,916,334 330,774 4,361,086 363,424 341,804 (21,619) ‐5.9%
Fines and Penalties 901,592 5,140 822,450 6,981 830,082 2,406 4,772 2,366 98.3%
Photo Enforcement 1,959,071 131,281 2,124,399 127,976 3,151,072 200,059 136,853 (63,206) ‐31.6%
Seizure Funds ‐ Federal/State/Local 987,293 ‐ 176,503 101,755 ‐ ‐ 5,094 5,094 100.0%
Interests and Other Earnings 1,058,880 51,219 1,155,371 59,675 875,300 43,837 76,546 32,710 74.6%
Rents, Leases, and Concessions 642,192 149,010 634,897 164,492 623,195 152,983 155,535 2,552 1.7%
Contributions and Donations 96,582 ‐ 177,919 575 70,000 147 ‐ (147) ‐100.0%
Other Miscellaneous 956,131 101,726 954,680 62,236 702,998 55,191 47,611 (7,580) ‐13.7%
Other Financing Sources (Transfer‐In, etc) 2,129,561 ‐ 283,213 ‐ 142,975 11,915 ‐ (11,915) ‐100.0%
Total Operating Revenues 125,816,444 7,317,475 109,530,146 7,364,146 100,191,383 7,921,333 8,189,596 268,264 3.4%
OPERATING EXPENDITURES
Council 358,550 34,732 362,101 36,043 374,666 36,796 38,187 (1,391) ‐3.8%
Executive 1,778,206 192,359 1,954,748 211,310 1,977,556 213,846 216,805 (2,959) ‐1.4%
Emergency Management*370,832 25,024 569,333 35,052 606,070 38,727 46,027 (7,299) ‐18.8%
City Attorney 1,983,834 157,485 2,088,718 168,105 2,251,312 179,986 177,424 2,562 1.4%
Court Services 2,075,763 163,432 2,174,217 169,642 2,250,644 176,384 182,051 (5,667) ‐3.2%
Community and Eco Dvlpmnt Admin 1,161,330 95,028 1,351,830 109,731 1,339,679 109,150 111,659 (2,509) ‐2.3%
Development Services 2,859,410 212,162 3,023,728 239,337 3,451,529 264,886 239,592 25,294 9.5%
Economic Development 1,004,411 50,235 949,467 46,869 1,122,610 55,791 54,919 872 1.6%
Planning 2,716,214 203,948 2,815,148 221,112 3,473,927 266,956 230,023 36,933 13.8%
Finance 3,046,824 220,501 3,132,609 197,230 3,628,725 245,302 215,045 30,258 12.3%
City Clerk 914,251 67,195 1,119,376 62,018 1,250,565 79,458 73,376 6,082 7.7%
Human Resources 1,193,016 89,683 1,221,841 87,874 1,370,877 100,796 93,068 7,729 7.7%
Police 28,891,879 2,427,387 30,987,047 2,564,523 32,949,811 2,746,918 2,631,438 115,480 4.2%
Jail Services 4,704,978 391,994 4,807,443 400,352 5,968,750 497,368 497,368 ‐ 0.0%
Fire*25,349,755 2,266,350 ‐ ‐ ‐ ‐ ‐ ‐ 0.0%
Community Services Admin 585,983 52,449 554,951 44,101 523,015 44,259 39,217 5,043 11.4%
Parks 4,448,302 302,959 4,817,186 309,997 5,219,050 345,400 313,568 31,832 9.2%
Parks Planning & Natural Resources 952,980 46,446 1,059,058 53,458 1,266,373 62,879 57,925 4,954 7.9%
Recreation 5,528,073 375,941 5,778,897 388,106 6,256,963 408,633 446,821 (38,187) ‐9.3%
Human Services 1,241,169 81,352 1,634,387 98,615 1,311,570 82,084 55,197 26,888 32.8%
Neighborhoods, Resources, & Events 430,527 20,423 483,148 20,155 247,305 16,990 (47,839) 64,829 381.6%
Museum 229,543 19,061 235,712 19,400 241,246 19,943 19,889 54 0.3%
Public Works Admin 398,796 33,119 406,781 33,498 417,024 34,486 34,521 (36) ‐0.1%
Street Maintenance 5,041,509 400,277 5,603,141 408,757 5,587,710 424,687 428,817 (4,130) ‐1.0%
Transportation 5,966,281 356,191 5,368,887 326,959 5,791,047 349,016 366,141 (17,125) ‐4.9%
Debt Service 6,099,166 44,758 6,063,576 41,377 5,703,244 37,996 37,996 ‐ 0.0%
Non‐Departmental and Other 9,883,923 294,800 14,245,763 301,517 3,720,864 309,681 309,681 ‐ 0.0%
Total Operating Expenditures 119,215,504 8,625,290 102,809,093 6,595,136 98,302,133 7,148,422 6,868,916 279,506 3.9%
Total Ending Fund Balance 26,563,785$ 18,655,030$ 33,284,838$ 27,332,795$ 22,825,573$ 21,709,234$ 34,605,518$ 12,896,285$ 59.4%
*Emergency Management was moved to Executive due to formation of RRFA
Favorable (Unfavorable)
2016 2017 2018 Variance
Annual Actual YTD Actual Annual Budget YTD Budget YTD ActualSummary of Sources and Uses Annual Actual YTD Actual
Monthly Financial Report January 2018
Page 1 of 37
Monthly Financial Report January 2018
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through January 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 71% of
all resources supporting general governmental activities. The following section provides detail information on property,
sales, utility, and other taxes.
Property Tax
January’s collection is ‐$13K. The
negative amount for January is
due to the timing of recording
January’s receipts in February.
February activity will correct the
negative January balance.
Sales Tax
January 2018 sales tax receipts
totaled $2.2M. Compared with
the same month last year, it is
$125K or 6% more. Compared to
the projected current month’s
budget, it is $121K or 6% above.
New Construction and Service
are the sectors that are collecting
more than anticipated. 2018’s
monthly budgets are generally
based on 2013 through 2017
collections.
2017 2018 2018
Actual Budget Actual $ % $ %
Jan 55,429$ 31,649$ (12,745)$ (68,174)$ ‐123% (44,394)$ ‐140%
Feb 195,332 161,273
Mar 902,965 687,696
Apr 7,035,332 4,704,879
May 4,489,476 4,548,312
Jun 128,834 84,239
Jul 69,600 40,053
Aug 101,349 108,016
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 55,429$ 31,649$ (12,745)$ (68,174)$ ‐123% (44,394)$ ‐140%
Annual Total 24,356,562$ 19,397,308$
Property Tax Revenues
Year to Date through January
2018 vs. 2017 2018 vs. Budget
Month
2017 2018 2018
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 ‐
Mar 1,945,278 1,990,954 ‐
Apr 1,871,345 1,956,740 ‐
May 2,381,981 2,327,614 ‐
Jun 2,075,555 2,050,822 ‐
Jul 2,236,477 2,140,543 ‐
Aug 2,421,720 2,378,153 ‐
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 2,092,821$ 2,096,932$ 2,217,949$ 125,128$ 6% 121,017$ 6%
Annual Total 26,331,634$ 26,683,440$
2018 vs. Budget2018 vs. 2017
Month
Year to Date through January
Local Retail Sales Tax Revenues
Page 2 of 37
Monthly Financial Report January 2018
The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business
sectors:
Utility tax
January utility tax revenues are
$1.4M, which is $303K or 18%
lower than the same month last
year and is also lower than the
budget by $77K or 5%. 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.
Sales Tax by Sector 2017 2018 Bgt YTD Act Change 2018/2017 2018 Act vs Bgt
New Construction 356,048$ 294,152$ 366,091$ 10,043$ 3% $ 71,939 24%
Auto Sales 394,601 396,528 401,075 6,474 2% 4,547 1%
General Retail 629,217 646,114 648,986 19,769 3% 2,872 0%
Manufacturing 111,398 143,234 148,763 37,365 34% 5,529 4%
Wholesale 120,058 111,641 108,665 (11,393) ‐9% (2,976)‐3%
Service 435,680 454,292 499,228 63,548 15% 44,935 10%
Other 45,820 50,970 45,141 (678) ‐1% (5,829)‐11%
YTD Total 2,092,821$ 2,096,932$ 2,217,949$ 125,128$ 6%121,017$ 6%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
2017 2018 2018
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
Mar 1,197,548 1,249,534
Apr 1,797,449 1,493,002
May 1,464,438 1,341,860
Jun 1,351,607 1,173,122
Jul 1,538,390 1,342,347
Aug 1,185,237 1,155,083
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 1,698,721$ 1,472,870$ 1,395,386$ (303,335)$ ‐18% (77,484)$ ‐5%
Annual Total 16,999,203$ 15,664,124$
2018 vs. Budget2018 vs. 2017
Year to Da te through January
Utility Tax Revenues
Month
Utility Tax by Type 2017 2018 Bgt YTD Act Change 2018/2017 2018 Act vs Bgt
Electrical 561,650$ 525,633$ 557,035$ (4,615)$ ‐1% $ 31,401 6%
Natural Gas 237,906 206,754 230,680 (7,226) ‐3% 23,926 12%
Cell 224,795 164,230 79,178 (145,616) ‐65% (85,051)‐52%
Phone 109,120 73,222 63,229 (45,891) ‐42% (9,993)‐14%
Cable 140,113 142,007 142,274 2,161 2% 268 0%
Garbage/Solid Waste 52,200 52,127 54,608 2,408 5% 2,480 5%
City Utilities 372,938 308,897 268,383 (104,555) ‐28% (40,515)‐13%
Utility Tax Audit ‐ ‐ ‐ ‐ N/A ‐ N/A
YTD Total 1,698,721$ 1,472,870$ 1,395,386$ (303,335)$ ‐18%(77,484)$ ‐5%
Annual Total 16,999,203$ 15,664,124$
YTD as % of 10% 9%
Page 3 of 37
Monthly Financial Report January 2018
Other Taxes
Real Estate Excise Tax
The City collected $840K in Real
Estate Excise Tax revenues (REET)
for January. This is $188K or 18%
less than the same month last
year but is $54K or 7% more than
the current month’s budget. The
higher than expected variance is
due to 5 large transactions in
December which accounts for
$574K of the total REET collected.
Gambling Tax
January’s Gambling Tax
collections totaled $211K, which
is $10K or 4% below the same
month last year but is above the
current month’s budget by $53K
or 34%.
Franchise Fees
Franchise Fees are due quarterly
in January, April, July, and
October. The year‐to‐date total
of $371K is $9K or 2% lower than
the prior year but is $45K or 14%
above the projected year‐to‐date
budget.
2017 2018 2018
Actual Budget Actual $ % $ %
Jan 220,536$ 157,924$ 210,929$ (9,607)$ ‐4% 53,004$ 34%
Feb 200,622 157,269 ‐
Mar 180,839 144,763 ‐
Apr 219,422 160,397 ‐
May 248,673 172,020 ‐
Jun 232,889 160,867 ‐
Jul 230,342 163,457 ‐
Aug 216,990 207,784 ‐
Sep 205,141 156,872 ‐
Oct 215,122 176,050 ‐
Nov 259,744 170,551 ‐
Dec 265,048 172,045 ‐
YTD Total 220,536$ 157,924$ 210,929$ (9,607)$ ‐4% 53,004$ 34%
Annual Total 2,695,368$ 2,000,000$
2018 vs. 2017
Gambling Tax Revenue
Month
Year to Date through January
2018 vs. Budget
2017 2018 2018
Actual Budget Actual $ % $ %
Jan 380,870$ 326,648$ 371,458$ (9,411)$ ‐2% 44,810$ 14%
Feb 6,300 2,823 ‐
Mar 9,100 4,078 ‐
Apr 369,626 324,886 ‐
May 7,688 3,445 ‐
Jun 21,325 9,555 ‐
Jul 342,363 307,508 ‐
Aug 7,700 3,450 ‐
Sep 8,750 6,161 ‐
Oct 375,128 324,373 ‐
Nov 10,500 4,705 ‐
Dec 22,750 12,367 ‐
YTD Total 380,870$ 326,648$ 371,458$ (9,411)$ ‐2% 44,810$ 14%
Annual Total 1,562,100$ 1,330,000$
Franchise Fees Revenue
Year to Date through January
Month
2018 vs. 2017 2018 vs. Budget
2017 2018 2018
Actual Budget Actual $ % $ %
Jan 1,028,456$ 786,056$ 840,316$ (188,139)$ ‐18% 54,260$ 7%
Feb 337,024 210,018
Mar 708,868 391,942
Apr 385,517 266,812
May 386,087 300,651
Jun 747,549 458,002
Jul 591,137 440,175
Aug 672,396 507,194
Sep 633,804 431,443
Oct 359,891 308,343
Nov 775,249 398,534
Dec 585,757 (79,171)
YTD Total 1,028,456$ 786,056$ 840,316$ (188,139)$ ‐18% 54,260$ 7%
Annual Total 7,211,736$ 4,420,000$
*Total REET (GF & CIP)
Month
2018 vs. Budget2018 vs. 2017
Real Estate Excise Tax (REET) Revenues*
Year to Date through January
Page 4 of 37
Monthly Financial Report January 2018
Admission Tax
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.
The year‐to‐date collection of
$57K is $4K or 7% less than the
prior year and is also $35K or 37%
less than the budget.
Business & Occupation Tax
Business and Occupation (B&O)
Tax is a new revenue source for
the City in 2016. It was adopted
by the Council in the 2015/2016
biennial budget. Businesses with
gross receipts of $1.5M or more
per year, earned within the City
of Renton, will be required to file
and pay B&O tax, in lieu of the
Per Employee Fee, which is
currently reported as Business
License revenue. Year‐to‐date
receipts totaled $1.3M. The
monthly budgets are based on
large business quarterly
reporting with smaller business
annual reporting.
Licenses and Permits
Business Licenses
Business Licenses totaled $574K
for January, which is $345K or
151% above the same month last
year and is also $297K or 107%
above the current month’s
budget. The variance with the
budget and prior year is due the
City adopting Ordinance 5866
which changed the reporting
period from quarterly to annually
with a due date January and
removing the per employee tax.
The City projects a decrease in
overall Business Licenses.
2017 2018 2018
Actual Budget Actual $ % $ %
Jan 60,741$ 90,356$ 56,598$ (4,143)$ ‐7% (33,759)$ ‐37%
Feb 2,788 2,733 ‐
Apr 58,566 80,156 ‐
May 1,279 842 ‐
Jun 785 517 ‐
Jul 51,061 73,680 ‐
Aug 1,578 1,040 ‐
Sep ‐ 341 ‐ ‐
Oct 1,705 39,955 ‐
Nov ‐ 956 ‐ ‐
Dec 44,655 29,423 ‐
YTD Total 60,741$ 90,356$ 56,598$ (4,143)$ ‐7% (33,759)$ ‐37%
Annual Total 223,157$ 320,000$
2018 vs. Budget
Admission Tax Revenue
Year to Date through January
Month
2018 vs. 2017
2017 2018 2018
Actual Budget Actual $ % $ %
Jan 432,319$ 1,527,200$ 1,301,574$ 869,256$ 201% (225,626)$ ‐15%
Feb 794,093 190,900 ‐
Mar 13,228 190,900 ‐
Apr 4,626,880 1,527,200 ‐
May 316,791 190,900 ‐
Jun 23,491 190,900 ‐
Jul 1,139,041 1,527,200 ‐
Aug 399,375 190,900 ‐
Sep 169,792 190,900 ‐
Oct 981,417 1,527,200 ‐
Nov 320,706 190,900 ‐
Dec 415,901 190,900 ‐
YTD Total 432,319$ 1,527,200$ 1,301,574$ 869,256$ 201% (225,626)$ ‐15%
Annual Total 9,633,034$ 7,636,000$
*Total Business & Occupation Taxes (GF & CIP)
Business & Occupation Taxes*
Year to Date through January
Month
2018 vs. 2017 2018 vs. Budget
2017 2018 2018
Actual Budget Actual $ % $ %
Jan 229,270$ 277,687 574,453$ 345,183$ 151% 296,767$ 107%
Feb 157,504 157,567 ‐
Mar 53,131 33,461 ‐
Apr 157,983 145,552 ‐
May 126,086 97,341 ‐
Jun 36,375 27,014 ‐
Jul 217,718 181,851 ‐
Aug 124,833 95,699 ‐
Sep 57,640 34,647 ‐
Oct 187,368 160,619 ‐
Nov 88,975 73,242 ‐
Dec 43,847 27,214 ‐
YTD Total 229,270$ 277,687$ 574,453$ 345,183$ 151% 296,767$ 107%
Annual Total 1,480,730$ 1,311,894$
*Total Business License (GF & CIP)
Business Licenses*
Month
2018 vs. 2017
Year to Date through January
2018 vs. Budget
Page 5 of 37
Monthly Financial Report January 2018
Building Permits and
Development Service Fees
Building Permits and
Development Service Fee
revenues totaled $315K in
January. This is $85K or 21% less
than the year before and is also
$253K or 45% less than the
budget. 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.
Intergovernmental
These revenue sources
include federal (direct
and indirect) grants,
state grants, state
shared revenues, local
grants, and
entitlements. State
shared revenues 95% of
the total revenues in
this category. The year‐
to‐date total
Intergovernmental revenue is $601K or 9% of the budget.
State Shared Revenues
State Shared Revenue
collections totaled
$570K since the start of
the year. Compared to
the prior year, State
Shared Revenues are
above by $27K or 5%.
Compared to the
projected budget, the
City is collecting $44K or
8% more. The higher
than expected collection
is due to collecting more
than anticipated
Criminal Justice’s Sales
Tax and Liquor Excise Tax.
2017 2018 2018
Actual Budget Actual $ % $ %
Jan 399,548$ 567,204$ 314,626$ (84,921)$ ‐21% (252,577)$ ‐45%
Feb 277,296 369,165
Mar 503,290 581,137
Apr 265,749 321,507
May 558,773 499,771
Jun 611,441 560,415
Jul 264,515 388,411
Aug 433,043 444,085
Sep 445,562 441,521
Oct 338,298 436,655
Nov 479,017 414,816
Dec 331,450 427,013
YTD Total 399,548$ 567,204$ 314,626$ (84,921)$ ‐21% (252,577)$ ‐45%
Annual Total 4,907,983$ 5,451,699$
Building Permits and Development Service Fees
Year to Da te through January
2018 vs. Budget2018 vs. 2017
Month
Intergovernmental 2017 2018 Bgt YTD Act Change 2018/2017 2018 Act vs Bgt
Fire District #25 ‐$ ‐$ ‐$ ‐$ N/A $ ‐ N/A
Fire District #40 ‐ ‐ ‐ ‐ N/A ‐ N/A
State Shared Revenue 543,102 525,336 569,772 26,670 5% 44,435 8%
Federal Grants 9,173 777 ‐ (9,173) 0% (777) 0%
State Grants ‐ 15,271 15,271 15,271 100%‐ 0%
Other Grants/Intgovt 52,403 54,286 16,313 (36,090) ‐69% (37,973) ‐70%
ARRA Grants ‐ ‐ ‐ ‐ N/A ‐ N/A
Total Rev YTD 604,678$ 595,670$ 601,356$ (3,322)$ ‐1%5,685$ 1%
Total Rev Annual 7,436,309$ 6,875,678$
YTD %8%9%9%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
2017 2018 2018
Actual Budget Actual $ % $ %
Crim Just Sales Tax 213,532$ 210,904$ 231,017$ 17,485$ 8% 20,113$ 10%
Judicial Contribution ‐ ‐ ‐ ‐ N/A ‐ N/A
Crim Just ‐ High Crime 67,721 66,589 68,269 549 1% 1,681 3%
Crim Just ‐ Pop 7,006 6,044 7,278 272 4% 1,233 20%
Crim Just ‐ Spec Prog 25,487 22,472 26,365 878 3% 3,893 17%
State DUI 3,863 4,413 3,796 (67) ‐2% (617) ‐14%
Marijuana Enforcement ‐ ‐ ‐ ‐ N/A ‐ N/A
Liquor Profits ‐ ‐ ‐ ‐ N/A ‐ N/A
Liquor Excise Tax 113,721 104,301 119,489 5,767 5% 15,188 15%
Fuel Tax 111,774 110,614 113,558 1,785 2% 2,944 3%
YTD Total 543,102$ 525,336$ 569,772$ 26,670$ 5% 44,435$ 8%
Annual Total 6,145,527$ 5,942,169$
2018 vs. Budget
State Shared Revenues
2018 vs. 2017
Revenue
Year to Date through January
Page 6 of 37
Monthly Financial Report January 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
56% of the total revenue in this category. The year‐to‐date total charges for services are $852K or 10% of the budget. The
following sections provide detail information for Public Safety, Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totaled
$225K 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 $161K or 249%
more. Compared to the year‐to‐
date budget, the City is over
budget by $168K or 295%. The
variance with the prior year is
due to collecting large
reimbursements for the School
Resource Officer program.
Recreation
Recreation revenues totaled
$138K for the current month.
Compared to the same month
the prior year, the City collected
$14K or 9% less. Compared to
the projected monthly budget,
the City collected $27K or 16%
less.
2017 2018 2018
Actual Budget Actual $ % $ %
Jan 64,424$ 57,002$ 224,932$ 160,509$ 249% 167,930$ 295%
Feb 68,705 56,753 ‐
Mar 148,707 69,703 ‐
Apr 61,399 37,896 ‐
May 63,815 37,767 ‐
Jun 43,374 75,004 ‐
Jul 59,850 31,948 ‐
Aug 58,114 34,576 ‐
Sep 53,908 40,957 ‐
Oct 52,056 71,643 ‐
Nov 77,748 49,060 ‐
Dec 85,628 55,327 ‐
YTD Total 64,424$ 57,002$ 224,932$ 160,509$ 249% 167,930$ 295%
Annual Total 837,728$ 617,635$
Year to Da te through January
Public Safety Services
2018 vs. 2017 2018 vs. Budget
Month
2017 2018 2018
Actual Budget Actual $ % $ %
Jan 152,350$ 165,445$ 138,388$ (13,962)$ ‐9% (27,057)$ ‐16%
Feb 38,452 45,248 ‐
Mar 65,420 65,959 ‐
Apr 74,806 98,092 ‐
May 84,381 81,970 ‐
Jun 153,304 205,712 ‐
Jul 482,458 422,598 ‐
Aug 382,296 383,056 ‐
Sep 135,476 127,239 ‐
Oct 49,113 49,623 ‐
Nov 58,320 66,278 ‐
Dec 45,946 44,704 ‐
YTD Total 152,350$ 165,445$ 138,388$ (13,962)$ ‐9% (27,057)$ ‐16%
Annual Total 1,722,323$ 1,755,923$
Recreation
Year to Da te through January
2018 vs. Budget2018 vs. 2017
Month
Page 7 of 37
Monthly Financial Report January 2018
Interfund Services
The year‐to‐date collections for
Interfund Services revenues are
$342K. Compared to the prior
year, the revenues are over by
$11K or 3%. Compared to the
projected budget, the revenues
are below by $22K or 6%. 2017’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
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
$142K. This is $7K or 5% higher
than a year ago and $61K or 30%
lower than the budget.
2017 2018 2018
Actual Budget Actual $ % $ %
Jan 330,774$ 363,424$ 341,804$ 11,030$ 3% (21,619)$ ‐6%
Feb 319,851 363,424 ‐
Mar 377,192 363,424 ‐
Apr 332,180 363,424 ‐
May 332,543 363,424 ‐
Jun 322,435 363,424 ‐
Jul 314,856 363,424 ‐
Aug 295,921 363,424 ‐
Sep 350,908 363,424 ‐
Oct 321,038 363,424 ‐
Nov 316,488 363,424 ‐
Dec 302,147 363,424 ‐
YTD Total 330,774$ 363,424$ 341,804$ 11,030$ 3% (21,619)$ ‐6%
Annual Total 3,916,334$ 4,361,086$
Interfund Services
Ye ar to Date through January
2018 vs. 2017 2018 vs. Budget
Month
2017 2018 2018
Actual Budget Actual $ % $ %
Jan 134,957$ 202,466$ 141,625$ 6,668$ 5% (60,841)$ ‐30%
Feb 217,056 304,761
Mar 212,186 326,326
Apr 242,816 334,935
May 229,877 307,640
Jun 302,666 394,406
Jul 247,260 323,718
Aug 298,685 368,664
Sep 220,425 286,907
Oct 274,245 357,604
Nov 240,739 355,833
Dec 325,938 417,895
YTD Total 134,957$ 202,466$ 141,625$ 6,668$ 5% (60,841)$ ‐30%
Annual Total 2,946,849$ 3,981,154$
2018 vs. Budget2018 vs. 2017
Year to Da te through January
Fines and Penalties by Month
Month
Year to Date through January
2017 2018 2018
Actual Budget Actual $ % $ %
Civil Penalties ‐$ ‐$ ‐$ ‐$ N/A ‐$ N/A
Civil Infraction Penalties ‐ ‐ ‐ ‐ N/A ‐ N/A
Civil Parking Infraction Penalties ‐ ‐ ‐ ‐ N/A ‐ N/A
Photo Enforcement Program 127,976 200,059 136,853 8,877 7% (63,206) ‐32%
Criminal Traffic Misdemeanor Fines ‐ ‐ ‐ ‐ N/A ‐ N/A
Criminal Non‐Traffic Fines 2,485 1,313 2,287 (198) ‐8% 974 74%
Criminal Costs ‐ ‐ ‐ ‐ N/A ‐ N/A
Non‐Court Fines, Forfeitures and Penalties 4,496 1,093 2,485 (2,011) ‐45% 1,392 127%
YTD Total 134,957$ 202,466$ 141,625$ 6,668$ 5% (60,841)$ ‐30%
Annual Total 2,946,849$ 3,981,154$
Revenue
2018 vs. Budget
Fines and Penalties by Type
2018 vs. 2017
Page 8 of 37
Monthly Financial Report January 2018
Included in the Fines and Penalties
revenue budget is $2M 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 $137K.
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
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. The year‐to‐date total
miscellaneous is $263K.
Compared to last year, the
revenues are below by $101K or
28%. Compared to the projected
year‐to‐date budget, the
revenues are over by $36K or
16%. The large variance with the
prior year is due to collecting
more than anticipated Seizure
Funds in 2017. Seizure Funds are
restricted to drug enforcement only and are not available for general operating purposes.
Favorable
18 Budget 18 Actual 18 Budget 18 Actual (Unfavorable)
1
Jan 200,059$ 136,853$ 121,775$ 27,432$ 109,421$
Feb 245,606 ‐ 121,775 ‐ ‐
Mar 255,819 ‐ 121,775 ‐ ‐
Apr 254,361 ‐ 121,775 ‐ ‐
May 245,760 ‐ 121,775 ‐ ‐
Jun 320,341 ‐ 121,775 ‐ ‐
Jul 253,555 ‐ 121,775 ‐ ‐
Aug 292,777 ‐ 121,775 ‐ ‐
Sep 214,081 ‐ 121,775 ‐ ‐
Oct 293,253 ‐ 121,775 ‐ ‐
Nov 285,573 ‐ 121,775 ‐ ‐
Dec 289,886 ‐ 121,775 ‐ ‐
YTD Total 200,059$ 136,853$ 121,775$ 27,432$ 109,421$
Annual Total 3,151,072$ 1,461,297$
1Actuals of Revenues and Expenses
ExpensesRevenues
Photo Enforcement Program
Year to Date through January
Month
2017 2018 2018
Actual Budget Actual $ % $ %
Jan 363,997$ 226,336$ 262,690$ (101,308)$ ‐28% 36,354$ 16%
Feb 148,988 104,377
Mar 150,954 106,591
Apr 188,887 113,950
May 152,678 116,937
Jun 179,152 142,288
Jul 193,718 157,194
Aug 198,576 161,026
Sep 151,310 124,685
Oct 156,212 117,382
Nov 125,698 95,292
Dec 468,107 358,060
YTD Total 363,997$ 226,336$ 262,690$ (101,308)$ ‐28% 36,354$ 16%
Annual Total 2,478,278$ 1,824,117$
Year to Date through January
Month
2018 vs. Budget2018 vs. 2017
Miscellaneous Revenues by Month
2017 2018 2018
Actual Budget Actual $ % $ %
Interests and Other Earnings 59,675$ 43,837$ 76,546$ 16,871$ 28% 32,710$ 75%
Rents, Leases, and Concessions 164,492 152,983 155,535 (8,957) ‐5% 2,552 2%
Contributions/Donations from Private Sources 575 147 ‐ (575) 0% (147) 0%
Other 37,500 29,369 25,514 (11,986) ‐32% (3,855) ‐13%
Seizure Funds ‐ Federal/State/Local 101,755 ‐ 5,094 (96,661) ‐95% 5,094 100%
YTD Total 363,997$ 226,336$ 262,690$ (101,308)$ ‐28% 36,354$ 16%
Annual Total 2,478,278$ 1,824,117$
2018 vs. Budget
Miscellaneous Revenues by Type
Year to Date through January
Revenue
2018 vs. 2017
Page 9 of 37
Monthly Financial Report January 2018
EXPENSES
Overall the City has expended 7% of its budgeted general governmental expenditures at the end of January. This is $280K or
3.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 $1K or 3.8%. This is due to the spending patterns of supplies and
professional services in 2016/2017 compared to 2018.
Executive department is over the year‐to‐date budget by $10K or 4.1%. This is due to the spending patterns of
salaries/benefits (vacancy in 2017) and professional services in 2016/2017 compared to 2018.
Court Services department is over the year‐to‐date budget by $6K or 3.2%. This is due to the spending patterns of professional
services in 2016/2017 compared to 2018.
Public Works (Administration, Street Maintenance, and Transportation) is over the year‐to‐date budget by $21K or 2.6%. This
is due to the spending patterns of supplies, utility charges, and interfund charges in 2016/2017 compared to 2018.
Page 10 of 37
Monthly Financial Report January 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 ‐ ‐ ‐ ‐ 8,400 5,100 ‐
Grants / intergovernmental ‐ ‐ ‐ ‐ ‐ ‐ ‐
Charges for services 21,955 60,471 570 1,317,994 887,625 1,045,751 1,431,262
Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐
Fines and penalties 6 ‐ ‐ ‐ ‐ ‐ ‐
Rents, leases, and misc fees 212,876 5,421 ‐ 40,165 ‐ ‐ ‐
Interest and other misc 2,906 248 2,916 132,281 91,956 11,708 5,227
TOTAL REVENUES 237,743 66,140 3,486 1,490,440 987,981 1,062,559 1,436,489
EXPENSES:
Utility billing ‐ ‐ 3,492 17,824 14,944 24,717 ‐
Utility systems ‐ ‐ 224,291 288,290 267,401 224,323 ‐
Utility maintenance ‐ ‐ 31,309 366,895 174,353 262,454 1,367,564
Transportation 123,513 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 143,994 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 123,513 143,994 259,092 673,009 456,698 511,494 1,367,564
AMOUNT AVAILABLE FOR DEBT SERVICE 114,230 (77,854) (255,606) 817,431 531,283 551,065 68,925
DEBT SERVICE:
Principal ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest ‐ ‐ ‐ ‐ ‐ 43,337 ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ ‐ ‐ 43,337 ‐
CAPITAL PROJECTS ‐ ‐ ‐ 9,981 8,518 8,409 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 114,230 (77,854) (255,606) 807,450 522,765 499,319 68,925
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, Jan 31 3,573,419 (72,587) 2,744,706 34,721,017 17,932,767 14,434,024 5,158,694
Page 11 of 37
Monthly Financial Report January 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 ‐ 15,175 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ ‐ ‐ ‐ ‐ ‐ ‐
Charges for services
Equipment rental m&o 175,293 360,712 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ ‐ ‐ 37,048 ‐ ‐ ‐
Communications ‐ ‐ ‐ 54,738 ‐ ‐ ‐
Facilities ‐ ‐ 338,572 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ ‐ ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest and other misc 5,656 3,090 1,381 504 14,369 3,712 9,575
Internal service fund misc:
Vehicle / equipment capital recovery 173,511 17,585 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 144,136 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 107,782 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 772,521 218,720
Other misc 60 ‐ ‐ ‐ ‐ 77,646 ‐
Interfund Loan ‐ ‐ ‐ ‐ ‐ ‐ ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets ‐ ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 185,530 ‐ ‐
TOTAL REVENUES 354,520 396,562 339,953 92,290 451,817 853,879 228,295
EXPENSES:
Communications 48,735
Equipment rental 133,030
Facilities 238,327
Healthcare 819,232
Information technology 323,527
Print and mail 25,189
Retiree healthcare 47,966
Risk management:
Risk management 348,601
Unemployment 9,614
Worker's compensation 130,142
TOTAL EXPENSES 133,030 323,527 238,327 73,924 488,357 819,232 47,966
AMOUNT AVAILABLE FOR CAPITAL 221,490 73,035 101,626 18,366 (36,540) 34,647 180,329
CAPITAL PROJECTS ‐ 54,094 ‐ ‐ ‐ ‐ ‐
TRANSFERS IN ‐ ‐ ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 221,490 18,941 101,626 18,366 (36,540) 34,647 180,329
BEGINNING FUND BALANCE, Ja n 1 6,882,620 3,737,060 1,530,747 608,145 17,731,130 4,617,488 11,887,344
ENDING FUND BALANCE, Jan 31 7,104,110 3,756,001 1,632,373 626,511 17,694,590 4,652,135 12,067,673
Page 12 of 37
Monthly Financial Report January 2018
FUND BALANCE
Page 14 shows the ending fund balance as of January 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 January, the City has $34.6M reported in the combined general governmental fund balance of the current year’s
operating budget, which is approximately 35% of budgeted operating expenditures. This is an increase of $1.3M from the
year’s beginning balance. January’s ending fund balance is over the anticipated General Governmental Fund Balance of
$21.7M by $13M or 59.8%. 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 13 of 37
Monthly Financial Report January 2018
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through January 31, 2018
Funds
Balance
01/01/2018
Budgeted
Revenue
Revenue
01/31/18
Total Funds
Available
Budgeted
Expenditure
Expenditure
01/31/18 Ending Balance
GENERAL GOVERNMENT FUNDS: 33,284,838 100,191,383 8,189,596 41,474,434 98,302,133 6,868,916 34,605,518
000 General 22,708,066 69,157,742 6,786,740 29,494,806 67,041,323 5,202,949 24,291,857
001 Community Services 4,840,993 13,425,796 910,581 5,751,574 13,443,212 805,296 4,946,278
003 Street 3,143,904 11,288,240 490,239 3,634,143 11,378,757 794,958 2,839,185
004 Community Dev Block Grant 54,286 424,857 ‐ 54,286 424,857 3,432 50,854
005 Museum 70,992 239,129 57 71,049 241,246 19,889 51,160
009 Farmers Market 105,323 59,400 86 105,409 69,494 4,396 101,013
201 Ltd GO Bonds Gen Govt Debt 863,732 ‐ 693 864,425 ‐ ‐ 864,425
215 Gen Govt Misc Debt Service 1,497,542 5,596,219 1,201 1,498,743 5,703,244 37,996 1,460,747
SPECIAL REVENUE FUNDS:2,093,053 1,950,224 202,587 2,295,640 1,892,764 50,307 2,245,333
102 Arterial Street 108,438 670,000 53,526 161,964 670,000 ‐ 161,964
108 Leased City Properties 611,055 902,550 98,260 709,315 845,090 48,619 660,696
110 Hotel Motel 461,434 265,000 31,552 492,986 265,000 1,688 491,298
125 1% For Art 103,109 15,000 83 103,192 15,000 ‐ 103,192
127 Cable Communication 472,489 97,674 18,895 491,384 97,674 ‐ 491,384
135 Springbrook Wetlands Bank 336,528 ‐ 271 336,799 ‐ ‐ 336,799
CAPITAL PROJECT FUNDS (CIP):36,295,483 9,410,400 2,415,878 38,711,361 13,039,521 71,403 38,639,958
303 Community Services Mitigation 1,909,355 86,500 39,044 1,948,399 ‐ ‐ 1,948,399
304 Fire Mitigation 936,972 99,000 11,219 948,191 142,975 ‐ 948,191
305 Transportation Mitigation 810,962 632,400 81,692 892,654 5,000 ‐ 892,654
316 Municipal Facilities CIP 19,671,696 4,627,000 1,677,658 21,349,354 8,926,046 47,833 21,301,521
317 Transportation CIP 5,808,539 3,965,500 450,499 6,259,038 3,965,500 23,570 6,235,468
326 Housing Opportunity 2,548,975 ‐ 2,054 2,551,029 ‐ ‐ 2,551,029
336 New Library Development 451,093 ‐ 357 451,450 ‐ ‐ 451,450
346 New Family First Center Dvlpmnt 4,157,891 ‐ 153,355 4,311,246 ‐ ‐ 4,311,246
ENTERPRISE FUNDS:76,812,811 83,652,598 5,285,675 82,098,486 92,373,701 3,606,446 78,492,040
4X2 Airport Operating & CIP 3,459,189 4,531,809 237,743 3,696,932 4,552,790 123,513 3,573,419
403 Solid Waste Utility 3,000,312 19,505,718 3,486 3,003,798 19,368,508 259,092 2,744,706
4X4 Golf Operating & CIP 5,267 2,912,920 66,977 72,244 2,728,654 144,831 (72,587)
4X5 Water Operating & CIP 33,913,567 17,420,439 1,490,440 35,404,007 21,538,687 682,990 34,721,017
4X6 Waste Water Operating & CIP 17,410,002 10,076,333 987,981 18,397,983 12,084,986 465,216 17,932,767
416 King County Metro 5,089,769 17,505,693 1,436,489 6,526,258 17,505,693 1,367,564 5,158,694
4X7 Surface Water Operating & CIP 13,934,705 11,699,686 1,062,559 14,997,264 14,594,383 563,240 14,434,024
INTERNAL SERVICE FUNDS: 46,994,534 30,283,478 2,717,315 49,711,849 31,616,210 2,178,459 47,533,390
501 Equipment Repair/Replacement 6,882,620 6,026,729 354,519 7,237,139 6,989,962 133,030 7,104,109
502 Insurance 17,731,130 3,307,514 451,817 18,182,947 3,315,116 488,358 17,694,589
503 Information Services 3,737,060 5,510,230 396,562 4,133,622 5,563,704 377,622 3,756,000
504 Facilities 1,530,747 4,887,148 339,953 1,870,700 4,978,288 238,327 1,632,373
505 Communications 608,145 1,102,300 92,290 700,435 1,096,329 73,924 626,511
512 Insurance, Healthcare 4,617,488 8,191,708 853,879 5,471,367 8,578,084 819,232 4,652,135
522 Insurance, Leoff1 Retirees HC 11,887,344 1,257,849 228,295 12,115,639 1,094,727 47,966 12,067,673
FIDUCIARY FUNDS: 5,832,897 468,000 2,872 5,835,769 200,475 19,633 5,816,136
611 Firemen's Pension 5,832,897 468,000 2,872 5,835,769 200,475 19,633 5,816,136
TOTAL FUNDS 201,313,616 225,956,083 18,813,923 220,127,539 237,424,804 12,795,164 207,332,375
Page 14 of 37
City of Renton
General Government Financial Position
2018 Budget Year
General Government Summary
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
March
April
May
June
July
August
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
‐
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 15 of 37
City of Renton
Monthly Revenue Analysis ‐ 2018 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,921,333 8,189,596 3.39%
Feb 14,456,967
Mar 20,967,626
Apr 33,049,752
May 43,714,613
Jun 49,967,964
Jul 57,841,252
Aug 64,578,816
Sep 70,897,922
Oct 81,916,928
Nov 93,260,810
Dec 100,191,383
Percent of budget 8.17%
Property Tax Budget
YTD
Actual
Annual %
over (under)
Jan 31,649 (12,745) ‐140.27%
Feb 192,923
Mar 880,619
Apr 5,585,498
May 10,133,810
Jun 10,218,049
Jul 10,258,103
Aug 10,366,119
Sep 10,682,507
Oct 13,934,125
Nov 19,305,972
Dec 19,397,308
Percent of budget ‐0.07%
$‐
$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
Page 16 of 37
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
Mar 7,092,465
Apr 9,200,855
May 11,717,901
Jun 13,938,141
Jul 16,253,766
Aug 18,828,019
Sep 21,239,052
Oct 23,758,560
Nov 26,381,491
Dec 28,803,740
Percent of budget 8.61%
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
Mar 4,135,571
Apr 5,628,573
May 6,970,433
Jun 8,143,555
Jul 9,485,903
Aug 10,640,985
Sep 11,865,442
Oct 13,187,689
Nov 14,330,720
Dec 15,664,124
Percent of budget 8.91%
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
Page 17 of 37
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
Mar 1,389,734
Apr 1,687,685
May 2,112,005
Jun 2,486,234
Jul 2,878,222
Aug 3,285,243
Sep 3,652,920
Oct 4,043,793
Nov 4,367,374
Dec 4,636,213
Percent of budget 11.39%
Note: GF only
Intergovt'l Budget
YTD
Actual
Annual %
over (under)
Jan 595,670 601,356 0.95%
Feb 1,189,782
Mar 1,735,985
Apr 2,262,908
May 2,645,100
Jun 3,236,786
Jul 3,779,451
Aug 4,382,470
Sep 4,976,677
Oct 5,573,144
Nov 6,003,005
Dec 6,875,678
Percent of budget 8.75%
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
Page 18 of 37
City of Renton
Monthly Revenue Analysis ‐ 2018 Budget Year
Charges for
Services Budget
YTD
Actual
Annual %
over (under)
Jan 736,093 851,592 15.69%
Feb 1,321,490
Mar 1,970,833
Apr 2,605,597
May 3,287,512
Jun 4,174,426
Jul 5,126,226
Aug 6,077,798
Sep 6,739,843
Oct 7,381,352
Nov 8,038,314
Dec 8,780,388
Percent of budget 9.70%
Note: Excludes FD25 & FD40 contracts
Fines &
Forfeits Budget
YTD
Actual
Annual %
over (under)
Jan 202,466 141,625 ‐30.05%
Feb 507,227
Mar 833,552
Apr 1,168,487
May 1,476,127
Jun 1,870,533
Jul 2,194,251
Aug 2,562,915
Sep 2,849,822
Oct 3,207,426
Nov 3,563,259
Dec 3,981,154
Percent of budget 3.56%
$‐
$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
Page 19 of 37
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
Mar 2,455,818
Apr 4,311,237
May 4,643,962
Jun 5,018,275
Jul 6,814,257
Aug 7,211,253
Sep 7,531,044
Oct 9,340,928
Nov 9,673,557
Dec 10,085,686
Percent of budget 19.24%
Misc Budget
YTD
Actual
Annual %
over (under)
Jan 226,336 262,690 16.06%
Feb 330,713
Mar 437,304
Apr 551,253
May 668,190
Jun 810,478
Jul 967,672
Aug 1,128,698
Sep 1,253,383
Oct 1,370,765
Nov 1,466,057
Dec 1,824,117
Percent of budget 14.40%
$‐
$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
Page 20 of 37
City of Renton
Monthly Revenue Analysis ‐ 2018 Budget Year
Other
Financing Budget
YTD
Actual
Annual %
over (under)
Jan 11,915 ‐ 0.00%
Feb 23,829
Mar 35,744
Apr 47,658
May 59,573
Jun 71,488
Jul 83,402
Aug 95,317
Sep 107,231
Oct 119,146
Nov 131,060
Dec 142,975
Percent of budget 0.00%
REET Budget
YTD
Actual
Annual %
over (under)
Jan 786,056 840,316 6.90%
Feb 996,074
Mar 1,388,016
Apr 1,654,828
May 1,955,479
Jun 2,413,482
Jul 2,853,657
Aug 3,360,851
Sep 3,792,293
Oct 4,100,637
Nov 4,499,171
Dec 4,420,000
Percent of budget 19.01%
$‐
$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
Page 21 of 37
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
Mar 1,517,506
Apr 1,839,013
May 2,338,784
Jun 2,899,199
Jul 3,287,609
Aug 3,731,695
Sep 4,173,216
Oct 4,609,871
Nov 5,024,686
Dec 5,451,699
Percent of budget 5.77%
B & O Tax Budget
YTD
Actual
Annual %
over (under)
Jan 1,527,200 1,301,574 ‐14.77%
Feb 1,718,100
Mar 1,909,000
Apr 3,436,200
May 3,627,100
Jun 3,818,000
Jul 5,345,200
Aug 5,536,100
Sep 5,727,000
Oct 7,254,200
Nov 7,445,100
Dec 7,636,000
Percent of budget 17.05%
$‐
$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
Page 22 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2018 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,148,422 6,868,916 ‐3.91%
Feb 15,152,603
Mar 23,171,096
Apr 30,885,119
May 39,100,982
Jun 46,910,079
Jul 55,626,922
Aug 63,991,756
Sep 72,419,060
Oct 80,682,382
Nov 88,548,122
Dec 98,302,133
Percent of budget expended 6.99%
Legislative Budget
YTD
Actual
Annual %
over (under)
Jan 36,796 38,187 3.78%
Feb 67,098
Mar 102,377
Apr 133,436
May 163,576
Jun 194,460
Jul 224,009
Aug 253,784
Sep 283,711
Oct 313,912
Nov 343,921
Dec 374,666
Percent of budget expended 10.19%
$‐
$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
Page 23 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2018 Budget Year
Executive Budget
YTD
Actual
Annual %
over (under)
Jan 213,846 216,805 1.38%
Feb 356,276
Mar 517,667
Apr 661,491
May 815,091
Jun 982,365
Jul 1,128,324
Aug 1,301,290
Sep 1,461,900
Oct 1,621,094
Nov 1,764,444
Dec 1,977,556
Percent of budget expended 10.96%
Emergency
Management Budget
YTD
Actual
Annual %
over (under)
Jan 38,727 46,027 18.85%
Feb 81,139
Mar 134,576
Apr 185,443
May 232,748
Jun 280,829
Jul 329,887
Aug 405,522
Sep 458,997
Oct 509,656
Nov 559,051
Dec 606,070
Percent of budget expended 7.59%
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
Millions Executive
Budget
Actual
Last Year
$‐
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
Emergency Management
Budget
Actual
Last Year
Page 24 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2018 Budget Year
City Attorney Budget
YTD
Actual
Annual %
over (under)
Jan 179,986 177,424 ‐1.42%
Feb 365,070
Mar 556,653
Apr 754,725
May 942,040
Jun 1,129,239
Jul 1,318,120
Aug 1,507,141
Sep 1,698,115
Oct 1,885,878
Nov 2,072,809
Dec 2,251,312
Percent of budget expended 7.88%
Court Services Budget
YTD
Actual
Annual %
over (under)
Jan 176,384 182,051 3.21%
Feb 359,319
Mar 546,315
Apr 734,460
May 920,481
Jun 1,108,912
Jul 1,293,945
Aug 1,479,202
Sep 1,674,344
Oct 1,861,659
Nov 2,050,602
Dec 2,250,644
Percent of budget expended 8.09%
$‐
$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
Page 25 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2018 Budget Year
CED Admin Budget
YTD
Actual
Annual %
over (under)
Jan 109,150 111,659 2.30%
Feb 218,777
Mar 328,405
Apr 438,243
May 548,295
Jun 663,572
Jul 774,577
Aug 885,667
Sep 996,682
Oct 1,107,057
Nov 1,217,230
Dec 1,339,679
Percent of budget expended 8.33%
Development
Services Budget
YTD
Actual
Annual %
over (under)
Jan 264,886 239,592 ‐9.55%
Feb 557,415
Mar 839,090
Apr 1,124,291
May 1,413,022
Jun 1,709,057
Jul 2,002,344
Aug 2,298,315
Sep 2,614,096
Oct 2,912,089
Nov 3,235,237
Dec 3,451,529
Percent of budget expended 6.94%
$‐
$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
Page 26 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2018 Budget Year
Economic
Development Budget
YTD
Actual
Annual %
over (under)
Jan 55,791 54,919 ‐1.56%
Feb 118,706
Mar 176,662
Apr 274,608
May 404,414
Jun 515,396
Jul 605,115
Aug 689,812
Sep 792,413
Oct 910,947
Nov 1,002,828
Dec 1,122,610
Percent of budget expended 4.89%
Planning Budget
YTD
Actual
Annual %
over (under)
Jan 266,956 230,023 ‐13.83%
Feb 541,213
Mar 823,680
Apr 1,100,866
May 1,394,553
Jun 1,683,599
Jul 1,961,865
Aug 2,251,300
Sep 2,541,336
Oct 2,819,947
Nov 3,095,613
Dec 3,473,927
Percent of budget expended 6.62%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
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
Page 27 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2018 Budget Year
Finance Budget
YTD
Actual
Annual %
over (under)
Jan 245,302 215,045 ‐12.33%
Feb 504,770
Mar 747,503
Apr 1,007,347
May 1,267,911
Jun 1,549,875
Jul 1,829,962
Aug 2,138,964
Sep 2,392,432
Oct 2,653,584
Nov 2,907,801
Dec 3,628,725
Percent of budget expended 5.93%
City Clerk Budget
YTD
Actual
Annual %
over (under)
Jan 79,458 73,376 ‐7.65%
Feb 301,896
Mar 387,290
Apr 475,507
May 564,629
Jun 655,905
Jul 750,959
Aug 909,171
Sep 928,629
Oct 1,017,318
Nov 1,112,561
Dec 1,250,565
Percent of budget expended 5.87%
Includes Hearing Examiner
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
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
Page 28 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2018 Budget Year
Human
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 100,796 93,068 ‐7.67%
Feb 204,801
Mar 324,936
Apr 448,888
May 558,639
Jun 668,238
Jul 780,343
Aug 900,878
Sep 1,015,333
Oct 1,137,950
Nov 1,248,675
Dec 1,370,877
Percent of budget expended 6.79%
Police Budget
YTD
Actual
Annual %
over (under)
Jan 3,244,286 3,128,806 ‐3.56%
Feb 6,148,434
Mar 9,555,956
Apr 12,508,356
May 15,845,284
Jun 18,835,493
Jul 22,469,382
Aug 25,517,304
Sep 28,931,676
Oct 31,961,399
Nov 35,153,006
Dec 38,918,561
Percent of budget expended 8.04%
$‐
$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
Page 29 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2018 Budget Year
Community
Services Admin Budget
YTD
Actual
Annual %
over (under)
Jan 44,259 39,217 ‐11.39%
Feb 90,786
Mar 129,908
Apr 167,621
May 208,993
Jun 245,893
Jul 284,078
Aug 322,361
Sep 359,818
Oct 397,782
Nov 435,311
Dec 523,015
Percent of budget expended 7.50%
Parks Budget
YTD
Actual
Annual %
over (under)
Jan 345,400 313,568 ‐9.22%
Feb 702,198
Mar 1,092,648
Apr 1,507,860
May 1,911,044
Jun 2,347,576
Jul 2,827,625
Aug 3,334,991
Sep 3,864,453
Oct 4,312,325
Nov 4,722,180
Dec 5,219,050
Percent of budget expended 6.01%
$‐
$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
Page 30 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2018 Budget Year
Parks Planning
and Natural
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 62,879 57,925 ‐7.88%
Feb 153,203
Mar 232,682
Apr 315,258
May 421,728
Jun 538,667
Jul 638,981
Aug 770,429
Sep 889,537
Oct 990,768
Nov 1,104,739
Dec 1,266,373
Percent of budget expended 4.57%
Recreation Budget
YTD
Actual
Annual %
over (under)
Jan 408,633 446,821 9.35%
Feb 860,914
Mar 1,326,264
Apr 1,801,571
May 2,249,644
Jun 2,746,156
Jul 3,458,309
Aug 4,201,750
Sep 4,842,832
Oct 5,313,670
Nov 5,777,349
Dec 6,256,963
Percent of budget expended 7.14%
$‐
$200,000
$400,000
$600,000
$800,000
$1,000,000
$1,200,000
$1,400,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
Page 31 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2018 Budget Year
Human
Services Budget
YTD
Actual
Annual %
over (under)
Jan 82,084 55,197 ‐32.76%
Feb 175,427
Mar 239,643
Apr 332,825
May 451,498
Jun 507,644
Jul 624,057
Aug 735,309
Sep 792,110
Oct 950,123
Nov 1,055,851
Dec 1,311,570
Percent of budget expended 4.21%
Neighborhoods
, Resources,
and Events Budget
YTD
Actual
Annual %
over (under)
Jan 16,990 (47,839) ‐381.57%
Feb 36,113
Mar 55,134
Apr 71,613
May 89,983
Jun 107,976
Jul 134,849
Aug 158,925
Sep 179,742
Oct 200,163
Nov 217,772
Dec 247,305
Percent of budget expended ‐19.34%
$‐
$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)
$‐
$200,000
$400,000
$600,000
$800,000
$1,000,000
$1,200,000
Neighborhoods, Resources, and Events
Budget
Actual
Last Year
Page 32 of 37
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
Mar 59,393
Apr 79,159
May 98,532
Jun 118,175
Jul 138,557
Aug 158,827
Sep 179,495
Oct 200,268
Nov 220,924
Dec 241,246
Percent of budget expended 8.24%
Public Works
Admin Budget
YTD
Actual
Annual %
over (under)
Jan 34,486 34,521 0.10%
Feb 69,669
Mar 104,789
Apr 139,642
May 174,360
Jun 209,285
Jul 244,157
Aug 279,239
Sep 314,679
Oct 348,881
Nov 383,025
Dec 417,024
Percent of budget expended 8.28%
$‐
$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
Page 33 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2018 Budget Year
Street
Maintenance Budget
YTD
Actual
Annual %
over (under)
Jan 424,687 428,817 0.97%
Feb 905,984
Mar 1,375,480
Apr 1,884,464
May 2,359,985
Jun 2,819,975
Jul 3,273,955
Aug 3,730,797
Sep 4,205,894
Oct 4,668,893
Nov 5,111,602
Dec 5,587,710
Percent of budget expended 7.67%
Transportation Budget
YTD
Actual
Annual %
over (under)
Jan 349,016 366,141 4.91%
Feb 722,719
Mar 1,158,018
Apr 1,596,075
May 2,137,819
Jun 2,579,738
Jul 3,036,128
Aug 3,478,037
Sep 3,932,755
Oct 4,733,597
Nov 5,116,826
Dec 5,791,047
Percent of budget expended 6.32%
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.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
Page 34 of 37
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 950,541
Mar 1,425,811
Apr 1,901,081
May 2,376,352
Jun 2,851,622
Jul 3,326,892
Aug 3,802,163
Sep 4,277,433
Oct 4,752,703
Nov 5,227,974
Dec 5,703,244
Percent of budget expended 0.67%
Non‐
Departmental
Other City Budget
YTD
Actual
Annual %
over (under)
Jan 309,681 309,681 0.00%
Feb 620,144
Mar 930,216
Apr 1,240,288
May 1,550,360
Jun 1,860,432
Jul 2,170,504
Aug 2,480,576
Sep 2,790,648
Oct 3,100,720
Nov 3,410,792
Dec 3,720,864
Percent of budget expended 8.32%
$‐
$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
Page 35 of 37
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2018 Budget Year
Utilities Budget Revenue Expense
Jan 3,982,954 4,980,942 3,338,103
Feb 8,679,714
Mar 13,675,652
Apr 21,105,708
May 27,294,382
Jun 34,248,822
Jul 42,732,840
Aug 49,378,807
Sep 61,633,041
Oct 67,327,896
Nov 75,168,661
Dec 85,092,257
Percent of budget expended 3.17%
Note: Operations and Capital
Airport Budget Revenue Expense
Jan 364,906 237,743 123,513
Feb 678,730
Mar 902,636
Apr 1,246,144
May 1,556,826
Jun 1,859,541
Jul 2,365,174
Aug 2,663,519
Sep 3,085,835
Oct 3,382,495
Nov 4,036,503
Dec 4,552,790
Percent of budget expended 2.71%
Note: Operations and Capital
$0
$10
$20
$30
$40
$50
$60
$70
$80
$90
Millions Utilities
Budget
Revenue
Expense
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
Millions Airport
Budget
Revenue
Expense
Page 36 of 37
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2018 Budget Year
Golf Course Budget Revenue Expense
Jan 153,642 66,977 144,831
Feb 377,249
Mar 568,683
Apr 811,999
May 1,025,759
Jun 1,265,001
Jul 1,614,536
Aug 1,842,643
Sep 2,085,914
Oct 2,317,518
Nov 2,525,822
Dec 2,728,654
Percent of budget expended 5.31%
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 37 of 37