HomeMy WebLinkAbout201711, November
h:\finance\financial reporting\monthly reports\2017 reports\cover 1117.docx
ADMINISTRATIVE SERVICES
M E M O R A N D U M
DATE: January 11, 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: November 2017 Financial Status Report
At the end of November, general governmental revenues show $4.2M or 4.4% over
budget. Revenue source(s) that are higher than expected are: property tax ($224K); sales
tax ($663K); utility taxes ($1.2M); franchise fees ($212K); gambling taxes ($586K);
business & occupation taxes ($1.8M); business license ($148K); state shared revenues
($287K); public safety ($187K); seizure funds ($169K), restricted to drug enforcement and
not available for general purposes); interest ($240K); and other miscellaneous ($256K). If
we remove B&O taxes and seizure funds, general governmental revenues are $2.2M or
2.3% over budget. On the down side, the revenue source(s) that are underperforming
the year to date budget are: admission tax ($141K below); real estate excise tax ($694K
below); building permits & development service fees ($686K below); and
interfund/interdept charges for services ($217K below).
General government expenditures showed a favorable variance of $4.4M or 5.3%. See
page 10 of report for further expenditure over‐spent 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
January 11, 2018
h:\finance\financial reporting\monthly reports\2017 reports\cover 1117.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,165,159 37,038,480 36,893,234 24,103,395 23,988,632 24,212,717 224,086 0.9%
Sales Tax 23,439,266 21,418,213 26,353,246 24,149,557 25,850,400 23,620,328 24,283,370 663,042 2.8%
Sales Tax ‐ Annexation Credit 2,778,858 2,539,635 3,114,762 2,852,862 3,063,280 2,802,815 2,879,980 77,164 2.8%
Criminal Justice Sales Tax 2,484,718 2,275,933 2,701,787 2,479,835 2,679,898 2,457,333 2,571,958 114,625 4.7%
Natural Gas Use Tax 228,899 219,877 184,638 170,785 228,000 210,893 169,071 (41,822) ‐19.8%
Admission Tax 309,790 309,790 262,506 262,506 320,000 320,000 178,503 (141,497) ‐44.2%
Franchise Fees 1,349,154 1,349,154 1,406,092 1,401,242 1,330,000 1,327,659 1,539,350 211,691 15.9%
Electricity Tax 5,012,962 4,528,875 5,440,139 4,958,272 5,596,019 5,078,900 5,194,921 116,021 2.3%
Natural Gas Utility Tax 1,437,552 1,277,156 1,327,937 1,194,432 1,350,900 1,207,334 1,458,097 250,764 20.8%
Garbage/Solid Waste 638,073 589,582 717,148 657,424 680,000 625,702 571,124 (54,578) ‐8.7%
TV Cable 1,591,866 1,451,947 1,619,364 1,476,915 1,645,659 1,500,954 1,520,672 19,718 1.3%
Telephone 880,233 846,680 859,868 772,602 789,875 735,032 784,978 49,946 6.8%
Cellular Phone 1,674,355 1,539,459 1,541,204 1,448,187 1,521,056 1,413,246 1,371,952 (41,294) ‐2.9%
City Utilities 4,183,165 3,844,246 4,206,473 3,858,439 3,941,628 3,618,883 4,480,697 861,814 23.8%
Utility Tax Audit 1,962,092 1,446,078 111,227 111,227 ‐ ‐ ‐ ‐ 0.0%
Leasehold Excise Tax 163,314 123,703 173,769 133,042 179,000 136,339 132,905 (3,434) ‐2.5%
Gambling Excise Tax 2,299,156 2,107,138 2,500,604 2,318,680 2,000,000 1,844,183 2,430,320 586,137 31.8%
Real Estate Excise Tax 4,595,166 4,158,068 6,121,830 5,814,448 5,170,000 4,847,713 6,625,978 1,778,265 36.7%
Less: CIP REET (1,401,300) (1,154,168) (2,707,676) (2,707,676) (4,420,000) (4,154,162) (6,625,978) (2,471,817) 59.5%
EMS Levy 936,406 702,305 479,597 479,597 ‐ ‐ ‐ ‐ 0.0%
B&O Taxes ‐ ‐ 6,375,322 6,375,322 7,500,000 7,312,500 9,217,133 1,904,633 26.0%
Less: CIP B&O Taxes ‐ ‐ (2,000,000) (2,000,000) (2,473,974) (2,412,125) (2,473,974) (61,849) 2.6%
Business License Fees 3,125,740 3,107,486 1,926,510 1,913,955 1,302,453 1,294,528 1,436,883 142,355 11.0%
Less: CIP Business License Fees (2,584,164) (2,569,019) (1,587,627) (1,577,304) (617,016) (613,249) (607,704) 5,545 ‐0.9%
Animal Licenses and Spec Events Permits 101,743 94,102 102,905 97,228 212,575 206,144 134,003 (72,141) ‐35.0%
Building Permits & Development Svc Fees 6,077,055 5,585,024 5,293,563 4,825,260 5,735,368 5,262,700 4,576,532 (686,168) ‐13.0%
Intergovt'l (Grants, State Shared, etc) 4,053,617 3,632,812 3,998,953 3,503,840 4,543,876 3,178,767 3,343,780 165,013 5.2%
Fire District 25 and 40 Contracts 6,369,132 4,024,382 3,517,779 3,517,779 341,939 341,939 341,939 ‐ 0.0%
Public Safety 649,797 598,458 994,179 915,706 613,081 564,706 752,100 187,394 33.2%
Culture and Recreation 1,587,878 1,545,547 1,632,903 1,593,428 1,750,923 1,706,451 1,676,377 (30,074) ‐1.8%
Interfund/Interdept‐Services 3,106,430 2,881,338 3,377,663 3,066,643 4,178,976 3,830,728 3,614,187 (216,541) ‐5.7%
Fines and Penalties 848,052 766,946 901,592 771,306 824,450 718,227 696,347 (21,880) ‐3.0%
Photo Enforcement 2,171,184 1,934,263 1,959,071 1,783,243 2,044,000 1,839,737 1,924,564 84,827 4.6%
Seizure Funds ‐ Federal/State/Local 21,676 21,676 987,293 1,012,754 ‐ ‐ 168,830 168,830 100.0%
Interests and Other Earnings 973,208 637,433 1,058,880 655,986 875,300 557,126 797,579 240,453 43.2%
Rents, Leases, and Concessions 762,361 738,668 642,192 617,485 623,195 601,720 606,915 5,195 0.9%
Contributions and Donations 147,292 137,537 96,582 87,363 175,500 161,846 125,841 (36,005) ‐22.2%
Other Miscellaneous 941,127 821,708 956,131 788,046 691,812 583,871 840,174 256,303 43.9%
Other Financing Sources (Transfer ‐In, etc) 270,224 (13,684,197) 2,129,561 29,061 171,196 108,951 108,951 ‐ 0.0%
Total Operating Revenues 119,555,505 109,704,799 125,816,444 116,702,709 104,522,763 96,826,351 101,061,072 4,234,721 4.4%
OPERATING EXPENDITURES
Council 320,877 293,152 358,550 329,610 368,211 337,502 331,903 5,599 1.7%
Executive 1,691,189 1,500,571 1,778,206 1,593,538 2,007,671 1,799,173 1,737,132 62,041 3.4%
Emergency Management*398,808 333,013 370,832 343,432 609,249 535,475 523,795 11,681 2.2%
City Attorney 1,791,167 1,640,168 1,983,834 1,841,277 2,163,329 1,995,101 1,908,369 86,732 4.3%
Court Services 2,013,364 1,835,205 2,075,763 1,890,069 2,265,056 2,063,510 1,982,165 81,345 3.9%
Community and Eco Dvlpmnt Admin 1,183,052 1,093,721 1,161,330 1,055,753 1,350,991 1,238,672 1,227,699 10,973 0.9%
Development Services 2,632,264 2,393,288 2,859,410 2,601,675 3,405,714 3,097,674 2,912,793 184,881 6.0%
Economic Development 658,515 588,721 1,004,411 930,197 1,613,665 1,473,922 815,203 658,720 44.7%
Planning 2,606,551 2,404,791 2,716,214 2,483,516 3,222,077 2,959,083 2,445,474 513,608 17.4%
Finance 3,132,812 2,461,903 3,046,824 2,449,791 3,407,369 2,708,242 2,501,966 206,277 7.6%
City Clerk 1,027,084 803,924 914,251 833,087 1,239,455 1,045,159 976,122 69,037 6.6%
Human Resources 1,182,629 1,050,082 1,193,016 1,083,398 1,359,317 1,220,753 1,116,195 104,558 8.6%
Police 28,144,699 25,702,274 28,891,879 25,771,653 31,830,126 28,725,805 28,168,125 557,680 1.9%
Jail Services 4,142,266 3,797,319 4,704,978 4,704,773 4,850,000 4,406,898 4,406,898 ‐ 0.0%
Fire* 26,138,192 23,842,205 25,349,755 25,352,252 ‐ ‐ ‐ ‐ 0.0%
Community Services Admin 508,766 462,553 585,983 493,412 563,654 492,198 456,199 36,000 7.3%
Parks 4,411,383 4,021,960 4,445,115 4,069,957 5,179,955 4,732,770 4,310,138 422,631 8.9%
Parks Planning & Natural Resources 808,558 732,286 952,980 816,259 1,269,569 1,116,062 938,972 177,090 15.9%
Recreation 5,088,483 4,674,667 5,096,236 4,717,419 5,720,955 5,275,717 4,862,184 413,533 7.8%
Human Services 1,225,835 1,043,621 1,241,169 1,058,333 1,648,578 1,404,633 1,256,572 148,061 10.5%
Neighborhoods, Resources, & Events 958,624 841,423 865,551 753,518 1,264,095 1,105,244 875,044 230,200 20.8%
Museum 227,094 208,186 229,543 210,229 236,275 216,498 215,835 663 0.3%
Public Works Admin 387,493 355,440 398,796 366,364 406,398 373,069 373,534 (466) ‐0.1%
Street Maintenance 5,061,723 4,592,421 5,041,509 4,605,606 5,636,437 5,131,438 5,132,052 (614) 0.0%
Transportation 4,975,059 4,416,007 5,966,281 5,370,311 5,669,897 5,071,355 4,645,164 426,191 8.4%
Debt Service 6,371,715 1,547,614 6,099,166 1,448,946 6,066,629 1,361,480 1,361,480 ‐ 0.0%
Non‐Departmental and Other 10,069,740 6,516,312 9,883,923 3,754,617 16,795,551 2,884,877 2,884,877 ‐ 0.0%
Total Operating Expenditures 117,157,942 99,152,824 119,215,504 100,928,993 110,150,225 82,772,309 78,365,889 4,406,421 5.3%
Total Ending Fund Balance 19,962,845$ 28,117,257$ 26,563,785$ 35,736,561$ 20,936,323$ 40,617,826$ 49,258,968$ 8,641,141$ 21.3%
*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 November 2017
Page 1 of 37
Monthly Financial Report November 2017
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through November 30, 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 77% of
all resources supporting general governmental activities. The following section provides detail information on property,
sales, utility, and other taxes.
Property Tax
November’s collection is $6.7M,
making the total year‐to‐date
collection $24.2M or 100.5% 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 $224K or 1% more. The
large variance with the prior year
is due to the formation of the
Renton Regional Fire Authority.
Sales Tax
November 2017 sales tax receipts
totaled $2.3M. Compared with
the same month last year, it is
$185K or 7% less. Compared to
the projected current month’s
budget, it is $33K or 1% below.
The year‐to‐date collection of
$24.3M is $134K or 1% more than
the prior year and is also $663K
or 3% more than budgeted.
Retail, Service, and Other 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
YTD Total 36,893,234$ 23,988,632$ 24,212,717$ (12,680,517)$ ‐34% 224,086$ 1%
Annual Total 37,038,480$ 24,103,395$
Property Tax Revenues
Year to Date through November
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 ‐
YTD Total 24,149,557$ 23,620,328$ 24,283,370$ 133,813$ 1% 663,042$ 3%
Annual Total 26,353,246$ 25,850,400$
2017 vs. Budget2017 vs. 2016
Month
Year to Date through November
Local Retail Sales Tax Revenues
Page 2 of 37
Monthly Financial Report November 2017
The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business
sectors:
Utility tax
November utility tax revenues
are $1.3M, which is $140K or 12%
higher than the same month last
year and is also higher than the
budget by $39K or 3%. The year‐
to‐date collection is $15.6M,
which is $903K 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,291,980$ 4,127,228$ 3,898,385$ (393,595)$ ‐9% $ (228,843)‐6%
Auto Sales 4,436,145 4,328,445 4,400,839 (35,306) ‐1% 72,394 2%
General Retail 6,708,369 6,733,650 7,063,086 354,717 5% 329,436 5%
Manufacturing 1,629,598 1,410,090 1,424,293 (205,306) ‐13% 14,203 1%
Wholesale 1,243,580 1,273,213 1,310,021 66,440 5% 36,808 3%
Service 5,198,540 5,147,783 5,482,587 284,046 5% 334,804 6%
Other 641,343 599,920 704,160 62,817 10% 104,240 17%
YTD Total 24,149,557$ 23,620,328$ 24,283,370$ 133,813$ 1%663,042$ 3%
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
YTD Total 14,648,282$ 14,390,944$ 15,551,512$ 903,230$ 6% 1,160,569$ 8%
Annual Total 16,007,999$ 15,753,137$
2017 vs. Budget2017 vs. 2016
Year to Date through November
Utility Tax Revenues
Month
Utility Tax by Type 2016 2017 Bgt YTD Act Change 2017/2016 2017 Act vs Bgt
Electrical 4,958,272$ 5,078,900$ 5,194,921$ 236,649$ 5% $ 116,021 2%
Natural Gas 1,365,216 1,418,226 1,627,168 261,952 19% 208,942 15%
Cell 1,448,187 1,413,246 1,371,952 (76,234) ‐5% (41,294)‐3%
Phone 772,602 735,032 784,978 12,376 2% 49,946 7%
Cable 1,476,915 1,500,954 1,520,672 43,757 3% 19,718 1%
Garbage/Solid Waste 657,424 625,702 571,124 (86,300) ‐13% (54,578)‐9%
City Utilities 3,858,439 3,618,883 4,480,697 622,258 16% 861,814 24%
Utility Tax Audit 111,227 ‐ ‐ (111,227) 0% ‐ N/A
YTD Total 14,648,282$ 14,390,944$ 15,551,512$ 903,230$ 6%1,160,569$ 8%
Annual Total 16,007,999$ 15,753,137$
YTD as % of 92% 91%
Page 3 of 37
Monthly Financial Report November 2017
Other Taxes
Real Estate Excise Tax
The City collected $775K in Real
Estate Excise Tax revenues (REET)
for November. This is $273K or
54% more than the same month
last year and is also $443K or
133% more than the current
month’s budget. The year‐to‐
date collection is $6.6M, which is
$812K or 14% more than the
prior year and is also $1.8M or
37% above the budget. The
higher than expected variance is
due to 31 large transactions in
December, January, February,
March, April, May, June, July, August, September and October which accounts for $2.4M of the total REET collected.
Gambling Tax
November’s Gambling Tax
collections totaled $260K, which
is $76K or 42% above the same
month last year and is also above
the current month’s budget by
$95K or 57%. The year‐to‐date
total of $2.4M is $112K or 5%
above the prior year and is also
$586K or 32% 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.5M is $138K or 10% higher
than the prior year and is also
$212K or 16% 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 ‐
YTD Total 2,318,680$ 1,844,183$ 2,430,320$ 111,640$ 5% 586,137$ 32%
Annual Total 2,500,604$ 2,000,000$
Gambling Tax Revenue
Month
Year to Date through November
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 ‐
YTD Total 1,401,242$ 1,327,659$ 1,539,350$ 138,108$ 10% 211,691$ 16%
Annual Total 1,406,092$ 1,330,000$
Month
2017 vs. 2016 2017 vs. Budget
Franchise Fees Revenue
Year to Date through November
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
YTD Total 5,814,448$ 4,847,713$ 6,625,978$ 811,531$ 14% 1,778,265$ 37%
Annual Total 6,121,830$ 5,170,000$
*Total REET (GF & CIP)
Month
2017 vs. Budget2017 vs. 2016
Real Estate Excise Tax (REET) Revenues*
Year to Date through November
Page 4 of 37
Monthly Financial Report November 2017
Admission Tax
Admission Tax returns are due
quarterly in January, April, July,
and October of each year. July
2017 collections represent
activities conducted during the
2nd quarter of 2017. The year‐to‐
date collection of $179K is $84K
or 32% less than the prior year
and is also $141K or 44% less than
the budget. The October
collection (3rd Quarter activity)
will be 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.2M. The
monthly budgets are based on
large business quarterly
reporting with smaller business
annual reporting.
Licenses and Permits
Business Licenses
Business Licenses totaled $89K
for November, which is $3K or 3%
below the same month last year
but is $33K or 58% above the
current month’s budget. The
year‐to‐date Business Licenses
revenue of $1.4M is $477K or
25% below the prior year but is
above the budget by $142K or
11%. 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) (289) ‐100%
Oct 58,934 74,983 1,705 (57,229) ‐97% (73,278) ‐98%
Nov 1,452 831 ‐ (1,452) ‐100% (831) ‐100%
Dec ‐ ‐ ‐
YTD Total 262,506$ 320,000$ 178,503$ (84,003)$ ‐32% (141,497)$ ‐44%
Annual Total 262,506$ 320,000$
2017 vs. Budget
Admission Tax Revenue
Year to Date through November
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 ‐
YTD Total 6,375,322$ 7,312,500$ 9,217,133$ 2,841,810$ 45% 1,904,633$ 26%
Annual Total 6,375,322$ 7,500,000$
*Total Business & Occupation Taxes (GF & CIP)
Business & Occupation Taxes*
Year to Date through November
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 ‐
YTD Total 1,913,955$ 1,294,528$ 1,436,883$ (477,072)$ ‐25% 142,355$ 11%
Annual Total 1,926,510$ 1,302,453$
*Total Business License (GF & CIP)
2017 vs. 2016
Year to Date through November
2017 vs. Budget
Business Licenses*
Month
Page 5 of 37
Monthly Financial Report November 2017
Building Permits and
Development Service Fees
Building Permits and
Development Service Fee
revenues totaled $479K in
November. The year‐to‐date
revenues of $4.6M is $249K or 5%
less than the year before but is
$686K or 13% higher than
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 94% of
the total revenues in
this category. The year‐
to‐date total
Intergovernmental revenue is $6.3M or 83% of the budget.
State Shared Revenues
State Shared Revenue
collections totaled
$5.5M since the start of
the year. Compared to
the prior year, State
Shared Revenues are
above by $165K or 3%.
Compared to the
projected budget, the
City is collecting $287K
or 5% 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
YTD Total 4,825,260$ 5,262,700$ 4,576,532$ (248,728)$ ‐5% (686,168)$ ‐13%
Annual Total 5,293,563$ 5,735,368$
Year to Date through November
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,361,795 5,239,944 5,527,062 165,268 3% 287,119 5%
Federal Grants 402,336 137,309 137,309 (265,026) ‐66%‐ 0%
State Grants 51,274 30,032 30,032 (21,242) ‐41%‐ 0%
Other Grants/Intgovt 647,867 228,815 221,335 (426,532) ‐66% (7,481) ‐3%
ARRA Grants ‐ ‐ ‐ ‐ N/A ‐ N/A
Total Rev YTD 9,981,050$ 5,978,039$ 6,257,677$ (3,723,373)$ ‐37%279,638$ 5%
Total Rev Annual 10,698,115$ 7,565,713$
YTD % 93% 79% 83%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
2016 2017 2017
Actual Budget Actual $ % $ %
Crim Just Sales Tax 2,479,835$ 2,457,333$ 2,571,958$ 92,124$ 4% 114,625$ 5%
Judicial Contribution 18,092 ‐ 11,141 (6,951) ‐38% 11,141 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 17,739 ‐ 43,934 26,194 148% 43,934 100%
Liquor Profits 636,375 637,629 641,637 5,262 1% 4,009 1%
Liquor Excise Tax 459,427 446,600 488,280 28,852 6% 41,680 9%
Fuel Tax 1,318,983 1,312,681 1,349,311 30,329 2% 36,630 3%
YTD Total 5,361,795$ 5,239,944$ 5,527,062$ 165,268$ 3% 287,119$ 5%
Annual Total 5,933,890$ 5,805,528$
State Shared Revenues
2017 vs. 2016
Revenue
Year to Date through November
2017 vs. Budget
Page 6 of 37
Monthly Financial Report November 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
67% of the total revenue in this category. The year‐to‐date total charges for services are $7.9M or 91% of the budget. The
following sections provide detail information for Public Safety, Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totaled
$752K 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 $164K or 18%
less. Compared to the year‐to‐
date budget, the City is over
budget by $187K or 33%. 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
$58K for the current month.
Compared to the same month
the prior year, the City collected
$10K or 15% less. Compared to
the projected monthly budget,
the City collected $12K or 17%
less. The year‐to‐date collection
of $1.7M is $83K or 5% higher
than the year before but is $30K
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 ‐
YTD Total 915,706$ 564,706$ 752,100$ (163,606)$ ‐18% 187,394$ 33%
Annual Total 994,179$ 613,081$
2017 vs. Budget
Month
2017 vs. 2016
Year to Date through November
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 ‐
YTD Total 1,593,428$ 1,706,451$ 1,676,377$ 82,949$ 5% (30,074)$ ‐2%
Annual Total 1,632,903$ 1,750,923$
2017 vs. Budget2017 vs. 2016
Month
Recreation
Year to Date through November
Page 7 of 37
Monthly Financial Report November 2017
Interfund Services
The year‐to‐date collections for
Interfund Services revenues are
$3.6M. Compared to the prior
year, the revenues are over by
$548K or 18%. Compared to the
projected budget, the revenues
are below by $217K 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.6M. This is $66K or 3% higher
than a year ago and $63K or 2%
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 ‐
YTD Total 3,066,643$ 3,830,728$ 3,614,187$ 547,543$ 18% (216,541)$ ‐6%
Annual Total 3,377,663$ 4,178,976$
2017 vs. Budget
Month
Interfund Services
Year to Date through November
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
YTD Total 2,554,549$ 2,557,964$ 2,620,911$ 66,362$ 3% 62,947$ 2%
Annual Total 2,860,662$ 2,868,450$
Month
2017 vs. Budget2017 vs. 2016
Year to Date through November
Fines and Penalties by Month
Year to Date through November
2016 2017 2017
Actual Budget Actual $ % $ %
Civil Penalties 2,193$ 4,561$ 1,906$ (287)$ ‐13% (2,655)$ ‐58%
Civil Infraction Penalties 311,551 299,527 283,933 (27,618) ‐9% (15,594) ‐5%
Civil Parking Infraction Penalties 146,890 208,356 157,638 10,748 7% (50,718) ‐24%
Photo Enforcement Program 1,783,243 1,839,737 1,924,564 141,321 8% 84,827 5%
Criminal Traffic Misdemeanor Fines 68,719 63,014 69,133 414 1% 6,118 10%
Criminal Non ‐Traffic Fines 24,421 45,283 70,281 45,860 188% 24,998 55%
Criminal Costs 81,841 77,292 74,421 (7,419) ‐9% (2,871) ‐4%
Non‐Court Fines, Forfeitures and Penalties 135,692 20,193 39,035 (96,657) ‐71% 18,842 93%
YTD Total 2,554,549$ 2,557,964$ 2,620,911$ 66,362$ 3% 62,947$ 2%
Annual Total 2,860,662$ 2,868,450$
Revenue
2017 vs. Budget
Fines and Penalties by Type
2017 vs. 2016
Page 8 of 37
Monthly Financial Report November 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
$1.9M.
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.
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 $2M. Compared
to last year, the revenues are
below by $751K or 27%.
Compared to the projected year‐
to‐date budget, the revenues are
over by $454K or 29%. 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.
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 ‐ 89,775 ‐ ‐
YTD Total 1,839,737$ 1,924,564$ 987,522$ 979,357$ 945,207$
Annual Total 2,044,000$ 1,077,297$
1Actuals of Revenues and Expenses
Photo Enforcement Program
Year to Date through November
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
YTD Total 2,761,475$ 1,555,958$ 2,010,171$ (751,305)$ ‐27% 454,213$ 29%
Annual Total 3,187,241$ 1,929,617$
Year to Date through November
Month
2017 vs. Budget2017 vs. 2016
Miscellaneous Revenues by Month
2016 2017 2017
Actual Budget Actual $ % $ %
Interests and Other Earnings 655,986$ 557,126$ 797,579$ 141,594$ 22% 240,453$ 43%
Rents, Leases, and Concessions 617,485 601,720 606,915 (10,570) ‐2% 5,195 1%
Contributions/Donations from Private Sources 87,363 161,846 125,841 38,478 44% (36,005) ‐22%
Other 387,888 235,266 311,006 (76,882) ‐20% 75,740 32%
Seizure Funds ‐ Federal/State/Local 1,012,754 ‐ 168,830 (843,924) ‐83% 168,830 100%
YTD Total 2,761,475$ 1,555,958$ 2,010,171$ (751,305)$ ‐27% 454,213$ 29%
Annual Total 3,187,241$ 1,929,617$
2017 vs. Budget
Miscellaneous Revenues by Type
Year to Date through November
Revenue
2017 vs. 2016
Page 9 of 37
Monthly Financial Report November 2017
EXPENSES
Overall the City has expended 71% of its budgeted general governmental expenditures at the end of November. This is $4.4M
or 5.3% below year‐to‐date budgeted expenditures. 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 37
Monthly Financial Report November 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. Golf Course has a negative ending fund
balance in November due to correcting entries made (October) to the prior years’ gift card and tournament play accounts.
Airport Golf Course Solid Waste
Utility Water Utility Wastewater
Utility
Surface Water
Utility Metro
REVENUES:
Licenses and permits ‐ ‐ ‐ ‐ 82,490 37,500 ‐
Grants / intergovernmental 19,100 ‐ 134,063 ‐ 1,232,421 1,338,138 ‐
Charges for services 178,904 1,708,489 15,907,520 16,495,269 9,580,844 10,559,500 15,507,622
Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐
Fines and penalties 1,355 ‐ ‐ ‐ 970 ‐ ‐
Rents, leases, and misc fees 2,271,907 388,757 11,857 153,579 ‐ ‐ ‐
Interest and other misc 22,291 (67,349) 47,038 4,556,267 3,267,290 1,931,303 35,133
TOTAL REVENUES 2,493,557 2,029,897 16,100,478 21,205,115 14,164,015 13,866,441 15,542,755
EXPENSES:
Utility billing ‐ ‐ 40,145 145,647 117,669 180,843 ‐
Utility systems ‐ ‐ 17,013,397 3,493,937 3,151,836 3,959,267 ‐
Utility maintenance ‐ ‐ 315,982 5,335,360 2,004,561 2,569,051 15,422,386
Transportation 1,530,248 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 2,091,718 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 1,530,248 2,091,718 17,369,524 8,974,944 5,274,066 6,709,161 15,422,386
AMOUNT AVAILABLE FOR DEBT SERVICE 963,309 (61,821) (1,269,045) 12,230,171 8,889,949 7,157,280 120,369
DEBT SERVICE:
Principal ‐ ‐ ‐ 3,804,103 1,673,420 1,231,454 ‐
Interest ‐ ‐ ‐ 244,891 111,357 579,845 ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ 4,048,994 1,784,777 1,811,299 ‐
CAPITAL PROJECTS 285,183 66,995 ‐ 2,031,178 2,769,860 1,896,877 ‐
TRANSFERS IN/(OUT)‐ ‐ (370) (433) (1,205) (1,891) ‐
CHANGE IN FUND BALANCE 678,126 (128,816) (1,269,415) 6,149,566 4,334,107 3,447,213 120,369
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, Nov 30 3,297,469 (91,728) 1,482,002 34,678,500 18,193,769 14,341,188 5,115,027
Page 11 of 37
Monthly Financial Report November 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 ‐ 190,352 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ 7,110 ‐ ‐ ‐ ‐ 47,440
Charges for services
Equipment rental m&o 2,493,826 3,896,214 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ ‐ ‐ 402,722 ‐ ‐ ‐
Communications ‐ 728,294 ‐ 584,758 ‐ ‐ ‐
Facilities ‐ ‐ 4,604,431 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ ‐ ‐ ‐ ‐ ‐ ‐
IT service co ntracts ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest and other misc 44,485 20,704 10,936 3,953 87,507 30,854 73,790
Internal service fund misc:
Vehicle / equipment capital recovery 2,029,504 443,628 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 1,573,257 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 1,279,588 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 8,468,373 2,405,960
Other misc 374 47 33,290 20 ‐ 853,649 ‐
Interfund Loan ‐ ‐ ‐ ‐ ‐ ‐ ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets 111,771 ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 178,049 ‐ ‐
TOTAL REVENUES 4,679,960 5,286,349 4,648,656 991,453 3,118,401 9,352,876 2,527,190
EXPENSES:
Communications 550,112
Equipment rental 2,098,494
Facilities 4,126,362
Healthcare 8,877,769
Information technology 3,888,402
Print and mail 372,420
Retiree healthcare 840,819
Risk management:
Risk management 1,233,223
Unemployment 51,343
Worker's compensation 1,187,528
TOTAL EXPENSES 2,098,494 3,888,402 4,126,362 922,532 2,472,094 8,877,769 840,819
AMOUNT AVAILABLE FOR CAPITAL 2,581,466 1,397,947 522,294 68,921 646,307 475,107 1,686,371
CAPITAL PROJECTS 2,455,191 450,656 30,077 ‐ ‐ ‐ ‐
TRANSFERS IN ‐ 30,608 ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ (89,876) ‐
CHANGE IN FUND BALANCE 126,275 977,899 492,217 68,921 646,307 385,231 1,686,371
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, Nov 30 6,558,328 3,548,273 1,767,270 611,848 13,498,816 4,541,379 11,765,622
Page 12 of 37
Monthly Financial Report November 2017
FUND BALANCE
Page 14 shows the ending fund balance as of November 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 November, the City has $49.3M reported in the combined general governmental fund balance of the current
year’s operating budget, which is approximately 45% of budgeted operating expenditures. This is an increase of $22.7M from
the year’s beginning balance. November’s ending fund balance is over the anticipated General Governmental Fund Balance
of $40.6M by $8.6M or 21.3%. 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 November 2017
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through November 30, 2017
Funds
Balance
01/01/2017
Budgeted
Revenue
Revenue
11/30/17
Total Funds
Available
Budgeted
Expenditure
Expenditure
11/30/17 Ending Balance
GENERAL GOVERNMENT FUNDS: 26,563,785 104,522,764 101,061,072 127,624,857 110,150,226 78,365,889 49,258,968
000 General 18,201,028 71,439,589 70,924,510 89,125,538 77,598,966 55,274,747 33,850,792
001 Community Services 3,769,766 13,857,754 12,987,257 16,757,023 13,887,263 11,345,134 5,411,889
003 Street 1,936,367 12,005,024 11,721,559 13,657,926 11,306,335 9,777,216 3,880,710
004 Community Dev Block Grant 66,654 896,292 413 67,067 943,792 294,075 (227,008)
005 Museum 72,372 233,936 234,267 306,639 236,275 215,835 90,805
009 Farmers Market 90,730 114,844 108,198 198,928 110,966 97,403 101,525
011 Fire Health & Wellness ‐ ‐ ‐ ‐ ‐ ‐ ‐
201 Ltd GO Bonds Gen Govt Debt 852,111 1,749,675 1,759,325 2,611,436 1,749,675 41,925 2,569,511
215 Gen Govt Misc Debt Service 1,574,757 4,225,650 3,325,543 4,900,300 4,316,954 1,319,555 3,580,744
SPECIAL REVENUE FUNDS:1,599,965 1,934,729 2,226,029 3,825,994 2,189,749 954,200 2,871,794
102 Arterial Street 63,480 660,000 637,387 700,867 660,000 ‐ 700,867
108 Leased City Properties 276,865 902,550 1,089,884 1,366,749 888,131 637,677 729,072
110 Hotel Motel 402,602 225,000 364,072 766,674 400,994 256,492 510,182
125 1% For Art 128,489 24,505 842 129,331 117,950 13,950 115,381
127 Cable Communication 394,504 122,674 131,583 526,087 122,674 46,081 480,006
135 Springbrook Wetlands Bank 334,025 ‐ 2,261 336,286 ‐ ‐ 336,286
CAPITAL PROJECT FUNDS (CIP): 26,202,403 42,298,215 19,340,285 45,542,688 52,879,521 13,954,666 31,588,022
303 Community Services Mitigation 1,255,194 406,014 346,277 1,601,471 54,074 ‐ 1,601,471
304 Fire Mitigation 607,163 99,000 481,257 1,088,420 158,696 ‐ 1,088,420
305 Transportation Mitigation 1,497,748 620,000 1,150,973 2,648,721 1,890,000 ‐ 2,648,721
316 Municipal Facilities CIP 15,038,030 15,161,013 10,343,994 25,382,024 24,657,514 3,787,521 21,594,503
317 Transportation CIP 5,640,494 20,512,188 6,989,595 12,630,089 25,094,010 9,870,131 2,759,958
326 Housing Opportunity 1,041,173 1,500,000 7,050 1,048,223 ‐ ‐ 1,048,223
336 New Library Development 1,122,601 ‐ 5,999 1,128,600 1,025,227 297,014 831,586
346 New Family First Center Dvlpmnt ‐ 4,000,000 15,140 15,140 ‐ ‐ 15,140
ENTERPRISE FUNDS:63,685,077 96,750,816 85,468,401 149,153,478 127,425,147 72,137,255 77,016,223
4X2 Airport Operating & CIP 2,619,343 3,405,842 2,493,557 5,112,900 5,688,023 1,815,432 3,297,468
403 Solid Waste Utility 2,751,417 19,187,851 16,100,478 18,851,895 19,024,775 17,369,893 1,482,002
4X4 Golf Operating & CIP 37,088 2,893,044 2,084,897 2,121,985 2,630,288 2,213,714 (91,729)
4X5 Water Operating & CIP 28,528,934 20,636,268 21,205,113 49,734,047 38,803,600 15,055,549 34,678,498
4X6 Waste Water Operating & CIP 13,859,662 14,898,560 14,175,159 28,034,821 22,238,802 9,841,054 18,193,767
416 King County Metro 4,994,658 17,505,693 15,542,755 20,537,413 17,505,693 15,422,386 5,115,027
4X7 Surface Water Operating & CIP 10,893,975 18,223,558 13,866,442 24,760,417 21,533,966 10,419,227 14,341,190
INTERNAL SERVICE FUNDS:37,908,315 35,014,282 30,635,495 68,543,810 34,026,354 26,252,272 42,291,538
501 Equipment Repair/Replacement 6,432,053 6,494,353 4,679,960 11,112,013 7,733,113 4,553,685 6,558,328
502 Insurance 12,852,509 7,392,368 3,118,402 15,970,911 3,571,166 2,472,094 13,498,817
503 Information Services 2,570,374 5,928,485 5,316,957 7,887,331 7,126,445 4,339,058 3,548,273
504 Facilities 1,275,053 5,077,715 4,648,656 5,923,709 5,316,091 4,156,439 1,767,270
505 Communications 542,927 1,078,253 991,453 1,534,380 1,076,474 922,533 611,847
512 Insurance, Healthcare 4,156,148 7,787,779 9,352,877 13,509,025 8,163,471 8,967,644 4,541,381
522 Insurance, Leoff1 Retirees HC 10,079,251 1,255,329 2,527,190 12,606,441 1,039,594 840,819 11,765,622
FIDUCIARY FUNDS: 5,578,045 468,000 176,710 5,754,755 210,475 190,633 5,564,122
611 Firemen's Pension 5,578,045 468,000 176,710 5,754,755 210,475 190,633 5,564,122
TOTAL FUNDS 161,537,590 280,988,806 238,907,992 400,445,582 326,881,472 191,854,915 208,590,667
Page 14 of 37
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
(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 15 of 37
City of Renton
Monthly Revenue Analysis ‐ 2017 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,414,840 7,364,146 ‐0.68%
Feb 14,004,750 14,472,917 3.34%
Mar 20,558,925 21,057,303 2.42%
Apr 33,652,773 39,230,543 16.57%
May 45,137,662 47,996,932 6.33%
Jun 51,500,188 54,429,132 5.69%
Jul 59,354,044 62,729,973 5.69%
Aug 66,028,282 69,843,380 5.78%
Sep 72,454,359 76,428,173 5.48%
Oct 84,192,631 88,032,675 4.56%
Nov 96,826,351 101,061,072 4.37%
Dec 104,522,763
Percent of budget 96.69%
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
Percent of budget 100.45%
$‐
$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 16 of 37
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
Percent of budget 93.95%
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
Percent of budget 98.72%
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 ‐ 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
Percent of budget 85.32%
Note: GF only
Intergovt'l Budget
YTD
Actual
Annual %
over (under)
Jan 567,324 604,678 6.58%
Feb 1,156,199 1,193,433 3.22%
Mar 1,699,398 1,773,868 4.38%
Apr 2,209,382 2,313,101 4.69%
May 2,601,589 2,729,902 4.93%
Jun 3,194,501 3,346,773 4.77%
Jul 3,772,397 4,001,945 6.08%
Aug 4,332,435 4,575,058 5.60%
Sep 4,923,899 5,211,371 5.84%
Oct 5,538,395 5,873,923 6.06%
Nov 5,978,039 6,257,677 4.68%
Dec 7,565,713
Percent of budget 82.71%
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 18 of 37
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
Percent of budget 91.05%
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
Percent of budget 91.37%
$‐
$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 ‐ 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
Percent of budget 114.78%
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
Percent of budget 104.17%
$‐
$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
Millions Other Taxes
Budget
Actual
Last Year
Page 20 of 37
City of Renton
Monthly Revenue Analysis ‐ 2017 Budget Year
Other
Financing Budget
YTD
Actual
Annual %
over (under)
Jan 14,266 ‐ 0.00%
Feb 28,533 ‐ 0.00%
Mar 42,799 ‐ 0.00%
Apr 94,231 94,231 0.00%
May 94,231 94,231 0.00%
Jun 94,981 94,981 0.00%
Jul 97,726 97,726 0.00%
Aug 98,866 98,866 0.00%
Sep 102,541 102,541 0.00%
Oct 108,951 108,951 0.00%
Nov 108,951 108,951 0.00%
Dec 171,196
Percent of budget 63.64%
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
Percent of budget 128.16%
$‐
$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
Real Estate Excise Tax
Budget
Actual
Last Year
$0
$1
$1
$2
$2
$3
Mi
l
l
i
o
n
s
Other Financing Sources
Budget
Actual
Last Year
Page 21 of 37
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
Percent of budget 79.79%
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
Percent of budget 122.90%
$‐
$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
Millions Business & Occupation Tax
Budget
Actual
Last Year
Page 22 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,000,299 6,595,136 ‐5.79%
Feb 14,018,508 13,388,134 ‐4.50%
Mar 21,610,760 20,198,065 ‐6.54%
Apr 28,621,968 27,006,711 ‐5.64%
May 36,042,202 34,253,900 ‐4.96%
Jun 43,906,056 41,552,555 ‐5.36%
Jul 52,164,359 49,694,920 ‐4.73%
Aug 60,178,058 57,216,081 ‐4.92%
Sep 67,888,437 64,564,463 ‐4.90%
Oct 75,629,161 71,278,851 ‐5.75%
Nov 82,772,309 78,365,889 ‐5.32%
Dec 110,150,225
Percent of budget expended 71.14%
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
Percent of budget expended 90.14%
$‐
$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 ‐ 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
Percent of budget expended 86.52%
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
Percent of budget expended 85.97%
$‐
$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 24 of 37
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
Percent of budget expended 88.21%
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
Percent of budget expended 87.51%
$‐
$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 ‐ 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
Percent of budget expended 90.87%
Development
Services Budget
YTD
Actual
Annual %
over (under)
Jan 256,532 239,337 ‐6.70%
Feb 543,616 501,405 ‐7.76%
Mar 824,781 754,102 ‐8.57%
Apr 1,091,529 1,024,029 ‐6.18%
May 1,371,743 1,282,903 ‐6.48%
Jun 1,656,371 1,542,242 ‐6.89%
Jul 1,936,099 1,806,056 ‐6.72%
Aug 2,228,864 2,066,905 ‐7.27%
Sep 2,531,097 2,334,025 ‐7.79%
Oct 2,815,631 2,598,327 ‐7.72%
Nov 3,097,674 2,912,793 ‐5.97%
Dec 3,405,714
Percent of budget expended 85.53%
$‐
$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 ‐ 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
Percent of budget expended 50.52%
Planning Budget
YTD
Actual
Annual %
over (under)
Jan 243,257 221,112 ‐9.10%
Feb 490,299 449,900 ‐8.24%
Mar 754,718 681,350 ‐9.72%
Apr 1,014,473 906,510 ‐10.64%
May 1,315,458 1,134,729 ‐13.74%
Jun 1,605,503 1,353,531 ‐15.69%
Jul 1,871,101 1,570,361 ‐16.07%
Aug 2,140,077 1,787,262 ‐16.49%
Sep 2,429,086 1,999,301 ‐17.69%
Oct 2,705,736 2,215,869 ‐18.10%
Nov 2,959,083 2,445,474 ‐17.36%
Dec 3,222,077
Percent of budget expended 75.90%
$‐
$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
Millions
Planning
Budget
Actual
Last Year
Page 27 of 37
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
Percent of budget expended 73.43%
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
Percent of budget expended 78.75%
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 28 of 37
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
Percent of budget expended 82.11%
Police Budget
YTD
Actual
Annual %
over (under)
Jan 3,067,542 2,964,875 ‐3.35%
Feb 5,816,054 5,600,968 ‐3.70%
Mar 9,085,213 8,701,186 ‐4.23%
Apr 11,866,779 11,416,735 ‐3.79%
May 15,007,583 14,450,621 ‐3.71%
Jun 17,896,145 17,182,081 ‐3.99%
Jul 21,129,826 20,754,850 ‐1.77%
Aug 23,958,750 23,624,806 ‐1.39%
Sep 27,182,947 26,747,506 ‐1.60%
Oct 30,072,681 29,482,171 ‐1.96%
Nov 33,132,703 32,575,023 ‐1.68%
Dec 36,680,126
Percent of budget expended 88.81%
$‐
$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 ‐ 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
Percent of budget expended 80.94%
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
Percent of budget expended 83.21%
$‐
$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 ‐ 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
Percent of budget expended 73.96%
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
Percent of budget expended 84.99%
$‐
$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 31 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
Human
Services Budget
YTD
Actual
Annual %
over (under)
Jan 85,407 98,615 15.46%
Feb 206,985 170,784 ‐17.49%
Mar 348,150 256,318 ‐26.38%
Apr 538,698 333,897 ‐38.02%
May 632,958 513,338 ‐18.90%
Jun 719,513 584,702 ‐18.74%
Jul 868,174 754,865 ‐13.05%
Aug 997,485 879,654 ‐11.81%
Sep 1,088,690 940,189 ‐13.64%
Oct 1,301,403 1,125,006 ‐13.55%
Nov 1,404,633 1,256,572 ‐10.54%
Dec 1,648,578
Percent of budget expended 76.22%
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
Percent of budget expended 69.22%
$‐
$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 32 of 37
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
Percent of budget expended 91.35%
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
Percent of budget expended 91.91%
$‐
$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 ‐ 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
Percent of budget expended 91.05%
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
Percent of budget expended 81.93%
$‐
$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 ‐ 2017 Budget Year
Debt Service Budget
YTD
Actual
Annual %
over (under)
Jan 41,377 41,377 0.00%
Feb 291,694 291,694 0.00%
Mar 293,691 293,691 0.00%
Apr 293,691 293,691 0.00%
May 293,691 293,691 0.00%
Jun 859,786 859,786 0.00%
Jul 1,111,163 1,111,163 0.00%
Aug 1,361,480 1,361,480 0.00%
Sep 1,361,480 1,361,480 0.00%
Oct 1,361,480 1,361,480 0.00%
Nov 1,361,480 1,361,480 0.00%
Dec 6,066,629
Percent of budget expended 22.44%
Non‐
Departmental
Other City Budget
YTD
Actual
Annual %
over (under)
Jan 301,517 301,517 0.00%
Feb 531,962 531,962 0.00%
Mar 776,618 776,618 0.00%
Apr 1,072,621 1,072,621 0.00%
May 1,356,243 1,356,243 0.00%
Jun 1,617,036 1,617,036 0.00%
Jul 1,892,140 1,892,140 0.00%
Aug 2,160,209 2,160,209 0.00%
Sep 2,411,010 2,411,010 0.00%
Oct 2,637,698 2,637,698 0.00%
Nov 2,884,877 2,884,877 0.00%
Dec 16,795,551
Percent of budget expended 17.18%
$‐
$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 35 of 37
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
Percent of budget expended 38.80%
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
Percent of budget expended 31.92%
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 36 of 37
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,084,897 2,213,714
Dec 2,630,288
Percent of budget expended 84.16%
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