HomeMy WebLinkAbout201712, December
h:\finance\financial reporting\monthly reports\2017 reports\cover 1217.docx
ADMINISTRATIVE SERVICES
M E M O R A N D U M
DATE: February 22, 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: December 2017 Financial Status Report
At the end of December, general governmental revenues show $5M or 4.8% over budget.
Revenue source(s) that are higher than expected are: property tax ($253K); sales tax
($481K); utility taxes ($1.2M); franchise fees ($232K); gambling taxes ($695K); business &
occupation taxes ($2.1M); business license ($180K); state shared revenues ($340K); public
safety ($225K); seizure funds ($177K), restricted to drug enforcement and not available
for general purposes); interest ($280K); and other miscellaneous/financing sources
($375K). If we remove B&O taxes and seizure funds, general governmental revenues are
$2.7M or 2.5% over budget. On the down side, the revenue source(s) that are
underperforming the year to date budget are: building permits & development service
fees ($827K below) and interfund/interdept charges for services ($263K below).
General government expenditures showed a favorable variance of $7.4M or 6.7%. 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.
Armondo Pavone, Council President
Members of Renton City Council
Page 2 of 2
February 22, 2018
h:\finance\financial reporting\monthly reports\2017 reports\cover 1217.docx
This page is intentionally left blank
General Governmental Funds
$%
Beginning Fund Balance 17,565,282$ 17,565,282$ 19,962,845$ 19,962,845$ 26,563,785$ 26,563,785$ 26,563,785$ ‐ 0.0%
OPERATING REVENUES
Property Tax 36,369,429 36,369,429 37,038,480 37,038,480 24,103,395 24,103,395 24,356,562 253,167 1.1%
Sales Tax 23,439,266 23,439,266 26,353,246 26,353,246 25,850,400 25,850,400 26,331,634 481,234 1.9%
Sales Tax ‐ Annexation Credit 2,778,858 2,778,858 3,114,762 3,114,762 3,063,280 3,063,280 3,123,230 59,950 2.0%
Criminal Justice Sales Tax 2,484,718 2,484,718 2,701,787 2,701,787 2,679,898 2,679,898 2,808,564 128,666 4.8%
Natural Gas Use Tax 228,899 228,899 184,638 184,638 228,000 228,000 180,456 (47,544) ‐20.9%
Admission Tax 309,790 309,790 262,506 262,506 320,000 320,000 223,157 (96,843) ‐30.3%
Franchise Fees 1,349,154 1,349,154 1,406,092 1,406,092 1,330,000 1,330,000 1,562,100 232,100 17.5%
Electricity Tax 5,012,962 5,012,962 5,440,139 5,440,139 5,596,019 5,596,019 5,721,366 125,347 2.2%
Natural Gas Utility Tax 1,437,552 1,437,552 1,327,937 1,327,937 1,350,900 1,350,900 1,630,375 279,475 20.7%
Garbage/Solid Waste 638,073 638,073 717,148 717,148 680,000 680,000 627,254 (52,746) ‐7.8%
TV Cable 1,591,866 1,591,866 1,619,364 1,619,364 1,645,659 1,645,659 1,651,405 5,746 0.3%
Telephone 880,233 880,233 859,868 859,868 789,875 789,875 866,519 76,644 9.7%
Cellular Phone 1,674,355 1,674,355 1,541,204 1,541,204 1,521,056 1,521,056 1,481,298 (39,758) ‐2.6%
City Utilities 4,183,165 4,183,165 4,206,473 4,206,473 3,941,628 3,941,628 4,840,530 898,902 22.8%
Utility Tax Audit 1,962,092 1,962,092 111,227 111,227 ‐ ‐ ‐ ‐ 0.0%
Leasehold Excise Tax 163,314 163,314 173,769 173,769 179,000 179,000 173,396 (5,604) ‐3.1%
Gambling Excise Tax 2,299,156 2,299,156 2,500,604 2,500,604 2,000,000 2,000,000 2,695,368 695,368 34.8%
Real Estate Excise Tax 4,595,166 4,595,166 6,121,830 6,121,830 5,170,000 5,170,000 7,211,736 2,041,736 39.5%
Less: CIP REET (1,401,300) (1,401,300) (2,707,676) (2,707,676) (4,420,000) (4,420,000) (6,461,736) (2,041,736) 46.2%
EMS Levy 936,406 936,406 479,597 479,597 ‐ ‐ ‐ ‐ 0.0%
B&O Taxes ‐ ‐ 6,375,322 6,375,322 7,500,000 7,500,000 9,633,034 2,133,034 28.4%
Less: CIP B&O Taxes ‐ ‐ (2,000,000) (2,000,000) (2,473,974) (2,473,974) (2,473,974) ‐ 0.0%
Business License Fees 3,125,740 3,125,740 1,926,510 1,926,510 1,302,453 1,302,453 1,480,730 178,277 13.7%
Less: CIP Business License Fees (2,584,164) (2,584,164) (1,587,627) (1,587,627) (617,016) (617,016) (614,796) 2,220 ‐0.4%
Animal Licenses and Spec Events Permits 101,743 101,743 102,905 102,905 212,575 212,575 140,391 (72,184) ‐34.0%
Building Permits & Development Svc Fees 6,077,055 6,077,055 5,293,563 5,293,563 5,735,368 5,735,368 4,907,983 (827,385) ‐14.4%
Intergovt'l (Grants, State Shared, etc) 4,053,617 4,053,617 3,998,953 3,998,953 4,583,876 4,583,876 4,285,806 (298,070) ‐6.5%
Fire District 25 and 40 Contracts 6,369,132 6,369,132 3,517,779 3,517,779 341,939 341,939 341,939 ‐ 0.0%
Public Safety 649,797 649,797 994,179 994,179 613,081 613,081 837,728 224,647 36.6%
Culture and Recreation 1,587,878 1,587,878 1,632,903 1,632,903 1,750,923 1,750,923 1,722,323 (28,600) ‐1.6%
Interfund/Interdept‐Services 3,106,430 3,106,430 3,377,663 3,377,663 4,178,976 4,178,976 3,916,334 (262,642) ‐6.3%
Fines and Penalties 848,052 848,052 901,592 901,592 824,450 824,450 822,450 (2,000) ‐0.2%
Photo Enforcement 2,171,184 2,171,184 1,959,071 1,959,071 2,044,000 2,044,000 2,124,399 80,399 3.9%
Seizure Funds ‐ Federal/State/Local 21,676 21,676 987,293 987,293 ‐ ‐ 176,503 176,503 100.0%
Interests and Other Earnings 973,208 973,208 1,058,880 1,058,880 875,300 875,300 1,155,371 280,071 32.0%
Rents, Leases, and Concessions 762,361 762,361 642,192 642,192 623,195 623,195 634,897 11,702 1.9%
Contributions and Donations 147,292 147,292 96,582 96,582 175,500 175,500 177,919 2,419 1.4%
Other Miscellaneous 941,127 941,127 956,131 956,131 691,812 691,812 954,680 262,868 38.0%
Other Financing Sources (Transfer‐In, etc) 270,224 (13,421,581) 2,129,561 2,129,561 171,196 171,196 283,213 112,017 65.4%
Total Operating Revenues 119,555,505 119,555,505 125,816,444 125,816,444 104,562,763 104,562,763 109,530,146 4,967,383 4.8%
OPERATING EXPENDITURES
Council 320,877 320,877 358,550 358,550 368,211 368,211 362,101 6,110 1.7%
Executive 1,691,189 1,691,189 1,778,206 1,778,206 2,007,671 2,007,671 1,954,748 52,923 2.6%
Emergency Management*398,808 398,808 370,832 370,832 609,249 609,249 569,333 39,916 6.6%
City Attorney 1,791,167 1,791,167 1,983,834 1,983,834 2,163,329 2,163,329 2,088,718 74,611 3.4%
Court Services 2,013,364 2,013,364 2,075,763 2,075,763 2,265,056 2,265,056 2,174,217 90,839 4.0%
Community and Eco Dvlpmnt Admin 1,183,052 1,183,052 1,161,330 1,161,330 1,350,991 1,350,991 1,351,830 (839) ‐0.1%
Development Services 2,632,264 2,632,264 2,859,410 2,859,410 3,285,005 3,285,005 3,023,728 261,277 8.0%
Economic Development 658,515 658,515 1,004,411 1,004,411 1,613,665 1,613,665 949,467 664,198 41.2%
Planning 2,606,551 2,606,551 2,716,214 2,716,214 3,342,786 3,342,786 2,815,148 527,638 15.8%
Finance 3,132,812 3,132,812 3,046,824 3,046,824 3,407,369 3,407,369 3,132,609 274,760 8.1%
City Clerk 1,027,084 1,027,084 914,251 914,251 1,239,455 1,239,455 1,119,376 120,080 9.7%
Human Resources 1,182,629 1,182,629 1,193,016 1,193,016 1,359,317 1,359,317 1,221,841 137,476 10.1%
Police 28,144,699 28,144,699 28,891,879 28,891,879 31,830,126 31,830,126 30,987,047 843,079 2.6%
Jail Services 4,142,266 4,142,266 4,704,978 4,704,978 4,850,000 4,850,000 4,807,443 42,557 0.9%
Fire* 26,138,192 26,138,192 25,349,755 25,349,755 ‐ ‐ ‐ ‐ 0.0%
Community Services Admin 508,766 508,766 585,983 585,983 563,654 563,654 554,951 8,703 1.5%
Parks 4,411,383 4,411,383 4,445,115 4,445,115 5,179,955 5,179,955 4,816,736 363,219 7.0%
Parks Planning & Natural Resources 808,558 808,558 952,980 952,980 1,269,569 1,269,569 1,059,058 210,512 16.6%
Recreation 5,088,483 5,088,483 5,096,236 5,096,236 5,720,955 5,720,955 5,278,631 442,324 7.7%
Human Services 1,225,835 1,225,835 1,241,169 1,241,169 1,688,578 1,688,578 1,634,387 54,191 3.2%
Neighborhoods, Resources, & Events 958,624 958,624 865,551 865,551 1,264,095 1,264,095 983,864 280,231 22.2%
Museum 227,094 227,094 229,543 229,543 236,275 236,275 235,712 562 0.2%
Public Works Admin 387,493 387,493 398,796 398,796 406,398 406,398 406,781 (383) ‐0.1%
Street Maintenance 5,061,723 5,061,723 5,041,509 5,041,509 5,636,437 5,636,437 5,603,141 33,296 0.6%
Transportation 4,975,059 4,975,059 5,966,281 5,966,281 5,669,897 5,669,897 5,368,887 301,011 5.3%
Debt Service 6,371,715 6,371,715 6,099,166 6,099,166 6,066,629 6,066,629 6,063,576 3,053 0.1%
Non‐Departmental and Other 10,069,740 10,069,740 9,883,923 9,883,923 16,795,551 16,795,551 14,245,763 2,549,788 15.2%
Total Operating Expenditures 117,157,942 117,157,942 119,215,504 119,215,504 110,190,225 110,190,225 102,809,093 7,381,133 6.7%
To tal Ending 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%
*Emergency Management was moved to Executive due to formation of RRFA
Summary of Sources and Uses Annual Actual YTD Actual Favorable (Unfavorable)
2015 2016 2017 Variance
Annual Actual YTD Actual Annual Budget YTD Budget YTD Actual
Monthly Financial Report December 2017
Page 1 of 38
Monthly Financial Report December 2017
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through December 31, 2017. 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 76% of
all resources supporting general governmental activities. The following section provides detail information on property,
sales, utility, and other taxes.
Property Tax
December’s collection is $144K,
making the total year‐to‐date
collection $24.4M or 101.1% of
the total budget. In comparison
to the previous year, the City
collected $12.7M or 34% less.
Compared to the budget, the City
collected $253K or 1% more. The
large variance with the prior year
is due to the formation of the
Renton Regional Fire Authority.
Sales Tax
December 2017 sales tax receipts
totaled $2M. Compared with the
same month last year, it is $155K
or 7% less. Compared to the
projected current month’s
budget, it is $182K or 8% below.
The year‐to‐date collection of
$26.3M is $22K less than the
prior year but is $481K or 2%
more than budgeted. Retail and
Service are the sectors that are
collecting more than anticipated.
2017’s monthly budgets are
generally based on 2011 through
2016 collections.
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 44,745$ 36,768$ 55,429$ 10,684$ 24% 18,661$ 51%
Feb 315,119 204,274 195,332 (119,788) ‐38% (8,942) ‐4%
Mar 1,273,685 726,604 902,965 (370,721) ‐29% 176,361 24%
Apr 7,856,230 5,915,645 7,035,332 (820,898) ‐10% 1,119,687 19%
May 9,906,533 5,742,951 4,489,476 (5,417,057) ‐55% (1,253,475) ‐22%
Jun 137,794 93,616 128,834 (8,960) ‐7% 35,218 38%
Jul 57,174 40,245 69,600 12,426 22% 29,355 73%
Aug 240,536 110,113 101,349 (139,188) ‐58% (8,764) ‐8%
Sep 558,716 367,830 442,694 (116,022) ‐21% 74,865 20%
Oct 6,233,910 4,103,547 4,057,893 (2,176,017) ‐35% (45,654) ‐1%
Nov 10,268,791 6,647,038 6,733,813 (3,534,978) ‐34% 86,775 1%
Dec 145,246 114,763 143,844 (1,401) ‐1% 29,081 25%
YTD Total 37,038,480$ 24,103,395$ 24,356,562$ (12,681,918)$ ‐34% 253,167$ 1%
Annual Total 37,038,480$ 24,103,395$
Property Tax Revenues
Year to Date through December
2017 vs. 2016 2017 vs. Budget
Month
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 1,978,530$ 2,043,139$ 2,092,821$ 114,291$ 6% 49,682$ 2%
Feb 2,320,497 2,437,183 2,473,715 153,218 7% 36,532 1%
Mar 1,854,773 1,897,851 1,945,278 90,505 5% 47,427 2%
Apr 1,888,875 1,892,753 1,871,345 (17,530) ‐1% (21,408) ‐1%
May 2,314,220 2,213,349 2,381,981 67,761 3% 168,632 8%
Jun 2,127,406 1,979,325 2,075,555 (51,851) ‐2% 96,230 5%
Jul 2,103,896 2,029,679 2,236,477 132,581 6% 206,799 10%
Aug 2,438,277 2,287,199 2,421,720 (16,557) ‐1% 134,521 6%
Sep 2,179,438 2,183,510 2,162,766 (16,672) ‐1% (20,744) ‐1%
Oct 2,410,824 2,275,244 2,273,788 (137,037) ‐6% (1,456) 0%
Nov 2,532,820 2,381,095 2,347,924 (184,896) ‐7% (33,171) ‐1%
Dec 2,203,689 2,230,072 2,048,264 (155,425) ‐7% (181,808) ‐8%
YTD Total 26,353,246$ 25,850,400$ 26,331,634$ (21,612)$ 0% 481,234$ 2%
Annual Total 26,353,246$ 25,850,400$
2017 vs. Budget2017 vs. 2016
Month
Year to Date through December
Local Retail Sales Tax Revenues
Page 2 of 38
Monthly Financial Report December 2017
The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business
sectors:
Utility tax
December utility tax revenues
are $1.4M, which is $88K or 6%
higher than the same month last
year and is also higher than the
budget by $85K or 6%. The year‐
to‐date collection is $17M, which
is $991K or 6% higher than the
prior year and is also $1.2M or 8%
higher than the budget. The
large January variance with the
budget is due to lower 2015
activity for Electricity and the
timing of when 2015
Cell/Garbage taxes were
recorded. The April variance is
due to collecting higher than
expected Electrical/Natural Gas
and a correction to City Utilities. The monthly budgets are based on 2015/2016 activity.
The table below breaks out Utility Tax by source.
Sales Tax by Sector 2016 2017 Bgt YTD Act Change 2017/2016 2017 Act vs Bgt
New Construction 4,682,830$ 4,552,159$ 4,246,126$ (436,704)$ ‐9% $ (306,033)‐7%
Auto Sales 4,809,026 4,696,807 4,775,263 (33,763) ‐1% 78,456 2%
General Retail 7,295,531 7,321,764 7,711,534 416,002 6% 389,770 5%
Manufacturing 1,810,521 1,584,850 1,550,359 (260,161) ‐14% (34,490)‐2%
Wholesale 1,435,391 1,421,220 1,405,676 (29,714) ‐2% (15,544)‐1%
Service 5,635,185 5,614,915 5,884,292 249,106 4% 269,377 5%
Other 684,762 658,685 758,384 73,622 11% 99,699 15%
YTD Total 26,353,246$ 25,850,400$ 26,331,634$ (21,612)$ 0%481,234$ 2%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 1,509,960$ 1,300,842$ 1,698,721$ 188,761$ 13% 397,880$ 31%
Feb 1,597,348 1,487,029 1,360,589 (236,759) ‐15% (126,441) ‐9%
Mar 1,423,774 1,487,206 1,197,548 (226,226) ‐16% (289,659) ‐19%
Apr 1,346,282 1,311,554 1,797,449 451,168 34% 485,896 37%
May 1,363,323 1,307,318 1,464,438 101,115 7% 157,119 12%
Jun 1,125,845 1,196,872 1,351,607 225,762 20% 154,735 13%
Jul 1,276,335 1,254,591 1,538,390 262,054 21% 283,799 23%
Aug 1,247,926 1,294,638 1,185,237 (62,689) ‐5% (109,401) ‐8%
Sep 1,277,502 1,247,004 1,261,199 (16,303) ‐1% 14,195 1%
Oct 1,351,888 1,274,849 1,428,438 76,550 6% 153,589 12%
Nov 1,128,100 1,229,041 1,267,897 139,797 12% 38,856 3%
Dec 1,359,717 1,362,193 1,447,690 87,974 6% 85,497 6%
YTD Total 16,007,999$ 15,753,137$ 16,999,203$ 991,204$ 6% 1,246,066$ 8%
Annual Total 16,007,999$ 15,753,137$
2017 vs. Budget2017 vs. 2016
Year to Date through December
Utility Tax Revenues
Month
Utility Tax by Type 2016 2017 Bgt YTD Act Change 2017/2016 2017 Act vs Bgt
Electrical 5,440,139$ 5,596,019$ 5,721,366$ 281,227$ 5% $ 125,347 2%
Natural Gas 1,512,576 1,578,900 1,810,831 298,255 20% 231,931 15%
Cell 1,541,204 1,521,056 1,481,298 (59,906) ‐4% (39,758)‐3%
Phone 859,868 789,875 866,519 6,651 1% 76,644 10%
Cable 1,619,364 1,645,659 1,651,405 32,041 2% 5,746 0%
Garbage/Solid Waste 717,148 680,000 627,254 (89,894) ‐13% (52,746)‐8%
City Utilities 4,206,473 3,941,628 4,840,530 634,057 15% 898,902 23%
Utility Tax Audit 111,227 ‐ ‐ (111,227) 0% ‐ N/A
YTD Total 16,007,999$ 15,753,137$ 16,999,203$ 991,204$ 6%1,246,066$ 8%
Annual Total 16,007,999$ 15,753,137$
YTD as % of 100% 100%
Page 3 of 38
Monthly Financial Report December 2017
Other Taxes
Real Estate Excise Tax
The City collected $586K in Real
Estate Excise Tax revenues (REET)
for December. This is $278K or
91% more than the same month
last year and is also $263K or 82%
more than the current month’s
budget. The year‐to‐date
collection is $7.2M, which is
$1.1M or 18% more than the
prior year and is also $2M or 39%
above the budget. The higher
than expected variance is due to
32 large transactions in
December, January, February,
March, April, May, June, July,
August, September, October, and November which accounts for $2.6M of the total REET collected.
Gambling Tax
December’s Gambling Tax
collections totaled $265K, which
is $83K or 46% above the same
month last year and is also above
the current month’s budget by
$109K or 70%. The year‐to‐date
total of $2.7M is $195K or 8%
above the prior year and is also
$695K or 35% above budget. The
large August variance with the
prior year month is due to
collections from a payment plan
of back taxes earned in
2013/2014.
Franchise Fees
Franchise Fees are due quarterly
in January, April, July, and
October. The year‐to‐date total
of $1.6M is $156K or 11% higher
than the prior year and is also
$232K or 17% above the
projected year‐to‐date budget.
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 189,749$ 145,025$ 220,536$ 30,786$ 16% 75,511$ 52%
Feb 207,961 163,404 200,622 (7,339) ‐4% 37,218 23%
Mar 195,255 151,889 180,839 (14,416) ‐7% 28,949 19%
Apr 197,286 168,730 219,422 22,136 11% 50,692 30%
May 198,234 158,893 248,673 50,439 25% 89,780 57%
Jun 185,042 149,623 232,889 47,846 26% 83,265 56%
Jul 194,317 162,180 230,342 36,025 19% 68,162 42%
Aug 322,828 229,017 216,990 (105,838) ‐33% (12,027) ‐5%
Sep 202,409 159,756 205,141 2,732 1% 45,385 28%
Oct 242,254 190,582 215,122 (27,132) ‐11% 24,541 13%
Nov 183,345 165,084 259,744 76,399 42% 94,659 57%
Dec 181,924 155,817 265,048 83,124 46% 109,231 70%
YTD Total 2,500,604$ 2,000,000$ 2,695,368$ 194,763$ 8% 695,368$ 35%
Annual Total 2,500,604$ 2,000,000$
Gambling Tax Revenue
Month
Year to Date through December
2017 vs. Budget2017 vs. 2016
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 348,118$ 328,952$ 380,870$ 32,752$ 9% 51,918$ 16%
Feb ‐ ‐ 6,300 6,300 100% 6,300 100%
Mar ‐ ‐ 9,100 9,100 100% 9,100 100%
Apr 355,430 333,387 369,626 14,196 4% 36,240 11%
May ‐ ‐ 7,688 7,688 100% 7,688 100%
Jun ‐ ‐ 21,325 21,325 100% 21,325 100%
Jul 343,910 330,451 342,363 (1,547) 0% 11,912 4%
Aug ‐ ‐ 7,700 7,700 100% 7,700 100%
Sep 5,000 2,414 8,750 3,750 75% 6,336 263%
Oct 348,783 332,455 375,128 26,345 8% 42,673 13%
Nov ‐ ‐ 10,500 10,500 100% 10,500 100%
Dec 4,850 2,341 22,750 17,900 369% 20,409 872%
YTD Total 1,406,092$ 1,330,000$ 1,562,100$ 156,008$ 11% 232,100$ 17%
Annual Total 1,406,092$ 1,330,000$
Month
2017 vs. 2016 2017 vs. Budget
Franchise Fees Revenue
Year to Date through December
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 1,204,479$ 796,327$ 1,028,456$ (176,023)$ ‐15% 232,129$ 29%
Feb 197,327 173,487 337,024 139,698 71% 163,537 94%
Mar 208,452 245,588 708,868 500,416 240% 463,280 189%
Apr 335,985 355,020 385,517 49,532 15% 30,497 9%
May 475,244 422,078 386,087 (89,156) ‐19% (35,990) ‐9%
Jun 405,179 410,218 747,549 342,371 84% 337,331 82%
Jul 644,038 582,439 591,137 (52,901) ‐8% 8,698 1%
Aug 759,583 551,458 672,396 (87,187) ‐11% 120,938 22%
Sep 522,472 469,872 633,804 111,332 21% 163,931 35%
Oct 559,552 509,015 359,891 (199,661) ‐36% (149,124) ‐29%
Nov 502,139 332,211 775,249 273,110 54% 443,038 133%
Dec 307,382 322,287 585,757 278,375 91% 263,471 82%
YTD Total 6,121,830$ 5,170,000$ 7,211,736$ 1,089,906$ 18% 2,041,736$ 39%
Annual Total 6,121,830$ 5,170,000$
*Total REET (GF & CIP)
Real Estate Excise Tax (REET) Revenues*
Year to Date through December
Month
2017 vs. Budget2017 vs. 2016
Page 4 of 38
Monthly Financial Report December 2017
Admission Tax
Admission Tax returns are due
quarterly in January, April, July,
and October of each year.
December 2017 collections
represent activities conducted
during the 3rd quarter of 2017.
The year‐to‐date collection of
$223K is $39K or 15% less than
the prior year and is also $97K or
30% less than the budget. The
October collection (3rd Quarter
activity) was recorded in
December.
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 $9.6M. The
monthly budgets are based on
large business quarterly
reporting with smaller business
annual reporting.
Licenses and Permits
Business Licenses
Business Licenses totaled $44K
for December, which is $31K or
249% above the same month last
year and is also $36K or 453%
above the current month’s
budget. The year‐to‐date
Business Licenses revenue of
$1.5M is $446K or 23% below the
prior year but is above the budget
by $178K or 14%. The variance
with the prior year is due the City
adopting the Business &
Occupation Tax for 2016 (January
2016 represents 2015 4th quarter
activity).
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 76,393$ 89,502$ 60,741$ (15,652)$ ‐20% (28,762)$ ‐32%
Feb 1,360 1,527 2,788 1,429 105% 1,261 83%
Mar ‐ 59 ‐ ‐ (59) ‐100%
Apr 63,088 71,681 58,566 (4,522) ‐7% (13,115) ‐18%
May ‐ 852 1,279 1,279 100% 427 50%
Jun ‐ ‐ 785 785 100% 785 100%
Jul 60,763 80,276 51,061 (9,701) ‐16% (29,214) ‐36%
Aug ‐ ‐ 1,578 1,578 100% 1,578 100%
Sep 518 289 ‐ (518) (2 89) ‐100%
Oct 58,934 74,983 1,705 (57,229) ‐97% (73,278) ‐98%
Nov 1,452 831 ‐ (1,452) ‐100% (831) ‐100%
Dec ‐ ‐ 44,655 44,655 100% 44,655 100%
YTD Total 262,506$ 320,000$ 223,157$ (39,348)$ ‐15% (96,843)$ ‐30%
Annual Total 262,506$ 320,000$
2017 vs. Budget
Admission Tax Revenue
Year to Date through December
Month
2017 vs. 2016
2016 2017 2017
Actual Budget Actual $ % $ %
Jan ‐$ 1,500,000$ 432,319$ 432,319$ 100% (1,067,681)$ ‐71%
Feb ‐ 187,500 794,093 794,093 100% 606,593 324%
Mar ‐ 187,500 13,228 13,228 100% (174,272) ‐93%
Apr 4,578,349 1,500,000 4,626,880 48,531 1% 3,126,880 208%
May 304,032 187,500 316,791 12,759 4% 129,291 69%
Jun 30,591 187,500 23,491 (7,100) ‐23% (164,009) ‐87%
Jul 376,209 1,500,000 1,139,041 762,832 203% (360,959) ‐24%
Aug 334,807 187,500 399,375 64,568 19% 211,875 113%
Sep 10,779 187,500 169,792 159,012 1475% (17,708) ‐9%
Oct 603,622 1,500,000 981,417 377,795 63% (518,583) ‐35%
Nov 136,933 187,500 320,706 183,772 134% 133,206 71%
Dec ‐ 187,500 415,901 415,901 100% 228,401 122%
YTD Total 6,375,322$ 7,500,000$ 9,633,034$ 3,257,712$ 51% 2,133,034$ 28%
Annual Total 6,375,322$ 7,500,000$
*Total Business & Occupation Taxes (GF & CIP)
Business & Occupation Taxes*
Year to Date through December
Month
2017 vs. 2016 2017 vs. Budget
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 559,894$ 294,472 229,270$ (330,624)$ ‐59% (65,202)$ ‐22%
Feb 275,059 127,682 157,504 (117,555) ‐43% 29,822 23%
Mar 31,642 14,759 53,131 21,490 68% 38,373 260%
Apr 207,099 184,956 157,983 (49,116) ‐24% (26,973) ‐15%
May 111,131 72,269 126,086 14,955 13% 53,817 74%
Jun 26,936 13,489 36,375 9,439 35% 22,886 170%
Jul 248,769 228,999 217,718 (31,050) ‐12% (11,281) ‐5%
Aug 121,095 65,678 124,833 3,738 3% 59,155 90%
Sep 22,190 13,573 57,640 35,450 160% 44,066 325%
Oct 218,271 222,326 187,368 (30,903) ‐14% (34,958) ‐16%
Nov 91,870 56,325 88,975 (2,895) ‐3% 32,650 58%
Dec 12,555 7,925 43,847 31,292 249% 35,922 453%
YTD Total 1,926,510$ 1,302,453$ 1,480,730$ (445,780)$ ‐23% 178,277$ 14%
Annual Total 1,926,510$ 1,302,453$
*Total Business License (GF & CIP)
2017 vs. 2016
Year to Date through December
2017 vs. Budget
Business Licenses*
Month
Page 5 of 38
Monthly Financial Report December 2017
Building Permits and
Development Service Fees
Building Permits and
Development Service Fee
revenues totaled $331K in
December. The year‐to‐date
revenues of $4.9M is $386K or 7%
less than the year before and is
also $827K or 14% less than the
budget. The large variances in
January/February 2016 is due to
large payments for building
permits and plan review
(Southport Developer and Group
Health). The large variance in
May 2017 is due to large
payments for building permits
(Renton School District and Valley Medical Center). The large variance in July 2016 is due to a large payment from Group
Health.
Intergovernmental
These revenue
sources include
federal (direct and
indirect) grants, state
grants, state shared
revenues, local
grants, and
entitlements. State
shared revenues 87%
of the total revenues
in this category. The
year‐to‐date total
Intergovernmental revenue is $7.4M or 98% of the budget.
State Shared
Revenues
State Shared
Revenue collections
totaled $6.1M since
the start of the year.
Compared to the
prior year, State
Shared Revenues are
above by $212K or
4%. Compared to the
projected budget,
the City is collecting
$340K or 6% more.
The higher than
expected collection is
due to collecting more than anticipated Criminal Justice’s Sales Tax, Marijuana Enforcement, Liquor Excise Tax, and Fuel Tax.
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 661,363$ 481,500$ 399,548$ (261,815)$ ‐40% (81,952)$ ‐17%
Feb 413,420 379,615 277,296 (136,124) ‐33% (102,319) ‐27%
Mar 583,658 440,847 503,290 (80,368) ‐14% 62,443 14%
Apr 336,108 484,673 265,749 (70,360) ‐21% (218,925) ‐45%
May 376,324 310,348 558,773 182,449 48% 248,425 80%
Jun 437,619 698,400 611,441 173,822 40% (86,959) ‐12%
Jul 462,211 691,725 264,515 (197,696) ‐43% (427,210) ‐62%
Aug 397,578 438,730 433,043 35,465 9% (5,687) ‐1%
Sep 380,480 498,572 445,562 65,082 17% (53,010) ‐11%
Oct 479,048 478,350 338,298 (140,750) ‐29% (140,052) ‐29%
Nov 297,449 359,940 479,017 181,569 61% 119,078 33%
Dec 468,303 472,668 331,450 (136,852) ‐29% (141,218) ‐30%
YTD Total 5,293,563$ 5,735,368$ 4,907,983$ (385,580)$ ‐7% (827,385)$ ‐14%
Annual Total 5,293,563$ 5,735,368$
Year to Date through December
2017 vs. Budget2017 vs. 2016
Month
Building Permits and Development Service Fees
Intergovernmental 2016 2017 Bgt YTD Act Change 2017/2016 2017 Act vs Bgt
Fire District #25 698,123$ ‐$ ‐$ (698,123)$ 0% $ ‐ N/A
Fire District #40 2,819,656 341,939 341,939 (2,477,717) ‐88%‐ 0%
State Shared Revenue 5,933,890 5,805,528 6,145,527 211,637 4% 339,999 6%
Federal Grants 542,638 1,056,041 676,148 133,510 25% (379,893) ‐36%
State Grants 51,274 40,000 31,404 (19,871) ‐39% (8,596) ‐21%
Other Grants/Intgovt 652,533 362,205 241,291 (411,242) ‐63% (120,914) ‐33%
ARRA Grants ‐ ‐ ‐ ‐ N/A ‐ N/A
Total Rev YTD 10,698,115$ 7,605,713$ 7,436,309$ (3,261,806)$ ‐30%(169,404)$ ‐2%
Total Rev Annual 10,698,115$ 7,605,713$
YTD %100% 100% 98%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
2016 2017 2017
Actual Budget Actual $ % $ %
Crim Just Sales Tax 2,701,787$ 2,679,898$ 2,808,564$ 106,777$ 4% 128,666$ 5%
Judicial Contribution 18,092 ‐ 16,707 (1,385) ‐8% 16,707 100%
Crim Just ‐ High Crime 289,982 253,750 272,857 (17,124) ‐6% 19,107 8%
Crim Just ‐ Pop 27,122 24,360 28,640 1,519 6% 4,280 18%
Crim Just ‐ Spec Prog 98,887 90,335 103,951 5,065 5% 13,616 15%
State DUI 15,353 17,255 15,352 (1) 0% (1,903) ‐11%
Marijuana Enforcement 29,625 ‐ 64,084 34,459 116% 64,084 100%
Liquor Profits 848,248 850,000 855,262 7,014 1% 5,262 1%
Liquor Excise Tax 459,427 446,600 488,280 28,852 6% 41,680 9%
Fuel Tax 1,445,368 1,443,330 1,491,829 46,461 3% 48,499 3%
YTD Total 5,933,890$ 5,805,528$ 6,145,527$ 211,637$ 4% 339,999$ 6%
Annual Total 5,933,890$ 5,805,528$
State Shared Revenues
2017 vs. 2016
Revenue
Year to Date through December
2017 vs. Budget
Page 6 of 38
Monthly Financial Report December 2017
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
66% of the total revenue in this category. The year‐to‐date total charges for services are $8.5M or 98% of the budget. The
following sections provide detail information for Public Safety, Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totaled
$838K 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 $156K or 16%
less. Compared to the year‐to‐
date budget, the City is over
budget by $225K or 37%. The
variance with the prior year is
due to collecting large
payments/reimbursements for
electronic home detention and
School Resource Officer
programs.
Recreation
Recreation revenues totaled
$46K for the current month.
Compared to the same month
the prior year, the City collected
$6K or 16% more. Compared to
the projected monthly budget,
the City collected $1K or 3%
more. The year‐to‐date
collection of $1.7M is $89K or 5%
higher than the year before but is
$29K or 2% lower than the year‐
to‐date budget.
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 104,644$ 60,800$ 64,424$ (40,221)$ ‐38% 3,624$ 6%
Feb 99,623 52,862 68,705 (30,918) ‐31% 15,844 30%
Mar 58,031 44,909 148,707 90,676 156% 103,798 231%
Apr 51,002 73,680 61,399 10,397 20% (12,280) ‐17%
May 48,201 38,573 63,815 15,615 32% 25,242 65%
Jun 179,089 79,037 43,374 (135,715) ‐76% (35,664) ‐45%
Jul 34,906 27,743 59,850 24,944 71% 32,108 116%
Aug 44,439 38,564 58,114 13,675 31% 19,550 51%
Sep 67,570 33,790 53,908 (13,663) ‐20% 20,118 60%
Oct 160,438 72,212 52,056 (108,382) ‐68% (20,155) ‐28%
Nov 67,763 42,537 77,748 9,985 15% 35,210 83%
Dec 78,473 48,375 85,628 7,156 9% 37,253 77%
YTD Total 994,179$ 613,081$ 837,728$ (156,451)$ ‐16% 224,647$ 37%
Annual Total 994,179$ 613,081$
2017 vs. Budget
Month
2017 vs. 2016
Year to Date through December
Public Safety Services
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 163,783$ 152,710$ 152,350$ (11,433)$ ‐7% (360)$ 0%
Feb 48,009 42,505 38,452 (9,558) ‐20% (4,053) ‐10%
Mar 60,615 52,493 65,420 4,805 8% 12,927 25%
Apr 112,627 110,918 74,806 (37,821) ‐34% (36,112) ‐33%
May 72,246 74,076 84,381 12,135 17% 10,305 14%
Jun 239,771 254,264 153,304 (86,467) ‐36% (100,960) ‐40%
Jul 325,043 409,892 482,458 157,415 48% 72,566 18%
Aug 349,650 360,345 382,296 32,646 9% 21,950 6%
Sep 107,652 123,607 135,476 27,824 26% 11,869 10%
Oct 45,706 55,007 49,113 3,407 7% (5,894) ‐11%
Nov 68,324 70,632 58,320 (10,004) ‐15% (12,312) ‐17%
Dec 39,475 44,472 45,946 6,471 16% 1,474 3%
YTD Total 1,632,903$ 1,750,923$ 1,722,323$ 89,420$ 5% (28,600)$ ‐2%
Annual Total 1,632,903$ 1,750,923$
2017 vs. Budget2017 vs. 2016
Month
Recreation
Year to Date through December
Page 7 of 38
Monthly Financial Report December 2017
Interfund Services
The year‐to‐date collections for
Interfund Services revenues are
$3.9M. Compared to the prior
year, the revenues are over by
$539K or 16%. Compared to the
projected budget, the revenues
are below by $263K 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
$2.9M. This is $86K or 3% higher
than a year ago and $78K or 3%
higher than the budget.
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 272,841$ 348,248$ 330,774$ 57,933$ 21% (17,474)$ ‐5%
Feb 286,748 348,248 319,851 33,103 12% (28,397) ‐8%
Mar 305,054 348,248 377,192 72,138 24% 28,944 8%
Apr 276,238 348,248 332,180 55,942 20% (16,068) ‐5%
May 272,641 348,248 332,543 59,902 22% (15,705) ‐5%
Jun 260,223 348,248 322,435 62,212 24% (25,813) ‐7%
Jul 259,888 348,248 314,856 54,968 21% (33,392) ‐10%
Aug 273,851 348,248 295,921 22,070 8% (52,327) ‐15%
Sep 286,057 348,248 350,908 64,850 23% 2,660 1%
Oct 277,517 348,248 321,038 43,521 16% (27,210) ‐8%
Nov 295,584 348,248 316,488 20,904 7% (31,760) ‐9%
Dec 311,019 348,248 302,147 (8,872) ‐3% (46,101) ‐13%
YTD Total 3,377,663$ 4,178,976$ 3,916,334$ 538,671$ 16% (262,642)$ ‐6%
Annual Total 3,377,663$ 4,178,976$
2017 vs. Budget
Month
Interfund Services
Year to Date through December
2017 vs. 2016
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 136,421$ 126,199$ 134,957$ (1,464)$ ‐1% 8,758$ 7%
Feb 217,667 213,156 217,056 (611) 0% 3,900 2%
Mar 263,648 264,385 212,186 (51,462) ‐20% (52,199) ‐20%
Apr 250,873 242,171 242,816 (8,056) ‐3% 645 0%
May 214,613 231,927 229,877 15,263 7% (2,050) ‐1%
Jun 261,254 261,299 302,666 41,411 16% 41,367 16%
Jul 222,267 219,171 247,260 24,993 11% 28,089 13%
Aug 274,964 252,324 298,685 23,721 9% 46,360 18%
Sep 200,986 232,621 220,425 19,439 10% (12,196) ‐5%
Oct 238,517 243,770 274,245 35,728 15% 30,475 13%
Nov 273,338 270,941 240,739 (32,599) ‐12% (30,203) ‐11%
Dec 306,114 310,486 325,938 19,824 6% 15,452 5%
YTD Total 2,860,662$ 2,868,450$ 2,946,849$ 86,186$ 3% 78,399$ 3%
Annual Total 2,860,662$ 2,868,450$
Month
2017 vs. Budget2017 vs. 2016
Year to Date through December
Fines and Penalties by Month
Year to Date through December
2016 2017 2017
Actual Budget Actual $ % $ %
Civil Penalties 2,557$ 5,500$ 2,178$ (378)$ ‐15% (3,322)$ ‐60%
Civil Infraction Penalties 366,683 330,500 341,971 (24,712) ‐7% 11,471 3%
Civil Parking Infraction Penalties 174,863 244,950 189,474 14,611 8% (55,476) ‐23%
Photo Enforcement Program 1,959,071 2,044,000 2,124,399 165,328 8% 80,399 4%
Criminal Traffic Misdemeanor Fines 81,217 73,000 77,052 (4,165) ‐5% 4,052 6%
Criminal Non‐Traffic Fines 32,414 58,000 77,363 44,949 139% 19,363 33%
Criminal Costs 97,412 90,500 86,958 (10,454) ‐11% (3,542) ‐4%
Non‐Court Fines, Forfeitures and Penalties 146,446 22,000 47,454 (98,992) ‐68% 25,454 116%
YTD Total 2,860,662$ 2,868,450$ 2,946,849$ 86,186$ 3% 78,399$ 3%
Annual Total 2,860,662$ 2,868,450$
Revenue
2017 vs. Budget
Fines and Penalties by Type
2017 vs. 2016
Page 8 of 38
Monthly Financial Report December 2017
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
$2.1M.
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 $318k for
personnel costs. The total costs for the
program equates to $1.1M which is
represented in the table. Due to the timing
of when the invoice was received, January 2017’s equipment rental cost was recorded in February. November and December
invoices were recorded in December.
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 $2.5M.
Compared to last year, the
revenues are below by $709K or
22%. Compared to the projected
year‐to‐date budget, the
revenues are over by $549K or
28%. The large variance with the
prior year is due to collecting
more than anticipated Seizure
Funds in 2016. Seizure Funds are
restricted to drug enforcement only and are not available for general operating purposes. The large variance with the budget
is due to collecting more in interest and not having a budget for seizure funds.
Favorable
17 Budget 17 Actual 17 Budget 17 Actual (Unfavorable)
1
Jan 125,201$ 127,976$ 89,775$ 27,432$ 100,544$
Feb 157,962 151,276 89,775 95,200 56,076
Mar 189,510 146,612 89,775 95,186 51,425
Apr 165,633 161,103 89,775 95,192 65,911
May 152,426 175,251 89,775 95,189 80,062
Jun 194,994 221,788 89,775 95,183 126,605
Jul 144,851 183,910 89,775 95,189 88,721
Aug 183,427 225,288 89,775 95,204 130,084
Sep 164,770 146,972 89,775 95,195 51,776
Oct 175,856 210,697 89,775 95,192 115,505
Nov 185,108 173,692 89,775 95,192 78,500
Dec 204,263 199,835 89,775 162,945 36,889
YTD Total 2,044,000$ 2,124,399$ 1,077,297$ 1,142,302$ 982,097$
Annual Total 2,044,000$ 1,077,297$
1Actuals of Revenues and Expenses
Photo Enforcement Program
Year to Date through December
Month
Revenues Expenses
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 258,876$ 212,142$ 363,997$ 105,122$ 41% 151,855$ 72%
Feb 802,908 120,191 148,988 (653,920) ‐81% 28,798 24%
Mar 125,950 132,420 150,954 25,004 20% 18,534 14%
Apr 142,439 110,718 188,887 46,448 33% 78,169 71%
May 139,504 117,051 152,678 13,174 9% 35,628 30%
Jun 174,848 163,596 179,152 4,304 2% 15,556 10%
Jul 181,285 170,361 193,718 12,433 7% 23,357 14%
Aug 294,665 163,223 198,576 (96,088) ‐33% 35,354 22%
Sep 160,616 123,853 151,310 (9,305) ‐6% 27,458 22%
Oct 152,817 135,225 156,212 3,395 2% 20,987 16%
Nov 327,568 107,180 125,698 (201,870) ‐62% 18,518 17%
Dec 425,765 373,659 468,107 42,342 10% 94,448 25%
YTD Total 3,187,241$ 1,929,617$ 2,478,278$ (708,963)$ ‐22% 548,661$ 28%
Annual Total 3,187,241$ 1,929,617$
Year to Date through December
Month
2017 vs. Budget2017 vs. 2016
Miscellaneous Revenues by Month
2016 2017 2017
Actual Budget Actual $ % $ %
Interests and Other Earnings 1,058,880$ 875,300$ 1,155,371$ 96,490$ 9% 280,071$ 32%
Rents, Leases, and Concessions 642,192 623,195 634,897 (7,295) ‐1% 11,702 2%
Contributions/Donations from Private Sources 96,582 175,500 177,919 81,337 84% 2,419 1%
Other 402,294 255,622 333,588 (68,706) ‐17% 77,966 31%
Seizure Funds ‐ Federal/State/Local 987,293 ‐ 176,503 (810,790) ‐82% 176,503 100%
YTD Total 3,187,241$ 1,929,617$ 2,478,278$ (708,963)$ ‐22% 548,661$ 28%
Annual Total 3,187,241$ 1,929,617$
2017 vs. Budget
Miscellaneous Revenues by Type
Year to Date through December
Revenue
2017 vs. 2016
Page 9 of 38
Monthly Financial Report December 2017
EXPENSES
Overall the City has expended 93% of its budgeted general governmental expenditures at the end of December. This is $7.4M
or 6.7% below year‐to‐date budgeted expenditures. $1.3M of the savings is related to various staffing vacancies in several
departments/divisions. $3.4M of the savings will need to be carried forward (CF) into 2018:
$1M CF/savings for PD take home cars
$704K CF for seizure funds ($250K will be used for PD take home cars)
$1M CF for FS15 equipment
$88.5K CF/new for 2017 voter registration
$500K CF for CDBG and Port of Seattle Grant
$105K CF for CS/Neighbourhoods, Resources, & Events (various special events)
Remaining $2.7M in savings have not been identified for CF, but will be based on further review into the CF budget
amendment process.
The City did not have any general governmental departments over budget but we did see some divisions within those
departments over budget. Please refer to the General Governmental Funds Summary of Sources and Uses table on page 1
for details.
Page 10 of 38
Monthly Financial Report December 2017
CASH AND INVESTMENTS –
4TH QUARTER
The current cash and
investments (C&I)
portfolio is provided in
the table to the right. The
City’s current C&I balance
is $209.6M. Currently,
the majority of the
portfolio is located in cash
deposits (US Bank) and
the State Investment
Pool. The rest is spread
out between US Federal
Agency Securities and
various certificates of
deposits.
The existing portfolio yield is approximately 1.03%.
Current %
Blended
Allowed
per policy
Current Portfolio
(principal value)
34% N/A $ 70,422,386
0% 100%‐$
43% 75% 90,923,543$
8% 75% 16,747,500$
15% 75% 31,482,542$
0% 25%‐$
TOTAL INVESTMENTS 100% 209,575,970$
*Excluding Cash the portfolio distribution is 65% LGIP; 23% CD's; 12% GSE's
Cash
US Treasury Securities
Local Government Investment Pool
US Federal Agency Securities
Certificates of Deposit
Commercial Paper
By Type
Cash
34%
LGIP
43%
GSE's
8%
CD's
15%
Distribution by Type
By Institution Current %
Blended
Allowed by
Policy
Current Portfolio
(principal value)Maturity Date APY
Weighted
Yield
Blended
Current
Principal
Balance
Cash US Bank ‐ Cash 34%N/A 70,422,386 overnight 0.45% 0.15%70,422,386
US Treasury Securities
none 0% 100%‐ N/A N/A N/A
‐
Local Government Investment Pool
3920 State Investment Pool 43% 75%
90,923,543 10/1/2014 0.10% 0.55%90,923,543
US Federal Agency Securities *
317189A FCCB 4,000,000 9/14/2018 1.25%
0.02%
315189D FNMA 4,997,500 10/26/2018 1.06%
0.03%
317209A FHLMC 2,750,000 4/27/2020 1.58%0.02%
317209B FHLMC 1,950,000 4/27/2020 1.63%
0.02%
317209C FHLMC 3,050,000 5/22/2020 1.63%
0.02%
Certificates of Deposit
115184A First Savings Bank Northwest 5,092,087 2/6/2018 1.03%0.03%
116214A First Savings Bank Northwest 5,154,418 2/3/2021 1.67%0.04%
117204A First Savings Bank Northwest 5,175,781 10/29/2020 1.85%
0.05%
116191A Opus 5,000,000 2/25/2019 1.00%
0.02%
116181A Opus 5,000,000 12/21/2018 1.35%0.03%
116191B Opus 5,000,000 12/21/2019 1.60%0.04%
216183A Commencement Bank (CDARS)1%1,060,257 9/16/2018 1.00%
0.01%1,060,257
Commercial Paper
none 0.00%5%‐ N/A N/AN/A ‐
209,575,970$ 209,575,970$
16,747,500 75%8%
15,422,285
*Held in our safekeeping account at BNY Trust and Custody
TOTAL CASH & INVESTMENTS
20%
7%
15,000,000 7%
Page 11 of 38
Monthly Financial Report December 2017
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 ‐ ‐ ‐ ‐ 89,890 41,100 ‐
Grants / intergovernmental 34,761 6,009 134,063 ‐ 1,232,421 1,648,469 ‐
Charges for services 200,175 1,844,620 19,477,238 17,733,532 10,437,806 11,392,726 16,883,456
Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐
Fines and penalties 1,378 ‐ ‐ ‐ 970 ‐ ‐
Rents, leases, and misc fees 2,626,371 410,853 11,857 159,015 ‐ ‐ ‐
Interest and other misc 24,792 (59,581) 48,097 4,639,105 3,371,577 1,986,946 38,803
TOTAL REVENUES 2,887,477 2,201,901 19,671,255 22,531,652 15,132,664 15,069,241 16,922,259
EXPENSES:
Utility billing ‐ ‐ 43,544 156,221 126,169 192,743 ‐
Utility systems ‐ ‐ 19,031,858 3,852,700 3,425,062 4,435,508 ‐
Utility maintenance ‐ ‐ 346,588 5,901,214 2,188,396 2,824,542 16,827,147
Transportation 1,762,448 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 2,166,727 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 1,762,448 2,166,727 19,421,990 9,910,135 5,739,627 7,452,793 16,827,147
AMOUNT AVAILABLE FOR DEBT SERVICE 1,125,029 35,174 249,265 12,621,517 9,393,037 7,616,448 95,112
DEBT SERVICE:
Principal ‐ ‐ ‐ 4,721,253 2,158,820 1,598,904 ‐
Interest ‐ ‐ ‐ 389,285 180,591 695,391 ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ 5,110,538 2,339,411 2,294,295 ‐
CAPITAL PROJECTS 285,183 66,995 ‐ 2,122,415 3,113,579 2,214,989 ‐
TRANSFERS IN/(OUT)‐ ‐ (370) (3,933) (389,705) (66,435) ‐
CH ANGE IN FUND BALANCE 839,846 (31,821) 248,895 5,384,631 3,550,342 3,040,729 95,112
BEGINNING FUND BALANCE, Jan 1 2,619,343 37,088 2,751,417 28,528,934 13,859,662 10,893,975 4,994,658
ENDING FUND BALANCE, Dec 31 3,459,189 5,267 3,000,312 33,913,565 17,410,004 13,934,704 5,089,770
Page 12 of 38
Monthly Financial Report December 2017
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 ‐ 205,921 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ 7,110 ‐ ‐ ‐ ‐ 47,440
Charges for services
Equipment rental m&o 2,728,597 4,250,415 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ ‐ ‐ 439,335 ‐ ‐ ‐
Communications ‐ 794,502 ‐ 637,918 ‐ ‐ ‐
Facilities ‐ ‐ 5,023,015 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ ‐ ‐ ‐ ‐ ‐ ‐
IT service co ntracts ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest and other misc 49,192 23,254 12,232 4,394 97,191 34,109 82,235
Internal service fund misc:
Vehicle / equipment capital recovery 2,214,005 483,956 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 1,716,276 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 1,364,787 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 9,252,695 2,624,684
Other misc 374 47 33,290 20 ‐ 929,743 ‐
Interfund Loan ‐ ‐ ‐ ‐ 175,000 ‐ ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets 209,301 ‐ ‐ 100 ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 186,898 ‐ ‐
TOTAL REVENUES 5,201,469 5,765,205 5,068,537 1,081,767 3,540,152 10,216,547 2,754,359
EXPENSES:
Communications 608,024
Equipment rental 2,415,687
Facilities 4,707,966
Healthcare 9,665,332
Information technology 4,340,685
Print and mail 408,525
Retiree healthcare 946,266
Risk management:
Risk ma nagement 1,478,848
Unemployment 51,343
Worker's compensation 1,231,339
TOTAL EXPENSES 2,415,687 4,340,685 4,707,966 1,016,549 2,761,530 9,665,332 946,266
AMOUNT AVAILABLE FOR CAPITAL 2,785,782 1,424,520 360,571 65,218 778,622 551,215 1,808,093
CAPITAL PROJECTS 2,990,710 534,416 30,077 ‐ ‐ ‐ ‐
TRANSFERS IN 655,495 276,582 10,700 ‐ 4,100,000 ‐ ‐
TRANSFERS (OUT)‐ ‐ (85,500) ‐ ‐ (89,876) ‐
CHANGE IN FUND BALANCE 450,567 1,166,686 255,694 65,218 4,878,622 461,339 1,808,093
BEGINNING FUND BALANCE, Jan 1 6,432,053 2,570,374 1,275,053 542,927 12,852,509 4,156,148 10,079,251
ENDING FUND BALANCE, Dec 31 6,882,620 3,737,060 1,530,747 608,145 17,731,131 4,617,487 11,887,344
Page 13 of 38
Monthly Financial Report December 2017
FUND BALANCE
Page 15 shows the ending fund balance as of December 2017. 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 December, the City has $33.3M reported in the combined general governmental fund balance of the current
year’s operating budget, which is approximately 30% of budgeted operating expenditures. This is an increase of $6.7M from
the year’s beginning balance. December’s ending fund balance is over the anticipated General Governmental Fund Balance
of $20.9M by $12.3M or 59%. 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 14 of 38
Monthly Financial Report December 2017
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through December 31, 2017
Funds
Balance
01/01/2017
Budgeted
Revenue
Revenue
12/31/17
Total Funds
Available
Budgeted
Expenditure
Expenditure
12/31/17 Ending Balance
GENERAL GOVERNMENT FUNDS: 26,563,785 104,562,764 109,530,146 136,093,931 110,190,226 102,809,093 33,284,838
000 General 18,201,028 71,439,589 76,808,186 95,009,214 77,598,966 72,301,147 22,708,066
001 Community Services 3,769,766 13,857,754 13,662,312 17,432,078 13,887,263 12,591,084 4,840,993
003 Street 1,936,367 12,005,024 12,179,565 14,115,932 11,306,335 10,972,028 3,143,904
004 Community Dev Block Grant 66,654 936,292 531,022 597,676 983,792 543,390 54,286
005 Museum 72,372 233,936 234,333 306,705 236,275 235,712 70,992
009 Farmers Market 90,730 114,844 116,749 207,479 110,966 102,155 105,323
201 Ltd GO Bonds Gen Govt Debt 852,111 1,749,675 1,761,171 2,613,282 1,749,675 1,749,550 863,732
215 Gen Govt Misc Debt Service 1,574,757 4,225,650 4,236,810 5,811,567 4,316,954 4,314,026 1,497,542
SPECIAL REVENUE F UNDS:1,599,965 1,934,729 2,483,111 4,083,076 2,189,749 1,990,023 2,093,053
102 Arterial Street 63,480 660,000 704,958 768,438 660,000 660,000 108,438
108 Leased City Properties 276,865 902,550 1,201,042 1,477,907 888,131 866,852 611,055
110 Hotel Motel 402,602 225,000 403,428 806,030 400,994 344,596 461,434
125 1% For Art 128,489 24,505 39,253 167,742 117,950 64,633 103,109
127 Cable Communication 394,504 122,674 131,927 526,431 122,674 53,942 472,489
135 Springbrook Wetlands Bank 334,025 ‐ 2,503 336,528 ‐ ‐ 336,528
CAPITAL PROJECT FUNDS (CIP): 26,202,403 42,298,215 34,074,763 60,277,166 52,879,521 23,981,683 36,295,483
303 Community Services Mitigation 1,255,194 406,014 693,656 1,948,850 54,074 39,495 1,909,355
304 Fire Mitigation 607,163 99,000 488,505 1,095,668 158,696 158,696 936,972
305 Transportation Mitigation 1,497,748 620,000 1,203,214 2,700,962 1,890,000 1,890,000 810,962
316 Municipal Facilities CIP 15,038,030 15,161,013 14,630,434 29,668,464 24,657,514 9,996,768 19,671,696
317 Transportation CIP 5,640,494 20,512,188 11,386,669 17,027,163 25,094,010 11,218,624 5,808,539
326 Housing Opportunity 1,041,173 1,500,000 1,507,802 2,548,975 ‐ ‐ 2,548,975
336 New Library Development 1,122,601 ‐ 6,592 1,129,193 1,025,227 678,100 451,093
346 New Family First Center Dvlpmnt ‐ 4,000,000 4,157,891 4,157,891 ‐ ‐ 4,157,891
ENTERPRISE FUNDS: 63,685,077 96,750,816 94,498,094 158,183,171 127,425,147 81,370,358 76,812,813
4X2 Airport Operating & CIP 2,619,343 3,405,842 2,887,478 5,506,821 5,688,023 2,047,631 3,459,190
403 Solid Waste Utility 2,751,417 19,187,851 19,671,256 22,422,673 19,024,775 19,422,360 3,000,313
4X4 Golf Operating & CIP 37,088 2,893,044 2,261,901 2,298,989 2,630,288 2,293,722 5,267
4X5 Water Operating & CIP 28,528,934 20,636,268 22,531,652 51,060,586 38,803,600 17,147,020 33,913,566
4X6 Waste Water Op erating & CIP 13,859,662 14,898,560 15,143,808 29,003,470 22,238,802 11,593,467 17,410,003
416 King County Metro 4,994,658 17,505,693 16,922,259 21,916,917 17,505,693 16,827,147 5,089,770
4X7 Surface Water Operating & CIP 10,893,975 18,223,558 15,079,740 25,973,715 21,533,966 12,039,011 13,934,704
INTERNAL SERVICE FUNDS:37,908,315 35,014,282 38,670,813 76,579,128 34,026,354 29,584,596 46,994,532
501 Equipment Repair/Replacement 6,432,053 6,494,353 5,856,964 12,289,017 7,733,113 5,406,397 6,882,620
502 I nsurance 12,852,509 7,392,368 7,640,152 20,492,661 3,571,166 2,761,531 17,731,130
503 Information Services 2,570,374 5,928,485 6,041,787 8,612,161 7,126,445 4,875,101 3,737,060
504 Facilities 1,275,053 5,077,715 5,079,237 6,354,290 5,316,091 4,823,543 1,530,747
505 Communications 542,927 1,078,253 1,081,767 1,624,694 1,076,474 1,016,550 608,144
512 Insurance, Healthcare 4,156,148 7,787,779 10,216,547 14,372,695 8,163,471 9,755,208 4,617,487
522 Insurance, Leoff1 Retirees HC 10,079,251 1,255,329 2,754,359 12,833,610 1,039,594 946,266 11,887,344
FIDUCIARY FUNDS: 5,578,045 468,000 506,951 6,084,996 210,475 252,098 5,832,898
611 Firemen's Pension 5,578,045 468,000 506,951 6,084,996 210,475 252,098 5,832,898
TOTAL FUNDS 161,537,590 281,028,806 279,763,878 441,301,468 326,921,472 239,987,851 201,313,617
Page 15 of 38
City of Renton
General Government Financial Position
2017 Budget Year
General Government Summary
Revenues Expenditures
$ Difference
over (under)
w/beginning
balance
26,563,785
January 7,364,146 6,595,136 769,010 27,332,795
February 14,472,917 13,388,134 1,084,783 27,648,568
March 21,057,303 20,198,065 859,238 27,423,023
April 39,230,543 27,006,711 12,223,832 38,787,617
May 47,996,932 34,253,900 13,743,032 40,306,817
June 54,429,132 41,552,555 12,876,577 39,440,362
July 62,729,973 49,694,920 13,035,053 39,598,838
August 69,843,380 57,216,081 12,627,299 39,191,084
September 76,428,173 64,564,463 11,863,710 38,427,495
October 88,032,675 71,278,851 16,753,824 43,317,609
November 101,061,072 78,365,889 22,695,183 49,258,968
December 109,530,146 102,809,093 6,721,053 33,284,838
(8,000,000) (7,000,000) (6,000,000) (5,000,000) (4,000,000)
(3,000,000)
(2,000,000) (1,000,000) ‐ 1,000,000 2,000,000 3,000,000
4,000,000
5,000,000 6,000,000 7,000,000 8,000,000 9,000,000
10,000,000
11,000,000 12,000,000 13,000,000 14,000,000 15,000,000 16,000,000
17,000,000
18,000,000 19,000,000 20,000,000 21,000,000 22,000,000
23,000,000
24,000,000
25,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 16 of 38
City of Renton
Monthly Revenue Analysis ‐ 2017 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,392,698 7,364,146 ‐0.39%
Feb 13,904,332 14,472,917 4.09%
Mar 20,442,901 21,057,303 3.01%
Apr 33,494,632 39,230,543 17.12%
May 45,399,934 47,996,932 5.72%
Jun 51,827,211 54,429,132 5.02%
Jul 59,600,418 62,729,973 5.25%
Aug 66,317,875 69,843,380 5.32%
Sep 72,771,453 76,428,173 5.02%
Oct 84,454,414 88,032,675 4.24%
Nov 97,343,045 101,061,072 3.82%
Dec 104,562,763 109,530,146 4.75%
Percent of budget 104.75%
Property Tax Budget
YTD
Actual
Annual %
over (under)
Jan 36,768 55,429 50.75%
Feb 241,042 250,761 4.03%
Mar 967,646 1,153,726 19.23%
Apr 6,883,291 8,189,058 18.97%
May 12,626,243 12,678,534 0.41%
Jun 12,719,859 12,807,368 0.69%
Jul 12,760,104 12,876,968 0.92%
Aug 12,870,217 12,978,317 0.84%
Sep 13,238,047 13,421,011 1.38%
Oct 17,341,593 17,478,904 0.79%
Nov 23,988,632 24,212,717 0.93%
Dec 24,103,395 24,356,562 1.05%
Percent of budget 101.05%
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
$120
$130
Millions
Total Revenue
General Government
Budget
Actual
Last Year
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
$36
$39
Millions Property Tax
Budget
Actual
Last Year
Page 17 of 38
City of Renton
Monthly Revenue Analysis ‐ 2017 Budget Year
Sales Tax Budget
YTD
Actual
Annual %
over (under)
Jan 2,273,135 2,340,558 2.97%
Feb 4,991,912 5,107,413 2.31%
Mar 7,106,616 7,282,613 2.48%
Apr 9,223,848 9,375,961 1.65%
May 11,702,869 12,040,621 2.89%
Jun 13,916,590 14,362,484 3.20%
Jul 16,191,014 16,864,294 4.16%
Aug 18,762,500 19,574,255 4.33%
Sep 21,208,945 21,993,685 3.70%
Oct 23,753,611 24,536,818 3.30%
Nov 26,423,143 27,163,350 2.80%
Dec 28,913,680 29,454,865 1.87%
Percent of budget 101.87%
Note: Excludes CJ Sales Tax and Natural Gas Use Tax.
Utility Tax Budget
YTD
Actual
Annual %
over (under)
Jan 1,300,842 1,698,721 30.59%
Feb 2,787,871 3,059,310 9.74%
Mar 4,275,077 4,256,858 ‐0.43%
Apr 5,586,631 6,054,307 8.37%
May 6,893,949 7,518,745 9.06%
Jun 8,090,821 8,870,352 9.63%
Jul 9,345,412 10,408,741 11.38%
Aug 10,640,050 11,593,978 8.97%
Sep 11,887,054 12,855,178 8.14%
Oct 13,161,903 14,283,615 8.52%
Nov 14,390,944 15,551,512 8.06%
Dec 15,753,137 16,999,203 7.91%
Percent of budget 107.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 18 of 38
City of Renton
Monthly Revenue Analysis ‐ 2017 Budget Year
Licenses &
Permits Budget
YTD
Actual
Annual %
over (under)
Jan 586,132 321,764 ‐45.10%
Feb 956,756 594,059 ‐37.91%
Mar 1,322,363 1,019,840 ‐22.88%
Apr 1,688,572 1,318,141 ‐21.94%
May 1,989,508 1,825,961 ‐8.22%
Jun 2,315,824 2,301,827 ‐0.60%
Jul 3,030,833 2,656,217 ‐12.36%
Aug 3,447,876 3,093,300 ‐10.28%
Sep 3,877,572 3,489,741 ‐10.00%
Oct 4,359,932 3,821,627 ‐12.35%
Nov 4,652,625 4,210,508 ‐9.50%
Dec 4,935,012 4,470,875 ‐9.40%
Percent of budget 90.60%
Note: GF only
Intergovt'l Budget
YTD
Actual
Annual %
over (under)
Jan 559,448 604,678 8.08%
Feb 1,084,313 1,193,433 10.06%
Mar 1,626,173 1,773,868 9.08%
Apr 2,145,472 2,313,101 7.81%
May 2,958,092 2,729,902 ‐7.71%
Jun 3,616,009 3,346,773 ‐7.45%
Jul 4,116,000 4,001,945 ‐2.77%
Aug 4,720,398 4,575,058 ‐3.08%
Sep 5,346,111 5,211,371 ‐2.52%
Oct 5,911,706 5,873,923 ‐0.64%
Nov 6,604,379 6,257,677 ‐5.25%
Dec 7,605,713 7,436,309 ‐2.23%
Percent of budget 97.77%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
$‐
$2
$4
$6
$8
$10
$12
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 19 of 38
City of Renton
Monthly Revenue Analysis ‐ 2017 Budget Year
Charges for
Services Budget
YTD
Actual
Annual %
over (under)
Jan 641,725 749,576 16.81%
Feb 1,192,622 1,295,589 8.63%
Mar 1,779,728 2,031,739 14.16%
Apr 2,574,617 2,607,404 1.27%
May 3,142,189 3,347,586 6.54%
Jun 4,270,357 4,077,898 ‐4.51%
Jul 5,207,148 5,052,850 ‐2.96%
Aug 6,077,059 5,992,324 ‐1.39%
Sep 6,705,746 6,661,946 ‐0.65%
Oct 7,327,762 7,230,905 ‐1.32%
Nov 7,947,988 7,901,039 ‐0.59%
Dec 8,677,538 8,540,911 ‐1.57%
Percent of budget 98.43%
Note: Excludes FD25 & FD40 contracts
Fines &
Forfeits Budget
YTD
Actual
Annual %
over (under)
Jan 126,199 134,957 6.94%
Feb 339,355 352,013 3.73%
Mar 603,740 564,199 ‐6.55%
Apr 845,911 807,015 ‐4.60%
May 1,077,838 1,036,892 ‐3.80%
Jun 1,339,137 1,339,558 0.03%
Jul 1,558,308 1,586,818 1.83%
Aug 1,810,632 1,885,502 4.14%
Sep 2,043,253 2,105,927 3.07%
Oct 2,287,023 2,380,172 4.07%
Nov 2,557,964 2,620,911 2.46%
Dec 2,868,450 2,946,849 2.73%
Percent of budget 102.73%
$‐
$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 20 of 38
City of Renton
Monthly Revenue Analysis ‐ 2017 Budget Year
Other Taxes Budget
YTD
Actual
Annual %
over (under)
Jan 1,656,308 1,094,465 ‐33.92%
Feb 1,978,128 2,107,354 6.53%
Mar 2,296,804 2,310,521 0.60%
Apr 3,970,819 7,618,498 91.86%
May 4,316,724 5,718,954 32.48%
Jun 4,702,000 6,043,234 28.52%
Jul 6,364,625 7,806,041 22.65%
Aug 6,798,946 8,474,829 24.65%
Sep 7,153,749 8,858,512 23.83%
Oct 8,864,681 10,433,287 17.70%
Nov 9,222,107 11,024,236 19.54%
Dec 9,605,026 12,563,082 30.80%
Percent of budget 130.80%
Misc Budget
YTD
Actual
Annual %
over (under)
Jan 212,142 363,997 71.58%
Feb 332,333 512,986 54.36%
Mar 464,753 663,940 42.86%
Apr 575,471 852,826 48.20%
May 692,521 1,005,505 45.19%
Jun 856,117 1,184,657 38.38%
Jul 1,026,478 1,378,374 34.28%
Aug 1,189,700 1,576,951 32.55%
Sep 1,313,553 1,728,261 31.57%
Oct 1,448,778 1,884,473 30.07%
Nov 1,555,958 2,010,171 29.19%
Dec 1,929,617 2,478,278 28.43%
Percent of budget 128.43%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
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 21 of 38
City of Renton
Monthly Revenue Analysis ‐ 2017 Budget Year
Other
Financing Budget
YTD
Actual
Annual %
over (under)
Jan ‐ ‐ N/A
Feb ‐ ‐ N/A
Mar ‐ ‐ N/A
Apr ‐ 94,231 100.00%
May ‐ 94,231 100.00%
Jun 496 94,981 19031.36%
Jul 496 97,726 19584.19%
Aug 496 98,866 19813.79%
Sep (2,576) 102,541 ‐4079.84%
Oct (2,576) 108,951 ‐4328.63%
Nov (695) 108,951 ‐15775.08%
Dec 171,196 283,213 65.43%
Percent of budget 165.43%
REET Budget
YTD
Actual
Annual %
over (under)
Jan 796,327 1,028,456 29.15%
Feb 969,814 1,365,480 40.80%
Mar 1,215,402 2,074,348 70.67%
Apr 1,570,422 2,459,865 56.64%
May 1,992,499 2,845,952 42.83%
Jun 2,402,718 3,593,502 49.56%
Jul 2,985,156 4,184,639 40.18%
Aug 3,536,615 4,857,035 37.34%
Sep 4,006,487 5,490,839 37.05%
Oct 4,515,503 5,850,729 29.57%
Nov 4,847,713 6,625,978 36.68%
Dec 5,170,000 7,211,736 39.49%
Percent of budget 139.49%
$‐
$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
‐$1
$0
$1
$1
$2
$2
$3
Mi
l
l
i
o
n
s
Other Financing Sources
Budget
Actual
Last Year
Page 22 of 38
City of Renton
Monthly Revenue Analysis ‐ 2017 Budget Year
Bldg Permits
& Devlpmt Svc
Fees Budget
YTD
Actual
Annual %
over (under)
Jan 481,500 399,548 ‐17.02%
Feb 861,115 676,844 ‐21.40%
Mar 1,301,962 1,180,134 ‐9.36%
Apr 1,786,635 1,445,882 ‐19.07%
May 2,096,984 2,004,656 ‐4.40%
Jun 2,795,383 2,616,096 ‐6.41%
Jul 3,487,109 2,880,611 ‐17.39%
Aug 3,925,839 3,313,654 ‐15.59%
Sep 4,424,411 3,759,217 ‐15.03%
Oct 4,902,760 4,097,515 ‐16.42%
Nov 5,262,700 4,576,532 ‐13.04%
Dec 5,735,368 4,907,983 ‐14.43%
Percent of budget 85.57%
B & O Tax Budget
YTD
Actual
Annual %
over (under)
Jan 1,500,000 432,319 ‐71.18%
Feb 1,687,500 1,226,412 ‐27.32%
Mar 1,875,000 1,239,641 ‐33.89%
Apr 3,375,000 5,866,521 73.82%
May 3,562,500 6,183,312 73.57%
Jun 3,750,000 6,206,803 65.51%
Jul 5,250,000 7,345,843 39.92%
Aug 5,437,500 7,745,219 42.44%
Sep 5,625,000 7,915,010 40.71%
Oct 7,125,000 8,896,427 24.86%
Nov 7,312,500 9,217,133 26.05%
Dec 7,500,000 9,633,034 28.44%
Percent of budget 128.44%
$‐
$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 23 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,316,510 6,595,136 ‐9.86%
Feb 14,383,362 13,388,134 ‐6.92%
Mar 22,216,418 20,198,065 ‐9.08%
Apr 29,335,397 27,006,711 ‐7.94%
May 40,200,859 34,253,900 ‐14.79%
Jun 48,645,183 41,552,555 ‐14.58%
Jul 60,191,578 49,694,920 ‐17.44%
Aug 68,031,777 57,216,081 ‐15.90%
Sep 75,956,996 64,564,463 ‐15.00%
Oct 83,872,817 71,278,851 ‐15.02%
Nov 91,115,073 78,365,889 ‐13.99%
Dec 110,190,225 102,809,093 ‐6.70%
Percent of budget expended 93.30%
Legislative Budget
YTD
Actual
Annual %
over (under)
Jan 36,183 36,043 ‐0.39%
Feb 66,236 64,877 ‐2.05%
Mar 101,649 97,498 ‐4.08%
Apr 131,509 127,629 ‐2.95%
May 161,207 157,670 ‐2.19%
Jun 190,925 187,856 ‐1.61%
Jul 219,892 216,595 ‐1.50%
Aug 249,074 245,568 ‐1.41%
Sep 278,319 274,509 ‐1.37%
Oct 308,035 303,126 ‐1.59%
Nov 337,502 331,903 ‐1.66%
Dec 368,211 362,101 ‐1.66%
Percent of budget expended 98.34%
$‐
$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 24 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
Executive Budget
YTD
Actual
Annual %
over (under)
Jan 217,181 211,310 ‐2.70%
Feb 363,825 350,285 ‐3.72%
Mar 549,441 490,536 ‐10.72%
Apr 695,792 632,403 ‐9.11%
May 841,124 793,626 ‐5.65%
Jun 1,005,349 963,928 ‐4.12%
Jul 1,151,389 1,110,100 ‐3.59%
Aug 1,316,295 1,290,543 ‐1.96%
Sep 1,505,622 1,426,031 ‐5.29%
Oct 1,652,178 1,596,730 ‐3.36%
Nov 1,799,173 1,737,132 ‐3.45%
Dec 2,007,671 1,954,748 ‐2.64%
Percent of budget expended 97.36%
Emergency
Management Budget
YTD
Actual
Annual %
over (under)
Jan 63,184 35,052 ‐44.52%
Feb 104,484 75,996 ‐27.27%
Mar 156,084 120,198 ‐22.99%
Apr 197,331 171,474 ‐13.10%
May 238,910 219,758 ‐8.02%
Jun 287,314 267,919 ‐6.75%
Jul 329,069 314,737 ‐4.36%
Aug 399,866 370,942 ‐7.23%
Sep 448,780 424,170 ‐5.48%
Oct 492,637 473,196 ‐3.95%
Nov 535,475 523,795 ‐2.18%
Dec 609,249 569,333 ‐6.55%
Percent of budget expended 93.45%
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
$2.40
Millions Executive
Budget
Actual
Last Year
$‐
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
Emergency Management
Budget
Actual
Last Year
Page 25 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
City Attorney Budget
YTD
Actual
Annual %
over (under)
Jan 176,840 168,105 ‐4.94%
Feb 356,198 333,751 ‐6.30%
Mar 539,974 508,012 ‐5.92%
Apr 727,889 694,752 ‐4.55%
May 911,796 866,583 ‐4.96%
Jun 1,096,207 1,038,696 ‐5.25%
Jul 1,281,325 1,211,095 ‐5.48%
Aug 1,466,602 1,384,646 ‐5.59%
Sep 1,658,357 1,559,146 ‐5.98%
Oct 1,826,387 1,734,835 ‐5.01%
Nov 1,995,101 1,908,369 ‐4.35%
Dec 2,163,329 2,088,718 ‐3.45%
Percent of budget expended 96.55%
Court Services Budget
YTD
Actual
Annual %
over (under)
Jan 174,688 169,642 ‐2.89%
Feb 359,261 343,353 ‐4.43%
Mar 546,129 523,105 ‐4.22%
Apr 731,190 708,103 ‐3.16%
May 919,420 888,624 ‐3.35%
Jun 1,116,580 1,072,725 ‐3.93%
Jul 1,303,785 1,252,041 ‐3.97%
Aug 1,494,740 1,429,897 ‐4.34%
Sep 1,689,236 1,614,919 ‐4.40%
Oct 1,876,650 1,796,548 ‐4.27%
Nov 2,063,510 1,982,165 ‐3.94%
Dec 2,265,056 2,174,217 ‐4.01%
Percent of budget expended 95.99%
$‐
$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 26 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
CED Admin Budget
YTD
Actual
Annual %
over (under)
Jan 105,708 109,731 3.81%
Feb 212,008 219,758 3.66%
Mar 318,307 329,786 3.61%
Apr 427,006 439,814 3.00%
May 536,809 549,841 2.43%
Jun 646,136 669,673 3.64%
Jul 810,818 781,490 ‐3.62%
Aug 917,941 893,461 ‐2.67%
Sep 1,025,297 1,005,432 ‐1.94%
Oct 1,132,181 1,116,598 ‐1.38%
Nov 1,238,672 1,227,699 ‐0.89%
Dec 1,350,991 1,351,830 0.06%
Percent of budget expended 100.06%
Development
Services Budget
YTD
Actual
Annual %
over (under)
Jan 247,440 239,337 ‐3.27%
Feb 524,348 501,405 ‐4.38%
Mar 795,548 754,102 ‐5.21%
Apr 1,052,842 1,024,029 ‐2.74%
May 1,323,124 1,282,903 ‐3.04%
Jun 1,597,665 1,542,242 ‐3.47%
Jul 1,867,478 1,806,056 ‐3.29%
Aug 2,149,867 2,066,905 ‐3.86%
Sep 2,441,388 2,334,025 ‐4.40%
Oct 2,715,837 2,598,327 ‐4.33%
Nov 2,987,883 2,912,793 ‐2.51%
Dec 3,285,005 3,023,728 ‐7.95%
Percent of budget expended 92.05%
$‐
$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 27 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
Economic
Development Budget
YTD
Actual
Annual %
over (under)
Jan 90,596 46,869 ‐48.27%
Feb 223,992 98,329 ‐56.10%
Mar 328,160 140,672 ‐57.13%
Apr 500,822 190,278 ‐62.01%
May 620,811 342,370 ‐44.85%
Jun 764,702 435,487 ‐43.05%
Jul 910,328 490,157 ‐46.16%
Aug 1,024,032 580,426 ‐43.32%
Sep 1,130,175 702,684 ‐37.83%
Oct 1,325,387 754,788 ‐43.05%
Nov 1,473,922 815,203 ‐44.69%
Dec 1,613,665 949,467 ‐41.16%
Percent of budget expended 58.84%
Planning Budget
YTD
Actual
Annual %
over (under)
Jan 252,370 221,112 ‐12.39%
Feb 508,667 449,900 ‐11.55%
Mar 782,992 681,350 ‐12.98%
Apr 1,052,478 906,510 ‐13.87%
May 1,364,739 1,134,729 ‐16.85%
Jun 1,665,650 1,353,531 ‐18.74%
Jul 1,941,198 1,570,361 ‐19.10%
Aug 2,220,251 1,787,262 ‐19.50%
Sep 2,520,087 1,999,301 ‐20.67%
Oct 2,807,101 2,215,869 ‐21.06%
Nov 3,069,939 2,445,474 ‐20.34%
Dec 3,342,786 2,815,148 ‐15.78%
Percent of budget expended 84.22%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
Millions
Economic Development
Budget
Actual
Last Year
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
Millions
Planning
Budget
Actual
Last Year
Page 28 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
Finance Budget
YTD
Actual
Annual %
over (under)
Jan 216,257 197,230 ‐8.80%
Feb 432,725 425,531 ‐1.66%
Mar 646,873 630,778 ‐2.49%
Apr 865,750 856,650 ‐1.05%
May 1,099,214 1,073,519 ‐2.34%
Jun 1,424,251 1,301,674 ‐8.61%
Jul 1,642,231 1,565,684 ‐4.66%
Aug 2,015,462 1,817,314 ‐9.83%
Sep 2,251,751 2,031,969 ‐9.76%
Oct 2,487,338 2,272,237 ‐8.65%
Nov 2,708,242 2,501,966 ‐7.62%
Dec 3,407,369 3,132,609 ‐8.06%
Percent of budget expended 91.94%
City Clerk Budget
YTD
Actual
Annual %
over (under)
Jan 78,434 62,018 ‐20.93%
Feb 189,186 322,088 70.25%
Mar 278,847 387,366 38.92%
Apr 369,230 459,577 24.47%
May 460,538 533,887 15.93%
Jun 552,158 606,380 9.82%
Jul 646,835 680,117 5.15%
Aug 816,873 751,477 ‐8.01%
Sep 832,467 825,121 ‐0.88%
Oct 948,567 896,304 ‐5.51%
Nov 1,045,159 976,122 ‐6.61%
Dec 1,239,455 1,119,376 ‐9.69%
Percent of budget expended 90.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
Millions Finance
Budget
Actual
Last Year
Page 29 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
Human
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 89,142 87,874 ‐1.42%
Feb 195,491 175,377 ‐10.29%
Mar 317,705 273,335 ‐13.97%
Apr 435,958 395,728 ‐9.23%
May 545,888 492,849 ‐9.72%
Jun 654,767 592,817 ‐9.46%
Jul 763,876 699,070 ‐8.48%
Aug 881,606 800,394 ‐9.21%
Sep 989,949 905,158 ‐8.57%
Oct 1,112,832 1,017,040 ‐8.61%
Nov 1,220,753 1,116,195 ‐8.57%
Dec 1,359,317 1,221,841 ‐10.11%
Percent of budget expended 89.89%
Police Budget
YTD
Actual
Annual %
over (under)
Jan 3,071,356 2,964,875 ‐3.47%
Feb 5,823,299 5,600,968 ‐3.82%
Mar 9,096,016 8,701,186 ‐4.34%
Apr 11,881,396 11,416,735 ‐3.91%
May 15,025,887 14,450,621 ‐3.83%
Jun 17,918,154 17,182,081 ‐4.11%
Jul 21,155,419 20,754,850 ‐1.89%
Aug 23,988,157 23,624,806 ‐1.51%
Sep 27,215,162 26,747,506 ‐1.72%
Oct 30,107,802 29,482,171 ‐2.08%
Nov 33,171,638 32,575,023 ‐1.80%
Dec 36,680,126 35,794,490 ‐2.41%
Percent of budget expended 97.59%
$‐
$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 30 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
Community
Services Admin Budget
YTD
Actual
Annual %
over (under)
Jan 48,329 44,101 ‐8.75%
Feb 101,910 84,711 ‐16.88%
Mar 147,422 128,246 ‐13.01%
Apr 190,653 168,961 ‐11.38%
May 232,862 214,954 ‐7.69%
Jun 272,191 254,219 ‐6.60%
Jul 316,663 294,560 ‐6.98%
Aug 360,730 336,379 ‐6.75%
Sep 404,945 375,461 ‐7.28%
Oct 448,567 415,405 ‐7.39%
Nov 492,198 456,199 ‐7.31%
Dec 563,654 554,951 ‐1.54%
Percent of budget expended 98.46%
Parks Budget
YTD
Actual
Annual %
over (under)
Jan 347,594 309,997 ‐10.82%
Feb 721,741 630,236 ‐12.68%
Mar 1,115,607 989,660 ‐11.29%
Apr 1,515,120 1,374,644 ‐9.27%
May 1,916,439 1,753,298 ‐8.51%
Jun 2,361,763 2,138,544 ‐9.45%
Jul 2,879,343 2,568,387 ‐10.80%
Aug 3,372,507 3,023,118 ‐10.36%
Sep 3,882,283 3,513,533 ‐9.50%
Oct 4,333,779 3,918,443 ‐9.58%
Nov 4,732,770 4,310,138 ‐8.93%
Dec 5,179,955 4,816,736 ‐7.01%
Percent of budget expended 92.99%
$‐
$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 31 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
Parks Planning
and Natural
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 66,732 53,458 ‐19.89%
Feb 141,820 140,186 ‐1.15%
Mar 228,022 204,477 ‐10.33%
Apr 302,447 289,729 ‐4.20%
May 420,850 369,879 ‐12.11%
Jun 528,260 461,775 ‐12.59%
Jul 633,665 554,297 ‐12.53%
Aug 754,109 667,579 ‐11.47%
Sep 878,846 758,713 ‐13.67%
Oct 1,003,331 841,880 ‐16.09%
Nov 1,116,062 938,972 ‐15.87%
Dec 1,269,569 1,059,058 ‐16.58%
Percent of budget expended 83.42%
Recreation Budget
YTD
Actual
Annual %
over (under)
Jan 375,392 347,558 ‐7.41%
Feb 777,039 729,951 ‐6.06%
Mar 1,194,529 1,120,569 ‐6.19%
Apr 1,621,359 1,523,454 ‐6.04%
May 2,043,886 1,886,814 ‐7.68%
Jun 2,507,300 2,298,110 ‐8.34%
Jul 3,180,141 2,894,508 ‐8.98%
Aug 3,874,805 3,510,278 ‐9.41%
Sep 4,439,159 4,067,733 ‐8.37%
Oct 4,857,478 4,466,281 ‐8.05%
Nov 5,275,717 4,862,184 ‐7.84%
Dec 5,720,955 5,278,631 ‐7.73%
Percent of budget expended 92.27%
$‐
$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
Millions Recreation
Budget
Actual
Last Year
Page 32 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
Human
Services Budget
YTD
Actual
Annual %
over (under)
Jan 87,480 98,615 12.73%
Feb 212,007 170,784 ‐19.44%
Mar 356,597 256,318 ‐28.12%
Apr 551,768 333,897 ‐39.49%
May 648,316 513,338 ‐20.82%
Jun 736,970 584,702 ‐20.66%
Jul 889,239 754,865 ‐15.11%
Aug 1,021,687 879,654 ‐13.90%
Sep 1,115,105 940,189 ‐15.69%
Oct 1,332,980 1,125,006 ‐15.60%
Nov 1,438,714 1,256,572 ‐12.66%
Dec 1,688,578 1,634,387 ‐3.21%
Percent of budget expended 96.79%
Neighborhoods
, Resources,
and Events Budget
YTD
Actual
Annual %
over (under)
Jan 85,560 60,703 ‐29.05%
Feb 191,666 125,601 ‐34.47%
Mar 284,838 198,834 ‐30.19%
Apr 364,363 266,753 ‐26.79%
May 456,960 337,861 ‐26.06%
Jun 550,630 414,589 ‐24.71%
Jul 694,993 526,036 ‐24.31%
Aug 811,349 631,442 ‐22.17%
Sep 917,991 727,920 ‐20.71%
Oct 1,016,269 804,485 ‐20.84%
Nov 1,105,244 875,044 ‐20.83%
Dec 1,264,095 983,864 ‐22.17%
Percent of budget expended 77.83%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
Millions Human Services
Budget
Actual
Last Year
$‐
$200,000
$400,000
$600,000
$800,000
$1,000,000
$1,200,000
$1,400,000
Neighborhoods, Resources, and Events
Budget
Actual
Last Year
Page 33 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
Museum Fund Budget
YTD
Actual
Annual %
over (under)
Jan 19,490 19,400 ‐0.46%
Feb 38,851 39,555 1.81%
Mar 57,801 59,213 2.44%
Apr 77,036 79,223 2.84%
May 96,758 97,324 0.59%
Jun 116,580 115,602 ‐0.84%
Jul 136,413 135,354 ‐0.78%
Aug 156,373 155,172 ‐0.77%
Sep 176,366 175,375 ‐0.56%
Oct 196,623 195,468 ‐0.59%
Nov 216,498 215,835 ‐0.31%
Dec 236,275 235,712 ‐0.24%
Percent of budget expended 99.76%
Public Works
Admin Budget
YTD
Actual
Annual %
over (under)
Jan 33,358 33,498 0.42%
Feb 68,245 67,352 ‐1.31%
Mar 102,054 101,914 ‐0.14%
Apr 135,775 135,878 0.08%
May 169,617 169,665 0.03%
Jun 203,557 203,650 0.05%
Jul 237,559 237,592 0.01%
Aug 272,046 271,835 ‐0.08%
Sep 306,358 306,988 0.21%
Oct 339,748 340,310 0.17%
Nov 373,069 373,534 0.12%
Dec 406,398 406,781 0.09%
Percent of budget expended 100.09%
$‐
$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 34 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
Street
Maintenance Budget
YTD
Actual
Annual %
over (under)
Jan 439,569 408,757 ‐7.01%
Feb 886,721 920,483 3.81%
Mar 1,366,996 1,383,891 1.24%
Apr 1,835,020 1,913,150 4.26%
May 2,295,588 2,408,369 4.91%
Jun 2,759,772 2,877,748 4.27%
Jul 3,256,692 3,319,755 1.94%
Aug 3,742,444 3,780,074 1.01%
Sep 4,214,166 4,250,178 0.85%
Oct 4,682,566 4,698,648 0.34%
Nov 5,131,438 5,132,052 0.01%
Dec 5,636,437 5,603,141 ‐0.59%
Percent of budget expended 99.41%
Transportation Budget
YTD
Actual
Annual %
over (under)
Jan 340,428 326,959 ‐3.96%
Feb 706,499 694,002 ‐1.77%
Mar 1,247,152 1,046,712 ‐16.07%
Apr 1,619,928 1,531,026 ‐5.49%
May 2,095,850 2,065,482 ‐1.45%
Jun 2,513,261 2,511,785 ‐0.06%
Jul 2,960,840 2,953,908 ‐0.23%
Aug 3,404,337 3,395,218 ‐0.27%
Sep 3,854,060 3,825,910 ‐0.73%
Oct 4,693,977 4,215,981 ‐10.18%
Nov 5,071,355 4,645,164 ‐8.40%
Dec 5,669,897 5,368,887 ‐5.31%
Percent of budget expended 94.69%
$‐
$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 35 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
Debt Service Budget
YTD
Actual
Annual %
over (under)
Jan 21,541 41,377 92.08%
Feb 137,629 291,694 111.94%
Mar 137,629 293,691 113.39%
Apr 141,519 293,691 107.53%
May 3,312,566 293,691 ‐91.13%
Jun 3,581,050 859,786 ‐75.99%
Jul 3,699,981 1,111,163 ‐69.97%
Aug 3,816,069 1,361,480 ‐64.32%
Sep 3,817,680 1,361,480 ‐64.34%
Oct 3,869,714 1,361,480 ‐64.82%
Nov 3,869,714 1,361,480 ‐64.82%
Dec 6,066,629 6,063,576 ‐0.05%
Percent of budget expended 99.95%
Non‐
Departmental
Other City Budget
YTD
Actual
Annual %
over (under)
Jan 631,657 301,517 ‐52.27%
Feb 1,039,514 531,962 ‐48.83%
Mar 1,520,046 776,618 ‐48.91%
Apr 1,911,216 1,072,621 ‐43.88%
May 2,461,701 1,356,243 ‐44.91%
Jun 3,593,992 1,617,036 ‐55.01%
Jul 7,282,408 1,892,140 ‐74.02%
Aug 7,504,555 2,160,209 ‐71.21%
Sep 7,963,448 2,411,010 ‐69.72%
Oct 8,304,853 2,637,698 ‐68.24%
Nov 8,645,325 2,884,877 ‐66.63%
Dec 16,795,551 14,245,763 ‐15.18%
Percent of budget expended 84.82%
$‐
$2.00
$4.00
$6.00
$8.00
$10.00
$12.00
$14.00
$16.00
$18.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 36 of 38
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2017 Budget Year
Utilities Budget Revenue Expense
Jan 4,571,586 6,899,538 3,629,075
Feb 11,110,840 13,370,807 7,900,322
Mar 17,641,639 19,032,931 12,269,408
Apr 24,067,140 24,791,562 19,152,344
May 30,676,489 31,698,603 24,885,271
Jun 40,496,131 38,440,101 31,089,893
Jul 47,776,948 45,643,871 38,955,538
Aug 61,130,459 53,462,764 45,109,789
Sep 73,377,308 67,860,074 55,682,855
Oct 96,911,662 74,684,009 60,779,840
Nov 104,294,910 80,889,839 68,104,579
Dec 119,106,836 89,348,593 77,023,932
Percent of budget expended 44.19%
Note: Operations and Capital
Airport Budget Revenue Expense
Jan 288,895 255,451 164,122
Feb 697,977 475,859 305,251
Mar 1,160,641 696,609 405,972
Apr 1,606,298 933,649 560,448
May 1,968,738 1,172,554 700,195
Jun 2,393,975 1,404,923 836,327
Jul 2,822,454 1,639,436 1,063,741
Aug 3,228,920 1,881,075 1,197,935
Sep 3,781,625 2,105,294 1,387,856
Oct 4,374,658 2,362,338 1,521,287
Nov 4,712,186 2,493,557 1,815,431
Dec 5,688,023 2,887,478 2,047,631
Percent of budget expended 36.00%
Note: Operations and Capital
$0
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
$120
$130
Millions Utilities
Budget
Revenue
Expense
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
Millions Airport
Budget
Revenue
Expense
Page 37 of 38
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2017 Budget Year
Golf Course Budget Revenue Expense
Jan 137,464 60,345 141,202
Feb 293,683 133,495 325,022
Mar 489,627 226,967 523,715
Apr 658,337 415,629 739,488
May 838,487 699,291 933,160
Jun 1,035,356 975,459 1,181,928
Jul 1,262,542 1,367,250 1,387,578
Aug 1,469,281 1,669,761 1,625,803
Sep 1,655,432 1,909,731 1,845,472
Oct 1,851,777 1,984,668 2,030,657
Nov 2,026,038 2,092,489 2,213,714
Dec 2,630,288 2,261,901 2,293,722
Percent of budget expended 87.20%
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 38 of 38