HomeMy WebLinkAbout201503, March.pdf ADMINISTRATIVE SERVICES
DEPARTMENT
M E M O R A N D U M
DATE: May 18, 2015
TO: Ed Prince, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: March 2015 Financial Status Report
At the end of March, general governmental revenues show $21k or 0.1% under budget.
Revenue sources that are higher than expected are: sales tax ($158k); state shared revenues
($118k); gambling taxes ($115k); and interest/other earnings ($128k). On the down side, the
revenue sources that are underperforming the year to date budget are: utility taxes ($209k
below) and building permits & development service fees ($280k below).
General government expenditures showed a favorable variance of $329k or 1.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$ 13,508,009$ 13,508,009$ 17,565,282$ 4,057,273 30.0%
OPERATING REVENUES
Property Tax 32,485,690 1,097,866 35,295,390 1,701,026 36,040,000 1,386,683 1,313,457 (73,226) ‐5.3%
Sales Tax 20,416,372 5,119,838 21,512,379 5,248,928 22,239,731 5,534,993 5,692,874 157,881 2.9%
Sales Tax ‐ Annexation Credit 2,418,789 605,458 2,542,394 618,612 2,519,968 621,751 673,289 51,539 8.3%
Criminal Justice Sa les Tax 2,091,174 522,217 2,267,947 562,564 2,305,519 573,736 609,416 35,681 6.2%
Natural Gas Use Tax 263,660 83,570 271,485 99,781 300,000 110,261 78,954 (31,307) ‐28.4%
Admission Tax 327,258 82,440 310,311 80,243 320,000 81,652 85,153 3,501 4.3%
Franchise Fees 1,312,727 315,362 1,342,269 323,121 1,260,000 303,009 333,343 30,334 10.0%
Electricity Tax 5,155,789 1,367,581 5,167,444 1,547,772 5,365,536 1,515,265 1,299,617 (215,648) ‐14.2%
Natural Ga s Utility Tax 1,550,900 581,317 1,562,341 694,379 1,550,900 635,504 578,683 (56,821) ‐8.9%
Garbage/Solid Waste 397,596 99,887 573,457 150,679 400,000 103,214 134,850 31,635 30.7%
TV Cable 1,481,779 332,857 1,518,821 348,235 1,579,365 358,493 361,627 3,134 0.9%
Telephone 917,021 177,601 909,088 258,930 952,500 227,695 260,572 32,877 14.4%
Cellular Phone 2,050,312 389,133 1,951,925 508,427 1,967,056 441,141 425,016 (16,125) ‐3.7%
City Utilities 3,964,989 901,280 3,961,052 920,917 4,058,377 933,021 975,860 42,839 4.6%
Utility Tax Audit ‐ ‐ 460,513 ‐ ‐ ‐ ‐ ‐ 0.0%
Leasehold Excise Tax 164,637 10,248 171,470 10,618 179,000 11,112 11,601 489 4.4%
Gambling Excise Tax 1,319,585 318,528 1,650,384 418,580 1,600,000 397,099 511,743 114,644 28.9%
Real Estate Excise Tax 4,131,665 624,405 4,348,762 838,225 4,000,000 761,342 728,573 (32,770) ‐4.3%
Less: CIP REET (700,000) (120,083) (1,650,000) (158,968) (1,000,000) (182,143) (182,143) ‐ 0.0%
EMS Levy 916,361 ‐ 916,361 ‐ 920,000 ‐ ‐ ‐ 0.0%
Business License Fees 503,766 148,480 515,555 133,498 506,000 139,977 144,538 4,561 3.3%
Animal Licenses and Spec Events Permits 99,411 27,038 95,698 28,113 91,000 27,316 29,720 2,404 8.8%
Building Permits & Development Svc Fees 4,001,625 862,909 4,519,234 1,233,397 4,679,749 1,145,031 864,986 (280,045) ‐24.5%
Intergovt'l (Grants, State Shared, etc) 3,863,974 1,249,516 4,522,540 1,492,870 3,535,784 839,929 919,084 79,155 9.4%
Fire District 25 and 40 Contracts 5,726,895 161,972 5,959,428 151,469 6,116,326 158,163 158,163 ‐ 0.0%
Public Safety 680,581 186,458 844,375 206,806 513,081 132,140 163,218 31,078 23.5%
Culture and Recreation 1,494,580 191,197 1,485,123 204,853 1,580,616 210,089 183,247 (26,843) ‐12.8%
Interfund/Interdept‐Services 3,464,913 876,233 3,270,503 846,300 3,147,416 786,854 789,552 2,698 0.3%
Fines and Penalties 1,137,140 213,349 962,977 258,026 1,126,500 251,135 142,646 (108,490) ‐43.2%
Photo Enforcement 1,629,524 462,103 1,719,971 233,688 2,194,000 455,760 471,928 16,168 3.5%
Seizure Funds ‐ Federal/State/Local 50,639 3,491 68,870 (470) 180,693 4,569 ‐ (4,569) ‐100.0%
Interests and Other Earnings 423,609 18,593 981,630 35,420 875,300 33,644 161,599 127,955 380.3%
Rents, Leases, and Concessions 734,530 265,202 711,070 262,643 710,216 259,327 248,863 (10,465) ‐4.0%
Contributions and Donations 84,320 19,028 113,626 27,847 97,000 22,970 30,402 7,431 32.4%
Other Miscellaneous 684,187 190,133 879,105 252,357 705,369 193,567 264,403 70,836 36.6%
Other Financing Sources (Transfer‐In, etc) 299,527 6,974 48,632 2,375 250,000 12,208 500 (11,708) ‐95.9%
Total Operating Revenues 105,545,527 17,392,180 111,782,133 19,541,262 112,867,002 18,486,506 18,465,333 (21,173) ‐0.1%
OPERATING EXPENDITURES
Council 289,911 72,806 309,317 84,100 335,838 87,938 88,145 (206) ‐0.2%
Executive 1,240,910 297,118 1,338,738 296,472 1,547,993 356,201 319,885 36,316 10.2%
City Attorney 1,922,225 427,953 1,829,254 419,299 2,001,421 452,011 443,297 8,714 1.9%
Court Services 2,003,104 468,698 2,016,273 487,984 2,111,321 502,531 477,408 25,123 5.0%
Community and Eco Dvlpmnt Admin 1,047,860 256,405 1,010,761 249,681 1,077,608 264,916 266,079 (1,163) ‐0.4%
Development Services 3,243,702 768,135 2,659,078 683,399 2,914,321 716,652 653,820 62,831 8.8%
Economic Development 467,511 109,135 654,007 136,650 848,340 185,917 171,373 14,544 7.8%
Planning 1,510,707 350,721 2,095,706 426,860 2,561,536 552,295 616,614 (64,319) ‐11.6%
Finance 2,274,147 437,042 2,644,827 505,966 2,795,120 535,847 531,013 4,834 0.9%
City Clerk 1,020,822 202,364 1,152,246 380,731 1,091,558 292,896 194,321 98,575 33.7%
Human Resources 904,182 212,385 922,668 203,164 1,316,577 299,478 256,191 43,287 14.5%
Police 24,946,784 6,243,286 26,383,640 6,598,483 28,267,334 7,071,880 6,971,905 99,975 1.4%
Jail Services 3,814,042 953,517 3,760,273 940,029 4,200,000 1,034,578 1,034,578 ‐ 0.0%
Fire 24,444,372 6,673,347 25,240,760 6,727,201 26,876,976 7,248,974 7,236,866 12,108 0.2%
Community Services Admin 452,146 111,667 480,727 120,240 545,712 135,661 131,187 4,475 3.3%
Parks 4,024,756 851,150 4,070,181 856,188 4,794,754 1,011,282 958,044 53,238 5.3%
Parks Planning & Natural Resources 829,250 142,461 722,739 148,948 798,301 149,893 151,169 (1,276) ‐0.9%
Recreation 4,846,970 1,002,907 4,823,195 928,117 5,200,923 1,038,567 1,048,007 (9,441) ‐0.9%
Human Services 1,162,330 218,002 1,159,189 249,760 1,199,977 241,783 251,898 (10,115) ‐4.2%
Neighborhoods, Resources, & Events 770,841 171,351 875,223 200,847 1,004,403 227,109 197,567 29,542 13.0%
Museum 209,387 51,213 214,291 49,955 227,761 54,386 56,379 (1,993) ‐3.7%
Public Works Admin 426,312 119,866 389,493 95,355 395,867 104,435 96,942 7,493 7.2%
Street Maintenance 3,814,132 937,528 4,503,315 980,862 5,181,713 1,195,144 1,213,907 (18,763) ‐1.6%
Transportation 4,476,854 1,074,529 4,263,725 921,240 4,914,998 1,122,260 1,186,713 (64,453) ‐5.7%
Debt Service 8,048,508 250,317 8,393,140 303,355 6,463,588 298,456 298,456 ‐ 0.0%
Non‐Departmental and Other 5,475,340 1,009,438 9,758,346 633,063 4,267,502 888,765 888,765 ‐ 0.0%
Total Operating Expenditures 103,667,105 23,413,342 111,671,112 23,627,952 112,941,443 26,069,856 25,740,531 329,325 1.3%
Total Ending Fund Balance 17,454,262$ 9,554,677$ 17,565,283$ 13,367,572$ 13,433,567$ 5,924,659$ 10,290,084$ 4,365,425$ 73.7%
Favorable (Unfavorable)
2013 2014 2015 Variance
Annual Actual YTD Actual Annual Budget YTD Budget YTD ActualSummary of Sources and Uses Annual Actual YTD Actual
Monthly Financial Report March 2015
Page 1 of 37
Monthly Financial Report March 2015
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through March 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 72% of all
resources supporting general governmental activities. The following section provides detail information on property, sales,
utility, and other taxes.
Property Tax
March’s collection is $939k,
making the total year‐to‐date
collection $1.3 million or 3.6% of
the total budget. In comparison
to the previous year, the City
collected $388k or 23% less.
Compared to the budget, the City
is below projections by $73k or
5%. The negative amount for
January 2014 was due to
receivables not yet received by
King County. These receivables
were recorded in February 2014’s
collection.
Sales Tax
March 2015 sales tax receipts
totalled $1.7 million. Compared
with the same month last year, it
is $112k or 7% more. Compared
to the projected current month’s
budget, it is $16k or 1% above.
The year‐to‐date collection of
$5.7 million is $444k or 8% more
than the prior year and is also
$158k or 3% more than budgeted.
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.
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
May 10,692,069 8,544,299
Jun (244,519) 17,789
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 1,701,026$ 1,386,683$ 1,313,457$ (387,569)$ ‐23% (73,226)$ ‐5%
Annual Total 35,295,390$ 36,040,000$
Property Tax Revenues
Year to Date through March
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 ‐
May 1,759,697 1,950,137 ‐
Jun 1,669,870 1,753,064 ‐
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 5,248,928$ 5,534,993$ 5,692,874$ 443,946$ 8% 157,881$ 3%
Annual Total 21,512,379$ 22,239,731$
2015 vs. Budget2015 vs. 2014
Month
Year to Date through March
Local Retail Sales Tax Revenues
Page 2 of 37
Monthly Financial Report March 2015
The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business
sectors:
Utility tax
March utility tax revenues are
$1.5 million, which is $87k or 5%
lower than the same month last
year but is ahead of the budget by
$102k or 7%. The year‐to‐date
collection is $4.1 million, which is
$414k or 9% lower than the prior
year and is also $209k or 5%
lower than the budget.
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
May 1,380,317 1,391,839
Jun 1,376,544 1,310,144
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 4,529,120$ 4,324,593$ 4,115,178$ (413,942)$ ‐9% (209,414)$ ‐5%
Annual Total 16,376,127$ 16,173,734$
2015 vs. Budget2015 vs. 2014
Year to Date through March
Utility Tax Revenues
Month
Sales Tax by Sector 2014 2015 Bgt YTD Act Change 2015/2014 2015 Act vs Bgt
New Construction 534,836$ 596,779$ 612,005$ 77,169$ 14%$ 15,226 3%
Auto Sales 946,498 1,002,983 1,060,781 114,283 12% 57,798 6%
General Retail 1,705,235 1,767,665 1,832,826 127,591 7% 65,162 4%
Manufacturing 543,297 522,871 497,222 (46,075) ‐8% (25,649)‐5%
Wholesale 252,914 280,894 275,396 22,482 9% (5,498)‐2%
Service 1,118,284 1,200,882 1,254,011 135,726 12% 53,129 4%
Other 147,864 162,920 160,632 12,769 9% (2,287)‐1%
YTD Total 5,248,928$ 5,534,993$ 5,692,874$ 443,946$ 8%157,881$ 3%
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 1,547,772$ 1,515,265$ 1,299,617$ (248,155)$ ‐16%$ (215,648)‐14%
Natural Gas 794,160 745,765 657,637 (136,523) ‐17% (88,128)‐12%
Cell 508,427 441,141 425,016 (83,411) ‐16% (16,125)‐4%
Phone 258,930 227,695 260,572 1,642 1% 32,877 14%
Cable 348,235 358,493 361,627 13,392 4% 3,134 1%
Garbage/Solid Waste 150,679 103,214 134,850 (15,830) ‐11% 31,635 31%
City Utilities 920,917 933,021 975,860 54,943 6% 42,839 5%
Utility Tax Audit ‐ ‐ ‐ ‐ N/A ‐ N/A
YTD Total 4,529,120$ 4,324,593$ 4,115,178$ (413,942)$ ‐9%(209,414)$ ‐5%
Annual Total 16,376,127$ 16,173,734$
YTD as % of 28% 27%
Page 3 of 37
Monthly Financial Report March 2015
Other Taxes
Real Estate Excise Tax
The City collected $344k in Real
Estate Excise Tax revenues (REET)
for March. This is $116k or 51%
more than the same month last
year and is $77k or 29% more
than the current month’s budget.
The year‐to‐date collection is
$729k, which is $110k or 13% less
than the prior year and is also
$33k 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 March 2015 is due to 5 large
transactions ($157k).
Gambling Tax
March’s Gambling Tax collections
totalled $169k, which is $16k or
10% above the same month last
year and is also above the current
month’s budget by $27k or 19%.
The year‐to‐date total of $512k is
$93k or 22% above the prior year
and is also $115k or 29% above
budget.
Pull tabs overall had a 38%
increase, bingo had a 20%
decrease, and card‐rooms are
seeing 49% 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
$333k is $10k or 3% higher than
the prior year and is also $31k or
10% above the projected year‐to‐
date budget.
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 492,247
May 262,746 294,767
Jun 624,342 479,448
Jul 350,214 314,696
Aug 346,677 333,456
Sep 265,534 274,793
Oct 436,050 354,712
Nov 223,675 316,987
Dec 92,179 377,551
YTD Total 838,225$ 761,342$ 728,573$ (109,652)$ ‐13% (32,770)$ ‐4%
Annual Total 4,348,762$ 4,000,000$
Month
2015 vs. Budget2015 vs. 2014
Real Estate Excise Tax Revenues
Year to Date through March
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 ‐
May 138,319 127,128 ‐
Jun 135,701 105,469 ‐
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 418,580$ 397,099$ 511,743$ 93,163$ 22% 114,644$ 29%
Annual Total 1,650,384$ 1,600,000$
2015 vs. 2014 2015 vs. Budget
Gambling Tax Revenue
Month
Year to Date through March
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 ‐
Jul 324,273 303,714 ‐
Oct 321,828 305,167 ‐
Dec 49,502 46,502 ‐
YTD Total 323,121$ 303,009$ 333,343$ 10,222$ 3% 30,852$ 10%
Annual Total 1,342,269$ 1,260,000$
Franchise Fees Revenue
Year to Date through March
Month
2015 vs. 2014 2015 vs. Budget
Page 4 of 37
Monthly Financial Report March 2015
Admission Tax
Admission Tax returns are due
quarterly in January, April, July,
and October of each year.
January 2015 collections
represent activities conducted
during the 4th quarter of 2014.
The year‐to‐date collection of
$85k is $5k or 6% more than the
prior year and is also $3.5k or 4%
more than the budget.
Licenses and Permits
Building Permits and
Development Service Fees
Building Permits and
Development Service Fee
revenues totalled $276k in March.
The year‐to‐date development
fees revenue of $865k is $368k or
30% less than the year before and
is also $280k or 24% lower than
budget.
Business Licenses
Business Licenses totalled $4.5k
for March, which is $1k or 18%
below the same month last year
and is also $4.4k or 50% below
the current month’s budget. The
year‐to‐date Business Licenses
revenue of $145k is $11k or 8%
above the prior year and is also
$4.6k or 3% higher than the
budget.
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%
Apr 74,163 72,512 ‐
Jun 145 73 ‐
Jul 79,130 83,619 ‐
Aug ‐ 38 ‐
Oct 76,631 81,433 ‐
Nov ‐ 598 ‐
Dec ‐ 75 ‐
YTD Total 80,243$ 81,652$ 85,153$ 4,909$ 6% 3,501$ 4%
Annual Total 310,311$ 320,000$
Month
2015 vs. 2014 2015 vs. Budget
Admission Tax Revenue
Year to Date through March
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
May 349,590 404,850
Jun 516,689 448,800
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 1,233,397$ 1,145,031$ 864,986$ (368,411)$ ‐30% (280,045)$ ‐24%
Annual Total 4,519,234$ 4,679,749$
Building Permits and Development Service Fees
Year to Date through March
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 ‐
May 15,091 24,049 ‐
Jun 7,444 6,525 ‐
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 133,498$ 139,977$ 144,538$ 11,040$ 8% 4,561$ 3%
Annual Total 515,555$ 506,000$
Business Licenses
Month
2015 vs. 2014
Year to Date through March
2015 vs. Budget
Page 5 of 37
Monthly Financial Report March 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 86% of the total
revenues in this category.
The year‐to‐date total Intergovernmental revenue is $1.7 million or 13% of the budget.
State Shared Revenues
State Shared Revenue
collections totalled $1.3
million since the start of the
year. Compared to the
prior year, State Shared
Revenues are above by
$34k or 3%. Compared to
the projected budget, the
City is collecting $118k or
10% 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 64%
of the total revenue in this category. The year‐to‐date total charges for services are $1.5 million or 22% of the budget. The
following sections provide detail information for Public Safety, Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totalled
$163k 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 $44k or 21% less.
Compared to the year‐to‐date
budget, the City is over budget by
$31k or 24%. 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 ‐
May 35,540 28,065 ‐
Jun 107,246 48,449 ‐
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 206,806$ 132,140$ 163,218$ (43,588)$ ‐21% 31,078$ 24%
Annual Total 846,409$ 513,081$
Month
2015 vs. 2014
Year to Date through March
Public Safety Services
2015 vs. Budget
Intergovernmental 2014 2015 Bgt YTD Act Change 2015/2014 2015 Act vs Bgt
Fire District #25 ‐$ ‐$ ‐$ ‐$ N/A $ ‐ N/A
Fire District #40 151,469 158,163 158,163 6,694 4%‐ 0%
State Shared Revenue 1,260,277 1,176,148 1,294,100 33,823 3% 117,952 10%
Federal Grants 722,044 133,343 133,343 (588,701) ‐82%‐ 0%
State Grants 7,658 12,147 12,147 4,490 59%‐ 0%
Other Grants/Intgovt 65,455 92,027 88,911 23,456 36% (3,116) ‐3%
ARRA Grants ‐ 0 ‐ ‐ N/A ‐ 0%
Total Rev YTD 2,206,902$ 1,571,828$ 1,686,664$ (520,239)$ ‐24%114,836$ 7%
Total Rev Annual 13,664,242$ 12,877,629$
YTD % 16% 12% 13%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
2014 2015 2015
Actual Budget Actual $ % $ %
Crim Just Sales Tax 562,564$ 573,736$ 609,416$ 46,853$ 8% 35,681$ 6%
Judicial Contribution 5,763 ‐ 5,409 (354) ‐6% 5,409 100%
Crim Just ‐ High Crime 63,559 ‐ 62,861 (698) ‐1% 62,861 100%
Crim Just ‐ Pop 5,947 5,767 6,345 398 7% 578 10%
Crim Just ‐ Spec Prog 22,008 21,437 23,311 1,303 6% 1,874 9%
State DUI 4,433 4,305 4,272 (161) ‐4% (33) ‐1%
Liquor Profits 212,414 212,605 212,978 565 0% 374 0%
Liquor Excise Tax 63,322 57,415 48,351 (14,971) ‐24% (9,064) ‐16%
Fuel Tax 320,268 300,883 321,156 888 0% 20,273 7%
YTD Total 1,260,277$ 1,176,148$ 1,294,100$ 33,823$ 3% 117,952$ 10%
Annual Total 5,045,728$ 4,777,519$
2015 vs. Budget
State Shared Revenues
2015 vs. 2014
Revenue
Year to Date through March
Page 6 of 37
Monthly Financial Report March 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.
Recreation
Recreation revenues totalled $36k
for the current month. Compared
to the same month the prior year,
the City collected $31k or 46%
less. Compared to the projected
monthly budget, the City
collected $41k or 54% less. The
year‐to‐date collection of $183k is
$22k or 11% lower than the year
before and is also $27k or 13%
lower than the year‐to‐date
budget.
Interfund Services
The year‐to‐date collections for
Interfund Services revenues are
$790k. Compared to the prior
year, the revenues are under by
$57k or 7%. Compared to the
projected budget, the revenues
are above by $2.7k. 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.
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 ‐
May 106,771 107,408 ‐
Jun 172,332 171,135 ‐
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 204,853$ 210,089$ 183,247$ (21,606)$ ‐11% (26,843)$ ‐13%
Annual Total 1,485,123$ 1,580,616$
Recreation
Year to Date through March
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 ‐
May 269,032 262,285 ‐
Jun 277,620 262,285 ‐
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 846,300$ 786,854$ 789,552$ (56,748)$ ‐7% 2,698$ 0%
An nual Total 3,270,503$ 3,147,416$
Interfund Services
Year to Date through March
2015 vs. 2014 2015 vs. Budget
Month
Page 7 of 37
Monthly Financial Report March 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
$615k. This is $123k or 25%
higher than a year ago but is $92k
or 13% 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.
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 $472k.
The associated costs includes the
equipment provided by American Traffic
Solutions, Inc. (ATS), dedicated 2 FTEs 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 90% pro tem
budget and interpreter costs amounts to
$362k 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.
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
May 208,436 298,306
Jun 224,214 299,729
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 491,714$ 706,895$ 614,574$ 122,859$ 25% (92,322)$ ‐13%
Annual Total 2,682,948$ 3,320,500$
2015 vs. Budget2015 vs. 2014
Year to Date through March
Fines and Penalties by Month
Month
Year to Date through March
2014 2015 2015
Actual Budget Actual $ % $ %
Civil Penalties 1,939$ 3,229$ 613$ (1,326)$ ‐68% (2,616)$ ‐81%
Civil Infraction Penalties 142,809 134,977 65,274 (77,535) ‐54% (69,702) ‐52%
Civil Parking Infraction Penalties 45,956 42,665 22,534 (23,422) ‐51% (20,131) ‐47%
Photo Enforcement Program 233,688 455,760 471,928 238,240 102% 16,168 4%
Criminal Traffic Misdemeanor Fines 20,854 24,315 13,831 (7,023) ‐34% (10,484) ‐43%
Criminal Non‐Traffic Fines 12,198 9,300 13,828 1,630 13% 4,528 49%
Criminal Costs 29,480 27,175 19,631 (9,850) ‐33% (7,545) ‐28%
Non‐Court Fines, Forfeitures and Penalties 4,790 9,475 6,935 2,145 45% (2,540) ‐27%
YTD Total 491,714$ 706,895$ 614,574$ 122,859$ 25% (92,322)$ ‐13%
Annual Total 2,682,948$ 3,320,500$
Revenue
2015 vs. Budget
Fines and Penalties by Type
2015 vs. 2014
Favorable
Budget Actual Budget Actual (Unfavorable)
1
Jan 138,983$ 121,709$ 93,410$ 30,160$ 91,549$
Feb 148,513 152,185 93,410 30,160 122,026
Mar 168,263 198,034 93,410 166,935 31,099
Apr 251,837 ‐ 93,410 ‐ ‐
May 200,513 ‐ 93,410 ‐ ‐
Jun 191,262 ‐ 93,410 ‐ ‐
Jul 193,937 ‐ 93,410 ‐ ‐
Aug 168,554 ‐ 93,410 ‐ ‐
Sep 153,716 ‐ 93,410 ‐ ‐
Oct 170,949 ‐ 93,410 ‐ ‐
Nov 199,054 ‐ 93,410 ‐ ‐
Dec 208,419 ‐ 93,410 ‐ ‐
YTD Total 455,760$ 471,928$ 280,230$ 227,255$ 244,673$
Annual Total 2,194,000$ 1,120,918$
1Actuals of Revenues and Expenses
ExpensesRevenues
Photo Enforcement Program
Year to Date through March
Month
Page 8 of 37
Monthly Financial Report March 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 70% of
the total revenue in this category.
The year‐to‐date total
miscellaneous is $588k.
Compared to last year, the
revenues are above by $118k or
25%. Compared to the projected
year‐to‐date budget, the revenues
are over by $174k or 42%. 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.
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 23% of its budgeted general governmental expenditures at the end of March. This is $329k or
1.3% below year‐to‐date budgeted expenditures. See below for summary of unfavorable items for general governmental
departments.
Council department is over the year‐to‐date budget by $206 or 0.2%. This is due to the timing of when travel/training
expenditures occurring compared to the previous 2 years. We will monitor these items to determine if a budget adjustment is
necessary.
Public Works department (Admin, Street Maintenance, and Transportation) is over the year‐to‐date budget by $76k or
3.1%. This is due to the timing of when the Commute Trip Reduction (CTR) program and Street Maintenance’s surface
water utility payments were made compared to the two prior years. Year‐to‐date budget should correct itself after April.
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
May 107,650 134,915
Jun 257,714 214,161
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 469,642$ 413,582$ 587,589$ 117,947$ 25% 174,007$ 42%
Annual Total 2,298,586$ 2,165,209$
Ye ar to Date through March
Month
2015 vs. Budget2015 vs. 2014
Miscellaneous Revenues by Month
2014 2015 2015
Actual Budget Actual $ % $ %
Interests and Other Earnings 35,420$ 33,644$ 161,599$ 126,178$ 356% 127,955$ 380%
Rents, Leases, and Concessions 262,643 259,327 248,863 (13,780) ‐5% (10,465) ‐4%
Contributions/Donations from Private Sources 27,847 22,970 30,402 2,555 9% 7,431 32%
Other 144,202 93,071 146,726 2,524 2% 53,655 58%
Seizure Funds ‐ Federal/State/Local1 (470) 4,569 ‐ 470 0% (4,569) 0%
YTD Total 469,642$ 413,582$ 587,589$ 117,947$ 25% 174,007$ 42%
Annual Total 2,298,586$ 2,165,209$
1Seizure Funds are categorized in Miscellaneous for 2013 and on.
2015 vs. Budget
Miscellaneous Revenues by Type
Year to Date through March
Revenue
2015 vs. 2014
Page 9 of 37
Monthly Financial Report March 2015
CASH AND INVESTMENTS – 1ST
QUARTER
The current cash and
investments (C&I) portfolio
is provided in the table to
the right. The City’s current
C&I balance is $119.5
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 .73%.
Current %
Blended
Allowed
per policy
Current Portfolio
(principal value)
39% N/A $ 46,918,256
0% 100%‐$
13% 75% 14,951,294$
33% 75% 39,100,755$
15% 75% 18,151,026$
0% 25%‐$
0% N/A 391,853$
TOTAL INVESTMENTS 100%119,513,185$
*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
39%
LGIP
13%
GSE's
33%CD's
15%
Distribution by Type
By Institution Current %
Blended
Allowed by
Policy
Current Portfolio
(principal value)Maturity Date APY
Weighted
Yield
Blended
Cash US Bank ‐ Cash 39%N/A 46,918,256 overnight 0.45% 0.18%
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 13%75%14,951,294 10/1/2014 0.10%0.02%
US Federal Agency Securities *
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.03%
314179E FHLB 5,000,000 10/16/2017 1.49%
0.06%
314179G FHLB 5,009,485 10/17/2017 0.93%0.04%
314179H FHLMC 5,000,000 11/21/2017 1.05%
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.05%
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
119,513,185$
75%33%
Golf Interfund Loan
*Held in our safekeeping account at BNY Trust and Custody
TOTAL CASH & INVESTMENTS
20%
13%
Page 10 of 37
Monthly Financial Report March 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. The negative beginning fund balance for the Golf
Course fund is due to receiving less than anticipated user fees in 2014 and 2015. The City is currently working to address this
issue for 2015 and on.
Airport Golf Course Solid Waste
Utility Water Utility Wastewater
Utility
Surface Water
Utility Metro
REVENUES:
Licenses and permits ‐ ‐ ‐ ‐ 26,725 9,750 ‐
Grants / intergovernmental 522,221 ‐ 36,628 ‐ ‐ 783,526 ‐
Charges for services 34,469 286,393 4,377,650 3,644,469 2,438,903 2,688,845 3,917,082
Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐
Fines and penalties 812 ‐ ‐ ‐ 162 ‐ ‐
Rents, leases, and misc fees 616,743 57,004 26,224 35,139 ‐ ‐ ‐
Interest and other misc 1,779 521 3,197 86,736 95,533 25,456 3,871
TOTAL REVENUES 1,176,024 343,918 4,443,699 3,766,344 2,561,323 3,507,577 3,920,953
EXPENSES:
Utility billing ‐ ‐ 32,746 29,358 23,596 38,039 ‐
Utility systems ‐ ‐ 2,856,582 1,103,619 761,139 805,191 ‐
Utility maintenance ‐ ‐ 65,996 1,183,715 373,188 637,741 3,873,377
Transportation 312,993 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 439,697 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 312,993 439,697 2,955,324 2,316,692 1,157,923 1,480,971 3,873,377
AMOUNT AVAILABLE FOR DEBT SERVICE 863,031 (95,779) 1,488,375 1,449,652 1,403,400 2,026,606 47,576
DEBT SERVICE:
Principal ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest ‐ ‐ ‐ ‐ ‐ 130,003 ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ ‐ ‐ 130,003 ‐
CAPITAL PROJECTS 840,476 ‐ ‐ 161,665 138,015 1,122,991 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ (882) (326) ‐ ‐
CHANGE IN FUND BALANCE 22,555 (95,779) 1,488,375 1,287,105 1,265,059 773,612 47,576
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, Mar 31 829,376 (138,690) 3,033,981 17,159,199 8,854,148 8,577,833 3,363,886
Page 11 of 37
Monthly Financial Report March 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 ‐ 27,469 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ ‐ ‐ ‐ ‐ ‐ 40,057
Charges for services
Equipment rental m&o 691,656 877,222 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 22,035 ‐ 105,113 ‐ ‐ ‐
Communications ‐ 1,591 ‐ 147,398 ‐ ‐ ‐
Facilities ‐ ‐ 1,230,367 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 40,104 ‐ ‐ ‐ ‐ ‐
IT service co ntracts ‐ 123,114 ‐ ‐ ‐ ‐ ‐
Interest and other misc 6,604 2,408 1,501 481 13,449 7,948 9,161
Internal service fund misc:
Vehicle / equipment capital recovery 740,248 42,506 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 464,009 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 427,937 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 2,890,570 556,645
Other misc 1,635 ‐ 484 17 ‐ 290,247 ‐
Interfund Loan ‐ ‐ ‐ ‐ ‐ ‐ ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets 27,088 ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 22,030 ‐ ‐
TOTAL REVENUES 1,467,231 1,136,449 1,232,351 253,009 927,425 3,188,765 605,863
EXPENSES:
Communications 102,558
Equipment rental 494,247
Facilities 1,037,104
Healthcare 2,748,228
Information technology 860,399
Print and mail 81,804
Retiree healthcare 236,132
Risk management:
Risk ma nagement 1,113,956
Unemployment 8,712
Worker's compensation 428,374
TOTAL EXPENSES 494,247 860,399 1,037,104 184,362 1,551,042 2,748,228 236,132
AMOUNT AVAILABLE FOR CAPITAL 972,984 276,050 195,247 68,647 (623,617) 440,537 369,731
CAPITAL PROJECTS 526,181 86,534 57,184 ‐ ‐ ‐ ‐
TRANSFERS IN 11,005 31,609 ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 457,808 221,125 138,063 68,647 (623,617) 440,537 369,731
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, Mar 31 5,768,127 2,137,173 1,292,152 452,616 11,445,694 7,116,042 8,081,594
Page 12 of 37
Monthly Financial Report March 2015
FUND BALANCE
Page 14 shows the ending fund balance as of March 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 March, the City has $10.3 million reported in the combined general governmental fund balance of the current
year’s operating budget, which is approximately 9% of budgeted operating expenditures. This is a decrease of $7.3 million from
the year’s beginning balance. March’s ending fund balance is over the anticipated General Governmental Fund Balance of $5.9
million by $4.4 million or 73.7%. 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 March 2015
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through March 31, 2015
Funds
Balance
01/01/2015
Budgeted
Revenue
Revenue
03/31/15
Total Funds
Available
Budgeted
Expenditure
Expenditure
03/31/15 Ending Balance
GENERAL GOVERNMENT FUNDS: 17,565,282 112,867,002 18,465,333 36,030,615 112,941,443 25,740,531 10,290,084
000 General 11,159,313 83,402,440 14,438,162 25,597,475 83,490,932 20,472,818 5,124,657
001 Community Services 2,467,703 12,284,640 1,800,510 4,268,213 12,284,640 2,474,459 1,793,754
003 Street 2,147,229 10,096,711 1,465,098 3,612,327 10,096,711 2,400,620 1,211,707
004 Community Dev Block Grant 74,951 307,462 ‐ 74,951 293,358 25,700 49,251
005 Museum 65,500 227,761 54 65,554 227,761 56,379 9,175
009 Farmers Market 104,950 59,400 6,027 110,977 59,453 11,516 99,461
011 Fire Health & Wellness 74,565 25,000 5,385 79,950 25,000 582 79,368
201 Ltd GO Bonds Gen Govt Debt 838,633 1,749,405 976 839,609 1,749,405 ‐ 839,609
215 Gen Govt Misc Debt Service 632,438 4,714,183 749,121 1,381,559 4,714,183 298,456 1,083,102
SPECIAL REVENUE FUNDS: 1,100,381 1,786,631 406,276 1,506,657 1,749,027 294,695 1,211,962
102 Arterial Street 14,885 640,000 151,209 166,094 640,000 ‐ 166,094
108 Leased City Properties 121,014 768,957 152,075 273,089 663,403 227,119 45,970
110 Hotel Motel 219,090 265,000 47,096 266,186 245,000 6,108 260,078
125 1% For Art 101,380 15,000 118 101,498 102,950 ‐ 101,498
127 Cable Communication 313,090 97,674 55,393 368,483 97,674 61,468 307,015
135 Springbrook Wetlands Bank 330,922 ‐ 385 331,307 ‐ ‐ 331,307
CAPITAL PROJECT FUNDS (CIP):27,979,966 16,913,628 2,656,850 30,636,816 18,086,630 4,643,844 25,992,972
303 Community Dev Mitigation 1,238,600 86,500 115,683 1,354,283 ‐ ‐ 1,354,283
304 Fire Mitigation 926,488 99,000 84,133 1,010,621 250,000 ‐ 1,010,621
305 Transportation Mitigation 844,648 216,500 241,395 1,086,043 196,000 ‐ 1,086,043
316 Municipal Facilities CIP 4,493,986 3,344,000 633,072 5,127,058 3,366,000 522,290 4,604,768
317 Transportation CIP 4,059,718 13,167,628 1,563,264 5,622,982 14,274,630 595,882 5,027,100
326 Housing Opportunity 1,086,766 ‐ 1,270 1,088,036 ‐ ‐ 1,088,036
336 New Library Development 15,329,760 ‐ 18,033 15,347,793 ‐ 3,525,672 11,822,121
ENTERPRISE FUNDS:36,891,230 77,167,168 19,732,339 56,623,569 76,362,879 14,943,832 41,679,737
4X2 Ai rport Operating & CIP 806,821 2,651,020 1,176,025 1,982,846 2,260,529 1,153,469 829,377
403 Solid Waste Utility 1,545,606 16,461,726 4,443,699 5,989,305 16,675,139 2,955,324 3,033,981
4X4 Golf Operating & CIP (42,911) 2,655,383 356,415 313,504 2,616,052 452,194 (138,690)
4X5 Water Operating & CIP 15,872,094 16,272,634 3,766,345 19,638,439 16,737,381 2,479,239 17,159,200
4X6 Waste Water Operating & CIP 7,589,089 10,487,717 2,561,324 10,150,413 9,688,076 1,296,264 8,854,149
416 King County Metro 3,316,310 16,638,722 3,920,953 7,237,263 16,638,722 3,873,377 3,363,886
4X7 Surface Water Operating & CIP 7,804,221 11,999,966 3,507,578 11,311,799 11,746,980 2,733,965 8,577,834
INTERNAL SERVICE FUNDS:35,221,104 35,246,283 8,853,706 44,074,810 34,193,238 7,781,413 36,293,397
501 Equipment Repair/Replacement 5,310,319 5,764,536 1,478,236 6,788,555 5,507,047 1,020,428 5,768,127
502 Insurance 12,069,311 4,341,647 927,425 12,996,736 3,594,578 1,551,042 11,445,694
503 Information Services 1,916,048 4,631,231 1,168,058 3,084,106 4,641,865 946,933 2,137,173
504 Facilities 1,154,089 4,922,003 1,232,351 2,386,440 4,918,001 1,094,288 1,292,152
505 Communications 383,969 992,431 253,008 636,977 991,430 184,362 452,615
512 Insurance, Healthcare 6,675,505 12,954,736 3,188,765 9,864,270 13,424,573 2,748,228 7,116,042
522 Insurance, Leoff1 Retirees HC 7,711,863 1,639,699 605,863 8,317,726 1,115,744 236,132 8,081,594
FIDUCIARY FUNDS:5,040,982 468,000 2,981 5,043,963 210,475 54,809 4,989,154
611 Firemen's Pension 5,040,982 468,000 2,981 5,043,963 210,475 54,809 4,989,154
TOTAL FUNDS 123,798,945 244,448,712 50,117,485 173,916,430 243,543,692 53,459,124 120,457,306
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
May
June
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)
‐
‐
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,720,631 5,697,180 ‐0.41%
Feb 12,057,605 11,956,490 ‐0.84%
Mar 18,486,506 18,465,333 ‐0.11%
Apr 33,282,802
May 49,575,359
Jun 55,535,932
Jul 62,047,597
Aug 68,320,760
Sep 74,747,304
Oct 90,749,321
Nov 105,493,933
Dec 112,867,002
Percent of budget 16.36%
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
May 17,968,476
Jun 17,986,266
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 3.64%
$‐
$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
May 10,179,318
Jun 12,126,605
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 25.71%
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
May 7,135,600
Jun 8,445,745
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 25.44%
Note: Includes Natural Gas Use Tax.
$‐
$3
$6
$9
$12
$15
$18
$21
$24
Millions Sales Tax
Budget
Actual
Last Year
$‐
$2
$4
$6
$8
$10
$12
$14
$16
Millions Utility Tax
Budget
Actual
Last Year
Page 17 of 37
City of Renton
Monthly Revenue Analysis ‐ 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
May 1,662,501
Jun 2,022,387
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 20.05%
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,580,924
May 5,101,935
Jun 5,757,428
Jul 6,417,846
Aug 6,996,588
Sep 7,688,688
Oct 8,699,471
Nov 12,246,736
Dec 12,877,629
Percent of budget 13.10%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
$10
$11
$12
$13
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
May 2,787,340
Jun 3,406,478
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 21.52%
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
May 1,363,093
Jun 1,662,822
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 18.51%
$‐
$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
May 2,705,211
Jun 3,242,156
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 23.40%
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
May 627,590
Jun 841,751
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 27.14%
$‐
$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 ‐ ‐ N/A
Feb ‐ 500 100.00%
Mar 12,208 500 ‐95.90%
Apr 17,718
May 44,295
Jun 44,295
Jul 44,295
Aug 118,310
Sep 141,275
Oct 215,293
Nov 242,935
Dec 250,000
Percent of budget 0.20%
$0
$50,000
$100,000
$150,000
$200,000
$250,000
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,253,589
May 1,548,356
Jun 2,027,804
Jul 2,342,500
Aug 2,675,957
Sep 2,950,749
Oct 3,305,462
Nov 3,622,449
Dec 4,000,000
Percent of budget 18.21%
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
May 1,958,109
Jun 2,406,908
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 18.48%
$‐
$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,773,402 8,067,548 ‐8.05%
Feb 17,610,936 17,074,731 ‐3.04%
Mar 26,069,856 25,740,531 ‐1.26%
Apr 36,778,256
May 45,904,457
Jun 54,971,296
Jul 64,735,249
Aug 74,435,023
Sep 83,873,894
Oct 93,001,464
Nov 102,103,460
Dec 112,941,443
Percent of budget expended 22.79%
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
May 142,930
Jun 171,000
Jul 198,534
Aug 225,314
Sep 252,423
Oct 279,819
Nov 307,043
Dec 335,838
Percent of budget expended 26.25%
$‐
$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 93,133 80,465 ‐13.60%
Feb 223,666 200,055 ‐10.56%
Mar 356,201 319,885 ‐10.20%
Apr 496,186
May 627,404
Jun 746,113
Jul 876,670
Aug 1,011,592
Sep 1,135,375
Oct 1,263,928
Nov 1,387,811
Dec 1,547,993
Percent of budget expended 20.66%
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
May 767,231
Jun 934,548
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 22.15%
$‐
$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 163,780 151,935 ‐7.23%
Feb 332,997 313,414 ‐5.88%
Mar 502,531 477,408 ‐5.00%
Apr 684,804
May 854,181
Jun 1,037,941
Jul 1,212,999
Aug 1,384,848
Sep 1,557,248
Oct 1,728,007
Nov 1,892,187
Dec 2,111,321
Percent of budget expended 22.61%
CED Admin Budget
YTD
Actual
Annual %
over (under)
Jan 88,213 88,408 0.22%
Feb 176,420 177,244 0.47%
Mar 264,916 266,079 0.44%
Apr 354,961
May 443,442
Jun 532,479
Jul 621,626
Aug 710,658
Sep 799,865
Oct 889,181
Nov 977,850
Dec 1,077,608
Percent of budget expended 24.69%
$‐
$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 241,499 201,493 ‐16.57%
Feb 470,308 427,863 ‐9.02%
Mar 716,652 653,820 ‐8.77%
Apr 983,852
May 1,225,761
Jun 1,467,752
Jul 1,708,759
Aug 1,966,546
Sep 2,186,420
Oct 2,426,496
Nov 2,662,593
Dec 2,914,321
Percent of budget expended 22.43%
Economic
Development Budget
YTD
Actual
Annual %
over (under)
Jan 84,840 43,127 ‐49.17%
Feb 122,587 122,554 ‐0.03%
Mar 185,917 171,373 ‐7.82%
Apr 251,626
May 307,009
Jun 377,269
Jul 460,326
Aug 538,006
Sep 610,514
Oct 681,260
Nov 748,259
Dec 848,340
Percent of budget expended 20.20%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
Millions
Development Services
Budget
Actual
Last Year
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
$0.70
$0.80
$0.90
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 167,736 197,905 17.99%
Feb 356,139 398,110 11.79%
Mar 552,295 616,614 11.65%
Apr 756,300
May 959,551
Jun 1,172,670
Jul 1,395,010
Aug 1,628,930
Sep 1,860,563
Oct 2,098,441
Nov 2,314,495
Dec 2,561,536
Percent of budget expended 24.07%
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
May 925,150
Jun 1,177,529
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 19.00%
$‐
$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
May 551,378
Jun 612,495
Jul 674,452
Aug 745,168
Sep 810,502
Oct 876,269
Nov 938,389
Dec 1,091,558
Percent of budget expended 17.80%
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
May 520,778
Jun 633,337
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 19.46%
$‐
$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,829,170 2,696,824 ‐4.68%
Feb 5,321,607 5,110,347 ‐3.97%
Mar 8,106,457 8,006,482 ‐1.23%
Apr 10,609,085
May 13,421,593
Jun 16,038,735
Jul 18,875,223
Aug 21,353,692
Sep 24,203,091
Oct 26,722,308
Nov 29,509,822
Dec 32,467,334
Percent of budget expended 24.66%
Fire &
Emergency
Services Budget
YTD
Actual
Annual %
over (under)
Jan 2,491,643 2,067,851 ‐17.01%
Feb 5,125,717 5,131,944 0.12%
Mar 7,248,974 7,236,866 ‐0.17%
Apr 9,379,249
May 11,416,898
Jun 13,542,860
Jul 15,720,061
Aug 18,079,575
Sep 20,227,876
Oct 22,397,733
Nov 24,547,971
Dec 26,876,976
Percent of budget expended 26.93%
$‐
$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 42,784 41,417 ‐3.20%
Feb 87,835 84,599 ‐3.68%
Mar 135,661 131,187 ‐3.30%
Apr 181,130
May 224,432
Jun 268,602
Jul 313,725
Aug 357,711
Sep 401,843
Oct 445,361
Nov 492,475
Dec 545,712
Percent of budget expended 24.04%
Parks Budget
YTD
Actual
Annual %
over (under)
Jan 320,611 291,345 ‐9.13%
Feb 662,569 618,104 ‐6.71%
Mar 1,011,282 958,044 ‐5.26%
Apr 1,390,703
May 1,776,757
Jun 2,191,915
Jul 2,640,750
Aug 3,128,904
Sep 3,592,085
Oct 4,027,374
Nov 4,407,027
Dec 4,794,754
Percent of budget expended 19.98%
$‐
$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 44,490 46,145 3.72%
Feb 91,953 93,550 1.74%
Mar 149,893 151,169 0.85%
Apr 204,875
May 272,098
Jun 326,132
Jul 390,482
Aug 450,693
Sep 516,652
Oct 578,809
Nov 645,319
Dec 798,301
Percent of budget expended 18.94%
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
May 1,774,643
Jun 2,177,027
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 20.15%
$‐
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
$700,000
$800,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
May 457,411
Jun 516,776
Jul 651,597
Aug 738,983
Sep 789,632
Oct 933,439
Nov 1,005,972
Dec 1,199,977
Percent of budget expended 20.99%
Neighborhoods
, Resources,
and Events Budget
YTD
Actual
Annual %
over (under)
Jan 69,628 57,115 ‐17.97%
Feb 155,933 132,128 ‐15.27%
Mar 227,109 197,567 ‐13.01%
Apr 298,524
May 363,585
Jun 447,759
Jul 561,420
Aug 649,367
Sep 727,116
Oct 805,119
Nov 890,187
Dec 1,004,403
Percent of budget expended 19.67%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Millions Human Services
Budget
Actual
Last Year
$‐
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
$700,000
$800,000
$900,000
$1,000,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
May 92,462
Jun 111,827
Jul 131,075
Aug 150,608
Sep 169,866
Oct 189,289
Nov 208,614
Dec 227,761
Percent of budget expended 24.75%
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
May 175,830
Jun 208,809
Jul 240,160
Aug 271,809
Sep 303,553
Oct 334,125
Nov 364,445
Dec 395,867
Percent of budget expended 24.49%
$‐
$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,080 387,644 1.46%
Feb 809,811 784,009 ‐3.19%
Mar 1,195,144 1,213,907 1.57%
Apr 1,693,091
May 2,113,391
Jun 2,542,593
Jul 2,966,489
Aug 3,391,442
Sep 3,831,008
Oct 4,318,388
Nov 4,741,692
Dec 5,181,713
Percent of budget expended 23.43%
Transportation Budget
YTD
Actual
Annual %
over (under)
Jan 331,818 300,741 ‐9.37%
Feb 732,656 642,729 ‐12.27%
Mar 1,122,260 1,186,713 5.74%
Apr 1,666,230
May 2,019,256
Jun 2,369,583
Jul 2,764,552
Aug 3,209,295
Sep 3,542,156
Oct 3,944,894
Nov 4,291,620
Dec 4,914,998
Percent of budget expended 24.14%
$‐
$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 2,154,529
May 2,693,162
Jun 3,231,794
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 4.62%
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,422,501
May 1,778,126
Jun 2,133,751
Jul 2,489,376
Aug 2,845,001
Sep 3,200,626
Oct 3,556,252
Nov 3,911,877
Dec 4,267,502
Percent of budget expended 20.83%
$‐
$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 35 of 37
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2015 Budget Year
Utilities Budget Revenue Expense
Jan 4,153,122 5,924,339 3,255,611
Feb 9,001,940 11,761,602 9,177,660
Mar 14,128,728 18,199,879 13,336,961
Apr 19,036,527
May 24,436,893
Jun 30,620,233
Jul 37,038,155
Aug 42,835,943
Sep 49,169,309
Oct 54,835,630
Nov 60,174,394
Dec 71,486,298
Percent of budget expended 14.81%
Note: Operations and Capital
Airport Budget Revenue Expense
Jan 52,738 211,809 77,274
Feb 229,489 801,118 211,920
Mar 595,740 1,176,025 1,153,469
Apr 685,098
May 848,241
Jun 936,763
Jul 1,185,625
Aug 1,283,302
Sep 1,589,106
Oct 1,718,861
Nov 1,930,107
Dec 2,260,529
Percent of budget expended 51.03%
Note: Operations and Capital
$0
$10
$20
$30
$40
$50
$60
$70
$80
Millions Utilities
Budget
Revenue
Expense
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
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
May 756,759
Jun 959,820
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 17.29%
Note: Operations and Capital
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
$2.40
$2.70
$3.00
Millions Golf Course
Budget
Revenue
Expense
Page 37 of 37