HomeMy WebLinkAbout201702, FebruaryADMINISTRATIVE SERVICES
DEPARTMENT
M E M O R A N D U M
DATE: March 23, 2017
TO: Armondo Pavone, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: February 2017 Financial Status Report
At the end of February, general governmental revenues show $833k or 6.1% over budget.
Revenue source(s) that are higher than expected are: sales tax (113k); utility taxes ($324k);
gambling taxes ($113k); business & occupation taxes ($253k); and seizure funds ($102k,
restricted to drug enforcement and not available for general purposes). If we remove seizure
funds, general governmental revenues are $731k or 5.4% over budget. On the down side, the
revenue source(s) that are underperforming the year to date budget is building permits &
development service fees ($184k below).
General government expenditures showed a favorable variance of $95k or 0.7%. 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$ 17,010,498$ 17,010,498$ 26,563,785$ 9,553,287 56.2%
OPERATING REVENUES
Property Tax 36,369,429 374,240 37,038,480 359,864 24,103,395 241,042 250,761 9,719 4.0%
Sales Tax 23,439,266 4,018,727 26,353,246 4,299,027 25,700,400 4,453,296 4,566,536 113,239 2.5%
Sales Tax ‐ Annexation Credit 2,778,858 475,946 3,114,762 508,330 3,063,280 511,589 540,877 29,288 5.7%
Criminal Justice Sa les Tax 2,484,718 429,905 2,701,787 474,407 2,679,898 467,264 483,778 16,515 3.5%
Natural Gas Use Tax 228,899 53,367 184,638 47,577 228,000 58,750 38,784 (19,966) ‐34.0%
Admission Tax 309,790 85,046 262,506 77,752 320,000 91,029 63,529 (27,500) ‐30.2%
Franchise Fees 1,349,154 333,343 1,406,092 348,118 1,330,000 328,952 387,170 58,218 17.7%
Electricity Tax 5,012,962 813,149 5,440,139 1,091,698 5,396,019 983,306 1,119,319 136,013 13.8%
Natural Ga s Utility Tax 1,437,552 406,322 1,327,937 388,344 1,350,900 388,182 474,022 85,840 22.1%
Garbage/Solid Waste 638,073 88,160 717,148 101,043 680,000 94,935 96,335 1,400 1.5%
TV Cable 1,591,866 228,618 1,619,364 235,742 1,645,659 237,971 240,964 2,993 1.3%
Telephone 880,233 203,129 859,868 173,049 714,875 154,543 161,207 6,664 4.3%
Cellular Phone 1,674,355 137,016 1,541,204 313,355 1,521,056 213,039 298,767 85,727 40.2%
City Utilities 4,183,165 641,357 4,206,473 645,273 3,941,628 604,486 629,913 25,428 4.2%
Utility Tax Audit 1,962,092 ‐ 111,227 111,227 ‐ ‐ ‐ ‐ 0.0%
Leasehold Excise Tax 163,314 11,601 173,769 713 179,000 6,539 9,086 2,546 38.9%
Gambling Excise Tax 2,299,156 342,481 2,500,604 397,710 2,000,000 308,429 421,158 112,729 36.5%
Real Estate Excise Tax 4,595,166 384,994 6,121,830 1,401,806 4,420,000 857,491 1,365,480 507,989 59.2%
Less: CIP REET (1,401,300) (96,248) (2,707,676) (700,903) (4,420,000) (857,491) (1,365,480) (507,989) 59.2%
EMS Levy 936,406 ‐ 479,597 ‐ ‐ ‐ ‐ ‐ 0.0%
B&O Taxes ‐ ‐ 6,375,322 ‐ 6,800,000 1,530,000 1,226,412 (303,588) ‐19.8%
Less: CIP B&O Taxes ‐ ‐ (2,000,000) ‐ (2,473,974) (556,644) ‐ 556,644 ‐100.0%
Business License Fees 3,125,740 810,114 1,926,510 834,953 1,302,453 422,154 386,774 (35,380) ‐8.4%
Less: CIP Business License Fees (2,584,164) (670,044) (1,587,627) (691,410) (617,016) (201,362) (220,070) (18,708) 9.3%
Animal Licenses and Spec Events Permits 101,743 18,845 102,905 14,955 92,575 16,290 15,680 (610) ‐3.7%
Building Permits & Development Svc Fees 6,077,055 589,160 5,293,563 1,074,783 5,735,368 861,115 676,844 (184,271) ‐21.4%
Intergovt'l (Grants, State Shared, etc) 4,053,617 556,375 3,998,953 584,560 3,708,241 517,965 538,686 20,720 4.0%
Fire District 25 and 40 Contracts 6,369,132 158,163 3,517,779 164,356 341,939 170,969 170,969 ‐ 0.0%
Public Safety 649,797 100,737 994,179 204,268 613,081 113,661 133,129 19,468 17.1%
Culture and Recreation 1,587,878 147,301 1,632,903 211,793 1,750,923 195,215 190,802 (4,414) ‐2.3%
Interfund/Interdept‐Services 3,106,430 529,480 3,377,663 559,590 4,178,976 696,496 650,626 (45,870) ‐6.6%
Fines and Penalties 848,052 64,943 901,592 55,802 824,450 56,192 72,761 16,569 29.5%
Photo Enforcement 2,171,184 273,894 1,959,071 298,285 2,044,000 283,163 279,252 (3,911) ‐1.4%
Seizure Funds ‐ Federal/State/Local 21,676 ‐ 987,293 661,152 ‐ ‐ 101,790 101,790 100.0%
Interests and Other Earnings 973,208 105,682 1,058,880 108,296 875,300 92,169 124,243 32,075 34.8%
Rents, Leases, and Concessions 762,361 196,165 642,192 175,867 623,195 165,069 175,373 10,304 6.2%
Contributions and Donations 147,292 8,177 96,582 22,075 70,000 8,683 23,095 14,412 166.0%
Other Miscellaneous 941,127 135,844 956,131 162,099 691,812 99,132 144,348 45,216 45.6%
Other Financing Sources (Transfer ‐In, etc) 270,224 500 2,129,561 ‐ 158,696 26,449 ‐ (26,449) ‐100.0%
Total Operating Revenues 119,555,505 11,956,490 125,816,444 14,715,559 101,574,129 13,640,071 14,472,917 832,847 6.1%
OPERATING EXPENDITURES
Council 320,877 58,037 358,550 64,182 368,211 66,236 64,877 1,359 2.1%
Executive 1,691,189 200,055 1,778,206 322,242 1,946,801 352,795 350,285 2,510 0.7%
Emergency Management*398,808 82,119 370,832 49,871 587,790 100,803 75,996 24,808 24.6%
City Attorney 1,791,167 294,916 1,983,834 326,649 2,163,329 356,198 333,751 22,447 6.3%
Court Services 2,013,364 313,414 2,075,763 335,163 2,220,656 352,218 343,353 8,865 2.5%
Community and Eco Dvlpmnt Admin 1,183,052 177,244 1,161,330 190,655 1,337,991 209,968 219,758 (9,791) ‐4.7%
Development Services 2,632,264 427,863 2,859,410 448,710 3,365,105 537,134 501,405 35,729 6.7%
Economic Development 658,515 122,554 1,004,411 108,276 1,104,342 153,293 98,329 54,964 35.9%
Planning 2,606,551 398,110 2,716,214 411,848 3,207,796 488,126 449,900 38,226 7.8%
Finance 3,132,812 350,741 3,046,824 434,053 3,312,369 420,660 425,531 (4,871) ‐1.2%
City Clerk 1,027,084 127,473 914,251 168,845 1,121,537 171,187 322,088 (150,901) ‐88.1%
Human Resources 1,182,629 156,267 1,193,016 185,388 1,321,317 190,026 175,377 14,650 7.7%
Police 28,144,699 4,420,628 28,891,879 4,565,715 30,291,917 4,772,614 4,799,880 (27,265) ‐0.6%
Jail Services 4,142,266 689,719 4,704,978 784,030 4,850,000 801,089 801,089 ‐ 0.0%
Fire*26,138,192 5,049,824 25,349,755 5,249,651 ‐ ‐ ‐ ‐ 0.0%
Community Services Admin 508,766 84,599 585,983 113,335 505,154 91,333 84,711 6,622 7.3%
Parks 4,411,383 618,104 4,445,115 615,902 5,091,258 709,382 630,236 79,147 11.2%
Parks Planning & Natural Resources 808,558 93,550 952,980 103,226 1,177,483 131,533 140,186 (8,653) ‐6.6%
Recreation 5,088,483 685,764 5,096,236 697,557 5,674,455 770,723 729,951 40,771 5.3%
Human Services 1,225,835 95,909 1,241,169 213,832 1,279,916 160,698 170,784 (10,085) ‐6.3%
Neighborhoods, Resources, & Events 958,624 132,128 865,551 144,459 1,041,408 157,901 125,601 32,301 20.5%
Museum 227,094 37,516 229,543 37,570 236,275 38,851 39,555 (703) ‐1.8%
Public Works Admin 387,493 64,809 398,796 67,230 406,398 68,245 67,352 894 1.3%
Street Maintenance 5,061,723 784,009 5,041,509 805,426 5,415,126 851,905 920,483 (68,578) ‐8.0%
Transportation 4,975,059 642,729 5,966,281 720,619 5,669,897 706,499 694,002 12,497 1.8%
Debt Service 6,371,715 298,456 6,099,166 295,075 6,066,629 291,694 291,694 ‐ 0.0%
Non‐Departmental and Other 10,069,740 668,193 9,883,923 566,783 9,445,551 531,962 531,962 ‐ 0.0%
Total Operating Expenditures 117,157,942 17,074,731 119,215,504 18,026,295 99,208,714 13,483,076 13,388,134 94,942 0.7%
Total Ending Fund Balance 19,962,845$ 12,447,041$ 26,563,785$ 16,652,109$ 19,375,913$ 17,167,493$ 27,648,568$ 10,481,075$ 61.1%
*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 February 2017
Page 1 of 37
Monthly Financial Report February 2017
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through February 28, 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 73% of
all resources supporting general governmental activities. The following section provides detail information on property,
sales, utility, and other taxes.
Property Tax
February’s collection is $195k,
making the total year‐to‐date
collection $251k or 1% of the
total budget. In comparison to
the previous year, the City
collected $109k or 30% less.
Compared to the budget, the City
collected $10k or 4% more.
Sales Tax
February 2017 sales tax receipts
totaled $2.5 million. Compared
with the same month last year, it
is $153k or 7% more. Compared
to the projected current month’s
budget, it is $52k or 2% above.
The year‐to‐date collection of
$4.6 million is $268k or 6% more
than the prior year and is also
$113k or 3% more than
budgeted. Auto and Retail 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
Apr 7,856,230 5,915,645
May 9,906,533 5,742,951
Jun 137,794 93,616
Jul 57,174 40,245
Aug 240,536 110,113
Sep 558,716 367,830
Oct 6,233,910 4,103,547
Nov 10,268,791 6,647,038
Dec 145,246 114,763
YTD Total 359,864$ 241,042$ 250,761$ (109,103)$ ‐30% 9,719$ 4%
Annual Total 37,038,480$ 24,103,395$
Property Tax Revenues
Year to Da te through February
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 ‐
Apr 1,888,875 1,881,780 ‐
May 2,314,220 2,200,305 ‐
Jun 2,127,406 1,967,578 ‐
Jul 2,103,896 2,017,854 ‐
Aug 2,438,277 2,274,282 ‐
Sep 2,179,438 2,171,299 ‐
Oct 2,410,824 2,262,292 ‐
Nov 2,532,820 2,367,730 ‐
Dec 2,203,689 2,217,808 ‐
YTD Total 4,299,027$ 4,453,296$ 4,566,536$ 267,509$ 6% 113,239$ 3%
Annual Total 26,353,246$ 25,700,400$
2017 vs. Budget2017 vs. 2016
Month
Year to Date through February
Local Retail Sales Tax Revenues
Page 2 of 37
Monthly Financial Report February 2017
The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business
sectors:
Utility tax
February utility tax revenues are
$1.4 million, which is $237k or
15% lower than the same month
last year and is also lower than
the budget by $97k or 7%. The
year‐to‐date collection is $3.1
million, which is $48k or 2%
lower than the prior year but is
$324k 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 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 599,519$ 747,218$ 719,531$ 120,012$ 20% $ (27,687)‐4%
Auto Sales 815,108 771,565 832,969 17,861 2% 61,404 8%
General Retail 1,349,672 1,354,449 1,437,641 87,969 7% 83,192 6%
Manufacturing 313,113 284,769 239,714 (73,399) ‐23% (45,056)‐16%
Wholesale 185,218 223,284 244,529 59,311 32% 21,245 10%
Service 931,371 960,868 981,950 50,579 5% 21,082 2%
Other 105,026 111,143 110,202 5,176 5% (942)‐1%
YTD Total 4,299,027$ 4,453,296$ 4,566,536$ 267,509$ 6%113,239$ 3%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 1,509,960$ 1,277,138$ 1,698,721$ 188,761$ 13% 421,584$ 33%
Feb 1,597,348 1,458,074 1,360,589 (236,759) ‐15% (97,485) ‐7%
Mar 1,423,774 1,462,603
Apr 1,346,282 1,289,233
May 1,363,323 1,284,502
Jun 1,125,845 1,177,807
Jul 1,276,335 1,234,377
Aug 1,247,926 1,269,789
Sep 1,277,502 1,227,003
Oct 1,351,888 1,252,150
Nov 1,128,100 1,206,958
Dec 1,359,717 1,338,504
YTD Total 3,107,308$ 2,735,212$ 3,059,310$ (47,998)$ ‐2% 324,098$ 12%
Annual Total 16,007,999$ 15,478,137$
2017 vs. Budget2017 vs . 2016
Year to Date through February
Utility Tax Revenues
Month
Utility Tax by Type 2016 2017 Bgt YTD Act Change 2017/2016 2017 Act vs Bgt
Electrical 1,091,698$ 983,306$ 1,119,319$ 27,620$ 3% $ 136,013 14%
Natural Gas 435,920 446,932 512,806 76,886 18% 65,874 15%
Cell 313,355 213,039 298,767 (14,588) ‐5% 85,727 40%
Phone 173,049 154,543 161,207 (11,842) ‐7% 6,664 4%
Cable 235,742 237,971 240,964 5,222 2% 2,993 1%
Garbage/Solid Waste 101,043 94,935 96,335 (4,708) ‐5% 1,400 1%
City Utilities 645,273 604,486 629,913 (15,360) ‐2% 25,428 4%
Utility Tax Audit 111,227 ‐ ‐ (111,227) 0% ‐ N/A
YTD Total 3,107,308$ 2,735,212$ 3,059,310$ (47,998)$ ‐2%324,098$ 12%
Annual Total 16,007,999$ 15,478,137$
YTD as % of 19% 18%
Page 3 of 37
Monthly Financial Report February 2017
Other Taxes
Real Estate Excise Tax
The City collected $337k in Real
Estate Excise Tax revenues (REET)
for February. This is $140k or
71% more than the same month
last year and is also $188k or
127% more than the current
month’s budget. The year‐to‐
date collection is $1.4 million,
which is $36k or 3% less than the
prior year but is $508k or 59%
above the budget. The higher
than expected variance is due to
9 large transactions in December
and January which accounts for
$740k of the total REET collected.
Gambling Tax
Februay’s Gambling Tax
collections totaled $201k, which
is $7k or 4% below the same
month last year but is above the
current month’s budget by $37k
or 23%. The year‐to‐date total of
$421k is $23k or 6% above the
prior year and is also $113k or
37% above budget.
Franchise Fees
Franchise Fees are due quarterly
in January, April, July, and
October. The year‐to‐date total
of $387k is $39k or 11% higher
than the prior year and is also
$58k or 18% 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
Apr 335,985 298,627
May 475,244 361,568
Jun 405,179 346,520
Jul 644,038 497,925
Aug 759,583 484,354
Sep 522,472 401,943
Oct 559,552 434,871
Nov 502,139 266,351
Dec 307,382 265,838
YTD Total 1,401,806$ 857,491$ 1,365,480$ (36,326)$ ‐3% 507,989$ 59%
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 February
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 ‐
Apr 197,286 168,730 ‐
May 198,234 158,893 ‐
Jun 185,042 149,623 ‐
Jul 194,317 162,180 ‐
Aug 322,828 229,017 ‐
Sep 202,409 159,756 ‐
Oct 242,254 190,582 ‐
Nov 183,345 165,084 ‐
Dec 181,924 155,817 ‐
YTD Total 397,710$ 308,429$ 421,158$ 23,447$ 6% 112,729$ 37%
Annual Total 2,500,604$ 2,000,000$
Gambling Tax Revenue
Month
Year to Date through February
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%
Apr 355,430 333,387 ‐
Jul 343,910 330,451 ‐
Sep 5,000 2,414 ‐
Oct 348,783 332,455 ‐
Dec 4,850 2,341 ‐
YTD Total 348,118$ 328,952$ 387,170$ 39,052$ 11% 58,218$ 18%
Annual Total 1,406,092$ 1,330,000$
Month
2017 vs. 2016 2017 vs. Budget
Franchise Fees Revenue
Year to Date through February
Page 4 of 37
Monthly Financial Report February 2017
Admission Tax
Admission Tax returns are due
quarterly in January, April, July,
and October of each year.
January 2017 collections
represent activities conducted
during the 4th quarter of 2016.
The year‐to‐date collection of
$64k is $14k or 18% less than the
prior year and is also $28k or 30%
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.5 million 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 $1.2 million.
Licenses and Permits
Business Licenses
Business Licenses totaled $158k
for February, which is $118k or
43% below the same month last
year but is $30k or 23% above the
current month’s budget. The
year‐to‐date Business Licenses
revenue of $387k is $448k or 54%
below the prior year and is also
below the budget by $35k or 8%.
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 ‐
May ‐ 852 ‐
Jul 60,763 80,276 ‐
Sep 518 289 ‐
Oct 58,934 74,983 ‐
Nov 1,452 831 ‐
YTD Total 77,752$ 91,029$ 63,529$ (14,224)$ ‐18% (27,500)$ ‐30%
Annual Total 262,506$ 320,000$
2017 vs. Budget
Admission Tax Revenue
Ye ar to Date through February
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 ‐
Apr 4,578,349 1,360,000 ‐
May 304,032 170,000 ‐
Jun 30,591 170,000 ‐
Jul 376,209 1,360,000 ‐
Aug 334,807 170,000 ‐
Sep 10,779 170,000 ‐
Oct 603,622 1,360,000 ‐
Nov 136,933 170,000 ‐
Dec ‐ 170,000 ‐
YTD Total ‐$ 1,530,000$ 1,226,412$ 1,226,412$ 100% (303,588)$ ‐20%
An nual Total 6,375,322$ 6,800,000$
*Total Business & Occupation Taxes (GF & CIP)
Business & Occupation Taxes*
Year to Date through February
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 ‐
Apr 207,099 184,956 ‐
May 111,131 72,269 ‐
Jun 26,936 13,489 ‐
Jul 248,769 228,999 ‐
Aug 121,095 65,678 ‐
Sep 22,190 13,573 ‐
Oct 218,271 222,326 ‐
Nov 91,870 56,325 ‐
Dec 12,555 7,925 ‐
YTD Total 834,953$ 422,154$ 386,774$ (448,179)$ ‐54% (35,380)$ ‐8%
Annual Total 1,926,510$ 1,302,453$
*Total Business License (GF & CIP)
2017 vs. 2016
Year to Date through February
2017 vs. Budget
Business Licenses*
Month
Page 5 of 37
Monthly Financial Report February 2017
Building Permits and
Development Service Fees
Building Permits and
Development Service Fee
revenues totaled $277k in
February. The year‐to‐date
revenues of $677k is $398k or
37% less than the year before
and is also $184k or 21% 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).
Intergovernmental
These revenue sources
include federal (direct
and indirect) grants,
state grants, state
shared revenues, local
grants, and
entitlements. State
shared revenues 92% of
the total revenues in
this category. The year‐
to‐date total
Intergovernmental revenue is $1.2 million or 18% of the budget.
State Shared Revenues
State Shared Revenue
collections totaled
$924k since the start of
the year. Compared to
the prior year, State
Shared Revenues are
below by $1k.
Compared to the
projected budget, the
City is collecting $41k or
5% more. The higher
than expected
collection is due to
collecting more than
anticipated Criminal
Justice’s Sales Tax and Liquor Excise Tax.
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 661,363$ 481,500$ 399,548$ (261,815)$ ‐40% (81,952)$ ‐17%
Feb 413,420 379,615 277,296 (136,124) ‐33% (102,319) ‐27%
Mar 583,658 440,847
Apr 336,108 484,673
May 376,324 310,348
Jun 437,619 698,400
Jul 462,211 691,725
Aug 397,578 438,730
Sep 380,480 498,572
Oct 479,048 478,350
Nov 297,449 359,940
Dec 468,303 472,668
YTD Total 1,074,783$ 861,115$ 676,844$ (397,939)$ ‐37% (184,271)$ ‐21%
Annual Total 5,293,563$ 5,735,368$
Year to Date through February
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 ‐$ ‐$ ‐$ ‐$ N/A $ ‐ N/A
Fire District #40 164,356 170,969 170,969 6,613 4%‐ 0%
State Shared Revenue 924,905 882,538 923,561 (1,344) 0% 41,023 5%
Federal Grants 65,477 12,295 12,295 (53,183) ‐81%‐ 0%
State Grants ‐ ‐ ‐ ‐ N/A ‐ N/A
Other Grants/Intgovt 68,584 90,396 86,608 18,024 26% (3,788) ‐4%
ARRA Grants ‐ ‐ ‐ ‐ N/A ‐ N/A
Total Rev YTD 1,223,323$ 1,156,199$ 1,193,433$ (29,890)$ ‐2%37,235$ 3%
Total Rev Annual 10,698,115$ 6,730,078$
YTD % 11% 17% 18%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
2016 2017 2017
Actual Budget Actual $ % $ %
Crim Just Sales Tax 474,407$ 467,264$ 483,778$ 9,371$ 2% 16,515$ 4%
Judicial Contribution 6,100 ‐ ‐ (6,100) 0%‐ N/A
Crim Just ‐ High Crime 77,796 62,415 67,721 (10,075) ‐13% 5,305 8%
Crim Just ‐ Pop 6,626 5,951 7,006 379 6% 1,054 18%
Crim Just ‐ Spec Prog 24,226 22,130 25,487 1,261 5% 3,357 15%
State DUI 3,873 4,673 3,863 (11) 0% (810) ‐17%
Marijuana Enforcement ‐ ‐ ‐ ‐ N/A ‐ N/A
Liquor Profits ‐ ‐ ‐ ‐ N/A ‐ N/A
Liquor Excise Tax 104,339 94,180 113,721 9,382 9% 19,541 21%
Fuel Tax 227,538 225,925 221,986 (5,551) ‐2% (3,939) ‐2%
YTD Total 924,905$ 882,538$ 923,561$ (1,344)$ 0% 41,023$ 5%
Annual Total 5,933,890$ 5,805,528$
State Shared Revenues
2017 vs. 2016
Revenue
Year to Date through February
2017 vs. Budget
Page 6 of 37
Monthly Financial Report February 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
65% of the total revenue in this category. The year‐to‐date total charges for services are $1.3 million or 15% of the budget.
The following sections provide detail information for Public Safety, Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totaled
$133k 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 $71k or 35% less.
Compared to the year‐to‐date
budget, the City is over budget by
$19k or 17%. 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
$38k for the current month.
Compared to the same month
the prior year, the City collected
$10k or 20% less. Compared to
the projected monthly budget,
the City collected $4k or 10%
more. The year‐to‐date
collection of $191k is $21k or
10% lower than the year before
and is also $4k 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 ‐
Apr 51,002 73,680 ‐
May 48,201 38,573 ‐
Jun 179,089 79,037 ‐
Jul 34,906 27,743 ‐
Aug 44,439 38,564 ‐
Sep 67,570 33,790 ‐
Oct 160,438 72,212 ‐
Nov 67,763 42,537 ‐
Dec 78,473 48,375 ‐
YTD Total 204,268$ 113,661$ 133,129$ (71,139)$ ‐35% 19,468$ 17%
Annual Total 994,179$ 613,081$
2017 vs. Budget
Month
2017 vs. 2016
Year to Date through February
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 ‐
Apr 112,627 110,918 ‐
May 72,246 74,076 ‐
Jun 239,771 254,264 ‐
Jul 325,043 409,892 ‐
Aug 349,650 360,345 ‐
Sep 107,652 123,607 ‐
Oct 45,706 55,007 ‐
Nov 68,324 70,632 ‐
Dec 39,475 44,472 ‐
YTD Total 211,793$ 195,215$ 190,802$ (20,991)$ ‐10% (4,414)$ ‐2%
Annual Total 1,632,903$ 1,750,923$
2017 vs. Budget2017 vs. 2016
Month
Recreation
Year to Date through February
Page 7 of 37
Monthly Financial Report February 2017
Interfund Services
The year‐to‐date collections for
Interfund Services revenues are
$651k. Compared to the prior
year, the revenues are over by
$91k or 16%. Compared to the
projected budget, the revenues
are below by $46k or 7%. 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
$352k. This is $2k or 1% lower
than a year ago but is $13k or 4%
above 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 ‐
Apr 276,238 348,248 ‐
May 272,641 348,248 ‐
Jun 260,223 348,248 ‐
Jul 259,888 348,248 ‐
Aug 273,851 348,248 ‐
Sep 286,057 348,248 ‐
Oct 277,517 348,248 ‐
Nov 295,584 348,248 ‐
Dec 311,019 348,248 ‐
YTD Total 559,590$ 696,496$ 650,626$ 91,036$ 16% (45,870)$ ‐7%
Annual Total 3,377,663$ 4,178,976$
2017 vs. Budget
Month
Interfund Services
Year to Date through February
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
Apr 250,873 242,171
May 214,613 231,927
Jun 261,254 261,299
Jul 222,267 219,171
Aug 274,964 252,324
Sep 200,986 232,621
Oct 238,517 243,770
Nov 273,338 270,941
Dec 306,114 310,486
YTD Total 354,088$ 339,355$ 352,013$ (2,075)$ ‐1% 12,658$ 4%
Annual Total 2,860,662$ 2,868,450$
Month
2017 vs. Budget2017 vs . 2016
Year to Date through February
Fines and Penalties by Month
Year to Date through February
2016 2017 2017
Actual Budget Actual $ % $ %
Civil Penalties 316$ 586$ 349$ 33$ 11% (237)$ ‐40%
Civil Infraction Penalties 25,826 23,527 26,890 1,065 4% 3,363 14%
Civil Parking Infraction Penalties 12,247 15,780 13,707 1,460 12% (2,073) ‐13%
Photo Enforcement Program 298,285 283,163 279,252 (19,034) ‐6% (3,911) ‐1%
Criminal Traffic Misdemeanor Fines 1,060 3,528 5,944 4,884 461% 2,415 68%
Criminal Non‐Traffic Fines 585 3,212 9,603 9,018 1542% 6,391 199%
Criminal Costs 7,762 7,958 8,415 654 8% 458 6%
Non‐Court Fines, Forfeitures and Penalties 8,008 1,601 7,853 (154) ‐2% 6,252 391%
YTD Total 354,088$ 339,355$ 352,013$ (2,075)$ ‐1% 12,658$ 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 February 2017
Included in the Fines and Penalties revenue
budget is $2 million 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 $279k.
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.1 million 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 $513k.
Compared to last year, the
revenues are below by $549k or
52%. Compared to the projected
year‐to‐date budget, the
revenues are over by $194k or
61%. 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 ‐ 89,775 ‐ ‐
Apr 165,633 ‐ 89,775 ‐ ‐
May 152,426 ‐ 89,775 ‐ ‐
Jun 194,994 ‐ 89,775 ‐ ‐
Jul 144,851 ‐ 89,775 ‐ ‐
Aug 183,427 ‐ 89,775 ‐ ‐
Sep 164,770 ‐ 89,775 ‐ ‐
Oct 175,856 ‐ 89,775 ‐ ‐
Nov 185,108 ‐ 89,775 ‐ ‐
Dec 204,263 ‐ 89,775 ‐ ‐
YTD Total 283,163$ 279,252$ 179,550$ 122,632$ 156,620$
Annual Total 2,044,000$ 1,077,297$
1Actuals of Revenues and Expenses
ExpensesRevenues
Photo Enforcement Program
Year to Date through February
Month
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 258,876$ 209,007$ 363,997$ 105,122$ 41% 154,990$ 74%
Feb 802,908 110,239 148,988 (653,920) ‐81% 38,750 35%
Mar 125,950 117,209
Apr 142,439 105,158
May 139,504 115,995
Jun 174,848 153,488
Jul 181,285 152,155
Aug 294,665 157,045
Sep 160,616 117,537
Oct 152,817 119,343
Nov 327,568 101,491
Dec 425,765 365,451
YTD Total 1,061,784$ 319,246$ 512,986$ (548,798)$ ‐52% 193,740$ 61%
Annual Total 3,187,241$ 1,824,117$
Year to Date through February
Month
2017 vs. Budget2017 vs. 2016
Miscellaneous Revenues by Month
2016 2017 2017
Actual Budget Actual $ % $ %
Interests and Other Earnings 108,296$ 92,169$ 124,243$ 15,947$ 15% 32,075$ 35%
Rents, Leases, and Concessions 175,867 165,069 175,373 (494) 0% 10,304 6%
Contributions/Donations from Private Sources 22,075 8,683 23,095 1,020 5% 14,412 166%
Other 94,393 53,325 88,485 (5,909) ‐6% 35,160 66%
Seizure Funds ‐ Federal/State/Local 661,152 ‐ 101,790 (559,363) ‐85% 101,790 100%
YTD Total 1,061,784$ 319,246$ 512,986$ (548,798)$ ‐52% 193,740$ 61%
Annual Total 3,187,241$ 1,824,117$
2017 vs. Budget
Miscellaneous Revenues by Type
Year to Date through February
Revenue
2017 vs. 2016
Page 9 of 37
Monthly Financial Report February 2017
EXPENSES
Overall the City has expended 13% of its budgeted general governmental expenditures at the end of February. This is $95k
or 0.7% below year‐to‐date budgeted expenditures. See below for summary of unfavorable items for general governmental
departments.
Administrative Services department (Finance and City Clerk) is over the year‐to‐date budget by $156k or 26.3%. This is due
to the spending patterns of Finance professional services and the timing of when the 2016 voter registration invoice was paid
in 2017 compared to 2015/2016.
Police department is over the year‐to‐date budget by $27k or 0.6%. This is due to the spending patterns of supplies and
professional services in 2015/2016 compared to 2017.
Public Works department (Admin, Street Maintenance, and Transportation) is over the year‐to‐date budget by $55k or
3.4%. This is due to the timing of when the 2016 Citywide Street Pavement Condition Study invoice was paid. It was
originally budgeted in 2016 and therefore will be carried forward into 2017 to cover the expense.
Page 10 of 37
Monthly Financial Report February 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 ‐ ‐ ‐ ‐ 16,600 9,600 ‐
Grants / intergovernmental ‐ ‐ ‐ ‐ 690,270 161,645 ‐
Charges for services 19,459 103,089 2,845,873 2,389,971 1,624,348 1,824,045 2,618,273
Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐
Fines and penalties 278 ‐ ‐ ‐ 132 ‐ ‐
Rents, leases, and misc fees 452,177 30,138 11,857 31,735 ‐ ‐ ‐
Interest and other misc 3,946 268 4,002 124,166 714,510 298,516 5,282
TOTAL REVENUES 475,860 133,495 2,861,732 2,545,872 3,045,860 2,293,806 2,623,555
EXPENSES:
Utility billing ‐ ‐ 9,916 29,169 22,409 35,670 ‐
Utility systems ‐ ‐ 1,276,338 567,722 557,284 543,690 ‐
Utility maintenance ‐ ‐ 49,455 819,180 295,163 432,648 2,800,313
Transportation 297,388 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 318,450 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 297,388 318,450 1,335,709 1,416,071 874,856 1,012,008 2,800,313
AMOUNT AVAILABLE FOR DEBT SERVICE 178,472 (184,955) 1,526,023 1,129,801 2,171,004 1,281,798 (176,758)
DEBT SERVICE:
Principal ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest ‐ ‐ ‐ ‐ ‐ 86,670 ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ ‐ ‐ 86,670 ‐
CAPITAL PROJECTS 7,864 6,572 ‐ 35,601 267,619 71,473 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 170,608 (191,527) 1,526,023 1,094,200 1,903,385 1,123,655 (176,758)
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, Feb 28 2,789,951 (154,439) 4,277,440 29,623,134 15,763,047 12,017,630 4,817,900
Page 11 of 37
Monthly Financial Report February 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 ‐ 22,590 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ ‐ ‐ ‐ ‐ ‐ ‐
Charges for services
Equipment rental m&o 450,516 708,405 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ ‐ ‐ 73,205 ‐ ‐ ‐
Communications ‐ 132,417 158,085 106,318 ‐ ‐ ‐
Facilities ‐ ‐ 679,088 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ ‐ ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest and other misc 7,126 2,920 1,613 601 13,549 4,486 10,832
Internal service fund misc:
Vehicle / equipment capital recovery 368,995 80,676 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 286,086 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 220,512 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 1,538,574 437,444
Other misc 57 27 652 ‐ ‐ 149,371 ‐
Interfund Loan ‐ ‐ ‐ ‐ ‐ ‐ ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets ‐ ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 40,356 ‐ ‐
TOTAL REVENUES 826,694 947,035 839,438 180,124 560,503 1,692,431 448,276
EXPENSES:
Communications 93,594
Equipment rental 331,168
Facilities 552,596
Healthcare 1,375,672
Information technology 717,486
Print and mail 57,643
Retiree healthcare 102,903
Risk management:
Risk management 367,242
Unemployment 18,685
Worker's compensation 375,240
TOTAL EXPENSES 331,168 717,486 552,596 151,237 761,167 1,375,672 102,903
AMOUNT AVAILABLE FOR CAPITAL 495,526 229,549 286,842 28,887 (200,664) 316,759 345,373
CAPITAL PROJECTS 204,598 56,989 ‐ ‐ ‐ ‐ ‐
TRANSFERS IN ‐ ‐ ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 290,928 172,560 286,842 28,887 (200,664) 316,759 345,373
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, Feb 28 6,722,981 2,742,934 1,561,895 571,814 12,651,845 4,472,907 10,424,624
Page 12 of 37
Monthly Financial Report February 2017
FUND BALANCE
Page 14 shows the ending fund balance as of February 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 February, the City has $27.6 million reported in the combined general governmental fund balance of the current
year’s operating budget, which is approximately 28% of budgeted operating expenditures. This is an increase of $1.1 million
from the year’s beginning balance. February’s ending fund balance is over the anticipated General Governmental Fund
Balance of $17.2 million by $10.5 million or 61.1%. 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 February 2017
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through February 28, 2017
Funds
Balance
01/01/2017
Budgeted
Revenue
Revenue
02/28/17
Total Funds
Available
Budgeted
Expenditure
Expenditure
02/28/17 Ending Balance
GENERAL GOVERNMENT FUNDS: 26,563,785 101,574,129 14,472,917 41,036,702 99,208,714 13,388,134 27,648,568
000 General 18,201,028 71,822,349 11,652,320 29,853,348 67,906,170 9,720,497 20,132,852
001 Community Services 3,769,766 12,336,177 1,566,143 5,335,909 13,422,904 1,701,018 3,634,892
003 Street 1,936,367 10,722,085 1,028,093 2,964,460 11,085,024 1,614,484 1,349,975
004 Community Dev Block Grant 66,654 424,857 413 67,067 424,857 11,219 55,848
005 Museum 72,372 233,936 67 72,439 236,275 39,555 32,884
009 Farmers Market 90,730 59,400 14,744 105,474 66,855 9,667 95,807
011 Fire Health & Wellness ‐ ‐ ‐ ‐ ‐ ‐ ‐
201 Ltd GO Bonds Gen Govt Debt 852,111 1,749,675 906 853,017 1,749,675 ‐ 853,017
215 Gen Govt Misc Debt Service 1,574,757 4,225,650 210,231 1,784,988 4,316,954 291,694 1,493,294
SPECIAL REVENUE FUNDS:1,599,965 1,974,729 392,917 1,992,882 1,902,670 121,876 1,871,006
102 Arterial Street 63,480 660,000 104,559 168,039 660,000 ‐ 168,039
108 Leased City Properties 276,865 902,550 188,939 465,804 839,996 76,543 389,261
110 Hotel Motel 402,602 265,000 36,273 438,875 265,000 45,333 393,542
125 1% For Art 128,489 24,505 137 128,626 15,000 ‐ 128,626
127 Cable Communication 394,504 122,674 62,653 457,157 122,674 ‐ 457,157
135 Springbrook Wetlands Bank 334,025 ‐ 356 334,381 ‐ ‐ 334,381
CAPITAL PROJECT FUNDS (CIP):26,202,403 22,464,152 4,025,646 30,228,049 19,574,182 499,478 29,728,571
303 Community Dev Mitigation 1,255,194 86,500 39,929 1,295,123 ‐ ‐ 1,295,123
304 Fire Mitigation 607,163 99,000 10,405 617,568 158,696 ‐ 617,568
305 Transportation Mitigation 1,497,748 620,000 116,289 1,614,037 1,005,000 ‐ 1,614,037
316 Municipal Facilities CIP 15,038,030 10,352,000 1,832,460 16,870,490 6,399,775 28,555 16,841,935
317 Transportation CIP 5,640,494 11,306,652 2,024,244 7,664,738 12,010,711 470,923 7,193,815
326 Housing Opportunity 1,041,173 ‐ 1,111 1,042,284 ‐ ‐ 1,042,284
336 New Library Development 1,122,601 ‐ 1,208 1,123,809 ‐ ‐ 1,123,809
ENTERPRISE FUNDS: 63,685,077 81,744,234 13,980,179 77,665,256 89,940,554 8,530,594 69,134,662
4X2 Airport Operating & CIP 2,619,343 3,122,486 475,860 3,095,203 3,894,902 305,251 2,789,952
403 Solid Waste Utility 2,751,417 19,187,851 2,861,732 5,613,149 19,010,175 1,335,710 4,277,439
4X4 Golf Operating & CIP 37,088 2,833,044 133,495 170,583 2,539,041 325,022 (154,439)
4X5 Water Operating & CIP 28,528,934 17,180,526 2,545,872 31,074,806 22,500,120 1,451,673 29,623,133
4X6 Waste Water Operating & CIP 13,859,662 10,024,949 3,045,859 16,905,521 12,137,333 1,142,474 15,763,047
416 King County Metro 4,994,658 17,505,693 2,623,555 7,618,213 17,505,693 2,800,313 4,817,900
4X7 Surface Water Operating & CIP 10,893,975 11,889,685 2,293,806 13,187,781 12,353,290 1,170,151 12,017,630
INTERNAL SERVICE FUNDS:37,908,315 30,287,916 5,494,502 43,402,817 31,512,994 4,253,817 39,149,000
501 Equipment Repair/Replacement 6,432,053 6,388,513 826,694 7,258,747 7,126,253 535,766 6,722,981
502 Insurance 12,852,509 3,292,368 560,504 13,413,013 3,571,166 761,167 12,651,846
503 Information S ervices 2,570,374 5,603,168 947,036 3,517,410 5,560,636 774,475 2,742,935
504 Facilities 1,275,053 4,882,506 839,438 2,114,491 4,981,195 552,596 1,561,895
505 Communications 542,927 1,078,253 180,124 723,051 1,076,474 151,238 571,813
512 Insurance, Healthcare 4,156,148 7,787,779 1,692,430 5,848,578 8,157,676 1,375,672 4,472,906
522 Insurance, Leoff1 Retirees HC 10,079,251 1,255,329 448,276 10,527,527 1,039,594 102,903 10,424,624
FIDUCIARY FUNDS:5,578,045 468,000 3,366 5,581,411 210,475 41,339 5,540,072
611 Firemen's Pension 5,578,045 468,000 3,366 5,581,411 210,475 41,339 5,540,072
TOTAL FUNDS 161,537,590 238,513,160 38,369,527 199,907,117 242,349,589 26,835,238 173,071,879
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
April
May
June
July
August
September
October
November
December
(8,000,000)
(7,000,000)
(6,000,000)
(5,000,000)
(4,000,000)
(3,000,000)
(2,000,000)
(1,000,000)
‐
1,000,000
2,000,000
3,000,000
4,000,000
5,000,000
6,000,000
7,000,000
8,000,000
‐
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,147,391 7,364,146 3.03%
Feb 13,640,071 14,472,917 6.11%
Mar 20,072,105
Apr 32,895,656
May 44,390,389
Jun 50,616,061
Jul 58,110,260
Aug 64,547,931
Sep 70,865,602
Oct 82,271,604
Nov 94,880,486
Dec 101,574,129
Percent of budget 14.25%
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
Apr 6,883,291
May 12,626,243
Jun 12,719,859
Jul 12,760,104
Aug 12,870,217
Sep 13,238,047
Oct 17,341,593
Nov 23,988,632
Dec 24,103,395
Percent of budget 1.04%
$‐
$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
Apr 9,174,172
May 11,640,150
Jun 13,842,125
Jul 16,104,724
Aug 18,663,293
Sep 21,097,526
Oct 23,629,240
Nov 26,285,407
Dec 28,763,680
Percent of budget 17.76%
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
Apr 5,487,047
May 6,771,549
Jun 7,949,356
Jul 9,183,733
Aug 10,453,523
Sep 11,680,525
Oct 12,932,675
Nov 14,139,633
Dec 15,478,137
Percent of budget 19.77%
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
Apr 1,688,572
May 1,961,934
Jun 2,264,302
Jul 2,972,183
Aug 3,368,015
Sep 3,791,878
Oct 4,274,238
Nov 4,532,625
Dec 4,815,012
Percent of budget 12.34%
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,688,367
Apr 2,201,507
May 2,732,833
Jun 3,322,482
Jul 3,812,126
Aug 4,273,273
Sep 4,876,573
Oct 5,417,661
Nov 5,978,044
Dec 6,730,078
Percent of budget 17.73%
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
Apr 2,574,617
May 3,142,189
Jun 4,270,357
Jul 5,207,148
Aug 6,077,059
Sep 6,705,746
Oct 7,327,762
Nov 7,947,988
Dec 8,677,538
Percent of budget 14.93%
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
Apr 845,911
May 1,077,838
Jun 1,339,137
Jul 1,558,308
Aug 1,810,632
Sep 2,043,253
Oct 2,287,023
Nov 2,557,964
Dec 2,868,450
Percent of budget 12.27%
$‐
$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
Apr 3,446,027
May 3,713,922
Jun 4,018,000
Jul 5,456,111
Aug 5,805,828
Sep 6,075,201
Oct 7,571,990
Nov 7,846,056
Dec 8,155,026
Percent of budget 25.84%
Misc Budget
YTD
Actual
Annual %
over (under)
Jan 209,007 363,997 74.16%
Feb 319,246 512,986 60.69%
Mar 436,454
Apr 541,612
May 657,607
Jun 811,095
Jul 963,250
Aug 1,120,295
Sep 1,237,832
Oct 1,357,175
Nov 1,458,666
Dec 1,824,117
Percent of budget 28.12%
$‐
$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 13,225 ‐ 0.00%
Feb 26,449 ‐ 0.00%
Mar 39,674
Apr 52,899
May 66,123
Jun 79,348
Jul 92,573
Aug 105,797
Sep 119,022
Oct 132,247
Nov 145,471
Dec 158,696
Percent of budget 0.00%
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
Apr 1,360,630
May 1,722,197
Jun 2,068,717
Jul 2,566,642
Aug 3,050,997
Sep 3,452,940
Oct 3,887,811
Nov 4,154,162
Dec 4,420,000
Percent of budget 30.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
Apr 1,786,635
May 2,096,984
Jun 2,795,383
Jul 3,487,109
Aug 3,925,839
Sep 4,424,411
Oct 4,902,760
Nov 5,262,700
Dec 5,735,368
Percent of budget 11.80%
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
Apr 3,060,000
May 3,230,000
Jun 3,400,000
Jul 4,760,000
Aug 4,930,000
Sep 5,100,000
Oct 6,460,000
Nov 6,630,000
Dec 6,800,000
Percent of budget 18.04%
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
Millions Building Permits and Development Service
Fees
Budget
Actual
Last Year
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
$5.50
$6.00
$6.50
$7.00
Millions Business & Occupation Tax
Budget
Actual
Last Year
Page 22 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 6,739,148 6,595,136 ‐2.14%
Feb 13,483,076 13,388,134 ‐0.70%
Mar 23,599,839
Apr 31,313,874
May 39,464,243
Jun 47,517,491
Jul 56,224,122
Aug 64,719,968
Sep 73,192,169
Oct 81,675,601
Nov 89,579,830
Dec 99,208,714
Percent of budget expended 13.49%
Legislative Budget
YTD
Actual
Annual %
over (under)
Jan 36,183 36,043 ‐0.39%
Feb 66,236 64,877 ‐2.05%
Mar 101,649
Apr 131,509
May 161,207
Jun 190,925
Jul 219,892
Aug 249,074
Sep 278,319
Oct 308,035
Nov 337,502
Dec 368,211
Percent of budget expended 17.62%
$‐
$20
$40
$60
$80
$100
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 210,597 211,310 0.34%
Feb 352,795 350,285 ‐0.71%
Mar 532,783
Apr 674,696
May 815,622
Jun 974,868
Jul 1,116,480
Aug 1,276,386
Sep 1,459,974
Oct 1,602,086
Nov 1,744,624
Dec 1,946,801
Percent of budget expended 17.99%
Emergency
Management Budget
YTD
Actual
Annual %
over (under)
Jan 60,959 35,052 ‐42.50%
Feb 100,803 75,996 ‐24.61%
Mar 150,586
Apr 190,380
May 230,495
Jun 277,194
Jul 317,478
Aug 385,782
Sep 432,973
Oct 475,285
Nov 516,615
Dec 587,790
Percent of budget expended 12.93%
$‐
$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
Apr 727,889
May 911,796
Jun 1,096,207
Jul 1,281,325
Aug 1,466,602
Sep 1,658,357
Oct 1,826,387
Nov 1,995,101
Dec 2,163,329
Percent of budget expended 15.43%
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
Apr 716,857
May 901,397
Jun 1,094,693
Jul 1,278,228
Aug 1,465,440
Sep 1,656,123
Oct 1,839,864
Nov 2,023,061
Dec 2,220,656
Percent of budget expended 15.46%
$‐
$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
Apr 422,897
May 531,643
Jun 639,918
Jul 803,016
Aug 909,108
Sep 1,015,431
Oct 1,121,287
Nov 1,226,753
Dec 1,337,991
Percent of budget expended 16.42%
Development
Services Budget
YTD
Actual
Annual %
over (under)
Jan 253,473 239,337 ‐5.58%
Feb 537,134 501,405 ‐6.65%
Mar 814,946
Apr 1,078,514
May 1,355,387
Jun 1,636,621
Jul 1,913,013
Aug 2,202,288
Sep 2,500,917
Oct 2,782,058
Nov 3,060,738
Dec 3,365,105
Percent of budget expended 14.90%
$‐
$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 62,001 46,869 ‐24.41%
Feb 153,293 98,329 ‐35.86%
Mar 224,582
Apr 342,747
May 424,864
Jun 523,338
Jul 623,000
Aug 700,815
Sep 773,456
Oct 907,053
Nov 1,008,707
Dec 1,104,342
Percent of budget expended 8.90%
Planning Budget
YTD
Actual
Annual %
over (under)
Jan 242,179 221,112 ‐8.70%
Feb 488,126 449,900 ‐7.83%
Mar 751,373
Apr 1,009,976
May 1,309,628
Jun 1,598,387
Jul 1,862,808
Aug 2,130,592
Sep 2,418,320
Oct 2,693,743
Nov 2,945,967
Dec 3,207,796
Percent of budget expended 14.03%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
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 210,228 197,230 ‐6.18%
Feb 420,660 425,531 1.16%
Mar 628,837
Apr 841,612
May 1,068,567
Jun 1,384,542
Jul 1,596,444
Aug 1,959,270
Sep 2,188,971
Oct 2,417,989
Nov 2,632,734
Dec 3,312,369
Percent of budget expended 12.85%
City Clerk Budget
YTD
Actual
Annual %
over (under)
Jan 70,972 62,018 ‐12.62%
Feb 171,187 322,088 88.15%
Mar 252,319
Apr 334,103
May 416,724
Jun 499,628
Jul 585,297
Aug 739,158
Sep 753,269
Oct 858,323
Nov 945,725
Dec 1,121,537
Percent of budget expended 28.72%
Includes Hearing Examiner
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
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 86,650 87,874 1.41%
Feb 190,026 175,377 ‐7.71%
Mar 308,824
Apr 423,771
May 530,627
Jun 636,463
Jul 742,522
Aug 856,960
Sep 962,275
Oct 1,081,723
Nov 1,186,626
Dec 1,321,317
Percent of budget expended 13.27%
Police Budget
YTD
Actual
Annual %
over (under)
Jan 2,938,648 2,964,875 0.89%
Feb 5,573,703 5,600,968 0.49%
Mar 8,715,041
Apr 11,385,347
May 14,397,411
Jun 17,169,439
Jul 20,269,792
Aug 22,985,168
Sep 26,075,758
Oct 28,848,141
Nov 31,783,447
Dec 35,141,917
Percent of budget expended 15.94%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
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
Apr 170,865
May 208,694
Jun 243,941
Jul 283,798
Aug 323,291
Sep 362,917
Oct 402,012
Nov 441,115
Dec 505,154
Percent of budget expended 16.77%
Parks Budget
YTD
Actual
Annual %
over (under)
Jan 341,642 309,997 ‐9.26%
Feb 709,382 630,236 ‐11.16%
Mar 1,096,504
Apr 1,489,177
May 1,883,623
Jun 2,321,322
Jul 2,830,040
Aug 3,314,760
Sep 3,815,806
Oct 4,259,572
Nov 4,651,730
Dec 5,091,258
Percent of budget expended 12.38%
$‐
$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 61,892 53,458 ‐13.63%
Feb 131,533 140,186 6.58%
Mar 211,483
Apr 280,509
May 390,324
Jun 489,944
Jul 587,703
Aug 699,411
Sep 815,101
Oct 930,556
Nov 1,035,110
Dec 1,177,483
Percent of budget expended 11.91%
Recreation Budget
YTD
Actual
Annual %
over (under)
Jan 372,341 347,558 ‐6.66%
Feb 770,723 729,951 ‐5.29%
Mar 1,184,820
Apr 1,608,181
May 2,027,273
Jun 2,486,920
Jul 3,154,292
Aug 3,843,311
Sep 4,403,077
Oct 4,817,996
Nov 5,232,836
Dec 5,674,455
Percent of budget expended 12.86%
$‐
$200,000
$400,000
$600,000
$800,000
$1,000,000
$1,200,000
Parks Planning and Natural Resources
Budget
Actual
Last Year
$0.00
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
$5.50
$6.00
Millions Recreation
Budget
Actual
Last Year
Page 31 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2017 Budget Year
Human
Services Budget
YTD
Actual
Annual %
over (under)
Jan 66,308 98,615 48.72%
Feb 160,698 170,784 6.28%
Mar 270,295
Apr 418,232
May 491,413
Jun 558,612
Jul 674,029
Aug 774,423
Sep 845,232
Oct 1,010,378
Nov 1,090,523
Dec 1,279,916
Percent of budget expended 13.34%
Neighborhoods
, Resources,
and Events Budget
YTD
Actual
Annual %
over (under)
Jan 70,488 60,703 ‐13.88%
Feb 157,901 125,601 ‐20.46%
Mar 234,660
Apr 300,176
May 376,460
Jun 453,629
Jul 572,561
Aug 668,419
Sep 756,275
Oct 837,240
Nov 910,541
Dec 1,041,408
Percent of budget expended 12.06%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
Millions Human Services
Budget
Actual
Last Year
$‐
$200,000
$400,000
$600,000
$800,000
$1,000,000
$1,200,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
Apr 77,036
May 96,758
Jun 116,580
Jul 136,413
Aug 156,373
Sep 176,366
Oct 196,623
Nov 216,498
Dec 236,275
Percent of budget expended 16.74%
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
Apr 135,775
May 169,617
Jun 203,557
Jul 237,559
Aug 272,046
Sep 306,358
Oct 339,748
Nov 373,069
Dec 406,398
Percent of budget expended 16.57%
$‐
$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 422,310 408,757 ‐3.21%
Feb 851,905 920,483 8.05%
Mar 1,313,322
Apr 1,762,969
May 2,205,454
Jun 2,651,411
Jul 3,128,820
Aug 3,595,499
Sep 4,048,699
Oct 4,498,708
Nov 4,929,955
Dec 5,415,126
Percent of budget expended 17.00%
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
Apr 1,619,928
May 2,095,850
Jun 2,513,261
Jul 2,960,840
Aug 3,404,337
Sep 3,854,060
Oct 4,693,977
Nov 5,071,355
Dec 5,669,897
Percent of budget expended 12.24%
$‐
$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 1,516,657
Apr 2,022,210
May 2,527,762
Jun 3,033,315
Jul 3,538,867
Aug 4,044,419
Sep 4,549,972
Oct 5,055,524
Nov 5,561,077
Dec 6,066,629
Percent of budget expended 4.81%
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 2,361,388
Apr 3,148,517
May 3,935,646
Jun 4,722,776
Jul 5,509,905
Aug 6,297,034
Sep 7,084,163
Oct 7,871,293
Nov 8,658,422
Dec 9,445,551
Percent of budget expended 5.63%
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
$7.00
$8.00
$9.00
$10.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 3,137,933 6,899,538 3,629,075
Feb 7,966,180 13,370,807 7,900,322
Mar 12,785,927
Apr 17,564,889
May 22,485,221
Jun 29,629,728
Jul 34,562,524
Aug 43,874,165
Sep 52,542,001
Oct 67,568,059
Nov 72,950,725
Dec 83,506,611
Percent of budget expended 6.45%
Note: Operations and Capital
Airport Budget Revenue Expense
Jan 197,822 255,451 164,122
Feb 477,943 475,859 305,251
Mar 794,755
Apr 1,099,920
May 1,348,103
Jun 1,639,286
Jul 1,932,689
Aug 2,211,019
Sep 2,589,486
Oct 2,995,569
Nov 3,226,692
Dec 3,894,902
Percent of budget expended 7.84%
Note: Operations and Capital
$0
$10
$20
$30
$40
$50
$60
$70
$80
$90
Millions Utilities
Budget
Revenue
Expense
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
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 132,696 60,345 141,202
Feb 283,495 133,495 325,022
Mar 472,641
Apr 635,498
May 809,399
Jun 999,439
Jul 1,218,743
Aug 1,418,310
Sep 1,598,003
Oct 1,787,537
Nov 1,955,753
Dec 2,539,041
Percent of budget expended 12.80%
Note: Operations and Capital
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
$2.40
$2.70
Millions Golf Course
Budget
Revenue
Expense
Page 37 of 37