HomeMy WebLinkAbout201212, December.pdfADMINISTRATIVE SERVICES
DEPARTMENT
M E M O R A N D U M
DATE: February 12, 2013
TO: Randy Corman, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: December 2012 Financial Status Report
At the end of December, general governmental revenues show $2.2 million or 2.1% over
budget. Revenues sources that are higher than expected are: property taxes ($570k); sales tax
($701k); sales tax annexation credit ($107k); gambling taxes ($91k); building permits &
development service fees ($935k); intergovernmental ($207k); interest and other earnings
($217k); rents leases and concessions ($121k); and other miscellaneous ($137k). On the down
side, the revenue sources that are underperforming the year to date budget are: admission tax
($39k below); franchise fees ($61k below); utility taxes ($201k below); EMS levy ($122k below);
culture and recreation fees ($167k below); interfund/inter‐departmental services ($305k
below); and fines and forfeitures ($154k below).
General government expenditures showed favourable variance of $2.8 million or 2.7%. 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,955,285$ 11,955,285$ 11,407,119$ 11,407,119$ 11,057,551$ 11,057,551$ 11,057,551$ ‐ 0.0%
OPERATING REVENUES
Property Tax 31,497,128 31,497,128 32,357,894 32,357,894 32,896,746 32,896,746 33,466,364 569,618 1.7%
Sales Tax 17,198,220 17,198,220 17,729,731 17,729,731 17,864,000 17,864,000 18,564,670 700,670 3.9%
Sales Tax ‐ Annexation Credit 2,025,660 2,025,660 2,033,954 2,033,954 2,101,647 2,101,647 2,208,492 106,845 5.1%
Criminal Justice Sales Tax 1,620,479 1,620,479 1,809,757 1,809,757 1,867,145 1,867,145 1,924,470 57,325 3.1%
Natural Gas Use Tax 228,514 228,514 249,407 249,407 270,394 270,394 272,530 2,136 0.8%
Admission Tax 291,399 291,399 308,200 308,200 350,000 350,000 311,054 (38,946) ‐11.1%
Franchise Fees 1,222,444 1,222,444 1,234,448 1,234,448 1,323,000 1,323,000 1,262,188 (60,812) ‐4.6%
Electricity Tax 5,036,907 5,036,907 5,166,711 5,166,711 5,283,280 5,283,280 5,211,111 (72,169) ‐1.4%
Natural Gas Utility Tax 1,577,756 1,577,756 1,848,806 1,848,806 1,950,000 1,950,000 1,669,967 (280,033) ‐14.4%
Transfer Station 269,912 269,912 297,474 297,474 248,762 248,762 330,607 81,845 32.9%
TV Cable 1,296,744 1,296,744 1,385,275 1,385,275 1,427,679 1,427,679 1,423,664 (4,015) ‐0.3%
Telephone 1,038,009 1,038,009 966,827 966,827 1,000,000 1,000,000 1,056,420 56,420 5.6%
Cellular Phone 2,206,637 2,206,637 2,054,183 2,054,183 2,309,360 2,309,360 2,183,853 (125,507) ‐5.4%
City Utilities 2,853,884 2,853,884 3,516,179 3,516,179 3,665,728 3,665,728 3,806,281 140,553 3.8%
Leasehold Excise Tax 138,830 138,830 162,593 162,593 145,000 145,000 158,849 13,849 9.6%
Gambling Excise Tax 1,546,386 1,546,386 1,671,414 1,671,414 1,600,000 1,600,000 1,691,209 91,209 5.7%
Real Estate Excise Tax 2,464,489 2,464,489 2,074,059 2,074,059 2,767,521 2,767,521 2,811,902 44,381 1.6%
Less: Municipal Facilities CIP REET (400,000) (400,000) (400,000) (400,000) (943,588) (943,588) (943,792) (204) 0.0%
EMS Levy 1,161,114 1,161,114 868,873 868,873 1,007,976 1,007,976 885,781 (122,195) ‐12.1%
Business License Fees 431,782 431,782 442,451 442,451 469,817 469,817 444,680 (25,137) ‐5.4%
Other Licenses and Permits 262,629 262,629 232,534 232,534 213,305 213,305 242,668 29,363 13.8%
Building Permits & Development Svc Fees 2,437,270 2,437,270 2,772,779 2,772,779 2,466,063 2,466,063 3,401,537 935,474 37.9%
Intergovt'l (Grants, State Shared, etc) 4,426,676 4,426,676 4,737,323 4,737,323 4,590,195 4,590,195 4,593,185 2,990 0.1%
Fire District 25 and 40 Contracts 5,252,877 5,252,877 6,110,668 6,110,668 6,008,694 6,008,694 6,155,621 146,927 2.4%
Public Safety 482,343 482,343 484,985 484,985 430,635 430,635 485,899 55,264 12.8%
Culture and Recreation 1,424,932 1,424,932 1,493,540 1,493,540 1,660,863 1,660,863 1,494,165 (166,698) ‐10.0%
Interfund/Interdept‐Services 3,190,908 3,190,908 3,070,506 3,070,506 3,617,185 3,617,185 3,311,715 (305,470) ‐8.4%
Fi nes and Forfeits 1,291,817 1,291,817 1,163,602 1,163,602 1,088,750 1,088,750 1,046,246 (42,504) ‐3.9%
Photo Enforcement 1,925,159 1,925,159 1,897,782 1,897,782 1,944,713 1,944,713 1,976,203 31,490 1.6%
Seizure Funds ‐ Federal/State/Local 221,046 221,046 83,220 83,220 180,693 180,693 37,941 (142,752) ‐79.0%
Interests and Other Earnings 183,511 183,511 107,183 107,183 125,400 125,400 342,424 217,024 173.1%
Rents, Leases, and Concessions 727,338 727,338 744,834 744,834 701,464 701,464 822,428 120,964 17.2%
Contributions and Donations 133,756 133,756 196,586 196,586 84,060 84,060 124,082 40,022 47.6%
Other Miscellaneous 434,286 434,286 529,147 529,147 427,358 427,358 564,571 137,213 32.1%
Other Financing Sources (Transfer‐In, etc) 653,595 653,595 1,073,507 1,073,507 2,773,886 2,773,886 2,803,188 29,302 1.1%
Total Operating Revenues 96,754,435 96,754,435 100,476,431 100,476,431 103,917,730 103,917,730 106,142,170 2,224,440 2.1%
OPERATING EXPENDITURES
Legislative 259,345 259,345 271,236 271,236 284,087 284,087 278,768 5,319 1.9%
Executive 1,578,526 1,578,526 1,566,906 1,566,906 1,468,694 1,468,694 1,377,109 91,585 6.2%
Hearing Examiner 174,447 174,447 59,878 59,878 71,025 71,025 60,368 10,657 15.0%
City Attorney 1,565,597 1,565,597 1,596,609 1,596,609 1,733,686 1,733,686 1,706,320 27,366 1.6%
Court Services 2,007,599 2,007,599 2,084,170 2,084,170 2,155,819 2,155,819 2,074,980 80,839 3.7%
Community and Eco Dvlpmnt Admin 579,396 579,396 929,814 929,814 952,912 952,912 942,071 10,841 1.1%
Development Services 2,946,413 2,946,413 2,810,736 2,810,736 3,434,929 3,434,929 3,103,568 331,361 9.6%
Economic Development 1,293,536 1,293,536 659,981 659,981 676,136 676,136 529,043 147,093 21.8%
Planning 1,774,508 1,774,508 1,447,781 1,447,781 1,516,719 1,516,719 1,482,233 34,486 2.3%
Finance 2,214,458 2,214,458 2,134,667 2,134,667 2,161,836 2,161,836 2,221,882 (60,046) ‐2.8%
City Clerk 789,209 789,209 736,880 736,880 1,002,105 1,002,105 937,067 65,039 6.5%
Human Resources 861,221 861,221 888,252 888,252 946,956 946,956 937,412 9,544 1.0%
Police 23,946,386 23,946,386 24,737,346 24,737,346 25,253,049 25,253,049 25,004,580 248,470 1.0%
Jail Services 3,539,035 3,539,035 6,206,735 6,206,735 4,315,888 4,315,888 3,489,616 826,272 19.1%
Fire 21,554,792 21,554,792 22,511,597 22,511,597 24,259,367 24,259,367 24,173,315 86,052 0.4%
Community Services Admin 1 1,063,011 1,063,011 416,284 416,284 421,043 421,043 434,558 (13,515) ‐3.2%
Parks 3,421,424 3,421,424 3,829,676 3,829,676 4,045,762 4,045,762 4,004,054 41,708 1.0%
Parks Planning & Natural Resources 448,574 448,574 551,423 551,423 685,122 685,122 577,934 107,188 15.6%
Recreation 4,433,420 4,433,420 4,974,002 4,974,002 5,276,859 5,276,859 4,982,229 294,630 5.6%
Human Services 1,326,778 1,326,778 1,247,294 1,247,294 1,298,201 1,298,201 1,193,871 104,330 8.0%
Neighborhoods, Resources, & Events 359,690 359,690 675,534 675,534 775,917 775,917 701,673 74,243 9.6%
Library 2,289,692 2,289,692 2,030,000 2,030,000 278,603 278,603 278,604 (1) 0.0%
Museum 191,090 191,090 210,620 210,620 213,533 213,533 216,887 (3,354) ‐1.6%
Public Works Admin 1 514,858 514,858 452,538 452,538 465,889 465,889 470,051 (4,161) ‐0.9%
Street Maintenance 3,412,892 3,412,892 3,534,025 3,534,025 3,728,945 3,728,945 3,755,640 (26,695) ‐0.7%
Transportation 5,215,309 5,215,309 4,509,066 4,509,066 4,763,972 4,763,972 4,615,160 148,812 3.1%
Debt Service 4,707,100 4,707,100 4,822,566 4,822,566 7,556,084 7,556,084 7,437,337 118,747 1.6%
Non‐Departmental and Other 4,834,296 4,834,296 4,930,383 4,930,383 4,660,315 4,660,315 4,637,555 22,760 0.5%
Total Operating Expenditures 97,302,601 97,302,601 100,825,999 100,825,999 104,403,452 104,403,452 101,623,882 2,779,570 2.7%
Total Ending Fund Balance 11,407,119$ 11,407,119$ 11,057,551$ 11,057,551$ 10,571,829$ 10,571,829$ 15,575,840$ 5,004,011$ 47.3%
1Facilities was included in Community Services Admin and Technical Services was included in Public Works Admin in 2010
Favourable (Unfavourable)
2010 2011 2012 Variance
Annual Actual YTD Actual Annual Budget YTD Budget YTD ActualSummary of Sources and Uses Annual Actual YTD Actual
Monthly Financial Report December 2012
Page 1 of 37
Monthly Financial Report December 2012
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through December 31, 2012. 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 72% of
all resources supporting general governmental activities. The following section provides detail information on property,
sales, utility, and other taxes.
Property Tax
December’s collection is $365k, making
the total year‐to‐date collection $33.5
million or 102% of the total budget. In
comparison to the previous year, the City
collected $1.1 million or 3% more.
Compared to the budget, the City is
above projections by $570k or 2%.
2012’s monthly budgets are based on
2009 through 2011 collections. The
October/November variance from the
prior year and budget is due the timing
of collections. An estimated $2.8 million
of November 2012’s collection was
receipted in October 2012. If these two months are combined, the City is on track with the monthly budgets.
Sales Tax
December 2012 sales tax receipts totalled
$1.6 million. Compared with the same
month last year, it is $201k or 14% more.
Compared to the projected current
month’s budget, it is $157k or 11% above.
The year‐to‐date collection of $18.6
million is $835k or 5% more than the prior
year and is also $701k or 4% more than
budgeted.
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 505,501$ 255,343$ 149,112$ (356,390)$ ‐71% (106,231)$ ‐42%
Feb 336,193 316,911 85,577 (250,616) ‐75% (231,334) ‐73%
Mar 745,285 675,495 880,380 135,094 18% 204,885 30%
Apr 7,618,492 7,776,464 10,012,008 2,393,515 31% 2,235,544 29%
May 7,849,481 8,109,059 6,131,450 (1,718,030) ‐22% (1,977,609) ‐24%
Jun 54,963 98,578 43,203 (11,760) ‐21% (55,375) ‐56%
Jul 112,076 106,083 346,717 234,641 209% 240,634 227%
Aug 25,954 84,126 48,857 22,903 88% (35,269) ‐42%
Sep 467,946 421,108 545,753 77,807 17% 124,645 30%
Oct 7,014,860 6,907,167 9,734,384 2,719,524 39% 2,827,217 41%
Nov 7,348,025 7,974,601 5,123,725 (2,224,301) ‐30% (2,850,877) ‐36%
Dec 279,117 171,812 365,200 86,083 31% 193,388 113%
YTD Total 32,357,894$ 32,896,746$ 33,466,364$ 1,108,470$ 3% 569,618$ 2%
Annual Total 32,357,894$ 32,896,746$
Property Tax Revenues
Year to Date through December
2012 vs. 2011 2012 vs. Budget
Month
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 1,339,658$ 1,388,527$ 1,327,548$ (12,111)$ ‐1% (60,980)$ ‐4%
Feb 1,982,269 1,787,327 1,923,714 (58,556) ‐3% 136,386 8%
Mar 1,299,237 1,372,298 1,303,820 4,583 0% (68,478) ‐5%
Apr 1,254,867 1,391,509 1,370,731 115,864 9% (20,778) ‐1%
May 1,590,780 1,578,875 1,599,184 8,403 1% 20,309 1%
Jun 1,368,213 1,422,596 1,482,794 114,580 8% 60,197 4%
Jul 1,437,859 1,411,637 1,505,142 67,283 5% 93,504 7%
Aug 1,534,218 1,522,536 1,583,903 49,685 3% 61,368 4%
Sep 1,472,399 1,468,712 1,472,566 167 0% 3,854 0%
Oct 1,517,444 1,529,207 1,660,941 143,496 9% 131,734 9%
Nov 1,508,954 1,522,978 1,709,049 200,095 13% 186,071 12%
Dec 1,423,832 1,467,796 1,625,280 201,448 14% 157,484 11%
YTD Total 17,729,731$ 17,864,000$ 18,564,670$ 834,939$ 5% 700,670$ 4%
Annual Total 17,729,731$ 17,864,000$
2012 vs. Budget2012 vs. 2011
Month
Year to Date through December
Local Retail Sales Tax Revenues
Page 2 of 37
Monthly Financial Report December 2012
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 2011 2012 Bgt YTD Act Change 2012/2011 2012 Act vs Bgt
New Construction 1,576,127$ 1,654,934$ 1,844,545$ 268,417$ 17%$ 189,611 11%
Auto Sales 3,179,418 3,497,360 3,361,196 181,778 6% (136,164)‐4%
General Retail 6,070,498 6,292,222 6,482,942 412,444 7% 190,720 3%
Manufacturing 1,073,075 724,326 1,043,859 (29,216) ‐3% 319,533 44%
Wholesale 1,148,656 1,183,120 1,169,431 20,775 2% (13,688)‐1%
Service 3,960,151 4,078,955 4,221,446 261,295 7% 142,491 3%
Other 721,805 433,083 441,252 (280,554) ‐39% 8,168 2%
Total 17,729,731$ 17,864,000$ 18,564,670$ 834,939$ 5%700,670$ 4%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility tax
December utility tax revenues are $1.5
million, which is $167k or 12% higher
than the same month last year and is
also ahead of the budget by $113k or 8%.
The year‐to‐date collection is $16 million,
which is $470k or 3% higher than the
prior year but is $201k or 1% lower than
the budget.
The table below breaks out Utility Tax by source. The Natural Gas variance is due to warmer weather year‐to‐date than the
prior year.
Utility Tax by Type 2011 2012 Bgt YTD Act Change 2012/2011 2012 Act vs Bgt
Electrical 5,166,711$ 5,283,280$ 5,211,111$ 44,400$ 1%$ (72,169)‐1%
Natural Gas 2,098,213 2,220,394 1,942,497 (155,716) ‐7% (277,897)‐13%
Cell 2,054,183 2,309,360 2,183,853 129,670 6% (125,507)‐5%
Phone 966,827 1,000,000 1,056,420 89,593 9% 56,420 6%
Cable 1,385,275 1,427,679 1,423,664 38,389 3% (4,015) 0%
Transfer Station 297,474 248,762 330,607 33,132 11% 81,845 33%
City Utilities 3,516,179 3,665,728 3,806,281 290,102 8% 140,553 4%
YTD Total 15,484,862$ 16,155,203$ 15,954,432$ 469,571$ 3%(200,771)$ ‐1%
Annual Total 15,484,862$ 16,155,203$
YTD as % of 100% 100%
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 1,363,023$ 1,423,448$ 1,469,178$ 106,155$ 8% 45,730$ 3%
Feb 1,448,275 1,512,984 1,512,539 64,263 4% (445) 0%
Mar 1,480,840 1,546,398 1,438,515 (42,325) ‐3% (107,883) ‐7%
Apr 1,370,718 1,433,422 1,384,240 13,522 1% (49,182) ‐3%
May 1,291,530 1,350,150 1,394,109 102,579 8% 43,959 3%
Jun 1,203,475 1,256,117 1,108,588 (94,888) ‐8% (147,530) ‐12%
Jul 1,188,526 1,240,117 1,340,939 152,413 13% 100,822 8%
Aug 1,165,863 1,217,180 1,153,724 (12,139) ‐1% (63,457) ‐5%
Sep 1,176,526 1,225,853 1,301,158 124,631 11%75,304 6%
Oct 1,202,559 1,253,072 1,126,772 (75,786) ‐6% (126,300) ‐10%
Nov 1,232,640 1,281,314 1,196,932 (35,708) ‐3% (84,382) ‐7%
Dec 1,360,887 1,415,147 1,527,740 166,854 12% 112,593 8%
YTD Total 15,484,862$ 16,155,203$ 15,954,432$ 469,571$ 3% (200,771)$ ‐1%
Annual Total 15,484,862$ 16,155,203$
2012 vs. Budget2012 vs. 2011
Year to Date through December
Utility Tax Revenues
Month
Page 3 of 37
Monthly Financial Report December 2012
Other Taxes
Real Estate Excise Tax
The City collected $251k in Real Estate
Excise Tax revenues (REET) for December.
This is $86k or 52% ahead of the same
month last year but is $4k or 2% below the
current month’s budget. The year‐to‐date
collection is $2.8 million, which is $738k or
36% more than the prior year and is also
$44k or 2% above the budget.
Gambling Tax
December’s Gambling Tax collections
total $153k. Year‐to‐date total of
$1.7 million is $20k or 1% above the
year before and is also $91k or 6%
above budget. The increase in
January’s collection from the
previous January is due to payment
plans with two establishments to
remit their monthly portions (starting
in October) of 2011 by year‐end,
which was receipted in the beginning
of 2012. Approximately $30k
collected in January was for the prior
year. The decrease in March is due
the timing of collections (the City
receipted $30k in April that was due for March). The variance in May is due to new payment plans with the same above
establishments.
Pull tabs overall had a 3% decrease, bingo increased by 24%, and card‐rooms are seeing 6% lower in activities when
compared to the prior year.
Franchise Fees
Franchise Fees are due quarterly and
the year‐to‐date revenue collections
are $1.3 million or 95% of the budget.
This is $28k or 2% higher than 2011
but is $61k or 5% below the
projected year‐to‐date budget.
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 161,911$ 211,959$ 77,631$ (84,280)$ ‐52% (134,328)$ ‐63%
Feb 99,677 132,347 214,137 114,460 115% 81,790 62%
Mar 141,700 186,507 203,583 61,883 44% 17,076 9%
Apr 110,987 146,082 194,868 83,881 76% 48,786 33%
May 157,519 207,329 253,446 95,927 61% 46,117 22%
Jun 228,506 300,763 347,179 118,673 52% 46,416 15%
Jul 117,567 154,743 177,839 60,273 51% 23,096 15%
Aug 159,524 209,967 222,933 63,409 40% 12,966 6%
Sep 205,753 270,814 173,212 (32,541) ‐16% (97,602) ‐36%
Oct 189,691 249,674 326,027 136,336 72% 76,353 31%
Nov 335,893 442,107 370,123 34,230 10% (71,984) ‐16%
Dec 165,331 255,227 250,922 85,591 52% (4,305) ‐2%
YTD Total 2,074,059$ 2,767,521$ 2,811,902$ 737,843$ 36% 44,381$ 2%
Annual Total 2,074,059$ 2,767,521$
Month
2012 vs. Budget2012 vs. 2011
Real Estate Excise Tax Revenues
Year to Date through December
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 118,304$ 113,250$ 175,959$ 57,655$ 49% 62,710$ 55%
Feb 135,926 130,118 143,837 7,911 6% 13,719 11%
Mar 135,067 129,296 98,279 (36,787) ‐27% (31,016) ‐24%
Apr 162,459 155,518 156,498 (5,961) ‐4% 980 1%
May 159,013 152,219 101,088 (57,924) ‐36% (51,130) ‐34%
Jun 151,240 144,778 127,372 (23,868) ‐16% (17,406) ‐12%
Jul 136,775 130,931 161,244 24,469 18% 30,313 23%
Aug 144,161 138,001 146,526 2,365 2% 8,525 6%
Sep 125,618 120,251 162,540 36,922 29% 42,289 35%
Oct 92,937 88,966 87,494 (5,443) ‐6% (1,472) ‐2%
Nov 139,018 133,078 177,352 38,334 28% 44,274 33%
Dec 170,897 163,595 153,019 (17,877) ‐10% (10,576) ‐6%
YTD Total 1,671,414$ 1,600,000$ 1,691,209$ 19,796$ 1% 91,209$ 6%
Annual Total 1,671,414$ 1,600,000$
2012 vs. 2011 2012 vs. Budget
Gambling Tax Revenue
Month
Year to Date through December
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 305,646$ 327,571$ 300,392$ (5,254)$ ‐2% (27,179)$ ‐8%
Apr 294,560 315,690 299,534 4,974 2% (16,156) ‐5%
Jul 294,438 315,560 305,065 10,627 4% (10,495) ‐3%
Oct 292,692 313,688 309,001 16,309 6% (4,687) ‐1%
Dec 47,111 50,491 48,195 1,084 2% (2,296) ‐5%
YTD Total 1,234,448$ 1,323,000$ 1,262,188$ 27,740$ 2% (60,812)$ ‐5%
Annual Total 1,234,448$ 1,323,000$
Franchise Fees Revenue
Year to Date through December
Month
2012 vs. 2011 2012 vs. Budget
Page 4 of 37
Monthly Financial Report December 2012
Admission Tax
Admission Tax returns are due quarterly in
January, April, July, and October each year.
October 2012 collections represent
activities conducted during the 3rd quarter
of 2012.
The report shows an increase of $4k or 1%
from the year before but is $37k or 11%
less than anticipated.
Licenses and Permits
Building Permits and Development Service Fees
Building Permits and Development Service
Fee revenues totalled $410k in December.
The year‐to‐date development fees
revenue of $3.4 million is $629k or 23%
more than 2011 and is also $935k or 38%
higher than budget. The higher than
expected fees are due to collecting more in
general building permits, electrical permits,
public works inspection fees and plan check
fees.
Business Licenses
Business Licenses totalled $3k for December,
which is right on track with the same month last
year and the current month’s budget. The year‐
to‐date Business Licenses revenue of $445k is 2k
or 1% more than the prior year but is $25k or 5%
behind the budget. The reason for the variance
in May is due to two corrections (one for 2011
and one for 2012) incorrectly coded to
amusement licenses and lower activity recorded
for general business licenses.
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 70,405$ 79,953$ 73,420$ 3,015$ 4% (6,534)$ ‐8%
Feb 477 542 934 457 96% 392 72%
Apr 63,582 72,205 80,352 16,770 26% 8,147 11%
May 407 462 ‐
Jul 86,024 97,691 81,104 (4,921) ‐6% (16,588) ‐17%
Aug 1,194 1,356 ‐
Oct 86,112 97,791 74,001 (12,111) ‐14% (23,790) ‐24%
Dec ‐ ‐ 1,244 1,244 100% 1,244 100%
YTD Total 308,200$ 350,000$ 311,054$ 4,455$ 1% (37,128)$ ‐11%
Annual Total 308,200$ 350,000$
Month
2012 vs. 2011 2012 vs. Budget
Admission Tax Revenue
Year to Date through December
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 132,621$ 112,664$ 160,750$ 28,129$ 21% 48,086$ 43%
Feb 141,672 125,262 197,549 55,877 39% 72,287 58%
Mar 265,782 238,974 262,937 (2,845) ‐1% 23,963 10%
Apr 190,534 167,552 259,386 68,852 36% 91,834 55%
May 239,018 215,841 285,205 46,187 19% 69,364 32%
Jun 215,975 195,717 291,218 75,243 35% 95,500 49%
Jul 211,760 187,937 299,611 87,851 41% 111,674 59%
Aug 393,797 351,616 368,587 (25,209) ‐6% 16,972 5%
Sep 321,961 289,918 182,210 (139,751) ‐43% (107,708) ‐37%
Oct 213,930 189,380 407,388 193,458 90% 218,008 115%
Nov 229,322 196,766 276,289 46,967 20% 79,522 40%
Dec 216,409 194,437 410,407 193,998 90% 215,970 111%
YTD Total 2,772,779$ 2,466,063$ 3,401,537$ 628,758$ 23% 935,474$ 38%
Annual Total 2,772,779$ 2,466,063$
Building Permits and Development Service Fees
Year to Date through December
2012 vs. Budget2012 vs. 2011
Month
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 84,109$ 89,311$ 88,676$ 4,568$ 5% (635)$ ‐1%
Feb 23,153 24,585 24,251 1,098 5% (334) ‐1%
Mar 3,811 4,047 4,927 1,115 29% 880 22%
Apr 83,930 89,121 89,003 5,074 6% (117) 0%
May 20,142 21,387 2,645 (17,496) ‐87% (18,742) ‐88%
Jun 3,964 4,209 3,377 (588) ‐15% (833) ‐20%
Jul 83,962 89,155 98,553 14,591 17% 9,398 11%
Aug 18,393 19,531 14,550 (3,844) ‐21% (4,981) ‐26%
Sep 4,135 4,391 3,197 (937) ‐23% (1,193) ‐27%
Oct 95,874 101,804 99,644 3,770 4% (2,160) ‐2%
Nov 18,291 19,423 12,484 (5,808) ‐32% (6,939) ‐36%
Dec 2,686 2,852 3,372 686 26% 520 18%
YTD Total 442,451$ 469,817$ 444,680$ 2,229$ 1% (25,137)$ ‐5%
Annual Total 442,451$ 469,817$
Business Licenses
Month
2012 vs. 2011
Year to Date through December
2012 vs. Budget
Page 5 of 37
Monthly Financial Report December 2012
Intergovernmental
These revenue sources include
federal (direct and indirect)
grants, state grants, state shared
revenues, local grants,
entitlements, and
intergovernmental. State shared
revenues and Fire Districts’ 25
and 40 contracts compose 87%
of the total revenues in this
category. The year‐to‐date total Intergovernmental revenue is $12.7 million or 102% of the budget.
State Shared Revenues
State Shared Revenue collections
totalled $4.8 million since the start
of 2012. Compared to the prior
year, State Shared Revenues are
above by $330k or 7%. Compared
to the projected budget, the City is
collecting $387k or 9% more. The
higher than expected collections
are due to the low budget of
Criminal Justice’s High Crime and
for Liquor Profits (due to auction
proceeds). The auction proceeds
will only be receipted in 2012. 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 72% of the total revenue in this category. The year‐to‐date total charges for services are $6.7 million or 100% of
the budget. This is 16k above budget projections. The following sections provide detail information for Public Safety,
Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totalled $486k since
the start of the year. These services include
private security, adult probation services,
and monitoring of prisoners. Compared to
the prior year, the City is right on track.
Compared to the budget, the City has
collected $55k or 13% more than the
anticipated revenue.
Intergovernmental 2011 2012 Bgt YTD Act Change 2012/2011 2012 Act vs Bgt
Fire District #25 1,400,820$ 1,353,114$ 1,397,433$ (3,387)$ 0% $ 44,319 3%
Fire District #40 4,709,848 4,655,580 4,758,188 48,340 1% 102,608 2%
State Shared Revenue 4,495,551 4,437,913 4,825,202 329,650 7% 387,289 9%
Federal Grants 1,040,557 1,483,534 981,308 (59,249) ‐6% (502,226) ‐34%
State Grants 150,400 102,549 160,964 10,564 7% 58,415 57%
Other Grants/Intgovt 186,110 163,344 156,189 (29,921) ‐16% (7,155) ‐4%
ARRA Grants 674,463 270,000 393,992 (280,471) ‐42% 123,992 46%
Total Rev YTD 12,657,748$ 12,466,034$ 12,673,276$ 15,528$ 0%207,242$ 2%
Total Rev Annual 12,657,748$ 12,466,034$
YTD %100% 100% 102%
Note: Includes CJ Sales Tax.
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 18,824$ 16,715$ 15,229$ (3,595)$ ‐19% (1,486)$ ‐9%
Feb 40,902 36,318 34,848 (6,054) ‐15% (1,470) ‐4%
Mar 30,346 26,945 35,353 5,007 17% 8,408 31%
Apr 52,434 46,558 68,426 15,993 31% 21,869 47%
May 35,609 31,619 42,979 7,370 21% 11,360 36%
Jun 46,295 41,107 31,486 (14,809) ‐32% (9,621) ‐23%
Jul 70,094 62,239 54,883 (15,211) ‐22% (7,356) ‐12%
Aug 35,891 31,868 34,742 (1,148) ‐3% 2,874 9%
Sep 30,743 27,298 36,019 5,276 17% 8,721 32%
Oct 34,756 30,861 37,300 2,543 7% 6,438 21%
Nov 42,944 38,131 33,025 (9,919) ‐23% (5,107) ‐13%
Dec 46,148 40,976 61,608 15,461 34% 20,632 50%
YTD Total 484,985$ 430,635$ 485,899$ 914$ 0% 55,264$ 13%
Annual Total 484,985$ 430,635$
Month
2012 vs. 2011
Year to Date through December
Public Safety Services
2012 vs. Budget
2011 2012 2012
Actual Budget Actual $ % $ %
Crim Just Sales Tax 1,809,757$ 1,867,145$ 1,924,470$ 114,713$ 6% 57,325$ 3%
Judicial Contribution 22,468 12,000 22,632 164 1% 10,632 89%
Crim Just ‐ High Crime 188,543 96,000 196,270 7,727 4% 100,270 104%
Crim Just ‐ Pop 19,922 ‐ 20,976 1,055 5% 20,976 100%
Crim Just ‐ Spec Prog 75,211 68,096 78,864 3,653 5% 10,768 16%
State DUI 18,973 15,111 17,397 (1,576) ‐8% 2,286 15%
Liquor Profits 633,856 650,000 928,773 294,917 47% 278,773 43%
Liquor Excise Tax 440,422 450,000 342,495 (97,928) ‐22% (107,505) ‐24%
Fuel Tax 1,286,399 1,279,561 1,293,325 6,926 1% 13,764 1%
YTD Total 4,495,551$ 4,437,913$ 4,825,202$ 329,650$ 7% 387,289$ 9%
Annual Total 4,495,551$ 4,437,913$
2012 vs. Budget
State Shared Revenues
2012 vs. 2011
Revenue
Year to Date through December
Page 6 of 37
Monthly Financial Report December 2012
Recreation
Recreation revenues totalled $60k for the
current month. Compared to the same
month the prior year, the City collected $12k
or 24% more. Compared to the projected
monthly budget, the City collected $6k or
11% more. The year‐to‐date collection of
$1.5 million is right on track with the prior
year but is $167k or 10% less than the
budget. The primary reason that recreation
fees are lower is due to the new cost
recovery policy approved by council this year
which reduces or eliminates those programs
that do not meet recovery objectives. This
revenue reduction translates into a savings
of $295k in the Recreation Division of the Community Services Department.
Interfund Services
The year‐to‐date collections for Interfund
Services revenues are $3.3 million.
Compared to the prior year, the revenues
are over by $241k or 8%. Compared to the
projected budget, the revenues are below by
$305k or 8%. 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, Transportation division’s capital
investment program reimbursements, and
Maintenance division’s street maintenance
reimbursements. The reason for the budget
shortfall is due to over projecting the interfund services budget for capital project inspections ($149k) and transportation
design ($170k).
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 on the following page
breaks down these fines by type. The
year‐to‐date total fines and penalties is $3
million. This is $85k or 3% lower than a
year ago and is also $187k or 6% under the
budget. The budget shortfall is due lower
activities for civil infraction penalties
($158k) and seizure funds ($143k).
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 61,933$ 68,872$ 62,072$ 138$ 0% (6,800)$ ‐10%
Feb 82,497 91,739 59,327 (23,170) ‐28% (32,412) ‐35%
Mar 99,537 110,688 104,775 5,238 5% (5,913) ‐5%
Apr 153,717 170,938 137,257 (16,460) ‐11% (33,681) ‐20%
May 134,113 149,138 139,013 4,900 4% (10,125) ‐7%
Jun 144,083 160,224 149,137 5,054 4% (11,087) ‐7%
Jul 211,388 235,070 260,363 48,975 23% 25,293 11%
Aug 254,060 282,523 262,038 7,978 3% (20,485) ‐7%
Sep 142,253 158,189 107,879 (34,373) ‐24% (50,310) ‐32%
Oct 83,540 92,899 85,973 2,433 3% (6,926) ‐7%
Nov 77,528 86,214 65,863 (11,665) ‐15% (20,351) ‐24%
Dec 48,890 54,368 60,467 11,577 24% 6,100 11%
YTD Total 1,493,540$ 1,660,863$ 1,494,165$ 625$ 0% (166,698)$ ‐10%
Annual Total 1,493,540$ 1,660,863$
Recreation
Year to Date through December
2012 vs. Budget2012 vs. 2011
Month
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 258,617$ 304,661$ 237,384$ (21,232)$ ‐8% (67,277)$ ‐22%
Feb 251,772 296,598 234,758 (17,014) ‐7% (61,840) ‐21%
Mar 269,526 317,513 271,071 1,545 1% (46,442) ‐15%
Apr 249,538 293,966 253,070 3,532 1% (40,897) ‐14%
May 255,425 300,902 291,941 36,516 14% (8,961) ‐3%
Jun 234,878 276,697 275,112 40,234 17% (1,584) ‐1%
Jul 238,262 280,683 217,828 (20,434) ‐9% (62,855) ‐22%
Aug 229,627 270,511 345,690 116,063 51% 75,179 28%
Sep 237,006 279,203 273,570 36,564 15% (5,634) ‐2%
Oct 270,340 318,472 338,304 67,964 25% 19,832 6%
Nov 266,859 314,371 276,902 10,043 4% (37,469) ‐12%
Dec 308,654 363,607 296,085 (12,569) ‐4% (67,522) ‐19%
YTD Total 3,070,506$ 3,617,185$ 3,311,715$ 241,210$ 8% (305,470)$ ‐8%
Annual Total 3,070,506$ 3,617,185$
Interfund Services
Year to Date through December
2012 vs. 2011 2012 vs. Budget
Month
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 165,721$ 169,834$ 183,478$ 17,757$ 11% 13,644$ 8%
Feb 261,655 262,221 238,928 (22,727) ‐9% (23,293) ‐9%
Mar 313,067 314,171 241,678 (71,389) ‐23% (72,493) ‐23%
Apr 289,767 288,252 276,301 (13,466) ‐5% (11,952) ‐4%
May 255,949 255,826 303,583 47,634 19% 47,757 19%
Jun 262,444 261,662 314,041 51,597 20% 52,379 20%
Jul 247,468 249,471 271,355 23,888 10% 21,885 9%
Aug 184,473 189,735 164,744 (19,729) ‐11% (24,991) ‐13%
Sep 181,000 185,846 176,829 (4,170) ‐2% (9,017) ‐5%
Oct 300,431 385,882 276,374 (24,057) ‐8% (109,507) ‐28%
Nov 297,580 299,240 245,273 (52,308) ‐18% (53,968) ‐18%
Dec 352,911 352,016 335,043 (17,868) ‐5% (16,973) ‐5%
YTD Total 3,112,464$ 3,214,156$ 3,027,627$ (84,838)$ ‐3% (186,529)$ ‐6%
Annual Total 3,112,464$ 3,214,156$
2012 vs. Budget2012 vs. 2011
Year to Date through December
Fines and Penalties by Month
Month
Page 7 of 37
Monthly Financial Report December 2012
Year to Date through December
2011 2012 2012
Actual Budget Actual $ % $ %
Civil Penalties 11,077$ 15,500$ 9,299$ (1,779)$ ‐16% (6,201)$ ‐40%
Civil Infraction Penalties 726,599 779,500 621,443 (105,156) ‐14% (158,057) ‐20%
Civil Parking Infraction Penalties 137,538 150,000 135,157 (2,380) ‐2% (14,843) ‐10%
Photo Enforcement Program 1,897,782 1,944,713 1,976,203 78,421 4% 31,490 2%
Criminal Traffic Misdemeanor Fines 99,417 90,000 88,457 (10,960) ‐11% (1,543) ‐2%
Criminal Non‐Traffic Fines 31,126 40,000 28,462 (2,663) ‐9% (11,538) ‐29%
Criminal Costs 124,481 11,750 129,907 5,426 4% 118,157 1006%
Seizure Funds ‐ Federal/State/Local 83,220 180,693 37,941 (45,279) ‐54% (142,752) ‐79%
Non‐Court Fines, Forfeitures and Penalties 1,225 2,000 758 (468) ‐38% (1,243) ‐62%
YTD Total 3,112,464$ 3,214,156$ 3,027,627$ (84,838)$ ‐3% (186,529)$ ‐6%
Annual Total 3,112,464$ 3,214,156$
Revenue
2012 vs. Budget
Fines and Penalties by Type
2012 vs. 2011
Included in the Fines and Penalties revenue budget is
$1.9 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 $2 million. 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. The City
received a credit in September for cameras that were
shut off but still charged (July and August).
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 $1.6 million.
Compared to last year, the revenues are
over by $280k or 21%. Compared to the
projected year‐to‐date budget, the
revenues are over by $529k or 48%. The
table on the next page breaks out
miscellaneous revenues by type:
Favorable
Budget Actual Budget Actual (Unfavorable)
1
Jan 169,793$ 183,453$ 76,201$ 68,003$ 115,449$
Feb 167,986 147,252 76,693 67,808 79,444
Mar 203,098 144,853 76,201 67,639 77,215
Apr 181,989 178,542 53,048 64,815 113,727
May 160,960 215,625 71,882 67,979 147,645
Jun 180,018 221,524 71,871 67,952 153,571
Jul 155,574 188,622 72,275 68,237 120,385
Aug 98,678 92,593 56,688 67,693 24,900
Sep 83,853 72,707 71,527 46,369 26,338
Oct 145,798 194,376 71,420 59,816 134,559
Nov 211,430 155,978 71,884 60,430 95,548
Dec 185,536 180,678 72,273 60,505 120,173
YTD Total 1,944,713$ 1,976,203$ 841,964$ 767,248$ 1,208,955$
Annual Total 1,944,713$ 841,964$
1 Actuals of Revenues and Expenses
Revenues Expenses
Photo Enforcement Program
Year to Date through December
Month
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 143,105$ 128,500$ 206,151$ 63,046$ 44% 77,651$ 60%
Feb 70,237 47,297 83,823 13,585 19% 36,526 77%
Mar 99,131 78,126 104,421 5,289 5% 26,294 34%
Apr 74,048 58,118 98,164 24,115 33% 40,046 69%
May 97,083 85,476 145,213 48,130 50% 59,738 70%
Jun 145,018 114,063 93,832 (51,185) ‐35% (20,231) ‐18%
Jul 173,878 119,673 112,316 (61,562) ‐35% (7,358) ‐6%
Aug 133,570 100,068 143,389 9,819 7% 43,321 43%
Sep 97,973 76,324 89,588 (8,385) ‐9% 13,263 17%
Oct 75,425 61,850 91,608 16,183 21% 29,758 48%
Nov 77,427 67,670 64,705 (12,722) ‐16% (2,966) ‐4%
Dec 163,299 164,593 397,713 234,414 144% 233,120 142%
YTD Total 1,350,195$ 1,101,759$ 1,630,922$ 280,727$ 21% 529,164$ 48%
Annual Total 1,350,195$ 1,101,759$
Year to Date through December
Month
2012 vs. Budget2012 vs. 2011
Miscellaneous Revenues by Month
Page 8 of 37
Monthly Financial Report December 2012
2011 2012 2012
Actual Budget Actual $ % $ %
Interests and Other Earnings 107,183$ 125,400$ 342,424$ 235,241$ 219% 217,024$ 173%
Rents, Leases, and Concessions 744,834 701,464 822,428 77,594 10% 120,964 17%
Contributions/Donations from Private Sources 196,586 84,060 124,082 (72,504) ‐37% 40,022 48%
Other 301,592 190,835 341,988 40,396 13% 151,153 79%
YTD Total 1,350,195$ 1,101,759$ 1,630,922$ 280,727$ 21% 529,164$ 48%
Annual Total 1,350,195$ 1,101,759$
2012 vs. Budget
Miscellaneous Re venues by Type
Year to Date through December
Revenue
2012 vs. 2011
Interest and other earnings are higher than the prior year and budget due to a change in recording the year‐end bank
earnings credit ($239k). Previously, the City netted the credits against the year‐end bank fees (2012 was $310k) and just
recorded the net expense as bank fees. This year, we recorded the full credit as revenues and the full bank fees as an
expense. This impacts the Finance Division of the Administrative Services Department’s budget and the main reason for the
over budget of $60k.
Rents, leases and concessions are higher than the prior year and budget due to higher than expected facility rentals at the
community center and food concession payments at Coulon Park.
Contributions and donations from private sources are favourable due to higher than expected donations.
Other miscellaneous revenues are higher than the prior year and budget due to higher than expected utility late payment
penalties.
EXPENSES
Overall the City has expended 97% of its budgeted general governmental expenditures at the end of December. This is $2.8
million or 2.7% below year‐to‐date budgeted expenditures. The City did not have any general governmental departments
over budget but did we did see some division within those departments over budget. Please refer to the General
Governmental Funds Summary of Sources and Uses table on page 1 for details.
While the majority of the $2.8 million is savings, approximately $713k (amount will change based on review) will have to be
carried forward into 2013 for obligations/services not yet received or been billed:
$30k for outside legal fees – City Attorney
$469k for seizure funds ‐ Police
$125k for EMPG grant ‐ Fire
$89k for KCD knotweed control grant – Parks Planning
Page 9 of 37
Monthly Financial Report December 2012
CASH AND INVESTMENTS – 4TH 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 $99.8
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). Previously, the
interfund loan was from the
general fund (000), but was
moved to the insurance fund
during the 2012 3rd Quarter
Budget Amendment (Ord 5671)
for the purpose of calling the
remaining balance of the 2002 Fire
Station 12 LTGO bonds. 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 .58%. The majority (.32%) is within the cash at US Bank.
US Bank ‐Cash
64%
State Investment Pool
10%
US Federal Agency Securities*
5%
Golf Course Interfund Loan
1%
Columbia Bank
5%Fortune Bank (incl. CDARS)
3%
Umpqua Bank
5%
Commencement Bank (incl.
CDARS)
7%
Distribution by Institution
(Percent of Cash & Investment Portfolio)
Deposit Total Maturity Date APY
Weighted
Yield
Current
Allocation of
Cash and
Allowed
by Policy
Current Principal
Balance
Cash US Bank ‐ Cash 64,315,204 overnight 0.45% 0.32%64%N/A 64,315,204
GOLF '13 375,000 12/1/2013 2.25% 0.01%
GOLF '14 395,000 12/1/2014 2.25% 0.01%
GOLF '15 410,000 12/1/2015 2.25% 0.01%
US Treasury Securities
none ‐ N/A N/A 0.00% 0% 100%‐
Local Government Investment Pool
3920 State Investment Pool 9,912,292 1/1/2013 0.19% 0.02% 10% 75% 9,912,292
US Federal Agency Securities *
312159a FNMA (Callable) 2,500,000 4/17/2015 0.75% 0.02%
312169a FNMA (Callable) 2,497,500 2/22/2016 1.27% 0.03%
Certificate of Deposit
First Savings Bank Northwest ‐ N/A N/A N/A
‐ N/A N/A N/A
112147a Columbia Bank 2,768,975 1/11/2014 0.69% 0.02%
111167a Columbia Bank 2,015,400 11/9/2016 0.99% 0.02%
212145a Fortune Bank (CDARS) 1,516,108 6/14/2014 0.70% 0.01%
212145b CDARS 1,000,685 12/18/2014 0.65% 0.01%
112145a Fortune Bank 252,980 12/23/2014 0.85% 0.00%
112146a Umpqua Bank 5,209,717 5/18/2014 0.85% 0.04%
211133a Commencement Bank (CDARS) 5,100,192 9/6/2013 1.00% 0.05%
212143a CDARS 1,030,141 9/20/2014 0.65% 0.01%
111133a Traditional 500,000 10/27/2013 1.00% 0.01%
Commercial Paper
none ‐ N/A N/A 0.00% 0.00% 5%‐
TOTAL CASH & INVESTMENTS 99,799,194$ 0.58% 100.00%99,799,194$
Institution
*Held in our safekeeping account at BNY Trust and Custody
Golf Interfund Loan
1% N/A
20%0%
20%5%
‐
4,784,375
2,769,772
5,209,717
5% 100%4,997,500
1,180,000
7% 20%6,630,333
20%3%
20%5%
Page 10 of 37
Monthly Financial Report December 2012
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 ‐ ‐ ‐ ‐ 44,385 37,025 ‐
Grants / intergovernmental 452,263 5,278 141,300 73,417 2,527 755,887 ‐
Charges for services 121,916 1,774,353 14,998,294 14,786,421 8,469,102 7,860,977 13,602,024
Interdepartmental services ‐ ‐ 5,624 368,129 202,131 579,476 ‐
Fines and penalties ‐ ‐ ‐ ‐ ‐ ‐ ‐
Rents, leases, and misc fees 2,311,951 354,606 74,093 135,582 ‐ ‐ ‐
Interest and other misc 8,610 4,678 15,272 5,394,122 2,810,081 3,374,934 4,664
TOTAL REVENUES 2,894,740 2,138,915 15,234,583 20,757,671 11,528,226 12,608,299 13,606,688
EXPENSES:
Utility billing ‐ ‐ 109,432 97,005 78,570 119,084 ‐
Utility systems ‐ ‐ 15,040,667 3,041,048 2,583,543 2,244,678 ‐
Utility maintenance ‐ ‐ 295,338 4,875,297 1,267,306 1,814,137 12,938,606
Transportation 1,333,039 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 1,773,993 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 1,333,039 1,773,993 15,445,437 8,013,350 3,929,419 4,177,899 12,938,606
AMOUNT AVAILABLE FOR DEBT SERVICE 1,561,701 364,922 (210,854) 12,744,321 7,598,807 8,430,400 668,082
DEBT SERVICE:
Principal 94,888 366,575 ‐ 6,852,095 3,075,144 3,356,392 ‐
Interest 10,316 34,085 ‐ 863,546 427,259 389,677 ‐
TOTAL DEBT SERVICE 105,204 400,660 ‐ 7,715,641 3,502,403 3,746,069 ‐
CAPITAL PROJECTS 1,090,834 38,517 ‐ 2,823,127 2,098,432 2,767,708 ‐
TRANSFERS IN/(OUT)(107,449) (1,418) ‐ (1,750) (10,594) (112,750) ‐
CHANGE IN FUND BALANCE 258,214 (75,673) (210,854) 2,203,803 1,987,378 1,803,873 668,082
BEGINNING FUND BALANCE, Jan 1 2,084,710 615,488 1,734,734 7,642,506 1,209,356 4,210,599 1,077,805
ENDING FUND BALANCE, Dec 31 2,342,924 539,815 1,523,880 9,846,309 3,196,734 6,014,472 1,745,887
Page 11 of 37
Monthly Financial Report December 2012
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 ‐ 104,340 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental 747 66,501 1,915 ‐ ‐ ‐ 43,637
Charges for services
Equipment rental m&o 2,638,082 2,116,586 ‐ ‐ ‐ ‐ ‐
Telecommunications ‐ 186,417 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 106,695 ‐ 397,163 ‐ ‐ ‐
Communications ‐ 3,500 ‐ 610,116 ‐ ‐ ‐
Facilities ‐ ‐ 4,173,513 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 150,146 ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ 316,122 ‐ ‐ ‐ ‐ ‐
Geographical information systems ‐ 196,832 ‐ ‐ ‐ ‐ ‐
Interest and other misc 14,934 7,099 2,094 710 22,098 25,805 20,441
Internal service fund misc:
Vehicle / equipment capital recovery 959,512 942,799 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 1,550,368 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 1,392,279 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 10,947,934 2,207,683
Other misc 916 211 10,185 146 204 690,706 1
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets 1,000 ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 65,543 9,639 139
TOTAL REVENUES 3,615,191 4,197,248 4,187,707 1,008,135 3,030,492 11,674,084 2,271,901
EXPENSES:
Communications 466,159
Equipment rental 2,522,589
Facilities 3,489,222
Healthcare 10,909,009
Information technology 3,353,164
Print and mail 379,619
Retiree healthcare 1,269,135
Risk management
Risk management 1,411,148
Unemployment 111,746
Worker's compensation 1,221,161
TOTAL EXPENSES 2,522,589 3,353,164 3,489,222 845,778 2,744,055 10,909,009 1,269,135
AMOUNT AVAILABLE FOR CAPITAL 1,092,602 844,084 698,484 162,357 286,437 765,075 1,002,766
DEBT SERVICE:
Interfund loan to Golf Course Fund 404 ‐ ‐ ‐ ‐ 1,716,067 ‐ ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ ‐ 1,716,067 ‐ ‐
CAPITAL PROJECTS 2,306,678 1,242,446 199,816 ‐ ‐ ‐ ‐
TRANSFERS IN 228,043 73,590 50,565 ‐ ‐ ‐ ‐
TRANSFERS (OUT)(65,843) ‐ ‐ ‐ (204,000) ‐ ‐
CHANGE IN FUND BALANCE (1,051,876) (324,772) 549,233 162,357 (1,633,630) 765,075 1,002,766
BEGINNING FUND BALANCE, Jan 1 4,774,376 2,181,743 300,238 141,120 6,620,437 7,133,996 5,479,399
ENDING FUND BALANCE, Dec 31 3,722,500 1,856,971 849,471 303,477 4,986,807 7,899,071 6,482,165
Page 12 of 37
Monthly Financial Report December 2012
FUND BALANCE
Page 14 shows the ending fund balance as of December 2012. 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 December, the City has $15.6 million reported in the combined general governmental fund balance of the
current year’s operating budget, which is approximately 15% of budgeted operating expenditures. This is an increase of
$4.5 million from the year’s beginning balance. December’s ending fund balance is over the anticipated General
Governmental Fund Balance of $10.6 million by $5 million or 47.3%. The reason for the surplus of fund balance is due to
overall revenues being favourable by $2.2 million and overall expenditures being favourable by $2.8 million.
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 December 2012
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through December 31, 2012
Funds
Balance
01/01/2012
Budgeted
Revenue
Revenue
12/31/12
Total Funds
Available
Budgeted
Expenditure
Expenditure
12/31/12
Ending
Balance
GENERAL GOVERNMENT FUNDS:11,057,551 106,232,730 108,457,170 119,514,721 106,718,452 103,938,882 15,575,839
000 General 6,934,747 75,227,799 77,929,846 84,864,593 76,301,221 74,289,223 10,575,369
001 Community Services 1,413,050 11,302,259 11,106,592 12,519,642 11,126,074 10,627,675 1,891,966
003 Street 1,264,341 8,953,479 8,692,011 9,956,352 8,492,917 8,370,800 1,585,553
004 Community Dev Block Grant 8,339 331,389 302,527 310,866 331,391 324,011 (13,145)
005 Museum 52,620 216,220 216,637 269,257 213,533 216,887 52,369
006 Library 48,603 230,000 230,000 278,603 278,603 278,604 (1)
009 Farmers Market 87,437 75,500 75,856 163,293 78,629 72,773 90,520
010 Fire Memorial 1,953 ‐ (1,952) 1 ‐ ‐ 1
011 Fire Health & Wellness 36,858 25,000 25,195 62,053 25,000 6,571 55,483
031 Pa rk Memorial 177,758 ‐ 609 178,367 ‐ ‐ 178,367
201 Ltd GO Bonds Gen Govt Debt 591,257 1,982,075 1,987,187 2,578,444 1,982,075 1,748,660 829,784
215 Gen Govt Misc Debt Service 440,588 7,889,009 7,892,662 8,333,250 7,889,009 8,003,677 329,573
SPECIAL REVENUE FUNDS:
102 Arterial Street 158,974 600,000 609,540 768,514 600,000 600,000 168,514
108 Leased City Properties 488,500 844,049 623,812 1,112,312 749,232 584,635 527,677
110 Hotel Motel 243,556 265,000 296,628 540,184 447,050 428,928 111,256
118 Reserve for Paths & Trails 3,314 ‐ ‐ 3,314 3,314 3,315 (1)
125 1% For Art 121,686 21,813 8,274 129,960 50,000 13,818 116,142
127 Cable Communication 185,968 85,000 91,490 277,458 235,674 20,086 257,372
135 Springbrook Wetlands Bank 663,556 ‐ 2,272 665,828 ‐ ‐ 665,828
CAPITAL PROJECT FUNDS (CIP):
303 Community Dev Mitigation 1,475,050 60,000 65,104 1,540,154 400,000 ‐ 1,540,154
304 Fire Mitigation 1,492,674 263,602 241,669 1,734,343 936,926 936,926 797,417
305 Transportation Mitigation 657,187 30,000 85,440 742,627 450,000 450,000 292,627
316 Municipal Facilities CIP 3,745,546 3,325,011 1,383,979 5,129,525 6,725,806 1,655,008 3,474,517
317 Transportation CIP 3,422,219 23,568,336 20,710,673 24,132,892 26,945,419 24,524,051 (391,159)
318 So Lake WA Infrastructure Proj 52,792 40,000 179 52,971 92,024 898 52,073
326 Housing Opportunity 130,546 ‐ 3,813 134,359 125,000 50,000 84,359
336 New Library Development 19,196,447 568,588 604,608 19,801,055 19,221,447 657,711 19,143,344
ENTERPRISE FUNDS:
402 Airport 494,718 1,231,925 1,176,116 1,670,834 1,367,780 1,338,895 331,939
403 Solid Waste Utility 1,734,734 15,021,811 15,234,583 16,969,317 15,486,501 15,445,436 1,523,881
404 Golf Course 379,997 2,483,545 2,138,052 2,518,049 2,492,204 2,226,071 291,978
422 Airport Capital 1,589,992 7,167,275 1,718,624 3,308,616 8,757,267 1,297,631 2,010,985
424 Golf Course Capital 235,491 50,000 50,862 286,353 145,000 38,517 247,836
INTERNAL SERVICE FUNDS:
501 Equipment Repair/Replacement 4,774,376 3,248,686 3,843,235 8,617,611 4,099,127 4,895,110 3,722,501
502 Insurance 6,620,437 3,187,593 3,030,493 9,650,930 4,850,146 4,664,123 4,986,807
503 Information Services 2,181,743 4,126,173 4,270,839 6,452,582 5,959,686 4,595,610 1,856,972
504 Facilities 300,238 4,377,629 4,238,272 4,538,510 4,394,294 3,689,038 849,472
505 Communications 141,120 974,307 1,008,135 1,149,255 991,015 845,778 303,477
512 Insurance, Healthcare 7,133,996 12,014,224 11,674,083 18,808,079 11,996,739 10,909,009 7,899,070
522 Insurance, Leoff1 Retirees HC 5,479,399 2,235,684 2,271,901 7,751,300 2,262,573 1,269,135 6,482,165
FIDUCIARY FUNDS:
611 Firemen's Pension 4,377,696 300,000 404,706 4,782,402 550,475 226,399 4,556,003
Funds
Balance
01/01/2012
Budgeted
Revenue
Revenue
12/31/12
Total Funds
Available
Budgeted
Expenditure
Expenditure
12/31/12
Ending
Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 14,140,266 57,748,512 58,500,884 72,641,150 66,838,018 51,837,747 20,803,403
405 Water Utility 3,993,415 11,106,460 17,186,356 21,179,771 16,459,445 15,730,742 5,449,029
406 Waste Water Utility 685,178 7,888,555 8,120,366 8,805,544 7,423,611 7,441,915 1,363,629
407 Surface Water Utility 1,625,915 8,657,535 8,701,679 10,327,594 8,758,975 8,057,823 2,269,771
416 King County Metro 1,077,805 13,209,387 13,606,688 14,684,493 13,209,387 12,938,606 1,745,887
425 Water Utility Construction 3,633,246 5,271,869 3,571,261 7,204,507 7,085,000 2,823,127 4,381,380
426 Waste Water Construction 524,178 3,310,000 3,407,859 3,932,037 3,710,000 2,098,932 1,833,105
427 Surface Water Construction 2,584,684 8,304,706 3,906,621 6,491,305 10,191,600 2,746,602 3,744,703
471 Waterworks Rate Stabilization 15,845 ‐ 54 15,899 ‐ ‐ 15,899
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
2012 Budget Year
General Government Summary
Revenues Expenditures
$ Difference
over (under)
w/beginning
balance
11,057,551
January 5,169,136 6,667,414 (1,498,278) 9,559,274
February 10,715,775 15,284,017 (4,568,242) 6,489,309
March 16,218,914 22,281,867 (6,062,953) 4,994,598
April 32,180,045 31,242,984 937,061 11,994,612
May 46,051,336 38,877,391 7,173,945 18,231,496
June 51,288,412 47,714,859 3,573,553 14,631,104
July 57,687,119 55,549,735 2,137,384 13,194,935
August 63,335,690 63,356,444 (20,754) 11,036,797
September 68,598,474 71,327,565 (2,729,091) 8,328,460
October 84,628,784 79,209,986 5,418,798 16,476,349
November 97,472,642 86,791,207 10,681,435 21,738,986
December 106,142,170 101,623,882 4,518,288 15,575,839
3 000 000
4,000,000
5,000,000
6,000,000
7,000,000
8,000,000
9,000,000
10,000,000
11,000,000
12,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
2,000,000
3,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 37
City of Renton
Monthly Revenue Analysis ‐ 2012 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 5,322,023 5,169,136 ‐2.87%
Feb 10,894,340 10,715,775 ‐1.64%
Mar 16,609,763 16,218,914 ‐2.35%
Apr 30,639,564 32,180,045 5.03%
May 45,645,542 46,051,336 0.89%
Jun 50,517,636 51,288,412 1.53%
Jul 56,519,396 57,687,119 2.07%
Aug 61,782,180 63,335,690 2.51%
Sep 66,896,094 68,598,474 2.54%
Oct 81,633,136 84,628,784 3.67%
Nov 96,568,859 97,472,642 0.94%
Dec 103,917,730 106,142,170 2.14%
Percent of budget 102.14%
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 255,343 149,112 ‐41.60%
Feb 572,253 234,689 ‐58.99%
Mar 1,247,748 1,115,068 ‐10.63%
Apr 9,024,212 11,127,076 23.30%
May 17,133,271 17,258,526 0.73%
Jun 17,231,849 17,301,729 0.41%
Jul 17,337,932 17,648,446 1.79%
Aug 17,422,058 17,697,303 1.58%
Sep 17,843,166 18,243,056 2.24%
Oct 24,750,333 27,977,440 13.04%
Nov 32,724,934 33,101,164 1.15%
Dec 32,896,746 33,466,364 1.73%
Percent of budget 101.73%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
$36
Budget
Actual
Last Year
Page 16 of 37
City of Renton
Monthly Revenue Analysis ‐ 2012 Budget Year
Sales Tax Budget
YTD
Actual
Annual %
over (under)
Jan 1,552,198 1,493,022 ‐3.81%
Feb 3,549,657 3,645,170 2.69%
Mar 5,080,681 5,103,858 0.46%
Apr 6,625,498 6,637,123 0.18%
May 8,384,823 8,425,848 0.49%
Jun 9,969,656 10,083,315 1.14%
Jul 11,554,021 11,766,784 1.84%
Aug 13,258,722 13,538,469 2.11%
Sep 14,907,971 15,185,575 1.86%
Oct 16,615,185 17,043,460 2.58%
Nov 18,322,808 18,955,075 3.45%
Dec 19,965,647 20,773,163 4.04%
Percent of budget 104.04%
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,423,448 1,469,178 3.21%
Feb 2,936,432 2,981,716 1.54%
Mar 4,482,830 4,420,232 ‐1.40%
Apr 5,916,252 5,804,472 ‐1.89%
May 7,266,402 7,198,580 ‐0.93%
Jun 8,522,519 8,307,168 ‐2.53%
Jul 9,762,636 9,648,107 ‐1.17%
Aug 10,979,816 10,801,830 ‐1.62%
Sep 12,205,670 12,102,988 ‐0.84%
Oct 13,458,742 13,229,760 ‐1.70%
Nov 14,740,056 14,426,692 ‐2.13%
Dec 16,155,203 15,954,432 ‐1.24%
Percent of budget 98.76%
Note: Includes Natural Gas Use Tax.
$0
$2
$4
$6
$8
$10
$12
$14
$16
Budget
Actual
Last Year
Page 17 of 37
City of Renton
Monthly Revenue Analysis ‐ 2012 Budget Year
Licenses &
Permits Budget
YTD
Actual
Annual %
over (under)
Jan 179,209 218,837 22.11%
Feb 303,772 388,194 27.79%
Mar 495,614 595,917 20.24%
Apr 721,466 863,503 19.69%
May 883,222 1,050,245 18.91%
Jun 1,025,529 1,249,175 21.81%
Jul 1,257,216 1,547,600 23.10%
Aug 1,551,253 1,839,226 18.56%
Sep 1,768,424 1,994,570 12.79%
Oct 2,019,748 2,376,216 17.65%
Nov 2,211,675 2,584,857 16.87%
Dec 2,403,331 2,887,166 20.13%
Percent of budget 120.13%
Note: Includes Fund 318.
YTD Annual % Millions
Intergovernmental
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
$2.40
$2.70
$3.00
Millions Licenses & Permits
Budget
Actual
Last Year
Intergovt'l Budget Actual over (under)
Jan 513,548 462,865 ‐9.87%
Feb 1,094,941 1,007,561 ‐7.98%
Mar 1,667,563 1,389,752 ‐16.66%
Apr 2,652,006 2,492,260 ‐6.02%
May 4,925,655 5,142,362 4.40%
Jun 5,561,357 5,924,916 6.54%
Jul 6,132,833 6,681,592 8.95%
Aug 6,783,538 7,648,504 12.75%
Sep 7,242,869 8,187,190 13.04%
Oct 8,609,645 9,396,556 9.14%
Nov 11,082,470 11,953,693 7.86%
Dec 12,466,034 12,673,276 1.66%
Percent of budget 101.66%
Note: Includes CJ Sales Tax.
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
$10
$11
$12
$13
Millions
Budget
Actual
Last Year
Page 18 of 37
City of Renton
Monthly Revenue Analysis ‐ 2012 Budget Year
Charges for
Services Budget
YTD
Actual
Annual %
over (under)
Jan 433,277 374,426 ‐13.58%
Feb 910,731 788,975 ‐13.37%
Mar 1,454,233 1,308,436 ‐10.03%
Apr 2,045,308 1,886,483 ‐7.77%
May 2,644,071 2,493,978 ‐5.68%
Jun 3,207,813 3,078,647 ‐4.03%
Jul 3,864,078 3,747,920 ‐3.01%
Aug 4,567,070 4,514,034 ‐1.16%
Sep 5,140,570 5,001,139 ‐2.71%
Oct 5,652,987 5,635,383 ‐0.31%
Nov 6,159,124 6,131,190 ‐0.45%
Dec 6,691,060 6,706,594 0.23%
Percent of budget 100.23%
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 169,834 183,478 8.03%
Feb 432,054 424,528 ‐1.74%
Mar 746,225 668,907 ‐10.36%
Apr 1,034,478 947,879 ‐8.37%
May 1,290,304 1,254,303 ‐2.79%
Jun 1,551,967 1,572,394 1.32%
Jul 1,801,437 1,846,637 2.51%
Aug 1,991,172 2,014,824 1.19%
Sep 2,177,018 2,193,991 0.78%
Oct 2,562,900 2,472,856 ‐3.51%
Nov 2,862,140 2,720,463 ‐4.95%
Dec 3,214,156 3,060,389 ‐4.78%
Percent of budget 95.22%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Budget
Actual
Last Year
Page 19 of 37
City of Renton
Monthly Revenue Analysis ‐ 2012 Budget Year
Other Taxes Budget
YTD
Actual
Annual %
over (under)
Jan 666,666 612,068 ‐8.19%
Feb 916,622 954,879 4.17%
Mar 1,172,735 1,216,856 3.76%
Apr 1,876,381 1,919,894 2.32%
May 2,286,914 2,445,811 6.95%
Jun 2,500,838 2,895,320 15.77%
Jul 3,742,517 3,811,124 1.83%
Aug 4,060,314 4,148,648 2.18%
Sep 4,364,707 4,452,726 2.02%
Oct 5,288,106 5,166,341 ‐2.30%
Nov 5,721,799 5,458,596 ‐4.60%
Dec 6,249,909 6,186,676 ‐1.01%
Percent of budget 98.99%
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 128,500 206,151 60.43%
Feb 175,797 289,974 64.95%
Mar 253,923 394,394 55.32%
Apr 312,041 492,558 57.85%
May 397,517 637,771 60.44%
Jun 511,580 731,604 43.01%
Jul 631,253 843,920 33.69%
Aug 731,321 987,309 35.00%
Sep 807,646 1,076,897 33.34%
Oct 869,496 1,168,505 34.39%
Nov 937,166 1,233,209 31.59%
Dec 1,101,759 1,630,922 48.03%
Percent of budget 148.03%
$‐
$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 37
City of Renton
Monthly Revenue Analysis ‐ 2012 Budget Year
Other
Financing Budget
YTD
Actual
Annual %
over (under)
Jan ‐ ‐ N/A
Feb 2,080 90 ‐95.68%
Mar 8,211 5,494 ‐33.08%
Apr 431,922 8,797 ‐97.96%
May 433,364 143,912 ‐66.79%
Jun 434,529 144,143 ‐66.83%
Jul 435,472 144,991 ‐66.70%
Aug 436,915 145,543 ‐66.69%
Sep 438,052 160,342 ‐63.40%
Oct 1,805,994 162,266 ‐91.02%
Nov 1,806,687 907,701 ‐49.76%
Dec 2,773,886 2,803,188 1.06%
Percent of budget 101.06%
YTD Annual % Millions
Real Estate Excise Tax
$‐
$2.00
$4.00
$6.00
$8.00
$10.00
$12.00
Millions Other Financing Sources
Budget
Actual
Last Year
REET Budget Actual over (under)
Jan 216,033 77,631 ‐64.07%
Feb 349,040 291,768 ‐16.41%
Mar 538,117 495,352 ‐7.95%
Apr 686,235 690,220 0.58%
May 896,400 943,666 5.27%
Jun 1,201,326 1,290,845 7.45%
Jul 1,358,189 1,468,685 8.14%
Aug 1,571,039 1,691,618 7.68%
Sep 1,845,604 1,864,830 1.04%
Oct 2,098,722 2,190,857 4.39%
Nov 2,546,922 2,560,980 0.55%
Dec 2,767,521 2,811,902 1.60%
Percent of budget 101.60%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
Millions
Budget
Actual
Last Year
Page 21 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,377,110 6,667,414 ‐9.62%
Feb 15,975,557 15,284,017 ‐4.33%
Mar 23,800,128 22,281,867 ‐6.38%
Apr 31,265,598 31,242,984 ‐0.07%
May 40,973,939 38,877,391 ‐5.12%
Jun 49,617,608 47,714,859 ‐3.83%
Jul 57,648,707 55,549,735 ‐3.64%
Aug 66,106,540 63,356,444 ‐4.16%
Sep 76,870,901 71,327,565 ‐7.21%
Oct 84,237,612 79,209,986 ‐5.97%
Nov 92,279,346 86,791,207 ‐5.95%
Dec 104,403,452 101,623,882 ‐2.66%
Percent of budget expended 99.56%
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,052 21,995 ‐4.59%
Feb 47,250 45,516 ‐3.67%
Mar 71,106 68,811 ‐3.23%
Apr 94,952 91,998 ‐3.11%
May 118,463 115,568 ‐2.44%
Jun 142,332 138,621 ‐2.61%
Jul 166,209 161,791 ‐2.66%
Aug 189,913 184,727 ‐2.73%
Sep 213,507 207,888 ‐2.63%
Oct 235,771 231,423 ‐1.84%
Nov 259,647 254,552 ‐1.96%
Dec 284,087 278,768 ‐1.87%
Percent of budget expended 98.13%
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
Budget
Actual
Last Year
Page 22 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
Executive Budget
YTD
Actual
Annual %
over (under)
Jan 115,566 75,851 ‐34.37%
Feb 234,736 193,315 ‐17.65%
Mar 352,251 312,540 ‐11.27%
Apr 476,167 427,410 ‐10.24%
May 597,036 545,056 ‐8.71%
Jun 714,061 660,020 ‐7.57%
Jul 838,503 775,729 ‐7.49%
Aug 949,052 892,376 ‐5.97%
Sep 1,083,306 1,001,508 ‐7.55%
Oct 1,204,110 1,113,782 ‐7.50%
Nov 1,318,583 1,231,423 ‐6.61%
Dec 1,468,694 1,377,109 ‐6.24%
Percent of budget expended 93.76%
Hearing YTD Annual %
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
Millions Executive
Budget
Actual
Last Year
$80 000
Hearing Examiner
Examiner Budget Actual over (under)
Jan 8,732 1,731 ‐80.18%
Feb 15,470 3,485 ‐77.47%
Mar 20,317 16,343 ‐19.56%
Apr 25,330 21,235 ‐16.17%
May 30,687 27,252 ‐11.19%
Jun 36,506 30,050 ‐17.68%
Jul 42,088 33,646 ‐20.06%
Aug 47,349 41,426 ‐12.51%
Sep 53,136 45,121 ‐15.08%
Oct 58,229 47,687 ‐18.10%
Nov 65,292 53,845 ‐17.53%
Dec 71,025 60,368 ‐15.01%
Percent of budget expended 84.99%
$‐
$10,000
$20,000
$30,000
$40,000
$50,000
$60,000
$70,000
$80,000
Budget
Actual
Last Year
Page 23 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
City Attorney Budget
YTD
Actual
Annual %
over (under)
Jan 141,234 136,926 ‐3.05%
Feb 291,116 277,093 ‐4.82%
Mar 436,269 419,219 ‐3.91%
Apr 581,948 563,552 ‐3.16%
May 725,684 700,106 ‐3.52%
Jun 871,642 844,781 ‐3.08%
Jul 1,016,111 982,591 ‐3.30%
Aug 1,160,451 1,122,280 ‐3.29%
Sep 1,304,888 1,261,497 ‐3.33%
Oct 1,440,264 1,426,459 ‐0.96%
Nov 1,582,804 1,563,092 ‐1.25%
Dec 1,733,686 1,706,320 ‐1.58%
Percent of budget expended 98.42%
YTD Annual % $2 20
Millions Court Services
$‐
$0.40
$0.80
$1.20
$1.60
$2.00
Millions City Attorney
Budget
Actual
Last Year
Court Services Budget Actual over (under)
Jan 174,964 166,993 ‐4.56%
Feb 344,821 334,252 ‐3.06%
Mar 521,572 504,905 ‐3.20%
Apr 698,400 674,406 ‐3.44%
May 871,345 860,008 ‐1.30%
Jun 1,069,741 1,045,629 ‐2.25%
Jul 1,252,611 1,225,120 ‐2.19%
Aug 1,433,492 1,396,118 ‐2.61%
Sep 1,617,436 1,559,621 ‐3.57%
Oct 1,784,453 1,728,593 ‐3.13%
Nov 1,963,784 1,901,324 ‐3.18%
Dec 2,155,819 2,074,980 ‐3.75%
Percent of budget expended 96.25%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
$2.00
$2.20
Budget
Actual
Last Year
Page 24 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
CED Admin Budget
YTD
Actual
Annual %
over (under)
Jan 77,315 79,562 2.91%
Feb 159,341 159,405 0.04%
Mar 239,050 239,249 0.08%
Apr 318,760 322,177 1.07%
May 398,469 399,357 0.22%
Jun 478,179 476,538 ‐0.34%
Jul 557,987 553,718 ‐0.77%
Aug 637,894 630,909 ‐1.09%
Sep 717,523 708,111 ‐1.31%
Oct 794,989 784,676 ‐1.30%
Nov 873,950 861,611 ‐1.41%
Dec 952,912 942,071 ‐1.14%
Percent of budget expended 98.86%
Development YTD Annual %
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
$0.70
$0.80
$0.90
$1.00
Millions
Community & Economic
Development Admin
Budget
Actual
Last Year
Millions
Development Services
Services Budget Actual over (under)
Jan 308,456 239,412 ‐22.38%
Feb 598,589 477,272 ‐20.27%
Mar 886,050 715,648 ‐19.23%
Apr 1,171,262 959,516 ‐18.08%
May 1,475,822 1,208,953 ‐18.08%
Jun 1,747,643 1,465,542 ‐16.14%
Jul 2,032,811 1,725,325 ‐15.13%
Aug 2,290,533 2,001,005 ‐12.64%
Sep 2,593,698 2,272,559 ‐12.38%
Oct 2,863,779 2,554,601 ‐10.80%
Nov 3,141,884 2,823,550 ‐10.13%
Dec 3,434,929 3,103,568 ‐9.65%
Percent of budget expended 90.35%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions
Budget
Actual
Last Year
Page 25 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
Economic
Development Budget
YTD
Actual
Annual %
over (under)
Jan 55,325 46,930 ‐15.17%
Feb 116,628 105,987 ‐9.12%
Mar 165,919 149,151 ‐10.11%
Apr 219,033 188,315 ‐14.02%
May 279,988 229,561 ‐18.01%
Jun 329,175 271,554 ‐17.50%
Jul 385,014 311,183 ‐19.18%
Aug 435,470 355,162 ‐18.44%
Sep 500,610 394,501 ‐21.20%
Oct 556,327 434,361 ‐21.92%
Nov 614,688 490,160 ‐20.26%
Dec 676,136 529,043 ‐21.75%
Percent of budget expended 78.25%
YTD Annual %
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
$0.70
Millions
Economic Development
Budget
Actual
Last Year
Millions
Planning
Planning Budget Actual over (under)
Jan 111,447 121,734 9.23%
Feb 242,600 245,831 1.33%
Mar 344,794 377,067 9.36%
Apr 461,325 493,399 6.95%
May 568,088 616,222 8.47%
Jun 719,930 738,072 2.52%
Jul 836,707 858,754 2.63%
Aug 990,965 995,013 0.41%
Sep 1,160,034 1,121,575 ‐3.32%
Oct 1,277,610 1,231,243 ‐3.63%
Nov 1,377,062 1,347,651 ‐2.14%
Dec 1,516,719 1,482,233 ‐2.27%
Percent of budget expended 97.73%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
Millions
Budget
Actual
Last Year
Page 26 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
Finance Budget
YTD
Actual
Annual %
over (under)
Jan 149,357 152,157 1.87%
Feb 299,349 312,270 4.32%
Mar 452,396 476,115 5.24%
Apr 602,531 635,592 5.49%
May 766,386 813,293 6.12%
Jun 922,974 995,643 7.87%
Jul 1,070,091 1,172,818 9.60%
Aug 1,235,336 1,348,224 9.14%
Sep 1,414,702 1,487,821 5.17%
Oct 1,554,314 1,627,884 4.73%
Nov 1,696,851 1,768,328 4.21%
Dec 2,161,836 2,221,882 2.78%
Percent of budget expended 102.78%
YTD Annual % $1 20
Millions City Clerk
$‐
$0.40
$0.80
$1.20
$1.60
$2.00
$2.40
Millions Finance
Budget
Actual
Last Year
City Clerk Budget Actual over (under)
Jan 64,108 51,770 ‐19.25%
Feb 125,530 111,173 ‐11.44%
Mar 197,338 170,116 ‐13.79%
Apr 357,645 226,333 ‐36.72%
May 485,052 283,861 ‐41.48%
Jun 548,623 343,072 ‐37.47%
Jul 613,605 611,198 ‐0.39%
Aug 677,277 677,021 ‐0.04%
Sep 742,449 739,885 ‐0.35%
Oct 863,525 802,631 ‐7.05%
Nov 930,561 866,205 ‐6.92%
Dec 1,002,105 937,067 ‐6.49%
Percent of budget expended 93.51%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Budget
Actual
Last Year
Page 27 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
Human
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 85,534 69,265 ‐19.02%
Feb 160,543 145,615 ‐9.30%
Mar 235,703 227,236 ‐3.59%
Apr 306,383 299,810 ‐2.15%
May 377,353 372,608 ‐1.26%
Jun 458,275 459,361 0.24%
Jul 539,353 540,433 0.20%
Aug 617,162 625,233 1.31%
Sep 695,139 700,143 0.72%
Oct 771,451 776,279 0.63%
Nov 853,247 850,165 ‐0.36%
Dec 946,956 937,412 ‐1.01%
Percent of budget expended 98.99%
YTD Annual %
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
Millions Human Resources
Budget
Actual
Last Year
$33
Millions Police
Police Budget Actual over (under)
Jan 2,379,528 1,905,016 ‐19.94%
Feb 4,429,946 4,392,199 ‐0.85%
Mar 7,027,938 6,307,019 ‐10.26%
Apr 9,165,318 9,480,882 3.44%
May 11,329,852 11,693,746 3.21%
Jun 14,079,857 14,209,937 0.92%
Jul 16,414,656 16,456,908 0.26%
Aug 19,039,447 18,597,181 ‐2.32%
Sep 21,277,937 21,374,890 0.46%
Oct 23,363,540 23,553,267 0.81%
Nov 26,104,608 26,017,797 ‐0.33%
Dec 29,568,937 28,494,195 ‐3.63%
Percent of budget expended 96.37%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
Budget
Actual
Last Year
Page 28 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
Fire &
Emergency
Services Budget
YTD
Actual
Annual %
over (under)
Jan 1,939,285 1,891,121 ‐2.48%
Feb 4,608,980 4,615,089 0.13%
Mar 6,520,418 6,539,657 0.30%
Apr 8,401,125 8,435,070 0.40%
May 10,377,667 10,741,041 3.50%
Jun 12,316,459 12,628,919 2.54%
Jul 14,303,981 14,471,622 1.17%
Aug 16,361,965 16,441,012 0.48%
Sep 18,365,673 18,352,396 ‐0.07%
Oct 20,245,912 20,229,262 ‐0.08%
Nov 22,255,390 22,184,782 ‐0.32%
Dec 24,259,367 24,173,315 ‐0.35%
Percent of budget expended 99.65%
Community YTD Annual %
$‐
$3
$6
$9
$12
$15
$18
$21
$24
Millions Fire & Emergency Services
Budget
Actual
Last Year
$0 50
Millions Community Services Admin
Services Admin Budget Actual over (under)
Jan 22,705 39,072 72.09%
Feb 69,191 73,790 6.65%
Mar 104,084 108,727 4.46%
Apr 138,770 143,787 3.62%
May 173,424 180,559 4.11%
Jun 208,186 215,856 3.68%
Jul 243,168 250,982 3.21%
Aug 278,693 285,879 2.58%
Sep 315,161 320,209 1.60%
Oct 349,074 354,172 1.46%
Nov 384,584 388,455 1.01%
Dec 421,043 434,558 3.21%
Percent of budget expended 103.21%
$‐
$0.05
$0.10
$0.15
$0.20
$0.25
$0.30
$0.35
$0.40
$0.45
$0.50
Budget
Actual
Last Year
Page 29 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
Parks Budget
YTD
Actual
Annual %
over (under)
Jan 262,517 274,545 4.58%
Feb 559,300 551,290 ‐1.43%
Mar 854,597 862,246 0.89%
Apr 1,171,115 1,179,119 0.68%
May 1,497,885 1,489,760 ‐0.54%
Jun 1,853,057 1,823,313 ‐1.61%
Jul 2,222,702 2,170,674 ‐2.34%
Aug 2,589,857 2,541,158 ‐1.88%
Sep 2,973,223 2,927,216 ‐1.55%
Oct 3,348,621 3,282,805 ‐1.97%
Nov 3,709,562 3,632,323 ‐2.08%
Dec 4,045,762 4,004,054 ‐1.03%
Percent of budget expended 98.97%
Parks Planning
and Natural YTD Annual %
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
Millions Parks
Budget
Actual
Last Year
$0 70
Millions Parks Planning and Natural Resources
Resources Budget Actual over (under)
Jan 33,341 36,047 8.11%
Feb 79,733 73,127 ‐8.29%
Mar 130,026 124,284 ‐4.42%
Apr 181,424 169,504 ‐6.57%
May 243,305 223,491 ‐8.14%
Jun 302,748 275,550 ‐8.98%
Jul 372,183 319,721 ‐14.10%
Aug 433,495 363,538 ‐16.14%
Sep 494,583 417,421 ‐15.60%
Oct 561,935 471,166 ‐16.15%
Nov 625,369 520,618 ‐16.75%
Dec 685,122 577,934 ‐15.65%
Percent of budget expended 84.35%
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
$0.70
Budget
Actual
Last Year
Page 30 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
Recreation Budget
YTD
Actual
Annual %
over (under)
Jan 359,441 304,539 ‐15.27%
Feb 719,755 652,057 ‐9.41%
Mar 1,091,168 999,673 ‐8.39%
Apr 1,458,822 1,377,160 ‐5.60%
May 1,839,738 1,750,284 ‐4.86%
Jun 2,245,447 2,133,041 ‐5.01%
Jul 2,856,921 2,707,614 ‐5.23%
Aug 3,525,903 3,346,772 ‐5.08%
Sep 4,078,172 3,831,606 ‐6.05%
Oct 4,458,478 4,203,108 ‐5.73%
Nov 4,852,563 4,567,758 ‐5.87%
Dec 5,276,859 4,982,229 ‐5.58%
Percent of budget expended 94.42%
Human YTD Annual % $1 40
Millions Human Services
$‐
$1
$2
$3
$4
$5
$6
Millions Recreation
Budget
Actual
Last Year
Services Budget Actual over (under)
Jan 54,440 58,787 7.99%
Feb 117,117 130,666 11.57%
Mar 194,189 266,033 37.00%
Apr 379,480 409,836 8.00%
May 481,847 478,640 ‐0.67%
Jun 548,008 546,207 ‐0.33%
Jul 727,654 682,779 ‐6.17%
Aug 805,280 748,587 ‐7.04%
Sep 873,474 797,375 ‐8.71%
Oct 1,021,819 948,716 ‐7.15%
Nov 1,113,747 1,019,454 ‐8.47%
Dec 1,298,201 1,193,871 ‐8.04%
Percent of budget expended 91.96%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
Budget
Actual
Last Year
Page 31 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
Neighborhoods
, Resources,
and Events Budget
YTD
Actual
Annual %
over (under)
Jan 44,479 46,222 3.92%
Feb 88,386 89,449 1.20%
Mar 135,715 144,802 6.70%
Apr 191,514 189,349 ‐1.13%
May 245,758 235,954 ‐3.99%
Jun 329,789 293,480 ‐11.01%
Jul 411,262 369,868 ‐10.07%
Aug 484,411 429,999 ‐11.23%
Sep 548,933 486,854 ‐11.31%
Oct 594,146 541,153 ‐8.92%
Nov 656,233 633,941 ‐3.40%
Dec 775,917 701,673 ‐9.57%
Percent of budget expended 90.43%
YTD Annual % $2 50
Millions Library Fund
$‐
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
$700,000
$800,000
Neighborhoods, Resources, and Events
Budget
Actual
Last Year
Library Fund Budget Actual over (under)
Jan 11,378 2,500 ‐78.03%
Feb 15,108 5,000 ‐66.90%
Mar 32,782 7,500 ‐77.12%
Apr 33,282 58,604 76.08%
May 69,632 61,106 ‐12.24%
Jun 185,886 263,606 41.81%
Jul 222,236 266,106 19.74%
Aug 222,398 268,606 20.78%
Sep 228,570 271,106 18.61%
Oct 277,677 273,606 ‐1.47%
Nov 278,324 276,106 ‐0.80%
Dec 278,603 278,604 0.00%
Percent of budget expended 100.00%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
Budget
Actual
Last Year
Page 32 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
Museum Fund Budget
YTD
Actual
Annual %
over (under)
Jan 17,252 17,791 3.12%
Feb 34,965 35,736 2.21%
Mar 52,434 53,787 2.58%
Apr 70,241 71,901 2.36%
May 88,071 90,015 2.21%
Jun 106,029 108,238 2.08%
Jul 124,048 126,037 1.60%
Aug 141,990 144,117 1.50%
Sep 160,056 162,485 1.52%
Oct 177,858 180,695 1.59%
Nov 195,702 199,085 1.73%
Dec 213,533 216,887 1.57%
Percent of budget expended 101.57%
Public Works YTD Annual % $0 60
Millions Public Works Admin
$‐
$30,000
$60,000
$90,000
$120,000
$150,000
$180,000
$210,000
Museum Fund
Budget
Actual
Last Year
Admin Budget Actual over (under)
Jan 38,441 39,864 3.70%
Feb 77,369 79,440 2.68%
Mar 116,179 119,164 2.57%
Apr 154,878 158,967 2.64%
May 193,891 197,642 1.93%
Jun 232,725 236,629 1.68%
Jul 271,807 275,725 1.44%
Aug 311,339 315,216 1.25%
Sep 350,878 354,626 1.07%
Oct 388,230 392,554 1.11%
Nov 426,925 430,641 0.87%
Dec 465,889 470,051 0.89%
Percent of budget expended 100.89%
$‐
$0.20
$0.40
$0.60
Budget
Actual
Last Year
Page 33 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
Street
Maintenance Budget
YTD
Actual
Annual %
over (under)
Jan 279,287 285,940 2.38%
Feb 611,900 614,685 0.46%
Mar 918,371 935,153 1.83%
Apr 1,215,152 1,217,508 0.19%
May 1,515,424 1,525,151 0.64%
Jun 1,821,797 1,857,066 1.94%
Jul 2,128,792 2,168,603 1.87%
Aug 2,447,569 2,463,011 0.63%
Sep 2,764,011 2,757,612 ‐0.23%
Oct 3,088,569 3,053,814 ‐1.13%
Nov 3,403,987 3,368,565 ‐1.04%
Dec 3,728,945 3,755,640 0.72%
Percent of budget expended 100.72%
YTD Annual %
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
Millions Street Maintenance
Budget
Actual
Last Year
$5 0
Millions Transportation
Transportation Budget Actual over (under)
Jan 347,406 288,400 ‐16.98%
Feb 740,928 660,477 ‐10.86%
Mar 1,157,753 1,000,881 ‐13.55%
Apr 1,503,626 1,428,601 ‐4.99%
May 1,890,393 1,806,575 ‐4.43%
Jun 2,314,346 2,150,841 ‐7.06%
Jul 2,673,048 2,561,195 ‐4.18%
Aug 3,094,333 2,910,811 ‐5.93%
Sep 3,467,142 3,316,587 ‐4.34%
Oct 3,889,049 3,699,159 ‐4.88%
Nov 4,270,515 4,086,739 ‐4.30%
Dec 4,763,972 4,615,160 ‐3.12%
Percent of budget expended 96.88%
$0.0
$0.5
$1.0
$1.5
$2.0
$2.5
$3.0
$3.5
$4.0
$4.5
$5.0
Budget
Actual
Last Year
Page 34 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
Debt Service Budget
YTD
Actual
Annual %
over (under)
Jan 1,315 ‐ 0.00%
Feb 109,009 250,317 129.63%
Mar 147,735 250,317 69.44%
Apr 147,758 842,026 469.87%
May 2,038,353 856,385 ‐57.99%
Jun 2,523,077 1,905,620 ‐24.47%
Jul 2,523,077 1,905,620 ‐24.47%
Aug 2,665,924 2,158,688 ‐19.03%
Sep 5,604,283 2,158,688 ‐61.48%
Oct 5,604,283 2,747,599 ‐50.97%
Nov 5,713,490 2,747,599 ‐51.91%
Dec 7,556,084 7,437,337 ‐1.57%
Percent of budget expended 98.43%
Non‐
Departmental YTD Annual % $5 00
Millions Non‐Departmental Other City Services
$‐
$2
$4
$6
$8
$10
$12
$14
$16
Millions Debt Service
Budget
Actual
Last Year
Other City Budget Actual over (under)
Jan 271,204 313,245 15.50%
Feb 1,077,897 649,480 ‐39.75%
Mar 1,393,975 886,227 ‐36.42%
Apr 1,739,359 1,176,929 ‐32.34%
May 2,294,326 1,375,197 ‐40.06%
Jun 2,511,114 1,597,673 ‐36.38%
Jul 2,802,080 1,863,974 ‐33.48%
Aug 3,039,041 2,072,373 ‐31.81%
Sep 3,272,380 2,298,266 ‐29.77%
Oct 3,463,598 2,519,291 ‐27.26%
Nov 3,609,992 2,705,438 ‐25.06%
Dec 4,660,315 4,637,555 ‐0.49%
Percent of budget expended 99.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 35 of 37
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2012 Budget Year
Utilities Budget Revenue Expense
Jan 4,249,300 4,860,643 3,270,986
Feb 10,156,860 9,712,888 7,451,062
Mar 16,768,202 15,372,251 11,393,139
Apr 22,007,388 20,105,679 15,700,049
May 27,265,171 25,621,490 19,760,057
Jun 38,024,123 30,561,965 25,608,749
Jul 44,706,754 36,536,725 30,837,617
Aug 50,441,862 41,774,863 35,411,926
Sep 57,497,690 47,449,846 39,860,995
Oct 64,463,232 53,197,620 45,185,106
Nov 71,144,317 58,842,489 49,563,198
Dec 82,324,519 63,735,507 67,279,683
Percent of budget expended 78.80%
Note: Operations and Capital
$0
$10
$20
$30
$40
$50
$60
$70
$80
$90
Millions Utilities
Budget
Revenue
Expense
$12 00
Millions Airport
Airport Budget Revenue Expense
Jan 716,145 182,302 131,563
Feb 1,283,046 480,547 293,170
Mar 1,914,140 679,165 431,819
Apr 2,610,035 909,193 601,497
May 3,149,699 1,114,820 823,315
Jun 4,221,031 1,360,778 1,122,991
Jul 4,919,456 1,744,572 1,261,393
Aug 6,130,412 1,950,517 1,464,878
Sep 7,073,054 2,169,957 1,602,471
Oct 8,321,067 2,442,272 1,894,436
Nov 9,288,920 2,668,625 2,033,515
Dec 10,125,047 2,894,741 2,636,527
Percent of budget expended 26.04%
Note: Operations and Capital
$‐
$2.00
$4.00
$6.00
$8.00
$10.00
$12.00
Budget
Revenue
Expense
Page 36 of 37
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2012 Budget Year
Golf Course Budget Revenue Expense
Jan 60,268 65,568 123,688
Feb 200,212 163,205 259,488
Mar 339,128 281,478 422,495
Apr 428,171 504,028 622,626
May 528,038 751,725 774,905
Jun 661,811 1,025,729 960,462
Jul 758,375 1,360,143 1,123,018
Aug 865,936 1,651,168 1,278,288
Sep 957,161 1,889,788 1,442,297
Oct 1,041,874 2,053,111 1,598,018
Nov 1,206,844 2,124,992 1,731,928
Dec 2,637,204 2,188,915 2,264,588
Percent of budget expended 85.87%
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