HomeMy WebLinkAbout201103, March.pdfFINANCE AND
INFORMATION TECHNOLOGY
M E M O R A N D U M
DATE: April 28, 2011
TO: Terri Briere, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: March 2011 Financial Status Report
At the end of March, general governmental revenues show $545k or 3.4% over budget. This
includes $531k of favorable property tax and $270k 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 $204k.
On the expenditures’ side, most departments conserved their spending and showed favorable
variances. Overall general governmental funds are showing a $1.1 million or 4.4% savings. A
few divisions may appear to exceed their budget at the end of March, most are due to the
timing of various payments and expenditures are on track when combined department level.
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 960,777 31,497,128 1,037,146 32,046,525 1,055,236 1,586,980 531,744 50.4%
Sales Tax 17,995,836 4,782,509 17,198,220 4,307,540 17,759,600 4,350,990 4,621,165 270,175 6.2%
Sales Tax ‐ Annexation Credit 2,132,110 564,676 2,025,660 511,021 2,119,680 534,740 515,376 (19,364) ‐3.6%
Criminal Justice Sa les Tax 1,650,350 436,358 1,620,479 413,523 1,804,005 460,357 433,145 (27,211) ‐5.9%
Natural Gas Use Tax 242,891 56,975 228,514 73,944 258,750 83,728 81,939 (1,788) ‐2.1%
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,479,929 5,036,907 1,381,772 4,968,000 1,362,868 1,471,764 108,895 8.0%
Natural Ga s Utility Tax 1,891,255 845,949 1,577,756 599,950 1,656,000 629,702 743,650 113,948 18.1%
Transfer Station 283,985 52,193 269,912 62,164 238,050 54,826 62,236 7,410 13.5%
TV Cable 1,263,743 310,738 1,296,744 327,983 1,366,200 345,551 313,748 (31,803) ‐9.2%
Telephone 1,037,873 255,239 1,038,009 269,528 1,000,000 259,658 251,762 (7,896) ‐3.0%
Cellular Phone 2,027,473 467,855 2,206,637 553,363 2,202,000 552,201 534,865 (17,336) ‐3.1%
City Utilities 2,871,599 681,906 2,853,884 664,892 3,477,600 810,204 832,175 21,971 2.7%
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 569,842 1,546,386 336,398 1,600,000 416,882 389,297 (27,586) ‐6.6%
Real Estate Excise Tax 2,418,456 483,801 2,464,489 487,709 2,240,000 443,487 403,288 (40,199) ‐9.1%
Less: Municipal Facilities CIP REET (1,000,000) (211,038) (400,000) (81,027) (400,000) (81,027) (72,016) 9,012 ‐11.1%
EMS Levy 1,170,657 ‐ 1,161,114 ‐ 950,921 ‐ ‐ ‐ 0.0%
Business License Fees 424,413 118,353 431,782 117,082 463,067 125,565 111,073 (14,492) ‐11.5%
Other Licenses and Permits 176,851 39,415 262,629 62,268 210,255 49,851 43,772 (6,079) ‐12.2%
Building Permits & Development Svc Fees 2,361,037 623,307 2,437,270 659,298 2,706,044 744,071 540,074 (203,998) ‐27.4%
Intergovernmental (Grants, State Shared R 3,820,932 766,431 4,426,676 1,103,708 3,623,386 896,680 936,670 39,990 4.5%
Fire District 25 and 40 Contracts 5,869,198 8,109 5,252,877 19,525 5,928,462 278,286 278,286 ‐ 0.0%
Public Safety 521,484 134,041 482,343 100,750 426,081 88,999 90,072 1,073 1.2%
Culture and Recreation 1,631,486 219,431 1,424,932 226,688 1,628,486 259,071 243,967 (15,104) ‐5.8%
Interfund/Interdept‐Services 3,225,745 783,565 3,190,908 766,090 3,314,653 795,800 724,768 (71,032) ‐8.9%
Fines and Forfeits 1,349,034 292,614 1,291,817 205,000 1,088,750 167,655 218,547 50,892 30.4%
Photo Enforcement 2,368,131 616,448 1,925,159 495,096 1,900,908 488,859 527,825 38,966 8.0%
Seizure Funds ‐ Federal/State/Local 99,844 27,157 221,046 46,627 180,693 38,115 ‐ (38,115) ‐100.0%
Interests and Other Earnings 535,314 111,818 327,558 73,008 477,730 106,479 44,893 (61,586) ‐57.8%
Rents, Leases, and Concessions 677,960 232,834 727,338 241,192 698,929 231,771 219,861 (11,911) ‐5.1%
Contributions and Donations 150,406 29,115 133,756 29,179 146,800 32,025 43,874 11,849 37.0%
Other Miscellaneous 355,086 65,610 290,239 66,801 352,218 84,807 47,740 (37,067) ‐43.7%
Refunding Debt and Premiums ‐ ‐ 6,613,484 ‐ ‐ ‐ ‐ ‐ 0.0%
Other Financing Sources (Transfer‐In, etc) 578,206 175 653,595 138 529,056 2,675 2,675 ‐ 0.0%
Total Operating Revenues 97,342,052 16,151,285 103,367,918 15,590,071 98,647,849 16,110,328 16,654,842 544,513 3.4%
OPERATING EXPENDITURES
Legislative 247,225 61,632 259,345 65,280 277,834 69,607 67,521 2,085 3.0%
Executive 1,499,747 348,810 1,578,526 407,609 1,484,762 364,848 346,789 18,059 4.9%
City Clerk 646,581 145,727 789,209 146,137 790,484 160,688 154,386 6,302 3.9%
Hearing Examiner 171,911 43,524 174,447 43,412 171,929 43,154 23,616 19,538 45.3%
City Attorney 1,248,380 296,034 1,565,597 400,465 1,600,531 396,154 395,280 874 0.2%
Court Services 1,819,731 462,719 2,007,599 499,117 2,148,421 539,914 490,833 49,081 9.1%
Community and Eco Dvlpmnt Admin 265,269 69,432 579,396 146,045 929,263 237,058 232,560 4,498 1.9%
Development Services 3,615,129 943,965 2,946,413 768,673 3,164,064 825,857 716,400 109,457 13.3%
Economic Development 1,244,175 318,971 1,322,004 305,673 745,313 181,420 179,805 1,615 0.9%
Planning 1,525,460 330,141 1,774,508 383,792 1,545,279 334,314 348,727 (14,413) ‐4.3%
Finance 1,969,936 587,513 2,214,458 443,082 2,101,797 517,662 467,036 50,626 9.8%
Human Resources 853,063 203,059 861,221 213,772 977,884 237,774 221,683 16,091 6.8%
Police 22,515,895 5,659,041 23,946,386 6,053,699 23,988,409 6,047,270 6,305,557 (258,287) ‐4.3%
Jail Services 3,317,861 780,255 3,539,035 623,568 7,043,820 1,442,092 769,664 672,428 46.6%
Fire 20,378,891 5,933,659 21,554,792 5,943,458 22,045,916 6,244,191 5,900,678 343,513 5.5%
Community Services Admin1 4,459,381 1,135,810 1,063,011 263,482 412,476 104,515 102,208 2,307 2.2%
Parks 3,894,745 776,991 3,421,424 732,269 3,928,721 810,460 799,401 11,059 1.4%
Parks Planning & Natural Resources ‐ ‐ 448,574 80,116 582,186 145,547 109,668 35,878 24.7%
Recreation 4,374,668 823,513 4,433,420 886,597 5,178,448 1,005,407 1,058,705 (53,298) ‐5.3%
Human Services 1,194,142 159,707 1,326,778 207,504 1,363,272 198,582 177,533 21,048 10.6%
Neighborhoods, Resources, & Events 348,185 62,782 331,222 64,287 688,984 128,860 110,686 18,174 14.1%
Library 2,321,878 479,590 2,289,692 500,663 2,030,000 7,619 7,619 ‐ 0.0%
Museum 140,801 35,858 191,090 46,726 208,407 51,858 51,915 (57) ‐0.1%
Public Works Admin 1 942,026 232,805 514,858 129,351 454,179 112,901 111,889 1,012 0.9%
Street Maintenance 3,794,716 924,161 3,412,892 816,882 3,693,925 892,291 894,017 (1,726) ‐0.2%
Transportation 5,110,639 1,237,670 5,215,309 1,261,456 4,606,639 1,114,917 1,101,787 13,130 1.2%
Debt Service 4,176,822 ‐ 11,320,584 126,390 4,715,035 390,380 390,380 ‐ 0.0%
Non‐Departmental and Other 5,126,072 1,065,371 4,834,296 1,136,033 3,820,946 1,784,740 1,784,740 ‐ 0.0%
Total Operating Expenditures 97,203,328 23,118,739 103,916,084 22,695,538 100,698,925 24,390,079 23,321,083 1,068,996 4.4%
Total Ending Fund Balance 11,955,285$ 4,849,107$ 11,407,119$ 4,849,818$ 9,356,043$ 3,127,368$ 4,740,878$ 1,613,510 51.6%
1Facilities was included in Community Services Admin and Technical Services was included in Public Works Admin in 2009
Favorable (Unfavorable)
2009 2010 2011 Variance
Annual Actual YTD Actual Annual Budget YTD Budget YTD ActualSummary of Sources and Uses Annual Actual YTD Actual
Monthly Financial Report March 2011
Page 1 of 37
Monthly Financial Report March 2011
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through March 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 73% of
all resources supporting general governmental activities. The following section provides detail information on property,
sales, utility, and other taxes.
Property Tax
March’s collection is $745k,
making the total year‐to‐date
collection $1.6 million or 5% of
the total budget. In comparison
to the previous year, the City
collected $550k or 53% more.
Compared to the budget, the City
is above projections by $532k or
50%. The City is projecting
property taxes to meet the 2011
budget at year‐end.
Sales Tax
March 2011 sales tax receipts
totaled $1.3 million. Compared to
the same month last year, it is $10k
or 1% more. Compared to the
projected current month’s budget, it
is above projections by $12k or 1%.
The year‐to‐date collection is $4.6
million or 26% of the sales tax
budget, which is $314k or 7% more
than the prior year and also $270k or
6% 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 745,285 197,653 36% 188,101 34%
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 1,037,146$ 1,055,236$ 1,586,980$ 549,834$ 53% 531,744$ 50%
Annual Total 31,497,128$ 32,046,525$
Property Tax Revenues
Year to Date through March
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 1,299,237 9,648 1% 11,571 1%
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 4,307,540$ 4,350,990$ 4,621,165$ 313,624$ 7% 270,175$ 6%
Annual Total 17,198,220$ 17,759,600$
2011 vs. Budget2011 vs. 2010
Month
Year to Date through March
Local Retail Sales Tax Revenues
Page 2 of 37
Monthly Financial Report March 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 457,001$ 415,129$ 360,477$ (96,524)$ ‐21%$ (54,652)‐13%
Auto Sales 719,899 782,196 788,059 68,160 9% 5,863 1%
General Retail 1,594,135 1,635,387 1,603,505 9,370 1% (31,882)‐2%
Manufacturing 212,902 191,871 423,520 210,617 99% 231,648 121%
Wholesale 243,265 279,883 295,717 52,451 22% 15,833 6%
Service 952,299 897,908 1,023,389 71,090 7% 125,481 14%
Other 128,038 148,615 126,498 (1,540) ‐1% (22,117)‐15%
Total 4,307,540$ 4,350,990$ 4,621,165$ 313,624$ 7%270,175$ 6%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility tax
March utility tax revenues are $1.5
million, which is $185k or 14% higher
than the same month last year and also
ahead of the budget by $134k or 10%.
The year‐to‐date collection is $4.3
million, which is $359k or 9% higher
than the prior year and is also $193k or
5% 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 1,381,772$ 1,362,868$ 1,471,764$ 89,992$ 7%$ 108,895 8%
Natural Gas 673,894 713,430 825,589 151,696 23% 112,159 16%
Cell 553,363 552,201 534,865 (18,498) ‐3% (17,336)‐3%
Phone 269,528 259,658 251,762 (17,766) ‐7% (7,896)‐3%
Cable 327,983 345,551 313,748 (14,235) ‐4% (31,803)‐9%
Transfer Station 62,164 54,826 62,236 72 0% 7,410 14%
City Utilities 664,892 810,204 832,175 167,283 25% 21,971 3%
YTD Total 3,933,596$ 4,098,738$ 4,292,138$ 358,543$ 9%193,401$ 5%
Annual Total 14,508,363$ 15,166,600$
YTD as % of 27% 27%
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 1,480,840 185,108 14% 133,881 10%
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 3,933,596$ 4,098,738$ 4,292,138$ 358,543$ 9% 193,401$ 5%
Annual Total 14,508,363$ 15,166,600$
2011 vs. Budget2011 vs. 2010
Year to Date through March
Utility Tax Revenues
Month
Page 3 of 37
Monthly Financial Report March 2011
Other Taxes
Real Estate Excise Tax
The City collected $142k in Real Estate
Excise Tax revenues (REET) in March.
This is $139k or 50% below the current
month’s budget and $167k or 54%
behind the same month last year. The
year‐to‐date collection is $403k or 18%
of the total budget, which is $84k or
17% less than the prior year and is also
$40k or 9% below the budget. Based on
the collections so far, the City is
projecting REET to be slightly under the
2011 budget by year‐end.
Gambling Tax
March’s Gambling Tax collections
total $135k. Year‐to‐date total of
$389k is $53k or 16% above the
year before but is $28k or 7%
below budget.
The lower tax collection is due to
cross‐the‐board reduction in
gambling activities. Pull tabs
overall increased by 1%, bingo
reduced by 36%, and card‐rooms
are seeing 3% lower in activities
when compared to the prior year.
Franchise Fees
Franchise Fees are due quarterly
and the year‐to‐date revenue
collections are $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 141,700 (167,464) ‐54% (139,421) ‐50%
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 487,709$ 443,487$ 403,288$ (84,421)$ ‐17% (40,199)$ ‐9%
Annual Total 2,464,489$ 2,240,000$
Mo nth
2011 vs. Budget2011 vs. 2010
Real Estate Excise Tax Revenues
Year to Date through March
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 134,061 135,067 72,013 114% 1,006 1%
Apr 196,085 134,062 ‐
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 336,398$ 416,882$ 389,297$ 52,899$ 16% (27,586)$ ‐7%
Annual Total 1,546,386$ 1,600,000$
2011 vs. 2010 2011 vs. Budget
Gambling Tax Revenue
Month
Year to Date through March
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 March
Month
2011 vs. 2010 2011 vs. Budget
Page 4 of 37
Monthly Financial Report March 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 $266k in
March. 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 $540k is
$204k or 27% less than the budget and is
also $119k or 18% lower than 2010.
Business Licenses totaled $4k for March, which
is $2k or 33% below the same month last year
and is also $2k or 38% below the current
month’s budget. The year‐to‐date Business
Licenses revenue is under the budget by $14k or
12% and is also $6k or 5% below last year.
The reason for the decline from the prior year is
we are seeing less licenses being renewed. In
the 1st quarter of 2010 (billed for 4th quarter of
2009), there were 1,479 licenses that were billed
for renewals. The total FTE count was 40,820.
In the 1st quarter of 2011 (billed for 4th quarter
of 2010), there were 1,453 licenses that were
billed for renewals. The total FTE count was
38,820. Since there was a decline in both
renewals and FTEs, we would expect a decrease
in Business Licenses revenues.
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$
Month
2011 vs. 2010 2011 vs. Budget
Admission Tax Revenue
Year to Date through Ma rch
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 3,811 (1,875) ‐33% (2,287) ‐38%
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 117,082$ 125,565$ 111,073$ (6,008)$ ‐5% (14,492)$ ‐12%
Annual Total 431,782$ 463,067$
Business Licenses
Month
2011 vs. 2010
Year to Date through March
2011 vs. Budget
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 265,782 93,686 54% 77,215 41%
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 659,298$ 744,071$ 540,074$ (119,225)$ ‐18% (203,998)$ ‐27%
Annual Total 2,437,270$ 2,706,044$
Building Permits and Development Service Fees
Year to Date through March
2011 vs. Budget2011 vs. 2010
Month
Page 5 of 37
Monthly Financial Report March 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 77%
of the total revenues in this category. The year‐to‐date total Intergovernmental revenue is $1.6 million or 15% of the
budget. All grant revenues also have corresponding expenditures which was added to the City’s budget through the 2011
carry forward budget adjustment.
State Shared Revenue
collections totaled $986k
since the start of 2011.
Compared to the projected
budget, State Shared
Revenues are above by
$104k or 12%. Compared to
the prior year, the City is
collecting $42k or 4% 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 77% of the total revenue in this category. The year‐to‐date total charges for services are $1.3 million or 20% of
the budget. This is 8% below budget projections. The following sections provide detail information for Public Safety,
Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totaled $90k 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 1% more than anticipated
revenue. Compared to the prior year, the
City is collecting $11k or 11% 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 30,346 (4,440) ‐13% (382) ‐1%
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 100,750$ 88,999$ 90,072$ (10,679)$ ‐11% 1,073$ 1%
Annual Total 482,343$ 426,081$
Month
2011 vs. 2010
Year to Date through March
Public Safety Services
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 19,525 278,286 278,286 258,761 1325%‐ 0%
State Shared Revenue 943,591 881,371 985,806 42,215 4% 104,434 12%
Federal Grants 291,186 167,370 167,370 (123,816) ‐43%‐ 0%
State Grants 96,391 48,791 48,791 (47,600) ‐49%‐ 0%
Other Grants/Intgovt 69,161 41,933 41,933 (27,228) ‐39%‐ 0%
ARRA Grants 116,903 125,916 125,916 9,013 8%‐ 0%
Total Rev YTD 1,536,757$ 1,543,667$ 1,648,102$ 111,345$ 7%104,434$ 7%
Total Rev Annual 11,300,032$ 11,355,853$
YTD % 14% 14% 15%
Note: Includes CJ Sales Tax.
2010 2011 2011
Actual Budget Actual $ % $ %
Crim Just Sales Tax 413,523$ 460,357$ 433,145$ 19,622$ 5% (27,211)$ ‐6%
Judicial Contribution 17,229 7,253 11,234 (5,995)$ ‐35% 3,981 55%
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 195,587 115,672 168,155 (27,432) ‐14% 52,483 45%
Liquor Excise Tax 103,016 103,051 104,651 1,636 2% 1,601 2%
Fuel Tax 188,118 174,772 194,493 6,374 3% 19,721 11%
YTD Total 943,591$ 881,371$ 985,806$ 42,215$ 4% 104,434$ 12%
Annual Total 4,189,298$ 3,874,444$
2011 vs. Budget
State Shared Revenues
2011 vs. 2010
Revenue
Year to Date through March
Page 6 of 37
Monthly Financial Report March 2011
Recreation
Recreation revenues totaled $100k for
the current month. Compared to the
projected monthly budget, the City
collected $14k or 12% less. Compared to
the same month the prior year, the City
collected $437 more. The year‐to‐date
collection of $244k is $17k or 8% more
than the prior year but $15k or 6% less
than the budget. The City is projecting
Recreation revenues to be slightly under
the 2011 budget by year‐end.
Interfund Services
The year‐to‐date collections for Interfund
Services revenues are $725k. Compared
to the projected budget, the revenues are
below by $71k or 9%. Compared to the
prior year, the revenues are under by $41k
or 5%. The majority of these revenues are
related to indirect cost allocations, which
are internal administrative costs. The
remaining costs consist of Development
Services division’s inspection fees,
Transportation division’s capital
investment program reimbursements, and
Maintenance division’s street
maintenance reimbursements.
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 $740k. This is $6k or 1%
lower than a year ago, but is $46k or
7% over 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.
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 99,537 437 0% (13,720) ‐12%
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 226,688$ 259,071$ 243,967$ 17,279$ 8% (15,104)$ ‐6%
Annual Total 1,424,932$ 1,628,486$
Recreation
Year to Date through March
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 251,144 1,386 1% (8,300) ‐3%
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 766,090$ 795,800$ 724,768$ (41,323)$ ‐5% (71,032)$ ‐9%
Annual Total 3,190,908$ 3,314,653$
Interfund Services
Year to Date through March
2011 vs. 2010 2011 vs. Budget
Month
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 313,067 33,756 12% 53,196 20%
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 746,724$ 694,630$ 740,442$ (6,282)$ ‐1% 45,812$ 7%
Annual Total 3,432,368$ 3,170,351$
2011 vs . Budget2011 vs. 2010
Year to Date through March
Fines and Penalties by Month
Month
Page 7 of 37
Monthly Financial Report March 2011
Year to Date through March
2010 2011 2011
Actual Budget Actual $ % $ %
Civil Penalties 2,434$ 2,248$ 2,901$ 467$ 19% 654$ 29%
Civil Infraction Penalties 126,678 114,501 141,715 15,037 12% 27,215 24%
Civil Parking Infraction Penalties 27,571 28,376 20,846 (6,725) ‐24% (7,530) ‐27%
Photo Enforcement Program 495,096 488,859 527,825 32,729 7% 38,966 8%
Criminal Traffic Misdemeanor Fines 15,107 13,818 18,121 3,014 20% 4,302 31%
Criminal Non‐Traffic Fines 4,907 4,999 6,143 1,236 25% 1,143 23%
Criminal Costs 17,539 1,838 22,851 5,312 30% 21,013 1143%
Seizure Funds ‐ Federal/State/Local 46,627 38,115 ‐ (46,627) 0% (38,115) 0%
Non‐Court Fines, Forfeitures and Penalties 10,765 1,875 40 (10,725) ‐100% (1,835) ‐98%
YTD Total 746,724$ 694,630$ 740,442$ (6,282)$ ‐1% 45,812$ 7%
Annual Total 3,432,368$ 3,170,351$
Revenue
2011 vs. Budget
Fines and Penalties by Type
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 $528k. 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 85% of the total revenue in
this category. The year‐to‐date total
miscellaneous is $312k. Compared to the
projected year‐to‐date budget, the
revenues are under by $101k or 24%.
Compared to last year, the revenues are
under by $60k or 16%. The table on the
next page breaks out Miscellaneous
revenues by type:
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 170,998$ 181,164$ 143,105$ (27,892)$ ‐16% (38,058)$ ‐21%
Feb 86,124 99,440 70,237 (15,887) ‐18% (29,203) ‐29%
Mar 115,122 132,824 99,131 (15,990) ‐14% (33,692) ‐25%
Apr 99,376 114,159
May 101,909 116,069
Jun 148,339 173,389
Jul 158,134 177,832
Aug 93,081 107,144
Sep 110,810 124,170
Oct 73,018 86,617
Nov 56,175 67,061
Dec 56,503 64,592
YTD Total 372,244$ 413,428$ 312,474$ (59,770)$ ‐16% (100,954)$ ‐24%
Annual Total 1,269,588$ 1,444,459$
Ye ar to Date through March
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 198,197 76,201 67,852 130,345
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 488,859$ 527,825$ 229,095$ 203,620$ 324,205$
Annual Total 1,900,908$ 841,964$
1 Actuals of Revenues and Expenses
Expenses
Photo Enforcement Program
Year to Date through March
Month
Page 8 of 37
Monthly Financial Report March 2011
2010 2011 2011
Actual Budget Actual $ % $ %
Interests and Other Earnings 73,008$ 106,479$ 44,893$ (28,115)$ ‐39% (61,586)$ ‐58%
Rents, Leases, and Concessions 241,192 231,771 219,861 (21,331) ‐9% (11,911) ‐5%
Contributions/Donations from Private Sources 29,179 32,025 43,874 14,694 50% 11,849 37%
Other 28,864 43,152 3,847 (25,018) ‐87% (39,305) ‐91%
YTD Total 372,244$ 413,428$ 312,474$ (59,770)$ ‐16% (100,954)$ ‐24%
Annual Total 1,269,588$ 1,444,459$
2011 vs. Budget
Miscellaneous Revenues by Type
Year to Date through March
Revenue
2011 vs. 2010
Rents, Leases, and Concessions are lower than the prior year due to receiving fewer revenues for the Carco Theater, Coulon
boat launches, and Coulon food concessions. Other revenues are lower than the prior year because this type of revenue
stream is one‐time types (unclaimed property, miscellaneous reimbursements for accidents, sale of scrap, etc.), which we
would expect to fluctuate.
EXPENSES
Overall the City has expended 23% of its budgeted general governmental expenditures at the end of March. This is $1.1
million or 4.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. At the end of March, there were no departments that are 10% or
greater over budget. Below are the explanations for the variances that are greater than 1% but less than 10% on
expenditures.
The Planning division of Community and Economic Development Department appears to be over budget by $14k or 4.3%.
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 Police Department is over budget by $258k or 4.3%. The majority of this is due to higher than anticipated salaries and
wages (by $146k) and overtime (by $94k). Of the $146k overage for salaries and wages (which includes budgeted uniform
allowance), $82k is related to various sick and vacation buy back/pay outs that was not included in the budget. If we
remove this amount, Police would only be $176k or 2.9% over budget. We are continuing to review the Police
department’s salaries and wages to determine the reason for the difference.
The Recreation division of Community Services Department is over budget by $53k or 5.3%. 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 this expense at year‐end.
Page 9 of 37
Monthly Financial Report March 2011
CASH AND INVESTMENTS – 1ST QUARTER
The current cash and investments (C&I)
portfolio is provided in the table to the
right. The City’s current C&I balance is
$53.4 million, of this amount; $1.875
million is an interfund loan investment
(Res 4070) from the general fund (000)
to the golf course fund (404). This
interfund loan is due in full on
December 1st 2015.
Currently the majority of the portfolio is
located in the State’s Investment Pool
(34.5%). The rest is spread out between
various certificates of deposits (total of
62%) and the interfund loan (3.5%).
State Investment Pool
$18,454,035.18
35%
Golf Course $1,875,000.00
4%
First Savings Bank
Northwest $4,657,695.94
9%
Columbia Bank
$4,000,000.00
7%
Fortune Bank (CDARS)
$3,248,000.00
6%
Sterling Bank
$5,000,000.00
9%
Umpqua Bank
$10,140,000.00
19%
Commencement Bank
(CDARS) $6,060,949.69
11%
Distribution by Institution
(Percent of Portfolio)
Allowed per
policy
Average
interest rate
Current Portfolio
Distribution
Current Principal
Balance
Cash
US Bank N/A 0.50%N/A 12,519,707$
Golf
Interfund Investment N/A 2.25%3.51% 1,875,000$
US Treasury Securities
none 100% N/A 0.00%‐$
Local Government Investment Pool
State Investment Pool 75% 0.26%34.54% 18,454,035$
US Federal Agency Securities *
0.00%‐$
Certificate of Deposit
First Savings Bank Northwest 0.92%8.72% 4,657,696$
Columbia Bank 0.95%7.49% 4,000,000$
Fortune Bank (CDARS)0.90%6.08% 3,248,000$
Sterling Bank 0.70%9.36% 5,000,000$
Umpqua Bank 0.88%18.98% 10,140,000$
Commencement Bank (CDARS)1.13%11.34% 6,060,950$
Commercial Paper ‐$
none 5%N/A
100.00% 53,435,681$
Institution
TOTAL INVESTMENTS
20%
Page 10 of 37
Monthly Financial Report March 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 ‐ ‐ ‐ ‐ 9,085 8,100 ‐
Grants / intergovernmental 19,569 ‐ 10,145 ‐ ‐ 38,167 ‐
Charges for services 25,356 192,291 3,791,580 2,749,519 4,965,289 1,553,291 ‐
Interdepartmental services ‐ ‐ ‐ 52,103 31,093 88,049 ‐
Fines and penalties ‐ ‐ ‐ ‐ ‐ ‐ ‐
Rents, leases, and misc fees 552,913 37,575 17,862 39,429 ‐ ‐ ‐
Interest and other misc 2,964 960 6,359 130,787 93,338 49,916 16
TOTAL REVENUES 600,802 230,826 3,825,946 2,971,838 5,098,805 1,737,523 16
EXPENSES:
Utility billing ‐ ‐ 29,499 49,425 21,012 33,536 ‐
Utility systems ‐ ‐ 3,489,527 690,553 585,722 532,823 ‐
Utility maintenance ‐ ‐ 66,314 1,047,061 3,466,848 399,805 ‐
Transportation 258,499 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 382,137 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 258,499 382,137 3,585,340 1,787,039 4,073,582 966,164 ‐
AMOUNT AVAILABLE FOR DEBT SERVICE 342,303 (151,311) 240,606 1,184,799 1,025,223 771,359 16
DEBT SERVICE:
Principal ‐ 5,965 ‐ ‐ ‐ ‐ ‐
Interest and other debt service costs ‐ 101 ‐ ‐ ‐ ‐ ‐
TOTAL DEBT SERVICE ‐ 6,066 ‐ ‐ ‐ ‐ ‐
CAPITAL PROJECTS 94,062 121,226 ‐ 277,797 915,372 229,250 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 248,241 (278,603) 240,606 907,002 109,851 542,109 16
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, March 31, 2011 1,609,590 610,001 1,202,394 7,666,756 1,463,083 3,815,972 15,789
Page 11 of 37
Monthly Financial Report March 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 ‐ 14,427 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ ‐ 146,334 ‐ ‐ ‐ 37,673
Charges for services
Equipment rental m&o 537,906 517,804 ‐ ‐ ‐ ‐ ‐
Telecommunications ‐ 94,925 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 26,658 ‐ 98,093 ‐ ‐ ‐
Communications ‐ ‐ ‐ 143,906 ‐ ‐ ‐
Facilities ‐ ‐ 1,029,240 ‐ ‐ ‐ ‐
Data ca rds and cell phones ‐ 37,529 ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ 78,380 ‐ ‐ ‐ ‐ ‐
Interest and other misc 5,696 2,221 369 92 6,015 6,613 4,160
Internal service fund misc:
Vehicle / equipment capital recovery 279,660 234,686 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 389,040 ‐ ‐
Worker's compensation / unemployment ‐ ‐ ‐ ‐ 329,705 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 2,572,839 1,295,711
Other misc 634 1,050 2,876 ‐ 3,234 160,408 ‐
Capital contributions 13,317 ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets 74,955 ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 20,760 5,750 793
TOTAL REVENUES 912,168 1,007,680 1,178,819 242,091 748,754 2,745,610 1,338,337
EXPENSES:
Communications 132,032
Equipment rental 522,428
Facilities 983,378
Healthcare 2,306,326
Information technology 712,711
Print and mail 85,130
Retiree healthcare 202,121
Risk management
Risk management 843,971
Unemployment 26,847
Worker's compensation 273,669
TOTAL EXPENSES 522,428 712,711 983,378 217,162 1,144,487 2,306,326 202,121
AMOUNT AVAILABLE FOR CAPITAL 389,740 294,969 195,441 24,929 (395,733) 439,284 1,136,216
CAPITAL PROJECTS 137,505 32,447 53,654 ‐ ‐ ‐ ‐
TRANSFERS IN ‐ ‐ ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND B ALANCE 252,235 262,522 141,787 24,929 (395,733) 439,284 1,136,216
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, March 31, 2011 5,545,342 2,211,687 382,833 95,143 6,294,291 6,641,178 4,507,253
Page 12 of 37
Monthly Financial Report March 2011
FUND BALANCE
Page 14 shows the ending fund balance as of March 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 March, the City has $4.7 million reported in combined general governmental fund balance of the current
year’s operating budget, which is approximately 5% of budgeted operating expenditures. This is a decrease of $6.7 million
from the beginning balance of January 1, 2011. March’s ending fund balance is over the anticipated General Governmental
Fund Balance of $3.1 million by $1.6 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 13 of 37
Monthly Financial Report March 2011
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through March 31, 2011
Funds
Balance
01/01/2011
Budgeted
Revenue
Revenue
03/31/11
Total Funds
Available
Budgeted
Expenditure
Expenditure
03/31/11 Ending Balance
GENERAL GOVERNMENT FUNDS:11,407,119 98,647,849 16,654,842 28,061,961 100,698,924 23,321,084 4,740,877
000 General 9,477,148 71,881,012 12,628,898 22,106,046 74,195,956 18,626,412 3,479,634
001 Community Services 631,801 10,829,491 1,981,770 2,613,571 10,790,815 2,180,668 432,903
003 Street 116,298 8,402,117 1,314,400 1,430,698 8,300,564 1,995,804 (565,106)
004 Community Dev Block Grant (55,231) 501,728 117,332 62,101 370,272 62,326 (225)
005 Museum 66,830 195,966 32 66,862 208,407 51,915 14,947
006 Library 47,347 2,030,000 45 47,392 2,030,000 7,619 39,773
009 Farmers Market 81,630 67,500 2,827 84,457 62,875 4,789 79,668
010 Fire Memorial 1,251 ‐ 620 1,871 ‐ ‐ 1,871
011 Fire Health & Wellness 24,072 25,000 5,833 29,905 25,000 1,171 28,734
031 Pa rk Memorial 176,950 ‐ 178 177,128 ‐ ‐ 177,128
201 Ltd GO Bonds Gen Govt Debt 312,938 1,983,075 124,497 437,435 1,983,075 ‐ 437,435
215 Gen Govt Misc Debt Service 526,085 2,731,960 478,410 1,004,495 2,731,960 390,380 614,115
SPECIAL REVENUE FUNDS:
102 Arterial Street 171,720 620,000 246,791 418,511 620,000 ‐ 418,511
108 Leased City Properties 759,594 748,060 122,847 882,441 614,457 112,058 770,383
110 Hotel Motel 212,950 245,000 107,017 319,967 275,000 79,134 240,833
118 Reserve for Paths & Trails 3,299 ‐ 3 3,302 ‐ ‐ 3,302
125 1% For Art 136,830 32,000 137 136,967 68,257 2,000 134,967
127 Cable Communication 171,358 85,000 54,008 225,366 221,301 12,781 212,585
135 Springbrook Wetlands Bank 660,524 ‐ 667 661,191 ‐ ‐ 661,191
DEBT SERVICE FUNDS:
219 1989 Unlimited GO Bonds ‐ ‐ ‐ ‐ ‐ ‐ ‐
CAPITAL PROJECT FUNDS (CIP):
303 Community Dev Mitigation 1,343,877 60,000 7,198 1,351,075 400,000 ‐ 1,351,075
304 Fire Mitigation 1,929,477 100,000 22,946 1,952,423 529,056 ‐ 1,952,423
305 Transportation Mitigation 1,119,954 250,000 48,989 1,168,943 999,494 ‐ 1,168,943
316 Municipal Facilities CIP 5,759,297 13,948,558 81,099 5,840,396 19,281,499 319,366 5,521,030
317 Transportation CIP 3,808,080 24,295,301 1,303,233 5,111,313 28,007,800 2,330,506 2,780,807
318 So Lake WA Infrastructure Proj 58,522 ‐ 59 58,581 58,000 ‐ 58,581
326 Housing Opportunity 163,787 ‐ 139 163,926 160,000 17,500 146,426
ENTERPRISE FUNDS:
402 Airport 1,295,036 432,010 143,173 1,438,209 1,125,756 258,499 1,179,710
403 Solid Waste Utility 961,788 15,015,942 3,825,946 4,787,734 14,951,710 3,585,339 1,202,395
404 Golf Course 630,924 2,483,545 230,548 861,472 2,504,738 427,373 434,099
422 Airport Capital 66,313 3,433,408 457,629 523,942 3,003,521 94,062 429,880
424 Golf Course Capital 257,680 100,000 25,281 282,961 220,000 107,059 175,902
INTERNAL SERVICE FUNDS:
501 Equipment Repair/Replacement 5,293,107 3,211,401 912,169 6,205,276 4,407,337 659,933 5,545,343
502 Insurance 6,690,024 3,178,883 748,755 7,438,779 3,018,564 1,144,486 6,294,293
503 Information Services 1,949,165 4,119,051 1,007,680 2,956,845 5,633,307 745,157 2,211,688
504 Facilities 241,046 4,243,673 1,178,819 1,419,865 4,256,261 1,037,032 382,833
505 Communications 70,214 953,941 242,091 312,305 957,746 217,162 95,143
512 Insurance, Healthcare 6,201,894 11,248,058 2,745,611 8,947,505 10,844,696 2,306,326 6,641,179
522 Insurance, Leoff1 Retirees HC 3,371,037 2,935,684 1,338,338 4,709,375 2,261,732 202,121 4,507,254
FIDUCIARY FUNDS:
611 Firemen's Pension 4,286,248 300,000 1,568 4,287,816 565,475 75,488 4,212,328
F unds
Balance
01/01/2011
Budgeted
Revenue
Revenue
03/31/11
Total Funds
Available
Budgeted
Expenditure
Expenditure
03/31/11 Ending Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 11,402,622 46,660,496 9,808,183 21,210,805 50,069,800 8,249,206 12,961,599
405 Water Utility 4,695,116 9,680,689 1,772,619 6,467,735 10,521,313 1,796,692 4,671,043
406 Waste Water Utility 681,616 4,931,139 942,033 1,623,649 5,141,813 916,874 706,775
407 Surface Water Utility 1,462,126 5,353,933 1,030,958 2,493,084 5,092,613 966,164 1,526,920
416 King County Metro 671,616 13,156,760 3,175,896 3,847,512 13,156,760 3,156,708 690,804
425 Water Utility Construction 2,064,638 4,997,301 1,199,219 3,263,857 6,067,301 268,146 2,995,711
426 Waste Water Construction ‐ 3,845,000 980,877 980,877 3,790,000 915,372 65,505
427 Surface Water Construction 1,811,737 4,695,674 706,565 2,518,302 6,300,000 229,250 2,289,052
461 Waterworks Bond Reserve ‐ ‐ ‐ ‐ ‐ ‐ ‐
471 Waterworks Ra te Stabilization 15,773 ‐ 16 15,789 ‐ ‐ 15,789
481 Future W/S Bond Proceeds ‐ ‐ ‐ ‐ ‐ ‐ ‐
Note: Waterworks Utility Funds are managed as a system and are designated by the dotted lines.
Page 14 of 37
City of Renton
General Government Financial Position
2011 Budget Year
General Government Summary
Revenues Expenditures
$ Difference
over (under)
w/beginning
balance
11,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 16,654,842 23,321,083 (6,666,241) 4,740,878
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
Change in Fund
Balance
Rev/Exp
Revenues
(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
Change in Fund
Balance
Rev/Exp
Revenues
Page 15 of 37
City of Renton
Monthly Revenue Analysis ‐ 2011 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 5,632,584 5,379,006 ‐4.50%
Feb 10,773,287 11,050,241 2.57%
Mar 16,111,337 16,654,842 3.37%
Apr 28,125,146
May 42,740,155
Jun 50,026,612
Jul 55,962,497
Aug 61,308,015
Sep 66,223,614
Oct 78,809,337
Nov 93,131,205
Dec 98,647,849
Percent of budget 16.88%
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 1,586,980 50.39%
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 4.95%
$‐
$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 16 of 37
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 5,136,541 5.13%
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 25.84%
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 4,292,138 4.72%
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 28.30%
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 17 of 37
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 539,342 ‐27.28%
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 20.64%
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,635,831 1,648,102 0.75%
Apr 2,079,147
May 2,981,273
Jun 5,690,278
Jul 6,094,363
Aug 6,771,103
Sep 7,235,647
Oct 7,872,145
Nov 11,055,511
Dec 11,355,853
Percent of budget 14.51%
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 18 of 37
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 1,257,415 ‐7.77%
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 19.75%
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 746,372 7.45%
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 23.54%
$‐
$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 19 of 37
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,219,558 1,132,303 ‐7.15%
Apr 1,910,301
May 2,209,418
Jun 2,528,643
Jul 3,613,125
Aug 3,958,169
Sep 4,158,270
Oct 4,951,774
Nov 5,228,432
Dec 6,075,921
Percent of budget 18.64%
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 181,164 143,105 ‐21.01%
Feb 280,604 213,343 ‐23.97%
Mar 413,428 312,474 ‐24.42%
Apr 527,586
May 643,655
Jun 817,044
Jul 994,876
Aug 1,102,019
Sep 1,226,190
Oct 1,312,806
Nov 1,379,867
Dec 1,444,459
Percent of budget 21.63%
$‐
$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 20 of 37
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 3,175 3,175 0.00%
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.60%
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 403,288 ‐9.02%
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 18.00%
$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 21 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,065,580 6,990,159 ‐1.07%
Feb 16,776,018 15,756,416 ‐6.08%
Mar 24,390,079 23,321,083 ‐4.38%
Apr 32,956,495
May 41,001,016
Jun 49,446,960
Jul 58,107,425
Aug 66,766,985
Sep 75,227,610
Oct 83,003,120
Nov 91,507,403
Dec 100,698,925
Percent of budget expended 23.16%
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 67,521 ‐3.00%
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 24.30%
$‐
$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 22 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Executive Budget
YTD
Actual
Annual %
over (under)
Jan 107,124 112,718 5.22%
Feb 236,884 229,987 ‐2.91%
Mar 364,848 346,789 ‐4.95%
Apr 492,060
May 616,193
Jun 735,255
Jul 865,752
Aug 985,602
Sep 1,122,608
Oct 1,245,595
Nov 1,362,997
Dec 1,484,762
Percent of budget expended 23.36%
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 154,386 ‐3.92%
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 19.53%
$‐
$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 23 of 37
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 23,616 ‐45.27%
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 13.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 395,280 ‐0.22%
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 24.70%
$‐
$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 24 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Court Services Budget
YTD
Actual
Annual %
over (under)
Jan 173,836 163,613 ‐5.88%
Feb 352,836 326,156 ‐7.56%
Mar 539,914 490,833 ‐9.09%
Apr 719,707
May 898,391
Jun 1,082,682
Jul 1,266,794
Aug 1,444,260
Sep 1,625,297
Oct 1,787,517
Nov 1,960,773
Dec 2,148,421
Percent of budget expended 22.85%
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 232,560 ‐1.90%
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 25.03%
$‐
$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 25 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Development
Services Budget
YTD
Actual
Annual %
over (under)
Jan 283,014 231,587 ‐18.17%
Feb 559,091 474,633 ‐15.11%
Mar 825,857 716,400 ‐13.25%
Apr 1,094,888
May 1,362,438
Jun 1,623,270
Jul 1,887,072
Aug 2,135,783
Sep 2,409,450
Oct 2,652,185
Nov 2,904,084
Dec 3,164,064
Percent of budget expended 22.64%
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 51,933 68,491 31.88%
Feb 121,356 123,830 2.04%
Mar 181,420 179,805 ‐0.89%
Apr 236,072
May 299,359
Jun 359,523
Jul 429,586
Aug 488,281
Sep 557,248
Oct 615,465
Nov 680,540
Dec 745,313
Percent of budget expended 24.12%
$‐
$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 26 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Planning Budget
YTD
Actual
Annual %
over (under)
Jan 110,790 104,320 ‐5.84%
Feb 218,683 258,972 18.42%
Mar 334,314 348,727 4.31%
Apr 439,437
May 559,927
Jun 718,541
Jul 835,766
Aug 973,934
Sep 1,145,112
Oct 1,281,210
Nov 1,381,332
Dec 1,545,279
Percent of budget expended 22.57%
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 186,686 155,421 ‐16.75%
Feb 341,891 315,453 ‐7.73%
Mar 517,662 467,036 ‐9.78%
Apr 674,058
May 865,088
Jun 1,023,874
Jul 1,187,649
Aug 1,354,267
Sep 1,520,593
Oct 1,632,415
Nov 1,777,248
Dec 2,101,797
Percent of budget expended 22.22%
$‐
$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 27 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Human
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 78,566 86,565 10.18%
Feb 155,480 155,437 ‐0.03%
Mar 237,774 221,683 ‐6.77%
Apr 319,048
May 399,386
Jun 483,070
Jul 565,498
Aug 647,359
Sep 729,334
Oct 806,895
Nov 882,317
Dec 977,884
Percent of budget expended 22.67%
Police Budget
YTD
Actual
Annual %
over (under)
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Millions Human Resources
Budget
Actual
Last Year
$30
$33
Millions Police
Budget
Actual
g ()
Jan 2,300,854 2,369,174 2.97%
Feb 4,975,525 4,383,450 ‐11.90%
Mar 7,489,363 7,075,221 ‐5.53%
Apr 9,965,388
May 12,372,160
Jun 15,119,628
Jul 17,670,174
Aug 20,219,584
Sep 22,892,770
Oct 25,166,744
Nov 28,038,602
Dec 31,032,228
Percent of budget expended 22.80%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
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 28 of 37
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 5,900,678 ‐5.50%
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 26.77%
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 102,208 ‐2.21%
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 24.78%
$‐
$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 29 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Parks Budget
YTD
Actual
Annual %
over (under)
Jan 239,087 261,191 9.24%
Feb 514,533 527,048 2.43%
Mar 810,460 799,401 ‐1.36%
Apr 1,116,871
May 1,440,935
Jun 1,782,886
Jul 2,144,016
Aug 2,551,900
Sep 2,893,918
Oct 3,240,517
Nov 3,551,772
Dec 3,928,721
Percent of budget expended 20.35%
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 109,668 ‐24.65%
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 18.84%
$‐
$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 30 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Recreation Budget
YTD
Actual
Annual %
over (under)
Jan 295,489 361,259 22.26%
Feb 635,715 702,382 10.49%
Mar 1,005,407 1,058,705 5.30%
Apr 1,348,862
May 1,717,169
Jun 2,116,097
Jul 2,772,458
Aug 3,488,144
Sep 3,976,930
Oct 4,329,768
Nov 4,783,906
Dec 5,178,448
Percent of budget expended 20.44%
Human
Services Budget
YTD
Actual
Annual %
over (under)
$1.40
$1.60
Millions Human Services
Budget
Actual
$‐
$1
$2
$3
$4
$5
$6
Millions Recreation
Budget
Actual
Last Year
g ()
Jan 59,293 53,756 ‐9.34%
Feb 126,188 118,956 ‐5.73%
Mar 198,582 177,533 ‐10.60%
Apr 390,623
May 474,289
Jun 553,794
Jul 757,937
Aug 837,909
Sep 900,588
Oct 1,060,018
Nov 1,161,722
Dec 1,363,272
Percent of budget expended 13.02%
$0.00
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
Millions Human Services
Budget
Actual
Last Year
$‐
$1
$2
$3
$4
$5
$6
Millions Recreation
Budget
Actual
Last Year
Page 31 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Neighborhood
s, Resources,
and Events Budget
YTD
Actual
Annual %
over (under)
Jan 41,830 36,383 ‐13.02%
Feb 85,281 73,402 ‐13.93%
Mar 128,860 110,686 ‐14.10%
Apr 173,464
May 228,231
Jun 290,830
Jul 376,730
Aug 426,476
Sep 473,127
Oct 511,361
Nov 548,937
Dec 688,984
Percent of budget expended 16.07%
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 7,619 7,619 0.00%
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.38%
$‐
$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 32 of 37
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 51,915 0.11%
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 24.91%
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 111,889 ‐0.90%
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 24.64%
$‐
$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 33 of 37
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 894,017 0.19%
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 24.20%
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 331,107 308,560 ‐6.81%
Feb 719,617 689,957 ‐4.12%
Mar 1,114,917 1,101,787 ‐1.18%
Apr 1,488,522
May 1,869,361
Jun 2,262,793
Jul 2,606,257
Aug 3,030,111
Sep 3,405,716
Oct 3,807,825
Nov 4,176,065
Dec 4,606,639
Percent of budget expended 23.92%
$‐
$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 34 of 37
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 390,380 390,380 0.00%
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 8.28%
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 1,784,740 1,784,740 0.00%
Apr 1,273,649
May 1,592,061
Jun 1,910,473
Jul 2,228,885
Aug 2,547,297
Sep 2,865,710
Oct 3,184,122
Nov 3,502,534
Dec 3,820,946
Percent of budget expended 46.71%
$‐
$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 35 of 37
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2011 Budget Year
Utilities Budget Revenue Expense
Jan 2,850,738 3,918,553 2,713,059
Feb 6,544,384 8,323,464 6,324,471
Mar 9,103,891 10,747,451 10,421,777
Apr 13,799,253
May 17,327,249
Jun 23,454,332
Jul 28,837,702
Aug 31,927,874
Sep 35,615,167
Oct 39,312,233
Nov 42,921,833
Dec 48,864,209
Percent of budget expended 21.33%
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 143,173 258,499
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 22.96%
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 36 of 37
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 230,548 427,373
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 17.06%
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 37 of 37