HomeMy WebLinkAbout201208, August.pdfFINANCE AND
INFORMATION TECHNOLOGY
M E M O R A N D U M
DATE: September 28, 2012
TO: Rich Zwicker, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: August 2012 Financial Status Report
At the end of August, general governmental revenues show $1.6 million or 2.6% over budget.
Revenues sources that are higher than expected are: property taxes ($275k); sales tax ($222k);
real estate excise taxes ($419k); building permits & development service fees ($530k); and state
shared revenues ($244k). On the down side, the revenue sources that are underperforming the
year to date budget are: franchise fees ($54k below); utility taxes ($178k below); culture and
recreation fees ($95k below); and interfund/inter‐departmental services ($215k below).
General government expenditures showed favorable variance of $1 million or 1.6%. 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 16,786,759 32,357,894 17,247,946 32,896,746 17,422,058 17,697,303 275,245 1.6%
Sales Tax 17,198,220 11,430,357 17,729,731 11,807,102 17,864,000 11,875,306 12,096,835 221,529 1.9%
Sales Tax ‐ Annexation Credit 2,025,660 1,346,094 2,033,954 1,338,857 2,101,647 1,383,416 1,441,634 58,218 4.2%
Criminal Justice Sales Tax 1,620,479 1,072,153 1,809,757 1,206,848 1,867,145 1,245,118 1,242,787 (2,330) ‐0.2%
Natural Gas Use Tax 228,514 170,550 249,407 192,218 270,394 208,393 228,398 20,005 9.6%
Admission Tax 291,399 217,864 308,200 222,088 350,000 252,209 235,808 (16,401) ‐6.5%
Franchise Fees 1,222,444 887,960 1,234,448 894,644 1,323,000 958,821 904,991 (53,830) ‐5.6%
Electricity Tax 5,036,907 3,354,397 5,166,711 3,465,315 5,283,280 3,543,498 3,514,842 (28,656) ‐0.8%
Natural Gas Utility Tax 1,577,756 1,140,236 1,848,806 1,404,522 1,950,000 1,481,398 1,276,914 (204,484) ‐13.8%
Transfer Station 269,912 157,215 297,474 168,199 248,762 140,656 202,290 61,634 43.8%
TV Cable 1,296,744 903,892 1,385,275 903,937 1,427,679 931,607 924,994 (6,613) ‐0.7%
Telephone 1,038,009 704,355 966,827 660,524 1,000,000 683,187 671,176 (12,011) ‐1.8%
Cellular Phone 2,206,637 1,554,714 2,054,183 1,412,985 2,309,360 1,588,510 1,484,840 (103,670) ‐6.5%
City Utilities 2,853,884 1,877,339 3,516,179 2,304,551 3,665,728 2,402,567 2,498,376 95,809 4.0%
Leasehold Excise Tax 138,830 103,100 162,593 122,412 145,000 109,167 92,045 (17,122) ‐15.7%
Gambling Excise Tax 1,546,386 1,073,429 1,671,414 1,142,944 1,600,000 1,094,109 1,110,803 16,694 1.5%
Real Estate Excise Tax 2,464,489 1,537,086 2,074,059 1,177,391 2,025,000 1,149,048 1,691,618 542,570 47.2%
Less: Municipal Facilities CIP REET (400,000) (258,148) (400,000) (210,248) (400,000) (210,248) (334,147) (123,898) 58.9%
EMS Levy 1,161,114 580,473 868,873 510,544 1,007,976 442,891 442,891 ‐ 0.0%
Business License Fees 431,782 319,296 442,451 321,464 469,817 341,347 325,982 (15,365) ‐4.5%
Other Licenses and Permits 262,629 159,099 232,534 130,873 213,305 120,051 144,825 24,774 20.6%
Building Permits & Development Svc Fees 2,437,270 1,758,928 2,772,779 1,791,158 2,466,063 1,595,562 2,125,243 529,682 33.2%
Intergovt'l (Grants, State Shared, etc) 4,426,676 2,711,369 4,737,323 2,761,252 4,359,315 2,932,356 3,179,092 246,736 8.4%
Fire District 25 and 40 Contracts 5,252,877 2,760,463 6,110,668 3,113,598 6,008,694 3,226,625 3,226,625 ‐ 0.0%
Public Safety 482,343 303,141 484,985 330,394 430,635 293,368 317,947 24,579 8.4%
Culture and Recreation 1,424,932 1,118,294 1,493,540 1,141,328 1,660,863 1,269,193 1,173,982 (95,211) ‐7.5%
Interfund/Interdept‐Services 3,190,908 2,170,982 3,070,506 1,987,646 3,617,185 2,341,531 2,126,854 (214,677) ‐9.2%
Fines and Forfeits 1,291,817 769,212 1,163,602 707,482 1,088,750 663,455 616,747 (46,709) ‐7.0%
Photo Enforcement 1,925,159 1,306,228 1,897,782 1,286,287 1,944,713 1,318,096 1,372,464 54,368 4.1%
Seizure Funds ‐ Federal/State/Local 221,046 191,693 83,220 4,431 180,693 9,621 25,614 15,993 166.2%
Interests and Other Earnings 183,511 133,306 107,183 67,572 125,400 79,057 66,355 (12,701) ‐16.1%
Rents, Leases, and Concessions 727,338 576,796 744,834 544,625 701,464 512,912 606,311 93,399 18.2%
Contributions and Donations 133,756 90,947 196,586 172,744 81,500 71,616 104,145 32,529 45.4%
Other Miscellaneous 434,286 309,414 529,147 302,562 427,358 222,758 353,563 130,805 58.7%
Other Financing Sources (Transfer‐In, etc) 653,595 653,094 1,073,507 169,086 1,241,752 18,477 145,543 127,066 687.7%
Total Operating Revenues 96,754,435 59,972,086 100,476,431 60,805,281 101,953,223 61,717,736 63,335,690 1,617,955 2.6%
OPERATING EXPENDITURES
Legislative 259,345 173,947 271,236 180,746 284,087 189,913 184,727 5,185 2.7%
Executive 1,578,526 1,038,272 1,566,906 994,268 1,468,694 949,052 892,376 56,676 6.0%
Hearing Examiner 174,447 116,431 59,878 39,784 71,025 47,349 41,426 5,923 12.5%
City Attorney 1,565,597 1,059,996 1,596,609 1,056,642 1,668,686 1,116,943 1,122,280 (5,337) ‐0.5%
Court Services 2,007,599 1,335,996 2,084,170 1,384,788 2,155,819 1,433,492 1,396,118 37,374 2.6%
Community and Eco Dvlpmnt Admin 579,396 389,497 929,814 620,791 952,912 637,894 630,909 6,984 1.1%
Development Services 2,946,413 1,962,273 2,810,736 1,876,800 3,434,929 2,290,533 2,001,005 289,528 12.6%
Economic Development 1,322,004 840,426 724,970 484,313 753,765 487,814 401,680 86,134 17.7%
Planning 1,774,508 1,153,979 1,447,781 951,339 1,516,719 990,965 995,013 (4,048) ‐0.4%
Finance 2,214,458 1,240,000 2,134,667 1,245,218 2,161,836 1,235,336 1,348,224 (112,888) ‐9.1%
City Clerk 789,209 505,723 736,880 525,691 1,002,105 677,277 677,021 256 0.0%
Human Resources 861,221 578,948 888,252 561,242 946,956 617,162 625,233 (8,071) ‐1.3%
Police 23,946,386 16,054,808 24,737,346 16,472,013 25,214,618 16,846,518 16,560,001 286,518 1.7%
Jail Services 3,539,035 2,117,139 6,206,735 2,776,765 5,340,599 2,037,181 2,037,181 ‐ 0.0%
Fire 21,554,792 14,550,092 22,511,597 15,170,911 24,099,606 16,254,213 16,441,012 (186,799) ‐1.1%
Community Services Admin 1 1,063,011 706,509 416,284 272,651 421,043 278,693 285,879 (7,187) ‐2.6%
Parks 3,421,424 2,206,684 3,829,676 2,435,040 4,045,762 2,589,857 2,541,158 48,699 1.9%
Parks Planning & Natural Resources 448,574 283,463 551,423 349,262 685,122 433,495 363,538 69,957 16.1%
Recreation 4,433,420 2,944,207 4,974,002 3,341,666 5,276,859 3,525,903 3,346,772 179,131 5.1%
Human Services 1,326,778 825,837 1,247,294 770,871 1,277,487 792,431 748,587 43,844 5.5%
Neighborhoods, Resources, & Events 331,222 210,720 610,545 369,016 697,288 429,239 383,481 45,758 10.7%
Library 2,289,692 1,628,119 2,030,000 1,820,119 230,000 268,606 268,606 ‐ 0.0%
Museum 191,090 127,286 210,620 139,835 213,533 141,990 144,117 (2,127) ‐1.5%
Public Works Admin 1 514,858 346,210 452,538 300,269 465,889 311,339 315,216 (3,878) ‐1.2%
Street Maintenance 3,412,892 2,224,610 3,534,025 2,335,142 3,728,945 2,447,569 2,463,011 (15,442) ‐0.6%
Transportation 5,215,309 3,381,065 4,509,066 2,935,188 4,763,972 3,094,333 2,910,811 183,522 5.9%
Debt Service 4,707,100 1,303,524 4,822,566 1,408,246 6,531,373 2,158,688 2,158,688 ‐ 0.0%
Non‐Departmental and Other 4,834,296 2,417,038 4,930,383 3,950,614 2,944,248 2,072,373 2,072,373 ‐ 0.0%
Total Operating Expenditures 97,302,601 61,722,799 100,825,999 64,769,227 102,353,876 64,356,158 63,356,444 999,714 1.6%
Total Ending Fund Balance 11,407,119$ 10,204,572$ 11,057,551$ 7,443,173$ 10,656,898$ 8,419,129$ 11,036,798$ 2,617,669 31.1%
1Facilities was included in Community Services Admin and Technical Services was included in Public Works Admin in 2010
Summary of Sources and Uses Annual Actual YTD Actual Favorable (Unfavorable)
2010 2011 2012 Variance
Annual Actual YTD Actual Annual Budget YTD Budget YTD Actual
Monthly Financial Report August 2012
Page 1 of 36
Monthly Financial Report August 2012
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through August 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 73% of
all resources supporting general governmental activities. The following section provides detail information on property,
sales, utility, and other taxes.
Property Tax
August’s collection is $49k, making the
total year‐to‐date collection $17.7 million
or 54% of the total budget. In
comparison to the previous year, the City
collected $449k or 3% more. Compared
to the budget, the City is above
projections by $275k or 2%. 2012’s
monthly budgets are based on 2009
through 2011 collections. The April/May
variance from the prior year and budget
is due the timing of collections. An
estimated $2.1 million of May 2012’s
collection was receipted in April 2012. If
we combine April and May, the City is right on target with budget projections.
Sales Tax
August 2012 sales tax receipts totalled
$1.6 million. Compared to the same
month last year, it is $50k or 3% more.
Compared to the projected current
month’s budget, it is $61k or 4% above.
The year‐to‐date collection of $12.1
million is $290k or 2% more than the prior
year and is also $222k 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
Oct 7,014,860 6,907,167
Nov 7,348,025 7,974,601
Dec 279,117 171,812
YTD Total 17,247,946$ 17,422,058$ 17,697,303$ 449,357$ 3% 275,245$ 2%
Annual Total 32,357,894$ 32,896,746$
Property Tax Revenues
Year to Date through August
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 ‐
Oct 1,517,444 1,529,207 ‐
Nov 1,508,954 1,522,978 ‐
Dec 1,423,832 1,467,796 ‐
YTD Total 11,807,102$ 11,875,306$ 12,096,835$ 289,733$ 2% 221,529$ 2%
Annual Total 17,729,731$ 17,864,000$
2012 vs. Budget2012 vs. 2011
Month
Year to Date through August
Local Retail Sales Tax Revenues
Page 2 of 36
Monthly Financial Report August 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 980,257$ 1,098,346$ 1,097,254$ 116,997$ 12%$ (1,092) 0%
Auto Sales 2,091,091 2,283,025 2,185,254 94,163 4% (97,771)‐4%
General Retail 4,060,049 4,210,799 4,315,794 255,745 6% 104,995 2%
Manufacturing 776,503 497,296 713,264 (63,239) ‐8% 215,968 43%
Wholesale 760,796 788,082 776,232 15,436 2% (11,850)‐2%
Service 2,626,385 2,707,870 2,729,726 103,341 4% 21,856 1%
Other 512,022 289,889 279,311 (232,711) ‐45% (10,578)‐4%
Total 11,807,102$ 11,875,306$ 12,096,835$ 289,733$ 2%221,529$ 2%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility tax
August utility tax revenues are $1.2
million, which is $12k or 1% lower than
the same month last year and is also
behind the budget by $63k or 5%. The
year‐to‐date collection is $10.8 million,
which is $290k or 3% higher than the
prior year but is $178k 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 3,465,315$ 3,543,498$ 3,514,842$ 49,527$ 1%$ (28,656)‐1%
Natural Gas 1,596,740 1,689,791 1,505,312 (91,428) ‐6% (184,479)‐11%
Cell 1,412,985 1,588,510 1,484,840 71,855 5% (103,670)‐7%
Phone 660,524 683,187 671,176 10,652 2% (12,011)‐2%
Cable 903,937 931,607 924,994 21,057 2% (6,613)‐1%
Transfer Station 168,199 140,656 202,290 34,091 20% 61,634 44%
City Utilities 2,304,551 2,402,567 2,498,376 193,825 8% 95,809 4%
YTD Total 10,512,250$ 10,979,816$ 10,801,830$ 289,580$ 3%(177,986)$ ‐2%
Annual Total 15,484,862$ 16,155,203$
YTD as % of 68% 68%
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
Oct 1,202,559 1,253,072
Nov 1,232,640 1,281,314
Dec 1,360,887 1,415,147
YTD Total 10,512,250$ 10,979,816$ 10,801,830$ 289,580$ 3% (177,986)$ ‐2%
Annual Total 15,484,862$ 16,155,203$
2012 vs. Budget2012 vs. 2011
Year to Date through August
Utility Tax Revenues
Month
Page 3 of 36
Monthly Financial Report August 2012
Other Taxes
Real Estate Excise Tax
The City collected $223k in Real Estate
Excise Tax revenues (REET) for August. This
is $63k or 40% ahead of the same month
last year and $67k or 43% above the
current month’s budget. The year‐to‐date
collection is $1.7 million, which is $514k or
44% more than the prior year and is also
$543k or 48% above the budget. The City is
projecting REET to exceed the budget at
year‐end.
Gambling Tax
August’s Gambling Tax collections
total $147k. Year‐to‐date total of
$1.1 million is $32k or 3% below the
year before but is $17k or 2% 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 1% decrease, bingo increased by 35%, and card‐rooms are seeing 5% lower in activities when
compared to the prior year.
Franchise Fees
Franchise Fees are due quarterly and
the year‐to‐date revenue collections
are $905k or 68% of the budget. This
is $10k or 1% higher than 2011 but is
$54k or 6% 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$ 157,987$ 77,631$ (84,280)$ ‐52% (80,356)$ ‐51%
Feb 99,677 97,304 214,137 114,460 115% 116,833 120%
Mar 141,700 138,289 203,583 61,883 44% 65,294 47%
Apr 110,987 108,315 194,868 83,881 76% 86,553 80%
May 157,519 153,728 253,446 95,927 61% 99,719 65%
Jun 228,506 223,006 347,179 118,673 52% 124,174 56%
Jul 117,567 114,737 177,839 60,273 51% 63,103 55%
Aug 159,524 155,683 222,933 63,409 40% 67,250 43%
Sep 205,753 200,800
Oct 189,691 185,125
Nov 335,893 327,808
Dec 165,331 162,219
YTD Total 1,177,391$ 1,149,048$ 1,691,618$ 514,227$ 44% 542,570$ 47%
Annual Total 2,074,059$ 2,025,000$
Real Estate Excise Tax Revenues
Year to Date through August
Month
2012 vs. Budget2012 vs. 2011
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 ‐
Oct 92,937 88,966 ‐
Nov 139,018 133,078 ‐
Dec 170,897 163,595 ‐
YTD Total 1,142,944$ 1,094,109$ 1,110,803$ (32,140)$ ‐3% 16,694$ 2%
Annual Total 1,671,414$ 1,600,000$
Year to Date through August
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 ‐
Dec 47,111 50,491 ‐
YTD Total 894,644$ 958,821$ 904,991$ 10,347$ 1% (53,830)$ ‐6%
Annual Total 1,234,448$ 1,323,000$
Month
2012 vs. 2011 2012 vs. Budget
Franchise Fees Revenue
Year to Date through August
Page 4 of 36
Monthly Financial Report August 2012
Admission Tax
Admission Tax returns are due
quarterly in January, April, July, and
October each year. July 2012
collections represent activities
conducted during the 2nd quarter of
2012.
The report shows an increase of $15k
or 6% from the year before but is
$15k or 7% less than anticipated. The
City is projecting admission tax
revenues to be slightly under the budget at year‐end.
Licenses and Permits
Building Permits and Development Service Fees
Building Permits and Development Service
Fee revenues totalled $369k in August. The
year‐to‐date development fees revenue of
$2.1 million is $334k or 19% more than
2011 and is also $530k or 33% 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 is projecting building permits and
development service fee revenues to
exceed the budget at year‐end.
Business Licenses
Business Licenses totalled $15k for August, which
is $4k or 21% below the same month last year
and is also $5k or 26% below the current month’s
budget. The year‐to‐date Business Licenses
revenue is over the prior year by $5k or 1% but is
$15k 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. 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 ‐
YTD Total 222,088$ 252,209$ 235,808$ 15,321$ 6% (14,582)$ ‐7%
Annual Total 308,200$ 350,000$
Month
2012 vs. 2011 2012 vs. Budget
Admission Tax Revenue
Year to Date through August
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
Oct 213,930 189,380
No v 229,322 196,766
Dec 216,409 194,437
YTD Total 1,791,158$ 1,595,562$ 2,125,243$ 334,086$ 19% 529,682$ 33%
Annual Total 2,772,779$ 2,466,063$
Building Permits and Development Service Fees
Year to Date through August
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 ‐
Oct 95,874 101,804 ‐
Nov 18,291 19,423 ‐
Dec 2,686 2,852 ‐
YTD Total 321,464$ 341,347$ 325,982$ 4,518$ 1% (15,365)$ ‐5%
Annual Total 442,451$ 469,817$
2012 vs. 2011
Year to Date through August
2012 vs. Budget
Business Licenses
Month
Page 5 of 36
Monthly Financial Report August 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 $7.6
million or 63% of the budget.
State Shared Revenues
State Shared Revenue collections
totalled $3.2 million since the start
of 2012. Compared to the prior
year, State Shared Revenues are
above by $193k or 6%. Compared
to the projected budget, the City is
collecting $244k 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
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 $4.5 million or 67% of
the budget. This is 1% below budget projections. The following sections provide detail information for Public Safety,
Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totalled $318k 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 $12k or 4%
less. Compared to the budget, the City is
collecting $25k or 8% 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 674,677$ 698,717$ 698,717$ 24,040$ 4% $ ‐ 0%
Fire District #40 2,438,922 2,527,908 2,527,908 88,986 4%‐ 0%
State Shared Revenue 2,976,442 2,925,466 3,169,872 193,430 6% 244,406 8%
Federal Grants 353,893 779,086 779,086 425,193 120%‐ 0%
State Grants 110,223 100,934 100,934 (9,288) ‐8%‐ 0%
Other Grants/Intgovt 121,635 98,043 98,043 (23,592) ‐19%‐ 0%
ARRA Grants 405,908 273,944 273,944 (131,963) ‐33%‐ 0%
Total Rev YTD 7,081,699$ 7,404,099$ 7,648,504$ 566,805$ 8%244,406$ 3%
Total Rev Annual 12,657,748$ 12,235,154$
YTD %56%61%63%
Note: Includes CJ Sales Tax.
2011 2012 2012
Actual Budget Actual $ % $ %
Crim Just Sales Tax 1,206,848$ 1,245,118$ 1,242,787$ 35,939$ 3% (2,330)$ 0%
Judicial Contribution 16,851 9,000 11,316 (5,535) ‐33% 2,316 26%
Crim Just ‐ High Crime 142,459 72,536 144,999 2,540 2% 72,464 100%
Crim Just ‐ Pop 14,900 ‐ 15,589 689 5% 15,589 100%
Crim Just ‐ Spec Prog 56,257 50,935 58,682 2,426 4% 7,747 15%
State DUI 14,591 11,621 13,149 (1,442) ‐10% 1,528 13%
Liquor Profits 355,913 364,978 506,059 150,146 42% 141,081 39%
Liquor Excise Tax 327,685 334,811 342,495 14,810 5% 7,684 2%
Fuel Tax 840,938 836,468 834,795 (6,143) ‐1% (1,673) 0%
YTD Total 2,976,442$ 2,925,466$ 3,169,872$ 193,430$ 6% 244,406$ 8%
Annual Total 4,495,551$ 4,437,913$
Year to Date through August
State Shared Revenues
2012 vs. 2011
Revenue
2012 vs. Budget
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 ‐
Oct 34,756 30,861 ‐
Nov 42,944 38,131 ‐
Dec 46,148 40,976 ‐
YTD Total 330,394$ 293,368$ 317,947$ (12,447)$ ‐4% 24,579$ 8%
Annual Total 484,985$ 430,635$
Month
2012 vs. 2011
Year to Date through August
Public Safety Services
2012 vs. Budget
Page 6 of 36
Monthly Financial Report August 2012
Recreation
Recreation revenues totalled $262k for the
current month. Compared to the same
month the prior year, the City collected $8k
or 3% more. Compared to the projected
monthly budget, the City collected $20k or
7% less. The year‐to‐date collection of $1.2
million is $33k or 3% more than the prior
year but is $95k or 8% less than the budget.
The City is projecting recreation revenues to
be under budget at year‐end.
Interfund Services
The year‐to‐date collections for Interfund
Services revenues are $2.1 million.
Compared to the prior year, the revenues
are over by $139k or 7%. Compared to the
projected budget, the revenues are below by
$215k or 9%. 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
million. This is $14k or 1% higher than a
year ago and also $3k above the budget.
The City is projecting fines and penalties to
meet 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 ‐
Oct 83,540 92,899 ‐
Nov 77,528 86,214 ‐
Dec 48,890 54,368 ‐
YTD Total 1,141,328$ 1,269,193$ 1,173,982$ 32,653$ 3% (95,211)$ ‐8%
Annual Total 1,493,540$ 1,660,863$
Recreation
Year to Date through August
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 ‐
Oct 270,340 318,472 ‐
Nov 266,859 314,371 ‐
Dec 308,654 363,607 ‐
YTD Total 1,987,646$ 2,341,531$ 2,126,854$ 139,208$ 7% (214,677)$ ‐9%
Annual Total 3,070,506$ 3,617,185$
2012 vs. Budget
Month
Interfund Services
Year to Date through August
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
Oct 300,431 385,882
Nov 297,580 299,240
Dec 352,911 352,016
YTD Total 1,980,542$ 1,991,172$ 1,994,108$ 13,565$ 1% 2,935$ 0%
Annual Total 3,112,464$ 3,214,156$
Month
2012 vs. Budget2012 vs. 2011
Year to Date through August
Fines and Penalties by Month
Page 7 of 36
Monthly Financial Report August 2012
Year to Date through August
2011 2012 2012
Actual Budget Actual $ % $ %
Civil Penalties 7,298$ 10,212$ 5,606$ (1,692)$ ‐23% (4,606)$ ‐45%
Civil Infraction Penalties 444,700 477,077 369,246 (75,454) ‐17% (107,831) ‐23%
Civil Parking Infraction Penalties 78,570 85,689 72,604 (5,966) ‐8% (13,085) ‐15%
Photo Enforcement Program 1,286,287 1,318,096 1,372,464 86,177 7% 54,368 4%
Criminal Traffic Misdemeanor Fines 63,199 57,213 54,484 (8,715) ‐14% (2,729) ‐5%
Criminal Non‐Traffic Fines 19,307 24,811 15,671 (3,635) ‐19% (9,140) ‐37%
Criminal Costs 75,964 7,170 77,766 1,801 2% 70,595 985%
Seizure Funds ‐ Federal/State/Local 4,431 9,621 25,614 21,183 478% 15,993 166%
Non‐Court Fines, Forfeitures and Penalties 785 1,282 653 (133) ‐17% (629) ‐49%
YTD Total 1,980,542$ 1,991,172$ 1,994,108$ 13,565$ 1% 2,935$ 0%
Annual Total 3,112,464$ 3,214,156$
2012 vs. 2011
Revenue
2012 vs. Budget
Fines and Penalties by Type
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.4
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.
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 68% of the
total revenue in this category. The year‐
to‐date total miscellaneous is $987k.
Compared to last year, the revenues are
over by $51k or 5%. Compared to the
projected year‐to‐date budget, the
revenues are over by $258k 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 ‐ 71,527 ‐ ‐
Oct 145,798 ‐ 71,420 ‐ ‐
Nov 211,430 ‐ 71,884 ‐ ‐
Dec 185,536 ‐ 72,273 ‐ ‐
YTD Total 1,318,096$ 1,372,464$ 554,860$ 540,128$ 832,336$
Annual Total 1,944,713$ 841,964$
1 Actuals of Revenues and Expenses
Expenses
Photo Enforcement Program
Year to Date through August
Month
Revenues
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 143,105$ 128,421$ 206,151$ 63,046$ 44% 77,730$ 61%
Feb 70,237 46,979 83,823 13,585 19% 36,844 78%
Mar 99,131 77,952 104,421 5,289 5% 26,469 34%
Apr 74,048 58,040 98,164 24,115 33% 40,123 69%
May 97,083 85,456 145,213 48,130 50% 59,757 70%
Jun 145,018 113,666 93,832 (51,185) ‐35% (19,834) ‐17%
Jul 173,878 118,884 112,316 (61,562) ‐35% (6,568) ‐6%
Aug 133,570 99,673 143,389 9,819 7% 43,716 44%
Sep 97,973 76,252
Oct 75,425 61,811
Nov 77,427 67,662
Dec 163,299 164,402
YTD Total 936,071$ 729,072$ 987,309$ 51,238$ 5% 258,237$ 35%
Annual Total 1,350,195$ 1,099,199$
Year to Date through August
Month
2012 vs. Budget2012 vs. 2011
Miscellaneous Revenues by Month
Page 8 of 36
Monthly Financial Report August 2012
2011 2012 2012
Actual Budget Actual $ % $ %
Interests and Other Earnings 67,572$ 79,057$ 66,355$ (1,217)$ ‐2% (12,701)$ ‐16%
Rents, Leases, and Concessions 544,625 512,912 606,311 61,686 11% 93,399 18%
Contributions/Donations from Private Sources 172,744 71,616 104,145 (68,599) ‐40% 32,529 45%
Other 151,130 65,487 210,498 59,367 39% 145,011 221%
YTD Total 936,071$ 729,072$ 987,309$ 51,238$ 5% 258,237$ 35%
Annual Total 1,350,195$ 1,099,199$
2012 vs. Budget
Miscellaneous Revenues by Type
Year to Date through August
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 62% of its budgeted general governmental expenditures at the end of August. This is $1
million or 1.6% below year‐to‐date budgeted expenditures. See below for summary of unfavorable items for general
governmental departments.
City Attorney Department is over the year‐to‐date budget by $5k or 0.5%. This is mainly due to over spending on
contracted services and publications and under spending in salaries/benefits and supplies.
Administrative Services Department (Finance and City Clerk) is over the year‐to‐date budget by $113k or 6%. This is due to
the spending patterns of the 1st and 2nd 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 $8k or 1.3%. 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 $187k or 1.1%. This is mainly due to over
spending on salaries/overtime/benefits ($15k), supplies ($115k), and intergovernmental ($54k). We will continue to
monitor these items to determine if a budget adjustment is needed.
Page 9 of 36
Monthly Financial Report August 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 ‐ ‐ ‐ ‐ 29,260 23,800 ‐
Grants / intergovernmental 331,152 5,278 107,838 75,060 2,527 535,194 ‐
Charges for services 82,410 1,337,003 10,038,180 8,973,342 5,599,033 5,260,889 9,010,857
Interdepartmental services ‐ ‐ 4,265 253,991 184,844 409,479 ‐
Fines and penalties ‐ ‐ ‐ ‐ ‐ ‐ ‐
Rents, leases, and misc fees 1,530,918 255,992 54,965 84,024 ‐ ‐ ‐
Interest and other misc 6,038 2,896 12,825 210,248 653,102 248,056 3,125
TOTAL REVENUES 1,950,518 1,601,169 10,218,073 9,596,665 6,468,766 6,477,418 9,013,982
EXPENSES:
Utility billing ‐ ‐ 74,799 70,104 53,822 81,453 ‐
Utility systems ‐ ‐ 9,236,334 1,952,646 1,719,036 1,495,684 ‐
Utility maintenance ‐ ‐ 193,793 3,097,012 900,684 1,210,830 8,510,755
Transportation 887,512 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 1,199,979 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 887,512 1,199,979 9,504,926 5,119,762 2,673,542 2,787,967 8,510,755
AMOUNT AVAILABLE FOR DEBT SERVICE 1,063,006 401,190 713,147 4,476,903 3,795,224 3,689,451 503,227
DEBT SERVICE:
Principal ‐ ‐ ‐ 1,093,925 741,076 144,290 ‐
Interest and other debt service costs ‐ ‐ ‐ 427,482 217,689 182,423 ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ 1,521,407 958,765 326,713 ‐
CAPITAL PROJECTS 572,010 28,309 ‐ 1,066,613 1,151,279 1,780,104 ‐
TRANSFERS IN/(OUT)(5,356) ‐ ‐ ‐ (10,094) ‐ ‐
CHANGE IN FUND BALANCE 485,640 372,881 713,147 1,888,883 1,675,086 1,582,634 503,227
BEGINNING FUND BALANCE, January 1, 2012 2,084,710 615,488 1,734,734 7,642,506 1,209,356 4,210,599 1,077,805
ENDING FUND BALANCE, August 31, 2012 2,570,350 988,369 2,447,881 9,531,389 2,884,442 5,793,233 1,581,032
Page 10 of 36
Monthly Financial Report August 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 ‐ 65,282 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental 747 66,501 1,915 ‐ ‐ ‐ 43,637
Charges for services
Equipment rental m&o 1,436,333 1,411,034 ‐ ‐ ‐ ‐ ‐
Telecommunications ‐ 124,269 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 71,123 ‐ 264,767 ‐ ‐ ‐
Communications ‐ 2,000 ‐ 404,980 ‐ ‐ ‐
Facilities ‐ ‐ 2,782,335 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 100,094 ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ 210,738 ‐ ‐ ‐ ‐ ‐
Geographical information systems ‐ 131,224 ‐ ‐ ‐ ‐ ‐
Interest and other misc 11,263 5,299 1,301 454 15,902 18,754 14,588
Internal service fund misc:
Vehicle / equipment capital recovery 639,680 628,523 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 1,042,781 ‐ ‐
Worker's compensation / unemployment ‐ ‐ ‐ ‐ 943,490 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 7,321,850 1,471,925
Other misc 916 132 6,356 126 199 459,476 ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets 1,000 ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 53,183 8,942 131
TOTAL REVENUES 2,089,939 2,816,219 2,791,907 670,327 2,055,555 7,809,022 1,530,281
EXPENSES:
Communications 307,934
Equipment rental 1,644,484
Facilities 2,295,841
Healthcare 7,642,565
Information technology 2,156,389
Print and mail 263,816
Retiree healthcare 807,947
Risk management
Risk management 1,050,384
Unemployment 100,494
Worker's compensation 902,164
TOTAL EXPENSES 1,644,484 2,156,389 2,295,841 571,750 2,053,042 7,642,565 807,947
AMOUNT AVAILABLE FOR CAPITAL 445,455 659,830 496,066 98,577 2,513 166,457 722,334
CAPITAL PROJECTS 1,182,117 736,802 120,665 ‐ ‐ ‐ ‐
TRANSFERS IN 15,450 ‐ 37,782 ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE (721,212) (76,972) 413,183 98,577 2,513 166,457 722,334
BEGINNING FUND BALANCE, January 1, 2012 4,774,376 2,181,743 300,238 141,120 6,620,437 7,133,996 5,479,399
ENDING FUND BALANCE, August 31, 2012 4,053,164 2,104,771 713,421 239,697 6,622,950 7,300,453 6,201,733
Page 11 of 36
Monthly Financial Report August 2012
FUND BALANCE
Page 13 shows the ending fund balance as of August 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 August, the City has $11 million reported in the combined general governmental fund balance of the current
year’s operating budget, which is approximately 11% of budgeted operating expenditures. This is a decrease of $21k from
the year’s beginning balance. August’s ending fund balance is over the anticipated General Governmental Fund Balance of
$8.4 million by $2.6 million or 31.1%. Although the ending fund balance is above projections, it is consistent with the prior
years’ trends since the City receipted the first half of 2012 property taxes in April/May and will receipt the second half in
October/November.
CONTACT INFORMATION
This report is prepared by the Finance Division of the Administrative Services Department. For additional financial
information, please also review our website: http://www.rentonwa.gov/. For any questions about the report, please feel
free to contact us at hnguyen@rentonwa.gov or JDThomas@Rentonwa.gov.
Page 12 of 36
Monthly Financial Report August 2012
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through August 31, 2012
Funds
Balance
01/01/2012
Budgeted
Revenue
Revenue
08/31/12
Total Funds
Available
Budgeted
Expenditure
Expenditure
08/31/12
Ending
Balance
GENERAL GOVERNMENT FUNDS:11,057,551 101,953,223 63,335,690 74,393,241 102,353,876 63,356,444 11,036,797
000 General 6,934,747 74,313,431 46,559,486 53,494,233 75,353,069 48,234,960 5,259,274
001 Community Services 1,413,050 11,302,259 7,111,645 8,524,695 11,126,074 6,920,829 1,603,866
003 Street 1,264,341 8,953,479 5,334,271 6,598,612 8,492,917 5,373,823 1,224,789
004 Community Dev Block Grant 8,339 305,961 120,003 128,342 303,281 205,790 (77,449)
005 Museum 52,620 216,220 216,557 269,177 213,533 144,117 125,060
006 Library 48,603 230,000 230,000 278,603 230,000 268,606 9,997
009 Farmers Market 87,437 75,500 61,122 148,559 78,629 46,518 102,042
010 Fire Memorial 1,953 ‐ (1,952) 1 ‐ ‐ 1
011 Fire Health & Wellness 36,858 25,000 16,927 53,785 25,000 3,114 50,671
031 Park Memorial 177,758 ‐ 445 178,203 ‐ ‐ 178,203
201 Ltd GO Bonds Gen Govt Debt 591,257 1,982,075 1,278,932 1,870,189 1,982,075 149,359 1,720,830
215 Gen Govt Misc Debt Service 440,588 4,549,298 2,408,255 2,848,843 4,549,298 2,009,329 839,515
SPECIAL REVENUE FUNDS:
102 Arterial Street 158,974 600,000 393,562 552,536 600,000 350,000 202,536
108 Leased City Properties 488,500 844,049 386,221 874,721 749,232 377,703 497,018
110 Hotel Motel 243,556 265,000 200,574 444,130 442,050 360,519 83,611
118 Reserve for Paths & Trails 3,314 ‐ 8 3,322 ‐ ‐ 3,322
125 1% For Art 121,686 32,813 297 121,983 50,000 13,736 108,247
127 Cable Communication 185,968 85,000 78,986 264,954 235,674 10,046 254,908
135 Springbrook Wetlands Bank 663,556 ‐ 1,660 665,216 ‐ ‐ 665,216
DEBT SERVICE FUNDS:
219 1989 Unlimited GO Bonds ‐ ‐ ‐ ‐ ‐ ‐ ‐
CAPITAL PROJECT FUNDS (CIP):
303 Community Dev Mitigation 1,475,050 60,000 25,476 1,500,526 400,000 ‐ 1,500,526
304 Fire Mitigation 1,492,674 100,000 201,737 1,694,411 536,926 ‐ 1,694,411
305 Transportation Mitigation 657,187 100,000 27,524 684,711 450,000 450,000 234,711
316 Municipal Facilities CIP 3,745,546 2,928,009 828,184 4,573,730 6,337,982 1,166,544 3,407,186
317 Transportation CIP 3,422,219 26,755,575 10,596,935 14,019,154 30,135,972 11,494,384 2,524,770
318 So Lake WA Infrastructure Proj 52,792 ‐ 131 52,923 52,024 441 52,482
326 Housing Opportunity 130,546 ‐ 3,297 133,843 125,000 50,000 83,843
336 New Library Development 19,196,447 ‐ 44,287 19,240,734 19,196,447 522,348 18,718,386
ENTERPRISE FUNDS:
402 Airport 494,718 1,299,150 1,083,458 1,578,176 1,307,780 892,868 685,308
403 Solid Wa ste Utility 1,734,734 15,021,811 10,218,073 11,952,807 15,014,481 9,504,925 2,447,882
404 Golf Course 379,997 2,483,545 1,600,538 1,980,535 2,492,204 1,249,979 730,556
422 Airport Capital 1,589,992 4,149,219 867,059 2,457,051 5,639,211 572,010 1,885,041
424 Golf Course Capital 235,491 50,000 50,630 286,121 145,000 28,309 257,812
INTERNAL SERVICE FUNDS:
501 Equipment Repair/Replacement 4,774,376 3,190,893 2,105,390 6,879,766 3,979,127 2,826,601 4,053,165
502 Insurance 6,620,437 3,187,593 2,055,555 8,675,992 3,134,079 2,053,042 6,622,950
503 Information Services 2,181,743 4,126,173 2,816,219 4,997,962 5,959,686 2,893,191 2,104,771
504 Facilities 300,238 4,334,952 2,829,689 3,129,927 4,389,399 2,416,506 713,421
505 Communications 141,120 974,307 670,327 811,447 991,015 571,750 239,697
512 Insurance, Healthcare 7,133,996 12,014,224 7,809,022 14,943,018 11,996,739 7,642,565 7,300,453
522 Insurance, Leoff1 Retirees HC 5,479,399 2,235,684 1,530,281 7,009,680 2,262,573 807,947 6,201,733
FIDUCIARY FUNDS:
611 Firemen's Pension 4,377,696 300,000 124,255 4,501,951 550,475 157,138 4,344,813
Funds
Balance
01/01/2012
Budgeted
Revenue
Revenue
08/31/12
Total Funds
Available
Budgeted
Expenditure
Expenditure
08/31/12
Ending
Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 14,140,266 49,406,145 31,556,830 45,697,096 52,104,452 25,907,000 19,790,096
405 Water Utility 3,993,415 11,106,460 8,120,984 12,114,399 10,689,883 6,641,169 5,473,230
406 Waste Water Utility 685,178 5,888,574 4,338,058 5,023,236 5,130,805 3,642,400 1,380,836
407 Surface Water Utility 1,625,915 5,637,563 4,358,801 5,984,716 5,479,377 3,114,680 2,870,036
416 King County Metro 1,077,805 13,209,387 9,013,982 10,091,787 13,209,387 8,510,755 1,581,032
425 Water Utility Construction 3,633,246 5,369,215 1,475,641 5,108,887 7,085,000 1,066,613 4,042,274
426 Waste Water Construction 524,178 3,310,000 2,130,707 2,654,885 3,710,000 1,151,279 1,503,606
427 Surface Water Construction 2,584,684 4,884,946 2,118,617 4,703,301 6,800,000 1,780,104 2,923,197
461 Waterworks Bond Reserve ‐ ‐ ‐ ‐ ‐ ‐ ‐
471 Waterworks Rate Stabilization 15,845 ‐ 40 15,885 ‐ ‐ 15,885
481 Future W/S Bond Proceeds ‐ ‐ ‐ ‐ ‐ ‐ ‐
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
October
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,193,603 5,169,136 ‐0.47%
Feb 10,686,507 10,715,775 0.27%
Mar 16,252,798 16,218,914 ‐0.21%
Apr 29,859,544 32,180,045 7.77%
May 45,353,538 46,051,336 1.54%
Jun 50,349,298 51,288,412 1.87%
Jul 56,152,355 57,687,119 2.73%
Aug 61,717,736 63,335,690 2.62%
Sep 67,933,451
Oct 81,368,568
Nov 96,216,488
Dec 101,953,223
Percent of budget 62.12%
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
Oct 24,750,333
Nov 32,724,934
Dec 32,896,746
Percent of budget 53.80%
$‐
$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
Oct 16,615,185
Nov 18,322,808
Dec 19,965,647
Percent of budget 67.81%
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
Oct 13,458,742
Nov 14,740,056
Dec 16,155,203
Percent of budget 66.86%
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
Oct 2,019,748
Nov 2,211,675
Dec 2,403,331
Percent of budget 76.53%
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,862,055
Oct 9,224,990
Nov 11,643,475
Dec 12,235,154
Percent of budget 62.51%
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
Oct 5,652,987
Nov 6,159,124
Dec 6,691,060
Percent of budget 67.46%
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
Oct 2,562,900
Nov 2,862,140
Dec 3,214,156
Percent of budget 62.69%
$‐
$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 650,754 612,068 ‐5.94%
Feb 891,088 954,879 7.16%
Mar 1,133,369 1,216,856 7.37%
Apr 1,766,475 1,919,894 8.69%
May 2,266,200 2,445,811 7.93%
Jun 2,634,402 2,895,320 9.90%
Jul 3,493,772 3,811,124 9.08%
Aug 3,795,997 4,148,648 9.29%
Sep 4,080,306
Oct 5,015,737
Nov 5,416,642
Dec 6,050,976
Percent of budget 68.56%
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,421 206,151 60.53%
Feb 175,400 289,974 65.32%
Mar 253,352 394,394 55.67%
Apr 311,392 492,558 58.18%
May 396,848 637,771 60.71%
Jun 510,515 731,604 43.31%
Jul 629,398 843,920 34.08%
Aug 729,072 987,309 35.42%
Sep 805,324
Oct 867,135
Nov 934,797
Dec 1,099,199
Percent of budget 89.82%
$‐
$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 87 90 3.21%
Mar 348 5,494 1478.88%
Apr 18,266 8,797 ‐51.84%
May 18,328 143,912 685.20%
Jun 18,378 144,143 684.32%
Jul 18,415 144,991 687.35%
Aug 18,477 145,543 687.70%
Sep 1,142,946
Oct 1,200,811
Nov 1,200,836
Dec 1,241,752
Percent of budget 11.72%
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 158,072 77,631 ‐50.89%
Feb 255,393 291,768 14.24%
Mar 393,741 495,352 25.81%
Apr 502,119 690,220 37.46%
May 655,898 943,666 43.87%
Jun 879,012 1,290,845 46.85%
Jul 993,789 1,468,685 47.79%
Aug 1,149,532 1,691,618 47.16%
Sep 1,350,432
Oct 1,535,639
Nov 1,863,587
Dec 2,025,000
Percent of budget 83.54%
$‐
$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,260,682 6,667,414 ‐8.17%
Feb 15,677,774 15,284,017 ‐2.51%
Mar 22,981,905 22,281,867 ‐3.05%
Apr 31,722,363 31,242,984 ‐1.51%
May 39,048,870 38,877,391 ‐0.44%
Jun 48,321,979 47,714,859 ‐1.26%
Jul 56,124,367 55,549,735 ‐1.02%
Aug 64,356,158 63,356,444 ‐1.55%
Sep 76,521,326
Oct 84,769,735
Nov 93,132,969
Dec 102,353,876
Percent of budget expended 61.90%
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
Oct 235,771
Nov 259,647
Dec 284,087
Percent of budget expended 65.02%
$‐
$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
Oct 1,204,110
Nov 1,318,583
Dec 1,468,694
Percent of budget expended 60.76%
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
Oct 58,229
Nov 65,292
Dec 71,025
Percent of budget expended 58.33%
$‐
$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 135,939 136,926 0.73%
Feb 280,202 277,093 ‐1.11%
Mar 419,912 419,219 ‐0.16%
Apr 560,129 563,552 0.61%
May 698,477 700,106 0.23%
Jun 838,962 844,781 0.69%
Jul 978,014 982,591 0.47%
Aug 1,116,943 1,122,280 0.48%
Sep 1,255,965
Oct 1,386,265
Nov 1,523,461
Dec 1,668,686
Percent of budget expended 67.26%
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
Oct 1,784,453
Nov 1,963,784
Dec 2,155,819
Percent of budget expended 64.76%
$‐
$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
Oct 794,989
Nov 873,950
Dec 952,912
Percent of budget expended 66.21%
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
Oct 2,863,779
Nov 3,141,884
Dec 3,434,929
Percent of budget expended 58.25%
$‐
$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 59,421 51,733 ‐12.94%
Feb 124,792 115,634 ‐7.34%
Mar 178,769 164,809 ‐7.81%
Apr 237,200 209,460 ‐11.69%
May 304,084 255,933 ‐15.83%
Jun 366,115 306,119 ‐16.39%
Jul 430,836 352,657 ‐18.15%
Aug 487,814 401,680 ‐17.66%
Sep 561,518
Oct 620,200
Nov 686,272
Dec 753,765
Percent of budget expended 53.29%
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
Oct 1,277,610
Nov 1,377,062
Dec 1,516,719
Percent of budget expended 65.60%
$‐
$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
Oct 1,554,314
Nov 1,696,851
Dec 2,161,836
Percent of budget expended 62.36%
YTD Annual % $0 80
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
Oct 863,525
Nov 930,561
Dec 1,002,105
Percent of budget expended 67.56%
$‐
$0.20
$0.40
$0.60
$0.80
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
Oct 771,451
Nov 853,247
Dec 946,956
Percent of budget expended 66.03%
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 22,942,085
Oct 25,357,122
Nov 27,888,227
Dec 30,555,217
Percent of budget expended 60.86%
$‐
$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,926,514 1,891,121 ‐1.84%
Feb 4,578,628 4,615,089 0.80%
Mar 6,477,477 6,539,657 0.96%
Apr 8,345,799 8,435,070 1.07%
May 10,309,325 10,741,041 4.19%
Jun 12,235,348 12,628,919 3.22%
Jul 14,209,782 14,471,622 1.84%
Aug 16,254,213 16,441,012 1.15%
Sep 18,244,725
Oct 20,112,582
Nov 22,108,827
Dec 24,099,606
Percent of budget expended 68.22%
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
Oct 349,074
Nov 384,584
Dec 421,043
Percent of budget expended 67.90%
$‐
$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
Oct 3,348,621
Nov 3,709,562
Dec 4,045,762
Percent of budget expended 62.81%
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
Oct 561,935
Nov 625,369
Dec 685,122
Percent of budget expended 53.06%
$‐
$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
Oct 4,458,478
Nov 4,852,563
Dec 5,276,859
Percent of budget expended 63.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 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
Oct 1,005,515
Nov 1,095,976
Dec 1,277,487
Percent of budget expended 58.60%
$‐
$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 42,811 41,419 ‐3.25%
Feb 85,883 79,802 ‐7.08%
Mar 129,550 129,143 ‐0.31%
Apr 180,806 168,204 ‐6.97%
May 230,302 209,582 ‐9.00%
Jun 293,808 258,915 ‐11.88%
Jul 363,607 328,394 ‐9.68%
Aug 429,239 383,481 ‐10.66%
Sep 484,127
Oct 529,989
Nov 583,317
Dec 697,288
Percent of budget expended 55.00%
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 172,500
Oct 191,667
Nov 210,833
Dec 230,000
Percent of budget expended 116.79%
$‐
$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
Oct 177,858
Nov 195,702
Dec 213,533
Percent of budget expended 67.49%
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
Oct 388,230
Nov 426,925
Dec 465,889
Percent of budget expended 67.66%
$‐
$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
Oct 3,088,569
Nov 3,403,987
Dec 3,728,945
Percent of budget expended 66.05%
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
Oct 3,889,049
Nov 4,270,515
Dec 4,763,972
Percent of budget expended 61.10%
$‐
$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 4,898,530
Oct 5,442,811
Nov 5,987,092
Dec 6,531,373
Percent of budget expended 33.05%
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,208,186
Oct 2,453,540
Nov 2,698,894
Dec 2,944,248
Percent of budget expended 70.39%
$‐
$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,475,799 4,860,643 3,270,986
Feb 8,418,801 9,712,888 7,451,062
Mar 14,051,183 15,372,251 11,393,139
Apr 18,326,955 20,105,679 15,700,049
May 22,684,083 25,621,490 19,760,057
Jun 31,272,421 30,561,965 25,608,749
Jul 36,738,457 36,536,725 30,837,617
Aug 41,485,486 41,774,863 35,411,926
Sep 47,210,495
Oct 52,849,867
Nov 58,237,289
Dec 67,118,933
Percent of budget expended 43.36%
Note: Operations and Capital
$0
$10
$20
$30
$40
$50
$60
$70
$80
Millions Utilities
Budget
Revenue
Expense
$8 00
Millions Airport
Airport Budget Revenue Expense
Jan 491,361 182,302 131,563
Feb 880,323 480,547 293,170
Mar 1,313,329 679,165 431,819
Apr 1,790,795 909,193 601,497
May 2,161,070 1,114,820 823,315
Jun 2,896,131 1,360,778 1,122,991
Jul 3,375,334 1,744,572 1,261,393
Aug 4,206,194 1,950,517 1,464,878
Sep 4,852,959
Oct 5,709,245
Nov 6,373,308
Dec 6,946,991
Percent of budget expended 21.09%
Note: Operations and Capital
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
$7.00
$8.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
Oct 1,041,874
Nov 1,206,844
Dec 2,637,204
Percent of budget expended 48.47%
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