HomeMy WebLinkAbout201002, February.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 566,588 30,660,522 312,932 31,364,643 373,209 489,513 116,304 31.2%
Sales Tax 20,825,055 3,850,785 17,995,836 3,321,502 18,609,000 3,263,908 3,017,952 (245,956) ‐7.5%
Sales Tax ‐ Annexation Credit ‐ ‐ 2,132,110 392,007 2,248,000 413,315 358,740 (54,574) ‐13.2%
Criminal Justice Sa les Tax 1,755,469 275,168 1,650,350 311,656 1,743,000 300,319 295,109 (5,211) ‐1.7%
Natural Gas Use Tax 253,377 73,239 242,891 56,975 ‐ ‐ 48,940 48,940 0.0%
Admission Tax 197,740 46,705 260,269 57,167 260,000 58,965 75,236 16,271 27.6%
Franchise Fees 998,288 240,795 1,039,031 259,992 1,040,000 255,639 320,478 64,840 25.4%
Electric Tax 4,580,037 786,179 4,963,151 1,029,605 5,150,000 979,891 960,877 (19,014) ‐1.9%
Gas Tax 1,565,810 381,260 1,891,255 595,888 1,858,000 525,168 426,892 (98,276) ‐18.7%
Transfer Station 380,961 40,072 283,985 46,908 230,000 30,086 27,925 (2,160) ‐7.2%
TV Cable 1,073,168 81,424 1,263,743 207,139 1,250,000 154,351 218,605 64,254 41.6%
Phone/Telegraph/Cellular Phone 2,780,196 439,691 3,065,347 491,336 2,860,000 455,516 504,694 49,178 10.8%
City Utilities 2,606,786 359,268 2,871,599 471,659 2,880,000 436,820 449,931 13,111 3.0%
Leasehold Excise Tax 190,644 9,416 146,002 27,996 100,000 11,113 35,999 24,886 223.9%
Gambling Excise Tax 2,157,029 401,109 2,141,720 398,744 2,000,000 372,133 273,344 (98,789) ‐26.5%
Real Estate Excise Tax 2,800,103 382,881 2,418,456 300,624 2,400,000 314,342 178,545 (135,797) ‐43.2%
Less: Municipal Facilities CIP REET (450,103) (191,440) (1,000,000) (174,406) (400,000) (100,916) (29,757) 71,159 ‐70.5%
EMS Levy 890,998 85,744 1,170,657 ‐ 897,095 ‐ ‐ ‐ ‐100.0%
Penalties & Interest on Delinquent Tax 8,125 96,071 1,353 73 ‐ ‐ 329 329 0.0%
Business License Fees 485,537 60,333 424,413 112,016 463,067 87,707 111,395 23,688 27.0%
Other Licenses and Permits 257,477 26,732 176,851 27,803 157,250 19,744 36,750 17,006 86.1%
Building Permits 2,034,225 586,259 1,683,082 257,788 1,766,059 400,999 347,896 (53,103) ‐13.2%
Intergovernmental (Grants, etc) 3,734,887 530,601 3,820,932 486,203 3,895,228 709,057 709,057 ‐ 0.0%
Fire District 25 and 40 Contracts 5,013,549 ‐ 5,869,198 ‐ 5,554,723 19,525 19,525 ‐ 0.0%
Records, Duplicating, and Passport Fees 176,950 38,772 187,721 27,854 217,585 39,753 20,223 (19,530) ‐49.1%
Public Safety 524,565 83,435 521,484 79,853 430,000 67,123 65,965 (1,158) ‐1.7%
Development Service Fees 903,768 140,012 677,955 81,734 696,708 97,673 139,306 41,633 42.6%
Culture and Recreation 1,678,818 149,044 1,631,486 138,397 1,572,240 136,521 127,588 (8,932) ‐6.5%
Interfund/Interdept‐Services 3,072,950 431,111 3,225,745 496,643 3,080,927 453,799 516,332 62,533 13.8%
Fines and Forfeits 2,110,973 194,149 3,817,008 565,975 1,327,193 170,181 246,697 76,515 45.0%
Photo Enforcement ‐ ‐ ‐ ‐ 2,250,000 340,169 220,716 (119,453) ‐35.1%
Interests and Other Earnings 735,910 109,016 535,314 94,222 434,300 69,434 46,329 (23,105) ‐33.3%
Rents, Leases, and Concessions 676,919 161,382 677,960 175,950 720,780 179,457 186,375 6,918 3.9%
Contributions and Donations 175,513 62,146 150,406 27,177 111,900 30,668 6,455 (24,213) ‐79.0%
Other Miscellaneous 91,070 45,581 166,012 38,576 111,000 36,336 17,963 (18,373) ‐50.6%
Agency Type Deposits (31,840) 117 1,202 96 ‐ ‐ 105 105 0.0%
Transfer ‐In 381,364 ‐ 577,004 ‐ 560,000 ‐ ‐ ‐ ‐100.0%
Total Operating Revenues 93,687,106 10,543,644 97,342,052 10,718,082 97,838,698 10,702,006 10,472,029 (229,978) ‐2.1%
OPERATING EXPENDITURES
Legislative 245,441 40,897 247,225 40,339 267,957 44,184 43,671 513 1.2%
City Attorney 1,661,225 279,208 1,248,380 163,483 1,621,295 246,677 266,526 (19,848) ‐8.0%
City Clerk 604,844 103,952 646,581 95,898 931,014 148,681 92,936 55,745 37.5%
Court Services 1,744,122 261,672 1,819,731 300,245 2,011,393 317,139 328,318 (11,180) ‐3.5%
Executive 966,373 159,664 1,499,747 218,383 1,635,047 250,647 272,736 (22,090) ‐8.8%
Hearing Examiner 166,820 27,557 171,911 29,101 200,440 33,527 29,129 4,397 13.1%
Community and Eco Dvlpmnt Admin ‐ ‐ 265,269 46,111 550,312 95,660 97,354 (1,695) ‐1.8%
Development Services 4,178,096 652,710 3,615,129 630,788 3,247,282 534,808 570,630 (35,822) ‐6.7%
Economic Development 1,875,749 318,796 1,244,175 202,776 1,277,641 213,589 215,064 (1,475) ‐0.7%
Planning ‐ ‐ 1,525,460 210,568 1,238,235 170,921 214,442 (43,521) ‐25.5%
Finance 1,909,652 370,576 1,969,936 393,890 1,964,890 387,178 286,770 100,408 25.9%
Human Resources 981,306 165,031 853,063 131,405 913,669 147,650 141,160 6,489 4.4%
Police 23,894,898 3,625,696 25,833,756 4,391,561 27,610,835 4,451,421 4,238,853 212,568 4.8%
Fire 21,763,640 3,525,827 20,375,286 4,250,970 21,802,109 4,023,609 4,239,777 (216,168) ‐5.4%
Facilities 3,614,850 593,958 ‐ ‐ ‐ ‐ ‐ ‐ 100.0%
Parks 4,892,441 507,909 4,820,336 508,370 5,061,804 529,633 549,946 (20,313) ‐3.8%
Recreation 4,383,163 639,690 7,878,458 1,231,794 4,936,795 753,500 728,855 24,645 3.3%
Human Services 1,162,553 95,531 1,194,142 120,078 1,165,599 106,639 113,264 (6,625) ‐6.2%
Community Resources & Events 367,627 39,758 348,185 41,503 355,694 40,379 42,593 (2,214) ‐5.5%
Library 1,890,886 306,231 2,312,128 305,850 2,544,263 370,519 229,125 141,394 38.2%
Museum 136,327 23,031 140,801 23,758 194,120 32,774 31,141 1,633 5.0%
Public Works Administration 886,867 152,098 463,533 79,651 518,399 88,965 86,114 2,851 3.2%
Street Maintenance 3,212,111 457,490 3,794,716 617,379 3,366,524 516,435 542,804 (26,368) ‐5.1%
Technical Services 515,708 85,791 478,493 72,205 ‐ ‐ ‐ ‐ 100.0%
Transportation 4,841,955 668,213 5,110,639 790,599 5,110,456 749,071 822,448 (73,378) ‐9.8%
Debt Service 4,263,739 ‐ 4,176,822 ‐ 4,494,945 126,390 126,390 ‐ 0.0%
Non‐Departmental 4,622,865 805,791 4,370,376 731,767 4,792,981 819,447 701,408 118,039 14.4%
Other 388,142 2,230 799,051 1,244 25,000 73 ‐ 73 100.0%
Total Operating Expenditures 95,171,399 13,909,310 97,203,328 15,629,716 97,838,698 15,199,515 15,011,456 188,060 1.2%
Total Ending Fund Balance 11,816,561$ 9,935,188$ 11,955,285$ 6,904,927$ 11,955,285$ 7,457,776$ 7,415,858$ (41,918) ‐0.6%
Summary of Sources and Uses Annual Actual YTD Actual Favorable (Unfavorable)
2008 2009 2010 Variance
Annual Actual YTD Actual Annual Budget YTD Budget YTD Actual
Monthly Financial Report February 2010
Page 1 of 37
Monthly Financial Report February 2010
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through February 28, 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 two preceding years. 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 70% of all resources supporting general governmental activities. The following section provides detail
information on property, sales, utility, and other taxes.
Property Tax
February’s collection is $438k, making
the total year‐to‐date collection of
$490k or 2% of the total budget. In
comparison to the previous year, the
City collected $135k or 44% higher.
Compared to the budget, the City is
above projections by $95k or 28%.
This difference in both the prior year
and budget is primarily due to the
homes and commercial properties that
were delinquent in their property tax
payments for 2009 and making their
payments late 2009/early 2010, which
would result in the City recording the
amounts in January and February.
Sales Tax
February 2010 sales tax receipts
totaled $1.7 million. Compared to the
same month last year, it is $135k or
7% less. Compared to the projected
current month’s budget, it is under
projections by $82k or 5%. The year‐
to‐date collection is $3 million or 16%
of the sales tax budget. This is $304k
less than the last year and $246k
below budget. Based on the year‐to‐
date collection, the City is projecting
sales tax revenues to be $17.2 million
by the end of 2010, which is $1.4
million under budget.
2009 2010 2010
Actual BudgetActual $%$%
Jan 1,458,072$ 1,453,037$ 1,289,364$ (168,709)$ ‐12% (163,673)$ ‐11%
Feb 1,863,430 1,810,870 1,728,588 (134,842) ‐7% (82,283) ‐5%
Mar 1,461,007 1,324,501 ‐
Apr 1,398,021 1,367,927 ‐
May 1,490,778 1,601,481 ‐
Jun 1,361,808 1,465,350 ‐
Jul 1,443,891 1,557,501 ‐
Aug 1,551,415 1,662,993 ‐
Sep 1,454,550 1,559,837 ‐
Oct 1,560,217 1,640,973 ‐
Nov 1,440,143 1,638,470 ‐
Dec 1,512,506 1,526,059 ‐
YTD Total 3,321,502$ 3,263,908$ 3,017,952$ (303,551)$ ‐9% (245,956)$ ‐8%
Annual Total 17,995,836$ 18,609,000$
2010 vs. Budget2010 vs. 2009
Month
Year to Date through February
Local Retail Sales Tax Revenues
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 9,419$ 29,859$ 51,304$ 41,885$ 445% 21,445$ 72%
Feb 303,513 343,350 438,210 134,696 44% 94,860 28%
Mar 647,845 683,920
Apr 8,063,214 7,376,995
May 6,711,943 7,741,430
Jun 113,279 121,150
Jul 104,757 134,776
Aug 66,589 85,226
Sep 250,296 150,707
Oct 5,770,027 7,038,559
Nov 8,275,695 7,410,047
Dec 343,945 248,626
YTD Total 312,932$ 373,209$ 489,513$ 176,581$ 56% 116,304$ 31%
Annual Total 30,660,522$ 31,364,643$
Property Tax Revenues
Year to Da te through February
2010 vs. 2009 2010 vs. Budget
Month
Page 2 of 37
Monthly Financial Report February 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 896,146$ 657,215$ 566,112$ 319,258$ (337,957)$ ‐51% $ (246,854)‐44%
Auto Sales 640,726 471,617 553,032 495,355 23,738 5% (57,677)‐10%
General Retail 1,160,919 1,135,757 1,174,997 1,145,209 9,451 1% (29,788)‐3%
Manufacturing 160,171 194,718 176,155 165,250 (29,467) ‐15% (10,905)‐6%
Wholesale 210,600 169,486 182,673 170,441 955 1% (12,232)‐7%
Service 710,762 639,629 679,288 640,763 1,135 0% (38,525)‐6%
Other 71,457 53,074 60,588 81,675 28,601 54% 21,087 35%
Total 3,850,781$ 3,321,497$ 3,263,908$ 3,017,952$ (303,545) ‐9%(245,956)$ ‐8%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility tax
February utility taxes revenue totals $1.4
million, which is $131k lower than same
month last year and ahead of budget by
$22k. The year‐to‐date collection of $2.6
million is above the budget by $49k or 2%
but is $262k or 9% below 2009. The City is
projecting utility tax revenues to meet the
2010 budget by the end of the year.
The table below breaks out Utility Tax by source, the lower amount generated from the transfer station is due to reduced
business activity:
Utility Tax by Type 2008 2009 2010 Bgt YTD Act Chg 10/09 10Act
vs Bgt
Electrical 786,179 1,029,605 979,891 960,877 ‐7%‐2%
Natural Gas 454,499 652,863 520,441 475,832 ‐27%‐9%
Cell 267,666 318,635 295,043 323,057 1% 9%
Phone 172,026 172,701 159,879 181,636 5% 14%
Cable 81,424 207,139 154,351 218,605 6% 42%
Transfer Station 40,072 46,908 30,086 27,925 ‐40%‐7%
City Utilities 359,268 471,659 436,820 449,931 ‐5% 3%
YTD Total 2,161,132 2,899,511 2,576,512 2,637,863 ‐9% 2%
Annual Total 13,240,334 14,581,971 14,228,000
YTD as % of 16% 20% 18%
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 1,413,641$ 1,254,767$ 1,282,930$ (130,711)$ ‐9% 28,163$ 2%
Feb 1,485,870 1,333,164 1,354,933 (130,936) ‐9% 21,770 2%
Mar 1,251,275 1,251,210
Apr 1,204,619 1,138,098
May 1,322,947 1,191,880
Jun 1,070,303 1,096,267
Jul 1,010,609 1,138,667
Aug 1,201,122 1,200,416
Sep 1,068,035 1,023,278
Oct 1,079,380 1,101,532
Nov 1,090,897 1,143,504
Dec 1,383,272 1,355,217
YTD Total 2,899,511$ 2,587,931$ 2,637,863$ (261,647)$ ‐9% 49,932$ 2%
Annual Total 14,581,971$ 14,228,000$
2010 vs. Budget2010 vs . 2009
Year to Date through February
Utility Tax Revenues
Month
Page 3 of 37
Monthly Financial Report February 2010
Other Taxes
The City collected $107k in Real Estate
Excise Tax revenues (REET) in February.
This is $3k below current month’s budget
and $38k ahead the same month last
year. Year‐to‐date collection of $179k is
$135k or 43% behind the budget and is
also $122k or 41% below 2009. A
struggling real estate market is a major
factor in the decline of REET.
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.
February Gambling Tax collections total
$137k. Year‐to‐date total of $273k is
$125k or 31% below the year before; and
$98k or 27% below budget. The amount
budgeted for January was lower partially
due to the prior year’s collection of $8k
(since the budget is based on the
previous two years’ history) and the
additional collection from the monthly
reporting of larger taxpayers.
Franchise Fees are due quarterly and the
year‐to‐date revenue collections are
$320. This is $65k or 25% above the
projected year‐to‐date budget and $60k
or 23% higher than 2009.
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 231,334$ 203,811$ 71,303$ (160,031)$ ‐69% (132,508)$ ‐65%
Feb 69,290 110,531 107,242 37,952 55% (3,289) ‐3%
Mar 183,177 173,727
Apr 141,038 313,557
May 308,077 237,133
Jun 211,295 200,979
Jul 201,960 205,047
Aug 310,599 266,493
Sep 208,046 177,788
Oct 209,975 183,300
Nov 222,052 249,543
Dec 121,614 78,092
YTD Total 300,624$ 314,352$ 178,545$ (122,079)$ ‐41% (135,797)$ ‐43%
Annual Total 2,418,456$ 2,400,000$
Real Estate Excise Tax Revenues
Year to Date through February
Month
2010 vs. Budget2010 vs. 2009
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 7,691$ 9,268$ 135,608$ 127,917$ 1663% 126,340$ 1363%
Feb 391,054 362,865 137,736 (253,317) ‐65% (225,128) ‐62%
Mar 171,097 124,815 ‐
Apr 177,856 96,474 ‐
May 178,840 329,976 ‐
Jun 186,920 88,262 ‐
Jul 182,851 90,903 ‐
Aug 210,237 358,304 ‐
Sep 173,745 83,651 ‐
Oct 176,490 75,950 ‐
Nov 146,960 309,692 ‐
Dec 137,979 69,840 ‐
YTD Total 398,744$ 372,133$ 273,344$ (125,400)$ ‐31% (98,789)$ ‐27%
Annual Total 2,141,720$ 2,000,000$
Gambling Tax Revenue
Month
Year to Date through February
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 ‐
May 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 259,992$ 255,639$ 320,478$ 60,487$ 23% 64,840$ 25%
Annual Total 1,039,031$ 1,040,000$
Franchise Fees Revenue
Year to Date through February
Month
2010 vs. 2009 2010 vs. Budget
Page 4 of 37
Monthly Financial Report February 2010
Admission Tax returns are due quarterly
in January, April, July, and October each
year. January 2010 collections represent
activities conducted during the 4th
quarter of 2009.
The report shows an increase of $18k
from the year before, primarily due to the
Landing 14 Regal Cinemas that opened in
mid‐October 2008. The total 2010
revenue is $16k 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 88% of the revenue in this category. As of the end of
February, we have collected 21% of the projected revenue from licenses and permits. The percentage of year‐to‐date
actual to year‐to‐date budget is under by 2%. Licenses and Permits totaled $496k by the end of February. The following
sections provide detail information for
Building Permits and Business Licenses
revenues.
Building Permits and Fees revenues
totaled $47k in February. The revenue
swing between the high in January and
the low in February is primarily
attributable to the rush of getting permit
completed prior to the new school impact
fees took effect. The year‐to‐date
development fees revenue is $332k,
which is $18k less than the budget but is
$101k more than 2009.
Business Licenses totaled $111k since the start of
the year, which is 1% under last year and 27%
above 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 over the budget
by $24k and $621 below last year.
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 106,633$ 165,811$ 285,826$ 179,192$ 168% 120,015$ 72%
Feb 124,555 184,933 46,586 (77,969) ‐63% (138,347) ‐75%
Mar 179,330 167,034 ‐
Apr 114,694 176,027 ‐
May 125,344 128,531 ‐
Jun 131,705 114,774 ‐
Jul 106,810 110,852 ‐
Aug 119,439 96,612 ‐
Sep 101,087 103,413 ‐
Oct 131,899 136,954 ‐
Nov 82,516 107,797 ‐
Dec 169,581 112,320 ‐
YTD Total 231,189$ 350,744$ 332,412$ 101,223$ 44% (18,332)$ ‐5%
Annual Total 1,493,593$ 1,605,059$
Building Permits and Fees
Year to Date through February
2010 vs. Budget2010 vs. 2009
Month
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 81,835$ 59,237$ 77,955$ (3,880)$ ‐5% 18,718$ 32%
Feb 30,180 28,470 33,440 3,260 11% 4,970 17%
Mar 6,337 37,791 ‐
Apr 73,055 53,038 ‐
May 14,185 20,801 ‐
Jun 9,352 33,258 ‐
Jul 80,579 57,140 ‐
Aug 20,280 21,268 ‐
Sep 1,746 36,504 ‐
Oct 84,002 88,095 ‐
Nov 18,937 19,872 ‐
Dec 3,922 7,592 ‐
YTD Total 112,016$ 87,707$ 111,395$ (621)$ ‐1% 23,688$ 27%
Annual Total 424,413$ 463,067$
Business Licenses
Month
Year to Date through February
2010 vs. Budget2010 vs. 2009
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 ‐
Jul 70,690 69,911 ‐
Oct 70,729 67,414 ‐
Nov 520 295 ‐
YTD Total 57,167$ 58,965$ 75,236$ 18,069$ 32% 16,271$ 28%
Annual Total 260,269$ 260,000$
Year to Date through February
Month
2010 vs. 2009 2010 vs. Budget
Admission Tax Revenue
Page 5 of 37
Monthly Financial Report February 2010
Intergovernmental
These revenue sources include
federal (direct and indirect)
grants, state grants, state shared
revenues, local grants,
entitlements, impact payments,
in‐lieu taxes, and service
revenues. State shared revenues
and Fire Districts’ 25 and 40
contracts compose 54% of the
total revenues in this category.
The year‐to‐date total
Intergovernmental revenue is $1
million or 9% of the budget.
State Shared Revenue collections
totaled $530k since the start of 2010.
Compared to the projected budget,
State Shared Revenues are over by
$40k or 8%. Compared to the prior
year, the City is collecting $253 less or
down by less than 1%. The actual
collection that lags budget is primarily
due to the reduced criminal justice
sales tax (King County countywide
sales tax decrease).
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 74% of the total revenue in this category. The year‐to‐date total charges for services are $869k or 14% of the
budget. This is 10% 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 $139k since
the start of the year. Compared to the budget,
the City is collecting $41k or 42% more than
anticipated revenue. Compared to the prior year,
the City is collecting $58k or 70% more.
Intergovernmental 2008 2009 2010 Bgt YTD Act Chg 10/09 10Act
vs Bgt
Fire District #25 ‐ ‐ ‐ ‐ N/A N/A
Fire District #40 ‐ ‐ 19,525 19,525 100% 0%
State Shared Revenue 436,024 530,681 530,428 530,428 0% 0%
Federal Grants 317,061 159,687 219,341 219,341 37% 0%
State Grants ‐ 71,777 86,276 86,276 20% 0%
Other Grants 52,682 35,714 51,218 51,218 43% 0%
ARRA Grants ‐ ‐ 116,903 116,903 100% 0%
Total Rev YTD 805,768 797,859 1,023,691 1,023,691 28% 0%
Total Rev Annual 10,503,905 11,340,480 11,192,951
YTD %8%7%9%9%
Note: Includes CJ Sa les Tax.
2009 2010 2010
Actual Budget Actual $ % $ %
Crim Just Sales Tax 311,656$ 300,319$ 295,109$ (16,547)$ ‐5% (5,211)$ ‐2%
Judicial Contribution 12,143 3,468 11,549 (594)$ ‐5% 8,081 233%
Crim Just ‐ Pop 4,291 ‐ 4,619 328 8% 4,619 100%
Crim Just ‐ Spec Prog 16,479 14,719 17,557 1,078 7% 2,837 19%
State DUI 3,668 2,337 3,942 274 7% 1,606 69%
Liquor Profits ‐ ‐ ‐ ‐ N/A ‐ N/A
Liquor Excise Tax 97,810 90,958 103,016 5,205 5% 12,058 13%
Fuel Tax 84,634 78,489 94,636 10,003 12% 16,148 21%
YTD Total 530,681$ 490,290$ 530,428$ (253)$ 0% 40,138$ 8%
Annual Total 3,986,791$ 3,988,931$
State Shared Revenues
2010 vs. 2009
Revenue
Year to Date through February
2010 vs. Budget
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 35,851$ 46,473$ 98,294$ 62,443$ 174% 51,821$ 112%
Feb 45,883 51,359 41,012 (4,871) ‐11% (10,347) ‐20%
Mar 86,425 104,237 ‐
Apr 27,659 45,577 ‐
May 58,715 57,465 ‐
Jun 43,085 47,549 ‐
Jul 61,541 58,692 ‐
Aug 43,348 48,227 ‐
Sep 36,509 45,087 ‐
Oct 67,095 64,910 ‐
Nov 59,883 53,992 ‐
Dec 109,397 73,139 ‐
YTD Total 81,734$ 97,832$ 139,306$ 57,573$ 70% 41,474$ 42%
Annual Total 675,391$ 696,708$
2010 vs. Budget
Year to Date through February
Plan Review / Inspection
Month
2010 vs. 2009
Page 6 of 37
Monthly Financial Report February 2010
Recreation revenues totaled $128k since the start
of the year. Compared to the projected monthly
budget, the City collected $9k or 12% less.
Compared to the same month the prior year, the
City collected $8k or 11% 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 $516k. Compared to the
projected budget, the revenues are above by
$63k or up by 14%. Compared to the prior
year, the revenues are over by $20k or up by
4%.
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 $467k. This is
$99k lower than a year ago and $9k over
budget. The increased revenue is almost
entirely due to the Photo Enforcement program
implemented in June 2008. The higher
revenues also require additional expenses
associated to the program as discussed in the
section below.
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 65,409$ 62,894$ 62,673$ (2,736)$ ‐4% (221)$ 0%
Feb 72,988 73,627 64,915 (8,072) ‐11% (8,712) ‐12%
Mar 81,034 76,730 ‐
Apr 141,783 152,787 ‐
May 145,050 148,257 ‐
Jun 154,237 150,313 ‐
Jul 429,059 390,363 ‐
Aug 203,222 209,608 ‐
Sep 123,439 105,960 ‐
Oct 79,452 72,263 ‐
Nov 61,971 55,423 ‐
Dec 73,842 74,015 ‐
YTD Total 138,397$ 136,521$ 127,588$ (10,808)$ ‐8% (8,932)$ ‐7%
Annual Total 1,631,486$ 1,572,240$
Recreation
2010 vs. Budget
Year to Date through February
2010 vs. 2009
Month
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 280,849$ 221,578$ 239,080$ (41,769)$ ‐15% 17,502$ 8%
Feb 285,126 237,113 228,332 (56,794) ‐20% (8,781) ‐4%
Mar 370,244 278,241
Apr 331,546 294,238
May 310,888 200,746
Jun 330,829 252,055
Jul 321,486 260,370
Aug 256,668 239,868
Sep 269,199 321,516
Oct 318,272 367,950
Nov 368,928 414,303
Dec 372,972 489,213
YTD Total 565,975$ 458,703$ 467,413$ (98,563)$ ‐17% 8,722$ 2%
Annual Total 3,817,008$ 3,577,193$
Month
2010 vs. Budget2010 vs . 2009
Year to Date through February
Fines and Penalties by Month
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 253,147$ 233,226$ 242,658$ (10,489)$ ‐4% 9,432$ 4%
Feb 243,496 220,573 273,674 30,178 12% 53,101 24%
Mar 286,921 257,268 ‐
Apr 280,094 254,026 ‐
May 282,056 249,388 ‐
Jun 270,778 283,900 ‐
Jul 263,897 251,656 ‐
Aug 258,386 247,246 ‐
Sep 265,902 227,116 ‐
Oct 266,313 278,719 ‐
Nov 281,154 295,494 ‐
Dec 273,599 282,315 ‐
YTD Total 496,643$ 453,799$ 516,332$ 19,689$ 4% 62,533$ 14%
Annual Total 3,225,745$ 3,080,927$
2010 vs. 2009 2010 vs. Budget
Month
Interfund Services
Year to Date through February
Page 7 of 37
Monthly Financial Report February 2010
Year to Date through February
2009 2010 2010
Actual Budget Actual $ % $ %
Civil Penalties 1,886$ 2,166$ 994$ (891)$ ‐47% (1,172)$ ‐54%
Civil Infraction Penalties 108,233 108,833 55,603 (52,629) ‐49% (53,230) ‐49%
Civil Parking Infraction Penalties 22,816 22,668 14,299 (8,517) ‐37% (8,369) ‐37%
Photo Enforcement Program 358,029 254,022 322,846 (35,183) ‐10% 68,824 27%
Crim Traffic Misdemeanor Fines 16,916 14,989 8,482 (8,435) ‐50% (6,507) ‐43%
Criminal Non‐Traffic Fines 9,119 7,462 1,752 (7,367) ‐81% (5,710) ‐77%
Criminal Costs 39,843 29,234 53,821 13,978 35% 24,586 84%
Non‐Court Fines, Forfeitures and Penalties 9,134 8,214 9,616 482 5% 1,402 17%
YTD Total 565,975$ 447,588$ 467,413$ (98,563)$ ‐17% 19,824$ 4%
Annual Total 3,817,008$ 3,577,193$
2010 vs. Budget
Fines and Penalties by Type
Revenue
2010 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 revenue. The year‐
to‐date collections from this program equates to $323k.
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. February’s expenses include only the staff
time. The payment to ATS was delayed and will be
recorded in March.
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 91% of
the total revenue in this category. The year‐to‐
date total miscellaneous is $257k. Compared to
the projected year‐to‐date budget, the revenues
are under by $42k or down by 14%.
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 30,160 105,405
Mar 245,529 ‐ 69,697 ‐ ‐
Apr 209,106 ‐ 70,260 ‐ ‐
May 192,106 ‐ 70,181 ‐ ‐
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 340,169$ 322,846$ 140,016$ 102,130$ 220,716$
Annual Total 2,250,000$ 841,964$
1Actuals of Revenues and Expenses
Revenues Expenses
Red‐Light Photo Enforcement Program
Year to Date through February
Month
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 143,245$ 161,103$ 170,998$ 27,753$ 19% 9,894$ 6%
Feb 192,680 138,169 86,124 (106,555) ‐55% (52,045) ‐38%
Mar 59,923 62,728
Apr 100,349 93,224
May 156,161 166,995
Jun 100,207 95,149
Jul 819,671 477,481
Aug 80,681 73,379
Sep (468,642) (173,144)
Oct 76,125 66,823
Nov 73,002 90,983
Dec 196,289 125,089
YTD Total 335,925$ 299,273$ 257,122$ (78,803)$ ‐23% (42,151)$ ‐14%
Annual Total 1,529,692$ 1,377,980$
Miscellaneous Revenues by Month
Ye ar to Date through February
Month
2010 vs. Budget2010 vs. 2009
Page 8 of 37
Monthly Financial Report February 2010
2009 2010 2010
Actual Budget Actual $ % $ %
Interests and Other Earnings 94,222$ 60,174$ 46,329$ (47,893)$ ‐51% (13,845)$ ‐23%
Rents, Leases, and Concessions 175,950 179,457 186,375 10,425 6% 6,918 4%
Contributions/Donations from Private Sources 27,177 30,668 6,455 (20,722) ‐76% (24,213) ‐79%
Other 38,576 28,971 17,963 (20,612) ‐53% (11,008) ‐38%
YTD Total 335,925$ 299,270$ 257,122$ (78,803)$ ‐23% (42,148)$ ‐14%
Annual Total 1,529,692$ 1,377,980$
2010 vs. 2009 2010 vs. Budget
Miscellaneous Revenues by Type
Year to Date through February
Revenue
EXPENSES
The City has completed the year and our operating costs are running below the trends from prior years. Overall the City has
expended 15% of its budgeted general governmental expenditures. The table on page 1 gives the expenditure budgets for
each department. Some of the budgeted expenditures will be to be carried forward from 2009 to complete projects we
have started and not yet complete as well as budgeted expenditures related to grants.
Page 9 of 37
Monthly Financial Report February 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 ‐ ‐ ‐ ‐ 9,675 9,300 ‐
Grants 61,220 ‐ ‐ ‐ ‐ 176,162 ‐
Charges for services 2,149 137,739 2,431,950 1,438,779 2,733,893 836,049 ‐
Interdepartmental services ‐ ‐ 128 48,788 16,717 75,869 ‐
Rents, leases, and misc fees 201,019 34,565 12,000 10,659 ‐ ‐ ‐
Interest and other misc 2,509 2,468 3,926 64,729 30,582 17,137 31
TOTAL REVENUES 266,897 174,772 2,448,004 1,562,955 2,790,867 1,114,517 31
EXPENSES:
Utility billing ‐ ‐ 20,748 15,165 15,166 24,748 ‐
Utility systems ‐ ‐ 1,657,610 419,752 367,359 344,195 ‐
Utility maintenance ‐ ‐ 25,674 782,636 2,059,286 264,259 ‐
Transportation 156,869 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 206,618 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 156,869 206,618 1,704,032 1,217,553 2,441,811 633,202 ‐
AMOUNT AVAILABLE FOR DEBT SERVICE 110,028 (31,846) 743,972 345,402 349,056 481,315 31
DEBT SERVICE:
Principal ‐ 3,774 ‐ ‐ ‐ ‐ ‐
Interest and other debt service costs ‐ 270 ‐ 875 350 525 ‐
TOTAL DEBT SERVICE ‐ 4,044 ‐ 875 350 525 ‐
CAPITAL PROJECTS 60,666 114,722 ‐ 86,965 132,975 221,941 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 49,362 (150,612) 743,972 257,562 215,731 258,849 31
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, February 28, 2010 1,098,445 935,189 1,070,006 7,414,670 2,991,269 4,241,691 15,636
Page 10 of 37
Monthly Financial Report February 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 ‐ ‐ ‐ ‐ ‐ ‐ ‐
Charges for services
Equipment rental m&o 351,998 327,091 ‐ ‐ ‐ ‐ ‐
Telecommunications ‐ 47,615 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 17,884 ‐ 56,238 ‐ ‐ ‐
Communications ‐ ‐ ‐ 90,002 ‐ ‐ ‐
Facilities ‐ ‐ 696,057 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 18,718 ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ 41,782 ‐ ‐ ‐ ‐ ‐
Interest and other misc 9,561 4,113 184 226 11,919 11,481 6,423
Internal service fund misc:
Vehicle/equipment capital recovery 239,799 166,100 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 368,138 ‐ ‐
Worker's compensation / unemployment ‐ ‐ ‐ ‐ 216,193 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 1,852,256 293,363
Other misc ‐ ‐ ‐ ‐ ‐ 129,585 ‐
Disposal of capital assets ‐ ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 28,261 17,451 5,909
TOTAL REVENUES 601,358 623,303 696,241 146,466 624,511 2,010,773 305,695
EXPENSES:
Communications 54,547
Equipment rental 280,089
Facilities 623,943
Healthcare 1,434,686
Information technology 462,509
Print and mail ‐ 82,453
Retiree healthcare 159,761
Risk management 911,043
TOTAL EXPENSES 280,089 462,509 623,943 137,000 911,043 1,434,686 159,761
AMOUNT AVAILABLE FOR DEBT SERVICE 321,269 160,794 72,298 9,466 (286,532) 576,087 145,934
DEBT SERVICE:
Principal ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest and other debt service costs ‐ ‐ ‐ ‐ ‐ ‐ ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ ‐ ‐ ‐ ‐
CAPITAL PROJECTS 340,493 71,919 25,000 29,408 ‐ ‐ ‐
TRANSFERS IN ‐ ‐ ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE (19,224) 88,875 47,298 (19,942) (286,532) 576,087 145,934
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, February 28, 2010 4,574,175 1,736,806 138,473 91,876 5,752,977 5,368,539 2,966,407
Page 11 of 37
Monthly Financial Report February 2010
THE SCORE
The South Correctional Entity (SCORE) is a public development authority (PDA) that 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 cost 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 ‐
Des Moines ‐
Federal Way ‐
Renton ‐
Seatac ‐
Tukwila ‐
Interest and other misc 58,206
Bond proceeds ‐
Tax Credit (BABs)‐
TOTAL REVENUES 58,206
EXPENSES:
Salaries and wages ‐
Benefits ‐
Supplies 381
Professional services 284,425
Intergovernmental 22,215
Construction 5,513,251
TOTAL EXPENSES 5,820,272
AMOUNT AVAILABLE FOR DEBT SERVICE (5,762,067)
DEBT SERVICE:
Principal ‐
Interest and other debt service costs 816,324
TOTAL DEBT SERVICE 816,324
CHANGE IN FUND BALANCE (6,578,391)
BEGINNING FUND BALANCE, January 1, 2010 80,644,637
ENDING FUND BALANCE, February 28, 2010 74,066,246
Page 12 of 37
Monthly Financial Report February 2010
FUND BALANCE
Page 14 shows the ending fund balance as of February 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 balances (or beginning balance) includes funds identified as being reserved for specific purposes or required
to meet current year appropriations. These balances also provide financial stability to the City’s operation during uncertain
times and provide a layer of security to bondholders.
At the end of February, the City has $7.4 million reported in combined general governmental fund balance of current year
operating budget, which is approximately 8% of budgeted operating expenditures. This is a decrease of $4.5 million from
the beginning balance of January 1, 2010. February’s ending fund balance is under the anticipated General Governmental
Fund Balance of $7.5 million by $42k. This is consistent with prior year trends since the City will not received the first
portion of property tax revenues for 2010 until April and 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 37
Monthly Financial Report February 2010
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through February 28, 2010
Funds
Balance
01/01/2010
Budgeted
Revenue
Revenue
02/28/10
Total Funds
Available
Budgeted
Expenditure
Expenditure
02/28/10 Ending Balance
GENERAL GOVERNMENT FUNDS:11,955,285 97,838,698 10,472,029 22,427,314 97,838,698 15,011,456 7,415,858
000 General 8,535,013 75,735,434 8,097,452 16,632,465 71,418,283 11,897,388 4,735,077
001 Community Services 958,009 8,011,778 1,271,107 2,229,116 10,354,293 1,321,394 907,722
003 Street 1,391,648 6,688,942 869,539 2,261,187 8,476,980 1,365,252 895,935
004 Community Dev Block Grant (6,528) 294,148 62,433 55,905 296,503 40,304 15,601
005 Museum 64,705 192,621 93 64,798 194,120 31,141 33,657
006 Library 706,011 1,395,801 13,611 719,622 2,544,263 229,125 490,497
009 Farmers Market 60,571 44,280 5,004 65,575 34,311 462 65,113
010 Fire Memorial 936 ‐ (700) 236 ‐ ‐ 236
011 Fire Health & Wellness 4,303 25,000 3,961 8,264 25,000 ‐ 8,264
031 Park Memorial 175,066 ‐ 381 175,447 ‐ ‐ 175,447
201 Ltd GO Bonds Gen Govt Debt 1,448 2,982,658 63,329 64,777 1,984,625 2,400 62,377
215 Gen Govt Misc Debt Service 64,103 2,468,036 85,819 149,922 2,510,320 123,990 25,932
SPECIAL REVENUE FUNDS:
102 Arterial Street 200,686 620,000 201,759 402,445 620,000 ‐ 402,445
108 Leased City Properties 837,613 941,533 38,435 876,048 581,940 71,097 804,951
110 Hotel Motel 247,828 245,000 39,315 287,143 245,000 62,781 224,362
118 Reserve for Paths & Trails 3,264 ‐ 10 3,274 ‐ ‐ 3,274
125 1% For Art 143,796 15,000 318 144,114 50,000 86 144,028
127 Cable Communication 89,391 85,000 13,723 103,114 85,674 2,100 101,014
135 Springbrook Wetlands Bank 459,528 ‐ 1,007 460,535 ‐ ‐ 460,535
DEBT SERVICE FUNDS:
219 1989 Unlimited GO Bonds 79,340 ‐ ‐ 79,340 1,388 ‐ 79,340
CAPITAL PROJECT FUNDS (CIP):
303 Community Dev Mitigation 1,066,593 60,000 6,238 1,072,831 ‐ ‐ 1,072,831
304 Fire Mitigation 2,363,522 100,000 9,179 2,372,701 560,000 ‐ 2,372,701
305 Transportation Mitigation 2,167,133 200,000 17,322 2,184,455 700,000 ‐ 2,184,455
316 Municipal Facilities CIP 6,933,186 730,000 140,878 7,074,064 1,653,454 162,950 6,911,114
317 Transportation CIP 2,892,341 15,692,002 1,620,369 4,512,710 16,126,973 1,638,736 2,873,974
318 So Lake WA Infrastructure Proj 114,039 ‐ 251 114,290 ‐ ‐ 114,290
326 Housing Opportunity 201,653 ‐ 444 202,097 ‐ ‐ 202,097
ENTERPRISE FUNDS:
402 Airport 415,929 1,917,163 204,281 620,210 1,001,800 156,869 463,341
403 Solid Waste Utility 326,034 15,000,000 2,448,003 2,774,037 15,000,000 1,704,033 1,070,004
404 Golf Course 798,278 2,483,545 174,258 972,536 2,566,837 215,710 756,826
422 Airport Capital 633,154 1,578,000 62,617 695,771 1,578,000 60,666 635,105
424 Golf Course Capital 287,523 150,000 514 288,037 150,000 109,674 178,363
INTERNAL SERVICE FUNDS:
501 Equipment Repair/Replacement 4,593,399 3,631,241 601,359 5,194,758 2,791,684 620,582 4,574,176
502 Insurance 6,039,509 3,287,584 624,510 6,664,019 4,170,106 911,043 5,752,976
503 Information Services 1,647,931 4,105,387 623,303 2,271,234 3,715,819 534,427 1,736,807
504 Facilities 91,175 4,555,485 696,241 787,416 4,176,210 648,943 138,473
505 Communications 111,818 1,049,671 146,466 258,284 877,560 166,408 91,876
512 Insurance, Healthcare 4,792,452 12,358,471 2,010,773 6,803,225 12,462,810 1,434,686 5,368,539
522 Insurance, Leoff1 Retirees HC 2,820,473 2,235,684 305,695 3,126,168 2,248,907 159,761 2,966,407
FIDUCIARY FUNDS:
611 Firemen's Pension 4,332,817 300,000 3,092 4,335,909 550,475 72,471 4,263,438
Funds
Balance
01/01/2010
Budgeted
Revenue
Revenue
02/28/10
Total Funds
Available
Budgeted
Expenditure
Expenditure
02/28/10 Ending Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 13,931,093 42,352,430 5,468,370 19,399,463 42,554,258 4,736,197 14,663,266
405 Water Utility 4,294,833 11,316,610 1,528,841 5,823,674 11,319,531 1,218,428 4,605,246
406 Waste Water Utility 1,887,815 6,070,737 905,137 2,792,952 6,389,869 588,265 2,204,687
407 Surface Water Utility 2,448,845 5,768,148 932,394 3,381,239 5,647,923 633,727 2,747,512
416 Ki ng County Metro 46,504 11,211,935 1,861,690 1,908,194 11,211,935 1,853,896 54,298
425 Water Utility Construction 2,862,275 2,960,000 34,114 2,896,389 2,960,000 86,965 2,809,424
426 Waste Water Construction 841,219 2,775,000 24,040 865,259 2,775,000 132,975 732,284
427 Surface Water Construction 1,533,997 2,250,000 182,123 1,716,120 2,250,000 221,941 1,494,179
461 Waterworks Bond Reserve ‐ ‐ ‐ ‐ ‐ ‐ ‐
471 Waterworks Rate Stabilization 15,605 ‐ 31 15,636 ‐ ‐ 15,636
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
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
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
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 37
City of Renton
Monthly Revenue Analysis ‐ 2010 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 5,004,449 4,881,556 ‐2.46%
Feb 10,889,447 10,472,029 ‐3.83%
Mar 16,056,309
Apr 27,392,879
May 40,802,650
Jun 46,001,799
Jul 52,423,931
Aug 59,142,514
Sep 64,734,974
Oct 75,764,331
Nov 88,960,814
Dec 97,838,698
Percent of budget 10.70%
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 29,796 218,705 634.01%
Feb 373,239 489,513 31.15%
Mar 1,056,988
Apr 8,434,266
May 16,175,687
Jun 16,296,755
Jul 16,431,623
Aug 16,516,621
Sep 16,667,485
Oct 23,706,024
Nov 31,115,921
Dec 31,364,643
Percent of budget 1.56%
$‐
$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 37
City of Renton
Monthly Revenue Analysis ‐ 2010 Budget Year
Sales Tax Budget
YTD
Actual
Annual %
over (under)
Jan 1,700,680 1,442,659 ‐15.17%
Feb 3,852,496 3,376,692 ‐12.35%
Mar 5,442,634
Apr 7,028,600
May 8,624,161
Jun 10,204,496
Jul 11,872,013
Aug 13,636,932
Sep 15,313,835
Oct 17,071,037
Nov 18,638,649
Dec 20,857,000
Percent of budget 16.19%
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,254,767 1,282,930 2.24%
Feb 2,587,931 2,637,863 1.93%
Mar 3,839,141
Apr 4,977,239
May 6,169,119
Jun 7,265,386
Jul 8,404,053
Aug 9,604,469
Sep 10,627,747
Oct 11,729,279
Nov 12,872,783
Dec 14,228,000
Percent of budget 18.54%
Note: Includes Natural Gas Use Tax.
$‐
$3
$6
$9
$12
$15
$18
$21
Millions Sales Tax
Budget
Actual
Last Year
$0
$2
$4
$6
$8
$10
$12
$14
$16
Millions Utility Tax
Budget
Actual
Last Year
Page 17 of 37
City of Renton
Monthly Revenue Analysis ‐ 2010 Budget Year
Licenses/
Permits Budget
YTD
Actual
Annual %
over (under)
Jan 254,388 394,387 55.03%
Feb 504,909 496,041 ‐1.76%
Mar 746,077
Apr 1,023,875
May 1,215,548
Jun 1,404,525
Jul 1,606,007
Aug 1,628,749
Sep 1,798,373
Oct 2,065,432
Nov 2,222,766
Dec 2,386,376
Percent of budget 20.79%
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 419,176 371,847 ‐11.29%
Feb 821,674 1,023,691 24.59%
Mar 1,183,319
Apr 1,599,585
May 3,428,289
Jun 4,216,608
Jul 4,619,666
Aug 5,371,049
Sep 6,707,488
Oct 7,273,291
Nov 9,074,685
Dec 11,192,951
Percent of budget 9.15%
Note: Includes CJ Sales Tax.
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
$10
$11
$12
Millions Intergovernmental
Budget
Actual
Last Year
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
$2.40
Millions Licenses & Permits
Budget
Actual
Last Year
Page 18 of 37
City of Renton
Monthly Revenue Analysis ‐ 2010 Budget Year
Charges for
Svcs Budget
YTD
Actual
Annual %
over (under)
Jan 391,454 445,172 13.72%
Feb 793,284 869,415 9.60%
Mar 1,292,872
Apr 1,805,775
May 2,316,759
Jun 2,849,273
Jul 3,617,668
Aug 4,169,074
Sep 4,591,056
Oct 5,060,357
Nov 5,508,367
Dec 5,997,460
Percent of budget 14.50%
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 221,571 239,080 7.90%
Feb 458,703 467,413 1.90%
Mar 736,938
Apr 1,031,162
May 1,231,914
Jun 1,483,963
Jul 1,744,347
Aug 1,984,197
Sep 2,305,716
Oct 2,673,666
Nov 3,087,976
Dec 3,577,193
Percent of budget 13.07%
$‐
$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 37
City of Renton
Monthly Revenue Analysis ‐ 2010 Budget Year
Other Taxes Budget
YTD
Actual
Annual %
over (under)
Jan 486,577 315,778 ‐35.10%
Feb 942,612 854,174 ‐9.38%
Mar 1,145,379
Apr 1,569,803
May 2,165,949
Jun 2,678,910
Jul 3,221,531
Aug 4,574,021
Sep 4,778,991
Oct 5,430,741
Nov 5,976,195
Dec 6,297,095
Percent of budget 13.56%
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 161,100 170,998 6.14%
Feb 299,270 257,122 ‐14.08%
Mar 361,995
Apr 455,229
May 622,213
Jun 717,363
Jul 1,194,846
Aug 1,268,224
Sep 1,095,081
Oct 1,161,913
Nov 1,252,887
Dec 1,377,980
Percent of budget 18.66%
$‐
$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 37
City of Renton
Monthly Revenue Analysis ‐ 2010 Budget Year
General Fund Budget
YTD
Actual
Annual %
over (under)
Jan 7,089,594 3,689,136 ‐47.96%
Feb 11,885,919 8,097,452 ‐31.87%
Mar 16,074,088
Apr 24,635,222
May 35,077,623
Jun 39,352,889
Jul 39,951,956
Aug 44,493,810
Sep 50,541,284
Oct 61,026,098
Nov 69,879,570
Dec 75,735,434
Percent of budget 10.69%
Community
Svcs Fund Budget
YTD
Actual
Annual %
over (under)
$‐
$10
$20
$30
$40
$50
$60
$70
$80
Millions General Fund
Budget
Actual
Last Year
$13.50
$15.00
Millions Community Svcs Fund
Budget
g ()
Jan 1,016,294 724,258 ‐28.74%
Feb 1,367,851 1,271,107 ‐7.07%
Mar 1,690,485
Apr 2,547,345
May 3,429,602
Jun 3,710,655
Jul 5,317,097
Aug 5,842,749
Sep 5,886,814
Oct 6,150,321
Nov 7,446,227
Dec 8,011,778
Percent of budget 15.87%
$‐
$10
$20
$30
$40
$50
$60
$70
$80
Millions General Fund
Budget
Actual
Last Year
$‐
$1.50
$3.00
$4.50
$6.00
$7.50
$9.00
$10.50
$12.00
$13.50
$15.00
Millions Community Svcs Fund
Budget
Actual
Last Year
Page 21 of 37
City of Renton
Monthly Revenue Analysis ‐ 2010 Budget Year
Street Fund Budget
YTD
Actual
Annual %
over (under)
Jan 963,676 400,608 ‐58.43%
Feb 1,284,544 869,539 ‐32.31%
Mar 1,590,430
Apr 2,228,555
May 2,886,747
Jun 3,200,324
Jul 4,322,796
Aug 4,685,136
Sep 4,655,905
Oct 4,906,874
Nov 5,852,757
Dec 6,688,942
Percent of budget 13.00%
Library Fund Budget
YTD
Actual
Annual %
over (under)
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
$10
$11
Millions Street Fund
Budget
Actual
Last Year
$3.00
$3.30
Millions Library Fund
Budget
At l
y g ()
Jan 116,317 6,904 ‐94.06%
Feb 232,634 13,611 ‐94.15%
Mar 348,950
Apr 465,267
May 581,584
Jun 697,901
Jul 814,217
Aug 930,534
Sep 1,046,851
Oct 1,163,168
Nov 1,279,484
Dec 1,395,801
Percent of budget 0.98%
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
$10
$11
Millions Street Fund
Budget
Actual
Last Year
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
$2.40
$2.70
$3.00
$3.30
Millions Library Fund
Budget
Actual
Last Year
Page 22 of 37
City of Renton
Monthly Revenue Analysis ‐ 2010 Budget Year
Museum Fund Budget
YTD
Actual
Annual %
over (under)
Jan 16,052 56 ‐99.65%
Feb 32,104 93 ‐99.71%
Mar 48,155
Apr 64,207
May 80,259
Jun 96,311
Jul 112,362
Aug 128,414
Sep 144,466
Oct 160,518
Nov 176,569
Dec 192,621
Percent of budget 0.05%
Note: Prior to 2009, Museum was part of the Library Fund
LTGO Debt
Funds Budget
YTD
Actual
Annual %
over (under)
$4.50
$5.00
Millions LTGO Debt Funds
Budget
$‐
$0.05
$0.10
$0.15
$0.20
$0.25
Millions Museum Fund
Budget
Actual
Last Year
g ()
Jan 505,388 59,552 ‐88.22%
Feb 628,356 149,148 ‐76.26%
Mar 815,424
Apr 1,363,001
May 1,866,427
Jun 2,072,790
Jul 2,649,473
Aug 3,602,146
Sep 3,876,207
Oct 4,091,127
Nov 4,726,079
Dec 5,450,694
Percent of budget 2.74%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
Millions LTGO Debt Funds
Budget
Actual
Last Year
$‐
$0.05
$0.10
$0.15
$0.20
$0.25
Millions Museum Fund
Budget
Actual
Last Year
Page 23 of 37
City of Renton
Monthly Revenue Analysis ‐ 2010 Budget Year
REET Budget
YTD
Actual
Annual %
over (under)
Jan 203,808 71,303 ‐65.01%
Feb 314,352 178,545 ‐43.20%
Mar 488,064
Apr 801,624
May 1,038,768
Jun 1,239,744
Jul 1,444,776
Aug 1,711,272
Sep 1,889,064
Oct 2,072,376
Nov 2,321,904
Dec 2,400,000
Percent of budget 7.44%
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 24 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2010 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,055,149 7,161,528 1.51%
Feb 15,023,132 15,011,456 ‐0.08%
Mar 22,448,111
Apr 30,034,524
May 37,370,469
Jun 45,896,133
Jul 54,113,605
Aug 61,992,556
Sep 69,771,711
Oct 77,459,876
Nov 85,382,853
Dec 97,838,698
Percent of budget expended 15.34%
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
Apr 91,263
May 113,769
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 16.30%
$‐
$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 25 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2010 Budget Year
Court Services Budget
YTD
Actual
Annual %
over (under)
Jan 152,504 168,470 10.47%
Feb 317,136 328,318 3.53%
Mar 482,634
Apr 655,111
May 827,668
Jun 1,002,217
Jul 1,170,590
Aug 1,338,240
Sep 1,505,085
Oct 1,673,117
Nov 1,832,379
Dec 2,011,393
Percent of budget expended 16.32%
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
Apr 521,891
May 654,166
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 16.68%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
$2.00
$2.20
Millions Court Services
Budget
Actual
Last Year
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
Millions Executive
Budget
Actual
Last Year
Page 26 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2010 Budget Year
Finance Budget
YTD
Actual
Annual %
over (under)
Jan 226,033 145,053 ‐35.83%
Feb 392,881 286,770 ‐27.01%
Mar 586,008
Apr 748,871
May 948,999
Jun 1,109,352
Jul 1,284,766
Aug 1,452,433
Sep 1,602,468
Oct 1,683,322
Nov 1,821,484
Dec 1,964,890
Percent of budget expended 14.59%
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
Apr 549,408
May 691,207
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 16.44%
$‐
$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 27 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2010 Budget Year
Human
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 62,623 71,457 14.11%
Feb 147,649 141,160 ‐4.39%
Mar 228,975
Apr 310,346
May 392,750
Jun 470,604
Jul 544,958
Aug 617,312
Sep 693,968
Oct 769,666
Nov 841,727
Dec 913,669
Percent of budget expended 15.45%
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 37,309 42,532 14.00%
Feb 82,363 86,114 4.55%
Mar 127,262
Apr 168,588
May 213,731
Jun 254,321
Jul 297,416
Aug 337,420
Sep 378,618
Oct 419,892
Nov 464,578
Dec 518,399
Percent of budget expended 16.61%
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 28 of 37
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
Apr 1,824,496
May 1,977,632
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 14.63%
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,148,675 2,260,619 5.21%
Feb 4,439,546 4,238,853 ‐4.52%
Mar 6,868,471
Apr 8,916,091
May 10,938,032
Jun 13,468,013
Jul 15,967,622
Aug 18,173,451
Sep 20,403,578
Oct 22,577,932
Nov 24,984,492
Dec 27,610,835
Percent of budget expended 15.35%
$‐
$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 29 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2010 Budget Year
Fire & Emerg
Svc Budget
YTD
Actual
Annual %
over (under)
Jan 1,667,207 1,768,398 6.07%
Feb 4,039,495 4,239,777 4.96%
Mar 5,743,330
Apr 7,478,778
May 9,233,411
Jun 10,950,327
Jul 12,762,955
Aug 14,470,932
Sep 16,303,835
Oct 18,165,082
Nov 19,927,128
Dec 21,802,109
Percent of budget expended 19.45%
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 59,659 48,025 ‐19.50%
Feb 133,656 92,936 ‐30.47%
Mar 201,304
Apr 369,538
May 438,200
Jun 506,146
Jul 574,920
Aug 637,419
Sep 700,467
Oct 772,528
Nov 841,106
Dec 931,014
Percent of budget expended 9.98%
$‐
$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 30 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2010 Budget Year
Human
Services Budget
YTD
Actual
Annual %
over (under)
Jan 27,446 40,228 46.57%
Feb 73,908 72,960 ‐1.28%
Mar 114,486
Apr 248,987
May 317,854
Jun 359,840
Jul 454,615
Aug 521,901
Sep 564,704
Oct 635,570
Nov 713,893
Dec 869,096
Percent of budget expended 8.39%
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 15,540 14,619 ‐5.93%
Feb 32,770 29,129 ‐11.11%
Mar 49,078
Apr 65,520
May 82,389
Jun 99,103
Jul 115,586
Aug 132,410
Sep 149,273
Oct 166,203
Nov 183,623
Dec 200,440
Percent of budget expended 14.53%
$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 31 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2010 Budget Year
CED Budget
YTD
Actual
Annual %
over (under)
Jan 506,665 555,670 9.67%
Feb 1,035,433 1,097,029 5.95%
Mar 1,557,734
Apr 2,077,334
May 2,585,381
Jun 3,116,095
Jul 3,643,231
Aug 4,174,950
Sep 4,677,471
Oct 5,185,894
Nov 5,731,302
Dec 6,279,159
Percent of budget expended 17.47%
Note: For comparative purposes history includes Development Svcs division (previously in Public Works).
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,662,041 5,746,764 1.50%
Feb 11,966,133 11,897,388 ‐0.57%
Mar 17,701,021
Apr 23,540,894
May 29,107,950
Jun 34,864,263
Jul 40,891,252
Aug 46,445,452
Sep 52,410,307
Oct 58,082,347
Nov 64,197,180
Dec 71,418,283
Percent of budget expended 16.66%
$‐
$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 32 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2010 Budget Year
Community
Svcs Fund Budget
YTD
Actual
Annual %
over (under)
Jan 621,982 570,605 ‐8.26%
Feb 1,400,832 1,321,394 ‐5.67%
Mar 2,156,281
Apr 2,938,134
May 3,741,731
Jun 4,572,145
Jul 5,702,834
Aug 6,858,683
Sep 7,709,910
Oct 8,544,362
Nov 9,406,564
Dec 10,354,293
Percent of budget expended 12.76%
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 596,271 641,040 7.51%
Feb 1,266,461 1,365,252 7.80%
Mar 1,943,687
Apr 2,643,546
May 3,357,223
Jun 4,032,499
Jul 4,764,656
Aug 5,522,667
Sep 6,242,278
Oct 6,950,276
Nov 7,651,237
Dec 8,476,980
Percent of budget expended 16.11%
$‐
$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 33 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2010 Budget Year
CDBG Budget
YTD
Actual
Annual %
over (under)
Jan 18,324 13,958 ‐23.83%
Feb 38,050 40,304 5.92%
Mar 56,015
Apr 74,268
May 91,504
Jun 109,680
Jul 128,087
Aug 173,546
Sep 191,770
Oct 213,331
Nov 253,994
Dec 296,503
Percent of budget expended 13.59%
Library Fund Budget
YTD
Actual
Annual %
over (under)$3.00
Millions Library Fund
Budget
At l
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
CDBG
Budget
Actual
Last Year
y g ()
Jan 152,452 173,794 14.00%
Feb 368,766 229,125 ‐37.87%
Mar 558,262
Apr 766,561
May 978,524
Jun 1,208,703
Jul 1,439,442
Aug 1,702,112
Sep 1,902,855
Oct 2,108,177
Nov 2,304,874
Dec 2,544,263
Percent of budget expended 9.01%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
Millions Library Fund
Budget
Actual
Last Year
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
CDBG
Budget
Actual
Last Year
Page 34 of 37
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
Apr 65,543
May 82,433
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 16.04%
Note: Prior to 2009, Museum was part of the Library Fund
LTGO Funds Budget
YTD
Actual
Annual %
over (under)
$4.50
$5.00
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 135 ‐ 0.00%
Feb 15,957 126,390 692.07%
Mar 15,957
Apr 15,957
May 15,957
Jun 831,340
Jul 831,430
Aug 831,430
Sep 2,010,544
Oct 2,215,693
Nov 2,295,344
Dec 4,494,945
Percent of budget expended 2.81%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
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 35 of 37
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2010 Budget Year
Utilities Budget Revenue Expense
Jan 2,457,102 3,901,859 2,612,849
Feb 5,532,784 7,676,067 5,998,348
Mar 8,458,919
Apr 10,568,438
May 14,342,459
Jun 18,820,257
Jul 22,986,726
Aug 27,032,198
Sep 30,031,294
Oct 33,032,203
Nov 36,377,070
Dec 45,317,258
Percent of budget expended 13.24%
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
Apr 329,772
May 438,337
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 15.66%
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 ‐ 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
Apr 618,377
May 813,533
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 8.40%
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