HomeMy WebLinkAbout201210, October.pdfFINANCE AND
INFORMATION TECHNOLOGY
M E M O R A N D U M
DATE: November 20, 2012
TO: Rich Zwicker, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: October 2012 Financial Status Report
At the end of October, general governmental revenues show $1.4 million or 1.7% over budget.
Revenues sources that are higher than expected are: property taxes ($3.2 million); sales tax
($357k); real estate excise taxes ($304k); building permits & development service fees ($640k);
and state shared revenues ($290k). On the down side, the revenue sources that are
underperforming the year to date budget are: admission tax ($40k); franchise fees ($59k
below); utility taxes ($229k below); culture and recreation fees ($152k below); interfund/inter‐
departmental services ($200k below); and other financing sources ($3.1 million). Property
taxes are higher than expected due to receipting $2.8 million (approximately) of November’s
collection in October and other financing sources are lower than expected due to transfers
(budget approved in October) that will be completed in December. If we take these two items
out, the City is actually $1.3 million or 1.6% over budget.
General government expenditures showed favorable variance of $1.6 million or 1.9%. 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 24,338,474 32,357,894 24,730,752 32,896,746 24,750,333 27,977,440 3,227,107 13.0%
Sales Tax 17,198,220 14,286,571 17,729,731 14,796,945 17,864,000 14,873,225 15,230,341 357,116 2.4%
Sales Tax ‐ Annexation Credit 2,025,660 1,682,805 2,033,954 1,685,852 2,101,647 1,741,960 1,813,119 71,159 4.1%
Criminal Justice Sales Tax 1,620,479 1,342,404 1,809,757 1,511,674 1,867,145 1,559,609 1,582,396 22,787 1.5%
Natural Gas Use Tax 228,514 197,823 249,407 219,454 270,394 237,920 247,977 10,056 4.2%
Admission Tax 291,399 290,937 308,200 308,200 350,000 350,000 309,809 (40,191) ‐11.5%
Franchise Fees 1,222,444 1,177,275 1,234,448 1,187,337 1,323,000 1,272,509 1,213,993 (58,517) ‐4.6%
Electricity Tax 5,036,907 4,132,699 5,166,711 4,253,979 5,283,280 4,349,955 4,310,830 (39,125) ‐0.9%
Natural Gas Utility Tax 1,577,756 1,273,974 1,848,806 1,529,264 1,950,000 1,612,968 1,399,177 (213,791) ‐13.3%
Transfer Station 269,912 238,487 297,474 229,158 248,762 191,633 262,775 71,142 37.1%
TV Cable 1,296,744 1,138,067 1,385,275 1,136,842 1,427,679 1,171,641 1,171,936 295 0.0%
Telephone 1,038,009 860,359 966,827 806,570 1,000,000 834,244 813,315 (20,929) ‐2.5%
Cellular Phone 2,206,637 1,848,037 2,054,183 1,759,414 2,309,360 1,977,974 1,833,559 (144,415) ‐7.3%
City Utilities 2,853,884 2,393,944 3,516,179 2,956,654 3,665,728 3,082,406 3,190,191 107,785 3.5%
Leasehold Excise Tax 138,830 104,082 162,593 123,748 145,000 110,358 120,295 9,936 9.0%
Gambling Excise Tax 1,546,386 1,305,148 1,671,414 1,361,499 1,600,000 1,303,327 1,360,838 57,511 4.4%
Real Estate Excise Tax 2,464,489 1,843,473 2,074,059 1,572,835 2,767,521 2,070,186 2,190,857 120,670 5.8%
Less: Municipal Facilities CIP REET (400,000) (400,000) (400,000) (280,863) (943,588) (662,548) (479,521) 183,028 ‐27.6%
EMS Levy 1,161,114 870,794 868,873 727,762 1,007,976 442,891 442,891 (0) 0.0%
Business License Fees 431,782 407,410 442,451 421,473 469,817 447,542 428,824 (18,718) ‐4.2%
Other Licenses and Permits 262,629 203,462 232,534 158,673 213,305 145,552 197,694 52,142 35.8%
Building Permits & Development Svc Fees 2,437,270 2,141,711 2,772,779 2,327,048 2,466,063 2,074,859 2,714,841 639,981 30.8%
Intergovt'l (Grants, State Shared, etc) 4,426,676 3,696,624 4,737,323 3,576,821 4,398,140 3,672,949 3,940,629 267,680 7.3%
Fire District 25 and 40 Contracts 5,252,877 2,770,532 6,110,668 3,877,364 6,008,694 3,873,531 3,873,531 ‐ 0.0%
Public Safety 482,343 384,944 484,985 395,894 430,635 351,528 391,266 39,738 11.3%
Culture and Recreation 1,424,932 1,307,790 1,493,540 1,367,121 1,660,863 1,520,281 1,367,834 (152,447) ‐10.0%
Interfund/Interdept‐Services 3,190,908 2,651,099 3,070,506 2,494,993 3,617,185 2,939,206 2,738,728 (200,478) ‐6.8%
Fines and Forfeits 1,291,817 995,201 1,163,602 893,279 1,088,750 839,490 801,543 (37,947) ‐4.5%
Photo Enforcement 1,925,159 1,558,745 1,897,782 1,510,396 1,944,713 1,547,747 1,639,547 91,800 5.9%
Seizure Funds ‐ Federal/State/Local 221,046 214,093 83,220 80,903 180,693 175,663 31,767 (143,896) ‐81.9%
Interests and Other Earnings 183,511 156,090 107,183 84,753 125,400 99,158 82,703 (16,455) ‐16.6%
Rents, Leases, and Concessions 727,338 666,168 744,834 649,692 701,464 611,861 718,136 106,274 17.4%
Contributions and Donations 133,756 127,729 196,586 181,300 82,750 76,316 118,098 41,782 54.7%
Other Miscellaneous 434,286 374,595 529,147 380,209 427,358 274,719 429,160 154,441 56.2%
Other Financing Sources (Transfer‐In, etc) 653,595 653,436 1,073,507 698,929 5,073,886 3,303,455 162,266 (3,141,189) ‐95.1%
Total Operating Revenues 96,754,435 77,234,978 100,476,431 79,715,923 106,024,365 83,224,450 84,628,784 1,404,334 1.7%
OPERATING EXPENDITURES
Legislative 259,345 214,315 271,236 226,026 284,087 235,771 231,423 4,347 1.8%
Executive 1,578,526 1,322,666 1,566,906 1,256,119 1,468,694 1,204,110 1,113,782 90,328 7.5%
Hearing Examiner 174,447 144,975 59,878 47,132 71,025 58,229 47,687 10,541 18.1%
City Attorney 1,565,597 1,306,058 1,596,609 1,320,953 1,733,686 1,440,264 1,426,459 13,805 1.0%
Court Services 2,007,599 1,657,900 2,084,170 1,729,013 2,155,819 1,784,453 1,728,593 55,860 3.1%
Community and Eco Dvlpmnt Admin 579,396 483,545 929,814 775,550 952,912 794,989 784,676 10,314 1.3%
Development Services 2,946,413 2,456,933 2,810,736 2,342,934 3,434,929 2,863,779 2,554,601 309,178 10.8%
Economic Development 1,293,536 1,055,795 659,981 551,565 676,136 556,327 434,361 121,966 21.9%
Planning 1,774,508 1,513,880 1,447,781 1,200,417 1,516,719 1,277,610 1,231,243 46,366 3.6%
Finance 2,214,458 1,562,272 2,134,667 1,564,657 2,161,836 1,554,314 1,627,884 (73,570) ‐4.7%
City Clerk 789,209 685,906 736,880 629,142 1,002,105 863,525 802,631 60,895 7.1%
Human Resources 861,221 710,580 888,252 714,653 946,956 771,451 776,279 (4,828) ‐0.6%
Police 23,946,386 19,826,238 24,737,346 20,539,728 25,214,618 20,906,623 20,646,141 260,482 1.2%
Jail Services 3,539,035 2,597,714 6,206,735 2,878,331 4,315,888 2,907,126 2,907,126 ‐ 0.0%
Fire 21,554,792 17,886,044 22,511,597 18,890,028 24,138,681 20,145,192 20,229,262 (84,070) ‐0.4%
Community Services Admin 1 1,063,011 886,316 416,284 340,122 421,043 349,074 354,172 (5,098) ‐1.5%
Parks 3,421,424 2,832,755 3,829,676 3,168,880 4,045,762 3,348,621 3,282,805 65,817 2.0%
Parks Planning & Natural Resources 448,574 364,453 551,423 455,741 685,122 561,935 471,166 90,768 16.2%
Recreation 4,433,420 3,721,997 4,974,002 4,226,441 5,276,859 4,458,478 4,203,108 255,370 5.7%
Human Services 1,326,778 1,015,658 1,247,294 1,010,405 1,277,487 1,005,515 948,716 56,800 5.6%
Neighborhoods, Resources, & Events 359,690 275,406 675,534 517,299 775,917 594,146 541,153 52,993 8.9%
Library 2,289,692 2,280,221 2,030,000 2,025,119 278,603 273,606 273,606 ‐ 0.0%
Museum 191,090 159,284 210,620 175,314 213,533 177,858 180,695 (2,837) ‐1.6%
Public Works Admin 1 514,858 429,145 452,538 376,995 465,889 388,230 392,554 (4,324) ‐1.1%
Street Maintenance 3,412,892 2,813,270 3,534,025 2,940,646 3,728,945 3,088,569 3,053,814 34,755 1.1%
Transportation 5,215,309 4,264,455 4,509,066 3,673,999 4,763,972 3,889,049 3,699,159 189,890 4.9%
Debt Service 4,707,100 1,303,524 4,822,566 1,398,850 9,871,084 2,747,599 2,747,599 ‐ 0.0%
Non‐Departmental and Other 4,834,296 2,784,616 4,930,383 4,472,604 4,660,315 2,519,291 2,519,291 ‐ 0.0%
Total Operating Expenditures 97,302,601 76,555,920 100,825,999 79,448,662 106,538,621 80,765,734 79,209,986 1,555,748 1.9%
Total Ending Fund Balance 11,407,119$ 12,634,343$ 11,057,551$ 11,674,380$ 10,543,295$ 13,516,267$ 16,476,349$ 2,960,082 21.9%
1Facilities was included in Community Services Admin and Technical Services was included in Public Works Admin in 2010
Favorable (Unfavorable)
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 October 2012
Page 1 of 36
Monthly Financial Report October 2012
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through October 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 75% of
all resources supporting general governmental activities. The following section provides detail information on property,
sales, utility, and other taxes.
Property Tax
October’s collection is $9.7 million,
making the total year‐to‐date
collection $28 million or 85% of the
total budget. In comparison to the
previous year, the City collected $2.7
million or 39% more. Compared to the
budget, the City is above projections
by $2.8 million or 41%. 2012’s
monthly budgets are based on 2009
through 2011 collections. The October
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. The City
has collected $5.4 million so far in November and if we combine October and November, the City has met the budget
projections.
Sales Tax
October 2012 sales tax receipts totalled
$1.7 million. Compared with the same
month last year, it is $143k or 9% more.
Compared to the projected current
month’s budget, it is $132k or 9% above.
The year‐to‐date collection of $15.2 million
is $433k or 3% more than the prior year
and is also $357k or 2% more than
budgeted. The City is projecting sales tax
revenues to meet the budget at year‐end.
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
Dec 279,117 171,812
YTD Total 24,730,752$ 24,750,333$ 27,977,440$ 3,246,688$ 13% 3,227,107$ 13%
Annual Total 32,357,894$ 32,896,746$
Property Tax Revenues
Year to Date through October
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 ‐
Dec 1,423,832 1,467,796 ‐
YTD Total 14,796,945$ 14,873,225$ 15,230,341$ 433,396$ 3% 357,116$ 2%
Annual Total 17,729,731$ 17,864,000$
2012 vs. Budget2012 vs. 2011
Month
Year to Date through October
Local Retail Sales Tax Revenues
Page 2 of 36
Monthly Financial Report October 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,285,755$ 1,372,408$ 1,412,496$ 126,741$ 10%$ 40,088 3%
Auto Sales 2,676,092 2,920,500 2,796,261 120,169 4% (124,239)‐4%
General Retail 5,075,322 5,255,222 5,376,059 300,737 6% 120,837 2%
Manufacturing 880,316 584,944 855,748 (24,568) ‐3% 270,804 46%
Wholesale 962,329 991,970 961,142 (1,187) 0% (30,828)‐3%
Service 3,283,040 3,382,730 3,471,139 188,100 6% 88,409 3%
Other 634,092 365,452 357,497 (276,595) ‐44% (7,955)‐2%
Total 14,796,945$ 14,873,225$ 15,230,341$ 433,396$ 3%357,116$ 2%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility tax
October utility tax revenues are $1.1
million, which is $76k or 6% lower than
the same month last year and is also
behind the budget by $126k or 10%. The
year‐to‐date collection is $13.2 million,
which is $338k or 3% higher than the prior
year but is $229k or 2% 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 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 4,253,979$ 4,349,955$ 4,310,830$ 56,851$ 1%$ (39,125)‐1%
Natural Gas 1,748,718 1,850,889 1,647,154 (101,564) ‐6% (203,735)‐11%
Cell 1,759,414 1,977,974 1,833,559 74,145 4% (144,415)‐7%
Phone 806,570 834,244 813,315 6,745 1% (20,929)‐3%
Cable 1,136,842 1,171,641 1,171,936 35,094 3% 295 0%
Transfer Station 229,158 191,633 262,775 33,617 15% 71,142 37%
City Utilities 2,956,654 3,082,406 3,190,191 233,536 8% 107,785 3%
YTD Total 12,891,335$ 13,458,742$ 13,229,760$ 338,425$ 3%(228,982)$ ‐2%
Annual Total 15,484,862$ 16,155,203$
YTD as % of 83% 83%
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
Dec 1,360,887 1,415,147
YTD Total 12,891,335$ 13,458,742$ 13,229,760$ 338,425$ 3% (228,982)$ ‐2%
Annual Total 15,484,862$ 16,155,203$
2012 vs. Budget2012 vs. 2011
Year to Date through October
Utility Tax Revenues
Month
Page 3 of 36
Monthly Financial Report October 2012
Other Taxes
Real Estate Excise Tax
The City collected $326k in Real Estate Excise
Tax revenues (REET) for October. This is $136k
or 72% ahead of the same month last year and
$76k or 31% above the current month’s
budget. The year‐to‐date collection is $2.2
million, which is $618k or 39% more than the
prior year and is also $121k or 6% above the
budget. The City is projecting REET to exceed
the budget at year‐end.
Gambling Tax
October’s Gambling Tax collections
total $87k. Year‐to‐date total of $1.4
million is right on target with the year
before and is $58k or 4% 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. The City is projecting gambling tax revenues to meet the
budget at year‐end.
Pull tabs overall had a 5% decrease, bingo increased by 35%, 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.2
million or 92% of the budget. This is $27k
or 2% higher than 2011 but is $59k or 5%
below the projected year‐to‐date budget.
The City is projecting franchise fees to be
slighting under budget at year‐end.
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
Dec 165,331 255,227
YTD Total 1,572,835$ 2,070,186$ 2,190,857$ 618,022$ 39% 120,670$ 6%
Annual Total 2,074,059$ 2,767,521$
Month
2012 vs. Budget2012 vs. 2011
Real Estate Excise Tax Revenues
Year to Date through October
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 ‐
Dec 170,897 163,595 ‐
YTD Total 1,361,499$ 1,303,327$ 1,360,838$ (661)$ 0% 57,511$ 4%
Annual Total 1,671,414$ 1,600,000$
Year to Date through October
2012 vs. 2011 2012 vs. Budget
Gambling Tax Revenue
Month
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 ‐
YTD Total 1,187,337$ 1,272,509$ 1,213,993$ 26,656$ 2% (58,517)$ ‐5%
Annual Total 1,234,448$ 1,323,000$
Month
2012 vs. 2011 2012 vs. Budget
Franchise Fees Revenue
Year to Date through October
Page 4 of 36
Monthly Financial Report October 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 $3k or 1%
from the year before but is $38k or 11%
less than anticipated. The City is
projecting admission tax revenues to be
under the budget at year‐end.
Licenses and Permits
Building Permits and Development Service
Fees
Building Permits and Development Service
Fee revenues totalled $407k in October. The
year‐to‐date development fees revenue of
$2.7 million is $388k or 17% more than 2011
and is also $640k or 31% 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. The City has met
the budget for building permits and
development service fee revenues.
Business Licenses
Business Licenses totalled $100k for October, which is
$4k or 4% above the same month last year but is $2k
or 2% below the current month’s budget. The year‐
to‐date Business Licenses revenue is over the prior
year by $7k or 2% but is $19k or 4% 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. The
City is projecting business licenses to be slightly under
the budget at year‐end.
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%
YTD Total 308,200$ 350,000$ 309,809$ 3,210$ 1% (38,372)$ ‐11%
Annual Total 308,200$ 350,000$
Month
2012 vs. 2011 2012 vs. Budget
Admission Tax Revenue
Year to Date through October
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
Dec 216,409 194,437
YTD Total 2,327,048$ 2,074,859$ 2,714,841$ 387,793$ 17% 639,981$ 31%
Annual Total 2,772,779$ 2,466,063$
Building Permits and Development Service Fees
Year to Date through October
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 ‐
Dec 2,686 2,852 ‐
YTD Total 421,473$ 447,542$ 428,824$ 7,351$ 2% (18,718)$ ‐4%
Annual Total 442,451$ 469,817$
2012 vs. 2011
Year to Date through October
2012 vs. Budget
Business Licenses
Month
Page 5 of 36
Monthly Financial Report October 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 84% of
the total revenues in this
category. The year‐to‐date total Intergovernmental revenue is $9.4 million or 77% of the budget.
State Shared Revenues
State Shared Revenue collections
totalled $4 million since the start of
2012. Compared to the prior year,
State Shared Revenues are above by
$221k or 6%. Compared to the
projected budget, the City is
collecting $290k or 8% more. The
higher than expected collections are
due to Criminal Justice’s High Crime
not being budgeted for 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. The City is projecting the
total state shared revenues to exceed the budget at year‐end.
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 73% of the total revenue in this category. The year‐to‐date total charges for services are $5.6 million or 84% of
the budget. This is right on target with budget projections. The following sections provide detail information for Public
Safety, Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totalled $391k since the
start of the year. These services include private
security, adult probation services, and
housing/monitoring of prisoners. Compared to
the prior year, the City is collecting $5k or 1%
less. Compared to the budget, the City is
collecting $40k or 11% more than anticipated
revenue. The City is projecting public safety
services revenues to meet the budget at year‐
end.
Intergovernmental 2011 2012 Bgt YTD Act Change 2012/2011 2012 Act vs Bgt
Fire District #25 1,349,353$ 1,345,623$ 1,345,623$ (3,730)$ 0% $ ‐ 0%
Fire District #40 2,528,011 2,527,908 2,527,908 (103) 0%‐ 0%
State Shared Revenue 3,829,039 3,759,339 4,049,806 220,766 6% 290,467 8%
Federal Grants 459,202 837,888 837,888 378,686 82%‐ 0%
State Grants 140,420 122,060 122,060 (18,361) ‐13%‐ 0%
Other Grants/Intgovt 130,416 119,280 119,280 (11,136) ‐9%‐ 0%
ARRA Grants 529,417 393,992 393,992 (135,425) ‐26%‐ 0%
Total Rev YTD 8,965,859$ 9,106,090$ 9,396,556$ 430,697$ 5%290,467$ 3%
Total Rev Annual 12,657,748$ 12,273,979$
YTD %71% 74% 77%
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 ‐
Dec 46,148 40,976 ‐
YTD Total 395,894$ 351,528$ 391,266$ (4,628)$ ‐1% 39,738$ 11%
Annual Total 484,985$ 430,635$
Month
2012 vs. 2011
Year to Date through October
Public Safety Services
2012 vs. Budget
2011 2012 2012
Actual Budget Actual $ % $ %
Crim Just Sales Tax 1,511,674$ 1,559,609$ 1,582,396$ 70,722$ 5% 22,787$ 1%
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 485,460 497,825 717,552 232,091 48% 219,727 44%
Liquor Excise Tax 440,422 450,000 342,495 (97,928) ‐22% (107,505) ‐24%
Fuel Tax 1,066,366 1,060,698 1,071,224 4,858 0% 10,526 1%
YTD Total 3,829,039$ 3,759,339$ 4,049,806$ 220,767$ 6% 290,467$ 8%
Annual Total 4,495,551$ 4,437,913$
Year to Date through October
State Shared Revenues
2012 vs. 2011
Revenue
2012 vs. Budget
Page 6 of 36
Monthly Financial Report October 2012
Recreation
Recreation revenues totalled $86k for the
current month. Compared to the same
month the prior year, the City collected $2k
or 3% more. Compared to the projected
monthly budget, the City collected $7k or 7%
less. The year‐to‐date collection of $1.4
million is right on target with the prior year
but is $152k 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 projected savings
of $250k 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 $244k or 10%. Compared to the
projected budget, the revenues are below by
$200k 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,
Transportation division’s capital investment
program reimbursements, and Maintenance
division’s street maintenance
reimbursements. The budget variance is due
to January and February maintenance activity
that was not recorded in those months and was corrected in March. The City projects interfund service revenues to be
under budget by year‐end.
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 $2.4 million.
This is $15k or 1% lower than a year ago
and is also $116k or 5% under the budget.
The City is projecting fines and penalties to
be slightly under the budget at year‐end.
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 ‐
Dec 48,890 54,368 ‐
YTD Total 1,367,121$ 1,520,281$ 1,367,834$ 713$ 0% (152,447)$ ‐10%
Annual Total 1,493,540$ 1,660,863$
Recreation
Year to Date through October
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 ‐
Dec 308,654 363,607 ‐
YTD Total 2,494,993$ 2,939,206$ 2,738,728$ 243,736$ 10% (200,478)$ ‐7%
Annual Total 3,070,506$ 3,617,185$
2012 vs. Budget
Month
Interfund Services
Year to Date through October
2012 vs. 2011
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
Dec 352,911 352,016
YTD Total 2,461,973$ 2,562,900$ 2,447,311$ (14,662)$ ‐1% (115,589)$ ‐5%
Annual Total 3,112,464$ 3,214,156$
Month
2012 vs. Budget2012 vs. 2011
Year to Date through October
Fines and Penalties by Month
Page 7 of 36
Monthly Financial Report October 2012
Year to Date through October
2011 2012 2012
Actual Budget Actual $ % $ %
Civil Penalties 8,728$ 12,213$ 6,815$ (1,913)$ ‐22% (5,398)$ ‐44%
Civil Infraction Penalties 560,113 600,893 477,850 (82,263) ‐15% (123,043) ‐20%
Civil Parking Infraction Penalties 106,738 116,410 99,889 (6,848) ‐6% (16,520) ‐14%
Photo Enforcement Program 1,510,396 1,547,747 1,639,547 129,151 9% 91,800 6%
Criminal Traffic Misdemeanor Fines 76,151 68,937 68,230 (7,920) ‐10% (707) ‐1%
Criminal Non‐Traffic Fines 23,665 30,413 21,313 (2,353) ‐10% (9,100) ‐30%
Criminal Costs 94,219 8,894 101,233 7,014 7% 92,339 1038%
Seizure Funds ‐ Federal/State/Local 80,903 175,663 31,767 (49,136) ‐61% (143,896) ‐82%
Non‐Court Fines, Forfeitures and Penalties 1,060 1,731 668 (393) ‐37% (1,063) ‐61%
YTD Total 2,461,973$ 2,562,900$ 2,447,311$ (14,662)$ ‐1% (115,589)$ ‐5%
Annual Total 3,112,464$ 3,214,156$
2012 vs. 2011
Revenue
2012 vs. Budget
Fines and Penalties by Ty pe
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 $1.6 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 69% of the total
revenue in this category. The year‐to‐date
total miscellaneous is $1.2 million.
Compared to last year, the revenues are
over by $59k or 5%. Compared to the
projected year‐to‐date budget, the
revenues are over by $300k or 35%. 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 ‐ 71,884 ‐ ‐
Dec 185,536 ‐ 72,273 ‐ ‐
YTD Total 1,547,747$ 1,639,547$ 697,807$ 646,313$ 993,234$
Annual Total 1,944,713$ 841,964$
1 Actuals of Revenues and Expenses
Expenses
Photo Enforcement Program
Year to Date through October
Month
Revenues
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 143,105$ 128,460$ 206,151$ 63,046$ 44% 77,691$ 60%
Feb 70,237 47,134 83,823 13,585 19% 36,688 78%
Mar 99,131 78,037 104,421 5,289 5% 26,384 34%
Apr 74,048 58,078 98,164 24,115 33% 40,086 69%
May 97,083 85,466 145,213 48,130 50% 59,748 70%
Jun 145,018 113,860 93,832 (51,185) ‐35% (20,028) ‐18%
Jul 173,878 119,269 112,316 (61,562) ‐35% (6,953) ‐6%
Aug 133,570 99,866 143,389 9,819 7% 43,523 44%
Sep 97,973 76,287 89,588 (8,385) ‐9% 13,300 17%
Oct 75,425 61,830 91,608 16,183 21% 29,778 48%
Nov 77,427 67,666
Dec 163,299 164,495
YTD Total 1,109,469$ 868,288$ 1,168,505$ 59,036$ 5% 300,217$ 35%
Annual Total 1,350,195$ 1,100,449$
Year to Date through October
Month
2012 vs. Budget2012 vs. 2011
Miscellaneous Revenues by Month
Page 8 of 36
Monthly Financial Report October 2012
2011 2012 2012
Actual Budget Actual $ % $ %
Interests and Other Earnings 84,753$ 99,158$ 82,703$ (2,050)$ ‐2% (16,455)$ ‐17%
Rents, Leases, and Concessions 649,692 611,861 718,136 68,444 11% 106,274 17%
Contributions/Donations from Private Sources 181,300 76,316 118,098 (63,202) ‐35% 41,782 55%
Other 193,724 80,953 249,568 55,844 29% 168,615 208%
YTD Total 1,109,469$ 868,288$ 1,168,505$ 59,036$ 5% 300,217$ 35%
Annual Total 1,350,195$ 1,100,449$
2012 vs. Budget
Miscellaneous Revenues by Type
Year to Date through October
Revenue
2012 vs. 2011
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 favorable 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 74% of its budgeted general governmental expenditures at the end of October. This is $1.6
million or 1.9% below year‐to‐date budgeted expenditures. See below for summary of unfavorable items for general
governmental departments.
Administrative Services Department (Finance and City Clerk) is over the year‐to‐date budget by $13k or 1%. This is due to
the spending patterns of the 1st, 2nd, and 3rd Quarter of 2012 compared to 2010 and 2011. The year‐to‐date budget should
even out later in the year. We will continue to monitor these items to determine if a budget adjustment is needed.
Human Resources and Risk Management Department (HR only) is over the year‐to‐date budget by $5k or 0.6%. This is due
to over spending salaries/benefits and professional services and under spending on supplies/small tools.
Fire and Emergency Services Department is over the year‐to‐date budget by $84k or 0.4%. This is mainly due to over
spending on salaries/benefits ($84k), supplies ($167k) and intergovernmental ($68k) and under spending on professional
services ($161k) and capital ($59k).
Page 9 of 36
Monthly Financial Report October 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 ‐ ‐ ‐ ‐ 36,740 30,975 ‐
Grants / intergovernmental 411,461 5,278 107,838 75,060 2,527 573,011 ‐
Charges for services 103,508 1,664,181 12,544,271 12,153,719 7,070,095 6,627,546 11,366,298
Interdepartmental services ‐ ‐ 5,060 313,133 175,600 469,469 ‐
Fines and penalties ‐ ‐ ‐ ‐ ‐ ‐ ‐
Rents, leases, and misc fees 1,919,914 329,649 67,919 113,339 ‐ ‐ ‐
Interest and other misc 7,388 4,003 14,061 335,679 752,934 358,437 3,955
TOTAL REVENUES 2,442,271 2,003,111 12,739,149 12,990,930 8,037,896 8,059,438 11,370,253
EXPENSES:
Utility billing ‐ ‐ 90,976 82,951 65,099 98,629 ‐
Utility systems ‐ ‐ 11,776,122 2,525,391 2,153,532 1,860,837 ‐
Utility maintenance ‐ ‐ 242,740 3,987,670 1,063,447 1,502,515 10,762,135
Transportation 1,124,532 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 1,515,122 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 1,124,532 1,515,122 12,109,838 6,596,012 3,282,078 3,461,981 10,762,135
AMOUNT AVAILABLE FOR DEBT SERVICE 1,317,739 487,989 629,311 6,394,918 4,755,818 4,597,457 608,118
DEBT SERVICE:
Principal 94,888 ‐ ‐ 1,093,925 741,076 144,290 ‐
Interest 10,316 ‐ ‐ 427,482 217,689 182,423 ‐
TOTAL DEBT SERVICE 105,204 ‐ ‐ 1,521,407 958,765 326,713 ‐
CAPITAL PROJECTS 601,550 32,896 ‐ 2,270,647 1,857,060 2,028,375 ‐
TRANSFERS IN/(OUT)(63,149) ‐ ‐ ‐ (10,094) ‐ ‐
CHANGE IN FUND BALANCE 547,836 455,093 629,311 2,602,864 1,929,899 2,242,369 608,118
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, Oct 31 2,632,546 1,070,581 2,364,045 10,245,370 3,139,255 6,452,968 1,685,923
Page 10 of 36
Monthly Financial Report October 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 ‐ 84,439 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental 747 66,501 1,915 ‐ ‐ ‐ 43,637
Charges for services
Equipment rental m&o 1,863,405 1,763,810 ‐ ‐ ‐ ‐ ‐
Telecommunications ‐ 155,343 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 88,909 ‐ 330,965 ‐ ‐ ‐
Communications ‐ 3,500 ‐ 511,548 ‐ ‐ ‐
Facilities ‐ ‐ 3,477,925 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 125,120 ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ 263,430 ‐ ‐ ‐ ‐ ‐
Geographical information systems ‐ 164,028 ‐ ‐ ‐ ‐ ‐
Interest and other misc 13,297 6,274 1,742 591 19,336 22,602 17,792
Internal service fund misc:
Vehicle / equipment capital recovery 799,596 785,661 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 1,303,485 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 1,174,607 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 9,133,900 1,839,797
Other misc 916 201 6,356 126 199 567,989 ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets 1,000 ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 61,069 9,639 139
TOTAL REVENUES 2,678,961 3,507,216 3,487,938 843,230 2,558,696 9,734,130 1,901,365
EXPENSES:
Communications 386,868
Equipment rental 2,062,070
Facilities 2,826,172
Healthcare 9,433,992
Information technology 2,771,764
Print and mail 314,613
Retiree healthcare 995,248
Risk management
Risk management 1,179,559
Unemployment 111,746
Worker's compensation 1,037,293
TOTAL EXPENSES 2,062,070 2,771,764 2,826,172 701,481 2,328,598 9,433,992 995,248
AMOUNT AVAILABLE FOR CAPITAL 616,891 735,452 661,765 141,749 230,098 300,138 906,117
CAPITAL PROJECTS 1,530,159 994,535 170,256 ‐ ‐ ‐ ‐
TRANSFERS IN 73,243 8,000 37,782 ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE (840,025) (251,083) 529,291 141,749 230,098 300,138 906,117
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, Oct 31 3,934,351 1,930,660 829,529 282,869 6,850,535 7,434,134 6,385,516
Page 11 of 36
Monthly Financial Report October 2012
FUND BALANCE
Page 13 shows the ending fund balance as of October 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 October, the City has $16.5 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
$5.4 million from the year’s beginning balance. October’s ending fund balance is over the anticipated General
Governmental Fund Balance of $13.5 million by $3 million or 21.9%. Although the ending fund balance is above
projections, it is consistent with the prior years’ trends since the City will receipt the second half of 2012 property taxes 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 12 of 36
Monthly Financial Report October 2012
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through October 31, 2012
Funds
Balance
01/01/2012
Budgeted
Revenue
Revenue
10/31/12
Total Funds
Available
Budgeted
Expenditure
Expenditure
10/31/12
Ending
Balance
GENERAL GOVERNMENT FUNDS:11,057,551 106,024,365 84,628,784 95,686,335 106,538,621 79,209,986 16,476,349
000 General 6,934,747 75,044,862 62,020,495 68,955,242 76,149,500 60,150,951 8,804,291
001 Community Services 1,413,050 11,302,259 9,106,475 10,519,525 11,126,074 8,790,445 1,729,080
003 Street 1,264,341 8,953,479 6,951,950 8,216,291 8,492,917 6,752,974 1,463,317
004 Community Dev Block Grant 8,339 305,961 174,922 183,261 303,281 247,430 (64,170)
005 Museum 52,620 216,220 216,607 269,227 213,533 180,695 88,531
006 Library 48,603 230,000 230,000 278,603 278,603 273,606 4,997
009 Farmers Market 87,437 75,500 75,817 163,254 78,629 61,958 101,296
010 Fire Memorial 1,953 ‐ (1,952) 1 ‐ ‐ 1
011 Fire Health & Wellness 36,858 25,000 21,063 57,921 25,000 4,327 53,594
031 Pa rk Memorial 177,758 ‐ 535 178,293 ‐ ‐ 178,293
201 Ltd GO Bonds Gen Govt Debt 591,257 1,982,075 1,735,678 2,326,935 1,982,075 149,359 2,177,576
215 Gen Govt Misc Debt Service 440,588 7,889,009 4,097,194 4,537,782 7,889,009 2,598,240 1,939,542
SPECIAL REVENUE FUNDS:
102 Arterial Street 158,974 600,000 504,967 663,941 600,000 600,000 63,941
108 Leased City Properties 488,500 844,049 483,146 971,646 749,232 488,137 483,509
110 Hotel Motel 243,556 265,000 252,425 495,981 442,050 397,919 98,062
118 Reserve for Paths & Trails 3,314 ‐ 8 3,322 3,314 ‐ 3,322
125 1% For Art 121,686 32,813 1,165 122,851 50,000 13,818 109,033
127 Cable Communication 185,968 85,000 79,115 265,083 235,674 10,046 255,037
135 Springbrook Wetlands Bank 663,556 ‐ 1,998 665,554 ‐ ‐ 665,554
CAPITAL PROJECT FUNDS (CIP):
303 Community Dev Mitigation 1,475,050 60,000 41,650 1,516,700 400,000 ‐ 1,516,700
304 Fire Mitigation 1,492,674 263,602 220,174 1,712,848 936,926 ‐ 1,712,848
305 Transportation Mitigation 657,187 30,000 52,779 709,966 450,000 450,000 259,966
316 Municipal Facilities CIP 3,745,546 3,054,112 941,957 4,687,503 6,453,264 1,327,038 3,360,465
317 Transportation CIP 3,422,219 23,568,336 12,248,391 15,670,610 26,945,419 16,924,693 (1,254,083)
318 So La ke WA Infrastructure Proj 52,792 ‐ 158 52,950 52,024 668 52,282
326 Housing Opportunity 130,546 ‐ 3,715 134,261 125,000 50,000 84,261
336 New Library Development 19,196,447 568,588 117,381 19,313,828 19,221,447 528,504 18,785,324
ENTERPRISE FUNDS:
402 Airport 494,718 1,299,150 1,158,073 1,652,791 1,307,780 1,129,889 522,902
403 Solid Waste Utility 1,734,734 15,021,811 12,739,148 14,473,882 15,486,501 12,109,838 2,364,044
404 Golf Course 379,997 2,483,545 2,002,351 2,382,348 2,492,204 1,565,122 817,226
422 Airport Capital 1,589,992 7,411,719 1,284,199 2,874,191 8,757,267 764,547 2,109,644
424 Golf Course Capital 235,491 50,000 50,760 286,251 145,000 32,896 253,355
INTERNAL SERVICE FUNDS:
501 Equipment Repair/Replacement 4,774,376 3,190,893 2,752,204 7,526,580 4,024,127 3,592,228 3,934,352
502 Insurance 6,620,437 3,187,593 2,558,697 9,179,134 4,850,146 2,328,599 6,850,535
503 Information Services 2,181,743 4,126,173 3,515,216 5,696,959 5,959,686 3,766,300 1,930,659
504 Facilities 300,238 4,372,734 3,525,720 3,825,958 4,389,399 2,996,428 829,530
505 Communications 141,120 974,307 843,231 984,351 991,015 701,481 282,870
512 Insurance, Healthcare 7,133,996 12,014,224 9,734,129 16,868,125 11,996,739 9,433,992 7,434,133
522 Insurance, Leoff1 Retirees HC 5,479,399 2,235,684 1,901,365 7,380,764 2,262,573 995,248 6,385,516
FIDUCIARY FUNDS:
611 Firemen's Pension 4,377,696 300,000 125,173 4,502,869 550,475 191,605 4,311,264
Funds
Balance
01/01/2012
Budgeted
Revenue
Revenue
10/31/12
Total Funds
Available
Budgeted
Expenditure
Expenditure
10/31/12
Ending
Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 14,140,266 50,050,145 40,458,520 54,598,786 53,712,104 33,075,267 21,523,519
405 Water Utility 3,993,415 11,106,460 10,199,018 14,192,433 11,226,288 8,117,418 6,075,015
406 Waste Water Utility 685,178 5,888,574 5,061,418 5,746,596 5,341,148 4,250,937 1,495,659
407 Surface Water Utility 1,625,915 5,637,563 5,093,481 6,719,396 5,696,281 3,801,336 2,918,060
416 King County Metro 1,077,805 13,209,387 11,370,253 12,448,058 13,209,387 10,762,135 1,685,923
425 Water Utility Construction 3,633,246 5,369,215 2,791,865 6,425,111 7,085,000 2,270,647 4,154,464
426 Waste Water Construction 524,178 3,310,000 2,976,478 3,500,656 3,710,000 1,857,060 1,643,596
427 Surface Water Construction 2,584,684 5,528,946 2,965,959 5,550,643 7,444,000 2,015,734 3,534,909
471 Waterworks Rate Stabilization 15,845 ‐ 48 15,893 ‐ ‐ 15,893
Note: Waterworks Utility Funds are managed as a system and are designated by the dotted lines.
Page 13 of 36
City of Renton
General Government Financial Position
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
December
2,000,000
3,000,000
4,000,000
5,000,000
6,000,000
7,000,000
8,000,000
9,000,000
60,000,000
70,000,000
80,000,000
90,000,000
100,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
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Page 14 of 36
City of Renton
Monthly Revenue Analysis ‐ 2012 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 5,209,553 5,169,136 ‐0.78%
Feb 10,715,953 10,715,775 0.00%
Mar 16,307,113 16,218,914 ‐0.54%
Apr 30,681,850 32,180,045 4.88%
May 46,193,805 46,051,336 ‐0.31%
Jun 51,214,145 51,288,412 0.15%
Jul 57,030,751 57,687,119 1.15%
Aug 62,614,473 63,335,690 1.15%
Sep 67,699,497 68,598,474 1.33%
Oct 83,224,450 84,628,784 1.69%
Nov 98,116,104
Dec 106,024,365
Percent of budget 79.82%
YTD Annual %
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
Millions
Total Revenue
General Government
Budget
Actual
Last Year
$33
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
Dec 32,896,746
Percent of budget 85.05%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
Budget
Actual
Last Year
Page 15 of 36
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
Dec 19,965,647
Percent of budget 85.36%
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
Dec 16,155,203
Percent of budget 81.89%
Note: Includes Natural Gas Use Tax.
$0
$2
$4
$6
$8
$10
$12
$14
$16
Budget
Actual
Last Year
Page 16 of 36
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
Dec 2,403,331
Percent of budget 98.87%
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
Millions Licenses & Permits
Budget
Actual
Last Year
Intergovt'l Budget Actual over (under)
Jan 401,119 462,865 15.39%
Feb 915,032 1,007,561 10.11%
Mar 1,358,397 1,389,752 2.31%
Apr 2,396,197 2,492,260 4.01%
May 5,070,068 5,142,362 1.43%
Jun 5,676,671 5,924,916 4.37%
Jul 6,433,449 6,681,592 3.86%
Aug 7,404,099 7,648,504 3.30%
Sep 7,833,634 8,187,190 4.51%
Oct 9,106,090 9,396,556 3.19%
Nov 11,534,274
Dec 12,273,979
Percent of budget 76.56%
Note: Includes CJ Sales Tax.
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
$10
$11
$12
$13
$14
Millions
Budget
Actual
Last Year
Page 17 of 36
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
Dec 6,691,060
Percent of budget 84.22%
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
Dec 3,214,156
Percent of budget 76.94%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Budget
Actual
Last Year
Page 18 of 36
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,816,675 1,919,894 5.68%
May 2,331,776 2,445,811 4.89%
Jun 2,722,283 2,895,320 6.36%
Jul 3,593,128 3,811,124 6.07%
Aug 3,910,925 4,148,648 6.08%
Sep 4,215,318 4,452,726 5.63%
Oct 4,886,723 5,166,341 5.72%
Nov 5,320,416
Dec 6,249,909
Percent of budget 82.66%
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,460 206,151 60.48%
Feb 175,594 289,974 65.14%
Mar 253,631 394,394 55.50%
Apr 311,709 492,558 58.02%
May 397,175 637,771 60.58%
Jun 511,035 731,604 43.16%
Jul 630,304 843,920 33.89%
Aug 730,170 987,309 35.22%
Sep 806,457 1,076,897 33.53%
Oct 868,288 1,168,505 34.58%
Nov 935,954
Dec 1,100,449
Percent of budget 106.18%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60 Budget
Actual
Last Year
Page 19 of 36
City of Renton
Monthly Revenue Analysis ‐ 2012 Budget Year
Other
Financing Budget
YTD
Actual
Annual %
over (under)
Jan ‐ ‐ N/A
Feb 3,805 90 ‐97.64%
Mar 15,019 5,494 ‐63.42%
Apr 790,055 8,797 ‐98.89%
May 792,693 143,912 ‐81.85%
Jun 794,824 144,143 ‐81.86%
Jul 796,549 144,991 ‐81.80%
Aug 799,188 145,543 ‐81.79%
Sep 801,268 160,342 ‐79.99%
Oct 3,303,455 162,266 ‐95.09%
Nov 3,304,723
Dec 5,073,886
Percent of budget 3.20%
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 173,600 77,631 ‐55.28%
Feb 280,482 291,768 4.02%
Mar 432,422 495,352 14.55%
Apr 551,446 690,220 25.17%
May 720,332 943,666 31.00%
Jun 965,365 1,290,845 33.72%
Jul 1,091,417 1,468,685 34.57%
Aug 1,262,460 1,691,618 33.99%
Sep 1,483,096 1,864,830 25.74%
Oct 1,686,497 2,126,819 26.11%
Nov 2,046,663
Dec 2,223,933
Percent of budget 95.63%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
Millions
Budget
Actual
Last Year
Page 20 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,266,672 6,667,414 ‐8.25%
Feb 15,690,450 15,284,017 ‐2.59%
Mar 23,002,079 22,281,867 ‐3.13%
Apr 31,750,255 31,242,984 ‐1.60%
May 39,084,152 38,877,391 ‐0.53%
Jun 48,373,538 47,714,859 ‐1.36%
Jul 56,187,336 55,549,735 ‐1.13%
Aug 64,428,849 63,356,444 ‐1.66%
Sep 72,663,664 71,327,565 ‐1.84%
Oct 80,765,734 79,209,986 ‐1.93%
Nov 96,969,189
Dec 106,538,621
Percent of budget expended 74.35%
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
Dec 284,087
Percent of budget expended 81.46%
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
Budget
Actual
Last Year
Page 21 of 36
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
Dec 1,468,694
Percent of budget expended 75.83%
Hearing YTD Annual %
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
Millions Executive
Budget
Actual
Last Year
$180 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
Dec 71,025
Percent of budget expended 67.14%
$‐
$30,000
$60,000
$90,000
$120,000
$150,000
$180,000
Budget
Actual
Last Year
Page 22 of 36
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
Dec 1,733,686
Percent of budget expended 82.28%
YTD Annual % $2 20
Millions Court Services
$‐
$0.40
$0.80
$1.20
$1.60
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
Dec 2,155,819
Percent of budget expended 80.18%
$‐
$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 23 of 36
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
Dec 952,912
Percent of budget expended 82.35%
Development YTD Annual %
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
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
Dec 3,434,929
Percent of budget expended 74.37%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
Millions
Budget
Actual
Last Year
Page 24 of 36
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
Dec 676,136
Percent of budget expended 64.24%
YTD Annual %
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
$0.70
$0.80
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
Dec 1,516,719
Percent of budget expended 81.18%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
Millions
Budget
Actual
Last Year
Page 25 of 36
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
Dec 2,161,836
Percent of budget expended 75.30%
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
Dec 1,002,105
Percent of budget expended 80.09%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Budget
Actual
Last Year
Page 26 of 36
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
Dec 946,956
Percent of budget expended 81.98%
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,247,759 1,905,016 ‐15.25%
Feb 4,466,855 4,392,199 ‐1.67%
Mar 6,695,875 6,307,019 ‐5.81%
Apr 9,540,664 9,480,882 ‐0.63%
May 11,609,004 11,693,746 0.73%
Jun 14,358,981 14,209,937 ‐1.04%
Jul 16,547,749 16,456,908 ‐0.55%
Aug 18,883,699 18,597,181 ‐1.52%
Sep 21,553,177 21,374,890 ‐0.83%
Oct 23,813,749 23,553,267 ‐1.09%
Nov 26,948,909
Dec 29,530,506
Percent of budget expended 79.76%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
Budget
Actual
Last Year
Page 27 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
Fire &
Emergency
Services Budget
YTD
Actual
Annual %
over (under)
Jan 1,929,637 1,891,121 ‐2.00%
Feb 4,586,051 4,615,089 0.63%
Mar 6,487,980 6,539,657 0.80%
Apr 8,359,331 8,435,070 0.91%
May 10,326,040 10,741,041 4.02%
Jun 12,255,187 12,628,919 3.05%
Jul 14,232,821 14,471,622 1.68%
Aug 16,280,567 16,441,012 0.99%
Sep 18,274,307 18,352,396 0.43%
Oct 20,145,192 20,229,262 0.42%
Nov 22,144,674
Dec 24,138,681
Percent of budget expended 83.80%
Community YTD Annual %
$‐
$3
$6
$9
$12
$15
$18
$21
$24
Millions Fire & Emergency Services
Budget
Actual
Last Year
$0 45
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
Dec 421,043
Percent of budget expended 84.12%
$‐
$0.05
$0.10
$0.15
$0.20
$0.25
$0.30
$0.35
$0.40
$0.45
Budget
Actual
Last Year
Page 28 of 36
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
Dec 4,045,762
Percent of budget expended 81.14%
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 60
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
Dec 685,122
Percent of budget expended 68.77%
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
Budget
Actual
Last Year
Page 29 of 36
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
Dec 5,276,859
Percent of budget expended 79.65%
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 53,571 58,787 9.74%
Feb 115,249 130,666 13.38%
Mar 191,090 266,033 39.22%
Apr 373,425 409,836 9.75%
May 474,159 478,640 0.95%
Jun 539,264 546,207 1.29%
Jul 716,044 682,779 ‐4.65%
Aug 792,431 748,587 ‐5.53%
Sep 859,537 797,375 ‐7.23%
Oct 1,005,515 948,716 ‐5.65%
Nov 1,095,976
Dec 1,277,487
Percent of budget expended 74.26%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
Budget
Actual
Last Year
Page 30 of 36
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
Dec 775,917
Percent of budget expended 69.74%
YTD Annual % $2 50
Millions Library Fund
$‐
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
$700,000
Neighborhoods, Resources, and Events
Budget
Actual
Last Year
Library Fund Budget Actual over (under)
Jan 2,500 2,500 0.00%
Feb 5,000 5,000 0.00%
Mar 7,500 7,500 0.00%
Apr 58,604 58,604 0.00%
May 61,106 61,106 0.00%
Jun 263,606 263,606 0.00%
Jul 266,106 266,106 0.00%
Aug 268,606 268,606 0.00%
Sep 271,106 271,106 0.00%
Oct 273,606 273,606 0.00%
Nov 255,386
Dec 278,603
Percent of budget expended 98.21%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
Budget
Actual
Last Year
Page 31 of 36
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
Dec 213,533
Percent of budget expended 84.62%
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
Dec 465,889
Percent of budget expended 84.26%
$‐
$0.20
$0.40
$0.60
Budget
Actual
Last Year
Page 32 of 36
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
Dec 3,728,945
Percent of budget expended 81.89%
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
$6
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
Dec 4,763,972
Percent of budget expended 77.65%
$‐
$1
$2
$3
$4
$5
$6
Budget
Actual
Last Year
Page 33 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
Debt Service Budget
YTD
Actual
Annual %
over (under)
Jan ‐ ‐ N/A
Feb 250,317 250,317 0.00%
Mar 250,317 250,317 0.00%
Apr 842,026 842,026 0.00%
May 856,385 856,385 0.00%
Jun 1,905,620 1,905,620 0.00%
Jul 1,905,620 1,905,620 0.00%
Aug 2,158,688 2,158,688 0.00%
Sep 2,158,688 2,158,688 0.00%
Oct 2,747,599 2,747,599 0.00%
Nov 9,048,494
Dec 9,871,084
Percent of budget expended 27.83%
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 313,245 313,245 0.00%
Feb 649,480 649,480 0.00%
Mar 886,227 886,227 0.00%
Apr 1,176,929 1,176,929 0.00%
May 1,375,197 1,375,197 0.00%
Jun 1,597,673 1,597,673 0.00%
Jul 1,863,974 1,863,974 0.00%
Aug 2,072,373 2,072,373 0.00%
Sep 2,298,266 2,298,266 0.00%
Oct 2,519,291 2,519,291 0.00%
Nov 4,271,955
Dec 4,660,315
Percent of budget expended 54.06%
$‐
$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 36
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2012 Budget Year
Utilities Budget Revenue Expense
Jan 3,577,122 4,860,643 3,270,986
Feb 8,661,002 9,712,888 7,451,062
Mar 14,450,068 15,372,251 11,393,139
Apr 18,848,862 20,105,679 15,700,049
May 23,339,223 25,621,490 19,760,057
Jun 32,195,178 30,561,965 25,608,749
Jul 37,831,512 36,536,725 30,837,617
Aug 42,717,193 41,774,863 35,411,926
Sep 48,620,479 47,449,846 39,860,995
Oct 54,440,591 53,197,620 45,185,106
Nov 60,007,113
Dec 69,198,605
Percent of budget expended 56.73%
Note: Operations and Capital
$0
$10
$20
$30
$40
$50
$60
$70
$80
Millions Utilities
Budget
Revenue
Expense
$12 00
Millions Airport
Airport Budget Revenue Expense
Jan 711,901 182,302 131,563
Feb 1,275,443 480,547 293,170
Mar 1,902,797 679,165 431,819
Apr 2,594,568 909,193 601,497
May 3,131,035 1,114,820 823,315
Jun 4,196,017 1,360,778 1,122,991
Jul 4,890,304 1,744,572 1,261,393
Aug 6,094,084 1,950,517 1,464,878
Sep 7,031,140 2,169,957 1,602,471
Oct 8,271,757 2,442,272 1,894,436
Nov 9,233,875
Dec 10,065,047
Percent of budget expended 18.82%
Note: Operations and Capital
$‐
$2.00
$4.00
$6.00
$8.00
$10.00
$12.00
Budget
Revenue
Expense
Page 35 of 36
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
Dec 2,637,204
Percent of budget expended 60.60%
Note: Operations and Capital
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
$2.40
$2.70
$3.00
Millions Golf Course
Budget
Revenue
Expense
Page 36 of 36