HomeMy WebLinkAbout201008, August.pdfFINANCE AND
INFORMATION TECHNOLOGY
M E M O R A N D U M
DATE: October 11, 2010
TO: Don Persson, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Iwen Wang, FIT Administrator
SUBJECT: August 2010 Financial Status Report
At the end of August, general governmental revenues show $916k or 1.4% under budget. This
includes a $398k favorable property tax collection but otherwise almost all other revenue
categories are under performing. Unfortunately, the favorable property tax collection is a
temporary phenomenon from the surge of home sales triggered by the stimulus package, which
ended in April with closing of sales by June. Without the favorable property tax, revenues are
$1.3 million or 1.9% below budget.
For the year, we are expecting a total sales tax collection of $17.1 million, similar to what we
have collected in 2005. This is underperforming the budget by $1.47 million. Similarly we
expect gambling tax to underperform the budget by $474k; court fines by $107k; real estate
excise tax by $156k, and recreation fees by $161k. This is a combined $2.4 million of lower than
expected revenue in 2010, and it will also require us to lower our projection for 2011 and 2012.
On the expenditures’ side, other than a couple of minor exceptions, all departments are
conserving their spending and are showing favorable variances. Overall general governmental
funds are showing a 2.7% or $1.9 million saving. Part of the savings is due to the timing of
certain lump sum payments which are not due until the last quarter of the year, such as
principal payments on the City’s general obligation debts, banking fees, and voter
registration/election costs. In addition to the timing of disbursements, there is also a risk of
over expenditure in certain areas. One is the street light energy cost. Due to the amount
budgeted for 2010, it is below the actual cost in 2009 and a rate increase took effect earlier this
year, the amount budgeted for the street light is likely to be insufficient to cover the cost.
Another risk factor is the winter weather condition. Therefore, while we do expect some
expenditure savings this year, we project it will be less than the current level.
The attached report provides more detailed discussion of each revenue sources and our
updated projections for the year. Please do not hesitate to contact me at x6858 or Hai Nguyen
at x6952 should you have any questions or any suggestions about the report.
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 15,485,773 30,660,522 16,020,559 31,364,643 16,388,472 16,786,759 398,287 2.4%
Sales Tax 20,825,055 13,328,066 17,995,836 12,028,421 18,609,000 12,264,491 11,430,357 (834,134) ‐6.8%
Sales Tax ‐ Annexation Credit ‐ ‐ 2,132,110 1,419,661 2,248,000 1,496,827 1,346,094 (150,733) ‐10.1%
Criminal Justice Sales Tax 1,755,469 1,128,780 1,650,350 1,096,752 1,743,000 1,158,323 1,072,153 (86,170) ‐7.4%
Natural Gas Use Tax 253,377 214,611 242,891 172,543 ‐ ‐ 170,550 170,550 100.0%
Admission Tax 197,740 149,716 260,269 189,020 260,000 188,824 217,864 29,040 15.4%
Franchise Fees 998,288 660,113 1,039,031 779,233 1,040,000 734,749 887,960 153,210 20.9%
Electricity Tax 4,580,037 3,084,489 4,963,151 3,410,958 5,150,000 3,539,371 3,354,397 (184,974) ‐5.2%
Gas Tax 1,565,810 1,161,260 1,891,255 1,498,063 1,858,000 1,471,722 1,140,236 (331,486) ‐22.5%
Transfer Station 380,961 232,495 283,985 158,142 230,000 128,080 157,215 29,135 22.7%
TV Cable 1,073,168 613,569 1,263,743 830,591 1,250,000 821,559 903,892 82,333 10.0%
Telephone 1,032,048 691,826 1,037,873 688,996 960,000 637,299 704,355 67,056 10.5%
Cellular Phone 1,748,147 1,162,889 2,027,473 1,284,063 1,900,000 1,203,330 1,554,714 351,385 29.2%
City Utilities 2,606,786 1,659,717 2,871,599 1,917,030 2,880,000 1,922,638 1,877,339 (45,299) ‐2.4%
Leasehold Excise Tax 190,644 133,112 146,002 103,819 100,000 71,108 103,100 31,992 45.0%
Gambling Excise Tax 2,157,029 1,633,406 2,141,720 1,506,546 2,000,000 1,406,856 1,073,429 (333,427) ‐23.7%
Real Estate Excise Tax 2,800,103 2,064,232 2,418,456 1,656,770 2,400,000 1,644,120 1,537,086 (107,034) ‐6.5%
Less: Municipal Facilities CIP REET (450,103) ‐ (1,000,000) (797,523) (400,000) (319,009) (258,148) 60,861 ‐19.1%
EMS Levy 890,998 555,476 1,170,657 780,438 897,095 580,473 580,473 ‐ 0.0%
Business License Fees 485,537 295,331 424,413 315,805 463,067 344,568 319,296 (25,271) ‐7.3%
Other Licenses and Permits 257,477 176,469 176,851 104,310 157,250 92,749 159,099 66,349 71.5%
Building Permits 2,034,225 1,421,090 1,683,082 1,141,643 1,766,059 1,197,927 1,142,226 (55,701) ‐4.6%
Intergovernmental (Grants, etc)3,734,887 1,841,990 3,820,932 2,588,513 4,355,523 2,711,369 2,711,369 ‐ 0.0%
Fire District 25 and 40 Contracts 5,013,549 775,262 5,869,198 3,050,973 5,554,723 2,760,463 2,760,463 ‐ 0.0%
Records, Duplicating, and Passport Fees 176,950 130,022 187,721 115,489 217,585 133,861 137,108 3,247 2.4%
Public Safety 524,565 360,446 521,484 363,800 430,000 299,979 303,141 3,162 1.1%
Development Service Fees 903,768 639,178 677,955 405,070 869,683 519,625 616,702 97,077 18.7%
Culture and Recreation 1,678,818 1,369,750 1,631,486 1,292,783 1,572,240 1,245,837 1,118,294 (127,543) ‐10.2%
Interfund/Interdept‐Services 3,072,950 1,944,500 3,225,745 2,138,776 3,335,677 2,211,665 2,170,982 (40,683) ‐1.8%
Fines and Forfeits 1,057,797 709,501 1,349,034 823,305 1,196,500 730,215 769,212 38,997 5.3%
Photo Enforcement 803,111 53,530 2,368,131 1,575,781 2,250,000 1,497,176 1,306,228 (190,948) ‐12.8%
Seizure Funds ‐ Federal/State/Local 250,065 37,486 99,844 88,550 130,693 115,910 191,693 75,783 65.4%
Interests and Other Earnings 735,910 563,174 535,314 377,123 434,300 305,960 233,864 (72,096) ‐23.6%
Rents, Leases, and Concessions 676,919 535,440 677,960 528,534 720,780 561,916 576,796 14,880 2.6%
Contributions and Donations 175,513 131,021 150,406 700,173 111,900 90,947 90,947 ‐ 0.0%
Other Miscellaneous 67,355 60,984 168,567 48,950 262,557 76,243 72,444 (3,799) ‐5.0%
Refunding Debt and Premiums ‐ ‐ ‐ ‐ 6,613,483 6,613,484 6,613,484 ‐ 0.0%
Transfer‐In 381,364 66,541 577,004 ‐ 652,398 652,398 652,398 ‐ 0.0%
Total Operating Revenues 93,687,106 55,071,243 97,342,052 60,403,662 105,584,156 67,501,527 66,585,570 (915,956) ‐1.4%
OPERATING EXPENDITURES
Legislative 245,441 166,289 247,225 165,499 267,957 180,457 173,947 6,509 3.6%
City Attorney 1,661,225 1,104,031 1,248,380 884,515 1,621,295 1,108,061 1,059,996 48,065 4.3%
City Clerk 604,844 424,619 646,581 464,567 931,014 661,522 505,723 155,799 23.6%
Court Services 1,744,122 1,134,225 1,819,731 1,236,898 2,016,361 1,341,537 1,335,996 5,541 0.4%
Executive 966,373 634,802 1,499,747 1,005,120 1,635,047 1,087,275 1,038,272 49,003 4.5%
Hearing Examiner 166,820 110,494 171,911 115,550 200,440 133,758 116,431 17,328 13.0%
Community and Eco Dvlpmnt Admin ‐ ‐ 265,269 180,430 646,149 439,496 389,497 49,998 11.4%
Development Services 4,178,096 2,692,649 3,615,129 2,466,850 3,035,683 2,071,454 1,962,273 109,180 5.3%
Economic Development 1,875,749 1,272,934 1,244,175 840,770 1,383,047 936,995 840,426 96,569 10.3%
Planning ‐ ‐ 1,525,460 925,873 1,834,707 1,223,138 1,153,979 69,159 5.7%
Finance 1,909,652 1,277,022 1,969,936 1,456,163 2,164,890 1,525,174 1,240,000 285,174 18.7%
Human Resources 981,306 683,469 853,063 555,907 918,169 620,354 578,948 41,406 6.7%
Police 23,894,898 15,224,384 25,833,756 16,861,210 28,022,582 18,080,545 18,171,947 (91,402) ‐0.5%
Fire 21,763,640 14,122,769 20,375,286 13,858,953 21,922,009 14,556,982 14,548,321 8,661 0.1%
Facilities 3,614,850 2,370,139 ‐ (242) ‐ ‐ ‐ ‐ 0.0%
Parks 4,892,441 3,140,048 4,820,336 3,223,065 4,584,001 3,003,107 2,681,081 322,026 10.7%
Parks Planning & Natural Resources ‐ ‐ ‐ ‐ 545,943 363,962 283,463 80,499 22.1%
Recreation 4,383,163 2,962,752 7,878,458 5,309,821 4,987,111 3,364,665 3,176,319 188,346 5.6%
Human Services 1,162,553 717,690 1,194,142 723,598 1,406,586 860,228 825,837 34,390 4.0%
Community Resources & Events 367,627 222,949 348,185 209,828 375,694 227,143 210,720 16,423 7.2%
Library 1,890,886 1,249,231 2,312,128 1,365,858 2,607,263 1,628,119 1,628,119 ‐ 0.0%
Museum 136,327 92,923 140,801 95,866 194,120 132,242 127,286 4,956 3.7%
Public Works Administration 886,867 624,696 463,533 320,421 518,399 362,816 346,210 16,606 4.6%
Street Maintenance 3,212,111 1,992,860 3,794,716 2,656,566 3,385,704 2,246,606 2,224,610 21,996 1.0%
Technical Services 515,708 334,651 478,493 318,035 ‐ ‐ ‐ ‐ 0.0%
Transportation 4,841,955 2,988,381 5,110,639 3,411,038 5,164,058 3,446,692 3,381,065 65,626 1.9%
Debt Service 4,263,739 1,049,799 4,176,822 975,339 4,494,945 1,303,814 1,303,814 ‐ 0.0%
Payment of LTGO Refunding Debt ‐ ‐ ‐ ‐ 6,613,194 6,613,194 6,613,194 ‐ 0.0%
Non‐Departmental and Other 5,011,007 3,064,188 5,169,426 2,606,307 4,817,981 2,683,612 2,418,808 264,804 9.9%
Total Operating Expenditures 95,171,399 59,657,995 97,203,328 62,233,805 106,294,348 70,202,945 68,336,283 1,866,662 2.7%
Total Ending Fund Balance 11,816,561$ 8,714,101$ 11,955,285$ 9,986,419$ 11,245,093$ 9,253,866$ 10,204,572$ 950,706 10.3%
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 August 2010
Page 1 of 34
Monthly Financial Report August 2010
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through August 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 65% of all resources supporting general governmental activities. The following section provides detail
information on property, sales, utility, and other taxes.
Property Tax
August’s collection is $149k,
making the total year‐to‐date
collection $16.8 million or 54% of
the total budget. In comparison
to the previous year, the City
collected $766k or 5% higher.
Compared to the budget, the City
is above projections by $398k or
2%. Based on distribution we
have received in August, we are
projecting property tax collections
to meet the projections at year
end.
Sales Tax
August 2010 sales tax receipts totaled
$1.5 million. Compared to the same
month last year, it is $81k or 5% less.
Compared to the projected current
month’s budget, it is below
projections by $192k or 12%. The
year‐to‐date collection is $11.4 million
or 61% of the sales tax budget. This is
$598k less than last year and $834k
below budget. Based on the year‐to‐
date collection, the City is projecting
sales tax revenues to be $17.1 million
by the end of 2010, $1.5 million or 8%
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 114,982 1,703 2% (899) ‐1%
Jul 104,757 107,163 87,952 (16,805) ‐16% (19,211) ‐18%
Aug 66,589 68,118 149,160 82,571 124% 81,042 119%
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 16,020,559$ 16,388,472$ 16,786,759$ 766,200$ 5% 398,287$ 2%
Annual Total 30,660,522$ 31,364,643$
Property Tax Revenues
Year to Date through August
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 1,382,049 20,241 1% (82,288) ‐6%
Jul 1,443,891 1,547,213 1,309,429 (134,462) ‐9% (237,785) ‐15%
Aug 1,551,415 1,662,544 1,470,881 (80,535) ‐5% (191,663) ‐12%
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 12,028,421$ 12,264,491$ 11,430,357$ (598,064)$ ‐5% (834,134)$ ‐7%
Annual Total 17,995,836$ 18,609,000$
2010 vs. Budget2010 vs. 2009
Month
Year to Date through August
Local Retail Sales Tax Revenues
Page 2 of 34
Monthly Financial Report August 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 3,285,102$ 2,034,593$ 1,840,277$ 1,538,078$ (496,515)$ ‐24% $ (302,199)‐16%
Auto Sales 2,474,382 2,031,250 2,210,378 1,965,753 (65,497) ‐3% (244,625)‐11%
General Retail 4,014,787 3,928,271 4,008,426 3,995,899 67,628 2% (12,527) 0%
Manufacturing 702,587 725,078 650,868 502,285 (222,792) ‐31% (148,583)‐23%
Wholesale 782,577 618,604 663,099 621,066 2,462 0% (42,033)‐6%
Service 2,604,420 2,393,219 2,518,103 2,452,539 59,320 2% (65,564)‐3%
Other 274,001 297,408 373,340 354,736 57,328 19% (18,604)‐5%
Total 14,137,858$ 12,028,423$ 12,264,491$ 11,430,357$ (598,066) ‐5%(834,134)$ ‐7%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility tax
August utility taxes revenue totals $1.1
million, which is $69k lower than the
same month last year and behind the
budget by $40k. The year‐to‐date
collection of $9.9 million is above the
budget by $144k or 1% but is $98k
below 2009. The unfavorable
comparisons in January and February
are 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 meet
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 3,084,489 3,410,958 3,517,768 3,354,397 ‐2%‐5%
Natural Gas 1,375,870 1,670,606 1,269,129 1,310,786 ‐22% 3%
Cell 1,162,889 1,284,063 1,297,817 1,554,714 21% 20%
Phone 691,826 688,996 655,739 704,355 2% 7%
Cable 613,569 830,591 853,827 903,892 9% 6%
Transfer Station 232,495 158,142 157,104 157,215 ‐1% 0%
City Utilities 1,659,717 1,917,030 1,967,218 1,877,339 ‐2%‐5%
YTD Total 8,820,856 9,960,386 9,718,602 9,862,699 ‐1%1%
Annual Total 13,240,334 14,581,971 14,228,000
YTD as % of 67% 68% 68%
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 1,165,188 94,885 9% 120,866 12%
Jul 1,010,609 986,077 1,140,413 129,803 13% 154,335 16%
Aug 1,201,122 1,171,965 1,131,693 (69,429) ‐6% (40,272) ‐3%
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 9,960,386$ 9,718,602$ 9,862,699$ (97,687)$ ‐1% 144,097$ 1%
Annual Total 14,581,971$ 14,228,000$
2010 vs. Budget2010 vs. 2009
Year to Date through August
Utility Tax Revenues
Month
Page 3 of 34
Monthly Financial Report August 2010
Other Taxes
Real Estate Excise Tax
The City collected $209k in Real Estate
Excise Tax revenues (REET) in August.
This is $99k below current month’s
budget and $101k behind the same
month last year. Year‐to‐date collection
of $1.5 million is $107k or 7% behind the
budget and is also $120k or 7% below
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
August’s Gambling Tax collections
total $139k. Year‐to‐date total of
$1.1 million is $433k or 29% below
the year before; and $333k or 24%
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 $474k 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 $888k. This is
$153k or 21% above the projected
year‐to‐date budget and $109k or
14% higher than 2009. 2009’s
May collection should have been
recorded in April. The City is
projecting franchise fees to meet
the 2010 budget.
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 191,741 (19,554) ‐9% (17,947) ‐9%
Jul 201,960 200,400 149,706 (52,253) ‐26% (50,694) ‐25%
Aug 310,599 308,232 209,369 (101,230) ‐33% (98,863) ‐32%
Sep 208,046 206,472
Oct 209,975 208,368
Nov 222,052 220,344
Dec 121,614 120,696
YTD Total 1,656,770$ 1,644,120$ 1,537,086$ (119,684)$ ‐7% (107,034)$ ‐7%
Annual Total 2,418,456$ 2,400,000$
Real Estate Excise Tax Revenues
Year to Date through August
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 142,790 (44,130) ‐24% (31,762) ‐18%
Jul 182,851 170,752 125,614 (57,237) ‐31% (45,138) ‐26%
Aug 210,237 196,325 138,563 (71,673) ‐34% (57,762) ‐29%
Sep 173,745 162,248 ‐
Oct 176,490 164,811 ‐
Nov 146,960 137,236 ‐
Dec 137,979 128,849 ‐
YTD Total 1,506,546$ 1,406,856$ 1,073,429$ (433,117)$ ‐29% (333,427)$ ‐24%
Annual Total 2,141,720$ 2,000,000$
2010 vs. Budget
Gambling Tax Revenue
Month
Year to Date through August
2010 vs. 2009
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 286,523 25,876 10% 42,164 17%
Aug ‐ ‐ 6,691 6,691 100% 6,691 100%
Sep ‐ 24,721 ‐
Oct 259,798 258,846 ‐
Nov ‐ ‐ ‐
Dec ‐ 21,683 ‐
YTD Total 779,233$ 734,749$ 887,960$ 108,727$ 14% 153,210$ 21%
Annual Total 1,039,031$ 1,040,000$
Franchise Fees Revenue
Year to Date through August
Month
2010 vs. 2009 2010 vs. Budget
Page 4 of 34
Monthly Financial Report August 2010
Admission Tax
Admission Tax returns are due
quarterly in January, April, July,
and October each year. July 2010
collections represent activities
conducted during the 2nd quarter
of 2010.
The report shows an increase of
$28k from the year before and
$25k 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 August,
we have collected 68% of the projected revenue from licenses and permits. Licenses and Permits totaled $1.6 million by
the end of August, which is $11k less that the budget. The following sections provide detail information for Building
Permits and Business Licenses revenues.
Building Permits and Fees revenues
totaled $121k in August. 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 $1 million is $50k or 5% less than the
budget but is $25k or 2% higher than
2009. The City is projecting building
permits and fees to be under the 2010
budget by $75k.
Business Licenses totaled $319k since the start of
the year, which is 1% above last year but 7%
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 $25k but $3k 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 76,024 5,334 8% 6,114 9%
Oct 70,729 67,414 ‐
Nov 520 295 ‐
YTD Total 189,020$ 192,291$ 217,864$ 28,844$ 15% 25,573$ 13%
Annual Total 260,269$ 260,000$
Year to Date through August
Month
2010 vs. 2009 2010 vs . Budget
Admission Tax 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 135,295 3,591 3% (6,238) ‐4%
Jul 106,810 114,781 137,367 30,557 29% 22,585 20%
Aug 119,439 128,352 121,011 1,573 1% (7,341) ‐6%
Sep 101,087 108,631 ‐
Oct 131,899 141,742 ‐
Nov 82,516 88,674 ‐
Dec 169,581 182,237 ‐
YTD Total 1,008,511$ 1,083,775$ 1,033,450$ 24,939$ 2% (50,325)$ ‐5%
Annual Total 1,493,593$ 1,605,059$
Building Permits and Fees
Year to Date through August
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 4,709 (4,643) ‐50% (5,495) ‐54%
Jul 80,579 87,918 83,201 2,622 3% (4,717) ‐5%
Aug 20,280 22,127 14,782 (5,498) ‐27% (7,345) ‐33%
Sep 1,746 1,905 ‐
Oct 84,002 91,653 ‐
Nov 18,937 20,662 ‐
Dec 3,922 4,279 ‐
YTD Total 315,805$ 344,568$ 319,296$ 3,491$ 1% (25,271)$ ‐7%
Annual Total 424,413$ 463,067$
Business Licenses
Month
Year to Date through August
2010 vs. Budget2010 vs. 2009
Page 5 of 34
Monthly Financial Report August 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 83% of the total
revenues in this category.
The year‐to‐date total
Intergovernmental revenue is
$6.5 million or 56% 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 $2.6 million since the start
of 2010. Compared to the
projected budget, State Shared
Revenues are above by $84k or 3%.
Compared to the prior year, the
City is collecting $82k more or up
by 3%. The actual collections that
lags budget are primarily due to the
reduced criminal justice sales tax
(King County countywide sales tax
decrease). Based on the collections
so far, the City is projecting State
Shared Revenues to meet the 2010 budget.
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 76% of the total revenue in this category. The year‐to‐date total charges for services are $4.3 million or 68% of
the budget. This is 1% below budget projections. The following sections provide detail information for Plan Review with
Inspection Fees, Recreation, and Interfund Services.
Plan Review and Inspection fees are $614k
since the start of the year. Compared to the
budget, the City is collecting $96k or 18%
more than anticipated revenue. Compared
to the prior year, the City is collecting $211k
or 53% more. The large increase in July is due
to a payment related to an environmental
impact statement. The City is projecting plan
review and inspection fees to exceed the 2010
budget.
Intergovernmental 2008 2009 2010 Bgt YTD Act Chg 10/09 10Act
vs Bgt
Fire District #25 775,262 681,675 810,735 810,735 19% 0%
Fire District #40 ‐ 2,369,298 1,949,728 1,949,728 ‐18% 0%
State Shared Revenue 2,333,509 2,561,363 2,558,799 2,643,095 3% 3%
Federal Grants 476,485 297,727 414,277 414,277 39% 0%
State Grants 17,996 157,675 168,703 168,703 7% 0%
Other Grants 142,780 668,500 161,567 161,567 ‐76% 0%
ARRA Grants ‐ ‐ 349,118 349,118 100% 0%
Total Rev YTD 3,746,032 6,736,238 6,412,926 6,497,222 ‐4% 1%
Total Rev Annual 10,503,905 11,340,480 11,653,246
YTD %36% 59% 55% 56%
Note: Includes CJ Sales Tax.
2009 2010 2010
Actual Budget Actual $ % $ %
Crim Just Sales Tax 1,096,752$ 1,158,323$ 1,072,153$ (24,599)$ ‐2% (86,170)$ ‐7%
Judicial Contribution 23,918 9,628 22,868 (1,050)$ ‐4% 13,240 138%
Crim Just ‐ Pop 13,209 ‐ 14,038 829 6% 14,038 100%
Crim Just ‐ Spec Prog 50,510 49,090 53,236 2,726 5% 4,147 8%
State DUI 11,244 6,111 11,787 543 5% 5,676 93%
Liquor Profits 280,373 296,062 351,048 70,675 25% 54,986 19%
Liquor Excise Tax 298,300 305,224 313,158 14,859 5% 7,934 3%
Fuel Tax 787,057 734,361 804,807 17,750 2% 70,446 10%
YTD Total 2,561,363$ 2,558,799$ 2,643,095$ 81,732$ 3% 84,295$ 3%
Annual Total 3,986,791$ 3,988,931$
State Shared Revenues
2010 vs. 2009
Revenue
Year to Date through August
2010 vs. Budget
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 35,851$ 46,164$ 98,294$ 62,443$ 174% 52,130$ 113%
Feb 45,883 59,082 41,012 (4,871) ‐11% (18,070) ‐31%
Mar 86,425 111,287 64,399 (22,026) ‐25% (46,888) ‐42%
Apr 27,659 35,615 45,065 17,406 63% 9,449 27%
May 58,715 75,606 103,250 44,534 76% 27,644 37%
Jun 43,085 55,479 60,642 17,557 41% 5,163 9%
Jul 61,541 79,245 162,517 100,977 164% 83,273 105%
Aug 43,348 55,817 38,649 (4,698) ‐11% (17,168) ‐31%
Sep 36,509 47,012 ‐
Oct 67,095 86,397 ‐
Nov 59,883 77,110 ‐
Dec 109,397 140,867 ‐
YTD Total 402,506$ 518,296$ 613,828$ 211,323$ 53% 95,532$ 18%
Annual Total 675,391$ 869,683$
Month
2010 vs. 2009 2010 vs. Budget
Year to Date through August
Plan Review / Inspection
Page 6 of 34
Monthly Financial Report August 2010
Recreation revenues totaled $1.1 million
since the start of the year. Compared to
the projected monthly budget, the City
collected $14k or 7% less. Compared to
the same month the prior year, the City
collected $22k or 11% less. Based on the
current month’s collection, the City is
projecting Recreation revenues to be
under the budget projection for 2010 by
$161k.
The year‐to‐date collections for Interfund
Service revenues are $2.2 million.
Compared to the projected budget, the
revenues are below by $41k or down by
2%. Compared to the prior year, the
revenues are over by $32k or up by 2%.
Interfund Services is projected to be slightly
under the budget projection for 2010.
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 $2.3
million. This is $221k or 9% lower than
a year ago and $76k or 3% under
budget. Part of the difference is due to
$76k higher than budgeted Seizure
Funds received this year. The use of
Seizure Funds is restricted to specific
drug enforcement only and not
available for general operating
purposes. Backing out this amount, we
are currently $150k or 6% below
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 193,082 38,844 25% 44,445 30%
Jul 429,059 413,478 280,956 (148,103) ‐35% (132,523) ‐32%
Aug 203,222 195,842 181,356 (21,866) ‐11% (14,486) ‐7%
Sep 123,439 118,956 ‐
Oct 79,452 76,566 ‐
Nov 61,971 59,720 ‐
Dec 73,842 71,161 ‐
YTD Total 1,292,783$ 1,245,837$ 1,118,294$ (174,489)$ ‐13% (127,543)$ ‐10%
Annual Total 1,631,486$ 1,572,240$
2010 vs. Budget
Recreation
Year to Date through August
2010 vs. 2009
Month
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 253,147$ 261,774$ 242,658$ (10,489)$ ‐4% (19,116)$ ‐7%
Feb 243,496 251,795 273,674 30,178 12% 21,880 9%
Mar 286,921 296,700 249,758 (37,163) ‐13% (46,942) ‐16%
Apr 280,094 289,640 348,019 67,925 24% 58,379 20%
May 282,056 291,668 269,154 (12,902) ‐5% (22,515) ‐8%
Jun 270,778 280,006 275,850 5,072 2% (4,156) ‐1%
Jul 263,897 272,891 263,285 (612) 0% (9,606) ‐4%
Aug 258,386 267,191 248,584 (9,801) ‐4% (18,607) ‐7%
Sep 265,902 274,964 ‐
Oct 266,313 275,389 ‐
Nov 281,154 290,736 ‐
Dec 273,599 282,923 ‐
YTD Total 2,138,776$ 2,211,665$ 2,170,982$ 32,206$ 2% (40,683)$ ‐2%
Annual Total 3,225,745$ 3,335,677$
Interfund Services
Year to Date through August
2010 vs. 2009 2010 vs. Budget
Month
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 280,849$ 260,504$ 239,080$ (41,769)$ ‐15% (21,424)$ ‐8%
Feb 285,126 273,615 228,332 (56,794) ‐20% (45,283) ‐17%
Mar 370,244 346,368 279,311 (90,933) ‐25% (67,057) ‐19%
Apr 331,546 308,110 294,612 (36,934) ‐11% (13,498) ‐4%
May 310,888 288,772 276,543 (34,345) ‐11% (12,229) ‐4%
Jun 330,829 308,278 373,623 42,794 13% 65,345 21%
Jul 321,486 320,479 256,225 (65,261) ‐20% (64,254) ‐20%
Aug 256,668 236,769 319,267 62,598 24% 82,497 35%
Sep 269,199 248,930 ‐
Oct 318,272 297,259 ‐
Nov 368,928 345,541 ‐
Dec 372,972 342,568 ‐
YTD Total 2,487,637$ 2,342,895$ 2,266,994$ (220,643)$ ‐9% (75,902)$ ‐3%
Annual Total 3,817,008$ 3,577,193$
2010 vs. Budget2010 vs. 2009
Year to Date through August
Fines and Penalties by Month
Month
Page 7 of 34
Monthly Financial Report August 2010
budget in Fines and Penalties and we expect to be $200k below budget at the end of the year. The projected shortfall is
primarily due to substantial declines in the photo enforcement fines, which we expect to continue. The decline is due to
driver behavior changes in the areas with photo enforcement programs and is consistent with the experience of other
jurisdictions. These factors contributed to the reduction in photo enforcement revenue by 3% in July and 15% in August
when compared with the same periods in 2009.
Year to Date through August
2009 2010 2010
Actual Budget Actual $ % $ %
Civil Penalties 10,712$ 9,173$ 9,892$ (820)$ ‐8% 719$ 8%
Civil Infraction Penalties 506,006 459,359 511,860 5,854 1% 52,502 11%
Civil Parking Infraction Penalties 102,202 87,535 91,741 (10,461) ‐10% 4,206 5%
Photo Enforcement Program 1,575,781 1,497,176 1,306,228 (269,554) ‐17% (190,948) ‐13%
Criminal Traffic Misdemeanor Fines 68,063 54,366 59,058 (9,005) ‐13% 4,693 9%
Criminal Non‐Traffic Fines 30,234 28,140 23,182 (7,052) ‐23% (4,958) ‐18%
Criminal Costs 69,104 59,306 62,129 (6,975) ‐10% 2,823 5%
Seizure Funds ‐ Federal/State/Local 88,550 115,910 191,693 103,142 116% 75,783 65%
Non‐Court Fines, Forfeitures and Penalties 36,984 31,930 11,211 (25,773) ‐70% (20,719) ‐65%
YTD Total 2,487,637$ 2,342,895$ 2,266,994$ (220,643)$ ‐9% (75,902)$ ‐3%
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 $1.3 million. 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 83% of the
total revenue in this category. The year‐
to‐date total miscellaneous is $973k.
Compared to the projected year‐to‐date
budget, the revenues are over by $25k or
3%.
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 217,862 69,786 67,880 149,982
Jul 143,538 146,429 69,991 68,261 78,167
Aug 143,576 128,118 69,525 53,540 74,577
Sep 149,862 ‐ 69,700 ‐ ‐
Oct 188,205 ‐ 69,347 ‐ ‐
Nov 240,433 ‐ 70,269 ‐ ‐
Dec 174,325 ‐ 73,194 ‐ ‐
YTD Total 1,497,176$ 1,306,228$ 559,455$ 524,048$ 782,180$
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 August
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 148,339 48,132 48% 58,070 64%
Jul 219,671 197,884 158,134 (61,537) ‐28% (39,751) ‐20%
Aug 80,681 72,680 93,081 12,399 15% 20,401 28%
Sep 131,358 118,330
Oct 76,125 68,575
Nov 73,002 65,762
Dec 196,289 176,822
YTD Total 1,052,917$ 948,491$ 973,082$ (79,835)$ ‐8% 24,591$ 3%
Annual Total 1,529,692$ 1,377,980$
Year to Date through August
Month
2010 vs. Budget2010 vs. 2009
Miscellaneous Revenues by Month
Page 8 of 34
Monthly Financial Report August 2010
2009 2010 2010
Actual Budget Actual $ % $ %
Interests and Other Earnings 377,123$ 298,937$ 233,864$ (143,259)$ ‐38% (65,073)$ ‐22%
Rents, Leases, and Concessions 528,534 496,127 576,796 48,262 9% 80,669 16%
Contributions/Donations from Private Sources 100,173 77,023 90,947 (9,226) ‐9% 13,924 18%
Other 47,087 76,403 71,474 24,388 52% (4,929) ‐6%
YTD Total 1,052,917$ 948,491$ 973,082$ (79,835)$ ‐8% 24,591$ 3%
Annual Total 1,529,692$ 1,377,980$
2010 vs. Budget
Miscellaneous Revenues by Type
Year to Date through August
Revenue
2010 vs. 2009
EXPENSES
Overall the City has expended 64% of its budgeted general governmental expenditures at the end of August. This is 2.7% or
$1.9 million below year‐to‐date budgeted expenditures. While some of these savings would be realized at the end of the
year, others are due to the timing of the payments. Below are the explanations for some of the large variances on the
expenditures. We do expect some expenditure savings at the end of the year, but it will be narrower than the 2.7% we
currently have.
The Finance Department appears to be under budget by $285k. 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 we do not expect savings in Finance at the end
of the year.
The City Clerk division is under budget by $156k due to lower expenditures in elections costs.
Community Services is under budget in total by $642k due to expending less in temporary/intermittent/seasonal help and
supplies.
Page 9 of 34
Monthly Financial Report August 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 ‐ ‐ ‐ ‐ 38,582 29,900 ‐
Grants 61,220 ‐ ‐ 2,699 ‐ 500,238 ‐
Charges for services 28,841 1,362,585 9,973,287 6,225,718 11,171,111 3,329,201 ‐
Interdepartmental services ‐ ‐ 1,969 159,762 113,991 361,705 ‐
Rents, leases, and misc fees 1,110,959 272,489 54,000 64,858 ‐ ‐ ‐
Interest and other misc 10,284 11,968 111,867 289,236 417,950 152,402 130
TOTAL REVENUES 1,211,304 1,647,042 10,141,123 6,742,273 11,741,634 4,373,446 130
EXPENSES:
Utility billing ‐ ‐ 84,921 69,925 61,949 100,921 ‐
Utility systems ‐ ‐ 8,755,184 1,679,852 1,510,213 1,392,459 ‐
Utility maintenance ‐ ‐ 183,656 2,964,882 8,189,170 1,114,370 ‐
Transportation 692,768 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 1,168,827 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 692,768 1,168,827 9,023,761 4,714,659 9,761,332 2,607,750 ‐
AMOUNT AVAILABLE FOR DEBT SERVICE 518,536 478,215 1,117,362 2,027,614 1,980,302 1,765,696 130
DEBT SERVICE:
Principal ‐ 15,296 ‐ 1,246,675 815,776 151,840 ‐
Interest and other debt service costs ‐ 57,542 ‐ 480,938 250,164 194,229 ‐
TOTAL DEBT SERVICE ‐ 72,838 ‐ 1,727,613 1,065,940 346,069 ‐
CAPITAL PROJECTS 206,279 165,652 ‐ 1,286,957 2,769,671 1,119,633 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 312,257 239,725 1,117,362 (986,956) (1,855,309) 299,994 130
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, August 31, 2010 1,361,340 1,325,526 1,443,396 6,170,152 920,229 4,282,836 15,735
Page 10 of 34
Monthly Financial Report August 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 1,424,419 1,308,343 ‐ ‐ ‐ ‐ ‐
Telecommunications ‐ 190,541 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 71,584 ‐ 225,006 ‐ ‐ ‐
Communications ‐ ‐ ‐ 360,026 ‐ ‐ ‐
Facilities ‐ ‐ 2,784,153 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 74,974 ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ 167,206 ‐ ‐ ‐ ‐ ‐
Interest and other misc 43,984 15,307 1,794 767 56,295 49,441 26,301
Internal service fund misc:
Vehicle/equipment capital recovery 960,664 664,520 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 1,472,612 ‐ ‐
Worker's compensation / unemployment ‐ ‐ ‐ ‐ 931,867 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 7,404,448 1,163,827
Other misc 336 ‐ 2,297 ‐ 3,611 319,334 ‐
Disposal of capital assets ‐ ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 72,316 103,246 31,832
TOTAL REVENUES 2,429,403 2,493,461 2,788,244 585,799 2,536,701 7,876,469 1,221,960
EXPENSES:
Communications 313,402
Equipment rental 1,441,731
Facilities 2,608,720
Healthcare 5,924,415
Information technology 2,100,566
Print and mail ‐ 281,153
Retiree healthcare 731,464
Risk management
Risk management 1,036,874
Unemployement 327,664
Worker's compensation 819,961
TOTAL EXPENSES 1,441,731 2,100,566 2,608,720 594,555 2,184,499 5,924,415 731,464
AMOUNT AVAILABLE FOR CAPITAL 987,672 392,895 179,524 (8,756) 352,202 1,952,054 490,496
CAPITAL PROJECTS 634,531 253,227 25,000 29,408 ‐ ‐ ‐
TRANSFERS IN ‐ ‐ ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 353,141 139,668 154,524 (38,164) 352,202 1,952,054 490,496
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, August 31, 2010 4,946,540 1,787,599 245,699 73,654 6,391,711 6,744,506 3,310,969
Page 11 of 34
Monthly Financial Report August 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 222,397
Bond proceeds ‐
Tax Credit (BABs) 837,545
TOTAL REVENUES 1,066,942
EXPENSES:
Salaries and wages 36,449
Benefits 26,039
Supplies 17,634
Professional services 1,076,658
Intergovernmental 767,810
Construction 32,645,939
TOTAL EXPENSES 34,570,531
AMOUNT AVAILABLE FOR DEBT SERVICE (33,503,589)
DEBT SERVICE:
Principal ‐
Interest and other debt service co sts 3,439,680
TOTAL DEBT SERVICE 3,439,680
CHANGE IN FUND BALANCE (36,943,269)
BEGINNING FUND BALANCE, January 1, 2010 80,644,637
ENDING FUND BALANCE, August 31, 2010 43,701,368
Page 12 of 34
Monthly Financial Report August 2010
FUND BALANCE
Page 14 shows the ending fund balance as of August 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 August, the City has $10.2 million reported in combined general governmental fund balance of the current
year’s operating budget, which is approximately 10% of budgeted operating expenditures. This is a decrease of $1.8 million
from the beginning balance of January 1, 2010. August’s ending fund balance is over the anticipated General Governmental
Fund Balance of $9.2 million by $962k. 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 and continue to decrease until we receive the second half
of 2010 property taxes in October and November.
CONTACT INFORMATION
This report is prepared by the Finance Division of the FIT Department. For additional financial information, please also
review our website: http://www.rentonwa.gov/. For any questions about the report, please feel free to contact us at
hnguyen@rentonwa.gov or iwang@rentonwa.gov.
Page 13 of 34
Monthly Financial Report August 2010
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through August 31, 2010
Funds
Balance
01/01/2010
Budgeted
Revenue
Revenue
08/31/10
Total Funds
Available
Budgeted
Expenditure
Expenditure
08/31/10 Ending Balance
GENERAL GOVERNMENT FUNDS:11,955,285 105,584,156 66,585,571 78,540,856 106,294,348 68,336,283 10,204,573
000 General 8,535,013 74,693,168 45,926,795 54,461,808 72,750,777 46,372,357 8,089,451
001 Community Services 958,009 9,557,924 6,164,334 7,122,343 10,492,749 6,351,583 770,760
003 Street 1,391,648 7,456,240 4,545,250 5,936,898 8,549,762 5,605,675 331,223
004 Community Dev Block Grant (6,528) 532,635 80,604 74,076 532,227 303,572 (229,496)
005 Museum 64,705 192,621 96,772 161,477 194,120 127,286 34,191
006 Library 706,011 1,888,252 926,098 1,632,109 2,607,263 1,628,119 3,990
009 Farmers Market 60,571 44,280 40,684 101,255 34,311 28,913 72,342
010 Fire Memorial 936 ‐ 315 1,251 ‐ ‐ 1,251
011 Fire Health & Wellness 4,303 25,000 15,931 20,234 25,000 1,770 18,464
031 Pa rk Memorial 175,066 ‐ 1,485 176,551 ‐ ‐ 176,551
201 Ltd GO Bonds Gen Govt Debt 1,448 2,033,177 541,226 542,674 1,984,625 318,588 224,086
215 Gen Govt Misc Debt Service 64,103 9,160,859 8,246,077 8,310,180 9,123,514 7,598,420 711,760
SPECIAL REVENUE FUNDS:
102 Arterial Street 200,686 620,000 382,563 583,249 620,000 ‐ 583,249
108 Leased City Properties 837,613 1,669,586 798,348 1,635,961 1,511,561 1,233,594 402,367
110 Hotel Motel 247,828 245,000 180,248 428,076 310,000 200,695 227,381
118 Reserve for Paths & Trails 3,264 ‐ 31 3,295 ‐ ‐ 3,295
125 1% For Art 143,796 35,000 1,207 145,003 50,000 8,611 136,392
127 Cable Communication 89,391 85,000 38,826 128,217 85,674 13,145 115,072
135 Springbrook Wetlands Bank 459,528 ‐ 3,906 463,434 ‐ ‐ 463,434
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 256,387 1,322,980 ‐ ‐ 1,322,980
304 Fire Mitigation 2,363,522 100,000 45,006 2,408,528 560,000 519,996 1,888,532
305 Transportation Mitigation 2,167,133 200,000 (28,126) 2,139,007 1,810,000 ‐ 2,139,007
316 Municipal Facilities CIP 6,933,186 1,333,553 756,707 7,689,893 7,681,771 1,086,737 6,603,156
317 Transportation CIP 2,892,341 31,352,042 7,257,238 10,149,579 33,183,734 7,532,800 2,616,779
318 So Lake WA Infrastructure Proj 114,039 ‐ 818 114,857 114,000 56,408 58,449
326 Housing Opportunity 201,653 ‐ 1,717 203,370 200,000 ‐ 203,370
ENTERPRISE FUNDS:
402 Airport 415,929 1,917,163 1,145,117 1,561,046 1,001,800 692,768 868,278
403 Solid Waste Utility 326,034 15,027,000 10,141,123 10,467,157 15,037,130 9,023,761 1,443,396
404 Golf Course 798,278 2,483,545 1,645,422 2,443,700 2,566,837 1,284,140 1,159,560
422 Airport Capital 633,154 1,578,000 66,188 699,342 1,831,485 206,279 493,063
424 Golf Course Capital 287,523 150,000 1,620 289,143 302,499 123,178 165,965
INTERNAL SERVICE FUNDS:
501 Equipment Repair/Replacement 4,593,399 3,631,241 2,429,403 7,022,802 3,414,047 2,076,262 4,946,540
502 Insurance 6,039,509 3,287,584 2,536,701 8,576,210 4,170,106 2,184,500 6,391,710
503 Information Services 1,647,931 4,194,774 2,493,460 4,141,391 4,841,706 2,353,793 1,787,598
504 Facilities 91,175 4,705,475 2,788,244 2,879,419 4,326,200 2,633,720 245,699
505 Communications 111,818 1,049,671 585,799 697,617 877,560 623,963 73,654
512 Insurance, Healthcare 4,792,452 12,358,471 7,876,469 12,668,921 12,462,810 5,924,415 6,744,506
522 Insurance, Leoff1 Retirees HC 2,820,473 2,235,684 1,221,960 4,042,433 2,248,907 731,464 3,310,969
FIDUCIARY FUNDS:
611 Firemen's Pension 4,332,817 300,000 124,376 4,457,193 550,475 253,889 4,203,304
Funds
Balance
01/01/2010
Budgeted
Revenue
Revenue
08/31/10
Total Funds
Available
Budgeted
Expenditure
Expenditure
08/31/10 Ending Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 13,931,093 45,033,520 24,057,484 37,988,577 51,412,468 26,599,624 11,388,953
405 Water Utility 4,294,833 11,316,910 6,561,523 10,856,356 11,712,205 6,458,350 4,398,006
406 Waste Water Utility 1,887,815 6,065,737 3,750,667 5,638,482 6,837,864 4,701,131 937,351
407 Surface Water Utility 2,448,845 5,788,148 3,760,633 6,209,478 6,695,464 2,953,819 3,255,659
416 King County Metro 46,504 11,211,935 7,593,299 7,639,803 11,211,935 7,326,142 313,661
425 Water Utility Construction 2,862,275 3,460,000 180,750 3,043,025 5,510,000 1,270,878 1,772,147
426 Waste Water Construction 841,219 3,153,781 1,597,669 2,438,888 3,995,000 2,769,671 (330,783)
427 Surface Water Construction 1,533,997 4,037,009 612,813 2,146,810 5,450,000 1,119,633 1,027,177
461 Waterworks Bond Reserve ‐ ‐ ‐ ‐ ‐ ‐ ‐
471 Wa terworks Rate Stabilization 15,605 ‐ 130 15,735 ‐ ‐ 15,735
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 55,079,253 52,299,100 2,780,152 14,735,437
July 60,897,449 60,400,225 497,224 12,452,509
August 66,585,570 68,336,283 (1,750,713) 10,204,572
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 5,264,426 4,881,556 ‐7.27%
Feb 11,625,871 10,472,029 ‐9.92%
Mar 17,518,523 15,590,071 ‐11.01%
Apr 31,317,316 27,747,760 ‐11.40%
May 53,887,444 48,191,829 ‐10.57%
Jun 59,447,505 55,079,253 ‐7.35%
Jul 65,989,500 60,897,449 ‐7.72%
Aug 72,131,330 66,585,570 ‐7.69%
Sep 77,124,405
Oct 89,234,907
Nov 105,923,539
Dec 112,197,350
Percent of budget 63.06%
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 16,549,647 2.08%
Jul 16,320,354 16,637,599 1.94%
Aug 16,388,472 16,786,759 2.43%
Sep 16,644,516
Oct 22,547,053
Nov 31,012,799
Dec 31,364,643
Percent of budget 53.52%
$‐
$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 9,663,981 ‐8.29%
Jul 12,138,293 11,131,292 ‐8.30%
Aug 13,935,185 12,776,450 ‐8.32%
Sep 15,628,456
Oct 17,436,835
Nov 18,929,142
Dec 20,857,000
Percent of budget 61.26%
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 7,590,593 0.40%
Jul 8,546,617 8,731,006 2.16%
Aug 9,718,578 9,862,699 1.48%
Sep 10,760,779
Oct 11,813,935
Nov 12,878,332
Dec 14,228,000
Percent of budget 69.32%
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 1,185,796 ‐3.19%
Jul 1,451,179 1,444,809 ‐0.44%
Aug 1,631,518 1,620,621 ‐0.67%
Sep 1,759,093
Oct 2,024,220
Nov 2,153,967
Dec 2,386,376
Percent of budget 67.91%
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 5,426,368 0.67%
Jul 5,807,628 5,897,632 1.55%
Aug 6,922,028 6,543,985 ‐5.46%
Sep 7,390,372
Oct 8,027,921
Nov 11,304,114
Dec 11,653,246
Percent of budget 56.16%
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 419,243 445,172 6.18%
Feb 848,381 869,415 2.48%
Mar 1,387,711 1,336,778 ‐3.67%
Apr 1,901,534 1,954,003 2.76%
May 2,472,989 2,466,435 ‐0.27%
Jun 3,018,488 3,043,138 0.82%
Jul 3,868,797 3,828,477 ‐1.04%
Aug 4,440,895 4,346,226 ‐2.13%
Sep 4,932,422
Oct 5,419,322
Nov 5,880,908
Dec 6,425,185
Percent of budget 67.64%
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 1,691,502 ‐5.54%
Jul 2,098,439 1,947,727 ‐7.18%
Aug 2,337,154 2,267,132 ‐3.00%
Sep 2,587,781
Oct 2,885,471
Nov 3,231,058
Dec 3,577,193
Percent of budget 63.38%
$‐
$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 2,591,928 ‐15.17%
Jul 3,781,909 3,784,819 0.08%
Aug 4,301,294 4,142,037 ‐3.70%
Sep 4,584,474
Oct 5,408,386
Nov 5,791,753
Dec 6,297,095
Percent of budget 65.78%
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 721,867 6.48%
Jul 875,817 880,001 0.48%
Aug 948,491 973,082 2.59%
Sep 1,066,818
Oct 1,135,400
Nov 1,201,158
Dec 1,377,980
Percent of budget 70.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 1,178,010 3.74%
Jul 1,335,888 1,327,717 ‐0.61%
Aug 1,644,120 1,537,086 ‐6.51%
Sep 1,850,592
Oct 2,058,960
Nov 2,279,304
Dec 2,400,000
Percent of budget 64.05%
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,664,885 7,161,528 ‐6.57%
Feb 16,321,497 15,011,456 ‐8.03%
Mar 24,388,175 22,695,538 ‐6.94%
Apr 32,630,239 29,817,438 ‐8.62%
May 47,213,383 43,949,015 ‐6.91%
Jun 56,475,873 52,299,100 ‐7.40%
Jul 65,403,535 60,400,225 ‐7.65%
Aug 73,963,419 68,336,283 ‐7.61%
Sep 82,414,882
Oct 90,767,492
Nov 99,375,209
Dec 112,907,542
Percent of budget expended 64.29%
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 131,035 ‐4.00%
Jul 158,472 152,284 ‐3.90%
Aug 180,456 173,947 ‐3.61%
Sep 202,484
Oct 224,540
Nov 246,799
Dec 267,957
Percent of budget expended 64.92%
$‐
$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 990,091 ‐1.45%
Jul 1,173,482 1,168,151 ‐0.45%
Aug 1,341,545 1,335,996 ‐0.41%
Sep 1,508,802
Oct 1,677,249
Nov 1,836,905
Dec 2,016,361
Percent of budget expended 66.26%
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 800,153 1.84%
Jul 935,460 933,696 ‐0.19%
Aug 1,087,274 1,038,272 ‐4.51%
Sep 1,225,811
Oct 1,370,153
Nov 1,499,437
Dec 1,635,047
Percent of budget expended 63.50%
$‐
$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 926,194 ‐20.59%
Jul 1,342,556 1,076,383 ‐19.83%
Aug 1,525,165 1,240,000 ‐18.70%
Sep 1,700,824
Oct 1,832,622
Nov 2,006,095
Dec 2,164,890
Percent of budget expended 57.28%
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 799,852 ‐3.14%
Jul 1,028,793 929,609 ‐9.64%
Aug 1,108,058 1,059,996 ‐4.34%
Sep 1,244,944
Oct 1,384,635
Nov 1,520,418
Dec 1,621,295
Percent of budget expended 65.38%
$‐
$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 428,866 ‐9.32%
Jul 547,642 505,205 ‐7.75%
Aug 620,352 578,948 ‐6.67%
Sep 697,386
Oct 773,457
Nov 845,873
Dec 918,169
Percent of budget expended 63.05%
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 258,597 ‐2.17%
Jul 308,727 302,033 ‐2.17%
Aug 353,278 346,210 ‐2.00%
Sep 394,646
Oct 441,919
Nov 483,769
Dec 518,399
Percent of budget expended 66.78%
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 1,849,216 ‐21.77%
Jul 2,580,253 2,144,315 ‐16.90%
Aug 2,956,550 2,417,038 ‐18.25%
Sep 3,332,176
Oct 3,741,593
Nov 4,083,716
Dec 4,792,981
Percent of budget expended 50.43%
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 13,574,734 0.80%
Jul 15,954,657 15,859,503 ‐0.60%
Aug 18,080,450 18,171,947 0.51%
Sep 20,560,448
Oct 22,762,743
Nov 25,377,250
Dec 28,022,582
Percent of budget expended 64.85%
$‐
$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 11,038,448 ‐1.51%
Jul 13,014,504 12,790,432 ‐1.72%
Aug 14,732,889 14,548,321 ‐1.25%
Sep 16,560,924
Oct 18,349,790
Nov 20,065,074
Dec 21,922,009
Percent of budget expended 66.36%
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 414,558 ‐23.07%
Jul 603,120 459,511 ‐23.81%
Aug 661,523 505,723 ‐23.55%
Sep 723,147
Oct 781,484
Nov 843,676
Dec 931,014
Percent of budget expended 54.32%
$‐
$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 372,237 3.13%
Jul 476,053 475,738 ‐0.07%
Aug 528,908 522,266 ‐1.26%
Sep 569,793
Oct 693,393
Nov 748,914
Dec 874,359
Percent of budget expended 59.73%
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 87,146 ‐12.84%
Jul 117,131 101,724 ‐13.15%
Aug 133,757 116,431 ‐12.95%
Sep 150,300
Oct 166,956
Nov 183,659
Dec 200,440
Percent of budget expended 58.09%
$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 527,322 555,670 5.38%
Feb 1,117,804 1,097,029 ‐1.86%
Mar 1,694,350 1,602,874 ‐5.40%
Apr 2,239,453 2,116,917 ‐5.47%
May 2,803,092 2,646,710 ‐5.58%
Jun 3,348,606 3,251,020 ‐2.91%
Jul 3,948,563 3,772,492 ‐4.46%
Aug 4,527,511 4,317,262 ‐4.64%
Sep 5,094,652
Oct 5,674,356
Nov 6,234,493
Dec 6,865,275
Percent of budget expended 62.89%
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,767,682 5,746,764 ‐0.36%
Feb 12,189,393 11,897,388 ‐2.40%
Mar 18,031,280 17,846,883 ‐1.02%
Apr 23,980,111 23,551,432 ‐1.79%
May 29,651,034 29,019,419 ‐2.13%
Jun 35,514,747 34,922,145 ‐1.67%
Jul 41,654,185 40,671,076 ‐2.36%
Aug 47,312,013 46,372,357 ‐1.99%
Sep 53,388,158
Oct 59,166,024
Nov 65,394,946
Dec 72,750,777
Percent of budget expended 63.74%
$‐
$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 630,299 570,605 ‐9.47%
Feb 1,419,564 1,321,394 ‐6.92%
Mar 2,185,115 2,026,750 ‐7.25%
Apr 2,977,422 2,733,709 ‐8.19%
May 3,791,765 3,481,093 ‐8.19%
Jun 4,633,283 4,303,348 ‐7.12%
Jul 5,779,091 5,324,731 ‐7.86%
Aug 6,950,397 6,351,583 ‐8.62%
Sep 7,813,005
Oct 8,658,616
Nov 9,532,347
Dec 10,492,749
Percent of budget expended 60.53%
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 601,390 641,040 6.59%
Feb 1,277,334 1,365,252 6.88%
Mar 1,960,375 2,078,338 6.02%
Apr 2,666,243 2,735,391 2.59%
May 3,386,048 3,438,717 1.56%
Jun 4,067,122 4,197,932 3.22%
Jul 4,805,564 4,826,691 0.44%
Aug 5,570,084 5,605,675 0.64%
Sep 6,295,873
Oct 7,009,949
Nov 7,716,929
Dec 8,549,762
Percent of budget expended 65.57%
$‐
$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 153,564 ‐36.27%
Jul 275,465 272,301 ‐1.15%
Aug 339,295 303,572 ‐10.53%
Sep 370,840
Oct 429,422
Nov 467,929
Dec 532,227
Percent of budget expended 57.04%
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 182,613 173,794 ‐4.83%
Feb 378,809 229,125 ‐39.51%
Mar 500,663 500,663 0.00%
Apr 505,911 505,911 0.00%
May 1,303,632 1,067,015 ‐18.15%
Jun 1,303,632 1,067,015 ‐18.15%
Jul 1,303,632 1,628,119 24.89%
Aug 1,692,130 1,628,119 ‐3.78%
Sep 1,692,130
Oct 1,692,130
Nov 2,476,900
Dec 2,607,263
Percent of budget expended 62.45%
$‐
$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 94,929 ‐4.63%
Jul 115,981 111,161 ‐4.16%
Aug 132,242 127,286 ‐3.75%
Sep 148,372
Oct 164,641
Nov 180,555
Dec 194,120
Percent of budget expended 65.57%
Note: Prior to 2009, Museum was part of the Library Fund
LTGO Funds Budget
YTD
Actual
Annual %
over (under)
$11.00
$12.00
Millions LTGO Funds
Budget
Actual
$‐
$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 54,985 126,390 129.86%
Apr 54,985 126,471 130.01%
May 54,985 6,739,665 12157.28%
Jun 2,665,176 7,540,445 182.92%
Jul 2,665,176 7,540,445 182.92%
Aug 2,665,176 7,917,008 197.05%
Sep 2,665,176
Oct 3,190,258
Nov 3,196,145
Dec 11,108,139
Percent of budget expended 71.27%
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
$7.00
$8.00
$9.00
$10.00
$11.00
$12.00
Millions LTGO Funds
Budget
Actual
Last Year
$‐
$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,801,416 3,901,859 2,612,849
Feb 6,307,320 7,676,067 5,998,348
Mar 9,643,301 11,963,798 8,343,902
Apr 12,048,386 15,716,035 12,647,433
May 16,350,167 19,691,324 15,881,194
Jun 21,455,174 23,695,967 21,496,504
Jul 26,204,723 27,958,146 26,430,562
Aug 29,894,785 31,807,245 29,263,202
Sep 33,313,431
Oct 36,734,374
Nov 40,547,974
Dec 45,924,856
Percent of budget expended 63.72%
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
$1.40
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 655,253 512,611
Jul 598,355 947,272 604,670
Aug 688,817 1,145,117 692,768
Sep 759,575
Oct 838,546
Nov 913,982
Dec 1,001,800
Percent of budget expended 69.15%
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
$1.40
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 1,006,321 958,609
Jul 1,232,903 1,301,264 1,111,362
Aug 1,384,039 1,645,422 1,284,140
Sep 1,549,779
Oct 1,857,389
Nov 1,994,766
Dec 2,566,837
Percent of budget expended 50.03%
Note: Operations only.
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
$2.40
$2.70
Millions Golf Course
Budget
Revenue
Expense
Page 34 of 34