HomeMy WebLinkAbout201407, July.pdf ADMINISTRATIVE SERVICES
DEPARTMENT
M E M O R A N D U M
DATE: September 2, 2014
TO: Don Persson, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: July 2014 Financial Status Report
At the end of July, general governmental revenues show $2.4 million or 3.9% over budget.
Revenues sources that are higher than expected are: sales tax ($295k); sales tax annexation
credit ($143k); utility taxes ($582k); state shared revenue ($228k); real estate excise tax
($936k); building permits & development service fees ($786k), and other miscellaneous
($169k). On the down side, the revenue sources that are underperforming the year to date
budget are: property tax ($233k below), seizure funds ($120k below, restricted to drug
enforcement only and is not available for general operating purposes) and fines/penalties
($516k 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 11,057,551$ 11,057,551$ 15,575,840$ 15,575,840$ 17,454,261$ 17,454,261$ 17,454,261$ ‐ 0.0%
OPERATING REVENUES
Property Tax 33,466,364 17,748,446 32,485,690 16,954,079 35,240,495 18,542,776 18,309,728 (233,048) ‐1.3%
Sales Tax 18,564,670 10,512,932 20,416,372 11,562,516 20,196,000 11,673,432 11,968,696 295,263 2.5%
Sales Tax ‐ Annexation Credit 2,208,492 1,253,852 2,418,789 1,369,168 2,236,262 1,267,647 1,411,086 143,439 11.3%
Criminal Justice Sales Tax 1,924,470 1,070,042 2,091,174 1,171,527 2,000,000 1,116,418 1,266,133 149,715 13.4%
Natural Gas Use Tax 272,530 218,126 263,660 169,403 300,000 216,824 205,804 (11,019) ‐5.1%
Admission Tax 311,054 235,808 327,258 240,224 308,000 229,697 233,681 3,984 1.7%
Franchise Fees 1,262,188 904,991 1,312,727 943,042 1,260,000 904,310 970,939 66,629 7.4%
Electricity Tax 5,211,111 3,149,766 5,155,789 3,049,554 5,409,000 3,234,537 3,141,952 (92,585) ‐2.9%
Natural Gas Utility Tax 1,669,967 1,215,126 1,550,900 1,085,808 1,500,520 1,071,947 1,139,753 67,807 6.3%
Garbage/Solid Waste 330,607 172,862 397,596 221,951 300,000 162,652 330,069 167,416 102.9%
TV Cable 1,423,664 801,145 1,481,779 838,645 1,529,365 863,152 867,188 4,036 0.5%
Telephone 1,056,420 577,643 917,021 528,707 952,500 533,990 514,864 (19,126) ‐3.6%
Cellular Phone 2,183,853 1,362,824 2,050,312 1,105,046 2,077,000 1,210,573 1,069,543 (141,031) ‐11.6%
City Utilities 3,806,281 2,150,615 3,964,989 2,267,850 3,791,465 2,155,691 2,301,923 146,232 6.8%
Utility Tax Audit ‐ ‐ ‐ ‐ ‐ ‐ 460,513 460,513 100.0%
Leasehold Excise Tax 158,849 80,019 164,637 82,442 145,000 72,822 89,256 16,434 22.6%
Gambling Excise Tax 1,691,209 964,278 1,319,585 725,074 1,600,000 897,757 919,169 21,411 2.4%
Real Estate Excise Tax 2,811,902 1,468,685 4,131,665 1,719,709 2,900,000 2,048,642 2,984,646 936,005 45.7%
Less: CIP REET (943,792) (290,111) (700,000) (330,727) (550,000) (566,047) (566,047) ‐ 0.0%
EMS Levy 885,781 442,891 916,361 458,181 900,000 450,784 450,784 (0) 0.0%
Business License Fees 444,680 311,433 503,766 342,769 533,067 367,689 362,506 (5,184) ‐1.4%
Animal Licenses and Spec Events Permits 91,835 61,088 99,411 66,615 90,000 58,467 65,576 7,109 12.2%
Building Permits & Development Svc Fees 3,552,369 1,824,188 4,001,625 2,224,985 3,705,701 1,976,502 2,762,637 786,135 39.8%
Intergovt'l (Grants, State Shared, etc) 4,593,185 2,532,984 3,863,974 2,539,941 4,188,188 2,624,801 2,703,122 78,322 3.0%
Fire District 25 and 40 Contracts 6,155,621 3,078,566 5,726,895 2,872,722 5,877,463 2,977,343 2,977,343 ‐ 0.0%
Public Safety 485,899 283,204 680,581 404,737 774,535 456,788 444,005 (12,783) ‐2.8%
Culture and Recreation 1,494,165 911,944 1,494,580 952,859 1,525,863 952,049 981,907 29,857 3.1%
Interfund/Interdept‐Services 3,311,715 1,781,164 3,464,913 2,034,531 3,332,794 1,944,130 1,933,148 (10,982) ‐0.6%
Fines and Penalties 1,046,246 541,152 1,137,140 603,794 1,108,500 582,112 593,389 11,277 1.9%
Photo Enforcement 1,976,203 1,279,871 1,629,524 1,174,581 1,950,000 1,327,384 799,863 (527,521) ‐39.7%
Seizure Funds ‐ Federal/State/Local 37,941 25,614 50,639 34,567 180,693 123,343 3,346 (119,997) ‐97.3%
Interests and Other Earnings 342,424 59,508 423,609 61,350 745,300 117,587 79,505 (38,082) ‐32.4%
Rents, Leases, and Concessions 822,428 529,399 734,530 527,965 756,464 513,731 514,153 421 0.1%
Contributions and Donations 124,082 71,324 84,320 52,867 96,100 57,268 65,672 8,404 14.7%
Other Miscellaneous 564,571 310,750 684,187 420,017 516,630 313,422 482,673 169,251 54.0%
Other Financing Sources (Transfer‐In, etc) 5,118,188 144,991 299,527 20,415 ‐ ‐ 8,617 8,617 100.0%
Total Operating Revenues 108,457,170 57,787,119 105,545,527 58,496,912 107,476,905 60,480,219 62,847,141 2,366,922 3.9%
OPERATING EXPENDITURES
Council 278,768 161,791 289,911 169,210 309,907 180,383 185,030 (4,647) ‐2.6%
Executive 1,377,109 775,729 1,240,910 718,411 1,359,996 776,168 742,514 33,655 4.3%
City Attorney 1,706,320 982,591 1,922,225 1,013,090 1,863,395 1,024,858 1,035,254 (10,396) ‐1.0%
Court Services 2,074,980 1,225,120 2,003,104 1,141,510 2,094,010 1,215,215 1,167,708 47,507 3.9%
Community and Eco Dvlpmnt Admin 942,071 553,718 1,047,860 600,318 1,012,142 586,980 587,213 (233) 0.0%
Development Services 3,091,238 1,718,369 3,243,702 1,867,544 3,040,435 1,721,037 1,593,443 127,594 7.4%
Economic Development 529,043 311,183 467,511 254,764 644,063 365,766 353,794 11,972 3.3%
Planning 1,494,563 865,711 1,510,707 856,640 2,261,206 1,296,003 1,107,408 188,595 14.6%
Finance 2,221,882 1,172,818 2,274,147 1,123,823 2,334,758 1,192,630 1,336,451 (143,820) ‐12.1%
City Clerk1 997,434 644,844 1,020,822 692,263 1,125,927 745,933 650,434 95,500 12.8%
Human Resources 937,412 540,433 904,182 510,868 1,002,994 572,574 516,316 56,259 9.8%
Police 25,004,580 14,710,132 24,946,784 14,602,739 25,925,197 15,213,638 15,223,692 (10,054) ‐0.1%
Jail Services 3,489,616 1,746,776 3,814,042 2,224,865 4,500,000 2,194,316 2,194,316 ‐ 0.0%
Fire 24,173,315 14,471,622 24,444,372 14,457,407 25,219,873 15,006,605 14,602,905 403,700 2.7%
Community Services Admin 434,558 250,982 452,146 262,830 493,982 286,244 273,470 12,774 4.5%
Parks 4,004,054 2,170,674 4,024,756 2,236,956 4,311,514 2,366,921 2,221,396 145,525 6.1%
Parks Planning & Natural Resources 577,934 319,721 829,250 370,751 880,373 431,978 388,391 43,587 10.1%
Recreation 4,982,229 2,707,614 4,846,970 2,696,025 5,111,272 2,809,941 2,585,291 224,650 8.0%
Human Services 1,193,871 682,779 1,162,330 628,351 1,221,989 679,987 632,253 47,734 7.0%
Neighborhoods, Resources, & Events 701,673 369,868 770,841 447,998 979,716 544,155 472,085 72,070 13.2%
Library 278,604 266,106 ‐ ‐ ‐ ‐ ‐ ‐ 0.0%
Museum 216,887 126,037 209,387 122,060 226,683 131,932 121,764 10,168 7.7%
Public Works Admin 470,051 275,725 426,312 269,323 456,340 277,486 225,599 51,886 18.7%
Street Maintenance 3,755,640 2,168,603 3,814,132 2,229,390 4,488,268 2,607,657 2,532,280 75,377 2.9%
Transportation 4,615,160 2,561,195 4,476,854 2,490,033 4,539,752 2,522,140 2,426,304 95,836 3.8%
Debt Service 9,752,337 1,905,620 8,048,508 1,808,239 8,340,863 2,068,927 2,068,927 ‐ 0.0%
Non‐Departmental and Other 4,637,555 1,863,974 5,475,340 2,740,276 7,881,844 6,782,586 6,782,586 ‐ 0.0%
Total Operating Expenditures 103,938,882 55,549,735 103,667,105 56,535,685 111,626,501 63,602,060 62,026,823 1,575,237 2.5%
Total Ending Fund Balance 15,575,840$ 13,294,935$ 17,454,262$ 17,537,067$ 13,304,665$ 14,332,420$ 18,274,579$ 3,942,159$ 27.5%
Summary of Sources and Uses Annual Actual YTD Actual Favorable (Unfavorable)
2012 2013 2014 Variance
Annual Actual YTD Actual Annual Budget YTD Budget YTD Actual
Monthly Financial Report July 2014
Page 1 of 36
Monthly Financial Report July 2014
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through July 31, 2014. Except as noted,
year‐to‐date budgeted (adjusted) 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 74% of all
resources supporting general governmental activities. The following section provides detail information on property, sales,
utility, and other taxes.
Property Tax
July’s collection is $352k, making
the total year‐to‐date collection
$18.3 million or 52% of the total
budget. In comparison to the
previous year, the City collected
$1.4 million or 8% more.
Compared to the budget, the City
is below projections by $233k or
1%. The variance from the
monthly budget is due the timing
of collections. The City is
projecting property tax to meet
the budget at year‐end.
Sales Tax
July 2014 sales tax receipts
totalled $1.7 million. Compared
with the same month last year, it
is $84k or 5% more. Compared to
the projected current month’s
budget, it is $132k or 8% above.
The year‐to‐date collection of $12
million is $406k or 4% more than
the prior year and is also $295k or
3% more than budgeted. As you
can see in the table below, almost
this entire amount is attributed to
a large transportation
manufacturer, which changed its
reporting method in late
2013/early 2014. 2014’s monthly
budgets are generally based on 2006 through 2013 collections. The City is projecting sales tax to meet the budget at year‐end.
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 1,620,555$ 1,607,453$ 1,607,045$ (13,510)$ ‐1% (408)$ 0%
Feb 1,962,886 2,047,494 2,079,673 116,787 6% 32,179 2%
Mar 1,536,397 1,523,208 1,562,210 25,814 2% 39,002 3%
Apr 1,509,953 1,548,879 1,558,271 48,318 3% 9,393 1%
May 1,732,058 1,762,699 1,759,697 27,639 2% (3,002) 0%
Jun 1,552,807 1,584,050 1,669,870 117,064 8% 85,821 5%
Jul 1,647,860 1,599,650 1,731,929 84,069 5% 132,279 8%
Aug 1,833,347 1,718,742 ‐
Sep 1,741,262 1,633,772 ‐
Oct 1,790,411 1,728,992 ‐
Nov 1,802,768 1,740,835 ‐
Dec 1,686,069 1,700,227 ‐
YTD Total 11,562,516$ 11,673,432$ 11,968,696$ 406,180$ 4% 295,263$ 3%
Annual Total 20,416,372$ 20,196,000$
2014 vs. Budget2014 vs. 2013
Month
Year to Date through July
Local Retail Sales Tax Revenues
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 154,945$ 162,468$ (101,807)$ (256,752)$ ‐166% (264,275)$ ‐163%
Feb 25,020 59,096 176,551 151,531 606% 117,455 199%
Mar 917,901 960,884 1,626,283 708,382 77% 665,398 69%
Apr 9,887,324 10,632,911 5,808,865 (4,078,459) ‐41% (4,824,046) ‐45%
May 5,780,361 6,364,899 10,692,069 4,911,708 85% 4,327,171 68%
Jun 88,480 70,363 (244,519) (332,999) ‐376% (314,882) ‐448%
Jul 100,047 292,155 352,287 252,240 252% 60,132 21%
Aug 58,101 3,718
Sep 548,071 584,469
Oct 10,140,892 10,620,057
Nov 4,341,474 5,057,587
Dec 443,072 431,888
YTD Total 16,954,079$ 18,542,776$ 18,309,728$ 1,355,649$ 8% (233,048)$ ‐1%
Annual Total 32,485,690$ 35,240,495$
Property Tax Revenues
Year to Date through July
2014 vs. 2013 2014 vs. Budget
Month
Page 2 of 36
Monthly Financial Report July 2014
The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business
sectors:
Utility tax
July utility tax revenues are $1.5
million, which is $267k or 21%
higher than the same month last
year and is also ahead of the
budget by $228k or 18%. The
year‐to‐date collection is $10
million, which is $765k or 8%
higher than the prior year and is
also $582k or 6% higher than the
budget. 79% of this favorable
variance is due to one‐time audit
adjustments. Excluding audit
related collections, the City is
projecting utility tax revenues to
be very close to the budget at
year‐end.
The table below breaks out Utility Tax by source. The variance for Garbage/Solid Waste (not City Utilities) is due to a one‐
time correction (under reporting during September 2013 through December 2013) receipted in February. The variance for
Cellular utilities is due to the timing of our revenue collection. As of July, we are only recording 6 months of revenue,
compared to 7 months in prior years. Excluding the timing difference variances and audit related revenue, the YTD is
approximately $9.7 million.
2013 2014 2014
ActualBudgetActual $%$%
Jan 1,277,860$ 1,372,593$ 1,373,119$ 95,259$ 7% 526$ 0%
Feb 1,462,236 1,490,351 1,524,563 62,327 4% 34,213 2%
Mar 1,193,129 1,310,634 1,631,438 438,309 37% 320,804 24%
Apr 1,545,257 1,463,692 1,218,999 (326,258) ‐21% (244,693) ‐17%
May 1,338,923 1,362,789 1,380,317 41,394 3% 17,529 1%
Jun 1,189,847 1,151,072 1,376,544 186,698 16% 225,472 20%
Jul 1,259,713 1,298,235 1,526,628 266,915 21% 228,393 18%
Aug 1,280,207 1,218,858
Sep 1,433,293 1,366,340
Oct 1,072,773 1,103,445
Nov 1,244,671 1,222,957
Dec 1,484,137 1,498,886
YTD Total 9,266,965$ 9,449,365$ 10,031,609$ 764,644$ 8% 582,243$ 6%
Annual Total 15,782,047$ 15,859,850$
2014 vs. Budget2014 vs. 2013
Year to Date through July
Utility Tax Revenues
Month
Sales Tax by Sector 2013 2014 Bgt YTD Act Change 2014/2013 2014 Act vs Bgt
New Construction 1,502,663$ 1,190,895$ 1,167,354$ (335,310)$ ‐22%$ (23,541)‐2%
Auto Sales 2,122,045 2,246,680 2,307,070 185,024 9% 60,390 3%
General Retail 3,771,296 3,886,095 3,792,234 20,938 1% (93,861)‐2%
Manufacturing 749,670 799,742 1,167,145 417,475 56% 367,403 46%
Wholesale 658,794 683,837 641,715 (17,079) ‐3% (42,122)‐6%
Service 2,449,354 2,557,948 2,560,726 111,371 5% 2,778 0%
Other 308,693 308,236 332,453 23,760 8% 24,217 8%
YTD Total 11,562,516$ 11,673,432$ 11,968,696$ 406,180$ 4%295,263$ 3%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility Tax by Type 2013 2014 Bgt YTD Act Change 2014/2013 2014 Act vs Bgt
Electrical 3,049,554$ 3,234,537$ 3,141,952$ 92,398$ 3%$ (92,585)‐3%
Natural Gas 1,255,211 1,288,770 1,345,558 90,346 7% 56,787 4%
Cell 1,105,046 1,210,573 1,069,543 (35,503) ‐3% (141,031)‐12%
Phone 528,707 533,990 514,864 (13,843) ‐3% (19,126)‐4%
Cable 838,645 863,152 867,188 28,543 3% 4,036 0%
Garbage/Solid Waste 221,951 162,652 330,069 108,118 49% 167,416 103%
City Utilities 2,267,850 2,155,691 2,301,923 34,072 2% 146,232 7%
Utility Tax Audit ‐ ‐ 460,513 460,513 100% 460,513 100%
YTD Total 9,266,965$ 9,449,365$ 10,031,609$ 764,644$ 8%582,243$ 6%
Annual Total 15,782,047$ 15,859,850$
Page 3 of 36
Monthly Financial Report July 2014
Other Taxes
Real Estate Excise Tax
The City collected $350k in Real
Estate Excise Tax revenues (REET)
for July. This is $86k or 33% more
than the same month last year
and is also $104k or 42% more
than the current month’s budget.
The year‐to‐date collection is $3
million, which is $1.3 million or
74% more than the prior year and
is also $936k or 46% above the
budget. The higher than expected
variance is due to 8 large
transactions in February, March,
April, June and July which
accounts for $1.2 million of the
total REET collected. The monthly
budget is based on a normalized annual distribution (2012 only). The City is projecting REET to exceed the budget at year‐end.
Gambling Tax
July’s Gambling Tax collections
totalled $123k, which is $33k or
37% above the same month last
year but is $10k or 8% below the
current month’s budget. The
year‐to‐date total of $919k is
$194k or 27% above the year and
is also $21k or 2% above budget.
The monthly variances are due to
2 establishments filing for
bankruptcy earlier in the year.
Pull tabs overall had a 14%
increase, bingo increased by 3%,
and card‐rooms are seeing 17%
higher in activities when compared to the prior year.
Franchise Fees
Franchise Fees are due quarterly
in January, April, July, and
October. Due to the timing of
when the payment was received,
the City recorded January’s
payment in February ($323k). The
year‐to‐date total of $971k is
$29k or 3% higher than the prior
year and is also $67k or 7% above
the projected year‐to‐date
budget. The City is projecting
Franchise Fees to meet budget at year‐end.
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 134,099$ 109,119$ 162,143$ 28,044$ 21% 53,024$ 49%
Feb 262,229 301,209 448,452 186,223 71% 147,243 49%
Mar 228,077 248,682 227,629 (448) 0% (21,053) ‐8%
Apr 197,659 369,133 909,120 711,461 360% 539,987 146%
May 285,948 305,678 262,746 (23,202) ‐8% (42,932) ‐14%
Jun 347,890 468,877 624,342 276,452 79% 155,465 33%
Jul 263,807 245,943 350,214 86,407 33% 104,270 42%
Aug 294,056 222,587
Sep 254,318 172,727
Oct 272,776 268,015
Nov 342,535 138,779
Dec 1,248,272 49,250
YTD Total 1,719,709$ 2,048,642$ 2,984,646$ 1,264,938$ 74% 936,005$ 46%
Annual Total 4,131,665$ 2,900,000$
Real Estate Excise Tax Revenues
Year to Date through July
Month
2014 vs. Budget2014 vs. 2013
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 133,504$ 164,456$ 131,776$ (1,728)$ ‐1% (32,679)$ ‐20%
Feb 73,730 115,620 133,109 59,379 81% 17,489 15%
Mar 111,294 111,371 153,695 42,401 38% 42,324 38%
Apr 159,655 168,010 103,980 (55,675) ‐35% (64,030) ‐38%
May 97,660 105,619 138,319 40,659 42% 32,700 31%
Jun 60,074 99,613 135,701 75,627 126% 36,088 36%
Jul 89,157 133,068 122,588 33,432 37% (10,480) ‐8%
Aug 99,930 130,972 ‐
Sep 116,204 148,130 ‐
Oct 112,141 106,090 ‐
Nov 114,909 155,314 ‐
Dec 151,327 161,736 ‐
YTD Total 725,074$ 897,757$ 919,169$ 194,094$ 27% 21,411$ 2%
Annual Total 1,319,585$ 1,600,000$
Year to Date through July
2014 vs. 2013 2014 vs. Budget
Gambling Tax Revenue
Month
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 314,269$ 300,776$ ‐$ (314,269)$ ‐100% (300,776)$ ‐100%
Feb 200 98 323,121 322,921 161461% 323,023 330063%
Mar 892 437 ‐
Apr 311,986 299,239 323,544 11,558 4% 24,305 8%
Jul 315,694 303,760 324,273 8,579 3% 20,513 7%
Oct 321,202 308,381 ‐
Nov ‐ ‐ ‐
Dec 48,484 47,308 ‐
YTD Total 943,042$ 904,310$ 970,939$ 28,790$ 3% 67,065$ 7%
Annual Total 1,312,727$ 1,260,000$
Month
2014 vs. 2013 2014 vs . Budget
Franchise Fees Revenue
Year to Date through July
Page 4 of 36
Monthly Financial Report July 2014
Admission Tax
Admission Tax returns are due
quarterly in January, April, July,
and October of each year. July
2014 collections represent
activities conducted during the 2nd
quarter of 2014. The year‐to‐date
collection of $234k is $6.5k or 3%
less than the prior year but is
$4.4k or 2% more than the
budget.
Licenses and Permits
Building Permits and
Development Service Fees
Building Permits and
Development Service Fee
revenues totalled $289k in July.
The year‐to‐date development
fees revenue of $2.8 million is
$538k or 24% more than the year
before and is also $786k or 40%
higher than budget. The higher
than expected fees are due to
collecting more in general
building permits, electrical
permits, and plan check fees. The
City is projecting Building Permits
and Development Service Fees to
exceed the budget at year‐end.
Business Licenses
Business Licenses totalled $109k
for July, which is $57k or 108%
above the same month last year
and is also $24k or 29% above the
current month’s budget. The
variance in July is due to a mid‐
year correction made in July 2013.
The year‐to‐date Business
Licenses revenue of $363k is $20k
or 6% above the prior year but is
$5k or 1% lower than the budget.
The City is projecting business
licenses to be under the budget at
year‐end.
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 82,440$ 75,206$ 80,243$ (2,196)$ ‐3% 5,038$ 7%
Feb ‐ 451 ‐
Apr 70,311 72,698 74,163 3,852 5% 1,464 2%
Jun ‐ ‐ 145 145 100% 145 100%
Jul 87,473 81,342 79,130 (8,344) ‐10% (2,213) ‐3%
Aug 76 37 ‐
Oct 85,616 77,019 ‐
Nov 1,192 575 ‐
Dec 149 672 ‐
YTD Total 240,224$ 229,697$ 233,681$ (6,543)$ ‐3% 4,435$ 2%
Annual Total 327,258$ 308,000$
2014 vs. Budget
Admission Tax Revenue
Year to Date through July
Month
2014 vs. 2013
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 327,584$ 251,556$ 432,890$ 105,306$ 32% 181,335$ 72%
Feb 230,039 215,688 412,317 182,278 79% 196,629 91%
Mar 305,085 286,301 388,190 83,105 27% 101,889 36%
Apr 367,165 315,718 374,004 6,839 2% 58,286 18%
May 386,735 320,878 349,590 (37,145) ‐10% 28,712 9%
Jun 293,386 278,431 516,689 223,303 76% 238,258 86%
Jul 314,991 307,931 288,957 (26,033) ‐8% (18,973) ‐6%
Aug 340,270 351,856
Sep 254,799 214,610
Oct 440,169 432,077
Nov 393,258 338,737
Dec 348,144 391,919
YTD Total 2,224,985$ 1,976,502$ 2,762,637$ 537,652$ 24% 786,135$ 40%
Annual Total 4,001,625$ 3,705,701$
Building Permits and Development Service Fees
Year to Date through July
2014 vs. Budget2014 vs. 2013
Month
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 95,381$ 103,448$ 103,064$ 7,683$ 8% (384)$ 0%
Feb 40,658 36,482 25,013 (15,645) ‐38% (11,469) ‐31%
Mar 12,441 9,762 5,421 (7,020) ‐56% (4,340) ‐44%
Apr 102,648 107,716 97,104 (5,544) ‐5% (10,612) ‐10%
May 33,354 20,233 15,091 (18,263) ‐55% (5,142) ‐25%
Jun 5,701 5,102 7,444 1,743 31% 2,342 46%
Jul 52,586 84,946 109,369 56,783 108% 24,423 29%
Aug 29,210 24,595 ‐
Sep 4,236 4,178 ‐
Oct 109,998 117,828 ‐
Nov 13,342 14,515 ‐
Dec 4,211 4,262 ‐
YTD Total 342,769$ 367,689$ 362,506$ 19,737$ 6% (5,184)$ ‐1%
Annual Total 503,766$ 533,067$
2014 vs. 2013
Year to Date through July
2014 vs. Budget
Business Licenses
Month
Page 5 of 36
Monthly Financial Report July 2014
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 84% of the total
revenues in this category.
The year‐to‐date total Intergovernmental revenue is $6.9 million or 58% of the budget.
State Shared Revenues
State Shared Revenue
collections totalled $2.9
million since the start of the
year. Compared to the
prior year, State Shared
Revenues are above by
$269k or 10%. Compared
to the projected budget,
the City is collecting $235k
or 9% more. The higher
than expected collection is
due to collecting more than
anticipated Criminal Justice Sales Tax, the low budget of Criminal Justice’s High Crime and collecting more than anticipated
Liquor Profits.
Charges for Services
These revenue sources consist of general government, public safety, plan review and inspection, culture and recreation, and
interfund/interdepartmental sales and services. Recreation and interfund/interdepartmental sales and services constitute 65%
of the total revenue in this category. The year‐to‐date total charges for services are $4.5 million or 62% of the budget. The
following sections provide detail information for Public Safety, Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totalled
$444k 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 $39k or 10% more.
Compared to the year‐to‐date
budget, the City is $13k or 3% less.
The large April variance is due to a
private security police provided
for a large one‐time private
business event in 2013. The large
June variance is due to staff
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 32,322$ 31,574$ 117,639$ 85,317$ 264% 86,066$ 273%
Feb 117,056 100,863 45,139 (71,918) ‐61% (55,725) ‐55%
Mar 37,079 48,095 44,028 6,949 19% (4,067) ‐8%
Apr 64,009 87,936 38,202 (25,806) ‐40% (49,734) ‐57%
May 47,985 60,400 35,540 (12,446) ‐26% (24,860) ‐41%
Jun 36,945 45,438 107,246 70,301 190% 61,808 136%
Jul 69,340 82,484 56,212 (13,128) ‐19% (26,272) ‐32%
Aug 42,753 51,456 ‐
Sep 48,986 56,443 ‐
Oct 81,116 78,627 ‐
Nov 49,703 54,931 ‐
Dec 53,287 76,290 ‐
YTD Total 404,737$ 456,788$ 444,005$ 39,269$ 10% (12,783)$ ‐3%
Annual Total 680,581$ 774,535$
Month
2014 vs. 2013
Year to Date through July
Public Safety Services
2014 vs. Budget
2013 2014 2014 2014
Actual Budget Budget Actual $ % $ %
Crim Just Sales Tax 1,171,527$ 2,000,000$ 1,116,418$ 1,266,133$ 94,606$ 8% 149,715$ 13%
Judicial Contribution 17,097 22,500 14,073 16,968 (129) ‐1% 2,895 21%
Crim Just ‐ High Crime 166,329 ‐ ‐ 191,330 25,001 15% 191,330 100%
Crim Just ‐ Pop 16,728 ‐ ‐ 18,245 1,518 9% 18,245 100%
Crim Just ‐ Spec Prog 62,393 90,000 66,773 67,823 5,430 9% 1,050 2%
State DUI 12,697 18,000 13,480 12,949 251 2% (532) ‐4%
Liquor Profits 423,384 660,000 345,484 424,823 1,440 0% 79,339 23%
Liquor Excise Tax ‐ 440,000 371,540 132,726 132,726 100% (238,814) ‐64%
Fuel Tax 742,427 1,285,000 718,758 750,824 8,397 1% 32,066 4%
YTD Total 2,612,582$ 4,515,500$ 2,646,527$ 2,881,821$ 269,239$ 10% 235,294$ 9%
Annual Total 4,701,889$ 4,515,500$
Year to Date through July
State Shared Revenues
2014 vs. 2013
Revenue
2014 vs. Budget
Intergovernmental 2013 2014 Bgt YTD Act Change 2014/2013 2014 Act vs Bgt
Fire District #25 591,779$ 620,568$ 620,568$ 28,789$ 5% $ ‐ 0%
Fire District #40 2,280,943 2,356,775 2,356,775 75,832 3%‐ 0%
State Shared Revenue 2,612,582 2,646,527 2,881,821 269,239 10% 235,294 9%
Federal Grants 904,426 934,344 934,344 29,918 3%‐ 0%
State Grants 52,942 22,404 22,404 (30,538) ‐58%‐ 0%
Other Grants/Intgovt 26,726 137,944 130,686 103,960 389% (7,258) ‐5%
ARRA Grants 114,792 0 ‐ (114,792) 0%‐ 0%
Total Rev YTD 6,584,190$ 6,718,562$ 6,946,598$ 362,408$ 6%228,036$ 3%
Total Rev Annual 11,682,043$ 12,065,651$
YTD %56% 56% 58%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
Page 6 of 36
Monthly Financial Report July 2014
reimbursement for training provided to the Basic Law Enforcement Academy. The City is projecting Public Safety Services to be
under the budget by year‐end.
Recreation
Recreation revenues totalled
$319k for the current month.
Compared to the same month the
prior year, the City collected $26k
or 8% less. Compared to the
projected monthly budget, the
City collected $10k or 3% more.
The year‐to‐date collection of
$982k is $29k or 3% higher than
the year before and is also $30k
or 3% higher than the year‐to‐
date budget. The City is
projecting Recreation revenues to
be very close with the budget at
year‐end.
Interfund Services
The year‐to‐date collections for
Interfund Services revenues are
$1.9 million. Compared to the
prior year, the revenues are under
by $101k or 5%. Compared to the
projected budget, the revenues
are below by $11k or 1%. 2014’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.
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 60,546$ 62,601$ 69,522$ 8,976$ 15% 6,921$ 11%
Feb 51,160 56,408 68,873 17,713 35% 12,465 22%
Mar 79,491 94,074 66,458 (13,033) ‐16% (27,616) ‐29%
Apr 170,541 157,142 179,282 8,742 5% 22,140 14%
May 95,710 119,835 106,771 11,061 12% (13,064) ‐11%
Jun 150,284 152,865 172,332 22,047 15% 19,466 13%
Jul 345,126 309,124 318,669 (26,458) ‐8% 9,544 3%
Aug 205,821 238,859 ‐
Sep 123,550 118,153 ‐
Oct 83,685 86,617 ‐
Nov 65,656 67,145 ‐
Dec 63,010 63,040 ‐
YTD Total 952,859$ 952,049$ 981,907$ 29,048$ 3% 29,857$ 3%
Annual Total 1,494,580$ 1,525,863$
Recreation
Year to Date through July
2014 vs. Budget2014 vs. 2013
Month
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 265,873$ 277,733$ 301,808$ 35,935$ 14% 24,075$ 9%
Feb 292,362 277,733 257,027 (35,335) ‐12% (20,706) ‐7%
Mar 317,998 277,733 287,465 (30,533) ‐10% 9,732 4%
Apr 288,610 277,733 295,489 6,879 2% 17,756 6%
May 299,652 277,733 269,032 (30,619) ‐10% (8,700) ‐3%
Jun 287,569 277,733 277,620 (9,950) ‐3% (113) 0%
Jul 282,466 277,733 244,707 (37,759) ‐13% (33,026) ‐12%
Aug 352,945 277,733 ‐
Sep 274,525 277,733 ‐
Oct 352,421 277,733 ‐
Nov 286,300 277,733 ‐
Dec 164,190 277,733 ‐
YTD Total 2,034,531$ 1,944,130$ 1,933,148$ (101,383)$ ‐5% (10,982)$ ‐1%
Annual Total 3,464,913$ 3,332,794$
2014 vs. Budget
Month
Interfund Services
Year to Date through July
2014 vs. 2013
Page 7 of 36
Monthly Financial Report July 2014
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 $385k or 22%
lower than a year ago and is also
$516k or 27% below the budget.
Included in the Fines and Penalties revenue
budget is $2 million from the Photo
Enforcement program. The monthly budget is
based on the prior year’s revenue. The year‐to‐
date collections from this program equates to
$800k. The budget shortfall is due to
temporary shutting down 4 intersection
cameras in construction areas (expected until
September) and lower activity (driver
behaviour changes).
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 $842k which is represented in the table. April
and May expenditures do not include the monthly equipment rental costs paid to ATS, these costs are recorded in June.
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 153,064$ 182,703$ 136,762$ (16,302)$ ‐11% (45,941)$ ‐25%
Feb 247,166 251,253 151,470 (95,696) ‐39% (99,783) ‐40%
Mar 275,222 276,820 203,482 (71,740) ‐26% (73,338) ‐26%
Apr 318,235 312,315 263,785 (54,451) ‐17% (48,530) ‐16%
May 278,783 309,616 208,436 (70,347) ‐25% (101,180) ‐33%
Jun 269,334 307,008 224,214 (45,120) ‐17% (82,794) ‐27%
Jul 236,571 269,780 205,103 (31,468) ‐13% (64,677) ‐24%
Aug 171,565 178,125
Sep 154,604 169,913
Oct 191,919 249,230
Nov 189,412 230,005
Dec 280,787 321,732
YTD Total 1,778,375$ 1,909,496$ 1,393,252$ (385,123)$ ‐22% (516,244)$ ‐27%
Annual Total 2,766,663$ 3,058,500$
Month
2014 vs. Budget2014 vs. 2013
Year to Date through July
Fines and Penalties by Month
Year to Date through July
2013 2014 2014
Actual Budget Actual $ % $ %
Civil Penalties 4,616$ 7,742$ 3,939$ (678)$ ‐15% (3,803)$ ‐49%
Civil Infraction Penalties 337,881 320,512 322,508 (15,373) ‐5% 1,996 1%
Civil Parking Infraction Penalties 90,031 89,895 102,473 12,442 14% 12,578 14%
Photo Enforcement Program 1,174,581 1,327,384 799,863 (374,718) ‐32% (527,521) ‐40%
Criminal Traffic Misdemeanor Fines 56,678 56,692 51,312 (5,366) ‐9% (5,380) ‐9%
Criminal Non‐Traffic Fines 23,334 23,921 25,287 1,953 8% 1,366 6%
Criminal Costs 70,047 65,739 73,734 3,687 5% 7,995 12%
Non‐Court Fines, Forfeitures and Penalties 21,207 17,612 14,137 (7,070) ‐33% (3,475) ‐20%
YTD Total 1,778,375$ 1,909,496$ 1,393,252$ (385,123)$ ‐22% (516,244)$ ‐27%
Annual Total 2,766,663$ 3,058,500$
Revenue
2014 vs. Budget
Fines and Penalties by Type
2014 vs. 2013
Favorable
Budget Actual Budget Actual (Unfavorable)
1
Jan 180,582$ 61,721$ 73,624$ 30,160$ 31,561$
Feb 165,453 68,045 73,336 51,174 16,871
Mar 161,059 103,922 73,278 79,750 24,172
Apr 214,411 166,547 71,661 30,160 136,388
May 214,507 125,097 73,575 30,160 94,937
Jun 207,265 130,264 71,358 179,726 (49,463)
Jul 184,107 144,267 71,451 80,154 64,113
Aug 93,843 ‐ 71,108 ‐ ‐
Sep 71,053 ‐ 58,646 ‐ ‐
Oct 159,611 ‐ 63,603 ‐ ‐
Nov 135,380 ‐ 64,079 ‐ ‐
Dec 162,729 ‐ 76,245 ‐ ‐
YTD Total 1,327,384$ 799,863$ 508,282$ 481,284$ 318,579$
Annual Total 1,950,000$ 841,964$
1Actuals of Revenues and Expenses
Photo Enforcement Program
Year to Date through July
Month
Revenues Expenses
Page 8 of 36
Monthly Financial Report July 2014
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 67% of
the total revenue in this category.
The year‐to‐date total
miscellaneous is $884k.
Compared to last year, the
revenues are above by $16k or
2%. Compared to the projected
year‐to‐date budget, the revenues
are under by $38k or 4%. The negative amount for July is due to a correction made to move interest earned from Utility tax
audits, originally recorded in June. The table below page breaks out miscellaneous revenues by type.
Other miscellaneous revenues are higher than the prior year and budget due to higher than expected utility late payment
penalties and miscellaneous reimbursements for Fire.
Seizure funds are lower than the budget due to the timing of activity.
EXPENSES
Overall the City has expended 56% of its budgeted general governmental expenditures at the end of July. This is $1.6 million or
2.5% 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 $5k or 2.6%. This is due to an annual membership payment made to
National League Online. The budget for this was included in the Carry Forward amendment. We anticipate at year‐end the
department will be within budget.
City Attorney is over the year‐to‐date budget by $10k or 1%. This is due to over spending on professional services. We will
monitor this item to determine if a budget adjustment is needed.
Administrative Services department is over the year‐to‐date by $48k or 2.5%. This is mainly due to the timing of payments
related to Springbrook merchant account fees and fees paid for utility tax audit. We have requested an adjustment in the
upcoming 2nd Quarter Budget Amendment.
Police department is over the year‐to‐date budget by $10k or 0.1%. This is due to over spending on salaries/benefits/overtime
2013 2014 2014
Actual Budget Actual $ % $ %
Jan 179,743$ 180,999$ 243,963$ 64,220$ 36% 62,964$ 35%
Feb 76,397 59,215 99,547 23,149 30% 40,331 68%
Mar 147,909 148,337 126,132 (21,777) ‐15% (22,204) ‐15%
Apr 92,872 93,691 70,094 (22,778) ‐25% (23,597) ‐25%
May 118,719 201,575 107,650 (11,069) ‐9% (93,925) ‐47%
Jun 123,441 122,135 257,714 134,273 109% 135,579 111%
Jul 128,246 115,614 (21,407) (149,652) ‐117% (137,021) ‐119%
Aug 122,652 124,685
Sep 92,799 87,377
Oct 82,288 81,590
Nov 63,945 80,793
Dec 399,005 673,545
YTD Total 867,327$ 921,566$ 883,693$ 16,366$ 2% (37,873)$ ‐4%
Annual Total 1,628,017$ 1,969,557$
Year to Date through July
Month
2014 vs. Budget2014 vs. 2013
Miscellaneous Revenues by Month
2013 2014 2014
ActualBudgetActual $%$%
Interests and Other Earnings 61,350$ 117,587$ 79,505$ 18,155$ 30% (38,082)$ ‐32%
Rents, Leases, and Concessions 527,965 513,731 514,153 (13,813) ‐3% 421 0%
Contributions/Donations from Private Sources 52,867 57,268 65,672 12,805 24% 8,404 15%
Other 190,579 109,637 221,016 30,438 16% 111,380 102%
Seizure Funds ‐ Federal/State/Local 1 34,567 123,343 3,346 (31,220) ‐90% (119,997) ‐97%
YTD Total 867,327$ 921,566$ 883,693$ 16,366$ 2% (37,873)$ ‐4%
Annual Total 1,628,017$ 1,969,557$
1Seizure Funds are categorized in Miscellaneous for 2013 and on.
2014 vs. Budget
Miscellaneous Revenues by Type
Year to Date through July
Revenue
2014 vs. 2013
Page 9 of 36
Monthly Financial Report July 2014
($20k), supplies ($15k), intergovernmental services ($42k), interfund services ($53k) and under spending on professional services
($108k).
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 ‐ ‐ ‐ ‐ 42,335 32,175 ‐
Grants / intergovernmental 823,695 ‐ 117,144 ‐ ‐ 915,597 ‐
Charges for services 82,964 1,131,510 10,187,835 8,959,854 5,548,747 5,896,474 8,797,684
Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐
Fines and penalties 4,111 ‐ ‐ ‐ 1,837 ‐ ‐
Rents, leases, and misc fees 1,388,086 194,389 44,891 83,599 ‐ ‐ ‐
Interest and other misc 3,196 955 4,185 134,519 492,814 461,331 4,574
TOTAL REVENUES 2,302,052 1,326,854 10,354,055 9,177,972 6,085,733 7,305,577 8,802,258
EXPENSES:
Utility billing ‐ ‐ 72,224 64,209 52,232 84,472 ‐
Utility systems ‐ ‐ 8,613,024 3,108,440 1,731,478 1,947,983 ‐
Utility maintenance ‐ ‐ 158,409 2,742,150 738,269 1,303,994 8,508,930
Transportation 1,803,461 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 1,174,790 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 1,803,461 1,174,790 8,843,657 5,914,799 2,521,979 3,336,449 8,508,930
AMOUNT AVAILABLE FOR DEBT SERVICE 498,591 152,064 1,510,398 3,263,173 3,563,754 3,969,128 293,328
DEBT SERVICE:
Principal ‐ ‐ ‐ 395,175 270,848 42,590 ‐
Interest ‐ 1,625 ‐ 329,405 166,761 142,024 ‐
TOTAL DEBT SERVICE ‐ 1,625 ‐ 724,580 437,609 184,614 ‐
CAPITAL PROJECTS 638,370 52,812 ‐ 1,190,454 1,406,953 1,134,731 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE (139,779) 97,627 1,510,398 1,348,139 1,719,192 2,649,783 293,328
BEGINNING FUND BALANCE, Jan 1 1,669,564 319,161 1,344,883 12,350,952 5,528,366 7,510,285 2,603,562
ENDING FUND BALANCE, Jul 31 1,529,785 416,788 2,855,281 13,699,091 7,247,558 10,160,068 2,896,890
Page 10 of 36
Monthly Financial Report July 2014
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 ‐ 93,295 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ ‐ ‐ ‐ ‐ ‐ 44,426
Charges for services
Equipment rental m&o 1,629,715 1,759,904 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 65,574 ‐ 235,504 ‐ ‐ ‐
Communications ‐ 3,090 ‐ 303,865 ‐ ‐ ‐
Facilities ‐ ‐ 2,482,434 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 81,909 ‐ ‐ ‐ ‐ ‐
IT service co ntracts ‐ 255,966 ‐ ‐ ‐ ‐ ‐
Interest and other misc 6,989 3,798 2,255 636 22,971 10,647 12,254
Internal service fund misc:
Vehicle / equipment capital recovery 887,559 78,746 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 950,761 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 957,329 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 6,648,877 996,043
Other misc ‐ 3,797 1,518 164 ‐ 197,075 ‐
Interfund Loan ‐ ‐ ‐ ‐ 139,931 ‐ ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets 21,043 ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 67,963 ‐ ‐
TOTAL REVENUES 2,545,306 2,346,079 2,486,207 540,169 2,138,955 6,856,599 1,052,723
EXPENSES:
Communications 296,914
Equipment rental 1,405,456
Facilities 2,176,340
Healthcare 7,763,303
Information technology 1,885,710
Print and mail 205,860
Retiree healthcare 722,134
Risk ma nagement
Risk management 1,183,581
Unemployment 76,569
Worker's compensation 889,450
TOTAL EXPENSES 1,405,456 1,885,710 2,176,340 502,774 2,149,600 7,763,303 722,134
AMOUNT AVAILABLE FOR CAPITAL 1,139,850 460,369 309,867 37,395 (10,645) (906,704) 330,589
CAPITAL PROJECTS 578,337 372,623 174,163 ‐ ‐ ‐ ‐
TRANSFERS IN ‐ 3,073 ‐ ‐ 3,600,000 ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 561,513 90,819 135,704 37,395 3,589,355 (906,704) 330,589
BEGINNING FUND BALANCE, Jan 1 3,935,088 2,216,612 1,167,714 347,771 7,630,077 6,934,304 7,207,703
ENDING FUND BALANCE, Jul 31 4,496,601 2,307,431 1,303,418 385,166 11,219,432 6,027,600 7,538,292
Page 11 of 36
Monthly Financial Report July 2014
FUND BALANCE
Page 13 shows the ending fund balance as of July 2014. 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 July, the City has $18.3 million reported in the combined general governmental fund balance of the current year’s
operating budget, which is approximately 16% of budgeted operating expenditures. This is an increase of $820k from the year’s
beginning balance. July’s ending fund balance is over the anticipated General Governmental Fund Balance of $14.3 million by
$3.9 million or 27.5%. Although the ending fund balance is above projections, it is consistent with the prior years’ trends.
CONTACT INFORMATION
This report is prepared by the Finance Division of the Administrative Services Department. For additional financial information,
please also review our website: http://www.rentonwa.gov/. For any questions about the report, please feel free to contact us at
hnguyen@rentonwa.gov or JDThomas@Rentonwa.gov.
Page 12 of 36
Monthly Financial Report July 2014
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through July 31, 2014
Funds
Balance
01/01/2014
Budgeted
Revenue
Revenue
07/31/14
Total Funds
Available
Budgeted
Expenditure
Expenditure
07/31/14
Ending
Balance
GENERAL GOVERNMENT FUNDS:17,454,261 107,476,905 62,847,141 80,301,402 111,626,502 62,026,823 18,274,580
000 General 12,515,053 77,540,984 45,400,133 57,915,186 81,920,905 48,785,722 9,129,464
001 Community Services 2,124,598 11,706,752 6,590,914 8,715,512 11,693,059 5,900,611 2,814,901
003 Street 1,667,393 9,028,020 4,946,054 6,613,447 9,028,020 4,958,584 1,654,863
004 Community Dev Block Grant (229,834) 548,203 304,785 74,951 308,172 147,039 (72,088)
005 Museum 52,979 226,683 113,408 166,387 226,683 121,764 44,622
009 Farmers Market 98,826 60,400 35,788 134,614 83,322 39,544 95,070
011 Fire Health & Wellness 55,094 25,000 14,617 69,711 25,000 4,153 65,558
031 Park Memorial 478 ‐ ‐ 478 478 478 ‐
201 Ltd GO Bonds Gen Govt Debt 833,717 1,749,705 876,676 1,710,393 1,749,705 119,700 1,590,693
215 Gen Govt Misc Debt Service 335,957 6,591,158 4,564,765 4,900,722 6,591,158 1,949,227 2,951,496
SPECIAL REVENUE FUNDS:
102 Arterial Street 192,689 633,000 353,887 546,576 810,000 ‐ 546,576
108 Leased City Properties 549,887 833,071 354,051 903,938 853,626 439,562 464,376
110 Hotel Motel 185,606 265,000 129,498 315,104 315,693 145,080 170,024
125 1% For Art 97,771 15,000 154 97,925 50,000 7,050 90,875
127 Cable Communication 284,632 85,674 77,348 361,980 85,674 21,155 340,825
135 Springbrook Wetlands Bank 667,613 ‐ 1,107 668,720 ‐ ‐ 668,720
CAPITAL PROJECT FUNDS (CIP):
303 Community Dev Mitigation 934,618 60,000 159,464 1,094,082 ‐ ‐ 1,094,082
304 Fire Mitigation 646,165 50,000 141,395 787,560 ‐ ‐ 787,560
305 Transportation Mitigation 486,185 40,000 350,440 836,625 200,000 ‐ 836,625
316 Municipal Facilities CIP 5,083,524 3,070,672 1,440,596 6,524,120 7,921,548 1,610,925 4,913,195
317 Transportation CIP 2,687,303 18,857,104 6,531,643 9,218,946 20,835,072 8,670,251 548,695
318 So Lake WA Infrastructure Proj 9,012 ‐ 15 9,027 9,012 ‐ 9,027
326 Housing Opportunity 84,599 1,000,000 1,000,533 1,085,132 75,000 ‐ 1,085,132
336 New Library Development 19,571,748 450,000 482,191 20,053,939 20,021,748 992,627 19,061,312
ENTERPRISE FUNDS:
402 Airport 191,466 1,505,636 1,475,971 1,667,437 1,496,624 922,834 744,603
403 Solid Waste Utility 1,344,883 16,419,820 10,354,055 11,698,938 16,508,948 8,843,658 2,855,280
404 Golf Course 33,445 2,487,449 1,326,402 1,359,847 2,522,025 1,184,027 175,820
422 Airport Capital 1,478,098 15,878,548 826,081 2,304,179 17,331,646 1,518,997 785,182
424 Golf Course Capital 285,716 50,000 29,617 315,333 193,894 74,366 240,967
INTERNAL SERVICE FUNDS:
501 Equipment Repair/Replacement 3,935,088 4,361,968 2,545,306 6,480,394 4,829,709 1,983,793 4,496,601
502 Insurance 7,630,077 7,344,062 5,738,955 13,369,032 3,188,983 2,149,600 11,219,432
503 Information Services 2,216,612 4,010,222 2,349,152 4,565,764 5,358,145 2,258,332 2,307,432
504 Facilities 1,167,714 4,105,749 2,486,207 3,653,921 4,505,641 2,350,503 1,303,418
505 Communications 347,771 896,374 540,169 887,940 917,403 502,774 385,166
512 Insurance, Healthcare 6,934,304 11,622,068 6,856,599 13,790,903 12,062,456 7,763,303 6,027,600
522 Insurance, Leoff1 Retirees HC 7,207,703 1,735,684 1,052,723 8,260,426 1,738,162 722,134 7,538,292
FIDUCIARY FUNDS:
611 Firemen's Pension 4,790,247 300,000 147,093 4,937,340 225,475 102,922 4,834,418
Funds
Balance
01/01/2014
Budgeted
Revenue
Revenue
07/31/14
Total Funds
Available
Budgeted
Expenditure
Expenditure
07/31/14
Ending
Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 27,993,165 62,804,226 31,371,541 59,364,706 68,486,436 25,361,098 34,003,608
405 Water Utility 8,523,106 13,765,149 9,081,268 17,604,374 11,453,942 5,431,632 12,172,742
406 Waste Water Utility 2,578,193 7,263,934 5,639,086 8,217,279 5,544,029 2,916,931 5,300,348
407 Surface Water Utility 4,342,360 4,867,612 5,937,767 10,280,127 6,996,129 3,079,971 7,200,156
416 King County Metro 2,603,562 15,202,336 8,802,258 11,405,820 15,202,336 8,508,930 2,896,890
425 Water Utility Construction 3,811,904 4,385,000 96,678 3,908,582 7,771,000 2,398,201 1,510,381
426 Waste Water Construction 2,950,173 4,900,000 446,647 3,396,820 7,055,000 1,449,609 1,947,211
427 Surface Water Construction 3,167,925 12,420,195 1,367,811 4,535,736 14,464,000 1,575,824 2,959,912
471 Waterworks Rate Stabilization 15,942 ‐ 26 15,968 ‐ ‐ 15,968
Note: Waterworks Utility Funds are managed as a system and are designated by the dotted lines.
Page 13 of 36
City of Renton
General Government Financial Position
2014 Budget Year
General Government Summary
Revenues Expenditures
$ Difference
over (under)
w/beginning
balance
17,454,261
January 5,710,991 8,047,088 (2,336,097) 15,118,164
February 12,530,792 15,890,655 (3,359,862) 14,094,399
March 19,541,262 23,627,952 (4,086,690) 13,367,571
April 32,250,423 32,119,009 131,414 17,585,675
May 50,233,421 44,853,913 5,379,508 22,833,769
June 56,390,743 53,545,448 2,845,294 20,299,555
July 62,847,141 62,026,823 820,318 18,274,579
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
‐
10,000,000
20,000,000
30,000,000
40,000,000
50,000,000
60,000,000
70,000,000
80,000,000
90,000,000
100,000,000
110,000,000
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Change in Fund
Balance
Rev/Exp Revenues
Expenditures
Change in Fund Balance
Page 14 of 36
City of Renton
Monthly Revenue Analysis ‐ 2014 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 5,851,672 5,710,991 ‐2.40%
Feb 11,906,391 12,530,792 5.24%
Mar 17,730,142 19,541,262 10.21%
Apr 34,988,423 32,250,423 ‐7.83%
May 48,805,878 50,233,421 2.92%
Jun 54,347,230 56,390,743 3.76%
Jul 60,480,219 62,847,141 3.91%
Aug 65,829,583
Sep 71,360,222
Oct 88,350,869
Nov 100,465,791
Dec 107,476,905
Percent of budget 58.48%
Property Tax Budget
YTD
Actual
Annual %
over (under)
Jan 162,468 (101,807) ‐162.66%
Feb 221,564 74,744 ‐66.27%
Mar 1,182,448 1,701,026 43.86%
Apr 11,815,359 7,509,891 ‐36.44%
May 18,180,258 18,201,961 0.12%
Jun 18,250,621 17,957,441 ‐1.61%
Jul 18,542,776 18,309,728 ‐1.26%
Aug 18,546,494
Sep 19,130,963
Oct 29,751,020
Nov 34,808,607
Dec 35,240,495
Percent of budget 51.96%
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
Millions
Total Revenue
General Government
Budget
Actual
Last Year
$(3)
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
$36
Millions Property Tax
Budget
Actual
Last Year
Page 15 of 36
City of Renton
Monthly Revenue Analysis ‐ 2014 Budget Year
Sales Tax Budget
YTD
Actual
Annual %
over (under)
Jan 1,780,130 1,796,358 0.91%
Feb 4,049,868 4,122,324 1.79%
Mar 5,735,971 5,867,541 2.29%
Apr 7,449,682 7,607,062 2.11%
May 9,403,295 9,574,693 1.82%
Jun 11,160,683 11,442,944 2.53%
Jul 12,941,079 13,379,782 3.39%
Aug 14,856,274
Sep 16,674,205
Oct 18,600,929
Nov 20,542,214
Dec 22,432,262
Percent of budget 59.65%
Note: Excludes CJ Sales Tax and Natural Gas Use Tax.
Utility Tax Budget
YTD
Actual
Annual %
over (under)
Jan 1,372,593 1,373,119 0.04%
Feb 2,862,943 2,897,682 1.21%
Mar 4,173,577 4,529,120 8.52%
Apr 5,637,269 5,748,119 1.97%
May 7,000,058 7,128,436 1.83%
Jun 8,151,130 8,504,980 4.34%
Jul 9,449,365 10,031,609 6.16%
Aug 10,668,223
Sep 12,034,563
Oct 13,138,008
Nov 14,360,964
Dec 15,859,850
Percent of budget 63.25%
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 16 of 36
City of Renton
Monthly Revenue Analysis ‐ 2014 Budget Year
Licenses &
Permits Budget
YTD
Actual
Annual %
over (under)
Jan 283,179 404,067 42.69%
Feb 483,298 718,566 48.68%
Mar 687,979 929,709 35.14%
Apr 1,005,116 1,321,521 31.48%
May 1,238,954 1,615,047 30.36%
Jun 1,452,511 2,018,843 38.99%
Jul 1,758,517 2,340,772 33.11%
Aug 2,047,093
Sep 2,213,029
Oct 2,636,671
Nov 2,886,417
Dec 3,129,504
Percent of budget 74.80%
Note: Franchise Fees
Intergovt'l Budget
YTD
Actual
Annual %
over (under)
Jan 804,661 846,109 5.15%
Feb 1,644,685 1,714,034 4.22%
Mar 2,017,623 2,206,902 9.38%
Apr 3,096,296 3,273,493 5.72%
May 5,523,875 5,716,232 3.48%
Jun 6,143,873 6,361,338 3.54%
Jul 6,718,562 6,946,598 3.39%
Aug 7,285,531
Sep 7,766,325
Oct 8,847,812
Nov 11,348,785
Dec 12,065,651
Percent of budget 57.57%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
$10
$11
$12
Millions
Intergovernmental
Budget
Actual
Last Year
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions Licenses & Permits
Budget
Actual
Last Year
Page 17 of 36
City of Renton
Monthly Revenue Analysis ‐ 2014 Budget Year
Charges for
Services Budget
YTD
Actual
Annual %
over (under)
Jan 466,134 669,010 43.52%
Feb 1,002,386 1,198,034 19.52%
Mar 1,548,420 1,831,413 18.28%
Apr 2,214,131 2,482,936 12.14%
May 2,816,212 3,017,160 7.14%
Jun 3,402,473 3,730,690 9.65%
Jul 4,200,894 4,470,663 6.42%
Aug 4,887,074
Sep 5,421,972
Oct 6,024,642
Nov 6,558,687
Dec 7,158,086
Percent of budget 62.46%
Note: Excludes FD25 & FD40 contracts
Fines &
Forfeits Budget
YTD
Actual
Annual %
over (under)
Jan 182,703 136,762 ‐25.15%
Feb 433,957 288,232 ‐33.58%
Mar 710,777 491,714 ‐30.82%
Apr 1,023,092 755,499 ‐26.16%
May 1,332,708 963,935 ‐27.67%
Jun 1,639,716 1,188,149 ‐27.54%
Jul 1,909,496 1,393,252 ‐27.04%
Aug 2,087,621
Sep 2,257,534
Oct 2,506,763
Nov 2,736,768
Dec 3,058,500
Percent of budget 45.55%
$‐
$1
$2
$3
$4
$5
$6
$7
$8
Millions Charges for Services
Budget
Actual
Last Year
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions Fines & Forfeits
Budget
Actual
Last Year
Page 18 of 36
City of Renton
Monthly Revenue Analysis ‐ 2014 Budget Year
Other Taxes Budget
YTD
Actual
Annual %
over (under)
Jan 618,804 343,410 ‐44.50%
Feb 967,476 1,173,666 21.31%
Mar 1,284,796 1,511,820 17.67%
Apr 2,265,235 3,008,720 32.82%
May 2,626,701 3,359,954 27.92%
Jun 3,340,270 4,272,641 27.91%
Jul 4,037,964 5,082,426 25.87%
Aug 4,405,021
Sep 4,728,003
Oct 5,629,805
Nov 5,927,336
Dec 6,563,000
Percent of budget 77.44%
Misc Budget
YTD
Actual
Annual %
over (under)
Jan 180,999 243,963 34.79%
Feb 240,215 343,510 43.00%
Mar 388,551 469,642 20.87%
Apr 482,243 539,736 11.92%
May 683,818 647,386 ‐5.33%
Jun 805,952 905,100 12.30%
Jul 921,566 883,693 ‐4.11%
Aug 1,046,251
Sep 1,133,629
Oct 1,215,219
Nov 1,296,012
Dec 1,969,557
Percent of budget 44.87%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
$2.00
Millions Miscellaneous
Budget
Actual
Last Year
$‐
$1
$2
$3
$4
$5
$6
$7
$8
Millions Other Taxes
Budget
Actual
Last Year
Page 19 of 36
City of Renton
Monthly Revenue Analysis ‐ 2014 Budget Year
Other
Financing Budget
YTD
Actual
Annual %
over (under)
Jan ‐ ‐ N/A
Feb ‐ ‐ N/A
Mar ‐ 2,375 100.00%
Apr ‐ 3,447 100.00%
May ‐ 8,617 100.00%
Jun ‐ 8,617 100.00%
Jul ‐ 8,617 100.00%
Aug ‐
Sep ‐
Oct ‐
Nov ‐
Dec ‐
Percent of budget 100.00%
$0
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
Other Financing Sources
Budget
Actual
Last Year
Page 20 of 36
City of Renton
Monthly Revenue Analysis ‐ 2014 Budget Year
REET Budget
YTD
Actual
Annual %
over (under)
Jan 94,134 162,143 72.25%
Feb 278,168 610,596 119.51%
Mar 438,277 838,225 91.25%
Apr 577,013 1,747,345 202.83%
May 777,722 2,010,091 158.46%
Jun 1,021,902 2,634,433 157.80%
Jul 1,207,067 2,984,646 147.26%
Aug 1,413,460
Sep 1,591,955
Oct 1,783,413
Nov 2,023,852
Dec 2,900,000
Percent of budget 102.92%
Bldg Permits
& Devlpmt Svc
Fees Budget
YTD
Actual
Annual %
over (under)
Jan 251,556 432,890 72.09%
Feb 467,244 845,207 80.89%
Mar 753,544 1,233,397 63.68%
Apr 1,069,262 1,607,401 50.33%
May 1,390,140 1,956,991 40.78%
Jun 1,668,571 2,473,680 48.25%
Jul 1,976,502 2,762,637 39.77%
Aug 2,328,357
Sep 2,542,968
Oct 2,975,045
Nov 3,313,782
Dec 3,705,701
Percent of budget 74.55%
$‐
$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
Millions Building Permits and Development Service
Fees
Budget
Actual
Last Year
Page 21 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,656,884 8,047,088 5.10%
Feb 16,346,895 15,890,655 ‐2.79%
Mar 24,067,020 23,627,952 ‐1.82%
Apr 32,912,955 32,119,009 ‐2.41%
May 46,211,853 44,853,913 ‐2.94%
Jun 54,872,871 53,545,448 ‐2.42%
Jul 63,602,060 62,026,823 ‐2.48%
Aug 73,936,346
Sep 83,251,821
Oct 92,225,305
Nov 101,392,393
Dec 111,626,501
Percent of budget expended 55.57%
Legislative Budget
YTD
Actual
Annual %
over (under)
Jan 24,713 23,569 ‐4.63%
Feb 50,791 55,960 10.18%
Mar 77,175 84,100 8.97%
Apr 103,348 108,911 5.38%
May 128,959 133,956 3.88%
Jun 154,624 159,997 3.48%
Jul 180,383 185,030 2.58%
Aug 205,498
Sep 231,042
Oct 256,847
Nov 282,568
Dec 309,907
Percent of budget expended 59.70%
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
$120
Millions
Total Expenditures
General Government
Budget
Actual
Last Year
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
Legislative
Budget
Actual
Last Year
Page 22 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Executive Budget
YTD
Actual
Annual %
over (under)
Jan 80,412 76,257 ‐5.17%
Feb 197,216 186,396 ‐5.49%
Mar 316,702 296,472 ‐6.39%
Apr 439,720 407,807 ‐7.26%
May 557,592 517,214 ‐7.24%
Jun 661,840 629,321 ‐4.91%
Jul 776,168 742,514 ‐4.34%
Aug 891,836
Sep 997,727
Oct 1,110,465
Nov 1,222,415
Dec 1,359,996
Percent of budget expended 54.60%
City Attorney Budget
YTD
Actual
Annual %
over (under)
Jan 143,108 135,206 ‐5.52%
Feb 289,153 276,371 ‐4.42%
Mar 435,055 419,299 ‐3.62%
Apr 589,689 562,501 ‐4.61%
May 731,578 713,626 ‐2.45%
Jun 882,055 878,900 ‐0.36%
Jul 1,024,858 1,035,254 1.01%
Aug 1,170,538
Sep 1,323,502
Oct 1,482,556
Nov 1,626,768
Dec 1,863,395
Percent of budget expended 55.56%
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
Millions Executive
Budget
Actual
Last Year
$‐
$0.40
$0.80
$1.20
$1.60
$2.00
Millions City Attorney
Budget
Actual
Last Year
Page 23 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Court Services Budget
YTD
Actual
Annual %
over (under)
Jan 163,940 159,512 ‐2.70%
Feb 331,204 323,167 ‐2.43%
Mar 499,924 487,984 ‐2.39%
Apr 676,750 660,115 ‐2.46%
May 849,947 830,863 ‐2.25%
Jun 1,039,155 997,832 ‐3.98%
Jul 1,215,215 1,167,708 ‐3.91%
Aug 1,385,662
Sep 1,555,116
Oct 1,726,270
Nov 1,897,359
Dec 2,094,010
Percent of budget expended 55.76%
CED Admin Budget
YTD
Actual
Annual %
over (under)
Jan 83,847 83,232 ‐0.73%
Feb 167,836 166,457 ‐0.82%
Mar 252,105 249,681 ‐0.96%
Apr 338,988 333,812 ‐1.53%
May 421,256 418,279 ‐0.71%
Jun 504,064 502,746 ‐0.26%
Jul 586,980 587,213 0.04%
Aug 669,788
Sep 752,773
Oct 835,539
Nov 918,100
Dec 1,012,142
Percent of budget expended 58.02%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
$2.00
$2.20
Millions Court Services
Budget
Actual
Last Year
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Millions
Community & Economic
Development Admin
Budget
Actual
Last Year
Page 24 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Development
Services Budget
YTD
Actual
Annual %
over (under)
Jan 245,147 216,780 ‐11.57%
Feb 475,540 437,105 ‐8.08%
Mar 710,754 683,399 ‐3.85%
Apr 967,749 931,956 ‐3.70%
May 1,211,026 1,163,496 ‐3.92%
Jun 1,463,648 1,382,845 ‐5.52%
Jul 1,721,037 1,593,443 ‐7.41%
Aug 1,995,920
Sep 2,250,357
Oct 2,519,009
Nov 2,776,952
Dec 3,040,435
Percent of budget expended 52.41%
Economic
Development Budget
YTD
Actual
Annual %
over (under)
Jan 79,265 36,443 ‐54.02%
Feb 121,101 80,671 ‐33.39%
Mar 166,928 136,650 ‐18.14%
Apr 216,402 186,131 ‐13.99%
May 261,778 230,384 ‐11.99%
Jun 312,460 286,843 ‐8.20%
Jul 365,766 353,794 ‐3.27%
Aug 423,762
Sep 475,562
Oct 526,555
Nov 583,152
Dec 644,063
Percent of budget expended 54.93%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions
Development Services
Budget
Actual
Last Year
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
$0.70
Millions
Economic Development
Budget
Actual
Last Year
Page 25 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Planning Budget
YTD
Actual
Annual %
over (under)
Jan 176,776 123,910 ‐29.91%
Feb 364,981 264,152 ‐27.63%
Mar 549,854 426,860 ‐22.37%
Apr 735,514 584,673 ‐20.51%
May 921,326 747,714 ‐18.84%
Jun 1,108,350 922,069 ‐16.81%
Jul 1,296,003 1,107,408 ‐14.55%
Aug 1,501,983
Sep 1,703,471
Oct 1,879,353
Nov 2,062,499
Dec 2,261,206
Percent of budget expended 48.97%
Finance Budget
YTD
Actual
Annual %
over (under)
Jan 153,798 161,643 5.10%
Feb 309,673 331,528 7.06%
Mar 474,196 505,966 6.70%
Apr 647,301 678,686 4.85%
May 825,083 852,555 3.33%
Jun 1,006,594 1,129,517 12.21%
Jul 1,192,630 1,336,451 12.06%
Aug 1,381,616
Sep 1,546,956
Oct 1,701,753
Nov 1,852,570
Dec 2,334,758
Percent of budget expended 57.24%
$‐
$0.40
$0.80
$1.20
$1.60
$2.00
$2.40
Millions Finance
Budget
Actual
Last Year
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
Millions
Planning
Budget
Actual
Last Year
Page 26 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
City Clerk Budget
YTD
Actual
Annual %
over (under)
Jan 64,003 62,855 ‐1.79%
Feb 132,897 183,252 37.89%
Mar 216,913 380,731 75.52%
Apr 292,782 446,560 52.52%
May 498,004 516,105 3.63%
Jun 563,065 583,164 3.57%
Jul 745,933 650,434 ‐12.80%
Aug 827,964
Sep 901,085
Oct 973,200
Nov 1,046,567
Dec 1,125,927
Percent of budget expended 57.77%
Includes Hearing Examiner
Human
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 72,706 63,751 ‐12.32%
Feb 152,715 131,247 ‐14.06%
Mar 239,432 203,164 ‐15.15%
Apr 320,251 294,344 ‐8.09%
May 397,478 365,419 ‐8.07%
Jun 489,534 439,333 ‐10.25%
Jul 572,574 516,316 ‐9.83%
Aug 658,226
Sep 739,793
Oct 822,360
Nov 907,045
Dec 1,002,994
Percent of budget expended 51.48%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
Millions Human Resources
Budget
Actual
Last Year
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Millions City Clerk
Budget
Actual
Last Year
Page 27 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Police Budget
YTD
Actual
Annual %
over (under)
Jan 2,445,788 2,620,270 7.13%
Feb 4,883,369 4,935,606 1.07%
Mar 7,300,805 7,538,512 3.26%
Apr 9,820,439 9,787,131 ‐0.34%
May 12,415,628 12,388,107 ‐0.22%
Jun 14,764,648 14,833,908 0.47%
Jul 17,407,954 17,418,007 0.06%
Aug 20,173,278
Sep 22,849,319
Oct 25,195,504
Nov 27,818,990
Dec 30,425,197
Percent of budget expended 57.25%
Fire &
Emergency
Services Budget
YTD
Actual
Annual %
over (under)
Jan 2,041,819 2,561,083 25.43%
Feb 4,847,480 4,745,812 ‐2.10%
Mar 6,854,096 6,727,201 ‐1.85%
Apr 8,855,803 8,701,872 ‐1.74%
May 11,028,108 10,587,000 ‐4.00%
Jun 13,014,291 12,576,090 ‐3.37%
Jul 15,006,605 14,602,905 ‐2.69%
Aug 17,030,818
Sep 19,036,886
Oct 21,071,064
Nov 23,133,937
Dec 25,219,873
Percent of budget expended 57.90%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
Millions Police
Budget
Actual
Last Year
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
Millions Fire & Emergency Services
Budget
Actual
Last Year
Page 28 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Community
Services Admin Budget
YTD
Actual
Annual %
over (under)
Jan 42,394 36,113 ‐14.82%
Feb 82,537 75,787 ‐8.18%
Mar 122,781 120,240 ‐2.07%
Apr 164,144 158,781 ‐3.27%
May 205,095 196,067 ‐4.40%
Jun 245,774 233,851 ‐4.85%
Jul 286,244 273,470 ‐4.46%
Aug 326,379
Sep 366,052
Oct 405,523
Nov 447,189
Dec 493,982
Percent of budget expended 55.36%
Parks Budget
YTD
Actual
Annual %
over (under)
Jan 292,322 271,473 ‐7.13%
Feb 598,427 555,521 ‐7.17%
Mar 920,103 856,188 ‐6.95%
Apr 1,273,822 1,154,945 ‐9.33%
May 1,614,058 1,483,776 ‐8.07%
Jun 1,979,168 1,838,337 ‐7.12%
Jul 2,366,921 2,221,396 ‐6.15%
Aug 2,777,634
Sep 3,184,127
Oct 3,574,538
Nov 3,939,495
Dec 4,311,514
Percent of budget expended 51.52%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
Millions Parks
Budget
Actual
Last Year
$0
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
$400,000
$450,000
$500,000
Community Services Admin
Budget
Actual
Last Year
Page 29 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Parks Planning
and Natural
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 49,228 43,855 ‐10.91%
Feb 101,030 90,409 ‐10.51%
Mar 166,883 148,948 ‐10.75%
Apr 229,214 201,429 ‐12.12%
May 301,827 270,042 ‐10.53%
Jun 366,732 323,404 ‐11.81%
Jul 431,978 388,391 ‐10.09%
Aug 495,631
Sep 564,205
Oct 636,195
Nov 702,081
Dec 880,373
Percent of budget expended 44.12%
Recreation Budget
YTD
Actual
Annual %
over (under)
Jan 317,480 278,944 ‐12.14%
Feb 677,093 603,208 ‐10.91%
Mar 1,041,360 928,117 ‐10.87%
Apr 1,429,365 1,262,485 ‐11.68%
May 1,793,244 1,601,422 ‐10.70%
Jun 2,188,393 1,972,450 ‐9.87%
Jul 2,809,941 2,585,291 ‐7.99%
Aug 3,479,188
Sep 3,980,445
Oct 4,344,574
Nov 4,701,254
Dec 5,111,272
Percent of budget expended 50.58%
$‐
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
$700,000
$800,000
$900,000
Parks Planning and Natural Resources
Budget
Actual
Last Year
$0.00
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
$5.50
Millions Recreation
Budget
Actual
Last Year
Page 30 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Human
Services Budget
YTD
Actual
Annual %
over (under)
Jan 54,337 47,594 ‐12.41%
Feb 134,179 143,610 7.03%
Mar 251,034 249,760 ‐0.51%
Apr 389,020 385,688 ‐0.86%
May 471,784 453,886 ‐3.79%
Jun 540,831 503,169 ‐6.96%
Jul 679,987 632,253 ‐7.02%
Aug 748,949
Sep 802,062
Oct 950,120
Nov 1,027,713
Dec 1,221,989
Percent of budget expended 51.74%
Neighborhoods
, Resources,
and Events Budget
YTD
Actual
Annual %
over (under)
Jan 68,622 57,193 ‐16.66%
Feb 131,885 146,776 11.29%
Mar 210,347 200,847 ‐4.52%
Apr 280,168 257,492 ‐8.09%
May 348,656 307,785 ‐11.72%
Jun 436,118 371,803 ‐14.75%
Jul 544,155 472,085 ‐13.24%
Aug 631,090
Sep 711,521
Oct 785,130
Nov 890,176
Dec 979,716
Percent of budget expended 48.19%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
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 31 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Museum Fund Budget
YTD
Actual
Annual %
over (under)
Jan 18,447 16,819 ‐8.82%
Feb 37,132 33,387 ‐10.09%
Mar 55,837 49,955 ‐10.53%
Apr 75,357 66,789 ‐11.37%
May 94,204 84,860 ‐9.92%
Jun 113,251 103,291 ‐8.79%
Jul 131,932 121,764 ‐7.71%
Aug 150,895
Sep 169,970
Oct 189,000
Nov 208,138
Dec 226,683
Percent of budget expended 53.72%
Public Works
Admin Budget
YTD
Actual
Annual %
over (under)
Jan 40,644 31,793 ‐21.78%
Feb 81,126 63,574 ‐21.64%
Mar 121,691 95,355 ‐21.64%
Apr 164,065 127,778 ‐22.12%
May 203,500 160,270 ‐21.24%
Jun 241,286 193,002 ‐20.01%
Jul 277,486 225,599 ‐18.70%
Aug 314,166
Sep 350,422
Oct 385,541
Nov 420,605
Dec 456,340
Percent of budget expended 49.44%
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
$400,000
$450,000
$500,000
Public Works Admin
Budget
Actual
Last Year
$‐
$30,000
$60,000
$90,000
$120,000
$150,000
$180,000
$210,000
$240,000
Museum Fund
Budget
Actual
Last Year
Page 32 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Street
Maintenance Budget
YTD
Actual
Annual %
over (under)
Jan 348,761 311,026 ‐10.82%
Feb 744,828 658,352 ‐11.61%
Mar 1,110,350 980,862 ‐11.66%
Apr 1,489,239 1,423,475 ‐4.42%
May 1,853,405 1,791,574 ‐3.34%
Jun 2,241,891 2,157,217 ‐3.78%
Jul 2,607,657 2,532,280 ‐2.89%
Aug 2,962,105
Sep 3,328,647
Oct 3,699,390
Nov 4,070,992
Dec 4,488,268
Percent of budget expended 56.42%
Transportation Budget
YTD
Actual
Annual %
over (under)
Jan 299,741 278,181 ‐7.19%
Feb 664,652 632,259 ‐4.87%
Mar 1,036,278 921,240 ‐11.10%
Apr 1,468,622 1,450,448 ‐1.24%
May 1,810,444 1,771,639 ‐2.14%
Jun 2,129,219 2,100,480 ‐1.35%
Jul 2,522,140 2,426,304 ‐3.80%
Aug 2,918,281
Sep 3,263,752
Oct 3,635,898
Nov 3,985,013
Dec 4,539,752
Percent of budget expended 53.45%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
Millions Street Maintenance
Budget
Actual
Last Year
$0.0
$0.5
$1.0
$1.5
$2.0
$2.5
$3.0
$3.5
$4.0
$4.5
$5.0
Millions Transportation
Budget
Actual
Last Year
Page 33 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2014 Budget Year
Debt Service Budget
YTD
Actual
Annual %
over (under)
Jan 51,520 51,520 0.00%
Feb 302,837 302,837 0.00%
Mar 303,355 303,355 0.00%
Apr 916,538 916,538 0.00%
May 917,058 917,058 0.00%
Jun 1,807,407 1,807,407 0.00%
Jul 2,068,927 2,068,927 0.00%
Aug 5,560,575
Sep 6,255,647
Oct 6,950,719
Nov 7,645,791
Dec 8,340,863
Percent of budget expended 24.80%
Non‐
Departmental
Other City Budget
YTD
Actual
Annual %
over (under)
Jan 298,065 298,065 0.00%
Feb 467,210 467,210 0.00%
Mar 633,063 633,063 0.00%
Apr 1,028,664 1,028,664 0.00%
May 6,350,814 6,350,814 0.00%
Jun 6,618,473 6,618,473 0.00%
Jul 6,782,586 6,782,586 0.00%
Aug 5,254,563
Sep 5,911,383
Oct 6,568,203
Nov 7,225,024
Dec 7,881,844
Percent of budget expended 86.05%
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
$7.00
$8.00
Millions Non‐Departmental Other City Services
Budget
Actual
Last Year
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
Millions Debt Service
Budget
Actual
Last Year
Page 34 of 36
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2014 Budget Year
Utilities Budget Revenue Expense
Jan 4,282,421 6,606,636 3,795,307
Feb 9,839,723 11,939,236 8,329,760
Mar 17,394,389 17,397,529 13,080,021
Apr 23,769,707 23,768,876 17,635,562
May 30,978,426 29,697,956 22,628,698
Jun 39,309,642 35,247,583 28,309,030
Jul 47,343,798 41,725,569 34,204,756
Aug 54,078,194
Sep 61,661,742
Oct 67,509,352
Nov 73,767,095
Dec 84,995,384
Percent of budget expended 40.73%
Note: Operations and Capital
Airport Budget Revenue Expense
Jan 211,065 292,698 108,595
Feb 433,615 639,757 472,632
Mar 878,150 1,015,941 1,226,930
Apr 1,081,496 1,499,014 1,410,992
May 2,139,080 1,720,026 1,746,960
Jun 3,390,971 2,031,905 1,929,278
Jul 5,546,997 2,302,052 2,441,832
Aug 11,430,266
Sep 12,053,858
Oct 17,677,109
Nov 17,970,642
Dec 18,828,270
Percent of budget expended 12.97%
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
$20.00
Millions Airport
Budget
Revenue
Expense
Page 35 of 36
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2014 Budget Year
Golf Course Budget Revenue Expense
Jan 148,339 83,199 128,950
Feb 311,204 157,539 295,744
Mar 506,698 276,011 463,052
Apr 746,715 478,430 653,009
May 929,343 731,751 898,163
Jun 1,151,882 1,039,218 1,072,304
Jul 1,346,835 1,356,019 1,258,392
Aug 1,533,049
Sep 1,729,746
Oct 1,916,501
Nov 2,077,100
Dec 2,715,919
Percent of budget expended 46.33%
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 36 of 36