HomeMy WebLinkAbout201802, February
h:\finance\financial reporting\monthly reports\2018 reports\cover 0218.docx
ADMINISTRATIVE SERVICES
M E M O R A N D U M
DATE: April 3, 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: February 2018 Financial Status Report
At the end of February, general governmental revenues show $1.9M or 13.1% over
budget. Revenue source(s) that are higher than expected are: sales tax ($465K); sales tax
annexation credit ($243K); utility taxes ($127K); gambling taxes ($151K); business &
occupation taxes ($907K); business license ($282K); and public safety ($172K). On the
down side, the revenue source(s) that are underperforming the year to date budget are:
building permits & development service fees ($341K below) and fines/penalties ($141K
below).
General government expenditures showed a favorable variance of $347K or 2.4%. 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
April 3, 2018
h:\finance\financial reporting\monthly reports\2018 reports\cover 0218.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 359,864 24,356,562 250,761 19,397,308 192,923 93,620 (99,303) ‐51.5%
Sales Tax 26,353,246 4,299,027 26,331,634 4,566,536 26,683,440 4,591,999 5,056,993 464,994 10.1%
Sales Tax ‐ Annexation Credit 3,114,762 508,330 3,123,230 540,877 2,120,300 356,626 600,038 243,412 68.3%
Criminal Justice Sa les Tax 2,701,787 474,407 2,808,564 483,778 2,782,404 483,827 528,481 44,653 9.2%
Natural Gas Use Tax 184,638 47,577 180,456 38,784 228,000 49,002 32,007 (16,995) ‐34.7%
Admission Tax 262,506 77,752 223,157 63,529 320,000 93,089 58,071 (35,019) ‐37.6%
Franchise Fees 1,406,092 348,118 1,562,100 387,170 1,330,000 329,471 388,058 58,587 17.8%
Electricity Tax 5,440,139 1,091,698 5,721,366 1,119,319 5,476,959 1,084,948 751,918 (333,029) ‐30.7%
Natural Ga s Utility Tax 1,327,937 388,344 1,630,375 474,022 1,350,900 393,796 761,135 367,340 93.3%
Garbage/Solid Waste 717,148 101,043 627,254 96,335 680,000 99,834 112,897 13,063 13.1%
TV Cable 1,619,364 235,742 1,651,405 240,964 1,662,115 242,249 233,140 (9,109) ‐3.8%
Telephone 859,868 173,049 866,519 161,207 729,131 141,171 127,651 (13,520) ‐9.6%
Cellular Phone 1,541,204 313,355 1,481,298 298,767 1,536,267 311,127 200,307 (110,820) ‐35.6%
City Utilities 4,206,473 645,273 4,840,530 629,913 4,000,752 563,911 794,302 230,391 40.9%
Utility Tax Audit 111,227 111,227 ‐ ‐ ‐ ‐ ‐ ‐ 0.0%
Leasehold Excise Tax 173,769 713 173,396 9,086 179,000 5,053 8,262 3,209 63.5%
Gambling Excise Tax 2,500,604 397,710 2,695,368 421,158 2,000,000 315,193 466,214 151,020 47.9%
Real Estate Excise Tax 6,121,830 1,401,806 7,211,736 1,365,480 4,420,000 996,074 1,206,327 210,253 21.1%
Less: CIP REET (2,707,676) (700,903) (6,461,736) (1,365,480) (4,420,000) (996,074) (1,206,327) (210,253) 21.1%
EMS Levy 479,597 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 0.0%
B&O Taxes 6,375,322 ‐ 9,633,034 1,226,412 7,636,000 1,718,100 2,315,204 597,104 34.8%
Less: CIP B&O Taxes (2,000,000) ‐ (2,473,974) ‐ (1,379,314) (310,346) ‐ 310,346 ‐100.0%
Business License Fees 1,926,510 834,953 1,480,730 386,774 1,311,894 435,254 783,400 348,146 80.0%
Less: CIP Business License Fees (1,587,627) (691,410) (614,796) (220,070) (623,186) (257,908) (324,542) (66,635) 25.8%
Animal Licenses and Spec Events Permits 102,905 14,955 140,391 15,680 94,174 15,209 25,989 10,780 70.9%
Building Permits & Development Svc Fees 5,293,563 1,074,783 4,907,983 676,844 5,451,699 936,369 595,371 (340,997) ‐36.4%
Intergovt'l (Grants, State Shared, etc) 3,998,953 584,560 4,285,806 538,686 3,735,614 532,507 534,397 1,889 0.4%
Fire District 25 and 40 Contracts 3,517,779 164,356 341,939 170,969 357,660 178,830 178,830 ‐ 0.0%
Public Safety 994,179 204,268 837,728 133,129 617,635 113,755 285,821 172,066 151.3%
Culture and Recreation 1,632,903 211,793 1,722,323 190,802 1,755,923 210,694 190,083 (20,611) ‐9.8%
Interfund/Interdept‐Services 3,377,663 559,590 3,916,334 650,626 4,361,086 726,848 686,144 (40,704) ‐5.6%
Fines and Penalties 901,592 55,802 822,450 72,761 830,082 61,561 74,998 13,436 21.8%
Photo Enforcement 1,959,071 298,285 2,124,399 279,252 3,151,072 445,665 291,441 (154,224) ‐34.6%
Seizure Funds ‐ Federal/State/Local 987,293 661,152 176,503 101,790 ‐ ‐ 16,733 16,733 100.0%
Interests and Other Earnings 1,058,880 108,296 1,155,371 124,243 875,300 91,923 157,830 65,907 71.7%
Rents, Leases, and Concessions 642,192 175,867 634,897 175,373 623,195 171,398 181,351 9,952 5.8%
Contributions and Donations 96,582 22,075 177,919 23,095 70,000 11,519 5 (11,514) ‐100.0%
Other Miscellaneous 956,131 162,099 954,680 144,348 702,998 102,924 129,254 26,331 25.6%
Other Financing Sources (Transfer ‐In, etc) 2,129,561 ‐ 283,213 ‐ 142,975 13,000 13,000 ‐ 0.0%
Total Operating Revenues 125,816,444 14,715,559 109,530,146 14,472,917 100,191,383 14,451,521 16,348,402 1,896,881 13.1%
OPERATING EXPENDITURES
Council 358,550 64,182 362,101 64,877 374,666 67,098 68,247 (1,149) ‐1.7%
Executive 1,778,206 322,242 1,954,748 350,285 1,977,556 356,276 370,213 (13,938) ‐3.9%
Emergency Management*370,832 49,871 569,333 75,996 606,070 81,139 92,381 (11,243) ‐13.9%
City Attorney 1,983,834 326,649 2,088,718 333,751 2,251,312 365,070 359,168 5,902 1.6%
Court Services 2,075,763 335,163 2,174,217 343,353 2,250,644 359,319 371,810 (12,492) ‐3.5%
Community and Eco Dvlpmnt Admin 1,161,330 190,655 1,351,830 219,758 1,339,679 218,777 223,634 (4,856) ‐2.2%
Development Services 2,859,410 448,710 3,023,728 501,405 3,451,529 557,415 474,218 83,198 14.9%
Economic Development 1,004,411 108,276 949,467 98,329 1,122,610 118,706 142,952 (24,246) ‐20.4%
Planning 2,716,214 411,848 2,815,148 449,900 3,473,927 541,213 479,452 61,761 11.4%
Finance 3,046,824 434,053 3,132,609 425,531 3,628,725 504,770 446,774 57,996 11.5%
City Clerk 914,251 168,845 1,119,376 322,088 1,250,565 301,896 154,002 147,894 49.0%
Human Resources 1,193,016 185,388 1,221,841 175,377 1,370,877 204,801 196,272 8,528 4.2%
Police 28,891,879 4,565,715 30,987,047 4,799,880 32,949,811 5,153,643 5,118,038 35,605 0.7%
Jail Services 4,704,978 784,030 4,807,443 801,089 5,968,750 994,735 994,735 ‐ 0.0%
Fire*25,349,755 5,249,651 ‐ ‐ ‐ ‐ ‐ ‐ 0.0%
Community Services Admin 585,983 113,335 554,951 84,711 523,015 90,786 85,085 5,702 6.3%
Parks 4,449,938 616,187 4,818,629 630,236 5,221,400 702,514 654,819 47,695 6.8%
Parks Planning & Natural Resources 952,980 103,226 1,059,058 140,186 1,266,373 153,203 124,297 28,905 18.9%
Recreation 5,544,516 790,421 5,799,202 812,123 6,256,963 860,914 861,285 (371) 0.0%
Human Services 1,241,169 213,832 1,634,387 170,784 1,311,570 175,427 184,247 (8,820) ‐5.0%
Neighborhoods, Resources, & Events 412,449 51,310 461,400 43,429 244,955 35,769 45,137 (9,367) ‐26.2%
Museum 229,543 37,570 235,712 39,555 241,246 39,991 40,634 (643) ‐1.6%
Public Works Admin 398,796 67,230 406,781 67,352 417,024 69,669 69,361 308 0.4%
Street Maintenance 5,041,509 805,426 5,603,141 920,483 5,587,710 905,984 859,296 46,688 5.2%
Transportation 5,966,281 720,619 5,368,887 694,002 5,791,047 722,719 818,473 (95,754) ‐13.2%
Debt Service 6,099,166 295,075 6,063,576 291,694 5,703,244 288,313 288,313 ‐ 0.0%
Non‐Departmental and Other 9,883,923 566,783 14,245,763 531,962 3,720,864 560,003 560,003 ‐ 0.0%
Total Operating Expenditures 119,215,504 18,026,295 102,809,093 13,388,134 98,302,133 14,430,151 14,082,847 347,304 2.4%
Total Ending Fund Balance 26,563,785$ 16,652,109$ 33,284,838$ 27,648,568$ 22,825,573$ 20,957,693$ 35,550,393$ 14,592,699$ 69.6%
*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 February 2018
Page 1 of 37
Monthly Financial Report February 2018
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through February 28, 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 73% of
all resources supporting general governmental activities. The following section provides detail information on property,
sales, utility, and other taxes.
Property Tax
February’s collection is $106K.
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 year‐to‐date collection of
$94K is $157K or 63% less than
the prior year and is also $99K or
51% less than the year‐to‐date
budget.
Sales Tax
February 2018 sales tax receipts
totaled $2.8M. Compared with
the same month last year, it is
$365K or 15% more. Compared
to the projected current month’s
budget, it is $344K or 14% above.
The year‐to‐date collection of
$5.1M is $490K or 11% more than
the prior year and is also $465K
or 10% more than budgeted.
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 106,364 (88,967) ‐46% (54,909) ‐34%
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 250,761$ 192,923$ 93,620$ (157,141)$ ‐63% (99,303)$ ‐51%
Annual Total 24,356,562$ 19,397,308$
Property Tax Revenues
Year to Da te through February
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 2,839,044 365,329 15% 343,977 14%
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 4,566,536$ 4,591,999$ 5,056,993$ 490,457$ 11% 464,994$ 10%
Annual Total 26,331,634$ 26,683,440$
2018 vs. Budget2018 vs. 2017
Month
Year to Date through February
Local Retail Sales Tax Revenues
Page 2 of 37
Monthly Financial Report February 2018
The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business
sectors:
Utility tax
February utility tax revenues are
$1.6M, which is $257K or 19%
higher than the same month last
year and is also higher than the
budget by $205K or 14%. The
year‐to‐date collection is $3M,
which is $46k or 2% lower than
the prior year but is $127K or 4%
higher than the budget. 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. The large variance with electrical and natural gas is due to an error in
recording these revenues. It will be corrected in March.
Sales Tax by Sector 2017 2018 Bgt YTD Act Change 2018/2017 2018 Act vs Bgt
New Construction 719,531$ 593,716$ 734,464$ 14,933$ 2% $ 140,749 24%
Auto Sales 832,969 824,262 883,610 50,642 6% 59,348 7%
General Retail 1,437,641 1,487,998 1,489,139 51,498 4% 1,140 0%
Manufacturing 239,714 337,385 364,849 125,135 52% 27,464 8%
Wholesale 244,529 225,609 255,399 10,870 4% 29,790 13%
Service 981,950 1,003,826 1,218,266 236,316 24% 214,440 21%
Other 110,202 119,202 111,265 1,063 1% (7,937)‐7%
YTD Total 4,566,536$ 4,591,999$ 5,056,993$ 490,457$ 11%464,994$ 10%
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 1,617,972 257,383 19% 204,804 14%
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 3,059,310$ 2,886,038$ 3,013,358$ (45,952)$ ‐2% 127,321$ 4%
Annual Total 16,999,203$ 15,664,124$
2018 vs. Budget2018 vs . 2017
Year to Date through February
Utility Tax Revenues
Month
Utility Tax by Type 2017 2018 Bgt YTD Act Change 2018/2017 2018 Act vs Bgt
Electrical 1,119,319$ 1,084,948$ 751,918$ (367,400)$ ‐33% $ (333,029)‐31%
Natural Gas 512,806 442,798 793,143 280,336 55% 350,345 79%
Cell 298,767 311,127 200,307 (98,460) ‐33% (110,820)‐36%
Phone 161,207 141,171 127,651 (33,555) ‐21% (13,520)‐10%
Cable 240,964 242,249 233,140 (7,824) ‐3% (9,109)‐4%
Garbage/Solid Waste 96,335 99,834 112,897 16,563 17% 13,063 13%
City Utilities 629,913 563,911 794,302 164,389 26% 230,391 41%
Utility Tax Audit ‐ ‐ ‐ ‐ N/A ‐ N/A
YTD Total 3,059,310$ 2,886,038$ 3,013,358$ (45,952)$ ‐2%127,321$ 4%
Annual Total 16,999,203$ 15,664,124$
YTD as % of 18% 18%
Page 3 of 37
Monthly Financial Report February 2018
Other Taxes
Real Estate Excise Tax
The City collected $366K in Real
Estate Excise Tax revenues (REET)
for February. This is $29K or 9%
more than the same month last
year and is also $156K or 74%
more than the current month’s
budget. The year‐to‐date
collection is $1.2M, which is
$159K or 12% less than the prior
year but is $210K or 21% above
the budget. 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
February’s Gambling Tax
collections totaled $255K, which
is $55K or 27% above the same
month last year and is also above
the current month’s budget by
$98K or 62%. The year‐to‐date
total of $466K is $45K or 11%
above the prior year and is also
$151K or 48% above budget.
Franchise Fees
Franchise Fees are due quarterly
in January, April, July, and
October. The year‐to‐date total
of $388K is right on target with
the prior year but is $59K or 18%
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 255,285 54,663 27% 98,016 62%
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 421,158$ 315,193$ 466,214$ 45,056$ 11% 151,020$ 48%
Annual Total 2,695,368$ 2,000,000$
2018 vs. 2017
Gambling Tax Revenue
Month
Year to Date through February
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 16,600 10,300 163% 13,777 488%
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 387,170$ 329,471$ 388,058$ 889$ 0% 58,587$ 18%
Annual Total 1,562,100$ 1,330,000$
Franchise Fees Revenue
Year to Date through February
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 366,011 28,987 9% 155,993 74%
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,365,480$ 996,074$ 1,206,327$ (159,153)$ ‐12% 210,253$ 21%
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 February
Page 4 of 37
Monthly Financial Report February 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
$58K is $5K or 9% less than the
prior year and is also $35K or 38%
less than the budget.
Business & Occupation Tax
Businesses with gross receipts of
$500K or more per year, earned
within the City of Renton, will be
required to file and pay Business
and Occupation (B&O) tax, in lieu
of the Business License
registration fee. Year‐to‐date
receipts totaled $2.3M. The
monthly budgets are based on
large business quarterly
reporting with smaller business
annual reporting.
Licenses and Permits
Business Licenses
Business Licenses totaled $209K
for February, which is $51K or
33% above the same month last
year and is $51K or 33% 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 of 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 1,473 (1,315) ‐47% (1,260) ‐46%
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 63,529$ 93,089$ 58,071$ (5,458)$ ‐9% (35,019)$ ‐38%
Annual Total 223,157$ 320,000$
2018 vs. Budget
Admission Tax Revenue
Year to Date through February
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 1,013,630 219,536 28% 822,730 431%
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 1,226,412$ 1,718,100$ 2,315,204$ 1,088,792$ 89% 597,104$ 35%
Annual Total 9,633,034$ 7,636,000$
*Total Business & Occupation Taxes (GF & CIP)
Business & Occupation Taxes*
Year to Date through February
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 208,947 51,443 33% 51,379 33%
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 386,774$ 435,254$ 783,400$ 396,626$ 103% 348,146$ 80%
Annual Total 1,480,730$ 1,311,894$
*Total Business License (GF & CIP)
Business Licenses*
Month
2018 vs. 2017
Year to Date through February
2018 vs. Budget
Page 5 of 37
Monthly Financial Report February 2018
Building Permits and
Development Service Fees
Building Permits and
Development Service Fee
revenues totaled $281K in
February. The year‐to‐date
revenues of $595K is $81K or 12%
less than the year before and is
$341K or 36% lower than 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 94%
of the total revenues
in this category. The
year‐to‐date total
Intergovernmental revenue is $1.2M or 18% of the budget.
State Shared
Revenues
State Shared
Revenue collections
totaled $992K since
the start of the year.
Compared to the
prior year, State
Shared Revenues are
above by $69K or 7%.
Compared to the
projected budget,
the City is collecting
$80K or 9% 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 280,745 3,449 1% (88,420) ‐24%
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 676,844$ 936,369$ 595,371$ (81,473)$ ‐12% (340,997)$ ‐36%
Annual Total 4,907,983$ 5,451,699$
Building Permits and Development Se rvice Fees
Year to Date through February
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 170,969 178,830 178,830 7,861 5%‐ 0%
State Shared Revenue 923,561 911,854 992,213 68,651 7% 80,359 9%
Federal Grants 12,295 30,560 ‐ (12,295) 0% (30,560) 0%
State Grants ‐ 15,271 15,271 15,271 100%‐ 0%
Other Grants/Intgovt 86,608 58,650 55,394 (31,214) ‐36% (3,256) ‐6%
ARRA Grants ‐ ‐ ‐ ‐ N/A ‐ N/A
Total Rev YTD 1,193,433$ 1,195,165$ 1,241,708$ 48,274$ 4%46,543$ 4%
Total Rev Annual 7,436,309$ 6,875,678$
YTD % 16% 17% 18%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
2017 2018 2018
Actual Budget Actual $ % $ %
Crim Just Sales Tax 483,778$ 483,827$ 528,481$ 44,703$ 9% 44,653$ 9%
Judicial Contribution ‐ ‐ 5,517 5,517 100% 5,517 100%
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 221,986 224,208 233,018 11,032 5% 8,810 4%
YTD Total 923,561$ 911,854$ 992,213$ 68,651$ 7% 80,359$ 9%
Annual Total 6,145,527$ 5,942,169$
2018 vs. Budget
State Shared Revenues
2018 vs. 2017
Revenue
Year to Date through February
Page 6 of 37
Monthly Financial Report February 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
60% of the total revenue in this category. The year‐to‐date total charges for services are $1.5M or 17% of the budget. The
following sections provide detail information for Public Safety, Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totaled
$286K 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 $153K or 115%
more. Compared to the year‐to‐
date budget, the City is over
budget by $172K or 151%. The
variance with the prior year is
due to collecting large
reimbursements for the School
Resource Officer program.
Recreation
Recreation revenues totaled
$52K for the current month.
Compared to the same month
the prior year, the City collected
$13K or 34% more. Compared to
the projected monthly budget,
the City collected $6K or 14%
more. The year‐to‐date
collection of $190K is right on
target with the year before but is
$21K or 10% lower than the year‐
to‐date budget.
2017 2018 2018
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 ‐
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 133,129$ 113,755$ 285,821$ 152,692$ 115% 172,066$ 151%
Annual Total 837,728$ 617,635$
Year to Date through February
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 51,694 13,243 34% 6,446 14%
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 190,802$ 210,694$ 190,083$ (719)$ 0% (20,611)$ ‐10%
Annual Total 1,722,323$ 1,755,923$
Recreation
Year to Date through February
2018 vs. Budget2018 vs. 2017
Month
Page 7 of 37
Monthly Financial Report February 2018
Interfund Services
The year‐to‐date collections for
Interfund Services revenues are
$686K. Compared to the prior
year, the revenues are over by
$36K or 5%. Compared to the
projected budget, the revenues
are below by $41K 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
$366K. This is $14K or 4% higher
than a year ago but is $141K or
28% 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 344,339 24,488 8% (19,084) ‐5%
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 650,626$ 726,848$ 686,144$ 35,518$ 5% (40,704)$ ‐6%
Annual Total 3,916,334$ 4,361,086$
Interfund Services
Year to Date through February
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 224,814 7,759 4% (79,947) ‐26%
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 352,013$ 507,227$ 366,439$ 14,427$ 4% (140,787)$ ‐28%
Annual Total 2,946,849$ 3,981,154$
2018 vs. Budget2018 vs . 2017
Year to Date through February
Fines and Penalties by Month
Month
Year to Date through February
2017 2018 2018
Actual Budget Actual $ % $ %
Civil Penalties 349$ 772$ 173$ (176)$ ‐50% (599)$ ‐78%
Civil Infraction Penalties 26,890 24,585 32,004 5,114 19% 7,418 30%
Civil Parking Infraction Penalties 13,707 17,851 16,346 2,639 19% (1,505) ‐8%
Photo Enforcement Program 279,252 445,665 291,441 12,190 4% (154,224) ‐35%
Criminal Traffic Misdemeanor Fines 5,944 3,230 6,120 177 3% 2,890 89%
Criminal Non‐Traffic Fines 9,603 5,383 6,687 (2,916) ‐30% 1,305 24%
Criminal Costs 8,415 7,941 8,843 428 5% 903 11%
Non‐Court Fines, Forfeitures and Penalties 7,853 1,800 4,824 (3,029) ‐39% 3,024 168%
YTD Total 352,013$ 507,227$ 366,439$ 14,427$ 4% (140,787)$ ‐28%
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 February 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
$291K.
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 $413K.
Compared to last year, the
revenues are below by $100K or
19%. Compared to the projected
year‐to‐date budget, the
revenues are over by $83K or
25%. 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 154,588 121,775 95,186 59,402
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 445,665$ 291,441$ 243,550$ 122,618$ 168,823$
Annual Total 3,151,072$ 1,461,297$
1Actuals of Revenues and Expenses
ExpensesRevenues
Photo Enforcement Program
Year to Date through February
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 150,608 1,620 1% 46,231 44%
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 512,986$ 330,713$ 413,298$ (99,688)$ ‐19% 82,585$ 25%
Annual Total 2,478,278$ 1,824,117$
Year to Date through February
Month
2018 vs. Budget2018 vs. 2017
Miscellaneous Revenues by Month
2017 2018 2018
Actual Budget Actual $ % $ %
Interests and Other Earnings 124,243$ 91,923$ 157,830$ 33,587$ 27% 65,907$ 72%
Rents, Leases, and Concessions 175,373 171,398 181,351 5,978 3% 9,952 6%
Contributions/Donations from Private Sources 23,095 11,519 5 (23,090) ‐100% (11,514) ‐100%
Other 88,485 55,872 57,379 (31,106) ‐35% 1,507 3%
Seizure Funds ‐ Federal/State/Local 101,790 ‐ 16,733 (85,057) ‐84% 16,733 100%
YTD Total 512,986$ 330,713$ 413,298$ (99,688)$ ‐19% 82,585$ 25%
Annual Total 2,478,278$ 1,824,117$
2018 vs. Budget
Miscellaneous Revenues by Type
Year to Date through February
Revenue
2018 vs. 2017
Page 9 of 37
Monthly Financial Report February 2018
EXPENSES
Overall the City has expended 14% of its budgeted general governmental expenditures at the end of February. This is $347K
or 2.4% 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 1.7%. This is due to over spending on benefits and
underspending on professional services. We will monitor this to determine if a budget adjustment is needed at year‐end.
Executive department is over the year‐to‐date budget by $25K or 5.8%. This is due to over spending salaries/benefits and
professional services. We will monitor this to determine if a budget adjustment is needed at year‐end.
Court Services department is over the year‐to‐date budget by $12K or 3.5%. 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 $49K or 2.9%. 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 February 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 ‐ ‐ ‐ ‐ 17,700 10,500 ‐
Grants / intergovernmental 23,656 ‐ ‐ ‐ ‐ 298,490 ‐
Charges for services 42,649 113,545 1,311,623 2,527,641 1,743,995 1,981,156 2,778,604
Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐
Fines and penalties 170 ‐ ‐ ‐ ‐ ‐ ‐
Rents, leases, and misc fees 416,865 21,643 ‐ 59,152 ‐ ‐ ‐
Interest and other misc 5,816 1,199 5,135 216,416 168,324 80,357 9,382
TOTAL REVENUES 489,156 136,387 1,316,758 2,803,209 1,930,019 2,370,503 2,787,986
EXPENSES:
Utility billing ‐ ‐ 6,947 28,259 23,583 36,811 ‐
Utility systems ‐ ‐ 2,190,672 643,385 538,892 504,858 ‐
Utility maintenance ‐ ‐ 59,516 851,340 353,168 512,108 2,735,129
Transportation 261,188 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 311,638 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 261,188 311,638 2,257,135 1,522,984 915,643 1,053,777 2,735,129
AMOUNT AVAILABLE FOR DEBT SERVICE 227,968 (175,251) (940,377) 1,280,225 1,014,376 1,316,726 52,857
DEBT SERVICE:
Principal ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest ‐ ‐ ‐ ‐ ‐ 86,670 ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ ‐ ‐ 86,670 ‐
CAPITAL PROJECTS 6,342 ‐ ‐ 274,373 216,467 212,932 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ ‐ ‐ (637) ‐
CHANGE IN FUND BALANCE 221,626 (175,251) (940,377) 1,005,852 797,909 1,016,487 52,857
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, Feb 28 3,680,815 (169,984) 2,059,935 34,919,419 18,207,911 14,951,192 5,142,626
Page 11 of 37
Monthly Financial Report February 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 ‐ 33,345 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ ‐ ‐ ‐ ‐ ‐ ‐
Charges for services
Equipment rental m&o 361,979 721,424 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ ‐ ‐ 74,090 ‐ ‐ ‐
Communications ‐ ‐ ‐ 115,805 ‐ ‐ ‐
Facilities ‐ ‐ 680,863 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ ‐ ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest and other misc 11,379 6,118 2,697 1,009 28,633 7,456 19,300
Internal service fund misc:
Vehicle / equipment capital recovery 347,033 35,149 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 288,276 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 217,166 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 1,550,930 437,444
Other misc 60 ‐ ‐ ‐ ‐ 150,896 ‐
Interfund Loan ‐ ‐ ‐ ‐ ‐ ‐ ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets ‐ ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 196,426 ‐ ‐
TOTAL REVENUES 720,451 796,036 683,559 190,904 730,501 1,709,282 456,744
EXPENSES:
Communications 102,976
Equipment rental 347,270
Facilities 562,615
Healthcare 1,471,652
Information technology 941,598
Print and mail 56,612
Retiree healthcare 89,969
Risk management:
Risk management 717,899
Unemployment 9,614
Worker's compensation 218,534
TOTAL EXPENSES 347,270 941,598 562,615 159,588 946,047 1,471,652 89,969
AMOUNT AVAILABLE FOR CAPITAL 373,181 (145,562) 120,944 31,316 (215,546) 237,630 366,775
CAPITAL PROJECTS 155,110 79,699 ‐ ‐ ‐ ‐ ‐
TRANSFERS IN ‐ 637 ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 218,071 (224,624) 120,944 31,316 (215,546) 237,630 366,775
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, Feb 28 7,100,691 3,512,436 1,651,691 639,461 17,515,584 4,855,118 12,254,119
Page 12 of 37
Monthly Financial Report February 2018
FUND BALANCE
Page 14 shows the ending fund balance as of February 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 February, the City has $35.6M reported in the combined general governmental fund balance of the current
year’s operating budget, which is approximately 36% of budgeted operating expenditures. This is an increase of $2.3M from
the year’s beginning balance. February’s ending fund balance is over the anticipated General Governmental Fund Balance of
$21M by $14.6M or 69.6%. 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 February 2018
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through February 28, 2018
Funds
Balance
01/01/2018
Budgeted
Revenue
Revenue
02/28/18
Total Funds
Available
Budgeted
Expenditure
Expenditure
02/28/18 Ending Balance
GENERAL GOVERNMENT FUNDS: 33,284,838 100,191,383 16,348,402 49,633,240 98,302,133 14,082,847 35,550,393
000 General 22,708,066 69,157,742 13,578,347 36,286,413 67,041,323 10,297,616 25,988,797
001 Community Services 4,840,993 13,425,796 1,227,219 6,068,212 13,443,212 1,761,417 4,306,795
003 Street 3,143,904 11,288,240 1,324,542 4,468,446 11,378,757 1,677,768 2,790,677
004 Community Dev Block Grant 54,286 424,857 ‐ 54,286 424,857 7,892 46,394
005 Museum 70,992 239,129 98 71,090 241,246 40,634 30,456
009 Farmers Market 105,323 59,400 889 106,212 69,494 9,206 97,006
201 Ltd GO Bonds Gen Govt Debt 863,732 ‐ 1,387 865,119 ‐ ‐ 865,119
215 Gen Govt Misc Debt Service 1,497,542 5,596,219 215,920 1,713,462 5,703,244 288,313 1,425,149
SPECIAL REVENUE FUNDS:2,093,053 1,950,224 412,346 2,505,399 1,892,764 132,176 2,373,223
102 Arterial Street 108,438 670,000 109,872 218,310 670,000 ‐ 218,310
108 Leased City Properties 611,055 902,550 187,314 798,369 845,090 101,329 697,040
110 Hotel Motel 461,434 265,000 55,161 516,595 265,000 28,847 487,748
125 1% For Art 103,109 15,000 166 103,275 15,000 ‐ 103,275
127 Cable Communication 472,489 97,674 59,291 531,780 97,674 2,000 529,780
135 Springbrook Wetlands Bank 336,528 ‐ 542 337,070 ‐ ‐ 337,070
CAPITAL PROJECT FUNDS (CIP):36,295,483 9,410,400 3,397,001 39,692,484 13,039,521 1,115,475 38,577,009
303 Community Services Mitigation 1,909,355 86,500 84,454 1,993,809 ‐ ‐ 1,993,809
304 Fire Mitigation 936,972 99,000 72,066 1,009,038 142,975 ‐ 1,009,038
305 Transportation Mitigation 810,962 632,400 189,379 1,000,341 5,000 ‐ 1,000,341
316 Municipal Facilities CIP 19,671,696 4,627,000 2,060,940 21,732,636 8,926,046 542,951 21,189,685
317 Transportation CIP 5,808,539 3,965,500 796,085 6,604,624 3,965,500 572,524 6,032,100
326 Housing Opportunity 2,548,975 ‐ 4,113 2,553,088 ‐ ‐ 2,553,088
336 New Library Development 451,093 ‐ 715 451,808 ‐ ‐ 451,808
346 New Family First Center Dvlpmnt 4,157,891 ‐ 189,249 4,347,140 ‐ ‐ 4,347,140
ENTERPRISE FUNDS: 76,812,811 83,652,598 11,835,688 88,648,499 92,373,701 9,856,589 78,791,910
4X2 Airport Operating & CIP 3,459,189 4,531,809 489,156 3,948,345 4,552,790 267,531 3,680,814
403 Solid Waste Utility 3,000,312 19,505,718 1,316,758 4,317,070 19,368,508 2,257,136 2,059,934
4X4 Golf Operating & CIP 5,267 2,912,920 138,056 143,323 2,728,654 313,308 (169,985)
4X5 Water Operating & CIP 33,913,567 17,420,439 2,803,209 36,716,776 21,538,687 1,797,357 34,919,419
4X6 Waste Water Operating & CIP 17,410,002 10,076,333 1,930,019 19,340,021 12,084,986 1,132,111 18,207,910
416 King County Metro 5,089,769 17,505,693 2,787,986 7,877,755 17,505,693 2,735,129 5,142,626
4X7 Surface Water Operating & CIP 13,934,705 11,699,686 2,370,504 16,305,209 14,594,383 1,354,017 14,951,192
INTERNAL SERVICE FUNDS:46,994,534 30,283,478 5,288,114 52,282,648 31,616,210 4,753,549 47,529,099
501 Equipment Repair/Replacement 6,882,620 6,026,729 720,452 7,603,072 6,989,962 502,380 7,100,692
502 Insurance 17,731,130 3,307,514 730,501 18,461,631 3,315,116 946,048 17,515,583
503 Information Services 3,737,060 5,510,230 796,673 4,533,733 5,563,704 1,021,296 3,512,437
504 Facilities 1,530,747 4,887,148 683,559 2,214,306 4,978,288 562,615 1,651,691
505 Communications 608,145 1,102,300 190,904 799,049 1,096,329 159,589 639,460
512 Insurance, Healthcare 4,617,488 8,191,708 1,709,281 6,326,769 8,578,084 1,471,652 4,855,117
522 Insurance, Leoff1 Retirees HC 11,887,344 1,257,849 456,744 12,344,088 1,094,727 89,969 12,254,119
FIDUCIARY FUNDS: 5,832,897 468,000 5,725 5,838,622 200,475 38,309 5,800,313
611 Firemen's Pension 5,832,897 468,000 5,725 5,838,622 200,475 38,309 5,800,313
TOTAL FUNDS 201,313,616 225,956,083 37,287,276 238,600,892 237,424,804 29,978,945 208,621,947
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 16,348,402 14,082,847 2,265,555 35,550,393
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
3,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,451,521 16,348,402 13.13%
Mar 20,972,871
Apr 33,054,932
May 43,717,780
Jun 49,969,025
Jul 57,841,558
Aug 64,579,058
Sep 70,898,163
Oct 81,917,169
Nov 93,261,010
Dec 100,191,383
Percent of budget 16.32%
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
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.48%
$‐
$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 5,657,031 14.32%
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 19.64%
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
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 19.24%
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 862,852 ‐4.74%
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 18.61%
Note: GF only
Intergovt'l Budget
YTD
Actual
Annual %
over (under)
Jan 595,670 601,356 0.95%
Feb 1,195,165 1,241,708 3.89%
Mar 1,741,231
Apr 2,268,089
May 2,648,267
Jun 3,237,847
Jul 3,779,757
Aug 4,382,711
Sep 4,976,919
Oct 5,573,386
Nov 6,003,205
Dec 6,875,678
Percent of budget 18.06%
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 1,451,288 9.82%
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 16.53%
Note: Excludes FD25 & FD40 contracts
Fines &
Forfeits Budget
YTD
Actual
Annual %
over (under)
Jan 202,466 141,625 ‐30.05%
Feb 507,227 366,439 ‐27.76%
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 9.20%
$‐
$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 3,235,809 50.46%
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 32.08%
Misc Budget
YTD
Actual
Annual %
over (under)
Jan 226,336 262,690 16.06%
Feb 330,713 413,298 24.97%
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 22.66%
$‐
$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 13,000 13,000 0.00%
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 9.09%
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
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 27.29%
$‐
$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 595,371 ‐36.42%
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 10.92%
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
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 30.32%
$‐
$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,416 6,868,916 ‐3.91%
Feb 14,430,151 14,082,847 ‐2.41%
Mar 23,171,064
Apr 30,885,118
May 39,100,987
Jun 46,910,110
Jul 55,626,914
Aug 63,991,747
Sep 72,419,092
Oct 80,682,421
Nov 88,548,179
Dec 98,302,133
Percent of budget expended 14.33%
Legislative Budget
YTD
Actual
Annual %
over (under)
Jan 36,796 38,187 3.78%
Feb 67,098 68,247 1.71%
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 18.22%
$‐
$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 370,213 3.91%
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 18.72%
Emergency
Management Budget
YTD
Actual
Annual %
over (under)
Jan 38,727 46,027 18.85%
Feb 81,139 92,381 13.86%
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 15.24%
$‐
$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 359,168 ‐1.62%
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 15.95%
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
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 16.52%
$‐
$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 223,634 2.22%
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 16.69%
Development
Services Budget
YTD
Actual
Annual %
over (under)
Jan 264,886 239,592 ‐9.55%
Feb 557,415 474,218 ‐14.93%
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 13.74%
$‐
$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 142,952 20.43%
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 12.73%
Planning Budget
YTD
Actual
Annual %
over (under)
Jan 266,956 230,023 ‐13.83%
Feb 541,213 479,452 ‐11.41%
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 13.80%
$‐
$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 446,774 ‐11.49%
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 12.31%
City Clerk Budget
YTD
Actual
Annual %
over (under)
Jan 79,458 73,376 ‐7.65%
Feb 301,896 154,002 ‐48.99%
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 12.31%
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 196,272 ‐4.16%
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 14.32%
Police Budget
YTD
Actual
Annual %
over (under)
Jan 3,244,286 3,128,806 ‐3.56%
Feb 6,148,378 6,112,773 ‐0.58%
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 15.71%
$‐
$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 85,085 ‐6.28%
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 16.27%
Parks Budget
YTD
Actual
Annual %
over (under)
Jan 345,556 313,568 ‐9.26%
Feb 702,514 654,819 ‐6.79%
Mar 1,093,140
Apr 1,508,539
May 1,911,905
Jun 2,348,633
Jul 2,828,899
Aug 3,336,493
Sep 3,866,193
Oct 4,314,267
Nov 4,724,307
Dec 5,221,400
Percent of budget expended 12.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
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 124,297 ‐18.87%
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 9.82%
Recreation Budget
YTD
Actual
Annual %
over (under)
Jan 408,633 446,821 9.35%
Feb 860,914 861,285 0.04%
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 13.77%
$‐
$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 184,247 5.03%
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 14.05%
Neighborhoods
, Resources,
and Events Budget
YTD
Actual
Annual %
over (under)
Jan 16,829 (47,839) ‐384.27%
Feb 35,769 45,137 26.19%
Mar 54,610
Apr 70,932
May 89,128
Jun 106,950
Jul 133,567
Aug 157,415
Sep 178,034
Oct 198,261
Nov 215,703
Dec 244,955
Percent of budget expended 18.43%
$‐
$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 40,634 1.61%
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 16.84%
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
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 16.63%
$‐
$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 859,296 ‐5.15%
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 15.38%
Transportation Budget
YTD
Actual
Annual %
over (under)
Jan 349,016 366,141 4.91%
Feb 722,719 818,473 13.25%
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 14.13%
$‐
$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 288,313 288,313 0.00%
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 5.06%
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 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 15.05%
$‐
$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 11,208,449 9,275,111
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 8.34%
Note: Operations and Capital
Airport Budget Revenue Expense
Jan 364,906 237,743 123,513
Feb 678,730 489,156 267,530
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 5.88%
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 138,056 313,308
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 11.48%
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