HomeMy WebLinkAbout201706, JuneADMINISTRATIVE SERVICES
DEPARTMENT
M E M O R A N D U M
DATE: August 14, 2017
TO: Armondo Pavone, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: June 2017 Financial Status Report
At the end of June, general governmental revenues show $3.9M or 7.7% over budget. Revenue
source(s) that are higher than expected are: sales tax ($452K); utility taxes ($921K); franchise fees
($133K); gambling taxes ($365K); business & occupation taxes ($1.6M); state shared revenues
($160K); public safety ($101K); seizure funds ($160K), restricted to drug enforcement and not
available for general purposes); interest ($116K); and other miscellaneous ($123K). If we remove
B&O taxes and seizure funds, general governmental revenues are $2.2M or 4.3% over budget.
On the down side, the revenue source(s) that are underperforming the year to date budget are
building permits & development service fees ($179K below) and culture & recreation (118K
below).
General government expenditures showed a favorable variance of $1.9M or 4.3%. See page 10
of report for further expenditure over‐spent explanations.
The attached report provides more detailed discussion of each revenue source and our updated
projections for the year. Please do not hesitate to contact me at x6952 should you have any
questions or any suggestions about the report.
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,204,760 37,038,480 19,534,107 24,103,395 12,719,859 12,807,368 87,509 0.7%
Sales Tax 23,439,266 11,098,681 26,353,246 12,484,301 25,700,400 12,389,135 12,840,694 451,560 3.6%
Sales Tax ‐ Annexation Credit 2,778,858 1,316,375 3,114,762 1,479,116 3,063,280 1,452,991 1,521,790 68,799 4.7%
Criminal Justice Sales Tax 2,484,718 1,178,742 2,701,787 1,297,691 2,679,898 1,279,588 1,346,925 67,337 5.3%
Natural Gas Use Tax 228,899 144,031 184,638 130,626 228,000 161,303 104,951 (56,352) ‐34.9%
Admission Tax 309,790 151,784 262,506 140,840 320,000 163,621 124,158 (39,463) ‐24.1%
Franchise Fees 1,349,154 668,561 1,406,092 703,549 1,330,000 662,339 794,909 132,570 20.0%
Electricity Tax 5,012,962 2,428,025 5,440,139 2,868,127 5,396,019 2,733,939 3,037,311 303,373 11.1%
Natural Gas Utility Tax 1,437,552 936,792 1,327,937 866,072 1,350,900 880,672 1,112,262 231,590 26.3%
Garbage/Solid Waste 638,073 291,342 717,148 335,580 680,000 314,566 293,779 (20,787) ‐6.6%
TV Cable 1,591,866 771,848 1,619,364 778,525 1,645,659 794,520 801,411 6,891 0.9%
Telephone 880,233 485,416 859,868 445,730 714,875 382,537 461,737 79,200 20.7%
Cellular Phone 1,674,355 824,961 1,541,204 796,456 1,521,056 766,979 729,666 (37,312) ‐4.9%
City Utilities 4,183,165 2,041,493 4,206,473 2,034,188 3,941,628 1,914,841 2,329,234 414,393 21.6%
Utility Tax Audit 1,962,092 533,218 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,076,516 2,500,604 1,173,527 2,000,000 937,564 1,302,980 365,416 39.0%
Real Estate Excise Tax 4,595,166 2,039,258 6,121,830 2,826,665 4,420,000 2,068,717 3,593,502 1,524,785 73.7%
Less: CIP REET (1,401,300) (509,815) (2,707,676) (1,413,332) (4,420,000) (2,068,717) (3,593,502) (1,524,785) 73.7%
EMS Levy 936,406 234,102 479,597 479,597 ‐ ‐ ‐ ‐ 0.0%
B&O Taxes ‐ ‐ 6,375,322 4,912,972 6,800,000 3,400,000 6,206,803 2,806,803 82.6%
Less: CIP B&O Taxes ‐ ‐ (2,000,000) (2,000,000) (2,473,974) (1,236,987) (2,473,974) (1,236,987) 100.0%
Business License Fees 3,125,740 1,543,189 1,926,510 1,211,760 1,302,453 707,627 760,349 52,723 7.5%
Less: CIP Business License Fees (2,584,164) (1,275,527) (1,587,627) (1,003,422) (617,016) (337,061) (343,055) (5,994) 1.8%
Animal Licenses and Spec Events Permits 101,743 56,400 102,905 52,178 92,575 49,866 53,664 3,798 7.6%
Building Permits & Development Svc Fees 6,077,055 2,780,238 5,293,563 2,808,493 5,735,368 2,795,383 2,616,096 (179,287) ‐6.4%
Intergovt'l (Grants, State Shared, etc) 4,053,617 2,018,764 3,998,953 2,018,515 4,440,610 1,743,944 1,828,879 84,935 4.9%
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 397,045 994,179 540,590 613,081 349,860 450,424 100,563 28.7%
Culture and Recreation 1,587,878 566,608 1,632,903 697,052 1,750,923 686,967 568,713 (118,254) ‐17.2%
Interfund/Interdept‐Services 3,106,430 1,591,272 3,377,663 1,673,746 4,178,976 2,089,488 2,014,975 (74,513) ‐3.6%
Fines and Penalties 848,052 381,565 901,592 356,194 824,450 353,411 355,552 2,141 0.6%
Photo Enforcement 2,171,184 1,003,547 1,959,071 988,282 2,044,000 985,726 984,006 (1,721) ‐0.2%
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 339,812 1,058,880 346,710 875,300 295,712 411,971 116,259 39.3%
Rents, Leases, and Concessions 762,361 438,102 642,192 347,693 623,195 348,655 339,656 (8,999) ‐2.6%
Contributions and Donations 147,292 60,684 96,582 43,389 115,000 49,076 78,808 29,732 60.6%
Other Miscellaneous 941,127 483,661 956,131 451,228 691,812 329,385 452,807 123,423 37.5%
Other Financing Sources (Transfer ‐In, etc) 270,224 (13,688,087) 2,129,561 6,075 171,196 94,981 94,981 ‐ 0.0%
Total Operating Revenues 119,555,505 58,502,159 125,816,444 64,628,067 102,363,998 50,522,916 54,429,132 3,906,215 7.7%
OPERATING EXPENDITURES
Council 320,877 166,120 358,550 186,176 368,211 190,925 187,856 3,068 1.6%
Executive 1,691,189 687,127 1,778,206 890,444 1,957,671 980,311 963,928 16,383 1.7%
Emergency Management*398,808 195,236 370,832 167,717 609,249 287,314 267,919 19,395 6.8%
City Attorney 1,791,167 908,816 1,983,834 1,004,061 2,163,329 1,096,207 1,038,696 57,511 5.2%
Court Services 2,013,364 994,496 2,075,763 1,021,277 2,220,656 1,094,693 1,072,725 21,968 2.0%
Community and Eco Dvlpmnt Admin 1,183,052 546,093 1,161,330 575,150 1,337,991 639,918 669,673 (29,755) ‐4.6%
Development Services 2,632,264 1,300,030 2,859,410 1,370,849 3,418,745 1,662,709 1,542,242 120,467 7.2%
Economic Development 658,515 326,497 1,004,411 461,549 1,755,838 832,077 435,487 396,590 47.7%
Planning 2,606,551 1,325,058 2,716,214 1,327,179 3,207,796 1,598,387 1,353,531 244,855 15.3%
Finance 3,132,812 1,245,394 3,046,824 1,337,642 3,362,369 1,405,442 1,301,674 103,768 7.4%
City Clerk 1,027,084 404,603 914,251 460,231 1,239,455 552,158 606,380 (54,221) ‐9.8%
Human Resources 1,182,629 560,008 1,193,016 584,313 1,357,317 653,804 592,817 60,987 9.3%
Police 28,144,699 13,735,488 28,891,879 14,026,779 31,280,337 15,225,547 14,779,090 446,457 2.9%
Jail Services 4,142,266 2,073,022 4,704,978 2,352,230 4,850,000 2,402,991 2,402,991 ‐ 0.0%
Fire* 26,138,192 13,264,215 25,349,755 12,658,635 ‐ ‐ ‐ ‐ 0.0%
Community Services Admin 508,766 246,475 585,983 282,185 505,154 243,941 254,219 (10,278) ‐4.2%
Parks 4,411,383 2,010,536 4,445,115 2,027,520 5,179,955 2,361,763 2,138,544 223,219 9.5%
Parks Planning & Natural Resources 808,558 338,895 952,980 394,070 1,181,283 491,525 461,775 29,750 6.1%
Recreation 5,088,483 2,208,240 5,096,236 2,255,376 5,707,355 2,501,339 2,298,110 203,229 8.1%
Human Services 1,225,835 548,427 1,241,169 528,283 1,419,333 619,460 584,702 34,758 5.6%
Neighborhoods, Resources, & Events 958,624 401,711 865,551 392,885 1,201,992 523,578 414,589 108,989 20.8%
Museum 227,094 113,004 229,543 112,304 236,275 116,580 115,602 978 0.8%
Public Works Admin 387,493 193,206 398,796 200,630 406,398 203,557 203,650 (94) 0.0%
Street Maintenance 5,061,723 2,452,514 5,041,509 2,494,337 5,636,437 2,759,772 2,877,748 (117,976) ‐4.3%
Transportation 4,975,059 2,312,208 5,966,281 2,537,694 5,669,897 2,513,261 2,511,785 1,476 0.1%
Debt Service 6,371,715 814,758 6,099,166 936,921 6,066,629 859,786 859,786 ‐ 0.0%
Non‐Departmental and Other 10,069,740 1,632,035 9,883,923 2,637,745 15,795,551 1,617,036 1,617,036 ‐ 0.0%
Total Operating Expenditures 117,157,942 51,004,212 119,215,504 53,224,181 108,135,225 43,434,080 41,552,555 1,881,525 4.3%
Total Ending Fund Balance 19,962,845$ 25,063,230$ 26,563,785$ 31,366,731$ 20,792,558$ 33,652,622$ 39,440,362$ 5,787,741$ 17.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 June 2017
Page 1 of 38
Monthly Financial Report June 2017
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through June 30, 2017. Except as noted,
year‐to‐date budgeted revenues and operating expenditures are generally based on the collection/disbursement patterns for
the same period of the preceding two years. The table on the previous page summarizes the general governmental fund
revenues and expenditures.
Revenues
Taxes
The combined collection of property, sales/use, utility, gambling, admissions, and real estate excise taxes represents 77% of
all resources supporting general governmental activities. The following section provides detail information on property,
sales, utility, and other taxes.
Property Tax
June’s collection is $129K,
making the total year‐to‐date
collection $12.8M or 53.1% 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 $88K or 1% more. The
large variance with the prior year
is due to the formation of the
Renton Regional Fire Authority.
Sales Tax
June 2017 sales tax receipts
totaled $2.1M. Compared with
the same month last year, it is
$52K or 2% less. Compared to
the projected current month’s
budget, it is $108K or 5% above.
The year‐to‐date collection of
$12.8M is $356K or 3% more than
the prior year and is also $452K
or 4% more than budgeted.
Auto, Retail, Wholesale, 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
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,534,107$ 12,719,859$ 12,807,368$ (6,726,739)$ ‐34% 87,509$ 1%
Annual Total 37,038,480$ 24,103,395$
Property Tax Revenues
Year to Date through June
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 ‐
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 12,484,301$ 12,389,135$ 12,840,694$ 356,394$ 3% 451,560$ 4%
Annual Total 26,353,246$ 25,700,400$
2017 vs. Budget2017 vs. 2016
Month
Year to Date through June
Local Retail Sales Tax Revenues
Page 2 of 38
Monthly Financial Report June 2017
The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business
sectors:
Utility tax
June utility tax revenues are
$1.4M, which is $226K or 20%
higher than the same month last
year and is also higher than the
budget by $174K or 15%. The
year‐to‐date collection is $8.9M,
which is $504K or 6% higher than
the prior year and is also $921K
or 12% higher than the budget.
The large January variance with
the budget is due to lower 2015
activity for Electricity and the
timing of when 2015
Cell/Garbage taxes were
recorded. The April variance is
due to collecting higher than
expected Electrical/Natural Gas
and a correction to City Utilities.
The monthly budgets are based on 2015/2016 activity.
The table below breaks out Utility Tax by source.
Sales Tax by Sector 2016 2017 Bgt YTD Act Change 2017/2016 2017 Act vs Bgt
New Construction 1,967,245$ 2,037,853$ 2,062,986$ 95,741$ 5%$ 25,133 1%
Auto Sales 2,379,966 2,263,018 2,365,026 (14,940) ‐1% 102,008 5%
General Retail 3,591,628 3,560,528 3,750,210 158,582 4% 189,682 5%
Manufacturing 875,243 780,048 748,812 (126,431) ‐14% (31,237)‐4%
Wholesale 615,668 661,865 736,136 120,468 20% 74,271 11%
Service 2,760,723 2,778,508 2,818,105 57,382 2% 39,597 1%
Other 293,828 307,315 359,420 65,593 22% 52,105 17%
YTD Total 12,484,301$ 12,389,135$ 12,840,694$ 356,394$ 3%451,560$ 4%
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
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 8,366,531$ 7,949,356$ 8,870,352$ 503,821$ 6% 920,996$ 12%
Annual Total 16,007,999$ 15,478,137$
2017 vs. Budget2017 vs. 2016
Year to Date through June
Utility Tax Revenues
Month
Utility Tax by Type 2016 2017 Bgt YTD Act Change 2017/2016 2017 Act vs Bgt
Electrical 2,868,127$ 2,733,939$ 3,037,311$ 169,185$ 6% $ 303,373 11%
Natural Gas 996,698 1,041,975 1,217,213 220,515 22% 175,238 17%
Cell 796,456 766,979 729,666 (66,790) ‐8% (37,312)‐5%
Phone 445,730 382,537 461,737 16,007 4% 79,200 21%
Cable 778,525 794,520 801,411 22,886 3% 6,891 1%
Garbage/Solid Waste 335,580 314,566 293,779 (41,800) ‐12% (20,787)‐7%
City Utilities 2,034,188 1,914,841 2,329,234 295,045 15% 414,393 22%
Utility Tax Audit 111,227 ‐ ‐ (111,227) 0% ‐ N/A
YTD Total 8,366,531$ 7,949,356$ 8,870,352$ 503,821$ 6%920,996$ 12%
Annual Total 16,007,999$ 15,478,137$
YTD as % of 52% 51%
Page 3 of 38
Monthly Financial Report June 2017
Other Taxes
Real Estate Excise Tax
The City collected $748K in Real
Estate Excise Tax revenues (REET)
for June. This is $342K or 84%
more than the same month last
year and is also $401K or 116%
more than the current month’s
budget. The year‐to‐date
collection is $3.6M, which is
$767k or 27% more than the prior
year and is also $1.5M or 74%
above the budget. The higher
than expected variance is due to
16 large transactions in
December, January, February,
March, April, and May which
accounts for $1.3M of the total
REET collected.
Gambling Tax
June’s Gambling Tax collections
totaled $233K, which is $48k or
26% above the same month last
year and is also above the current
month’s budget by $83K or 56%.
The year‐to‐date total of $1.3M is
$129K or 11% above the prior
year and is also $365K or 39%
above budget.
Franchise Fees
Franchise Fees are due quarterly
in January, April, July, and
October. The year‐to‐date total
of $795K is $91K or 13% higher
than the prior year and is also
$133K or 20% 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
Aug 759,583 484,354
Sep 522,472 401,943
Oct 559,552 434,871
Nov 502,139 266,351
Dec 307,382 265,838
YTD Total 2,826,665$ 2,068,717$ 3,593,502$ 766,837$ 27% 1,524,785$ 74%
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 June
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 ‐
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,173,527$ 937,564$ 1,302,980$ 129,453$ 11% 365,416$ 39%
Annual Total 2,500,604$ 2,000,000$
Gambling Tax Revenue
Month
Year to Date through June
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 ‐
Sep 5,000 2,414 ‐
Oct 348,783 332,455 ‐
Dec 4,850 2,341 ‐
YTD Total 703,549$ 662,339$ 794,909$ 91,360$ 13% 132,570$ 20%
Annual Total 1,406,092$ 1,330,000$
Franchise Fees Revenue
Year to Date through June
Month
2017 vs. 2016 2017 vs. Budget
Page 4 of 38
Monthly Financial Report June 2017
Admission Tax
Admission Tax returns are due
quarterly in January, April, July,
and October of each year. April
2017 collections represent
activities conducted during the
1st quarter of 2017. The year‐to‐
date collection of $124K is $17K
or 12% less than the prior year
and is also $39K or 24% less than
the budget.
Business & Occupation Tax
Business and Occupation (B&O)
Tax is a new revenue source for
the City in 2016. It was adopted
by the Council in the 2015/2016
biennial budget. Businesses with
gross receipts of $1.5M or more
per year, earned within the City
of Renton, will be required to file
and pay B&O tax, in lieu of the
Per Employee Fee, which is
currently reported as Business
License revenue. Year‐to‐date
receipts totaled $6.2M. The
monthly budgets are based on
large business quarterly
reporting with smaller business
annual reporting.
Licenses and Permits
Business Licenses
Business Licenses totaled $36K
for June, which is $9K or 35%
above the same month last year
and is also $23K or 170% above
the current month’s budget. The
year‐to‐date Business Licenses
revenue of $760K is $451K or
37% below the prior year but is
above the budget by $53K or 7%.
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 ‐
Sep 518 289 ‐
Oct 58,934 74,983 ‐
Nov 1,452 831 ‐
YTD Total 140,840$ 163,621$ 124,158$ (16,682)$ ‐12% (39,403)$ ‐24%
Annual Total 262,506$ 320,000$
2017 vs. Budget
Admission Tax Revenue
Year to Date through June
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 ‐
Aug 334,807 170,000 ‐
Sep 10,779 170,000 ‐
Oct 603,622 1,360,000 ‐
Nov 136,933 170,000 ‐
Dec ‐ 170,000 ‐
YTD Total 4,912,972$ 3,400,000$ 6,206,803$ 1,293,831$ 26% 2,806,803$ 83%
Annual Total 6,375,322$ 6,800,000$
*Total Business & Occupation Taxes (GF & CIP)
Business & Occupation Taxes*
Year to Date through June
Month
2017 vs. 2016 2017 vs. Budget
2016 2017 2017
ActualBudgetActual $%$%
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 ‐
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,211,760$ 707,627$ 760,349$ (451,411)$ ‐37% 52,723$ 7%
Annual Total 1,926,510$ 1,302,453$
*Total Business License (GF & CIP)
2017 vs. 2016
Year to Date through June
2017 vs. Budget
Business Licenses*
Month
Page 5 of 38
Monthly Financial Report June 2017
Building Permits and
Development Service Fees
Building Permits and
Development Service Fee
revenues totaled $611K in June.
The year‐to‐date revenues of
$2.6M is $192K or 7% less than
the year before and is also $179K
or 6% lower than budget. The
large variances in
January/February 2016 is due to
large payments for building
permits and plan review
(Southport Developer and Group
Health). The large variance in
May 2017 is due to large
payments for building permits
(Renton School District and
Valley Medical Center)
Intergovernmental
These revenue sources
include federal (direct and
indirect) grants, state
grants, state shared
revenues, local grants, and
entitlements. State shared
revenues 93% of the total
revenues in this category.
The year‐to‐date total
Intergovernmental
revenue is $3.3M or 45% of
the budget.
State Shared Revenues
State Shared Revenue
collections totaled $2.9M
since the start of the year.
Compared to the prior
year, State Shared
Revenues are above by
$56K or 2%. Compared to
the projected budget, the
City is collecting $160K or
6% more. The higher than
expected collection is due
to collecting more than
anticipated Criminal
Justice’s Sales Tax,
Marijuana Enforcement,
and Liquor Excise Tax.
2016 2017 2017
ActualBudgetActual $%$%
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
Aug 397,578 438,730
Sep 380,480 498,572
Oct 479,048 478,350
Nov 297,449 359,940
Dec 468,303 472,668
YTD Total 2,808,493$ 2,795,383$ 2,616,096$ (192,397)$ ‐7% (179,287)$ ‐6%
Annual Total 5,293,563$ 5,735,368$
Year to Date through June
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 2,892,162 2,788,637 2,948,390 56,228 2% 159,753 6%
Federal Grants 240,001 65,665 65,665 (174,336) ‐73%‐ 0%
State Grants 39,421 22,246 22,246 (17,175) ‐44%‐ 0%
Other Grants/Intgovt 624,219 146,984 139,503 (484,716) ‐78% (7,481) ‐5%
ARRA Grants ‐ ‐ ‐ ‐ N/A ‐ N/A
Total Rev YTD 7,149,225$ 3,194,501$ 3,346,773$ (3,802,452)$ ‐53%152,272$ 5%
Total Rev Annual 10,698,115$ 7,462,447$
YTD % 67% 43% 45%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
2016 2017 2017
Actual Budget Actual $ % $ %
Crim Just Sales Tax 1,297,691$ 1,279,588$ 1,346,925$ 49,234$ 4% 67,337$ 5%
Judicial Contribution 12,200 ‐ ‐ (12,200) 0%‐ N/A
Crim Just ‐ High Crime 155,458 124,759 135,448 (20,010) ‐13% 10,688 9%
Crim Just ‐ Pop 13,231 11,892 14,011 780 6% 2,119 18%
Crim Just ‐ Spec Prog 48,378 44,223 50,973 2,595 5% 6,751 15%
State DUI 7,700 9,319 7,725 25 0% (1,594) ‐17%
Marijuana Enforcement 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 234,988 212,072 247,760 12,772 5% 35,687 17%
Fuel Tax 692,185 681,574 694,008 1,822 0% 12,433 2%
YTD Total 2,892,162$ 2,788,637$ 2,948,390$ 56,228$ 2% 159,753$ 6%
Annual Total 5,933,890$ 5,805,528$
State Shared Revenues
2017 vs. 2016
Revenue
Year to Date through June
2017 vs. Budget
Page 6 of 38
Monthly Financial Report June 2017
Charges for Services
These revenue sources consist of general government, public safety, plan review and inspection, culture and recreation, and
interfund/interdepartmental sales and services. Recreation and interfund/interdepartmental sales and services constitute
63% of the total revenue in this category. The year‐to‐date total charges for services are $4.1M or 47% of the budget. The
following sections provide detail information for Public Safety, Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totaled
$450K 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 $90K or 17%
less. Compared to the year‐to‐
date budget, the City is over
budget by $101K or 29%. 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
$153K for the current month.
Compared to the same month
the prior year, the City collected
$86K or 36% less. Compared to
the projected monthly budget,
the City collected $101K or 40%
less. The year‐to‐date collection
of $569K is $128K or 18% lower
than the year before and is also
$118K or 17% 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 ‐
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 540,590$ 349,860$ 450,424$ (90,166)$ ‐17% 100,563$ 29%
Annual Total 994,179$ 613,081$
2017 vs. Budget
Month
2017 vs. 2016
Year to Date through June
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 ‐
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 697,052$ 686,967$ 568,713$ (128,339)$ ‐18% (118,254)$ ‐17%
Annual Total 1,632,903$ 1,750,923$
2017 vs. Budget2017 vs. 2016
Month
Recreation
Year to Date through June
Page 7 of 38
Monthly Financial Report June 2017
Interfund Services
The year‐to‐date collections for
Interfund Services revenues are
$2M. Compared to the prior
year, the revenues are over by
$341K or 20%. Compared to the
projected budget, the revenues
are below by $75K 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.3M. This is $5K lower than a
year ago but is right on target
with 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 ‐
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,673,746$ 2,089,488$ 2,014,975$ 341,229$ 20% (74,513)$ ‐4%
Annual Total 3,377,663$ 4,178,976$
2017 vs. Budget
Month
Interfund Services
Year to Date through June
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
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,344,477$ 1,339,137$ 1,339,558$ (4,919)$ 0% 421$ 0%
Annual Total 2,860,662$ 2,868,450$
Month
2017 vs. Budget2017 vs. 2016
Year to Date through June
Fines and Penalties by Month
Year to Date through June
2016 2017 2017
Actual Budget Actual $ % $ %
Civil Penalties 961$ 2,231$ 1,017$ 57$ 6% (1,214)$ ‐54%
Civil Infraction Penalties 150,025 146,776 148,198 (1,827) ‐1% 1,423 1%
Civil Parking Infraction Penalties 71,319 98,473 75,184 3,865 5% (23,289) ‐24%
Photo Enforcement Program 988,282 985,726 984,006 (4,277) 0% (1,721) 0%
Criminal Traffic Misdemeanor Fines 31,415 29,752 32,216 800 3% 2,464 8%
Criminal Non‐Traffic Fines 16,019 28,368 40,447 24,429 153% 12,080 43%
Criminal Costs 43,394 41,028 38,258 (5,136) ‐12% (2,769) ‐7%
Non‐Court Fines, Forfeitures and Penalties 43,061 6,784 20,231 (22,830) ‐53% 13,448 198%
YTD Total 1,344,477$ 1,339,137$ 1,339,558$ (4,919)$ 0% 421$ 0%
Annual Total 2,860,662$ 2,868,450$
Revenue
2017 vs. Budget
Fines and Penalties by Type
2017 vs. 2016
Page 8 of 38
Monthly Financial Report June 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 $984K.
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.2M.
Compared to last year, the
revenues are below by $460K or
28%. Compared to the projected
year‐to‐date budget, the
revenues are over by $354K or
43%. 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 ‐ 89,775 ‐ ‐
Aug 183,427 ‐ 89,775 ‐ ‐
Sep 164,770 ‐ 89,775 ‐ ‐
Oct 175,856 ‐ 89,775 ‐ ‐
Nov 185,108 ‐ 89,775 ‐ ‐
Dec 204,263 ‐ 89,775 ‐ ‐
YTD Total 985,726$ 984,006$ 538,649$ 503,383$ 480,623$
Annual Total 2,044,000$ 1,077,297$
1Actuals of Revenues and Expenses
Photo Enforcement Program
Year to Date through June
Month
Revenues Expenses
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 258,876$ 210,344$ 363,997$ 105,122$ 41% 153,653$ 73%
Feb 802,908 114,483 148,988 (653,920) ‐81% 34,505 30%
Mar 125,950 123,697 150,954 25,004 20% 27,257 22%
Apr 142,439 107,529 188,887 46,448 33% 81,357 76%
May 139,504 116,445 152,678 13,174 9% 36,233 31%
Jun 174,848 157,799 179,152 4,304 2% 21,353 14%
Jul 181,285 159,920
Aug 294,665 159,680
Sep 160,616 120,231
Oct 152,817 126,118
Nov 327,568 103,917
Dec 425,765 368,952
YTD Total 1,644,525$ 830,299$ 1,184,657$ (459,868)$ ‐28% 354,358$ 43%
Annual Total 3,187,241$ 1,869,117$
Year to Date through June
Month
2017 vs. Budget2017 vs. 2016
Miscellaneous Revenues by Month
2016 2017 2017
Actual Budget Actual $ % $ %
Interests and Other Earnings 346,710$ 295,712$ 411,971$ 65,261$ 19% 116,259$ 39%
Rents, Leases, and Concessions 347,693 348,655 339,656 (8,038) ‐2% (8,999) ‐3%
Contributions/Donations from Private Sources 43,389 49,076 78,808 35,419 82% 29,732 61%
Other 243,590 136,856 194,248 (49,341) ‐20% 57,392 42%
Seizure Funds ‐ Federal/State/Local 663,143 ‐ 159,974 (503,169) ‐76% 159,974 100%
YTD Total 1,644,525$ 830,299$ 1,184,657$ (459,868)$ ‐28% 354,358$ 43%
Annual Total 3,187,241$ 1,869,117$
2017 vs. Budget
Miscellaneous Revenues by Type
Year to Date through June
Revenue
2017 vs. 2016
Page 9 of 38
Monthly Financial Report June 2017
EXPENSES
Overall the City has expended 38% of its budgeted general governmental expenditures at the end of June. This is $1.9M or
4.3% 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 $117K or
2.1%. This is mainly due to overspending on supplies ($59K), back billing of Surface Water utility (rate increase portion only,
$29K), and interfund payments to other Maintenance sections ($37K).
Page 10 of 38
Monthly Financial Report June 2017
CASH AND INVESTMENTS –
2ND QUARTER
The current cash and
investments (C&I)
portfolio is provided in
the table to the right.
The City’s current C&I
balance is $191M.
Currently, the majority
of the portfolio is
located in cash deposits
(US Bank) and the State
Investment Pool. The
rest is spread out
between US Federal
Agency Securities and
various certificates of
deposits.
The existing portfolio yield is approximately 0.88%.
Current %
Blended
Allowed
per policy
Current Portfolio
(principal value)
34% N/A $ 64,387,155
0% 100%‐$
40% 75% 75,433,080$
10% 75% 19,753,905$
16% 75% 31,306,761$
0% 25%‐$
TOTAL INVESTMENTS 100% 190,880,902$
*Excluding Cash the portfolio distribution is 60% LGIP; 25% CD's; 15% GSE's
By Type
Cash
US Treasury Securities
Local Government Investment Pool
US Federal Agency Securities
Certificates of Deposit
Commercial Paper
Cash
34%
LGIP
40%
GSE's
10%
CD's
16%
Distribution by Type
By Institution Current %
Blended
Allowed by
Policy
Current Portfolio
(principal value)Maturity Date APY
Weighted
Yield
Blended
Current
Principal
Balance
Cash US Bank ‐ Cash 34%N/A 64,387,155 overnight 0.45% 0.15%64,387,155
US Treasury Securities
none 0%100%‐ N/A N/A N/A
‐
Local Government Investment Pool
3920 State Investment Pool 40%75%75,433,080 10/1/2014 0.10% 0.39%75,433,080
US Federal Agency Securities *
314179A FHLB 1,996,920 8/11/2017 1.05%0.01%
315189D FNMA 4,997,500 10/26/2018 1.06%
0.03%
314179G FHLB 5,009,485 10/17/2017 0.93%0.02%
317209A FHLMC 2,750,000 4/27/2020 1.58%
0.02%
317209B FHLMC 1,950,000 4/27/2020 1.63%0.02%
317209C FHLMC 3,050,000 5/22/2020 1.63%
0.03%
Certificates of Deposit
115184A First Savings Bank Northwest 5,092,087 2/6/2018 1.03%
0.03%
116214A First Savings Bank Northwest 5,154,418 2/3/2021 1.67%0.05%
114174A First Savings Bank Northwest 5,000,000 10/29/2017 1.15%
0.03%
116191A Opus 5,000,000 2/25/2019 1.00%0.03%
116181A Opus 5,000,000 12/21/2018 1.35%
0.04%
116191B Opus 5,000,000 12/21/2019 1.60%
0.04%
216183A Commencement Bank (CDARS)1%1,060,257 9/16/2018 1.00%0.01%1,060,257
Commercial Paper
none 0.00%5%‐ N/A N/AN/A ‐
190,880,902$ 190,880,902$
15,246,504
*Held in our safekeeping account at BNY Trust and Custody
TOTAL CASH & INVESTMENTS
20%
8%
15,000,000 8%
19,753,905 75%10%
Page 11 of 38
Monthly Financial Report June 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 ‐ ‐ ‐ ‐ 43,200 22,500 ‐
Grants / intergovernmental 5,788 ‐ 31,780 ‐ 690,270 346,048 ‐
Charges for services 68,368 781,639 8,850,867 7,421,918 5,148,583 5,741,888 8,339,762
Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐
Fines and penalties 450 ‐ ‐ ‐ 968 ‐ ‐
Rents, leases, and misc fees 1,319,312 163,216 11,857 98,323 ‐ ‐ ‐
Interest and other misc 11,004 605 38,380 341,594 902,459 381,130 17,484
TOTAL REVENUES 1,404,922 945,460 8,932,884 7,861,835 6,785,480 6,491,566 8,357,246
EXPENSES:
Utility billing ‐ ‐ 23,267 79,182 62,348 95,521 ‐
Utility systems ‐ ‐ 8,214,483 1,758,266 1,711,593 2,130,758 ‐
Utility maintenance ‐ ‐ 163,633 2,749,112 1,060,040 1,381,418 7,004,456
Transportation 779,019 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 1,084,933 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 779,019 1,084,933 8,401,383 4,586,560 2,833,981 3,607,697 7,004,456
AMOUNT AVAILABLE FOR DEBT SERVICE 625,903 (139,473) 531,501 3,275,275 3,951,499 2,883,869 1,352,790
DEBT SERVICE:
Principal ‐ ‐ ‐ 395,175 ‐ ‐ ‐
Interest ‐ ‐ ‐ 207,051 93,469 350,108 ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ 602,226 93,469 350,108 ‐
CAPITAL PROJECTS 57,308 66,995 ‐ 1,511,297 1,336,215 750,986 ‐
TRANSFERS IN/(OUT)‐ ‐ (370) (433) (1,205) (370) ‐
CHANGE IN FUND BALANCE 568,595 (206,468) 531,131 1,161,319 2,520,610 1,782,405 1,352,790
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, Jun 30 3,187,938 (169,380) 3,282,548 29,690,253 16,380,272 12,676,380 6,347,448
Page 12 of 38
Monthly Financial Report June 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 ‐ 100,928 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ 7,110 ‐ ‐ ‐ ‐ 47,440
Charges for services
Equipment rental m&o 1,355,353 2,125,209 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ ‐ ‐ 219,657 ‐ ‐ ‐
Communications ‐ 397,251 ‐ 318,958 ‐ ‐ ‐
Facilities ‐ ‐ 2,511,510 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ ‐ ‐ ‐ ‐ ‐ ‐
IT service co ntracts ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest and other misc 23,119 9,521 5,240 1,949 43,497 15,301 35,800
Internal service fund misc:
Vehicle / equipment capital recovery 1,106,999 241,988 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 858,162 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 678,142 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 4,621,831 1,312,340
Other misc 201 47 4,442 10 ‐ 457,542 ‐
Interfund Loan ‐ ‐ ‐ ‐ ‐ ‐ ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets 52,456 ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 102,656 ‐ ‐
TOTAL REVENUES 2,538,128 2,882,054 2,521,192 540,574 1,682,457 5,094,674 1,395,580
EXPENSES:
Communications 294,585
Equipment rental 1,150,430
Facilities 2,154,765
Healthcare 4,666,140
Information technology 2,124,533
Print and mail 198,998
Retiree healthcare 430,835
Risk management:
Risk management 574,037
Unemployment 29,994
Worker's compensation 813,926
TOTAL EXPENSES 1,150,430 2,124,533 2,154,765 493,583 1,417,957 4,666,140 430,835
AMOUNT AVAILABLE FOR CAPITAL 1,387,698 757,521 366,427 46,991 264,500 428,534 964,745
CAPITAL PROJECTS 1,423,826 267,070 7,640 ‐ ‐ ‐ ‐
TRANSFERS IN ‐ 2,484 ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ (89,876) ‐
CHANGE IN FUND BALANCE (36,128) 492,935 358,787 46,991 264,500 338,658 964,745
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, Jun 30 6,395,925 3,063,309 1,633,840 589,918 13,117,009 4,494,806 11,043,996
Page 13 of 38
Monthly Financial Report June 2017
FUND BALANCE
Page 15 shows the ending fund balance as of June 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 June, the City has $39.4M 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.9M from the
year’s beginning balance. June’s ending fund balance is over the anticipated General Governmental Fund Balance of $33.7M
by $5.8M or 17.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 14 of 38
Monthly Financial Report June 2017
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through June 30, 2017
Funds
Balance
01/01/2017
Budgeted
Revenue
Revenue
06/30/17
Total Funds
Available
Budgeted
Expenditure
Expenditure
06/30/17 Ending Balance
GENERAL GOVERNMENT FUNDS: 26,563,785 102,363,998 54,429,132 80,992,917 108,135,226 41,552,555 39,440,362
000 General 18,201,028 69,622,089 38,204,818 56,405,846 75,673,977 29,549,139 26,856,707
001 Community Services 3,769,766 13,482,904 6,745,087 10,514,853 13,682,477 5,527,089 4,987,763
003 Street 1,936,367 11,885,024 6,367,961 8,304,328 11,306,335 5,389,533 2,914,795
004 Community Dev Block Grant 66,654 1,068,770 413 67,067 1,076,270 71,257 (4,190)
005 Museum 72,372 233,936 117,147 189,519 236,275 115,602 73,917
009 Farmers Market 90,730 95,950 41,031 131,761 93,263 40,148 91,612
011 Fire Health & Wellness ‐ ‐ ‐ ‐ ‐ ‐ ‐
201 Ltd GO Bonds Gen Govt Debt 852,111 1,749,675 878,516 1,730,627 1,749,675 41,925 1,688,702
215 Gen Govt Misc Debt Service 1,574,757 4,225,650 2,074,160 3,648,917 4,316,954 817,861 2,831,056
SPECIAL REVENUE FUNDS:1,599,965 1,974,729 1,130,522 2,730,487 2,116,614 447,654 2,282,833
102 Arterial Street 63,480 660,000 327,270 390,750 660,000 ‐ 390,750
108 Leased City Properties 276,865 902,550 590,644 867,509 839,996 310,866 556,643
110 Hotel Motel 402,602 265,000 125,040 527,642 375,994 102,166 425,476
125 1% For Art 128,489 24,505 438 128,927 117,950 ‐ 128,927
127 Cable Communication 394,504 122,674 85,993 480,497 122,674 34,622 445,875
135 Springbrook Wetlands Bank 334,025 ‐ 1,137 335,162 ‐ ‐ 335,162
CAPITAL PROJECT FUNDS (CIP):26,202,403 34,585,139 12,575,902 38,778,305 45,620,731 6,286,446 32,491,859
303 Community Dev Mitigation 1,255,194 406,014 172,492 1,427,686 ‐ ‐ 1,427,686
304 Fire Mitigation 607,163 99,000 363,215 970,378 158,696 ‐ 970,378
305 Transportation Mitigation 1,497,748 620,000 445,272 1,943,020 1,855,000 ‐ 1,943,020
316 Municipal Facilities CIP 15,038,030 13,650,632 6,753,128 21,791,158 19,147,133 989,375 20,801,783
317 Transportation CIP 5,640,494 18,309,493 4,834,990 10,475,484 23,434,675 5,000,296 5,475,188
326 Housing Opportunity 1,041,173 1,500,000 3,546 1,044,719 ‐ ‐ 1,044,719
336 New Library Development 1,122,601 ‐ 3,259 1,125,860 1,025,227 296,775 829,085
ENTERPRISE FUNDS: 63,685,077 89,985,148 40,820,540 104,505,617 120,529,012 33,110,155 71,395,462
402 Airport 1,577,038 495,754 256,002 1,833,040 1,735,630 716,225 1,116,815
422 Airport Capital 1,042,305 2,910,088 1,148,921 2,191,226 3,952,393 120,102 2,071,124
4X2 Airport Operating & CIP 2,619,343 3,405,842 1,404,923 4,024,266 5,688,023 836,327 3,187,939
403 Solid Waste Utility 2,751,417 19,187,851 8,932,884 11,684,301 19,024,775 8,401,753 3,282,548
4X4 Golf Operating & CIP 37,088 2,893,044 975,460 1,012,548 2,630,288 1,181,929 (169,381)
4X5 Water Operating & CIP 28,528,934 17,180,526 7,861,836 36,390,770 35,347,154 6,700,514 29,690,256
4X6 Waste Water Operating & CIP 13,859,662 13,264,936 6,796,625 20,656,287 20,537,816 4,276,016 16,380,271
416 King County Metro 4,994,658 17,505,693 8,357,246 13,351,904 17,505,693 7,004,456 6,347,448
4X7 Surface Water Operating & CIP 10,893,975 16,547,256 6,491,566 17,385,541 19,795,263 4,709,160 12,676,381
INTERNAL SERVICE FUNDS:37,908,315 34,753,373 16,657,143 54,565,458 33,465,387 14,226,653 40,338,805
501 Equipment Repair/Replacement 6,432,053 6,480,853 2,538,128 8,970,181 7,684,613 2,574,256 6,395,925
502 Insurance 12,852,509 7,392,368 1,682,457 14,534,966 3,571,166 1,417,956 13,117,010
503 Information Services 2,570,374 5,731,776 2,884,538 5,454,912 6,835,636 2,391,603 3,063,309
504 Facilities 1,275,053 5,027,015 2,521,192 3,796,245 5,094,433 2,162,405 1,633,840
505 Communications 542,927 1,078,253 540,574 1,083,501 1,076,474 493,583 589,918
512 Insurance, Healthcare 4,156,148 7,787,779 5,094,674 9,250,822 8,163,471 4,756,015 4,494,807
522 Insurance, Leoff1 Retirees HC 10,079,251 1,255,329 1,395,580 11,474,831 1,039,594 430,835 11,043,996
FIDUCIARY FUNDS:5,578,045 468,000 163,841 5,741,886 210,475 114,197 5,627,689
611 Firemen's Pension 5,578,045 468,000 163,841 5,741,886 210,475 114,197 5,627,689
TOTAL FUNDS 161,537,590 264,130,387 125,777,080 287,314,670 310,077,445 95,737,660 191,577,010
Page 15 of 38
City of Renton
General Government Financial Position
2017 Budget Year
General Government Summary
Revenues Expenditures
$ Difference
over (under)
w/beginning
balance
26,563,785
January 7,364,146 6,595,136 769,010 27,332,795
February 14,472,917 13,388,134 1,084,783 27,648,568
March 21,057,303 20,198,065 859,238 27,423,023
April 39,230,543 27,006,711 12,223,832 38,787,617
May 47,996,932 34,253,900 13,743,032 40,306,817
June 54,429,132 41,552,555 12,876,577 39,440,362
July
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 16 of 38
City of Renton
Monthly Revenue Analysis ‐ 2017 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,149,770 7,364,146 3.00%
Feb 13,647,736 14,472,917 6.05%
Mar 20,098,332 21,057,303 4.77%
Apr 32,959,305 39,230,543 19.03%
May 44,302,145 47,996,932 8.34%
Jun 50,522,916 54,429,132 7.73%
Jul 58,021,318
Aug 64,764,749
Sep 71,132,060
Oct 82,492,610
Nov 95,329,881
Dec 102,363,998
Percent of budget 53.17%
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
Aug 12,870,217
Sep 13,238,047
Oct 17,341,593
Nov 23,988,632
Dec 24,103,395
Percent of budget 53.14%
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
$120
$130
Millions
Total Revenue
General Government
Budget
Actual
Last Year
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
$36
$39
Millions Property Tax
Budget
Actual
Last Year
Page 17 of 38
City of Renton
Monthly Revenue Analysis ‐ 2017 Budget Year
Sales Tax Budget
YTD
Actual
Annual %
over (under)
Jan 2,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
Aug 18,663,293
Sep 21,097,526
Oct 23,629,240
Nov 26,285,407
Dec 28,763,680
Percent of budget 49.93%
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
Aug 10,453,523
Sep 11,680,525
Oct 12,932,675
Nov 14,139,633
Dec 15,478,137
Percent of budget 57.31%
Note: Includes Natural Gas Use Tax.
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
Millions Sales Tax
Budget
Actual
Last Year
$‐
$2
$4
$6
$8
$10
$12
$14
$16
Millions Utility Tax
Budget
Actual
Last Year
Page 18 of 38
City of Renton
Monthly Revenue Analysis ‐ 2017 Budget Year
Licenses &
Permits Budget
YTD
Actual
Annual %
over (under)
Jan 586,132 321,764 ‐45.10%
Feb 956,756 594,059 ‐37.91%
Mar 1,322,363 1,019,840 ‐22.88%
Apr 1,688,572 1,318,141 ‐21.94%
May 1,961,934 1,825,961 ‐6.93%
Jun 2,264,302 2,301,827 1.66%
Jul 2,972,183
Aug 3,368,015
Sep 3,791,878
Oct 4,274,238
Nov 4,532,625
Dec 4,815,012
Percent of budget 47.81%
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,688,923
Aug 4,452,153
Sep 5,101,357
Oct 5,589,178
Nov 6,374,481
Dec 7,462,447
Percent of budget 44.85%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
$‐
$2
$4
$6
$8
$10
$12
Millions
Intergovernmental
Budget
Actual
Last Year
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
Millions Licenses & Permits
Budget
Actual
Last Year
Page 19 of 38
City of Renton
Monthly Revenue Analysis ‐ 2017 Budget Year
Charges for
Services Budget
YTD
Actual
Annual %
over (under)
Jan 641,725 749,576 16.81%
Feb 1,192,622 1,295,589 8.63%
Mar 1,779,728 2,031,739 14.16%
Apr 2,574,617 2,607,404 1.27%
May 3,142,189 3,347,586 6.54%
Jun 4,270,357 4,077,898 ‐4.51%
Jul 5,207,148
Aug 6,077,059
Sep 6,705,746
Oct 7,327,762
Nov 7,947,988
Dec 8,677,538
Percent of budget 46.99%
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
Aug 1,810,632
Sep 2,043,253
Oct 2,287,023
Nov 2,557,964
Dec 2,868,450
Percent of budget 46.70%
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
Millions Charges for Services
Budget
Actual
Last Year
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
Millions Fines & Forfeits
Budget
Actual
Last Year
Page 20 of 38
City of Renton
Monthly Revenue Analysis ‐ 2017 Budget Year
Other Taxes Budget
YTD
Actual
Annual %
over (under)
Jan 1,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
Aug 5,805,828
Sep 6,075,201
Oct 7,571,990
Nov 7,846,056
Dec 8,155,026
Percent of budget 74.10%
Misc Budget
YTD
Actual
Annual %
over (under)
Jan 210,344 363,997 73.05%
Feb 324,828 512,986 57.93%
Mar 448,525 663,940 48.03%
Apr 556,054 852,826 53.37%
May 672,500 1,005,505 49.52%
Jun 830,299 1,184,657 42.68%
Jul 990,219
Aug 1,149,899
Sep 1,270,130
Oct 1,396,247
Nov 1,500,165
Dec 1,869,117
Percent of budget 63.38%
$‐
$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 21 of 38
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 99,864
Aug 114,131
Sep 128,397
Oct 142,663
Nov 156,930
Dec 171,196
Percent of budget 55.48%
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
Aug 3,050,997
Sep 3,452,940
Oct 3,887,811
Nov 4,154,162
Dec 4,420,000
Percent of budget 81.30%
$‐
$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 22 of 38
City of Renton
Monthly Revenue Analysis ‐ 2017 Budget Year
Bldg Permits &
Devlpmt Svc
Fees Budget
YTD
Actual
Annual %
over (under)
Jan 481,500 399,548 ‐17.02%
Feb 861,115 676,844 ‐21.40%
Mar 1,301,962 1,180,134 ‐9.36%
Apr 1,786,635 1,445,882 ‐19.07%
May 2,096,984 2,004,656 ‐4.40%
Jun 2,795,383 2,616,096 ‐6.41%
Jul 3,487,109
Aug 3,925,839
Sep 4,424,411
Oct 4,902,760
Nov 5,262,700
Dec 5,735,368
Percent of budget 45.61%
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
Aug 4,930,000
Sep 5,100,000
Oct 6,460,000
Nov 6,630,000
Dec 6,800,000
Percent of budget 91.28%
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
Millions Building Permits and Development Service
Fees
Budget
Actual
Last Year
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
$5.50
$6.00
$6.50
$7.00
Millions Business & Occupation Tax
Budget
Actual
Last Year
Page 23 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 6,922,649 6,595,136 ‐4.73%
Feb 13,866,897 13,388,134 ‐3.45%
Mar 21,370,450 20,198,065 ‐5.49%
Apr 28,303,146 27,006,711 ‐4.58%
May 35,643,471 34,253,900 ‐3.90%
Jun 43,434,080 41,552,555 ‐4.33%
Jul 61,378,159
Aug 70,614,851
Sep 79,814,188
Oct 89,066,826
Nov 97,712,050
Dec 108,135,225
Percent of budget expended 38.43%
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
Aug 249,074
Sep 278,319
Oct 308,035
Nov 337,502
Dec 368,211
Percent of budget expended 51.02%
$‐
$20
$40
$60
$80
$100
$120
Millions
Total Expenditures
General Government
Budget
Actual
Last Year
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
$400,000
Legislative
Budget
Actual
Last Year
Page 24 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
Executive Budget
YTD
Actual
Annual %
over (under)
Jan 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
Aug 1,283,513
Sep 1,468,126
Oct 1,611,032
Nov 1,754,366
Dec 1,957,671
Percent of budget expended 49.24%
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
Aug 399,866
Sep 448,780
Oct 492,637
Nov 535,475
Dec 609,249
Percent of budget expended 43.98%
$‐
$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 25 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
City Attorney Budget
YTD
Actual
Annual %
over (under)
Jan 176,840 168,105 ‐4.94%
Feb 356,198 333,751 ‐6.30%
Mar 539,974 508,012 ‐5.92%
Apr 727,889 694,752 ‐4.55%
May 911,796 866,583 ‐4.96%
Jun 1,096,207 1,038,696 ‐5.25%
Jul 1,281,325
Aug 1,466,602
Sep 1,658,357
Oct 1,826,387
Nov 1,995,101
Dec 2,163,329
Percent of budget expended 48.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
Aug 1,465,440
Sep 1,656,123
Oct 1,839,864
Nov 2,023,061
Dec 2,220,656
Percent of budget expended 48.31%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
$2.00
$2.20
Millions Court Services
Budget
Actual
Last Year
$‐
$0.40
$0.80
$1.20
$1.60
$2.00
$2.40
Millions City Attorney
Budget
Actual
Last Year
Page 26 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
CED Admin Budget
YTD
Actual
Annual %
over (under)
Jan 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
Aug 909,108
Sep 1,015,431
Oct 1,121,287
Nov 1,226,753
Dec 1,337,991
Percent of budget expended 50.05%
Development
Services Budget
YTD
Actual
Annual %
over (under)
Jan 257,513 239,337 ‐7.06%
Feb 545,696 501,405 ‐8.12%
Mar 827,936 754,102 ‐8.92%
Apr 1,095,705 1,024,029 ‐6.54%
May 1,376,992 1,282,903 ‐6.83%
Jun 1,662,709 1,542,242 ‐7.25%
Jul 1,943,507
Aug 2,237,392
Sep 2,540,782
Oct 2,826,404
Nov 3,109,526
Dec 3,418,745
Percent of budget expended 45.11%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
Millions
Community & Economic
Development Admin
Budget
Actual
Last Year
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions
Development Services
Budget
Actual
Last Year
Page 27 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
Economic
Development Budget
YTD
Actual
Annual %
over (under)
Jan 98,578 46,869 ‐52.46%
Feb 243,727 98,329 ‐59.66%
Mar 357,073 140,672 ‐60.60%
Apr 544,948 190,278 ‐65.08%
May 675,508 342,370 ‐49.32%
Jun 832,077 435,487 ‐47.66%
Jul 990,534
Aug 1,114,255
Sep 1,229,750
Oct 1,442,161
Nov 1,603,783
Dec 1,755,838
Percent of budget expended 24.80%
Planning Budget
YTD
Actual
Annual %
over (under)
Jan 242,179 221,112 ‐8.70%
Feb 488,126 449,900 ‐7.83%
Mar 751,373 681,350 ‐9.32%
Apr 1,009,976 906,510 ‐10.24%
May 1,309,628 1,134,729 ‐13.35%
Jun 1,598,387 1,353,531 ‐15.32%
Jul 1,862,808
Aug 2,130,592
Sep 2,418,320
Oct 2,693,743
Nov 2,945,967
Dec 3,207,796
Percent of budget expended 42.20%
$‐
$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 28 of 38
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
Aug 1,988,845
Sep 2,222,013
Oct 2,454,488
Nov 2,672,475
Dec 3,362,369
Percent of budget expended 38.71%
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
Aug 816,873
Sep 832,467
Oct 948,567
Nov 1,045,159
Dec 1,239,455
Percent of budget expended 48.92%
Includes Hearing Examiner
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
Millions City Clerk
Budget
Actual
Last Year
$‐
$0.40
$0.80
$1.20
$1.60
$2.00
$2.40
$2.80
$3.20
$3.60
Millions Finance
Budget
Actual
Last Year
Page 29 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
Human
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 89,011 87,874 ‐1.28%
Feb 195,204 175,377 ‐10.16%
Mar 317,238 273,335 ‐13.84%
Apr 435,317 395,728 ‐9.09%
May 545,084 492,849 ‐9.58%
Jun 653,804 592,817 ‐9.33%
Jul 762,752
Aug 880,309
Sep 988,492
Oct 1,111,195
Nov 1,218,957
Dec 1,357,317
Percent of budget expended 43.68%
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,838,877
Aug 23,629,666
Sep 26,807,915
Oct 29,657,572
Nov 32,675,468
Dec 36,130,337
Percent of budget expended 47.56%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
Millions Human Resources
Budget
Actual
Last Year
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
$36
Millions Police
Budget
Actual
Last Year
Page 30 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
Community
Services Admin Budget
YTD
Actual
Annual %
over (under)
Jan 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
Aug 323,291
Sep 362,917
Oct 402,012
Nov 441,115
Dec 505,154
Percent of budget expended 50.33%
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
Aug 3,372,507
Sep 3,882,283
Oct 4,333,779
Nov 4,732,770
Dec 5,179,955
Percent of budget expended 41.28%
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
Millions Parks
Budget
Actual
Last Year
$0
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
Community Services Admin
Budget
Actual
Last Year
Page 31 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
Parks Planning
and Natural
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 62,091 53,458 ‐13.90%
Feb 131,957 140,186 6.24%
Mar 212,165 204,477 ‐3.62%
Apr 281,414 289,729 2.95%
May 391,584 369,879 ‐5.54%
Jun 491,525 461,775 ‐6.05%
Jul 589,600
Aug 701,668
Sep 817,731
Oct 933,559
Nov 1,038,451
Dec 1,181,283
Percent of budget expended 39.09%
Recreation Budget
YTD
Actual
Annual %
over (under)
Jan 374,500 347,558 ‐7.19%
Feb 775,191 729,951 ‐5.84%
Mar 1,191,689 1,120,569 ‐5.97%
Apr 1,617,505 1,523,454 ‐5.81%
May 2,039,027 1,886,814 ‐7.46%
Jun 2,501,339 2,298,110 ‐8.12%
Jul 3,172,581
Aug 3,865,594
Sep 4,428,606
Oct 4,845,930
Nov 5,263,175
Dec 5,707,355
Percent of budget expended 40.27%
$‐
$200,000
$400,000
$600,000
$800,000
$1,000,000
$1,200,000
Parks Planning and Natural Resources
Budget
Actual
Last Year
$0.00
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
$5.50
$6.00
Millions Recreation
Budget
Actual
Last Year
Page 32 of 38
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
Aug 858,779
Sep 937,301
Oct 1,120,435
Nov 1,209,310
Dec 1,419,333
Percent of budget expended 41.20%
Neighborhoods
, Resources,
and Events Budget
YTD
Actual
Annual %
over (under)
Jan 81,357 60,703 ‐25.39%
Feb 182,250 125,601 ‐31.08%
Mar 270,845 198,834 ‐26.59%
Apr 346,463 266,753 ‐23.01%
May 434,510 337,861 ‐22.24%
Jun 523,578 414,589 ‐20.82%
Jul 660,849
Aug 771,489
Sep 872,891
Oct 966,341
Nov 1,050,945
Dec 1,201,992
Percent of budget expended 34.49%
$‐
$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 33 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
Museum Fund Budget
YTD
Actual
Annual %
over (under)
Jan 19,490 19,400 ‐0.46%
Feb 38,851 39,555 1.81%
Mar 57,801 59,213 2.44%
Apr 77,036 79,223 2.84%
May 96,758 97,324 0.59%
Jun 116,580 115,602 ‐0.84%
Jul 136,413
Aug 156,373
Sep 176,366
Oct 196,623
Nov 216,498
Dec 236,275
Percent of budget expended 48.93%
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
Aug 272,046
Sep 306,358
Oct 339,748
Nov 373,069
Dec 406,398
Percent of budget expended 50.11%
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
$400,000
$450,000
Public Works Admin
Budget
Actual
Last Year
$‐
$30,000
$60,000
$90,000
$120,000
$150,000
$180,000
$210,000
$240,000
Museum Fund
Budget
Actual
Last Year
Page 34 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
Street
Maintenance Budget
YTD
Actual
Annual %
over (under)
Jan 439,569 408,757 ‐7.01%
Feb 886,721 920,483 3.81%
Mar 1,366,996 1,383,891 1.24%
Apr 1,835,020 1,913,150 4.26%
May 2,295,588 2,408,369 4.91%
Jun 2,759,772 2,877,748 4.27%
Jul 3,256,692
Aug 3,742,444
Sep 4,214,166
Oct 4,682,566
Nov 5,131,438
Dec 5,636,437
Percent of budget expended 51.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
Aug 3,404,337
Sep 3,854,060
Oct 4,693,977
Nov 5,071,355
Dec 5,669,897
Percent of budget expended 44.30%
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
Millions Street Maintenance
Budget
Actual
Last Year
$0.0
$1.0
$2.0
$3.0
$4.0
$5.0
$6.0
Millions Transportation
Budget
Actual
Last Year
Page 35 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
Debt Service Budget
YTD
Actual
Annual %
over (under)
Jan 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 3,538,867
Aug 4,044,419
Sep 4,549,972
Oct 5,055,524
Nov 5,561,077
Dec 6,066,629
Percent of budget expended 14.17%
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 9,214,071
Aug 10,530,367
Sep 11,846,663
Oct 13,162,959
Nov 14,479,255
Dec 15,795,551
Percent of budget expended 10.24%
$‐
$2.00
$4.00
$6.00
$8.00
$10.00
$12.00
$14.00
$16.00
$18.00
Millions Non‐Departmental Other City Services
Budget
Actual
Last Year
$‐
$1
$2
$3
$4
$5
$6
$7
Millions Debt Service
Budget
Actual
Last Year
Page 36 of 38
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2017 Budget Year
Utilities Budget Revenue Expense
Jan 4,298,388 6,899,538 3,629,075
Feb 10,508,247 13,370,807 7,900,322
Mar 16,709,830 19,032,931 12,269,408
Apr 22,820,299 24,791,562 19,152,344
May 29,105,061 31,698,603 24,885,271
Jun 38,397,219 38,440,101 31,089,893
Jul 45,228,609
Aug 57,815,428
Sep 69,394,209
Oct 91,234,500
Nov 98,233,402
Dec 112,210,701
Percent of budget expended 18.96%
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
Aug 3,228,920
Sep 3,781,625
Oct 4,374,658
Nov 4,712,186
Dec 5,688,023
Percent of budget expended 14.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 37 of 38
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2017 Budget Year
Golf Course Budget Revenue Expense
Jan 137,464 60,345 141,202
Feb 293,683 133,495 325,022
Mar 489,627 226,967 523,715
Apr 658,337 415,629 739,488
May 838,487 699,291 933,160
Jun 1,035,356 975,459 1,181,928
Jul 1,262,542
Aug 1,469,281
Sep 1,655,432
Oct 1,851,777
Nov 2,026,038
Dec 2,630,288
Percent of budget expended 44.94%
Note: Operations and Capital
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
$2.40
$2.70
$3.00
Millions Golf Course
Budget
Revenue
Expense
Page 38 of 38