HomeMy WebLinkAbout201705, MayADMINISTRATIVE SERVICES
DEPARTMENT
M E M O R A N D U M
DATE: July 14, 2017
TO: Armondo Pavone, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: May 2017 Financial Status Report
At the end of May, general governmental revenues show $3.7M or 8.3% over budget. Revenue
source(s) that are higher than expected are: sales tax ($344k); utility taxes ($747k); franchise fees
($111k); gambling taxes ($282k); business & occupation taxes ($1.7M); state shared revenues
($132k); public safety ($136k); seizure funds ($150k, restricted to drug enforcement and not
available for general purposes); and other miscellaneous ($114k). If we remove B&O taxes and
seizure funds, general governmental revenues are $1.9M or 4.3% over budget. May did not have
any revenues that were $100k under budget.
General government expenditures showed a favorable variance of $1.4M or 3.9%. 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.
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 19,057,443 37,038,480 19,396,313 24,103,395 12,626,243 12,678,534 52,291 0.4%
Sales Tax 23,439,266 9,421,223 26,353,246 10,356,895 25,700,400 10,421,556 10,765,139 343,583 3.3%
Sales Tax ‐ Annexation Credit 2,778,858 1,117,529 3,114,762 1,226,993 3,063,280 1,218,594 1,275,481 56,888 4.7%
Criminal Justice Sales Tax 2,484,718 991,298 2,701,787 1,086,336 2,679,898 1,073,526 1,134,254 60,728 5.7%
Natural Gas Use Tax 228,899 122,782 184,638 115,809 228,000 143,006 93,242 (49,764) ‐34.8%
Admission Tax 309,790 151,784 262,506 140,840 320,000 163,621 123,373 (40,248) ‐24.6%
Franchise Fees 1,349,154 668,561 1,406,092 703,549 1,330,000 662,339 773,584 111,245 16.8%
Electricity Tax 5,012,962 2,075,204 5,440,139 2,500,347 5,396,019 2,361,956 2,609,011 247,056 10.5%
Natural Gas Utility Tax 1,437,552 853,281 1,327,937 793,545 1,350,900 804,450 1,011,722 207,272 25.8%
Garbage/Solid Waste 638,073 238,557 717,148 276,362 680,000 258,368 230,528 (27,840) ‐10.8%
TV Cable 1,591,866 629,058 1,619,364 643,405 1,645,659 652,099 661,829 9,730 1.5%
Telephone 880,233 397,717 859,868 410,986 714,875 332,234 404,260 72,025 21.7%
Cellular Phone 1,674,355 684,933 1,541,204 743,627 1,521,056 675,751 641,414 (34,337) ‐5.1%
City Utilities 4,183,165 1,640,310 4,206,473 1,645,378 3,941,628 1,543,685 1,866,739 323,054 20.9%
Utility Tax Audit 1,962,092 ‐ 111,227 111,227 ‐ ‐ ‐ ‐ 0.0%
Leasehold Excise Tax 163,314 42,865 173,769 42,176 179,000 45,159 42,568 (2,592) ‐5.7%
Gambling Excise Tax 2,299,156 902,480 2,500,604 988,484 2,000,000 787,941 1,070,091 282,150 35.8%
Real Estate Excise Tax 4,595,166 1,561,072 6,121,830 2,421,486 4,420,000 1,722,197 2,845,952 1,123,755 65.3%
Less: CIP REET (1,401,300) (390,268) (2,707,676) (1,210,743) (4,420,000) (1,722,197) (2,845,952) (1,123,755) 65.3%
EMS Levy 936,406 234,102 479,597 239,798 ‐ ‐ ‐ ‐ 0.0%
B&O Taxes ‐ ‐ 6,375,322 4,882,381 6,800,000 3,230,000 6,183,312 2,953,312 91.4%
Less: CIP B&O Taxes ‐ ‐ (2,000,000) (2,000,000) (2,473,974) (1,175,138) (2,473,974) (1,298,836) 110.5%
Business License Fees 3,125,740 1,517,527 1,926,510 1,184,825 1,302,453 694,138 723,975 29,836 4.3%
Less: CIP Business License Fees (2,584,164) (1,254,253) (1,587,627) (981,152) (617,016) (330,621) (333,537) (2,916) 0.9%
Animal Licenses and Spec Events Permits 101,743 46,675 102,905 41,190 92,575 41,038 45,949 4,911 12.0%
Building Permits & Development Svc Fees 6,077,055 1,755,389 5,293,563 2,370,874 5,735,368 2,096,984 2,004,656 (92,328) ‐4.4%
Intergovt'l (Grants, State Shared, etc) 4,053,617 1,490,944 3,998,953 1,612,068 4,440,610 1,357,094 1,424,679 67,585 5.0%
Fire District 25 and 40 Contracts 6,369,132 3,105,766 3,517,779 3,272,879 341,939 170,969 170,969 ‐ 0.0%
Public Safety 649,797 364,041 994,179 361,501 613,081 270,823 407,050 136,227 50.3%
Culture and Recreation 1,587,878 338,666 1,632,903 457,281 1,750,923 432,703 415,410 (17,294) ‐4.0%
Interfund/Interdept‐Services 3,106,430 1,298,792 3,377,663 1,413,523 4,178,976 1,741,240 1,692,540 (48,699) ‐2.8%
Fines and Penalties 848,052 314,127 901,592 288,282 824,450 287,106 274,674 (12,432) ‐4.3%
Photo Enforcement 2,171,184 802,869 1,959,071 794,941 2,044,000 790,732 762,218 (28,514) ‐3.6%
Seizure Funds ‐ Federal/State/Local 21,676 6,444 987,293 663,143 ‐ ‐ 149,552 149,552 100.0%
Interests and Other Earnings 973,208 277,510 1,058,880 282,676 875,300 241,294 335,699 94,405 39.1%
Rents, Leases, and Concessions 762,361 340,235 642,192 276,280 623,195 273,546 275,104 1,558 0.6%
Contributions and Donations 147,292 38,318 96,582 42,389 115,000 38,058 71,218 33,160 87.1%
Other Miscellaneous 941,127 407,609 956,131 373,667 691,812 277,420 391,438 114,018 41.1%
Other Financing Sources (Transfer ‐In, etc) 270,224 (13,688,087) 2,129,561 ‐ 171,196 94,231 94,231 ‐ 0.0%
Total Operating Revenues 119,555,505 51,254,305 125,816,444 57,969,563 102,363,998 44,302,145 47,996,932 3,694,786 8.3%
OPERATING EXPENDITURES
Council 320,877 140,500 358,550 156,960 368,211 161,207 157,670 3,537 2.2%
Executive 1,691,189 568,027 1,778,206 744,988 1,957,671 820,176 793,626 26,550 3.2%
Emergency Management*398,808 160,514 370,832 141,292 609,249 238,910 219,758 19,152 8.0%
City Attorney 1,791,167 753,544 1,983,834 837,538 2,163,329 911,796 866,583 45,214 5.0%
Court Services 2,013,364 810,280 2,075,763 849,557 2,220,656 901,397 888,624 12,774 1.4%
Community and Eco Dvlpmnt Admin 1,183,052 452,800 1,161,330 478,727 1,337,991 531,643 549,841 (18,198) ‐3.4%
Development Services 2,632,264 1,086,324 2,859,410 1,125,595 3,418,745 1,376,992 1,282,903 94,089 6.8%
Economic Development 658,515 278,258 1,004,411 361,504 1,755,838 675,508 342,370 333,138 49.3%
Planning 2,606,551 1,087,344 2,716,214 1,085,749 3,207,796 1,309,628 1,134,729 174,899 13.4%
Finance 3,132,812 907,912 3,046,824 1,085,634 3,362,369 1,084,697 1,073,519 11,178 1.0%
City Clerk 1,027,084 337,039 914,251 384,293 1,239,455 460,538 533,887 (73,349) ‐15.9%
Human Resources 1,182,629 462,817 1,193,016 491,217 1,357,317 545,084 492,849 52,235 9.6%
Police 28,144,699 11,476,180 28,891,879 11,827,647 31,280,337 12,780,423 12,448,091 332,331 2.6%
Jail Services 4,142,266 1,728,163 4,704,978 1,960,150 4,850,000 2,002,529 2,002,529 ‐ 0.0%
Fire* 26,138,192 11,200,334 25,349,755 11,604,483 ‐ ‐ ‐ ‐ 0.0%
Community Services Admin 508,766 211,318 585,983 240,955 505,154 208,694 214,954 (6,260) ‐3.0%
Parks 4,411,383 1,638,570 4,445,115 1,638,087 5,179,955 1,916,439 1,753,298 163,140 8.5%
Parks Planning & Natural Resources 808,558 283,762 952,980 300,170 1,181,283 391,584 369,879 21,705 5.5%
Recreation 5,088,483 1,795,232 5,096,236 1,843,391 5,707,355 2,039,027 1,886,814 152,213 7.5%
Human Services 1,225,835 470,636 1,241,169 476,551 1,419,333 544,941 513,338 31,604 5.8%
Neighborhoods, Resources, & Events 958,624 324,365 865,551 335,059 1,201,992 434,510 337,861 96,649 22.2%
Museum 227,094 94,299 229,543 92,699 236,275 96,758 97,324 (566) ‐0.6%
Public Works Admin 387,493 161,020 398,796 167,151 406,398 169,617 169,665 (49) 0.0%
Street Maintenance 5,061,723 2,027,380 5,041,509 2,087,428 5,636,437 2,295,588 2,408,369 (112,780) ‐4.9%
Transportation 4,975,059 1,925,413 5,966,281 2,119,001 5,669,897 2,095,850 2,065,482 30,368 1.4%
Debt Service 6,371,715 298,751 6,099,166 295,075 6,066,629 293,691 293,691 ‐ 0.0%
Non‐Departmental and Other 10,069,740 1,403,520 9,883,923 1,521,060 15,795,551 1,356,243 1,356,243 ‐ 0.0%
Total Operating Expenditures 117,157,942 42,084,303 119,215,504 44,251,964 108,135,225 35,643,471 34,253,900 1,389,571 3.9%
Total Ending Fund Balance 19,962,845$ 26,735,284$ 26,563,785$ 33,680,444$ 20,792,558$ 35,222,459$ 40,306,817$ 5,084,358$ 14.4%
*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 May 2017
Page 1 of 37
Monthly Financial Report May 2017
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through May 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 79% of
all resources supporting general governmental activities. The following section provides detail information on property,
sales, utility, and other taxes.
Property Tax
May’s collection is $4.5M,
making the total year‐to‐date
collection $12.7M or 52.6% of the
total budget. In comparison to
the previous year, the City
collected $6.7M or 35% less.
Compared to the budget, the City
collected $52k more. The large
variance with the prior year is
due to the formation of the
Renton Regional Fire Authority.
Sales Tax
May 2017 sales tax receipts
totaled $2.4M. Compared with
the same month last year, it is
$68k or 3% more. Compared to
the projected current month’s
budget, it is $182k or 8% above.
The year‐to‐date collection of
$10.8M is $408k or 4% more than
the prior year and is also $344k or
3% more than budgeted. Auto,
Retail, 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
Jul 57,174 40,245
Aug 240,536 110,113
Sep 558,716 367,830
Oct 6,233,910 4,103,547
Nov 10,268,791 6,647,038
Dec 145,246 114,763
YTD Total 19,396,313$ 12,626,243$ 12,678,534$ (6,717,779)$ ‐35% 52,291$ 0%
Annual Total 37,038,480$ 24,103,395$
Property Tax Revenues
Year to Date through May
2017 vs. 2016 2017 vs. Budget
Month
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 1,978,530$ 2,031,194$ 2,092,821$ 114,291$ 6% 61,627$ 3%
Feb 2,320,497 2,422,103 2,473,715 153,218 7% 51,612 2%
Mar 1,854,773 1,886,175 1,945,278 90,505 5% 59,103 3%
Apr 1,888,875 1,881,780 1,871,345 (17,530) ‐1% (10,435) ‐1%
May 2,314,220 2,200,305 2,381,981 67,761 3% 181,675 8%
Jun 2,127,406 1,967,578 ‐
Jul 2,103,896 2,017,854 ‐
Aug 2,438,277 2,274,282 ‐
Sep 2,179,438 2,171,299 ‐
Oct 2,410,824 2,262,292 ‐
Nov 2,532,820 2,367,730 ‐
Dec 2,203,689 2,217,808 ‐
YTD Total 10,356,895$ 10,421,556$ 10,765,139$ 408,244$ 4% 343,583$ 3%
Annual Total 26,353,246$ 25,700,400$
2017 vs. Budget2017 vs. 2016
Month
Year to Date through May
Local Retail Sales Tax Revenues
Page 2 of 37
Monthly Financial Report May 2017
The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business
sectors:
Utility tax
May utility tax revenues are
$1.5M, which is $101k or 7%
higher than the same month last
year and is also higher than the
budget by $180k or 14%. The
year‐to‐date collection is $7.5M,
which is $278k or 4% higher than
the prior year and is also $747k or
11% 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 1,616,412$ 1,709,455$ 1,747,742$ 131,330$ 8% $ 38,287 2%
Auto Sales 1,970,381 1,878,779 1,975,629 5,247 0% 96,849 5%
General Retail 3,011,181 3,000,345 3,152,579 141,399 5% 152,234 5%
Manufacturing 749,644 691,244 642,159 (107,486) ‐14% (49,085)‐7%
Wholesale 505,043 548,468 579,336 74,293 15% 30,869 6%
Service 2,265,021 2,339,101 2,351,275 86,254 4% 12,174 1%
Other 239,212 254,164 316,419 77,207 32% 62,255 24%
YTD Total 10,356,895$ 10,421,556$ 10,765,139$ 408,244$ 4%343,583$ 3%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 1,509,960$ 1,277,138$ 1,698,721$ 188,761$ 13% 421,584$ 33%
Feb 1,597,348 1,458,074 1,360,589 (236,759) ‐15% (97,485) ‐7%
Mar 1,423,774 1,462,603 1,197,548 (226,226) ‐16% (265,055) ‐18%
Apr 1,346,282 1,289,233 1,797,449 451,168 34% 508,217 39%
May 1,363,323 1,284,502 1,464,438 101,115 7% 179,936 14%
Jun 1,125,845 1,177,807
Jul 1,276,335 1,234,377
Aug 1,247,926 1,269,789
Sep 1,277,502 1,227,003
Oct 1,351,888 1,252,150
Nov 1,128,100 1,206,958
Dec 1,359,717 1,338,504
YTD Total 7,240,686$ 6,771,549$ 7,518,745$ 278,059$ 4% 747,196$ 11%
Annual Total 16,007,999$ 15,478,137$
2017 vs. Budget2017 vs. 2016
Year to Date through May
Utility Tax Revenues
Month
Utility Tax by Type 2016 2017 Bgt YTD Act Change 2017/2016 2017 Act vs Bgt
Electrical 2,500,347$ 2,361,956$ 2,609,011$ 108,665$ 4% $ 247,056 10%
Natural Gas 909,353 947,456 1,104,964 195,610 22% 157,508 17%
Cell 743,627 675,751 641,414 (102,212) ‐14% (34,337)‐5%
Phone 410,986 332,234 404,260 (6,727) ‐2% 72,025 22%
Cable 643,405 652,099 661,829 18,423 3% 9,730 1%
Garbage/Solid Waste 276,362 258,368 230,528 (45,834) ‐17% (27,840)‐11%
City Utilities 1,645,378 1,543,685 1,866,739 221,361 13% 323,054 21%
Utility Tax Audit 111,227 ‐ ‐ (111,227) 0% ‐ N/A
YTD Total 7,240,686$ 6,771,549$ 7,518,745$ 278,059$ 4%747,196$ 11%
Annual Total 16,007,999$ 15,478,137$
YTD as % of 45% 44%
Page 3 of 37
Monthly Financial Report May 2017
Other Taxes
Real Estate Excise Tax
The City collected $386k in Real
Estate Excise Tax revenues (REET)
for May. This is $89k or 19% less
than the same month last year
but is $25k or 7% more than the
current month’s budget. The
year‐to‐date collection is $2.8M,
which is $424k or 18% more than
the prior year and is also $1.1M
or 65% above the budget. The
higher than expected variance is
due to 14 large transactions in
December, January, February,
March, and April which accounts
for $1.1M of the total REET
collected.
Gambling Tax
May’s Gambling Tax collections
totaled $249k, which is $50k or
25% above the same month last
year and is also above the current
month’s budget by $90k or 57%.
The year‐to‐date total of $1.1M is
$82k or 8% above the prior year
and is also $282k or 36% above
budget.
Franchise Fees
Franchise Fees are due quarterly
in January, April, July, and
October. The year‐to‐date total
of $774k is $70k or 10% higher
than the prior year and is also
$111k or 17% above the
projected year‐to‐date budget.
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 1,204,479$ 708,703$ 1,028,456$ (176,023)$ ‐15% 319,752$ 45%
Feb 197,327 148,787 337,024 139,698 71% 188,237 127%
Mar 208,452 204,512 708,868 500,416 240% 504,357 247%
Apr 335,985 298,627 385,517 49,532 15% 86,890 29%
May 475,244 361,568 386,087 (89,156) ‐19% 24,519 7%
Jun 405,179 346,520
Jul 644,038 497,925
Aug 759,583 484,354
Sep 522,472 401,943
Oct 559,552 434,871
Nov 502,139 266,351
Dec 307,382 265,838
YTD Total 2,421,486$ 1,722,197$ 2,845,952$ 424,466$ 18% 1,123,755$ 65%
Annual Total 6,121,830$ 4,420,000$
*For 2017, REET is only in CIP
Real Estate Excise Tax (REET) Revenues*
Year to Date through May
Month
2017 vs. Budget2017 vs. 2016
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 ‐
Jul 194,317 162,180 ‐
Aug 322,828 229,017 ‐
Sep 202,409 159,756 ‐
Oct 242,254 190,582 ‐
Nov 183,345 165,084 ‐
Dec 181,924 155,817 ‐
YTD Total 988,484$ 787,941$ 1,070,091$ 81,607$ 8% 282,150$ 36%
Annual Total 2,500,604$ 2,000,000$
Gambling Tax Revenue
Month
Year to Date through May
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%
Jul 343,910 330,451 ‐
Sep 5,000 2,414 ‐
Oct 348,783 332,455 ‐
Dec 4,850 2,341 ‐
YTD Total 703,549$ 662,339$ 773,584$ 70,035$ 10% 111,245$ 17%
Annual Total 1,406,092$ 1,330,000$
Franchise Fees Revenue
Year to Date through May
Month
2017 vs. 2016 2017 vs. Budget
Page 4 of 37
Monthly Financial Report May 2017
Admission Tax
Admission Tax returns are due
quarterly in January, April, July,
and October of each year. April
2017 collections represent
activities conducted during the
1st quarter of 2017. The year‐to‐
date collection of $123k is $17k
or 12% less than the prior year
and is also $40k or 25% less than
the budget.
Business & Occupation Tax
Business and Occupation (B&O)
Tax is a new revenue source for
the City in 2016. It was adopted
by the Council in the 2015/2016
biennial budget. Businesses with
gross receipts of $1.5M or more
per year, earned within the City
of Renton, will be required to file
and pay B&O tax, in lieu of the
Per Employee Fee, which is
currently reported as Business
License revenue. Year‐to‐date
receipts totaled $6.2M.
Licenses and Permits
Business Licenses
Business Licenses totaled $126k
for May, which is $15k or 13%
above the same month last year
and is also $54k or 74% above the
current month’s budget. The
year‐to‐date Business Licenses
revenue of $724k is $461k or 39%
below the prior year but is above
the budget by $30k or 4%. 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 ‐
Apr 63,088 71,681 58,566 (4,522) ‐7% (13,115) ‐18%
May ‐ 852 1,279 1,279 100% 427 50%
Jul 60,763 80,276 ‐
Sep 518 289 ‐
Oct 58,934 74,983 ‐
Nov 1,452 831 ‐
YTD Total 140,840$ 163,621$ 123,373$ (17,467)$ ‐12% (40,188)$ ‐25%
Annual Total 262,506$ 320,000$
2017 vs. Budget
Admission Tax Revenue
Year to Date through May
Month
2017 vs. 2016
2016 2017 2017
Actual Budget Actual $ % $ %
Jan ‐$ 1,360,000$ 432,319$ 432,319$ 100% (927,681)$ ‐68%
Feb ‐ 170,000 794,093 794,093 100% 624,093 367%
Mar ‐ 170,000 13,228 13,228 100% (156,772) ‐92%
Apr 4,578,349 1,360,000 4,626,880 48,531 1% 3,266,880 240%
May 304,032 170,000 316,791 12,759 4% 146,791 86%
Jun 30,591 170,000 ‐
Jul 376,209 1,360,000 ‐
Aug 334,807 170,000 ‐
Sep 10,779 170,000 ‐
Oct 603,622 1,360,000 ‐
Nov 136,933 170,000 ‐
Dec ‐ 170,000 ‐
YTD Total 4,882,381$ 3,230,000$ 6,183,312$ 1,300,931$ 27% 2,953,312$ 91%
Annual Total 6,375,322$ 6,800,000$
*Total Business & Occupation Taxes (GF & CIP)
Business & Occupation Taxes*
Year to Date through May
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 ‐
Jul 248,769 228,999 ‐
Aug 121,095 65,678 ‐
Sep 22,190 13,573 ‐
Oct 218,271 222,326 ‐
Nov 91,870 56,325 ‐
Dec 12,555 7,925 ‐
YTD Total 1,184,825$ 694,138$ 723,975$ (460,850)$ ‐39% 29,836$ 4%
Annual Total 1,926,510$ 1,302,453$
*Total Business License (GF & CIP)
2017 vs. 2016
Year to Date through May
2017 vs. Budget
Business Licenses*
Month
Page 5 of 37
Monthly Financial Report May 2017
Building Permits and
Development Service Fees
Building Permits and
Development Service Fee
revenues totaled $559k in May.
The year‐to‐date revenues of
$2M is $366k or 15% less than the
year before and is also $92k or
4% lower 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)
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 $2.7M or 37% of the budget.
State Shared Revenues
State Shared Revenue
collections totaled
$2.4M since the start of
the year. Compared to
the prior year, State
Shared Revenues are
above by $40k or 2%.
Compared to the
projected budget, the
City is collecting $132k
or 6% more. The higher
than expected collection
is due to collecting more
than anticipated
Criminal Justice’s Sales
Tax and Liquor Excise 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
Jul 462,211 691,725
Aug 397,578 438,730
Sep 380,480 498,572
Oct 479,048 478,350
Nov 297,449 359,940
Dec 468,303 472,668
YTD Total 2,370,874$ 2,096,984$ 2,004,656$ (366,219)$ ‐15% (92,328)$ ‐4%
Annual Total 5,293,563$ 5,735,368$
Year to Date through May
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 670,937$ ‐$ ‐$ (670,937)$ 0% $ ‐ N/A
Fire District #40 2,601,942 170,969 170,969 (2,430,973) ‐93%‐ 0%
State Shared Revenue 2,342,712 2,250,403 2,382,505 39,794 2% 132,102 6%
Federal Grants 225,612 57,658 57,658 (167,955) ‐74%‐ 0%
State Grants 39,421 22,246 22,246 (17,175) ‐44%‐ 0%
Other Grants/Intgovt 330,458 100,312 96,524 (233,934) ‐71% (3,788) ‐4%
ARRA Grants ‐ ‐ ‐ ‐ N/A ‐ N/A
Total Rev YTD 6,211,081$ 2,601,589$ 2,729,902$ (3,481,179)$ ‐56%128,314$ 5%
Total Rev Annual 10,698,115$ 7,462,447$
YTD % 58% 35% 37%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
2016 2017 2017
Actual Budget Actual $ % $ %
Crim Just Sales Tax 1,086,336$ 1,073,526$ 1,134,254$ 47,918$ 4% 60,728$ 6%
Judicial Contribution 12,200 ‐ ‐ (12,200) 0%‐ N/A
Crim Just ‐ High Crime 155,458 124,759 135,448 (20,010) ‐13% 10,688 9%
Crim Just ‐ Pop 13,231 11,892 14,011 780 6% 2,119 18%
Crim Just ‐ Spec Prog 48,378 44,223 50,973 2,595 5% 6,751 15%
State DUI 7,700 9,319 7,725 25 0% (1,594) ‐17%
Marijuana Enforcement 2,927 ‐ 11,885 8,958 306% 11,885 100%
Liquor Profits 212,574 212,784 213,888 1,314 1% 1,103 1%
Liquor Excise Tax 234,988 212,072 247,760 12,772 5% 35,687 17%
Fuel Tax 568,919 561,828 566,562 (2,358) 0% 4,734 1%
YTD Total 2,342,712$ 2,250,403$ 2,382,505$ 39,794$ 2% 132,102$ 6%
Annual Total 5,933,890$ 5,805,528$
State Shared Revenues
2017 vs. 2016
Revenue
Year to Date through May
2017 vs. Budget
Page 6 of 37
Monthly Financial Report May 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
63% of the total revenue in this category. The year‐to‐date total charges for services are $3.3M or 39% of the budget. The
following sections provide detail information for Public Safety, Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totaled
$407k 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 $46k or 13%
more. Compared to the year‐to‐
date budget, the City is over
budget by $136k or 50%. 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
$84k for the current month.
Compared to the same month
the prior year, the City collected
$12k or 17% more. Compared to
the projected monthly budget,
the City collected $10k or 14%
more. The year‐to‐date
collection of $415k is $42k or 9%
lower than the year before and is
also $17k or 4% 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 ‐
Jul 34,906 27,743 ‐
Aug 44,439 38,564 ‐
Sep 67,570 33,790 ‐
Oct 160,438 72,212 ‐
Nov 67,763 42,537 ‐
Dec 78,473 48,375 ‐
YTD Total 361,501$ 270,823$ 407,050$ 45,549$ 13% 136,227$ 50%
Annual Total 994,179$ 613,081$
2017 vs. Budget
Month
2017 vs. 2016
Year to Date through May
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 ‐
Jul 325,043 409,892 ‐
Aug 349,650 360,345 ‐
Sep 107,652 123,607 ‐
Oct 45,706 55,007 ‐
Nov 68,324 70,632 ‐
Dec 39,475 44,472 ‐
YTD Total 457,281$ 432,703$ 415,410$ (41,872)$ ‐9% (17,294)$ ‐4%
Annual Total 1,632,903$ 1,750,923$
2017 vs. Budget2017 vs. 2016
Month
Recreation
Year to Date through May
Page 7 of 37
Monthly Financial Report May 2017
Interfund Services
The year‐to‐date collections for
Interfund Services revenues are
$1.7M. Compared to the prior
year, the revenues are over by
$279k or 20%. Compared to the
projected budget, the revenues
are below by $49k or 3%. 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
$1M. This is $46k or 4% lower
than a year ago and is also $41k
or 4% below 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 ‐
Jul 259,888 348,248 ‐
Aug 273,851 348,248 ‐
Sep 286,057 348,248 ‐
Oct 277,517 348,248 ‐
Nov 295,584 348,248 ‐
Dec 311,019 348,248 ‐
YTD Total 1,413,523$ 1,741,240$ 1,692,540$ 279,018$ 20% (48,699)$ ‐3%
Annual Total 3,377,663$ 4,178,976$
2017 vs. Budget
Month
Interfund Services
Year to Date through May
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
Jul 222,267 219,171
Aug 274,964 252,324
Sep 200,986 232,621
Oct 238,517 243,770
Nov 273,338 270,941
Dec 306,114 310,486
YTD Total 1,083,222$ 1,077,838$ 1,036,892$ (46,330)$ ‐4% (40,946)$ ‐4%
Annual Total 2,860,662$ 2,868,450$
Month
2017 vs. Budget2017 vs. 2016
Year to Date through May
Fines and Penalties by Month
Year to Date through May
2016 2017 2017
Actual Budget Actual $ % $ %
Civil Penalties 757$ 1,897$ 868$ 111$ 15% (1,029)$ ‐54%
Civil Infraction Penalties 122,981 120,455 118,444 (4,538) ‐4% (2,011) ‐2%
Civil Parking Infraction Penalties 54,634 77,581 60,382 5,748 11% (17,199) ‐22%
Photo Enforcement Program 794,941 790,732 762,218 (32,723) ‐4% (28,514) ‐4%
Criminal Traffic Misdemeanor Fines 27,259 25,443 25,722 (1,537) ‐6% 278 1%
Criminal Non‐Traffic Fines 12,623 22,370 21,156 8,533 68% (1,214) ‐5%
Criminal Costs 35,687 33,750 31,210 (4,477) ‐13% (2,540) ‐8%
Non‐Court Fines, Forfeitures and Penalties 34,341 5,610 16,893 (17,448) ‐51% 11,283 201%
YTD Total 1,083,222$ 1,077,838$ 1,036,892$ (46,330)$ ‐4% (40,946)$ ‐4%
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 May 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 $762k.
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 $1M. Compared
to last year, the revenues are
below by $464k or 32%.
Compared to the projected year‐
to‐date budget, the revenues are
over by $333k or 50%. 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 ‐ 89,775 ‐ ‐
Jul 144,851 ‐ 89,775 ‐ ‐
Aug 183,427 ‐ 89,775 ‐ ‐
Sep 164,770 ‐ 89,775 ‐ ‐
Oct 175,856 ‐ 89,775 ‐ ‐
Nov 185,108 ‐ 89,775 ‐ ‐
Dec 204,263 ‐ 89,775 ‐ ‐
YTD Total 790,732$ 762,218$ 448,874$ 408,200$ 354,018$
Annual Total 2,044,000$ 1,077,297$
1 Actuals of Revenues and Expenses
Photo Enforcement Program
Year to Date through May
Month
Revenues Expenses
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 258,876$ 210,344$ 363,997$ 105,122$ 41% 153,653$ 73%
Feb 802,908 114,483 148,988 (653,920) ‐81% 34,505 30%
Mar 125,950 123,697 150,954 25,004 20% 27,257 22%
Apr 142,439 107,529 188,887 46,448 33% 81,357 76%
May 139,504 116,445 152,678 13,174 9% 36,233 31%
Jun 174,848 157,799
Jul 181,285 159,920
Aug 294,665 159,680
Sep 160,616 120,231
Oct 152,817 126,118
Nov 327,568 103,917
Dec 425,765 368,952
YTD Total 1,469,677$ 672,500$ 1,005,505$ (464,173)$ ‐32% 333,005$ 50%
Annual Total 3,187,241$ 1,869,117$
Year to Date through May
Month
2017 vs. Budget2017 vs. 2016
Miscellaneous Revenues by Month
2016 2017 2017
Actual Budget Actual $ % $ %
Interests and Other Earnings 282,676$ 241,294$ 335,699$ 53,022$ 19% 94,405$ 39%
Rents, Leases, and Concessions 276,280 273,546 275,104 (1,177) 0% 1,558 1%
Contributions/Donations from Private Sources 42,389 38,058 71,218 28,829 68% 33,160 87%
Other 205,188 119,602 173,933 (31,255) ‐15% 54,331 45%
Seizure Funds ‐ Federal/State/Local 663,143 ‐ 149,552 (513,592) ‐77% 149,552 100%
YTD Total 1,469,677$ 672,500$ 1,005,505$ (464,173)$ ‐32% 333,005$ 50%
Annual Total 3,187,241$ 1,869,117$
2017 vs. Budget
Miscellaneous Revenues by Type
Year to Date through May
Revenue
2017 vs. 2016
Page 9 of 37
Monthly Financial Report May 2017
EXPENSES
Overall the City has expended 32% of its budgeted general governmental expenditures at the end of May. This is $1.4M or
3.9% below year‐to‐date budgeted expenditures. See below for summary of unfavorable items for general governmental
departments.
Administrative Services department (Finance and City Clerk) is over the year‐to‐date budget by $62k or 4%. This is due to the
timing of when the 2016 voter registration invoice was paid in 2017 compared to 2015/2016.
Public Works department (Admin, Street Maintenance, and Transportation) is over the year‐to‐date budget by $82k or
1.8%. This is due to overspending on supplies, back billing of Surface Water utility (rate increase portion only), and
interfund payments to other Maintenance sections.
Page 10 of 37
Monthly Financial Report May 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 ‐ ‐ ‐ ‐ 36,500 20,100 ‐
Grants / intergovernmental 5,788 ‐ 31,780 ‐ 690,270 346,048 ‐
Charges for services 54,915 560,799 6,914,693 6,056,608 4,243,658 4,831,184 6,884,654
Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐
Fines and penalties 450 ‐ ‐ ‐ 964 ‐ ‐
Rents, leases, and misc fees 1,102,319 112,954 11,857 87,743 ‐ ‐ ‐
Interest and other misc 9,082 538 37,026 278,294 841,933 371,703 13,633
TOTAL REVENUES 1,172,554 674,291 6,995,356 6,422,645 5,813,325 5,569,035 6,898,287
EXPENSES:
Utility billing ‐ ‐ 19,929 68,939 54,004 83,840 ‐
Utility systems ‐ ‐ 7,368,436 1,409,935 1,419,042 1,615,932 ‐
Utility maintenance ‐ ‐ 137,111 2,281,653 864,671 1,140,017 5,602,463
Transportation 642,887 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 875,821 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 642,887 875,821 7,525,476 3,760,527 2,337,717 2,839,789 5,602,463
AMOUNT AVAILABLE FOR DEBT SERVICE 529,667 (201,530) (530,119) 2,662,118 3,475,608 2,729,246 1,295,824
DEBT SERVICE:
Principal ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest ‐ ‐ ‐ 521 263 216,911 ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ 521 263 216,911 ‐
CAPITAL PROJECTS 57,308 32,339 ‐ 1,344,185 711,822 545,226 ‐
TRANSFERS IN/(OUT)‐ ‐ (370) (433) (1,205) (370) ‐
CHANGE IN FUND BALANCE 472,359 (233,869) (530,489) 1,316,979 2,762,318 1,966,739 1,295,824
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, May 31 3,091,702 (196,781) 2,220,928 29,845,913 16,621,980 12,860,714 6,290,482
Page 11 of 37
Monthly Financial Report May 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 ‐ 76,843 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ 7,110 ‐ ‐ ‐ ‐ 47,440
Charges for services
Equipment rental m&o 1,131,556 1,771,008 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ ‐ ‐ 183,044 ‐ ‐ ‐
Communications ‐ 331,043 395,211 265,798 ‐ ‐ ‐
Facilities ‐ ‐ 1,697,714 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ ‐ ‐ ‐ ‐ ‐ ‐
IT service co ntracts ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest and other misc 19,050 7,719 4,277 1,590 35,575 12,400 29,099
Internal service fund misc:
Vehicle / equipment capital recovery 922,498 201,660 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 715,143 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 558,291 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 3,856,996 1,093,616
Other misc 201 47 653 10 ‐ 379,409 ‐
Interfund Loan ‐ ‐ ‐ ‐ ‐ ‐ ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets ‐ ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 100,643 ‐ ‐
TOTAL REVENUES 2,073,305 2,395,430 2,097,856 450,442 1,409,652 4,248,805 1,170,155
EXPENSES:
Communications 244,688
Equipment rental 947,490
Facilities 1,801,920
Healthcare 3,561,204
Information technology 1,795,380
Print and mail 160,838
Retiree healthcare 296,922
Risk management:
Risk ma nagement 540,978
Unemployment 29,994
Worker's compensation 735,133
TOTAL EXPENSES 947,490 1,795,380 1,801,920 405,526 1,306,105 3,561,204 296,922
AMOUNT AVAILABLE FOR CAPITAL 1,125,815 600,050 295,936 44,916 103,547 687,601 873,233
CAPITAL PROJECTS 942,880 229,074 ‐ ‐ ‐ ‐ ‐
TRANSFERS IN ‐ 2,484 ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ (89,876) ‐
CHANGE IN FUND BALANCE 182,935 373,460 295,936 44,916 103,547 597,725 873,233
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, May 31 6,614,988 2,943,834 1,570,989 587,843 12,956,056 4,753,873 10,952,484
Page 12 of 37
Monthly Financial Report May 2017
FUND BALANCE
Page 14 shows the ending fund balance as of May 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 May, the City has $40.3M reported in the combined general governmental fund balance of the current year’s
operating budget, which is approximately 37% of budgeted operating expenditures. This is an increase of $13.7M from the
year’s beginning balance. May’s ending fund balance is over the anticipated General Governmental Fund Balance of $35.2M
by $5.1M or 14.4%. 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 May 2017
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through May 31, 2017
Funds
Balance
01/01/2017
Budgeted
Revenue
Revenue
05/31/17
Total Funds
Available
Budgeted
Expenditure
Expenditure
05/31/17 Ending Balance
GENERAL GOVERNMENT FUNDS: 26,563,785 102,363,998 47,996,932 74,560,717 108,135,226 34,253,900 40,306,817
000 General 18,201,028 69,622,089 32,860,499 51,061,527 75,673,977 24,797,719 26,263,808
001 Community Services 3,769,766 13,482,904 6,081,790 9,851,556 13,682,477 4,533,768 5,317,788
003 Street 1,936,367 11,885,024 5,993,335 7,929,702 11,306,335 4,473,851 3,455,851
004 Community Dev Block Grant 66,654 1,068,770 413 67,067 1,076,270 28,508 38,559
005 Museum 72,372 233,936 117,090 189,462 236,275 97,324 92,138
009 Farmers Market 90,730 95,950 31,900 122,630 93,263 29,039 93,591
011 Fire Health & Wellness ‐ ‐ ‐ ‐ ‐ ‐ ‐
201 Ltd GO Bonds Gen Govt Debt 852,111 1,749,675 877,458 1,729,569 1,749,675 300 1,729,269
215 Gen Govt Misc Debt Service 1,574,757 4,225,650 2,034,446 3,609,203 4,316,954 293,391 3,315,812
SPECIAL REVENUE FUNDS:1,599,965 1,974,729 946,999 2,546,964 2,116,614 371,030 2,175,934
102 Arterial Street 63,480 660,000 267,094 330,574 660,000 ‐ 330,574
108 Leased City Properties 276,865 902,550 495,056 771,921 839,996 253,661 518,260
110 Hotel Motel 402,602 265,000 97,838 500,440 375,994 84,499 415,941
125 1% For Art 128,489 24,505 359 128,848 117,950 ‐ 128,848
127 Cable Communication 394,504 122,674 85,719 480,223 122,674 32,870 447,353
135 Springbrook Wetlands Bank 334,025 ‐ 933 334,958 ‐ ‐ 334,958
CAPITAL PROJECT FUNDS (CIP):26,202,403 34,585,139 10,596,193 36,798,596 45,620,731 4,699,125 32,099,471
303 Community Dev Mitigation 1,255,194 406,014 155,190 1,410,384 ‐ ‐ 1,410,384
304 Fire Mitigation 607,163 99,000 352,467 959,630 158,696 ‐ 959,630
305 Transportation Mitigation 1,497,748 620,000 351,366 1,849,114 1,855,000 ‐ 1,849,114
316 Municipal Facilities CIP 15,038,030 13,650,632 5,681,268 20,719,298 19,147,133 582,689 20,136,609
317 Transportation CIP 5,640,494 18,309,493 4,050,229 9,690,723 23,434,675 3,819,933 5,870,790
326 Housing Opportunity 1,041,173 1,500,000 2,908 1,044,081 ‐ ‐ 1,044,081
336 New Library Development 1,122,601 ‐ 2,765 1,125,366 1,025,227 296,503 828,863
ENTERPRISE FUNDS: 63,685,077 89,985,148 33,570,495 97,255,572 120,529,012 26,520,635 70,734,937
4X2 Ai rport Operating & CIP 2,619,343 3,405,842 1,172,554 3,791,897 5,688,023 700,196 3,091,701
403 Solid Waste Utility 2,751,417 19,187,851 6,995,356 9,746,773 19,024,775 7,525,845 2,220,928
4X4 Golf Operating & CIP 37,088 2,893,044 699,292 736,380 2,630,288 933,160 (196,780)
4X5 Water Operating & CIP 28,528,934 17,180,526 6,422,645 34,951,579 35,347,154 5,105,666 29,845,913
4X6 Waste Water Operating & CIP 13,859,662 13,264,936 5,813,325 19,672,987 20,537,816 3,051,008 16,621,979
416 King County Metro 4,994,658 17,505,693 6,898,287 11,892,945 17,505,693 5,602,463 6,290,482
4X7 Surface Water Operating & CIP 10,893,975 16,547,256 5,569,036 16,463,011 19,795,263 3,602,297 12,860,714
INTERNAL SERVICE FUNDS: 37,908,315 34,753,373 13,848,127 51,756,442 33,465,387 11,376,377 40,380,065
501 Equipment Repair/Replacement 6,432,053 6,480,853 2,073,305 8,505,358 7,684,613 1,890,370 6,614,988
502 Insurance 12,852,509 7,392,368 1,409,652 14,262,161 3,571,166 1,306,105 12,956,056
503 Information Services 2,570,374 5,731,776 2,397,913 4,968,287 6,835,636 2,024,453 2,943,834
504 Facilities 1,275,053 5,027,015 2,097,856 3,372,909 5,094,433 1,801,920 1,570,989
505 Communications 542,927 1,078,253 450,442 993,369 1,076,474 405,527 587,842
512 Insurance, Healthcare 4,156,148 7,787,779 4,248,804 8,404,952 8,163,471 3,651,080 4,753,872
522 Insurance, Leoff1 Retirees HC 10,079,251 1,255,329 1,170,155 11,249,406 1,039,594 296,922 10,952,484
FIDUCIARY FUNDS:5,578,045 468,000 161,867 5,739,912 210,475 99,056 5,640,856
611 Firemen's Pension 5,578,045 468,000 161,867 5,739,912 210,475 99,056 5,640,856
TOTAL FUNDS 161,537,590 264,130,387 107,120,613 268,658,203 310,077,445 77,320,123 191,338,080
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
July
August
September
October
November
December
(8,000,000)
(7,000,000)
(6,000,000)
(5,000,000)
(4,000,000)
(3,000,000)
(2,000,000)
(1,000,000)
‐
1,000,000
2,000,000
3,000,000
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
‐
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,149,770 7,364,146 3.00%
Feb 13,647,736 14,472,917 6.05%
Mar 20,098,332 21,057,303 4.77%
Apr 32,959,305 39,230,543 19.03%
May 44,302,145 47,996,932 8.34%
Jun 50,579,477
Jul 58,087,814
Aug 64,775,659
Sep 71,135,180
Oct 82,502,291
Nov 95,334,325
Dec 102,363,998
Percent of budget 46.89%
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
Jul 12,760,104
Aug 12,870,217
Sep 13,238,047
Oct 17,341,593
Nov 23,988,632
Dec 24,103,395
Percent of budget 52.60%
$‐
$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,261,189 2,340,558 3.51%
Feb 4,964,886 5,107,413 2.87%
Mar 7,067,913 7,282,613 3.04%
Apr 9,174,172 9,375,961 2.20%
May 11,640,150 12,040,621 3.44%
Jun 13,842,125
Jul 16,104,724
Aug 18,663,293
Sep 21,097,526
Oct 23,629,240
Nov 26,285,407
Dec 28,763,680
Percent of budget 41.86%
Note: Excludes CJ Sales Tax and Natural Gas Use Tax.
Utility Tax Budget
YTD
Actual
Annual %
over (under)
Jan 1,277,138 1,698,721 33.01%
Feb 2,735,212 3,059,310 11.85%
Mar 4,197,814 4,256,858 1.41%
Apr 5,487,047 6,054,307 10.34%
May 6,771,549 7,518,745 11.03%
Jun 7,949,356
Jul 9,183,733
Aug 10,453,523
Sep 11,680,525
Oct 12,932,675
Nov 14,139,633
Dec 15,478,137
Percent of budget 48.58%
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,961,934 1,825,961 ‐6.93%
Jun 2,264,302
Jul 2,972,183
Aug 3,368,015
Sep 3,791,878
Oct 4,274,238
Nov 4,532,625
Dec 4,815,012
Percent of budget 37.92%
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,260,445
Jul 3,755,419
Aug 4,463,063
Sep 5,104,478
Oct 5,598,859
Nov 6,378,926
Dec 7,462,447
Percent of budget 36.58%
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
Jul 5,207,148
Aug 6,077,059
Sep 6,705,746
Oct 7,327,762
Nov 7,947,988
Dec 8,677,538
Percent of budget 38.58%
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
Jul 1,558,308
Aug 1,810,632
Sep 2,043,253
Oct 2,287,023
Nov 2,557,964
Dec 2,868,450
Percent of budget 36.15%
$‐
$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,428,684 1,094,465 ‐23.39%
Feb 1,708,305 2,107,354 23.36%
Mar 1,968,404 2,310,521 17.38%
Apr 3,446,027 7,618,498 121.08%
May 3,713,922 5,718,954 53.99%
Jun 4,018,000
Jul 5,456,111
Aug 5,805,828
Sep 6,075,201
Oct 7,571,990
Nov 7,846,056
Dec 8,155,026
Percent of budget 70.13%
Misc Budget
YTD
Actual
Annual %
over (under)
Jan 210,344 363,997 73.05%
Feb 324,828 512,986 57.93%
Mar 448,525 663,940 48.03%
Apr 556,054 852,826 53.37%
May 672,500 1,005,505 49.52%
Jun 830,299
Jul 990,219
Aug 1,149,899
Sep 1,270,130
Oct 1,396,247
Nov 1,500,165
Dec 1,869,117
Percent of budget 53.80%
$‐
$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 85,598
Jul 99,864
Aug 114,131
Sep 128,397
Oct 142,663
Nov 156,930
Dec 171,196
Percent of budget 55.04%
REET Budget
YTD
Actual
Annual %
over (under)
Jan 708,703 1,028,456 45.12%
Feb 857,491 1,365,480 59.24%
Mar 1,062,002 2,074,348 95.32%
Apr 1,360,630 2,459,865 80.79%
May 1,722,197 2,845,952 65.25%
Jun 2,068,717
Jul 2,566,642
Aug 3,050,997
Sep 3,452,940
Oct 3,887,811
Nov 4,154,162
Dec 4,420,000
Percent of budget 64.39%
$‐
$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
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
Jul 3,487,109
Aug 3,925,839
Sep 4,424,411
Oct 4,902,760
Nov 5,262,700
Dec 5,735,368
Percent of budget 34.95%
B & O Tax Budget
YTD
Actual
Annual %
over (under)
Jan 1,360,000 432,319 ‐68.21%
Feb 1,530,000 1,226,412 ‐19.84%
Mar 1,700,000 1,239,641 ‐27.08%
Apr 3,060,000 5,866,521 91.72%
May 3,230,000 6,183,312 91.43%
Jun 3,400,000
Jul 4,760,000
Aug 4,930,000
Sep 5,100,000
Oct 6,460,000
Nov 6,630,000
Dec 6,800,000
Percent of budget 90.93%
$‐
$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
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 6,922,649 6,595,136 ‐4.73%
Feb 13,866,897 13,388,134 ‐3.45%
Mar 21,370,450 20,198,065 ‐5.49%
Apr 28,303,146 27,006,711 ‐4.58%
May 35,643,471 34,253,900 ‐3.90%
Jun 51,910,357
Jul 61,378,159
Aug 70,614,851
Sep 79,814,188
Oct 89,066,826
Nov 97,712,050
Dec 108,135,225
Percent of budget expended 31.68%
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
Jul 219,892
Aug 249,074
Sep 278,319
Oct 308,035
Nov 337,502
Dec 368,211
Percent of budget expended 42.82%
$‐
$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 211,773 211,310 ‐0.22%
Feb 354,764 350,285 ‐1.26%
Mar 535,758 490,536 ‐8.44%
Apr 678,464 632,403 ‐6.79%
May 820,176 793,626 ‐3.24%
Jun 980,311
Jul 1,122,714
Aug 1,283,513
Sep 1,468,126
Oct 1,611,032
Nov 1,754,366
Dec 1,957,671
Percent of budget expended 40.54%
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
Jul 329,069
Aug 399,866
Sep 448,780
Oct 492,637
Nov 535,475
Dec 609,249
Percent of budget expended 36.07%
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
Millions Executive
Budget
Actual
Last Year
$‐
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
Emergency Management
Budget
Actual
Last Year
Page 24 of 37
City of Renton
Monthly Expenditure Analysis ‐ 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
Jul 1,281,325
Aug 1,466,602
Sep 1,658,357
Oct 1,826,387
Nov 1,995,101
Dec 2,163,329
Percent of budget expended 40.06%
Court Services Budget
YTD
Actual
Annual %
over (under)
Jan 171,264 169,642 ‐0.95%
Feb 352,218 343,353 ‐2.52%
Mar 535,423 523,105 ‐2.30%
Apr 716,857 708,103 ‐1.22%
May 901,397 888,624 ‐1.42%
Jun 1,094,693
Jul 1,278,228
Aug 1,465,440
Sep 1,656,123
Oct 1,839,864
Nov 2,023,061
Dec 2,220,656
Percent of budget expended 40.02%
$‐
$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 104,691 109,731 4.81%
Feb 209,968 219,758 4.66%
Mar 315,244 329,786 4.61%
Apr 422,897 439,814 4.00%
May 531,643 549,841 3.42%
Jun 639,918
Jul 803,016
Aug 909,108
Sep 1,015,431
Oct 1,121,287
Nov 1,226,753
Dec 1,337,991
Percent of budget expended 41.09%
Development
Services Budget
YTD
Actual
Annual %
over (under)
Jan 257,513 239,337 ‐7.06%
Feb 545,696 501,405 ‐8.12%
Mar 827,936 754,102 ‐8.92%
Apr 1,095,705 1,024,029 ‐6.54%
May 1,376,992 1,282,903 ‐6.83%
Jun 1,662,709
Jul 1,943,507
Aug 2,237,392
Sep 2,540,782
Oct 2,826,404
Nov 3,109,526
Dec 3,418,745
Percent of budget expended 37.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 98,578 46,869 ‐52.46%
Feb 243,727 98,329 ‐59.66%
Mar 357,073 140,672 ‐60.60%
Apr 544,948 190,278 ‐65.08%
May 675,508 342,370 ‐49.32%
Jun 832,077
Jul 990,534
Aug 1,114,255
Sep 1,229,750
Oct 1,442,161
Nov 1,603,783
Dec 1,755,838
Percent of budget expended 19.50%
Planning Budget
YTD
Actual
Annual %
over (under)
Jan 242,179 221,112 ‐8.70%
Feb 488,126 449,900 ‐7.83%
Mar 751,373 681,350 ‐9.32%
Apr 1,009,976 906,510 ‐10.24%
May 1,309,628 1,134,729 ‐13.35%
Jun 1,598,387
Jul 1,862,808
Aug 2,130,592
Sep 2,418,320
Oct 2,693,743
Nov 2,945,967
Dec 3,207,796
Percent of budget expended 35.37%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
$2.00
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 213,401 197,230 ‐7.58%
Feb 427,010 425,531 ‐0.35%
Mar 638,330 630,778 ‐1.18%
Apr 854,316 856,650 0.27%
May 1,084,697 1,073,519 ‐1.03%
Jun 1,405,442
Jul 1,620,542
Aug 1,988,845
Sep 2,222,013
Oct 2,454,488
Nov 2,672,475
Dec 3,362,369
Percent of budget expended 31.93%
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
Jul 646,835
Aug 816,873
Sep 832,467
Oct 948,567
Nov 1,045,159
Dec 1,239,455
Percent of budget expended 43.07%
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,011 87,874 ‐1.28%
Feb 195,204 175,377 ‐10.16%
Mar 317,238 273,335 ‐13.84%
Apr 435,317 395,728 ‐9.09%
May 545,084 492,849 ‐9.58%
Jun 653,804
Jul 762,752
Aug 880,309
Sep 988,492
Oct 1,111,195
Nov 1,218,957
Dec 1,357,317
Percent of budget expended 36.31%
Police Budget
YTD
Actual
Annual %
over (under)
Jan 3,021,473 2,964,875 ‐1.87%
Feb 5,729,432 5,600,968 ‐2.24%
Mar 8,949,044 8,701,186 ‐2.77%
Apr 11,689,480 11,416,735 ‐2.33%
May 14,782,952 14,450,621 ‐2.25%
Jun 17,650,547
Jul 20,838,877
Aug 23,629,666
Sep 26,807,915
Oct 29,657,572
Nov 32,675,468
Dec 36,130,337
Percent of budget expended 40.00%
$‐
$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 43,313 44,101 1.82%
Feb 91,333 84,711 ‐7.25%
Mar 132,122 128,246 ‐2.93%
Apr 170,865 168,961 ‐1.11%
May 208,694 214,954 3.00%
Jun 243,941
Jul 283,798
Aug 323,291
Sep 362,917
Oct 402,012
Nov 441,115
Dec 505,154
Percent of budget expended 42.55%
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
Jul 2,879,343
Aug 3,372,507
Sep 3,882,283
Oct 4,333,779
Nov 4,732,770
Dec 5,179,955
Percent of budget expended 33.85%
$‐
$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 62,091 53,458 ‐13.90%
Feb 131,957 140,186 6.24%
Mar 212,165 204,477 ‐3.62%
Apr 281,414 289,729 2.95%
May 391,584 369,879 ‐5.54%
Jun 491,525
Jul 589,600
Aug 701,668
Sep 817,731
Oct 933,559
Nov 1,038,451
Dec 1,181,283
Percent of budget expended 31.31%
Recreation Budget
YTD
Actual
Annual %
over (under)
Jan 374,500 347,558 ‐7.19%
Feb 775,191 729,951 ‐5.84%
Mar 1,191,689 1,120,569 ‐5.97%
Apr 1,617,505 1,523,454 ‐5.81%
May 2,039,027 1,886,814 ‐7.46%
Jun 2,501,339
Jul 3,172,581
Aug 3,865,594
Sep 4,428,606
Oct 4,845,930
Nov 5,263,175
Dec 5,707,355
Percent of budget expended 33.06%
$‐
$200,000
$400,000
$600,000
$800,000
$1,000,000
$1,200,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
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 73,531 98,615 34.11%
Feb 178,202 170,784 ‐4.16%
Mar 299,737 256,318 ‐14.49%
Apr 463,788 333,897 ‐28.01%
May 544,941 513,338 ‐5.80%
Jun 619,460
Jul 747,449
Aug 858,779
Sep 937,301
Oct 1,120,435
Nov 1,209,310
Dec 1,419,333
Percent of budget expended 36.17%
Neighborhoods
, Resources,
and Events Budget
YTD
Actual
Annual %
over (under)
Jan 81,357 60,703 ‐25.39%
Feb 182,250 125,601 ‐31.08%
Mar 270,845 198,834 ‐26.59%
Apr 346,463 266,753 ‐23.01%
May 434,510 337,861 ‐22.24%
Jun 523,578
Jul 660,849
Aug 771,489
Sep 872,891
Oct 966,341
Nov 1,050,945
Dec 1,201,992
Percent of budget expended 28.11%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
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
Jul 136,413
Aug 156,373
Sep 176,366
Oct 196,623
Nov 216,498
Dec 236,275
Percent of budget expended 41.19%
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
Jul 237,559
Aug 272,046
Sep 306,358
Oct 339,748
Nov 373,069
Dec 406,398
Percent of budget expended 41.75%
$‐
$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
Jul 3,256,692
Aug 3,742,444
Sep 4,214,166
Oct 4,682,566
Nov 5,131,438
Dec 5,636,437
Percent of budget expended 42.73%
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
Jul 2,960,840
Aug 3,404,337
Sep 3,854,060
Oct 4,693,977
Nov 5,071,355
Dec 5,669,897
Percent of budget expended 36.43%
$‐
$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 3,033,315
Jul 3,538,867
Aug 4,044,419
Sep 4,549,972
Oct 5,055,524
Nov 5,561,077
Dec 6,066,629
Percent of budget expended 4.84%
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 7,897,776
Jul 9,214,071
Aug 10,530,367
Sep 11,846,663
Oct 13,162,959
Nov 14,479,255
Dec 15,795,551
Percent of budget expended 8.59%
$‐
$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,298,388 6,899,538 3,629,075
Feb 10,508,247 13,370,807 7,900,322
Mar 16,709,830 19,032,931 12,269,408
Apr 22,820,299 24,791,562 19,152,344
May 29,105,061 31,698,603 24,885,271
Jun 38,397,219
Jul 45,228,609
Aug 57,815,428
Sep 69,394,209
Oct 91,234,500
Nov 98,233,402
Dec 112,210,701
Percent of budget expended 14.44%
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
Jul 2,822,454
Aug 3,228,920
Sep 3,781,625
Oct 4,374,658
Nov 4,712,186
Dec 5,688,023
Percent of budget expended 12.31%
Note: Operations and Capital
$0
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
$120
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
Jul 1,262,542
Aug 1,469,281
Sep 1,655,432
Oct 1,851,777
Nov 2,026,038
Dec 2,630,288
Percent of budget expended 35.48%
Note: Operations and Capital
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
$2.40
$2.70
$3.00
Millions Golf Course
Budget
Revenue
Expense
Page 37 of 37