HomeMy WebLinkAbout201203, March.pdfFINANCE AND
INFORMATION TECHNOLOGY
M E M O R A N D U M
DATE: May 1, 2012
TO: Rich Zwicker, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: March 2012 Financial Status Report
At the end of March, general governmental revenues show $6k over budget. Revenues sources
that are higher than expected are: gambling excise taxes ($45k); real estate excise taxes ($76k);
building permits & development service fees ($144k); state shared revenues ($31k); rents,
leases, and concessions ($54k); and other miscellaneous (61k). On the down side, the revenue
sources that are underperforming the year to date budget are: property taxes ($133k below);
franchise fees ($27k below); utility taxes ($63k below); culture and recreation fees ($45k
below); interfund/inter‐departmental services ($124k below); and fines/forfeitures ($77k
below).
General government expenditures showed favorable variance of $398k or 1.8%. See page 9 of
report for further expenditure savings/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$ 9,338,707$ 9,338,707$ 11,057,551$ 1,718,844$ 18.4%
OPERATING REVENUES
Property Tax 31,497,128 1,037,146 32,357,894 1,586,980 32,896,746 1,247,748 1,115,068 (132,680) ‐10.6%
Sales Tax 17,198,220 4,307,540 17,729,731 4,621,165 17,864,000 4,548,153 4,555,081 6,929 0.2%
Sales Tax ‐ Annexation Credit 2,025,660 511,021 2,033,954 515,376 2,101,647 532,528 548,776 16,248 3.1%
Criminal Justice Sales Tax 1,620,479 413,523 1,809,757 433,145 1,867,145 446,881 469,776 22,895 5.1%
Natural Gas Use Tax 228,514 73,944 249,407 81,939 270,394 88,834 135,319 46,485 52.3%
Admission Tax 291,399 75,236 308,200 70,881 350,000 80,495 74,353 (6,141) ‐7.6%
Franchise Fees 1,222,444 320,478 1,234,448 305,646 1,323,000 327,571 300,392 (27,179) ‐8.3%
Electricity Tax 5,036,907 1,381,772 5,166,711 1,471,764 5,283,280 1,504,969 1,522,488 17,519 1.2%
Natural Ga s Utility Tax 1,577,756 599,950 1,848,806 743,650 1,950,000 784,353 698,786 (85,568) ‐10.9%
Transfer Station 269,912 62,164 297,474 62,236 248,762 52,045 66,603 14,559 28.0%
TV Cable 1,296,744 327,983 1,385,275 313,748 1,427,679 323,352 315,052 (8,300) ‐2.6%
Telephone 1,038,009 269,528 966,827 251,762 1,000,000 260,400 236,098 (24,302) ‐9.3%
Cellular Phone 2,206,637 553,363 2,054,183 534,865 2,309,360 601,308 563,415 (37,893) ‐6.3%
City Utilities 2,853,884 664,892 3,516,179 832,175 3,665,728 867,568 882,471 14,903 1.7%
Leasehold Excise Tax 138,830 35,999 162,593 34,846 145,000 31,075 26,202 (4,873) ‐15.7%
Gambling Excise Tax 1,546,386 336,398 1,671,414 389,297 1,600,000 372,663 418,076 45,412 12.2%
Real Estate Excise Tax 2,464,489 487,709 2,074,059 403,288 2,025,000 393,580 495,352 101,772 25.9%
Less: Municipal Facilities CIP REET (400,000) (81,027) (400,000) (72,016) (400,000) (72,016) (97,847) (25,832) 35.9%
EMS Levy 1,161,114 ‐ 868,873 ‐ 1,007,976 ‐ ‐ ‐ 0.0%
Business License Fees 431,782 117,082 442,451 111,073 469,817 117,943 117,854 (89) ‐0.1%
Other Licenses and Permits 262,629 62,268 232,534 43,772 213,305 40,152 66,324 26,172 65.2%
Building Permits & Development Svc Fees 2,437,270 659,298 2,772,779 540,074 2,466,063 476,899 621,236 144,337 30.3%
Intergovt'l (Grants, State Shared, etc) 4,426,676 1,103,708 4,737,323 936,670 4,381,262 759,316 767,775 8,459 1.1%
Fire District 25 and 40 Contracts 5,252,877 19,525 6,110,668 278,286 6,008,694 152,200 152,200 ‐ 0.0%
Public Safety 482,343 100,750 484,985 90,072 430,635 79,978 85,430 5,452 6.8%
Culture and Recreation 1,424,932 226,688 1,493,540 243,967 1,660,863 271,299 226,174 (45,125) ‐16.6%
Interfund/Interdept‐Services 3,190,908 766,090 3,070,506 724,768 3,414,200 867,214 743,213 (124,001) ‐14.3%
Fines and Forfeits 1,291,817 205,000 1,163,602 218,547 1,088,750 205,348 181,611 (23,737) ‐11.6%
Photo Enforcement 1,925,159 495,096 1,897,782 527,825 1,944,713 540,877 475,558 (65,319) ‐12.1%
Seizure Funds ‐ Federal/State/Local 221,046 46,627 83,220 ‐ 180,693 ‐ 11,738 11,738 100.0%
Interests and Other Earnings 183,511 37,996 107,183 17,599 125,400 20,590 20,892 302 1.5%
Rents, Leases, and Concessions 727,338 241,192 744,834 219,861 701,464 207,059 260,753 53,695 25.9%
Contributions and Donations 133,756 29,179 196,586 43,874 105,000 23,434 37,447 14,013 59.8%
Other Miscellaneous 434,286 101,812 529,147 74,534 427,358 58,789 119,752 60,963 103.7%
Other Financing Sources (Transfer‐In, etc) 653,595 138 1,073,507 3,175 1,037,752 291 5,494 5,203 1788.1%
Total Operating Revenues 96,754,435 15,590,071 100,476,431 16,654,842 101,591,685 16,212,898 16,218,914 6,016 0.0%
OPERATING EXPENDITURES
Legislative 259,345 65,280 271,236 67,521 284,087 71,106 68,811 2,295 3.2%
Executive 1,578,526 407,609 1,566,906 346,789 1,468,694 352,251 312,540 39,711 11.3%
Hearing Examiner 174,447 43,412 59,878 23,616 71,025 20,317 16,343 3,974 19.6%
City Attorney 1,565,597 400,465 1,596,609 395,280 1,668,686 419,912 419,219 693 0.2%
Court Services 2,007,599 499,117 2,084,170 490,833 2,147,819 519,637 504,905 14,732 2.8%
Community and Eco Dvlpmnt Admin 579,396 146,045 929,814 232,560 952,912 239,050 239,249 (198) ‐0.1%
Development Services 2,946,413 768,673 2,810,736 716,400 3,181,944 820,791 715,648 105,144 12.8%
Economic Development 1,322,004 305,673 724,970 179,805 735,088 174,340 164,809 9,530 5.5%
Planning 1,774,508 383,792 1,447,781 348,727 1,516,719 344,794 377,067 (32,273) ‐9.4%
Finance 2,214,458 443,082 2,134,667 467,036 1,969,836 412,217 476,115 (63,897) ‐15.5%
City Clerk 789,209 146,137 736,880 154,386 897,889 176,816 170,116 6,700 3.8%
Human Resources 861,221 213,772 888,252 221,683 946,956 235,703 227,236 8,467 3.6%
Police 23,946,386 6,053,699 24,737,346 6,305,557 24,746,366 6,282,318 6,012,336 269,982 4.3%
Jail Services 3,539,035 623,568 6,206,735 769,664 4,740,599 294,683 294,683 ‐ 0.0%
Fire 21,554,792 5,943,458 22,511,597 5,900,678 24,056,171 6,465,803 6,539,657 (73,854) ‐1.1%
Community Services Admin 1 1,063,011 263,482 416,284 102,208 421,043 104,084 108,727 (4,643) ‐4.5%
Parks 3,421,424 732,269 3,829,676 799,401 4,034,496 852,218 862,246 (10,028) ‐1.2%
Parks Planning & Natural Resources 448,574 80,116 551,423 109,668 595,868 113,087 124,284 (11,197) ‐9.9%
Recreation 4,433,420 886,597 4,974,002 1,058,705 5,263,801 1,088,468 999,673 88,795 8.2%
Human Services 1,326,778 207,504 1,247,294 177,533 1,250,561 187,063 266,033 (78,971) ‐42.2%
Neighborhoods, Resources, & Events 331,222 64,287 610,545 110,686 692,698 128,698 129,143 (445) ‐0.3%
Library 2,289,692 500,663 2,030,000 7,619 230,000 7,500 7,500 ‐ 0.0%
Museum 191,090 46,726 210,620 51,915 213,533 52,434 53,787 (1,353) ‐2.6%
Public Works Admin 1 514,858 129,351 452,538 111,889 465,889 116,179 119,164 (2,985) ‐2.6%
Street Maintenance 3,412,892 816,882 3,534,025 894,017 3,728,945 918,371 935,153 (16,782) ‐1.8%
Transportation 5,215,309 1,261,456 4,509,066 1,101,787 4,711,542 1,145,011 1,000,881 144,130 12.6%
Debt Service 4,707,100 126,390 4,822,566 390,380 6,531,373 250,317 250,317 ‐ 0.0%
Non‐Departmental and Other 4,834,296 1,136,033 4,930,383 1,784,740 2,944,248 886,227 886,227 ‐ 0.0%
Total Operating Expenditures 97,302,601 22,695,538 100,825,999 23,321,083 100,468,787 22,679,391 22,281,867 397,524 1.8%
Total Ending Fund Balance 11,407,119$ 4,849,818$ 11,057,551$ 4,740,878$ 10,461,605$ 2,872,215$ 4,994,598$ 2,122,383 73.9%
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 March 2012
Page 1 of 37
Monthly Financial Report March 2012
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through March 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
March’s collection is $880k, making
the total year‐to‐date collection $1.1
million or 3% of the total budget. In
comparison to the previous year,
the City collected $472k or 30% less.
Compared to the budget, the City is
below projections by $133k or 11%.
2012’s monthly budgets are based
on 2009 through 2011 collections.
The variance from the prior year is
due to a portion ($129k) of 2010’s
collection being receipted in January
2011. Taking this into consideration,
the City is $342k or 23% behind
2011.
Sales Tax
March 2012 sales tax receipts totalled
$1.3 million. Compared to the same
month last year, it is $5k more.
Compared to the projected current
month’s budget, it is $68k or 5%
below. The year‐to‐date collection of
$4.6 million is $66k or 1% less than the
prior year but is $7k more than
budgeted.
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 505,501$ 255,343$ 149,112$ (356,390)$ ‐71% (106,231)$ ‐42%
Feb 336,193 316,911 85,577 (250,616) ‐75% (231,334) ‐73%
Mar 745,285 675,495 880,380 135,094 18% 204,885 30%
Apr 7,618,492 7,776,464
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 1,586,980$ 1,247,748$ 1,115,068$ (471,912)$ ‐30% (132,680)$ ‐11%
Annual Total 32,357,894$ 32,896,746$
Property Tax Revenues
Year to Date through March
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 ‐
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 4,621,165$ 4,548,153$ 4,555,081$ (66,083)$ ‐1% 6,929$ 0%
Annual Total 17,729,731$ 17,864,000$
2012 vs. Budget2012 vs. 2011
Month
Year to Date through March
Local Retail Sales Tax Revenues
Page 2 of 37
Monthly Financial Report March 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 360,477$ 356,535$ 398,607$ 38,129$ 11%$ 42,072 12%
Auto Sales 788,059 848,617 800,860 12,801 2% (47,757)‐6%
General Retail 1,603,505 1,682,068 1,688,543 85,038 5% 6,475 0%
Manufacturing 423,520 199,022 251,433 (172,087) ‐41% 52,411 26%
Wholesale 295,717 311,059 283,392 (12,325) ‐4% (27,667)‐9%
Service 1,023,389 1,051,442 1,046,461 23,072 2% (4,981) 0%
Other 126,498 99,410 85,786 (40,712) ‐32% (13,624)‐14%
Total 4,621,165$ 4,548,153$ 4,555,081$ (66,083)$ ‐1%6,929$ 0%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility tax
March utility tax revenues are
$1.4 million, which is $42k or 3%
lower than the same month last
year and is also behind the budget
by $108k or 7%. The year‐to‐date
collection is $4.4 million, which is
$128k or 3% higher than the prior
year but is $63k or 1% lower than
the budget.
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,471,764$ 1,504,969$ 1,522,488$ 50,724$ 3%$ 17,519 1%
Natural Gas 825,589 873,188 834,105 8,516 1% (39,083)‐4%
Cell 534,865 601,308 563,415 28,550 5% (37,893)‐6%
Phone 251,762 260,400 236,098 (15,664) ‐6% (24,302)‐9%
Cable 313,748 323,352 315,052 1,304 0% (8,300)‐3%
Transfer Station 62,236 52,045 66,603 4,367 7% 14,559 28%
City Utilities 832,175 867,568 882,471 50,296 6% 14,903 2%
YTD Total 4,292,138$ 4,482,830$ 4,420,232$ 128,093$ 3%(62,598)$ ‐1%
Annual Total 15,484,862$ 16,155,203$
YTD as % of 28% 28%
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
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 4,292,138$ 4,482,830$ 4,420,232$ 128,093$ 3% (62,598)$ ‐1%
Annual Total 15,484,862$ 16,155,203$
2012 vs. Budget2012 vs. 2011
Year to Date through March
Utility Tax Revenues
Month
Page 3 of 37
Monthly Financial Report March 2012
Other Taxes
Real Estate Excise Tax
The City collected $204k in Real Estate
Excise Tax revenues (REET) in March.
This is $62k or 44% ahead of the same
month last year and $65k or 47% above
the current month’s budget. The year‐
to‐date collection is $495k, which is
$92k or 23% more than the prior year
and is also $102k or 26% above the
budget.
Gambling Tax
March’s Gambling Tax collections
total $98k. Year‐to‐date total of
$418k is $29k or 7% above the
year before and is also $45k or
12% 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).
Pull tabs overall had a 7% increase, bingo increased by 46%, and card‐rooms are seeing 6% higher in activities when
compared to the prior year.
Franchise Fees
Franchise Fees are due quarterly
and the year‐to‐date revenue
collections are $300k or 23% of
the budget. This is $5k or 2%
lower than 2011 and is also $27k
or 8% below the projected year‐
to‐date budget.
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
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 403,288$ 393,580$ 495,352$ 92,064$ 23% 101,772$ 26%
Annual Total 2,074,059$ 2,025,000$
Month
2012 vs. Budget2012 vs. 2011
Real Estate Excise Tax Revenues
Year to Date through March
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 ‐
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 389,297$ 372,663$ 418,076$ 28,779$ 7% 45,412$ 12%
Annual Total 1,671,414$ 1,600,000$
2012 vs. 2011 2012 vs. Budget
Gambling Tax Revenue
Month
Year to Date through March
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 305,646$ 327,571$ 300,392$ (5,254)$ ‐2% (27,179)$ ‐8%
Apr 294,560 315,690 ‐
Jul 294,438 315,560 ‐
Oct 292,692 313,688 ‐
Dec 47,111 50,491 ‐
YTD Total 305,646$ 327,571$ 300,392$ (5,254)$ ‐2% (27,179)$ ‐8%
Annual Total 1,234,448$ 1,323,000$
Franchise Fees Revenue
Year to Date through March
Month
2012 vs. 2011 2012 vs. Budget
Page 4 of 37
Monthly Financial Report March 2012
Admission Tax
Admission Tax returns are due
quarterly in January, April, July,
and October each year. January
2012 collections represent
activities conducted during the 4th
quarter of 2011.
The report shows an increase of
$3k or 5% from the year before
but is $6k or 8% less than
anticipated.
Licenses and Permits
Building Permits and Development Service Fees
Building Permits and Development
Service Fee revenues totalled $263k in
March. The year‐to‐date development
fees revenue of $621k is $81k or 15%
more than 2011 and is also $144k or
30% higher than budget. The higher
than expected fees are due to collecting
more in general building permits,
electrical permits and plan check fees.
Business Licenses
Business Licenses totalled $5k for March,
which is $1k or 29% above the same month
last year and is also $880 or 22% above the
current month’s budget. The year‐to‐date
Business Licenses revenue is ahead of the
prior year by $7k 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 ‐
May 407 462 ‐
Jul 86,024 97,691 ‐
Aug 1,194 1,356 ‐
Oct 86,112 97,791 ‐
YTD Total 70,881$ 80,495$ 74,353$ 3,472$ 5% (6,141)$ ‐8%
Annual Total 308,200$ 350,000$
Month
2012 vs. 2011 2012 vs. Budget
Admission Tax Revenue
Year to Date through Ma rch
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 ‐
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 111,073$ 117,943$ 117,854$ 6,781$ 6% (89)$ 0%
Annual Total 442,451$ 469,817$
Business Licenses
Month
2012 vs. 2011
Year to Date through March
2012 vs. Budget
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
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 540,074$ 476,899$ 621,236$ 81,162$ 15% 144,337$ 30%
Annual Total 2,772,779$ 2,466,063$
Building Permits and Development Service Fees
Year to Date through March
2012 vs. Budget2012 vs. 2011
Month
Page 5 of 37
Monthly Financial Report March 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 89% of the total revenues in this category. The year‐to‐date total Intergovernmental revenue is $1.4 million or
11% of the budget.
State Shared Revenues
State Shared Revenue
collections totalled $1.1 million
since the start of 2012.
Compared to the prior year,
State Shared Revenues are
below by $10k or 1%.
Compared to the projected
budget, the City is collecting
$31k or 3% more. The higher
than expected collections are
due to Criminal Justice’s High
Crime not being budgeted for.
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 74% of the total revenue in this category. The year‐to‐date total charges for services are $1.3 million or 20% of
the budget. This is 7% below budget projections. The following sections provide detail information for Public Safety,
Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totalled $85k since the
start of the year. These services include private
security, adult probation services, and
housing/monitoring of prisoners. Compared to
the prior year, the City is collecting $5k or 5%
less. Compared to the budget, the City is
collecting $5k or 7% more than anticipated
revenue.
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 ‐
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 90,072$ 79,978$ 85,430$ (4,642)$ ‐5% 5,452$ 7%
Annual Total 484,985$ 430,635$
Month
2012 vs. 2011
Year to Date through March
Public Safety Services
2012 vs. Budget
Intergovernmental 2011 2012 Bgt YTD Act Change 2012/2011 2012 Act vs Bgt
Fire District #25 ‐$ ‐$ ‐$ ‐$ N/A $ ‐ N/A
Fire District #40 278,286 152,200 152,200 (126,086) ‐45%‐ 0%
State Shared Revenue 1,091,168 1,050,113 1,081,467 (9,700) ‐1% 31,355 3%
Federal Grants 167,370 77,003 77,003 (90,367) ‐54%‐ 0%
State Grants 48,791 30,646 30,646 (18,145) ‐37%‐ 0%
Other Grants/Intgovt 41,933 48,434 48,434 6,501 16%‐ 0%
ARRA Grants 125,916 ‐ ‐ (125,916) 0%‐ N/A
Total Rev YTD 1,753,464$ 1,358,397$ 1,389,752$ (363,712)$ ‐21%31,355$ 2%
Total Rev Annual 12,657,748$ 12,257,101$
YTD % 14% 11% 11%
Note: Includes CJ Sales Tax.
2011 2012 2012
Actual Budget Actual $ % $ %
Crim Just Sales Tax 433,145$ 446,881$ 469,776$ 36,630$ 8% 22,895$ 5%
Judicial Contribution 11,234 6,000 5,658 (5,576) ‐50% (342) ‐6%
Crim Just ‐ High Crime 47,179 ‐ 46,747 (432) ‐1% 46,747 100%
Crim Just ‐ Pop 4,821 ‐ 5,086 265 5% 5,086 100%
Crim Just ‐ Spec Prog 18,203 16,481 19,194 991 5% 2,713 16%
State DUI 3,924 3,125 4,438 514 13% 1,312 42%
Liquor Profits 168,155 172,438 123,076 (45,079) ‐27% (49,362) ‐29%
Liquor Excise Tax 104,651 106,927 109,021 4,369 4% 2,094 2%
Fuel Tax 299,855 298,261 298,472 (1,383) 0% 211 0%
YTD Total 1,091,168$ 1,050,113$ 1,081,467$ (9,700)$ ‐1% 31,355$ 3%
Annual Total 4,495,551$ 4,437,913$
2012 vs. Budget
State Shared Revenues
2012 vs. 2011
Revenue
Year to Date through March
Page 6 of 37
Monthly Financial Report March 2012
Recreation
Recreation revenues totalled $105k for
the current month. Compared to the
same month the prior year, the City
collected $5k or 5% more. Compared to
the projected monthly budget, the City
collected $6k or 5% less. The year‐to‐
date collection of $226k is $18k or 7%
less than the prior year and is also $45k
or 17% less than the budget.
Interfund Services
The year‐to‐date collections for Interfund
Services revenues are $743k. Compared
to the prior year, the revenues are under
by $37k or 5%. Compared to the
projected budget, the revenues are
below by $124k or 14%. 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.
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 $664k. This is $76k or 10% lower than
a year ago and also $82k or 11% below
the budget.
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 258,617$ 287,565$ 237,384$ (21,232)$ ‐8% (50,181)$ ‐17%
Feb 251,772 279,954 234,758 (17,014) ‐7% (45,196) ‐16%
Mar 269,526 299,696 271,071 1,545 1% (28,625) ‐10%
Apr 249,538 277,470 ‐
May 255,425 284,016 ‐
Jun 234,878 261,169 ‐
Jul 238,262 264,932 ‐
Aug 229,627 255,330 ‐
Sep 237,006 263,535 ‐
Oct 270,340 300,600 ‐
Nov 266,859 296,730 ‐
Dec 308,654 343,203 ‐
YTD Total 779,915$ 867,214$ 743,213$ (36,702)$ ‐5% (124,001)$ ‐14%
Annual Total 3,070,506$ 3,414,200$
Interfund Services
Year to Date through March
2012 vs. 2011 2012 vs. Budget
Month
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 165,721$ 169,834$ 183,478$ 17,757$ 11% 13,644$ 8%
Feb 261,655 262,221 238,928 (22,727) ‐9% (23,293) ‐9%
Mar 313,067 314,171 241,678 (71,389) ‐23% (72,493) ‐23%
Apr 289,767 288,252
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 740,442$ 746,225$ 664,083$ (76,358)$ ‐10% (82,142)$ ‐11%
Annual Total 3,112,464$ 3,214,156$
2012 vs. Budget2012 vs. 2011
Year to Date through March
Fines and Penalties by Month
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 ‐
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 243,967$ 271,299$ 226,174$ (17,793)$ ‐7% (45,125)$ ‐17%
Annual Total 1,493,540$ 1,660,863$
Recreation
Year to Date through March
2012 vs. Budget2012 vs. 2011
Month
Page 7 of 37
Monthly Financial Report March 2012
Year to Date through March
2011 2012 2012
Actual Budget Actual $ % $ %
Civil Penalties 2,901$ 4,060$ 1,667$ (1,235)$ ‐43% (2,393)$ ‐59%
Civil Infraction Penalties 141,715 152,033 111,839 (29,876) ‐21% (40,193) ‐26%
Civil Parking Infraction Penalties 20,846 22,735 19,964 (882) ‐4% (2,771) ‐12%
Photo Enforcement Program 527,825 540,877 475,558 (52,266) ‐10% (65,319) ‐12%
Criminal Traffic Misdemeanor Fines 18,121 16,404 16,774 (1,346) ‐7% 370 2%
Criminal Non‐Traffic Fines 6,143 7,894 4,364 (1,779) ‐29% (3,531) ‐45%
Criminal Costs 22,851 2,157 22,054 (797) ‐3% 19,897 922%
Seizure Funds ‐ Federal/State/Local ‐ ‐ 11,738 11,738 100% 11,738 100%
Non‐Court Fines, Forfeitures and Penalties 40 65 125 85 213% 60 91%
YTD Total 740,442$ 746,225$ 664,083$ (76,358)$ ‐10% (82,142)$ ‐11%
Annual Total 3,112,464$ 3,214,156$
Revenue
2012 vs. Budget
Fines and Penalties by Type
2012 vs. 2011
Included in the Fines and Penalties revenue budget
is $1.9 million from the Photo Enforcement
program. The budget was based on the prior year’s
revenue. The year‐to‐date collections from this
program equates to $476k. 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 71% of the total
revenue in this category. The year‐to‐date
total miscellaneous is $394k. Compared to
last year, the revenues are over by $82k or
26%. Compared to the projected year‐to‐
date budget, the revenues are over by $129k
or 49%. The table on the next page breaks
out miscellaneous revenues by type:
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 143,105$ 129,601$ 206,151$ 63,046$ 44% 76,550$ 59%
Feb 70,237 54,283 83,823 13,585 19% 29,540 54%
Mar 99,131 81,184 104,421 5,289 5% 23,236 29%
Apr 74,048 61,628
May 97,083 84,780
Jun 145,018 116,531
Jul 173,878 129,148
Aug 133,570 104,016
Sep 97,973 80,880
Oct 75,425 63,490
Nov 77,427 64,538
Dec 163,299 152,620
YTD Total 312,474$ 265,069$ 394,394$ 81,920$ 26% 129,326$ 49%
Annual Total 1,350,195$ 1,122,699$
Ye ar to Date through March
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 ‐ 53,048 ‐ ‐
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 540,877$ 475,558$ 229,095$ 203,451$ 272,108$
Annual Total 1,944,713$ 841,964$
1Actuals of Revenues and Expenses
Revenues Expenses
Photo Enforcement Program
Year to Date through March
Month
Page 8 of 37
Monthly Financial Report March 2012
2011 2012 2012
Actual Budget Actual $ % $ %
Interests and Other Earnings 17,599$ 20,590$ 20,892$ 3,293$ 19% 302$ 1%
Rents, Leases, and Concessions 219,861 207,059 260,753 40,893 19% 53,695 26%
Contributions/Donations from Private Sources 43,874 23,434 37,447 (6,426) ‐15% 14,013 60%
Other 31,141 13,986 75,302 44,161 142% 61,316 438%
YTD Total 312,474$ 265,069$ 394,394$ 81,920$ 26% 129,326$ 49%
Annual Total 1,350,195$ 1,122,699$
2012 vs. Budget
Miscellaneous Revenues by Type
Year to Date through March
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 higher than the prior year and budget due to the timing of donations
received.
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 22% of its budgeted general governmental expenditures at the end of March. This is $398k
or 1.8% below year‐to‐date budgeted expenditures. See below for summary of unfavorable items for general governmental
departments.
Administrative Services Department (Finance and City Clerk) is over budget by $57k or 10%. This is due to the spending
patterns of the 1st Quarter of 2012 compared to 2010 and 2011. The year‐to‐date budget should even out later in the year.
Fire and Emergency Services Department is over budget by $74k or 1.1%. This is mainly due to over spending on supplies
and intergovernmental ($107k) and under spending in professional services ($15k).
Community Services Department is over budget by $18k or 1%. This is mainly due to over spending on salaries/benefits
($5k) and professional services ($30k) and under spending in supplies ($19k).
Page 9 of 37
Monthly Financial Report March 2012
CASH AND INVESTMENTS – 1ST QUARTER
The current cash and investments
(C&I) portfolio is provided in the
table to the right. The City’s
current C&I balance is $90.8
million, of this amount; $1.5 million
is an interfund loan investment
(Res 4070) from the general fund
(000) to the golf course fund (404).
This interfund loan is due in full on
December 1st 2015.
Currently the majority of the
portfolio is located in cash deposits
(US Bank). The rest is spread out
between the State Investment
Pool, various certificates of
deposits, and the interfund loan.
The existing portfolio yield is
approximately .66%. The majority
(.24%) lies within the cash at US
Bank.
US Bank ‐Cash
49%
State Investment Pool
11%
Golf Course
Interfund Loan
2%
First Savings Bank Northwest
5%
Columbia Bank
7%
Fortune Bank (CDARS)
2%
Sterling Bank
6%
Umpqua Bank
11%
Commencement Bank
(CDARS)
7%
Distribution by Institution
(Percent of Cash & Investment Portfolio)
Deposit Total Maturity Date APY
Weighted
Yield
Current
Allocation of Cash
and Investments
Allowed by
Policy
Current Principal
Balance
Cash
US Bank ‐ Cash 44,401,384 overnight 0.50% 0.24% 48.90% N/A 44,401,384
355,000 12/01/2012 2.25% 0.01%
375,000 12/13/2013 2.25% 0.01%
395,000 12/01/2014 2.25% 0.01%
410,000 12/01/2015 0.85% 0.01%
1,535,000
US Treasury Securities
none ‐ N/A N/A 0.00%100%‐
Local Government Investment Pool
State Investment Pool 9,893,782 overnight 0.13% 0.01%
21.32% 75.00% 9,893,782
US Federal Agency Securities *
‐ 0.00% 100.00%‐
Certificate of Deposit
First Savings Bank Northwest 2,328,105 08/24/2012 0.92% 0.02%
2,328,848 08/24/2012 0.92% 0.02%
Columbia Bank 2,768,975 01/11/2014 0.69% 0.02%
2,000,000 11/05/2012 1.12% 0.02%
2,015,400 11/09/2016 0.99% 0.02%
Fortune Bank (CDARS)
1,504,108 06/14/2012 0.80% 0.01%
Fortune Bank 250,839 12/23/2012 0.75% 0.00%
Sterling Bank 5,000,000 06/16/2012 0.70% 0.04%
10.77% 20.00% 5,000,000
Umpqua Bank 5,140,000 05/18/2012 0.90% 0.05%
5,042,636 12/25/2012 1.20% 0.07%
Commencement Bank (CDARS)1,000,000 09/20/2012 1.50% 0.02%
CDARS 5,100,192 09/06/2013 1.00% 0.06%
Traditional 500,000 10/27/2013 1.00% 0.01%
Commercial Paper ‐
none N/A 0.00% 5.00%
TOTAL CASH & INVESTMENTS 90,809,267$ 0.66% 100.00% 90,809,267$
Institution
Golf Interfund Loan
3.31% N/A
20.00%10.03%
20.00%14.62%
4,656,953
6,784,375
14.22% 20.00% 6,600,192
1,754,947
10,182,636
20.00%3.78%
20.00%21.94%
Page 10 of 37
Monthly Financial Report March 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 ‐ ‐ ‐ ‐ 10,090 8,150 ‐
Grants / intergovernmental 87,907 ‐ 107,838 52,524 ‐ 337,907 ‐
Charges for services 20,214 212,696 3,803,009 3,157,495 2,067,559 1,905,500 3,353,349
Interdepartmental services ‐ ‐ 3,031 65,077 72,285 156,606 ‐
Fines and penalties ‐ ‐ ‐ ‐ ‐ ‐ ‐
Rents, leases, and misc fees 568,755 42,755 18,000 32,506 ‐ ‐ ‐
Interest and other misc 2,289 1,024 8,800 46,410 111,233 53,818 1,081
TOTAL REVENUES 679,165 256,475 3,940,678 3,354,012 2,261,167 2,461,981 3,354,430
EXPENSES:
Utility billing ‐ ‐ 24,788 22,102 17,125 25,787 ‐
Utility systems ‐ ‐ 2,925,525 656,933 614,225 562,167 ‐
Utility maintenance ‐ ‐ 69,298 1,086,885 341,116 455,551 3,239,310
Transportation 324,120 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 386,123 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 324,120 386,123 3,019,611 1,765,920 972,466 1,043,505 3,239,310
AMOUNT AVAILABLE FOR DEBT SERVICE 355,045 (129,648) 921,067 1,588,092 1,288,701 1,418,476 115,120
DEBT SERVICE:
Principal ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest and other debt service costs ‐ ‐ ‐ ‐ ‐ ‐ ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ ‐ ‐ ‐ ‐
CAPITAL PROJECTS 107,699 11,369 ‐ 244,313 441,441 666,575 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CH ANGE IN FUND BALANCE 247,346 (141,017) 921,067 1,343,779 847,260 751,901 115,120
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, March 31, 2012 2,332,056 474,471 2,655,801 8,986,285 2,056,616 4,962,500 1,192,925
Page 11 of 37
Monthly Financial Report March 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 ‐ 19,510 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ 17,500 1,915 ‐ ‐ ‐ 43,637
Charges for services
Equipment rental m&o 564,524 529,094 ‐ ‐ ‐ ‐ ‐
Telecommunications ‐ 46,584 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 26,658 ‐ 99,272 ‐ ‐ ‐
Communications ‐ ‐ ‐ 147,820 ‐ ‐ ‐
Facilities ‐ ‐ 1,043,360 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 37,525 ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ 79,008 ‐ ‐ ‐ ‐ ‐
Geographical information systems ‐ 49,214 ‐ ‐ ‐ ‐ ‐
Interest and other misc 4,620 2,024 448 161 5,897 7,246 5,487
Internal service fund misc:
Vehicle / equipment capital recovery 239,890 235,678 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 391,021 ‐ ‐
Worker's compensation / unemployment ‐ ‐ ‐ ‐ 336,411 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 2,763,500 552,374
Other misc 153 126 2,591 126 199 176,737 ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets ‐ ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 20,572 50 17
TOTAL REVENUES 809,187 1,042,921 1,048,314 247,379 754,100 2,947,533 601,515
EXPENSES:
Communications 112,373
Equipment rental 599,912
Facilities 838,114
Healthcare 2,249,212
Information technology 793,176
Print and mail 97,132
Retiree healthcare 269,006
Risk management
Risk management 826,666
Unemployment 42,976
Worker's compensation 200,317
TOTAL EXPENSES 599,912 793,176 838,114 209,505 1,069,959 2,249,212 269,006
AMOUNT AVAILABLE FOR CAPITAL 209,275 249,745 210,200 37,874 (315,859) 698,321 332,509
CAPITAL PROJECTS 211,047 318,437 47,602 ‐ ‐ ‐ ‐
TRANSFERS IN ‐ ‐ ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE (1,772) (68,692) 162,598 37,874 (315,859) 698,321 332,509
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, March 31, 2012 4,772,604 2,113,051 462,836 178,994 6,304,578 7,832,317 5,811,908
Page 12 of 37
Monthly Financial Report March 2012
FUND BALANCE
Page 14 shows the ending fund balance as of March 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 March, the City has $5 million reported in the combined general governmental fund balance of the current
year’s operating budget, which is approximately 5% of budgeted operating expenditures. This is a decrease of $6.1 million
from the year’s beginning balance. March’s ending fund balance is over the anticipated General Governmental Fund
Balance of $2.9 million by $2 million or 73.9%. 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 13 of 37
Monthly Financial Report March 2012
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through March 31, 2012
Funds
Balance
01/01/2012
Budgeted
Revenue
Revenue
03/31/12
Total Funds
Available
Budgeted
Expenditure
Expenditure
03/31/12
Ending
Balance
GENERAL GOVERNMENT FUNDS:11,057,551 101,591,685 16,218,914 27,276,465 100,468,787 22,281,867 4,994,598
000 General 6,934,747 74,013,147 11,869,999 18,804,746 73,638,578 17,726,701 1,078,045
001 Community Services 1,413,050 11,241,005 2,031,534 3,444,584 11,007,906 2,224,072 1,220,511
003 Street 1,264,341 8,953,479 1,465,196 2,729,537 8,440,487 1,936,035 793,502
004 Community Dev Block Grant 8,339 305,961 73,144 81,483 303,281 66,791 14,692
005 Museum 52,620 216,220 216,306 268,926 213,533 53,787 215,139
006 Library 48,603 230,000 41 48,644 230,000 7,500 41,144
009 Farmers Market 87,437 75,500 16,877 104,314 78,629 15,658 88,656
010 Fire Memorial 1,953 ‐ ‐ 1,953 ‐ ‐ 1,953
011 Fire Health & Wellness 36,858 25,000 6,474 43,332 25,000 1,005 42,327
031 Pa rk Memorial 177,758 ‐ 171 177,929 ‐ ‐ 177,929
201 Ltd GO Bonds Gen Govt Debt 591,257 1,982,075 208,609 799,866 1,982,075 ‐ 799,866
215 Gen Govt Misc Debt Service 440,588 4,549,298 330,563 771,151 4,549,298 250,317 520,834
SPECIAL REVENUE FUNDS:
102 Arterial Street 158,974 630,000 140,700 299,674 630,000 ‐ 299,674
108 Leased City Properties 488,500 971,049 124,482 612,982 876,232 118,172 494,810
110 Hotel Motel 243,556 265,000 106,538 350,094 265,000 230,145 119,949
118 Reserve for Paths & Trails 3,314 ‐ 3 3,317 ‐ ‐ 3,317
125 1% For Art 121,686 15,000 117 121,803 50,000 ‐ 121,803
127 Cable Communication 185,968 85,000 53,954 239,922 85,674 2,137 237,785
135 Springbrook Wetlands Bank 663,556 ‐ 638 664,194 ‐ ‐ 664,194
DEBT SERVICE FUNDS:
219 1989 Unlimited GO Bonds ‐ ‐ ‐ ‐ ‐ ‐ ‐
CAPITAL PROJECT FUNDS (CIP):
303 Community Dev Mitigation 1,475,050 60,000 1,419 1,476,469 ‐ ‐ 1,476,469
304 Fire Mitigation 1,492,674 100,000 3,963 1,496,637 536,926 ‐ 1,496,637
305 Transportation Mitigation 657,187 150,000 3,012 660,199 400,000 ‐ 660,199
316 Municipal Facilities CIP 3,745,546 760,000 189,110 3,934,656 1,170,000 553,249 3,381,407
317 Transportation CIP 3,422,219 21,418,181 969,640 4,391,859 21,603,852 1,000,911 3,390,948
318 So Lake WA Infrastructure Proj 52,792 ‐ 50 52,842 ‐ 441 52,401
326 Housing Opportunity 130,546 ‐ 1,335 131,881 ‐ ‐ 131,881
336 New Library Development 19,196,447 ‐ 17,262 19,213,709 8,000,000 174,882 19,038,827
ENTERPRISE FUNDS:
402 Airport 494,718 1,862,168 409,800 904,518 1,288,846 324,120 580,398
403 Solid Waste Utility 1,734,734 15,004,692 3,940,678 5,675,412 14,972,362 3,019,611 2,655,801
404 Golf Course 379,997 2,483,545 256,242 636,239 2,542,204 411,126 225,113
422 Airport Capital 1,589,992 3,275,003 269,365 1,859,357 4,766,203 107,699 1,751,658
424 Golf Course Capital 235,491 100,000 25,236 260,727 100,000 11,369 249,358
INTERNAL SERVICE FUNDS:
501 Equipment Repair/Replacement 4,774,376 3,079,893 809,187 5,583,563 3,145,756 810,958 4,772,605
502 Insurance 6,620,437 3,187,593 754,100 7,374,537 2,930,079 1,069,959 6,304,578
503 Information Services 2,181,743 4,118,173 1,042,921 3,224,664 4,409,226 1,111,613 2,113,051
504 Facilities 300,238 4,324,987 1,048,314 1,348,552 4,379,434 885,716 462,836
505 Communications 141,120 974,307 247,379 388,499 991,015 209,504 178,995
512 Insurance, Healthcare 7,133,996 12,014,224 2,947,533 10,081,529 11,996,739 2,249,212 7,832,317
522 Insurance, Leoff1 Retirees HC 5,479,399 2,235,684 601,516 6,080,915 2,262,573 269,006 5,811,909
FIDUCIARY FUNDS:
611 Firemen's Pension 4,377,696 300,000 1,753 4,379,449 550,475 69,843 4,309,606
Funds
Balance
01/01/2012
Budgeted
Revenue
Revenue
03/31/12
Total Funds
Available
Budgeted
Expenditure
Expenditure
03/31/12
Ending
Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 14,140,266 47,683,644 11,431,588 25,571,854 46,070,637 8,373,530 17,198,324
405 Water Utility 3,993,415 11,106,460 2,660,525 6,653,940 10,662,036 1,765,920 4,888,020
406 Waste Water Utility 685,178 5,888,574 1,399,054 2,084,232 5,130,805 972,466 1,111,766
407 Surface Wa ter Utility 1,625,915 5,469,223 1,451,100 3,077,015 4,968,409 1,043,505 2,033,510
416 King County Metro 1,077,805 13,209,387 3,354,430 4,432,235 13,209,387 3,239,310 1,192,925
425 Water Utility Construction 3,633,246 5,200,000 693,471 4,326,717 5,350,000 244,313 4,082,404
426 Waste Water Construction 524,178 3,310,000 862,113 1,386,291 3,250,000 441,441 944,850
427 Surface Water Construction 2,584,684 3,500,000 1,010,880 3,595,564 3,500,000 666,575 2,928,989
461 Waterworks Bond Reserve ‐ ‐ ‐ ‐ ‐ ‐ ‐
471 Waterworks Rate Stabilization 15,845 ‐ 15 15,860 ‐ ‐ 15,860
481 Future W/S Bond Proceeds ‐ ‐ ‐ ‐ ‐ ‐ ‐
Note: Waterworks Utility Funds are managed as a system and are designated by the dotted lines.
Page 14 of 37
City of Renton
General Government Financial Position
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
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 15 of 37
City of Renton
Monthly Revenue Analysis ‐ 2011 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 5,177,686 5,169,136 ‐0.17%
Feb 10,661,236 10,715,775 0.51%
Mar 16,212,898 16,218,914 0.04%
Apr 29,811,735
May 44,765,022
Jun 49,576,341
Jul 55,545,967
Aug 60,654,624
Sep 66,677,448
Oct 80,091,446
Nov 94,892,892
Dec 101,591,685
Percent of budget 15.96%
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
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 3.39%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
Budget
Actual
Last Year
Page 16 of 37
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
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 25.56%
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
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 27.36%
Note: Includes Natural Gas Use Tax.
$0
$2
$4
$6
$8
$10
$12
$14
$16
Budget
Actual
Last Year
Page 17 of 37
City of Renton
Monthly Revenue Analysis ‐ 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
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 24.80%
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,344,433
May 4,599,738
Jun 5,211,152
Jul 5,769,160
Aug 6,293,933
Sep 6,754,771
Oct 8,152,834
Nov 10,545,615
Dec 12,257,101
Percent of budget 11.34%
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 18 of 37
City of Renton
Monthly Revenue Analysis ‐ 2011 Budget Year
Charges for
Services Budget
YTD
Actual
Annual %
over (under)
Jan 416,181 374,426 ‐10.03%
Feb 876,990 788,975 ‐10.04%
Mar 1,402,675 1,308,436 ‐6.72%
Apr 1,977,253
May 2,559,130
Jun 3,107,345
Jul 3,747,859
Aug 4,435,671
Sep 4,993,503
Oct 5,488,048
Nov 5,976,544
Dec 6,488,075
Percent of budget 20.17%
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
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 20.81%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Budget
Actual
Last Year
Page 19 of 37
City of Renton
Monthly Revenue Analysis ‐ 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
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 20.11%
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 129,601 206,151 59.07%
Feb 183,884 289,974 57.69%
Mar 265,069 394,394 48.79%
Apr 326,696
May 411,476
Jun 528,008
Jul 657,155
Aug 761,171
Sep 842,051
Oct 905,541
Nov 970,079
Dec 1,122,699
Percent of budget 35.13%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60 Budget
Actual
Last Year
Page 20 of 37
City of Renton
Monthly Revenue Analysis ‐ 2011 Budget Year
Other
Financing Budget
YTD
Actual
Annual %
over (under)
Jan ‐ ‐ N/A
Feb 73 90 23.00%
Mar 291 5,494 1788.14%
Apr 15,265
May 15,317
Jun 15,359
Jul 15,390
Aug 15,442
Sep 955,178
Oct 1,003,537
Nov 1,003,558
Dec 1,037,752
Percent of budget 0.53%
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
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 24.46%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
Millions
Budget
Actual
Last Year
Page 21 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,159,501 6,667,414 ‐6.87%
Feb 15,479,015 15,284,017 ‐1.26%
Mar 22,679,391 22,281,867 ‐1.75%
Apr 32,885,245
May 41,086,528
Jun 49,407,682
Jul 58,035,836
Aug 66,615,729
Sep 75,130,713
Oct 83,223,433
Nov 91,435,213
Dec 100,468,787
Percent of budget expended 22.18%
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
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 24.22%
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
Budget
Actual
Last Year
Page 22 of 37
City of Renton
Monthly Expenditure Analysis ‐ 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
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 21.28%
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
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 23.01%
$‐
$30,000
$60,000
$90,000
$120,000
$150,000
$180,000
Budget
Actual
Last Year
Page 23 of 37
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
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 25.12%
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,315 166,993 ‐4.20%
Feb 343,541 334,252 ‐2.70%
Mar 519,637 504,905 ‐2.84%
Apr 695,808
May 868,112
Jun 1,065,771
Jul 1,247,962
Aug 1,428,172
Sep 1,611,434
Oct 1,777,831
Nov 1,956,497
Dec 2,147,819
Percent of budget expended 23.51%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
$2.00
$2.20
Budget
Actual
Last Year
Page 24 of 37
City of Renton
Monthly Expenditure Analysis ‐ 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
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 25.11%
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 285,738 239,412 ‐16.21%
Feb 554,503 477,272 ‐13.93%
Mar 820,791 715,648 ‐12.81%
Apr 1,084,998
May 1,367,126
Jun 1,618,928
Jul 1,883,093
Aug 2,121,834
Sep 2,402,670
Oct 2,652,859
Nov 2,910,482
Dec 3,181,944
Percent of budget expended 22.49%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions
Budget
Actual
Last Year
Page 25 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Economic
Development Budget
YTD
Actual
Annual %
over (under)
Jan 57,949 51,733 ‐10.73%
Feb 121,700 115,634 ‐4.98%
Mar 174,340 164,809 ‐5.47%
Apr 231,323
May 296,550
Jun 357,043
Jul 420,160
Aug 475,727
Sep 547,604
Oct 604,832
Nov 669,268
Dec 735,088
Percent of budget expended 22.42%
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
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 24.86%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
Millions
Budget
Actual
Last Year
Page 26 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Finance Budget
YTD
Actual
Annual %
over (under)
Jan 136,092 152,157 11.80%
Feb 272,763 312,270 14.48%
Mar 412,217 476,115 15.50%
Apr 549,019
May 698,320
Jun 841,002
Jul 975,053
Aug 1,125,622
Sep 1,289,057
Oct 1,416,270
Nov 1,546,148
Dec 1,969,836
Percent of budget expended 24.17%
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 57,441 51,770 ‐9.87%
Feb 112,475 111,173 ‐1.16%
Mar 176,816 170,116 ‐3.79%
Apr 320,451
May 434,608
Jun 491,567
Jul 549,792
Aug 606,842
Sep 665,236
Oct 773,721
Nov 833,785
Dec 897,889
Percent of budget expended 18.95%
$‐
$0.20
$0.40
$0.60
$0.80
Budget
Actual
Last Year
Page 27 of 37
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
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 24.00%
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,206,020 1,905,016 ‐13.64%
Feb 4,389,322 4,392,199 0.07%
Mar 6,577,000 6,307,019 ‐4.10%
Apr 9,802,495
May 12,224,630
Jun 14,750,537
Jul 17,291,458
Aug 19,694,067
Sep 22,140,419
Oct 24,468,872
Nov 26,911,238
Dec 29,486,965
Percent of budget expended 21.39%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
Budget
Actual
Last Year
Page 28 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Fire &
Emergency
Services Budget
YTD
Actual
Annual %
over (under)
Jan 1,923,042 1,891,121 ‐1.66%
Feb 4,570,376 4,615,089 0.98%
Mar 6,465,803 6,539,657 1.14%
Apr 8,330,757
May 10,290,744
Jun 12,213,296
Jul 14,184,171
Aug 16,224,917
Sep 18,211,842
Oct 20,076,333
Nov 22,068,980
Dec 24,056,171
Percent of budget expended 27.18%
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
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 25.82%
$‐
$0.05
$0.10
$0.15
$0.20
$0.25
$0.30
$0.35
$0.40
$0.45
Budget
Actual
Last Year
Page 29 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Parks Budget
YTD
Actual
Annual %
over (under)
Jan 261,786 274,545 4.87%
Feb 557,743 551,290 ‐1.16%
Mar 852,218 862,246 1.18%
Apr 1,167,853
May 1,493,714
Jun 1,847,897
Jul 2,216,513
Aug 2,582,645
Sep 2,964,943
Oct 3,339,297
Nov 3,699,232
Dec 4,034,496
Percent of budget expended 21.37%
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 28,998 36,047 24.31%
Feb 69,346 73,127 5.45%
Mar 113,087 124,284 9.90%
Apr 157,789
May 211,609
Jun 263,308
Jul 323,697
Aug 377,022
Sep 430,152
Oct 488,729
Nov 543,900
Dec 595,868
Percent of budget expended 20.86%
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
Budget
Actual
Last Year
Page 30 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Recreation Budget
YTD
Actual
Annual %
over (under)
Jan 358,551 304,539 ‐15.06%
Feb 717,974 652,057 ‐9.18%
Mar 1,088,468 999,673 ‐8.16%
Apr 1,455,212
May 1,835,186
Jun 2,239,891
Jul 2,849,851
Aug 3,517,178
Sep 4,068,080
Oct 4,447,445
Nov 4,840,555
Dec 5,263,801
Percent of budget expended 18.99%
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 52,442 58,787 12.10%
Feb 112,820 130,666 15.82%
Mar 187,063 266,033 42.22%
Apr 365,554
May 464,165
Jun 527,898
Jul 700,951
Aug 775,728
Sep 841,420
Oct 984,322
Nov 1,072,876
Dec 1,250,561
Percent of budget expended 21.27%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
Budget
Actual
Last Year
Page 31 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Neighborhoods
, Resources,
and Events Budget
YTD
Actual
Annual %
over (under)
Jan 42,529 41,419 ‐2.61%
Feb 85,318 79,802 ‐6.47%
Mar 128,698 129,143 0.35%
Apr 179,615
May 228,786
Jun 291,874
Jul 361,214
Aug 426,413
Sep 480,940
Oct 526,500
Nov 579,477
Dec 692,698
Percent of budget expended 18.64%
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 76,667
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 3.26%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
Budget
Actual
Last Year
Page 32 of 37
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
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 25.19%
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
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 25.58%
$‐
$0.20
$0.40
$0.60
Budget
Actual
Last Year
Page 33 of 37
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
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 25.08%
YTD Annual %
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
Millions Street Maintenance
Budget
Actual
Last Year
$5
Millions Transportation
Transportation Budget Actual over (under)
Jan 343,583 288,400 ‐16.06%
Feb 732,773 660,477 ‐9.87%
Mar 1,145,011 1,000,881 ‐12.59%
Apr 1,487,078
May 1,869,588
Jun 2,288,875
Jul 2,643,630
Aug 3,060,278
Sep 3,428,984
Oct 3,846,248
Nov 4,223,516
Dec 4,711,542
Percent of budget expended 21.24%
$‐
$1
$1
$2
$2
$3
$3
$4
$4
$5
$5
Budget
Actual
Last Year
Page 34 of 37
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 2,177,124
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 3.83%
Non‐
Departmental YTD Annual % $5 00
Millions Non‐Departmental Other City Services
$‐
$2
$4
$6
$8
$10
$12
$14
$16
Millions Debt Service
Budget
Actual
Last Year
Other City Budget Actual over (under)
Jan 313,245 313,245 0.00%
Feb 649,480 649,480 0.00%
Mar 886,227 886,227 0.00%
Apr 981,416
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 30.10%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00 Budget
Actual
Last Year
Page 35 of 37
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2011 Budget Year
Utilities Budget Revenue Expense
Jan 3,164,286 4,860,643 3,270,986
Feb 7,740,013 9,712,888 7,451,062
Mar 13,011,714 15,372,251 11,393,139
Apr 16,907,772
May 20,901,033
Jun 28,637,592
Jul 33,611,835
Aug 37,987,613
Sep 43,191,375
Oct 48,302,115
Nov 53,139,220
Dec 61,042,999
Percent of budget expended 12.55%
Note: Operations and Capital
$0
$10
$20
$30
$40
$50
$60
$70
Millions Utilities
Budget
Revenue
Expense
$7 00
Millions Airport
Airport Budget Revenue Expense
Jan 428,274 182,302 131,563
Feb 767,296 480,547 293,170
Mar 1,144,707 679,165 431,819
Apr 1,560,870
May 1,883,605
Jun 2,524,289
Jul 2,941,966
Aug 3,666,150
Sep 4,229,875
Oct 4,976,221
Nov 5,555,023
Dec 6,055,049
Percent of budget expended 7.13%
Note: Operations and Capital
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
$7.00
Budget
Revenue
Expense
Page 36 of 37
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2011 Budget Year
Golf Course Budget Revenue Expense
Jan 60,382 65,568 123,688
Feb 200,592 163,205 259,488
Mar 339,771 281,478 422,495
Apr 428,982
May 529,040
Jun 663,065
Jul 759,813
Aug 867,578
Sep 958,975
Oct 1,043,849
Nov 1,209,132
Dec 2,642,204
Percent of budget expended 15.99%
Note: Operations and Capital
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
$2.40
$2.70
$3.00
Millions Golf Course
Budget
Revenue
Expense
Page 37 of 37