HomeMy WebLinkAbout201204, April.pdfFINANCE AND
INFORMATION TECHNOLOGY
M E M O R A N D U M
DATE: May 17, 2012
TO: Rich Zwicker, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: April 2012 Financial Status Report
At the end of April, general governmental revenues show $2.3 million or 7.8% over budget.
Revenues sources that are higher than expected are: property taxes ($2.1 million); gambling
excise taxes ($46k); real estate excise taxes ($144k); building permits & development service
fees ($236k); state shared revenues ($96k); rents, leases, and concessions ($68k); and other
miscellaneous (74k). On the down side, the revenue sources that are underperforming the year
to date budget are: franchise fees ($43k below); utility taxes ($112k below); culture and
recreation fees ($79k below); interfund/inter‐departmental services ($216k below); and
fines/forfeitures ($87k below).
The $2.3 million favorable revenue variance is mostly due to the $2.1 million higher than
expected collections in property taxes. This is due to the timing of collections in which the $2.1
million was recorded in April instead of normally being recorded in May. Taking this amount
out, the general governmental revenues are actually $218k or 0.7% favorable.
General government expenditures showed favorable variance of $479k or 1.5%. 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.
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.0%
OPERATING REVENUES
Property Tax 31,497,128 7,697,974 32,357,894 9,205,472 32,896,746 9,024,212 11,127,076 2,102,864 23.3%
Sales Tax 17,198,220 5,768,664 17,729,731 5,876,031 17,864,000 5,939,662 5,925,812 (13,850) ‐0.2%
Sales Tax ‐ Annexation Credit 2,025,660 677,118 2,033,954 663,746 2,101,647 685,836 711,311 25,475 3.7%
Criminal Justice Sales Tax 1,620,479 536,715 1,809,757 562,500 1,867,145 580,337 606,636 26,299 4.5%
Natural Gas Use Tax 228,514 99,228 249,407 109,217 270,394 118,408 164,028 45,621 38.5%
Admission Tax 291,399 141,355 308,200 134,463 350,000 152,699 154,705 2,005 1.3%
Franchise Fees 1,222,444 594,746 1,234,448 600,206 1,323,000 643,262 599,927 (43,335) ‐6.7%
Electricity Tax 5,036,907 1,822,135 5,166,711 1,928,010 5,283,280 1,971,509 1,972,182 672 0.0%
Natural Ga s Utility Tax 1,577,756 754,082 1,848,806 950,006 1,950,000 1,002,004 902,298 (99,706) ‐10.0%
Transfer Station 269,912 67,963 297,474 74,244 248,762 62,087 87,625 25,539 41.1%
TV Cable 1,296,744 439,031 1,385,275 432,285 1,427,679 445,518 435,101 (10,417) ‐2.3%
Telephone 1,038,009 346,118 966,827 329,404 1,000,000 340,706 308,743 (31,963) ‐9.4%
Cellular Phone 2,206,637 750,775 2,054,183 711,036 2,309,360 799,363 736,280 (63,082) ‐7.9%
City Utilities 2,853,884 914,373 3,516,179 1,128,654 3,665,728 1,176,657 1,198,213 21,556 1.8%
Leasehold Excise Tax 138,830 36,976 162,593 36,189 145,000 32,273 36,481 4,208 13.0%
Gambling Excise Tax 1,546,386 532,483 1,671,414 551,756 1,600,000 528,181 574,574 46,393 8.8%
Real Estate Excise Tax 2,464,489 769,455 2,074,059 514,275 2,025,000 501,895 690,220 188,325 37.5%
Less: Municipal Facilities CIP REET (400,000) (127,787) (400,000) (91,835) (400,000) (91,835) (136,340) (44,505) 48.5%
EMS Levy 1,161,114 ‐ 868,873 51,467 1,007,976 ‐ ‐ ‐ 0.0%
Business License Fees 431,782 195,045 442,451 195,003 469,817 207,064 206,858 (206) ‐0.1%
Other Licenses and Permits 262,629 83,563 232,534 57,805 213,305 53,025 81,688 28,663 54.1%
Building Permits & Development Svc Fees 2,437,270 839,812 2,772,779 730,608 2,466,063 644,451 880,622 236,171 36.6%
Intergovt'l (Grants, State Shared, etc) 4,426,676 1,572,167 4,737,323 1,269,625 4,359,315 1,016,753 1,086,517 69,764 6.9%
Fire District 25 and 40 Contracts 5,252,877 19,525 6,110,668 875,762 6,008,694 799,107 799,107 ‐ 0.0%
Public Safety 482,343 148,438 484,985 142,506 430,635 126,536 153,856 27,321 21.6%
Culture and Recreation 1,424,932 379,140 1,493,540 397,684 1,660,863 442,237 363,431 (78,806) ‐17.8%
Interfund/Interdept‐Services 3,190,908 1,114,110 3,070,506 955,923 3,617,185 1,212,739 996,283 (216,456) ‐17.8%
Fines and Forfeits 1,291,817 337,093 1,163,602 333,659 1,088,750 311,611 275,874 (35,737) ‐11.5%
Photo Enforcement 1,925,159 657,615 1,897,782 705,422 1,944,713 722,866 654,101 (68,766) ‐9.5%
Seizure Funds ‐ Federal/State/Local 221,046 46,627 83,220 ‐ 180,693 ‐ 17,904 17,904 100.0%
Interests and Other Earnings 183,511 53,332 107,183 25,356 125,400 29,666 29,924 258 0.9%
Rents, Leases, and Concessions 727,338 298,827 744,834 264,766 701,464 249,349 317,035 67,686 27.1%
Contributions and Donations 133,756 35,704 196,586 49,818 81,500 20,653 46,718 26,065 126.2%
Other Miscellaneous 434,286 145,114 529,147 124,491 427,358 92,447 166,458 74,011 80.1%
Other Financing Sources (Transfer‐In, etc) 653,595 245 1,073,507 167,151 1,241,752 18,266 8,797 (9,469) ‐51.8%
Total Operating Revenues 96,754,435 27,747,760 100,476,431 30,062,704 101,953,223 29,859,544 32,180,045 2,320,501 7.8%
OPERATING EXPENDITURES
Legislative 259,345 87,679 271,236 89,659 284,087 94,952 91,998 2,954 3.1%
Executive 1,578,526 539,712 1,566,906 480,072 1,468,694 476,167 427,410 48,757 10.2%
Hearing Examiner 174,447 58,097 59,878 25,472 71,025 25,330 21,235 4,096 16.2%
City Attorney 1,565,597 532,980 1,596,609 528,480 1,668,686 560,129 563,552 (3,423) ‐0.6%
Court Services 2,007,599 664,092 2,084,170 661,478 2,155,819 698,400 674,406 23,994 3.4%
Community and Eco Dvlpmnt Admin 579,396 194,735 929,814 310,112 952,912 318,760 322,177 (3,417) ‐1.1%
Development Services 2,946,413 1,009,764 2,810,736 953,343 3,434,929 1,171,262 959,516 211,746 18.1%
Economic Development 1,322,004 409,322 724,970 234,834 753,765 237,200 209,460 27,740 11.7%
Planning 1,774,508 504,760 1,447,781 475,330 1,516,719 461,325 493,399 (32,075) ‐7.0%
Finance 2,214,458 591,163 2,134,667 620,994 2,161,836 602,531 635,592 (33,061) ‐5.5%
City Clerk 789,209 229,025 736,880 315,627 1,002,105 357,645 226,333 131,312 36.7%
Human Resources 861,221 283,314 888,252 282,721 946,956 306,383 299,810 6,574 2.1%
Police 23,946,386 7,955,883 24,737,346 8,219,907 25,214,618 8,377,878 8,318,096 59,782 0.7%
Jail Services 3,539,035 999,808 6,206,735 749,488 5,340,599 1,162,786 1,162,786 ‐ 0.0%
Fire 21,554,792 7,607,800 22,511,597 7,652,583 24,099,606 8,345,799 8,435,070 (89,271) ‐1.1%
Community Services Admin 1 1,063,011 351,426 416,284 136,129 421,043 138,770 143,787 (5,017) ‐3.6%
Parks 3,421,424 989,504 3,829,676 1,109,451 4,045,762 1,171,115 1,179,119 (8,004) ‐0.7%
Parks Planning & Natural Resources 448,574 114,194 551,423 150,610 685,122 181,424 169,504 11,920 6.6%
Recreation 4,433,420 1,191,976 4,974,002 1,408,767 5,276,859 1,458,822 1,377,160 81,662 5.6%
Human Services 1,326,778 383,074 1,247,294 369,358 1,277,487 373,425 409,836 (36,411) ‐9.8%
Neighborhoods, Resources, & Events 331,222 86,610 610,545 157,589 697,288 180,806 168,204 12,602 7.0%
Library 2,289,692 505,911 2,030,000 10,119 230,000 58,604 58,604 ‐ 0.0%
Museum 191,090 62,643 210,620 69,499 213,533 70,241 71,901 (1,660) ‐2.4%
Public Works Admin 1 514,858 172,378 452,538 149,219 465,889 154,878 158,967 (4,089) ‐2.6%
Street Maintenance 3,412,892 1,095,310 3,534,025 1,168,482 3,728,945 1,215,152 1,217,508 (2,357) ‐0.2%
Transportation 5,215,309 1,640,081 4,509,066 1,429,170 4,763,972 1,503,626 1,428,601 75,026 5.0%
Debt Service 4,707,100 126,471 4,822,566 390,380 6,531,373 842,026 842,026 ‐ 0.0%
Non‐Departmental and Other 4,834,296 1,429,727 4,930,383 2,214,722 2,944,248 1,176,929 1,176,929 ‐ 0.0%
Total Operating Expenditures 97,302,601 29,817,438 100,825,999 30,363,594 102,353,876 31,722,363 31,242,984 479,379 1.5%
Total Ending Fund Balance 11,407,119$ 9,885,607$ 11,057,551$ 11,106,230$ 10,656,898$ 9,194,732$ 11,994,612$ 2,799,880 30.5%
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 April 2012
Page 1 of 36
Monthly Financial Report April 2012
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through April 30, 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 79% of
all resources supporting general governmental activities. The following section provides detail information on property,
sales, utility, and other taxes.
Property Tax
April’s collection is $10 million,
making the total year‐to‐date
collection $11.1 million or 34% of
the total budget. In comparison
to the previous year, the City
collected $1.9 million or 21%
more. Compared to the budget,
the City is above projections by
$2.1 million or 23%. 2012’s
monthly budgets are based on
2009 through 2011 collections.
The 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
remove this amount, the City is right on target with budget projections.
Sales Tax
April 2012 sales tax receipts totalled
$1.4 million. Compared to the same
month last year, it is $116k or 9%
more. Compared to the projected
current month’s budget, it is $21k or
1% below. The year‐to‐date collection
of $5.9 million is $50k or 1% more than
the prior year but is $14k less than
budgeted. The City is projecting sales
tax revenues to be slightly under 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
Jun 54,963 98,578
Jul 112,076 106,083
Aug 25,954 84,126
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 9,205,472$ 9,024,212$ 11,127,076$ 1,921,604$ 21% 2,102,864$ 23%
Annual Total 32,357,894$ 32,896,746$
Property Tax Revenues
Year to Date through April
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 ‐
Jun 1,368,213 1,422,596 ‐
Jul 1,437,859 1,411,637 ‐
Aug 1,534,218 1,522,536 ‐
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 5,876,031$ 5,939,662$ 5,925,812$ 49,781$ 1% (13,850)$ 0%
Annual Total 17,729,731$ 17,864,000$
2012 vs. Budget2012 vs. 2011
Month
Year to Date through April
Local Retail Sales Tax Revenues
Page 2 of 36
Monthly Financial Report April 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 447,248$ 550,963$ 514,243$ 66,995$ 15%$ (36,720)‐7%
Auto Sales 1,026,985 1,103,588 1,054,395 27,410 3% (49,193)‐4%
General Retail 2,048,966 2,148,879 2,188,496 139,530 7% 39,617 2%
Manufacturing 500,880 264,751 336,085 (164,795) ‐33% 71,334 27%
Wholesale 379,099 387,531 370,201 (8,898) ‐2% (17,330)‐4%
Service 1,316,276 1,350,800 1,352,548 36,271 3% 1,747 0%
Other 156,578 133,149 109,845 (46,734) ‐30% (23,304)‐18%
Total 5,876,031$ 5,939,662$ 5,925,812$ 49,781$ 1%(13,850)$ 0%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility tax
April utility tax revenues are $1.4
million, which is $14k or 1% higher
than the same month last year but is
behind the budget by $49k or 3%.
The year‐to‐date collection is $5.8
million, which is $142k or 3% higher
than the prior year but is $112k or 2%
lower than the budget. The City is
projecting utility tax revenues to be
under budget by about $300k at year‐
end.
The table below breaks out Utility Tax by source.
Utility Tax by Type 2011 2012 Bgt YTD Act Change 2012/2011 2012 Act vs Bgt
Electrical 1,928,010$ 1,971,509$ 1,972,182$ 44,171$ 2%$ 672 0%
Natural Gas 1,059,223 1,120,412 1,066,327 7,103 1% (54,086)‐5%
Cell 711,036 799,363 736,280 25,245 4% (63,082)‐8%
Phone 329,404 340,706 308,743 (20,661) ‐6% (31,963)‐9%
Cable 432,285 445,518 435,101 2,816 1% (10,417)‐2%
Transfer Station 74,244 62,087 87,625 13,381 18% 25,539 41%
City Utilities 1,128,654 1,176,657 1,198,213 69,560 6% 21,556 2%
YTD Total 5,662,856$ 5,916,252$ 5,804,472$ 141,615$ 3%(111,780)$ ‐2%
Annual Total 15,484,862$ 16,155,203$
YTD as % of 37% 37%
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
Jun 1,203,475 1,256,117
Jul 1,188,526 1,240,117
Aug 1,165,863 1,217,180
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 5,662,856$ 5,916,252$ 5,804,472$ 141,615$ 3% (111,780)$ ‐2%
Annual Total 15,484,862$ 16,155,203$
2012 vs. Budget2012 vs. 2011
Year to Date through April
Utility Tax Revenues
Month
Page 3 of 36
Monthly Financial Report April 2012
Other Taxes
Real Estate Excise Tax
The City collected $195k in Real Estate
Excise Tax revenues (REET) for April.
This is $84k or 76% ahead of the same
month last year and $87k or 80% above
the current month’s budget. The year‐
to‐date collection is $690k, which is
$176k or 34% more than the prior year
and is also $188k or 38% above the
budget. The City is projecting REET to
meet the budget at year‐end.
Gambling Tax
April’s Gambling Tax collections
total $156k. Year‐to‐date total of
$575k is $23k or 4% above the
year before and is also $46k or 9%
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 City is projecting gambling tax revenues to meet the budget at year‐end.
Pull tabs overall had a 3% increase, bingo increased by 38%, and card‐rooms are seeing 3% lower in activities when
compared to the prior year.
Franchise Fees
Franchise Fees are due quarterly
and the year‐to‐date revenue
collections are $600k or 45% of
the budget. This is right on target
with 2011 but is $43k or 7% 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
Jun 228,506 223,006
Jul 117,567 114,737
Aug 159,524 155,683
Sep 205,753 200,800
Oct 189,691 185,125
Nov 335,893 327,808
Dec 165,331 162,219
YTD Total 514,275$ 501,895$ 690,220$ 175,945$ 34% 188,325$ 38%
Annual Total 2,074,059$ 2,025,000$
Real Estate Excise Tax Revenues
Year to Date through April
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 ‐
Jun 151,240 144,778 ‐
Jul 136,775 130,931 ‐
Aug 144,161 138,001 ‐
Sep 125,618 120,251 ‐
Oct 92,937 88,966 ‐
Nov 139,018 133,078 ‐
Dec 170,897 163,595 ‐
YTD Total 551,756$ 528,181$ 574,574$ 22,818$ 4% 46,393$ 9%
Annual Total 1,671,414$ 1,600,000$
Year to Date through April
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 ‐
Oct 292,692 313,688 ‐
Dec 47,111 50,491 ‐
YTD Total 600,206$ 643,262$ 599,927$ (279)$ 0% (43,335)$ ‐7%
Annual Total 1,234,448$ 1,323,000$
Month
2012 vs. 2011 2012 vs. Budget
Franchise Fees Revenue
Year to Date through April
Page 4 of 36
Monthly Financial Report April 2012
Admission Tax
Admission Tax returns are due
quarterly in January, April, July,
and October each year. April
2012 collections represent
activities conducted during the 1st
quarter of 2012.
The report shows an increase of
$20k or 15% from the year before
and is also $2k or 1% more than
anticipated. The City is projecting
admission tax revenues to meet the budget at year‐end.
Licenses and Permits
Building Permits and Development Service Fees
Building Permits and Development
Service Fee revenues totalled $259k in
April. The year‐to‐date development
fees revenue of $881k is $150k or 21%
more than 2011 and is also $236k or
37% higher than budget. The higher
than expected fees are due to collecting
more in general building permits,
electrical permits and plan check fees.
The City is projecting building permits
and development service fee revenues
to meet the budget at year‐end.
Business Licenses
Business Licenses totalled $89k for April,
which is $5k or 6% above the same month last
year and is right on target with the current
month’s budget. The year‐to‐date Business
Licenses revenue is ahead of the prior year by
$12k or 6% and is right on target with the
budget.
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 ‐
Aug 1,194 1,356 ‐
Oct 86,112 97,791 ‐
YTD Total 134,463$ 152,699$ 154,705$ 20,242$ 15% 2,005$ 1%
Annual Total 308,200$ 350,000$
Month
2012 vs. 2011 2012 vs. Budget
Admission Tax Revenue
Year to Date through April
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 ‐
Jun 3,964 4,209 ‐
Jul 83,962 89,155 ‐
Aug 18,393 19,531 ‐
Sep 4,135 4,391 ‐
Oct 95,874 101,804 ‐
Nov 18,291 19,423 ‐
Dec 2,686 2,852 ‐
YTD Total 195,003$ 207,064$ 206,858$ 11,855$ 6% (206)$ 0%
Annual Total 442,451$ 469,817$
2012 vs. 2011
Year to Date through April
2012 vs. Budget
Business Licenses
Month
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
Jun 215,975 195,717
Jul 211,760 187,937
Aug 393,797 351,616
Sep 321,961 289,918
Oct 213,930 189,380
Nov 229,322 196,766
Dec 216,409 194,437
YTD Total 730,608$ 644,451$ 880,622$ 150,014$ 21% 236,171$ 37%
Annual Total 2,772,779$ 2,466,063$
Building Permits and Development Service Fees
Year to Date through April
2012 vs. Budget2012 vs. 2011
Month
Page 5 of 36
Monthly Financial Report April 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 93% of the total revenues in this category. The year‐to‐date total Intergovernmental revenue is $2.5 million or
20% of the budget.
State Shared Revenues
State Shared Revenue
collections totalled $1.5 million
since the start of 2012.
Compared to the prior year,
State Shared Revenues are
above by $4k. Compared to
the projected budget, the City
is collecting $96k or 7% more.
The higher than expected
collections are due to Criminal
Justice’s High Crime not being
budgeted for. The City is
projecting the total state
shared revenues to meet 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 72% of the total revenue in this category. The year‐to‐date total charges for services are $1.9 million or 28% of
the budget. This is 8% below budget projections. The following sections provide detail information for Public Safety,
Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totalled $154k 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 $11k or 8%
more. Compared to the budget, the City is
collecting $27k or 22% more than anticipated
revenue. The City is projecting public safety
services revenues to meet the budget at year‐
end.
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 ‐
Jun 46,295 41,107 ‐
Jul 70,094 62,239 ‐
Aug 35,891 31,868 ‐
Sep 30,743 27,298 ‐
Oct 34,756 30,861 ‐
Nov 42,944 38,131 ‐
Dec 46,148 40,976 ‐
YTD Total 142,506$ 126,536$ 153,856$ 11,351$ 8% 27,321$ 22%
Annual Total 484,985$ 430,635$
Month
2012 vs. 2011
Year to Date through April
Public Safety Services
2012 vs. Budget
Intergovernmental 2011 2012 Bgt YTD Act Change 2012/2011 2012 Act vs Bgt
Fire District #25 597,476$ 646,907$ 646,907$ 49,431$ 8% $ ‐ 0%
Fire District #40 278,286 152,200 152,200 (126,086) ‐45%‐ 0%
State Shared Revenue 1,511,638 1,419,839 1,515,902 4,264 0% 96,063 7%
Federal Grants 158,327 85,002 85,002 (73,325) ‐46%‐ 0%
State Grants 58,771 40,908 40,908 (17,863) ‐30%‐ 0%
Other Grants/Intgovt 82,836 51,342 51,342 (31,494) ‐38%‐ 0%
ARRA Grants 125,916 ‐ ‐ (125,916) 0%‐ N/A
Total Rev YTD 2,813,250$ 2,396,197$ 2,492,260$ (320,990)$ ‐11%96,063$ 4%
Total Rev Annual 12,657,748$ 12,235,154$
YTD %22% 20% 20%
Note: Includes CJ Sales Tax.
2011 2012 2012
Actual Budget Actual $ % $ %
Crim Just Sales Tax 562,500$ 580,337$ 606,636$ 44,136$ 8% 26,299$ 5%
Judicial Contribution 11,234 6,000 5,658 (5,576) ‐50% (342) ‐6%
Crim Just ‐ High Crime 96,385 ‐ 93,724 (2,661) ‐3% 93,724 100%
Crim Just ‐ Pop 9,840 ‐ 10,194 354 4% 10,194 100%
Crim Just ‐ Spec Prog 37,165 33,649 38,473 1,308 4% 4,823 14%
State DUI 8,013 6,382 8,895 882 11% 2,513 39%
Liquor Profits 168,155 172,438 123,076 (45,079) ‐27% (49,362) ‐29%
Liquor Excise Tax 220,756 225,557 229,464 8,708 4% 3,907 2%
Fuel Tax 397,589 395,476 399,781 2,192 1% 4,306 1%
YTD Total 1,511,638$ 1,419,839$ 1,515,902$ 4,264$ 0% 96,063$ 7%
Annual Total 4,495,551$ 4,437,913$
Year to Date through April
State Shared Revenues
2012 vs. 2011
Revenue
2012 vs. Budget
Page 6 of 36
Monthly Financial Report April 2012
Recreation
Recreation revenues totalled $137k for
the current month. Compared to the
same month the prior year, the City
collected $16k or 11% less. Compared to
the projected monthly budget, the City
collected $34k or 20% less. The year‐to‐
date collection of $363k is $34k or 9%
less than the prior year and is also $79k
or 18% 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 $996k. Compared
to the prior year, the revenues are under
by $33k or 3%. Compared to the
projected budget, the revenues are
below by $216k or 18%. 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 $940k. This is $90k or 9% lower than a
year ago and also $94k or 9% below the
budget. The City is projecting fines and
penalties to be under budget at year‐end.
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 ‐
Jun 234,878 276,697 ‐
Jul 238,262 280,683 ‐
Aug 229,627 270,511 ‐
Sep 237,006 279,203 ‐
Oct 270,340 318,472 ‐
Nov 266,859 314,371 ‐
Dec 308,654 363,607 ‐
YTD Total 1,029,453$ 1,212,739$ 996,283$ (33,170)$ ‐3% (216,456)$ ‐18%
Annual Total 3,070,506$ 3,617,185$
2012 vs. Budget
Month
Interfund Services
Year to Date through April
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
Jun 262,444 261,662
Jul 247,468 249,471
Aug 184,473 189,735
Sep 181,000 185,846
Oct 300,431 385,882
Nov 297,580 299,240
Dec 352,911 352,016
YTD Total 1,030,208$ 1,034,478$ 940,384$ (89,824)$ ‐9% (94,094)$ ‐9%
Annual Total 3,112,464$ 3,214,156$
Month
2012 vs. Budget2012 vs. 2011
Year to Date through April
Fines and Penalties by Month
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 ‐
Jun 144,083 160,224 ‐
Jul 211,388 235,070 ‐
Aug 254,060 282,523 ‐
Sep 142,253 158,189 ‐
Oct 83,540 92,899 ‐
Nov 77,528 86,214 ‐
Dec 48,890 54,368 ‐
YTD Total 397,684$ 442,237$ 363,431$ (34,253)$ ‐9% (78,806)$ ‐18%
Annual Total 1,493,540$ 1,660,863$
Recreation
Year to Date through April
2012 vs. Budget2012 vs. 2011
Month
Page 7 of 36
Monthly Financial Report April 2012
Year to Date through April
2011 2012 2012
Actual Budget Actual $ % $ %
Civil Penalties 3,990$ 5,583$ 2,601$ (1,389)$ ‐35% (2,982)$ ‐53%
Civil Infraction Penalties 211,474 226,871 168,641 (42,833) ‐20% (58,230) ‐26%
Civil Parking Infraction Penalties 32,843 35,819 29,383 (3,460) ‐11% (6,436) ‐18%
Photo Enforcement Program 705,422 722,866 654,101 (51,321) ‐7% (68,766) ‐10%
Criminal Traffic Misdemeanor Fines 30,936 28,006 24,889 (6,047) ‐20% (3,117) ‐11%
Criminal Non‐Traffic Fines 9,214 11,841 7,013 (2,201) ‐24% (4,828) ‐41%
Criminal Costs 36,288 3,425 35,520 (768) ‐2% 32,095 937%
Seizure Funds ‐ Federal/State/Local ‐ ‐ 17,904 17,904 100% 17,904 100%
Non‐Court Fines, Forfeitures and Penalties 40 65 333 293 731% 267 409%
YTD Total 1,030,208$ 1,034,478$ 940,384$ (89,824)$ ‐9% (94,094)$ ‐9%
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 $654k. 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 70% of the total
revenue in this category. The year‐to‐date
total miscellaneous is $493k. Compared to
last year, the revenues are over by $106k or
27%. Compared to the projected year‐to‐
date budget, the revenues are over by $181k
or 58%. The table on the next page breaks
out miscellaneous revenues by type:
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
Jun 145,018 113,666
Jul 173,878 118,884
Aug 133,570 99,673
Sep 97,973 76,252
Oct 75,425 61,811
Nov 77,427 67,662
Dec 163,299 164,402
YTD Total 386,523$ 311,392$ 492,558$ 106,035$ 27% 181,166$ 58%
Annual Total 1,350,195$ 1,099,199$
Year to Date through April
Month
2012 vs. Budget2012 vs. 2011
Miscellaneous Revenues by Month
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 ‐ 71,882 ‐ ‐
Jun 180,018 ‐ 71,871 ‐ ‐
Jul 155,574 ‐ 72,275 ‐ ‐
Aug 98,678 ‐ 56,688 ‐ ‐
Sep 83,853 ‐ 71,527 ‐ ‐
Oct 145,798 ‐ 71,420 ‐ ‐
Nov 211,430 ‐ 71,884 ‐ ‐
Dec 185,536 ‐ 72,273 ‐ ‐
YTD Total 722,866$ 654,101$ 282,143$ 268,266$ 385,835$
Annual Total 1,944,713$ 841,964$
1 Actuals of Revenues and Expenses
Expenses
Photo Enforcement Program
Year to Date through April
Month
Revenues
Page 8 of 36
Monthly Financial Report April 2012
2011 2012 2012
Actual Budget Actual $ % $ %
Interests and Other Earnings 25,356$ 29,666$ 29,924$ 4,568$ 18% 258$ 1%
Rents, Leases, and Concessions 264,766 249,349 317,035 52,269 20% 67,686 27%
Contributions/Donations from Private Sources 49,818 20,653 46,718 (3,099) ‐6% 26,065 126%
Other 46,583 11,724 98,880 52,298 112% 87,157 743%
YTD Total 386,523$ 311,392$ 492,558$ 106,035$ 27% 181,166$ 58%
Annual Total 1,350,195$ 1,099,199$
2012 vs. Budget
Miscellaneous Revenues by Type
Year to Date through April
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 31% of its budgeted general governmental expenditures at the end of April. This is $479k or
1.5% below year‐to‐date budgeted expenditures. See below for summary of unfavorable items for general governmental
departments.
City Attorney Department is over budget by $3k or 0.6%. This is mainly due to over spending on contracted services and
publications and under spending in salaries/benefits and supplies.
Fire and Emergency Services Department is over budget by $89k or 1.1%. This is mainly due to over spending on supplies
and intergovernmental ($126k) and under spending in professional services ($31k).
Page 9 of 36
Monthly Financial Report April 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 ‐ ‐ ‐ ‐ 14,610 12,650 ‐
Grants / intergovernmental 109,223 ‐ 107,838 52,524 ‐ 358,345 ‐
Charges for services 30,003 397,554 5,048,378 4,102,934 2,705,920 2,601,277 4,382,174
Interdepartmental services ‐ ‐ 3,031 94,371 85,037 194,067 ‐
Fines and penalties ‐ ‐ ‐ ‐ ‐ ‐ ‐
Rents, leases, and misc fees 766,907 71,862 30,000 43,997 ‐ ‐ ‐
Interest and other misc 3,060 1,275 9,635 56,318 142,678 58,465 1,451
TOTAL REVENUES 909,193 470,691 5,198,882 4,350,144 2,948,245 3,224,804 4,383,625
EXPENSES:
Utility billing ‐ ‐ 34,239 36,230 24,008 36,237 ‐
Utility systems ‐ ‐ 4,212,021 900,104 840,585 742,757 ‐
Utility maintenance ‐ ‐ 92,623 1,501,541 452,876 576,140 4,312,165
Transportation 434,915 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 574,529 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 434,915 574,529 4,338,883 2,437,875 1,317,469 1,355,134 4,312,165
AMOUNT AVAILABLE FOR DEBT SERVICE 474,278 (103,838) 860,000 1,912,269 1,630,776 1,869,670 71,460
DEBT SERVICE:
Principal ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest and other debt service costs ‐ ‐ ‐ ‐ ‐ ‐ ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ ‐ ‐ ‐ ‐
CAPITAL PROJECTS 166,581 14,761 ‐ 368,020 545,069 1,025,432 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CH ANGE IN FUND BALANCE 307,697 (118,599) 860,000 1,544,249 1,085,707 844,238 71,460
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, April 30, 2012 2,392,407 496,889 2,594,734 9,186,755 2,295,063 5,054,837 1,149,265
Page 10 of 36
Monthly Financial Report April 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 ‐ 27,063 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ 17,500 1,915 ‐ ‐ ‐ 43,637
Charges for services
Equipment rental m&o 742,519 705,482 ‐ ‐ ‐ ‐ ‐
Telecommunications ‐ 62,121 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 35,551 ‐ 132,371 ‐ ‐ ‐
Communications ‐ ‐ ‐ 197,104 ‐ ‐ ‐
Facilities ‐ ‐ 1,391,155 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 50,042 ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ 105,354 ‐ ‐ ‐ ‐ ‐
Geographical information systems ‐ 65,616 ‐ ‐ ‐ ‐ ‐
Interest and other misc 6,052 2,717 627 220 7,908 9,647 7,365
Internal service fund misc:
Vehicle / equipment capital recovery 319,848 314,247 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 521,373 ‐ ‐
Worker's compensation / unemployment ‐ ‐ ‐ ‐ 448,846 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 3,687,912 736,310
Other misc 153 126 2,591 126 199 237,852 ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets ‐ ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 23,233 50 17
TOTAL REVENUES 1,068,572 1,385,819 1,396,287 329,821 1,001,559 3,935,461 787,329
EXPENSES:
Communications 152,825
Equipment rental 833,084
Facilities 1,141,865
Healthcare 3,602,853
Information technology 1,014,486
Print and mail 137,433
Retiree healthcare 439,284
Risk management
Risk management 899,890
Unemployment 84,107
Worker's compensation 342,302
TOTAL EXPENSES 833,084 1,014,486 1,141,865 290,258 1,326,299 3,602,853 439,284
AMOUNT AVAILABLE FOR CAPITAL 235,488 371,333 254,422 39,563 (324,740) 332,608 348,045
CAPITAL PROJECTS 603,801 404,046 49,860 ‐ ‐ ‐ ‐
TRANSFERS IN ‐ ‐ 37,782 ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE (368,313) (32,713) 242,344 39,563 (324,740) 332,608 348,045
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, April 30, 2012 4,406,063 2,149,030 542,582 180,683 6,295,697 7,466,604 5,827,444
Page 11 of 36
Monthly Financial Report April 2012
FUND BALANCE
Page 13 shows the ending fund balance as of April 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 April, the City has $12 million reported in the combined general governmental fund balance of the current
year’s operating budget, which is approximately 12% of budgeted operating expenditures. This is an increase of $937k from
the year’s beginning balance. April’s ending fund balance is over the anticipated General Governmental Fund Balance of
$9.2 million by $2.8 million or 30.5%. Although the ending fund balance is above projections, it is consistent with the prior
years’ trends since the City will receipt the first half of 2012 property taxes in April/May and 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 April 2012
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through April 30, 2012
Funds
Balance
01/01/2012
Budgeted
Revenue
Revenue
04/30/12
Total Funds
Available
Budgeted
Expenditure
Expenditure
04/30/12
Ending
Balance
GENERAL GOVERNMENT FUNDS:11,057,551 101,953,223 32,180,045 43,237,596 102,353,876 31,242,984 11,994,612
000 General 6,934,747 74,313,431 23,456,553 30,391,300 75,353,069 24,471,160 5,920,139
001 Community Services 1,413,050 11,302,259 3,571,717 4,984,767 11,126,074 3,037,773 1,946,994
003 Street 1,264,341 8,953,479 2,882,531 4,146,872 8,492,917 2,646,109 1,500,763
004 Community Dev Block Grant 8,339 305,961 73,144 81,483 303,281 92,695 (11,212)
005 Museum 52,620 216,220 216,370 268,990 213,533 71,901 197,088
006 Library 48,603 230,000 230,041 278,644 230,000 58,604 220,040
009 Farmers Market 87,437 75,500 22,606 110,043 78,629 21,145 88,899
010 Fire Memorial 1,953 ‐ ‐ 1,953 ‐ ‐ 1,953
011 Fire Health & Wellness 36,858 25,000 8,588 45,446 25,000 1,571 43,876
031 Pa rk Memorial 177,758 ‐ 228 177,986 ‐ ‐ 177,986
201 Ltd GO Bonds Gen Govt Debt 591,257 1,982,075 573,804 1,165,061 1,982,075 ‐ 1,165,061
215 Gen Govt Misc Debt Service 440,588 4,549,298 1,144,464 1,585,052 4,549,298 842,026 743,025
SPECIAL REVENUE FUNDS:
102 Arterial Street 158,974 600,000 188,488 347,462 600,000 ‐ 347,462
108 Leased City Properties 488,500 844,049 189,867 678,367 749,232 188,557 489,810
110 Hotel Motel 243,556 265,000 126,489 370,045 442,050 265,169 104,876
118 Reserve for Paths & Trails 3,314 ‐ 4 3,318 ‐ ‐ 3,318
125 1% For Art 121,686 32,813 156 121,842 50,000 ‐ 121,842
127 Cable Communication 185,968 85,000 66,318 252,286 235,674 4,137 248,149
135 Springbrook Wetlands Bank 663,556 ‐ 852 664,408 ‐ ‐ 664,408
DEBT SERVICE FUNDS:
219 1989 Unlimited GO Bonds ‐ ‐ ‐ ‐ ‐ ‐ ‐
CAPITAL PROJECT FUNDS (CIP):
303 Community Dev Mitigation 1,475,050 60,000 7,735 1,482,785 400,000 ‐ 1,482,785
304 Fire Mitigation 1,492,674 100,000 9,814 1,502,488 536,926 ‐ 1,502,488
305 Transportation Mitigation 657,187 100,000 11,869 669,056 450,000 ‐ 669,056
316 Municipal Facilities CIP 3,745,546 2,928,009 404,391 4,149,937 6,337,982 674,551 3,475,386
317 Transportation CIP 3,422,219 26,755,575 1,358,907 4,781,126 30,135,972 2,750,295 2,030,831
318 So Lake WA Infrastructure Proj 52,792 ‐ 67 52,859 52,024 441 52,418
326 Housing Opportunity 130,546 ‐ 1,759 132,305 125,000 ‐ 132,305
336 New Library Development 19,196,447 ‐ 23,038 19,219,485 19,196,447 185,466 19,034,019
ENTERPRISE FUNDS:
402 Airport 494,718 1,299,150 617,954 1,112,672 1,307,780 434,915 677,757
403 Solid Waste Utility 1,734,734 15,021,811 5,198,883 6,933,617 15,014,481 4,338,882 2,594,735
404 Golf Course 379,997 2,483,545 470,377 850,374 2,492,204 607,865 242,509
422 Airport Capital 1,589,992 4,149,219 291,239 1,881,231 5,639,211 166,581 1,714,650
424 Golf Course Capital 235,491 50,000 33,651 269,142 145,000 14,761 254,381
INTERNAL SERVICE FUNDS:
501 Equipment Repair/Replacement 4,774,376 3,190,893 1,068,572 5,842,948 3,979,127 1,436,886 4,406,062
502 Insurance 6,620,437 3,187,593 1,001,558 7,621,995 3,134,079 1,326,300 6,295,695
503 Information Services 2,181,743 4,126,173 1,385,818 3,567,561 5,959,686 1,418,532 2,149,029
504 Facilities 300,238 4,334,952 1,434,070 1,734,308 4,389,399 1,191,725 542,583
505 Communications 141,120 974,307 329,822 470,942 991,015 290,258 180,684
512 Insurance, Healthcare 7,133,996 12,014,224 3,935,461 11,069,457 11,996,739 3,602,853 7,466,604
522 Insurance, Leoff1 Retirees HC 5,479,399 2,235,684 787,330 6,266,729 2,262,573 439,284 5,827,445
FIDUCIARY FUNDS:
611 Firemen's Pension 4,377,696 300,000 2,328 4,380,024 550,475 88,186 4,291,838
Funds
Balance
01/01/2012
Budgeted
Revenue
Revenue
04/30/12
Total Funds
Available
Budgeted
Expenditure
Expenditure
04/30/12
Ending
Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 14,140,266 49,406,145 14,906,816 29,047,082 52,104,452 11,361,165 17,685,917
405 Water Utility 3,993,415 11,106,460 3,655,373 7,648,788 10,689,883 2,437,875 5,210,913
406 Waste Water Utility 685,178 5,888,574 2,068,468 2,753,646 5,130,805 1,317,469 1,436,177
407 Surface Water Utility 1,625,915 5,637,563 2,210,050 3,835,965 5,479,377 1,355,135 2,480,830
416 King County Metro 1,077,805 13,209,387 4,383,625 5,461,430 13,209,387 4,312,165 1,149,265
425 Water Utility Construction 3,633,246 5,369,215 694,750 4,327,996 7,085,000 368,020 3,959,976
426 Waste Water Construction 524,178 3,310,000 879,777 1,403,955 3,710,000 545,069 858,886
427 Surface Water Construction 2,584,684 4,884,946 1,014,753 3,599,437 6,800,000 1,025,432 2,574,005
461 Waterworks Bond Reserve ‐ ‐ ‐ ‐ ‐ ‐ ‐
471 Waterworks Rate Stabilization 15,845 ‐ 20 15,865 ‐ ‐ 15,865
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
2011 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
June
July
August
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 ‐ 2011 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,919,251 32,180,045 7.56%
May 44,905,468
Jun 49,752,021
Jul 55,739,238
Aug 60,906,216
Sep 67,121,931
Oct 80,526,499
Nov 95,374,419
Dec 101,953,223
Percent of budget 31.56%
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
Jun 17,231,849
Jul 17,337,932
Aug 17,422,058
Sep 17,843,166
Oct 24,750,333
Nov 32,724,934
Dec 32,896,746
Percent of budget 33.82%
$‐
$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 ‐ 2011 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
Jun 9,969,656
Jul 11,554,021
Aug 13,258,722
Sep 14,907,971
Oct 16,615,185
Nov 18,322,808
Dec 19,965,647
Percent of budget 33.24%
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
Jun 8,522,519
Jul 9,762,636
Aug 10,979,816
Sep 12,205,670
Oct 13,458,742
Nov 14,740,056
Dec 16,155,203
Percent of budget 35.93%
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 ‐ 2011 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
Jun 1,025,529
Jul 1,257,216
Aug 1,551,253
Sep 1,768,424
Oct 2,019,748
Nov 2,211,675
Dec 2,403,331
Percent of budget 35.93%
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 4,666,860
Jun 5,300,839
Jul 5,870,943
Aug 6,443,189
Sep 6,901,146
Oct 8,264,080
Nov 10,682,566
Dec 12,235,154
Percent of budget 20.37%
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 ‐ 2011 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
Jun 3,207,813
Jul 3,864,078
Aug 4,567,070
Sep 5,140,570
Oct 5,652,987
Nov 6,159,124
Dec 6,691,060
Percent of budget 28.19%
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
Jun 1,551,967
Jul 1,801,437
Aug 1,991,172
Sep 2,177,018
Oct 2,562,900
Nov 2,862,140
Dec 3,214,156
Percent of budget 29.49%
$‐
$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 ‐ 2011 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,826,182 1,919,894 5.13%
May 2,221,338
Jun 2,412,957
Jul 3,643,161
Aug 3,945,386
Sep 4,229,695
Oct 5,134,578
Nov 5,535,483
Dec 6,050,976
Percent of budget 31.73%
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
Jun 510,515
Jul 629,398
Aug 729,072
Sep 805,324
Oct 867,135
Nov 934,797
Dec 1,099,199
Percent of budget 44.81%
$‐
$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 ‐ 2011 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
Jun 18,378
Jul 18,415
Aug 18,477
Sep 1,142,946
Oct 1,200,811
Nov 1,200,836
Dec 1,241,752
Percent of budget 0.71%
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
Jun 879,012
Jul 993,789
Aug 1,149,532
Sep 1,350,432
Oct 1,535,639
Nov 1,863,587
Dec 2,025,000
Percent of budget 34.08%
$‐
$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 ‐ 2011 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 41,859,756
Jun 50,333,706
Jul 59,118,853
Aug 67,850,124
Sep 76,521,326
Oct 84,769,735
Nov 93,132,969
Dec 102,353,876
Percent of budget expended 30.52%
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
Jun 142,332
Jul 166,209
Aug 189,913
Sep 213,507
Oct 235,771
Nov 259,647
Dec 284,087
Percent of budget expended 32.38%
$‐
$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 ‐ 2011 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
Jun 714,061
Jul 838,503
Aug 949,052
Sep 1,083,306
Oct 1,204,110
Nov 1,318,583
Dec 1,468,694
Percent of budget expended 29.10%
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
Jun 36,506
Jul 42,088
Aug 47,349
Sep 53,136
Oct 58,229
Nov 65,292
Dec 71,025
Percent of budget expended 29.90%
$‐
$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 ‐ 2011 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
Jun 838,962
Jul 978,014
Aug 1,116,943
Sep 1,255,965
Oct 1,386,265
Nov 1,523,461
Dec 1,668,686
Percent of budget expended 33.77%
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
Jun 1,069,741
Jul 1,252,611
Aug 1,433,492
Sep 1,617,436
Oct 1,784,453
Nov 1,963,784
Dec 2,155,819
Percent of budget expended 31.28%
$‐
$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 ‐ 2011 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
Jun 478,179
Jul 557,987
Aug 637,894
Sep 717,523
Oct 794,989
Nov 873,950
Dec 952,912
Percent of budget expended 33.81%
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
Jun 1,747,643
Jul 2,032,811
Aug 2,290,533
Sep 2,593,698
Oct 2,863,779
Nov 3,141,884
Dec 3,434,929
Percent of budget expended 27.93%
$‐
$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 ‐ 2011 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
Jun 366,115
Jul 430,836
Aug 487,814
Sep 561,518
Oct 620,200
Nov 686,272
Dec 753,765
Percent of budget expended 27.79%
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
Jun 719,930
Jul 836,707
Aug 990,965
Sep 1,160,034
Oct 1,277,610
Nov 1,377,062
Dec 1,516,719
Percent of budget expended 32.53%
$‐
$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 ‐ 2011 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
Jun 922,974
Jul 1,070,091
Aug 1,235,336
Sep 1,414,702
Oct 1,554,314
Nov 1,696,851
Dec 2,161,836
Percent of budget expended 29.40%
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
Jun 548,623
Jul 613,605
Aug 677,277
Sep 742,449
Oct 863,525
Nov 930,561
Dec 1,002,105
Percent of budget expended 22.59%
$‐
$0.20
$0.40
$0.60
$0.80
Budget
Actual
Last Year
Page 26 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2011 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
Jun 458,275
Jul 539,353
Aug 617,162
Sep 695,139
Oct 771,451
Nov 853,247
Dec 946,956
Percent of budget expended 31.66%
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 12,668,569
Jun 15,284,797
Jul 17,916,322
Aug 20,406,918
Sep 22,942,085
Oct 25,357,122
Nov 27,888,227
Dec 30,555,217
Percent of budget expended 31.03%
$‐
$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 ‐ 2011 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
Jun 12,235,348
Jul 14,209,782
Aug 16,254,213
Sep 18,244,725
Oct 20,112,582
Nov 22,108,827
Dec 24,099,606
Percent of budget expended 35.00%
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
Jun 208,186
Jul 243,168
Aug 278,693
Sep 315,161
Oct 349,074
Nov 384,584
Dec 421,043
Percent of budget expended 34.15%
$‐
$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 ‐ 2011 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
Jun 1,853,057
Jul 2,222,702
Aug 2,589,857
Sep 2,973,223
Oct 3,348,621
Nov 3,709,562
Dec 4,045,762
Percent of budget expended 29.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
Jun 302,748
Jul 372,183
Aug 433,495
Sep 494,583
Oct 561,935
Nov 625,369
Dec 685,122
Percent of budget expended 24.74%
$‐
$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 ‐ 2011 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
Jun 2,245,447
Jul 2,856,921
Aug 3,525,903
Sep 4,078,172
Oct 4,458,478
Nov 4,852,563
Dec 5,276,859
Percent of budget expended 26.10%
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
Jun 539,264
Jul 716,044
Aug 792,431
Sep 859,537
Oct 1,005,515
Nov 1,095,976
Dec 1,277,487
Percent of budget expended 32.08%
$‐
$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 ‐ 2011 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
Jun 293,808
Jul 363,607
Aug 429,239
Sep 484,127
Oct 529,989
Nov 583,317
Dec 697,288
Percent of budget expended 24.12%
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 95,833
Jun 115,000
Jul 134,167
Aug 153,333
Sep 172,500
Oct 191,667
Nov 210,833
Dec 230,000
Percent of budget expended 25.48%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
Budget
Actual
Last Year
Page 31 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2011 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
Jun 106,029
Jul 124,048
Aug 141,990
Sep 160,056
Oct 177,858
Nov 195,702
Dec 213,533
Percent of budget expended 33.67%
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
Jun 232,725
Jul 271,807
Aug 311,339
Sep 350,878
Oct 388,230
Nov 426,925
Dec 465,889
Percent of budget expended 34.12%
$‐
$0.20
$0.40
$0.60
Budget
Actual
Last Year
Page 32 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2011 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
Jun 1,821,797
Jul 2,128,792
Aug 2,447,569
Sep 2,764,011
Oct 3,088,569
Nov 3,403,987
Dec 3,728,945
Percent of budget expended 32.65%
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
Jun 2,314,346
Jul 2,673,048
Aug 3,094,333
Sep 3,467,142
Oct 3,889,049
Nov 4,270,515
Dec 4,763,972
Percent of budget expended 29.99%
$‐
$1
$2
$3
$4
$5
$6
Budget
Actual
Last Year
Page 33 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2011 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 2,721,405
Jun 3,265,687
Jul 3,809,968
Aug 4,354,249
Sep 4,898,530
Oct 5,442,811
Nov 5,987,092
Dec 6,531,373
Percent of budget expended 12.89%
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,226,770
Jun 1,472,124
Jul 1,717,478
Aug 1,962,832
Sep 2,208,186
Oct 2,453,540
Nov 2,698,894
Dec 2,944,248
Percent of budget expended 39.97%
$‐
$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 ‐ 2011 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
Jun 31,272,421
Jul 36,738,457
Aug 41,485,486
Sep 47,210,495
Oct 52,849,867
Nov 58,237,289
Dec 67,118,933
Percent of budget expended 15.79%
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
Jun 2,896,131
Jul 3,375,334
Aug 4,206,194
Sep 4,852,959
Oct 5,709,245
Nov 6,373,308
Dec 6,946,991
Percent of budget expended 8.66%
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 ‐ 2011 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
Jun 661,811
Jul 758,375
Aug 865,936
Sep 957,161
Oct 1,041,874
Nov 1,206,844
Dec 2,637,204
Percent of budget expended 23.61%
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