HomeMy WebLinkAbout201102, February.pdfFINANCE AND
INFORMATION TECHNOLOGY
M E M O R A N D U M
DATE: March 24, 2011
TO: Terri Briere, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: February 2011 Financial Status Report
At the end of February, general governmental revenues show $279k or 2.6% over budget. This
includes $344k of favorable property and $259k sales tax collections but otherwise almost all
other revenue categories are under performing. The largest deficit is from building permits and
development services’ fees by $281k.
On the expenditures’ side, most departments conserved their spending and showed favorable
variances. Overall general governmental funds are showing a $904k or 5.4% savings. A number
of divisions may appear to exceed their budget at the end of February, most are due to timing
of various payments and expenditures that are fine at the combined department level.
The Recreation division of Community Services Department has a prior year utility bill
correction ($28k for 2009 natural gas at the Henry Moses Aquatic Center) paid in January. We
will monitor their budget to determine if a budget adjustment is necessary later in the year.
It is important to note that it is still early and the result is not a good gauge for the performance
of the year. We will have a much better sense about the year after the first quarter.
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,816,561$ 11,816,561$ 11,955,285$ 11,955,285$ 11,407,119$ 11,407,119$ 11,407,119$ ‐$ 0.0%
OPERATING REVENUES
Property Tax 30,660,522 312,932 31,497,128 489,513 32,046,525 498,052 841,695 343,643 69.0%
Sales Tax 17,995,836 3,321,502 17,198,220 3,017,952 17,759,600 3,063,324 3,321,928 258,603 8.4%
Sales Tax ‐ Annexation Credit 2,132,110 392,007 2,025,660 358,740 2,119,680 375,391 361,762 (13,629) ‐3.6%
Criminal Justice Sa les Tax 1,650,350 311,656 1,620,479 295,109 1,804,005 328,531 306,150 (22,381) ‐6.8%
Natural Gas Use Tax 242,891 56,975 228,514 48,940 258,750 55,415 51,913 (3,502) ‐6.3%
Admission Tax 260,269 57,167 291,399 75,236 280,000 72,293 70,881 (1,412) ‐2.0%
Franchise Fees 1,039,031 259,992 1,222,444 320,478 1,260,000 330,324 305,646 (24,678) ‐7.5%
Electricity Tax 4,963,151 1,029,605 5,036,907 960,877 4,968,000 947,732 961,417 13,685 1.4%
Natural Ga s Utility Tax 1,891,255 595,888 1,577,756 426,892 1,656,000 448,062 472,200 24,137 5.4%
Transfer Station 283,985 46,908 269,912 27,925 238,050 24,629 42,655 18,026 73.2%
TV Cable 1,263,743 207,139 1,296,744 218,605 1,366,200 230,313 196,580 (33,734) ‐14.6%
Telephone 1,037,873 172,701 1,038,009 181,636 1,000,000 174,985 168,190 (6,795) ‐3.9%
Cellular Phone 2,027,473 318,635 2,206,637 323,057 2,202,000 322,378 359,479 37,100 11.5%
City Utilities 2,871,599 471,659 2,853,884 449,931 3,477,600 548,263 558,864 10,601 1.9%
Leasehold Excise Tax 146,002 27,996 138,830 35,999 145,000 37,599 34,846 (2,753) ‐7.3%
Gambling Excise Tax 2,141,720 398,744 1,546,386 273,344 1,600,000 282,821 254,230 (28,591) ‐10.1%
Real Estate Excise Tax 2,418,456 300,624 2,464,489 178,545 2,240,000 162,366 261,588 99,222 61.1%
Less: Municipal Facilities CIP REET (1,000,000) (174,406) (400,000) (29,757) (400,000) (29,757) (46,712) (16,955) 57.0%
EMS Levy 1,170,657 ‐ 1,161,114 ‐ 950,921 ‐ ‐ ‐ 0.0%
Business License Fees 424,413 112,016 431,782 111,395 463,067 119,466 107,262 (12,204) ‐10.2%
Other Licenses and Permits 176,851 27,803 262,629 36,750 210,255 29,421 27,241 (2,180) ‐7.4%
Building Permits & Development Svc Fees 2,361,037 339,522 2,437,270 487,202 2,706,044 555,505 274,292 (281,212) ‐50.6%
Intergovernmental (Grants, State Shared R 3,820,932 486,203 4,426,676 709,057 3,244,263 580,526 636,857 56,332 9.7%
Fire District 25 and 40 Contracts 5,869,198 ‐ 5,252,877 19,525 5,928,462 136,635 136,635 ‐ 0.0%
Public Safety 521,484 79,853 482,343 65,965 426,081 58,271 59,726 1,456 2.5%
Culture and Recreation 1,631,486 138,397 1,424,932 127,588 1,628,486 145,815 144,430 (1,384) ‐0.9%
Interfund/Interdept‐Services 3,225,745 496,643 3,190,908 516,332 3,314,653 536,356 473,624 (62,732) ‐11.7%
Fines and Forfeits 1,349,034 184,743 1,291,817 97,940 1,088,750 77,865 100,833 22,968 29.5%
Photo Enforcement 2,368,131 358,029 1,925,159 322,846 1,900,908 318,779 329,628 10,849 3.4%
Seizure Funds ‐ Federal/State/Local 99,844 23,204 221,046 46,627 180,693 38,115 ‐ (38,115) ‐100.0%
Interests and Other Earnings 535,314 94,222 327,558 46,329 477,730 67,569 22,280 (45,289) ‐67.0%
Rents, Leases, and Concessions 677,960 175,950 727,338 186,375 698,929 179,095 160,887 (18,209) ‐10.2%
Contributions and Donations 150,406 27,177 133,756 6,455 100,000 4,826 30,480 25,654 531.6%
Other Miscellaneous 355,086 66,503 290,239 38,515 352,218 49,255 21,946 (27,308) ‐55.4%
Refunding Debt and Premiums ‐ ‐ 6,613,484 ‐ ‐ ‐ ‐ ‐ 0.0%
Other Financing Sources (Transfer‐In, etc) 578,206 96 653,595 105 529,056 808 808 ‐ 0.0%
Total Operating Revenues 97,342,052 10,718,082 103,367,918 10,472,029 98,221,926 10,771,029 11,050,241 279,213 2.6%
OPERATING EXPENDITURES
Legislative 247,225 40,339 259,345 43,671 277,834 46,076 44,576 1,500 3.3%
Executive 1,499,747 218,383 1,578,526 272,736 1,454,762 232,098 229,987 2,111 0.9%
City Clerk 646,581 95,898 789,209 92,936 790,484 103,964 98,230 5,734 5.5%
Hearing Examiner 171,911 29,101 174,447 29,129 171,929 28,905 21,908 6,997 24.2%
City Attorney 1,248,380 163,483 1,565,597 266,526 1,600,531 244,580 264,464 (19,884) ‐8.1%
Court Services 1,819,731 300,245 2,007,599 328,318 2,104,953 345,697 326,156 19,541 5.7%
Community and Eco Dvlpmnt Admin 265,269 46,111 579,396 97,354 929,263 157,835 155,007 2,827 1.8%
Development Services 3,615,129 630,788 2,946,413 528,639 3,081,560 544,513 474,633 69,880 12.8%
Economic Development 1,244,175 202,776 1,322,004 215,064 687,775 111,988 123,830 (11,842) ‐10.6%
Planning 1,525,460 210,568 1,774,508 256,434 1,459,446 206,537 258,972 (52,436) ‐25.4%
Finance 1,969,936 393,890 2,214,458 286,770 1,909,797 310,659 315,453 (4,794) ‐1.5%
Human Resources 853,063 131,405 861,221 141,160 948,554 150,817 155,437 (4,620) ‐3.1%
Police 25,833,756 4,391,561 27,485,421 4,238,853 30,651,495 4,961,350 4,383,450 577,899 11.6%
Fire 20,378,891 4,252,214 21,554,792 4,239,777 22,045,916 4,464,519 4,132,293 332,226 7.4%
Community Services Admin1 4,459,381 756,836 1,063,011 175,538 412,476 69,640 67,558 2,083 3.0%
Parks 3,894,745 482,807 3,421,424 475,369 3,921,721 513,616 527,048 (13,432) ‐2.6%
Parks Planning & Natural Resources ‐ ‐ 448,574 47,118 582,186 97,031 69,260 27,771 28.6%
Recreation 4,374,668 500,520 4,433,420 580,776 5,147,357 631,899 702,382 (70,483) ‐11.2%
Human Services 1,194,142 120,078 1,326,778 113,264 1,256,071 116,265 118,956 (2,691) ‐2.3%
Neighborhoods, Resources, & Events 348,185 41,503 331,222 42,593 678,584 83,994 73,402 10,592 12.6%
Library 2,321,878 305,850 2,289,692 229,125 2,030,000 5,119 5,119 ‐ 0.0%
Museum 140,801 23,758 191,090 31,141 208,407 34,473 34,638 (164) ‐0.5%
Public Works Administration 1 942,026 151,856 514,858 86,114 454,179 74,186 74,538 (352) ‐0.5%
Street Maintenance 3,794,716 617,379 3,412,892 542,804 3,693,925 594,598 597,149 (2,551) ‐0.4%
Transportation 5,110,639 790,599 5,215,309 822,448 4,599,219 718,458 689,957 28,500 4.0%
Debt Service 4,176,822 ‐ 11,320,584 126,390 4,715,035 254,918 254,918 ‐ 0.0%
Non‐Departmental and Other 5,126,072 731,767 4,834,296 701,408 3,120,946 1,557,092 1,557,092 ‐ 0.0%
Total Operating Expenditures 97,203,328 15,629,716 103,916,084 15,011,456 98,934,407 16,660,826 15,756,416 904,410 5.4%
Total Ending Fund Balance 11,955,285$ 6,904,927$ 11,407,119$ 7,415,858$ 10,694,638$ 5,517,322$ 6,700,944$ 1,183,623 21.5%
1Facilities was included in Community Services Admin and Technical Services was included in Public Works Admin in 2009
Summary of Sources and Uses Annual Actual YTD Actual Favorable (Unfavorable)
2009 2010 2011 Variance
Annual Actual YTD Actual Annual Budget YTD Budget YTD Actual
Monthly Financial Report February 2011
Page 1 of 36
Monthly Financial Report February 2011
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through February 28, 2011. 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 74% 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 $336k,
making the total year‐to‐date
collection $841k or 3% of the total
budget. $129k of January’s
collection is actually collected by
King County but wasn’t yet
distributed to the City at the end
of 2010. Excluding this amount
and the 1% change, the City is
$223k or 46% ahead of prior year
and $214k or 43% over the
budget.
Sales Tax
February 2011 sales tax receipts
totaled $2.0 million. Compared to
the same month last year, it is $254k
or 15% more. Compared to the
projected current month’s budget, it
is above projections by $288k or
17%. The year‐to‐date collection is
$3.3 million or 19% of the sales tax
budget, which is $304k or 10% more
than the prior year and also $259k or
8% higher than the budget. Based
on the year‐to‐date collection, the
City projected sales tax revenues to
be $18 million by the end of 2011.
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 218,705$ 222,520$ 505,501$ 286,797$ 131% 282,981$ 127%
Feb 270,809 275,532 336,193 65,385 24% 60,661 22%
Mar 547,632 557,184
Apr 6,660,829 6,777,012
May 8,736,691 8,889,083
Jun 114,982 116,988
Jul 87,952 89,486
Aug 149,160 151,761
Sep 491,642 500,217
Oct 7,060,074 7,183,221
Nov 7,288,083 7,029,490
Dec (129,429) 254,031
YTD Total 489,513$ 498,052$ 841,695$ 352,181$ 72% 343,643$ 69%
Annual Total 31,497,128$ 32,046,525$
Property Tax Revenues
Year to Date through February
2011 vs. 2010 2011 vs. Budget
Month
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 1,289,364$ 1,368,563$ 1,339,658$ 50,295$ 4% (28,905)$ ‐2%
Feb 1,728,588 1,694,761 1,982,269 253,682 15% 287,508 17%
Mar 1,289,589 1,287,665 ‐
Apr 1,461,123 1,310,854 ‐
May 1,499,335 1,507,510 ‐
Jun 1,382,049 1,417,926 ‐
Jul 1,309,429 1,473,254 ‐
Aug 1,470,881 1,609,937 ‐
Sep 1,408,876 1,477,231 ‐
Oct 1,447,338 1,529,414 ‐
Nov 1,508,617 1,569,580 ‐
Dec 1,403,032 1,512,904 ‐
YTD Total 3,017,952$ 3,063,324$ 3,321,928$ 303,976$ 10% 258,603$ 8%
Annual Total 17,198,220$ 17,759,600$
2011 vs. Budget2011 vs. 2010
Month
Year to Date through February
Local Retail Sales Tax Revenues
Page 2 of 36
Monthly Financial Report February 2011
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 2010 2011 Bgt YTD Act Change 2011/2010 2011 Act vs Bgt
New Construction 319,258$ 290,039$ 273,159$ (46,099)$ ‐14%$ (16,880)‐6%
Auto Sales 495,355 522,980 537,537 42,182 9% 14,557 3%
General Retail 1,145,209 1,182,389 1,154,748 9,539 1% (27,641)‐2%
Manufacturing 165,250 156,652 371,387 206,137 125% 214,735 137%
Wholesale 170,441 188,642 196,181 25,740 15% 7,539 4%
Service 640,763 615,592 699,570 58,807 9% 83,978 14%
Other 81,675 107,031 89,346 7,670 9% (17,685)‐17%
Total 3,017,952$ 3,063,324$ 3,321,928$ 303,976 10%258,603$ 8%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility tax
February utility tax revenues are $1.4
million, which is $203k or 16% higher
than the same month last year and also
ahead of the budget by $146k or 11%.
The year‐to‐date collection is $2.8
million, which is $173k or 7% higher
than the prior year and is also $60k or
2% higher than the budget. Based on
collections so far the City is projecting
utility taxes to meet the 2011 budget at
the end of the year.
The table below breaks out Utility Tax
by source:
Utility Tax by Type 2010 2011 Bgt YTD Act Change 2011/2010 2011 Act vs Bgt
Electrical 960,877$ 947,732$ 961,417$ 540$ 0%$ 13,685 1%
Natural Gas 475,832 503,478 524,113 48,281 10% 20,635 4%
Cell 323,057 322,378 359,479 36,421 11% 37,100 12%
Phone 181,636 174,985 168,190 (13,446) ‐7% (6,795)‐4%
Cable 218,605 230,313 196,580 (22,025) ‐10% (33,734)‐15%
Transfer Station 27,925 24,629 42,655 14,730 53% 18,026 73%
City Utilities 449,931 548,263 558,864 108,933 24% 10,601 2%
YTD Total 2,637,863$ 2,751,779$ 2,811,298$ 173,435$ 7%59,519$ 2%
Annual Total 14,508,363$ 15,166,600$
YTD as % of 18% 18%
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 1,392,232$ 1,449,257$ 1,363,023$ (29,209)$ ‐2% (86,234)$ ‐6%
Feb 1,245,631 1,302,522 1,448,275 202,644 16% 145,753 11%
Mar 1,295,732 1,346,959
Apr 1,260,110 1,321,643
May 1,231,700 1,281,842
Jun 1,165,188 1,221,180
Jul 1,140,413 1,193,031
Aug 1,131,693 1,190,578
Sep 1,082,231 1,136,760
Oct 1,138,457 1,193,046
Nov 1,112,608 1,157,583
Dec 1,312,366 1,372,199
YTD Total 2,637,863$ 2,751,779$ 2,811,298$ 173,435$ 7% 59,519$ 2%
Annual Total 14,508,363$ 15,166,600$
2011 vs. Budget2011 vs . 2010
Year to Date through February
Utility Tax Revenues
Month
Page 3 of 36
Monthly Financial Report February 2011
Other Taxes
Real Estate Excise Tax
The City collected $100k in Real Estate
Excise Tax revenues (REET) in February.
This is $2k or 2% above current month’s
budget and $8k or 7% behind the same
month last year. The year‐to‐date
collection is $262k or 12% of the total
budget, which is $83k or 47% more than
the prior year and is also $99k or 61%
above the budget. Based on the
collections so far, the City is projecting
REET to meet the 2011 budget by year‐
end.
Gambling Tax
February’s Gambling Tax
collections total $136k. Year‐to‐
date total of $254k is $19k or 7%
below the year before and is also
$29k or 10% below budget.
The lower tax collection is due to
cross‐the‐board reduction in
gambling activities. Pull tabs
overall reduced by 2% bingo
reduced by 49%, and card‐rooms
are seeing 11% lower in activities
when compared to the prior year.
Franchise Fees
Franchise Fees are due quarterly
and the year‐to‐date revenue
collections are $306k. This is $25k
or 7% below the projected year‐
to‐date budget and $15k or 5%
lower than 2010.
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 71,303$ 64,842$ 161,911$ 90,608$ 127% 97,069$ 150%
Feb 107,242 97,524 99,677 (7,565) ‐7% 2,153 2%
Mar 309,164 281,121
Apr 281,746 256,194
May 216,814 197,233
Jun 191,741 174,436
Jul 149,706 136,195
Aug 209,369 190,471
Sep 123,054 111,936
Oct 183,333 176,560
Nov 203,091 184,761
Dec 417,925 368,726
YTD Total 178,545$ 162,366$ 261,588$ 83,043$ 47% 99,222$ 61%
Annual Total 2,464,489$ 2,240,000$
Month
2011 vs. Budget2011 vs . 2010
Real Estate Excise Tax Revenues
Year to Date through February
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 135,608$ 140,310$ 118,304$ (17,304)$ ‐13% (22,005)$ ‐16%
Feb 137,736 142,512 135,926 (1,811) ‐1% (6,586) ‐5%
Mar 63,054 65,240 ‐
Apr 196,085 202,883 ‐
May 133,979 138,624 ‐
Jun 142,790 147,741 ‐
Jul 125,614 129,969 ‐
Aug 138,563 143,368 ‐
Sep 105,323 108,974 ‐
Oct 126,396 130,779 ‐
Nov 121,757 125,978 ‐
Dec 119,481 123,624 ‐
YTD Total 273,344$ 282,821$ 254,230$ (19,114)$ ‐7% (28,591)$ ‐10%
Annual Total 1,546,386$ 1,600,000$
Gambling Tax Revenue
Month
Year to Date through February
2011 vs. 2010 2011 vs. Budget
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 320,478$ 330,324$ 305,646$ (14,833)$ ‐5% (24,678)$ ‐7%
Apr 274,268 282,694 ‐
Jul 286,523 295,326 ‐
Aug 6,691 6,896 ‐
Oct 289,316 298,204 ‐
Dec 45,169 46,556 ‐
YTD Total 320,478$ 330,324$ 305,646$ (14,833)$ ‐5% (24,678)$ ‐7%
Annual Total 1,222,444$ 1,260,000$
Franchise Fees Revenue
Year to Date through February
Month
2011 vs. 2010 2011 vs. Budget
Page 4 of 36
Monthly Financial Report February 2011
Admission Tax
Admission Tax returns are due
quarterly in January, April, July,
and October each year. January
2011 collections represent
activities conducted during the 4th
quarter of 2010.
The report shows a decrease of
$4k or 6% from the year before
and also a $1k or 2% less than
anticipated.
Building Permits and Development Service Fees
Building Permits and Development
Service Fee revenues totaled $142k in
February. The revenue swing between
the high in January 2010 and the low in
February 2010 is primarily attributable
to the rush of getting permits completed
prior to the new school impact fees
taking effect. The year‐to‐date
development fees revenue of $274k is
$281k or 51% less than the budget and is
also $213k or 44% lower than 2010.
Business Licenses totaled $23k for February,
which is $10k or 31% below the same month last
year and is also $13k or 35% below the current
month’s budget. The year‐to‐date Business
Licenses revenue is under the budget by $12k or
10% and is also $4k or 4% below last year.
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 74,777$ 71,852$ 70,405$ (4,372)$ ‐6% (1,447)$ ‐2%
Feb 459 441 477 18 4% 35 8%
Apr 66,119 63,533 ‐
Jul 76,024 73,050 ‐
Aug 485 466 ‐
Oct 73,073 70,215 ‐
Nov 462 444 ‐
YTD Total 75,236$ 72,293$ 70,881$ (4,355)$ ‐6% (1,412)$ ‐2%
Annual Total 291,399$ 280,000$
Admission Tax Revenue
Year to Date through February
Month
2011 vs. 2010 2011 vs. Budget
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 77,955$ 83,603$ 84,109$ 6,154$ 8% 506$ 1%
Feb 33,440 35,863 23,153 (10,287) ‐31% (12,710) ‐35%
Mar 5,687 6,099 ‐
Apr 77,964 83,612 ‐
May 21,558 23,120 ‐
Jun 4,709 5,051 ‐
Jul 83,201 89,230 ‐
Aug 14,782 15,853 ‐
Sep 4,475 4,799 ‐
Oct 83,639 89,699 ‐
Nov 22,288 23,903 ‐
Dec 2,084 2,235 ‐
YTD Total 111,395$ 119,466$ 107,262$ (4,133)$ ‐4% (12,204)$ ‐10%
Annual Total 431,782$ 463,067$
2011 vs. 2010
Year to Date through February
2011 vs. Budget
Business Licenses
Month
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 394,165$ 454,717$ 132,621$ (261,545)$ ‐66% (322,096)$ ‐71%
Feb 93,037 100,788 141,672 48,634 52% 40,884 41%
Mar 172,096 188,567
Apr 180,514 207,481
May 221,843 238,569
Jun 210,810 240,300
Jul 319,462 336,067
Aug 167,001 194,145
Sep 158,882 183,653
Oct 223,901 232,210
Nov 125,748 143,854
Dec 169,811 185,693
YTD Total 487,202$ 555,505$ 274,292$ (212,910)$ ‐44% (281,212)$ ‐51%
Annual Total 2,437,270$ 2,706,044$
Building Permits and Development Se rvice Fees
Year to Date through February
2011 vs. Budget2011 vs. 2010
Month
Page 5 of 36
Monthly Financial Report February 2011
Intergovernmental
These revenue sources
include federal (direct
and indirect) grants,
state grants, state
shared revenues, local
grants, and
entitlements. State
shared revenues and
Fire Districts’ 25 and 40
contracts compose 66%
of the total revenues in this category. The year‐to‐date total Intergovernmental revenue is $1 million or 9% of the budget.
All grant revenues also have corresponding expenditures which will be added to the City’s budget through the 2011 carry
forward budget adjustment.
State Shared Revenue
collections totaled $579k
since the start of 2011.
Compared to the projected
budget, State Shared
Revenues are above by $34k
or 6%. Compared to the
prior year, the City is
collecting $48k more. The
actual collection that lags
budget is primarily due to the
reduced criminal justice sales
tax (King County countywide
sales tax decrease). The City
is projecting State Shared Revenues to meet the 2011 budget by the end of the year.
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 79% of the total revenue in this category. The year‐to‐date total charges for services are $786k or 12% of the
budget. This is 11% below budget projections. The following sections provide detail information for Public Safety,
Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totaled $60k since the
start of the year. These services include
private security, adult probation services,
and housing/monitoring of prisoners.
Compared to the budget, the City is
collecting $1k or 2% more than anticipated
revenue. Compared to the prior year, the
City is collecting $6k or 9% less. The City is
projecting Public Safety Service revenues to
meet the 2011 projected budget by year‐
end.
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 35,994$ 31,795$ 18,824$ (17,169)$ ‐48% (12,971)$ ‐41%
Feb 29,971 26,475 40,902 10,931 36% 14,427 54%
Mar 34,786 30,728 ‐
Apr 47,687 42,125 ‐
May 36,393 32,148 ‐
Jun 27,093 23,933 ‐
Jul 57,010 50,360 ‐
Aug 34,206 30,217 ‐
Sep 42,316 37,380 ‐
Oct 39,487 34,881 ‐
Nov 24,065 21,258 ‐
Dec 73,334 64,780 ‐
YTD Total 65,965$ 58,271$ 59,726$ (6,239)$ ‐9% 1,456$ 2%
Annual Total 482,343$ 426,081$
Month
2011 vs. 2010
Year to Date through February
Public Safety Services
2011 vs. Budget
Intergovernmental 2010 2011 Bgt YTD Act Change 2011/2010 2011 Act vs Bgt
Fire District #25 ‐$ 135,462$ 135,462$ 135,462$ 100% $ ‐ 0%
Fire District #40 19,525 1,173 1,173 (18,352) ‐94%‐ 0%
State Shared Revenue 530,428 544,633 578,584 48,156 9% 33,951 6%
Federal Grants 219,341 162,600 162,600 (56,740) ‐26%‐ 0%
State Grants 86,276 38,605 38,605 (47,671) ‐55%‐ 0%
Other Grants 51,218 37,303 37,303 (13,916) ‐27%‐ 0%
ARRA Grants 116,903 125,916 125,916 9,013 8%‐ 0%
Total Rev YTD 1,023,691$ 1,045,692$ 1,079,643$ 55,952$ 5%33,951$ 3%
Total Rev Annual 11,300,032$ 10,976,730$
YTD %9% 10% 10%
Note: Includes CJ Sales Tax.
2010 2011 2011
Actual Budget Actual $ % $ %
Crim Just Sales Tax 295,109$ 328,531$ 306,150$ 11,041$ 4% (22,381)$ ‐7%
Judicial Contribution 11,549 4,862 ‐ (11,549)$ 0% (4,862) 0%
Crim Just ‐ High Crime ‐ ‐ 47,179 47,179 100% 47,179 100%
Crim Just ‐ Pop 4,619 ‐ 4,821 202 4% 4,821 100%
Crim Just ‐ Spec Prog 17,557 16,524 18,203 646 4% 1,680 10%
State DUI 3,942 3,744 3,924 (18) 0% 180 5%
Liquor Profits ‐ ‐ ‐ ‐ N/A ‐ N/A
Liquor Excise Tax 103,016 103,051 104,651 1,636 2% 1,601 2%
Fuel Tax 94,636 87,922 93,655 (981) ‐1% 5,733 7%
YTD Total 530,428$ 544,633$ 578,584$ 48,156$ 9% 33,951$ 6%
Annual Total 4,189,298$ 3,874,444$
2011 vs. Budget
State Shared Revenues
2011 vs. 2010
Revenue
Year to Date through February
Page 6 of 36
Monthly Financial Report February 2011
Recreation
Recreation revenues totaled $82k for the
current month. Compared to the
projected monthly budget, the City
collected $8k or 11% more. Compared to
the same month the prior year, the City
collected $18k or 27% more. The year‐to‐
date collection of $144k is $17k or 13%
more than the prior year but $1k or 1%
less than the budget. The City is
projecting Recreation revenues to meet
the 2011 budget by year‐end.
Interfund Services
The year‐to‐date collections for Interfund
Services revenues are $474k. Compared
to the projected budget, the revenues are
below by $63k or 12%. Compared to the
prior year, the revenues are under by $43k
or 8%. The majority of these revenues are
related to indirect cost allocations, which
are internal administrative costs. The
remaining costs consists of Development
Services division’s inspection fees,
Transportation division’s capital
investment program reimbursements, and
Maintenance division’s street
maintenance reimbursements.
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 $427k. This is $40k or 9%
lower than a year ago and also $7k or
2% under budget. This difference also
includes $38k lower than budgeted
Seizure Funds received this year. The
use of Seizure Funds is restricted to
drug enforcement only and not
available for general operating
purposes. The table on the next page
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 62,673$ 71,626$ 61,933$ (740)$ ‐1% (9,693)$ ‐14%
Feb 64,915 74,189 82,497 17,582 27% 8,309 11%
Mar 99,100 113,257 ‐
Apr 152,452 174,230 ‐
May 83,760 95,725 ‐
Jun 193,082 220,664 ‐
Jul 280,956 321,091 ‐
Aug 181,356 207,263 ‐
Sep 111,952 127,945 ‐
Oct 77,544 88,621 ‐
Nov 51,672 59,054 ‐
Dec 65,469 74,822 ‐
YTD Total 127,588$ 145,815$ 144,430$ 16,842$ 13% (1,384)$ ‐1%
Annual Total 1,424,932$ 1,628,486$
Recreation
Year to Date through February
2011 vs. Budget2011 vs. 2010
Month
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 242,658$ 252,068$ 190,881$ (51,777)$ ‐21% (61,187)$ ‐24%
Feb 273,674 284,288 282,743 9,068 3% (1,545) ‐1%
Mar 249,758 259,444 ‐
Apr 348,019 361,516 ‐
May 269,154 279,591 ‐
Jun 275,850 286,548 ‐
Jul 263,285 273,495 ‐
Aug 248,584 258,224 ‐
Sep 238,713 247,970 ‐
Oct 241,403 250,765 ‐
Nov 255,986 265,913 ‐
Dec 283,824 294,831 ‐
YTD Total 516,332$ 536,356$ 473,624$ (42,709)$ ‐8% (62,732)$ ‐12%
Annual Total 3,190,908$ 3,314,653$
2011 vs. 2010 2011 vs. Budget
Month
Interfund Services
Year to Date through February
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 239,080$ 223,938$ 165,721$ (73,360)$ ‐31% (58,218)$ ‐26%
Feb 228,332 210,821 261,655 33,322 15% 50,833 24%
Mar 279,311 259,871
Apr 294,612 273,484
May 276,543 257,620
Jun 373,623 347,746
Jul 256,225 239,290
Aug 319,267 286,019
Sep 231,632 208,702
Oct 267,539 247,930
Nov 314,160 297,164
Dec 352,044 317,767
YTD Total 467,413$ 434,759$ 427,375$ (40,037)$ ‐9% (7,384)$ ‐2%
Annual Total 3,432,368$ 3,170,351$
2011 vs. Budget2011 vs . 2010
Year to Date through February
Fines and Penalties by Month
Month
Page 7 of 36
Monthly Financial Report February 2011
breaks out Fines and Penalties by type:
Year to Date through February
2010 2011 2011
Actual Budget Actual $ % $ %
Civil Penalties 994$ 918$ 1,578$ 584$ 59% 660$ 72%
Civil Infraction Penalties 55,603 50,258 63,022 7,419 13% 12,764 25%
Civil Parking Infraction Penalties 14,299 14,716 10,124 (4,175) ‐29% (4,592) ‐31%
Photo Enforcement Program 322,846 318,779 329,628 6,783 2% 10,849 3%
Criminal Traffic Misdemeanor Fines 8,482 7,758 8,800 318 4% 1,042 13%
Criminal Non‐Traffic Fines 1,752 1,786 3,416 1,664 95% 1,630 91%
Criminal Costs 7,193 754 10,782 3,589 50% 10,028 1330%
Seizure Funds ‐ Federal/State/Local 46,627 38,115 ‐ (46,627) 0% (38,115) 0%
Non‐Court Fines, Forfeitures and Penalties 9,616 1,675 25 (9,591) ‐100% (1,650) ‐99%
YTD Total 467,413$ 434,759$ 427,375$ (40,037)$ ‐9% (7,384)$ ‐2%
Annual Total 3,432,368$ 3,170,351$
2011 vs. Budget
Fines and Penalties by Type
Revenue
2011 vs. 2010
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 $330k. The associated costs
includes the equipment provided by American
Traffic Solutions Inc (ATS), we are also dedicating 2
FTEs in the Court Division to process the increased
caseload and 1.1 FTEs in the Police Department for
support services. These staff’s 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 86% of the total revenue in
this category. The year‐to‐date total
miscellaneous is $213k. Compared to the
projected year‐to‐date budget, the
revenues are under by $65k or 23%.
Compared to last year, the revenues are
under by $44k or 17%. The table on the
next page breaks out Miscellaneous
revenues by type:
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 170,998$ 180,108$ 143,105$ (27,892)$ ‐16% (37,003)$ ‐21%
Feb 86,124 98,237 70,237 (15,887) ‐18% (28,000) ‐29%
Mar 115,122 124,873
Apr 99,376 111,876
May 101,909 113,638
Jun 148,339 168,762
Jul 158,134 166,028
Aug 93,081 106,676
Sep 110,810 110,821
Oct 73,018 87,097
Nov 56,175 66,475
Dec 56,503 63,069
YTD Total 257,122$ 278,345$ 213,343$ (43,780)$ ‐17% (65,003)$ ‐23%
Annual Total 1,269,588$ 1,397,659$
Year to Date through Fe bruary
Month
2011 vs. Budget2011 vs. 2010
Miscellaneous Revenues by Month
Favorable
Budget Actual Budget Actual (Unfavorable)
1
Jan 184,922$ 165,696$ 76,201$ 67,883$ 97,812$
Feb 133,857 163,932 76,693 67,885 96,048
Mar 170,080 ‐ 76,201 ‐ ‐
Apr 160,472 ‐ 53,048 ‐ ‐
May 154,236 ‐ 71,882 ‐ ‐
Jun 215,118 ‐ 71,871 ‐ ‐
Jul 144,584 ‐ 72,275 ‐ ‐
Aug 126,504 ‐ 56,688 ‐ ‐
Sep 90,979 ‐ 71,527 ‐ ‐
Oct 158,357 ‐ 71,420 ‐ ‐
Nov 208,633 ‐ 71,884 ‐ ‐
Dec 153,166 ‐ 72,273 ‐ ‐
YTD Total 318,779$ 329,628$ 152,894$ 135,768$ 193,860$
Annual Total 1,900,908$ 841,964$
1 Actuals of Revenues and Expenses
Expenses
Photo Enforcement Program
Year to Date through February
Month
Page 8 of 36
Monthly Financial Report February 2011
2010 2011 2011
Actual Budget Actual $ % $ %
Interests and Other Earnings 46,329$ 67,569$ 22,280$ (24,049)$ ‐52% (45,289)$ ‐67%
Rents, Leases, and Concessions 186,375 179,095 160,887 (25,488) ‐14% (18,209) ‐10%
Contributions/Donations from Private Sources 6,455 4,826 30,480 24,025 372% 25,654 532%
Other 17,963 26,855 (304) (18,267) ‐102% (27,159) ‐101%
YTD Total 257,122$ 278,345$ 213,343$ (43,780)$ ‐17% (65,003)$ ‐23%
Annual Total 1,269,588$ 1,397,659$
2011 vs. Budget
Miscellaneous Revenues by Type
Year to Date through February
Revenue
2011 vs. 2010
EXPENSES
Overall the City has expended 16% of its budgeted general governmental expenditures at the end of February. This is
$904k or 5.4% below year‐to‐date budgeted expenditures. While some of these savings would be realized at the end of the
year, others are due to the timing of the payments. Below are the explanations for some of the large variances on the
expenditures.
The Economic Development division of Community and Economic Development Department appears to be over budget by
$12k. This is due to contributing the 2011 Marketing Campaign ($15k) earlier in 2011 than in 2009 (March) and 2010
(February) and earlier payment for the 2011 Public Sector Partnership membership with Enterprise Seattle (2010’s payment
was in April).
The Planning division of Community and Economic Development Department appears to be over budget by $52k. This is
due to the timing of professional services contract payments made in 2009 and 2010 compared to 2011. Payments were
made later in the year for 2009 and 2010 and therefore would skew the current 2011 year‐to‐date budget. The year‐to‐
date budget will correct itself in May and August.
The Recreation division of Community Services Department is over budget by $70k. This is due to a prior period payment
($28k for 2009) for natural gas for the Henry Moses Aquatic Center. We will monitor their budget to determine if a budget
adjustment is necessary to cover the possibility of exceeding budget at year‐end.
Page 9 of 36
Monthly Financial Report February 2011
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
Bond/Rate
Stabilization
Funds
REVENUES:
Licenses and permits ‐ ‐ ‐ ‐ 3,840 3,400 ‐
Grants 4,895 ‐ ‐ ‐ ‐ 667 ‐
Charges for services 20,042 113,045 2,461,952 1,720,647 2,970,575 991,062 ‐
Interdepartmental services ‐ ‐ ‐ 33,115 19,009 55,049 ‐
Fines and penalties ‐ ‐ ‐ ‐ ‐ ‐ ‐
Rents, leases, and misc fees 377,054 24,688 11,908 29,578 ‐ ‐ ‐
Interest and other misc 1,093 503 5,690 110,684 84,562 47,292 10
TOTAL REVENUES 403,084 138,236 2,479,550 1,894,024 3,077,986 1,097,470 10
EXPENSES:
Utility billing ‐ ‐ 19,066 41,236 13,390 21,103 ‐
Utility systems ‐ ‐ 1,753,044 461,393 394,391 356,359 ‐
Utility maintenance ‐ ‐ 45,071 654,698 2,309,494 255,225 ‐
Transportation 166,746 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 237,291 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 166,746 237,291 1,817,181 1,157,327 2,717,275 632,687 ‐
AMOUNT AVAILABLE FOR DEBT SERVICE 236,338 (99,055) 662,369 736,697 360,711 464,783 10
DEBT SERVICE:
Principal ‐ 3,969 ‐ ‐ ‐ ‐ ‐
Interest and other debt service costs ‐ 76 ‐ ‐ ‐ ‐ ‐
TOTAL DEBT SERVICE ‐ 4,045 ‐ ‐ ‐ ‐ ‐
CAPITAL PROJECTS 69,571 ‐ ‐ 146,999 370,765 169,590 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 166,767 (103,100) 662,369 589,698 (10,054) 295,193 10
BEGINNING FUND BALANCE, January 1, 2011 1,361,349 888,604 961,788 6,759,754 1,353,232 3,273,863 15,773
ENDING FUND BALANCE, February 28, 2011 1,528,116 785,504 1,624,157 7,349,452 1,343,178 3,569,056 15,783
Page 10 of 36
Monthly Financial Report February 2011
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 ‐ 5,945 ‐ ‐ ‐ ‐ ‐
Grants ‐ ‐ 145,179 ‐ ‐ ‐ ‐
Charges for services
Equipment rental m&o 356,205 345,200 ‐ ‐ ‐ ‐ ‐
Telecommunications ‐ 63,274 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 17,765 ‐ 65,392 ‐ ‐ ‐
Communications ‐ ‐ ‐ 95,921 ‐ ‐ ‐
Facilities ‐ ‐ 686,156 ‐ ‐ ‐ ‐
Data cards and ce ll phones ‐ 25,016 ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ 52,242 ‐ ‐ ‐ ‐ ‐
Interest and other misc 3,507 1,373 216 56 3,635 4,061 2,457
Internal service fund misc:
Vehicle/equipment capital recovery 186,441 156,451 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 259,349 ‐ ‐
Worker's compensation / unemployment ‐ ‐ ‐ ‐ 220,088 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 1,719,383 1,111,002
Other misc 423 1,050 1,673 ‐ 18 108,507 ‐
Capital contributions 1,884 ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets 74,955 ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 9,731 3,177 ‐
TOTAL REVENUES 623,415 668,316 833,224 161,369 492,821 1,835,128 1,113,459
EXPENSES:
Communications 87,754
Equipment rental 301,362
Facilities 669,217
Healthcare 1,462,008
Information technology 461,779
Print and mail 64,692
Retiree healthcare 109,584
Risk management
Risk management 713,137
Unemployment 26,847
Worker's compensation 264,505
TOTAL EXPENSES 301,362 461,779 669,217 152,446 1,004,489 1,462,008 109,584
AMOUNT AVAILABLE FOR CAPITAL 322,053 206,537 164,007 8,923 (511,668) 373,120 1,003,875
CAPITAL PROJECTS 11,135 32,620 32,155 ‐ ‐ ‐ ‐
TRANSFERS IN ‐ ‐ ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 310,918 173,917 131,852 8,923 (511,668) 373,120 1,003,875
BEGINNING FUND BALANCE, January 1, 2011 5,293,107 1,949,165 241,046 70,214 6,690,024 6,201,894 3,371,037
ENDING FUND BALANCE, February 28, 2011 5,604,025 2,123,082 372,898 79,137 6,178,356 6,575,014 4,374,912
Page 11 of 36
Monthly Financial Report February 2011
FUND BALANCE
Page 13 shows the ending fund balance as of February 2011. The City’s fund balance is a combination of current
deficit/surplus of funds which have accrued from unexpended operating budgets and unanticipated excess revenues and
from balances accumulated from prior years.
The prior year’s balances (or beginning balance) includes 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.7 million reported in combined general governmental fund balance of the current
year’s operating budget, which is approximately 7% of budgeted operating expenditures. This is a decrease of $4.7 million
from the beginning balance of January 1, 2011. February’s ending fund balance is over the anticipated General
Governmental Fund Balance of $5.5 million by $1.2 million. 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 2011 property taxes in April and May. We
expect the fund balance to decrease but be in line with the projected fund balance after May and continue to decrease until
we receive the second half of 2011 property taxes in October and November.
CONTACT INFORMATION
This report is prepared by the Finance Division of the FIT 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 iwang@rentonwa.gov.
Page 12 of 36
Monthly Financial Report February 2011
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through February 28, 2011
Funds
Balance
01/01/2011
Budgeted
Revenue
Revenue
02/28/11
Total Funds
Available
Budgeted
Expenditure
Expenditure
02/28/11 Ending Balance
GENERAL GOVERNMENT FUNDS:11,407,119 98,221,926 11,050,240 22,457,359 98,934,406 15,756,417 6,700,942
000 General 9,477,148 71,689,933 8,470,056 17,947,204 72,568,621 12,692,497 5,254,707
001 Community Services 631,801 10,817,691 1,299,762 1,931,563 10,742,324 1,439,650 491,913
003 Street 116,298 8,391,801 806,794 923,092 8,293,144 1,287,106 (364,014)
004 Community Dev Block Grant (55,231) 304,000 117,332 62,101 304,000 40,332 21,769
005 Museum 66,830 195,966 21 66,851 208,407 34,638 32,213
006 Library 47,347 2,030,000 29 47,376 2,030,000 5,119 42,257
009 Farmers Market 81,630 52,500 950 82,580 47,875 1,467 81,113
010 Fire Memorial 1,251 ‐ 620 1,871 ‐ ‐ 1,871
011 Fire Health & Wellness 24,072 25,000 3,887 27,959 25,000 690 27,269
031 Pa rk Memorial 176,950 ‐ 109 177,059 ‐ ‐ 177,059
201 Ltd GO Bonds Gen Govt Debt 312,938 1,983,075 80,694 393,632 1,983,075 ‐ 393,632
215 Gen Govt Misc Debt Service 526,085 2,731,960 269,986 796,071 2,731,960 254,918 541,153
SPECIAL REVENUE FUNDS:
102 Arterial Street 171,720 620,000 199,192 370,912 620,000 ‐ 370,912
108 Leased City Properties 759,594 744,933 67,364 826,958 614,457 58,018 768,940
110 Hotel Motel 212,950 245,000 93,576 306,526 245,000 30,186 276,340
118 Reserve for Paths & Trails 3,299 ‐ 2 3,301 ‐ ‐ 3,301
125 1% For Art 136,830 15,000 84 136,914 50,000 ‐ 136,914
127 Cable Communication 171,358 85,000 53,922 225,280 85,674 2,012 223,268
135 Springbrook Wetlands Bank 660,524 ‐ 411 660,935 ‐ ‐ 660,935
DEBT SERVICE FUNDS:
219 1989 Unlimited GO Bonds ‐ ‐ ‐ ‐ ‐ ‐ ‐
CAPITAL PROJECT FUNDS (CIP):
303 Community Dev Mitigation 1,343,877 60,000 6,675 1,350,552 400,000 ‐ 1,350,552
304 Fire Mitigation 1,929,477 100,000 21,214 1,950,691 529,056 ‐ 1,950,691
305 Transportation Mitigation 1,119,954 250,000 46,384 1,166,338 499,494 ‐ 1,166,338
316 Municipal Facilities CIP 5,759,297 13,310,000 50,698 5,809,995 14,962,000 120,692 5,689,303
317 Transportation CIP 3,808,080 10,657,819 1,245,433 5,053,513 11,647,819 1,153,530 3,899,983
318 So Lake WA Infrastructure Proj 58,522 ‐ 36 58,558 ‐ ‐ 58,558
326 Housing Opportunity 163,787 ‐ 82 163,869 ‐ 17,500 146,369
ENTERPRISE FUNDS:
402 Airport 1,295,036 636,214 398,208 1,693,244 1,125,756 166,746 1,526,498
403 Solid Waste Utility 961,788 15,015,942 2,479,549 3,441,337 14,951,710 1,817,181 1,624,156
404 Golf Course 630,924 2,483,545 138,059 768,983 2,504,738 258,005 510,978
422 Airport Capital 66,313 2,803,204 4,876 71,189 2,803,204 69,571 1,618
424 Golf Course Capital 257,680 100,000 16,848 274,528 100,000 ‐ 274,528
INTERNAL SERVICE FUNDS:
501 Equipment Repair/Replacement 5,293,107 3,211,401 623,415 5,916,522 3,195,267 312,497 5,604,025
502 Insurance 6,690,024 3,178,883 492,821 7,182,845 3,293,564 1,004,489 6,178,356
503 Information Services 1,949,165 4,029,664 668,316 2,617,481 4,513,461 494,399 2,123,082
504 Facilities 241,046 4,243,673 833,224 1,074,270 4,256,261 701,372 372,898
505 Communications 70,214 953,941 161,369 231,583 957,746 152,446 79,137
512 Insurance, Healthcare 6,201,894 11,248,058 1,835,128 8,037,022 10,844,696 1,462,008 6,575,014
522 Insurance, Leoff1 Retirees HC 3,371,037 2,235,684 1,113,459 4,484,496 2,261,732 109,584 4,374,912
FIDUCIARY FUNDS:
611 Firemen's Pension 4,286,248 300,000 976 4,287,224 565,475 51,449 4,235,775
Funds
Balance
01/01/2011
Budgeted
Revenue
Revenue
02/28/11
Total Funds
Available
Budgeted
Expenditure
Expenditure
02/28/11 Ending Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 11,402,622 44,828,741 6,069,490 17,472,112 44,901,718 5,194,644 12,277,468
405 Water Utility 4,695,116 9,680,689 1,797,564 6,492,680 10,107,179 1,157,327 5,335,353
406 Waste Water Utility 681,616 4,896,139 1,031,788 1,713,404 4,831,929 612,804 1,100,600
407 Surface Water Utility 1,462,126 5,155,153 1,050,615 2,512,741 4,865,850 632,687 1,880,054
416 King County Metro 671,616 13,156,760 1,963,947 2,635,563 13,156,760 2,104,472 531,091
425 Water Utility Construction 2,064,638 4,500,000 96,460 2,161,098 4,500,000 146,999 2,014,099
426 Waste Water Construction ‐ 3,790,000 82,251 82,251 3,790,000 370,765 (288,514)
427 Surface Water Construction 1,811,737 3,650,000 46,855 1,858,592 3,650,000 169,590 1,689,002
461 Waterworks Bond Reserve ‐ ‐ ‐ ‐ ‐ ‐ ‐
471 Waterworks Rate Stabilization 15,773 ‐ 10 15,783 ‐ ‐ 15,783
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,407,119
January 5,379,006 6,990,159 (1,611,153) 9,795,966
February 11,050,241 15,756,416 (4,706,175) 6,700,944
March
April
May
June
July
August
September
October
November
December
1 000 000
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
DifferenceRev/Exp Revenues
Expenditures
Difference
(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
2,000,000
3,000,000
4,000,000
5,000,000
6,000,000
7,000,000
8,000,000
9,000,000
‐
10,000,000
20,000,000
30,000,000
40,000,000
50,000,000
60,000,000
70,000,000
80,000,000
90,000,000
100,000,000
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
DifferenceRev/Exp Revenues
Expenditures
Difference
Page 14 of 36
City of Renton
Monthly Revenue Analysis ‐ 2011 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 5,631,529 5,379,006 ‐4.48%
Feb 10,771,029 11,050,241 2.59%
Mar 15,884,173
Apr 27,942,282
May 42,549,255
Jun 49,800,142
Jul 55,719,872
Aug 61,047,279
Sep 65,931,906
Oct 78,458,589
Nov 92,742,572
Dec 98,221,926
Percent of budget 11.25%
Property Tax Budget
YTD
Actual
Annual %
over (under)
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
Millions
Total Revenue
General Government
Budget
Actual
Last Year
$30
$33
Millions Property Tax
Budget
Actual
py g ()
Jan 222,520 505,501 127.17%
Feb 498,052 841,695 69.00%
Mar 1,055,236
Apr 7,832,248
May 16,721,331
Jun 16,838,319
Jul 16,927,805
Aug 17,079,566
Sep 17,579,783
Oct 24,763,004
Nov 31,792,494
Dec 32,046,525
Percent of budget 2.63%
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
Millions Total Revenue
General Government
Budget
Actual
Last Year
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
Millions Property Tax
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,528,973 1,498,057 ‐2.02%
Feb 3,438,716 3,683,690 7.12%
Mar 4,885,730
Apr 6,370,390
May 8,061,144
Jun 9,648,275
Jul 11,286,739
Aug 13,079,043
Sep 14,729,086
Oct 16,438,028
Nov 18,193,943
Dec 19,879,280
Percent of budget 18.53%
Note: Excludes CJ Sales Tax and Natural Gas Use Tax.
Utility Tax Budget
YTD
Actual
Annual %
over (under)
$‐
$3
$6
$9
$12
$15
$18
$21
Millions Sales Tax
Budget
Actual
Last Year
$14
$16
Millions Utility Tax
Budget
Actual
y g ()
Jan 1,449,257 1,363,023 ‐5.95%
Feb 2,751,779 2,811,298 2.16%
Mar 4,098,738
Apr 5,420,381
May 6,702,223
Jun 7,923,403
Jul 9,116,434
Aug 10,307,012
Sep 11,443,772
Oct 12,636,818
Nov 13,794,401
Dec 15,166,600
Percent of budget 18.54%
Note: Includes Natural Gas Use Tax.
$‐
$3
$6
$9
$12
$15
$18
$21
Millions Sales Tax
Budget
Actual
Last Year
$0
$2
$4
$6
$8
$10
$12
$14
$16
Millions Utility Tax
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 469,355 185,889 ‐60.39%
Feb 583,113 322,341 ‐44.72%
Mar 741,647
Apr 1,010,644
May 1,187,535
Jun 1,393,028
Jul 1,693,253
Aug 1,895,469
Sep 2,064,907
Oct 2,302,673
Nov 2,462,856
Dec 2,612,987
Percent of budget 12.34%
Note: Includes Fund 318.
Intergovt'l Budget
YTD
Actual
Annual %
over (under)
$11
$12
Millions Intergovernmental
Budget
Al
$‐
$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
g g ()
Jan 514,868 565,843 9.90%
Feb 1,045,692 1,079,643 3.25%
Mar 1,490,863
Apr 1,908,775
May 2,805,296
Jun 5,483,358
Jul 5,883,091
Aug 6,542,188
Sep 6,989,111
Oct 7,566,088
Nov 10,712,155
Dec 10,976,730
Percent of budget 9.84%
Note: Includes CJ Sales Tax.
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
$10
$11
$12
Millions Intergovernmental
Budget
Actual
Last Year
$‐
$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
Page 17 of 36
City of Renton
Monthly Revenue Analysis ‐ 2011 Budget Year
Charges for
Svcs Budget
YTD
Actual
Annual %
over (under)
Jan 447,067 323,609 ‐27.62%
Feb 884,119 786,123 ‐11.08%
Mar 1,363,364
Apr 2,006,320
May 2,526,347
Jun 3,132,602
Jul 3,941,618
Aug 4,487,827
Sep 4,949,440
Oct 5,447,614
Nov 5,842,063
Dec 6,366,817
Percent of budget 12.35%
Fines &
Forfeits Budget
YTD
Actual
Annual %
over (under)
$‐
$1
$2
$3
$4
$5
$6
$7
Millions Charges for Services
Budget
Actual
Last Year
$3.50
Millions Fines & Forfeits
Budget
g ()
Jan 223,938 165,721 ‐26.00%
Feb 434,759 430,461 ‐0.99%
Mar 694,630
Apr 968,114
May 1,225,734
Jun 1,573,479
Jul 1,812,769
Aug 2,098,788
Sep 2,307,490
Oct 2,555,419
Nov 2,852,584
Dec 3,170,351
Percent of budget 13.58%
$‐
$1
$2
$3
$4
$5
$6
$7
Millions Charges for Services
Budget
Actual
Last Year
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions Fines & Forfeits
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 595,443 628,259 5.51%
Feb 855,646 880,840 2.94%
Mar 1,150,736
Apr 1,910,301
May 2,209,419
Jun 2,528,644
Jul 3,613,125
Aug 3,958,169
Sep 4,158,271
Oct 4,951,774
Nov 5,228,432
Dec 6,075,921
Percent of budget 14.50%
Misc Budget
YTD
Actual
Annual %
over (under)$1.40
Millions Miscellaneous
Budget
Actual
$0
$1
$2
$3
$4
$5
$6
$7
Millions Other Taxes
Budget
Actual
Last Year
g ()
Jan 180,108 143,105 ‐20.54%
Feb 278,345 213,343 ‐23.35%
Mar 403,218
Apr 515,094
May 628,732
Jun 797,494
Jul 963,522
Aug 1,070,198
Sep 1,181,018
Oct 1,268,115
Nov 1,334,590
Dec 1,397,659
Percent of budget 15.26%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
Millions Miscellaneous
Budget
Actual
Last Year
$0
$1
$2
$3
$4
$5
$6
$7
Millions Other Taxes
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 808 808 0.00%
Mar 11
Apr 16
May 481,494
Jun 481,541
Jul 481,515
Aug 529,019
Sep 529,030
Oct 529,056
Nov 529,056
Dec 529,056
Percent of budget 0.15%
REET Budget
YTD
Actual
Annual %
over (under)
$2.50
Millions Real Estate Excise Tax
Budget
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
$7.00
$8.00
Millions Other Financing Sources
Budget
Actual
Last Year
g ()
Jan 64,803 161,911 149.85%
Feb 162,288 261,588 61.19%
Mar 443,274
Apr 699,373
May 896,426
Jun 1,070,698
Jul 1,206,778
Aug 1,397,066
Sep 1,508,909
Oct 1,675,542
Nov 1,860,141
Dec 2,240,000
Percent of budget 11.68%
$0.00
$0.50
$1.00
$1.50
$2.00
$2.50
Millions Real Estate Excise Tax
Budget
Actual
Last Year
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
$7.00
$8.00
Millions Other Financing Sources
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,095,623 6,990,159 ‐1.49%
Feb 16,660,826 15,756,416 ‐5.43%
Mar 24,571,104
Apr 32,500,435
May 40,453,561
Jun 48,725,038
Jul 57,267,425
Aug 65,777,735
Sep 74,125,311
Oct 81,760,223
Nov 90,086,743
Dec 98,934,407
Percent of budget expended 15.93%
Legislative Budget
YTD
Actual
Annual %
over (under)
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
Millions
Total Expenditures
General Government
Budget
Actual
Last Year
$300,000
Legislative
Budget
Actual
g g ()
Jan 22,689 22,021 ‐2.94%
Feb 46,076 44,576 ‐3.26%
Mar 69,607
Apr 93,677
May 116,993
Jun 140,280
Jul 163,146
Aug 186,174
Sep 208,887
Oct 230,365
Nov 253,583
Dec 277,834
Percent of budget expended 16.04%
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
Millions
Total Expenditures
General Government
Budget
Actual
Last Year
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
Legislative
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 104,959 112,718 7.39%
Feb 232,098 229,987 ‐0.91%
Mar 357,476
Apr 482,118
May 603,743
Jun 720,399
Jul 848,259
Aug 965,687
Sep 1,099,926
Oct 1,220,428
Nov 1,335,457
Dec 1,454,762
Percent of budget expended 15.81%
City Clerk Budget
YTD
Actual
Annual %
over (under)
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
Millions Executive
Budget
Actual
Last Year
$0.80
Millions City Clerk
Budget
Actual
y g ()
Jan 51,492 49,604 ‐3.67%
Feb 103,964 98,230 ‐5.52%
Mar 160,688
Apr 280,719
May 380,999
Jun 435,251
Jul 485,774
Aug 534,200
Sep 583,630
Oct 678,087
Nov 727,878
Dec 790,484
Percent of budget expended 12.43%
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
Millions Executive
Budget
Actual
Last Year
$0.00
$0.20
$0.40
$0.60
$0.80
Millions City Clerk
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 14,528 14,189 ‐2.33%
Feb 28,905 21,908 ‐24.21%
Mar 43,154
Apr 57,736
May 71,939
Jun 86,324
Jul 100,917
Aug 115,153
Sep 129,406
Oct 143,109
Nov 157,369
Dec 171,929
Percent of budget expended 12.74%
City Attorney Budget
YTD
Actual
Annual %
over (under)$1.60
Millions City Attorney
Budget
Actual
$‐
$30,000
$60,000
$90,000
$120,000
$150,000
$180,000
Hearing Examiner
Budget
Actual
Last Year
y y g ()
Jan 103,073 130,446 26.56%
Feb 244,580 264,464 8.13%
Mar 396,154
Apr 541,694
May 682,825
Jun 823,807
Jul 963,283
Aug 1,105,997
Sep 1,241,400
Oct 1,376,729
Nov 1,510,648
Dec 1,600,531
Percent of budget expended 16.52%
$‐
$0.40
$0.80
$1.20
$1.60
Millions City Attorney
Budget
Actual
Last Year
$‐
$30,000
$60,000
$90,000
$120,000
$150,000
$180,000
Hearing Examiner
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 170,319 163,613 ‐3.94%
Feb 345,697 326,156 ‐5.65%
Mar 528,990
Apr 705,146
May 880,215
Jun 1,060,776
Jul 1,241,163
Aug 1,415,039
Sep 1,592,413
Oct 1,751,351
Nov 1,921,102
Dec 2,104,953
Percent of budget expended 15.49%
CED Admin Budget
YTD
Actual
Annual %
over (under)
$‐
$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
$1.00
Millions Community & Economic
Development Admin
Budget
g ()
Jan 74,575 77,455 3.86%
Feb 157,835 155,007 ‐1.79%
Mar 237,058
Apr 315,978
May 394,187
Jun 472,083
Jul 549,691
Aug 627,009
Sep 704,035
Oct 777,925
Nov 853,594
Dec 929,263
Percent of budget expended 16.68%
$‐
$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
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
$0.70
$0.80
$0.90
$1.00
Millions Community & Economic
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 275,635 231,587 ‐15.98%
Feb 544,513 474,633 ‐12.83%
Mar 804,323
Apr 1,066,338
May 1,326,912
Jun 1,580,943
Jul 1,837,866
Aug 2,080,091
Sep 2,346,623
Oct 2,583,029
Nov 2,828,359
Dec 3,081,560
Percent of budget expended 15.40%
Economic
Development Budget
YTD
Actual
Annual %
over (under)
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions Development Services
Budget
Actual
Last Year
$1.40
Millions Economic Development
Budget
p g ()
Jan 47,924 68,491 42.92%
Feb 111,988 123,830 10.57%
Mar 167,414
Apr 217,848
May 276,248
Jun 331,768
Jul 396,422
Aug 450,586
Sep 514,229
Oct 567,952
Nov 628,002
Dec 687,775
Percent of budget expended 18.00%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions Development Services
Budget
Actual
Last Year
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
Millions Economic Development
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 104,636 104,320 ‐0.30%
Feb 206,537 258,972 25.39%
Mar 315,744
Apr 415,028
May 528,825
Jun 678,629
Jul 789,343
Aug 919,836
Sep 1,081,506
Oct 1,210,045
Nov 1,304,606
Dec 1,459,446
Percent of budget expended 17.74%
Finance Budget
YTD
Actual
Annual %
over (under)$2.40
Millions Finance
Budget
Actual
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
$2.00
Millions Planning
Budget
Actual
Last Year
g ()
Jan 169,632 155,421 ‐8.38%
Feb 310,659 315,453 1.54%
Mar 470,373
Apr 612,482
May 786,062
Jun 930,343
Jul 1,079,157
Aug 1,230,554
Sep 1,381,686
Oct 1,483,293
Nov 1,614,896
Dec 1,909,797
Percent of budget expended 16.52%
$‐
$0.40
$0.80
$1.20
$1.60
$2.00
$2.40
Millions Finance
Budget
Actual
Last Year
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
$2.00
Millions Planning
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 76,209 86,565 13.59%
Feb 150,817 155,437 3.06%
Mar 230,642
Apr 309,479
May 387,407
Jun 468,581
Jul 548,537
Aug 627,943
Sep 707,458
Oct 782,694
Nov 855,853
Dec 948,554
Percent of budget expended 16.39%
Police Budget
YTD
Actual
Annual %
over (under)
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
Millions Human Resources
Budget
Actual
Last Year
$30
$33
Millions Police
Budget
Actual
g ()
Jan 2,381,559 2,369,174 ‐0.52%
Feb 4,961,350 4,383,450 ‐11.65%
Mar 7,540,294
Apr 9,955,313
May 12,384,370
Jun 15,069,945
Jul 17,625,828
Aug 20,139,446
Sep 22,813,750
Oct 25,058,648
Nov 27,862,041
Dec 30,651,495
Percent of budget expended 14.30%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
Millions Human Resources
Budget
Actual
Last Year
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
Millions Police
Budget
Actual
Last Year
Page 27 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Fire & Emerg
Svc Budget
YTD
Actual
Annual %
over (under)
Jan 1,894,040 1,754,253 ‐7.38%
Feb 4,464,519 4,132,293 ‐7.44%
Mar 6,244,191
Apr 7,913,923
May 9,636,531
Jun 11,386,741
Jul 13,170,370
Aug 14,956,836
Sep 16,745,399
Oct 18,390,379
Nov 20,227,278
Dec 22,045,916
Percent of budget expended 18.74%
Community
Services
Admin Budget
YTD
Actual
Annual %
over (under)
$‐
$3
$6
$9
$12
$15
$18
$21
$24
Millions Fire & Emergency Services
Budget
Actual
Last Year
$1,200,000
Community Services Admin
Budget
Actual
g ()
Jan 24,324 33,774 38.85%
Feb 69,640 67,558 ‐2.99%
Mar 104,515
Apr 139,398
May 174,108
Jun 208,889
Jul 243,517
Aug 277,183
Sep 311,098
Oct 344,781
Nov 378,368
Dec 412,476
Percent of budget expended 16.38%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
Millions Fire & Emergency Services
Budget
Actual
Last Year
$‐
$200,000
$400,000
$600,000
$800,000
$1,000,000
$1,200,000
Community Services Admin
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 238,661 261,191 9.44%
Feb 513,616 527,048 2.62%
Mar 809,016
Apr 1,114,881
May 1,438,367
Jun 1,779,710
Jul 2,140,196
Aug 2,547,353
Sep 2,888,762
Oct 3,234,743
Nov 3,545,443
Dec 3,921,721
Percent of budget expended 13.44%
Parks
Planning and
Natural Budget
YTD
Actual
Annual %
over (under)
$‐
$1
$1
$2
$2
$3
$3
$4
$4
$5
Millions Parks
Budget
Actual
Last Year
$1
$1
Millions Parks Planning and Natural Resources
Budget
Actual
g ()
Jan 48,516 34,349 ‐29.20%
Feb 97,031 69,260 ‐28.62%
Mar 145,547
Apr 194,062
May 242,578
Jun 291,093
Jul 339,609
Aug 388,124
Sep 436,640
Oct 485,155
Nov 533,671
Dec 582,186
Percent of budget expended 11.90%
$‐
$1
$1
$2
$2
$3
$3
$4
$4
$5
Millions Parks
Budget
Actual
Last Year
$‐
$0
$0
$0
$0
$1
$1
$1
Millions Parks Planning and Natural Resources
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 293,715 361,259 23.00%
Feb 631,899 702,382 11.15%
Mar 999,371
Apr 1,340,764
May 1,706,859
Jun 2,103,392
Jul 2,755,813
Aug 3,467,201
Sep 3,953,053
Oct 4,303,772
Nov 4,755,184
Dec 5,147,357
Percent of budget expended 13.65%
Human
Services Budget
YTD
Actual
Annual %
over (under)
$1 20
$1.40
Millions Human Services
Budget
Actual
$‐
$1
$2
$3
$4
$5
$6
Millions Recreation
Budget
Actual
Last Year
g ()
Jan 54,631 53,756 ‐1.60%
Feb 116,265 118,956 2.31%
Mar 182,966
Apr 359,906
May 436,993
Jun 510,247
Jul 698,336
Aug 772,020
Sep 829,771
Oct 976,664
Nov 1,070,370
Dec 1,256,071
Percent of budget expended 9.47%
$0.00
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
Millions Human Services
Budget
Actual
Last Year
$‐
$1
$2
$3
$4
$5
$6
Millions Recreation
Budget
Actual
Last Year
Page 30 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Neighborhood
s, Resources,
and Events Budget
YTD
Actual
Annual %
over (under)
Jan 41,199 36,383 ‐11.69%
Feb 83,994 73,402 ‐12.61%
Mar 126,915
Apr 170,845
May 224,786
Jun 286,440
Jul 371,043
Aug 420,039
Sep 465,985
Oct 503,642
Nov 540,651
Dec 678,584
Percent of budget expended 10.82%
Library Fund Budget
YTD
Actual
Annual %
over (under)$2.50
Millions Library Fund
Budget
Actual
$‐
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
$700,000
$800,000
Neighborhoods, Resources, and Events
Budget
Actual
Last Year
y g ()
Jan 2,619 2,619 0.00%
Feb 5,119 5,119 0.00%
Mar 507,500
Apr 676,667
May 845,833
Jun 1,015,000
Jul 1,184,167
Aug 1,353,333
Sep 1,522,500
Oct 1,691,667
Nov 1,860,833
Dec 2,030,000
Percent of budget expended 0.25%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
Millions Library Fund
Budget
Actual
Last Year
$‐
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
$700,000
$800,000
Neighborhoods, Resources, and Events
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 16,891 17,146 1.51%
Feb 34,473 34,638 0.48%
Mar 51,858
Apr 69,554
May 87,464
Jun 105,332
Jul 122,835
Aug 140,126
Sep 157,397
Oct 174,522
Nov 191,345
Dec 208,407
Percent of budget expended 16.62%
Public Works
Admin Budget
YTD
Actual
Annual %
over (under)$0.60
Millions Public Works Admin
Budget
Actual
$‐
$30,000
$60,000
$90,000
$120,000
$150,000
$180,000
$210,000
Museum Fund
Budget
Actual
Last Year
g ()
Jan 36,310 37,289 2.70%
Feb 74,186 74,538 0.47%
Mar 112,901
Apr 154,191
May 191,427
Jun 228,374
Jul 266,290
Aug 306,966
Sep 342,897
Oct 378,232
Nov 415,139
Dec 454,179
Percent of budget expended 16.41%
$‐
$0.20
$0.40
$0.60
Millions Public Works Admin
Budget
Actual
Last Year
$‐
$30,000
$60,000
$90,000
$120,000
$150,000
$180,000
$210,000
Museum Fund
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 292,781 279,841 ‐4.42%
Feb 594,598 597,149 0.43%
Mar 892,291
Apr 1,214,569
May 1,516,549
Jun 1,833,551
Jul 2,172,817
Aug 2,501,620
Sep 2,789,645
Oct 3,081,338
Nov 3,362,752
Dec 3,693,925
Percent of budget expended 16.17%
Transportatio
n Budget
YTD
Actual
Annual %
over (under)
$‐
$1
$1
$2
$2
$3
$3
$4
$4
Millions Street Maintenance
Budget
Actual
Last Year
$6
Millions Transportation
Budget
Actual
g ()
Jan 330,574 308,560 ‐6.66%
Feb 718,458 689,957 ‐3.97%
Mar 1,113,121
Apr 1,486,124
May 1,866,350
Jun 2,259,148
Jul 2,602,059
Aug 3,025,230
Sep 3,400,230
Oct 3,801,691
Nov 4,169,339
Dec 4,599,219
Percent of budget expended 15.00%
$‐
$1
$1
$2
$2
$3
$3
$4
$4
Millions Street Maintenance
Budget
Actual
Last Year
$‐
$1
$2
$3
$4
$5
$6
Millions Transportation
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 4,600 4,600 0.00%
Feb 254,918 254,918 0.00%
Mar 1,178,759
Apr 1,571,678
May 1,964,598
Jun 2,357,518
Jul 2,750,437
Aug 3,143,357
Sep 3,536,276
Oct 3,929,196
Nov 4,322,115
Dec 4,715,035
Percent of budget expended 5.41%
Non
Departmental
Other City Budget
YTD
Actual
Annual %
over (under)
$4.50
$5.00
Millions Non‐Departmental Other City Services
Budget
Actual
$‐
$2.00
$4.00
$6.00
$8.00
$10.00
$12.00
Millions Debt Service
Budget
Actual
Last Year
y g ()
Jan 219,534 219,534 0.00%
Feb 1,557,092 1,557,092 0.00%
Mar 780,237
Apr 1,040,315
May 1,300,394
Jun 1,560,473
Jul 1,820,552
Aug 2,080,631
Sep 2,340,710
Oct 2,600,788
Nov 2,860,867
Dec 3,120,946
Percent of budget expended 49.89%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
Millions Non‐Departmental Other City Services
Budget
Actual
Last Year
$‐
$2.00
$4.00
$6.00
$8.00
$10.00
$12.00
Millions Debt Service
Budget
Actual
Last Year
Page 34 of 36
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2011 Budget Year
Utilities Budget Revenue Expense
Jan 2,795,269 3,918,553 2,713,059
Feb 6,417,045 8,323,464 6,324,471
Mar 8,926,751
Apr 13,530,752
May 16,990,102
Jun 22,997,966
Jul 28,276,589
Aug 31,306,634
Sep 34,922,181
Oct 38,547,311
Nov 42,086,676
Dec 47,913,428
Percent of budget expended 13.20%
Note: Operations only, excludes bond proceeds and transfers to capital.
Airport Budget Revenue Expense
$0
$5
$10
$15
$20
$25
$30
$35
$40
$45
$50
Millions Utilities
Budget
Revenue
Expense
$1.20
Millions Airport
Budget
Revenue
p g p
Jan 74,953 209,065 71,560
Feb 161,681 398,208 166,746
Mar 250,109
Apr 335,667
May 422,777
Jun 528,351
Jul 623,241
Aug 714,044
Sep 814,991
Oct 896,338
Nov 989,111
Dec 1,125,756
Percent of budget expended 14.81%
Note: Operations only.
$0
$5
$10
$15
$20
$25
$30
$35
$40
$45
$50
Millions Utilities
Budget
Revenue
Expense
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Millions Airport
Budget
Revenue
Expense
Page 35 of 36
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2011 Budget Year
Golf Course Budget Revenue Expense
Jan 126,264 56,081 126,007
Feb 252,083 138,059 258,005
Mar 468,172
Apr 603,406
May 793,857
Jun 1,040,631
Jul 1,203,067
Aug 1,350,547
Sep 1,512,286
Oct 1,812,451
Nov 1,946,516
Dec 2,504,738
Percent of budget expended 10.30%
Note: Operations only.
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
$2.40
$2.70
Millions Golf Course
Budget
Revenue
Expense
Page 36 of 36