HomeMy WebLinkAbout201005, May.pdf
General Governmental Funds
$%
Beginning Fund Balance 13,300,854$ 13,300,854$ 11,816,561$ 11,816,561$ 11,955,285$ 11,955,285$ 11,955,285$ ‐$ 0.0%
OPERATING REVENUES
Property Tax 29,050,790 12,860,483 30,660,522 15,735,934 31,364,643 16,097,311 16,434,665 337,354 2.1%
Sales Tax 20,825,055 8,355,432 17,995,836 7,671,307 18,609,000 7,590,397 7,267,999 (322,399) ‐4.2%
Sales Tax ‐ Annexation Credit ‐ ‐ 2,132,110 906,821 2,248,000 956,111 852,234 (103,877) ‐10.9%
Criminal Justice Sa les Tax 1,755,469 676,898 1,650,350 697,773 1,743,000 736,946 676,723 (60,223) ‐8.2%
Natural Gas Use Tax 253,377 162,939 242,891 124,780 ‐ ‐ 123,656 123,656 100.0%
Admission Tax 197,740 97,253 260,269 118,330 260,000 118,207 141,355 23,148 19.6%
Franchise Fees 998,288 442,071 1,039,031 518,585 1,040,000 622,396 594,746 (27,650) ‐4.4%
Electricity Tax 4,580,037 2,064,587 4,963,151 2,333,954 5,150,000 2,421,821 2,222,605 (199,216) ‐8.2%
Gas Tax 1,565,810 717,957 1,891,255 1,264,962 1,858,000 1,242,720 890,300 (352,420) ‐28.4%
Transfer Station 380,961 121,060 283,985 93,585 230,000 75,794 91,294 15,500 20.4%
TV Cable 1,073,168 252,955 1,263,743 518,998 1,250,000 513,354 552,440 39,086 7.6%
Telephone 1,032,048 438,459 1,037,873 427,027 960,000 394,987 444,889 49,902 12.6%
Cellular Phone 1,748,147 703,490 2,027,473 794,277 1,900,000 744,338 973,548 229,209 30.8%
City Utilities 2,606,786 923,650 2,871,599 1,120,769 2,880,000 1,124,048 1,126,673 2,625 0.2%
Leasehold Excise Tax 190,644 21,698 146,002 28,626 100,000 19,607 36,976 17,369 88.6%
Gambling Excise Tax 2,157,029 1,058,191 2,141,720 926,538 2,000,000 865,228 666,462 (198,766) ‐23.0%
Real Estate Excise Tax 2,800,103 1,325,761 2,418,456 932,916 2,400,000 925,800 986,269 60,469 6.5%
Less: Municipal Facilities CIP REET (450,103) (662,880) (1,000,000) (435,595) (400,000) (174,238) (164,527) 9,712 ‐5.6%
EMS Levy 890,998 85,744 1,170,657 ‐ 897,095 ‐ ‐ ‐ 0.0%
Business License Fees 485,537 186,112 424,413 205,594 463,067 224,318 216,603 (7,715) ‐3.4%
Other Licenses and Permits 257,477 113,664 176,851 64,408 157,250 57,269 90,744 33,474 58.5%
Building Permits 2,034,225 1,276,304 1,683,082 732,133 1,766,059 768,228 707,120 (61,108) ‐8.0%
Intergovernmental (Grants, etc)3,734,887 1,147,899 3,820,932 1,829,190 4,355,523 1,703,248 1,703,248 ‐ 0.0%
Fire District 25 and 40 Contracts 5,013,549 739 5,869,198 2,338,225 5,554,723 583,869 583,869 ‐ 0.0%
Records, Duplicating, and Passport Fees 176,950 89,420 187,721 74,465 217,585 86,311 80,905 (5,406) ‐6.3%
Public Safety 524,565 224,205 521,484 222,442 430,000 183,419 184,831 1,412 0.8%
Development Service Fees 903,768 437,033 677,955 254,533 696,708 261,574 354,535 92,962 35.5%
Culture and Recreation 1,678,818 576,568 1,631,486 506,264 1,572,240 487,880 462,900 (24,980) ‐5.1%
Interfund/Interdept‐Services 3,072,950 1,137,188 3,225,745 1,345,715 3,080,927 1,285,300 1,383,263 97,963 7.6%
Fines and Forfeits 2,110,973 462,830 1,448,878 539,928 1,327,193 494,582 504,059 9,477 1.9%
Photo Enforcement ‐ ‐ 2,368,131 1,038,725 2,250,000 986,910 813,819 (173,090) ‐17.5%
Interests and Other Earnings 735,910 313,514 535,314 237,476 434,300 192,665 132,674 (59,990) ‐31.1%
Rents, Leases, and Concessions 676,919 325,192 677,960 340,141 720,780 361,625 359,452 (2,173) ‐0.6%
Contributions and Donations 175,513 110,475 150,406 40,498 111,900 30,130 42,652 12,523 41.6%
Other Miscellaneous 67,355 36,058 168,567 34,586 262,557 53,871 39,364 (14,507) ‐26.9%
Refunding Debt and Premiums ‐ ‐ ‐ ‐ ‐ 6,613,484 6,613,484 ‐ 0.0%
Transfer‐In 381,364 ‐ 577,004 ‐ 652,398 ‐ ‐ ‐ 0.0%
Total Operating Revenues 93,687,106 36,082,951 97,342,052 43,583,909 98,542,948 48,649,506 48,191,829 (457,677) ‐0.9%
OPERATING EXPENDITURES
Legislative 245,441 105,042 247,225 104,134 267,957 113,769 109,177 4,591 4.0%
City Attorney 1,661,225 706,144 1,248,380 534,316 1,621,295 691,212 666,194 25,018 3.6%
City Clerk 604,844 302,249 646,581 323,213 931,014 465,321 368,812 96,509 20.7%
Court Services 1,744,122 688,352 1,819,731 778,154 2,016,361 829,722 822,296 7,425 0.9%
Executive 966,373 382,024 1,499,747 604,647 1,635,047 654,166 672,872 (18,706) ‐2.9%
Hearing Examiner 166,820 68,624 171,911 72,547 200,440 83,536 72,376 11,160 13.4%
Community and Eco Dvlpmnt Admin ‐ ‐ 265,269 114,875 696,149 301,468 243,426 58,042 19.3%
Development Services 4,178,096 1,648,878 3,615,129 1,572,624 3,347,282 1,383,673 1,357,492 26,181 1.9%
Economic Development 1,875,749 764,327 1,244,175 502,880 1,323,047 537,376 527,838 9,538 1.8%
Planning ‐ ‐ 1,525,460 570,770 1,300,133 486,461 520,231 (33,770) ‐6.9%
Finance 1,909,652 827,613 1,969,936 951,436 2,164,890 992,746 770,836 221,910 22.4%
Human Resources 981,306 442,834 853,063 345,695 918,169 394,688 354,450 40,237 10.2%
Police 23,894,898 9,355,596 25,833,756 10,525,995 28,022,582 11,203,470 11,016,981 186,489 1.7%
Fire 21,763,640 8,618,495 20,375,286 8,977,114 21,922,009 9,475,312 9,312,143 163,169 1.7%
Facilities 3,614,850 1,434,119 ‐ (242) ‐ ‐ ‐ ‐ 0.0%
Parks 4,892,441 1,479,626 4,820,336 1,499,633 4,569,001 1,401,477 1,332,731 68,746 4.9%
Parks Planning & Natural Resources ‐ ‐ ‐ ‐ 545,943 227,476 150,956 76,520 33.6%
Recreation 4,383,163 1,668,604 7,878,458 3,214,705 4,970,795 1,979,667 1,885,060 94,608 4.8%
Human Services 1,162,553 405,023 1,194,142 421,293 1,406,586 493,184 455,748 37,436 7.6%
Community Resources & Events 367,627 104,602 348,185 112,712 375,694 114,057 112,347 1,711 1.5%
Library 1,890,886 781,099 2,312,128 836,642 2,544,263 1,067,015 1,067,015 ‐ 0.0%
Museum 136,327 57,166 140,801 60,516 194,120 82,433 78,771 3,662 4.4%
Public Works Administration 886,867 383,165 463,533 199,901 518,399 223,830 215,438 8,393 3.7%
Street Maintenance 3,212,111 1,236,449 3,794,716 1,591,822 3,379,080 1,363,948 1,367,277 (3,329) ‐0.2%
Technical Services 515,708 218,835 478,493 198,707 ‐ ‐ ‐ ‐ 0.0%
Transportation 4,841,955 1,769,571 5,110,639 2,118,799 5,164,058 2,017,541 2,071,440 (53,899) ‐2.7%
Debt Service 4,263,739 41,740 4,176,822 ‐ 4,494,945 126,471 126,471 ‐ 0.0%
Payment of LTGO Refunding Debt ‐ ‐ ‐ ‐ ‐ 6,613,194 6,613,194 ‐ 0.0%
Non‐Departmental and Other 5,011,007 1,927,490 5,169,426 1,829,482 4,817,981 1,778,021 1,657,444 120,577 6.8%
Total Operating Expenditures 95,171,399 35,417,666 97,203,328 38,062,368 99,347,239 45,101,235 43,949,015 1,152,220 2.6%
Total Ending Fund Balance 11,816,561$ 13,966,139$ 11,955,285$ 17,338,103$ 11,150,994$ 15,503,557$ 16,198,100$ 694,543 4.5%
Favorable (Unfavorable)
2008 2009 2010 Variance
Annual Actual YTD Actual Annual Budget YTD Budget YTD ActualSummary of Sources and Uses Annual Actual YTD Actual
Monthly Financial Report May 2010
Page 1 of 34
Monthly Financial Report May 2010
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through May 31, 2010. 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 tax, sales/use tax, utility tax, gambling, admissions, and real estate excise tax
represents 69% of all resources supporting general governmental activities. The following section provides detail
information on property, sales, utility, and other taxes.
Property Tax
May’s collection is $8.7 million,
making the total year‐to‐date
collection $16.4 million or 52% of
the total budget. In comparison
to the previous year, the City
collected $699k or 4% higher.
Compared to the budget, the City
is above projections by $337k or
2%. Based on distribution we
have received in May, we are
projecting property tax collections
to meet the projections at year
end.
Sales Tax
May 2010 sales tax receipts totaled
$1.5 million. Compared to the same
month last year, it is $9k or 1% more.
Compared to the projected current
month’s budget, it is below projections
by $104k or 7%. The year‐to‐date
collection is $7.3 million or 39% of the
sales tax budget. This is $403k less
than the last year and $322k below
budget. Based on the year‐to‐date
collection, the City is projecting sales
tax revenues to be $17.8 million by the
end of 2010, which is $809k under
budget.
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 9,419$ 9,635$ 51,304$ 41,885$ 445% 41,669$ 432%
Feb 303,513 310,483 438,210 134,696 44% 127,727 41%
Mar 647,845 662,723 547,632 (100,213) ‐15% (115,091) ‐17%
Apr 8,063,214 8,248,386 6,660,829 (1,402,385) ‐17% (1,587,557) ‐19%
May 6,711,943 6,866,083 8,736,691 2,024,747 30% 1,870,608 27%
Jun 113,279 115,881
Jul 104,757 107,163
Aug 66,589 68,118
Sep 250,296 256,044
Oct 5,770,027 5,902,536
Nov 8,275,695 8,465,747
Dec 343,945 351,844
YTD Total 15,735,934$ 16,097,311$ 16,434,665$ 698,731$ 4% 337,355$ 2%
Annual Total 30,660,522$ 31,364,643$
Property Tax Revenues
Year to Date through May
2010 vs. 2009 2010 vs. Budget
Month
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 1,458,072$ 1,459,527$ 1,289,364$ (168,709)$ ‐12% (170,163)$ ‐12%
Feb 1,863,430 1,834,595 1,728,588 (134,842) ‐7% (106,007) ‐6%
Mar 1,461,007 1,324,674 1,289,589 (171,418) ‐12% (35,085) ‐3%
Apr 1,398,021 1,367,908 1,461,123 63,103 5% 93,215 7%
May 1,490,778 1,603,693 1,499,335 8,557 1% (104,359) ‐7%
Jun 1,361,808 1,464,336 ‐
Jul 1,443,891 1,547,213 ‐
Aug 1,551,415 1,662,544 ‐
Sep 1,454,550 1,573,534 ‐
Oct 1,560,217 1,610,574 ‐
Nov 1,440,143 1,636,255 ‐
Dec 1,512,506 1,524,146 ‐
YTD Total 7,671,307$ 7,590,397$ 7,267,999$ (403,309)$ ‐5% (322,399)$ ‐4%
Annual Total 17,995,836$ 18,609,000$
2010 vs. Budget2010 vs. 2009
Month
Year to Date through May
Local Retail Sales Tax Revenues
Page 2 of 34
Monthly Financial Report May 2010
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 2008 2009 2010 Bgt YTD Act Chg 10/09 10Act vs Bgt
New Construction 2,015,329$ 1,390,639$ 1,113,373$ 1,005,901$ (384,738)$ ‐28% $ (107,471)‐10%
Auto Sales 1,535,933 1,193,527 1,315,505 1,209,729 16,203 1% (105,776)‐8%
General Retail 2,525,578 2,504,397 2,529,921 2,529,216 24,819 1% (704) 0%
Manufacturing 438,154 496,603 404,807 321,266 (175,337) ‐35% (83,541)‐21%
Wholesale 469,585 376,788 411,516 395,235 18,447 5% (16,281)‐4%
Service 1,636,528 1,547,266 1,581,027 1,559,850 12,584 1% (21,177)‐1%
Other 177,998 162,082 234,249 246,802 84,719 52% 12,552 5%
Total 8,799,103$ 7,671,302$ 7,590,397$ 7,267,999$ (403,303) ‐5%(322,399)$ ‐4%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility tax
May utility taxes revenue totals $1.2
million, which is $91k lower than the
same month last year and behind the
budget by $59k. The year‐to‐date
collection of $6.4 million is below the
budget by $91k or 1% and is also $253k
or 4% below 2009. The unfavorable
comparisons in January and February is
primarily due to higher than normal
electrical and natural gas consumptions
during winter months in 2009 that
distorted the budget for these two
months. At this time, the City is
projecting utility tax revenues to be
slightly under our 2010 budget by the end
of the year.
The table below breaks out Utility Tax by source, the lower amount generated from Natural Gas is due to warmer
temperatures in the 1st quarter of 2010 than 2009:
Utility Tax by Type 2008 2009 2010 Bgt YTD Act Chg 10/09 10Act
vs Bgt
Electrical 2,064,587 2,333,954 2,358,632 2,222,605 ‐5%‐6%
Natural Gas 880,896 1,389,742 850,940 1,013,957 ‐27% 19%
Cell 703,490 794,277 870,175 973,548 23% 12%
Phone 438,459 427,027 439,667 444,889 4% 1%
Cable 252,955 518,998 572,484 552,440 6%‐4%
Transfer Station 121,060 93,585 105,337 91,294 ‐2%‐13%
City Utilities 923,650 1,120,769 1,319,002 1,126,673 1%‐15%
YTD Total 5,385,097 6,678,351 6,516,237 6,425,405 ‐4%‐1%
Annual Total 13,240,334 14,581,971 14,228,000
YTD as % of 41% 46% 46%
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 1,413,641$ 1,379,325$ 1,282,930$ (130,711)$ ‐9% (96,395)$ ‐7%
Feb 1,485,870 1,449,801 1,354,933 (130,936) ‐9% (94,868) ‐7%
Mar 1,251,275 1,220,901 1,295,732 44,457 4% 74,831 6%
Apr 1,204,619 1,175,377 1,260,110 55,491 5% 84,733 7%
May 1,322,947 1,290,833 1,231,700 (91,247) ‐7% (59,133) ‐5%
Jun 1,070,303 1,044,322
Jul 1,010,609 986,077
Aug 1,201,122 1,171,965
Sep 1,068,035 1,042,109
Oct 1,079,380 1,053,179
Nov 1,090,897 1,064,416
Dec 1,383,272 1,349,694
YTD Total 6,678,351$ 6,516,237$ 6,425,405$ (252,946)$ ‐4% (90,832)$ ‐1%
Annual Total 14,581,971$ 14,228,000$
2010 vs. Budget2010 vs. 2009
Year to Date through May
Utility Tax Revenues
Month
Page 3 of 34
Monthly Financial Report May 2010
Other Taxes
Real Estate Excise Tax
The City collected $216k in Real Estate
Excise Tax revenues (REET) in May. This is
$89k below current month’s budget and
$91k behind the same month last year.
Year‐to‐date collection of $986k is $60k
or 7% ahead of the budget and is also
$53k or 6% above 2009.
Almost all REET in recent months are
generated from residential property
transactions. The activities appear to be
smaller in amount but steady in volume.
We hope this trend will continue and not
stop once the federal stimulus incentive
expires.
Gambling Tax
May’s Gambling Tax collections
total $134k. Year‐to‐date total of
$666k is $260k or 28% below the
year before; and $199k or 23%
below budget.
The lower tax collection is due to
cross‐the‐board reduction in
gambling activities. Pull tabs
overall reduced by 25%, partially
due to the change in business at
Cascade Lanes; and card‐rooms are
seeing over 30% lower in activities.
Because of these changes, the City
is anticipating around $459k less in
gambling tax revenue collection
than budgeted by the end of the year.
Franchise Fees
Franchise Fees are due quarterly
and the year‐to‐date revenue
collections are $594k. This is $104k
or 21% above the projected year‐
to‐date budget and $76k or 15%
higher than 2009. 2009’s May
collection should have been
recorded in April.
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 231,334$ 229,560$ 71,303$ (160,031)$ ‐69% (158,257)$ ‐69%
Feb 69,290 68,760 107,242 37,952 55% 38,482 56%
Mar 183,177 181,800 309,164 125,987 69% 127,364 70%
Apr 141,038 139,944 281,746 140,708 100% 141,802 101%
May 308,077 305,736 216,814 (91,262) ‐30% (88,922) ‐29%
Jun 211,295 209,688
Jul 201,960 200,400
Aug 310,599 308,232
Sep 208,046 206,472
Oct 209,975 208,368
Nov 222,052 220,344
Dec 121,614 120,696
YTD Total 932,916$ 925,800$ 986,269$ 53,353$ 6% 60,469$ 7%
Annual Total 2,418,456$ 2,400,000$
Real Estate Excise Tax Revenues
Year to Date through May
Month
2010 vs. Budget2010 vs. 2009
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 7,691$ 186,179$ 135,608$ 127,917$ 1663% (50,571)$ ‐27%
Feb 391,054 186,179 137,736 (253,317) ‐65% (48,443) ‐26%
Mar 171,097 159,776 63,054 (108,044) ‐63% (96,722) ‐61%
Apr 177,856 166,087 196,085 18,229 10% 29,998 18%
May 178,840 167,006 133,979 (44,861) ‐25% (33,027) ‐20%
Jun 186,920 174,551 ‐
Jul 182,851 170,752 ‐
Aug 210,237 196,325 ‐
Sep 173,745 162,248 ‐
Oct 176,490 164,811 ‐
Nov 146,960 137,236 ‐
Dec 137,979 128,849 ‐
YTD Total 926,538$ 865,228$ 666,462$ (260,076)$ ‐28% (198,766)$ ‐23%
Annual Total 2,141,720$ 2,000,000$
Gambling Tax Revenue
Month
Year to Date through May
2010 vs. 2009 2010 vs. Budget
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 259,792$ 255,537$ 45,703$ (214,089)$ ‐82% (209,834)$ ‐82%
Feb 200 102 274,776 274,576 137288% 274,674 269037%
Mar ‐ ‐ ‐
Apr ‐ 102,746 274,268 274,268 100% 171,521 167%
May 258,593 132,005 ‐ (258,593) (132,005)
Jun ‐ ‐ ‐
Jul 260,647 244,359 ‐
Aug ‐ ‐ ‐
Sep ‐ 24,721 ‐
Oct 259,798 258,846 ‐
Nov ‐ ‐ ‐
Dec ‐ 21,683 ‐
YTD Total 518,585$ 490,391$ 594,746$ 76,161$ 15% 104,355$ 21%
Annual Total 1,039,031$ 1,040,000$
Franchise Fees Revenue
Year to Date through May
Month
2010 vs. 2009 2010 vs. Budget
Page 4 of 34
Monthly Financial Report May 2010
Admission Tax
Admission Tax returns are due
quarterly in January, April, July, and
October each year. April 2010
collections represent activities
conducted during the 1th quarter of
2010.
The report shows an increase of
$23k from the year before and
$19k more than anticipated.
Licenses and Permits
These revenue sources reflect the collection of business licenses; building permits; and other licenses, fees, and permits.
Building Permit Fees and General Business Licenses constitute 83% of the revenue in this category. As of the end of May,
we have collected 43% of the projected revenue from licenses and permits. The percentage of year‐to‐date actual to year‐
to‐date budget is 3% less. Licenses and Permits totaled $1 million by the end of May. The following sections provide detail
information for Building Permits and Business Licenses revenues.
Building Permits and Fees revenues
totaled $102k in May. The revenue
swing between the high in January and
the low in February 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 $640k is $59k less than the budget
and is also $11k lower than 2009.
Business Licenses totaled $217k since the start of
the year, which is 5% above last year but 3%
below budget. The month by month comparison
is not representative due to the payment timing
shift of employers. The General Fund portion of
the Business Licenses revenue is under the
budget by $8k but $11k above last year.
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 57,167$ 58,965$ 74,777$ 17,610$ 31% 15,811$ 27%
Feb ‐ ‐ 459 459 100% 459 100%
Apr 61,163 63,415 66,119 4,956 8% 2,704 4%
Jul 70,690 69,911 ‐
Oct 70,729 67,414 ‐
Nov 520 295 ‐
YTD Total 118,330$ 122,381$ 141,355$ 23,026$ 19% 18,975$ 16%
Annual Total 260,269$ 260,000$
Year to Date through May
Month
2010 vs. 2009 2010 vs. Budget
Admission Ta x Revenue
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 106,633$ 114,591$ 285,826$ 179,192$ 168% 171,234$ 149%
Feb 124,555 133,851 46,586 (77,969) ‐63% (87,265) ‐65%
Mar 179,330 192,714 82,637 (96,693) ‐54% (110,076) ‐57%
Apr 114,694 123,254 122,217 7,522 7% (1,037) ‐1%
May 125,344 134,698 102,511 (22,833) ‐18% (32,187) ‐24%
Jun 131,705 141,534 ‐
Jul 106,810 114,781 ‐
Aug 119,439 128,352 ‐
Sep 101,087 108,631 ‐
Oct 131,899 141,742 ‐
Nov 82,516 88,674 ‐
Dec 169,581 182,237 ‐
YTD Total 650,557$ 699,108$ 639,777$ (10,781)$ ‐2% (59,331)$ ‐8%
Annual Total 1,493,593$ 1,605,059$
Building Permits and Fees
Year to Date through May
2010 vs. Budget2010 vs. 2009
Month
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 81,835$ 89,289$ 77,955$ (3,880)$ ‐5% (11,334)$ ‐13%
Feb 30,180 32,929 33,440 3,260 11% 511 2%
Mar 6,337 6,914 5,687 (650) ‐10% (1,228) ‐18%
Apr 73,055 79,709 77,964 4,908 7% (1,746) ‐2%
May 14,185 15,477 21,558 7,373 52% 6,081 39%
Jun 9,352 10,204 ‐
Jul 80,579 87,918 ‐
Aug 20,280 22,127 ‐
Sep 1,746 1,905 ‐
Oct 84,002 91,653 ‐
Nov 18,937 20,662 ‐
Dec 3,922 4,279 ‐
YTD Total 205,594$ 224,318$ 216,603$ 11,010$ 5% (7,715)$ ‐3%
Annual Total 424,413$ 463,067$
Business Licenses
Month
Year to Date through May
2010 vs. Budget2010 vs. 2009
Page 5 of 34
Monthly Financial Report May 2010
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 72% of the total
revenues in this category.
The year‐to‐date total
Intergovernmental revenue is
$3 million or 25% of the budget. All grant revenues also have corresponding expenditures which have been added to the
City’s budget through the 2010 carry forward budget adjustment.
State Shared Revenue collections
totaled $1.5 million since the start
of 2010. Compared to the projected
budget, State Shared Revenues are
under by $33k or 2%. Compared to
the prior year, the City is collecting
$33k less or down by 2%. The actual
collections that lags budget are
primarily due to the reduced
criminal justice sales tax (King
County countywide sales tax
decrease) and fuel tax.
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. Culture, recreation, interfund/interdepartmental‐sales and services
constitute 75% of the total revenue in this category. The year‐to‐date total charges for services are $2.5 million or 41% of
the budget. This is 7% above budget projections. The following sections provide detail information for Plan Review with
Inspection Fees, Recreation, and Interfund Services.
Plan Review and Inspection fees are $352k since
the start of the year. Compared to the budget,
the City is collecting $89k or 34% more than
anticipated revenue. Compared to the prior
year, the City is collecting $97k or 38% more.
Intergovernmental 2008 2009 2010 Bgt YTD Act Chg 10/09 10Act
vs Bgt
Fire District #25 739 ‐ 558,243 558,243 100% 0%
Fire District #40 ‐ 2,338,225 25,626 25,626 ‐99% 0%
State Shared Revenue 1,337,441 1,570,946 1,570,765 1,538,209 ‐2%‐2%
Federal Grants 382,850 212,035 503,657 503,657 138% 0%
State Grants 7,996 133,703 117,354 117,354 ‐12% 0%
Other Grants 96,511 610,279 103,847 103,847 ‐83% 0%
ARRA Grants ‐ ‐ 116,903 116,903 100% 0%
Total Rev YTD 1,825,536 4,865,188 2,996,396 2,963,839 ‐39%‐1%
Total Rev Annual 10,503,905 11,340,480 11,653,246
YTD %17% 43% 26% 25%
Note: Includes CJ Sales Tax.
2009 2010 2010
Actual Budget Actual $ % $ %
Crim Just Sales Tax 697,773$ 736,946$ 676,723$ (21,050)$ ‐3% (60,223)$ ‐8%
Judicial Contribution 12,143 4,888 17,229 5,086$ 42% 12,341 252%
Crim Just ‐ Pop 8,611 ‐ 9,223 611 7% 9,223 100%
Crim Just ‐ Spec Prog 33,049 32,120 35,060 2,011 6% 2,941 9%
State DUI 7,334 3,986 7,871 537 7% 3,885 97%
Liquor Profits 136,619 144,264 195,587 58,967 43% 51,322 36%
Liquor Excise Tax 203,698 208,427 213,880 10,182 5% 5,453 3%
Fuel Tax 471,718 440,135 382,636 (89,082) ‐19% (57,499) ‐13%
YTD Total 1,570,946$ 1,570,765$ 1,538,209$ (32,737)$ ‐2% (32,557)$ ‐2%
Annual Total 3,986,791$ 3,988,931$
State Shared Revenues
2010 vs. 2009
Revenue
Year to Date through May
2010 vs. Budget
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 35,851$ 36,982$ 98,294$ 62,443$ 174% 61,312$ 166%
Feb 45,883 47,331 41,012 (4,871) ‐11% (6,319) ‐13%
Mar 86,425 89,153 64,399 (22,026) ‐25% (24,754) ‐28%
Apr 27,659 28,532 45,065 17,406 63% 16,533 58%
May 58,715 60,569 103,250 44,534 76% 42,681 70%
Jun 43,085 44,445 ‐
Jul 61,541 63,483 ‐
Aug 43,348 44,716 ‐
Sep 36,509 37,662 ‐
Oct 67,095 69,213 ‐
Nov 59,883 61,773 ‐
Dec 109,397 112,850 ‐
YTD Total 254,533$ 262,567$ 352,020$ 97,487$ 38% 89,453$ 34%
Annual Total 675,391$ 696,708$
2010 vs. Budget
Year to Date through May
Plan Review / Inspection
Month
2010 vs. 2009
Page 6 of 34
Monthly Financial Report May 2010
Recreation revenues totaled $463k since the
start of the year. Compared to the projected
monthly budget, the City collected $56k or
40% less. Compared to the same month the
prior year, the City collected $61k or 42%
less. Based on the current month’s
collection, the City is projecting Recreation
revenues to be slightly under the budget
projection for 2010.
The year‐to‐date collections for Interfund
Service revenues are $1.4 million.
Compared to the projected budget, the
revenues are above by $98k or up by 8%.
Compared to the prior year, the revenues
are over by $38k or up by 3%.
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 below breaks
down these fines by type. The year‐to‐
date total fines and penalties is $1.3
million. This is $261k lower than a
year ago and $162k under budget.
Part of the difference is due to the
timing of revenue recognition, which
contributed to the variance in January
and will be caught up at the end of the
year.
There are also substantial declines in
the photo enforcement fines, which
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 65,409$ 63,034$ 62,673$ (2,736)$ ‐4% (361)$ ‐1%
Feb 72,988 70,337 64,915 (8,072) ‐11% (5,422) ‐8%
Mar 81,034 78,092 99,100 18,065 22% 21,008 27%
Apr 141,783 136,635 152,452 10,669 8% 15,818 12%
May 145,050 139,783 83,760 (61,290) ‐42% (56,023) ‐40%
Jun 154,237 148,636 ‐
Jul 429,059 413,478 ‐
Aug 203,222 195,842 ‐
Sep 123,439 118,956 ‐
Oct 79,452 76,566 ‐
Nov 61,971 59,720 ‐
Dec 73,842 71,161 ‐
YTD Total 506,264$ 487,880$ 462,900$ (43,364)$ ‐9% (24,980)$ ‐5%
Annual Total 1,631,486$ 1,572,240$
Recreation
Year to Date through May
2010 vs. 2009
Month
2010 vs. Budget
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 253,147$ 241,782$ 242,658$ (10,489)$ ‐4% 876$ 0%
Feb 243,496 232,565 273,674 30,178 12% 41,110 18%
Mar 286,921 274,040 249,758 (37,163) ‐13% (24,282) ‐9%
Apr 280,094 267,520 348,019 67,925 24% 80,499 30%
May 282,056 269,393 269,154 (12,902) ‐5% (240) 0%
Jun 270,778 258,622 ‐
Jul 263,897 252,050 ‐
Aug 258,386 246,785 ‐
Sep 265,902 253,965 ‐
Oct 266,313 254,357 ‐
Nov 281,154 268,532 ‐
Dec 273,599 261,316 ‐
YTD Total 1,345,715$ 1,285,300$ 1,383,263$ 37,548$ 3% 97,963$ 8%
Annual Total 3,225,745$ 3,080,927$
2010 vs. 2009 2010 vs. Budget
Month
Interfund Services
Year to Date through May
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 280,849$ 262,296$ 239,080$ (41,769)$ ‐15% (23,215)$ ‐9%
Feb 285,126 270,000 228,332 (56,794) ‐20% (41,668) ‐15%
Mar 370,244 347,334 279,311 (90,933) ‐25% (68,023) ‐20%
Apr 331,546 310,184 294,612 (36,934) ‐11% (15,572) ‐5%
May 310,888 290,518 276,543 (34,345) ‐11% (13,976) ‐5%
Jun 330,829 310,311 ‐
Jul 321,486 307,795 ‐
Aug 256,668 238,715 ‐
Sep 269,199 250,627 ‐
Oct 318,272 297,690 ‐
Nov 368,928 345,586 ‐
Dec 372,972 346,135 ‐
YTD Total 1,578,653$ 1,480,333$ 1,317,878$ (260,775)$ ‐17% (162,454)$ ‐11%
Annual Total 3,817,008$ 3,577,193$
2010 vs. Budget2010 vs. 2009
Year to Date through May
Fines and Penalties by Month
Month
Page 7 of 34
Monthly Financial Report May 2010
we expect to continue. The decline is due to driver behavior changes in the areas with photo enforcement programs; and
the recent change in speed enforcement threshold in school zones. These factors contributed to the reduction in photo
enforcement revenue by 35% in April and 29% in May when compared with the same periods in 2009. At this point, the
City is projecting Fines and Penalties to be under budget by $400k by the end of 2010.
Year to Date through May
2009 2010 2010
Actual Budget Actual $ % $ %
Civil Penalties 6,729$ 5,762$ 5,699$ (1,030)$ ‐15% (63)$ ‐1%
Civil Infraction Penalties 316,655 287,464 293,334 (23,321) ‐7% 5,870 2%
Civil Parking Infraction Penalties 63,321 54,234 55,018 (8,303) ‐13% 784 1%
Photo Enforcement Program 1,038,725 986,910 813,819 (224,906) ‐22% (173,090) ‐18%
Crim Traffic Misdemeanor Fines 39,419 31,486 34,836 (4,582) ‐12% 3,351 11%
Criminal Non‐Traffic Fines 20,461 19,045 13,813 (6,649) ‐32% (5,232) ‐27%
Criminal Costs 70,148 75,407 90,342 20,195 29% 14,935 20%
Non‐Court Fines, Forfeitures and Penalties 23,195 20,025 11,016 (12,179) ‐53% (9,009) ‐45%
YTD Total 1,578,653$ 1,480,333$ 1,317,878$ (260,775)$ ‐17% (162,454)$ ‐11%
Annual Total 3,817,008$ 3,577,193$
Fines and Penalties by Type
Revenue
2010 vs. Budget2010 vs. 2009
Included in the Fines and Penalties revenue budget
is $2.3 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 $814k. The associated costs
includes the equipment provided by American
Traffic Solutions Inc (ATS), we are also dedicating 2
FTEs in the Court Division to process the increased
caseload and 1.1 FTEs in the Police Department for
support services. These staff’s time along with a
90% pro tem budget and interpreter costs amounts
to $362k for personnel costs. The total costs for the
program equates to $842k which is represented in
the table.
Miscellaneous
This revenue source reflects the collection
of interest and other earnings, rents, leases,
and concessions, contributions, and
donations from private sources, and other
miscellaneous revenues. Interest and other
earnings along with rents, leases, and
concessions constitute 86% of the total
revenue in this category. The year‐to‐date
total miscellaneous is $574k. Compared to
the projected year‐to‐date budget, the
revenues are under by $14k or down by 2%.
Favorable
Budget Actual Budget Actual (Unfavorable)
1
Jan 173,461$ 187,281$ 70,097$ 71,970$ 115,311$
Feb 166,708 135,565 69,919 72,434 63,131
Mar 245,529 172,250 69,697 71,970 100,280
Apr 209,106 162,520 70,260 50,102 112,418
May 192,106 156,204 70,181 67,891 88,313
Jun 223,152 ‐ 69,786 ‐ ‐
Jul 143,538 ‐ 69,991 ‐ ‐
Aug 143,576 ‐ 69,525 ‐ ‐
Sep 149,862 ‐ 69,700 ‐ ‐
Oct 188,205 ‐ 69,347 ‐ ‐
Nov 240,433 ‐ 70,269 ‐ ‐
Dec 174,325 ‐ 73,194 ‐ ‐
YTD Total 986,910$ 813,819$ 350,153$ 334,366$ 479,453$
Annual Total 2,250,000$ 841,964$ 1,408,036$
1 Actuals of Revenues and Expenses
Revenues Expenses
Photo Enforcement Program
Year to Date through May
Month
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 143,245$ 129,038$ 170,998$ 27,753$ 19% 41,959$ 33%
Feb 192,680 173,570 86,124 (106,555) ‐55% (87,446) ‐50%
Mar 59,923 53,980 115,122 55,199 92% 61,142 113%
Apr 100,349 90,397 99,376 (974) ‐1% 8,979 10%
May 156,161 140,673 101,909 (54,252) ‐35% (38,764) ‐28%
Jun 100,207 90,269
Jul 219,671 197,884
Aug 80,681 72,680
Sep 131,358 118,330
Oct 76,125 68,575
Nov 73,002 65,762
Dec 196,289 176,822
YTD Total 652,358$ 587,658$ 573,528$ (78,829)$ ‐12% (14,130)$ ‐2%
Annual Total 1,529,692$ 1,377,980$
Year to Date through May
Month
2010 vs. Budget2010 vs. 2009
Miscellaneous Revenues by Month
Page 8 of 34
Monthly Financial Report May 2010
2009 2010 2010
Actual Budget Actual $ % $ %
Interests and Other Earnings 237,476$ 185,213$ 132,674$ (104,802)$ ‐44% (52,539)$ ‐28%
Rents, Leases, and Concessions 340,141 307,386 359,452 19,310 6% 52,065 17%
Contributions/Donations from Private Sources 40,498 47,721 42,652 2,155 5% (5,069) ‐11%
Other 34,242 47,337 38,750 4,508 13% (8,587) ‐18%
YTD Total 652,358$ 587,658$ 573,528$ (78,829)$ ‐12% (14,130)$ ‐2%
Annual Total 1,529,692$ 1,377,980$
2010 vs. Budget
Miscellaneous Revenues by Type
Year to Date through May
Revenue
2010 vs. 2009
EXPENSES
Overall the City has expended 44% of its budgeted general governmental expenditures at the end of May. This is 2.6% or
$1.2 million below year‐to‐date budgeted expenditure. Below are the explanations for some of the large variances on the
expenditures. We do expect some expenditure savings at the end of the year, but it will be narrower than the 2.6% we
currently have.
The Executive Department appears to be over budget but this is not the case. The difference is primarily caused by the
change in expenditure pattern between 2008/2009 vs. 2010. The forming of the Communications Division mid last year and
we made a lump‐sum interfund‐payment to the Communications Division in July 2009 after the budget adjustment was
approved by the City Council, thus less amount proportionally was shown as spent in the first half of 2009 in the Executive
Department. Our budget projection relies on the previous two year’s spending patterns, therefore it appears as if the
Executive Department is over budget this year. We expect the department to be on budget when the year‐to‐date budget
catches up with the annual budget.
Similarly, we expect the rest of the departments currently showing “unfavorable variances” to be on budget as well. This
includes the Planning Division of Community and Economic Development as well as the Transportation Division of Public
Works. There was an error in the 2010 budget for the Planning Division (one position was budgeted in Development
Services Division instead of Planning). The Transportation Division incurred unanticipated increased electricity costs in April
2010.
On the positive variance side, the Finance Department appears to be under budget by $222k. This is due to the $200,000
banking service fees in the carry forward budget amendment that will not be paid until year‐end. The department had a
couple of temporary vacancies in 2010 which also helped the year‐to‐day status. These positions are now filled and we
expect the banking service fees to be substantially higher than we have budgeted for, therefore staff does not expect
savings in Finance at the end of the year, and we will likely need to make an additional adjustment to cover the higher bank
fees.
Page 9 of 34
Monthly Financial Report May 2010
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 ‐ ‐ ‐ ‐ 27,217 22,000 ‐
Grants 61,220 ‐ ‐ 2,699 ‐ 274,107 ‐
Charges for services 6,676 592,315 6,150,049 3,767,017 6,994,553 2,084,452 ‐
Interdepartmental services ‐ ‐ 1,163 102,863 59,727 195,933 ‐
Rents, leases, and misc fees 508,054 118,008 30,000 37,624 ‐ ‐ ‐
Interest and other misc 6,173 8,032 107,418 162,266 117,891 86,625 80
TOTAL REVENUES 582,123 718,355 6,288,630 4,072,469 7,199,388 2,663,117 80
EXPENSES:
Utility billing ‐ ‐ 54,253 48,146 40,170 66,253 ‐
Utility systems ‐ ‐ 5,170,626 1,008,352 917,140 856,015 ‐
Utility maintenance ‐ ‐ 113,981 1,861,438 5,094,114 632,577 ‐
Transportation 410,185 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 688,618 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 410,185 688,618 5,338,860 2,917,936 6,051,424 1,554,845 ‐
AMOUNT AVAILABLE FOR DEBT SERVICE 171,938 29,737 949,770 1,154,533 1,147,964 1,108,272 80
DEBT SERVICE:
Principal ‐ 9,503 ‐ ‐ ‐ ‐ ‐
Interest and other debt service costs ‐ 607 ‐ 1,040 428 582 ‐
TOTAL DEBT SERVICE ‐ 10,110 ‐ 1,040 428 582 ‐
CAPITAL PROJECTS 136,683 159,439 ‐ 606,922 888,505 484,084 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 35,255 (139,812) 949,770 546,571 259,031 623,606 80
BEGINNING FUND BALANCE, January 1, 2010 1,049,083 1,085,801 326,034 7,157,108 2,775,538 3,982,842 15,605
ENDING FUND BALANCE, May 31, 2010 1,084,338 945,989 1,275,804 7,703,679 3,034,569 4,606,448 15,685
Page 10 of 34
Monthly Financial Report May 2010
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:
Grants ‐ 986 ‐ ‐ ‐ ‐ ‐
Charges for services
Equipment rental m&o 866,296 817,717 ‐ ‐ ‐ ‐ ‐
Telecommunications ‐ 119,078 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 44,734 ‐ 140,622 ‐ ‐ ‐
Communications ‐ ‐ ‐ 225,014 ‐ ‐ ‐
Facilities ‐ ‐ 1,740,105 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 46,846 ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ 104,494 ‐ ‐ ‐ ‐ ‐
Interest and other misc 23,422 9,366 893 502 29,940 28,991 16,034
Internal service fund misc:
Vehicle/equipment capital recovery 600,094 415,310 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 920,375 ‐ ‐
Worker's compensation / unemployment ‐ ‐ ‐ ‐ 548,251 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 4,618,280 732,144
Other misc ‐ ‐ 2,078 ‐ ‐ 190,405 ‐
Disposal of capital assets ‐ ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 53,512 84,869 27,898
TOTAL REVENUES 1,489,812 1,558,531 1,743,076 366,138 1,552,078 4,922,545 776,076
EXPENSES:
Communications 182,464
Equipment rental 853,139
Facilities 1,588,031
Healthcare 3,924,036
Information technology 1,311,629
Print and mail ‐ 187,931
Retiree healthcare 441,635
Risk management 1,572,451
TOTAL EXPENSES 853,139 1,311,629 1,588,031 370,395 1,572,451 3,924,036 441,635
AMOUNT AVAILABLE FOR DEBT SERVICE 636,673 246,902 155,045 (4,257) (20,373) 998,509 334,441
DEBT SERVICE:
Principal ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest and other debt service costs ‐ ‐ ‐ ‐ ‐ ‐ ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ ‐ ‐ ‐ ‐
CAPITAL PROJECTS 608,509 161,127 25,000 29,408 ‐ ‐ ‐
TRANSFERS IN ‐ ‐ ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 28,164 85,775 130,045 (33,665) (20,373) 998,509 334,441
BEGINNING FUND BALANCE, January 1, 2010 4,593,399 1,647,931 91,175 111,818 6,039,509 4,792,452 2,820,473
ENDING FUND BALANCE, May 31, 2010 4,621,563 1,733,706 221,220 78,153 6,019,136 5,790,961 3,154,914
Page 11 of 34
Monthly Financial Report May 2010
THE SCORE
The South Correctional Entity (SCORE) is a public development authority (PDA) that was formed to build and operate a new
822‐bed misdemeanor jail in South King County. SCORE is made up of cities located in South King County and they are
Auburn, Burien, Des Moines, Federal Way, Renton, SeaTac, and Tukwila. The City of Renton is the principle of the PDA as
well as acting as the treasurer and fiscal agent for SCORE during the planning and development phase. The design and
permit work, construction bid opening, and bond sell has been completed.
The current estimated total development and construction costs for the project is around $95 million, including capitalized
interest and startup costs. The bonding is $87 million with the remaining $8 million to be financed by member
contributions. The City of Renton is obligated for 36% of the bonds issued.
The table below lists the year to date financing sources and uses of the SCORE:
SCORE
REVENUES:
Interlocal city contribution
Auburn ‐
Burien 4,000
Des Moines ‐
Federal Way ‐
Renton ‐
Seatac 3,000
Tukwila ‐
Interest and other misc 138,450
Bond proceeds ‐
Tax Credit (BABs)‐
TOTAL REVENUES 145,450
EXPENSES:
Salaries and wages ‐
Benefits ‐
Supplies 3,987
Professional services 912,056
Intergovernmental 612,192
Construction 18,074,309
TOTAL EXPENSES 19,602,543
AMOUNT AVAILABLE FOR DEBT SERVICE (19,457,094)
DEBT SERVICE:
Principal ‐
Interest and other debt service costs 861,814
TOTAL DEBT SERVICE 861,814
CHANGE IN FUND BALANCE (20,318,907)
BEGINNING FUND BALANCE, January 1, 2010 80,644,637
ENDING FUND BALANCE, May 31, 2010 60,325,730
Page 12 of 34
Monthly Financial Report May 2010
FUND BALANCE
Page 14 shows the ending fund balance as of May 2010. 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) include funds identified as being reserved for specific purposes or required
to meet the current year’s appropriations. These balances also provide financial stability to the City’s operation during
uncertain times and provide a layer of security to bondholders.
At the end of May, the City has $16.2 million reported in combined general governmental fund balance of the current year’s
operating budget, which is approximately 16% of budgeted operating expenditures. This is an increase of $4.2 million from
the beginning balance of January 1, 2010. May’s ending fund balance is over the anticipated General Governmental Fund
Balance of $15.3 million by $827k. Although the ending fund balance is above projections, it is consistent with the prior
years’ trends since the City receipted the first half of 2010 property taxes in April and May. We expect the fund balance to
decrease but be in line with the projected fund balance after May.
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 34
Monthly Financial Report May 2010
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through May 31, 2010
Funds
Balance
01/01/2010
Budgeted
Revenue
Revenue
05/31/10
Total Funds
Available
Budgeted
Expenditure
Expenditure
05/31/10 Ending Balance
GENERAL GOVERNMENT FUNDS:11,955,285 98,542,948 48,191,829 60,147,114 99,347,239 43,949,015 16,198,099
000 General 8,535,013 74,520,193 32,565,736 41,100,749 72,517,802 29,019,419 12,081,330
001 Community Services 958,009 9,557,924 4,118,473 5,076,482 10,461,433 3,481,093 1,595,389
003 Street 1,391,648 7,201,490 3,499,637 4,891,285 8,543,138 3,438,717 1,452,568
004 Community Dev Block Grant (6,528) 532,635 81,103 74,575 532,227 122,058 (47,483)
005 Museum 64,705 192,621 96,610 161,315 194,120 78,771 82,544
006 Library 706,011 1,888,252 364,923 1,070,934 2,544,263 1,067,015 3,919
009 Farmers Market 60,571 44,280 18,132 78,703 34,311 2,277 76,426
010 Fire Memorial 936 ‐ (700) 236 ‐ ‐ 236
011 Fire Health & Wellness 4,303 25,000 9,939 14,242 25,000 ‐ 14,242
031 Park Memorial 175,066 ‐ 929 175,995 ‐ ‐ 175,995
201 Ltd GO Bonds Gen Govt Debt 1,448 2,033,177 347,977 349,425 1,984,625 2,400 347,025
215 Gen Govt Misc Debt Service 64,103 2,547,376 7,089,070 7,153,173 2,510,320 6,737,265 415,908
SPECIAL REVENUE FUNDS:
102 Arterial Street 200,686 620,000 338,817 539,503 620,000 ‐ 539,503
108 Leased City Properties 837,613 1,669,586 896,290 1,733,903 1,511,561 1,055,164 678,739
110 Hotel Motel 247,828 245,000 116,242 364,070 245,000 135,034 229,036
118 Reserve for Paths & Trails 3,264 ‐ 21 3,285 ‐ ‐ 3,285
125 1% For Art 143,796 35,000 768 144,564 50,000 86 144,478
127 Cable Communication 89,391 85,000 26,090 115,481 85,674 11,500 103,981
135 Springbrook Wetlands Bank 459,528 ‐ 2,445 461,973 ‐ ‐ 461,973
DEBT SERVICE FUNDS:
219 1989 Unlimited GO Bonds 79,340 ‐ ‐ 79,340 79,340 ‐ 79,340
CAPITAL PROJECT FUNDS (CIP):
303 Community Dev Mitigation 1,066,593 60,000 252,212 1,318,805 ‐ ‐ 1,318,805
304 Fire Mitigation 2,363,522 100,000 26,479 2,390,001 560,000 ‐ 2,390,001
305 Transportation Mitigation 2,167,133 200,000 (39,741) 2,127,392 1,810,000 ‐ 2,127,392
316 Municipal Facilities CIP 6,933,186 1,333,553 582,456 7,515,642 7,621,771 901,203 6,614,439
317 Transportation CIP 2,892,341 30,582,042 5,585,003 8,477,344 32,413,734 6,233,658 2,243,686
318 So Lake WA Infrastructure Proj 114,039 ‐ 591 114,630 114,000 37,778 76,852
326 Housing Opportunity 201,653 ‐ 1,076 202,729 ‐ ‐ 202,729
ENTERPRISE FUNDS:
402 Airport 415,929 1,917,163 517,628 933,557 1,001,800 410,185 523,372
403 Solid Waste Utility 326,034 15,025,000 6,288,631 6,614,665 15,025,000 5,338,860 1,275,805
404 Golf Course 798,278 2,483,545 717,289 1,515,567 2,566,837 741,203 774,364
422 Airport Capital 633,154 1,578,000 64,494 697,648 1,831,485 136,683 560,965
424 Golf Course Capital 287,523 150,000 1,066 288,589 302,499 116,964 171,625
INTERNAL SERVICE FUNDS:
501 Equipment Repair/Replacement 4,593,399 3,631,241 1,489,812 6,083,211 3,413,927 1,461,648 4,621,563
502 Insurance 6,039,509 3,287,584 1,552,078 7,591,587 4,170,106 1,572,451 6,019,136
503 Information Services 1,647,931 4,194,774 1,558,531 3,206,462 4,841,706 1,472,756 1,733,706
504 Facilities 91,175 4,705,475 1,743,076 1,834,251 4,326,200 1,613,031 221,220
505 Communications 111,818 1,049,671 366,138 477,956 877,560 399,802 78,154
512 Insurance, Healthcare 4,792,452 12,358,471 4,922,545 9,714,997 12,462,810 3,924,036 5,790,961
522 Insurance, Leoff1 Retirees HC 2,820,473 2,235,684 776,075 3,596,548 2,248,907 441,635 3,154,913
FIDUCIARY FUNDS:
611 Firemen's Pension 4,332,817 300,000 120,062 4,452,879 550,475 163,756 4,289,123
F unds
Balance
01/01/2010
Budgeted
Revenue
Revenue
05/31/10
Total Funds
Available
Budgeted
Expenditure
Expenditure
05/31/10 Ending Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 13,931,093 44,912,214 13,935,055 27,866,148 51,150,420 12,505,765 15,360,383
405 Water Utility 4,294,833 11,316,610 3,971,896 8,266,729 11,560,951 2,935,054 5,331,675
406 Waste Water Utility 1,887,815 6,070,737 2,339,635 4,227,450 6,780,650 1,467,777 2,759,673
407 Surface Water Utility 2,448,845 5,783,148 2,334,400 4,783,245 6,641,884 1,555,428 3,227,817
416 King County Metro 46,504 11,211,935 4,756,763 4,803,267 11,211,935 4,584,075 219,192
425 Water Utility Construction 2,862,275 3,460,000 100,574 2,962,849 5,510,000 590,842 2,372,007
426 Waste Water Construction 841,219 3,153,781 102,990 944,209 3,995,000 888,505 55,704
427 Surface Water Construction 1,533,997 3,916,003 328,717 1,862,714 5,450,000 484,084 1,378,630
461 Waterworks Bond Reserve ‐ ‐ ‐ ‐ ‐ ‐ ‐
471 Waterworks Rate Stabilization 15,605 ‐ 80 15,685 ‐ ‐ 15,685
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 34
City of Renton
General Government Financial Position
2010 Budget Year
General Government Summary
Revenues Expenditures
$ Difference
over (under)
w/beginning
balance
11,955,285
January 4,881,556 7,161,528 (2,279,972) 9,675,313
February 10,472,029 15,011,456 (4,539,427) 7,415,858
March 15,590,071 22,695,538 (7,105,467) 4,849,818
April 27,747,760 29,817,438 (2,069,678) 9,885,607
May 48,191,829 43,949,015 4,242,814 16,198,099
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
70,000,000
80,000,000
90,000,000
100,000,000
110,000,000
DifferenceRev/Exp Revenues
Expenditures
Difference
(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
‐
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
110,000,000
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
DifferenceRev/Exp Revenues
Expenditures
Difference
Page 15 of 34
City of Renton
Monthly Revenue Analysis ‐ 2010 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 4,913,351 4,881,556 ‐0.65%
Feb 10,850,564 10,472,029 ‐3.49%
Mar 16,350,246 15,590,071 ‐4.65%
Apr 29,228,824 27,747,760 ‐5.07%
May 44,121,619 48,191,829 9.22%
Jun 49,310,891
Jul 55,416,612
Aug 61,148,855
Sep 65,808,951
Oct 77,111,827
Nov 92,687,526
Dec 98,542,948
Percent of budget 48.90%
Property Tax Budget
YTD
Actual
Annual %
over (under)
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
Millions
Total Revenue
General Government
Budget
Actual
Last Year
$30
$33
Millions Property Tax
Budget
Actual
py g ()
Jan 9,635 218,705 2169.90%
Feb 320,118 489,513 52.92%
Mar 982,841 1,037,146 5.53%
Apr 9,231,227 7,697,974 ‐16.61%
May 16,097,311 16,434,665 2.10%
Jun 16,213,191
Jul 16,320,354
Aug 16,388,472
Sep 16,644,516
Oct 22,547,053
Nov 31,012,799
Dec 31,364,643
Percent of budget 52.40%
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
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 34
City of Renton
Monthly Revenue Analysis ‐ 2010 Budget Year
Sales Tax Budget
YTD
Actual
Annual %
over (under)
Jan 1,688,260 1,442,659 ‐14.55%
Feb 3,848,016 3,376,692 ‐12.25%
Mar 5,540,865 4,818,562 ‐13.04%
Apr 7,161,203 6,445,782 ‐9.99%
May 8,888,836 8,120,233 ‐8.65%
Jun 10,537,549
Jul 12,138,293
Aug 13,935,185
Sep 15,628,456
Oct 17,436,835
Nov 18,929,142
Dec 20,857,000
Percent of budget 38.93%
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,379,262 1,282,930 ‐6.98%
Feb 2,829,096 2,637,863 ‐6.76%
Mar 4,050,000 3,933,596 ‐2.87%
Apr 5,225,375 5,193,705 ‐0.61%
May 6,516,282 6,425,405 ‐1.39%
Jun 7,560,617
Jul 8,546,617
Aug 9,718,578
Sep 10,760,779
Oct 11,813,935
Nov 12,878,332
Dec 14,228,000
Percent of budget 45.16%
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 34
City of Renton
Monthly Revenue Analysis ‐ 2010 Budget Year
Licenses/
Permits Budget
YTD
Actual
Annual %
over (under)
Jan 220,191 394,387 79.11%
Feb 415,373 496,041 19.42%
Mar 640,289 633,007 ‐1.14%
Apr 866,016 867,134 0.13%
May 1,046,903 1,014,467 ‐3.10%
Jun 1,224,807
Jul 1,451,179
Aug 1,631,518
Sep 1,759,093
Oct 2,024,220
Nov 2,153,967
Dec 2,386,376
Percent of budget 42.51%
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
Millions Licenses & Permits
Budget
Actual
Last Year
g g ()
Jan 352,045 371,847 5.62%
Feb 819,806 1,023,691 24.87%
Mar 1,244,334 1,536,757 23.50%
Apr 1,688,788 2,128,407 26.03%
May 4,999,359 2,963,839 ‐40.72%
Jun 5,390,092
Jul 5,807,628
Aug 6,922,028
Sep 7,390,372
Oct 8,027,921
Nov 11,304,114
Dec 11,653,246
Percent of budget 25.43%
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
Millions Licenses & Permits
Budget
Actual
Last Year
Page 18 of 34
City of Renton
Monthly Revenue Analysis ‐ 2010 Budget Year
Charges for
Svcs Budget
YTD
Actual
Annual %
over (under)
Jan 391,334 445,172 13.76%
Feb 791,905 869,415 9.79%
Mar 1,295,331 1,336,778 3.20%
Apr 1,774,948 1,954,003 10.09%
May 2,308,362 2,466,435 6.85%
Jun 2,817,547
Jul 3,611,251
Aug 4,145,264
Sep 4,604,070
Oct 5,058,558
Nov 5,489,415
Dec 5,997,460
Percent of budget 41.12%
Fines &
Forfeits Budget
YTD
Actual
Annual %
over (under)
$‐
$1
$2
$3
$4
$5
$6
$7
Millions Charges for Services
Budget
Actual
Last Year
$4.00
Millions Fines & Forfeits
Budget
g ()
Jan 262,296 239,080 ‐8.85%
Feb 532,296 467,413 ‐12.19%
Mar 879,630 746,724 ‐15.11%
Apr 1,189,814 1,041,335 ‐12.48%
May 1,480,333 1,317,878 ‐10.97%
Jun 1,790,644
Jul 2,098,439
Aug 2,337,154
Sep 2,587,781
Oct 2,885,471
Nov 3,231,058
Dec 3,577,193
Percent of budget 36.84%
$‐
$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
$4.00
Millions Fines & Forfeits
Budget
Actual
Last Year
Page 19 of 34
City of Renton
Monthly Revenue Analysis ‐ 2010 Budget Year
Other Taxes Budget
YTD
Actual
Annual %
over (under)
Jan 424,298 315,778 ‐25.58%
Feb 887,009 854,174 ‐3.70%
Mar 1,210,805 1,175,121 ‐2.95%
Apr 1,527,046 1,947,556 27.54%
May 2,129,929 2,261,610 6.18%
Jun 3,055,413
Jul 3,781,909
Aug 4,301,294
Sep 4,584,474
Oct 5,408,386
Nov 5,791,753
Dec 6,297,095
Percent of budget 35.92%
Misc Budget
YTD
Actual
Annual %
over (under)
$1 60
$1.80
Millions Miscellaneous
Budget
Al
$0
$1
$2
$3
$4
$5
$6
$7
Millions Other Taxes
Budget
Actual
Last Year
g ()
Jan 129,034 170,998 32.52%
Feb 302,604 257,122 ‐15.03%
Mar 356,594 372,244 4.39%
Apr 446,989 471,619 5.51%
May 587,653 573,528 ‐2.40%
Jun 677,925
Jul 1,416,302
Aug 1,488,990
Sep 1,066,818
Oct 1,135,400
Nov 1,201,158
Dec 1,377,980
Percent of budget 41.62%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
Millions Miscellaneous
Budget
Actual
Last Year
$0
$1
$2
$3
$4
$5
$6
$7
Millions Other Taxes
Budget
Actual
Last Year
Page 20 of 34
City of Renton
Monthly Revenue Analysis ‐ 2010 Budget Year
REET Budget
YTD
Actual
Annual %
over (under)
Jan 229,560 71,303 ‐68.94%
Feb 298,320 178,545 ‐40.15%
Mar 480,120 487,709 1.58%
Apr 620,064 769,455 24.09%
May 925,800 986,269 6.53%
Jun 1,135,488
Jul 1,335,888
Aug 1,644,120
Sep 1,850,592
Oct 2,058,960
Nov 2,279,304
Dec 2,400,000
Percent of budget 41.09%
Note: Combines Funds 201, 215, 316, and 318
$0.00
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
Millions Real Estate Excise Tax
Budget
Actual
Last Year
Page 21 of 34
City of Renton
Monthly Expenditure Analysis ‐ 2010 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,163,929 7,161,528 ‐0.03%
Feb 15,254,769 15,011,456 ‐1.59%
Mar 22,794,231 22,695,538 ‐0.43%
Apr 30,497,615 29,817,438 ‐2.23%
May 37,946,671 43,949,015 15.82%
Jun 46,603,790
Jul 54,947,964
Aug 62,948,398
Sep 70,847,497
Oct 78,654,203
Nov 86,699,342
Dec 99,347,239
Percent of budget expended 44.24%
Legislative Budget
YTD
Actual
Annual %
over (under)
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
Millions
Total Expenditures
General Government
Budget
Actual
Last Year
$300,000
Legislative
Budget
g g ()
Jan 21,938 21,032 ‐4.13%
Feb 44,183 43,671 ‐1.16%
Mar 68,592 65,280 ‐4.83%
Apr 91,263 87,679 ‐3.93%
May 113,769 109,177 ‐4.04%
Jun 136,495
Jul 158,472
Aug 180,456
Sep 202,484
Oct 224,540
Nov 246,799
Dec 267,957
Percent of budget expended 40.74%
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
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 34
City of Renton
Monthly Expenditure Analysis ‐ 2010 Budget Year
Court Services Budget
YTD
Actual
Annual %
over (under)
Jan 152,880 168,470 10.20%
Feb 317,920 328,318 3.27%
Mar 483,826 499,117 3.16%
Apr 656,729 664,092 1.12%
May 829,712 822,296 ‐0.89%
Jun 1,004,692
Jul 1,173,482
Aug 1,341,545
Sep 1,508,802
Oct 1,677,249
Nov 1,836,905
Dec 2,016,361
Percent of budget expended 40.78%
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
g ()
Jan 105,591 134,784 27.65%
Feb 250,653 272,736 8.81%
Mar 385,511 407,609 5.73%
Apr 521,891 539,712 3.41%
May 654,166 672,872 2.86%
Jun 785,689
Jul 935,460
Aug 1,087,274
Sep 1,225,811
Oct 1,370,153
Nov 1,499,437
Dec 1,635,047
Percent of budget expended 41.15%
$‐
$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 23 of 34
City of Renton
Monthly Expenditure Analysis ‐ 2010 Budget Year
Finance Budget
YTD
Actual
Annual %
over (under)
Jan 254,764 145,053 ‐43.06%
Feb 426,592 286,770 ‐32.78%
Mar 619,310 443,082 ‐28.46%
Apr 794,926 591,163 ‐25.63%
May 992,753 770,836 ‐22.35%
Jun 1,166,399
Jul 1,342,556
Aug 1,525,165
Sep 1,700,824
Oct 1,832,622
Nov 2,006,095
Dec 2,164,890
Percent of budget expended 35.61%
City Attorney Budget
YTD
Actual
Annual %
over (under)
$1.60
$1.80
Millions City Attorney
Budget
At l
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
Millions Finance
Budget
Actual
Last Year
y y g ()
Jan 106,795 127,162 19.07%
Feb 246,680 266,526 8.05%
Mar 403,070 400,465 ‐0.65%
Apr 549,408 532,980 ‐2.99%
May 691,207 666,194 ‐3.62%
Jun 825,807
Jul 1,028,793
Aug 1,108,058
Sep 1,244,944
Oct 1,384,635
Nov 1,520,418
Dec 1,621,295
Percent of budget expended 41.09%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
Millions City Attorney
Budget
Actual
Last Year
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
Millions Finance
Budget
Actual
Last Year
Page 24 of 34
City of Renton
Monthly Expenditure Analysis ‐ 2010 Budget Year
Human
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 62,931 71,457 13.55%
Feb 148,376 141,160 ‐4.86%
Mar 230,102 213,772 ‐7.10%
Apr 311,875 283,314 ‐9.16%
May 394,684 354,450 ‐10.19%
Jun 472,922
Jul 547,642
Aug 620,352
Sep 697,386
Oct 773,457
Nov 845,873
Dec 918,169
Percent of budget expended 38.60%
Public Works Budget
YTD
Actual
Annual %
over (under)
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
$0.70
$0.80
$0.90
$1.00
Millions Human Resources
Budget
Actual
Last Year
$1.20
Millions Public Works
Budget
g ()
Jan 40,311 42,532 5.51%
Feb 86,173 86,114 ‐0.07%
Mar 133,892 129,351 ‐3.39%
Apr 179,050 172,378 ‐3.73%
May 221,237 215,438 ‐2.62%
Jun 264,331
Jul 308,727
Aug 353,278
Sep 394,646
Oct 441,919
Nov 483,769
Dec 518,399
Percent of budget expended 41.56%
Note: For comparative purposes history does not include Development Svcs division (now in CED).
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
$0.70
$0.80
$0.90
$1.00
Millions Human Resources
Budget
Actual
Last Year
$‐
$0.30
$0.60
$0.90
$1.20
Millions Public Works
Budget
Actual
Last Year
Page 25 of 34
City of Renton
Monthly Expenditure Analysis ‐ 2010 Budget Year
Other City
Services Budget
YTD
Actual
Annual %
over (under)
Jan 414,785 348,715 ‐15.93%
Feb 819,456 701,408 ‐14.41%
Mar 1,210,803 1,136,033 ‐6.18%
Apr 1,824,496 1,429,727 ‐21.64%
May 1,977,632 1,657,444 ‐16.19%
Jun 2,363,946
Jul 2,580,253
Aug 2,956,550
Sep 3,332,176
Oct 3,741,593
Nov 4,083,716
Dec 4,792,981
Percent of budget expended 34.58%
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
$27
$30
Millions Police
Budget
Actual
g ()
Jan 2,165,025 2,260,619 4.42%
Feb 4,517,801 4,238,853 ‐6.17%
Mar 6,790,712 6,677,267 ‐1.67%
Apr 8,836,921 8,955,690 1.34%
May 11,203,428 11,016,981 ‐1.66%
Jun 13,466,812
Jul 15,954,657
Aug 18,080,450
Sep 20,560,448
Oct 22,762,743
Nov 25,377,250
Dec 28,022,582
Percent of budget expended 39.31%
$‐
$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
Millions Police
Budget
Actual
Last Year
Page 26 of 34
City of Renton
Monthly Expenditure Analysis ‐ 2010 Budget Year
Fire & Emerg
Svc Budget
YTD
Actual
Annual %
over (under)
Jan 1,804,022 1,768,398 ‐1.97%
Feb 4,287,068 4,239,777 ‐1.10%
Mar 6,047,506 5,943,458 ‐1.72%
Apr 7,733,307 7,607,800 ‐1.62%
May 9,475,312 9,312,143 ‐1.72%
Jun 11,207,916
Jul 13,014,504
Aug 14,732,889
Sep 16,560,924
Oct 18,349,790
Nov 20,065,074
Dec 21,922,009
Percent of budget expended 42.48%
City Clerk Budget
YTD
Actual
Annual %
over (under)
$‐
$3
$6
$9
$12
$15
$18
$21
$24
Millions Fire & Emergency Services
Budget
Actual
Last Year
$1.00
Millions City Clerk
Budget
y g ()
Jan 77,013 48,025 ‐37.64%
Feb 148,683 92,936 ‐37.49%
Mar 257,863 146,137 ‐43.33%
Apr 393,130 229,025 ‐41.74%
May 465,321 368,812 ‐20.74%
Jun 538,843
Jul 603,120
Aug 661,523
Sep 723,147
Oct 781,484
Nov 843,676
Dec 931,014
Percent of budget expended 39.61%
$‐
$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
$1.00
Millions City Clerk
Budget
Actual
Last Year
Page 27 of 34
City of Renton
Monthly Expenditure Analysis ‐ 2010 Budget Year
Human
Services Budget
YTD
Actual
Annual %
over (under)
Jan 31,267 40,228 28.66%
Feb 68,742 72,960 6.14%
Mar 97,456 139,024 42.65%
Apr 240,125 282,858 17.80%
May 298,961 333,690 11.62%
Jun 360,953
Jul 476,053
Aug 528,908
Sep 569,793
Oct 693,393
Nov 748,914
Dec 874,359
Percent of budget expended 38.16%
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
$200,000
$220,000
Hearing Examiner
Budget
g ()
Jan 16,707 14,619 ‐12.50%
Feb 33,528 29,129 ‐13.12%
Mar 50,066 43,412 ‐13.29%
Apr 67,019 58,097 ‐13.31%
May 83,535 72,376 ‐13.36%
Jun 99,983
Jul 117,131
Aug 133,757
Sep 150,300
Oct 166,956
Nov 183,659
Dec 200,440
Percent of budget expended 36.11%
$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
$‐
$20,000
$40,000
$60,000
$80,000
$100,000
$120,000
$140,000
$160,000
$180,000
$200,000
$220,000
Hearing Examiner
Budget
Actual
Last Year
Page 28 of 34
City of Renton
Monthly Expenditure Analysis ‐ 2010 Budget Year
CED Budget
YTD
Actual
Annual %
over (under)
Jan 509,427 555,670 9.08%
Feb 1,079,871 1,097,029 1.59%
Mar 1,636,852 1,602,874 ‐2.08%
Apr 2,163,456 2,116,917 ‐2.15%
May 2,707,968 2,646,710 ‐2.26%
Jun 3,234,971
Jul 3,814,567
Aug 4,373,869
Sep 4,921,763
Oct 5,481,795
Nov 6,022,924
Dec 6,632,300
Percent of budget expended 39.91%
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
$‐
$1.50
$3.00
$4.50
$6.00
$7.50
Millions Community & Economic
Development
Budget
Actual
Last Year
g ()
Jan 5,749,211 5,746,764 ‐0.04%
Feb 12,150,358 11,897,388 ‐2.08%
Mar 17,973,537 17,846,883 ‐0.70%
Apr 23,903,318 23,551,432 ‐1.47%
May 29,556,081 29,019,419 ‐1.82%
Jun 35,401,015
Jul 41,520,793
Aug 47,160,502
Sep 53,217,189
Oct 58,976,553
Nov 65,185,527
Dec 72,517,802
Percent of budget expended 40.02%
$‐
$15
$30
$45
$60
$75
Millions General Fund
Budget
Actual
Last Year
$‐
$1.50
$3.00
$4.50
$6.00
$7.50
Millions Community & Economic
Development
Budget
Actual
Last Year
Page 29 of 34
City of Renton
Monthly Expenditure Analysis ‐ 2010 Budget Year
Community
Svcs Fund Budget
YTD
Actual
Annual %
over (under)
Jan 628,418 570,605 ‐9.20%
Feb 1,415,327 1,321,394 ‐6.64%
Mar 2,178,593 2,026,750 ‐6.97%
Apr 2,968,536 2,733,709 ‐7.91%
May 3,780,448 3,481,093 ‐7.92%
Jun 4,619,455
Jul 5,761,843
Aug 6,929,653
Sep 7,789,687
Oct 8,632,774
Nov 9,503,898
Dec 10,461,433
Percent of budget expended 33.28%
Street Fund Budget
YTD
Actual
Annual %
over (under)
$‐
$2
$4
$6
$8
$10
$12
$14
Millions Community Svcs Fund
Budget
Actual
Last Year
$8
$9
Millions Street Fund
Budget
At l
g ()
Jan 600,924 641,040 6.68%
Feb 1,276,345 1,365,252 6.97%
Mar 1,958,856 2,078,338 6.10%
Apr 2,664,177 2,735,391 2.67%
May 3,383,424 3,438,717 1.63%
Jun 4,063,971
Jul 4,801,841
Aug 5,565,769
Sep 6,290,996
Oct 7,004,518
Nov 7,710,951
Dec 8,543,138
Percent of budget expended 40.25%
$‐
$2
$4
$6
$8
$10
$12
$14
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 30 of 34
City of Renton
Monthly Expenditure Analysis ‐ 2010 Budget Year
CDBG Budget
YTD
Actual
Annual %
over (under)
Jan 35,191 13,958 ‐60.34%
Feb 75,363 40,304 ‐46.52%
Mar 120,736 68,480 ‐43.28%
Apr 167,971 100,216 ‐40.34%
May 204,663 122,058 ‐40.36%
Jun 240,955
Jul 275,465
Aug 339,295
Sep 370,840
Oct 429,422
Nov 467,929
Dec 532,227
Percent of budget expended 22.93%
Library Fund Budget
YTD
Actual
Annual %
over (under)$3.00
Millions Library Fund
Budget
At l
$‐
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
CDBG
Budget
Actual
Last Year
y g ()
Jan 178,200 173,794 ‐2.47%
Feb 369,656 229,125 ‐38.02%
Mar 573,477 500,663 ‐12.70%
Apr 777,934 505,911 ‐34.97%
May 977,023 1,067,015 9.21%
Jun 1,176,467
Jul 1,368,254
Aug 1,579,352
Sep 1,772,156
Oct 1,974,603
Nov 2,165,372
Dec 2,544,263
Percent of budget expended 41.94%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
Millions Library Fund
Budget
Actual
Last Year
$‐
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
CDBG
Budget
Actual
Last Year
Page 31 of 34
City of Renton
Monthly Expenditure Analysis ‐ 2010 Budget Year
Museum Fund Budget
YTD
Actual
Annual %
over (under)
Jan 15,829 15,310 ‐3.28%
Feb 32,775 31,141 ‐4.99%
Mar 49,002 46,726 ‐4.64%
Apr 65,543 62,643 ‐4.42%
May 82,433 78,771 ‐4.44%
Jun 99,543
Jul 115,981
Aug 132,242
Sep 148,372
Oct 164,641
Nov 180,555
Dec 194,120
Percent of budget expended 40.58%
Note: Prior to 2009, Museum was part of the Library Fund
LTGO Funds Budget
YTD
Actual
Annual %
over (under)
$6 50
$7.00
$7.50
Millions LTGO Funds
Budget
$‐
$20,000
$40,000
$60,000
$80,000
$100,000
$120,000
$140,000
$160,000
$180,000
$200,000
$220,000
Museum Fund
Budget
Actual
Last Year
g ()
Jan ‐ ‐ N/A
Feb ‐ 126,390 100.00%
Mar 22,250 126,390 468.04%
Apr 22,250 126,471 468.41%
May 22,250 6,739,665 30190.63%
Jun 1,078,472
Jul 1,078,472
Aug 1,078,472
Sep 1,078,472
Oct 1,290,948
Nov 1,293,331
Dec 4,494,945
Percent of budget expended 149.94%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
$5.50
$6.00
$6.50
$7.00
$7.50
Millions LTGO Funds
Budget
Actual
Last Year
$‐
$20,000
$40,000
$60,000
$80,000
$100,000
$120,000
$140,000
$160,000
$180,000
$200,000
$220,000
Museum Fund
Budget
Actual
Last Year
Page 32 of 34
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2010 Budget Year
Utilities Budget Revenue Expense
Jan 2,475,180 3,901,859 2,612,849
Feb 5,573,491 7,676,067 5,998,348
Mar 8,521,156 11,963,798 8,343,902
Apr 10,646,195 15,716,035 12,647,433
May 14,447,983 19,691,324 15,881,194
Jun 18,958,727
Jul 23,155,850
Aug 27,231,086
Sep 30,252,248
Oct 33,275,236
Nov 36,644,712
Dec 45,650,678
Percent of budget expended 34.79%
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
p g p
Jan 66,269 94,268 72,717
Feb 159,667 204,281 156,869
Mar 250,901 310,979 242,660
Apr 329,772 418,081 325,667
May 438,337 517,628 410,185
Jun 517,870
Jul 598,355
Aug 688,817
Sep 759,575
Oct 838,546
Nov 913,982
Dec 1,001,800
Percent of budget expended 40.94%
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 ‐ 2010 Budget Year
Golf Course Budget Revenue Expense
Jan 129,394 68,826 97,947
Feb 258,326 174,258 215,710
Mar 479,768 309,509 434,186
Apr 618,377 505,332 578,898
May 813,533 717,289 741,203
Jun 1,066,444
Jul 1,232,903
Aug 1,384,039
Sep 1,549,779
Oct 1,857,389
Nov 1,994,766
Dec 2,566,837
Percent of budget expended 28.88%
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