HomeMy WebLinkAbout201703, MarchADMINISTRATIVE SERVICES
DEPARTMENT
M E M O R A N D U M
DATE: May 12, 2017
TO: Armondo Pavone, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: March 2017 Financial Status Report
At the end of March, general governmental revenues show $974k or 4.9% over budget. Revenue
source(s) that are higher than expected are: property tax ($186k); sales tax (172k); gambling taxes
($142k); business & occupation taxes ($158k); public safety ($123k); and seizure funds ($107k,
restricted to drug enforcement and not available for general purposes). If we remove seizure
funds, general governmental revenues are $868k or 4.3% over budget. On the down side, the
revenue source(s) that are underperforming the year to date budget is building permits &
development service fees ($122k below).
General government expenditures showed a favorable variance of $583k or 2.8%. 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 1,313,457 37,038,480 1,633,550 24,103,395 967,646 1,153,726 186,080 19.2%
Sales Tax 23,439,266 5,692,874 26,353,246 6,153,800 25,700,400 6,339,471 6,511,814 172,342 2.7%
Sales Tax ‐ Annexation Credit 2,778,858 673,289 3,114,762 728,203 3,063,280 728,442 770,799 42,357 5.8%
Criminal Justice Sa les Tax 2,484,718 609,416 2,701,787 665,383 2,679,898 658,696 691,484 32,787 5.0%
Natural Gas Use Tax 228,899 78,954 184,638 72,943 228,000 90,074 62,356 (27,718) ‐30.8%
Admission Tax 309,790 85,153 262,506 77,752 320,000 91,089 63,529 (27,560) ‐30.3%
Franchise Fees 1,349,154 333,343 1,406,092 348,118 1,330,000 328,952 396,270 67,318 20.5%
Electricity Tax 5,012,962 1,299,617 5,440,139 1,600,340 5,396,019 1,496,993 1,490,417 (6,576) ‐0.4%
Natural Ga s Utility Tax 1,437,552 578,683 1,327,937 557,961 1,350,900 555,234 617,203 61,969 11.2%
Garbage/Solid Waste 638,073 134,850 717,148 153,593 680,000 144,730 138,662 (6,068) ‐4.2%
TV Cable 1,591,866 361,627 1,619,364 371,036 1,645,659 375,468 382,954 7,486 2.0%
Telephone 880,233 260,572 859,868 244,707 714,875 207,580 259,942 52,361 25.2%
Cellular Phone 1,674,355 425,016 1,541,204 437,934 1,521,056 408,201 387,600 (20,601) ‐5.0%
City Utilities 4,183,165 975,860 4,206,473 981,340 3,941,628 919,534 917,726 (1,808) ‐0.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 511,743 2,500,604 592,965 2,000,000 460,318 601,996 141,678 30.8%
Real Estate Excise Tax 4,595,166 728,573 6,121,830 1,610,258 4,420,000 1,062,002 2,074,348 1,012,346 95.3%
Less: CIP REET (1,401,300) (182,143) (2,707,676) (805,129) (4,420,000) (1,062,002) (2,074,348) (1,012,346) 95.3%
EMS Levy 936,406 ‐ 479,597 ‐ ‐ ‐ ‐ ‐ 0.0%
B&O Taxes ‐ ‐ 6,375,322 ‐ 6,800,000 1,700,000 1,239,641 (460,359) ‐27.1%
Less: CIP B&O Taxes ‐ ‐ (2,000,000) ‐ (2,473,974) (618,494) ‐ 618,494 ‐100.0%
Business License Fees 3,125,740 836,181 1,926,510 866,595 1,302,453 436,913 439,906 2,993 0.7%
Less: CIP Business License Fees (2,584,164) (691,643) (1,587,627) (717,651) (617,016) (208,437) (245,781) (37,344) 17.9%
Animal Licenses and Spec Events Permits 101,743 29,720 102,905 24,160 92,575 25,955 27,732 1,777 6.8%
Building Permits & Development Svc Fees 6,077,055 864,986 5,293,563 1,658,442 5,735,368 1,301,962 1,180,134 (121,828) ‐9.4%
Intergovt'l (Grants, State Shared, etc) 4,053,617 919,084 3,998,953 954,547 3,708,241 869,733 911,415 41,683 4.8%
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 163,218 994,179 262,299 613,081 158,570 281,836 123,265 77.7%
Culture and Recreation 1,587,878 183,247 1,632,903 272,407 1,750,923 247,709 256,222 8,513 3.4%
Interfund/Interdept‐Services 3,106,430 789,552 3,377,663 864,644 4,178,976 1,044,744 1,027,817 (16,927) ‐1.6%
Fines and Penalties 848,052 142,646 901,592 134,548 824,450 131,067 138,335 7,268 5.5%
Photo Enforcement 2,171,184 471,928 1,959,071 483,189 2,044,000 472,673 425,863 (46,809) ‐9.9%
Seizure Funds ‐ Federal/State/Local 21,676 ‐ 987,293 661,152 ‐ ‐ 106,573 106,573 100.0%
Interests and Other Earnings 973,208 161,599 1,058,880 165,180 875,300 140,757 191,446 50,689 36.0%
Rents, Leases, and Concessions 762,361 248,863 642,192 189,094 623,195 194,320 207,290 12,970 6.7%
Contributions and Donations 147,292 30,402 96,582 35,013 70,000 18,776 36,395 17,619 93.8%
Other Miscellaneous 941,127 264,403 956,131 243,599 691,812 177,278 205,950 28,672 16.2%
Other Financing Sources (Transfer ‐In, etc) 270,224 500 2,129,561 ‐ 158,696 39,674 ‐ (39,674) ‐100.0%
Total Operating Revenues 119,555,505 18,465,333 125,816,444 21,798,267 101,574,129 20,083,136 21,057,303 974,167 4.9%
OPERATING EXPENDITURES
Council 320,877 88,145 358,550 99,419 368,211 101,649 97,498 4,151 4.1%
Executive 1,691,189 319,885 1,778,206 486,643 1,946,801 532,783 490,536 42,246 7.9%
Emergency Management*398,808 108,612 370,832 88,563 587,790 150,586 120,198 30,388 20.2%
City Attorney 1,791,167 443,297 1,983,834 498,957 2,163,329 539,974 508,012 31,963 5.9%
Court Services 2,013,364 477,408 2,075,763 508,523 2,220,656 535,423 523,105 12,319 2.3%
Community and Eco Dvlpmnt Admin 1,183,052 266,079 1,161,330 286,282 1,337,991 315,244 329,786 (14,542) ‐4.6%
Development Services 2,632,264 653,820 2,859,410 676,129 3,365,105 814,946 754,102 60,844 7.5%
Economic Development 658,515 171,373 1,004,411 166,805 1,104,342 224,582 140,672 83,911 37.4%
Planning 2,606,551 616,614 2,716,214 630,155 3,207,796 751,373 681,350 70,023 9.3%
Finance 3,132,812 531,013 3,046,824 642,161 3,312,369 628,837 630,778 (1,941) ‐0.3%
City Clerk 1,027,084 194,321 914,251 242,432 1,121,537 252,319 387,366 (135,047) ‐53.5%
Human Resources 1,182,629 256,191 1,193,016 299,054 1,321,317 308,824 273,335 35,489 11.5%
Police 28,144,699 6,971,905 28,891,879 7,154,611 30,291,917 7,502,541 7,499,489 3,052 0.0%
Jail Services 4,142,266 1,034,578 4,704,978 1,176,073 4,850,000 1,201,697 1,201,697 ‐ 0.0%
Fire*26,138,192 7,128,254 25,349,755 7,428,023 ‐ ‐ 44 (44) 100.0%
Community Services Admin 508,766 131,187 585,983 155,142 505,154 132,122 128,246 3,875 2.9%
Parks 4,411,383 958,044 4,445,115 949,380 5,091,258 1,096,504 989,660 106,844 9.7%
Parks Planning & Natural Resources 808,558 151,169 952,980 165,213 1,177,483 211,483 204,477 7,006 3.3%
Recreation 5,088,483 1,048,007 5,096,236 1,078,551 5,674,455 1,184,820 1,120,569 64,250 5.4%
Human Services 1,225,835 251,898 1,241,169 269,088 1,279,916 270,295 256,318 13,977 5.2%
Neighborhoods, Resources, & Events 958,624 197,567 865,551 213,473 1,041,408 234,660 198,834 35,827 15.3%
Museum 227,094 56,379 229,543 55,330 236,275 57,801 59,213 (1,412) ‐2.4%
Public Works Admin 387,493 96,942 398,796 100,509 406,398 102,054 101,914 140 0.1%
Street Maintenance 5,061,723 1,213,907 5,041,509 1,236,414 5,415,126 1,313,322 1,383,891 (70,569) ‐5.4%
Transportation 4,975,059 1,186,713 5,966,281 1,219,946 5,669,897 1,247,152 1,046,712 200,440 16.1%
Debt Service 6,371,715 298,456 6,099,166 295,075 6,066,629 293,691 293,691 ‐ 0.0%
Non‐Departmental and Other 10,069,740 888,765 9,883,923 917,099 9,445,551 776,618 776,618 ‐ 0.0%
Total Operating Expenditures 117,157,942 25,740,531 119,215,504 27,039,048 99,208,714 20,781,300 20,198,109 583,191 2.8%
Total Ending Fund Balance 19,962,845$ 10,290,084$ 26,563,785$ 14,722,064$ 19,375,913$ 16,312,335$ 27,422,979$ 11,110,645$ 68.1%
*Emergency Management was moved to Executive due to formation of RRFA
Favorable (Unfavorable)
2015 2016 2017 Variance
Annual Actual YTD Actual Annual Budget YTD Budget YTD ActualSummary of Sources and Uses Annual Actual YTD Actual
Monthly Financial Report March 2017
Page 1 of 38
Monthly Financial Report March 2017
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through March 31, 2017. Except as noted,
year‐to‐date budgeted revenues and operating expenditures are generally based on the collection/disbursement patterns for
the same period of the preceding two years. The table on the previous page summarizes the general governmental fund
revenues and expenditures.
Revenues
Taxes
The combined collection of property, sales/use, utility, gambling, admissions, and real estate excise taxes represents 71% of
all resources supporting general governmental activities. The following section provides detail information on property,
sales, utility, and other taxes.
Property Tax
March’s collection is $903k,
making the total year‐to‐date
collection $1.2 million or 4.8% of
the total budget. In comparison
to the previous year, the City
collected $480k or 29% less.
Compared to the budget, the City
collected $186k or 19% more.
Sales Tax
March 2017 sales tax receipts
totaled $1.9 million. Compared
with the same month last year, it
is $91k or 5% more. Compared to
the projected current month’s
budget, it is $59k or 3% above.
The year‐to‐date collection of
$6.5 million is $358k or 6% more
than the prior year and is also
$172k 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 902,965 (370,721) ‐29% 176,361 24%
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 1,633,550$ 967,646$ 1,153,726$ (479,824)$ ‐29% 186,080$ 19%
Annual Total 37,038,480$ 24,103,395$
Property Tax Revenues
Year to Date through March
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 ‐
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 6,153,800$ 6,339,471$ 6,511,814$ 358,014$ 6% 172,342$ 3%
An nual Total 26,353,246$ 25,700,400$
2017 vs. Budget2017 vs. 2016
Month
Year to Date through March
Local Retail Sales Tax Revenues
Page 2 of 38
Monthly Financial Report March 2017
The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business
sectors:
Utility tax
March utility tax revenues are
$1.2 million, which is $226k or
16% lower than the same month
last year and is also lower than
the budget by $265k or 18%. The
year‐to‐date collection is $4.3
million, which is $274k or 6%
lower than the prior year but is
$59k or 1% 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 873,553$ 1,051,038$ 1,053,453$ 179,900$ 21% $ 2,416 0%
Auto Sales 1,189,828 1,108,816 1,198,109 8,281 1% 89,293 8%
General Retail 1,874,318 1,871,573 1,980,703 106,385 6% 109,130 6%
Manufacturing 431,563 403,214 370,507 (61,056) ‐14% (32,707)‐8%
Wholesale 276,840 317,976 334,843 58,003 21% 16,867 5%
Service 1,357,842 1,428,037 1,413,183 55,341 4% (14,854)‐1%
Other 149,854 158,817 161,015 11,160 7% 2,197 1%
YTD Total 6,153,800$ 6,339,471$ 6,511,814$ 358,014$ 6%172,342$ 3%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 1,509,960$ 1,277,138$ 1,698,721$ 188,761$ 13% 421,584$ 33%
Feb 1,597,348 1,458,074 1,360,589 (236,759) ‐15% (97,485) ‐7%
Mar 1,423,774 1,462,603 1,197,548 (226,226) ‐16% (265,055) ‐18%
Apr 1,346,282 1,289,233
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 4,531,081$ 4,197,814$ 4,256,858$ (274,223)$ ‐6% 59,044$ 1%
Annual Total 16,007,999$ 15,478,137$
2017 vs. Budget2017 vs. 2016
Year to Date through March
Utility Tax Revenues
Month
Utility Tax by Type 2016 2017 Bgt YTD Act Change 2017/2016 2017 Act vs Bgt
Electrical 1,600,340$ 1,496,993$ 1,490,417$ (109,923)$ ‐7% $ (6,576) 0%
Natural Gas 630,904 645,308 679,558 48,654 8% 34,251 5%
Cell 437,934 408,201 387,600 (50,334) ‐11% (20,601)‐5%
Phone 244,707 207,580 259,942 15,235 6% 52,361 25%
Cable 371,036 375,468 382,954 11,917 3% 7,486 2%
Garbage/Solid Waste 153,593 144,730 138,662 (14,931) ‐10% (6,068)‐4%
City Utilities 981,340 919,534 917,726 (63,615) ‐6% (1,808) 0%
Utility Tax Audit 111,227 ‐ ‐ (111,227) 0% ‐ N/A
YTD Total 4,531,081$ 4,197,814$ 4,256,858$ (274,223)$ ‐6%59,044$ 1%
Annual Total 16,007,999$ 15,478,137$
YTD as % of 28% 27%
Page 3 of 38
Monthly Financial Report March 2017
Other Taxes
Real Estate Excise Tax
The City collected $709k in Real
Estate Excise Tax revenues (REET)
for March. This is $500k or 240%
more than the same month last
year and is also $504k or 247%
more than the current month’s
budget. The year‐to‐date
collection is $2.1 million, which is
$464k or 29% more than the prior
year and is also $1 million or 95%
above the budget. The higher
than expected variance is due to
12 large transactions in
December, January, and which
accounts for $1.1 million of the
total REET collected.
Gambling Tax
March’s Gambling Tax collections
totaled $181k, which is $14k or
7% below the same month last
year but is above the current
month’s budget by $29k or 19%.
The year‐to‐date total of $602k is
$9k or 2% above the prior year
and is also $142k or 31% above
budget.
Franchise Fees
Franchise Fees are due quarterly
in January, April, July, and
October. The year‐to‐date total
of $396k is $48k or 14% higher
than the prior year and is also
$67k 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
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,610,258$ 1,062,002$ 2,074,348$ 464,091$ 29% 1,012,346$ 95%
Annual Total 6,121,830$ 4,420,000$
*For 2017, REET is only in CIP
Month
2017 vs. Budget2017 vs. 2016
Real Estate Excise Tax (REET) Revenues*
Year to Date through March
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 ‐
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 592,965$ 460,318$ 601,996$ 9,032$ 2% 141,678$ 31%
Annual Total 2,500,604$ 2,000,000$
2017 vs. 2016
Gambling Tax Revenue
Month
Year to Date through March
2017 vs. Budget
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 348,118$ 328,952$ 380,870$ 32,752$ 9% 51,918$ 16%
Feb ‐ ‐ 6,300 6,300 100% 6,300 100%
Mar ‐ ‐ 9,100 9,100 100% 9,100 100%
Apr 355,430 333,387 ‐
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$ 396,270$ 48,152$ 14% 67,318$ 20%
Annual Total 1,406,092$ 1,330,000$
Franchise Fees Revenue
Year to Date through March
Month
2017 vs. 2016 2017 vs. Budget
Page 4 of 38
Monthly Financial Report March 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 $53k
for March, which is $21k or 68%
above the same month last year
and is also $38k or 260% above
the current month’s budget. The
year‐to‐date Business Licenses
revenue of $440k is $427k or 49%
below the prior year but is above
the budget by $3k or 1%. 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,089$ 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 March
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 ‐
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,700,000$ 1,239,641$ 1,239,641$ 100% (460,359)$ ‐27%
Annual Total 6,375,322$ 6,800,000$
*Total Business & Occupation Taxes (GF & CIP)
Business & Occupation Taxes*
Year to Date through March
Month
2017 vs. 2016 2017 vs. Budget
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 559,894$ 294,472 229,270$ (330,624)$ ‐59% (65,202)$ ‐22%
Feb 275,059 127,682 157,504 (117,555) ‐43% 29,822 23%
Mar 31,642 14,759 53,131 21,490 68% 38,373 260%
Apr 207,099 184,956 ‐
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 866,595$ 436,913$ 439,906$ (426,689)$ ‐49% 2,993$ 1%
An nual Total 1,926,510$ 1,302,453$
*Total Business License (GF & CIP)
Business Licenses*
Month
2017 vs. 2016
Year to Date through March
2017 vs. Budget
Page 5 of 38
Monthly Financial Report March 2017
Building Permits and
Development Service Fees
Building Permits and
Development Service Fee
revenues totaled $503k in March.
The year‐to‐date revenues of
$1.2 million is $478k or 29% less
than the year before and is also
$122k or 9% 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 93% of
the total revenues in this
category. The year‐to‐
date total
Intergovernmental revenue is $1.8 million or 26% of the budget.
State Shared Revenues
State Shared Revenue
collections totaled $1.5
million since the start of
the year. Compared to
the prior year, State
Shared Revenues are
above by $29k or 2%.
Compared to the
projected budget, the
City is collecting $78k or
6% more. The higher
than expected collection
is due to collecting more
than anticipated
Criminal Justice’s Sales
Tax and Liquor Excise Tax.
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 661,363$ 481,500$ 399,548$ (261,815)$ ‐40% (81,952)$ ‐17%
Feb 413,420 379,615 277,296 (136,124) ‐33% (102,319) ‐27%
Mar 583,658 440,847 503,290 (80,368) ‐14% 62,443 14%
Apr 336,108 484,673
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,658,442$ 1,301,962$ 1,180,134$ (478,308)$ ‐29% (121,828)$ ‐9%
Annual Total 5,293,563$ 5,735,368$
Building Permits and Development Service Fees
Year to Date through March
2017 vs. Budget2017 vs. 2016
Month
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 1,448,340 1,399,347 1,477,606 29,266 2% 78,259 6%
Federal Grants 65,938 11,542 11,542 (54,396) ‐82%‐ 0%
State Grants 25,065 22,246 22,246 (2,819) ‐11%‐ 0%
Other Grants/Intgovt 80,587 95,293 91,505 10,918 14% (3,788) ‐4%
ARRA Grants ‐ ‐ ‐ ‐ N/A ‐ N/A
Total Rev YTD 1,784,286$ 1,699,398$ 1,773,868$ (10,417)$ ‐1%74,471$ 4%
Total Rev Annual 10,698,115$ 6,730,078$
YTD % 17% 25% 26%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
2016 2017 2017
Actual Budget Actual $ % $ %
Crim Just Sales Tax 665,383$ 658,696$ 691,484$ 26,101$ 4% 32,787$ 5%
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 2,927 ‐ 11,885 8,958 306% 11,885 100%
Liquor Profits 212,574 212,784 213,888 1,314 1% 1,103 1%
Liquor Excise Tax 104,339 94,180 113,721 9,382 9% 19,541 21%
Fuel Tax 344,496 338,518 342,553 (1,943) ‐1% 4,035 1%
YTD Total 1,448,340$ 1,399,347$ 1,477,606$ 29,266$ 2% 78,259$ 6%
Annual Total 5,933,890$ 5,805,528$
2017 vs. Budget
State Shared Revenues
2017 vs. 2016
Revenue
Year to Date through March
Page 6 of 38
Monthly Financial Report March 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 $2 million or 23% of the budget.
The following sections provide detail information for Public Safety, Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totaled
$282k 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 $20k or 7%
more. Compared to the year‐to‐
date budget, the City is over
budget by $123k or 78%. 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
$65k for the current month.
Compared to the same month
the prior year, the City collected
$5k or 8% more. Compared to
the projected monthly budget,
the City collected $13k or 25%
more. The year‐to‐date
collection of $256k is $16k or 6%
lower than the year before but is
$9k or 3% higher 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 ‐
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 262,299$ 158,570$ 281,836$ 19,537$ 7% 123,265$ 78%
Annual Total 994,179$ 613,081$
Year to Date through March
Public Safety Services
2017 vs. 2016 2017 vs. Budget
Month
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 163,783$ 152,710$ 152,350$ (11,433)$ ‐7% (360)$ 0%
Feb 48,009 42,505 38,452 (9,558) ‐20% (4,053) ‐10%
Mar 60,615 52,493 65,420 4,805 8% 12,927 25%
Apr 112,627 110,918 ‐
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 272,407$ 247,709$ 256,222$ (16,186)$ ‐6% 8,513$ 3%
An nual Total 1,632,903$ 1,750,923$
Recreation
Year to Date through March
2017 vs. Budget2017 vs. 2016
Month
Page 7 of 38
Monthly Financial Report March 2017
Interfund Services
The year‐to‐date collections for
Interfund Services revenues are
$1 million. Compared to the
prior year, the revenues are over
by $163k or 19%. Compared to
the projected budget, the
revenues are below by $17k or
2%. 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
$564k. This is $54k or 9% lower
than a year ago and is also $40k
or 7% below the budget.
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 272,841$ 348,248$ 330,774$ 57,933$ 21% (17,474)$ ‐5%
Feb 286,748 348,248 319,851 33,103 12% (28,397) ‐8%
Mar 305,054 348,248 377,192 72,138 24% 28,944 8%
Apr 276,238 348,248 ‐
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 864,644$ 1,044,744$ 1,027,817$ 163,173$ 19% (16,927)$ ‐2%
An nual Total 3,377,663$ 4,178,976$
Interfund Services
Year to Date through March
2017 vs. 2016 2017 vs. Budget
Month
2016 2017 2017
Actual Budget Actual $ % $ %
Jan 136,421$ 126,199$ 134,957$ (1,464)$ ‐1% 8,758$ 7%
Feb 217,667 213,156 217,056 (611) 0% 3,900 2%
Mar 263,648 264,385 212,186 (51,462) ‐20% (52,199) ‐20%
Apr 250,873 242,171
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 617,736$ 603,740$ 564,199$ (53,537)$ ‐9% (39,541)$ ‐7%
Annual Total 2,860,662$ 2,868,450$
2017 vs. Budget2017 vs. 2016
Year to Date through March
Fines and Penalties by Month
Month
Year to Date through March
2016 2017 2017
Actual Budget Actual $ % $ %
Civil Penalties 443$ 904$ 531$ 89$ 20% (372)$ ‐41%
Civil Infraction Penalties 57,595 54,011 52,460 (5,135) ‐9% (1,551) ‐3%
Civil Parking Infraction Penalties 24,738 34,014 29,629 4,891 20% (4,386) ‐13%
Photo Enforcement Program 483,189 472,673 425,863 (57,325) ‐12% (46,809) ‐10%
Criminal Traffic Misdemeanor Fines 9,646 10,170 13,834 4,188 43% 3,664 36%
Criminal Non‐Traffic Fines 6,679 12,150 16,068 9,389 141% 3,919 32%
Criminal Costs 18,036 16,887 14,870 (3,166) ‐18% (2,016) ‐12%
Non‐Court Fines, Forfeitures and Penalties 17,411 2,932 10,943 (6,468) ‐37% 8,011 273%
YTD Total 617,736$ 603,740$ 564,199$ (53,537)$ ‐9% (39,541)$ ‐7%
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 March 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 $426k.
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 $664k.
Compared to last year, the
revenues are below by $524k or
44%. Compared to the projected
year‐to‐date budget, the
revenues are over by $227k or
52%. 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 ‐ 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 472,673$ 425,863$ 269,324$ 217,818$ 208,045$
Annual Total 2,044,000$ 1,077,297$
1Actuals of Revenues and Expenses
ExpensesRevenues
Photo Enforcement Program
Year to Date through March
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 150,954 25,004 20% 33,745 29%
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,187,734$ 436,454$ 663,940$ (523,794)$ ‐44% 227,485$ 52%
Annual Total 3,187,241$ 1,824,117$
Ye ar to Date through March
Month
2017 vs. Budget2017 vs. 2016
Miscellaneous Revenues by Month
2016 2017 2017
Actual Budget Actual $ % $ %
Interests and Other Earnings 165,180$ 140,757$ 191,446$ 26,265$ 16% 50,689$ 36%
Rents, Leases, and Concessions 189,094 194,320 207,290 18,196 10% 12,970 7%
Contributions/Donations from Private Sources 35,013 18,776 36,395 1,382 4% 17,619 94%
Other 137,295 82,602 122,237 (15,058) ‐11% 39,635 48%
Seizure Funds ‐ Federal/State/Local 661,152 ‐ 106,573 (554,580) ‐84% 106,573 100%
YTD Total 1,187,734$ 436,454$ 663,940$ (523,794)$ ‐44% 227,485$ 52%
Annual Total 3,187,241$ 1,824,117$
2017 vs. Budget
Miscellaneous Revenues by Type
Year to Date through March
Revenue
2017 vs. 2016
Page 9 of 38
Monthly Financial Report March 2017
EXPENSES
Overall the City has expended 20% of its budgeted general governmental expenditures at the end of March. This is $583k or
2.8% 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 $137k or 15.5%. 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.
Page 10 of 38
Monthly Financial Report March 2017
CASH AND INVESTMENTS –
1ST 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 $175 million.
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.75%.
Current %
Blended
Allowed
per policy
Current Portfolio
(principal value)
29% N/A $ 50,009,968
0% 100%‐$
43% 75% 75,265,535$
11% 75% 18,453,255$
18% 75% 31,306,761$
0% 25%‐$
TOTAL INVESTMENTS 100% 175,035,519$
*Excluding Cash the portfolio distribution is 60% LGIP; 25% CD's; 15% GSE's
Cash
US Treasury Securities
Local Government Investment Pool
US Federal Agency Securities
Certificates of Deposit
Commercial Paper
By Type
Cash
29%
LGIP
43%
GSE's
10%
CD's
18%
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 29%N/A 50,009,968 overnight 0.45% 0.13%50,009,968
US Treasury Securities
none 0%100%‐ N/A N/A N/A ‐
Local Government Investment Pool
3920 State Investment Pool 43%75%75,265,535 10/1/2014 0.10% 0.28%75,265,535
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.03%
315209A FHLMC 1,600,000 5/26/2020 1.75%0.02%
314179C FNMA 4,849,350 11/28/2017 1.00%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.05%
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 ‐
175,035,519$ 175,035,519$
18,453,255 75%11%
15,246,504
*Held in our safekeeping account at BNY Trust and Custody
TOTAL CASH & INVESTMENTS
20%
9%
15,000,000 9%
Page 11 of 38
Monthly Financial Report March 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 ‐ ‐ ‐ ‐ 23,800 13,500 ‐
Grants / intergovernmental ‐ ‐ ‐ ‐ 690,270 161,645 ‐
Charges for services 30,511 180,049 3,907,005 3,604,603 2,524,257 2,716,801 4,090,002
Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐
Fines and penalties 301 ‐ ‐ ‐ 132 ‐ ‐
Rents, leases, and misc fees 660,241 46,285 11,857 43,812 ‐ ‐ ‐
Interest and other misc 5,556 633 31,899 141,013 757,551 306,832 7,980
TOTAL REVENUES 696,609 226,967 3,950,761 3,789,428 3,996,010 3,198,778 4,097,982
EXPENSES:
Utility billing ‐ ‐ 13,254 40,536 30,754 47,353 ‐
Utility systems ‐ ‐ 1,369,235 842,322 829,851 920,886 ‐
Utility maintenance ‐ ‐ 73,976 1,409,204 466,469 669,561 4,200,470
Transportation 398,109 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 496,950 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 398,109 496,950 1,456,465 2,292,062 1,327,074 1,637,800 4,200,470
AMOUNT AVAILABLE FOR DEBT SERVICE 298,500 (269,983) 2,494,296 1,497,366 2,668,936 1,560,978 (102,488)
DEBT SERVICE:
Principal ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest ‐ ‐ ‐ 521 263 130,245 ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ 521 263 130,245 ‐
CAPITAL PROJECTS 7,864 26,765 ‐ 595,403 391,249 237,856 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 290,636 (296,748) 2,494,296 901,442 2,277,424 1,192,877 (102,488)
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, Mar 31 2,909,979 (259,660) 5,245,713 29,430,376 16,137,086 12,086,852 4,892,170
Page 12 of 38
Monthly Financial Report March 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 ‐ 41,229 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ 7,110 ‐ ‐ ‐ ‐ 47,440
Charges for services
Equipment rental m&o 679,146 1,062,606 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ ‐ ‐ 109,818 ‐ ‐ ‐
Communications ‐ 198,626 237,127 159,478 ‐ ‐ ‐
Facilities ‐ ‐ 1,018,630 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ ‐ ‐ ‐ ‐ ‐ ‐
IT service co ntracts ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest and other misc 10,909 4,459 2,493 921 20,631 6,984 16,672
Internal service fund misc:
Vehicle / equipment capital recovery 553,496 121,004 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 429,105 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 331,485 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 2,304,626 656,168
Other misc 57 27 653 10 ‐ 227,849 ‐
Interfund Loan ‐ ‐ ‐ ‐ ‐ ‐ ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets ‐ ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 58,773 ‐ ‐
TOTAL REVENUES 1,243,608 1,435,061 1,258,903 270,227 839,994 2,539,459 720,280
EXPENSES:
Communications 143,868
Equipment rental 533,718
Facilities 1,021,510
Healthcare 2,100,463
Information technology 1,110,110
Print and mail 93,545
Retiree healthcare 211,054
Risk management:
Risk ma nagement 406,594
Unemployment 18,685
Worker's compensation 468,097
TOTAL EXPENSES 533,718 1,110,110 1,021,510 237,413 893,376 2,100,463 211,054
AMOUNT AVAILABLE FOR CAPITAL 709,890 324,951 237,393 32,814 (53,382) 438,996 509,226
CAPITAL PROJECTS 227,932 134,848 ‐ ‐ ‐ ‐ ‐
TRANSFERS IN ‐ ‐ ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 481,958 190,103 237,393 32,814 (53,382) 438,996 509,226
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, Mar 31 6,914,011 2,760,477 1,512,446 575,741 12,799,127 4,595,144 10,588,477
Page 13 of 38
Monthly Financial Report March 2017
FUND BALANCE
Page 15 shows the ending fund balance as of March 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 March, the City has $27.4 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 $859k from
the year’s beginning balance. March’s ending fund balance is over the anticipated General Governmental Fund Balance of
$16.3 million by $11.1 million or 68.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 14 of 38
Monthly Financial Report March 2017
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through March 31, 2017
Funds
Balance
01/01/2017
Budgeted
Revenue
Revenue
03/31/17
Total Funds
Available
Budgeted
Expenditure
Expenditure
03/31/17 Ending Balance
GENERAL GOVERNMENT FUNDS: 26,563,785 101,574,129 21,057,303 47,621,088 99,208,714 20,198,109 27,422,979
000 General 18,201,028 71,822,349 17,242,024 35,443,052 67,906,170 14,753,036 20,690,015
001 Community Services 3,769,766 12,336,177 2,082,851 5,852,617 13,422,904 2,626,946 3,225,671
003 Street 1,936,367 10,722,085 1,502,671 3,439,038 11,085,024 2,430,603 1,008,435
004 Community Dev Block Grant 66,654 424,857 413 67,067 424,857 19,780 47,287
005 Museum 72,372 233,936 85 72,457 236,275 59,213 13,244
009 Farmers Market 90,730 59,400 16,813 107,543 66,855 14,841 92,703
011 Fire Health & Wellness ‐ ‐ ‐ ‐ ‐ ‐ ‐
201 Ltd GO Bonds Gen Govt Debt 852,111 1,749,675 1,382 853,493 1,749,675 300 853,193
215 Gen Govt Misc Debt Service 1,574,757 4,225,650 211,065 1,785,822 4,316,954 293,391 1,492,431
SPECIAL REVENUE FUNDS:1,599,965 1,974,729 566,615 2,166,580 1,902,670 189,472 1,977,108
102 Arterial Street 63,480 660,000 161,390 224,870 660,000 ‐ 224,870
108 Leased City Properties 276,865 902,550 286,894 563,759 839,996 129,655 434,104
110 Hotel Motel 402,602 265,000 54,670 457,272 265,000 59,166 398,106
125 1% For Art 128,489 24,505 209 128,698 15,000 ‐ 128,698
127 Cable Communication 394,504 122,674 62,909 457,413 122,674 651 456,762
135 Springbrook Wetlands Bank 334,025 ‐ 543 334,568 ‐ ‐ 334,568
CAPITAL PROJECT FUNDS (CIP):26,202,403 22,464,152 5,782,535 31,984,938 19,574,182 2,101,997 29,882,941
303 Community Dev Mitigation 1,255,194 86,500 139,675 1,394,869 ‐ ‐ 1,394,869
304 Fire Mitigation 607,163 99,000 336,496 943,659 158,696 ‐ 943,659
305 Transportation Mitigation 1,497,748 620,000 308,104 1,805,852 1,005,000 ‐ 1,805,852
316 Municipal Facilities CIP 15,038,030 10,352,000 2,858,912 17,896,942 6,399,775 286,478 17,610,464
317 Transportation CIP 5,640,494 11,306,652 2,135,828 7,776,322 12,010,711 1,520,507 6,255,815
326 Housing Opportunity 1,041,173 ‐ 1,694 1,042,867 ‐ ‐ 1,042,867
336 New Library Development 1,122,601 ‐ 1,826 1,124,427 ‐ 295,012 829,415
ENTERPRISE FUNDS: 63,685,077 81,744,234 19,956,534 83,641,611 89,940,554 13,199,093 70,442,518
4X2 Airport Operating & CIP 2,619,343 3,122,486 696,609 3,315,952 3,894,902 405,972 2,909,980
403 Solid Waste Utility 2,751,417 19,187,851 3,950,761 6,702,178 19,010,175 1,456,465 5,245,713
4X4 Golf Operating & CIP 37,088 2,833,044 226,967 264,055 2,539,041 523,714 (259,659)
4X5 Water Operating & CIP 28,528,934 17,180,526 3,789,429 32,318,363 22,500,120 2,887,986 29,430,377
4X6 Waste Water Operating & CIP 13,859,662 10,024,949 3,996,009 17,855,671 12,137,333 1,718,585 16,137,086
416 King County Metro 4,994,658 17,505,693 4,097,982 9,092,640 17,505,693 4,200,470 4,892,170
4X7 Surface Water Operating & CIP 10,893,975 11,889,685 3,198,777 14,092,752 12,353,290 2,005,901 12,086,851
INTERNAL SERVICE FUNDS: 37,908,315 30,287,916 8,307,531 46,215,846 31,512,994 6,470,424 39,745,422
501 Equipment Repair/Replacement 6,432,053 6,388,513 1,243,607 7,675,660 7,126,253 761,650 6,914,010
502 Insurance 12,852,509 3,292,368 839,994 13,692,503 3,571,166 893,376 12,799,127
503 Information Services 2,570,374 5,603,168 1,435,061 4,005,435 5,560,636 1,244,958 2,760,477
504 Facilities 1,275,053 4,882,506 1,258,903 2,533,956 4,981,195 1,021,510 1,512,446
505 Communications 542,927 1,078,253 270,227 813,154 1,076,474 237,413 575,741
512 Insurance, Healthcare 4,156,148 7,787,779 2,539,459 6,695,607 8,157,676 2,100,463 4,595,144
522 Insurance, Leoff1 Retirees HC 10,079,251 1,255,329 720,280 10,799,531 1,039,594 211,054 10,588,477
FIDUCIARY FUNDS:5,578,045 468,000 7,305 5,585,350 210,475 62,008 5,523,342
611 Firemen's Pension 5,578,045 468,000 7,305 5,585,350 210,475 62,008 5,523,342
TOTAL FUNDS 161,537,590 238,513,160 55,677,823 217,215,413 242,349,589 42,221,103 174,994,310
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,109 859,194 27,422,979
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 16 of 38
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,083,136 21,057,303 4.85%
Apr 32,904,937
May 44,396,215
Jun 50,619,606
Jul 58,113,674
Aug 64,550,453
Sep 70,866,878
Oct 82,271,802
Nov 94,881,012
Dec 101,574,129
Percent of budget 20.73%
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
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 4.79%
$‐
$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
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 25.32%
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
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 27.50%
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
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 21.18%
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,210,788
May 2,738,658
Jun 3,326,028
Jul 3,815,540
Aug 4,275,795
Sep 4,877,848
Oct 5,417,859
Nov 5,978,570
Dec 6,730,078
Percent of budget 26.36%
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
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 23.41%
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
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 19.67%
$‐
$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
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 28.33%
Misc Budget
YTD
Actual
Annual %
over (under)
Jan 209,007 363,997 74.16%
Feb 319,246 512,986 60.69%
Mar 436,454 663,940 52.12%
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 36.40%
$‐
$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 13,225 ‐ 0.00%
Feb 26,449 ‐ 0.00%
Mar 39,674 ‐ 0.00%
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 2,074,348 95.32%
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 46.93%
$‐
$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
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 20.58%
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
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.23%
$‐
$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,739,148 6,595,136 ‐2.14%
Feb 13,483,076 13,388,134 ‐0.70%
Mar 20,781,300 20,198,109 ‐2.81%
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 20.36%
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
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 26.48%
$‐
$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 24 of 38
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 490,536 ‐7.93%
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 25.20%
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 120,198 ‐20.18%
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 20.45%
$‐
$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
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 23.48%
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
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 23.56%
$‐
$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
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 24.65%
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 754,102 ‐7.47%
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 22.41%
$‐
$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 62,001 46,869 ‐24.41%
Feb 153,293 98,329 ‐35.86%
Mar 224,582 140,672 ‐37.36%
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 12.74%
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
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 21.24%
$‐
$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 28 of 38
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 630,778 0.31%
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 19.04%
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 387,366 53.52%
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 34.54%
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 29 of 38
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 273,335 ‐11.49%
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 20.69%
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,704,237 8,701,186 ‐0.04%
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 24.76%
$‐
$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 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
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 25.39%
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 989,660 ‐9.74%
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 19.44%
$‐
$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 61,892 53,458 ‐13.63%
Feb 131,533 140,186 6.58%
Mar 211,483 204,477 ‐3.31%
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 17.37%
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 1,120,569 ‐5.42%
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 19.75%
$‐
$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 66,308 98,615 48.72%
Feb 160,698 170,784 6.28%
Mar 270,295 256,318 ‐5.17%
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 20.03%
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 198,834 ‐15.27%
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 19.09%
$‐
$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 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
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 25.06%
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
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 25.08%
$‐
$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 422,310 408,757 ‐3.21%
Feb 851,905 920,483 8.05%
Mar 1,313,322 1,383,891 5.37%
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 25.56%
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
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 18.46%
$‐
$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 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.84%
Non‐
Departmental
Other City Budget
YTD
Actual
Annual %
over (under)
Jan 301,517 301,517 0.00%
Feb 531,962 531,962 0.00%
Mar 776,618 776,618 0.00%
Apr 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 8.22%
$‐
$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 36 of 38
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 19,032,931 12,269,408
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 12.84%
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 696,609 405,972
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 10.42%
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 37 of 38
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 226,967 523,715
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 20.63%
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 38 of 38