HomeMy WebLinkAbout201202, February.pdfFINANCE AND
INFORMATION TECHNOLOGY
M E M O R A N D U M
DATE: March 23, 2012
TO: Rich Zwicker, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: February 2012 Financial Status Report
At the end of February, general governmental revenues show $56k or 0.5% over budget.
Revenues sources that are higher than expected are: sales taxes ($75k); utility taxes ($45k);
gambling excise taxes ($76k); building permits & development service fees ($120k); state
shared revenues ($93k); and rents, leases, and concessions ($41k). On the down side, the
revenue sources that are underperforming the year to date budget are: property taxes ($338k
below); franchise fees ($27k below); culture and recreation fees ($39k below); and
interfund/inter‐departmental services ($95k below).
General government expenditures showed favorable variance of $195k or 1.3%. 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 489,513 32,357,894 841,695 32,896,746 572,253 234,689 (337,565) ‐59.0%
Sales Tax 17,198,220 3,017,952 17,729,731 3,321,928 17,864,000 3,175,855 3,251,262 75,407 2.4%
Sales Tax ‐ Annexation Credit 2,025,660 358,740 2,033,954 361,762 2,101,647 373,802 393,908 20,106 5.4%
Criminal Justice Sales Tax 1,620,479 295,109 1,809,757 306,150 1,867,145 315,858 338,736 22,878 7.2%
Natural Gas Use Tax 228,514 48,940 249,407 51,913 270,394 56,282 103,454 47,172 83.8%
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 960,877 5,166,711 961,417 5,283,280 983,108 1,020,050 36,942 3.8%
Natural Ga s Utility Tax 1,577,756 426,892 1,848,806 472,200 1,950,000 498,045 482,804 (15,241) ‐3.1%
Transfer Station 269,912 27,925 297,474 42,655 248,762 35,670 31,552 (4,119) ‐11.5%
TV Cable 1,296,744 218,605 1,385,275 196,580 1,427,679 202,597 196,557 (6,040) ‐3.0%
Telephone 1,038,009 181,636 966,827 168,190 1,000,000 173,961 165,318 (8,643) ‐5.0%
Cellular Phone 2,206,637 323,057 2,054,183 359,479 2,309,360 404,134 398,483 (5,652) ‐1.4%
City Utilities 2,853,884 449,931 3,516,179 558,864 3,665,728 582,634 583,499 866 0.1%
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 273,344 1,671,414 254,230 1,600,000 243,368 319,797 76,429 31.4%
Real Estate Excise Tax 2,464,489 178,545 2,074,059 261,588 2,025,000 255,291 291,768 36,477 14.3%
Less: Municipal Facilities CIP REET (400,000) (29,757) (400,000) (46,712) (400,000) (46,712) (57,633) (10,921) 23.4%
EMS Levy 1,161,114 ‐ 868,873 ‐ 1,007,976 ‐ ‐ ‐ 0.0%
Business License Fees 431,782 111,395 442,451 107,262 469,817 113,896 112,928 (968) ‐0.9%
Other Licenses and Permits 262,629 36,750 232,534 27,241 213,305 24,988 38,378 13,390 53.6%
Building Permits & Development Svc Fees 2,437,270 487,202 2,772,779 274,292 2,466,063 237,925 358,299 120,374 50.6%
Intergovt'l (Grants, State Shared, etc) 4,426,676 709,057 4,737,323 636,857 4,381,262 446,974 516,625 69,651 15.6%
Fire District 25 and 40 Contracts 5,252,877 19,525 6,110,668 136,635 6,008,694 152,200 152,200 ‐ 0.0%
Public Safety 482,343 65,965 484,985 59,726 430,635 53,033 50,077 (2,956) ‐5.6%
Culture and Recreation 1,424,932 127,588 1,493,540 144,430 1,660,863 160,611 121,399 (39,212) ‐24.4%
Interfund/Interdept‐Services 3,190,908 516,332 3,070,506 473,624 3,414,200 567,518 472,142 (95,376) ‐16.8%
Fines and Forfeits 1,291,817 97,940 1,163,602 100,833 1,088,750 94,275 82,132 (12,143) ‐12.9%
Photo Enforcement 1,925,159 322,846 1,897,782 329,628 1,944,713 337,779 330,705 (7,074) ‐2.1%
Seizure Funds ‐ Federal/State/Local 221,046 46,627 83,220 ‐ 180,693 ‐ 11,690 11,690 100.0%
Interests and Other Earnings 327,558 46,329 294,452 22,280 195,400 14,785 42,753 27,967 189.2%
Rents, Leases, and Concessions 727,338 186,375 744,834 160,887 701,464 151,518 192,089 40,570 26.8%
Contri butions and Donations 133,756 6,455 196,586 30,480 105,000 16,280 35,428 19,148 117.6%
Other Miscellaneous 290,239 38,515 341,878 21,946 357,358 22,491 43,651 21,160 94.1%
Other Financing Sources (Transfer‐In, etc) 653,595 105 1,073,507 808 1,037,752 73 90 17 23.0%
Total Operating Revenues 96,754,435 10,472,029 100,476,431 11,050,241 101,591,685 10,659,637 10,715,775 56,139 0.5%
OPERATING EXPENDITURES
Legislative 259,345 43,671 271,236 44,576 284,087 47,250 45,516 1,734 3.7%
Executive 1,578,526 272,736 1,566,906 229,987 1,468,694 234,736 193,315 41,422 17.6%
Hearing Examiner 174,447 29,129 59,878 21,908 71,025 15,470 3,485 11,985 77.5%
City Attorney 1,565,597 266,526 1,596,609 264,464 1,668,686 280,202 277,093 3,109 1.1%
Court Services 2,007,599 328,318 2,084,170 326,156 2,147,819 343,541 334,252 9,289 2.7%
Community and Eco Dvlpmnt Admin 579,396 97,354 929,814 155,007 952,912 159,341 159,405 (65) 0.0%
Development Services 2,946,413 528,639 2,810,736 474,633 3,181,944 554,503 477,272 77,231 13.9%
Economic Development 1,322,004 215,064 724,970 123,830 735,088 121,700 115,634 6,066 5.0%
Planning 1,774,508 256,434 1,447,781 258,972 1,516,719 242,600 245,831 (3,231) ‐1.3%
Finance 2,214,458 286,770 2,134,667 315,453 1,969,836 272,763 312,270 (39,507) ‐14.5%
City Clerk 789,209 92,936 736,880 98,230 897,889 112,475 111,173 1,302 1.2%
Human Resources 861,221 141,160 888,252 155,437 946,956 160,543 145,615 14,927 9.3%
Police 23,946,386 3,954,817 24,737,346 4,106,211 24,746,366 4,097,491 4,100,369 (2,878) ‐0.1%
Jail Services 3,539,035 284,035 6,206,735 277,239 4,740,599 291,830 291,830 ‐ 0.0%
Fire 21,554,792 4,239,777 22,511,597 4,132,293 24,056,171 4,570,376 4,615,089 (44,713) ‐1.0%
Community Services Admin 1 1,063,011 175,538 416,284 67,558 421,043 69,191 73,790 (4,599) ‐6.6%
Parks 3,421,424 475,369 3,829,676 527,048 4,034,496 557,743 551,290 6,453 1.2%
Parks Planning & Natural Resources 448,574 47,118 551,423 69,260 595,868 69,346 73,127 (3,781) ‐5.5%
Recreation 4,433,420 580,776 4,974,002 702,382 5,263,801 717,974 652,057 65,917 9.2%
Human Services 1,326,778 113,264 1,247,294 118,956 1,250,561 112,820 130,666 (17,846) ‐15.8%
Neighborhoods, Resources, & Events 331,222 42,593 610,545 73,402 692,698 85,318 79,802 5,516 6.5%
Library 2,289,692 229,125 2,030,000 5,119 230,000 5,000 5,000 ‐ 0.0%
Museum 191,090 31,141 210,620 34,638 213,533 34,965 35,736 (771) ‐2.2%
Public Works Admin 1 514,858 86,114 452,538 74,538 465,889 77,369 79,440 (2,071) ‐2.7%
Street Maintenance 3,412,892 542,804 3,534,025 597,149 3,728,945 611,900 614,685 (2,785) ‐0.5%
Transportation 5,215,309 822,448 4,509,066 689,957 4,711,542 732,773 660,477 72,296 9.9%
Debt Service 4,707,100 126,390 4,822,566 254,918 6,531,373 250,317 250,317 ‐ 0.0%
Non‐Departmental and Other 4,834,296 701,408 4,930,383 1,557,092 2,944,248 649,480 649,480 ‐ 0.0%
Total Operating Expenditures 97,302,601 15,011,456 100,825,999 15,756,416 100,468,787 15,479,015 15,284,017 194,998 1.3%
Total Ending Fund Balance 11,407,119$ 7,415,858$ 11,057,551$ 6,700,944$ 10,461,605$ 4,519,328$ 6,489,310$ 1,969,981 43.6%
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 February 2012
Page 1 of 36
Monthly Financial Report February 2012
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through February 29, 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
February’s collection is $86k,
making the total year‐to‐date
collection $235k or 1% of the total
budget. In comparison to the
previous year, the City collected
$607k or 72% less. Compared to
the budget, the City is below
projections by $338k or 59%.
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 $478k or
67% behind 2011.
Sales Tax
February 2012 sales tax receipts
totalled $1.9 million. Compared to the
same month last year, it is $59k or 3%
less. Compared to the projected
current month’s budget, it is $136k or
8% above. The year‐to‐date collection
of $3.3 million is $71k or 2% less than
the prior year but is $75k or 2% 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
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 841,695$ 572,253$ 234,689$ (607,006)$ ‐72% (337,565)$ ‐59%
Annual Total 32,357,894$ 32,896,746$
Property Tax Revenues
Year to Date through February
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 ‐
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 3,321,928$ 3,175,855$ 3,251,262$ (70,666)$ ‐2% 75,407$ 2%
Annual Total 17,729,731$ 17,864,000$
2012 vs . Budget2012 vs. 2011
Month
Year to Date through February
Local Retail Sales Tax Revenues
Page 2 of 36
Monthly Financial Report February 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 273,159$ 258,377$ 298,972$ 25,813$ 9%$ 40,596 16%
Auto Sales 537,537 581,269 571,189 33,651 6% (10,081)‐2%
General Retail 1,154,748 1,207,179 1,244,660 89,912 8% 37,481 3%
Manufacturing 371,387 144,815 158,954 (212,433) ‐57% 14,139 10%
Wholesale 196,181 207,494 210,413 14,232 7% 2,919 1%
Service 699,570 707,473 705,670 6,099 1% (1,803) 0%
Other 89,346 69,248 61,404 (27,942) ‐31% (7,844)‐11%
Total 3,321,928$ 3,175,855$ 3,251,262$ (70,666)$ ‐2%75,407$ 2%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility tax
February utility tax revenues are $1.5
million, which is $64k or 4% higher
than the same month last year but is
behind the budget by $445. The year‐
to‐date collection is $3 million, which
is $170k or 6% higher than the prior
year and is also $45k or 2% higher
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 961,417$ 983,108$ 1,020,050$ 58,633$ 6%$ 36,942 4%
Natural Gas 524,113 554,327 586,258 62,145 12% 31,931 6%
Cell 359,479 404,134 398,483 39,004 11% (5,652)‐1%
Phone 168,190 173,961 165,318 (2,872) ‐2% (8,643)‐5%
Cable 196,580 202,597 196,557 (22) 0% (6,040)‐3%
Transfer Station 42,655 35,670 31,552 (11,104) ‐26% (4,119)‐12%
City Utilities 558,864 582,634 583,499 24,635 4% 866 0%
YTD Total 2,811,298$ 2,936,432$ 2,981,716$ 170,418$ 6%45,285$ 2%
Annual Total 15,484,862$ 16,155,203$
YTD as % of 18% 18%
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
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 2,811,298$ 2,936,432$ 2,981,716$ 170,418$ 6% 45,285$ 2%
Annual Total 15,484,862$ 16,155,203$
2012 vs. Budget2012 vs . 2011
Year to Date through February
Utility Tax Revenues
Month
Page 3 of 36
Monthly Financial Report February 2012
Other Taxes
Real Estate Excise Tax
The City collected $214k in Real Estate
Excise Tax revenues (REET) in February.
This is $114k or 115% ahead of the same
month last year and $117k or 120%
above the current month’s budget. The
year‐to‐date collection is $292k, which is
$30k or 12% more than the prior year
and is also $36k or 14% above the
budget.
Gambling Tax
February’s Gambling Tax
collections total $144k. Year‐to‐
date total of $320k is $66k or 26%
above the year before and is also
$76k or 31% 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.
Pull tabs overall had a 12%
increase, bingo increased by 41%, and card‐rooms are seeing 24% 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
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 261,588$ 255,291$ 291,768$ 30,180$ 12% 36,477$ 14%
Annual Total 2,074,059$ 2,025,000$
Real Estate Excise Tax Re venues
Year to Date through February
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 ‐
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 254,230$ 243,368$ 319,797$ 65,566$ 26% 76,429$ 31%
Annual Total 1,671,414$ 1,600,000$
Ye a r to Date through February
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 ‐
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$
Month
2012 vs. 2011 2012 vs. Budget
Franchise Fees Revenue
Year to Date through February
Page 4 of 36
Monthly Financial Report February 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 $198k in
February. The year‐to‐date
development fees revenue of $358k is
$84k or 31% more than 2011 and is also
$120k or 51% higher than budget. The
higher than expected fees are due to
collecting more in general building
permits and zoning/plan check fees.
Business Licenses
Business Licenses totalled $24k for February,
which is $1k or 5% above the same month last
year but is $334 or 1% below the current
month’s budget. The year‐to‐date Business
Licenses revenue is ahead of the prior year by
$6k or 5% and but is $1k or 1% below 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 February
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 ‐
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 107,262$ 113,896$ 112,928$ 5,666$ 5% (968)$ ‐1%
Annual Total 442,451$ 469,817$
2012 vs . 2011
Year to Date through February
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
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 274,292$ 237,925$ 358,299$ 84,007$ 31% 120,374$ 51%
Annual Total 2,772,779$ 2,466,063$
Building Permits and Development Service Fees
Year to Date through February
2012 vs. Budget2012 vs. 2011
Month
Page 5 of 36
Monthly Financial Report February 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 88% of the total revenues in this category. The year‐to‐date total Intergovernmental revenue is $1 million or 8%
of the budget.
State Shared Revenues
State Shared Revenue
collections totalled $733k since
the start of 2012. Compared to
the prior year, State Shared
Revenues are above by $49k or
7%. Compared to the
projected budget, the City is
collecting $93k or 14% more.
The higher than expected
collections are due to Criminal
Justice’s High Crime and
Population 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 75% of the total revenue in this category. The year‐to‐date total charges for services are $789k or 12% of the
budget. This is 10% below budget projections. The following sections provide detail information for Public Safety,
Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totalled $50k 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 $10k or 16%
less. Compared to the budget, the City is
collecting $3k or 6% less 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 ‐
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 59,726$ 53,033$ 50,077$ (9,649)$ ‐16% (2,956)$ ‐6%
Annual Total 484,985$ 430,635$
Mont h
2012 vs. 2011
Year to Date through February
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 136,635 152,200 152,200 15,565 11%‐ 0%
State Shared Revenue 683,946 640,351 732,880 48,934 7% 92,529 14%
Federal Grants 162,600 66,138 66,138 (96,463) ‐59%‐ 0%
State Grants 38,605 20,385 20,385 (18,220) ‐47%‐ 0%
Other Grants/Intgovt 37,303 35,958 35,958 (1,345) ‐4%‐ 0%
ARRA Grants 125,916 ‐ ‐ (125,916) 0%‐ N/A
Total Rev YTD 1,185,005$ 915,032$ 1,007,561$ (177,443)$ ‐15%92,529$ 10%
Total Rev Annual 12,657,748$ 12,257,101$
YTD %9%7%8%
Note: Includes CJ Sales Tax.
2011 2012 2012
Actual Budget Actual $ % $ %
Crim Just Sales Tax 306,150$ 315,858$ 338,736$ 32,586$ 11% 22,878$ 7%
Judicial Contribution ‐ ‐ 5,658 5,658 100% 5,658 100%
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 ‐ ‐ ‐ ‐ N/A ‐ N/A
Liquor Excise Tax 104,651 106,927 109,021 4,369 4% 2,094 2%
Fuel Tax 199,017 197,959 204,001 4,983 3% 6,041 3%
YTD Total 683,946$ 640,351$ 732,880$ 48,934$ 7% 92,529$ 14%
Annual Total 4,495,551$ 4,437,913$
Year to Date through February
State Shared Revenues
2012 vs. 2011
Revenue
2012 vs. Budget
Page 6 of 36
Monthly Financial Report February 2012
Recreation
Recreation revenues totalled $59k for the
current month. Compared to the same
month the prior year, the City collected
$23k or 28% less. Compared to the
projected monthly budget, the City
collected $32k or 35% less. The year‐to‐
date collection of $121k is $23k or 16%
less than the prior year and is also $39k
or 24% less than the budget.
Interfund Services
The year‐to‐date collections for Interfund
Services revenues are $472k. Compared
to the prior year, the revenues are under
by $38k or 7%. Compared to the
projected budget, the revenues are
below by $95k or 17%. 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 will be 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 $422k. This is $5k or 1% lower than a
year ago and also $10k or 2% 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 ‐
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 510,389$ 567,518$ 472,142$ (38,246)$ ‐7% (95,376)$ ‐17%
Annual Total 3,070,506$ 3,414,200$
2012 vs. Budget
Month
Interfund Services
Year to Date through February
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
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 427,375$ 432,054$ 422,405$ (4,970)$ ‐1% (9,649)$ ‐2%
Annual Total 3,112,464$ 3,214,156$
Month
2012 vs. Budget2012 vs . 2011
Year to Date through February
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 ‐
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 144,430$ 160,611$ 121,399$ (23,031)$ ‐16% (39,212)$ ‐24%
Annual Total 1,493,540$ 1,660,863$
Recreation
Year to Date through February
2012 vs. Budget2012 vs. 2011
Month
Page 7 of 36
Monthly Financial Report February 2012
Year to Date through February
2011 2012 2012
Actual Budget Actual $ % $ %
Civil Penalties 1,578$ 2,208$ 765$ (813)$ ‐51% (1,443)$ ‐65%
Civil Infraction Penalties 63,022 67,611 49,475 (13,548) ‐21% (18,136) ‐27%
Civil Parking Infraction Penalties 10,124 11,041 8,153 (1,970) ‐19% (2,887) ‐26%
Photo Enforcement Program 329,628 337,779 330,705 1,077 0% (7,074) ‐2%
Criminal Traffic Misdemeanor Fines 8,800 7,966 8,457 (343) ‐4% 491 6%
Criminal Non‐Traffic Fines 3,416 4,390 2,297 (1,119) ‐33% (2,093) ‐48%
Criminal Costs 10,782 1,018 10,788 6 0% 9,770 960%
Seizure Funds ‐ Federal/State/Local ‐ ‐ 11,690 11,690 100% 11,690 100%
Non‐Court Fines, Forfeitures and Penalties 25 41 75 50 200% 34 84%
YTD Total 427,375$ 432,054$ 422,405$ (4,970)$ ‐1% (9,649)$ ‐2%
Annual Total 3,112,464$ 3,214,156$
2012 vs. 2011
Revenue
2012 vs. Budget
Fines and Penalties by Type
Included in the Fines and Penalties revenue budget
is $1.9 million from the Photo Enforcement
program. The budget was based on the prior year’s
revenue. The year‐to‐date collections from this
program equates to $331k. 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 81% of the total
revenue in this category. The year‐to‐date
total miscellaneous is $290k. Compared to
last year, the revenues are over by $77k or
36%. Compared to the projected year‐to‐
date budget, the revenues are over by $108k
or 59%. The table on the next page breaks
out miscellaneous revenues by type:
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 143,105$ 129,016$ 206,151$ 63,046$ 44% 77,135$ 60%
Feb 70,237 53,269 83,823 13,585 19% 30,554 57%
Mar 99,131 81,783
Apr 74,048 61,550
May 97,083 83,787
Jun 145,018 115,471
Jul 173,878 130,160
Aug 133,570 106,004
Sep 97,973 82,788
Oct 75,425 62,931
Nov 77,427 64,812
Dec 163,299 151,128
YTD Total 213,343$ 182,285$ 289,974$ 76,631$ 36% 107,689$ 59%
Annual Total 1,350,195$ 1,122,699$
Year to Date through Fe bruary
Mont h
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 ‐ 76,201 ‐ ‐
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 337,779$ 330,705$ 152,894$ 135,812$ 194,893$
Annual Total 1,944,713$ 841,964$
1 Actuals of Revenues and Expenses
Expenses
Photo Enforcement Program
Year to Date through February
Month
Revenues
Page 8 of 36
Monthly Financial Report February 2012
2011 2012 2012
Actual Budget Actual $ % $ %
Interests and Other Earnings 22,280$ 14,785$ 42,753$ 20,473$ 92% 27,967$ 189%
Rents, Leases, and Concessions 160,887 151,518 192,089 31,202 19% 40,570 27%
Contributions/Donations from Private Sources 30,480 16,280 35,428 4,948 16% 19,148 118%
Other (304) (299) 19,705 20,008 ‐6591% 20,004 ‐6699%
YTD Total 213,343$ 182,285$ 289,974$ 76,631$ 36% 107,689$ 59%
Annual Total 1,350,195$ 1,122,699$
2012 vs. Budget
Miscellaneous Revenues by Type
Ye a r to Date through February
Revenue
2012 vs. 2011
Interest and other earnings are higher than the prior year and budget due to higher than expected utility late payment
penalties.
Rents, leases and concessions are higher than the prior year and budget due to higher than expected 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.
EXPENSES
Overall the City has expended 15% of its budgeted general governmental expenditures at the end of February. This is
$195k or 1.3% 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 unfavorable by $38k or 10%. This is due to the spending
patterns of January and February 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 $45k or 1%. This is mainly due to over spending on supplies and
intergovernmental ($53k) and under spending in professional services ($12k).
Page 9 of 36
Monthly Financial Report February 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 ‐ ‐ ‐ ‐ 6,595 5,000 ‐
Grants / intergovernmental 87,907 ‐ 11,694 ‐ ‐ 131,317 ‐
Charges for services 10,987 119,606 2,527,622 2,050,741 1,316,931 1,280,334 2,154,118
Interdepartmental services ‐ ‐ ‐ 30,877 24,562 58,185 ‐
Fines and penalties ‐ ‐ ‐ ‐ ‐ ‐ ‐
Rents, leases, and misc fees 380,230 26,264 12,000 20,510 ‐ ‐ ‐
Interest and other misc 1,424 666 7,934 27,004 26,944 19,838 693
TOTAL REVENUES 480,548 146,536 2,559,250 2,129,132 1,375,032 1,494,674 2,154,811
EXPENSES:
Utility billing ‐ ‐ 17,088 15,898 11,992 18,088 ‐
Utility systems ‐ ‐ 1,759,945 414,214 412,240 353,004 ‐
Utility maintenance ‐ ‐ 43,991 685,390 197,308 276,751 2,159,540
Transportation 219,635 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 232,381 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 219,635 232,381 1,821,024 1,115,502 621,540 647,843 2,159,540
AMOUNT AVAILABLE FOR DEBT SERVICE 260,913 (85,845) 738,226 1,013,630 753,492 846,831 (4,729)
DEBT SERVICE:
Principal ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest and other debt service costs ‐ ‐ ‐ ‐ ‐ ‐ ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ ‐ ‐ ‐ ‐
CAPITAL PROJECTS 73,535 10,438 ‐ 135,760 376,071 573,783 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 187,378 (96,283) 738,226 877,870 377,421 273,048 (4,729)
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, February 29, 2012 2,272,088 519,205 2,472,960 8,520,376 1,586,777 4,483,647 1,073,076
Page 10 of 36
Monthly Financial Report February 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 ‐ 10,840 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ 17,500 1,915 ‐ ‐ ‐ ‐
Charges for services
Equipment rental m&o 375,612 352,706 ‐ ‐ ‐ ‐ ‐
Telecommunications ‐ 31,047 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 17,765 ‐ 66,173 ‐ ‐ ‐
Communications ‐ ‐ ‐ 98,536 ‐ ‐ ‐
Facilities ‐ ‐ 695,565 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 25,016 ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ 52,662 ‐ ‐ ‐ ‐ ‐
Geographical information systems ‐ 32,812 ‐ ‐ ‐ ‐ ‐
Interest and other misc 3,056 1,336 297 103 3,862 4,695 3,594
Internal service fund misc:
Vehicle / equipment capital recovery 159,932 157,109 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 260,669 ‐ ‐
Worker's compensation / unemployment ‐ ‐ ‐ ‐ 224,147 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 1,850,867 368,438
Other misc 153 108 2,362 126 ‐ 121,772 ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets ‐ ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 13,793 50 17
TOTAL REVENUES 538,753 698,901 700,139 164,938 502,471 1,977,384 372,049
EXPENSES:
Communications 74,883
Equipment rental 360,155
Facilities 473,009
Healthcare 1,617,041
Information technology 582,032
Print and mail 64,278
Retiree healthcare 150,233
Risk management
Risk management 741,620
Unemployment 42,976
Worker's compensation 149,625
TOTAL EXPENSES 360,155 582,032 473,009 139,161 934,221 1,617,041 150,233
AMOUNT AVAILABLE FOR CAPITAL 178,598 116,869 227,131 25,777 (431,750) 360,343 221,816
CAPITAL PROJECTS 201,677 178,695 36,923 ‐ ‐ ‐ ‐
TRANSFERS IN ‐ ‐ ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE (23,079) (61,826) 190,208 25,777 (431,750) 360,343 221,816
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, February 29, 2012 4,751,297 2,119,917 490,446 166,897 6,188,687 7,494,339 5,701,215
Page 11 of 36
Monthly Financial Report February 2012
FUND BALANCE
Page 13 shows the ending fund balance as of February 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 February, the City has $6.5 million reported in the combined general governmental fund balance of the
current year’s operating budget, which is approximately 6% of budgeted operating expenditures. This is a decrease of $4.6
million from the year’s beginning balance. February’s ending fund balance is over the anticipated General Governmental
Fund Balance of $4.5 million by $2 million or 43.6%. 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 February 2012
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through February 29, 2012
Funds
Balance
01/01/2012
Budgeted
Revenue
Revenue
02/29/12
Total Funds
Available
Budgeted
Expenditure
Expenditure
02/29/12
Ending
Balance
GENERAL GOVERNMENT FUNDS:11,057,551 101,591,685 10,715,775 21,773,326 100,468,787 15,284,017 6,489,309
000 General 6,934,747 74,013,147 7,906,931 14,841,678 73,638,578 12,236,203 2,605,475
001 Community Services 1,413,050 11,241,005 1,352,839 2,765,889 11,007,906 1,430,067 1,335,822
003 Street 1,264,341 8,953,479 996,717 2,261,058 8,440,487 1,275,162 985,896
004 Community Dev Block Grant 8,339 305,961 73,144 81,483 303,281 41,337 40,145
005 Museum 52,620 216,220 16 52,636 213,533 35,736 16,900
006 Library 48,603 230,000 28 48,631 230,000 5,000 43,631
009 Farmers Market 87,437 75,500 6,279 93,716 78,629 9,647 84,069
010 Fire Memorial 1,953 ‐ 20 1,973 ‐ ‐ 1,973
011 Fire Health & Wellness 36,858 25,000 4,315 41,173 25,000 547 40,626
031 Park Memorial 177,758 ‐ 113 177,871 ‐ ‐ 177,871
201 Ltd GO Bonds Gen Govt Debt 591,257 1,982,075 122,894 714,151 1,982,075 ‐ 714,151
215 Gen Govt Misc Debt Service 440,588 4,549,298 252,480 693,068 4,549,298 250,317 442,751
SPECIAL REVENUE FUNDS:
102 Arterial Street 158,974 630,000 96,146 255,120 630,000 ‐ 255,120
108 Leased City Properties 488,500 971,049 67,142 555,642 876,232 63,615 492,027
110 Hotel Motel 243,556 265,000 45,568 289,124 265,000 219,993 69,131
118 Reserve for Paths & Trails 3,314 ‐ 2 3,316 ‐ ‐ 3,316
125 1% For Art 121,686 15,000 77 121,763 50,000 ‐ 121,763
127 Cable Communication 185,968 85,000 53,876 239,844 85,674 2,137 237,707
135 Springbrook Wetlands Bank 663,556 ‐ 422 663,978 ‐ ‐ 663,978
DEBT SERVICE FUNDS:
219 1989 Unlimited GO Bonds ‐ ‐ ‐ ‐ ‐ ‐ ‐
CAPITAL PROJECT FUNDS (CIP):
303 Community Dev Mitigation 1,475,050 60,000 938 1,475,988 ‐ ‐ 1,475,988
304 Fire Mitigation 1,492,674 100,000 1,436 1,494,110 536,926 ‐ 1,494,110
305 Transportation Mitigation 657,187 150,000 1,134 658,321 400,000 ‐ 658,321
316 Municipal Facilities CIP 3,745,546 760,000 103,201 3,848,747 1,170,000 197,764 3,650,983
317 Transportation CIP 3,422,219 21,418,181 939,668 4,361,887 21,603,852 393,036 3,968,851
318 So Lake WA Infrastructure Proj 52,792 ‐ 33 52,825 ‐ 441 52,384
326 Housing Opportunity 130,546 ‐ 888 131,434 ‐ ‐ 131,434
336 New Library Development 19,196,447 ‐ 11,440 19,207,887 8,000,000 59,824 19,148,063
ENTERPRISE FUNDS:
402 Airport 494,718 1,862,168 391,607 886,325 1,288,846 219,635 666,690
403 Solid Waste Utility 1,734,734 15,004,692 2,559,251 4,293,985 14,972,362 1,821,025 2,472,960
404 Golf Course 379,997 2,483,545 146,384 526,381 2,542,204 249,051 277,330
422 Airport Capital 1,589,992 3,275,003 88,940 1,678,932 4,766,203 73,535 1,605,397
424 Golf Course Capital 235,491 100,000 16,822 252,313 100,000 10,438 241,875
INTERNAL SERVICE FUNDS:
501 Equipment Repair/Replacement 4,774,376 3,079,893 538,753 5,313,129 3,145,756 561,833 4,751,296
502 Insurance 6,620,437 3,187,593 502,471 7,122,908 2,930,079 934,222 6,188,686
503 Information Services 2,181,743 4,118,173 698,901 2,880,644 4,409,226 760,727 2,119,917
504 Facilities 300,238 4,324,987 700,139 1,000,377 4,379,434 509,932 490,445
505 Communications 141,120 974,307 164,938 306,058 991,015 139,162 166,896
512 Insurance, Healthcare 7,133,996 12,014,224 1,977,384 9,111,380 11,996,739 1,617,041 7,494,339
522 Insurance, Leoff1 Retirees HC 5,479,399 2,235,684 372,049 5,851,448 2,262,573 150,233 5,701,215
FIDUCIARY FUNDS:
611 Firemen's Pen s ion 4,377,696 300,000 1,166 4,378,862 550,475 48,377 4,330,485
Funds
Balance
01/01/2012
Budgeted
Revenue
Revenue
02/29/12
Total Funds
Available
Budgeted
Expenditure
Expenditure
02/29/12
Ending
Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 14,140,266 47,683,644 7,153,646 21,293,912 46,070,637 5,630,037 15,663,875
405 Water Utility 3,993,415 11,106,460 2,124,607 6,118,022 10,662,036 1,115,466 5,002,556
406 Waste Water Utility 685,178 5,888,574 1,349,366 2,034,544 5,130,805 621,539 1,413,005
407 Surface Wate r Utility 1,625,915 5,469,223 1,476,233 3,102,148 4,968,409 647,842 2,454,306
416 King County Metro 1,077,805 13,209,387 2,154,810 3,232,615 13,209,387 2,159,540 1,073,075
425 Water Utility Construction 3,633,246 5,200,000 4,515 3,637,761 5,350,000 135,796 3,501,965
426 Waste Water Construction 524,178 3,310,000 25,666 549,844 3,250,000 376,071 173,773
427 Surface Water Construction 2,584,684 3,500,000 18,439 2,603,123 3,500,000 573,783 2,029,340
461 Waterworks Bond Res e rve ‐ ‐ ‐ ‐ ‐ ‐ ‐
471 Waterworks Rate Stabilization 15,845 ‐ 10 15,855 ‐ ‐ 15,855
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
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 14 of 36
City of Renton
Monthly Revenue Analysis ‐ 2011 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 5,177,101 5,169,136 ‐0.15%
Feb 10,659,637 10,715,775 0.53%
Mar 16,324,199
Apr 29,922,958
May 44,875,252
Jun 49,685,509
Jul 55,656,149
Aug 60,766,794
Sep 66,791,526
Oct 80,204,965
Nov 95,006,684
Dec 101,591,685
Percent of budget 10.55%
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
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 0.71%
$‐
$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
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 18.26%
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
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 18.46%
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
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 16.15%
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,470,698
Apr 2,456,734
May 4,712,039
Jun 5,323,454
Jul 5,881,461
Aug 6,406,234
Sep 6,867,073
Oct 8,265,135
Nov 10,657,916
Dec 12,257,101
Percent of budget 8.22%
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 416,181 374,426 ‐10.03%
Feb 876,990 788,975 ‐10.04%
Mar 1,402,675
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 12.16%
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
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 13.21%
$‐
$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
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 15.78%
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,016 206,151 59.79%
Feb 182,285 289,974 59.08%
Mar 264,067
Apr 325,618
May 409,405
Jun 524,875
Jul 655,036
Aug 761,039
Sep 843,828
Oct 906,759
Nov 971,571
Dec 1,122,699
Percent of budget 25.83%
$‐
$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 73 90 23.00%
Mar 291
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.01%
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
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 14.41%
$‐
$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,159,501 6,667,414 ‐6.87%
Feb 15,479,015 15,284,017 ‐1.26%
Mar 24,852,219
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 15.21%
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
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 16.02%
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
Budget
Actual
Last Year
Page 21 of 36
City of Renton
Monthly Expenditure Analysis ‐ 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
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 13.16%
YTD Annual %
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
Millions Executive
Budget
Actual
Last Year
$0 80
Millions City Clerk
City Clerk Budget Actual over (under)
Jan 57,441 51,770 ‐9.87%
Feb 112,475 111,173 ‐1.16%
Mar 176,816
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 12.38%
$‐
$0.20
$0.40
$0.60
$0.80
Budget
Actual
Last Year
Page 22 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Hearing
Examiner Budget
YTD
Actual
Annual %
over (under)
Jan 8,732 1,731 ‐80.18%
Feb 15,470 3,485 ‐77.47%
Mar 20,317
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 4.91%
YTD Annual % $1 60
Millions City Attorney
$‐
$30,000
$60,000
$90,000
$120,000
$150,000
$180,000
Hearing Examiner
Budget
Actual
Last Year
City Attorney Budget Actual over (under)
Jan 135,939 136,926 0.73%
Feb 280,202 277,093 ‐1.11%
Mar 419,912
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 16.61%
$‐
$0.40
$0.80
$1.20
$1.60 Budget
Actual
Last Year
Page 23 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Court Services Budget
YTD
Actual
Annual %
over (under)
Jan 174,315 166,993 ‐4.20%
Feb 343,541 334,252 ‐2.70%
Mar 519,637
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 15.56%
YTD Annual %
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
$2.00
$2.20
Millions Court Services
Budget
Actual
Last Year
Millions
Community & Economic
Dl Ad iCED Admin Budget Actual over (under)
Jan 77,315 79,562 2.91%
Feb 159,341 159,405 0.04%
Mar 239,050
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 16.73%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Millions Development Admin
Budget
Actual
Last Year
Page 24 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Development
Services Budget
YTD
Actual
Annual %
over (under)
Jan 285,738 239,412 ‐16.21%
Feb 554,503 477,272 ‐13.93%
Mar 820,791
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 15.00%
Economic YTD Annual %
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions
Development Services
Budget
Actual
Last Year
Millions
Economic Development
Development Budget Actual over (under)
Jan 57,949 51,733 ‐10.73%
Feb 121,700 115,634 ‐4.98%
Mar 174,340
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 15.73%
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
$0.70
$0.80
Millions
Budget
Actual
Last Year
Page 25 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Planning Budget
YTD
Actual
Annual %
over (under)
Jan 111,447 121,734 9.23%
Feb 242,600 245,831 1.33%
Mar 344,794
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 16.21%
YTD Annual % $2 40
Millions Finance
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
Millions
Planning
Budget
Actual
Last Year
Finance Budget Actual over (under)
Jan 136,092 152,157 11.80%
Feb 272,763 312,270 14.48%
Mar 412,217
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 15.85%
$‐
$0.40
$0.80
$1.20
$1.60
$2.00
$2.40 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
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 15.38%
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 7,467,467
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 14.90%
$‐
$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,923,042 1,891,121 ‐1.66%
Feb 4,570,376 4,615,089 0.98%
Mar 6,465,803
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 19.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
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 17.53%
$‐
$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 261,786 274,545 4.87%
Feb 557,743 551,290 ‐1.16%
Mar 852,218
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 13.66%
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
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 12.27%
$‐
$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 358,551 304,539 ‐15.06%
Feb 717,974 652,057 ‐9.18%
Mar 1,088,468
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 12.39%
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
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 10.45%
$‐
$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,529 41,419 ‐2.61%
Feb 85,318 79,802 ‐6.47%
Mar 128,698
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 11.52%
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 57,500
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 2.17%
$‐
$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
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 16.74%
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
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 17.05%
$‐
$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
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 16.48%
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
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 14.02%
$‐
$1
$1
$2
$2
$3
$3
$4
$4
$5
$5
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 1,632,843
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 736,062
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 22.06%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00 Budget
Actual
Last Year
Page 34 of 36
City of Renton
Monthly Enterprise Fund Financial Report ‐ 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
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 7.81%
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
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 4.84%
Note: Operations and Capital
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
$7.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,382 65,568 123,688
Feb 200,592 163,205 259,488
Mar 339,771
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 9.82%
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