HomeMy WebLinkAbout201309, September.pdfADMINISTRATIVE SERVICES
DEPARTMENT
M E M O R A N D U M
DATE: October 31, 2013
TO: Randy Corman, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: September 2013 Financial Status Report
At the end of September, general governmental revenues show $3 million or 4.5% over budget.
Revenues sources that are higher than expected are: property tax ($378k); sales tax ($1.3
million); sales tax annexation credit ($243k); real estate excise tax ($150k); building permits &
development service fees ($745k); state shared revenues ($467k); public safety services
($219k); interfund services ($177k); rents, leases, and concessions ($105k); and other
miscellaneous ($165k). On the down side, the revenue sources that are underperforming the
year to date budget are: utility taxes ($339k below); gambling taxes ($263k below);
culture/recreation services ($106k below) and seizure funds ($116k below, restricted to drug
enforcement only and is not available for general operating purposes).
General government expenditures showed a favorable variance of $1.6 million or 2.1%. 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,407,119$ 11,407,119$ 11,057,551$ 11,057,551$ 15,575,839$ 15,575,839$ 15,575,839$ ‐ 0.0%
OPERATING REVENUES
Property Tax 32,357,894 17,715,892 33,466,364 18,243,056 31,741,366 17,182,454 17,560,252 377,798 2.2%
Sales Tax 17,729,731 13,279,501 18,564,670 13,569,401 18,604,000 13,833,214 15,137,125 1,303,911 9.4%
Sales Tax ‐ Annexation Credit 2,033,954 1,513,579 2,208,492 1,616,174 2,119,680 1,551,182 1,794,409 243,227 15.7%
Criminal Justice Sales Tax 1,809,757 1,361,430 1,924,470 1,411,031 1,932,500 1,416,918 1,539,899 122,980 8.7%
Natural Gas Use Tax 249,407 206,447 272,530 237,769 300,000 248,325 215,644 (32,681) ‐13.2%
Admission Tax 308,200 222,088 311,054 235,808 308,000 233,493 240,300 6,807 2.9%
Franchise Fees 1,234,448 894,644 1,262,188 904,991 1,260,000 903,423 943,042 39,619 4.4%
Electricity Tax 5,166,711 3,846,982 5,211,111 3,941,360 5,468,000 4,135,655 3,914,651 (221,004) ‐5.3%
Natural Gas Utility Tax 1,848,806 1,465,021 1,669,967 1,336,635 1,656,000 1,325,455 1,202,418 (123,038) ‐9.3%
Transfer Station 297,474 199,986 330,607 236,134 300,000 214,274 308,417 94,143 43.9%
TV Cable 1,385,275 1,019,718 1,423,664 1,046,925 1,477,648 1,086,623 1,089,195 2,572 0.2%
Telephone 966,827 731,537 1,056,420 749,210 1,000,000 709,197 698,254 (10,943) ‐1.5%
Cellular Phone 2,054,183 1,585,584 2,183,853 1,709,535 2,200,000 1,722,176 1,542,260 (179,915) ‐10.4%
City Utilities 3,516,179 2,633,503 3,806,281 2,845,421 3,849,014 2,877,366 3,009,627 132,261 4.6%
Leasehold Excise Tax 162,593 122,412 158,849 92,045 145,000 84,020 94,965 10,945 13.0%
Gambling Excise Tax 1,671,414 1,268,562 1,691,209 1,273,344 1,600,000 1,204,670 941,208 (263,463) ‐21.9%
Real Estate Excise Tax 2,074,059 1,383,144 2,811,902 1,864,830 2,600,000 2,118,410 2,268,082 149,672 7.1%
Less: Municipal Facilities CIP REET (400,000) (246,990) (943,792) (368,361) (500,000) (436,184) (436,184) ‐ 0.0%
EMS Levy 868,873 510,544 885,781 442,891 900,000 458,181 458,181 ‐ 0.0%
Business License Fees 442,451 325,599 444,680 329,180 533,067 394,610 376,215 (18,394) ‐4.7%
Animal Licenses and Spec Events Permits 232,534 143,117 242,668 166,755 90,000 73,690 82,695 9,005 12.2%
Building Permits & Development Svc Fees 2,772,779 2,113,119 3,401,537 2,307,453 3,123,413 2,075,833 2,821,074 745,241 35.9%
Intergovt'l (Grants, State Shared, etc) 4,737,323 3,033,325 4,593,185 3,549,535 3,471,505 2,672,973 3,016,992 344,019 12.9%
Fire District 25 and 40 Contracts 6,110,668 3,144,397 6,155,621 3,226,625 5,865,056 3,018,575 3,018,575 ‐ 0.0%
Public Safety 484,985 361,137 485,899 353,966 380,229 276,988 496,475 219,487 79.2%
Culture and Recreation 1,493,540 1,283,581 1,494,165 1,281,861 1,618,486 1,388,518 1,282,229 (106,289) ‐7.7%
Interfund/Interdept‐Services 3,070,506 2,224,652 3,311,715 2,400,424 3,313,830 2,485,373 2,662,001 176,629 7.1%
Fines and Penalties 1,163,602 802,240 1,046,246 717,053 1,108,500 762,186 790,356 28,170 3.7%
Photo Enforcement 1,897,782 1,368,117 1,976,203 1,445,171 1,950,000 1,426,009 1,314,189 (111,820) ‐7.8%
Seizure Funds ‐ Federal/State/Local 83,220 10,903 37,941 31,767 180,693 151,290 34,876 (116,414) ‐76.9%
Interests and Other Earnings 107,183 74,807 342,424 74,233 745,300 161,572 79,852 (81,720) ‐50.6%
Rents, Leases, and Concessions 744,834 607,276 822,428 670,969 650,929 531,054 636,377 105,323 19.8%
Contributions and Donations 196,586 178,284 124,082 104,431 93,100 78,356 73,345 (5,010) ‐6.4%
Other Miscellaneous 529,147 344,741 564,571 390,512 516,369 364,625 529,590 164,964 45.2%
Other Financing Sources (Transfer‐In, etc) 1,073,507 169,528 5,118,188 160,342 254,868 7,985 20,415 12,430 155.7%
Total Operating Revenues 100,476,431 65,898,407 108,457,170 68,598,474 100,856,553 66,738,488 69,756,998 3,018,510 4.5%
OPERATING EXPENDITURES
Council 271,236 203,409 278,768 207,888 290,291 217,082 216,073 1,008 0.5%
Executive 1,566,906 1,121,986 1,377,109 1,001,508 1,322,364 953,811 919,138 34,673 3.6%
City Attorney 1,596,609 1,189,429 1,706,320 1,261,497 1,915,103 1,421,095 1,315,727 105,367 7.4%
Court Services 2,084,170 1,559,522 2,074,980 1,559,621 2,026,149 1,519,505 1,468,967 50,538 3.3%
Community and Eco Dvlpmnt Admin 929,814 698,417 942,071 708,111 1,020,208 766,581 771,885 (5,304) ‐0.7%
Development Services 2,810,736 2,109,094 3,103,568 2,272,559 3,358,299 2,488,019 2,425,328 62,691 2.5%
Economic Development 659,981 499,623 529,043 394,501 570,280 428,840 341,333 87,507 20.4%
Planning 1,447,781 1,082,329 1,482,233 1,121,575 1,541,592 1,159,558 1,133,145 26,413 2.3%
Finance 2,134,667 1,425,349 2,221,882 1,487,821 2,242,682 1,499,653 1,491,143 8,510 0.6%
City Clerk1 796,758 621,362 997,434 785,006 1,101,505 863,409 830,214 33,195 3.8%
Human Resources 888,252 633,893 937,412 700,143 977,094 713,975 658,189 55,787 7.8%
Police 24,737,346 18,379,946 25,004,580 18,758,350 25,379,201 18,948,608 18,763,787 184,822 1.0%
Jail Services 6,206,735 2,826,495 3,489,616 2,616,541 3,750,000 2,860,536 2,860,536 ‐ 0.0%
Fire 22,511,597 17,069,616 24,173,315 18,352,396 24,197,056 18,359,431 18,346,018 13,413 0.1%
Community Services Admin 416,284 306,588 434,558 320,209 450,911 332,176 336,859 (4,683) ‐1.4%
Parks 3,829,676 2,788,379 4,004,054 2,927,216 4,153,621 3,030,537 3,002,198 28,340 0.9%
Parks Planning & Natural Resources 551,423 397,535 577,934 417,421 934,005 673,988 484,402 189,586 28.1%
Recreation 4,974,002 3,855,315 4,982,229 3,831,606 5,130,300 3,960,958 3,822,962 137,996 3.5%
Human Services 1,247,294 846,288 1,193,871 797,375 1,196,052 805,315 749,137 56,178 7.0%
Neighborhoods, Resources, & Events 675,534 464,692 701,673 486,854 914,955 632,165 582,563 49,602 7.8%
Library 2,030,000 1,822,619 278,604 271,106 ‐ ‐ ‐ ‐ 0.0%
Museum 210,620 157,635 216,887 162,485 211,080 158,058 157,141 917 0.6%
Public Works Admin 452,538 339,129 470,051 354,626 483,035 363,226 333,688 29,538 8.1%
Street Maintenance 3,534,025 2,630,100 3,755,640 2,757,612 4,294,894 3,174,309 2,856,379 317,930 10.0%
Transportation 4,509,066 3,283,394 4,615,160 3,316,587 4,579,081 3,312,264 3,219,909 92,355 2.8%
Debt Service 4,822,566 1,398,850 9,752,337 2,158,688 8,034,283 2,058,808 2,058,808 ‐ 0.0%
Non‐Departmental and Other 4,930,383 4,273,035 4,637,555 2,298,266 5,641,350 3,192,930 3,192,930 ‐ 0.0%
Total Operating Expenditures 100,825,999 71,984,031 103,938,882 71,327,565 105,715,391 73,894,837 72,338,457 1,556,380 2.1%
Total Ending Fund Balance 11,057,551$ 5,321,495$ 15,575,840$ 8,328,460$ 10,717,001$ 8,419,490$ 12,994,380$ 4,574,890$ 54.3%
1 Hearing Examiner is reported under City Clerk
Summary of Sources and Uses Annual Actual YTD Actual Favorable (Unfavorable)
2011 2012 2013 Variance
Annual Actual YTD Actual Annual Budget YTD Budget YTD Actual
Monthly Financial Report September 2013
Page 1 of 38
Monthly Financial Report September 2013
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through September 30, 2013. Except as
noted, year‐to‐date budgeted revenues and operating expenditures are generally based on the collection/disbursement
patterns for the same period of the preceding year. The table on the previous page summarizes the general governmental
fund revenues and expenditures.
Revenues
Taxes
The combined collection of property, sales/use, utility, gambling, admissions, and real estate excise taxes represents 73% of
all resources supporting general governmental activities. The following section provides detail information on property,
sales, utility, and other taxes.
Property Tax
September’s collection is $548k, making
the total year‐to‐date collection $17.6
million or 55.3% of the total budget. In
comparison to the previous year, the City
collected $683k or 4% less. Compared to
the budget, the City is above projections by
$378k or 2%. 2013’s monthly budgets are
based on 2010 through 2012 collections.
The variance from the monthly budget is
due the timing of collections. The City is
projecting property taxes to meet the
budget by year‐end.
Sales Tax
September 2013 sales tax receipts totalled
$1.7 million. Compared with the same
month last year, it is $269k or 18% more.
Compared to the projected current
month’s budget, it is $233k or 15% above.
The year‐to‐date collection of $15.1 million
is $1.6 million or 12% more than the prior
year and is also $1.3 million or 9% more
than budgeted. The increase is primarily
attributed to several major projects
underway in both Building Construction
and Heavy and Civil projects, which account
for $661k of the budget variance. Another
item is a 1‐time audit correction in the
manufacturing sector for 2012 that reduced activity in 2012 by $131k. If we remove all of these items, we are $776k or 6%
over 2012 and $643k or 5% more than budget.
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 149,112$ 218,452$ 154,945$ 5,834$ 4% (63,506)$ ‐29%
Feb 85,577 238,602 25,020 (60,557) ‐71% (213,582) ‐90%
Mar 880,380 747,935 917,901 37,521 4% 169,966 23%
Apr 10,012,008 8,452,665 9,887,324 (124,683) ‐1% 1,434,659 17%
May 6,131,450 6,807,499 5,780,361 (351,089) ‐6% (1,027,138) ‐15%
Jun 43,203 69,561 88,480 45,277 105% 18,919 27%
Jul 446,717 218,293 100,047 (346,670) ‐78% (118,246) ‐54%
Aug (51,143) 13,620 58,101 109,245 ‐214% 44,482 327%
Sep 545,753 415,826 548,071 2,319 0% 132,245 32%
Oct 9,734,384 7,408,344
Nov 5,123,725 6,825,452
Dec 365,200 325,116
YTD Total 18,243,056$ 17,182,454$ 17,560,252$ (682,804)$ ‐4% 377,798$ 2%
Annual Total 33,466,364$ 31,741,366$
Property Tax Revenues
Year to Date through September
2013 vs. 2012 2013 vs. Budget
Month
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 1,327,548$ 1,426,729$ 1,620,555$ 293,007$ 22% 193,826$ 14%
Feb 1,923,714 1,924,871 1,962,886 39,173 2% 38,015 2%
Mar 1,303,820 1,392,437 1,536,397 232,577 18% 143,960 10%
Apr 1,370,731 1,433,794 1,509,953 139,222 10% 76,159 5%
May 1,599,184 1,625,701 1,732,058 132,874 8% 106,357 7%
Jun 1,482,794 1,471,334 1,552,807 70,013 5% 81,473 6%
Jul 1,505,142 1,462,124 1,647,860 142,718 9% 185,736 13%
Aug 1,583,903 1,588,018 1,833,347 249,443 16% 245,328 15%
Sep 1,472,566 1,508,206 1,741,262 268,697 18% 233,056 15%
Oct 1,660,941 1,588,803 ‐
Nov 1,709,049 1,622,090 ‐
Dec 1,625,280 1,559,893 ‐
YTD Total 13,569,401$ 13,833,214$ 15,137,125$ 1,567,724$ 12% 1,303,911$ 9%
Annual Total 18,564,670$ 18,604,000$
2013 vs. Budget2013 vs. 2012
Month
Year to Date through September
Local Retail Sales Tax Revenues
Page 2 of 38
Monthly Financial Report September 2013
The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business
sectors:
Sales Tax by Sector 2012 2013 Bgt YTD Act Change 2013/2012 2013 Act vs Bgt
New Construction 1,219,145$ 1,315,850$ 2,033,285$ 814,140$ 67%$ 717,435 55%
Auto Sales 2,480,675 2,509,428 2,794,641 313,966 13% 285,213 11%
General Retail 4,828,840 4,888,680 4,865,080 36,240 1% (23,600) 0%
Manufacturing 782,592 787,061 937,384 154,793 20% 150,324 19%
Wholesale 868,790 878,597 861,947 (6,844) ‐1% (16,650)‐2%
Service 3,069,135 3,150,760 3,261,008 191,873 6% 110,249 3%
Other 320,223 302,838 383,779 63,556 20% 80,941 27%
YTD Total 13,569,401$ 13,833,214$ 15,137,125$ 1,567,724$ 12%1,303,911$ 9%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility tax
September utility tax revenues are $1.4
million, which is $132k or 10% higher
than the same month last year and is
also ahead of the budget by $101k or
8%. The year‐to‐date collection is $12
million, which is $123k or 1% lower than
the prior year and is also $339k or 3%
lower than the budget. The City is
projecting utility tax revenues to be
under budget at year‐end.
The table below breaks out Utility Tax by source. The Electrical/Natural Gas variance is due to warmer weather
year‐to‐date than the prior year and we are projecting a combined unfavorable variance of $339k or 5%. Cell and Phone
variances are due the timing of receipts compared to 2012 (which should mostly catch up at the end of the year, but we are
projecting a combined unfavorable budget variance of $271k or 8%).
Utility Tax by Type 2012 2013 Bgt YTD Act Change 2013/2012 2013 Act vs Bgt
Electrical 3,941,360$ 4,135,655$ 3,914,651$ (26,709)$ ‐1%$ (221,004)‐5%
Natural Gas 1,574,403 1,573,781 1,418,062 (156,342) ‐10% (155,719)‐10%
Cell 1,709,535 1,722,176 1,542,260 (167,275) ‐10% (179,915)‐10%
Phone 749,210 709,197 698,254 (50,956) ‐7% (10,943)‐2%
Cable 1,046,925 1,086,623 1,089,195 42,270 4% 2,572 0%
Transfer Station 236,134 214,274 308,417 72,283 31% 94,143 44%
City Utilities 2,845,421 2,877,366 3,009,627 164,206 6% 132,261 5%
YTD Total 12,102,988$ 12,319,071$ 11,980,466$ (122,523)$ ‐1%(338,605)$ ‐3%
Annual Total 15,954,432$ 16,250,662$
YTD as % of 76% 76%
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 1,469,178$ 1,494,708$ 1,277,860$ (191,318)$ ‐13% (216,848)$ ‐15%
Feb 1,512,539 1,497,446 1,462,236 (50,302) ‐3% (35,210) ‐2%
Mar 1,438,515 1,467,773 1,193,129 (245,387) ‐17% (274,644) ‐19%
Apr 1,384,240 1,412,358 1,545,257 161,017 12% 132,899 9%
May 1,394,109 1,423,158 1,338,923 (55,185) ‐4% (84,235) ‐6%
Jun 1,108,588 1,140,870 1,189,847 81,259 7% 48,977 4%
Jul 1,340,939 1,370,103 1,259,713 (81,225) ‐6% (110,390) ‐8%
Aug 1,153,724 1,180,346 1,280,207 126,484 11% 99,861 8%
Sep 1,301,158 1,332,309 1,433,293 132,136 10%100,985 8%
Oct 1,126,772 1,153,538
Nov 1,196,932 1,213,641
Dec 1,527,740 1,564,412
YTD Total 12,102,988$ 12,319,071$ 11,980,466$ (122,523)$ ‐1% (338,605)$ ‐3%
Annual Total 15,954,432$ 16,250,662$
2013 vs. Budget2013 vs. 2012
Year to Date through September
Utility Tax Revenues
Month
Page 3 of 38
Monthly Financial Report September 2013
Other Taxes
Real Estate Excise Tax
The City collected $254k in Real Estate
Excise Tax revenues (REET) for September.
This is $81k or 47% above the same month
last year and is also $49k or 24% more than
the current month’s budget. The year‐to‐
date collection is $2.3 million, which is
$403k or 22% more than the prior year and
is also $150k or 7% above the budget. The
City is projecting REET to meet the budget
at year‐end.
Gambling Tax
September’s Gambling Tax
collections totalled $116k, which is
$46k or 29% below the same month
last year and is also $38k or 24%
below the current month’s budget.
The year‐to‐date total of $941k is
$332k or 26% below the year before
and is also $263k or 22% below
budget. The decline in revenue is
mainly due to payment plans with
two (2) establishments that will be
paid in full within 18 months. The
City is also seeing a decline in overall
activity.
Pull tabs overall had a 5% decrease,
bingo decreased by 12%, and card‐rooms are seeing 38% lower in activities when compared to the prior year.
Franchise Fees
Franchise Fees are due quarterly and the
year‐to‐date revenue collections are
$943k or 75% of the budget. This is $38k
or 4% higher than the prior year and is
also $40k or 4% above the projected
year‐to‐date budget. The City is
projecting franchise fees to be very close
to the budget at year‐end.
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 77,631$ 95,818$ 134,099$ 56,468$ 73% 38,281$ 40%
Feb 214,137 243,603 262,229 48,092 22% 18,627 8%
Mar 203,583 227,510 228,077 24,494 12% 568 0%
Apr 194,868 213,798 197,659 2,791 1% (16,140) ‐8%
May 253,446 283,619 285,948 32,501 13% 2,329 1%
Jun 347,179 380,093 347,890 711 0% (32,203) ‐8%
Jul 177,839 211,158 263,807 85,967 48% 52,649 25%
Aug 222,933 257,653 294,056 71,123 32% 36,403 14%
Sep 173,212 205,159 254,318 81,106 47% 49,160 24%
Oct 326,027 253,867
Nov 370,123 155,134
Dec 250,922 72,589
YTD Total 1,864,830$ 2,118,410$ 2,268,082$ 403,253$ 22% 149,672$ 7%
Annual Total 2,811,902$ 2,600,000$
Month
2013 vs. Budget2013 vs. 2012
Real Estate Excise Tax Revenues
Year to Date through September
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 175,959$ 166,470$ 133,504$ (42,455)$ ‐24% (32,965)$ ‐20%
Feb 143,837 136,080 73,730 (70,107) ‐49% (62,350) ‐46%
Mar 98,279 92,979 111,294 13,014 13% 18,315 20%
Apr 156,498 148,058 159,655 3,158 2% 11,598 8%
May 101,088 95,636 97,660 (3,428) ‐3% 2,024 2%
Jun 127,372 120,502 60,074 (67,298) ‐53% (60,428) ‐50%
Jul 161,244 152,548 89,157 (72,087) ‐45% (63,391) ‐42%
Aug 146,526 138,623 99,930 (46,596) ‐32% (38,694) ‐28%
Sep 162,540 153,774 116,204 (46,336) ‐29% (37,570) ‐24%
Oct 87,494 82,776 ‐
Nov 177,352 167,787 ‐
Dec 153,019 144,767 ‐
YTD Total 1,273,344$ 1,204,670$ 941,208$ (332,136)$ ‐26% (263,463)$ ‐22%
Annual Total 1,691,209$ 1,600,000$
2013 vs. 2012 2013 vs. Budget
Gambling Tax Revenue
Month
Year to Date through September
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 300,392$ 299,872$ 314,269$ 13,877$ 5% 14,397$ 5%
Feb ‐ ‐ 200 200 100% 200 100%
Mar ‐ ‐ 892 892 100% 892 100%
Apr 299,534 299,015 311,986 12,452 4% 12,971 4%
Jul 305,065 304,536 315,694 10,630 3% 11,158 4%
Oct 309,001 308,466 ‐
Dec 48,195 48,111 ‐
YTD Total 904,991$ 903,423$ 943,042$ 38,050$ 4% 39,619$ 4%
Annual Total 1,262,188$ 1,260,000$
Franchise Fees Revenue
Year to Date through September
Month
2013 vs. 2012 2013 vs. Budget
Page 4 of 38
Monthly Financial Report September 2013
Admission Tax
Admission Tax returns are due
quarterly in January, April, July, and
October of each year. July 2013
collections represent activities
conducted during the 2nd quarter of
2013. The year‐to‐date collection of
$240k is $5k or 2% more than the prior
year and is also $8k or 3% more than
the budget. The City is projecting
admission tax revenues to be very
close to the budget at year‐end.
Licenses and Permits
Building Permits and Development Service Fees
Building Permits and Development Service Fee
revenues totalled $255k in September. The
year‐to‐date development fees revenue of $2.8
million is $590k or 26% more than the year
before and is also $745k or 36% higher than
budget. The higher than expected fees are due
to collecting more in general building permits,
electrical permits, street excavations, 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 $4k for September,
which is $1k or 32% above the same month last
year and is also $403 or 11% above the current
month’s budget. The year‐to‐date Business
Licenses revenue of $376k is $47k or 14% above
the prior year but is $18k or 5% lower than the
budget. The variance for July is due to correcting
the percentages distributed between the
General fund and Transportation CIP fund. The
City is projecting business licenses to be very
close with the budget at year‐end.
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 151,891$ 150,030$ 327,644$ 175,754$ 116% 177,614$ 118%
Feb 185,509 182,234 230,104 44,595 24% 47,870 26%
Mar 253,914 237,278 305,160 51,246 20% 67,882 29%
Apr 249,923 243,068 367,285 117,362 47% 124,217 51%
May 277,438 236,982 386,795 109,358 39% 149,814 63%
Jun 284,208 245,409 293,386 9,178 3% 47,977 20%
Jul 292,686 278,792 315,496 22,809 8% 36,703 13%
Aug 360,657 347,350 340,335 (20,322) ‐6% (7,014) ‐2%
Sep 174,587 154,690 254,869 80,281 46% 100,179 65%
Oct 400,995 384,228
Nov 271,519 262,232
Dec 406,375 401,120
YTD Total 2,230,813$ 2,075,833$ 2,821,074$ 590,261$ 26% 745,241$ 36%
Annual Total 3,309,702$ 3,123,413$
Building Permits and Development Service Fees
Year to Date through September
2013 vs. Budget2013 vs. 2012
Month
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 88,676$ 106,302$ 95,381$ 6,705$ 8% (10,921)$ ‐10%
Feb 24,251 29,071 40,658 16,407 68% 11,587 40%
Mar 4,927 5,906 12,441 7,515 153% 6,535 111%
Apr 89,003 106,694 102,648 13,644 15% (4,047) ‐4%
May 2,645 3,171 33,354 30,709 1161% 30,183 952%
Jun 3,377 4,048 5,701 2,324 69% 1,653 41%
Jul 98,553 118,142 52,586 (45,967) ‐47% (65,556) ‐55%
Aug 14,550 17,442 29,210 14,661 101% 11,769 67%
Sep 3,197 3,833 4,236 1,039 32% 403 11%
Oct 99,644 119,450 ‐
Nov 12,484 14,965 ‐
Dec 3,372 4,042 ‐
YTD Total 329,180$ 394,610$ 376,215$ 47,035$ 14% (18,394)$ ‐5%
Annual Total 444,680$ 533,067$
Business Licenses
Month
2013 vs. 2012
Year to Date through September
2013 vs. Budget
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 73,420$ 72,699$ 82,440$ 9,020$ 12% 9,741$ 13%
Feb 934 925 ‐
Apr 80,352 79,563 70,311 (10,041) ‐12% (9,252) ‐12%
Jul 81,104 80,307 87,473 6,370 8% 7,166 9%
Aug ‐ ‐ 76 76 100% 76 100%
Oct 74,001 73,275 ‐
Dec 1,244 1,232 ‐
YTD Total 235,808$ 233,493$ 240,300$ 5,426$ 2% 7,731$ 3%
Annual Total 311,054$ 308,000$
Month
2013 vs. 2012 2013 vs. Budget
Admission Tax Revenue
Year to Date through September
Page 5 of 38
Monthly Financial Report September 2013
Intergovernmental
These revenue sources
include federal (direct
and indirect) grants,
state grants, state
shared revenues, local
grants, and
entitlements. State
shared revenues and
Fire Districts’ 25 and 40
contracts compose 85%
of the total revenues in this category. The year‐to‐date total Intergovernmental revenue is $7.6 million or 67% of the
budget.
State Shared Revenues
State Shared Revenue collections
totalled $3.4 million since the start
of the year. Compared to the
prior year, State Shared Revenues
are below by $251k or 7%.
Compared to the projected
budget, the City is collecting $467k
or 16% more. The higher than
expected (but lower than prior
year) collection is due to collecting
more than anticipated Criminal
Justice Sales Tax, the low budget
of Criminal Justice’s High Crime and the higher than expected collections for Liquor Profits. The reason for the decline in
Liquor Excise Tax is also due to the passage of Initiative 1183. Starting October 2012, the State will divert all Liquor Excise
Taxes that would normally be distributed to local governments to their State General Fund for one year. The City will not
receive these excise taxes in January 2013, April 2013 and July 2013. On the October 2013 distribution and on, local
governments will start receiving their portions of the excise taxes less a $10 million (per year) transfer from the State Liquor
Excise Tax Fund to the State General Fund.
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 70% of the total revenue in this category. The year‐to‐date total charges for services are $5.6 million or 87% of
the budget. This is 14% above budget projections. The following sections provide detail information for Public Safety,
Recreation, and Interfund Services.
2012 2013 2013
Actual Budget Actual $ % $ %
Crim Just Sales Tax 1,411,031$ 1,416,918$ 1,539,899$ 128,868$ 9% 122,980$ 9%
Judicial Contribution 22,632 22,500 17,097 (5,535) ‐24% (5,403) ‐24%
Crim Just ‐ High Crime 144,999 ‐ 166,329 21,330 15% 166,329 100%
Crim Just ‐ Pop 15,589 ‐ 16,728 1,139 7% 16,728 100%
Crim Just ‐ Spec Prog 58,682 66,969 62,393 3,711 6% (4,575) ‐7%
State DUI 13,149 13,605 12,697 (451) ‐3% (908) ‐7%
Liquor Profits 717,552 494,451 635,103 (82,449) ‐11% 140,651 28%
Liquor Excise Tax 342,495 ‐ ‐ (342,495) 0%‐ N/A
Fuel Tax 950,329 944,212 975,409 25,080 3% 31,197 3%
YTD Total 3,676,458$ 2,958,655$ 3,425,655$ (250,803)$ ‐7% 466,999$ 16%
Annual Total 4,825,202$ 4,208,000$
2013 vs. Budget
State Shared Revenues
2013 vs. 2012
Revenue
Year to Date through September
Intergovernmental 2012 2013 Bgt YTD Act Change 2013/2012 2013 Act vs Bgt
Fire District #25 698,717$ 591,779$ 591,779$ (106,938)$ ‐15% $ ‐ 0%
Fire District #40 2,527,908 2,426,796 2,426,796 (101,112) ‐4%‐ 0%
State Shared Revenue 3,676,458 2,958,655 3,425,655 (250,803) ‐7% 466,999 16%
Federal Grants 779,086 922,762 922,762 143,676 18%‐ 0%
State Grants 111,798 63,711 63,711 (48,088) ‐43%‐ 0%
Other Grants/Intgovt 119,280 29,972 29,972 (89,308) ‐75%‐ 0%
ARRA Grants 273,944 114,792 114,792 (159,153) ‐58%‐ 0%
Total Rev YTD 8,187,190$ 7,108,467$ 7,575,466$ (611,724)$ ‐7%466,999$ 7%
Total Rev Annual 12,673,276$ 11,269,061$
YTD % 65% 63% 67%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
Page 6 of 38
Monthly Financial Report September 2013
Public Safety Services
Public Safety Services totalled $496k 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 $142k or 40% more. Compared to
the year‐to‐date budget, the City is $219k or
79% more. The reason for the large favourable
variance with the prior year is due to a
different way of accounting for
intergovernmental services. Prior to 2013, the
City accounted for these services as general
intergovernmental. Due to the 2013
Budgeting, Accounting, and Reporting System (BARS) Restructuring Project, the State does not recognize intergovernmental
charges for services as separate from charges for services. Of the $496k receipted for Public Safety Services, $132k is for
intergovernmental.
Recreation
Recreation revenues totalled $124k for the
current month. Compared to the same month
the prior year, the City collected $16k or 15%
more. Compared to the projected monthly
budget, the City collected $7k or 6% more.
The primary reason that recreation fees are
lower is due to the new cost recovery policy
approved by council in 2012 which reduces or
eliminates those programs that do not meet
recovery objectives. This revenue reduction
translates into a savings of $138k in the
Recreation Division of the Community Services
Department.
Interfund Services
The year‐to‐date collections for Interfund
Services revenues are $2.7 million. Compared
to the prior year, the revenues are over by
$262k or 11%. Compared to the projected
budget, the revenues are above by $177k or
7%. 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.
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 15,229$ 11,917$ 32,322$ 17,093$ 112% 20,405$ 171%
Feb 34,848 27,269 117,056 82,208 236% 89,787 329%
Mar 35,353 27,665 37,079 1,726 5% 9,414 34%
Apr 68,426 53,545 64,009 (4,418) ‐6% 10,463 20%
May 42,979 33,632 47,985 5,007 12% 14,353 43%
Jun 31,486 24,639 36,945 5,459 17% 12,306 50%
Jul 54,883 42,948 69,340 14,457 26% 26,393 61%
Aug 34,742 27,187 42,753 8,010 23% 15,566 57%
Sep 36,019 28,186 48,986 12,967 36% 20,800 74%
Oct 37,300 29,188 ‐
Nov 33,025 25,843 ‐
Dec 61,608 48,210 ‐
YTD Total 353,966$ 276,988$ 496,475$ 142,509$ 40% 219,487$ 79%
Annual Total 485,899$ 380,229$
Month
2013 vs. 2012
Year to Date through September
Public Safety Services
2013 vs. Budget
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 62,072$ 67,237$ 60,546$ (1,526)$ ‐2% (6,690)$ ‐10%
Feb 59,327 64,264 51,160 (8,167) ‐14% (13,104) ‐20%
Mar 104,775 113,492 79,491 (25,283) ‐24% (34,001) ‐30%
Apr 137,257 148,678 170,541 33,284 24% 21,863 15%
May 139,013 150,580 95,710 (43,303) ‐31% (54,870) ‐36%
Jun 149,137 161,546 150,284 1,147 1% (11,262) ‐7%
Jul 260,363 282,026 345,126 84,763 33% 63,100 22%
Aug 262,038 283,841 205,821 (56,217) ‐21% (78,020) ‐27%
Sep 107,879 116,855 123,550 15,670 15% 6,694 6%
Oct 85,973 93,126 ‐
Nov 65,863 71,343 ‐
Dec 60,467 65,498 ‐
YTD Total 1,281,861$ 1,388,518$ 1,282,229$ 368$ 0% (106,289)$ ‐8%
Annual Total 1,494,165$ 1,618,486$
Recreation
Year to Date through September
2013 vs. Budget2013 vs. 2012
Month
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 237,384$ 276,153$ 265,873$ 28,489$ 12% (10,279)$ ‐4%
Feb 234,758 276,153 292,362 57,604 25% 16,209 6%
Mar 271,071 276,153 317,998 46,927 17% 41,846 15%
Apr 253,070 276,153 288,610 35,541 14% 12,458 5%
May 291,941 276,153 299,652 7,711 3% 23,499 9%
Jun 275,112 276,153 287,569 12,457 5% 11,417 4%
Jul 217,828 276,153 282,466 64,638 30% 6,314 2%
Aug 345,690 276,153 352,945 7,255 2% 76,793 28%
Sep 273,570 276,153 274,525 955 0% (1,628) ‐1%
Oct 338,304 276,153 ‐
Nov 276,902 276,153 ‐
Dec 296,085 276,153 ‐
YTD Total 2,400,424$ 2,485,373$ 2,662,001$ 261,577$ 11% 176,629$ 7%
Annual Total 3,311,715$ 3,313,830$
Interfund Services
Year to Date through September
2013 vs. 2012 2013 vs. Budget
Month
Page 7 of 38
Monthly Financial Report September 2013
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 $2.1 million. This is $89k or 4%
lower than a year ago and is also $84k or 4%
below the budget. The City is projecting
fines and penalties to be slightly under the
budget at year‐end.
Year to Date through September
2012 2013 2013
Actual Budget Actual $ % $ %
Civil Penalties 6,354$ 10,592$ 6,553$ 199$ 3% (4,039)$ ‐38%
Civil Infraction Penalties 428,168 416,494 439,569 11,402 3% 23,075 6%
Civil Parking Infraction Penalties 112,087 126,825 126,215 14,129 13% (609) 0%
Photo Enforcement Program 1,445,171 1,426,009 1,314,189 (130,982) ‐9% (111,820) ‐8%
Criminal Traffic Misdemeanor Fines 62,481 72,046 75,073 12,593 20% 3,027 4%
Criminal Non‐Traffic Fines 17,720 32,374 30,197 12,477 70% (2,178) ‐7%
Criminal Costs 89,576 84,469 90,586 1,010 1% 6,117 7%
Seizure Funds ‐ Federal/State/Local1 31,767 ‐ ‐ (31,767) 0%‐ N/A
Non‐Court Fines, Forfeitures and Penalties 668 19,386 22,162 21,495 3220% 2,776 14%
YTD Total 2,193,991$ 2,188,195$ 2,104,545$ (89,446)$ ‐4% (83,650)$ ‐4%
Annual Total 3,060,389$ 3,058,500$
1Seizure Funds are categorized in Miscellaneous for 2013 and on.
Revenue
2013 vs. Budget
Fines and Penalties by Type
2013 vs. 2012
Included in the Fines and Penalties revenue budget is
$2 million from the Photo Enforcement program. The
budget was based on the prior year’s revenue. The
year‐to‐date collections from this program equates to
$1.3 million. The budget shortfall in January is due to
a change in receipting operations that resulted in a 1‐
month lag for defendant paid infractions. December’s
receipts will recognize 2 month’s worth of defendant
paid infractions. The budget shortfall starting in June
is due to temporary shutting down cameras in
construction areas. These revenues should pick up
after construction is near completion.
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.
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 183,478$ 181,746$ 153,064$ (30,413)$ ‐17% (28,682)$ ‐16%
Feb 241,050 231,901 247,166 6,116 3% 15,265 7%
Mar 244,379 246,962 275,222 30,842 13% 28,259 11%
Apr 278,972 279,587 318,235 39,264 14% 38,648 14%
May 306,424 310,705 278,783 (27,641) ‐9% (31,922) ‐10%
Jun 318,091 312,586 269,334 (48,758) ‐15% (43,252) ‐14%
Jul 274,243 277,336 236,571 (37,672) ‐14% (40,765) ‐15%
Aug 168,187 171,297 171,565 3,378 2% 268 0%
Sep 179,166 176,075 154,604 (24,562) ‐14% (21,470) ‐12%
Oct 278,866 280,183
Nov 247,607 251,568
Dec 339,926 338,553
YTD Total 2,193,991$ 2,188,195$ 2,104,545$ (89,446)$ ‐4% (83,650)$ ‐4%
Annual Total 3,060,389$ 3,058,500$
2013 vs. Budget2013 vs. 2012
Year to Date through September
Fines and Penalties by Month
Month
Favorable
Budget Actual Budget Actual (Unfavorable)
1
Jan 181,020$ 150,459$ 74,626$ 60,422$ 90,037$
Feb 145,300 158,685 74,412 60,116 98,568
Mar 142,933 152,959 74,226 60,184 92,775
Apr 176,175 217,923 71,127 60,187 157,736
May 212,766 181,018 74,599 60,361 120,657
Jun 218,587 161,729 74,570 56,521 105,208
Jul 186,121 151,808 74,882 56,398 95,411
Aug 91,365 80,932 74,285 56,345 24,586
Sep 71,743 58,676 50,884 55,930 2,747
Oct 191,799 ‐ 65,641 ‐ ‐
Nov 153,910 ‐ 66,315 ‐ ‐
Dec 178,282 ‐ 66,397 ‐ ‐
YTD Total 1,426,009$ 1,314,189$ 643,611$ 526,464$ 787,725$
Annual Total 1,950,000$ 841,964$
1Actuals of Revenues and Expenses
Revenues Expenses
Photo Enforcement Program
Year to Date through September
Month
Page 8 of 38
Monthly Financial Report September 2013
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 66% of the total
revenue in this category. The year‐to‐date
total miscellaneous is $1.1 million. Compared
to last year, the revenues are above by $6k or
1%. Compared to the projected year‐to‐date
budget, the revenues are over by $34k or 3%.
The table below breaks out miscellaneous
revenues by type:
2012 2013 2013
Actual Budget Actual $ % $ %
Interests and Other Earnings 74,233$ 161,572$ 79,852$ 5,619$ 8% (81,720)$ ‐51%
Rents, Leases, and Concessions 670,969 531,054 636,377 (34,593) ‐5% 105,323 20%
Contributions/Donations from Private Sources 104,431 78,356 73,345 (31,085) ‐30% (5,010) ‐6%
Other 227,263 126,328 258,328 31,065 14% 132,001 104%
Seizure Funds ‐ Federal/State/Local1 ‐ 151,290 34,876 34,876 100% (116,414) ‐77%
YTD Total 1,076,897$ 1,048,599$ 1,082,778$ 5,882$ 1% 34,180$ 3%
Annual Total 1,630,922$ 1,861,022$
1Seizure Funds are categorized in Miscellaneous for 2013 and on.
2013 vs. Budget
Miscellaneous Revenues by Type
Year to Date through September
Revenue
2013 vs. 2012
Rents, leases and concessions are higher than the prior year and budget due to higher than expected picnic shelter rentals,
facility/fitness area rentals at the community center and food concession payments at Coulon Park.
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. The use of Seizure Funds is restricted to drug
enforcement only and is not available for general operating purposes.
EXPENSES
Overall the City has expended 68% of its budgeted general governmental expenditures at the end of September. This is
$1.6 million or 2.1% below year‐to‐date budgeted expenditures. The City did not have any general governmental
departments over budget but did we did see some divisions within those departments over budget. Please refer to the
General Governmental Funds Summary of Sources and Uses table on page 1 for details.
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 206,151$ 163,080$ 179,743$ (26,408)$ ‐13% 16,663$ 10%
Feb 83,823 135,969 76,397 (7,425) ‐9% (59,572) ‐44%
Mar 104,421 84,515 147,909 43,488 42% 63,394 75%
Apr 98,164 111,835 92,872 (5,291) ‐5% (18,963) ‐17%
May 145,213 112,179 118,719 (26,494) ‐18% 6,540 6%
Jun 93,832 113,839 123,441 29,609 32% 9,602 8%
Jul 112,316 95,083 128,246 15,930 14% 33,163 35%
Aug 143,389 131,277 122,652 (20,737) ‐14% (8,624) ‐7%
Sep 89,588 100,822 92,799 3,211 4% (8,024) ‐8%
Oct 91,608 75,456
Nov 64,705 56,841
Dec 397,713 680,126
YTD Total 1,076,897$ 1,048,599$ 1,082,778$ 5,882$ 1% 34,180$ 3%
Annual Total 1,630,922$ 1,861,022$
Year to Date through September
Month
2013 vs. Budget2013 vs. 2012
Miscellaneous Revenues by Month
Page 9 of 38
Monthly Financial Report September 2013
CASH AND INVESTMENTS –
3RD 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 $110.1 million,
of this amount; $1.2
million 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, various certificates of deposits, and the interfund loan.
The existing portfolio yield is approximately .56%. The majority (.28%) is within the cash at US Bank.
Cash
63%
Local Government
Investment Pool
9%
US Federal Agency
Securities
5%
Certificates of
Deposit
22%
INTERFUND
INVESTMENT
1%
Distribution by Instrument
(Percent of Cash and Investment Portfolio)
Deposit Total Maturity Date APY Weighted Yield Current Allocation of
Cash and Investments
Allowed
by Policy
Current Principal
Balance
Cash US Bank ‐ Cash 69,689,281 overnight 0.45% 0.39%63%N/A 69,689,281
GOLF '13 375,000 12/1/2013 2.25% 0.03%
GOLF '14 395,000 12/1/2014 2.25% 0.03%
GOLF '15 410,000 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,924,780 5/31/2013 0.13% 0.02%9% 75%9,924,780
US Federal Agency Securities *
313169A BONY Trust 5,000,000 12/27/2016 1.00% 0.16%5%
Certificates of Deposit
113154A First Savings Bank Northwest 5,000,000 2/4/2015 0.92% 0.15%
113164A First Savings Bank Northwest 5,000,000 2/4/2016 1.02% 0.17%
112147a Columbia Bank 2,768,975 1/11/2014 0.69% 0.06%
111167a Columbia Bank 2,015,400 11/9/2016 0.99% 0.07%
212145a Fortune Bank (CDARS) 1,516,108 6/14/2014 0.70% 0.03%
212145b Fortune Bank (CDARS) 1,000,685 12/18/2014 0.65% 0.02%
112145a Fortune Bank (traditional) 252,980 12/23/2014 0.85% 0.01%0% 20%
112146a Umpqua Bank 5,209,717 5/18/2014 0.85% 0.15%
211133a Commencement Bank (CDARS)
111133a Commencement Bank (traditional)500,000 10/27/2013 1.00% 0.02%
212143a Commencement Bank (CDARS) 1,030,141 9/20/2014 0.65% 0.02%
Commercial Paper
none ‐ N/A N/A 0.00%0.00% 5%‐
TOTAL CASH & INVESTMENTS 110,088,067$ 110,088,067$
100%5,000,000
1,180,000
1% 20%1,530,141
20%3%
20%5%5,209,717
2,769,772
Institution
*Held in our safekeeping account at BNY Trust and Custody
Golf Interfund Loan
1% N/A
20%9%
20%4%
10,000,000
4,784,375
Page 10 of 38
Monthly Financial Report September 2013
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 ‐ ‐ ‐ ‐ 43,171 34,706 ‐
Grants / intergovernmental 5,849,491 ‐ 104,987 355 85 912,175 ‐
Charges for services 92,349 1,568,662 11,861,375 12,425,420 7,027,373 6,671,687 11,434,339
Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐
Fines and penalties 5,442 ‐ ‐ ‐ 535 ‐ ‐
Rents, leases, and misc fees 1,749,449 298,025 57,055 109,779 ‐ ‐ ‐
Interest and other misc 5,698 78,795 8,043 431,530 538,075 249,363 3,926
TOTAL REVENUES 7,702,429 1,945,482 12,031,460 12,967,084 7,609,239 7,867,931 11,438,265
EXPENSES:
Utility billing ‐ ‐ 87,297 88,514 63,581 103,513 ‐
Utility systems ‐ ‐ 11,575,489 3,972,292 2,175,377 2,429,970 ‐
Utility maintenance ‐ ‐ 219,725 3,485,106 921,466 1,519,244 10,735,412
Transportation 1,191,725 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 1,607,102 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 1,191,725 1,607,102 11,882,511 7,545,912 3,160,424 4,052,727 10,735,412
AMOUNT AVAILABLE FOR DEBT SERVICE 6,510,704 338,380 148,948 5,421,172 4,448,815 3,815,204 702,853
DEBT SERVICE:
Principal ‐ ‐ ‐ 664,925 565,383 63,340 ‐
Interest ‐ ‐ ‐ 348,144 180,798 146,868 ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ 1,013,069 746,181 210,208 ‐
CAPITAL PROJECTS 6,370,981 15,145 ‐ 2,780,601 1,830,432 1,308,077 ‐
TRANSFERS IN/(OUT)(13,499) ‐ ‐ 7,526 (3,763) (8,967) ‐
CHANGE IN FUND BALANCE 126,224 323,235 148,948 1,635,028 1,868,439 2,287,952 702,853
BEGINNING FUND BALANCE, Jan 1 2,342,924 539,814 1,523,881 9,846,308 3,196,734 6,014,474 1,745,887
ENDING FUND BALANCE, Sep 30 2,469,148 863,049 1,672,829 11,481,336 5,065,173 8,302,426 2,448,740
Page 11 of 38
Monthly Financial Report September 2013
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 ‐ 87,476 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental 83 ‐ ‐ ‐ ‐ ‐ 32,467
Charges for services
Equipment rental m&o 2,036,376 2,290,308 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 84,308 ‐ 300,516 ‐ ‐ ‐
Communications ‐ 4,545 73,834 382,050 ‐ ‐ ‐
Facilities ‐ ‐ 3,209,049 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 105,309 ‐ ‐ ‐ ‐ ‐
IT service co ntracts ‐ 329,114 ‐ ‐ ‐ ‐ ‐
Interest and other misc 8,540 4,117 2,144 662 24,267 15,117 13,677
Internal service fund misc:
Vehicle / equipment capital recovery 1,065,426 127,497 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 1,194,013 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 1,212,811 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 6,812,250 1,280,548
Other misc 6,131 11,853 9,128 ‐ 227 88,968 ‐
Interfund Loan ‐ ‐ ‐ ‐ 136,852 ‐ ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets 91,261 ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries 25,000 ‐ ‐ ‐ 72,592 7,820 ‐
TOTAL REVENUES 3,232,817 3,044,527 3,294,155 683,228 2,640,762 6,924,155 1,326,692
EXPENSES:
Communications 361,834
Equipment rental 1,770,396
Facilities 2,675,454
Healthcare 7,978,321
Information technology 2,401,808
Print and mail 280,039
Retiree healthcare 719,144
Risk management
Ri sk management 1,402,445
Unemployment 38,738
Worker's compensation 1,017,100
TOTAL EXPENSES 1,770,396 2,401,808 2,675,454 641,873 2,458,283 7,978,321 719,144
AMOUNT AVAILABLE FOR CAPITAL 1,462,421 642,719 618,701 41,355 182,479 (1,054,166) 607,548
CAPITAL PROJECTS 978,606 473,455 211,006 ‐ ‐ ‐ ‐
TRANSFERS IN 54,385 89,130 551 ‐ 2,000,000 ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 538,200 258,394 408,247 41,355 2,182,479 (1,054,166) 607,548
BEGINNING FUND BALANCE, Jan 1 3,722,501 1,856,972 849,472 303,477 4,986,807 7,899,070 6,482,165
ENDING FUND BALANCE, Sep 30 4,260,701 2,115,366 1,257,719 344,832 7,169,286 6,844,904 7,089,713
Page 12 of 38
Monthly Financial Report September 2013
FUND BALANCE
Page 14 shows the ending fund balance as of September 2013. 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 September, the City has $13 million reported in the combined general governmental fund balance of the
current year’s operating budget, which is approximately 12% of budgeted operating expenditures. This is a decrease of
$2.6 million from the year’s beginning balance. September’s ending fund balance is over the anticipated General
Governmental Fund Balance of $8.4 million by $4.6 million or 54.3%. Although the ending fund balance is above
projections, it is consistent with the prior years’ trends since the City receipted the first half of 2013 property taxes in
April/May and will receipt the second half in October/November.
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 38
Monthly Financial Report September 2013
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through September 30, 2013
Funds
Balance
01/01/2013
Budgeted
Revenue
Revenue
09/30/13
Total Funds
Available
Budgeted
Expenditure
Expenditure
09/30/13
Ending
Balance
GENERAL GOVERNMENT FUNDS:15,575,839 100,856,553 69,756,998 85,332,837 105,715,391 72,338,457 12,994,380
000 General 10,575,369 71,987,103 51,733,475 62,308,844 76,690,192 55,644,248 6,664,596
001 Community Services 1,891,966 11,328,945 7,606,266 9,498,232 11,325,011 8,188,706 1,309,526
003 Street 1,585,553 8,877,257 5,348,966 6,934,519 8,873,975 6,076,288 858,231
004 Community Dev Block Grant (13,145) 367,512 86,254 73,109 297,069 149,053 (75,944)
005 Museum 52,369 209,903 105,024 157,393 211,080 157,141 251
009 Farmers Market 90,520 59,400 45,399 135,919 80,414 40,277 95,643
011 Fire Health & Wellness 55,483 25,000 23,076 78,559 25,000 23,936 54,624
031 Park Memorial 178,367 ‐ 360 178,727 178,367 ‐ 178,727
201 Ltd GO Bonds Gen Govt Debt 829,784 1,749,305 877,260 1,707,044 1,749,305 134,500 1,572,544
215 Gen Govt Misc Debt Service 329,573 6,252,128 3,930,918 4,260,491 6,284,978 1,924,308 2,336,183
SPECIAL REVENUE FUNDS:
102 Arterial Street 168,514 643,000 459,805 628,319 600,000 ‐ 628,319
108 Leased City Properties 527,677 797,289 466,672 994,349 752,011 470,584 523,765
110 Hotel Motel 111,256 245,000 236,940 348,196 291,000 156,078 192,118
125 1% For Art 116,142 16,000 215 116,357 50,000 29,800 86,557
127 Cable Communication 257,372 85,674 79,256 336,628 85,674 40,515 296,113
135 Springbrook Wetlands Bank 665,828 ‐ 1,342 667,170 ‐ ‐ 667,170
CAPITAL PROJECT FUNDS (CIP):
303 Community Dev Mitigation 1,540,154 60,000 64,732 1,604,886 700,000 ‐ 1,604,886
304 Fire Mitigation 797,417 25,000 67,588 865,005 250,000 ‐ 865,005
305 Transportation Mitigation 292,627 40,000 177,212 469,839 100,000 ‐ 469,839
316 Municipal Facilities CIP 3,474,517 4,361,912 2,004,295 5,478,812 7,735,752 1,489,956 3,988,856
317 Transportation CIP (391,159) 34,020,559 19,421,692 19,030,533 33,608,158 15,619,069 3,411,464
318 So Lake WA Infrastructure Proj 52,073 44,874 44,907 96,980 96,947 87,974 9,006
326 Housing Opportunity 84,359 ‐ 181 84,540 75,000 ‐ 84,540
336 New Library Development 19,143,344 1,830,836 38,140 19,181,484 20,974,180 687,087 18,494,397
ENTERPRISE FUNDS:
402 Airport 331,939 1,264,418 1,848,917 2,180,856 1,432,346 1,119,080 1,061,776
403 Solid Waste Utility 1,523,881 15,700,852 12,031,460 13,555,341 16,177,073 11,882,512 1,672,829
404 Golf Course 291,978 2,453,669 1,944,956 2,236,934 2,476,366 1,647,159 589,775
422 Airport Capital 2,010,985 15,668,122 5,853,513 7,864,498 17,650,611 6,457,125 1,407,373
424 Golf Course Capital 247,836 50,000 38,024 285,860 156,482 12,587 273,273
INTERNAL SERVICE FUNDS:
501 Equipment Repair/Replacement 3,722,501 4,261,224 3,287,202 7,009,703 4,295,028 2,749,002 4,260,701
502 Insurance 4,986,807 5,713,764 4,640,763 9,627,570 3,060,718 2,458,282 7,169,288
503 Information Services 1,856,972 4,188,823 3,133,657 4,990,629 5,326,336 2,875,263 2,115,366
504 Facilities 849,472 4,276,112 3,294,707 4,144,179 4,468,879 2,886,460 1,257,719
505 Communications 303,477 877,773 683,228 986,705 893,249 641,873 344,832
512 Insurance, Healthcare 7,899,070 9,329,364 6,924,154 14,823,224 10,904,461 7,978,321 6,844,903
522 Insurance, Leoff1 Retirees HC 6,482,165 1,735,684 1,326,692 7,808,857 1,737,782 719,144 7,089,713
FIDUCIARY FUNDS:
611 Firemen's Pension 4,556,003 300,000 133,356 4,689,359 240,475 146,632 4,542,727
Funds
Balance
01/01/2013
Budgeted
Revenue
Revenue
09/30/13
Total Funds
Available
Budgeted
Expenditure
Expenditure
09/30/13
Ending
Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 20,803,403 57,384,364 39,890,045 60,693,448 60,603,334 33,395,774 27,297,674
405 Water Utility 5,449,029 13,402,096 11,680,947 17,129,976 11,034,019 7,158,280 9,971,696
406 Waste Water Utility 1,363,629 6,758,645 6,767,221 8,130,850 5,505,490 3,868,967 4,261,883
407 Surface Water Utility 2,269,771 7,963,326 6,538,428 8,808,199 6,180,122 3,627,112 5,181,087
416 King County Metro 1,745,887 15,126,703 11,438,265 13,184,152 15,126,703 10,735,412 2,448,740
425 Water Utility Construction 4,381,380 3,746,643 1,293,631 5,675,011 8,007,000 4,181,303 1,493,708
426 Waste Water Construction 1,833,105 3,300,000 842,018 2,675,123 4,870,000 1,871,834 803,289
427 Surface Water Construction 3,744,703 7,086,951 1,329,503 5,074,206 9,880,000 1,952,866 3,121,340
471 Waterworks Rate Stabilization 15,899 ‐ 32 15,931 ‐ ‐ 15,931
Note: Waterworks Utility Funds are managed as a system and are designated by the dotted lines.
Page 14 of 38
City of Renton
General Government Financial Position
2013 Budget Year
General Government Summary
Revenues Expenditures
$ Difference
over (under)
w/beginning
balance
15,575,839
January 5,592,172 7,563,322 (1,971,150) 13,604,689
February 11,590,564 15,996,818 (4,406,254) 11,169,585
March 17,392,180 23,413,342 (6,021,162) 9,554,677
April 33,559,062 31,631,530 1,927,532 17,503,371
May 46,893,848 39,883,684 7,010,164 22,586,003
June 52,007,692 48,473,829 3,533,864 19,109,703
July 58,496,912 56,535,685 1,961,227 17,537,066
August 64,000,182 64,579,234 (579,052) 14,996,787
September 69,756,998 72,338,457 (2,581,459) 12,994,380
October
November
December
1,000,000
2,000,000
3,000,000
4,000,000
5,000,000
6,000,000
7,000,000
8,000,000
70,000,000
80,000,000
90,000,000
100,000,000
110,000,000
Change in Fund
Balance
Rev/Exp Revenues
Expenditures
Change in Fund Balance
(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
‐
10,000,000
20,000,000
30,000,000
40,000,000
50,000,000
60,000,000
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Page 15 of 38
City of Renton
Monthly Revenue Analysis ‐ 2013 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 5,359,402 5,592,172 4.34%
Feb 11,478,844 11,590,564 0.97%
Mar 16,855,063 17,392,180 3.19%
Apr 31,092,707 33,559,062 7.93%
May 45,252,914 46,893,848 3.63%
Jun 50,278,277 52,007,692 3.44%
Jul 56,607,277 58,496,912 3.34%
Aug 61,667,555 64,000,182 3.78%
Sep 66,738,488 69,756,998 4.52%
Oct 79,945,341
Nov 93,727,155
Dec 100,856,553
Percent of budget 69.16%
YTD Annual %
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
Millions
Total Revenue
General Government
Budget
Actual
Last Year
$36
Millions Property Tax
Property Tax Budget Actual over (under)
Jan 218,452 154,945 ‐29.07%
Feb 457,054 179,965 ‐60.62%
Mar 1,204,989 1,097,866 ‐8.89%
Apr 9,657,654 10,985,190 13.75%
May 16,465,154 16,765,551 1.82%
Jun 16,534,715 16,854,032 1.93%
Jul 16,753,008 16,954,079 1.20%
Aug 16,766,628 17,012,180 1.46%
Sep 17,182,454 17,560,252 2.20%
Oct 24,590,798
Nov 31,416,250
Dec 31,741,366
Percent of budget 55.32%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
$36
Budget
Actual
Last Year
Page 16 of 38
City of Renton
Monthly Revenue Analysis ‐ 2013 Budget Year
Sales Tax Budget
YTD
Actual
Annual %
over (under)
Jan 1,585,548 1,812,385 14.31%
Feb 3,729,667 4,006,705 7.43%
Mar 5,270,744 5,725,296 8.62%
Apr 6,860,537 7,413,785 8.06%
May 8,668,156 9,351,345 7.88%
Jun 10,307,140 11,088,148 7.58%
Jul 11,940,419 12,931,683 8.30%
Aug 13,708,668 14,983,749 9.30%
Sep 15,384,395 16,931,533 10.06%
Oct 17,162,223
Nov 18,978,733
Dec 20,723,680
Percent of budget 81.70%
Note: Excludes CJ Sales Tax and Natural Gas Use Tax.
YTD Annual %
$‐
$3
$6
$9
$12
$15
$18
$21
Millions Sales Tax
Budget
Actual
Last Year
$16
Millions Utility Tax
Utility Tax Budget Actual over (under)
Jan 1,494,708 1,277,860 ‐14.51%
Feb 2,992,154 2,740,096 ‐8.42%
Mar 4,459,927 3,933,225 ‐11.81%
Apr 5,872,284 5,478,482 ‐6.71%
May 7,295,443 6,817,405 ‐6.55%
Jun 8,436,312 8,007,252 ‐5.09%
Jul 9,806,416 9,266,965 ‐5.50%
Aug 10,986,762 10,547,172 ‐4.00%
Sep 12,319,071 11,980,466 ‐2.75%
Oct 13,472,609
Nov 14,686,250
Dec 16,250,662
Percent of budget 73.72%
Note: Includes Natural Gas Use Tax.
$0
$2
$4
$6
$8
$10
$12
$14
$16
Budget
Actual
Last Year
Page 17 of 38
City of Renton
Monthly Revenue Analysis ‐ 2013 Budget Year
Licenses &
Permits Budget
YTD
Actual
Annual %
over (under)
Jan 219,854 325,005 47.83%
Feb 386,512 547,949 41.77%
Mar 577,616 747,996 29.50%
Apr 857,151 1,091,568 27.35%
May 1,039,941 1,368,619 31.61%
Jun 1,233,639 1,596,317 29.40%
Jul 1,546,609 1,891,884 22.32%
Aug 1,840,424 2,172,762 18.06%
Sep 1,982,247 2,348,691 18.49%
Oct 2,367,813
Nov 2,572,223
Dec 2,863,828
Percent of budget 82.01%
Note: Franchise Fees
YTD Annual % Millions
Intergovernmental
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
Millions Licenses & Permits
Budget
Actual
Last Year
Intergovt'l Budget Actual over (under)
Jan 479,441 565,532 17.96%
Feb 1,377,678 1,466,833 6.47%
Mar 1,687,937 1,933,705 14.56%
Apr 2,496,563 2,801,258 12.20%
May 4,899,480 5,218,611 6.51%
Jun 5,430,762 5,720,394 5.33%
Jul 6,203,725 6,584,190 6.13%
Aug 6,663,813 7,051,132 5.81%
Sep 7,108,467 7,575,466 6.57%
Oct 7,954,052
Nov 10,550,392
Dec 11,269,061
Percent of budget 67.22%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
$10
$11
$12
$13
Millions
Budget
Actual
Last Year
Page 18 of 38
City of Renton
Monthly Revenue Analysis ‐ 2013 Budget Year
Charges for
Services Budget
YTD
Actual
Annual %
over (under)
Jan 407,503 485,115 19.05%
Feb 859,916 1,051,174 22.24%
Mar 1,369,614 1,636,717 19.50%
Apr 1,960,890 2,321,588 18.39%
May 2,514,144 2,949,916 17.33%
Jun 3,065,252 3,543,866 15.61%
Jul 3,787,273 4,364,049 15.23%
Aug 4,478,128 5,084,872 13.55%
Sep 4,951,061 5,643,259 13.98%
Oct 5,499,477
Nov 5,985,046
Dec 6,520,566
Percent of budget 86.55%
Note: Excludes FD25 & FD40 contracts
Fines & YTD Annual %
$‐
$1
$2
$3
$4
$5
$6
$7
Millions Charges for Services
Budget
Actual
Last Year
Millions Fines & Forfeits
Forfeits Budget Actual over (under)
Jan 181,746 153,064 ‐15.78%
Feb 413,648 400,231 ‐3.24%
Mar 660,610 675,452 2.25%
Apr 940,197 993,688 5.69%
May 1,250,902 1,272,471 1.72%
Jun 1,563,488 1,541,804 ‐1.39%
Jul 1,840,824 1,778,375 ‐3.39%
Aug 2,012,121 1,949,941 ‐3.09%
Sep 2,188,195 2,104,545 ‐3.82%
Oct 2,468,378
Nov 2,719,947
Dec 3,058,500
Percent of budget 68.81%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Budget
Actual
Last Year
Page 19 of 38
City of Renton
Monthly Revenue Analysis ‐ 2013 Budget Year
Other Taxes Budget
YTD
Actual
Annual %
over (under)
Jan 609,070 638,523 4.84%
Feb 963,161 934,497 ‐2.98%
Mar 1,239,788 1,230,900 ‐0.72%
Apr 1,951,594 1,963,238 0.60%
May 2,504,949 2,520,946 0.64%
Jun 2,978,377 2,903,455 ‐2.52%
Jul 3,905,284 3,837,944 ‐1.72%
Aug 4,255,988 4,187,979 ‐1.60%
Sep 4,566,014 4,509,594 ‐1.24%
Oct 5,297,857
Nov 5,592,217
Dec 6,313,000
Percent of budget 71.43%
YTD Annual % Millions Miscellaneous
$0
$1
$2
$3
$4
$5
$6
$7
Millions Other Taxes
Budget
Actual
Last Year
Misc Budget Actual over (under)
Jan 163,080 179,743 10.22%
Feb 299,049 256,140 ‐14.35%
Mar 383,564 404,049 5.34%
Apr 495,399 496,921 0.31%
May 607,578 615,640 1.33%
Jun 721,417 739,082 2.45%
Jul 816,500 867,327 6.23%
Aug 947,776 989,980 4.45%
Sep 1,048,599 1,082,778 3.26%
Oct 1,124,055
Nov 1,180,896
Dec 1,861,022
Percent of budget 58.18%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80 Budget
Actual
Last Year
Page 20 of 38
City of Renton
Monthly Revenue Analysis ‐ 2013 Budget Year
Other
Financing Budget
YTD
Actual
Annual %
over (under)
Jan ‐ ‐ N/A
Feb 5 6,974 139374.80%
Mar 273 6,974 2454.48%
Apr 438 13,343 2946.36%
May 7,167 13,343 86.17%
Jun 7,177 13,343 85.91%
Jul 7,220 20,415 182.75%
Aug 7,248 20,415 181.66%
Sep 7,985 20,415 155.66%
Oct 8,079
Nov 45,201
Dec 254,868
Percent of budget 8.01%
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
Millions Other Financing Sources
Budget
Actual
Last Year
Page 21 of 38
City of Renton
Monthly Revenue Analysis ‐ 2013 Budget Year
REET Budget
YTD
Actual
Annual %
over (under)
Jan 71,786 134,099 86.80%
Feb 269,776 396,328 46.91%
Mar 458,016 624,405 36.33%
Apr 638,196 822,064 28.81%
May 872,560 1,108,012 26.98%
Jun 1,193,556 1,455,902 21.98%
Jul 1,358,006 1,719,709 26.63%
Aug 1,564,134 2,013,764 28.75%
Sep 1,724,294 2,268,082 31.54%
Oct 2,025,764
Nov 2,367,976
Dec 2,600,000
Percent of budget 87.23%
Bldg Permits &
Devlpmt Svc YTD Annual %
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
Millions
Real Estate Excise Tax
Budget
Actual
Last Year
Millions Building Permits and Development Service
Fees Budget Actual over (under)
Jan 150,030 327,644 118.39%
Feb 332,264 557,749 67.86%
Mar 569,542 862,909 51.51%
Apr 812,611 1,230,194 51.39%
May 1,049,592 1,616,989 54.06%
Jun 1,295,001 1,910,374 47.52%
Jul 1,573,793 2,225,870 41.43%
Aug 1,921,143 2,566,205 33.58%
Sep 2,075,833 2,821,074 35.90%
Oct 2,460,061
Nov 2,722,293
Dec 3,123,413
Percent of budget 90.32%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions Fees
Budget
Actual
Last Year
Page 22 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,463,801 7,563,322 1.33%
Feb 16,259,347 15,996,818 ‐1.61%
Mar 23,771,912 23,413,342 ‐1.51%
Apr 32,103,134 31,631,530 ‐1.47%
May 40,743,889 39,883,684 ‐2.11%
Jun 49,545,186 48,473,829 ‐2.16%
Jul 57,808,775 56,535,685 ‐2.20%
Aug 65,993,240 64,579,234 ‐2.14%
Sep 73,894,837 72,338,457 ‐2.11%
Oct 87,529,180
Nov 96,164,029
Dec 105,715,391
Percent of budget expended 68.43%
YTD Annual %
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
Millions
Total Expenditures
General Government
Budget
Actual
Last Year
$300 000
Legislative
Legislative Budget Actual over (under)
Jan 23,231 23,354 0.53%
Feb 47,551 47,686 0.28%
Mar 71,956 72,806 1.18%
Apr 95,878 97,646 1.84%
May 120,148 121,071 0.77%
Jun 144,309 145,113 0.56%
Jul 168,859 169,210 0.21%
Aug 192,896 192,361 ‐0.28%
Sep 217,082 216,073 ‐0.46%
Oct 241,441
Nov 265,573
Dec 290,291
Percent of budget expended 74.43%
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
Budget
Actual
Last Year
Page 23 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Executive Budget
YTD
Actual
Annual %
over (under)
Jan 84,700 78,944 ‐6.80%
Feb 190,135 186,330 ‐2.00%
Mar 296,151 297,118 0.33%
Apr 407,614 419,061 2.81%
May 516,918 528,321 2.21%
Jun 623,960 614,036 ‐1.59%
Jul 735,658 718,411 ‐2.34%
Aug 847,425 824,425 ‐2.71%
Sep 953,811 919,138 ‐3.64%
Oct 1,064,489
Nov 1,170,013
Dec 1,322,364
Percent of budget expended 69.51%
City Attorney Budget
YTD
Actual
Annual %
over (under)
Jan 155,027 141,744 ‐8.57%
Feb 314,005 285,967 ‐8.93%
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
Millions Executive
Budget
Actual
Last Year
$2.00
$2.40
Millions City Attorney
Budget
Actual
Last Year
Mar 472,262 427,953 ‐9.38%
Apr 633,182 584,735 ‐7.65%
May 787,132 724,478 ‐7.96%
Jun 947,880 872,824 ‐7.92%
Jul 1,105,337 1,013,090 ‐8.35%
Aug 1,263,381 1,157,082 ‐8.41%
Sep 1,421,095 1,315,727 ‐7.41%
Oct 1,593,003
Nov 1,749,576
Dec 1,915,103
Percent of budget expended 68.70%
$‐
$0.40
$0.80
$1.20
$1.60
Page 24 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Court Services Budget
YTD
Actual
Annual %
over (under)
Jan 161,056 152,280 ‐5.45%
Feb 321,721 310,767 ‐3.40%
Mar 485,078 468,698 ‐3.38%
Apr 650,782 643,564 ‐1.11%
May 824,039 795,263 ‐3.49%
Jun 1,016,165 978,124 ‐3.74%
Jul 1,185,948 1,141,510 ‐3.75%
Aug 1,354,731 1,302,458 ‐3.86%
Sep 1,519,505 1,468,967 ‐3.33%
Oct 1,684,389
Nov 1,852,716
Dec 2,026,149
Percent of budget expended 72.50%
YTD Annual %
$‐
$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
Millions
Community & Economic
Dl Ad iCED Admin Budget Actual over (under)
Jan 85,577 85,287 ‐0.34%
Feb 171,360 170,570 ‐0.46%
Mar 257,144 256,405 ‐0.29%
Apr 344,608 344,293 ‐0.09%
May 428,940 428,857 ‐0.02%
Jun 513,272 514,481 0.24%
Jul 597,689 600,318 0.44%
Aug 682,197 685,933 0.55%
Sep 766,581 771,885 0.69%
Oct 850,349
Nov 934,318
Dec 1,020,208
Percent of budget expended 75.66%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Millions Development Admin
Budget
Actual
Last Year
Page 25 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Development
Services Budget
YTD
Actual
Annual %
over (under)
Jan 267,446 272,362 1.84%
Feb 540,517 515,474 ‐4.63%
Mar 813,155 768,135 ‐5.54%
Apr 1,086,172 1,060,776 ‐2.34%
May 1,379,682 1,319,207 ‐4.38%
Jun 1,645,056 1,589,997 ‐3.35%
Jul 1,929,849 1,867,544 ‐3.23%
Aug 2,201,921 2,165,714 ‐1.64%
Sep 2,488,019 2,425,328 ‐2.52%
Oct 2,780,951
Nov 3,065,780
Dec 3,358,299
Percent of budget expended 72.22%
Economic YTD Annual %
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions
Development Services
Budget
Actual
Last Year
Millions
Economic Development
Development Budget Actual over (under)
Jan 54,655 75,717 38.54%
Feb 109,521 81,391 ‐25.68%
Mar 155,477 109,135 ‐29.81%
Apr 198,321 146,523 ‐26.12%
May 246,022 175,487 ‐28.67%
Jun 290,316 211,913 ‐27.01%
Jul 339,634 254,764 ‐24.99%
Aug 384,572 300,522 ‐21.86%
Sep 428,840 341,333 ‐20.41%
Oct 472,869
Nov 524,583
Dec 570,280
Percent of budget expended 59.85%
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
Millions
Budget
Actual
Last Year
Page 26 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Planning Budget
YTD
Actual
Annual %
over (under)
Jan 118,936 112,247 ‐5.62%
Feb 265,596 237,260 ‐10.67%
Mar 381,868 350,721 ‐8.16%
Apr 509,685 480,129 ‐5.80%
May 630,402 603,248 ‐4.31%
Jun 748,996 728,944 ‐2.68%
Jul 870,176 856,640 ‐1.56%
Aug 1,024,050 993,017 ‐3.03%
Sep 1,159,558 1,133,145 ‐2.28%
Oct 1,279,389
Nov 1,405,692
Dec 1,541,592
Percent of budget expended 73.50%
YTD Annual % $2 40
Millions Finance
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
Millions
Planning
Budget
Actual
Last Year
Finance Budget Actual over (under)
Jan 158,336 144,010 ‐9.05%
Feb 323,142 284,066 ‐12.09%
Mar 485,519 437,042 ‐9.98%
Apr 646,871 610,911 ‐5.56%
May 815,548 775,564 ‐4.90%
Jun 991,610 942,750 ‐4.93%
Jul 1,157,861 1,123,823 ‐2.94%
Aug 1,335,063 1,312,345 ‐1.70%
Sep 1,499,653 1,491,143 ‐0.57%
Oct 1,643,469
Nov 1,786,254
Dec 2,242,682
Percent of budget expended 66.49%
$‐
$0.40
$0.80
$1.20
$1.60
$2.00
$2.40 Budget
Actual
Last Year
Page 27 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
City Clerk Budget
YTD
Actual
Annual %
over (under)
Jan 72,010 61,226 ‐14.97%
Feb 144,148 123,564 ‐14.28%
Mar 223,753 202,364 ‐9.56%
Apr 361,399 277,252 ‐23.28%
May 435,793 581,575 33.45%
Jun 507,931 636,188 25.25%
Jul 710,263 692,263 ‐2.53%
Aug 788,236 765,703 ‐2.86%
Sep 863,409 830,214 ‐3.84%
Oct 937,218
Nov 1,017,649
Dec 1,101,505
Percent of budget expended 75.37%
Includes Hearing Examiner
Human YTD Annual % $1 00
Millions Human Resources
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Millions City Clerk
Budget
Actual
Last Year
Resources Budget Actual over (under)
Jan 83,400 64,230 ‐22.99%
Feb 161,123 134,784 ‐16.35%
Mar 240,261 212,385 ‐11.60%
Apr 311,770 288,203 ‐7.56%
May 382,831 357,200 ‐6.70%
Jun 469,447 439,470 ‐6.39%
Jul 552,148 510,868 ‐7.48%
Aug 635,001 583,333 ‐8.14%
Sep 713,975 658,189 ‐7.81%
Oct 797,946
Nov 885,037
Dec 977,094
Percent of budget expended 67.36%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
Budget
Actual
Last Year
Page 28 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Police Budget
YTD
Actual
Annual %
over (under)
Jan 2,428,964 2,521,995 3.83%
Feb 4,822,823 4,737,466 ‐1.77%
Mar 7,238,322 7,196,803 ‐0.57%
Apr 9,709,330 9,460,145 ‐2.57%
May 11,923,689 11,645,035 ‐2.34%
Jun 14,548,208 14,265,277 ‐1.94%
Jul 17,149,272 16,827,604 ‐1.88%
Aug 19,396,212 19,071,306 ‐1.68%
Sep 21,809,144 21,624,322 ‐0.85%
Oct 24,138,751
Nov 26,546,714
Dec 29,129,201
Percent of budget expended 74.24%
Fire &
Emergency YTD Annual %
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
Millions Police
Budget
Actual
Last Year
$24
Millions Fire & Emergency Services
Services Budget Actual over (under)
Jan 1,889,418 2,045,002 8.23%
Feb 4,533,817 4,729,656 4.32%
Mar 6,447,897 6,673,347 3.50%
Apr 8,338,322 8,636,731 3.58%
May 10,511,037 10,518,427 0.07%
Jun 12,419,816 12,459,420 0.32%
Jul 14,337,761 14,457,407 0.83%
Aug 16,384,640 16,390,199 0.03%
Sep 18,359,431 18,346,018 ‐0.07%
Oct 20,275,751
Nov 22,207,188
Dec 24,197,056
Percent of budget expended 75.82%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
Budget
Actual
Last Year
Page 29 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Community
Services Admin Budget
YTD
Actual
Annual %
over (under)
Jan 38,606 37,025 ‐4.09%
Feb 74,909 74,364 ‐0.73%
Mar 111,787 111,667 ‐0.11%
Apr 148,344 150,854 1.69%
May 185,868 187,590 0.93%
Jun 222,528 225,313 1.25%
Jul 259,410 262,830 1.32%
Aug 295,998 299,975 1.34%
Sep 332,176 336,859 1.41%
Oct 367,946
Nov 405,451
Dec 450,911
Percent of budget expended 74.71%
YTD Annual % $4 50
Millions Parks
$‐
$0.05
$0.10
$0.15
$0.20
$0.25
$0.30
$0.35
$0.40
$0.45
$0.50
Millions Community Services Admin
Budget
Actual
Last Year
Parks Budget Actual over (under)
Jan 284,059 269,811 ‐5.02%
Feb 571,759 563,088 ‐1.52%
Mar 881,042 851,150 ‐3.39%
Apr 1,213,451 1,192,965 ‐1.69%
May 1,544,269 1,515,905 ‐1.84%
Jun 1,894,848 1,862,252 ‐1.72%
Jul 2,261,158 2,236,956 ‐1.07%
Aug 2,638,492 2,631,293 ‐0.27%
Sep 3,030,537 3,002,198 ‐0.94%
Oct 3,420,829
Nov 3,789,095
Dec 4,153,621
Percent of budget expended 72.28%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50 Budget
Actual
Last Year
Page 30 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Parks Planning
and Natural
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 58,219 42,639 ‐26.76%
Feb 117,758 88,359 ‐24.97%
Mar 193,484 142,461 ‐26.37%
Apr 264,742 196,871 ‐25.64%
May 353,686 258,947 ‐26.79%
Jun 439,691 310,633 ‐29.35%
Jul 513,977 370,751 ‐27.87%
Aug 589,503 428,676 ‐27.28%
Sep 673,988 484,402 ‐28.13%
Oct 766,574
Nov 852,923
Dec 934,005
Percent of budget expended 51.86%
YTD Annual %
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
$0.70
$0.80
$0.90
$1.00
Millions Parks Planning and Natural Resources
Budget
Actual
Last Year
$6
Millions Recreation
Recreation Budget Actual over (under)
Jan 343,076 305,989 ‐10.81%
Feb 697,923 650,023 ‐6.86%
Mar 1,060,652 1,002,907 ‐5.44%
Apr 1,435,547 1,371,571 ‐4.46%
May 1,810,378 1,698,203 ‐6.20%
Jun 2,195,700 2,075,334 ‐5.48%
Jul 2,787,526 2,696,025 ‐3.28%
Aug 3,446,454 3,343,858 ‐2.98%
Sep 3,960,958 3,822,962 ‐3.48%
Oct 4,343,623
Nov 4,714,526
Dec 5,130,300
Percent of budget expended 74.52%
$‐
$1
$2
$3
$4
$5
$6
Budget
Actual
Last Year
Page 31 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Human
Services Budget
YTD
Actual
Annual %
over (under)
Jan 55,141 45,984 ‐16.61%
Feb 122,303 128,054 4.70%
Mar 217,326 218,002 0.31%
Apr 381,767 340,261 ‐10.87%
May 479,318 431,038 ‐10.07%
Jun 542,375 496,606 ‐8.44%
Jul 674,923 628,351 ‐6.90%
Aug 744,460 695,514 ‐6.57%
Sep 805,315 749,137 ‐6.98%
Oct 959,873
Nov 1,030,967
Dec 1,196,052
Percent of budget expended 62.63%
Neighborhoods
, Resources, YTD Annual %
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Millions Human Services
Budget
Actual
Last Year
$1 00
Millions Neighborhoods, Resources, and Events
and Events Budget Actual over (under)
Jan 55,854 56,917 1.90%
Feb 109,166 108,774 ‐0.36%
Mar 172,916 171,351 ‐0.91%
Apr 236,903 231,744 ‐2.18%
May 298,441 288,076 ‐3.47%
Jun 378,699 362,006 ‐4.41%
Jul 470,110 447,998 ‐4.70%
Aug 555,842 518,531 ‐6.71%
Sep 632,165 582,563 ‐7.85%
Oct 703,188
Nov 803,370
Dec 914,955
Percent of budget expended 63.67%
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
$0.70
$0.80
$0.90
$1.00
Budget
Actual
Last Year
Page 32 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Library Fund Budget
YTD
Actual
Annual %
over (under)
Jan ‐ ‐ N/A
Feb ‐ ‐ N/A
Mar ‐ ‐ N/A
Apr ‐ ‐ N/A
May ‐ ‐ N/A
Jun ‐ ‐ N/A
Jul ‐ ‐ N/A
Aug ‐ ‐ N/A
Sep ‐ ‐ N/A
Oct ‐
Nov ‐
Dec ‐
Percent of budget expended N/A
YTD Annual %
$‐
$0.05
$0.10
$0.15
$0.20
$0.25
$0.30
Millions Library Fund
Budget
Actual
Last Year
$240 000
Museum Fund
Museum Fund Budget Actual over (under)
Jan 17,250 16,898 ‐2.04%
Feb 34,747 34,090 ‐1.89%
Mar 52,190 51,213 ‐1.87%
Apr 69,816 69,807 ‐0.01%
May 87,358 87,136 ‐0.25%
Jun 105,057 104,728 ‐0.31%
Jul 122,568 122,060 ‐0.41%
Aug 140,200 139,638 ‐0.40%
Sep 158,058 157,141 ‐0.58%
Oct 175,778
Nov 193,585
Dec 211,080
Percent of budget expended 74.45%
$‐
$30,000
$60,000
$90,000
$120,000
$150,000
$180,000
$210,000
$240,000
Budget
Actual
Last Year
Page 33 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Public Works
Admin Budget
YTD
Actual
Annual %
over (under)
Jan 40,394 39,971 ‐1.05%
Feb 80,618 79,912 ‐0.88%
Mar 120,971 119,866 ‐0.91%
Apr 161,356 163,297 1.20%
May 201,472 202,081 0.30%
Jun 241,508 237,314 ‐1.74%
Jul 281,724 269,323 ‐4.40%
Aug 322,247 301,882 ‐6.32%
Sep 363,226 333,688 ‐8.13%
Oct 402,909
Nov 442,662
Dec 483,035
Percent of budget expended 69.08%
Street YTD Annual %
$‐
$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
$5 00
Millions Street Maintenance
Maintenance Budget Actual over (under)
Jan 333,344 302,270 ‐9.32%
Feb 713,983 641,518 ‐10.15%
Mar 1,077,703 937,528 ‐13.01%
Apr 1,405,768 1,294,196 ‐7.94%
May 1,756,371 1,600,743 ‐8.86%
Jun 2,128,477 1,924,036 ‐9.61%
Jul 2,485,951 2,229,390 ‐10.32%
Aug 2,826,956 2,532,782 ‐10.41%
Sep 3,174,309 2,856,379 ‐10.02%
Oct 3,531,791
Nov 3,898,668
Dec 4,294,894
Percent of budget expended 66.51%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
Budget
Actual
Last Year
Page 34 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Transportation Budget
YTD
Actual
Annual %
over (under)
Jan 299,590 311,908 4.11%
Feb 677,729 670,659 ‐1.04%
Mar 1,055,244 1,074,529 1.83%
Apr 1,434,200 1,512,690 5.47%
May 1,803,617 1,819,302 0.87%
Jun 2,165,731 2,113,464 ‐2.41%
Jul 2,562,459 2,490,033 ‐2.83%
Aug 2,933,871 2,933,793 0.00%
Sep 3,312,264 3,219,909 ‐2.79%
Oct 3,700,291
Nov 4,085,694
Dec 4,579,081
Percent of budget expended 70.32%
YTD Annual % $10
Millions Debt Service
$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
Debt Service Budget Actual over (under)
Jan ‐ ‐ N/A
Feb 250,317 250,317 0.00%
Mar 250,317 250,317 0.00%
Apr 835,676 835,676 0.00%
May 835,676 835,676 0.00%
Jun 1,776,589 1,776,589 0.00%
Jul 1,808,239 1,808,239 0.00%
Aug 2,058,556 2,058,556 0.00%
Sep 2,058,808 2,058,808 0.00%
Oct 6,695,236
Nov 7,364,759
Dec 8,034,283
Percent of budget expended 25.63%
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
$10
Budget
Actual
Last Year
Page 35 of 38
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Non‐
Departmental
Other City Budget
YTD
Actual
Annual %
over (under)
Jan 355,512 355,512 0.00%
Feb 862,677 862,677 0.00%
Mar 1,009,438 1,009,438 0.00%
Apr 1,221,630 1,221,630 0.00%
May 2,385,254 2,385,254 0.00%
Jun 2,587,016 2,587,016 0.00%
Jul 2,740,276 2,740,276 0.00%
Aug 2,950,337 2,950,337 0.00%
Sep 3,192,930 3,192,930 0.00%
Oct 4,701,125
Nov 5,171,238
Dec 5,641,350
Percent of budget expended 56.60%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
$5.50
$6.00
Millions Non‐Departmental Other City Services
Budget
Actual
Last Year
Page 36 of 38
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2013 Budget Year
Utilities Budget Revenue Expense
Jan 3,829,376 5,451,016 3,091,235
Feb 8,589,616 10,484,839 7,162,971
Mar 13,047,174 16,704,949 12,742,494
Apr 17,968,338 21,897,618 17,525,965
May 22,562,679 27,540,401 22,717,408
Jun 29,148,341 33,144,751 28,759,364
Jul 35,053,685 39,459,369 34,603,156
Aug 40,236,656 46,050,162 39,527,809
Sep 45,248,315 51,921,474 45,278,284
Oct 51,131,985
Nov 56,094,010
Dec 76,780,407
Percent of budget expended 59.55%
Note: Operations and Capital
$0
$10
$20
$30
$40
$50
$60
$70
$80
$90
Millions Utilities
Budget
Revenue
Expense
$25 00
Millions Airport
Airport Budget Revenue Expense
Jan 952,240 197,380 132,655
Feb 2,122,025 816,583 272,568
Mar 3,125,407 1,033,561 551,940
Apr 4,353,586 1,326,892 679,773
May 5,959,035 1,542,344 1,344,469
Jun 8,128,195 2,240,528 2,131,340
Jul 9,129,859 3,029,040 3,486,489
Aug 10,602,682 4,424,167 7,184,207
Sep 11,598,621 7,702,430 7,576,205
Oct 13,711,677
Nov 14,718,494
Dec 19,082,957
Percent of budget expended 39.70%
Note: Operations and Capital
$‐
$5.00
$10.00
$15.00
$20.00
$25.00
Budget
Revenue
Expense
Page 37 of 38
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2013 Budget Year
Golf Course Budget Revenue Expense
Jan 138,483 59,391 129,801
Feb 283,549 161,197 254,957
Mar 587,345 291,654 404,017
Apr 749,859 505,367 579,467
May 958,900 747,089 721,090
Jun 1,133,021 1,010,936 914,581
Jul 1,331,819 1,404,992 1,099,310
Aug 1,513,051 1,694,229 1,422,736
Sep 1,688,936 1,982,981 1,659,746
Oct 1,864,635
Nov 2,024,142
Dec 2,632,848
Percent of budget expended 63.04%
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 38 of 38