HomeMy WebLinkAbout201708, August
h:\finance\financial reporting\monthly reports\2017 reports\cover 0817.docx
ADMINISTRATIVE SERVICES
M E M O R A N D U M
DATE: October 16, 2017
TO: Armondo Pavone, Council President
Members of Renton City Council
CC: Denis Law, Mayor
Jay Covington, Chief Administrative Officer
FROM: Jan Hawn, ASD Administrator
STAFF CONTACT: Hai Nguyen, Sr. Finance Analyst
SUBJECT: August 2017 Financial Status Report
At the end of August, general governmental revenues show $5.2M or 8% over budget.
Revenue source(s) that are higher than expected are: property tax ($108K); sales tax
($818K); utility taxes ($1.1M); franchise fees ($152K); gambling taxes ($422K); business &
occupation taxes ($2.1M); state shared revenues ($250K); public safety ($152K); seizure
funds ($160K), restricted to drug enforcement and not available for general purposes);
interest ($163K); and other miscellaneous ($218K). If we remove B&O taxes and seizure
funds, general governmental revenues are $2.9M 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 ($612K below) and interfund/interdept charges for
services (160K below).
General government expenditures showed a favorable variance of $2.5M or 4.1%. See
page 10 of report for further expenditure over‐spent explanations.
The attached report provides more detailed discussion of each revenue source and our
updated projections for the year. Please do not hesitate to contact me at x6952 should
you have any questions or any suggestions about the report.
Armondo Pavone, Council President
Members of Renton City Council
Page 2 of 2
October 16, 2017
h:\finance\financial reporting\monthly reports\2017 reports\cover 0817.docx
This page is intentionally left blank
General Governmental Funds
$%
Beginning Fund Balance 17,565,282$ 17,565,282$ 19,962,845$ 19,962,845$ 26,563,785$ 26,563,785$ 26,563,785$ ‐ 0.0%
OPERATING REVENUES
Property Tax 36,369,429 19,364,972 37,038,480 19,831,817 24,103,395 12,870,217 12,978,317 108,100 0.8%
Sales Tax 23,439,266 15,143,919 26,353,246 17,026,474 25,700,400 16,681,270 17,498,892 817,622 4.9%
Sales Tax ‐ Annexation Credit 2,778,858 1,795,753 3,114,762 2,017,574 3,063,280 1,982,022 2,075,363 93,341 4.7%
Criminal Justice Sales Tax 2,484,718 1,612,067 2,701,787 1,766,874 2,679,898 1,745,919 1,824,013 78,094 4.5%
Natural Gas Use Tax 228,899 172,628 184,638 140,029 228,000 172,914 124,252 (48,662) ‐28.1%
Admission Tax 309,790 234,588 262,506 201,603 320,000 243,897 176,798 (67,099) ‐27.5%
Franchise Fees 1,349,154 1,009,218 1,406,092 1,047,459 1,330,000 992,790 1,144,972 152,182 15.3%
Electricity Tax 5,012,962 3,286,688 5,440,139 3,681,969 5,396,019 3,597,306 3,879,254 281,948 7.8%
Natural Gas Utility Tax 1,437,552 1,060,598 1,327,937 986,171 1,350,900 999,816 1,239,512 239,696 24.0%
Garbage/Solid Waste 638,073 404,233 717,148 462,068 680,000 434,678 403,111 (31,567) ‐7.3%
TV Cable 1,591,866 1,038,885 1,619,364 1,051,609 1,645,659 1,071,316 1,083,446 12,130 1.1%
Telephone 880,233 636,126 859,868 598,082 714,875 507,042 583,788 76,746 15.1%
Cellular Phone 1,674,355 1,112,742 1,541,204 1,046,848 1,521,056 1,021,550 1,009,511 (12,039) ‐1.2%
City Utilities 4,183,165 2,825,314 4,206,473 2,812,790 3,941,628 2,648,900 3,271,104 622,204 23.5%
Utility Tax Audit 1,962,092 1,446,078 111,227 111,227 ‐ ‐ ‐ ‐ 0.0%
Leasehold Excise Tax 163,314 96,661 173,769 99,207 179,000 104,011 131,503 27,491 26.4%
Gambling Excise Tax 2,299,156 1,498,195 2,500,604 1,690,672 2,000,000 1,328,761 1,750,312 421,551 31.7%
Real Estate Excise Tax 4,595,166 2,884,653 6,121,830 4,230,285 4,420,000 3,050,997 4,857,035 1,806,038 59.2%
Less: CIP REET (1,401,300) (721,163) (2,707,676) (2,115,143) (4,420,000) (3,050,997) (4,857,035) (1,806,038) 59.2%
EMS Levy 936,406 468,203 479,597 479,597 ‐ ‐ ‐ ‐ 0.0%
B&O Taxes ‐ ‐ 6,375,322 5,623,988 6,800,000 4,930,000 7,745,219 2,815,219 57.1%
Less: CIP B&O Taxes ‐ ‐ (2,000,000) (2,000,000) (2,473,974) (1,793,631) (2,473,974) (680,343) 37.9%
Business License Fees 3,125,740 2,323,308 1,926,510 1,581,624 1,302,453 1,002,304 1,102,900 100,597 10.0%
Less: CIP Business License Fees (2,584,164) (1,921,829) (1,587,627) (1,309,525) (617,016) (477,924) (486,201) (8,277) 1.7%
Animal Licenses and Spec Events Permits 101,743 73,230 102,905 70,186 92,575 65,358 105,184 39,826 60.9%
Building Permits & Development Svc Fees 6,077,055 4,108,757 5,293,563 3,668,283 5,735,368 3,925,839 3,313,654 (612,184) ‐15.6%
Intergovt'l (Grants, State Shared, etc) 4,053,617 2,373,692 3,998,953 2,576,559 4,639,252 2,244,578 2,409,107 164,529 7.3%
Fire District 25 and 40 Contracts 6,369,132 3,343,329 3,517,779 3,517,779 341,939 341,939 341,939 ‐ 0.0%
Public Safety 649,797 495,631 994,179 619,935 613,081 416,167 568,388 152,221 36.6%
Culture and Recreation 1,587,878 1,308,748 1,632,903 1,371,745 1,750,923 1,457,205 1,433,468 (23,737) ‐1.6%
Interfund/Interdept‐Services 3,106,430 2,092,497 3,377,663 2,207,485 4,178,976 2,785,984 2,625,752 (160,231) ‐5.8%
Fines and Penalties 848,052 519,223 901,592 554,632 824,450 496,629 492,299 (4,330) ‐0.9%
Photo Enforcement 2,171,184 1,368,096 1,959,071 1,287,076 2,044,000 1,314,004 1,393,203 79,200 6.0%
Seizure Funds ‐ Federal/State/Local 21,676 6,444 987,293 776,237 ‐ ‐ 159,974 159,974 100.0%
Interests and Other Earnings 973,208 462,120 1,058,880 473,805 875,300 403,140 565,841 162,702 40.4%
Rents, Leases, and Concessions 762,361 608,000 642,192 505,330 623,195 493,981 504,182 10,201 2.1%
Contributions and Donations 147,292 93,874 96,582 66,563 130,500 85,852 104,075 18,223 21.2%
Other Miscellaneous 941,127 624,913 956,131 613,025 691,812 447,265 665,357 218,091 48.8%
Other Financing Sources (Transfer ‐In, etc) 270,224 (13,684,197) 2,129,561 6,075 171,196 98,866 98,866 ‐ 0.0%
Total Operating Revenues 119,555,505 73,257,997 125,816,444 79,378,013 102,578,140 64,639,963 69,843,380 5,203,417 8.0%
OPERATING EXPENDITURES
Council 320,877 217,023 358,550 242,571 368,211 249,074 245,568 3,506 1.4%
Executive 1,691,189 1,085,450 1,778,206 1,165,850 1,957,671 1,283,513 1,290,543 (7,030) ‐0.5%
Emergency Management*398,808 247,011 370,832 258,124 609,249 399,866 370,942 28,924 7.2%
City Attorney 1,791,167 1,217,493 1,983,834 1,341,723 2,163,329 1,466,602 1,384,646 81,956 5.6%
Court Services 2,013,364 1,335,130 2,075,763 1,363,339 2,220,656 1,465,440 1,429,897 35,543 2.4%
Community and Eco Dvlpmnt Admin 1,183,052 824,910 1,161,330 767,998 1,337,991 909,108 893,461 15,647 1.7%
Development Services 2,632,264 1,743,441 2,859,410 1,850,577 3,404,464 2,228,046 2,066,905 161,141 7.2%
Economic Development 658,515 435,115 1,004,411 620,177 1,847,888 1,172,670 580,426 592,243 50.5%
Planning 2,606,551 1,737,966 2,716,214 1,797,371 3,222,077 2,140,077 1,787,262 352,815 16.5%
Finance 3,132,812 1,830,087 3,046,824 1,825,174 3,362,369 1,988,845 1,817,314 171,531 8.6%
City Clerk 1,027,084 552,466 914,251 726,986 1,239,455 816,873 751,477 65,396 8.0%
Human Resources 1,182,629 754,220 1,193,016 786,540 1,359,317 881,606 800,394 81,211 9.2%
Police 28,144,699 18,470,803 28,891,879 18,719,878 31,280,337 20,396,333 20,420,879 (24,546) ‐0.1%
Jail Services 4,142,266 2,762,741 4,704,978 3,136,577 4,850,000 3,203,926 3,203,926 ‐ 0.0%
Fire* 26,138,192 17,433,332 25,349,755 19,449,611 ‐ ‐ ‐ ‐ 0.0%
Community Services Admin 508,766 333,786 585,983 366,838 505,154 323,291 336,379 (13,088) ‐4.0%
Parks 4,411,383 2,870,952 4,445,115 2,895,238 5,179,955 3,372,507 3,023,118 349,390 10.4%
Parks Planning & Natural Resources 808,558 489,839 952,980 556,494 1,271,569 755,297 667,579 87,718 11.6%
Recreation 5,088,483 3,441,339 5,096,236 3,456,776 5,714,855 3,870,674 3,510,278 360,396 9.3%
Human Services 1,225,835 760,204 1,241,169 732,476 1,419,333 858,779 879,654 (20,875) ‐2.4%
Neighborhoods, Resources, & Events 958,624 613,785 865,551 557,046 1,225,894 786,830 631,442 155,388 19.7%
Museum 227,094 151,082 229,543 151,132 236,275 156,373 155,172 1,201 0.8%
Public Works Admin 387,493 258,768 398,796 267,579 406,398 272,046 271,835 211 0.1%
Street Maintenance 5,061,723 3,381,140 5,041,509 3,327,137 5,636,437 3,742,444 3,780,074 (37,630) ‐1.0%
Transportation 4,975,059 3,156,877 5,966,281 3,412,556 5,669,897 3,404,337 3,395,218 9,119 0.3%
Debt Service 6,371,715 1,323,214 6,099,166 1,441,996 6,066,629 1,361,480 1,361,480 ‐ 0.0%
Non‐Departmental and Other 10,069,740 5,851,672 9,883,923 3,063,984 16,795,551 2,160,209 2,160,209 ‐ 0.0%
Total Operating Expenditures 117,157,942 73,279,846 119,215,504 74,281,749 109,350,963 59,666,247 57,216,081 2,450,167 4.1%
Total Ending Fund Balance 19,962,845$ 17,543,433$ 26,563,785$ 25,059,109$ 19,790,962$ 31,537,501$ 39,191,084$ 7,653,584$ 24.3%
*Emergency Management was moved to Executive due to formation of RRFA
Favorable (Unfavorable)
2015 2016 2017 Variance
Annual Actual YTD Actual Annual Budget YTD Budget YTD ActualSummary of Sources and Uses Annual Actual YTD Actual
Monthly Financial Report August 2017
Page 1 of 37
Monthly Financial Report August 2017
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through August 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 75% of
all resources supporting general governmental activities. The following section provides detail information on property,
sales, utility, and other taxes.
Property Tax
August’s collection is $101K,
making the total year‐to‐date
collection $13M or 53.8% of the
total budget. In comparison to
the previous year, the City
collected $6.9M or 35% less.
Compared to the budget, the City
collected $108K or 1% more. The
large variance with the prior year
is due to the formation of the
Renton Regional Fire Authority.
Sales Tax
August 2017 sales tax receipts
totaled $2.4M. Compared with
the same month last year, it is
$17K or 1% less. Compared to
the projected current month’s
budget, it is $147K or 6% above.
The year‐to‐date collection of
$17.5M is $472K or 3% more than
the prior year and is also $818K
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 101,349 (139,188) ‐58% (8,764) ‐8%
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,831,817$ 12,870,217$ 12,978,317$ (6,853,500)$ ‐35% 108,100$ 1%
Annual Total 37,038,480$ 24,103,395$
Property Tax Revenues
Year to Date through August
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 2,421,720 (16,557) ‐1% 147,439 6%
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 17,026,474$ 16,681,270$ 17,498,892$ 472,418$ 3% 817,622$ 5%
Annual Total 26,353,246$ 25,700,400$
2017 vs. Budget2017 vs. 2016
Month
Year to Date through August
Local Retail Sales Tax Revenues
Page 2 of 37
Monthly Financial Report August 2017
The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business
sectors:
Utility tax
August utility tax revenues are
$1.2M, which is $63K or 5% lower
than the same month last year
and is also lower than the budget
by $85K or 7%. The year‐to‐date
collection is $11.6M, which is
$703K or 6% higher than the prior
year and is also $1.1M 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 2,869,498$ 2,795,483$ 2,828,855$ (40,644)$ ‐1% $ 33,371 1%
Auto Sales 3,175,412 3,059,579 3,168,239 (7,173) 0% 108,660 4%
General Retail 4,817,366 4,774,934 5,077,816 260,450 5% 302,883 6%
Manufacturing 1,200,893 1,045,481 1,001,529 (199,364) ‐17% (43,952)‐4%
Wholesale 839,568 909,833 1,002,949 163,381 19% 93,115 10%
Service 3,722,345 3,677,748 3,901,077 178,733 5% 223,329 6%
Other 401,392 418,212 518,428 117,036 29% 100,215 24%
YTD Total 17,026,474$ 16,681,270$ 17,498,892$ 472,418$ 3%817,622$ 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 1,185,237 (62,689) ‐5% (84,552) ‐7%
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 10,890,792$ 10,453,523$ 11,593,978$ 703,186$ 6% 1,140,456$ 11%
Annual Total 16,007,999$ 15,478,137$
2017 vs. Budget2017 vs. 2016
Year to Date through August
Utility Tax Revenues
Month
Utility Tax by Type 2016 2017 Bgt YTD Act Change 2017/2016 2017 Act vs Bgt
Electrical 3,681,969$ 3,597,306$ 3,879,254$ 197,285$ 5% $ 281,948 8%
Natural Gas 1,126,200 1,172,730 1,363,764 237,564 21% 191,033 16%
Cell 1,046,848 1,021,550 1,009,511 (37,336) ‐4% (12,039)‐1%
Phone 598,082 507,042 583,788 (14,294) ‐2% 76,746 15%
Cable 1,051,609 1,071,316 1,083,446 31,837 3% 12,130 1%
Garbage/Solid Waste 462,068 434,678 403,111 (58,956) ‐13% (31,567)‐7%
City Utilities 2,812,790 2,648,900 3,271,104 458,314 16% 622,204 23%
Utility Tax Audit 111,227 ‐ ‐ (111,227) 0% ‐ N/A
YTD Total 10,890,792$ 10,453,523$ 11,593,978$ 703,186$ 6%1,140,456$ 11%
Annual Total 16,007,999$ 15,478,137$
YTD as % of 68% 68%
Page 3 of 37
Monthly Financial Report August 2017
Other Taxes
Real Estate Excise Tax
The City collected $672K in Real
Estate Excise Tax revenues (REET)
for August. This is $87K or 11%
less than the same month last
year but is $188K or 39% more
than the current month’s budget.
The year‐to‐date collection is
$4.9M, which is $627k or 15%
more than the prior year and is
also $1.8M or 59% above the
budget. The higher than
expected variance is due to 24
large transactions in December,
January, February, March, April,
May, June, and July which
accounts for $1.6M of the total
REET collected.
Gambling Tax
August’s Gambling Tax
collections totaled $217K, which
is $106k or 33% below the same
month last year and is also below
the current month’s budget by
$12K or 5%. The year‐to‐date
total of $1.8M is $60K or 4%
above the prior year and is also
$422K or 32% above budget. The
large variance with the prior year
month is due to collections from
a payment plan of back taxes
earned in 2013/2014.
Franchise Fees
Franchise Fees are due quarterly
in January, April, July, and
October. The year‐to‐date total
of $1.1M is $98K or 9% higher
than the prior year and is also
$152K 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 672,396 (87,187) ‐11% 188,042 39%
Sep 522,472 401,943
Oct 559,552 434,871
Nov 502,139 266,351
Dec 307,382 265,838
YTD Total 4,230,285$ 3,050,997$ 4,857,035$ 626,750$ 15% 1,806,038$ 59%
Annual Total 6,121,830$ 4,420,000$
*For 2017, REET is only in CIP
Month
2017 vs. Budget2017 vs. 2016
Real Estate Excise Tax (REET) Revenues*
Year to Date through August
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 189,749$ 145,025$ 220,536$ 30,786$ 16% 75,511$ 52%
Feb 207,961 163,404 200,622 (7,339) ‐4% 37,218 23%
Mar 195,255 151,889 180,839 (14,416) ‐7% 28,949 19%
Apr 197,286 168,730 219,422 22,136 11% 50,692 30%
May 198,234 158,893 248,673 50,439 25% 89,780 57%
Jun 185,042 149,623 232,889 47,846 26% 83,265 56%
Jul 194,317 162,180 230,342 36,025 19% 68,162 42%
Aug 322,828 229,017 216,990 (105,838) ‐33% (12,027) ‐5%
Sep 202,409 159,756 ‐
Oct 242,254 190,582 ‐
Nov 183,345 165,084 ‐
Dec 181,924 155,817 ‐
YTD Total 1,690,672$ 1,328,761$ 1,750,312$ 59,640$ 4% 421,551$ 32%
Annual Total 2,500,604$ 2,000,000$
2017 vs. 2016
Gambling Tax Revenue
Month
Year to Date through August
2017 vs. Budget
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 348,118$ 328,952$ 380,870$ 32,752$ 9% 51,918$ 16%
Feb ‐ ‐ 6,300 6,300 100% 6,300 100%
Mar ‐ ‐ 9,100 9,100 100% 9,100 100%
Apr 355,430 333,387 369,626 14,196 4% 36,240 11%
May ‐ ‐ 7,688 7,688 100% 7,688 100%
Jun ‐ ‐ 21,325 21,325 100% 21,325 100%
Jul 343,910 330,451 342,363 (1,547) 0% 11,912 4%
Aug ‐ ‐ 7,700 7,700 100% 7,700 100%
Sep 5,000 2,414 ‐
Oct 348,783 332,455 ‐
Dec 4,850 2,341 ‐
YTD Total 1,047,459$ 992,790$ 1,144,972$ 97,513$ 9% 152,182$ 15%
Annual Total 1,406,092$ 1,330,000$
Franchise Fees Revenue
Year to Date through August
Month
2017 vs. 2016 2017 vs. Budget
Page 4 of 37
Monthly Financial Report August 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 $177K is $25K
or 12% less than the prior year
and is also $67K 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.7M. The
monthly budgets are based on
large business quarterly
reporting with smaller business
annual reporting.
Licenses and Permits
Business Licenses
Business Licenses totaled $125K
for August, which is $4K or 3%
above the same month last year
and is also $59K or 90% above
the current month’s budget. The
year‐to‐date Business Licenses
revenue of $1.1M is $479K or
30% below the prior year but is
above the budget by $101K or
10%. 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%
Aug ‐ ‐ 1,578 1,578 100% 1,578 100%
Sep 518 289 ‐
Oct 58,934 74,983 ‐
Nov 1,452 831 ‐
YTD Total 201,603$ 243,897$ 176,798$ (24,805)$ ‐12% (67,039)$ ‐28%
Annual Total 262,506$ 320,000$
2017 vs. Budget
Admission Tax Revenue
Year to Date through August
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 399,375 64,568 19% 229,375 135%
Sep 10,779 170,000 ‐
Oct 603,622 1,360,000 ‐
Nov 136,933 170,000 ‐
Dec ‐ 170,000 ‐
YTD Total 5,623,988$ 4,930,000$ 7,745,219$ 2,121,231$ 38% 2,815,219$ 57%
Annual Total 6,375,322$ 6,800,000$
*Total Business & Occupation Taxes (GF & CIP)
Business & Occupation Taxes*
Year to Date through August
Month
2017 vs. 2016 2017 vs. Budget
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 559,894$ 294,472 229,270$ (330,624)$ ‐59% (65,202)$ ‐22%
Feb 275,059 127,682 157,504 (117,555) ‐43% 29,822 23%
Mar 31,642 14,759 53,131 21,490 68% 38,373 260%
Apr 207,099 184,956 157,983 (49,116) ‐24% (26,973) ‐15%
May 111,131 72,269 126,086 14,955 13% 53,817 74%
Jun 26,936 13,489 36,375 9,439 35% 22,886 170%
Jul 248,769 228,999 217,718 (31,050) ‐12% (11,281) ‐5%
Aug 121,095 65,678 124,833 3,738 3% 59,155 90%
Sep 22,190 13,573 ‐
Oct 218,271 222,326 ‐
Nov 91,870 56,325 ‐
Dec 12,555 7,925 ‐
YTD Total 1,581,624$ 1,002,304$ 1,102,900$ (478,724)$ ‐30% 100,597$ 10%
Annual Total 1,926,510$ 1,302,453$
*Total Business License (GF & CIP)
Business Licenses*
Month
2017 vs. 2016
Year to Date through August
2017 vs. Budget
Page 5 of 37
Monthly Financial Report August 2017
Building Permits and
Development Service Fees
Building Permits and
Development Service Fee
revenues totaled $433K in
August. The year‐to‐date
revenues of $3.3M is $355K or
10% less than the year before and
is also $612K or 16% 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 93% of
the total revenues in
this category. The year‐
to‐date total
Intergovernmental revenue is $4.6M or 60% of the budget.
State Shared Revenues
State Shared Revenue
collections totaled
$3.9M since the start of
the year. Compared to
the prior year, State
Shared Revenues are
above by $88K or 2%.
Compared to the
projected budget, the
City is collecting $250K
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 433,043 35,465 9% (5,687) ‐1%
Sep 380,480 498,572
Oct 479,048 478,350
Nov 297,449 359,940
Dec 468,303 472,668
YTD Total 3,668,283$ 3,925,839$ 3,313,654$ (354,628)$ ‐10% (612,184)$ ‐16%
Annual Total 5,293,563$ 5,735,368$
Building Permits and Development Service Fees
Year to Date through August
2017 vs. Budget2017 vs. 2016
Month
Intergovernmental 2016 2017 Bgt YTD Act Change 2017/2016 2017 Act vs Bgt
Fire District #25 698,123$ ‐$ ‐$ (698,123)$ 0% $ ‐ N/A
Fire District #40 2,819,656 341,939 341,939 (2,477,717) ‐88%‐ 0%
State Shared Revenue 3,814,844 3,653,138 3,903,242 88,398 2% 250,104 7%
Federal Grants 322,703 81,719 81,719 (240,984) ‐75%‐ 0%
State Grants 39,421 30,032 30,032 (9,389) ‐24%‐ 0%
Other Grants/Intgovt 646,061 225,607 218,127 (427,934) ‐66% (7,481) ‐3%
ARRA Grants ‐ ‐ ‐ ‐ N/A ‐ N/A
Total Rev YTD 8,340,808$ 4,332,435$ 4,575,058$ (3,765,749)$ ‐45%242,623$ 6%
Total Rev Annual 10,698,115$ 7,661,089$
YTD %78% 57% 60%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
2016 2017 2017
Actual Budget Actual $ % $ %
Crim Just Sales Tax 1,766,874$ 1,745,919$ 1,824,013$ 57,139$ 3% 78,094$ 4%
Judicial Contribution 18,092 ‐ 5,570 (12,522) ‐69% 5,570 100%
Crim Just ‐ High Crime 222,737 154,614 204,154 (18,583) ‐8% 49,540 32%
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 932,622 925,475 951,413 18,791 2% 25,939 3%
YTD Total 3,814,844$ 3,653,138$ 3,903,242$ 88,398$ 2% 250,104$ 7%
Annual Total 5,933,890$ 5,805,528$
2017 vs. Budget
State Shared Revenues
2017 vs. 2016
Revenue
Year to Date through August
Page 6 of 37
Monthly Financial Report August 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
68% of the total revenue in this category. The year‐to‐date total charges for services are $6M or 69% of the budget. The
following sections provide detail information for Public Safety, Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totaled
$568K 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 $52K or 8% less.
Compared to the year‐to‐date
budget, the City is over budget by
$152K or 37%. The variance with
the prior year is due to collecting
large payments/reimbursements
for electronic home detention
and School Resource Officer
programs.
Recreation
Recreation revenues totaled
$382K for the current month.
Compared to the same month
the prior year, the City collected
$33K or 9% more. Compared to
the projected monthly budget,
the City collected $22K or 6%
more. The year‐to‐date
collection of $1.4M is $62K or 4%
higher than the year before but is
$24K or 2% lower than the year‐
to‐date budget.
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 104,644$ 60,800$ 64,424$ (40,221)$ ‐38% 3,624$ 6%
Feb 99,623 52,862 68,705 (30,918) ‐31% 15,844 30%
Mar 58,031 44,909 148,707 90,676 156% 103,798 231%
Apr 51,002 73,680 61,399 10,397 20% (12,280) ‐17%
May 48,201 38,573 63,815 15,615 32% 25,242 65%
Jun 179,089 79,037 43,374 (135,715) ‐76% (35,664) ‐45%
Jul 34,906 27,743 59,850 24,944 71% 32,108 116%
Aug 44,439 38,564 58,114 13,675 31% 19,550 51%
Sep 67,570 33,790 ‐
Oct 160,438 72,212 ‐
Nov 67,763 42,537 ‐
Dec 78,473 48,375 ‐
YTD Total 619,935$ 416,167$ 568,388$ (51,546)$ ‐8% 152,221$ 37%
Annual Total 994,179$ 613,081$
Year to Date through August
Public Safety Services
2017 vs. 2016 2017 vs. Budget
Month
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 163,783$ 152,710$ 152,350$ (11,433)$ ‐7% (360)$ 0%
Feb 48,009 42,505 38,452 (9,558) ‐20% (4,053) ‐10%
Mar 60,615 52,493 65,420 4,805 8% 12,927 25%
Apr 112,627 110,918 74,806 (37,821) ‐34% (36,112) ‐33%
May 72,246 74,076 84,381 12,135 17% 10,305 14%
Jun 239,771 254,264 153,304 (86,467) ‐36% (100,960) ‐40%
Jul 325,043 409,892 482,458 157,415 48% 72,566 18%
Aug 349,650 360,345 382,296 32,646 9% 21,950 6%
Sep 107,652 123,607 ‐
Oct 45,706 55,007 ‐
Nov 68,324 70,632 ‐
Dec 39,475 44,472 ‐
YTD Total 1,371,745$ 1,457,205$ 1,433,468$ 61,722$ 4% (23,737)$ ‐2%
Annual Total 1,632,903$ 1,750,923$
Recreation
Year to Date through August
2017 vs. Budget2017 vs. 2016
Month
Page 7 of 37
Monthly Financial Report August 2017
Interfund Services
The year‐to‐date collections for
Interfund Services revenues are
$2.6M. Compared to the prior
year, the revenues are over by
$418K or 19%. Compared to the
projected budget, the revenues
are below by $160K or 6%.
2017’s monthly budgets are
based on 1/12th of the annual
budget. The majority of these
revenues are related to indirect
cost allocations, which are
internal administrative costs.
The remaining costs consist of
Development Services division’s
inspection fees, Parks Planning
and Natural Resources division’s capital investment program reimbursements, Transportation division’s capital investment
program reimbursements, and Maintenance division’s street maintenance reimbursements.
Fines and Penalties
These revenue sources contain
civil (penalties, infractions, and
parking), criminal (traffic, non‐
traffic, and costs), and non‐court
fines, forfeitures, and penalties.
The table below breaks down
these fines by type. The year‐to‐
date total fines and penalties is
$1.9M. This is $44K or 2% higher
than a year ago and $75K or 4%
higher than the budget.
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 272,841$ 348,248$ 330,774$ 57,933$ 21% (17,474)$ ‐5%
Feb 286,748 348,248 319,851 33,103 12% (28,397) ‐8%
Mar 305,054 348,248 377,192 72,138 24% 28,944 8%
Apr 276,238 348,248 332,180 55,942 20% (16,068) ‐5%
May 272,641 348,248 332,543 59,902 22% (15,705) ‐5%
Jun 260,223 348,248 322,435 62,212 24% (25,813) ‐7%
Jul 259,888 348,248 314,856 54,968 21% (33,392) ‐10%
Aug 273,851 348,248 295,921 22,070 8% (52,327) ‐15%
Sep 286,057 348,248 ‐
Oct 277,517 348,248 ‐
Nov 295,584 348,248 ‐
Dec 311,019 348,248 ‐
YTD Total 2,207,485$ 2,785,984$ 2,625,752$ 418,268$ 19% (160,231)$ ‐6%
Annual Total 3,377,663$ 4,178,976$
Interfund Services
Year to Date through August
2017 vs. 2016 2017 vs. Budget
Month
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 136,421$ 126,199$ 134,957$ (1,464)$ ‐1% 8,758$ 7%
Feb 217,667 213,156 217,056 (611) 0% 3,900 2%
Mar 263,648 264,385 212,186 (51,462) ‐20% (52,199) ‐20%
Apr 250,873 242,171 242,816 (8,056) ‐3% 645 0%
May 214,613 231,927 229,877 15,263 7% (2,050) ‐1%
Jun 261,254 261,299 302,666 41,411 16% 41,367 16%
Jul 222,267 219,171 247,260 24,993 11% 28,089 13%
Aug 274,964 252,324 298,685 23,721 9% 46,360 18%
Sep 200,986 232,621
Oct 238,517 243,770
Nov 273,338 270,941
Dec 306,114 310,486
YTD Total 1,841,708$ 1,810,632$ 1,885,502$ 43,795$ 2% 74,870$ 4%
Annual Total 2,860,662$ 2,868,450$
2017 vs. Budget2017 vs. 2016
Year to Date through August
Fines and Penalties by Month
Month
Year to Date through August
2016 2017 2017
Actual Budget Actual $ % $ %
Civil Penalties 1,321$ 2,906$ 1,463$ 143$ 11% (1,443)$ ‐50%
Civil Infraction Penalties 211,834 201,453 196,958 (14,876) ‐7% (4,495) ‐2%
Civil Parking Infraction Penalties 100,146 140,417 106,999 6,853 7% (33,418) ‐24%
Photo Enforcement Program 1,287,076 1,314,004 1,393,203 106,128 8% 79,200 6%
Criminal Traffic Misdemeanor Fines 51,245 43,429 52,529 1,285 3% 9,101 21%
Criminal Non ‐Traffic Fines 17,910 36,155 56,310 38,400 214% 20,155 56%
Criminal Costs 61,201 56,699 52,244 (8,957) ‐15% (4,455) ‐8%
Non‐Court Fines, Forfeitures and Penalties 110,976 15,571 25,796 (85,180) ‐77% 10,225 66%
YTD Total 1,841,708$ 1,810,632$ 1,885,502$ 43,795$ 2% 74,870$ 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 August 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.4M.
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.6M.
Compared to last year, the
revenues are below by $544K or
26%. Compared to the projected
year‐to‐date budget, the
revenues are over by $417K or
36%. The large variance with the
prior year is due to collecting
more than anticipated Seizure
Funds in 2016. Seizure Funds are restricted to drug enforcement only and are not available for general operating purposes.
Favorable
17 Budget 17 Actual 17 Budget 17 Actual (Unfavorable)
1
Jan 125,201$ 127,976$ 89,775$ 27,432$ 100,544$
Feb 157,962 151,276 89,775 95,200 56,076
Mar 189,510 146,612 89,775 95,186 51,425
Apr 165,633 161,103 89,775 95,192 65,911
May 152,426 175,251 89,775 95,189 80,062
Jun 194,994 221,788 89,775 95,183 126,605
Jul 144,851 183,910 89,775 95,189 88,721
Aug 183,427 225,288 89,775 95,204 130,084
Sep 164,770 ‐ 89,775 ‐ ‐
Oct 175,856 ‐ 89,775 ‐ ‐
Nov 185,108 ‐ 89,775 ‐ ‐
Dec 204,263 ‐ 89,775 ‐ ‐
YTD Total 1,314,004$ 1,393,203$ 718,198$ 693,777$ 699,427$
Annual Total 2,044,000$ 1,077,297$
1Actuals of Revenues and Expenses
ExpensesRevenues
Photo Enforcement Program
Year to Date through August
Month
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 198,576 (96,088) ‐33% 37,989 24%
Sep 160,616 121,159
Oct 152,817 128,451
Nov 327,568 104,753
Dec 425,765 370,158
YTD Total 2,120,475$ 1,160,096$ 1,576,951$ (543,524)$ ‐26% 416,854$ 36%
Annual Total 3,187,241$ 1,884,617$
Year to Date through August
Month
2017 vs. Budget2017 vs. 2016
Miscellaneous Revenues by Month
2016 2017 2017
Actual Budget Actual $ % $ %
Interests and Other Earnings 473,805$ 403,140$ 565,841$ 92,036$ 19% 162,702$ 40%
Rents, Leases, and Concessions 505,330 493,981 504,182 (1,149) 0% 10,201 2%
Contributions/Donations from Private Sources 66,563 85,852 104,075 37,512 56% 18,223 21%
Other 298,538 177,124 242,879 (55,659) ‐19% 65,755 37%
Seizure Funds ‐ Federal/State/Local 776,237 ‐ 159,974 (616,264) ‐79% 159,974 100%
YTD Total 2,120,475$ 1,160,096$ 1,576,951$ (543,524)$ ‐26% 416,854$ 36%
Annual Total 3,187,241$ 1,884,617$
2017 vs. Budget
Miscellaneous Revenues by Type
Year to Date through August
Revenue
2017 vs. 2016
Page 9 of 37
Monthly Financial Report August 2017
EXPENSES
Overall the City has expended 52% of its budgeted general governmental expenditures at the end of August. This is $2.5M
or 4.1% below year‐to‐date budgeted expenditures. See below for summary of unfavorable items for general governmental
departments.
Executive department is over the year‐to‐date budget by $7K or 0.5%. This is due to the timing of when memberships &
dues were paid in 2017 compared to 2015/2016.
Police department is over the year‐to‐date budget by $25K or 0.1%. This is due to the spending patterns of supplies and
professional services in 2017 compared to 2015/2016.
Public Works department (Admin, Street Maintenance, and Transportation) is over the year‐to‐date budget by $28K or
0.4%. This is mainly due to overspending on supplies ($95K), professional services ($191K), interfund payments to other
Maintenance sections ($39K), and capital equipment ($8K) and underspending on salaries/benefits ($311K).
Page 10 of 37
Monthly Financial Report August 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 ‐ ‐ ‐ ‐ 58,990 28,500 ‐
Grants / intergovernmental 13,312 ‐ 134,063 ‐ 1,232,421 1,309,445 ‐
Charges for services 104,715 1,337,887 10,663,260 10,998,467 6,910,917 7,794,531 11,169,609
Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐
Fines and penalties 1,044 ‐ ‐ ‐ 970 ‐ ‐
Rents, leases, and misc fees 1,746,579 291,025 11,857 118,253 ‐ ‐ ‐
Interest and other misc 15,426 849 41,974 885,819 1,428,929 638,584 25,108
TOTAL REVENUES 1,881,076 1,629,761 10,851,154 12,002,539 9,632,227 9,771,060 11,194,717
EXPENSES:
Utility billing ‐ ‐ 29,991 107,799 85,722 132,181 ‐
Utility systems ‐ ‐ 12,360,151 2,482,423 2,299,367 2,842,480 ‐
Utility maintenance ‐ ‐ 222,523 3,786,190 1,406,438 1,838,983 11,210,725
Transportation 1,058,018 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 1,518,808 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 1,058,018 1,518,808 12,612,665 6,376,412 3,791,527 4,813,644 11,210,725
AMOUNT AVAILABLE FOR DEBT SERVICE 823,058 110,953 (1,761,510) 5,626,127 5,840,700 4,957,416 (16,008)
DEBT SERVICE:
Principal ‐ ‐ ‐ 395,175 ‐ ‐ ‐
Interest ‐ ‐ ‐ 207,051 93,469 436,774 ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ 602,226 93,469 436,774 ‐
CAPITAL PROJECTS 139,917 66,995 ‐ 1,609,272 2,273,373 1,278,186 ‐
TRANSFERS IN/(OUT)‐ ‐ (370) (433) (1,205) (370) ‐
CHANGE IN FUND BALANCE 683,141 43,958 (1,761,880) 3,414,196 3,472,653 3,242,086 (16,008)
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, Aug 31 3,302,484 81,046 989,537 31,943,130 17,332,315 14,136,061 4,978,650
Page 11 of 37
Monthly Financial Report August 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 ‐ 144,073 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ 7,110 ‐ ‐ ‐ ‐ 47,440
Charges for services
Equipment rental m&o 1,805,922 2,833,611 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ ‐ ‐ 292,883 ‐ ‐ ‐
Communications ‐ 529,668 ‐ 425,278 ‐ ‐ ‐
Facilities ‐ ‐ 3,348,678 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ ‐ ‐ ‐ ‐ ‐ ‐
IT service co ntracts ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest and other misc 31,895 13,823 7,485 2,752 61,198 21,473 50,930
Internal service fund misc:
Vehicle / equipment capital recovery 1,476,001 322,644 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 1,144,200 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 916,947 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 6,147,070 1,749,788
Other misc 239 47 18,850 20 ‐ 623,466 ‐
Interfund Loan ‐ ‐ ‐ ‐ ‐ ‐ ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets 56,422 ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 111,055 ‐ ‐
TOTAL REVENUES 3,370,479 3,850,976 3,375,012 720,933 2,233,400 6,792,009 1,848,158
EXPENSES:
Communications 393,887
Equipment rental 1,532,774
Facilities 2,933,015
Healthcare 6,256,735
Information technology 2,703,533
Print and mail 273,537
Retiree healthcare 577,926
Risk management:
Risk management 1,011,229
Unemployment 40,444
Worker's compensation 997,028
TOTAL EXPENSES 1,532,774 2,703,533 2,933,015 667,424 2,048,701 6,256,735 577,926
AMOUNT AVAILABLE FOR CAPITAL 1,837,705 1,147,443 441,997 53,509 184,699 535,274 1,270,232
CAPITAL PROJECTS 2,207,693 339,923 30,077 ‐ ‐ ‐ ‐
TRANSFERS IN ‐ 15,684 ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ (89,876) ‐
CHANGE IN FUND BALANCE (369,988) 823,204 411,920 53,509 184,699 445,398 1,270,232
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, Aug 31 6,062,065 3,393,578 1,686,973 596,436 13,037,208 4,601,546 11,349,483
Page 12 of 37
Monthly Financial Report August 2017
FUND BALANCE
Page 14 shows the ending fund balance as of August 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 August, the City has $39.2M 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 $12.6M from the
year’s beginning balance. August’s ending fund balance is over the anticipated General Governmental Fund Balance of
$31.5M by $7.7M or 24.3%. Although the ending fund balance is above projections, it is consistent with the prior years’
trends.
CONTACT INFORMATION
This report is prepared by the Finance Division of the Administrative Services Department. For additional financial
information, please also review our website: http://www.rentonwa.gov/. For any questions about the report, please feel
free to contact us at hnguyen@rentonwa.gov or JDThomas@Rentonwa.gov.
Page 13 of 37
Monthly Financial Report August 2017
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through August 31, 2017
Funds
Balance
01/01/2017
Budgeted
Revenue
Revenue
08/31/17
Total Funds
Available
Budgeted
Expenditure
Expenditure
08/31/17 Ending Balance
GENERAL GOVERNMENT FUNDS: 26,563,785 102,578,140 69,843,380 96,407,165 109,350,964 57,216,081 39,191,084
000 General 18,201,028 69,687,089 50,805,903 69,006,931 76,768,027 40,215,366 28,791,564
001 Community Services 3,769,766 13,615,254 8,651,373 12,421,139 13,788,263 8,099,704 4,321,435
003 Street 1,936,367 11,885,024 7,066,796 9,003,163 11,306,335 7,175,292 1,827,871
004 Community Dev Block Grant 66,654 1,068,770 413 67,067 1,076,270 139,973 (72,907)
005 Museum 72,372 233,936 117,234 189,606 236,275 155,172 34,433
009 Farmers Market 90,730 112,742 72,058 162,788 109,165 69,092 93,695
011 Fire Health & Wellness ‐ ‐ ‐ ‐ ‐ ‐ ‐
201 Ltd GO Bonds Gen Govt Debt 852,111 1,749,675 880,806 1,732,917 1,749,675 41,925 1,690,992
215 Gen Govt Misc Debt Service 1,574,757 4,225,650 2,248,798 3,823,555 4,316,954 1,319,555 2,504,000
SPECIAL REVENUE FUNDS:1,599,965 1,974,729 1,565,092 3,165,057 2,164,749 668,131 2,496,926
102 Arterial Street 63,480 660,000 448,973 512,453 660,000 ‐ 512,453
108 Leased City Properties 276,865 902,550 792,543 1,069,408 888,131 434,957 634,451
110 Hotel Motel 402,602 265,000 212,529 615,131 375,994 176,921 438,210
125 1% For Art 128,489 24,505 613 129,102 117,950 13,950 115,152
127 Cable Communication 394,504 122,674 108,841 503,345 122,674 42,303 461,042
135 Springbrook Wetlands Bank 334,025 ‐ 1,593 335,618 ‐ ‐ 335,618
CAPITAL PROJECT FUNDS (CIP): 26,202,403 35,746,139 15,089,642 41,292,045 50,816,731 9,356,424 31,935,621
303 Community Dev Mitigation 1,255,194 406,014 212,996 1,468,190 ‐ ‐ 1,468,190
304 Fire Mitigation 607,163 99,000 378,511 985,674 158,696 ‐ 985,674
305 Transportation Mitigation 1,497,748 620,000 598,180 2,095,928 1,890,000 ‐ 2,095,928
316 Municipal Facilities CIP 15,038,030 13,701,632 8,085,780 23,123,810 23,198,133 2,064,960 21,058,850
317 Transportation CIP 5,640,494 19,419,493 5,804,837 11,445,331 24,544,675 6,994,450 4,450,881
326 Housing Opportunity 1,041,173 1,500,000 4,967 1,046,140 ‐ ‐ 1,046,140
336 New Library Development 1,122,601 ‐ 4,371 1,126,972 1,025,227 297,014 829,958
ENTERPRISE FUNDS:63,685,077 89,995,648 57,013,677 120,698,754 120,539,512 47,935,536 72,763,218
4X2 Ai rport Operating & CIP 2,619,343 3,405,842 1,881,076 4,500,419 5,688,023 1,197,935 3,302,484
403 Solid Waste Utility 2,751,417 19,187,851 10,851,154 13,602,571 19,024,775 12,613,035 989,536
4X4 Golf Operating & CIP 37,088 2,893,044 1,669,761 1,706,849 2,630,288 1,625,803 81,046
4X5 Water Operating & CIP 28,528,934 17,180,526 12,002,539 40,531,473 35,347,154 8,588,344 31,943,129
4X6 Waste Water Operating & CIP 13,859,662 13,264,936 9,643,371 23,503,033 20,537,816 6,170,721 17,332,312
416 King County Metro 4,994,658 17,505,693 11,194,717 16,189,375 17,505,693 11,210,725 4,978,650
4X7 Surface Water Operating & CIP 10,893,975 16,557,756 9,771,059 20,665,034 19,805,763 6,528,973 14,136,061
INTERNAL SERVICE FUNDS:37,908,315 34,806,873 22,206,651 60,114,966 33,548,887 19,387,677 40,727,289
501 Equipment Repair/Replacement 6,432,053 6,494,353 3,370,478 9,802,531 7,728,113 3,740,467 6,062,064
502 Insurance 12,852,509 7,392,368 2,233,401 15,085,910 3,571,166 2,048,701 13,037,209
503 Information Services 2,570,374 5,731,776 3,866,660 6,437,034 6,835,636 3,043,456 3,393,578
504 Facilities 1,275,053 5,067,015 3,375,012 4,650,065 5,134,433 2,963,092 1,686,973
505 Communications 542,927 1,078,253 720,933 1,263,860 1,076,474 667,424 596,436
512 Insurance, Healthcare 4,156,148 7,787,779 6,792,009 10,948,157 8,163,471 6,346,611 4,601,546
522 Insurance, Leoff1 Retirees HC 10,079,251 1,255,329 1,848,158 11,927,409 1,039,594 577,926 11,349,483
FIDUCIARY FUNDS: 5,578,045 468,000 168,202 5,746,247 210,475 144,771 5,601,476
611 Firemen's Pension 5,578,045 468,000 168,202 5,746,247 210,475 144,771 5,601,476
TOTAL FUNDS 161,537,590 265,569,529 165,886,644 327,424,234 316,631,318 134,708,620 192,715,614
Page 14 of 37
City of Renton
General Government Financial Position
2017 Budget Year
General Government Summary
Revenues Expenditures
$ Difference
over (under)
w/beginning
balance
26,563,785
January 7,364,146 6,595,136 769,010 27,332,795
February 14,472,917 13,388,134 1,084,783 27,648,568
March 21,057,303 20,198,065 859,238 27,423,023
April 39,230,543 27,006,711 12,223,832 38,787,617
May 47,996,932 34,253,900 13,743,032 40,306,817
June 54,429,132 41,552,555 12,876,577 39,440,362
July 62,729,973 49,694,920 13,035,053 39,598,838
August 69,843,380 57,216,081 12,627,299 39,191,084
September
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,639,963 69,843,380 8.05%
Sep 71,031,665
Oct 82,422,565
Nov 95,354,085
Dec 102,578,140
Percent of budget 68.09%
Property Tax Budget
YTD
Actual
Annual %
over (under)
Jan 36,768 55,429 50.75%
Feb 241,042 250,761 4.03%
Mar 967,646 1,153,726 19.23%
Apr 6,883,291 8,189,058 18.97%
May 12,626,243 12,678,534 0.41%
Jun 12,719,859 12,807,368 0.69%
Jul 12,760,104 12,876,968 0.92%
Aug 12,870,217 12,978,317 0.84%
Sep 13,238,047
Oct 17,341,593
Nov 23,988,632
Dec 24,103,395
Percent of budget 53.84%
$‐
$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 19,574,255 4.88%
Sep 21,097,526
Oct 23,629,240
Nov 26,285,407
Dec 28,763,680
Percent of budget 68.05%
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 11,593,978 10.91%
Sep 11,680,525
Oct 12,932,675
Nov 14,139,633
Dec 15,478,137
Percent of budget 74.91%
Note: Includes Natural Gas Use Tax.
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
Millions Sales Tax
Budget
Actual
Last Year
$‐
$2
$4
$6
$8
$10
$12
$14
$16
Millions Utility Tax
Budget
Actual
Last Year
Page 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 3,093,300 ‐8.16%
Sep 3,791,878
Oct 4,274,238
Nov 4,532,625
Dec 4,815,012
Percent of budget 64.24%
Note: GF only
Intergovt'l Budget
YTD
Actual
Annual %
over (under)
Jan 567,324 604,678 6.58%
Feb 1,156,199 1,193,433 3.22%
Mar 1,699,398 1,773,868 4.38%
Apr 2,209,382 2,313,101 4.69%
May 2,601,589 2,729,902 4.93%
Jun 3,194,501 3,346,773 4.77%
Jul 3,772,397 4,001,945 6.08%
Aug 4,332,435 4,575,058 5.60%
Sep 4,989,837
Oct 5,505,674
Nov 6,384,392
Dec 7,661,089
Percent of budget 59.72%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
$‐
$2
$4
$6
$8
$10
$12
Millions
Intergovernmental
Budget
Actual
Last Year
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
Millions Licenses & Permits
Budget
Actual
Last Year
Page 18 of 37
City of Renton
Monthly Revenue Analysis ‐ 2017 Budget Year
Charges for
Services Budget
YTD
Actual
Annual %
over (under)
Jan 641,725 749,576 16.81%
Feb 1,192,622 1,295,589 8.63%
Mar 1,779,728 2,031,739 14.16%
Apr 2,574,617 2,607,404 1.27%
May 3,142,189 3,347,586 6.54%
Jun 4,270,357 4,077,898 ‐4.51%
Jul 5,207,148 5,052,850 ‐2.96%
Aug 6,077,059 5,992,324 ‐1.39%
Sep 6,705,746
Oct 7,327,762
Nov 7,947,988
Dec 8,677,538
Percent of budget 69.06%
Note: Excludes FD25 & FD40 contracts
Fines &
Forfeits Budget
YTD
Actual
Annual %
over (under)
Jan 126,199 134,957 6.94%
Feb 339,355 352,013 3.73%
Mar 603,740 564,199 ‐6.55%
Apr 845,911 807,015 ‐4.60%
May 1,077,838 1,036,892 ‐3.80%
Jun 1,339,137 1,339,558 0.03%
Jul 1,558,308 1,586,818 1.83%
Aug 1,810,632 1,885,502 4.14%
Sep 2,043,253
Oct 2,287,023
Nov 2,557,964
Dec 2,868,450
Percent of budget 65.73%
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
Millions Charges for Services
Budget
Actual
Last Year
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
Millions Fines & Forfeits
Budget
Actual
Last Year
Page 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 8,474,829 45.97%
Sep 6,075,201
Oct 7,571,990
Nov 7,846,056
Dec 8,155,026
Percent of budget 103.92%
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 1,576,951 35.93%
Sep 1,281,255
Oct 1,409,706
Nov 1,514,459
Dec 1,884,617
Percent of budget 83.67%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions Miscellaneous
Budget
Actual
Last Year
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
$10
$11
$12
$13
Millions Other Taxes
Budget
Actual
Last Year
Page 20 of 37
City of Renton
Monthly Revenue Analysis ‐ 2017 Budget Year
Other
Financing Budget
YTD
Actual
Annual %
over (under)
Jan 14,266 ‐ 0.00%
Feb 28,533 ‐ 0.00%
Mar 42,799 ‐ 0.00%
Apr 94,231 94,231 0.00%
May 94,231 94,231 0.00%
Jun 94,981 94,981 0.00%
Jul 97,726 97,726 0.00%
Aug 98,866 98,866 0.00%
Sep 128,397
Oct 142,663
Nov 156,930
Dec 171,196
Percent of budget 57.75%
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 4,857,035 59.20%
Sep 3,452,940
Oct 3,887,811
Nov 4,154,162
Dec 4,420,000
Percent of budget 109.89%
$‐
$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 3,313,654 ‐15.59%
Sep 4,424,411
Oct 4,902,760
Nov 5,262,700
Dec 5,735,368
Percent of budget 57.78%
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 7,745,219 57.10%
Sep 5,100,000
Oct 6,460,000
Nov 6,630,000
Dec 6,800,000
Percent of budget 113.90%
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
Millions Building Permits and Development Service
Fees
Budget
Actual
Last Year
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
$5.50
$6.00
$6.50
$7.00
$7.50
$8.00
$8.50
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 59,666,247 57,216,081 ‐4.11%
Sep 80,715,944
Oct 90,074,524
Nov 98,821,901
Dec 109,350,963
Percent of budget expended 52.32%
Legislative Budget
YTD
Actual
Annual %
over (under)
Jan 36,183 36,043 ‐0.39%
Feb 66,236 64,877 ‐2.05%
Mar 101,649 97,498 ‐4.08%
Apr 131,509 127,629 ‐2.95%
May 161,207 157,670 ‐2.19%
Jun 190,925 187,856 ‐1.61%
Jul 219,892 216,595 ‐1.50%
Aug 249,074 245,568 ‐1.41%
Sep 278,319
Oct 308,035
Nov 337,502
Dec 368,211
Percent of budget expended 66.69%
$‐
$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 1,290,543 0.55%
Sep 1,468,126
Oct 1,611,032
Nov 1,754,366
Dec 1,957,671
Percent of budget expended 65.92%
Emergency
Management Budget
YTD
Actual
Annual %
over (under)
Jan 63,184 35,052 ‐44.52%
Feb 104,484 75,996 ‐27.27%
Mar 156,084 120,198 ‐22.99%
Apr 197,331 171,474 ‐13.10%
May 238,910 219,758 ‐8.02%
Jun 287,314 267,919 ‐6.75%
Jul 329,069 314,737 ‐4.36%
Aug 399,866 370,942 ‐7.23%
Sep 448,780
Oct 492,637
Nov 535,475
Dec 609,249
Percent of budget expended 60.89%
$‐
$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 1,384,646 ‐5.59%
Sep 1,658,357
Oct 1,826,387
Nov 1,995,101
Dec 2,163,329
Percent of budget expended 64.01%
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 1,429,897 ‐2.43%
Sep 1,656,123
Oct 1,839,864
Nov 2,023,061
Dec 2,220,656
Percent of budget expended 64.39%
$‐
$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 893,461 ‐1.72%
Sep 1,015,431
Oct 1,121,287
Nov 1,226,753
Dec 1,337,991
Percent of budget expended 66.78%
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 2,066,905 ‐7.23%
Sep 2,530,168
Oct 2,814,598
Nov 3,096,537
Dec 3,404,464
Percent of budget expended 60.71%
$‐
$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 580,426 ‐50.50%
Sep 1,294,219
Oct 1,517,766
Nov 1,687,862
Dec 1,847,888
Percent of budget expended 31.41%
Planning Budget
YTD
Actual
Annual %
over (under)
Jan 243,257 221,112 ‐9.10%
Feb 490,299 449,900 ‐8.24%
Mar 754,718 681,350 ‐9.72%
Apr 1,014,473 906,510 ‐10.64%
May 1,315,458 1,134,729 ‐13.74%
Jun 1,605,503 1,353,531 ‐15.69%
Jul 1,871,101 1,570,361 ‐16.07%
Aug 2,140,077 1,787,262 ‐16.49%
Sep 2,429,086
Oct 2,705,736
Nov 2,959,083
Dec 3,222,077
Percent of budget expended 55.47%
$‐
$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 1,817,314 ‐8.62%
Sep 2,222,013
Oct 2,454,488
Nov 2,672,475
Dec 3,362,369
Percent of budget expended 54.05%
City Clerk Budget
YTD
Actual
Annual %
over (under)
Jan 78,434 62,018 ‐20.93%
Feb 189,186 322,088 70.25%
Mar 278,847 387,366 38.92%
Apr 369,230 459,577 24.47%
May 460,538 533,887 15.93%
Jun 552,158 606,380 9.82%
Jul 646,835 680,117 5.15%
Aug 816,873 751,477 ‐8.01%
Sep 832,467
Oct 948,567
Nov 1,045,159
Dec 1,239,455
Percent of budget expended 60.63%
Includes Hearing Examiner
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
Millions City Clerk
Budget
Actual
Last Year
$‐
$0.40
$0.80
$1.20
$1.60
$2.00
$2.40
$2.80
$3.20
$3.60
Millions Finance
Budget
Actual
Last Year
Page 28 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
Human
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 89,142 87,874 ‐1.42%
Feb 195,491 175,377 ‐10.29%
Mar 317,705 273,335 ‐13.97%
Apr 435,958 395,728 ‐9.23%
May 545,888 492,849 ‐9.72%
Jun 654,767 592,817 ‐9.46%
Jul 763,876 699,070 ‐8.48%
Aug 881,606 800,394 ‐9.21%
Sep 989,949
Oct 1,112,832
Nov 1,220,753
Dec 1,359,317
Percent of budget expended 58.88%
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,600,260 23,624,806 0.10%
Sep 26,807,915
Oct 29,657,572
Nov 32,675,468
Dec 36,130,337
Percent of budget expended 65.39%
$‐
$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 336,379 4.05%
Sep 362,917
Oct 402,012
Nov 441,115
Dec 505,154
Percent of budget expended 66.59%
Parks Budget
YTD
Actual
Annual %
over (under)
Jan 347,594 309,997 ‐10.82%
Feb 721,741 630,236 ‐12.68%
Mar 1,115,607 989,660 ‐11.29%
Apr 1,515,120 1,374,644 ‐9.27%
May 1,916,439 1,753,298 ‐8.51%
Jun 2,361,763 2,138,544 ‐9.45%
Jul 2,879,343 2,568,387 ‐10.80%
Aug 3,372,507 3,023,118 ‐10.36%
Sep 3,882,283
Oct 4,333,779
Nov 4,732,770
Dec 5,179,955
Percent of budget expended 58.36%
$‐
$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 667,579 ‐11.61%
Sep 880,231
Oct 1,004,912
Nov 1,117,820
Dec 1,271,569
Percent of budget expended 52.50%
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 3,510,278 ‐9.31%
Sep 4,434,425
Oct 4,852,298
Nov 5,270,092
Dec 5,714,855
Percent of budget expended 61.42%
$‐
$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 879,654 2.43%
Sep 937,301
Oct 1,120,435
Nov 1,209,310
Dec 1,419,333
Percent of budget expended 61.98%
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 631,442 ‐19.75%
Sep 890,249
Oct 985,557
Nov 1,071,844
Dec 1,225,894
Percent of budget expended 51.51%
$‐
$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 155,172 ‐0.77%
Sep 176,366
Oct 196,623
Nov 216,498
Dec 236,275
Percent of budget expended 65.67%
Public Works
Admin Budget
YTD
Actual
Annual %
over (under)
Jan 33,358 33,498 0.42%
Feb 68,245 67,352 ‐1.31%
Mar 102,054 101,914 ‐0.14%
Apr 135,775 135,878 0.08%
May 169,617 169,665 0.03%
Jun 203,557 203,650 0.05%
Jul 237,559 237,592 0.01%
Aug 272,046 271,835 ‐0.08%
Sep 306,358
Oct 339,748
Nov 373,069
Dec 406,398
Percent of budget expended 66.89%
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
$400,000
$450,000
Public Works Admin
Budget
Actual
Last Year
$‐
$30,000
$60,000
$90,000
$120,000
$150,000
$180,000
$210,000
$240,000
Museum Fund
Budget
Actual
Last Year
Page 33 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
Street
Maintenance Budget
YTD
Actual
Annual %
over (under)
Jan 439,569 408,757 ‐7.01%
Feb 886,721 920,483 3.81%
Mar 1,366,996 1,383,891 1.24%
Apr 1,835,020 1,913,150 4.26%
May 2,295,588 2,408,369 4.91%
Jun 2,759,772 2,877,748 4.27%
Jul 3,256,692 3,319,755 1.94%
Aug 3,742,444 3,780,074 1.01%
Sep 4,214,166
Oct 4,682,566
Nov 5,131,438
Dec 5,636,437
Percent of budget expended 67.06%
Transportation Budget
YTD
Actual
Annual %
over (under)
Jan 340,428 326,959 ‐3.96%
Feb 706,499 694,002 ‐1.77%
Mar 1,247,152 1,046,712 ‐16.07%
Apr 1,619,928 1,531,026 ‐5.49%
May 2,095,850 2,065,482 ‐1.45%
Jun 2,513,261 2,511,785 ‐0.06%
Jul 2,960,840 2,953,908 ‐0.23%
Aug 3,404,337 3,395,218 ‐0.27%
Sep 3,854,060
Oct 4,693,977
Nov 5,071,355
Dec 5,669,897
Percent of budget expended 59.88%
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
Millions Street Maintenance
Budget
Actual
Last Year
$0.0
$1.0
$2.0
$3.0
$4.0
$5.0
$6.0
Millions Transportation
Budget
Actual
Last Year
Page 34 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
Debt Service Budget
YTD
Actual
Annual %
over (under)
Jan 41,377 41,377 0.00%
Feb 291,694 291,694 0.00%
Mar 293,691 293,691 0.00%
Apr 293,691 293,691 0.00%
May 293,691 293,691 0.00%
Jun 859,786 859,786 0.00%
Jul 1,111,163 1,111,163 0.00%
Aug 1,361,480 1,361,480 0.00%
Sep 4,549,972
Oct 5,055,524
Nov 5,561,077
Dec 6,066,629
Percent of budget expended 22.44%
Non‐
Departmental
Other City Budget
YTD
Actual
Annual %
over (under)
Jan 301,517 301,517 0.00%
Feb 531,962 531,962 0.00%
Mar 776,618 776,618 0.00%
Apr 1,072,621 1,072,621 0.00%
May 1,356,243 1,356,243 0.00%
Jun 1,617,036 1,617,036 0.00%
Jul 1,892,140 1,892,140 0.00%
Aug 2,160,209 2,160,209 0.00%
Sep 12,596,663
Oct 13,996,293
Nov 15,395,922
Dec 16,795,551
Percent of budget expended 12.86%
$‐
$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 53,462,764 45,109,789
Sep 69,401,520
Oct 91,243,653
Nov 98,243,043
Dec 112,221,201
Percent of budget expended 24.30%
Note: Operations and Capital
Airport Budget Revenue Expense
Jan 288,895 255,451 164,122
Feb 697,977 475,859 305,251
Mar 1,160,641 696,609 405,972
Apr 1,606,298 933,649 560,448
May 1,968,738 1,172,554 700,195
Jun 2,393,975 1,404,923 836,327
Jul 2,822,454 1,639,436 1,063,741
Aug 3,228,920 1,881,075 1,197,935
Sep 3,781,625
Oct 4,374,658
Nov 4,712,186
Dec 5,688,023
Percent of budget expended 21.06%
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 1,669,761 1,625,803
Sep 1,655,432
Oct 1,851,777
Nov 2,026,038
Dec 2,630,288
Percent of budget expended 61.81%
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