HomeMy WebLinkAbout201707, JulyADMINISTRATIVE SERVICES
DEPARTMENT
M E M O R A N D U M
DATE: October 10, 2017
TO: Armondo Pavone, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: July 2017 Financial Status Report
At the end of July, general governmental revenues show $4.6M or 7.9% over budget. Revenue
source(s) that are higher than expected are: property tax ($117K); sales tax ($670K); utility taxes
($1.2M); franchise fees ($144K); gambling taxes ($434K); business & occupation taxes ($1.8M);
state shared revenues ($237K); public safety ($133K); seizure funds ($160K), restricted to drug
enforcement and not available for general purposes); interest ($137K); and other miscellaneous
($117K). If we remove B&O taxes and seizure funds, general governmental revenues are $2.6M
or 4.5% over budget. On the down side, the revenue source(s) that are underperforming the
year to date budget are building permits & development service fees ($606K below) and
interfund/interdept charges for services (108K below).
General government expenditures showed a favorable variance of $2M 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,270,155 37,038,480 19,591,281 24,103,395 12,760,104 12,876,968 116,864 0.9%
Sales Tax 23,439,266 12,965,630 26,353,246 14,588,197 25,700,400 14,406,989 15,077,171 670,183 4.7%
Sales Tax ‐ Annexation Credit 2,778,858 1,537,488 3,114,762 1,728,882 3,063,280 1,697,735 1,787,122 89,387 5.3%
Criminal Justice Sales Tax 2,484,718 1,375,384 2,701,787 1,514,910 2,679,898 1,493,432 1,563,288 69,856 4.7%
Natural Gas Use Tax 228,899 164,540 184,638 132,033 228,000 163,040 115,435 (47,605) ‐29.2%
Admission Tax 309,790 234,588 262,506 201,603 320,000 243,897 175,220 (68,677) ‐28.2%
Franchise Fees 1,349,154 1,009,218 1,406,092 1,047,459 1,330,000 992,790 1,137,272 144,482 14.6%
Electricity Tax 5,012,962 2,825,401 5,440,139 3,286,831 5,396,019 3,155,209 3,464,919 309,710 9.8%
Natural Gas Utility Tax 1,437,552 1,001,485 1,327,937 932,161 1,350,900 944,557 1,178,692 234,134 24.8%
Garbage/Solid Waste 638,073 346,373 717,148 399,216 680,000 374,110 356,201 (17,908) ‐4.8%
TV Cable 1,591,866 905,533 1,619,364 914,541 1,645,659 932,734 940,824 8,090 0.9%
Telephone 880,233 526,776 859,868 511,087 714,875 426,379 564,873 138,495 32.5%
Cellular Phone 1,674,355 964,725 1,541,204 947,235 1,521,056 904,415 940,094 35,679 3.9%
City Utilities 4,183,165 2,451,380 4,206,473 2,408,536 3,941,628 2,283,290 2,847,704 564,414 24.7%
Utility Tax Audit 1,962,092 1,446,078 111,227 111,227 ‐ ‐ ‐ ‐ 0.0%
Leasehold Excise Tax 163,314 84,782 173,769 87,456 179,000 91,462 88,358 (3,105) ‐3.4%
Gambling Excise Tax 2,299,156 1,271,410 2,500,604 1,367,844 2,000,000 1,099,744 1,533,322 433,578 39.4%
Real Estate Excise Tax 4,595,166 2,602,732 6,121,830 3,470,703 4,420,000 2,566,642 4,184,639 1,617,996 63.0%
Less: CIP REET (1,401,300) (650,683) (2,707,676) (1,735,351) (4,420,000) (2,566,642) (4,184,639) (1,617,996) 63.0%
EMS Levy 936,406 234,102 479,597 479,597 ‐ ‐ ‐ ‐ 0.0%
B&O Taxes ‐ ‐ 6,375,322 5,289,180 6,800,000 4,760,000 7,345,843 2,585,843 54.3%
Less: CIP B&O Taxes ‐ ‐ (2,000,000) (2,000,000) (2,473,974) (1,731,782) (2,473,974) (742,192) 42.9%
Business License Fees 3,125,740 2,188,980 1,926,510 1,460,529 1,302,453 936,626 978,068 41,442 4.4%
Less: CIP Business License Fees (2,584,164) (1,811,112) (1,587,627) (1,209,063) (617,016) (446,690) (431,193) 15,497 ‐3.5%
Animal Licenses and Spec Events Permits 101,743 64,170 102,905 61,866 92,575 57,954 97,159 39,205 67.6%
Building Permits & Development Svc Fees 6,077,055 3,653,786 5,293,563 3,270,705 5,735,368 3,487,109 2,880,611 (606,497) ‐17.4%
Intergovt'l (Grants, State Shared, etc) 4,053,617 2,233,580 3,998,953 2,361,003 4,639,252 2,107,996 2,267,687 159,692 7.6%
Fire District 25 and 40 Contracts 6,369,132 3,105,766 3,517,779 3,353,423 341,939 170,969 170,969 ‐ 0.0%
Public Safety 649,797 436,585 994,179 575,496 613,081 377,603 510,274 132,671 35.1%
Culture and Recreation 1,587,878 995,551 1,632,903 1,022,095 1,750,923 1,096,859 1,051,172 (45,687) ‐4.2%
Interfund/Interdept‐Services 3,106,430 1,843,723 3,377,663 1,933,634 4,178,976 2,437,736 2,329,831 (107,904) ‐4.4%
Fines and Penalties 848,052 455,490 901,592 433,790 824,450 427,731 418,902 (8,828) ‐2.1%
Photo Enforcement 2,171,184 1,151,572 1,959,071 1,132,954 2,044,000 1,130,577 1,167,915 37,338 3.3%
Seizure Funds ‐ Federal/State/Local 21,676 6,444 987,293 663,143 ‐ ‐ 159,974 159,974 100.0%
Interests and Other Earnings 973,208 401,205 1,058,880 413,380 875,300 350,874 488,225 137,351 39.1%
Rents, Leases, and Concessions 762,361 516,109 642,192 416,116 623,195 413,625 419,315 5,690 1.4%
Contributions and Donations 147,292 79,984 96,582 66,173 130,500 78,211 98,558 20,348 26.0%
Other Miscellaneous 941,127 566,036 956,131 517,172 691,812 388,934 505,446 116,512 30.0%
Other Financing Sources (Transfer‐In, etc 270,224 (13,683,697) 2,129,561 6,075 171,196 97,726 97,726 ‐ 0.0%
Total Operating Revenues 119,555,505 66,463,072 125,816,444 71,753,118 102,578,140 58,111,943 62,729,973 4,618,030 7.9%
OPERATING EXPENDITURES
Council 320,877 191,473 358,550 214,274 368,211 219,892 216,595 3,297 1.5%
Executive 1,691,189 814,282 1,778,206 1,019,792 1,957,671 1,122,714 1,110,100 12,614 1.1%
Emergency Management*398,808 218,700 370,832 196,999 609,249 329,069 314,737 14,331 4.4%
City Attorney 1,791,167 1,062,566 1,983,834 1,173,342 2,163,329 1,281,325 1,211,095 70,230 5.5%
Court Services 2,013,364 1,162,369 2,075,763 1,191,366 2,220,656 1,278,228 1,252,041 26,187 2.0%
Community and Eco Dvlpmnt Admin 1,183,052 735,445 1,161,330 671,572 1,337,991 803,016 781,490 21,526 2.7%
Development Services 2,632,264 1,514,993 2,859,410 1,606,944 3,404,464 1,935,388 1,806,056 129,332 6.7%
Economic Development 658,515 375,085 1,004,411 563,033 1,847,888 1,042,462 490,157 552,306 53.0%
Planning 2,606,551 1,537,578 2,716,214 1,553,419 3,222,077 1,871,101 1,570,361 300,739 16.1%
Finance 3,132,812 1,427,769 3,046,824 1,550,596 3,362,369 1,620,542 1,565,684 54,858 3.4%
City Clerk 1,027,084 472,059 914,251 541,066 1,239,455 646,835 680,117 (33,281) ‐5.1%
Human Resources 1,182,629 659,471 1,193,016 675,537 1,359,317 763,876 699,070 64,806 8.5%
Police 28,144,699 16,284,443 28,891,879 16,554,469 31,280,337 18,009,710 17,951,276 58,434 0.3%
Jail Services 4,142,266 2,417,882 4,704,978 2,744,498 4,850,000 2,803,574 2,803,574 ‐ 0.0%
Fire* 26,138,192 15,388,569 25,349,755 19,454,040 ‐ ‐ ‐ ‐ 0.0%
Community Services Admin 508,766 289,892 585,983 325,143 505,154 283,798 294,560 (10,763) ‐3.8%
Parks 4,411,383 2,473,410 4,445,115 2,449,585 5,179,955 2,879,343 2,568,387 310,956 10.8%
Parks Planning & Natural Resources 808,558 418,287 952,980 460,928 1,271,569 634,663 554,297 80,366 12.7%
Recreation 5,088,483 2,821,618 5,096,236 2,839,821 5,714,855 3,176,750 2,894,508 282,242 8.9%
Human Services 1,225,835 685,824 1,241,169 613,350 1,419,333 747,449 754,865 (7,416) ‐1.0%
Neighborhoods, Resources, & Events 958,624 520,522 865,551 482,399 1,225,894 673,990 526,036 147,954 22.0%
Museum 227,094 131,778 229,543 131,860 236,275 136,413 135,354 1,059 0.8%
Public Works Admin 387,493 225,570 398,796 234,053 406,398 237,559 237,592 (33) 0.0%
Street Maintenance 5,061,723 2,920,408 5,041,509 2,917,165 5,636,437 3,256,692 3,319,755 (63,063) ‐1.9%
Transportation 4,975,059 2,724,715 5,966,281 2,988,891 5,669,897 2,960,840 2,953,908 6,932 0.2%
Debt Service 6,371,715 1,072,897 6,099,166 1,191,679 6,066,629 1,111,163 1,111,163 ‐ 0.0%
Non‐Departmental and Other 10,069,740 5,791,355 9,883,923 2,860,383 16,795,551 1,892,140 1,892,140 ‐ 0.0%
Total Operating Expenditures 117,157,942 64,338,959 119,215,504 67,206,203 109,350,963 51,718,532 49,694,920 2,023,612 3.9%
Total Ending Fund Balance 19,962,845$ 19,689,395$ 26,563,785$ 24,509,761$ 19,790,962$ 32,957,196$ 39,598,838$ 6,641,642$ 20.2%
*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 July 2017
Page 1 of 37
Monthly Financial Report July 2017
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through July 31, 2017. Except as noted,
year‐to‐date budgeted revenues and operating expenditures are generally based on the collection/disbursement patterns for
the same period of the preceding two years. The table on the previous page summarizes the general governmental fund
revenues and expenditures.
Revenues
Taxes
The combined collection of property, sales/use, utility, gambling, admissions, and real estate excise taxes represents 76% of
all resources supporting general governmental activities. The following section provides detail information on property,
sales, utility, and other taxes.
Property Tax
July’s collection is $70K, making
the total year‐to‐date collection
$12.9M or 53.4% of the total
budget. In comparison to the
previous year, the City collected
$6.7M or 34% less. Compared to
the budget, the City collected
$117K or 1% more. The large
variance with the prior year is
due to the formation of the
Renton Regional Fire Authority.
Sales Tax
July 2017 sales tax receipts
totaled $2.2M. Compared with
the same month last year, it is
$133K or 6% more. Compared to
the projected current month’s
budget, it is $219K or 11% above.
The year‐to‐date collection of
$15.1M is $489K or 3% more than
the prior year and is also $670K
or 5% more than budgeted.
Auto, Retail, Wholesale, 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
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,591,281$ 12,760,104$ 12,876,968$ (6,714,313)$ ‐34% 116,864$ 1%
Annual Total 37,038,480$ 24,103,395$
Property Tax Revenues
Year to Date through July
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 2,075,555 (51,851) ‐2% 107,977 5%
Jul 2,103,896 2,017,854 2,236,477 132,581 6% 218,623 11%
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 14,588,197$ 14,406,989$ 15,077,171$ 488,975$ 3% 670,183$ 5%
Annual Total 26,353,246$ 25,700,400$
2017 vs. Budget2017 vs. 2016
Month
Year to Date through July
Local Retail Sales Tax Revenues
Page 2 of 37
Monthly Financial Report July 2017
The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business
sectors:
Utility tax
July utility tax revenues are
$1.5M, which is $262K or 21%
higher than the same month last
year and is also higher than the
budget by $304K or 25%. The
year‐to‐date collection is
$10.4M, which is $766K or 8%
higher than the prior year and is
also $1.2M or 13% 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 2,351,822$ 2,354,134$ 2,413,711$ 61,889$ 3% $ 59,577 3%
Auto Sales 2,791,024 2,663,742 2,777,927 (13,097) 0% 114,185 4%
General Retail 4,182,666 4,151,156 4,384,543 201,877 5% 233,386 6%
Manufacturing 1,023,797 903,315 889,563 (134,234) ‐13% (13,752)‐2%
Wholesale 706,355 773,464 844,538 138,183 20% 71,074 9%
Service 3,192,103 3,200,434 3,311,024 118,921 4% 110,591 3%
Other 340,431 360,743 455,866 115,434 34% 95,123 26%
YTD Total 14,588,197$ 14,406,989$ 15,077,171$ 488,975$ 3%670,183$ 5%
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 1,351,607 225,762 20% 173,800 15%
Jul 1,276,335 1,234,377 1,538,390 262,054 21% 304,012 25%
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 9,642,866$ 9,183,733$ 10,408,741$ 765,875$ 8% 1,225,008$ 13%
Annual Total 16,007,999$ 15,478,137$
2017 vs. Budget2017 vs. 2016
Year to Date through July
Utility Tax Revenues
Month
Utility Tax by Type 2016 2017 Bgt YTD Act Change 2017/2016 2017 Act vs Bgt
Electrical 3,286,831$ 3,155,209$ 3,464,919$ 178,088$ 5% $ 309,710 10%
Natural Gas 1,064,193 1,107,597 1,294,127 229,933 22% 186,530 17%
Cell 947,235 904,415 940,094 (7,142) ‐1% 35,679 4%
Phone 511,087 426,379 564,873 53,787 11% 138,495 32%
Cable 914,541 932,734 940,824 26,282 3% 8,090 1%
Garbage/Solid Waste 399,216 374,110 356,201 (43,015) ‐11% (17,908)‐5%
City Utilities 2,408,536 2,283,290 2,847,704 439,168 18% 564,414 25%
Utility Tax Audit 111,227 ‐ ‐ (111,227) 0% ‐ N/A
YTD Total 9,642,866$ 9,183,733$ 10,408,741$ 765,875$ 8%1,225,008$ 13%
Annual Total 16,007,999$ 15,478,137$
YTD as % of 60% 59%
Page 3 of 37
Monthly Financial Report July 2017
Other Taxes
Real Estate Excise Tax
The City collected $591K in Real
Estate Excise Tax revenues (REET)
for July. This is $53K or 8% less
than the same month last year
and is also $93K or 19% more
than the current month’s budget.
The year‐to‐date collection is
$4.2M, which is $714k or 21%
more than the prior year and is
also $1.6M or 63% above the
budget. The higher than
expected variance is due to 19
large transactions in December,
January, February, March, April,
May, and June which accounts
for $1.4M of the total REET
collected.
Gambling Tax
July’s Gambling Tax collections
totaled $230K, which is $36k or
19% above the same month last
year and is also above the current
month’s budget by $68K or 42%.
The year‐to‐date total of $1.5M is
$165K or 12% above the prior
year and is also $434K or 39%
above budget.
Franchise Fees
Franchise Fees are due quarterly
in January, April, July, and
October. The year‐to‐date total
of $1.1M is $90K or 9% higher
than the prior year and is also
$144K or 15% 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 747,549 342,371 84% 401,030 116%
Jul 644,038 497,925 591,137 (52,901) ‐8% 93,212 19%
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 3,470,703$ 2,566,642$ 4,184,639$ 713,936$ 21% 1,617,996$ 63%
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 July
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 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 ‐
Sep 202,409 159,756 ‐
Oct 242,254 190,582 ‐
Nov 183,345 165,084 ‐
Dec 181,924 155,817 ‐
YTD Total 1,367,844$ 1,099,744$ 1,533,322$ 165,478$ 12% 433,578$ 39%
Annual Total 2,500,604$ 2,000,000$
Gambling Tax Revenue
Month
Year to Date through July
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%
Sep 5,000 2,414 ‐
Oct 348,783 332,455 ‐
Dec 4,850 2,341 ‐
YTD Total 1,047,459$ 992,790$ 1,137,272$ 89,813$ 9% 144,482$ 15%
Annual Total 1,406,092$ 1,330,000$
Month
2017 vs. 2016 2017 vs. Budget
Franchise Fees Revenue
Year to Date through July
Page 4 of 37
Monthly Financial Report July 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 $175K is $26K
or 13% less than the prior year
and is also $69K or 28% 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 $7.3M. The
monthly budgets are based on
large business quarterly
reporting with smaller business
annual reporting.
Licenses and Permits
Business Licenses
Business Licenses totaled $218K
for July, which is $31K or 12%
below the same month last year
and is also $11K or 5% below the
current month’s budget. The
year‐to‐date Business Licenses
revenue of $978K is $482K or
33% below the prior year but is
above the budget by $41K 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%
Jun ‐ ‐ 785 785 100% 785 100%
Jul 60,763 80,276 51,061 (9,701) ‐16% (29,214) ‐36%
Sep 518 289 ‐
Oct 58,934 74,983 ‐
Nov 1,452 831 ‐
YTD Total 201,603$ 243,897$ 175,220$ (26,383)$ ‐13% (68,617)$ ‐28%
Annual Total 262,506$ 320,000$
2017 vs. Budget
Admission Tax Revenue
Year to Date through July
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 23,491 (7,100) ‐23% (146,509) ‐86%
Jul 376,209 1,360,000 1,139,041 762,832 203% (220,959) ‐16%
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 5,289,180$ 4,760,000$ 7,345,843$ 2,056,663$ 39% 2,585,843$ 54%
Annual Total 6,375,322$ 6,800,000$
*Total Business & Occupation Taxes (GF & CIP)
Business & Occupation Taxes*
Year to Date through July
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 ‐
Sep 22,190 13,573 ‐
Oct 218,271 222,326 ‐
Nov 91,870 56,325 ‐
Dec 12,555 7,925 ‐
YTD Total 1,460,529$ 936,626$ 978,068$ (482,462)$ ‐33% 41,442$ 4%
Annual Total 1,926,510$ 1,302,453$
*Total Business License (GF & CIP)
2017 vs. 2016
Year to Date through July
2017 vs. Budget
Business Licenses*
Month
Page 5 of 37
Monthly Financial Report July 2017
Building Permits and
Development Service Fees
Building Permits and
Development Service Fee
revenues totaled $265K in July.
The year‐to‐date revenues of
$2.9M is $390K or 12% less than
the year before and is also $606K
or 17% 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). 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 92% of
the total revenues in
this category. The year‐
to‐date total
Intergovernmental revenue is $4M or 52% of the budget.
State Shared
Revenues
State Shared
Revenue collections
totaled $3.5M since
the start of the year.
Compared to the
prior year, State
Shared Revenues are
above by $80K or 2%.
Compared to the
projected budget,
the City is collecting
$237K or 7% more.
The higher than
expected collection is
due to collecting more than anticipated Criminal Justice’s Sales Tax, Criminal Justice’s High Crime, 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
Sep 380,480 498,572
Oct 479,048 478,350
Nov 297,449 359,940
Dec 468,303 472,668
YTD Total 3,270,705$ 3,487,109$ 2,880,611$ (390,093)$ ‐12% (606,497)$ ‐17%
Annual Total 5,293,563$ 5,735,368$
Year to Date through July
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,655,300 170,969 170,969 (2,484,330) ‐94%‐ 0%
State Shared Revenue 3,433,059 3,275,988 3,513,017 79,958 2% 237,029 7%
Federal Grants 241,372 73,397 73,397 (167,975) ‐70%‐ 0%
State Grants 39,421 29,932 29,932 (9,489) ‐24%‐ 0%
Other Grants/Intgovt 641,657 222,110 214,629 (427,028) ‐67% (7,481) ‐3%
ARRA Grants ‐ ‐ ‐ ‐ N/A ‐ N/A
Total Rev YTD 7,708,932$ 3,772,397$ 4,001,945$ (3,706,987)$ ‐48%229,548$ 6%
Total Rev Annual 10,698,115$ 7,661,089$
YTD % 72% 49% 52%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
2016 2017 2017
Actual Budget Actual $ % $ %
Crim Just Sales Tax 1,514,910$ 1,493,432$ 1,563,288$ 48,378$ 3% 69,856$ 5%
Judicial Contribution 12,200 ‐ 5,570 (6,630) ‐54% 5,570 100%
Crim Just ‐ High Crime 226,089 156,101 204,154 (21,934) ‐10% 48,053 31%
Crim Just ‐ Pop 20,178 18,127 21,331 1,153 6% 3,203 18%
Crim Just ‐ Spec Prog 73,638 67,283 77,480 3,843 5% 10,197 15%
State DUI 11,527 12,835 11,541 14 0% (1,294) ‐10%
Marijuana Enforcement 5,854 ‐ 23,772 17,918 306% 23,772 100%
Liquor Profits 424,476 425,210 427,768 3,292 1% 2,558 1%
Liquor Excise Tax 338,846 303,675 356,200 17,354 5% 52,525 17%
Fuel Tax 805,341 799,324 821,912 16,571 2% 22,588 3%
YTD Total 3,433,059$ 3,275,988$ 3,513,017$ 79,958$ 2% 237,029$ 7%
Annual Total 5,933,890$ 5,805,528$
State Shared Revenues
2017 vs. 2016
Revenue
Year to Date through July
2017 vs. Budget
Page 6 of 37
Monthly Financial Report July 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 $5.1M or 58% of the budget. The
following sections provide detail information for Public Safety, Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totaled
$510K 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 $65K or 11%
less. Compared to the year‐to‐
date budget, the City is over
budget by $133K or 35%. 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
$482K for the current month.
Compared to the same month
the prior year, the City collected
$157K or 48% more. Compared
to the projected monthly budget,
the City collected $73K or 18%
more. The year‐to‐date
collection of $1.1M is $29K or 3%
higher than the year before but is
$46K 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 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 ‐
Sep 67,570 33,790 ‐
Oct 160,438 72,212 ‐
Nov 67,763 42,537 ‐
Dec 78,473 48,375 ‐
YTD Total 575,496$ 377,603$ 510,274$ (65,222)$ ‐11% 132,671$ 35%
Annual Total 994,179$ 613,081$
2017 vs. Budget
Month
2017 vs. 2016
Year to Date through July
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 ‐
Sep 107,652 123,607 ‐
Oct 45,706 55,007 ‐
Nov 68,324 70,632 ‐
Dec 39,475 44,472 ‐
YTD Total 1,022,095$ 1,096,859$ 1,051,172$ 29,076$ 3% (45,687)$ ‐4%
Annual Total 1,632,903$ 1,750,923$
2017 vs. Budget2017 vs. 2016
Month
Recreation
Year to Date through July
Page 7 of 37
Monthly Financial Report July 2017
Interfund Services
The year‐to‐date collections for
Interfund Services revenues are
$2.3M. Compared to the prior
year, the revenues are over by
$396K or 20%. Compared to the
projected budget, the revenues
are below by $108K or 4%.
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
$1.6M. This is $20K or 1% higher
than a year ago and $29K 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 ‐
Sep 286,057 348,248 ‐
Oct 277,517 348,248 ‐
Nov 295,584 348,248 ‐
Dec 311,019 348,248 ‐
YTD Total 1,933,634$ 2,437,736$ 2,329,831$ 396,197$ 20% (107,904)$ ‐4%
Annual Total 3,377,663$ 4,178,976$
2017 vs. Budget
Month
Interfund Services
Year to Date through July
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
Sep 200,986 232,621
Oct 238,517 243,770
Nov 273,338 270,941
Dec 306,114 310,486
YTD Total 1,566,744$ 1,558,308$ 1,586,818$ 20,074$ 1% 28,510$ 2%
Annual Total 2,860,662$ 2,868,450$
Month
2017 vs. Budget2017 vs. 2016
Year to Date through July
Fines and Penalties by Month
Year to Date through July
2016 2017 2017
Actual Budget Actual $ % $ %
Civil Penalties 1,132$ 2,577$ 1,218$ 85$ 8% (1,359)$ ‐53%
Civil Infraction Penalties 182,927 175,833 173,426 (9,501) ‐5% (2,408) ‐1%
Civil Parking Infraction Penalties 85,884 118,951 90,058 4,174 5% (28,893) ‐24%
Photo Enforcement Program 1,132,954 1,130,577 1,167,915 34,961 3% 37,338 3%
Criminal Traffic Misdemeanor Fines 43,554 37,670 41,351 (2,203) ‐5% 3,681 10%
Criminal Non‐Traffic Fines 19,474 35,669 44,150 24,677 127% 8,482 24%
Criminal Costs 52,785 49,359 44,738 (8,047) ‐15% (4,621) ‐9%
Non ‐Court Fines, Forfeitures and Penalties 48,033 7,671 23,961 (24,071) ‐50% 16,290 212%
YTD Total 1,566,744$ 1,558,308$ 1,586,818$ 20,074$ 1% 28,510$ 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 July 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.2M.
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 $1.4M.
Compared to last year, the
revenues are below by $447K or
25%. Compared to the projected
year‐to‐date budget, the
revenues are over by $379K or
38%. 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 ‐ 89,775 ‐ ‐
Sep 164,770 ‐ 89,775 ‐ ‐
Oct 175,856 ‐ 89,775 ‐ ‐
Nov 185,108 ‐ 89,775 ‐ ‐
Dec 204,263 ‐ 89,775 ‐ ‐
YTD Total 1,130,577$ 1,167,915$ 628,423$ 598,572$ 569,343$
Annual Total 2,044,000$ 1,077,297$
1Actuals of Revenues and Expenses
Photo Enforcement Program
Year to Date through July
Month
Revenues Expenses
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 258,876$ 210,805$ 363,997$ 105,122$ 41% 153,192$ 73%
Feb 802,908 115,946 148,988 (653,920) ‐81% 33,043 28%
Mar 125,950 125,932 150,954 25,004 20% 25,022 20%
Apr 142,439 108,346 188,887 46,448 33% 80,540 74%
May 139,504 116,600 152,678 13,174 9% 36,078 31%
Jun 174,848 159,284 179,152 4,304 2% 19,867 12%
Jul 181,285 162,595 193,718 12,433 7% 31,122 19%
Aug 294,665 160,588
Sep 160,616 121,159
Oct 152,817 128,451
Nov 327,568 104,753
Dec 425,765 370,158
YTD Total 1,825,810$ 999,509$ 1,378,374$ (447,436)$ ‐25% 378,865$ 38%
Annual Total 3,187,241$ 1,884,617$
Year to Date through July
Month
2017 vs. Budget2017 vs. 2016
Miscellaneous Revenues by Month
2016 2017 2017
Actual Budget Actual $ % $ %
Interests and Other Earnings 413,380$ 350,874$ 488,225$ 74,844$ 18% 137,351$ 39%
Rents, Leases, and Concessions 416,116 413,625 419,315 3,199 1% 5,690 1%
Contributions/Donations from Private Sources 66,173 78,211 98,558 32,385 49% 20,348 26%
Other 266,997 156,799 212,302 (54,695) ‐20% 55,503 35%
Seizure Funds ‐ Federal/State/Local 663,143 ‐ 159,974 (503,169) ‐76% 159,974 100%
YTD Total 1,825,810$ 999,509$ 1,378,374$ (447,436)$ ‐25% 378,865$ 38%
Annual Total 3,187,241$ 1,884,617$
2017 vs. Budget
Miscellaneous Revenues by Type
Year to Date through July
Revenue
2017 vs. 2016
Page 9 of 37
Monthly Financial Report July 2017
EXPENSES
Overall the City has expended 45% of its budgeted general governmental expenditures at the end of July. This is $2M or 3.9%
below year‐to‐date budgeted expenditures. See below for summary of unfavorable items for general governmental
departments.
Public Works department (Admin, Street Maintenance, and Transportation) is over the year‐to‐date budget by $56K or
0.9%. This is mainly due to overspending on supplies ($46K), professional services ($201K), and interfund payments to
other Maintenance sections ($39K) and underspending on salaries/benefits ($234K).
Page 10 of 37
Monthly Financial Report July 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 ‐ ‐ ‐ ‐ 54,490 26,100 ‐
Grants / intergovernmental 13,312 ‐ 134,063 ‐ 1,232,421 1,070,980 ‐
Charges for services 83,078 1,097,816 9,389,506 9,005,661 5,985,120 6,785,126 9,681,455
Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐
Fines and penalties 1,035 ‐ ‐ ‐ 970 ‐ ‐
Rents, leases, and misc fees 1,528,850 233,782 11,857 118,253 ‐ ‐ ‐
Interest and other misc 13,161 652 40,549 522,539 1,155,861 396,158 21,684
TOTAL REVENUES 1,639,436 1,332,250 9,575,975 9,646,453 8,428,862 8,278,364 9,703,139
EXPENSES:
Utility billing ‐ ‐ 26,621 97,391 77,296 120,385 ‐
Utility systems ‐ ‐ 10,105,565 2,111,702 2,003,987 2,475,612 ‐
Utility maintenance ‐ ‐ 191,269 3,263,294 1,236,361 1,612,166 9,808,587
Transportation 923,825 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 1,285,583 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 923,825 1,285,583 10,323,455 5,472,387 3,317,644 4,208,163 9,808,587
AMOUNT AVAILABLE FOR DEBT SERVICE 715,611 46,667 (747,480) 4,174,066 5,111,218 4,070,201 (105,448)
DEBT SERVICE:
Principal ‐ ‐ ‐ 395,175 ‐ ‐ ‐
Interest ‐ ‐ ‐ 207,051 93,469 393,441 ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ 602,226 93,469 393,441 ‐
CAPITAL PROJECTS 139,917 66,995 ‐ 1,548,375 2,016,909 1,159,369 ‐
TRANSFERS IN/(OUT)‐ ‐ (370) (433) (1,205) (370) ‐
CHANGE IN FUND BALANCE 575,694 (20,328) (747,850) 2,023,032 2,999,635 2,517,021 (105,448)
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, Jul 31 3,195,037 16,760 2,003,567 30,551,966 16,859,297 13,410,996 4,889,210
Page 11 of 37
Monthly Financial Report July 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 Communicatio
ns Insurance Healthcare Retiree
Healthcare
REVENUES:
Technology Fee ‐ 112,226 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ 7,110 ‐ ‐ ‐ ‐ 47,440
Charges for services
Equipment rental m&o 1,583,237 2,479,410 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ ‐ ‐ 256,270 ‐ ‐ ‐
Communications ‐ 463,460 ‐ 372,118 ‐ ‐ ‐
Facilities ‐ ‐ 2,930,094 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ ‐ ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest and other misc 27,360 11,549 6,323 2,339 52,164 18,267 43,103
Internal service fund misc:
Vehicle / equipment capital recovery 1,291,500 282,316 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 1,001,181 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 774,491 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 5,377,103 1,531,064
Other misc 239 47 10,047 20 ‐ 535,238 ‐
Interfund Loan ‐ ‐ ‐ ‐ ‐ ‐ ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets 52,322 ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 104,520 ‐ ‐
TOTAL REVENUES 2,954,658 3,356,118 2,946,464 630,747 1,932,356 5,930,608 1,621,607
EXPENSES:
Communications 344,839
Equipment rental 1,336,160
Facilities 2,535,871
Healthcare 5,400,076
Information technology 2,404,268
Print and mail 237,534
Retiree healthcare 491,441
Risk management:
Risk management 944,969
Unemployment 29,994
Worker's compensation 876,139
TOTAL EXPENSES 1,336,160 2,404,268 2,535,871 582,373 1,851,102 5,400,076 491,441
AMOUNT AVAILABLE FOR CAPITAL 1,618,498 951,850 410,593 48,374 81,254 530,532 1,130,166
CAPITAL PROJECTS 1,660,604 267,070 30,077 ‐ ‐ ‐ ‐
TRANSFERS IN ‐ 2,484 ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ (89,876) ‐
CHANGE IN FUND BALANCE (42,106) 687,264 380,516 48,374 81,254 440,656 1,130,166
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, Jul 31 6,389,947 3,257,638 1,655,569 591,301 12,933,763 4,596,804 11,209,417
Page 12 of 37
Monthly Financial Report July 2017
FUND BALANCE
Page 14 shows the ending fund balance as of July 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 July, the City has $39.6M reported in the combined general governmental fund balance of the current year’s
operating budget, which is approximately 36% of budgeted operating expenditures. This is an increase of $13M from the
year’s beginning balance. July’s ending fund balance is over the anticipated General Governmental Fund Balance of $33M by
$6.6M or 20.2%. 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 July 2017
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through July 31, 2017
Funds
Balance
01/01/2017
Budgeted
Revenue
Revenue
07/31/17
Total Funds
Available
Budgeted
Expenditure
Expenditure
07/31/17 Ending Balance
GENERAL GOVERNMENT FUNDS: 26,563,785 102,578,140 62,729,973 89,293,758 109,350,964 49,694,920 39,598,838
000 General 18,201,028 69,687,089 45,089,298 63,290,326 76,768,027 35,247,046 28,043,280
001 Community Services 3,769,766 13,615,254 7,767,848 11,537,614 13,788,263 6,786,543 4,751,072
003 Street 1,936,367 11,885,024 6,748,858 8,685,225 11,306,335 6,273,663 2,411,562
004 Community Dev Block Grant 66,654 1,068,770 413 67,067 1,076,270 89,906 (22,839)
005 Museum 72,372 233,936 117,196 189,568 236,275 135,354 54,214
009 Farmers Market 90,730 112,742 50,695 141,425 109,165 51,246 90,179
011 Fire Health & Wellness ‐ ‐ ‐ ‐ ‐ ‐ ‐
201 Ltd GO Bonds Gen Govt Debt 852,111 1,749,675 879,633 1,731,744 1,749,675 41,925 1,689,819
215 Gen Govt Misc Debt Service 1,574,757 4,225,650 2,076,032 3,650,789 4,316,954 1,069,238 2,581,551
SPECIAL REVENUE FUNDS:1,599,965 1,974,729 1,360,852 2,960,817 2,164,749 581,622 2,379,195
102 Arterial Street 63,480 660,000 387,719 451,199 660,000 ‐ 451,199
108 Leased City Properties 276,865 902,550 695,282 972,147 888,131 383,446 588,701
110 Hotel Motel 402,602 265,000 167,455 570,057 375,994 163,554 406,503
125 1% For Art 128,489 24,505 523 129,012 117,950 ‐ 129,012
127 Cable Communication 394,504 122,674 108,514 503,018 122,674 34,622 468,396
135 Springbrook Wetlands Bank 334,025 ‐ 1,359 335,384 ‐ ‐ 335,384
CAPITAL PROJECT FUNDS (CIP):26,202,403 35,746,139 14,087,702 40,290,105 50,816,731 7,609,934 32,680,171
303 Community Dev Mitigation 1,255,194 406,014 199,132 1,454,326 ‐ ‐ 1,454,326
304 Fire Mitigation 607,163 99,000 374,458 981,621 158,696 ‐ 981,621
305 Transportation Mitigation 1,497,748 620,000 553,993 2,051,741 1,890,000 ‐ 2,051,741
316 Municipal Facilities CIP 15,038,030 13,701,632 7,374,622 22,412,652 23,198,133 1,507,272 20,905,380
317 Transportation CIP 5,640,494 19,419,493 5,577,461 11,217,955 24,544,675 5,805,648 5,412,307
326 Housing Opportunity 1,041,173 1,500,000 4,237 1,045,410 ‐ ‐ 1,045,410
336 New Library Development 1,122,601 ‐ 3,799 1,126,400 1,025,227 297,014 829,386
ENTERPRISE FUNDS:63,685,077 89,995,648 48,650,623 112,335,700 120,539,512 41,408,866 70,926,834
4X2 Airport Operating & CIP 2,619,343 3,405,842 1,639,435 4,258,778 5,688,023 1,063,741 3,195,037
403 Solid Waste Utility 2,751,417 19,187,851 9,575,975 12,327,392 19,024,775 10,323,825 2,003,567
4X4 Golf Operating & CIP 37,088 2,893,044 1,367,250 1,404,338 2,630,288 1,387,578 16,760
4X5 Water Operating & CIP 28,528,934 17,180,526 9,646,453 38,175,387 35,347,154 7,623,421 30,551,966
4X6 Waste Water Operating & CIP 13,859,662 13,264,936 8,440,007 22,299,669 20,537,816 5,440,372 16,859,297
416 King County Metro 4,994,658 17,505,693 9,703,139 14,697,797 17,505,693 9,808,587 4,889,210
4X7 Surface Water Operating & CIP 10,893,975 16,557,756 8,278,364 19,172,339 19,805,763 5,761,342 13,410,997
INTERNAL SERVICE FUNDS:37,908,315 34,806,873 19,375,043 57,283,358 33,548,887 16,648,919 40,634,439
501 Equipment Repair/Replacement 6,432,053 6,494,353 2,954,658 9,386,711 7,728,113 2,996,765 6,389,946
502 Insurance 12,852,509 7,392,368 1,932,357 14,784,866 3,571,166 1,851,102 12,933,764
503 Information Services 2,570,374 5,731,776 3,358,602 5,928,976 6,835,636 2,671,338 3,257,638
504 Facilities 1,275,053 5,067,015 2,946,464 4,221,517 5,134,433 2,565,948 1,655,569
505 Communications 542,927 1,078,253 630,747 1,173,674 1,076,474 582,373 591,301
512 Insurance, Healthcare 4,156,148 7,787,779 5,930,608 10,086,756 8,163,471 5,489,952 4,596,804
522 Insurance, Leoff1 Retirees HC 10,079,251 1,255,329 1,621,607 11,700,858 1,039,594 491,441 11,209,417
FIDUCIARY FUNDS:5,578,045 468,000 165,966 5,744,011 210,475 129,484 5,614,527
611 Firemen's Pension 5,578,045 468,000 165,966 5,744,011 210,475 129,484 5,614,527
TOTAL FUNDS 161,537,590 265,569,529 146,370,159 307,907,749 316,631,318 116,073,745 191,834,004
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
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,150,230 7,364,146 2.99%
Feb 13,649,659 14,472,917 6.03%
Mar 20,102,489 21,057,303 4.75%
Apr 32,964,280 39,230,543 19.01%
May 44,307,275 47,996,932 8.33%
Jun 50,529,531 54,429,132 7.72%
Jul 58,111,943 62,729,973 7.95%
Aug 64,897,824
Sep 71,259,286
Oct 82,659,005
Nov 95,500,221
Dec 102,578,140
Percent of budget 61.15%
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
Sep 13,238,047
Oct 17,341,593
Nov 23,988,632
Dec 24,103,395
Percent of budget 53.42%
$‐
$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 14,362,484 3.76%
Jul 16,104,724 16,864,294 4.72%
Aug 18,663,293
Sep 21,097,526
Oct 23,629,240
Nov 26,285,407
Dec 28,763,680
Percent of budget 58.63%
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 8,870,352 11.59%
Jul 9,183,733 10,408,741 13.34%
Aug 10,453,523
Sep 11,680,525
Oct 12,932,675
Nov 14,139,633
Dec 15,478,137
Percent of budget 67.25%
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 2,301,827 1.66%
Jul 2,972,183 2,656,217 ‐10.63%
Aug 3,368,015
Sep 3,791,878
Oct 4,274,238
Nov 4,532,625
Dec 4,815,012
Percent of budget 55.17%
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,575,031
Sep 5,217,458
Oct 5,742,114
Nov 6,530,528
Dec 7,661,089
Percent of budget 52.24%
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
Sep 6,705,746
Oct 7,327,762
Nov 7,947,988
Dec 8,677,538
Percent of budget 58.23%
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
Sep 2,043,253
Oct 2,287,023
Nov 2,557,964
Dec 2,868,450
Percent of budget 55.32%
$‐
$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 6,043,234 50.40%
Jul 5,456,111 7,806,041 43.07%
Aug 5,805,828
Sep 6,075,201
Oct 7,571,990
Nov 7,846,056
Dec 8,155,026
Percent of budget 95.72%
Misc Budget
YTD
Actual
Annual %
over (under)
Jan 210,805 363,997 72.67%
Feb 326,751 512,986 57.00%
Mar 452,682 663,940 46.67%
Apr 561,029 852,826 52.01%
May 677,629 1,005,505 48.39%
Jun 836,913 1,184,657 41.55%
Jul 999,509 1,378,374 37.91%
Aug 1,160,096
Sep 1,281,255
Oct 1,409,706
Nov 1,514,459
Dec 1,884,617
Percent of budget 73.14%
$‐
$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 114,131
Sep 128,397
Oct 142,663
Nov 156,930
Dec 171,196
Percent of budget 57.08%
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 3,593,502 73.71%
Jul 2,566,642 4,184,639 63.04%
Aug 3,050,997
Sep 3,452,940
Oct 3,887,811
Nov 4,154,162
Dec 4,420,000
Percent of budget 94.68%
$‐
$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 2,616,096 ‐6.41%
Jul 3,487,109 2,880,611 ‐17.39%
Aug 3,925,839
Sep 4,424,411
Oct 4,902,760
Nov 5,262,700
Dec 5,735,368
Percent of budget 50.23%
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 6,206,803 82.55%
Jul 4,760,000 7,345,843 54.32%
Aug 4,930,000
Sep 5,100,000
Oct 6,460,000
Nov 6,630,000
Dec 6,800,000
Percent of budget 108.03%
$‐
$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
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,934,806 6,595,136 ‐4.90%
Feb 13,894,584 13,388,134 ‐3.64%
Mar 21,412,691 20,198,065 ‐5.67%
Apr 28,362,799 27,006,711 ‐4.78%
May 35,721,015 34,253,900 ‐4.11%
Jun 43,530,101 41,552,555 ‐4.54%
Jul 51,718,532 49,694,920 ‐3.91%
Aug 71,415,418
Sep 80,715,944
Oct 90,074,524
Nov 98,821,901
Dec 109,350,963
Percent of budget expended 45.45%
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
Sep 278,319
Oct 308,035
Nov 337,502
Dec 368,211
Percent of budget expended 58.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 963,928 ‐1.67%
Jul 1,122,714 1,110,100 ‐1.12%
Aug 1,283,513
Sep 1,468,126
Oct 1,611,032
Nov 1,754,366
Dec 1,957,671
Percent of budget expended 56.71%
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
Sep 448,780
Oct 492,637
Nov 535,475
Dec 609,249
Percent of budget expended 51.66%
$‐
$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 1,038,696 ‐5.25%
Jul 1,281,325 1,211,095 ‐5.48%
Aug 1,466,602
Sep 1,658,357
Oct 1,826,387
Nov 1,995,101
Dec 2,163,329
Percent of budget expended 55.98%
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 1,072,725 ‐2.01%
Jul 1,278,228 1,252,041 ‐2.05%
Aug 1,465,440
Sep 1,656,123
Oct 1,839,864
Nov 2,023,061
Dec 2,220,656
Percent of budget expended 56.38%
$‐
$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 669,673 4.65%
Jul 803,016 781,490 ‐2.68%
Aug 909,108
Sep 1,015,431
Oct 1,121,287
Nov 1,226,753
Dec 1,337,991
Percent of budget expended 58.41%
Development
Services Budget
YTD
Actual
Annual %
over (under)
Jan 256,438 239,337 ‐6.67%
Feb 543,416 501,405 ‐7.73%
Mar 824,478 754,102 ‐8.54%
Apr 1,091,128 1,024,029 ‐6.15%
May 1,371,240 1,282,903 ‐6.44%
Jun 1,655,763 1,542,242 ‐6.86%
Jul 1,935,388 1,806,056 ‐6.68%
Aug 2,228,046
Sep 2,530,168
Oct 2,814,598
Nov 3,096,537
Dec 3,404,464
Percent of budget expended 53.05%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
Millions
Community & Economic
Development Admin
Budget
Actual
Last Year
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions
Development Services
Budget
Actual
Last Year
Page 26 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
Economic
Development Budget
YTD
Actual
Annual %
over (under)
Jan 103,746 46,869 ‐54.82%
Feb 256,504 98,329 ‐61.67%
Mar 375,792 140,672 ‐62.57%
Apr 573,516 190,278 ‐66.82%
May 710,921 342,370 ‐51.84%
Jun 875,698 435,487 ‐50.27%
Jul 1,042,462 490,157 ‐52.98%
Aug 1,172,670
Sep 1,294,219
Oct 1,517,766
Nov 1,687,862
Dec 1,847,888
Percent of budget expended 26.53%
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
Sep 2,429,086
Oct 2,705,736
Nov 2,959,083
Dec 3,222,077
Percent of budget expended 48.74%
$‐
$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 1,301,674 ‐7.38%
Jul 1,620,542 1,565,684 ‐3.39%
Aug 1,988,845
Sep 2,222,013
Oct 2,454,488
Nov 2,672,475
Dec 3,362,369
Percent of budget expended 46.56%
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
Sep 832,467
Oct 948,567
Nov 1,045,159
Dec 1,239,455
Percent of budget expended 54.87%
Includes Hearing Examiner
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
Millions City Clerk
Budget
Actual
Last Year
$‐
$0.40
$0.80
$1.20
$1.60
$2.00
$2.40
$2.80
$3.20
$3.60
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
Sep 989,949
Oct 1,112,832
Nov 1,220,753
Dec 1,359,317
Percent of budget expended 51.43%
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,628,538 17,182,081 ‐2.53%
Jul 20,813,284 20,754,850 ‐0.28%
Aug 23,629,666
Sep 26,807,915
Oct 29,657,572
Nov 32,675,468
Dec 36,130,337
Percent of budget expended 57.44%
$‐
$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 254,219 4.21%
Jul 283,798 294,560 3.79%
Aug 323,291
Sep 362,917
Oct 402,012
Nov 441,115
Dec 505,154
Percent of budget expended 58.31%
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
Sep 3,882,283
Oct 4,333,779
Nov 4,732,770
Dec 5,179,955
Percent of budget expended 49.58%
$‐
$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,837 53,458 ‐20.02%
Feb 142,043 140,186 ‐1.31%
Mar 228,381 204,477 ‐10.47%
Apr 302,923 289,729 ‐4.36%
May 421,513 369,879 ‐12.25%
Jun 529,092 461,775 ‐12.72%
Jul 634,663 554,297 ‐12.66%
Aug 755,297
Sep 880,231
Oct 1,004,912
Nov 1,117,820
Dec 1,271,569
Percent of budget expended 43.59%
Recreation Budget
YTD
Actual
Annual %
over (under)
Jan 374,992 347,558 ‐7.32%
Feb 776,210 729,951 ‐5.96%
Mar 1,193,255 1,120,569 ‐6.09%
Apr 1,619,630 1,523,454 ‐5.94%
May 2,041,706 1,886,814 ‐7.59%
Jun 2,504,626 2,298,110 ‐8.25%
Jul 3,176,750 2,894,508 ‐8.88%
Aug 3,870,674
Sep 4,434,425
Oct 4,852,298
Nov 5,270,092
Dec 5,714,855
Percent of budget expended 50.65%
$‐
$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 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 584,702 ‐5.61%
Jul 747,449 754,865 0.99%
Aug 858,779
Sep 937,301
Oct 1,120,435
Nov 1,209,310
Dec 1,419,333
Percent of budget expended 53.18%
Neighborhoods
, Resources,
and Events Budget
YTD
Actual
Annual %
over (under)
Jan 82,975 60,703 ‐26.84%
Feb 185,874 125,601 ‐32.43%
Mar 276,230 198,834 ‐28.02%
Apr 353,352 266,753 ‐24.51%
May 443,151 337,861 ‐23.76%
Jun 533,990 414,589 ‐22.36%
Jul 673,990 526,036 ‐21.95%
Aug 786,830
Sep 890,249
Oct 985,557
Nov 1,071,844
Dec 1,225,894
Percent of budget expended 42.91%
$‐
$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 115,602 ‐0.84%
Jul 136,413 135,354 ‐0.78%
Aug 156,373
Sep 176,366
Oct 196,623
Nov 216,498
Dec 236,275
Percent of budget expended 57.29%
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
Sep 306,358
Oct 339,748
Nov 373,069
Dec 406,398
Percent of budget expended 58.46%
$‐
$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
Sep 4,214,166
Oct 4,682,566
Nov 5,131,438
Dec 5,636,437
Percent of budget expended 58.90%
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
Sep 3,854,060
Oct 4,693,977
Nov 5,071,355
Dec 5,669,897
Percent of budget expended 52.10%
$‐
$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 4,044,419
Sep 4,549,972
Oct 5,055,524
Nov 5,561,077
Dec 6,066,629
Percent of budget expended 18.32%
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 11,197,034
Sep 12,596,663
Oct 13,996,293
Nov 15,395,922
Dec 16,795,551
Percent of budget expended 11.27%
$‐
$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,667 6,899,538 3,629,075
Feb 10,508,877 13,370,807 7,900,322
Mar 16,710,823 19,032,931 12,269,408
Apr 22,821,669 24,791,562 19,152,344
May 29,106,807 31,698,603 24,885,271
Jun 38,399,372 38,440,101 31,089,893
Jul 45,231,872 45,643,871 38,955,538
Aug 57,821,285
Sep 69,401,520
Oct 91,243,653
Nov 98,243,043
Dec 112,221,201
Percent of budget expended 21.57%
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
Sep 3,781,625
Oct 4,374,658
Nov 4,712,186
Dec 5,688,023
Percent of budget expended 18.70%
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 975,459 1,181,928
Jul 1,262,542 1,367,250 1,387,578
Aug 1,469,281
Sep 1,655,432
Oct 1,851,777
Nov 2,026,038
Dec 2,630,288
Percent of budget expended 52.75%
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