HomeMy WebLinkAbout201101, January.pdfFINANCE AND
INFORMATION TECHNOLOGY
M E M O R A N D U M
DATE: March 21, 2011
TO: Terri Briere, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: January 2011 Financial Status Report
At the end of January, general governmental revenues show $275k or 4.9% under budget. This
includes a $283k favorable property tax collection but otherwise almost all other revenue
categories are under performing. Without the favorable property tax, revenues are $559k or
9.9% below budget. The largest deficit is from building permits and development service fees
by $322k.
On the expenditures’ side, most departments conserved their spending and showed favorable
variances. Overall general governmental funds are showing a $105k or 1.5% savings. A number
of divisions may appear to exceed their budget at the end of January, most are due to timing of
various payments and that expenditures 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 any given month’s result is not a good gague for the performance of
the year. We will have 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 9,419 31,497,128 218,705 32,046,525 222,520 505,501 282,982 127.2%
Sales Tax 17,995,836 1,458,072 17,198,220 1,289,364 17,759,600 1,369,175 1,339,658 (29,516) ‐2.2%
Sales Tax ‐ Annexation Credit 2,132,110 171,175 2,025,660 153,295 2,119,680 160,410 158,398 (2,012) ‐1.3%
Criminal Justice Sa les Tax 1,650,350 138,676 1,620,479 126,465 1,804,005 140,788 132,724 (8,064) ‐5.7%
Natural Gas Use Tax 242,891 ‐ 228,514 20,459 258,750 23,166 22,911 (255) ‐1.1%
Admission Tax 260,269 57,167 291,399 74,777 280,000 71,852 70,405 (1,447) ‐2.0%
Franchise Fees 1,039,031 259,792 1,222,444 45,703 1,260,000 330,324 305,646 (24,678) ‐7.5%
Electricity Tax 4,963,151 523,055 5,036,907 526,090 4,968,000 518,893 476,061 (42,832) ‐8.3%
Gas Tax 1,891,255 299,890 1,577,756 247,250 1,656,000 259,512 218,308 (41,204) ‐15.9%
Transfer Station 283,985 9,506 269,912 5,937 238,050 5,236 20,780 15,544 296.9%
TV Cable 1,263,743 104,315 1,296,744 109,302 1,366,200 115,157 118,469 3,312 2.9%
Telephone 1,037,873 79,780 1,038,009 79,580 1,000,000 76,666 73,415 (3,251) ‐4.2%
Cellular Phone 2,027,473 154,579 2,206,637 186,705 2,592,000 219,310 179,272 (40,038) ‐18.3%
City Utilities 2,871,599 242,515 2,853,884 216,909 2,937,600 223,272 253,808 30,536 13.7%
Leasehold Excise Tax 146,002 ‐ 138,830 ‐ 145,000 ‐ ‐ ‐ 0.0%
Gambling Excise Tax 2,141,720 7,691 1,546,386 135,608 1,600,000 140,310 118,304 (22,005) ‐15.7%
Real Estate Excise Tax 2,418,456 231,334 2,464,489 71,303 2,240,000 64,803 161,911 97,108 149.9%
Less: Municipal Facilities CIP REET (1,000,000) (139,761) (400,000) (11,884) (400,000) (11,884) (28,006) (16,123) 135.7%
EMS Levy 1,170,657 ‐ 1,161,114 ‐ 950,921 ‐ ‐ ‐ 0.0%
Business License Fees 424,413 81,835 431,782 77,955 463,067 83,603 84,109 506 0.6%
Other Licenses and Permits 176,851 10,254 262,629 20,561 210,255 16,461 14,017 (2,443) ‐14.8%
Building Permits & Development Svc Fees 2,361,037 154,548 2,437,270 394,165 2,706,044 454,717 132,621 (322,096) ‐70.8%
Intergovernmental (Grants, etc)3,820,932 203,891 4,426,676 245,381 3,244,263 431,946 431,946 ‐ 0.0%
Fire District 25 and 40 Contracts 5,869,198 ‐ 5,252,877 ‐ 5,928,462 1,173 1,173 ‐ 0.0%
Public Safety 521,484 40,270 482,343 35,994 426,081 31,795 18,824 (12,971) ‐40.8%
Culture and Recreation 1,631,486 65,409 1,424,932 62,673 1,628,486 71,626 61,933 (9,693) ‐13.5%
Interfund/Interdept‐Services 3,225,745 253,147 3,190,908 242,658 3,314,653 252,068 190,881 (61,187) ‐24.3%
Fines and Forfeits 1,349,034 98,281 1,291,817 5,172 1,088,750 4,359 25 (4,334) ‐99.4%
Photo Enforcement 2,368,131 182,568 1,925,159 187,281 1,900,908 184,922 165,696 (19,226) ‐10.4%
Seizure Funds ‐ Federal/State/Local 99,844 ‐ 221,046 46,627 180,693 ‐ ‐ ‐ 0.0%
Interests and Other Earnings 535,314 76,476 327,558 21,570 477,730 31,459 12,157 (19,302) ‐61.4%
Rents, Leases, and Concessions 677,960 51,300 727,338 135,736 698,929 130,435 122,667 (7,768) ‐6.0%
Contributions and Donations 150,406 9,329 133,756 3,016 100,000 2,255 6,055 3,800 168.5%
Other Miscellaneous 356,288 18,988 291,436 16,501 502,218 28,435 9,339 (19,096) ‐67.2%
Refunding Debt and Premiums ‐ ‐ 6,613,484 ‐ ‐ ‐ ‐ ‐ 0.0%
Transfer ‐In 577,004 ‐ 652,398 ‐ 529,056 ‐ ‐ ‐ 0.0%
Total Operating Revenues 97,342,052 4,853,501 103,367,918 4,990,858 98,221,926 5,654,762 5,379,006 (275,756) ‐4.9%
OPERATING EXPENDITURES
Legislative 247,225 20,336 259,345 21,032 277,834 22,689 22,021 667 2.9%
City Attorney 1,248,380 54,056 1,565,597 127,162 1,600,531 103,073 130,446 (27,373) ‐26.6%
City Clerk 646,581 45,501 789,209 48,025 790,484 51,492 49,604 1,888 3.7%
Court Services 1,819,731 141,212 2,007,599 168,470 2,104,953 170,319 163,613 6,706 3.9%
Executive 1,499,747 87,309 1,578,526 134,784 1,454,762 104,959 112,718 (7,759) ‐7.4%
Hearing Examiner 171,911 14,648 174,447 14,619 171,929 14,528 14,189 339 2.3%
Community and Eco Dvlpmnt Admin 265,269 22,791 579,396 44,995 929,263 74,575 77,455 (2,880) ‐3.9%
Development Services 3,615,129 301,504 2,946,413 285,403 3,081,560 275,635 231,587 44,047 16.0%
Economic Development 1,244,175 85,932 1,322,004 92,877 687,775 47,924 68,491 (20,568) ‐42.9%
Planning 1,525,460 104,143 1,774,508 132,451 1,459,446 104,636 104,320 316 0.3%
Finance 1,969,936 226,614 2,214,458 145,053 1,909,797 169,632 155,421 14,212 8.4%
Human Resources 853,063 66,273 861,221 71,457 948,554 76,209 86,565 (10,356) ‐13.6%
Police 25,833,756 1,882,172 27,485,421 2,260,619 30,651,495 2,381,559 2,369,174 12,385 0.5%
Fire 20,378,891 1,834,269 21,554,792 1,768,398 22,045,916 1,894,040 1,754,253 139,787 7.4%
Community Services Admin1 4,459,381 279,668 1,063,011 45,998 412,476 24,324 33,774 (9,450) ‐38.8%
Parks 3,894,745 235,923 3,421,424 209,312 3,921,721 238,661 261,191 (22,529) ‐9.4%
Parks Planning & Natural Resources ‐ ‐ 448,574 14,316 582,186 48,516 34,349 14,167 29.2%
Recreation 4,374,668 223,059 4,433,420 279,542 5,147,357 293,715 361,259 (67,544) ‐23.0%
Human Services 1,194,142 55,456 1,326,778 54,186 1,256,071 54,631 53,756 874 1.6%
Community Resources & Events 348,185 19,811 331,222 21,438 678,584 41,199 36,383 4,815 11.7%
Library 2,321,878 146,852 2,289,692 173,794 2,030,000 2,619 2,619 ‐ 0.0%
Museum 140,801 11,589 191,090 15,310 208,407 16,891 17,146 (256) ‐1.5%
Public Works Administration 1 942,026 73,940 514,858 42,532 454,179 36,310 37,289 (979) ‐2.7%
Street Maintenance 3,794,716 330,813 3,412,892 240,463 3,693,925 292,781 279,841 12,940 4.4%
Transportation 5,110,639 341,612 5,215,309 400,577 4,599,219 330,574 308,560 22,014 6.7%
Debt Service 4,176,822 ‐ 11,320,584 ‐ 4,715,035 4,600 4,600 ‐ 0.0%
Non‐Departmental and Other 5,126,072 299,635 4,834,296 348,715 3,120,946 219,534 219,534 ‐ 0.0%
Total Operating Expenditures 97,203,328 6,905,118 103,916,084 7,161,528 98,934,407 7,095,623 6,990,159 105,464 1.5%
Total Ending Fund Balance 11,955,285$ 9,764,945$ 11,407,119$ 9,784,616$ 10,694,638$ 9,966,258$ 9,795,967$ (170,292) ‐1.7%
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 January 2011
Page 1 of 34
Monthly Financial Report January 2011
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through January 31, 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 69% of
all resources supporting general governmental activities. The following section provides detail information on property,
sales, utility, and other taxes.
Property Tax
January’s collection is $506k, of
this amount $129k 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 $157k or 72% ahead the
same month the prior year and
$154k or 69% over the current
month’s budget.
Sales Tax
January 2011 sales tax receipts
totaled $1.3 million. Compared to
the same month last year, it is $50k
or 4% more. Compared to the
projected current month’s budget, it
is below projections by $56k or 4%.
The year‐to‐date collection is $1.3
million or 8% of the sales tax budget.
Based on the year‐to‐date collection,
the City projected sales tax revenues
to be $17.7 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
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 218,705$ 222,520$ 505,501$ 286,797$ 131% 282,981$ 127%
Annual Total 31,497,128$ 32,046,525$
Property Tax Revenues
Year to Date through January
2011 vs . 2010 2011 vs. Budget
Month
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 1,289,364$ 1,395,441$ 1,339,658$ 50,295$ 4% (55,783)$ ‐4%
Feb 1,728,588 ‐ ‐
Mar 1,289,589 ‐ ‐
Apr 1,461,123 ‐ ‐
May 1,499,335 ‐ ‐
Jun 1,382,049 ‐ ‐
Jul 1,309,429 ‐ ‐
Aug 1,470,881 ‐ ‐
Sep 1,408,876 ‐ ‐
Oct 1,447,338 ‐ ‐
Nov 1,508,617 ‐ ‐
Dec 1,403,032 ‐ ‐
YTD Total 1,289,364$ 1,395,441$ 1,339,658$ 50,295$ 4% (55,783)$ ‐4%
Annual Total 17,198,220$ 17,759,600$
2011 vs. Budget2011 vs. 2010
Month
Year to Da te through January
Local Retail Sales Tax Revenues
Page 2 of 34
Monthly Financial Report January 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 123,561$ 175,985$ 125,321$ 1,760$ 1%$ (50,663)‐29%
Auto Sales 211,836 234,791 251,874 40,038 19% 17,083 7%
General Retail 486,982 509,907 485,811 (1,171) 0% (24,097)‐5%
Manufacturing 68,593 57,336 61,291 (7,302) ‐11% 3,955 7%
Wholesale 68,484 77,250 112,293 43,808 64% 35,043 45%
Service 289,984 291,239 273,275 (16,709) ‐6% (17,963)‐6%
Other 39,924 48,933 29,794 (10,130) ‐25% (19,139)‐39%
Total 1,289,364$ 1,395,441$ 1,339,658$ 50,295 4%(55,783)$ ‐4%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility tax
January utility tax revenues are $1.4
million, which is $29k or 2% lower than
the same month last year and also
behind the budget by $78k or 5%.
Based on collections so far the City is
projecting utility taxes to be slightly
under 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 526,090$ 518,893$ 476,061$ (50,030)$ ‐10%$ (42,832)‐8%
Natural Gas 267,709 282,678 241,219 (26,491) ‐10% (41,459)‐15%
Cell 186,705 219,310 179,272 (7,432) ‐4% (40,038)‐18%
Phone 79,580 76,666 73,415 (6,165) ‐8% (3,251)‐4%
Cable 109,302 115,157 118,469 9,166 8% 3,312 3%
Transfer Station 5,937 5,236 20,780 14,843 250% 15,544 297%
City Utilities 216,909 223,272 253,808 36,899 17% 30,536 14%
YTD Total 1,392,232$ 1,441,212$ 1,363,023$ (29,209)$ ‐2%(78,189)$ ‐5%
Annual Total 14,508,363$ 15,016,600$
YTD as % of 9%9%
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 1,392,232$ 1,441,212$ 1,363,023$ (29,209)$ ‐2% (78,189)$ ‐5%
Feb 1,245,631 1,282,530 ‐
Mar 1,295,732 1,346,989 ‐
Apr 1,260,110 1,309,327 ‐
May 1,231,700 1,281,045 ‐
Jun 1,165,188 1,212,643 ‐
Jul 1,140,413 1,184,247 ‐
Aug 1,131,693 1,168,575 ‐
Sep 1,082,231 1,110,224 ‐
Oct 1,138,457 1,173,674 ‐
Nov 1,112,608 1,150,651 ‐
Dec 1,312,366 1,355,481 ‐
YTD Total 1,392,232$ 1,441,212$ 1,363,023$ (29,209)$ ‐2% (78,189)$ ‐5%
Annual Total 14,508,363$ 15,016,600$
2011 vs. Budget2011 vs. 2010
Year to Date through January
Utility Tax Revenues
Month
Page 3 of 34
Monthly Financial Report January 2011
Other Taxes
Real Estate Excise Tax
The City collected $162k in Real Estate
Excise Tax revenues (REET) in January.
This is $97k or 150% above current
month’s budget and $91k or 127%
ahead of the same month last year.
Gambling Tax
January’s Gambling Tax
collections total $118k. Year‐to‐
date total of $118k is $17k or 13%
below the year before; and $23k
or 16% below budget.
The lower tax collection is due to
cross‐the‐board reduction in
gambling activities. Pull tabs
overall reduced by 4% and card‐
rooms are seeing 20% lower in
activities.
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 is also $15k or
5% lower than 2010.
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 71,303$ 64,803$ 161,911$ 90,608$ 127% 97,108$ 150%
Feb 107,242 97,485
Mar 309,164 280,986
Apr 281,746 256,099
May 216,814 197,053
Jun 191,741 174,272
Jul 149,706 136,080
Aug 209,369 190,288
Sep 123,054 111,843
Oct 183,333 166,633
Nov 203,091 184,599
Dec 417,925 379,859
YTD Total 71,303$ 64,803$ 161,911$ 90,608$ 127% 97,108$ 150%
Annual Total 2,464,489$ 2,240,000$
Real Estate Excise Tax Revenues
Year to Date through January
Month
2011 vs. Budget2011 vs. 2010
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 135,608$ 141,411$ 118,304$ (17,304)$ ‐13% (23,106)$ ‐16%
Feb 137,736 141,411 ‐
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 135,608$ 140,310$ 118,304$ (17,304)$ ‐13% (23,106)$ ‐16%
Annual Total 1,546,386$ 1,600,000$
Gambling Tax Revenue
Month
Year to Date through January
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 January
Month
2011 vs. 2010 2011 vs. Budget
Page 4 of 34
Monthly Financial Report January 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 $3k or 5% more than
anticipated.
Building Permits and Development Service Fees
Building Permits and Development
Service Fee revenues totaled $133k in
January. 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 is $322k or
71% less than the budget and is also
$262k or 66% lower than 2010.
Business Licenses
Business Licenses totaled $84k since the start of
the year, which is 8% above last year and also
1% above budget. The General Fund portion of
the Business Licenses revenue is over the budget
by $506 and also $6k above last year.
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 74,777$ 66,968$ 70,405$ (4,372)$ ‐6% 3,436$ 5%
Feb 459 233 ‐
Apr 66,119 64,602 ‐
Jul 76,024 74,465 ‐
Aug 485 246 ‐
Oct 73,073 72,987 ‐
Nov 462 498 ‐
YTD Total 74,777$ 66,968$ 70,405$ (4,372)$ ‐6% 3,436$ 5%
Annual Total 291,399$ 280,000$
Year to Date through January
Month
2011 vs. 2010 2011 vs. Budget
Admission Tax Revenue
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 394,165$ 454,717$ 132,621$ (261,545)$ ‐66% (322,096)$ ‐71%
Feb 93,037 100,788 ‐
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 394,165$ 454,717$ 132,621$ (261,545)$ ‐66% (322,096)$ ‐71%
Annual Total 2,437,270$ 2,706,044$
Building Permits and Development Service Fees
Year to Date through January
2011 vs. Budget2011 vs. 2010
Month
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 77,955$ 83,603$ 84,109$ 6,154$ 8% 506$ 1%
Feb 33,440 35,863 ‐
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 77,955$ 83,603$ 84,109$ 6,154$ 8% 506$ 1%
Annual Total 431,782$ 463,067$
Business Licenses
Month
Year to Date through January
2011 vs. Budget2011 vs. 2010
Page 5 of 34
Monthly Financial Report January 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 60%
of the total revenues in this category. The year‐to‐date total Intergovernmental revenue is $519k or 5% 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 $311k since the start of
2011. Compared to the projected
budget, State Shared Revenues
are above by $4k or 1%.
Compared to the prior year, the
City is collecting $9k more or up
by 3%. 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 78% of the total revenue in this category. The year‐to‐date total charges for services are $324k or 5% of the
budget. This is 28% below budget projections. The following sections provide detail information for Public Safety,
Recreation, and Interfund Services.
Public Safety Services totaled $19k 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 $13k or
41% less than anticipated revenue.
Compared to the prior year, the City is
collecting $17k or 48% less. The City is
projecting Public Safety Service revenues to
meet the 2011 projected budget by year‐end.
2010 2011 2011
Actual Budget Actual $ % $ %
Crim Just Sales Tax 126,465$ 140,788$ 132,724$ 6,258$ 5% (8,064)$ ‐6%
Judicial Contribution ‐ ‐ ‐ ‐$ N/A ‐ N/A
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 45,992 42,729 46,307 315 1% 3,578 8%
YTD Total 301,591$ 306,835$ 310,630$ 9,039$ 3% 3,795$ 1%
Annual Total 4,095,806$ 3,874,444$
State Shared Revenues
2011 vs. 2010
Revenue
Year to Date through January
2011 vs. Budget
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 35,994$ 31,795$ 18,824$ (17,169)$ ‐48% (12,971)$ ‐41%
Feb 29,971 26,475 ‐
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 35,994$ 31,795$ 18,824$ (17,169)$ ‐48% (12,971)$ ‐41%
Annual Total 482,343$ 426,081$
Year to Date through January
Public Safety Services
Month
2011 vs. 2010 2011 vs. Budget
Intergovernmental 2010 2011 Bgt YTD Act Change 2011/2010 2011 Act vs Bgt
Fire District #25 ‐$ ‐$ ‐$ ‐$ N/A $ ‐ N/A
Fire District #40 ‐ 1,173 1,173 1,173 100% ‐ 0%
State Shared Revenue 301,591 278,924 310,630 9,039 3% 31,706 11%
Federal Grants 3,069 35,519 35,519 32,450 1057% ‐ 0%
State Grants 18,168 27,738 27,738 9,569 53% ‐ 0%
Other Grants 49,018 28,243 28,243 (20,775) ‐42% ‐ 0%
ARRA Grants ‐ 115,360 115,360 115,360 100% ‐ 0%
Total Rev YTD 371,847$ 486,958$ 518,663$ 146,817$ 39%31,706$ 7%
Total Rev Annual 11,300,032$ 10,976,730$
YTD %3%4%5%
Note: Includes CJ Sales Tax.
Page 6 of 34
Monthly Financial Report January 2011
Recreation revenues totaled $62k since
the start of the year. Compared to the
projected monthly budget, the City
collected $10k or 14% less. Compared to
the same month the prior year, the City
collected $740 or 1% less. The City is
projecting Recreation revenues to be
slightly under the 2011 budget at year‐
end.
The year‐to‐date collections for Interfund
Services revenues are $191k. Compared
to the projected budget, the revenues are
below by $61k or 24%. Compared to the
prior year, the revenues are under by $52k
or 21%. 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 $166k. This is $73k or 31%
lower than a year ago and $58k or 26%
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 projected shortfall is
primarily due to substantial declines in
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 62,673$ 71,626$ 61,933$ (740)$ ‐1% (9,693)$ ‐14%
Feb 64,915 74,189 ‐
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 62,673$ 71,626$ 61,933$ (740)$ ‐1% (9,693)$ ‐14%
Annual Total 1,424,932$ 1,628,486$
Recreation
Year to Da te through January
2011 vs. 2010
Month
2011 vs. Budget
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 242,658$ 252,068$ 190,881$ (51,777)$ ‐21% (61,187)$ ‐24%
Feb 273,674 284,288 ‐
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 242,658$ 252,068$ 190,881$ (51,777)$ ‐21% (61,187)$ ‐24%
Annual Total 3,190,908$ 3,314,653$
2011 vs. 2010 2011 vs. Budget
Month
Interfund Services
Year to Date through January
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 239,080$ 223,938$ 165,721$ (73,360)$ ‐31% (58,218)$ ‐26%
Feb 228,332 210,821 ‐
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 239,080$ 223,938$ 165,721$ (73,360)$ ‐31% (58,218)$ ‐26%
Annual Total 3,432,368$ 3,170,351$
2011 vs. Budget2011 vs. 2010
Year to Date through January
Fines and Penalties by Month
Month
Page 7 of 34
Monthly Financial Report January 2011
the photo enforcement fines, which we expect to continue. The decline is due to driver behavior changes in the areas with
photo enforcement programs and is consistent with the experience of other jurisdictions. These factors contributed to the
reduction in photo enforcement revenue by 12% in January when compared with the same period in 2010.
Year to Date through January
2010 2011 2011
Actual Budget Actual $ % $ %
Civil Penalties ‐$ ‐$ ‐$ ‐$ N/A ‐$ N/A
Civil Infraction Penalties ‐ ‐ ‐ ‐ N/A ‐ N/A
Civil Parking Infraction Penalties ‐ ‐ ‐ ‐ N/A ‐ N/A
Photo Enforcement Program 187,281 184,922 165,696 (21,585) ‐12% (19,226) ‐10%
Criminal Traffic Misdemeanor Fines ‐ ‐ ‐ ‐ N/A ‐ N/A
Criminal Non‐Traffic Fines ‐ ‐ ‐ ‐ N/A ‐ N/A
Criminal Costs ‐ ‐ ‐ ‐ N/A ‐ N/A
Seizure Funds ‐ Federal/State/Local 46,627 38,115 ‐ (46,627) 0% (38,115) 0%
Non‐Court Fines, Forfeitures and Penalties 5,172 901 25 (5,147) ‐100% (876) ‐97%
YTD Total 239,080$ 223,938$ 165,721$ (73,360)$ ‐31% (58,218)$ ‐26%
Annual Total 3,432,368$ 3,170,351$
Fines and Penalties by Type
Revenue
2011 vs. Budget2011 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 $166k. 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 94% of the total revenue in
this category. The year‐to‐date total
miscellaneous is $143k. Compared to the
projected year‐to‐date budget, the
revenues are under by $37k or 21%.
Compared to last year, the revenues are
under by $28k or 16%.
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 170,998$ 180,108$ 143,105$ (27,892)$ ‐16% (37,003)$ ‐21%
Feb 86,124 98,237 ‐
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 170,998$ 180,108$ 143,105$ (27,892)$ ‐16% (37,003)$ ‐21%
Annual Total 1,269,588$ 1,397,659$
Year to Date through January
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 ‐ 76,693 ‐ ‐
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 184,922$ 165,696$ 76,201$ 67,883$ 97,812$
Annual Total 1,900,908$ 841,964$
1Actuals of Revenues and Expenses
Expenses
Photo Enforcement Program
Year to Date through January
Month
Page 8 of 34
Monthly Financial Report January 2011
2010 2011 2011
Actual Budget Actual $ % $ %
Interests and Other Earnings 21,570$ 31,459$ 12,157$ (9,413)$ ‐44% (19,302)$ ‐61%
Rents, Leases, and Concessions 135,736 130,435 122,667 (13,069) ‐10% (7,768) ‐6%
Contributions/Donations from Private Sources 3,016 2,255 6,055 3,039 101% 3,800 169%
Other 10,676 15,960 2,227 (8,449) ‐79% (13,733) ‐86%
YTD Total 170,998$ 180,108$ 143,105$ (27,892)$ ‐16% (37,003)$ ‐21%
Annual Total 1,269,588$ 1,397,659$
2011 vs. Budget
Miscellaneous Revenues by Type
Year to Date through January
Revenue
2011 vs. 2010
EXPENSES
Overall the City has expended 7% of its budgeted general governmental expenditures at the end of January. This is $255k
or 3.5% 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.
City Attorney Department is over budget by $27k. This is due to the department not being fully staffed in 2009 until later in
the year which would skew the current year‐to‐budget. If we were to compare their year‐to‐date expenditures with a
budget divided equally by 12 months, they would be under budget by $3k.
The Economic Development division of Community and Economic Development Department appears to be over budget by
$21k. This is due to contributing the 2011 Marketing Campaign ($15k) earlier in 2011 than in 2009 (March) and 2010
(February).
Human Resources Department is over budget by $10k. This is due to invoices received in early 2011 that were for services
provided in 2010. The upcoming 2011 Carry Forward Budget Amendment will adjust their budget accordingly.
The Recreation division of Community Services Department is over budget by $68k. 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 34
Monthly Financial Report January 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 ‐ ‐ ‐ ‐ 2,440 2,050 ‐
Grants ‐ ‐ ‐ ‐ ‐ ‐ ‐
Charges for services 6,760 45,441 1,194,411 786,086 1,449,746 457,792 ‐
Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐
Fines and penalties ‐ ‐ ‐ ‐ ‐ ‐ ‐
Rents, leases, and misc fees 201,679 10,274 ‐ 9,882 ‐ ‐ ‐
Interest and other misc 657 479 6,651 65,904 53,449 30,550 7
TOTAL REVENUES 209,096 56,194 1,201,062 861,872 1,505,635 490,392 7
EXPENSES:
Utility billing ‐ ‐ 8,467 5,657 5,657 8,504 ‐
Utility systems ‐ ‐ 526,021 202,764 187,158 176,943 ‐
Utility maintenance ‐ ‐ 22,784 294,105 1,152,224 122,775 ‐
Transportation 71,560 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 115,648 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 71,560 115,648 557,272 502,526 1,345,039 308,222 ‐
AMOUNT AVAILABLE FOR DEBT SERVICE 137,536 (59,454) 643,790 359,346 160,596 182,170 7
DEBT SERVICE:
Principal ‐ 1,980 ‐ ‐ ‐ ‐ ‐
Interest and other debt service costs ‐ 42 ‐ ‐ ‐ ‐ ‐
TOTAL DEBT SERVICE ‐ 2,022 ‐ ‐ ‐ ‐ ‐
CAPITAL PROJECTS 60,348 ‐ ‐ 31,454 33,106 80,123 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 77,188 (61,476) 643,790 327,892 127,490 102,047 7
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, January 31, 2011 1,438,537 827,128 1,605,578 7,087,646 1,480,722 3,375,910 15,780
Page 10 of 34
Monthly Financial Report January 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 ‐ 2,992 ‐ ‐ ‐ ‐ ‐
Grants ‐ ‐ ‐ ‐ ‐ ‐ ‐
Charges for services
Equipment rental m&o 173,893 172,596 ‐ ‐ ‐ ‐ ‐
Telecommunications ‐ 31,623 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 8,872 ‐ 32,691 ‐ ‐ ‐
Communications ‐ ‐ ‐ 47,936 ‐ ‐ ‐
Facilities ‐ ‐ 343,072 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 12,507 ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ 26,104 ‐ ‐ ‐ ‐ ‐
Interest and other misc 2,343 915 117 38 2,587 2,792 1,423
Internal service fund misc:
Vehicle/equipment capital recovery 93,222 78,216 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 129,658 ‐ ‐
Worker's compensation / unemployment ‐ ‐ ‐ ‐ 110,603 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 864,020 9,034
Other misc 211 ‐ 3 ‐ ‐ 56,896 ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets 15,000 ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 7,464 ‐ ‐
TOTAL REVENUES 284,669 333,825 343,193 80,665 250,312 923,708 10,457
EXPENSES:
Communications 42,972
Equipment rental 110,316
Facilities 294,182
Healthcare 578,287
Information technology 296,891
Print and mail 31,914
Retiree healthcare 52,299
Risk ma nagement
Risk management 680,205
Unemployment 26,847
Worker's compensation 130,249
TOTAL EXPENSES 110,316 296,891 294,182 74,886 837,301 578,287 52,299
AMOUNT AVAILABLE FOR CAPITAL 174,353 36,934 49,011 5,779 (586,989) 345,421 (41,842)
CAPITAL PROJECTS ‐ 9,875 25,000 ‐ ‐ ‐ ‐
TRANSFERS IN ‐ ‐ ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 174,353 27,059 24,011 5,779 (586,989) 345,421 (41,842)
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, January 31, 2011 5,467,460 1,976,224 265,057 75,993 6,103,035 6,547,315 3,329,195
Page 11 of 34
Monthly Financial Report January 2011
FUND BALANCE
Page 13 shows the ending fund balance as of January 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 January, the City has $9.8 million reported in combined general governmental fund balance of the current
year’s operating budget, which is approximately 10% of budgeted operating expenditures. This is a decrease of $1.6 million
from the beginning balance of January 1, 2011. January’s ending fund balance is under the anticipated General
Governmental Fund Balance of $10 million by $170k. Although the ending fund balance is below 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 34
Monthly Financial Report January 2011
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through January 31, 2011
Funds
Balance
01/01/2011
Budgeted
Revenue
Revenue
01/31/11
Total Funds
Available
Budgeted
Expenditure
Expenditure
01/31/11 Ending Balance
GENERAL GOVERNMENT FUNDS:11,407,119 98,221,926 5,379,006 16,786,125 98,934,406 6,990,157 9,795,968
000 General 9,477,148 71,689,933 4,230,017 13,707,165 72,568,621 5,630,932 8,076,233
001 Community Services 631,801 10,817,691 666,903 1,298,704 10,742,324 726,955 571,749
003 Street 116,298 8,391,801 344,152 460,450 8,293,144 588,400 (127,950)
004 Community Dev Block Grant (55,231) 304,000 ‐ (55,231) 304,000 17,455 (72,686)
005 Museum 66,830 195,966 21 66,851 208,407 17,146 49,705
006 Library 47,347 2,030,000 19 47,366 2,030,000 2,619 44,747
009 Farmers Market 81,630 52,500 935 82,565 47,875 1,467 81,098
010 Fire Memorial 1,251 ‐ 620 1,871 ‐ ‐ 1,871
011 Fire Health & Wellness 24,072 25,000 1,946 26,018 25,000 583 25,435
031 Park Memorial 176,950 ‐ 76 177,026 ‐ ‐ 177,026
201 Ltd GO Bonds Gen Govt Debt 312,938 1,983,075 48,465 361,403 1,983,075 ‐ 361,403
215 Gen Govt Misc Debt Service 526,085 2,731,960 85,852 611,937 2,731,960 4,600 607,337
SPECIAL REVENUE FUNDS:
102 Arterial Street 171,720 620,000 98,518 270,238 620,000 ‐ 270,238
108 Leased City Properties 759,594 744,933 10,069 769,663 614,457 11,952 757,711
110 Hotel Motel 212,950 245,000 49,124 262,074 245,000 24,562 237,512
118 Reserve for Paths & Trails 3,299 ‐ 1 3,300 ‐ ‐ 3,300
125 1% For Art 136,830 15,000 59 136,889 50,000 ‐ 136,889
127 Cable Communication 171,358 85,000 12,361 183,719 85,674 ‐ 183,719
135 Springbrook Wetlands Bank 660,524 ‐ 283 660,807 ‐ ‐ 660,807
DEBT SERVICE FUNDS:
219 1989 Unlimited GO Bonds ‐ ‐ ‐ ‐ ‐ ‐ ‐
CAPITAL PROJECT FUNDS (CIP):
303 Community Dev Mitigation 1,343,877 60,000 6,416 1,350,293 400,000 ‐ 1,350,293
304 Fire Mitigation 1,929,477 100,000 7,660 1,937,137 529,056 ‐ 1,937,137
305 Transportation Mitigation 1,119,954 250,000 11,968 1,131,922 499,494 ‐ 1,131,922
316 Municipal Facilities CIP 5,759,297 13,310,000 30,477 5,789,774 14,962,000 78,601 5,711,173
317 Transportation CIP 3,808,080 10,657,819 1,060,039 4,868,119 11,647,819 119,976 4,748,143
318 So Lake WA Infrastructure Proj 58,522 ‐ 25 58,547 ‐ ‐ 58,547
326 Housing Opportunity 163,787 ‐ 63 163,850 ‐ 17,500 146,350
ENTERPRISE FUNDS:
402 Airport 1,295,036 636,214 209,065 1,504,101 1,125,756 71,560 1,432,541
403 Solid Waste Utility 961,788 15,015,942 1,201,062 2,162,850 14,951,710 557,272 1,605,578
404 Golf Course 630,924 2,483,545 56,081 687,005 2,504,738 126,007 560,998
422 Airport Capital 66,313 2,803,204 32 66,345 2,803,204 60,348 5,997
424 Golf Course Capital 257,680 100,000 8,451 266,131 100,000 ‐ 266,131
INTERNAL SERVICE FUNDS:
501 Equipment Repair/Replacement 5,293,107 3,211,401 284,670 5,577,777 3,195,267 110,316 5,467,461
502 Insurance 6,690,024 3,178,883 250,312 6,940,336 3,293,564 837,301 6,103,035
503 Information Services 1,949,165 4,029,664 333,825 2,282,990 4,513,461 306,765 1,976,225
504 Facilities 241,046 4,243,673 343,193 584,239 4,256,261 319,182 265,057
505 Communications 70,214 953,941 80,665 150,879 957,746 74,886 75,993
512 Insurance, Healthcare 6,201,894 11,248,058 923,708 7,125,602 10,844,696 578,287 6,547,315
522 Insurance, Leoff1 Retirees HC 3,371,037 2,235,684 10,457 3,381,494 2,261,732 52,299 3,329,195
FIDUCIARY FUNDS:
611 Firemen's Pension 4,286,248 300,000 664 4,286,912 565,475 27,774 4,259,138
Funds
Balance
01/01/2011
Budgeted
R evenue
Revenue
01/31/11
Total Funds
Available
Budgeted
Expenditure
Expenditure
01/31/11 Ending Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 11,402,622 44,828,741 2,857,906 14,260,528 44,901,718 2,300,471 11,960,057
405 Water Utility 4,695,116 9,680,689 805,040 5,500,156 10,107,179 502,527 4,997,629
406 Waste Water Utility 681,616 4,896,139 470,045 1,151,661 4,831,929 292,803 858,858
407 Surface Water Utility 1,462,126 5,155,153 460,275 1,922,401 4,865,850 308,222 1,614,179
416 King County Metro 671,616 13,156,760 982,131 1,653,747 13,156,760 1,052,236 601,511
425 Water Utility Construction 2,064,638 4,500,000 56,831 2,121,469 4,500,000 31,454 2,090,015
426 Waste Water Construction ‐ 3,790,000 53,459 53,459 3,790,000 33,106 20,353
427 Surface Water Construction 1,811,737 3,650,000 30,118 1,841,855 3,650,000 80,123 1,761,732
461 Waterworks Bond Reserve ‐ ‐ ‐ ‐ ‐ ‐ ‐
471 Waterworks Rate Stabilization 15,773 ‐ 7 15,780 ‐ ‐ 15,780
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 34
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
March
April
May
June
July
August
September
October
November
December
1,500,000
2,500,000
3,500,000
4,500,000
5,500,000
6,500,000
7,500,000
60,000,000
70,000,000
80,000,000
90,000,000
100,000,000
DifferenceRev/Exp Revenues
Expenditures
Difference
(7,500,000)
(6,500,000)
(5,500,000)
(4,500,000)
(3,500,000)
(2,500,000)
(1,500,000)
(500,000)
500,000
1,500,000
2,500,000
3,500,000
4,500,000
5,500,000
6,500,000
7,500,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 34
City of Renton
Monthly Revenue Analysis ‐ 2011 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 5,234,393 5,379,006 2.76%
Feb 10,726,046
Mar 15,949,429
Apr 28,328,731
May 42,891,216
Jun 49,901,941
Jul 55,746,350
Aug 60,921,650
Sep 65,834,562
Oct 78,488,144
Nov 92,843,165
Dec 98,221,926
Percent of budget 5.48%
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
Mar 1,055,236
Apr 7,832,248
May 16,721,331
Jun 16,838,318
Jul 16,927,805
Aug 17,079,566
Sep 17,579,784
Oct 24,763,004
Nov 32,178,212
Dec 32,046,525
Percent of budget 1.58%
$‐
$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 34
City of Renton
Monthly Revenue Analysis ‐ 2011 Budget Year
Sales Tax Budget
YTD
Actual
Annual %
over (under)
Jan 1,491,843 1,498,057 0.42%
Feb 3,491,814
Mar 4,982,841
Apr 6,665,538
May 8,397,076
Jun 10,063,873
Jul 11,510,791
Aug 13,212,038
Sep 14,839,724
Oct 16,513,820
Nov 18,258,011
Dec 19,879,280
Percent of budget 7.54%
Note: Includes Funds 108, 318, 501, and 503. 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,327,918 1,363,023 2.64%
Feb 2,730,318
Mar 4,071,451
Apr 5,375,642
May 6,650,552
Jun 7,856,535
Jul 9,036,840
Aug 10,208,135
Sep 11,328,373
Oct 12,506,725
Nov 13,658,198
Dec 15,016,600
Percent of budget 9.08%
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 34
City of Renton
Monthly Revenue Analysis ‐ 2011 Budget Year
Licenses/
Permits Budget
YTD
Actual
Annual %
over (under)
Jan 458,318 185,889 ‐59.44%
Feb 576,477
Mar 735,634
Apr 1,007,725
May 1,178,954
Jun 1,378,037
Jul 1,679,053
Aug 1,883,363
Sep 2,047,641
Oct 2,295,405
Nov 2,460,258
Dec 2,612,987
Percent of budget 7.11%
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 565,843 565,843 0.00%
Feb 994,382
Mar 1,492,835
Apr 2,067,467
May 2,879,087
Jun 5,271,136
Jul 5,728,865
Aug 6,356,734
Sep 6,878,568
Oct 7,586,128
Nov 10,426,467
Dec 10,976,730
Percent of budget 5.15%
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 34
City of Renton
Monthly Revenue Analysis ‐ 2011 Budget Year
Charges for
Svcs Budget
YTD
Actual
Annual %
over (under)
Jan 457,901 323,609 ‐29.33%
Feb 894,219
Mar 1,374,914
Apr 2,009,749
May 2,536,795
Jun 3,129,991
Jul 3,937,749
Aug 4,470,269
Sep 4,928,235
Oct 5,439,554
Nov 5,833,087
Dec 6,366,817
Percent of budget 5.08%
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
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 5.23%
$‐
$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 34
City of Renton
Monthly Revenue Analysis ‐ 2011 Budget Year
Other Taxes Budget
YTD
Actual
Annual %
over (under)
Jan 306,004 628,259 105.31%
Feb 827,674
Mar 1,138,659
Apr 1,887,139
May 2,191,462
Jun 2,511,537
Jul 3,667,441
Aug 4,013,540
Sep 4,214,699
Oct 5,030,918
Nov 5,312,703
Dec 6,225,921
Percent of budget 10.09%
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
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 10.24%
$‐
$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 34
City of Renton
Monthly Revenue Analysis ‐ 2011 Budget Year
Other
Financing Budget
YTD
Actual
Annual %
over (under)
Jan ‐ ‐ N/A
Feb 5
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.00%
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
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 7.23%
Note: Combines Funds 201, 215, 316, and 318
$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 34
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,064,387 6,990,159 ‐1.05%
Feb 15,690,539
Mar 23,447,618
Apr 31,043,698
May 40,588,339
Jun 48,858,760
Jul 56,984,282
Aug 64,977,806
Sep 72,803,211
Oct 80,261,428
Nov 88,068,108
Dec 98,934,405
Percent of budget expended 7.07%
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,688 22,021 ‐2.94%
Feb 46,076
Mar 69,606
Apr 93,677
May 116,993
Jun 140,279
Jul 163,144
Aug 186,174
Sep 208,887
Oct 230,366
Nov 253,582
Dec 277,834
Percent of budget expended 7.93%
$‐
$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 34
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Court Services Budget
YTD
Actual
Annual %
over (under)
Jan 170,312 163,613 ‐3.93%
Feb 345,696
Mar 528,996
Apr 705,138
May 880,207
Jun 1,060,770
Jul 1,241,164
Aug 1,415,034
Sep 1,592,418
Oct 1,751,342
Nov 1,921,106
Dec 2,104,953
Percent of budget expended 7.77%
Executive 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.80
Millions Executive
Budget
Actual
g ()
Jan 104,961 112,718 7.39%
Feb 232,093
Mar 357,479
Apr 482,123
May 603,741
Jun 720,398
Jul 848,257
Aug 965,685
Sep 1,099,931
Oct 1,220,429
Nov 1,335,457
Dec 1,454,762
Percent of budget expended 7.75%
$‐
$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.30
$0.60
$0.90
$1.20
$1.50
$1.80
Millions Executive
Budget
Actual
Last Year
Page 22 of 34
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Finance Budget
YTD
Actual
Annual %
over (under)
Jan 169,628 155,421 ‐8.38%
Feb 310,667
Mar 470,364
Apr 612,491
May 786,053
Jun 930,339
Jul 1,079,150
Aug 1,230,559
Sep 1,381,681
Oct 1,483,301
Nov 1,614,905
Dec 1,909,797
Percent of budget expended 8.14%
City Attorney Budget
YTD
Actual
Annual %
over (under)$1.60
Millions City Attorney
Budget
Actual
$‐
$0.40
$0.80
$1.20
$1.60
$2.00
$2.40
Millions Finance
Budget
Actual
Last Year
y y g ()
Jan 103,074 130,446 26.56%
Feb 244,577
Mar 396,147
Apr 541,700
May 682,818
Jun 823,809
Jul 963,280
Aug 1,105,999
Sep 1,241,404
Oct 1,376,729
Nov 1,510,645
Dec 1,600,531
Percent of budget expended 8.15%
$‐
$0.40
$0.80
$1.20
$1.60
Millions City Attorney
Budget
Actual
Last Year
$‐
$0.40
$0.80
$1.20
$1.60
$2.00
$2.40
Millions Finance
Budget
Actual
Last Year
Page 23 of 34
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Human
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 76,207 86,565 13.59%
Feb 150,820
Mar 230,641
Apr 309,475
May 387,409
Jun 468,586
Jul 548,540
Aug 627,943
Sep 707,460
Oct 782,690
Nov 855,852
Dec 948,554
Percent of budget expended 9.13%
Public Works Budget
YTD
Actual
Annual %
over (under)
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
Millions Human Resources
Budget
Actual
Last Year
$0.60
Millions Public Works
Budget
Actual
g ()
Jan 36,312 37,289 2.69%
Feb 74,186
Mar 112,900
Apr 154,189
May 191,427
Jun 228,375
Jul 266,289
Aug 306,966
Sep 342,896
Oct 378,231
Nov 415,137
Dec 454,179
Percent of budget expended 8.21%
Note: For comparative purposes history does not include Development Svcs division (now in CED).
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
Millions Human Resources
Budget
Actual
Last Year
$‐
$0.20
$0.40
$0.60
Millions Public Works
Budget
Actual
Last Year
Page 24 of 34
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Other City
Services Budget
YTD
Actual
Annual %
over (under)
Jan 219,839 219,534 ‐0.14%
Feb 485,931
Mar 746,405
Apr 1,135,150
May 1,167,546
Jun 1,376,056
Jul 1,485,789
Aug 1,685,529
Sep 1,865,514
Oct 2,068,532
Nov 2,215,123
Dec 3,120,946
Percent of budget expended 7.03%
Police Budget
YTD
Actual
Annual %
over (under)
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
Millions Other City Services
Budget
Actual
Last Year
$30
$33
Millions Police
Budget
Actual
g ()
Jan 2,381,621 2,369,174 ‐0.52%
Feb 4,961,251
Mar 7,540,268
Apr 9,955,299
May 12,384,430
Jun 15,069,808
Jul 17,625,836
Aug 20,139,565
Sep 22,813,601
Oct 25,058,517
Nov 27,861,903
Dec 30,651,495
Percent of budget expended 7.73%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
Millions Other City Services
Budget
Actual
Last Year
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
Millions Police
Budget
Actual
Last Year
Page 25 of 34
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Fire & Emerg
Svc Budget
YTD
Actual
Annual %
over (under)
Jan 1,895,249 1,753,670 ‐7.47%
Feb 4,468,183
Mar 6,251,234
Apr 7,901,795
May 9,626,861
Jun 11,379,253
Jul 13,165,123
Aug 14,923,518
Sep 16,714,411
Oct 18,361,473
Nov 20,199,683
Dec 22,020,916
Percent of budget expended 7.96%
City Clerk Budget
YTD
Actual
Annual %
over (under)
$‐
$3
$6
$9
$12
$15
$18
$21
$24
Millions Fire & Emergency Services
Budget
Actual
Last Year
$0.80
Millions City Clerk
Budget
Actual
y g ()
Jan 51,492 49,604 ‐3.67%
Feb 103,964
Mar 160,690
Apr 280,717
May 380,998
Jun 435,248
Jul 485,776
Aug 534,201
Sep 583,630
Oct 678,085
Nov 727,878
Dec 790,484
Percent of budget expended 6.28%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
Millions Fire & Emergency Services
Budget
Actual
Last Year
$0.00
$0.20
$0.40
$0.60
$0.80
Millions City Clerk
Budget
Actual
Last Year
Page 26 of 34
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Human
Services Budget
YTD
Actual
Annual %
over (under)
Jan 42,339 36,301 ‐14.26%
Feb 82,116
Mar 128,349
Apr 284,898
May 344,583
Jun 396,861
Jul 524,848
Aug 572,185
Sep 610,449
Oct 732,276
Nov 801,654
Dec 952,071
Percent of budget expended 3.81%
Note: General Fund only
Hearing
Examiner Budget
YTD
Actual
Annual %
over (under)
$0.00
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
$0.70
$0.80
$0.90
$1.00
Millions Human Svcs (Comm Svcs)
Budget
Actual
Last Year
$180,000
Hearing Examiner
Budget
Actual
g ()
Jan 14,528 14,189 ‐2.33%
Feb 28,905
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,368
Dec 171,929
Percent of budget expended 8.25%
$0.00
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
$0.70
$0.80
$0.90
$1.00
Millions Human Svcs (Comm Svcs)
Budget
Actual
Last Year
$‐
$30,000
$60,000
$90,000
$120,000
$150,000
$180,000
Hearing Examiner
Budget
Actual
Last Year
Page 27 of 34
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
CED Budget
YTD
Actual
Annual %
over (under)
Jan 494,252 480,388 ‐2.81%
Feb 1,010,255
Mar 1,507,990
Apr 1,989,227
May 2,496,921
Jun 3,022,151
Jul 3,530,578
Aug 4,027,029
Sep 4,598,269
Oct 5,092,826
Nov 5,565,814
Dec 6,110,169
Percent of budget expended 7.86%
Note: For comparative purposes history includes Development Svcs division (previously in Public Works).
Note: General Fund only
General Fund Budget
YTD
Actual
Annual %
over (under)$75
Millions General Fund
Budget
Actual
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
$7.00
Millions Community & Economic
Development
Budget
Actual
Last Year
g ()
Jan 5,745,258 5,630,932 ‐1.99%
Feb 12,467,289
Mar 18,430,978
Apr 24,433,129
May 29,909,157
Jun 35,856,156
Jul 41,631,892
Aug 47,377,876
Sep 53,354,628
Oct 58,777,681
Nov 64,730,485
Dec 72,568,621
Percent of budget expended 7.76%
$‐
$15
$30
$45
$60
$75
Millions General Fund
Budget
Actual
Last Year
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
$7.00
Millions Community & Economic
Development
Budget
Actual
Last Year
Page 28 of 34
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Community
Svcs Fund Budget
YTD
Actual
Annual %
over (under)
Jan 626,922 726,955 15.96%
Feb 1,463,642
Mar 2,276,299
Apr 3,077,891
May 3,920,089
Jun 4,805,686
Jul 5,934,382
Aug 7,122,376
Sep 8,070,064
Oct 8,906,998
Nov 9,792,166
Dec 10,742,324
Percent of budget expended 6.77%
Street Fund Budget
YTD
Actual
Annual %
over (under)
$‐
$2
$4
$6
$8
$10
$12
Millions Community Svcs Fund
Budget
Actual
Last Year
$8
$9
Millions Street Fund
Budget
Actual
g ()
Jan 621,239 588,400 ‐5.29%
Feb 1,311,727
Mar 2,005,531
Apr 2,699,087
May 3,381,529
Jun 4,091,257
Jul 4,768,475
Aug 5,521,326
Sep 6,185,359
Oct 6,880,905
Nov 7,531,004
Dec 8,293,144
Percent of budget expended 7.10%
$‐
$2
$4
$6
$8
$10
$12
Millions Community Svcs Fund
Budget
Actual
Last Year
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
Millions Street Fund
Budget
Actual
Last Year
Page 29 of 34
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
CDBG Budget
YTD
Actual
Annual %
over (under)
Jan 12,494 17,455 39.71%
Feb 32,862
Mar 52,407
Apr 77,593
May 95,271
Jun 115,544
Jul 172,529
Aug 197,059
Sep 215,369
Oct 242,671
Nov 266,651
Dec 304,000
Percent of budget expended 5.74%
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
CDBG
Budget
Actual
Last Year
y g ()
Jan 2,619 2,619 0.00%
Feb 259,962
Mar 471,305
Apr 547,349
May 897,402
Jun 969,447
Jul 1,316,678
Aug 1,397,188
Sep 1,518,602
Oct 1,870,747
Nov 1,951,541
Dec 2,030,000
Percent of budget expended 0.13%
$‐
$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
CDBG
Budget
Actual
Last Year
Page 30 of 34
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Museum Fund Budget
YTD
Actual
Annual %
over (under)
Jan 16,752 17,146 2.35%
Feb 34,481
Mar 51,445
Apr 68,801
May 86,527
Jun 104,531
Jul 122,389
Aug 140,166
Sep 157,921
Oct 175,477
Nov 193,118
Dec 208,407
Percent of budget expended 8.23%
Note: Prior to 2009, Museum was part of the Library Fund
Farmer's
Market Fund Budget
YTD
Actual
Annual %
over (under)
$‐
$30,000
$60,000
$90,000
$120,000
$150,000
$180,000
$210,000
Museum Fund
Budget
Actual
Last Year
$50,000
Farmer's Market Fund
Budget
Actual
g ()
Jan 1,777 1,467 ‐17.47%
Feb 3,988
Mar 6,727
Apr 8,728
May 12,914
Jun 20,638
Jul 27,421
Aug 35,535
Sep 37,093
Oct 39,747
Nov 40,954
Dec 47,875
Percent of budget expended 3.06%
$‐
$30,000
$60,000
$90,000
$120,000
$150,000
$180,000
$210,000
Museum Fund
Budget
Actual
Last Year
$‐
$10,000
$20,000
$30,000
$40,000
$50,000
Farmer's Market Fund
Budget
Actual
Last Year
Page 31 of 34
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Health &
Wellness Budget
YTD
Actual
Annual %
over (under)
Jan 82 583 611.50%
Feb 682
Mar 1,206
Apr 22,159
May 22,159
Jun 22,488
Jul 22,805
Aug 23,129
Sep 23,359
Oct 23,636
Nov 25,000
Dec 25,000
Percent of budget expended 2.33%
LTGO Funds Budget
YTD
Actual
Annual %
over (under)
$11.00
$12.00
Millions LTGO Funds
Budget
Actual
$‐
$5,000
$10,000
$15,000
$20,000
$25,000
Fire Health & Wellness Fund
Budget
Actual
Last Year
g ()
Jan ‐ 4,600 100.00%
Feb 38,475
Mar 38,475
Apr 38,475
May 2,050,522
Jun 2,590,912
Jul 2,590,912
Aug 2,705,487
Sep 2,705,487
Oct 2,763,341
Nov 2,831,567
Dec 4,715,035
Percent of budget expended 0.10%
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
$7.00
$8.00
$9.00
$10.00
$11.00
$12.00
Millions LTGO Funds
Budget
Actual
Last Year
$‐
$5,000
$10,000
$15,000
$20,000
$25,000
Fire Health & Wellness Fund
Budget
Actual
Last Year
Page 32 of 34
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
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 5.66%
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
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 6.36%
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 33 of 34
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
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 5.03%
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 34 of 34