HomeMy WebLinkAbout201506, June.pdf ADMINISTRATIVE SERVICES
DEPARTMENT
M E M O R A N D U M
DATE: August 3, 2015
TO: Ed Prince, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: June 2015 Financial Status Report
At the end of June, general governmental revenues show $2.5 million or 3.6% over budget.
Revenue sources that are higher than expected are: property tax ($1.2 million); sales tax
($181k); sales tax annexation credit ($108k); state shared revenues ($291k); gambling taxes
($305k); building permits & development service fees ($373k); interest/other earnings ($183k);
and other miscellaneous ($131k). On the down side, the revenue sources that are
underperforming the year to date budget are: recreation ($108k below) and fines/penalties
($278k below).
General government expenditures showed a favorable variance of $1.6 million or 2.5%. 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 16,854,032 35,295,390 17,957,441 36,040,000 17,986,266 19,204,760 1,218,495 6.8%
Sales Tax 20,416,372 9,914,656 21,512,379 10,236,767 22,239,731 10,917,883 11,098,681 180,798 1.7%
Sales Tax ‐ Annexation Credit 2,418,789 1,173,493 2,542,394 1,206,177 2,519,968 1,208,722 1,316,375 107,654 8.9%
Criminal Justice Sales Tax 2,091,174 1,000,904 2,267,947 1,081,737 2,305,519 1,101,499 1,178,742 77,243 7.0%
Natural Gas Use Tax 263,660 151,197 271,485 187,378 300,000 207,059 144,031 (63,028) ‐30.4%
Admission Tax 327,258 152,751 310,311 154,551 320,000 154,237 151,784 (2,453) ‐1.6%
Franchise Fees 1,312,727 627,348 1,342,269 646,666 1,260,000 604,617 668,561 63,944 10.6%
Electricity Tax 5,155,789 2,705,889 5,167,444 2,834,180 5,365,536 2,879,470 2,428,025 (451,444) ‐15.7%
Natural Gas Utility Tax 1,550,900 1,015,621 1,562,341 1,170,336 1,550,900 1,088,962 936,792 (152,170) ‐14.0%
Garbage/Solid Waste 397,596 195,483 573,457 273,920 400,000 193,358 291,342 97,984 50.7%
TV Cable 1,481,779 712,128 1,518,821 738,225 1,579,365 763,393 771,848 8,454 1.1%
Telephone 917,021 410,588 909,088 470,647 952,500 459,653 485,416 25,763 5.6%
Cellular Phone 2,050,312 912,334 1,951,925 908,528 1,967,056 894,934 824,961 (69,973) ‐7.8%
City Utilities 3,964,989 1,904,012 3,961,052 1,921,766 4,058,377 1,958,916 2,041,493 82,577 4.2%
Utility Tax Audit ‐ ‐ 460,513 ‐ ‐ ‐ 533,218 533,218 100.0%
Leasehold Excise Tax 164,637 82,442 171,470 89,256 179,000 91,441 84,782 (6,659) ‐7.3%
Gambling Excise Tax 1,319,585 635,917 1,650,384 796,580 1,600,000 771,724 1,076,516 304,792 39.5%
Real Estate Excise Tax 4,131,665 1,455,902 4,348,762 2,634,433 4,000,000 2,129,952 2,039,258 (90,694) ‐4.3%
Less: CIP REET (700,000) (279,995) (1,650,000) (499,628) (1,000,000) (509,815) (509,815) ‐ 0.0%
EMS Levy 916,361 229,090 916,361 450,784 920,000 234,102 234,102 ‐ 0.0%
Business License Fees 503,766 290,183 515,555 253,136 506,000 269,709 267,662 (2,047) ‐0.8%
Animal Licenses and Spec Events Permits 99,411 55,012 95,698 55,724 91,000 52,227 56,400 4,173 8.0%
Building Permits & Development Svc Fees 4,001,625 1,909,994 4,519,234 2,473,680 4,679,749 2,406,908 2,780,238 373,329 15.5%
Intergovt'l (Grants, State Shared, etc) 3,863,974 1,925,151 4,522,540 2,302,258 3,909,542 1,811,576 2,018,764 207,188 11.4%
Fire District 25 and 40 Contracts 5,726,895 2,794,338 5,959,428 2,977,343 6,116,326 3,104,566 3,104,566 ‐ 0.0%
Public Safety 680,581 335,396 844,375 387,793 513,081 242,997 398,245 155,248 63.9%
Culture and Recreation 1,494,580 607,732 1,485,123 663,238 1,580,616 674,200 566,608 (107,592) ‐16.0%
Interfund/Interdept‐Services 3,464,913 1,752,065 3,270,503 1,688,441 3,147,416 1,573,708 1,591,272 17,564 1.1%
Fines and Penalties 1,137,140 519,031 962,977 532,553 1,126,500 563,450 381,565 (181,884) ‐32.3%
Photo Enforcement 1,629,524 1,022,773 1,719,971 655,596 2,194,000 1,099,372 1,003,547 (95,825) ‐8.7%
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 52,161 981,630 198,922 875,300 156,395 339,812 183,416 117.3%
Rents, Leases, and Concessions 734,530 440,405 711,070 446,145 710,216 435,558 438,102 2,545 0.6%
Contributions and Donations 84,320 43,186 113,626 55,876 97,000 48,543 60,684 12,140 25.0%
Other Miscellaneous 684,187 358,563 879,105 428,331 705,369 353,046 483,661 130,615 37.0%
Refunding Debt and Premiums ‐ ‐ ‐ ‐ ‐ 13,691,804 13,691,804 ‐ 0.0%
Other Financing Sources (Transfer ‐In, etc) 299,527 13,343 48,632 8,617 255,000 3,718 3,718 (0) 0.0%
Total Operating Revenues 105,545,527 52,007,692 111,782,133 56,390,743 113,245,760 69,681,474 72,193,964 2,512,490 3.6%
OPERATING EXPENDITURES
Council 289,911 145,113 309,317 159,997 335,838 171,000 166,120 4,880 2.9%
Executive 1,240,910 614,036 1,338,738 629,321 1,714,717 826,471 687,127 139,345 16.9%
City Attorney 1,922,225 872,824 1,829,254 878,900 2,001,421 934,548 908,816 25,732 2.8%
Court Services 2,003,104 978,124 2,016,273 997,832 2,148,553 1,056,245 994,496 61,749 5.8%
Community and Eco Dvlpmnt Admin 1,047,860 514,481 1,010,761 502,746 1,177,608 581,892 546,093 35,799 6.2%
Development Services 3,243,702 1,589,997 2,659,078 1,382,845 2,964,321 1,492,934 1,300,030 192,904 12.9%
Economic Development 467,511 211,913 654,007 286,843 1,053,786 468,634 326,497 142,137 30.3%
Planning 1,510,707 728,944 2,095,706 922,069 2,714,466 1,242,681 1,325,058 (82,377) ‐6.6%
Finance 2,274,147 942,750 2,644,827 1,129,517 2,795,120 1,177,529 1,245,394 (67,865) ‐5.8%
City Clerk 1,020,822 636,188 1,152,246 583,164 1,091,558 612,495 404,603 207,891 33.9%
Human Resources 904,182 439,470 922,668 439,333 1,316,577 633,337 560,008 73,329 11.6%
Police 24,946,784 12,358,254 26,383,640 12,952,983 28,371,356 13,990,029 13,735,488 254,541 1.8%
Jail Services 3,814,042 1,907,023 3,760,273 1,880,926 4,200,000 2,073,022 2,073,022 ‐ 0.0%
Fire 24,444,372 12,459,420 25,240,760 12,576,090 26,890,757 13,549,804 13,459,450 90,354 0.7%
Community Services Admin 452,146 225,313 480,727 233,851 560,787 276,022 247,147 28,875 10.5%
Parks 4,024,756 1,862,252 4,070,181 1,838,337 4,870,254 2,226,430 2,010,536 215,894 9.7%
Parks Planning & Natural Resources 829,250 310,633 722,739 323,404 999,004 408,125 338,895 69,230 17.0%
Recreation 4,846,970 2,075,334 4,823,195 1,972,450 5,200,923 2,177,027 2,207,568 (30,540) ‐1.4%
Human Services 1,162,330 496,606 1,159,189 503,169 1,199,977 516,776 548,427 (31,651) ‐6.1%
Neighborhoods, Resources, & Events 770,841 362,006 875,223 371,803 1,036,841 462,220 401,711 60,509 13.1%
Museum 209,387 104,728 214,291 103,291 227,761 111,827 113,004 (1,177) ‐1.1%
Public Works Admin 426,312 237,314 389,493 193,002 395,867 208,809 193,206 15,603 7.5%
Street Maintenance 3,814,132 1,924,036 4,503,315 2,157,217 5,186,713 2,545,047 2,452,514 92,532 3.6%
Transportation 4,476,854 2,113,464 4,263,725 2,100,480 5,076,998 2,447,685 2,312,208 135,477 5.5%
Debt Service 8,048,508 1,776,589 8,393,140 1,807,407 6,463,588 14,506,562 14,506,562 ‐ 0.0%
Non‐Departmental and Other 5,475,340 2,587,016 9,758,346 6,618,473 6,740,778 1,632,035 1,632,035 ‐ 0.0%
Total Operating Expenditures 103,667,105 48,473,829 111,671,112 53,545,448 116,735,570 66,329,186 64,696,016 1,633,170 2.5%
Total Ending Fund Balance 17,454,262$ 19,109,703$ 17,565,283$ 20,299,556$ 14,075,471$ 20,917,570$ 25,063,230$ 4,145,660$ 19.8%
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 June 2015
Page 1 of 37
Monthly Financial Report June 2015
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through June 30, 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 60% of all
resources supporting general governmental activities. The following section provides detail information on property, sales,
utility, and other taxes.
Property Tax
June’s collection is $148k, making
the total year‐to‐date collection
$19.2 million or 53.3% of the total
budget. In comparison to the
previous year, the City collected
$1.2 million or 7% more.
Compared to the budget, the City
is above projections by $1.2
million or 7%. The April and May
2015 variances are due to the
timing of collections. The
negative amount for January and
June 2014 was due to receivables
not yet received by King County.
These receivables were recorded
in February and July 2014’s
collection. The City is projecting property taxes to meet the budget at year‐end.
Sales Tax
June 2015 sales tax receipts
totalled $1.7 million. Compared
with the same month last year, it
is $8k more. Compared to the
projected current month’s
budget, it is $76k or 4% below.
The year‐to‐date collection of
$11.1 million is $862k or 8% more
than the prior year and is also
$181k or 2% 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
Aug 178,936 427,951
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 17,957,441$ 17,986,266$ 19,204,760$ 1,247,319$ 7% 1,218,495$ 7%
Annual Total 35,295,390$ 36,040,000$
Property Tax Revenues
Year to Date through June
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 ‐
Aug 2,030,161 1,940,381 ‐
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 10,236,767$ 10,917,883$ 11,098,681$ 861,914$ 8% 180,798$ 2%
Annual Total 21,512,379$ 22,239,731$
2015 vs. Budget2015 vs. 2014
Month
Year to Date through June
Local Retail Sales Tax Revenues
Page 2 of 37
Monthly Financial Report June 2015
The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business
sectors:
Utility tax
June utility tax revenues are $1.8
million, which is $439k or 32%
higher than the same month last
year and is also ahead of the
budget by $505k or 39%. The
year‐to‐date collection is $8.5
million, which is $48k or 1% lower
than the prior year but is $11k or
higher than the budget. Almost
100% of this favourable variance
is due to one‐time audit
adjustments. 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.
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 1,186,657
Aug 1,270,116 1,293,475
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 8,504,980$ 8,445,745$ 8,457,125$ (47,855)$ ‐1% 11,380$ 0%
Annual Total 16,376,127$ 16,173,734$
2015 vs. Budget2015 vs. 2014
Year to Date through June
Utility Tax Revenues
Month
Sales Tax by Sector 2014 2015 Bgt YTD Act Change 2015/2014 2015 Act vs Bgt
New Construction 991,398$ 1,204,748$ 1,294,181$ 302,783$ 31%$ 89,433 7%
Auto Sales 1,964,025 2,053,446 2,160,978 196,952 10% 107,531 5%
General Retail 3,252,454 3,354,473 3,466,859 214,405 7% 112,386 3%
Manufacturing 1,028,454 1,039,166 901,475 (126,980) ‐12% (137,691)‐13%
Wholesale 517,530 565,814 568,904 51,374 10% 3,090 1%
Service 2,191,194 2,336,535 2,419,079 227,885 10% 82,544 4%
Other 291,711 363,701 287,206 (4,505) ‐2% (76,495)‐21%
YTD Total 10,236,767$ 10,917,883$ 11,098,681$ 861,914$ 8%180,798$ 2%
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 2,834,180$ 2,879,470$ 2,428,025$ (406,155)$ ‐14%$ (451,444)‐16%
Natural Gas 1,357,714 1,296,021 1,080,822 (276,892) ‐20% (215,199)‐17%
Cell 908,528 894,934 824,961 (83,567) ‐9% (69,973)‐8%
Phone 470,647 459,653 485,416 14,769 3% 25,763 6%
Cable 738,225 763,393 771,848 33,623 5% 8,454 1%
Garbage/Solid Waste 273,920 193,358 291,342 17,422 6% 97,984 51%
City Utilities 1,921,766 1,958,916 2,041,493 119,727 6% 82,577 4%
Utility Tax Audit ‐ ‐ 533,218 533,218 100% 533,218 100%
YTD Total 8,504,980$ 8,445,745$ 8,457,125$ (47,855)$ ‐1%11,380$ 0%
Annual Total 16,376,127$ 16,173,734$
YTD as % of 52% 52%
Page 3 of 37
Monthly Financial Report June 2015
Other Taxes
Real Estate Excise Tax
The City collected $478k in Real
Estate Excise Tax revenues (REET)
for June. This is $146k or 23% less
than the same month last year
and is $26k or 5% less than the
current month’s budget. The
year‐to‐date collection is $2
million, which is $595k or 23% less
than the prior year and is also
$91k or 4% below the budget.
The variance in February 2014 is
due to an audit done by the
Washington State Department of
Revenue ($135k) and 1 large
transaction ($119k). The variance
in April 2014 is due to 3 large
transactions ($619k). The City is projecting REET to be under the budget at year‐end.
Gambling Tax
June’s Gambling Tax collections
totalled $174k, which is $38k or
28% above the same month last
year and is also above the current
month’s budget by $69k or 65%.
The year‐to‐date total of $1.1
million is $280k or 35% above the
prior year and is also $305k or
39% above budget. The City is
projecting gambling taxes to
exceed the budget at year‐end.
Pull tabs overall had a 6%
increase, bingo had a 20%
decrease, and card‐rooms are
seeing 61% 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 $669k is $22k or 3% higher
than the prior year and is also
$64k 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 302,358
Aug 346,677 319,703
Sep 265,534 262,898
Oct 436,050 341,955
Nov 223,675 300,967
Dec 92,179 342,168
YTD Total 2,634,433$ 2,129,952$ 2,039,258$ (595,175)$ ‐23% (90,694)$ ‐4%
Annual Total 4,348,762$ 4,000,000$
Real Estate Excise Tax Revenues
Year to Date through June
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 ‐
Aug 130,381 124,075 ‐
Sep 139,444 137,724 ‐
Oct 155,499 144,185 ‐
Nov 156,921 146,442 ‐
Dec 148,970 161,778 ‐
YTD Total 796,580$ 771,724$ 1,076,516$ 279,936$ 35% 304,792$ 39%
Annual Total 1,650,384$ 1,600,000$
Year to Date through June
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 ‐
Oct 321,828 305,167 ‐
Dec 49,502 46,502 ‐
YTD Total 646,666$ 604,617$ 668,561$ 21,896$ 3% 64,462$ 11%
Annual Total 1,342,269$ 1,260,000$
Month
2015 vs. 2014 2015 vs. Budget
Franchise Fees Revenue
Year to Date through June
Page 4 of 37
Monthly Financial Report June 2015
Admission Tax
Admission Tax returns are due
quarterly in January, April, July,
and October of each year. April
2015 collections represent
activities conducted during the 1st
quarter of 2015. The year‐to‐date
collection of $152k is $3k or 2%
less than the prior year and is also
$2k or 2% 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 $1 million in
June. The year‐to‐date
development fees revenue of $2.8
million is $307k or 12% more than
the year before and is also $373k
or 16% higher than budget. The
variance in June 2015 is due to a
large payment for plan checking
fees (Southport Developer
Project). 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 $4k for
June, which is $3k or 41% below
the same month last year and is
also $2k or 33% below the current
month’s budget. The year‐to‐date
Business Licenses revenue of
$268k is $15k or 6% above the
prior year but is below the budget
by $2k or 1%. 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 ‐
Aug ‐ 38 ‐
Oct 76,631 81,433 ‐
Nov ‐ 598 ‐
Dec ‐ 75 ‐
YTD Total 154,551$ 154,237$ 151,784$ (2,622)$ ‐2% (2,380)$ ‐2%
Annual Total 310,311$ 320,000$
2015 vs. Budget
Admission Tax Revenue
Year to Date through June
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
Aug 300,184 353,949
Sep 369,040 343,237
Oct 393,023 463,224
Nov 239,983 351,665
Dec 454,368 427,027
YTD Total 2,473,680$ 2,406,908$ 2,780,238$ 306,558$ 12% 373,329$ 16%
Annual Total 4,519,234$ 4,679,749$
Building Permits and Development Service Fees
Year to Date through June
2015 vs. Budget2015 vs. 2014
Month
2014 2015 2015
Actual Budget Actual $ % $ %
Jan 103,064$ 98,510$ 101,630$ (1,434)$ ‐1% 3,120$ 3%
Feb 25,013 32,600 38,440 13,428 54% 5,841 18%
Mar 5,421 8,867 4,468 (953) ‐18% (4,399) ‐50%
Apr 97,104 99,158 88,757 (8,347) ‐9% (10,401) ‐10%
May 15,091 24,049 29,979 14,888 99% 5,930 25%
Jun 7,444 6,525 4,388 (3,056) ‐41% (2,137) ‐33%
Jul 109,369 80,396 ‐
Aug 16,430 22,656 ‐
Sep 5,290 4,729 ‐
Oct 108,777 108,602 ‐
Nov 18,991 16,050 ‐
Dec 3,562 3,858 ‐
YTD Total 253,136$ 269,709$ 267,662$ 14,525$ 6% (2,047)$ ‐1%
Annual Total 515,555$ 506,000$
2015 vs. 2014
Year to Date through June
2015 vs. Budget
Business Licenses
Month
Page 5 of 37
Monthly Financial Report June 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 87% of the total
revenues in this category.
The year‐to‐date total Intergovernmental revenue is $6.5 million or 49% of the budget.
State Shared Revenues
State Shared Revenue
collections totalled $2.6
million since the start of the
year. Compared to the
prior year, State Shared
Revenues are above by
$126k or 5%. Compared to
the projected budget, the
City is collecting $291k or
13% 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 51%
of the total revenue in this category. The year‐to‐date total charges for services are $4.2 million or 60% of the budget. The
following sections provide detail information for Public Safety, Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totalled
$398k 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 $10k or 3% more.
Compared to the year‐to‐date
budget, the City is over budget by
$155k or 64%. 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 ‐
Aug 64,201 35,937 ‐
Sep 44,169 31,301 ‐
Oct 190,822 91,374 ‐
Nov 37,507 29,303 ‐
Dec 65,704 39,982 ‐
YTD Total 387,793$ 242,997$ 398,245$ 10,452$ 3% 155,248$ 64%
Annual Total 846,409$ 513,081$
Month
2015 vs. 2014
Year to Date through June
Public Safety Services
2015 vs. Budget
Intergovernmental 2014 2015 Bgt YTD Act Change 2015/2014 2015 Act vs Bgt
Fire District #25 620,568$ 628,463$ 628,463$ 7,896$ 1% $ ‐ 0%
Fire District #40 2,356,775 2,476,103 2,476,103 119,328 5%‐ 0%
State Shared Revenue 2,440,379 2,275,308 2,565,972 125,593 5% 290,664 13%
Federal Grants 790,526 451,430 451,430 (339,096) ‐43%‐ 0%
State Grants 22,404 39,151 39,151 16,746 75%‐ 0%
Other Grants/Intgovt 130,686 381,288 375,056 244,370 187% (6,233) ‐2%
ARRA Grants ‐ 0 ‐ ‐ N/A ‐ 0%
Total Rev YTD 6,361,338$ 6,251,743$ 6,536,174$ 174,837$ 3%284,431$ 5%
Total Rev Annual 13,664,242$ 13,251,387$
YTD %47% 47% 49%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
2014 2015 2015
Actual Budget Actual $ % $ %
Crim Just Sales Tax 1,081,737$ 1,101,499$ 1,178,742$ 97,006$ 9% 77,243$ 7%
Judicial Contribution 11,342 ‐ 10,895 (447) ‐4% 10,895 100%
Crim Just ‐ High Crime 128,835 ‐ 125,694 (3,141) ‐2% 125,694 100%
Crim Just ‐ Pop 11,925 11,549 12,688 763 6% 1,139 10%
Crim Just ‐ Spec Prog 44,611 43,173 46,617 2,006 4% 3,444 8%
State DUI 8,694 8,525 8,544 (151) ‐2% 19 0%
Liquor Profits 424,823 425,177 425,911 1,087 0% 734 0%
Liquor Excise Tax 92,598 83,960 108,837 16,239 18% 24,877 30%
Fuel Tax 635,812 601,424 648,044 12,231 2% 46,620 8%
YTD Total 2,440,379$ 2,275,308$ 2,565,972$ 125,593$ 5% 290,664$ 13%
Annual Total 5,045,728$ 4,777,519$
Year to Date through June
State Shared Revenues
2015 vs. 2014
Revenue
2015 vs. Budget
Page 6 of 37
Monthly Financial Report June 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
$228k for the current month.
Compared to the same month the
prior year, the City collected $56k
or 32% more. Compared to the
projected monthly budget, the
City collected $57k or 33% more.
The year‐to‐date collection of
$567k is $97k or 15% lower than
the year before and is also $108k
or 16% lower 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 is projecting recreation revenues to be
under the budget at year‐end.
Interfund Services
The year‐to‐date collections for
Interfund Services revenues are
$1.6 million. Compared to the
prior year, the revenues are under
by $97k or 6%. Compared to the
projected budget, the revenues
are above by $18k or 1%. 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 ‐
Aug 245,982 239,664 ‐
Sep 119,109 128,721 ‐
Oct 72,614 82,910 ‐
Nov 36,383 54,128 ‐
Dec 29,129 48,876 ‐
YTD Total 663,238$ 674,200$ 566,608$ (96,630)$ ‐15% (107,592)$ ‐16%
Annual Total 1,485,123$ 1,580,616$
Recreation
Year to Date through June
2015 vs. Budget2015 vs. 2014
Month
2014 2015 2015
Actual Budget Actual $ % $ %
Jan 301,808$ 262,285$ 265,068$ (36,741)$ ‐12% 2,783$ 1%
Feb 257,027 262,285 264,413 7,386 3% 2,128 1%
Mar 287,465 262,285 260,071 (27,393) ‐10% (2,213) ‐1%
Apr 295,489 262,285 248,466 (47,023) ‐16% (13,819) ‐5%
May 269,032 262,285 260,774 (8,259) ‐3% (1,511) ‐1%
Jun 277,620 262,285 292,480 14,860 5% 30,196 12%
Jul 244,707 262,285 ‐
Aug 284,344 262,285 ‐
Sep 278,550 262,285 ‐
Oct 256,662 262,285 ‐
Nov 254,192 262,285 ‐
Dec 263,607 262,285 ‐
YTD Total 1,688,441$ 1,573,708$ 1,591,272$ (97,169)$ ‐6% 17,564$ 1%
Annual Total 3,270,503$ 3,147,416$
2015 vs. Budget
Month
Interfund Services
Year to Date through June
2015 vs. 2014
Page 7 of 37
Monthly Financial Report June 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.4 million. This is $197k or 17%
higher than a year ago but is
$278k or 17% 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
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
Aug 258,728 261,362
Sep 247,480 243,883
Oct 239,990 262,728
Nov 287,406 292,068
Dec 256,092 325,729
YTD Total 1,188,149$ 1,662,822$ 1,385,113$ 196,964$ 17% (277,709)$ ‐17%
Annual Total 2,682,948$ 3,320,500$
Month
2015 vs. Budget2015 vs. 2014
Year to Date through June
Fines and Penalties by Month
Year to Date through June
2014 2015 2015
Actual Budget Actual $ % $ %
Civil Penalties 3,782$ 7,508$ 1,645$ (2,137)$ ‐56% (5,862)$ ‐78%
Civil Infraction Penalties 293,804 310,163 183,871 (109,933) ‐37% (126,292) ‐41%
Civil Parking Infraction Penalties 92,700 91,753 65,534 (27,167) ‐29% (26,219) ‐29%
Photo Enforcement Program 655,596 1,099,372 1,003,547 347,951 53% (95,825) ‐9%
Criminal Traffic Misdemeanor Fines 44,689 57,345 37,269 (7,420) ‐17% (20,077) ‐35%
Criminal Non‐Traffic Fines 22,291 22,495 31,864 9,573 43% 9,369 42%
Criminal Costs 65,599 61,923 48,120 (17,479) ‐27% (13,803) ‐22%
Non‐Court Fines, Forfeitures and Penalties 9,687 12,263 13,263 3,576 37% 1,000 8%
YTD Total 1,188,149$ 1,662,822$ 1,385,113$ 196,964$ 17% (277,709)$ ‐17%
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 ‐ 88,955 ‐ ‐
Aug 168,554 ‐ 88,955 ‐ ‐
Sep 153,716 ‐ 88,955 ‐ ‐
Oct 170,949 ‐ 88,955 ‐ ‐
Nov 199,054 ‐ 88,955 ‐ ‐
Dec 208,419 ‐ 88,955 ‐ ‐
YTD Total 1,099,372$ 1,003,547$ 533,730$ 496,397$ 507,150$
Annual Total 2,194,000$ 1,067,460$
1Actuals of Revenues and Expenses
Photo Enforcement Program
Year to Date through June
Month
Revenues Expenses
Page 8 of 37
Monthly Financial Report June 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 72% of
the total revenue in this category.
The year‐to‐date total
miscellaneous is $1.1 million.
Compared to last year, the
revenues are above by $176k or
19%. Compared to the projected
year‐to‐date budget, the revenues
are over by $239k or 28%. 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 55% of its budgeted general governmental expenditures at the end of June. This is $1.6 million or
2.5% below year‐to‐date budgeted expenditures. The City did not have any general governmental departments over budget but
did 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,249$ 269,664$ 25,701$ 11% 74,416$ 38%
Feb 99,547 79,392 135,539 35,992 36% 56,147 71%
Mar 126,132 138,941 182,386 56,253 45% 43,445 31%
Apr 70,094 79,092 132,893 62,799 90% 53,801 68%
May 107,650 134,915 144,753 37,103 34% 9,837 7%
Jun 257,714 214,161 215,629 (42,085) ‐16% 1,468 1%
Jul (21,407) 37,022
Aug 121,979 120,533
Sep 552,749 422,492
Oct 119,594 105,005
Nov 128,732 105,350
Dec 491,839 533,056
YTD Total 905,100$ 841,751$ 1,080,863$ 175,764$ 19% 239,113$ 28%
Annual Total 2,298,586$ 2,165,209$
Year to Date through June
Month
2015 vs. Budget2015 vs. 2014
Miscellaneous Revenues by Month
2014 2015 2015
Actual Budget Actual $ % $ %
Interests and Other Earnings 198,922$ 156,395$ 339,812$ 140,889$ 71% 183,416$ 117%
Rents, Leases, and Concessions 446,145 435,558 438,102 (8,043) ‐2% 2,545 1%
Contributions/Donations from Private Sources 55,876 48,543 60,684 4,808 9% 12,140 25%
Other 200,810 143,931 235,822 35,012 17% 91,891 64%
Seizure Funds ‐ Federal/State/Local 3,346 57,323 6,444 3,097 93% (50,880) ‐89%
YTD Total 905,100$ 841,751$ 1,080,863$ 175,764$ 19% 239,113$ 28%
Annual Total 2,298,586$ 2,165,209$
2015 vs. Budget
Miscellaneous Revenues by Type
Year to Date through June
Revenue
2015 vs. 2014
Page 9 of 37
Monthly Financial Report June 2015
CASH AND INVESTMENTS – 2ND
QUARTER
The current cash and
investments (C&I) portfolio
is provided in the table to
the right. The City’s current
C&I balance is $132.8
million, of this amount;
$392k is an interfund loan
investment (Res 4070) from
the insurance fund (502) to
the golf course fund (404).
This interfund loan is due in
full on December 1st 2015.
Currently, the majority of
the portfolio is located in
cash deposits (US Bank).
The rest is spread out
between the State
Investment Pool, US Federal
Agency Securities, various
certificates of deposits, and
the interfund loan.
The existing portfolio yield is approximately .76%.
Current %
Blended
Allowed per
policy
Current Portfolio
(principal value)
44% N/A $ 58,552,838
0% 100%‐$
7% 75% 9,955,053$
34% 75% 45,700,755$
14% 75%18,151,026$
0% 25%‐$
0% N/A 391,853$
TOTAL INVESTMENTS 100%132,751,525$
*Excluding Cash the portfolio distribution is 53% LGIP; 16% CD's; 30% GSE's; 1% internal
Cash
US Treasury Securities
Local Government Investment Pool
US Federal Agency Securities
INTERFUND INVESTMENT
By Type
Certificates of Deposit
Commercial Paper
Cash
44%LGIP
8%
GSE's
34%CD's
14%
Distribution by Type
By Institution Current %
Blended
Allowed by
Policy
Current Portfolio
(principal value)Maturity Date APY
Weighted
Yield
Blended
Cash US Bank ‐ Cash 44%N/A 58,552,838 overnight 0.45% 0.20%
GOLF '15 GOLF '15 0.3%391,853 12/1/2015 2.25%0.01%
US Treasury Securities
none 0%100%‐ N/A N/A N/A
Local Government Investment Pool
3920 State Investment Pool 7%75%9,955,053 10/1/2014 0.10%0.01%
US Federal Agency Securitie s *
314179A FHLB 1,996,920 8/11/2017 1.05%
0.02%
314179D FHLB 1,100,000 9/29/2017 1.18%0.01%
315189A FHLB 5,000,000 3/29/2018 1.07%
0.04%
314179F FHLB 2,400,000 10/16/2017 1.25%
0.02%
314179E FHLB 5,000,000 10/16/2017 1.49%0.06%
314179G FHLB 5,009,485 10/17/2017 0.93%0.04%
315189B FHLMC 5,000,000 7/23/2018 1.25%
0.05%
315209A FHLMC 1,600,000 5/26/2020 1.75%0.02%
315189C FHLMC 5,000,000 6/1/2018 1.12%0.04%
314179I FHLMC 5,000,000 10/30/2017 1.05%
0.04%
314189A FNMA 3,745,000 2/15/2018 1.30%
0.04%
314179C FNMA 4,849,350 11/28/2017 1.00%0.04%
Certificates of Deposit
115184A First Savings Bank Northwest 5,092,087 2/6/2018 1.03%
0.04%
114174A First Savings Bank Northwest 5,000,000 10/29/2017 1.15%0.04%
113164A First Savings Bank Northwest 5,000,000 2/4/2016 1.02%
0.04%
111167a Columbia Bank 2% 2,015,400 11/9/2016 0.99%
0.02%
214163A Commencement Bank (CDARS)1%1,043,540 9/15/2016 0.90%0.01%
Commercial Paper
none 0.00%5%‐ N/A N/AN/A
132,751,525$
75%34%
Golf Interfund Loan
*Held in our safekeeping account at BNY Trust and Custody
TOTAL CASH & INVESTMENTS
20%
11%
Page 10 of 37
Monthly Financial Report June 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 ‐ ‐ ‐ ‐ 50,725 22,250 ‐
Grants / intergovernmental 1,324,831 ‐ 109,496 ‐ ‐ 1,052,680 ‐
Charges for services 70,984 959,372 8,692,788 7,530,286 4,878,011 5,287,830 7,873,375
Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐
Fines and penalties 1,616 ‐ ‐ ‐ 495 ‐ ‐
Rents, leases, and misc fees 1,232,889 191,259 39,336 77,785 ‐ ‐ ‐
Interest and other misc 2,991 7,738 7,190 458,728 459,711 887,823 8,684
TOTAL REVENUES 2,633,311 1,158,369 8,848,810 8,066,799 5,388,942 7,250,583 7,882,059
EXPENSES:
Utility billing ‐ ‐ 65,587 59,338 47,240 76,129 ‐
Utility systems ‐ ‐ 7,706,301 1,999,786 1,573,538 1,623,878 ‐
Utility maintenance ‐ ‐ 139,651 2,473,028 763,869 1,265,194 7,688,577
Transportation 759,195 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 931,204 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 759,195 931,204 7,911,539 4,532,152 2,384,647 2,965,201 7,688,577
AMOUNT AVAILABLE FOR DEBT SERVICE 1,874,116 227,165 937,271 3,534,647 3,004,295 4,285,382 193,482
DEBT SERVICE:
Principal ‐ ‐ ‐ 395,175 265,745 42,590 ‐
Interest ‐ ‐ ‐ 297,136 148,920 387,693 ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ 692,311 414,665 430,283 ‐
CAPITAL PROJECTS 1,638,649 ‐ ‐ 497,122 346,374 1,937,851 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ (3,187) (326) ‐ ‐
CHANGE IN FUND BALANCE 235,467 227,165 937,271 2,342,027 2,242,930 1,917,248 193,482
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, Jun 30 1,042,288 184,254 2,482,877 18,214,121 9,832,019 9,721,469 3,509,792
Page 11 of 37
Monthly Financial Report June 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 ‐ 59,544 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ ‐ ‐ ‐ ‐ ‐ 40,057
Charges for services
Equipment rental m&o 1,393,378 1,754,431 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 44,082 ‐ 210,224 ‐ ‐ ‐
Communications ‐ 3,183 ‐ 290,451 ‐ ‐ ‐
Facilities ‐ ‐ 2,460,739 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 80,214 ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ 246,228 ‐ ‐ ‐ ‐ ‐
Interest and other misc 13,031 5,126 3,234 1,067 34,540 16,879 19,496
Internal service fund misc:
Vehicle / equipment capital recovery 1,480,489 85,004 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 928,058 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 874,301 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 5,785,499 1,113,298
Other misc 1,727 ‐ 3,122 17 ‐ 581,535 ‐
Interfund Loan ‐ ‐ ‐ ‐ 143,079 ‐ ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets 29,088 ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 46,902 ‐ ‐
TOTAL REVENUES 2,917,713 2,277,812 2,467,095 501,759 2,026,880 6,383,913 1,172,851
EXPENSES:
Communications 207,390
Equipment rental 1,042,843
Facilities 2,039,494
Healthcare 6,030,306
Information technology 1,782,332
Print and mail 184,633
Retiree healthcare 539,210
Risk management:
Risk ma nagement 1,327,409
Unemployment 20,244
Worker's compensation 817,744
TOTAL EXPENSES 1,042,843 1,782,332 2,039,494 392,023 2,165,397 6,030,306 539,210
AMOUNT AVAILABLE FOR CAPITAL 1,874,870 495,480 427,601 109,736 (138,517) 353,607 633,641
CAPITAL PROJECTS 2,385,500 209,563 143,310 ‐ ‐ ‐ ‐
TRANSFERS IN 11,005 50,115 ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE (499,625) 336,032 284,291 109,736 (138,517) 353,607 633,641
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, Jun 30 4,810,694 2,252,080 1,438,380 493,705 11,930,794 7,029,112 8,345,504
Page 12 of 37
Monthly Financial Report June 2015
FUND BALANCE
Page 14 shows the ending fund balance as of June 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 June, the City has $25.1 million reported in the combined general governmental fund balance of the current year’s
operating budget, which is approximately 21% of budgeted operating expenditures. This is an increase of $7.5 million from the
year’s beginning balance. June’s ending fund balance is over the anticipated General Governmental Fund Balance of $20.9
million by $4.1 million or 19.8%. Although the ending fund balance is above projections, it is consistent with the prior years’
trends.
CONTACT INFORMATION
This report is prepared by the Finance Division of the Administrative Services Department. For additional financial information,
please also review our website: http://www.rentonwa.gov/. For any questions about the report, please feel free to contact us at
hnguyen@rentonwa.gov or JDThomas@Rentonwa.gov.
Page 13 of 37
Monthly Financial Report June 2015
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through June 30, 2015
Funds
Balance
01/01/2015
Budgeted
Revenue
Revenue
06/30/15
Total Funds
Available
Budgeted
Expenditure
Expenditure
06/30/15 Ending Balance
GENERAL GOVERNMENT FUNDS: 17,565,282 113,245,760 72,193,964 89,759,246 116,735,570 64,696,016 25,063,230
000 General 11,159,313 83,431,472 44,005,444 55,164,757 86,638,897 40,063,384 15,101,373
001 Community Services 2,467,703 12,478,920 5,785,382 8,253,085 12,608,356 5,173,651 3,079,434
003 Street 2,147,229 10,096,711 5,381,875 7,529,104 10,263,711 4,764,722 2,764,381
004 Community Dev Block Grant 74,951 462,908 ‐ 74,951 448,804 31,734 43,217
005 Museum 65,500 227,761 113,993 179,493 227,761 113,004 66,489
009 Farmers Market 104,950 59,400 22,852 127,802 59,453 32,206 95,596
011 Fire Health & Wellness 74,565 25,000 10,272 84,837 25,000 10,753 74,084
201 Ltd GO Bonds Gen Govt Debt 838,633 1,749,405 877,292 1,715,925 1,749,405 97,050 1,618,875
215 Gen Govt Misc Debt Service 632,438 4,714,183 15,996,855 16,629,293 4,714,183 14,409,512 2,219,781
SPECIAL REVENUE FUNDS: 1,100,381 1,786,631 820,199 1,920,580 1,807,969 709,510 1,211,070
102 Arterial Street 14,885 640,000 305,312 320,197 640,000 ‐ 320,197
108 Leased City Properties 121,014 768,957 320,521 441,535 663,403 573,641 (132,106)
110 Hotel Motel 219,090 265,000 123,777 342,867 283,942 71,980 270,887
125 1% For Art 101,380 15,000 247 101,627 102,950 ‐ 101,627
127 Cable Communication 313,090 97,674 69,538 382,628 117,674 63,889 318,739
135 Springbrook Wetlands Bank 330,922 ‐ 804 331,726 ‐ ‐ 331,726
CAPITAL PROJECT FUNDS (CIP):27,979,966 23,803,437 3,676,089 31,656,055 47,027,879 10,824,842 20,831,213
303 Community Dev Mitigation 1,238,600 86,500 169,424 1,408,024 ‐ ‐ 1,408,024
304 Fire Mitigation 926,488 99,000 108,082 1,034,570 250,000 ‐ 1,034,570
305 Transportation Mitigation 844,648 216,500 348,396 1,193,044 391,000 ‐ 1,193,044
316 Municipal Facilities CIP 4,493,986 4,718,145 1,381,085 5,875,071 8,918,715 2,103,537 3,771,534
317 Transportation CIP 4,059,718 18,683,292 1,634,590 5,694,308 22,063,404 1,970,520 3,723,788
326 Housing Opportunity 1,086,766 ‐ 2,606 1,089,372 75,000 50,000 1,039,372
336 New Library Development 15,329,760 ‐ 31,906 15,361,666 15,329,760 6,700,785 8,660,881
ENTERPRISE FUNDS:36,891,230 97,849,061 41,253,871 78,145,101 107,984,277 33,158,282 44,986,819
4X2 Airport Operating & CIP 806,821 16,596,888 2,633,309 3,440,130 16,469,927 2,397,844 1,042,286
403 Solid Waste Utility 1,545,606 16,461,726 8,848,811 10,394,417 16,675,139 7,911,539 2,482,878
4X4 Golf Operating & CIP (42,911) 2,655,383 1,183,366 1,140,455 2,616,052 956,202 184,253
4X5 Water Operating & CIP 15,872,094 16,272,634 8,066,799 23,938,893 20,799,381 5,724,772 18,214,121
4X6 Waste Water Operating & CIP 7,589,089 11,979,140 5,388,943 12,978,032 13,588,076 3,146,013 9,832,019
416 King County Metro 3,316,310 16,638,722 7,882,059 11,198,369 16,638,722 7,688,577 3,509,792
4X7 Surface Water Operating & CIP 7,804,221 17,244,568 7,250,584 15,054,805 21,196,980 5,333,335 9,721,470
INTERNAL SERVICE FUNDS:35,221,104 37,224,840 17,809,140 53,030,244 36,727,348 16,729,978 36,300,266
501 Equipment Repair/Replacement 5,310,319 5,779,036 2,928,717 8,239,036 6,878,442 3,428,343 4,810,693
502 Insurance 12,069,311 5,641,647 2,026,879 14,096,190 3,594,578 2,165,397 11,930,793
503 Information Services 1,916,048 4,631,231 2,327,927 4,243,975 5,606,865 1,991,895 2,252,080
504 Facilities 1,154,089 4,954,325 2,467,095 3,621,184 5,115,716 2,182,804 1,438,380
505 Communications 383,969 992,431 501,759 885,728 991,430 392,023 493,705
512 Insurance, Healthcare 6,675,505 12,954,736 6,383,912 13,059,417 13,424,573 6,030,306 7,029,111
522 Insurance, Leoff1 Retirees HC 7,711,863 2,271,434 1,172,851 8,884,714 1,115,744 539,210 8,345,504
FIDUCIARY FUNDS: 5,040,982 468,000 152,464 5,193,446 210,475 104,607 5,088,839
611 Firemen's Pension 5,040,982 468,000 152,464 5,193,446 210,475 104,607 5,088,839
TOTAL FUNDS 123,798,945 274,377,729 135,905,727 259,704,672 310,493,518 126,223,235 133,481,437
Page 14 of 37
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 64,946,109 55,776,107 9,170,002 26,735,284
June 72,193,964 64,696,016 7,497,948 25,063,230
July
August
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 15 of 37
City of Renton
Monthly Revenue Analysis ‐ 2015 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 5,741,881 5,697,180 ‐0.78%
Feb 12,058,105 11,956,490 ‐0.84%
Mar 18,474,798 18,465,333 ‐0.05%
Apr 33,331,883 35,699,323 7.10%
May 63,674,894 64,946,109 2.00%
Jun 69,681,474 72,193,964 3.61%
Jul 62,454,760
Aug 68,746,127
Sep 75,119,080
Oct 91,044,401
Nov 105,820,398
Dec 113,245,760
Percent of budget 63.75%
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
Aug 18,941,825
Sep 19,457,794
Oct 28,804,271
Nov 35,032,115
Dec 36,040,000
Percent of budget 53.29%
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
$120
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 16 of 37
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
Aug 16,267,801
Sep 18,318,344
Oct 20,462,487
Nov 22,646,995
Dec 24,759,699
Percent of budget 50.14%
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 9,632,402
Aug 10,925,876
Sep 12,263,996
Oct 13,427,619
Nov 14,660,851
Dec 16,173,734
Percent of budget 52.29%
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
Millions Utility Tax
Budget
Actual
Last Year
Page 17 of 37
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
Aug 2,657,556
Sep 2,918,335
Oct 3,399,093
Nov 3,693,994
Dec 3,911,417
Percent of budget 43.92%
Note: Franchise Fees
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,720,554
Aug 7,370,265
Sep 8,010,489
Oct 8,997,344
Nov 12,582,386
Dec 13,251,387
Percent of budget 49.32%
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 18 of 37
City of Renton
Monthly Revenue Analysis ‐ 2015 Budget Year
Charges for
Services Budget
YTD
Actual
Annual %
over (under)
Jan 534,248 523,882 ‐1.94%
Feb 1,045,979 982,531 ‐6.07%
Mar 1,605,315 1,508,665 ‐6.02%
Apr 2,237,065 2,428,409 8.55%
May 2,787,340 2,895,781 3.89%
Jun 3,406,478 4,190,545 23.02%
Jul 4,183,462
Aug 4,839,746
Sep 5,375,897
Oct 5,947,939
Nov 6,408,613
Dec 7,009,814
Percent of budget 59.78%
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
Aug 2,196,092
Sep 2,439,975
Oct 2,702,703
Nov 2,994,771
Dec 3,320,500
Percent of budget 41.71%
$‐
$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 19 of 37
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
Aug 4,377,660
Sep 4,721,202
Oct 5,563,642
Nov 5,934,771
Dec 6,359,000
Percent of budget 55.21%
Misc Budget
YTD
Actual
Annual %
over (under)
Jan 195,249 269,664 38.11%
Feb 274,641 405,203 47.54%
Mar 413,582 587,589 42.07%
Apr 492,674 720,482 46.24%
May 627,590 865,234 37.87%
Jun 841,751 1,080,863 28.41%
Jul 878,773
Aug 999,306
Sep 1,421,798
Oct 1,526,803
Nov 1,632,153
Dec 2,165,209
Percent of budget 49.92%
$‐
$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 20 of 37
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 13,695,522 13,695,522 0.00%
Jun 13,695,522 13,695,522 0.00%
Jul 148,750
Aug 170,000
Sep 191,250
Oct 212,500
Nov 233,750
Dec 255,000
Percent of budget 5370.79%
$0
$2
$4
$6
$8
$10
$12
$14
$16
Mi
l
l
i
o
n
s
Other Financing Sources
Budget
Actual
Last Year
Page 21 of 37
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,432,310
Aug 2,752,013
Sep 3,014,911
Oct 3,356,866
Nov 3,657,832
Dec 4,000,000
Percent of budget 50.98%
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
Aug 3,094,595
Sep 3,437,832
Oct 3,901,056
Nov 4,252,721
Dec 4,679,749
Percent of budget 59.41%
$‐
$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 22 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2015 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 8,870,600 8,067,548 ‐9.05%
Feb 17,801,905 17,074,731 ‐4.08%
Mar 26,364,534 25,740,531 ‐2.37%
Apr 35,014,766 33,688,640 ‐3.79%
May 57,313,591 55,776,107 ‐2.68%
Jun 66,329,186 64,696,016 ‐2.46%
Jul 66,904,610
Aug 76,924,507
Sep 86,678,596
Oct 96,121,914
Nov 105,536,315
Dec 116,735,570
Percent of budget expended 55.42%
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
Aug 225,314
Sep 252,423
Oct 279,819
Nov 307,043
Dec 335,838
Percent of budget expended 49.46%
$‐
$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 23 of 37
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
Aug 1,120,544
Sep 1,257,659
Oct 1,400,057
Nov 1,537,283
Dec 1,714,717
Percent of budget expended 40.07%
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
Aug 1,255,535
Sep 1,423,372
Oct 1,584,730
Nov 1,745,168
Dec 2,001,421
Percent of budget expended 45.41%
$‐
$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 24 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2015 Budget Year
Court Services Budget
YTD
Actual
Annual %
over (under)
Jan 166,668 151,935 ‐8.84%
Feb 338,869 313,414 ‐7.51%
Mar 511,393 477,408 ‐6.65%
Apr 696,880 641,217 ‐7.99%
May 869,244 810,280 ‐6.78%
Jun 1,056,245 994,496 ‐5.85%
Jul 1,234,390
Aug 1,409,269
Sep 1,584,709
Oct 1,758,480
Nov 1,925,555
Dec 2,148,553
Percent of budget expended 46.29%
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
Aug 776,605
Sep 874,091
Oct 971,695
Nov 1,068,592
Dec 1,177,608
Percent of budget expended 46.37%
$‐
$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 25 of 37
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
Aug 2,000,285
Sep 2,223,932
Oct 2,468,126
Nov 2,708,274
Dec 2,964,321
Percent of budget expended 43.86%
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
Aug 668,297
Sep 758,365
Oct 846,244
Nov 929,468
Dec 1,053,786
Percent of budget expended 30.98%
$‐
$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 26 of 37
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
Aug 1,726,181
Sep 1,971,643
Oct 2,223,724
Nov 2,452,676
Dec 2,714,466
Percent of budget expended 48.81%
Finance Budget
YTD
Actual
Annual %
over (under)
Jan 173,682 171,705 ‐1.14%
Feb 349,801 350,741 0.27%
Mar 535,847 531,013 ‐0.90%
Apr 732,791 711,350 ‐2.93%
May 925,150 907,912 ‐1.86%
Jun 1,177,529 1,245,394 5.76%
Jul 1,398,007
Aug 1,642,462
Sep 1,853,414
Oct 2,043,444
Nov 2,229,526
Dec 2,795,120
Percent of budget expended 44.56%
$‐
$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 27 of 37
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
Aug 745,168
Sep 810,502
Oct 876,269
Nov 938,389
Dec 1,091,558
Percent of budget expended 37.07%
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
Aug 851,182
Sep 962,393
Oct 1,068,605
Nov 1,178,873
Dec 1,316,577
Percent of budget expended 42.54%
$‐
$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 28 of 37
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,935,667
Aug 21,421,969
Sep 24,280,565
Oct 26,807,764
Nov 29,604,248
Dec 32,571,356
Percent of budget expended 48.54%
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
Aug 18,088,845
Sep 20,238,248
Oct 22,409,217
Nov 24,560,558
Dec 26,890,757
Percent of budget expended 50.05%
$‐
$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 29 of 37
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
Aug 367,593
Sep 412,944
Oct 457,663
Nov 506,080
Dec 560,787
Percent of budget expended 44.07%
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
Aug 3,178,173
Sep 3,648,648
Oct 4,090,791
Nov 4,476,422
Dec 4,870,254
Percent of budget expended 41.28%
$‐
$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 30 of 37
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
Aug 564,003
Sep 646,544
Oct 724,329
Nov 807,560
Dec 999,004
Percent of budget expended 33.92%
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
Aug 3,538,644
Sep 4,068,609
Oct 4,421,871
Nov 4,779,294
Dec 5,200,923
Percent of budget expended 42.45%
$‐
$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 31 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2015 Budget Year
Human
Services Budget
YTD
Actual
Annual %
over (under)
Jan 48,370 46,455 ‐3.96%
Feb 140,421 95,909 ‐31.70%
Mar 241,783 251,898 4.18%
Apr 375,238 410,324 9.35%
May 457,411 470,636 2.89%
Jun 516,776 548,427 6.12%
Jul 651,597
Aug 738,983
Sep 789,632
Oct 933,439
Nov 1,005,972
Dec 1,199,977
Percent of budget expended 45.70%
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
Aug 670,339
Sep 750,598
Oct 831,121
Nov 918,936
Dec 1,036,841
Percent of budget expended 38.74%
$‐
$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 32 of 37
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
Aug 150,608
Sep 169,866
Oct 189,289
Nov 208,614
Dec 227,761
Percent of budget expended 49.62%
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
Aug 271,809
Sep 303,553
Oct 334,125
Nov 364,445
Dec 395,867
Percent of budget expended 48.81%
$‐
$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 33 of 37
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
Aug 3,394,715
Sep 3,834,705
Oct 4,322,555
Nov 4,746,267
Dec 5,186,713
Percent of budget expended 47.28%
Transportation Budget
YTD
Actual
Annual %
over (under)
Jan 342,755 300,741 ‐12.26%
Feb 756,805 642,729 ‐15.07%
Mar 1,159,250 1,186,713 2.37%
Apr 1,721,150 1,532,946 ‐10.93%
May 2,085,812 1,925,413 ‐7.69%
Jun 2,447,685 2,312,208 ‐5.53%
Jul 2,855,673
Aug 3,315,075
Sep 3,658,906
Oct 4,074,919
Nov 4,433,073
Dec 5,076,998
Percent of budget expended 45.54%
$‐
$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 34 of 37
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 13,990,556 13,990,556 0.00%
Jun 14,506,562 14,506,562 0.00%
Jul 3,770,426
Aug 4,309,059
Sep 4,847,691
Oct 5,386,323
Nov 5,924,956
Dec 6,463,588
Percent of budget expended 224.44%
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 3,932,120
Aug 4,493,852
Sep 5,055,583
Oct 5,617,315
Nov 6,179,046
Dec 6,740,778
Percent of budget expended 24.21%
$‐
$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
$‐
$2
$4
$6
$8
$10
$12
$14
$16
Millions Debt Service
Budget
Actual
Last Year
Page 35 of 37
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
Aug 52,345,600
Sep 60,520,029
Oct 67,617,877
Nov 74,232,293
Dec 88,898,298
Percent of budget expended 27.52%
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
Aug 9,349,977
Sep 11,578,029
Oct 12,523,403
Nov 14,062,517
Dec 16,469,927
Percent of budget expended 14.56%
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 36 of 37
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
Aug 1,493,111
Sep 1,741,845
Oct 1,899,744
Nov 2,046,993
Dec 2,616,052
Percent of budget expended 36.55%
Note: Operations and Capital
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
$2.40
$2.70
Millions Golf Course
Budget
Revenue
Expense
Page 37 of 37