HomeMy WebLinkAbout201406, June.pdf ADMINISTRATIVE SERVICES
DEPARTMENT
M E M O R A N D U M
DATE: July 22, 2014
TO: Don Persson, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: June 2014 Financial Status Report
At the end of June, general governmental revenues show $2.1 million or 3.8% over budget.
Revenues sources that are higher than expected are: sales tax ($163k); sales tax annexation
credit ($119k); utility taxes ($354k); state shared revenue ($225k); real estate excise tax
($832k); building permits & development service fees ($805k), interest/other earnings ($100k)
and other miscellaneous ($161k). On the down side, the revenue sources that are
underperforming the year to date budget are: property tax ($293k below), seizure funds ($120k
below, restricted to drug enforcement only and is not available for general operating purposes)
and fines/penalties ($452k below).
General government expenditures showed a favorable variance of $1.3 million or 2.4%. 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,301,729 32,485,690 16,854,032 35,240,495 18,250,621 17,957,441 (293,179) ‐1.6%
Sales Tax 18,564,670 9,007,790 20,416,372 9,914,656 20,196,000 10,073,782 10,236,767 162,985 1.6%
Sales Tax ‐ Annexation Credit 2,208,492 1,075,526 2,418,789 1,173,493 2,236,262 1,086,900 1,206,177 119,276 11.0%
Criminal Justice Sales Tax 1,924,470 910,648 2,091,174 1,000,904 2,000,000 952,053 1,081,737 129,684 13.6%
Natural Gas Use Tax 272,530 204,786 263,660 151,197 300,000 199,173 187,378 (11,795) ‐5.9%
Admission Tax 311,054 154,705 327,258 152,751 308,000 148,355 154,551 6,197 4.2%
Franchise Fees 1,262,188 599,927 1,312,727 627,348 1,260,000 600,550 646,666 46,115 7.7%
Electricity Tax 5,211,111 2,760,541 5,155,789 2,705,889 5,409,000 2,852,146 2,834,180 (17,966) ‐0.6%
Natural Gas Utility Tax 1,669,967 1,130,252 1,550,900 1,015,621 1,500,520 999,707 1,170,336 170,628 17.1%
Garbage/Solid Waste 330,607 147,380 397,596 195,483 300,000 141,251 273,920 132,669 93.9%
TV Cable 1,423,664 678,526 1,481,779 712,128 1,529,365 732,012 738,225 6,213 0.8%
Telephone 1,056,420 472,440 917,021 410,588 952,500 426,202 470,647 44,445 10.4%
Cellular Phone 2,183,853 1,076,921 2,050,312 912,334 2,077,000 975,797 908,528 (67,269) ‐6.9%
City Utilities 3,806,281 1,836,322 3,964,989 1,904,012 3,791,465 1,824,843 1,921,766 96,924 5.3%
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 803,034 1,319,585 635,917 1,600,000 764,689 796,580 31,891 4.2%
Real Estate Excise Tax 2,811,902 1,290,845 4,131,665 1,455,902 2,900,000 1,802,698 2,634,433 831,734 46.1%
Less: CIP REET (943,792) (254,982) (700,000) (279,995) (550,000) (499,628) (499,628) ‐ 0.0%
EMS Levy 885,781 221,445 916,361 229,090 900,000 450,784 450,784 (0) 0.0%
Business License Fees 444,680 212,880 503,766 290,183 533,067 282,743 253,136 (29,606) ‐10.5%
Animal Licenses and Spec Events Permits 91,835 54,163 99,411 55,012 90,000 51,104 55,724 4,620 9.0%
Building Permits & Development Svc Fees 3,552,369 1,515,579 4,001,625 1,909,994 3,705,701 1,668,571 2,473,680 805,109 48.3%
Intergovt'l (Grants, State Shared, etc) 4,593,185 2,012,340 3,863,974 1,925,151 4,188,188 2,207,220 2,302,258 95,038 4.3%
Fire District 25 and 40 Contracts 6,155,621 3,001,928 5,726,895 2,794,338 5,877,463 2,977,343 2,977,343 ‐ 0.0%
Public Safety 485,899 228,321 680,581 335,396 774,535 374,305 387,793 13,489 3.6%
Culture and Recreation 1,494,165 651,581 1,494,580 607,732 1,525,863 642,925 663,238 20,313 3.2%
Interfund/Interdept‐Services 3,311,715 1,563,336 3,464,913 1,752,065 3,332,794 1,666,397 1,688,441 22,044 1.3%
Fines and Penalties 1,046,246 455,531 1,137,140 519,031 1,108,500 496,439 532,553 36,114 7.3%
Photo Enforcement 1,976,203 1,091,249 1,629,524 1,022,773 1,950,000 1,143,277 655,596 (487,681) ‐42.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 49,775 423,609 52,161 745,300 99,177 198,922 99,745 100.6%
Rents, Leases, and Concessions 822,428 449,066 734,530 440,405 756,464 432,158 446,145 13,986 3.2%
Contributions and Donations 124,082 70,614 84,320 43,186 96,100 52,476 55,876 3,399 6.5%
Other Miscellaneous 564,571 264,438 684,187 358,563 516,630 267,738 428,331 160,594 60.0%
Other Financing Sources (Transfer‐In, etc) 5,118,188 144,143 299,527 13,343 ‐ ‐ 8,617 8,617 100.0%
Total Operating Revenues 108,457,170 51,288,412 105,545,527 52,007,692 107,476,905 54,339,972 56,390,743 2,050,771 3.8%
OPERATING EXPENDITURES
Council 278,768 138,621 289,911 145,113 309,907 154,624 159,997 (5,373) ‐3.5%
Executive 1,377,109 660,020 1,240,910 614,036 1,359,996 661,840 629,321 32,519 4.9%
City Attorney 1,706,320 844,781 1,922,225 872,824 1,863,395 882,055 878,900 3,156 0.4%
Court Services 2,074,980 1,045,629 2,003,104 978,124 2,094,010 1,039,155 997,832 41,322 4.0%
Community and Eco Dvlpmnt Admin 942,071 476,538 1,047,860 514,481 1,012,142 504,064 502,746 1,318 0.3%
Development Services 3,090,735 1,459,242 3,243,702 1,589,997 3,040,435 1,463,648 1,382,845 80,803 5.5%
Economic Development 529,043 271,554 467,511 211,913 644,063 312,460 286,843 25,617 8.2%
Planning 1,495,066 744,372 1,510,707 728,944 2,261,206 1,108,350 922,069 186,281 16.8%
Finance 2,221,882 995,643 2,274,147 942,750 2,334,758 1,006,594 1,129,517 (122,923) ‐12.2%
City Clerk1 997,434 373,122 1,020,822 636,188 1,125,927 563,065 583,164 (20,099) ‐3.6%
Human Resources 937,412 459,361 904,182 439,470 1,002,994 489,534 439,333 50,200 10.3%
Police 25,004,580 12,465,453 24,946,784 12,358,254 25,925,197 12,883,723 12,952,983 (69,260) ‐0.5%
Jail Services 3,489,616 1,744,484 3,814,042 1,907,023 4,500,000 1,880,926 1,880,926 ‐ 0.0%
Fire 24,173,315 12,628,919 24,444,372 12,459,420 25,219,873 13,014,291 12,576,090 438,201 3.4%
Community Services Admin 434,558 215,856 452,146 225,313 493,982 245,774 233,851 11,923 4.9%
Parks 4,004,054 1,823,313 4,024,756 1,862,252 4,311,514 1,979,168 1,838,337 140,831 7.1%
Parks Planning & Natural Resources 577,934 275,550 829,250 310,633 880,373 366,732 323,404 43,328 11.8%
Recreation 4,982,229 2,133,041 4,846,970 2,075,334 5,111,272 2,188,393 1,972,450 215,944 9.9%
Human Services 1,193,871 546,207 1,162,330 496,606 1,221,989 540,831 503,169 37,662 7.0%
Neighborhoods, Resources, & Events 701,673 293,480 770,841 362,006 979,716 436,118 371,803 64,315 14.7%
Library 278,604 263,606 ‐ ‐ ‐ ‐ ‐ ‐ 0.0%
Museum 216,887 108,238 209,387 104,728 226,683 113,251 103,291 9,960 8.8%
Public Works Admin 470,051 236,629 426,312 237,314 456,340 241,286 193,002 48,284 20.0%
Street Maintenance 3,755,640 1,857,066 3,814,132 1,924,036 4,488,268 2,241,891 2,157,217 84,674 3.8%
Transportation 4,615,160 2,150,841 4,476,854 2,113,464 4,539,752 2,129,219 2,100,480 28,739 1.3%
Debt Service 9,752,337 1,905,620 8,048,508 1,776,589 8,340,863 1,807,407 1,807,407 ‐ 0.0%
Non‐Departmental and Other 4,637,555 1,597,673 5,475,340 2,587,016 7,881,844 6,618,473 6,618,473 ‐ 0.0%
Total Operating Expenditures 103,938,882 47,714,859 103,667,105 48,473,829 111,626,501 54,872,871 53,545,448 1,327,422 2.4%
Total Ending Fund Balance 15,575,840$ 14,631,104$ 17,454,262$ 19,109,703$ 13,304,665$ 16,921,362$ 20,299,555$ 3,378,193$ 20.0%
1 Hearing Examiner is reported under City Clerk
Favorable (Unfavorable)
2012 2013 2014 Variance
Annual Actual YTD Actual Annual Budget YTD Budget YTD ActualSummary of Sources and Uses Annual Actual YTD Actual
Monthly Financial Report June 2014
Page 1 of 37
Monthly Financial Report June 2014
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through June 30, 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 75% of all
resources supporting general governmental activities. The following section provides detail information on property, sales,
utility, and other taxes.
Property Tax
June’s collection is ‐$245k, making
the total year‐to‐date collection
$18 million or 51% of the total
budget. The negative amount for
June is due to receivables not yet
received by King County. These
receivables will be recorded in
July 2014’s collection. The City is
projecting property tax to meet
the budget at year‐end.
Sales Tax
June 2014 sales tax receipts
totalled $1.7 million. Compared
with the same month last year, it
is $117k or 8% more. Compared
to the projected current month’s
budget, it is $86k or 5% above.
The year‐to‐date collection of
$10.2 million is $322k or 3% more
than the prior year and is also
$163k or 2% more than budgeted.
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 ‐
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 9,914,656$ 10,073,782$ 10,236,767$ 322,111$ 3% 162,985$ 2%
Annual Total 20,416,372$ 20,196,000$
2014 vs. Budget2014 vs. 2013
Month
Year to Date through June
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
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,854,032$ 18,250,621$ 17,957,441$ 1,103,410$ 7% (293,179)$ ‐2%
Annual Total 32,485,690$ 35,240,495$
Property Tax Revenues
Year to Date through June
2014 vs. 2013 2014 vs. Budget
Month
Page 2 of 37
Monthly Financial Report June 2014
The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business
sectors:
Utility tax
June utility tax revenues are $1.4
million, which is $187k or 16%
higher than the same month last
year and is also ahead of the
budget by $225k or 20%. The
year‐to‐date collection is $8.5
million, which is $498k or 6%
higher than the prior year and is
also $354k or 4% higher than the
budget. 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 June, we are only recording 5 months of revenue,
compared to 6 months in prior years. The variance for Electricity/Natural Gas is due to the results of a utility tax audit.
Utility Tax by Type 2013 2014 Bgt YTD Act Change 2014/2013 2014 Act vs Bgt
Electrical 2,705,889$ 2,852,146$ 2,834,180$ 128,292$ 5%$ (17,966)‐1%
Natural Gas 1,166,818 1,198,881 1,357,714 190,896 16% 158,833 13%
Cell 912,334 975,797 908,528 (3,806) 0% (67,269)‐7%
Phone 410,588 426,202 470,647 60,059 15% 44,445 10%
Cable 712,128 732,012 738,225 26,097 4% 6,213 1%
Garbage/Solid Waste 195,483 141,251 273,920 78,437 40% 132,669 94%
City Utilities 1,904,012 1,824,843 1,921,766 17,755 1% 96,924 5%
YTD Total 8,007,252$ 8,151,130$ 8,504,980$ 497,729$ 6%353,850$ 4%
Annual Total 15,782,047$ 15,859,850$
YTD as % of 51% 51%
Sales Tax by Sector 2013 2014 Bgt YTD Act Change 2014/2013 2014 Act vs Bgt
New Construction 1,329,527$ 1,049,449$ 991,398$ (338,129)$ ‐25%$ (58,050)‐6%
Auto Sales 1,786,638 1,907,028 1,964,025 177,387 10% 56,997 3%
General Retail 3,255,213 3,341,243 3,252,454 (2,759) 0% (88,789)‐3%
Manufacturing 626,581 699,528 1,028,454 401,873 64% 328,926 47%
Wholesale 574,256 589,490 517,530 (56,725) ‐10% (71,960)‐12%
Service 2,079,716 2,220,723 2,191,194 111,477 5% (29,530)‐1%
Other 262,724 266,321 291,711 28,987 11% 25,390 10%
YTD Total 9,914,656$ 10,073,782$ 10,236,767$ 322,111$ 3%162,985$ 2%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
2013 2014 2014
Actual Budget Actual $ % $ %
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
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 8,007,252$ 8,151,130$ 8,504,980$ 497,729$ 6% 353,850$ 4%
Annual Total 15,782,047$ 15,859,850$
2014 vs. Budget2014 vs. 2013
Year to Date through June
Utility Tax Revenues
Month
Page 3 of 37
Monthly Financial Report June 2014
Other Taxes
Real Estate Excise Tax
The City collected $624k in Real
Estate Excise Tax revenues (REET)
for June. This is $276k or 79%
more than the same month last
year and is also $155k or 33%
more than the current month’s
budget. The year‐to‐date
collection is $2.6 million, which is
$1.2 million or 81% more than the
prior year and is also $832k or
46% above the budget. The
higher than expected variance is
due to 7 large transactions in
February, March, April and June
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
June’s Gambling Tax collections
totalled $136k, which is $76k or
126% above the same month last
year and is also $36k or 36%
above the current month’s
budget. The year‐to‐date total of
$797k is $161k or 25% above the
year and is also $32k or 4% above
budget. The monthly variances
are due to 2 establishments filing
for bankruptcy.
Pull tabs overall had a 14%
increase, bingo increased by 3%,
and card‐rooms are seeing 13%
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 $647k is
$20k or 3% higher than the prior
year and is also $47k or 8% 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 185,608
Aug 294,056 231,826
Sep 254,318 180,718
Oct 272,776 276,586
Nov 342,535 149,542
Dec 1,248,272 73,021
YTD Total 1,455,902$ 1,802,698$ 2,634,433$ 1,178,531$ 81% 831,734$ 46%
Annual Total 4,131,665$ 2,900,000$
Month
2014 vs. Budget2014 vs. 2013
Real Estate Excise Tax Revenues
Year to Date through June
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 ‐
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 635,917$ 764,689$ 796,580$ 160,663$ 25% 31,891$ 4%
Annual Total 1,319,585$ 1,600,000$
2014 vs. 2013 2014 vs. Budget
Gambling Tax Revenue
Month
Year to Date through June
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%
Apr 311,986 299,239 323,544 11,558 4% 24,305 8%
Jul 315,694 303,760 ‐
Oct 321,202 308,381 ‐
Dec 48,484 47,308 ‐
YTD Total 627,348$ 600,550$ 646,666$ 20,210$ 3% 46,552$ 8%
Annual Total 1,312,727$ 1,260,000$
Franchise Fees Revenue
Year to Date through June
Month
2014 vs. 2013 2014 vs. Budget
Page 4 of 37
Monthly Financial Report June 2014
Admission Tax
Admission Tax returns are due
quarterly in January, April, July,
and October of each year. April
2014 collections represent
activities conducted during the 1st
quarter of 2014. The year‐to‐date
collection of $155k is $1.8k or 1%
more than the prior year and is
also $7k or 4% more than the
budget.
Licenses and Permits
Building Permits and Development
Service Fees
Building Permits and Development
Service Fee revenues totalled
$517k in June. The year‐to‐date
development fees revenue of $2.5
million is $564k or 30% more than
the year before and is also $805k
or 48% 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 $7k for
June, which is $1.7k or 31% above
the same month last year and is
also $2.3k or 46% above the
current month’s budget. The
year‐to‐date Business Licenses
revenue of $253k is $37k or 13%
below the prior year and is also
$30k or 10% 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 ‐
Aug 76 37 ‐
Oct 85,616 77,019 ‐
Nov 1,192 575 ‐
Dec 149 672 ‐
YTD Total 152,751$ 148,355$ 154,551$ 1,800$ 1% 6,647$ 4%
Annual Total 327,258$ 308,000$
2014 vs. Budget
Ad mission Tax Revenue
Year to Date through June
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
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 1,909,994$ 1,668,571$ 2,473,680$ 563,685$ 30% 805,109$ 48%
Annual Total 4,001,625$ 3,705,701$
Building Permits and Development Service Fees
Year to Date through June
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 ‐
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 290,183$ 282,743$ 253,136$ (37,047)$ ‐13% (29,606)$ ‐10%
Annual Total 503,766$ 533,067$
Business Licenses
Month
2014 vs. 2013
Year to Date through June
2014 vs. Budget
Page 5 of 37
Monthly Financial Report June 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 85% of
the total revenues in this
category. The year‐to‐date total Intergovernmental revenue is $6.4 million or 53% of the budget. The change in federal grants is
due to the collection for CDBG grants in 2014.
State Shared Revenues
State Shared Revenue
collections totalled $2.4
million since the start of
the year. Compared to the
prior year, State Shared
Revenues are above by
$218k or 10%. Compared
to the projected budget,
the City is collecting $225k
or 10% 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 63%
of the total revenue in this category. The year‐to‐date total charges for services are $3.7 million or 52% of the budget. The
following sections provide detail information for Public Safety, Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totalled
$388k 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 $52k or 16% more.
Compared to the year‐to‐date
budget, the City is $13k or 4%
more. The large April variance is
due to a private security police
provided for a large one‐time
private business event in 2013.
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 ‐
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 335,396$ 374,305$ 387,793$ 52,397$ 16% 13,489$ 4%
Annual Total 680,581$ 774,535$
Month
2014 vs. 2013
Year to Date through June
Public Safety Services
2014 vs. Budget
Intergovernmental 2013 2014 Bgt YTD Act Change 2014/2013 2014 Act vs Bgt
Fire District #25 565,310$ 620,568$ 620,568$ 55,257$ 10% $ ‐ 0%
Fire District #40 2,229,028 2,356,775 2,356,775 127,748 6%‐ 0%
State Shared Revenue 2,222,390 2,215,657 2,440,379 217,989 10% 224,722 10%
Federal Grants 515,719 790,526 790,526 274,807 53%‐ 0%
State Grants 51,897 22,404 22,404 (29,493) ‐57%‐ 0%
Other Grants/Intgovt 21,259 130,686 130,686 109,427 515%‐ 0%
ARRA Grants 114,792 0 ‐ (114,792) 0%‐ 0%
Total Rev YTD 5,720,394$ 6,136,616$ 6,361,338$ 640,944$ 11%224,722$ 4%
Total Rev Annual 11,682,043$ 12,065,651$
YTD % 49% 51% 53%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
2013 2014 2014
Actual Budget Actual $ % $ %
Crim Just Sales Tax 1,000,904$ 952,053$ 1,081,737$ 80,832$ 8% 129,684$ 14%
Judicial Contribution 11,398 11,250 11,342 (56) 0%92 1%
Crim Just ‐ High Crime 102,994 ‐ 128,835 25,841 25% 128,835 100%
Crim Just ‐ Pop 10,797 ‐ 11,925 1,128 10% 11,925 100%
Crim Just ‐ Spec Prog 40,452 43,527 44,611 4,159 10% 1,084 2%
State DUI 8,515 9,080 8,694 180 2% (386) ‐4%
Liquor Profits 423,384 345,484 424,823 1,440 0% 79,339 23%
Liquor Excise Tax ‐ 248,924 92,598 92,598 100% (156,326) ‐63%
Fuel Tax 623,946 605,339 635,812 11,867 2% 30,474 5%
YTD Total 2,222,390$ 2,215,657$ 2,440,379$ 217,989$ 10% 224,722$ 10%
Annual Total 4,701,889$ 4,515,500$
2014 vs. Budget
State Shared Revenues
2014 vs. 2013
Revenue
Year to Date through June
Page 6 of 37
Monthly Financial Report June 2014
The large June variance is due to staff 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
$172k for the current month.
Compared to the same month the
prior year, the City collected $22k
or 15% more. Compared to the
projected monthly budget, the
City collected $19k or 13% more.
The year‐to‐date collection of
$663k is $56k or 9% higher than
the year before and is also $20k
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.7 million. Compared to the
prior year, the revenues are under
by $64k or 4%. Compared to the
projected budget, the revenues
are above by $22k 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 ‐
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 607,732$ 642,925$ 663,238$ 55,506$ 9% 20,313$ 3%
Annual Total 1,494,580$ 1,525,863$
Recreation
Year to Date through June
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 ‐
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 1,752,065$ 1,666,397$ 1,688,441$ (63,624)$ ‐4% 22,044$ 1%
Annual Total 3,464,913$ 3,332,794$
Interfund Services
Year to Date through June
2014 vs. 2013 2014 vs. Budget
Month
Page 7 of 37
Monthly Financial Report June 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.2 million. This is $354k or 23%
lower than a year ago and is also
$452k or 28% 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
$656k. 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 included in June’s.
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
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,541,804$ 1,639,716$ 1,188,149$ (353,655)$ ‐23% (451,567)$ ‐28%
Annual Total 2,766,663$ 3,058,500$
2014 vs. Budget2014 vs. 2013
Year to Date through June
Fines and Penalties by Month
Month
Year to Date through June
2013 2014 2014
Actual Budget Actual $ % $ %
Civil Penalties 3,705$ 6,390$ 3,782$ 77$ 2% (2,608)$ ‐41%
Civil Infraction Penalties 289,144 271,084 293,804 4,660 2% 22,719 8%
Civil Parking Infraction Penalties 76,160 75,590 92,700 16,541 22% 17,110 23%
Photo Enforcement Program 1,022,773 1,143,277 655,596 (367,177) ‐36% (487,681) ‐43%
Criminal Traffic Misdemeanor Fines 49,732 49,600 44,689 (5,042) ‐10% (4,910) ‐10%
Criminal Non‐Traffic Fines 19,159 20,923 22,291 3,132 16% 1,368 7%
Criminal Costs 60,465 55,796 65,599 5,134 8% 9,803 18%
Non‐Court Fines, Forfeitures and Penalties 20,667 17,055 9,687 (10,980) ‐53% (7,368) ‐43%
YTD Total 1,541,804$ 1,639,716$ 1,188,149$ (353,655)$ ‐23% (451,567)$ ‐28%
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 ‐ 71,451 ‐ ‐
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,143,277$ 655,596$ 436,832$ 401,130$ 254,466$
Annual Total 1,950,000$ 841,964$
1Actuals of Revenues and Expenses
ExpensesRevenues
Photo Enforcement Program
Year to Date through June
Month
Page 8 of 37
Monthly Financial Report June 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 71% of
the total revenue in this category.
The year‐to‐date total
miscellaneous is $905k.
Compared to last year, the
revenues are above by $166k or
22%. Compared to the projected
year‐to‐date budget, the revenues
are over by $99k or 12%. 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 results of a utility tax audit.
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 48% of its budgeted general governmental expenditures at the end of June. This is $1.3 million or
2.4% 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 3.5%. 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.
Administrative Services department is over the year‐to‐date by $143k or 9.1%. This is mainly due to the timing of payments
related to Springbrook merchant account fees, fees paid for utility tax audit and elections/voter registration costs compared to
the prior years. We will monitor this item to determine if a budget adjustment is needed.
Police department is over the year‐to‐date budget by $69k or 0.5%. This is due to over spending on salaries/benefits/overtime
($33k), supplies ($22k), intergovernmental services ($33k), interfund services ($38k) and under spending on professional services
($90k).
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
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 739,082$ 805,952$ 905,100$ 166,018$ 22% 99,147$ 12%
Annual Total 1,628,017$ 1,969,557$
Year to Date through June
Month
2014 vs. Budget2014 vs. 2013
Miscellaneous Revenues by Month
2013 2014 2014
Actual Budget Actual $ % $ %
Interests and Other Earnings 52,161$ 99,177$ 198,922$ 146,762$ 281% 99,745$ 101%
Rents, Leases, and Concessions 440,405 432,158 446,145 5,740 1% 13,986 3%
Contributions/Donations from Private Sources 43,186 52,476 55,876 12,690 29% 3,399 6%
Other 168,763 98,797 200,810 32,047 19% 102,013 103%
Seizure Funds ‐ Federal/State/Local1 34,567 123,343 3,346 (31,220) ‐90% (119,997) ‐97%
YTD Total 739,082$ 805,952$ 905,100$ 166,018$ 22% 99,147$ 12%
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 June
Revenue
2014 vs. 2013
Page 9 of 37
Monthly Financial Report June 2014
CASH AND INVESTMENTS – 2ND
QUARTER
The current cash and
investments (C&I) portfolio
is provided in the table to
the right. The City’s current
C&I balance is $123.5
million, of this amount;
$775k 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 .57%. The majority (.40%) is within the cash at US Bank.
Cash, $81,643,990 ,
66%
Local Government
Investment Pool,
$9,932,872 , 8%
US Federal Agency
Securities,
$16,846,270 , 14%
Certificates of
Deposit,
$14,299,206 , 11%
INTERFUND
INVESTMENT,
$775,092 , 1%
Distribution by Instrument
(shown as percent of blended Portfolio*)
Deposit Total Maturity Date APY Weighted Yield Current Allocation of
Cash and Investments
Allowed
by Policy
Current Principal
Balance
Cash US Bank ‐ Cash 81,643,990 overnight 0.45% 0.40%66%N/A 81,643,990
GOLF '14 GOLF '14 383,239 12/1/2014 2.25% 0.03%
GOLF '15 GOLF '15 391,853 12/1/2015 2.25% 0.03%
US Treasury Securities
none ‐ N/A N/A 0.00% 0% 100%‐
Local Government Investment Pool
3920 State Investment Pool 9,932,872 4/1/2014 0.09% 0.01% 8% 75% 9,932,872
US Federal Agency Securities *
314179A FHLB 1,996,920 8/11/2017 1.00% 0.07%
313169B FHLMC 2,500,000 10/24/2016 0.90% 0.07%
313169C FNMA 2,500,000 10/24/2016 1.06% 0.08%
314179C FNMA 4,849,350 8/11/2017 1.06% 0.15%
314179B FHLMC 5,000,000 11/28/2017 1.13% 0.18%
Certificates of Deposit
113154A First Savings Bank Northwest 5,000,000 2/4/2015 0.92% 0.14%
113164A First Savings Bank Northwest 5,000,000 2/4/2016 1.02% 0.16%
111167a Columbia Bank 2,015,400 11/9/2016 0.99% 0.06%
212145b Homestreet Bank (CDARS) 1,000,685 12/18/2014 0.65% 0.02%
112145a Homestreet (traditional) 252,980 12/23/2014 0.85% 0.01%0% 20%
Commencement Bank (CDARS) 1,030,141 9/20/2014 0.65% 0.02%1%
Commercial Paper
none ‐ N/A N/A 0.00% 0.00% 5%‐
TOTAL CASH & INVESTMENTS 123,497,430$ 123,497,430$
By Institution
*Held in our safekeeping account at BNY Trust and Custody
Golf Interfund Loan
20%8%
20%2%
10,000,000
2,015,400
20% 1,030,141
20%1%1,253,664
1% N/A 775,092
14% 75% 16,846,270
Page 10 of 37
Monthly Financial Report June 2014
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 ‐ ‐ ‐ ‐ 38,085 30,525 ‐
Grants / intergovernmental 771,603 ‐ 117,144 ‐ ‐ 915,597 ‐
Charges for services 69,793 872,721 8,598,777 7,373,419 4,739,026 4,908,069 7,559,604
Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐
Fines and penalties 4,045 ‐ ‐ ‐ 143 ‐ ‐
Rents, leases, and misc fees 1,183,648 140,734 38,478 72,139 ‐ ‐ ‐
Interest and other misc 2,817 765 3,634 120,409 419,049 309,526 3,981
TOTAL REVENUES 2,031,906 1,014,220 8,758,033 7,565,967 5,196,303 6,163,717 7,563,585
EXPENSES:
Utility billing ‐ ‐ 61,679 56,275 44,618 72,176 ‐
Utility systems ‐ ‐ 7,220,021 2,683,650 1,463,504 1,641,102 ‐
Utility maintenance ‐ ‐ 137,792 2,304,917 637,001 1,103,942 7,280,667
Transportation 1,459,596 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 992,869 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 1,459,596 992,869 7,419,492 5,044,842 2,145,123 2,817,220 7,280,667
AMOUNT AVAILABLE FOR DEBT SERVICE 572,310 21,351 1,338,541 2,521,125 3,051,180 3,346,497 282,918
DEBT SERVICE:
Principal ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest ‐ 1,625 ‐ 309,294 156,301 141,172 ‐
TOTAL DEBT SERVICE ‐ 1,625 ‐ 309,294 156,301 141,172 ‐
CAPITAL PROJECTS 469,682 52,812 ‐ 815,295 1,221,842 957,781 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 102,628 (33,086) 1,338,541 1,396,536 1,673,037 2,247,544 282,918
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, Jun 30 1,772,192 286,075 2,683,424 13,747,488 7,201,403 9,757,829 2,886,480
Page 11 of 37
Monthly Financial Report June 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 ‐ 82,507 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ ‐ ‐ ‐ ‐ ‐ 44,426
Charges for services
Equipment rental m&o 1,391,574 1,508,485 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 56,207 ‐ 201,860 ‐ ‐ ‐
Communications ‐ 3,090 ‐ 262,812 ‐ ‐ ‐
Facilities ‐ ‐ 2,127,801 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 70,209 ‐ ‐ ‐ ‐ ‐
IT service co ntracts ‐ 219,392 ‐ ‐ ‐ ‐ ‐
Interest and other misc 6,074 3,312 1,954 554 20,705 9,350 10,700
Internal service fund misc:
Vehicle / equipment capital recovery 760,765 67,495 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 815,708 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 795,879 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 5,700,532 853,750
Other misc ‐ 3,797 1,302 164 ‐ 163,038 ‐
Interfund Loan ‐ ‐ ‐ ‐ 139,931 ‐ ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets 21,043 ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 55,145 ‐ ‐
TOTAL REVENUES 2,179,456 2,014,494 2,131,058 465,390 1,827,368 5,872,920 908,876
EXPENSES:
Communications 254,235
Equipment rental 1,193,108
Facilities 1,795,508
Healthcare 6,463,129
Information technology 1,663,292
Print and mail 160,032
Retiree healthcare 552,557
Risk ma nagement
Risk management 1,138,930
Unemployment 55,733
Worker's compensation 781,124
TOTAL EXPENSES 1,193,108 1,663,292 1,795,508 414,267 1,975,787 6,463,129 552,557
AMOUNT AVAILABLE FOR CAPITAL 986,348 351,202 335,550 51,123 (148,419) (590,209) 356,319
CAPITAL PROJECTS 562,740 206,722 51,761 ‐ ‐ ‐ ‐
TRANSFERS IN ‐ ‐ ‐ ‐ 3,600,000 ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 423,608 144,480 283,789 51,123 3,451,581 (590,209) 356,319
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, Jun 30 4,358,696 2,361,092 1,451,503 398,894 11,081,658 6,344,095 7,564,022
Page 12 of 37
Monthly Financial Report June 2014
FUND BALANCE
Page 14 shows the ending fund balance as of June 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 June, the City has $20.3 million reported in the combined general governmental fund balance of the current year’s
operating budget, which is approximately 18% of budgeted operating expenditures. This is an increase of $2.8 million from the
year’s beginning balance. June’s ending fund balance is over the anticipated General Governmental Fund Balance of $16.9
million by $3.4 million or 20%. Although the ending fund balance is above projections, it is consistent with the prior years’
trends.
CONTACT INFORMATION
This report is prepared by the Finance Division of the Administrative Services Department. For additional financial information,
please also review our website: http://www.rentonwa.gov/. For any questions about the report, please feel free to contact us at
hnguyen@rentonwa.gov or JDThomas@Rentonwa.gov.
Page 13 of 37
Monthly Financial Report June 2014
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through June 30, 2014
Funds
Balance
01/01/2014
Budgeted
Revenue
Revenue
06/30/14
Total Funds
Available
Budgeted
Expenditure
Expenditure
06/30/14
Ending
Balance
GENERAL GOVERNMENT FUNDS:17,454,261 107,476,905 56,390,743 73,845,004 111,626,502 53,545,448 20,299,556
000 General 12,515,053 77,540,984 40,096,895 52,611,948 81,920,905 42,511,474 10,100,475
001 Community Services 2,124,598 11,706,752 5,920,375 8,044,973 11,693,059 4,705,659 3,339,314
003 Street 1,667,393 9,028,020 4,762,017 6,429,410 9,028,020 4,257,697 2,171,713
004 Community Dev Block Grant (229,834) 548,203 304,785 74,951 308,172 121,583 (46,631)
005 Museum 52,979 226,683 113,395 166,374 226,683 103,291 63,083
009 Farmers Market 98,826 60,400 24,023 122,849 83,322 33,708 89,141
011 Fire Health & Wellness 55,094 25,000 12,534 67,628 25,000 4,153 63,475
031 Park Memorial 478 ‐ ‐ 478 478 478 ‐
201 Ltd GO Bonds Gen Govt Debt 833,717 1,749,705 876,350 1,710,067 1,749,705 119,700 1,590,367
215 Gen Govt Misc Debt Service 335,957 6,591,158 4,280,369 4,616,326 6,591,158 1,687,707 2,928,620
SPECIAL REVENUE FUNDS:
102 Arterial Street 192,689 633,000 299,662 492,351 810,000 ‐ 492,351
108 Leased City Properties 549,887 833,071 294,487 844,374 853,626 380,681 463,693
110 Hotel Motel 185,606 265,000 94,366 279,972 315,693 117,145 162,827
125 1% For Art 97,771 15,000 135 97,906 50,000 7,050 90,856
127 Cable Communication 284,632 85,674 65,050 349,682 85,674 19,930 329,752
135 Springbrook Wetlands Bank 667,613 ‐ 970 668,583 ‐ ‐ 668,583
CAPITAL PROJECT FUNDS (CIP):
303 Community Dev Mitigation 934,618 60,000 90,640 1,025,258 ‐ ‐ 1,025,258
304 Fire Mitigation 646,165 50,000 103,428 749,593 ‐ ‐ 749,593
305 Transportation Mitigation 486,185 40,000 241,603 727,788 200,000 ‐ 727,788
316 Municipal Facilities CIP 5,083,524 3,070,672 1,177,649 6,261,173 7,921,548 1,557,876 4,703,297
317 Transportation CIP 2,687,303 18,857,104 2,233,059 4,920,362 20,835,072 7,380,264 (2,459,902)
318 So Lake WA Infrastructure Proj 9,012 ‐ 13 9,025 9,012 ‐ 9,025
326 Housing Opportunity 84,599 1,000,000 1,000,310 1,084,909 75,000 ‐ 1,084,909
336 New Library Development 19,571,748 450,000 478,267 20,050,015 20,021,748 942,789 19,107,226
ENTERPRISE FUNDS:
402 Airport 191,466 1,505,636 1,258,146 1,449,612 1,496,624 783,314 666,298
403 Solid Waste Utility 1,344,883 16,419,820 8,758,033 10,102,916 16,508,948 7,419,491 2,683,425
404 Golf Course 33,445 2,487,449 1,013,817 1,047,262 2,522,025 997,939 49,323
422 Airport Capital 1,478,098 15,878,548 773,759 2,251,857 17,331,646 1,145,964 1,105,893
424 Golf Course Capital 285,716 50,000 25,401 311,117 193,894 74,366 236,751
INTERNAL SERVICE FUNDS:
501 Equipment Repair/Replacement 3,935,088 4,361,968 2,179,456 6,114,544 4,829,709 1,755,848 4,358,696
502 Insurance 7,630,077 7,344,062 5,427,368 13,057,445 3,188,983 1,975,786 11,081,659
503 Information Services 2,216,612 4,010,222 2,014,494 4,231,106 5,358,145 1,870,014 2,361,092
504 Facilities 1,167,714 4,105,749 2,131,058 3,298,772 4,505,641 1,847,269 1,451,503
505 Communications 347,771 896,374 465,390 813,161 917,403 414,267 398,894
512 Insurance, Healthcare 6,934,304 11,622,068 5,872,921 12,807,225 12,062,456 6,463,129 6,344,096
522 Insurance, Leoff1 Retirees HC 7,207,703 1,735,684 908,876 8,116,579 1,738,162 552,557 7,564,022
FIDUCIARY FUNDS:
611 Firemen's Pension 4,790,247 300,000 146,536 4,936,783 225,475 88,565 4,848,218
Funds
Balance
01/01/2014
Budgeted
Revenue
Revenue
06/30/14
Total Funds
Available
Budgeted
Expenditure
Expenditure
06/30/14
Ending
Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 27,993,165 62,804,226 26,489,572 54,482,737 68,486,436 20,889,538 33,593,199
405 Water Utility 8,523,106 13,765,149 7,480,912 16,004,018 11,453,942 4,245,633 11,758,385
406 Waste Water Utility 2,578,193 7,263,934 4,797,764 7,375,957 5,544,029 2,266,431 5,109,526
407 Surface Water Utility 4,342,360 4,867,612 4,946,359 9,288,719 6,996,129 2,608,724 6,679,995
416 King County Metro 2,603,562 15,202,336 7,563,585 10,167,147 15,202,336 7,280,667 2,886,480
425 Water Utility Construction 3,811,904 4,385,000 85,033 3,896,937 7,771,000 1,923,799 1,973,138
426 Waste Water Construction 2,950,173 4,900,000 398,539 3,348,712 7,055,000 1,256,835 2,091,877
427 Surface Water Construction 3,167,925 12,420,195 1,217,357 4,385,282 14,464,000 1,307,449 3,077,833
471 Waterworks Rate Stabilization 15,942 ‐ 23 15,965 ‐ ‐ 15,965
Note: Waterworks Utility Funds are managed as a system and are designated by the dotted lines.
Page 14 of 37
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
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 15 of 37
City of Renton
Monthly Revenue Analysis ‐ 2014 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 5,848,043 5,710,991 ‐2.34%
Feb 11,902,762 12,530,792 5.28%
Mar 17,726,513 19,541,262 10.24%
Apr 34,984,794 32,250,423 ‐7.82%
May 48,802,249 50,233,421 2.93%
Jun 54,339,972 56,390,743 3.77%
Jul 60,735,576
Aug 66,121,221
Sep 71,650,348
Oct 88,577,302
Nov 100,608,721
Dec 107,476,905
Percent of budget 52.47%
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
Aug 18,546,494
Sep 19,130,963
Oct 29,751,020
Nov 34,808,607
Dec 35,240,495
Percent of budget 50.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 16 of 37
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
Aug 14,856,274
Sep 16,674,205
Oct 18,600,929
Nov 20,542,214
Dec 22,432,262
Percent of budget 51.01%
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
Aug 10,668,223
Sep 12,034,563
Oct 13,138,008
Nov 14,360,964
Dec 15,859,850
Percent of budget 53.63%
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 ‐ 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
Aug 2,047,093
Sep 2,213,029
Oct 2,636,671
Nov 2,886,417
Dec 3,129,504
Percent of budget 64.51%
Note: Franchise Fees
Intergovt'l Budget
YTD
Actual
Annual %
over (under)
Jan 801,032 846,109 5.63%
Feb 1,641,056 1,714,034 4.45%
Mar 2,013,994 2,206,902 9.58%
Apr 3,092,667 3,273,493 5.85%
May 5,520,246 5,716,232 3.55%
Jun 6,136,615 6,361,338 3.66%
Jul 6,824,180
Aug 7,427,431
Sep 7,906,712
Oct 8,962,576
Nov 11,380,047
Dec 12,065,651
Percent of budget 52.72%
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 18 of 37
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
Aug 4,887,074
Sep 5,421,972
Oct 6,024,642
Nov 6,558,687
Dec 7,158,086
Percent of budget 52.12%
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
Aug 2,087,621
Sep 2,257,534
Oct 2,506,763
Nov 2,736,768
Dec 3,058,500
Percent of budget 38.85%
$‐
$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 ‐ 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,187,703
Aug 4,554,759
Sep 4,877,742
Oct 5,741,474
Nov 6,039,005
Dec 6,563,000
Percent of budget 65.10%
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
Aug 1,046,251
Sep 1,133,629
Oct 1,215,219
Nov 1,296,012
Dec 1,969,557
Percent of budget 45.95%
$‐
$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 20 of 37
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 ‐
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 21 of 37
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
Aug 1,413,460
Sep 1,591,955
Oct 1,783,413
Nov 2,023,852
Dec 2,900,000
Percent of budget 90.84%
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
Aug 2,328,357
Sep 2,542,968
Oct 2,975,045
Nov 3,313,782
Dec 3,705,701
Percent of budget 66.75%
$‐
$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 22 of 37
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 64,644,477
Aug 73,936,346
Sep 83,251,821
Oct 92,225,305
Nov 101,392,393
Dec 111,626,501
Percent of budget expended 47.97%
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
Aug 205,498
Sep 231,042
Oct 256,847
Nov 282,568
Dec 309,907
Percent of budget expended 51.63%
$‐
$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 ‐ 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
Aug 891,836
Sep 997,727
Oct 1,110,465
Nov 1,222,415
Dec 1,359,996
Percent of budget expended 46.27%
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
Aug 1,170,538
Sep 1,323,502
Oct 1,482,556
Nov 1,626,768
Dec 1,863,395
Percent of budget expended 47.17%
$‐
$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 24 of 37
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
Aug 1,385,662
Sep 1,555,116
Oct 1,726,270
Nov 1,897,359
Dec 2,094,010
Percent of budget expended 47.65%
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
Aug 669,788
Sep 752,773
Oct 835,539
Nov 918,100
Dec 1,012,142
Percent of budget expended 49.67%
$‐
$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 ‐ 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
Aug 1,995,920
Sep 2,250,357
Oct 2,519,009
Nov 2,776,952
Dec 3,040,435
Percent of budget expended 45.48%
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
Aug 423,762
Sep 475,562
Oct 526,555
Nov 583,152
Dec 644,063
Percent of budget expended 44.54%
$‐
$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 26 of 37
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
Aug 1,501,983
Sep 1,703,471
Oct 1,879,353
Nov 2,062,499
Dec 2,261,206
Percent of budget expended 40.78%
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
Aug 1,381,616
Sep 1,546,956
Oct 1,701,753
Nov 1,852,570
Dec 2,334,758
Percent of budget expended 48.38%
$‐
$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 27 of 37
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
Aug 827,964
Sep 901,085
Oct 973,200
Nov 1,046,567
Dec 1,125,927
Percent of budget expended 51.79%
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
Aug 658,226
Sep 739,793
Oct 822,360
Nov 907,045
Dec 1,002,994
Percent of budget expended 43.80%
$‐
$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 28 of 37
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,838,638
Aug 20,173,278
Sep 22,849,319
Oct 25,195,504
Nov 27,818,990
Dec 30,425,197
Percent of budget expended 48.76%
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
Aug 17,030,818
Sep 19,036,886
Oct 21,071,064
Nov 23,133,937
Dec 25,219,873
Percent of budget expended 49.87%
$‐
$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 ‐ 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
Aug 326,379
Sep 366,052
Oct 405,523
Nov 447,189
Dec 493,982
Percent of budget expended 47.34%
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
Aug 2,777,634
Sep 3,184,127
Oct 3,574,538
Nov 3,939,495
Dec 4,311,514
Percent of budget expended 42.64%
$‐
$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 30 of 37
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
Aug 495,631
Sep 564,205
Oct 636,195
Nov 702,081
Dec 880,373
Percent of budget expended 36.73%
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
Aug 3,479,188
Sep 3,980,445
Oct 4,344,574
Nov 4,701,254
Dec 5,111,272
Percent of budget expended 38.59%
$‐
$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 31 of 37
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
Aug 748,949
Sep 802,062
Oct 950,120
Nov 1,027,713
Dec 1,221,989
Percent of budget expended 41.18%
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
Aug 631,090
Sep 711,521
Oct 785,130
Nov 890,176
Dec 979,716
Percent of budget expended 37.95%
$‐
$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 32 of 37
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
Aug 150,895
Sep 169,970
Oct 189,000
Nov 208,138
Dec 226,683
Percent of budget expended 45.57%
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
Aug 314,166
Sep 350,422
Oct 385,541
Nov 420,605
Dec 456,340
Percent of budget expended 42.29%
$‐
$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 33 of 37
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
Aug 2,962,105
Sep 3,328,647
Oct 3,699,390
Nov 4,070,992
Dec 4,488,268
Percent of budget expended 48.06%
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
Aug 2,918,281
Sep 3,263,752
Oct 3,635,898
Nov 3,985,013
Dec 4,539,752
Percent of budget expended 46.27%
$‐
$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 34 of 37
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 4,865,503
Aug 5,560,575
Sep 6,255,647
Oct 6,950,719
Nov 7,645,791
Dec 8,340,863
Percent of budget expended 21.67%
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 4,597,742
Aug 5,254,563
Sep 5,911,383
Oct 6,568,203
Nov 7,225,024
Dec 7,881,844
Percent of budget expended 83.97%
$‐
$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 35 of 37
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
Aug 54,078,194
Sep 61,661,742
Oct 67,509,352
Nov 73,767,095
Dec 84,995,384
Percent of budget expended 32.09%
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
Aug 11,430,266
Sep 12,053,858
Oct 17,677,109
Nov 17,970,642
Dec 18,828,270
Percent of budget expended 10.25%
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 36 of 37
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
Aug 1,533,049
Sep 1,729,746
Oct 1,916,501
Nov 2,077,100
Dec 2,715,919
Percent of budget expended 39.48%
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