HomeMy WebLinkAbout201508, August.pdfADMINISTRATIVE SERVICES
DEPARTMENT
M E M O R A N D U M
DATE: September 24, 2015
TO: Ed Prince, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: August 2015 Financial Status Report
At the end of August, general governmental revenues show $3.1 million or 4.4% over budget.
Revenue sources that are higher than expected are: property tax ($423k); sales tax ($522k);
sales tax annexation credit ($150k); state shared revenues ($361k); franchise fees ($101k);
gambling taxes ($488k); building permits & development service fees ($1 million); public safety
($176k); interest/other earnings ($361k); and other miscellaneous ($154k). On the down side,
the revenue sources that are underperforming the year to date budget are: utility taxes ($377k
below) and fines/penalties ($309k below).
General government expenditures showed a favorable variance of $2.3 million or 3%. See page
9 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 15,575,840$ 15,575,840$ 17,454,262$ 17,454,262$ 17,565,282$ 17,565,282$ 17,565,282$ ‐ 0.0%
OPERATING REVENUES
Property Tax 32,485,690 17,012,180 35,295,390 18,488,664 36,040,000 18,941,825 19,364,972 423,147 2.2%
Sales Tax 20,416,372 13,395,862 21,512,379 13,998,857 22,239,731 14,622,132 15,143,919 521,787 3.6%
Sales Tax ‐ Annexation Credit 2,418,789 1,587,887 2,542,394 1,652,022 2,519,968 1,645,669 1,795,753 150,084 9.1%
Criminal Justice Sales Tax 2,091,174 1,354,300 2,267,947 1,470,567 2,305,519 1,494,059 1,612,067 118,008 7.9%
Natural Gas Use Tax 263,660 203,203 271,485 223,696 300,000 247,191 172,628 (74,563) ‐30.2%
Admission Tax 327,258 240,300 310,311 233,681 320,000 237,894 234,588 (3,306) ‐1.4%
Franchise Fees 1,312,727 943,042 1,342,269 970,939 1,260,000 908,331 1,009,218 100,887 11.1%
Electricity Tax 5,155,789 3,478,251 5,167,444 3,554,849 5,365,536 3,655,478 3,286,688 (368,790) ‐10.1%
Natural Gas Utility Tax 1,550,900 1,146,359 1,562,341 1,199,605 1,550,900 1,168,672 1,060,598 (108,074) ‐9.2%
Garbage/Solid Waste 397,596 266,152 573,457 373,166 400,000 263,350 404,233 140,883 53.5%
TV Cable 1,481,779 964,072 1,518,821 995,180 1,579,365 1,031,252 1,038,885 7,633 0.7%
Telephone 917,021 577,545 909,088 616,067 952,500 622,589 636,126 13,537 2.2%
Cellular Phone 2,050,312 1,273,172 1,951,925 1,233,774 1,967,056 1,232,136 1,112,742 (119,395) ‐9.7%
City Utilities 3,964,989 2,638,419 3,961,052 2,644,875 4,058,377 2,705,209 2,825,314 120,105 4.4%
Utility Tax Audit ‐ ‐ 460,513 460,513 1,434,000 1,434,000 1,446,078 12,078 0.8%
Leasehold Excise Tax 164,637 94,965 171,470 101,390 179,000 104,572 96,661 (7,911) ‐7.6%
Gambling Excise Tax 1,319,585 825,004 1,650,384 1,049,550 1,600,000 1,009,871 1,498,195 488,324 48.4%
Real Estate Excise Tax 4,131,665 2,013,764 4,348,762 3,331,324 4,000,000 2,838,154 2,884,653 46,499 1.6%
Less: CIP REET (700,000) (387,276) (1,650,000) (631,791) (1,000,000) (721,163) (721,163) ‐ 0.0%
EMS Levy 916,361 458,181 916,361 450,784 920,000 468,203 468,203 ‐ 0.0%
Business License Fees 2,911,691 2,153,498 2,965,850 2,188,972 3,006,000 2,220,946 2,323,308 102,362 4.6%
Less: CIP Business License Fees (2,407,925) (1,781,519) (2,450,295) (1,810,037) (2,500,000) (1,848,185) (1,921,829) (73,644) 4.0%
Animal Licenses and Spec Events Permits 99,411 75,047 95,698 72,729 91,000 68,313 73,230 4,917 7.2%
Building Permits & Development Svc Fees 4,001,625 2,565,255 4,519,234 3,062,821 4,679,749 3,094,595 4,108,757 1,014,162 32.8%
Intergovt'l (Grants, State Shared, etc) 3,863,974 2,678,845 4,522,540 2,953,454 3,909,542 2,136,611 2,373,692 237,082 11.1%
Fire District 25 and 40 Contracts 5,726,895 3,017,987 5,959,428 3,130,845 6,116,326 3,342,129 3,342,129 ‐ 0.0%
Public Safety 680,581 447,489 844,375 506,172 513,081 321,121 496,831 175,710 54.7%
Culture and Recreation 1,494,580 1,158,679 1,485,123 1,227,889 1,580,616 1,265,981 1,308,748 42,767 3.4%
Interfund/Interdept‐Services 3,464,913 2,387,476 3,270,503 2,217,492 3,221,947 2,147,965 2,092,497 (55,468) ‐2.6%
Fines and Penalties 1,137,140 694,428 962,977 675,723 1,126,500 734,230 519,223 (215,007) ‐29.3%
Photo Enforcement 1,629,524 1,255,513 1,719,971 976,256 2,194,000 1,461,863 1,368,096 (93,767) ‐6.4%
Seizure Funds ‐ Federal/State/Local 50,639 34,567 68,870 3,346 180,693 57,323 6,444 (50,880) ‐88.8%
Interests and Other Earnings 423,609 71,048 981,630 91,426 875,300 101,203 462,120 360,917 356.6%
Rents, Leases, and Concessions 734,530 582,513 711,070 578,552 710,216 570,425 608,000 37,575 6.6%
Contributions and Donations 84,320 71,717 113,626 83,499 112,000 87,823 93,874 6,051 6.9%
Other Miscellaneous 684,187 481,842 879,105 548,447 705,369 470,548 624,913 154,365 32.8%
Other Financing Sources (Transfer‐In, etc) 299,527 20,415 48,632 23,015 255,000 7,607 7,607 0 0.0%
Total Operating Revenues 105,545,527 64,000,182 111,782,133 68,948,315 114,769,291 70,149,921 73,257,997 3,108,076 4.4%
OPERATING EXPENDITURES
Council 289,911 192,361 309,317 209,660 335,838 225,314 217,023 8,291 3.7%
Executive 1,240,910 824,425 1,338,738 861,339 1,714,717 1,120,544 1,085,450 35,094 3.1%
City Attorney 1,922,225 1,157,082 1,829,254 1,196,303 2,001,421 1,255,535 1,217,493 38,042 3.0%
Court Services 2,003,104 1,302,458 2,016,273 1,333,913 2,157,721 1,415,282 1,335,130 80,153 5.7%
Community and Eco Dvlpmnt Admin 1,047,860 685,933 1,010,761 671,680 1,177,608 776,605 824,910 (48,304) ‐6.2%
Development Services 3,243,702 2,165,714 2,659,078 1,817,405 2,964,321 2,000,285 1,743,441 256,844 12.8%
Economic Development 467,511 300,522 654,007 410,729 1,053,786 668,297 435,115 233,182 34.9%
Planning 1,510,707 993,017 2,095,706 1,300,370 2,714,466 1,726,181 1,737,966 (11,785) ‐0.7%
Finance 2,274,147 1,312,345 2,644,827 1,578,130 3,167,120 1,861,055 1,830,087 30,968 1.7%
City Clerk 1,020,822 765,703 1,152,246 717,774 1,091,558 745,168 552,466 192,701 25.9%
Human Resources 904,182 583,333 922,668 597,747 1,316,577 851,182 754,220 96,962 11.4%
Police 24,946,784 16,528,605 26,383,640 17,162,895 28,371,356 18,621,969 18,470,803 151,166 0.8%
Jail Services 3,814,042 2,542,701 3,760,273 2,507,506 4,200,000 2,762,741 2,762,741 ‐ 0.0%
Fire 24,444,372 16,390,199 25,240,760 17,031,941 26,890,757 18,088,845 17,680,343 408,502 2.3%
Community Services Admin 452,146 299,975 480,727 311,518 560,787 367,593 334,458 33,135 9.0%
Parks 4,024,756 2,631,293 4,070,181 2,651,206 4,870,254 3,178,173 2,870,952 307,221 9.7%
Parks Planning & Natural Resources 829,250 428,676 722,739 447,522 999,004 564,003 489,839 74,164 13.1%
Recreation 4,846,970 3,343,858 4,823,195 3,235,603 5,200,923 3,538,644 3,440,666 97,977 2.8%
Human Services 1,162,330 695,514 1,159,189 734,148 1,204,977 742,062 760,204 (18,143) ‐2.4%
Neighborhoods, Resources, & Events 770,841 518,531 875,223 545,684 1,036,841 670,339 613,785 56,554 8.4%
Museum 209,387 139,638 214,291 140,521 227,761 150,608 151,082 (474) ‐0.3%
Public Works Admin 426,312 301,882 389,493 258,263 395,867 271,809 258,768 13,041 4.8%
Street Maintenance 3,814,132 2,532,782 4,503,315 2,911,004 5,186,713 3,394,715 3,381,140 13,575 0.4%
Transportation 4,476,854 2,933,793 4,263,725 2,773,453 5,166,529 3,373,535 3,156,877 216,658 6.4%
Debt Service 8,048,508 2,058,556 8,393,140 2,319,244 6,459,484 1,323,214 1,323,214 0 0.0%
Non‐Departmental and Other 5,475,340 2,950,337 9,758,346 7,060,175 6,740,778 5,851,672 5,851,672 ‐ 0.0%
Total Operating Expenditures 103,667,105 64,579,234 111,671,112 70,785,733 117,207,165 75,545,369 73,279,846 2,265,523 3.0%
Total Ending Fund Balance 17,454,262$ 14,996,787$ 17,565,283$ 15,616,844$ 15,127,407$ 12,169,834$ 17,543,433$ 5,373,599$ 44.2%
Summary of Sources and Uses Annual Actual YTD Actual Favorable (Unfavorable)
2013 2014 2015 Variance
Annual Actual YTD Actual Annual Budget YTD Budget YTD Actual
Monthly Financial Report August 2015
Page 1 of 36
Monthly Financial Report August 2015
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through August 31, 2015. 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
August’s collection is $95k,
making the total year‐to‐date
collection $19.4 million or 53.7%
of the total budget. In
comparison to the previous year,
the City collected $876k or 5%
more. Compared to the budget,
the City is above projections by
$423k or 2%. The variances from
prior year and budget are due to a
change in recognition of REET. In
2014 and prior, the City recorded
the activity in the month it
occurred. In 2015, the City is
recording REET in the month the
City’s receives the cash deposit.
The City is projecting property taxes to meet the budget at year‐end.
Sales Tax
August 2015 sales tax receipts
totalled $2.2 million. Compared
with the same month last year, it
is $148k or 7% more. Compared
to the projected current month’s
budget, it is $238k or 12% above.
The year‐to‐date collection of
$15.1 million is $1.1 million or 8%
more than the prior year and is
also $522k or 4% more than
budgeted. New Construction,
Auto Sales, General Retail, and
Services are the main sectors that
are collecting more than
anticipated. 2015’s monthly
budgets are generally based on
2010 through 2014 collections. The City is projecting sales taxes to meet the budget at year‐end.
2014 2015 2015
Actual Budget Actual $ % $ %
Jan (101,807)$ 27,853$ 67,234$ 169,041$ ‐166% 39,381$ 141%
Feb 176,551 292,775 307,006 130,455 74% 14,231 5%
Mar 1,626,283 1,066,055 939,218 (687,065) ‐42% (126,838) ‐12%
Apr 5,808,865 8,037,494 10,160,118 4,351,253 75% 2,122,623 26%
May 10,692,069 8,544,299 7,583,868 (3,108,202) ‐29% (960,431) ‐11%
Jun (244,519) 17,789 147,318 391,837 ‐160% 129,528 728%
Jul 352,287 527,609 65,395 (286,892) ‐81% (462,214) ‐88%
Aug 178,936 427,951 94,817 (84,119) ‐47% (333,134) ‐78%
Sep 574,579 515,969
Oct 11,777,175 9,346,477
Nov 4,051,387 6,227,843
Dec 403,584 1,007,885
YTD Total 18,488,664$ 18,941,825$ 19,364,972$ 876,308$ 5% 423,147$ 2%
Annual Total 35,295,390$ 36,040,000$
Property Tax Revenues
Year to Date through August
2015 vs. 2014 2015 vs. Budget
Month
2014 2015 2015
Actual Budget Actual $ % $ %
Jan 1,607,045$ 1,736,775$ 1,758,332$ 151,287$ 9% 21,557$ 1%
Feb 2,079,673 2,139,897 2,260,395 180,722 9% 120,498 6%
Mar 1,562,210 1,658,321 1,674,147 111,937 7% 15,826 1%
Apr 1,558,271 1,679,689 1,750,506 192,235 12% 70,817 4%
May 1,759,697 1,950,137 1,977,843 218,146 12% 27,706 1%
Jun 1,669,870 1,753,064 1,677,458 7,588 0% (75,606) ‐4%
Jul 1,731,929 1,763,868 1,866,949 135,020 8% 103,080 6%
Aug 2,030,161 1,940,381 2,178,289 148,128 7% 237,908 12%
Sep 1,849,720 1,834,221 ‐
Oct 1,869,025 1,923,863 ‐
Nov 1,952,887 1,959,088 ‐
Dec 1,841,892 1,900,427 ‐
YTD Total 13,998,857$ 14,622,132$ 15,143,919$ 1,145,062$ 8% 521,787$ 4%
Annual Total 21,512,379$ 22,239,731$
2015 vs. Budget2015 vs. 2014
Month
Year to Date through August
Local Retail Sales Tax Revenues
Page 2 of 36
Monthly Financial Report August 2015
The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business
sectors:
Utility tax
August utility tax revenues are
$1.4 million, which is $81k or 6%
higher than the same month last
year and is also ahead of the
budget by $58k or 4%. The year‐
to‐date collection is $12 million,
which is $682k or 6% higher than
the prior year but is $377k or 3%
lower than the budget. Excluding
audit related collections, the City
is projecting utility tax revenues
to be under the budget at year‐
end.
The table below breaks out Utility Tax by source. The variance for Electrical and Natural Gas utilities is due to lower activity.
The favourable utility tax audit revenues are gross and do not include the related audit fees (projected to be $372k for
2015).
2014 2015 2015
Actual Budget Actual $ % $ %
Jan 1,373,119$ 1,371,800$ 1,199,348$ (173,771)$ ‐13% (172,452)$ ‐13%
Feb 1,524,563 1,510,913 1,371,771 (152,792) ‐10% (139,143) ‐9%
Mar 1,631,438 1,441,880 1,544,060 (87,378) ‐5% 102,180 7%
Apr 1,218,999 1,419,168 1,263,898 44,900 4% (155,270) ‐11%
May 1,380,317 1,391,839 1,262,764 (117,553) ‐9% (129,076) ‐9%
Jun 1,376,544 1,310,144 1,815,284 438,740 32% 505,140 39%
Jul 1,526,628 2,620,657 2,175,167 648,538 42% (445,490) ‐17%
Aug 1,270,116 1,293,475 1,351,000 80,884 6% 57,525 4%
Sep 1,206,313 1,338,119
Oct 1,202,725 1,163,623
Nov 1,170,266 1,233,232
Dec 1,495,099 1,512,883
YTD Total 11,301,725$ 12,359,876$ 11,983,292$ 681,567$ 6% (376,584)$ ‐3%
Annual Total 16,376,127$ 17,607,734$
2015 vs. Budget2015 vs. 2014
Year to Date through August
Utility Tax Revenues
Month
Sales Tax by Sector 2014 2015 Bgt YTD Act Change 2015/2014 2015 Act vs Bgt
New Construction 1,396,108$ 1,627,054$ 1,784,455$ 388,347$ 28%$ 157,400 10%
Auto Sales 2,655,909 2,766,469 2,954,996 299,087 11% 188,527 7%
General Retail 4,376,153 4,479,539 4,681,060 304,907 7% 201,521 4%
Manufacturing 1,385,728 1,393,643 1,166,196 (219,532) ‐16% (227,447)‐16%
Wholesale 763,291 773,392 780,454 17,162 2% 7,061 1%
Service 3,023,280 3,092,735 3,396,374 373,094 12% 303,639 10%
Other 398,389 489,300 380,384 (18,005) ‐5% (108,916)‐22%
YTD Total 13,998,857$ 14,622,132$ 15,143,919$ 1,145,062$ 8%521,787$ 4%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility Tax by Type 2014 2015 Bgt YTD Act Change 2015/2014 2015 Act vs Bgt
Electrical 3,554,849$ 3,655,478$ 3,286,688$ (268,161)$ ‐8%$ (368,790)‐10%
Natural Gas 1,423,301 1,415,863 1,233,226 (190,075) ‐13% (182,637)‐13%
Cell 1,233,774 1,232,136 1,112,742 (121,032) ‐10% (119,395)‐10%
Phone 616,067 622,589 636,126 20,059 3% 13,537 2%
Cable 995,180 1,031,252 1,038,885 43,705 4% 7,633 1%
Garbage/Solid Waste 373,166 263,350 404,233 31,067 8% 140,883 53%
City Utilities 2,644,875 2,705,209 2,825,314 180,439 7% 120,105 4%
Utility Tax Audit 460,513 1,434,000 1,446,078 985,565 214% 12,078 1%
YTD Total 11,301,725$ 12,359,876$ 11,983,292$ 681,567$ 6%(376,584)$ ‐3%
Annual Total 16,376,127$ 17,607,734$
YTD as % of 69% 70%
Page 3 of 36
Monthly Financial Report August 2015
Other Taxes
Real Estate Excise Tax
The City collected $282k in Real
Estate Excise Tax revenues (REET)
for August. This is $65k or 19%
less than the same month last
year and is $42k or 13% less than
the current month’s budget. The
year‐to‐date collection is $2.9
million, which is $447k or 13% less
than the prior year but is $46k or
2% above the budget. The higher
than expected variance is due to
14 large transactions in February,
March, April, May and June which
accounts for $539k of the total
REET collected. The City is
projecting REET to be very close to
the budget at year‐end.
Gambling Tax
August’s Gambling Tax collections
totalled $227k, which is $96k or
74% above the same month last
year and is also above the current
month’s budget by $103k or 83%.
The year‐to‐date total of $1.5
million is $449k or 43% above the
prior year and is also $488k or
48% above budget. $77k of the
year‐to‐date collections are from
a payment plan of back taxes
earned in 2013/2014. The City is
projecting gambling taxes to
exceed the budget at year‐end.
Pull tabs overall had a 9%
increase, bingo had a 22% decrease, and card‐rooms are seeing 62% higher in activities when compared to the prior year.
Franchise Fees
Franchise Fees are due quarterly
in January, April, July, and
October. The year‐to‐date total
of $1 million is $38k or 4% higher
than the prior year and is also
$101k or 11% above the projected
year‐to‐date budget. The City is
projecting franchise fees to
exceed the budget at year‐end.
2014 2015 2015
Actual Budget Actual $ % $ %
Jan 162,143$ 173,895$ 226,377$ 64,234$ 40% 52,482$ 30%
Feb 448,452 321,137 158,616 (289,836) ‐65% (162,521) ‐51%
Mar 227,629 266,310 343,579 115,950 51% 77,269 29%
Apr 909,120 548,260 438,485 (470,635) ‐52% (109,775) ‐20%
May 262,746 315,718 394,014 131,268 50% 78,296 25%
Jun 624,342 504,632 478,186 (146,155) ‐23% (26,445) ‐5%
Jul 350,214 384,017 563,474 213,260 61% 179,457 47%
Aug 346,677 324,185 281,921 (64,756) ‐19% (42,264) ‐13%
Sep 265,534 249,426
Oct 436,050 327,505
Nov 223,675 282,822
Dec 92,179 302,093
YTD Total 3,331,324$ 2,838,154$ 2,884,653$ (446,671)$ ‐13% 46,499$ 2%
Annual Total 4,348,762$ 4,000,000$
Real Estate Excise Tax Revenues
Year to Date through August
Month
2015 vs. Budget2015 vs. 2014
2014 2015 2015
Actual Budget Actual $ % $ %
Jan 131,776$ 142,914$ 158,293$ 26,516$ 20% 15,379$ 11%
Feb 133,109 111,429 184,189 51,080 38% 72,759 65%
Mar 153,695 142,756 169,262 15,567 10% 26,506 19%
Apr 103,980 142,027 207,646 103,666 100% 65,619 46%
May 138,319 127,128 183,090 44,771 32% 55,962 44%
Jun 135,701 105,469 174,036 38,335 28% 68,567 65%
Jul 122,588 114,073 194,895 72,306 59% 80,822 71%
Aug 130,381 124,075 226,785 96,404 74% 102,710 83%
Sep 139,444 137,724 ‐
Oct 155,499 144,185 ‐
Nov 156,921 146,442 ‐
Dec 148,970 161,778 ‐
YTD Total 1,049,550$ 1,009,871$ 1,498,195$ 448,645$ 43% 488,324$ 48%
Annual Total 1,650,384$ 1,600,000$
Year to Date through August
2015 vs. 2014 2015 vs. Budget
Gambling Tax Revenue
Month
2014 2015 2015
Actual Budget Actual $ % $ %
Jan 323,121$ 302,491$ 333,343$ 10,222$ 3% 30,852$ 10%
Feb ‐ 95 ‐
Mar ‐ 424 ‐
Apr 323,544 301,608 335,218 11,674 4% 33,610 11%
Jul 324,273 303,714 340,657 16,383 5% 36,943 12%
Oct 321,828 305,167 ‐
Dec 49,502 46,502 ‐
YTD Total 970,939$ 908,331$ 1,009,218$ 38,279$ 4% 101,405$ 11%
Annual Total 1,342,269$ 1,260,000$
Month
2015 vs. 2014 2015 vs. Budget
Franchise Fees Revenue
Year to Date through August
Page 4 of 36
Monthly Financial Report August 2015
Admission Tax
Admission Tax returns are due
quarterly in January, April, July,
and October of each year. July
2015 collections represent
activities conducted during the 2nd
quarter of 2015. The year‐to‐date
collection of $235k is $1k more
than the prior year but is $3k or
1% less than the budget. The City
is projecting admission taxes to be
very close to the budget at year‐
end.
Licenses and Permits
Building Permits and
Development Service Fees
Building Permits and
Development Service Fee
revenues totalled $455k in
August. The year‐to‐date
development fees revenue of $4.1
million is $1 million or 34% more
than the year before and is also
$1 million or 33% higher than
budget. The variance in June/July
2015 is due to a large payment for
building permits and plan
checking fees (Southport
Developer and Group Health
Projects). The City is projecting
building permits and development
service fees to exceed the budget at year‐end (due to one‐time large projects: Southport, Group Health, and Ikea).
Business Licenses
Business Licenses totalled $134k
for August, which is $38k or 40%
above the same month last year
but is right on target with the
current month’s budget. The
year‐to‐date Business Licenses
revenue of $2.3 million is $134k or
6% above the prior year and is
above the budget by $102k or 5%.
The City is projecting business
licenses to be very close to the
budget at year‐end.
2014 2015 2015
Actual Budget Actual $ % $ %
Jan 80,243$ 81,652$ 83,675$ 3,432$ 4% 2,023$ 2%
Feb ‐ ‐ 1,371 1,371 100% 1,371 100%
Mar ‐ ‐ 106 106 100% 106 100%
Apr 74,163 72,512 65,108 (9,055) ‐12% (7,404) ‐10%
May ‐ ‐ 1,523 1,523 100% 1,523 100%
Jun 145 73 ‐
Jul 79,130 83,619 82,804 3,675 5% (815) ‐1%
Aug ‐ 38 ‐
Oct 76,631 81,433 ‐
Nov ‐ 598 ‐
Dec ‐ 75 ‐
YTD Total 233,681$ 237,894$ 234,588$ 1,053$ 0% (3,195)$ ‐1%
Annual Total 310,311$ 320,000$
2015 vs. Budget
Admission Tax Revenue
Year to Date through August
Month
2015 vs. 2014
2014 2015 2015
Actual Budget Actual $ % $ %
Jan 432,890$ 417,515$ 260,603$ (172,288)$ ‐40% (156,913)$ ‐38%
Feb 412,317 354,160 328,557 (83,760) ‐20% (25,602) ‐7%
Mar 388,190 373,356 275,826 (112,364) ‐29% (97,530) ‐26%
Apr 374,004 408,228 655,282 281,279 75% 247,055 61%
May 349,590 404,850 235,121 (114,469) ‐33% (169,729) ‐42%
Jun 516,689 448,800 1,024,848 508,160 98% 576,048 128%
Jul 288,957 333,738 873,549 584,591 202% 539,811 162%
Aug 300,184 353,949 454,971 154,787 52% 101,022 29%
Sep 369,040 343,237
Oct 393,023 463,224
Nov 239,983 351,665
Dec 454,368 427,027
YTD Total 3,062,821$ 3,094,595$ 4,108,757$ 1,045,936$ 34% 1,014,162$ 33%
Annual Total 4,519,234$ 4,679,749$
Building Permits and Development Service Fees
Year to Date through August
2015 vs. Budget2015 vs. 2014
Month
2014 2015 2015
Actual Budget Actual $ % $ %
Jan 597,369$ 544,128$ 588,093$ (9,276)$ ‐2% 43,964$ 8%
Feb 145,936 178,140 222,022 76,086 52% 43,882 25%
Mar 28,425 46,252 26,067 (2,358) ‐8% (20,185) ‐44%
Apr 557,203 543,071 513,360 (43,843) ‐8% (29,711) ‐5%
May 86,852 129,015 167,985 81,133 93% 38,971 30%
Jun 39,763 34,705 25,663 (14,100) ‐35% (9,042) ‐26%
Jul 637,487 611,117 645,791 8,304 1% 34,674 6%
Aug 95,938 134,518 134,328 38,390 40% (190) 0%
Sep 28,686 27,016 ‐
Oct 619,492 640,673 ‐
Nov 108,061 95,071 ‐
Dec 20,639 22,294 ‐
YTD Total 2,188,972$ 2,220,946$ 2,323,308$ 134,336$ 6% 102,362$ 5%
Annual Total 2,965,850$ 3,006,000$
*Total Business License (GF & CIP)
Business Licenses*
Month
2015 vs. 2014
Year to Date through August
2015 vs. Budget
Page 5 of 36
Monthly Financial Report August 2015
Intergovernmental
These revenue sources
include federal (direct and
indirect) grants, state
grants, state shared
revenues, local grants, and
entitlements. State shared
revenues and Fire Districts’
25 and 40 contracts
compose 85% of the total
revenues in this category.
The year‐to‐date total Intergovernmental revenue is $7.8 million or 59% of the budget.
State Shared Revenues
State Shared Revenue
collections totalled $3.3
million since the start of the
year. Compared to the
prior year, State Shared
Revenues are above by
$118k or 4%. Compared to
the projected budget, the
City is collecting $361k or
12% more. The higher than
expected collection is due
to collecting more than
anticipated Criminal Justice
Sales Tax and the low budget of Criminal Justice’s High Crime.
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 58%
of the total revenue in this category. The year‐to‐date total charges for services are $5.8 million or 82% of the budget. The
following sections provide detail information for Public Safety, Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totalled
$497k 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 $11k or 2% less.
Compared to the year‐to‐date
budget, the City is over budget by
$176k or 55%. The large January
2014 variance is due to the timing
of when Valley Narcotics
Enforcement Team (VNET)
contributions are receipted. The
2014 2015 2015
Actual Budget Actual $ % $ %
Jan 117,639$ 50,388$ 58,509$ (59,130)$ ‐50% 8,121$ 16%
Feb 45,139 54,499 42,228 (2,910) ‐6% (12,271) ‐23%
Mar 44,028 27,253 62,481 18,453 42% 35,228 129%
Apr 38,202 34,344 146,715 108,513 284% 112,371 327%
May 35,540 28,065 55,309 19,769 56% 27,243 97%
Jun 107,246 48,449 33,004 (74,242) ‐69% (15,445) ‐32%
Jul 56,212 42,187 39,540 (16,672) ‐30% (2,647) ‐6%
Aug 64,201 35,937 59,046 (5,155) ‐8% 23,109 64%
Sep 44,169 31,301 ‐
Oct 190,822 91,374 ‐
Nov 37,507 29,303 ‐
Dec 65,704 39,982 ‐
YTD Total 508,206$ 321,121$ 496,831$ (11,375)$ ‐2% 175,710$ 55%
Annual Total 846,409$ 513,081$
Month
2015 vs. 2014
Year to Date through August
Public Safety Services
2015 vs. Budget
Intergovernmental 2014 2015 Bgt YTD Act Change 2015/2014 2015 Act vs Bgt
Fire District #25 620,568$ 655,274$ 655,274$ 34,706$ 6% $ ‐ 0%
Fire District #40 2,508,244 2,686,855 2,686,855 178,611 7%‐ 0%
State Shared Revenue 3,198,313 2,955,013 3,316,335 118,022 4% 361,322 12%
Federal Grants 1,050,032 461,747 461,747 (588,285) ‐56%‐ 0%
State Grants 41,174 39,894 39,894 (1,280) ‐3%‐ 0%
Other Grants/Intgovt 134,504 642,219 635,986 501,483 373% (6,233) ‐1%
ARRA Grants ‐ 0 ‐ ‐ N/A ‐ 0%
Total Rev YTD 7,552,833$ 7,441,002$ 7,796,091$ 243,258$ 3%355,089$ 5%
Total Rev Annual 13,664,242$ 13,251,387$
YTD %55% 56% 59%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
2014 2015 2015
Actual Budget Actual $ % $ %
Crim Just Sales Tax 1,470,567$ 1,494,059$ 1,612,067$ 141,500$ 10% 118,008$ 8%
Judicial Contribution 16,968 ‐ 10,895 (6,073) ‐36% 10,895 100%
Crim Just ‐ High Crime 191,330 ‐ 125,694 (65,636) ‐34% 125,694 100%
Crim Just ‐ Pop 18,245 17,776 19,332 1,086 6% 1,556 9%
Crim Just ‐ Spec Prog 67,823 66,090 70,894 3,072 5% 4,804 7%
State DUI 12,949 12,704 10,847 (2,102) ‐16% (1,858) ‐15%
Liquor Profits 424,823 425,177 425,911 1,087 0% 734 0%
Liquor Excise Tax 132,726 120,345 153,491 20,764 16% 33,146 28%
Fuel Tax 862,881 818,861 887,205 24,324 3% 68,344 8%
YTD Total 3,198,313$ 2,955,013$ 3,316,335$ 118,022$ 4% 361,322$ 12%
Annual Total 5,045,728$ 4,777,519$
Year to Date through August
State Shared Revenues
2015 vs. 2014
Revenue
2015 vs. Budget
Page 6 of 36
Monthly Financial Report August 2015
large June 2014 variance is due to staff reimbursement for training provided to the Basic Law Enforcement Academy. The large
October 2014 variance is due to staff reimbursement for the Oso mudslide. April 2015 variance is due to receipting $75k
reimbursement for the School Resource Officer (SRO) program. The City is projecting public safety services to exceed the budget
at year‐end.
Recreation
Recreation revenues totalled
$313k for the current month.
Compared to the same month the
prior year, the City collected $67k
or 27% more. Compared to the
projected monthly budget, the
City collected $74k or 31% more.
The year‐to‐date collection of
$1.3 million is $81k or 7% higher
than the year before and is also
$43k or 3% higher than the year‐
to‐date budget. The variance
with the prior year and monthly
budget is due to a change in how
the recreation class revenues are
recorded. The City is now
recognizing class revenues as the classes begin instead of when they are paid. The City currently has $177k in class revenues to
be recognized as soon as the classes begin. The City is projecting recreation revenues to be under the budget at year‐end.
Interfund Services
The year‐to‐date collections for
Interfund Services revenues are
$2.1 million. Compared to the
prior year, the revenues are under
by $125k or 6%. Compared to the
projected budget, the revenues
are below by $55k or 3%. 2015’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. The City is projecting interfund
services to be very close to the budget at year‐end.
2014 2015 2015
Actual Budget Actual $ % $ %
Jan 69,522$ 68,996$ 117,124$ 47,602$ 68% 48,128$ 70%
Feb 68,873 63,673 30,177 (38,696) ‐56% (33,495) ‐53%
Mar 66,458 77,421 35,946 (30,513) ‐46% (41,475) ‐54%
Apr 179,282 185,568 91,404 (87,879) ‐49% (94,164) ‐51%
May 106,771 107,408 64,015 (42,756) ‐40% (43,393) ‐40%
Jun 172,332 171,135 227,942 55,610 32% 56,807 33%
Jul 318,669 352,117 428,943 110,275 35% 76,826 22%
Aug 245,982 239,664 313,197 67,215 27% 73,533 31%
Sep 119,109 128,721 ‐
Oct 72,614 82,910 ‐
Nov 36,383 54,128 ‐
Dec 29,129 48,876 ‐
YTD Total 1,227,889$ 1,265,981$ 1,308,748$ 80,859$ 7% 42,767$ 3%
Annual Total 1,485,123$ 1,580,616$
Recreation
Year to Date through August
2015 vs. Budget2015 vs. 2014
Month
2014 2015 2015
Actual Budget Actual $ % $ %
Jan 301,808$ 268,496$ 265,068$ (36,741)$ ‐12% (3,428)$ ‐1%
Feb 257,027 268,496 264,413 7,386 3% (4,083) ‐2%
Mar 287,465 268,496 260,071 (27,393) ‐10% (8,424) ‐3%
Apr 295,489 268,496 248,466 (47,023) ‐16% (20,030) ‐7%
May 269,032 268,496 260,774 (8,259) ‐3% (7,722) ‐3%
Jun 277,620 268,496 292,480 14,860 5% 23,985 9%
Jul 244,707 268,496 252,451 7,744 3% (16,045) ‐6%
Aug 284,344 268,496 248,774 (35,570) ‐13% (19,721) ‐7%
Sep 278,550 268,496 ‐
Oct 256,662 268,496 ‐
Nov 254,192 268,496 ‐
Dec 263,607 268,496 ‐
YTD Total 2,217,492$ 2,147,965$ 2,092,497$ (124,996)$ ‐6% (55,468)$ ‐3%
Annual Total 3,270,503$ 3,221,947$
2015 vs. Budget
Month
Interfund Services
Year to Date through August
2015 vs. 2014
Page 7 of 36
Monthly Financial Report August 2015
Fines and Penalties
These revenue sources contain
civil (penalties, infractions, and
parking), criminal (traffic, non‐
traffic, and costs), and non‐court
fines, forfeitures, and penalties.
The table below breaks down
these fines by type. The year‐to‐
date total fines and penalties is
$1.9 million. This is $235k or 14%
higher than a year ago but is
$309k or 14% below the budget.
The reason for the variance with
the prior year and budget is due to
a change in accounting for
December 2014’s revenue. In the
past we would record December
through November, but starting in 2015 we are recording January through December. The City is projecting fines and penalties
to be under the budget at year‐end.
Included in the Fines and Penalties revenue
budget is $2.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
$1.4 million.
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 $308k 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 and February 2015’s equipment rental costs were recorded in March. The City is projecting photo enforcement
program revenues to be under the budget at year‐end.
2014 2015 2015
Actual Budget Actual $ % $ %
Jan 136,762$ 180,526$ 124,856$ (11,906)$ ‐9% (55,670)$ ‐31%
Feb 151,470 241,215 213,981 62,511 41% (27,234) ‐11%
Mar 203,482 285,153 275,737 72,255 36% (9,417) ‐3%
Apr 263,785 357,892 245,206 (18,579) ‐7% (112,686) ‐31%
May 208,436 298,306 257,217 48,781 23% (41,089) ‐14%
Jun 224,214 299,729 268,116 43,903 20% (31,612) ‐11%
Jul 205,103 271,908 221,949 16,846 8% (49,959) ‐18%
Aug 258,728 261,362 280,257 21,529 8% 18,895 7%
Sep 247,480 243,883
Oct 239,990 262,728
Nov 287,406 292,068
Dec 256,092 325,729
YTD Total 1,651,980$ 2,196,092$ 1,887,318$ 235,338$ 14% (308,774)$ ‐14%
Annual Total 2,682,948$ 3,320,500$
Month
2015 vs. Budget2015 vs. 2014
Year to Date through August
Fines and Penalties by Month
Year to Date through August
2014 2015 2015
Actual Budget Actual $ % $ %
Civil Penalties 4,473$ 9,983$ 2,074$ (2,399)$ ‐54% (7,909)$ ‐79%
Civil Infraction Penalties 368,761 401,903 246,446 (122,315) ‐33% (155,457) ‐39%
Civil Parking Infraction Penalties 116,580 122,460 94,999 (21,581) ‐19% (27,461) ‐22%
Photo Enforcement Program 976,256 1,461,863 1,368,096 391,839 40% (93,767) ‐6%
Criminal Traffic Misdemeanor Fines 57,759 74,154 49,012 (8,746) ‐15% (25,142) ‐34%
Criminal Non‐Traffic Fines 25,851 28,904 43,116 17,265 67% 14,212 49%
Criminal Costs 84,861 80,956 65,268 (19,593) ‐23% (15,688) ‐19%
Non ‐Court Fines, Forfeitures and Penalties 17,440 15,870 18,308 868 5% 2,438 15%
YTD Total 1,651,980$ 2,196,092$ 1,887,318$ 235,338$ 14% (308,774)$ ‐14%
Annual Total 2,682,948$ 3,320,500$
Revenue
2015 vs. Budget
Fines and Penalties by Type
2015 vs. 2014
Favorable
15 Budget 15 Actual 15 Budget 15 Actual (Unfavorable)
1
Jan 138,983$ 121,709$ 88,955$ 25,705$ 96,004$
Feb 148,513 152,185 88,955 25,705 126,480
Mar 168,263 198,034 88,955 162,480 35,554
Apr 251,837 166,166 88,955 94,253 71,913
May 200,513 164,775 88,955 94,100 70,675
Jun 191,262 200,678 88,955 94,154 106,524
Jul 193,937 148,024 88,955 94,291 53,734
Aug 168,554 216,524 88,955 94,258 122,266
Sep 153,716 ‐ 88,955 ‐ ‐
Oct 170,949 ‐ 88,955 ‐ ‐
Nov 199,054 ‐ 88,955 ‐ ‐
Dec 208,419 ‐ 88,955 ‐ ‐
YTD Total 1,461,863$ 1,368,096$ 711,640$ 684,945$ 683,151$
Annual Total 2,194,000$ 1,067,460$
1Actuals of Revenues and Expenses
Photo Enforcement Program
Year to Date through August
Month
Revenues Expenses
Page 8 of 36
Monthly Financial Report August 2015
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. Interest and other
earnings along with rents, leases,
and concessions constitute 73% of
the total revenue in this category.
The year‐to‐date total
miscellaneous is $1.5 million.
Compared to last year, the
revenues are above by $465k or
46%. Compared to the projected
year‐to‐date budget, the revenues
are over by $460k or 45%. The negative amount for July 2014 is due to a correction made to move interest earned from Utility
tax audits, originally recorded in June. The large variance in January 2015 and September 2014 is due to recording a trued up
asset interfund interest received from Surface Water Utility. This offsets the correction made to the acreage count Street
Maintenance pays to Surface Water. The table below page breaks out miscellaneous revenues by type. The City is projecting
miscellaneous revenues to exceed the budget at year‐end.
Interest and other earnings are higher than the prior year and budget due to the timing of when interfund interest was recorded
from Surface Water to Street Maintenance (prior year, trued up in September).
Other miscellaneous revenues are higher than the prior year and budget due to higher than expected utility late payment
penalties and miscellaneous fire reimbursements.
EXPENSES
Overall the City has expended 63% of its budgeted general governmental expenditures at the end of August. This is $2.3 million
or 3% below year‐to‐date budgeted expenditures. The City did not have any general governmental departments over budget
but we did see some divisions within those departments over budget. Please refer to the General Governmental Funds Summary
of Sources and Uses table on page 1 for details.
2014 2015 2015
Actual Budget Actual $ % $ %
Jan 243,963$ 195,690$ 269,664$ 25,701$ 11% 73,974$ 38%
Feb 99,547 79,577 135,539 35,992 36% 55,962 70%
Mar 126,132 141,867 182,386 56,253 45% 40,519 29%
Apr 70,094 79,651 132,893 62,799 90% 53,242 67%
May 107,650 136,284 144,753 37,103 34% 8,469 6%
Jun 257,714 216,188 215,629 (42,085) ‐16% (559) 0%
Jul (21,407) 38,498 189,913 211,319 ‐987% 151,414 393%
Aug 121,979 123,312 199,969 77,990 64% 76,657 62%
Sep 552,749 422,616
Oct 119,594 105,792
Nov 128,732 106,773
Dec 491,839 533,961
YTD Total 1,005,672$ 1,011,068$ 1,470,745$ 465,073$ 46% 459,677$ 45%
Annual Total 2,298,586$ 2,180,209$
Year to Date through August
Month
2015 vs. Budget2015 vs. 2014
Miscellaneous Revenues by Month
2014 2015 2015
Actual Budget Actual $ % $ %
Interests and Other Earnings 91,426$ 101,203$ 462,120$ 370,693$ 405% 360,917$ 357%
Rents, Leases, and Concessions 578,552 570,425 608,000 29,449 5% 37,575 7%
Contributions/Donations from Private Sources 83,499 87,823 93,874 10,374 12% 6,051 7%
Other 248,848 194,294 300,308 51,460 21% 106,014 55%
Seizure Funds ‐ Federal/State/Local 3,346 57,323 6,444 3,097 93% (50,880) ‐89%
YTD Total 1,005,672$ 1,011,068$ 1,470,745$ 465,073$ 46% 459,677$ 45%
Annual Total 2,298,586$ 2,180,209$
2015 vs. Budget
Miscellaneous Revenues by Type
Year to Date through August
Revenue
2015 vs. 2014
Page 9 of 36
Monthly Financial Report August 2015
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 fund are the capital revenues and expenditures.
Airport Golf Course Solid Waste
Utility Water Utility Wastewater
Utility
Surface Water
Utility Metro
REVENUES:
Licenses and permits ‐ ‐ ‐ ‐ 67,775 35,550 ‐
Grants / intergovernmental 1,706,871 ‐ 109,496 ‐ 15,161 1,053,148 ‐
Charges for services 98,686 1,488,359 11,691,230 11,684,310 6,643,765 7,120,366 10,718,861
Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐
Fines and penalties 1,870 ‐ ‐ ‐ 495 ‐ ‐
Rents, leases, and misc fees 1,652,348 308,192 59,004 104,906 ‐ ‐ ‐
Interest and other misc 3,906 8,278 10,085 657,770 707,452 1,099,899 11,768
TOTAL REVENUES 3,463,681 1,804,829 11,869,816 12,446,986 7,434,648 9,308,963 10,730,629
EXPENSES:
Utility billing ‐ ‐ 87,659 79,316 63,122 101,701 ‐
Utility systems ‐ ‐ 9,805,899 2,709,574 2,108,734 2,203,888 ‐
Utility maintenance ‐ ‐ 185,717 3,407,928 999,740 1,674,168 10,233,043
Transportation 1,036,280 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 1,323,620 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 1,036,280 1,323,620 10,079,275 6,196,818 3,171,596 3,979,757 10,233,043
AMOUNT AVAILABLE FOR DEBT SERVICE 2,427,401 481,209 1,790,540 6,250,168 4,263,052 5,329,206 497,586
DEBT SERVICE:
Principal ‐ ‐ ‐ 395,175 265,745 42,590 ‐
Interest ‐ ‐ ‐ 297,136 148,920 474,359 ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ 692,311 414,665 516,949 ‐
CAPITAL PROJECTS 1,984,186 ‐ ‐ 611,698 484,681 2,355,710 ‐
TRANSFERS IN/(OUT)‐ ‐ (629) (3,504) (644) (317) ‐
CHANGE IN FUND BALANCE 443,215 481,209 1,789,911 4,942,655 3,363,062 2,456,230 497,586
BEGINNING FUND BALANCE, Jan 1 806,821 (42,911) 1,545,606 15,872,094 7,589,089 7,804,221 3,316,310
ENDING FUND BALANCE, Aug 31 1,250,036 438,298 3,335,517 20,814,749 10,952,151 10,260,451 3,813,896
Page 10 of 36
Monthly Financial Report August 2015
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 ‐ 114,911 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ ‐ ‐ ‐ ‐ ‐ 40,057
Charges for services
Equipment rental m&o 1,857,252 2,339,237 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 58,780 ‐ 280,298 ‐ ‐ ‐
Communications ‐ 3,183 ‐ 385,621 ‐ ‐ ‐
Facilities ‐ ‐ 3,280,987 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 106,954 ‐ ‐ ‐ ‐ ‐
IT service co ntracts ‐ 328,304 ‐ ‐ ‐ ‐ ‐
Interest and other misc 17,320 7,085 4,487 1,510 45,478 22,889 26,772
Internal service fund misc:
Vehicle / equipment capital recovery 1,973,983 113,336 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 1,237,424 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 1,229,946 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 7,734,547 1,484,400
Other misc 1,843 300 3,153 17 ‐ 785,828 ‐
Interfund Loan ‐ ‐ ‐ ‐ 143,079 ‐ ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets 63,271 ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 62,336 ‐ ‐
TOTAL REVENUES 3,913,669 3,072,090 3,288,627 667,446 2,718,263 8,543,264 1,551,229
EXPENSES:
Communications 277,571
Equipment rental 1,446,916
Facilities 2,841,369
Healthcare 8,342,054
Information technology 2,413,685
Print and mail 247,337
Retiree healthcare 736,717
Risk management:
Ri sk management 1,455,304
Unemployment 29,303
Worker's compensation 1,057,007
TOTAL EXPENSES 1,446,916 2,413,685 2,841,369 524,908 2,541,614 8,342,054 736,717
AMOUNT AVAILABLE FOR CAPITAL 2,466,753 658,405 447,258 142,538 176,649 201,210 814,512
CAPITAL PROJECTS 2,637,550 273,123 338,787 ‐ ‐ ‐ ‐
TRANSFERS IN 125,500 62,700 ‐ ‐ 1,300,000 ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE (45,297) 447,982 108,471 142,538 1,476,649 201,210 814,512
BEGINNING FUND BALANCE, Jan 1 5,310,319 1,916,048 1,154,089 383,969 12,069,311 6,675,505 7,711,863
ENDING FUND BALANCE, Aug 31 5,265,022 2,364,030 1,262,560 526,507 13,545,960 6,876,715 8,526,375
Page 11 of 36
Monthly Financial Report August 2015
FUND BALANCE
Page 13 shows the ending fund balance as of August 2015. The City’s fund balance is a combination of current deficit/surplus of
funds which have accrued from unexpended operating budgets, unanticipated excess revenues, and from balances accumulated
from prior years.
The prior year’s balances (or beginning balance) include funds identified as being reserved for specific purposes or required to
meet the current year’s appropriations. These balances also provide financial stability to the City’s operation during uncertain
times and provide a layer of security to bondholders.
At the end of August, the City has $17.5 million reported in the combined general governmental fund balance of the current
year’s operating budget, which is approximately 15% of budgeted operating expenditures. This is a decrease of $22k from the
year’s beginning balance. August’s ending fund balance is over the anticipated General Governmental Fund Balance of $12.2
million by $5.4 million or 44.2%. Although the ending fund balance is above projections, it is consistent with the prior years’
trends.
CONTACT INFORMATION
This report is prepared by the Finance Division of the Administrative Services Department. For additional financial information,
please also review our website: http://www.rentonwa.gov/. For any questions about the report, please feel free to contact us at
hnguyen@rentonwa.gov or JDThomas@Rentonwa.gov.
Page 12 of 36
Monthly Financial Report August 2015
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through August 31, 2015
Funds
Balance
01/01/2015
Budgeted
Revenue
Revenue
08/31/15
Total Funds
Available
Budgeted
Expenditure
Expenditure
08/31/15 Ending Balance
GENERAL GOVERNMENT FUNDS: 17,565,282 128,461,095 86,949,801 104,515,083 130,898,969 86,971,650 17,543,433
000 General 11,159,313 84,865,472 55,478,131 66,637,444 87,025,065 57,469,412 9,168,032
001 Community Services 2,467,703 12,478,920 7,570,791 10,038,494 12,608,356 7,693,968 2,344,526
003 Street 2,147,229 10,186,242 6,061,946 8,209,175 10,353,242 6,538,017 1,671,158
004 Community Dev Block Grant 74,951 462,908 ‐ 74,951 448,804 37,103 37,848
005 Museum 65,500 227,761 114,043 179,543 227,761 151,082 28,461
009 Farmers Market 104,950 59,400 41,584 146,534 59,453 55,732 90,802
011 Fire Health & Wellness 74,565 25,000 13,547 88,112 25,000 11,318 76,794
201 Ltd GO Bonds Gen Govt Debt 838,633 1,749,405 878,697 1,717,330 1,749,405 97,050 1,620,280
215 Gen Govt Misc Debt Service 632,438 18,405,987 16,791,062 17,423,500 18,401,883 14,917,968 2,505,532
SPECIAL REVENUE FUNDS: 1,100,381 1,786,631 1,136,345 2,236,726 1,807,969 873,818 1,362,908
102 Arterial Street 14,885 640,000 418,161 433,046 640,000 ‐ 433,046
108 Leased City Properties 121,014 768,957 442,529 563,543 663,403 681,171 (117,628)
110 Hotel Motel 219,090 265,000 191,214 410,304 283,942 120,774 289,530
125 1% For Art 101,380 15,000 335 101,715 102,950 ‐ 101,715
127 Cable Communication 313,090 97,674 83,015 396,105 117,674 71,873 324,232
135 Springbrook Wetlands Bank 330,922 ‐ 1,091 332,013 ‐ ‐ 332,013
CAPITAL PROJECT FUNDS (CIP):27,979,966 25,305,129 8,983,164 36,963,130 48,907,406 15,821,123 21,142,007
303 Community Dev Mitigation 1,238,600 86,500 310,872 1,549,472 ‐ ‐ 1,549,472
304 Fire Mitigation 926,488 99,000 398,584 1,325,072 250,000 ‐ 1,325,072
305 Transportation Mitigation 844,648 600,000 1,005,611 1,850,259 1,152,335 ‐ 1,850,259
316 Municipal Facilities CIP 4,493,986 5,546,015 3,874,290 8,368,276 9,746,585 3,807,500 4,560,776
317 Transportation CIP 4,059,718 18,973,614 3,350,985 7,410,703 22,353,726 3,382,619 4,028,084
326 Housing Opportunity 1,086,766 ‐ 3,509 1,090,275 75,000 50,000 1,040,275
336 New Library Development 15,329,760 ‐ 39,313 15,369,073 15,329,760 8,581,004 6,788,069
ENTERPRISE FUNDS:36,891,230 97,849,061 57,092,882 93,984,112 107,984,277 43,119,015 50,865,097
4X2 Airport Operating & CIP 806,821 16,596,888 3,463,681 4,270,502 16,469,927 3,020,466 1,250,036
403 Solid Waste Utility 1,545,606 16,461,726 11,869,816 13,415,422 16,675,139 10,079,904 3,335,518
4X4 Golf Operating & CIP (42,911) 2,655,383 1,838,160 1,795,249 2,616,052 1,356,952 438,297
4X5 Water Operating & CIP 15,872,094 16,272,634 12,446,985 28,319,079 20,799,381 7,504,332 20,814,747
4X6 Waste Water Operating & CIP 7,589,089 11,979,140 7,434,648 15,023,737 13,588,076 4,071,584 10,952,153
416 King County Metro 3,316,310 16,638,722 10,730,630 14,046,940 16,638,722 10,233,043 3,813,897
4X7 Surface Water Operating & CIP 7,804,221 17,244,568 9,308,962 17,113,183 21,196,980 6,852,734 10,260,449
INTERNAL SERVICE FUNDS:35,221,104 37,393,475 25,242,785 60,463,889 37,332,083 22,096,722 38,367,167
501 Equipment Repair/Replacement 5,310,319 5,901,271 4,039,169 9,349,488 7,436,777 4,084,465 5,265,023
502 Insurance 12,069,311 5,641,647 4,018,262 16,087,573 3,594,578 2,541,614 13,545,959
503 Information Services 1,916,048 4,677,631 3,134,789 5,050,837 5,653,265 2,686,808 2,364,029
504 Facilities 1,154,089 4,954,325 3,288,627 4,442,716 5,115,716 3,180,156 1,262,560
505 Communications 383,969 992,431 667,446 1,051,415 991,430 524,908 526,507
512 Insurance, Healthcare 6,675,505 12,954,736 8,543,264 15,218,769 13,424,573 8,342,054 6,876,715
522 Insurance, Leoff1 Retirees HC 7,711,863 2,271,434 1,551,228 9,263,091 1,115,744 736,717 8,526,374
FIDUCIARY FUNDS:5,040,982 468,000 154,511 5,195,493 210,475 149,966 5,045,527
611 Firemen's Pension 5,040,982 468,000 154,511 5,195,493 210,475 149,966 5,045,527
TOTAL FUNDS 123,798,945 291,263,391 179,559,488 303,358,433 327,141,179 169,032,294 134,326,139
Page 13 of 36
City of Renton
General Government Financial Position
2015 Budget Year
General Government Summary
Revenues Expenditures
$ Difference
over (under)
w/beginning
balance
17,565,282
January 5,697,180 8,067,548 (2,370,368) 15,194,914
February 11,956,490 17,074,731 (5,118,241) 12,447,041
March 18,465,333 25,740,531 (7,275,198) 10,290,084
April 35,699,323 33,688,640 2,010,683 19,575,965
May 51,254,305 42,084,303 9,170,002 26,735,284
June 58,502,159 51,004,212 7,497,948 25,063,230
July 66,463,072 64,338,959 2,124,113 19,689,395
August 73,257,997 73,279,846 (21,849) 17,543,433
September
October
November
December
(9,000,000)
(8,000,000)
(7,000,000)
(6,000,000)
(5,000,000)
(4,000,000)
(3,000,000)
(2,000,000)
(1,000,000)
‐
1,000,000
2,000,000
3,000,000
4,000,000
5,000,000
6,000,000
7,000,000
8,000,000
9,000,000
10,000,000
11,000,000
‐
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 14 of 36
City of Renton
Monthly Revenue Analysis ‐ 2015 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 5,748,533 5,697,180 ‐0.89%
Feb 12,071,152 11,956,490 ‐0.95%
Mar 18,496,983 18,465,333 ‐0.17%
Apr 33,360,837 35,699,323 7.01%
May 50,019,624 51,254,305 2.47%
Jun 56,034,442 58,502,159 4.40%
Jul 63,719,267 66,463,072 4.31%
Aug 70,149,921 73,257,997 4.43%
Sep 76,746,654
Oct 92,647,128
Nov 107,214,921
Dec 114,769,291
Percent of budget 63.83%
Property Tax Budget
YTD
Actual
Annual %
over (under)
Jan 27,853 67,234 141.39%
Feb 320,628 374,240 16.72%
Mar 1,386,683 1,313,457 ‐5.28%
Apr 9,424,178 11,473,575 21.75%
May 17,968,476 19,057,443 6.06%
Jun 17,986,266 19,204,760 6.77%
Jul 18,513,875 19,270,155 4.08%
Aug 18,941,825 19,364,972 2.23%
Sep 19,457,794
Oct 28,804,271
Nov 35,032,115
Dec 36,040,000
Percent of budget 53.73%
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
$120
$130
Millions
Total Revenue
General Government
Budget
Actual
Last Year
$(3)
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
$36
Millions Property Tax
Budget
Actual
Last Year
Page 15 of 36
City of Renton
Monthly Revenue Analysis ‐ 2015 Budget Year
Sales Tax Budget
YTD
Actual
Annual %
over (under)
Jan 1,930,372 1,966,653 1.88%
Feb 4,312,924 4,494,673 4.21%
Mar 6,156,744 6,366,163 3.40%
Apr 8,019,181 8,324,401 3.81%
May 10,179,318 10,538,752 3.53%
Jun 12,126,605 12,415,056 2.38%
Jul 14,093,945 14,503,117 2.90%
Aug 16,267,801 16,939,671 4.13%
Sep 18,318,344
Oct 20,462,487
Nov 22,646,995
Dec 24,759,699
Percent of budget 68.42%
Note: Excludes CJ Sales Tax and Natural Gas Use Tax.
Utility Tax Budget
YTD
Actual
Annual %
over (under)
Jan 1,371,800 1,199,348 ‐12.57%
Feb 2,882,713 2,571,119 ‐10.81%
Mar 4,324,593 4,115,178 ‐4.84%
Apr 5,743,761 5,379,077 ‐6.35%
May 7,135,600 6,641,841 ‐6.92%
Jun 8,445,745 8,457,125 0.13%
Jul 11,066,402 10,632,292 ‐3.92%
Aug 12,359,876 11,983,292 ‐3.05%
Sep 13,697,996
Oct 14,861,619
Nov 16,094,851
Dec 17,607,734
Percent of budget 68.06%
Note: Includes Natural Gas Use Tax.
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
Millions Sales Tax
Budget
Actual
Last Year
$‐
$2
$4
$6
$8
$10
$12
$14
$16
$18
$20
Millions Utility Tax
Budget
Actual
Last Year
Page 16 of 36
City of Renton
Monthly Revenue Analysis ‐ 2015 Budget Year
Licenses &
Permits Budget
YTD
Actual
Annual %
over (under)
Jan 401,666 299,656 ‐25.40%
Feb 703,556 583,727 ‐17.03%
Mar 936,587 784,273 ‐16.26%
Apr 1,341,646 1,164,263 ‐13.22%
May 1,662,501 1,377,137 ‐17.16%
Jun 2,022,387 1,717,718 ‐15.06%
Jul 2,361,559 2,571,810 8.90%
Aug 2,657,556 2,976,733 12.01%
Sep 2,918,335
Oct 3,399,093
Nov 3,693,994
Dec 3,911,417
Percent of budget 76.10%
Note: GF only
Intergovt'l Budget
YTD
Actual
Annual %
over (under)
Jan 434,559 500,793 15.24%
Feb 1,046,944 1,144,443 9.31%
Mar 1,571,828 1,686,664 7.31%
Apr 2,644,504 2,889,749 9.27%
May 5,550,244 5,820,910 4.88%
Jun 6,251,743 6,536,174 4.55%
Jul 6,639,245 6,947,631 4.64%
Aug 7,441,002 7,796,091 4.77%
Sep 8,136,280
Oct 9,091,290
Nov 12,460,494
Dec 13,251,387
Percent of budget 58.83%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
$‐
$2
$4
$6
$8
$10
$12
$14
Millions
Intergovernmental
Budget
Actual
Last Year
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
Millions Licenses & Permits
Budget
Actual
Last Year
Page 17 of 36
City of Renton
Monthly Revenue Analysis ‐ 2015 Budget Year
Charges for
Services Budget
YTD
Actual
Annual %
over (under)
Jan 540,459 523,882 ‐3.07%
Feb 1,058,401 982,531 ‐7.17%
Mar 1,623,947 1,508,665 ‐7.10%
Apr 2,261,909 2,428,409 7.36%
May 2,818,394 2,895,781 2.75%
Jun 3,443,743 4,190,545 21.69%
Jul 4,226,938 5,100,073 20.66%
Aug 4,889,434 5,829,415 19.22%
Sep 5,431,795
Oct 6,010,048
Nov 6,476,933
Dec 7,084,345
Percent of budget 82.29%
Note: Excludes FD25 & FD40 contracts
Fines &
Forfeits Budget
YTD
Actual
Annual %
over (under)
Jan 180,526 124,856 ‐30.84%
Feb 421,742 338,837 ‐19.66%
Mar 706,895 614,574 ‐13.06%
Apr 1,064,787 859,779 ‐19.25%
May 1,363,093 1,116,996 ‐18.05%
Jun 1,662,822 1,385,113 ‐16.70%
Jul 1,934,730 1,607,062 ‐16.94%
Aug 2,196,092 1,887,318 ‐14.06%
Sep 2,439,975
Oct 2,702,703
Nov 2,994,771
Dec 3,320,500
Percent of budget 56.84%
$‐
$1
$2
$3
$4
$5
$6
$7
$8
Millions Charges for Services
Budget
Actual
Last Year
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions Fines & Forfeits
Budget
Actual
Last Year
Page 18 of 36
City of Renton
Monthly Revenue Analysis ‐ 2015 Budget Year
Other Taxes Budget
YTD
Actual
Annual %
over (under)
Jan 644,357 745,094 15.63%
Feb 1,048,477 1,061,217 1.22%
Mar 1,372,072 1,488,270 8.47%
Apr 2,360,868 2,456,370 4.05%
May 2,705,211 2,936,494 8.55%
Jun 3,242,156 3,511,086 8.29%
Jul 3,986,710 4,552,047 14.18%
Aug 4,377,660 5,002,153 14.27%
Sep 4,721,202
Oct 5,563,642
Nov 5,934,771
Dec 6,359,000
Percent of budget 78.66%
Misc Budget
YTD
Actual
Annual %
over (under)
Jan 195,690 269,664 37.80%
Feb 275,267 405,203 47.20%
Mar 417,134 587,589 40.86%
Apr 496,785 720,482 45.03%
May 633,069 865,234 36.67%
Jun 849,257 1,080,863 27.27%
Jul 887,756 1,270,776 43.14%
Aug 1,011,068 1,470,745 45.46%
Sep 1,433,683
Oct 1,539,475
Nov 1,646,248
Dec 2,180,209
Percent of budget 67.46%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
Millions Miscellaneous
Budget
Actual
Last Year
$‐
$1
$2
$3
$4
$5
$6
$7
Millions Other Taxes
Budget
Actual
Last Year
Page 19 of 36
City of Renton
Monthly Revenue Analysis ‐ 2015 Budget Year
Other
Financing Budget
YTD
Actual
Annual %
over (under)
Jan 21,250 ‐ 0.00%
Feb 500 500 0.00%
Mar 500 500 0.00%
Apr 3,218 3,218 0.00%
May 3,718 3,718 0.00%
Jun 3,718 3,718 0.00%
Jul 8,107 8,107 0.00%
Aug 7,607 7,607 0.00%
Sep 191,250
Oct 212,500
Nov 233,750
Dec 255,000
Percent of budget 2.98%
$0
$0
$0
$0
$0
$0
$0
Mi
l
l
i
o
n
s
Other Financing Sources
Budget
Actual
Last Year
Page 20 of 36
City of Renton
Monthly Revenue Analysis ‐ 2015 Budget Year
REET Budget
YTD
Actual
Annual %
over (under)
Jan 173,895 226,377 30.18%
Feb 495,032 384,994 ‐22.23%
Mar 761,342 728,573 ‐4.30%
Apr 1,309,602 1,167,058 ‐10.88%
May 1,625,320 1,561,072 ‐3.95%
Jun 2,129,952 2,039,258 ‐4.26%
Jul 2,513,969 2,602,732 3.53%
Aug 2,838,154 2,884,653 1.64%
Sep 3,087,581
Oct 3,415,085
Nov 3,697,907
Dec 4,000,000
Percent of budget 72.12%
Bldg Permits
& Devlpmt Svc
Fees Budget
YTD
Actual
Annual %
over (under)
Jan 417,515 260,603 ‐37.58%
Feb 771,675 589,160 ‐23.65%
Mar 1,145,031 864,986 ‐24.46%
Apr 1,553,259 1,520,269 ‐2.12%
May 1,958,109 1,755,389 ‐10.35%
Jun 2,406,908 2,780,238 15.51%
Jul 2,740,646 3,653,786 33.32%
Aug 3,094,595 4,108,757 32.77%
Sep 3,437,832
Oct 3,901,056
Nov 4,252,721
Dec 4,679,749
Percent of budget 87.80%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
Millions
Real Estate Excise Tax
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 Building Permits and Development Service
Fees
Budget
Actual
Last Year
Page 21 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2015 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 8,900,673 8,067,548 ‐9.36%
Feb 17,863,836 17,074,731 ‐4.42%
Mar 26,459,482 25,740,531 ‐2.72%
Apr 35,147,181 33,688,640 ‐4.15%
May 43,787,312 42,084,303 ‐3.89%
Jun 52,843,922 51,004,212 ‐3.48%
Jul 66,278,597 64,338,959 ‐2.93%
Aug 75,545,369 73,279,846 ‐3.00%
Sep 86,996,763
Oct 96,473,707
Nov 105,919,862
Dec 117,207,165
Percent of budget expended 74.20%
Legislative Budget
YTD
Actual
Annual %
over (under)
Jan 26,298 32,033 21.81%
Feb 58,089 58,037 ‐0.09%
Mar 87,938 88,145 0.23%
Apr 115,765 113,635 ‐1.84%
May 142,930 140,500 ‐1.70%
Jun 171,000 166,120 ‐2.85%
Jul 198,534 191,473 ‐3.56%
Aug 225,314 217,023 ‐3.68%
Sep 252,423
Oct 279,819
Nov 307,043
Dec 335,838
Percent of budget expended 64.62%
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
$120
Millions
Total Expenditures
General Government
Budget
Actual
Last Year
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
Legislative
Budget
Actual
Last Year
Page 22 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2015 Budget Year
Executive Budget
YTD
Actual
Annual %
over (under)
Jan 103,164 80,465 ‐22.00%
Feb 247,755 200,055 ‐19.25%
Mar 394,565 319,885 ‐18.93%
Apr 549,627 443,641 ‐19.28%
May 694,977 568,027 ‐18.27%
Jun 826,471 687,127 ‐16.86%
Jul 971,091 814,282 ‐16.15%
Aug 1,120,544 1,085,450 ‐3.13%
Sep 1,257,659
Oct 1,400,057
Nov 1,537,283
Dec 1,714,717
Percent of budget expended 63.30%
City Attorney Budget
YTD
Actual
Annual %
over (under)
Jan 147,754 151,100 2.27%
Feb 300,008 294,916 ‐1.70%
Mar 452,011 443,297 ‐1.93%
Apr 612,052 599,643 ‐2.03%
May 767,231 753,544 ‐1.78%
Jun 934,548 908,816 ‐2.75%
Jul 1,092,795 1,062,566 ‐2.77%
Aug 1,255,535 1,217,493 ‐3.03%
Sep 1,423,372
Oct 1,584,730
Nov 1,745,168
Dec 2,001,421
Percent of budget expended 60.83%
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
Millions Executive
Budget
Actual
Last Year
$‐
$0.40
$0.80
$1.20
$1.60
$2.00
Millions City Attorney
Budget
Actual
Last Year
Page 23 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2015 Budget Year
Court Services Budget
YTD
Actual
Annual %
over (under)
Jan 167,379 151,935 ‐9.23%
Feb 340,315 313,414 ‐7.90%
Mar 513,575 477,408 ‐7.04%
Apr 699,853 641,217 ‐8.38%
May 872,953 810,280 ‐7.18%
Jun 1,060,752 994,496 ‐6.25%
Jul 1,239,657 1,162,369 ‐6.23%
Aug 1,415,282 1,335,130 ‐5.66%
Sep 1,591,471
Oct 1,765,983
Nov 1,933,771
Dec 2,157,721
Percent of budget expended 61.88%
CED Admin Budget
YTD
Actual
Annual %
over (under)
Jan 96,399 88,408 ‐8.29%
Feb 192,792 177,244 ‐8.06%
Mar 289,500 266,079 ‐8.09%
Apr 387,901 358,681 ‐7.53%
May 484,593 452,800 ‐6.56%
Jun 581,892 546,093 ‐6.15%
Jul 679,312 735,445 8.26%
Aug 776,605 824,910 6.22%
Sep 874,091
Oct 971,695
Nov 1,068,592
Dec 1,177,608
Percent of budget expended 70.05%
$‐
$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.20
$0.40
$0.60
$0.80
$1.00
$1.20
Millions
Community & Economic
Development Admin
Budget
Actual
Last Year
Page 24 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2015 Budget Year
Development
Services Budget
YTD
Actual
Annual %
over (under)
Jan 245,642 201,493 ‐17.97%
Feb 478,377 427,863 ‐10.56%
Mar 728,947 653,820 ‐10.31%
Apr 1,000,731 867,751 ‐13.29%
May 1,246,791 1,086,324 ‐12.87%
Jun 1,492,934 1,300,030 ‐12.92%
Jul 1,738,076 1,514,993 ‐12.84%
Aug 2,000,285 1,743,441 ‐12.84%
Sep 2,223,932
Oct 2,468,126
Nov 2,708,274
Dec 2,964,321
Percent of budget expended 58.81%
Economic
Development Budget
YTD
Actual
Annual %
over (under)
Jan 105,386 43,127 ‐59.08%
Feb 152,275 122,554 ‐19.52%
Mar 230,941 171,373 ‐25.79%
Apr 312,564 228,439 ‐26.91%
May 381,359 278,258 ‐27.04%
Jun 468,634 326,497 ‐30.33%
Jul 571,804 375,085 ‐34.40%
Aug 668,297 435,115 ‐34.89%
Sep 758,365
Oct 846,244
Nov 929,468
Dec 1,053,786
Percent of budget expended 41.29%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
Millions
Development Services
Budget
Actual
Last Year
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Millions
Economic Development
Budget
Actual
Last Year
Page 25 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2015 Budget Year
Planning Budget
YTD
Actual
Annual %
over (under)
Jan 177,750 197,905 11.34%
Feb 377,402 398,110 5.49%
Mar 585,268 616,614 5.36%
Apr 801,453 829,531 3.50%
May 1,016,839 1,087,344 6.93%
Jun 1,242,681 1,325,058 6.63%
Jul 1,478,295 1,537,578 4.01%
Aug 1,726,181 1,737,966 0.68%
Sep 1,971,643
Oct 2,223,724
Nov 2,452,676
Dec 2,714,466
Percent of budget expended 64.03%
Finance Budget
YTD
Actual
Annual %
over (under)
Jan 196,797 171,705 ‐12.75%
Feb 396,355 350,741 ‐11.51%
Mar 607,163 531,013 ‐12.54%
Apr 830,317 711,350 ‐14.33%
May 1,048,277 907,912 ‐13.39%
Jun 1,334,245 1,245,394 ‐6.66%
Jul 1,584,067 1,427,769 ‐9.87%
Aug 1,861,055 1,830,087 ‐1.66%
Sep 2,100,083
Oct 2,315,404
Nov 2,526,251
Dec 3,167,120
Percent of budget expended 57.78%
$‐
$0.40
$0.80
$1.20
$1.60
$2.00
$2.40
$2.80
Millions Finance
Budget
Actual
Last Year
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
Millions
Planning
Budget
Actual
Last Year
Page 26 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2015 Budget Year
City Clerk Budget
YTD
Actual
Annual %
over (under)
Jan 62,327 55,655 ‐10.71%
Feb 154,117 127,473 ‐17.29%
Mar 292,896 194,321 ‐33.66%
Apr 363,579 264,641 ‐27.21%
May 551,378 337,039 ‐38.87%
Jun 612,495 404,603 ‐33.94%
Jul 674,452 472,059 ‐30.01%
Aug 745,168 552,466 ‐25.86%
Sep 810,502
Oct 876,269
Nov 938,389
Dec 1,091,558
Percent of budget expended 50.61%
Includes Hearing Examiner
Human
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 92,234 66,108 ‐28.33%
Feb 191,724 156,267 ‐18.49%
Mar 299,478 256,191 ‐14.45%
Apr 419,831 366,906 ‐12.61%
May 520,778 462,817 ‐11.13%
Jun 633,337 560,008 ‐11.58%
Jul 740,272 659,471 ‐10.92%
Aug 851,182 754,220 ‐11.39%
Sep 962,393
Oct 1,068,605
Nov 1,178,873
Dec 1,316,577
Percent of budget expended 57.29%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
Millions Human Resources
Budget
Actual
Last Year
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Millions City Clerk
Budget
Actual
Last Year
Page 27 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2015 Budget Year
Police Budget
YTD
Actual
Annual %
over (under)
Jan 2,838,312 2,696,824 ‐4.98%
Feb 5,338,652 5,110,347 ‐4.28%
Mar 8,132,481 8,006,482 ‐1.55%
Apr 10,622,411 10,472,025 ‐1.42%
May 13,442,707 13,204,343 ‐1.77%
Jun 16,063,051 15,808,511 ‐1.58%
Jul 18,903,549 18,702,324 ‐1.06%
Aug 21,384,709 21,233,544 ‐0.71%
Sep 24,280,565
Oct 26,807,764
Nov 29,604,248
Dec 32,571,356
Percent of budget expended 65.19%
Fire &
Emergency
Services Budget
YTD
Actual
Annual %
over (under)
Jan 2,492,921 2,067,851 ‐17.05%
Feb 5,128,345 5,131,944 0.07%
Mar 7,252,690 7,236,866 ‐0.22%
Apr 9,384,058 9,250,808 ‐1.42%
May 11,422,752 11,360,848 ‐0.54%
Jun 13,549,804 13,459,450 ‐0.67%
Jul 15,728,121 15,607,269 ‐0.77%
Aug 18,088,845 17,680,343 ‐2.26%
Sep 20,238,248
Oct 22,409,217
Nov 24,560,558
Dec 26,890,757
Percent of budget expended 65.75%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
Millions Police
Budget
Actual
Last Year
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
Millions Fire & Emergency Services
Budget
Actual
Last Year
Page 28 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2015 Budget Year
Community
Services Admin Budget
YTD
Actual
Annual %
over (under)
Jan 43,966 41,417 ‐5.80%
Feb 90,262 84,599 ‐6.27%
Mar 139,409 131,187 ‐5.90%
Apr 186,134 173,595 ‐6.74%
May 230,632 211,318 ‐8.37%
Jun 276,022 247,147 ‐10.46%
Jul 322,391 290,564 ‐9.87%
Aug 367,593 334,458 ‐9.01%
Sep 412,944
Oct 457,663
Nov 506,080
Dec 560,787
Percent of budget expended 59.64%
Parks Budget
YTD
Actual
Annual %
over (under)
Jan 325,659 291,345 ‐10.54%
Feb 673,002 618,104 ‐8.16%
Mar 1,027,206 958,044 ‐6.73%
Apr 1,412,601 1,289,256 ‐8.73%
May 1,804,734 1,638,570 ‐9.21%
Jun 2,226,430 2,010,536 ‐9.70%
Jul 2,682,332 2,473,410 ‐7.79%
Aug 3,178,173 2,870,952 ‐9.67%
Sep 3,648,648
Oct 4,090,791
Nov 4,476,422
Dec 4,870,254
Percent of budget expended 58.95%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.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 29 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2015 Budget Year
Parks Planning
and Natural
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 55,675 46,145 ‐17.12%
Feb 115,072 93,550 ‐18.70%
Mar 187,578 151,169 ‐19.41%
Apr 256,383 208,488 ‐18.68%
May 340,506 283,762 ‐16.66%
Jun 408,125 338,895 ‐16.96%
Jul 488,654 418,287 ‐14.40%
Aug 564,003 489,839 ‐13.15%
Sep 646,544
Oct 724,329
Nov 807,560
Dec 999,004
Percent of budget expended 49.03%
Recreation Budget
YTD
Actual
Annual %
over (under)
Jan 314,595 338,282 7.53%
Feb 674,027 685,764 1.74%
Mar 1,038,567 1,048,007 0.91%
Apr 1,416,679 1,422,635 0.42%
May 1,774,643 1,795,232 1.16%
Jun 2,177,027 2,207,568 1.40%
Jul 2,840,460 2,820,946 ‐0.69%
Aug 3,538,644 3,440,666 ‐2.77%
Sep 4,068,609
Oct 4,421,871
Nov 4,779,294
Dec 5,200,923
Percent of budget expended 66.15%
$‐
$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
Millions Recreation
Budget
Actual
Last Year
Page 30 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2015 Budget Year
Human
Services Budget
YTD
Actual
Annual %
over (under)
Jan 48,572 46,455 ‐4.36%
Feb 141,007 95,909 ‐31.98%
Mar 242,790 251,898 3.75%
Apr 376,801 410,324 8.90%
May 459,317 470,636 2.46%
Jun 518,930 548,427 5.68%
Jul 654,312 685,824 4.82%
Aug 742,062 760,204 2.44%
Sep 792,922
Oct 937,329
Nov 1,010,163
Dec 1,204,977
Percent of budget expended 63.09%
Neighborhoods
, Resources,
and Events Budget
YTD
Actual
Annual %
over (under)
Jan 71,877 57,115 ‐20.54%
Feb 160,969 132,128 ‐17.92%
Mar 234,444 197,567 ‐15.73%
Apr 308,166 257,014 ‐16.60%
May 375,327 324,365 ‐13.58%
Jun 462,220 401,711 ‐13.09%
Jul 579,552 520,522 ‐10.19%
Aug 670,339 613,785 ‐8.44%
Sep 750,598
Oct 831,121
Nov 918,936
Dec 1,036,841
Percent of budget expended 59.20%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
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 31 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2015 Budget Year
Museum Fund Budget
YTD
Actual
Annual %
over (under)
Jan 18,126 18,605 2.64%
Feb 36,275 37,516 3.42%
Mar 54,386 56,379 3.67%
Apr 73,431 75,445 2.74%
May 92,462 94,299 1.99%
Jun 111,827 113,004 1.05%
Jul 131,075 131,778 0.54%
Aug 150,608 151,082 0.31%
Sep 169,866
Oct 189,289
Nov 208,614
Dec 227,761
Percent of budget expended 66.33%
Public Works
Admin Budget
YTD
Actual
Annual %
over (under)
Jan 34,823 31,422 ‐9.77%
Feb 69,626 64,809 ‐6.92%
Mar 104,435 96,942 ‐7.17%
Apr 141,243 128,823 ‐8.79%
May 175,830 161,020 ‐8.42%
Jun 208,809 193,206 ‐7.47%
Jul 240,160 225,570 ‐6.08%
Aug 271,809 258,768 ‐4.80%
Sep 303,553
Oct 334,125
Nov 364,445
Dec 395,867
Percent of budget expended 65.37%
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
$400,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 32 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2015 Budget Year
Street
Maintenance Budget
YTD
Actual
Annual %
over (under)
Jan 382,448 387,644 1.36%
Feb 810,592 784,009 ‐3.28%
Mar 1,196,298 1,213,907 1.47%
Apr 1,694,724 1,612,472 ‐4.85%
May 2,115,430 2,027,380 ‐4.16%
Jun 2,545,047 2,452,514 ‐3.64%
Jul 2,969,351 2,920,408 ‐1.65%
Aug 3,394,715 3,381,140 ‐0.40%
Sep 3,834,705
Oct 4,322,555
Nov 4,746,267
Dec 5,186,713
Percent of budget expended 65.19%
Transportation Budget
YTD
Actual
Annual %
over (under)
Jan 348,799 300,741 ‐13.78%
Feb 770,151 642,729 ‐16.55%
Mar 1,179,693 1,186,713 0.60%
Apr 1,751,501 1,532,946 ‐12.48%
May 2,122,594 1,925,413 ‐9.29%
Jun 2,490,849 2,312,208 ‐7.17%
Jul 2,906,031 2,724,715 ‐6.24%
Aug 3,373,535 3,156,877 ‐6.42%
Sep 3,723,430
Oct 4,146,779
Nov 4,511,249
Dec 5,166,529
Percent of budget expended 61.10%
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
Millions Street Maintenance
Budget
Actual
Last Year
$0.0
$0.5
$1.0
$1.5
$2.0
$2.5
$3.0
$3.5
$4.0
$4.5
$5.0
Millions Transportation
Budget
Actual
Last Year
Page 33 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2015 Budget Year
Debt Service Budget
YTD
Actual
Annual %
over (under)
Jan 48,139 48,139 0.00%
Feb 298,456 298,456 0.00%
Mar 298,456 298,456 0.00%
Apr 315,231 315,231 0.00%
May 298,751 298,751 0.00%
Jun 814,758 814,758 0.00%
Jul 1,072,897 1,072,897 0.00%
Aug 1,323,214 1,323,214 0.00%
Sep 4,844,613
Oct 5,382,903
Nov 5,921,194
Dec 6,459,484
Percent of budget expended 20.48%
Non‐
Departmental
Other City Budget
YTD
Actual
Annual %
over (under)
Jan 455,629 455,629 0.00%
Feb 668,193 668,193 0.00%
Mar 888,765 888,765 0.00%
Apr 1,114,142 1,114,142 0.00%
May 1,403,520 1,403,520 0.00%
Jun 1,632,035 1,632,035 0.00%
Jul 5,791,355 5,791,355 0.00%
Aug 5,851,672 5,851,672 0.00%
Sep 5,055,583
Oct 5,617,315
Nov 6,179,046
Dec 6,740,778
Percent of budget expended 86.81%
$‐
$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
$8
$9
Millions Debt Service
Budget
Actual
Last Year
Page 34 of 36
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2015 Budget Year
Utilities Budget Revenue Expense
Jan 5,199,392 5,924,339 3,255,611
Feb 11,168,377 11,761,602 9,177,660
Mar 17,399,993 18,199,879 13,336,961
Apr 23,282,829 24,382,710 16,788,962
May 29,815,221 30,878,316 22,688,463
Jun 37,340,357 37,437,155 29,803,028
Jul 45,172,785 44,703,712 33,891,138
Aug 52,345,600 51,790,989 38,739,436
Sep 60,520,029
Oct 67,617,877
Nov 74,232,293
Dec 88,898,298
Percent of budget expended 36.07%
Note: Operations and Capital
Airport Budget Revenue Expense
Jan 384,243 211,809 77,274
Feb 1,672,027 801,118 211,920
Mar 4,340,484 1,176,025 1,153,469
Apr 4,991,541 1,410,614 1,457,521
May 6,180,175 2,385,348 2,167,372
Jun 6,825,138 2,633,309 2,397,844
Jul 8,638,312 2,841,764 2,666,191
Aug 9,349,977 3,463,681 3,020,465
Sep 11,578,029
Oct 12,523,403
Nov 14,062,517
Dec 16,469,927
Percent of budget expended 18.34%
Note: Operations and Capital
$0
$10
$20
$30
$40
$50
$60
$70
$80
$90
Millions Utilities
Budget
Revenue
Expense
$‐
$2.00
$4.00
$6.00
$8.00
$10.00
$12.00
$14.00
$16.00
$18.00
Millions Airport
Budget
Revenue
Expense
Page 35 of 36
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2015 Budget Year
Golf Course Budget Revenue Expense
Jan 136,222 86,725 126,955
Feb 267,568 192,539 271,231
Mar 424,001 356,415 452,194
Apr 608,130 576,883 608,006
May 756,759 835,706 774,384
Jun 959,820 1,183,367 956,202
Jul 1,153,686 1,502,346 1,166,019
Aug 1,493,111 1,838,160 1,356,952
Sep 1,741,845
Oct 1,899,744
Nov 2,046,993
Dec 2,616,052
Percent of budget expended 51.87%
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 36 of 36