HomeMy WebLinkAbout201011, November.pdfFINANCE AND
INFORMATION TECHNOLOGY
M E M O R A N D U M
DATE: January 12, 2011
TO: Terri Briere, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Finance Analyst
SUBJECT: November 2010 Financial Status Report
At the end of November, general governmental revenues show $1.4 million or 1.4% under
budget. This includes a $614k favorable property tax collection but otherwise almost all other
revenue categories are under performing. Part of the favorable property tax collection is due
to the timing of receipting 2009 October and November property taxes in 2009, which we use
to calculate the 2010 October and November budgeted amounts. Without the favorable
property tax, revenues are $2 million or 2% below budget. For the year, we are still expecting a
total sales tax collection to underperform the budget by $1.4 million, gambling tax by $475k,
court fines by $171k, and recreation fees by $148k; for a combined $2.2 million of lower than
expected revenue in 2010.
On the expenditures’ side, most departments are conserving their spending and are showing
favorable variances. Overall general governmental funds are showing a 3.5% or $3.3 million
savings. Part of the savings is due to the timing of certain lump sum payments which are not
yet processed but will be recorded to 2010, such as principal payments on the City’s general
obligation debts, banking fees, and voter registration/election costs. Also included in the
savings is a $702k reduction in medical insurance premiums based on lower actual utilization of
the City’s self insurance program.
There are two divisions showing unfavorable comparisons with budget. These are primarily due
to internal service fund charges paid in these divisions and not allocated evenly to the
department. Departments taken as a whole are within budget and projected targets.
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 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 26,675,972 30,660,522 30,316,577 31,364,643 31,012,799 31,626,558 613,758 2.0%
Sales Tax 20,825,055 18,329,895 17,995,836 16,483,331 18,609,000 17,084,854 15,795,188 (1,289,666) ‐7.5%
Sales Tax ‐ Annexation Credit ‐ ‐ 2,132,110 1,784,145 2,248,000 1,881,122 1,860,875 (20,247) ‐1.1%
Criminal Justice Sales Tax 1,755,469 1,608,411 1,650,350 1,520,057 1,743,000 1,605,392 1,489,606 (115,786) ‐7.2%
Natural Gas Use Tax 253,377 253,377 242,891 218,951 ‐ ‐ 212,031 212,031 100.0%
Admission Tax 197,740 197,740 260,269 260,269 260,000 260,000 291,399 31,399 12.1%
Franchise Fees 998,288 955,811 1,039,031 1,039,031 1,040,000 1,018,317 1,177,275 158,959 15.6%
Electricity Tax 4,580,037 4,179,749 4,963,151 4,535,698 5,150,000 4,706,455 4,543,890 (162,565) ‐3.5%
Gas Tax 1,565,810 1,407,481 1,891,255 1,728,070 1,858,000 1,697,684 1,373,970 (323,714) ‐19.1%
Transfer Station 380,961 352,733 283,985 237,829 230,000 192,618 263,595 70,977 36.8%
TV Cable 1,073,168 971,388 1,263,743 1,146,478 1,250,000 1,134,011 1,174,364 40,353 3.6%
Telephone 1,032,048 943,063 1,037,873 950,599 960,000 879,274 961,905 82,631 9.4%
Cellular Phone 1,748,147 1,603,935 2,027,473 1,749,181 1,900,000 1,639,205 2,048,458 409,253 25.0%
City Utilities 2,606,786 2,261,791 2,871,599 2,631,892 2,880,000 2,639,591 2,617,783 (21,808) ‐0.8%
Leasehold Excise Tax 190,644 156,855 146,002 104,957 100,000 71,887 104,082 32,195 44.8%
Gambling Excise Tax 2,157,029 2,144,895 2,141,720 2,003,741 2,000,000 1,871,151 1,426,905 (444,247) ‐23.7%
Real Estate Excise Tax 2,800,103 2,751,914 2,418,456 2,296,843 2,400,000 2,279,304 2,046,564 (232,740) ‐10.2%
Less: Municipal Facilities CIP REET (450,103) (343,841) (1,000,000) (1,000,000) (400,000) (400,000) (434,525) (34,525) 8.6%
EMS Levy 890,998 756,789 1,170,657 975,548 897,095 870,794 870,794 ‐ 0.0%
Business License Fees 485,537 474,539 424,413 420,491 463,067 458,788 429,698 (29,090) ‐6.3%
Other Licenses and Permits 257,477 243,429 176,851 152,211 157,250 135,341 232,391 97,051 71.7%
Building Permits 2,034,225 1,934,734 1,683,082 1,489,161 1,766,059 1,562,578 1,454,937 (107,641) ‐6.9%
Intergovernmental (Grants, etc)3,734,887 2,575,271 3,820,932 3,611,475 4,507,080 3,991,060 3,991,060 ‐ 0.0%
Fire District 25 and 40 Contracts 5,013,549 2,526,026 5,869,198 5,869,198 5,554,723 5,252,877 5,252,877 ‐ 0.0%
Records, Duplicating, and Passport Fees 176,950 166,956 187,721 163,967 217,585 190,052 183,188 (6,864) ‐3.6%
Public Safety 524,565 477,791 521,484 473,137 430,000 390,134 409,009 18,874 4.8%
Development Service Fees 903,768 847,387 677,955 568,558 869,683 729,348 812,521 83,173 11.4%
Culture and Recreation 1,678,818 1,596,823 1,631,486 1,557,644 1,572,240 1,501,079 1,359,462 (141,617) ‐9.4%
Interfund/Interdept‐Services 3,072,950 2,769,380 3,225,745 2,952,146 3,335,677 3,052,754 2,907,085 (145,670) ‐4.8%
Fines and Forfeits 1,057,797 972,707 1,349,034 1,159,539 1,196,500 1,028,431 1,098,650 70,219 6.8%
Photo Enforcement 803,111 572,824 2,368,131 2,184,653 2,250,000 2,075,675 1,770,040 (305,636) ‐14.7%
Seizure Funds ‐ Federal/State/Local 250,065 127,710 99,844 99,844 130,693 130,693 214,093 83,400 63.8%
Interests and Other Earnings 735,910 693,163 535,314 487,560 434,300 395,558 303,077 (92,481) ‐23.4%
Rents, Leases, and Concessions 676,919 643,950 677,960 643,713 720,780 684,370 695,028 10,658 1.6%
Contributions and Donations 175,513 160,324 150,406 130,706 111,900 97,243 129,404 32,161 33.1%
Other Miscellaneous 67,355 79,092 168,567 73,699 111,000 48,530 86,983 38,453 79.2%
Refunding Debt and Premiums ‐ ‐ ‐ ‐ 6,613,483 6,613,484 6,613,484 ‐ 0.0%
Transfer‐In 381,364 66,541 577,004 537,174 652,398 652,398 652,398 ‐ 0.0%
Total Operating Revenues 93,687,106 82,136,608 97,342,052 91,558,074 105,584,156 99,434,851 98,046,101 (1,388,750) ‐1.4%
OPERATING EXPENDITURES
Legislative 245,441 227,726 247,225 226,037 267,957 246,798 236,316 10,482 4.2%
City Attorney 1,661,225 1,505,273 1,248,380 1,223,305 1,621,295 1,520,423 1,432,643 87,780 5.8%
City Clerk 604,844 547,125 646,581 586,905 931,014 843,676 735,170 108,506 12.9%
Court Services 1,744,122 1,579,096 1,819,731 1,667,572 2,016,361 1,836,904 1,825,471 11,433 0.6%
Executive 966,373 886,287 1,499,747 1,375,285 1,635,047 1,499,431 1,450,539 48,892 3.3%
Hearing Examiner 166,820 153,169 171,911 157,203 200,440 183,658 159,823 23,835 13.0%
Community and Eco Dvlpmnt Admin ‐ ‐ 265,269 244,414 646,149 595,349 578,970 16,379 2.8%
Development Services 4,178,096 3,773,633 3,615,129 3,332,013 3,035,683 2,797,945 2,642,891 155,055 5.5%
Economic Development 1,875,749 1,694,398 1,244,175 1,141,752 1,383,047 1,257,251 1,201,408 55,844 4.4%
Planning ‐ ‐ 1,525,460 1,348,339 1,834,707 1,681,815 1,601,519 80,296 4.8%
Finance 1,909,652 1,768,857 1,969,936 1,826,162 2,164,890 2,006,094 1,712,099 293,995 14.7%
Human Resources 981,306 916,046 853,063 773,893 918,169 845,877 772,857 73,020 8.6%
Police 23,894,898 21,486,773 25,833,756 23,547,266 28,022,582 25,377,120 24,919,572 457,548 1.8%
Fire 21,763,640 19,522,521 20,375,286 18,667,578 21,922,009 19,867,704 19,761,222 106,482 0.5%
Community Services Admin 1 1,078,884 1,009,952 4,549,381 4,091,161 958,648 868,860 974,590 (105,730) ‐12.2%
Facilities 3,614,850 3,218,128 ‐ (242) ‐ ‐ ‐ ‐ 0.0%
Parks 4,892,441 4,504,357 4,820,336 4,474,734 4,584,001 4,237,733 3,819,286 418,447 9.9%
Parks Planning & Natural Resources ‐ ‐ ‐ ‐ 545,943 500,448 402,085 98,363 19.7%
Recreation 3,304,279 3,002,826 3,329,077 3,042,438 4,028,463 3,671,312 3,384,752 286,560 7.8%
Human Services 1,162,553 1,004,846 1,194,142 1,024,652 1,406,586 1,211,300 1,123,568 87,732 7.2%
Community Resources & Events 367,627 281,294 348,185 270,086 375,694 289,392 271,220 18,171 6.3%
Library 1,890,886 1,731,237 2,312,128 1,844,408 2,607,263 2,287,744 2,287,744 ‐ 0.0%
Museum 136,327 128,219 140,801 129,542 194,120 180,554 175,177 5,377 3.0%
Public Works Administration 886,867 855,440 463,533 428,146 518,399 492,750 471,654 21,095 4.3%
Street Maintenance 3,212,111 2,794,230 3,794,716 3,468,484 3,385,704 3,026,148 3,092,938 (66,790) ‐2.2%
Technical Services 515,708 472,545 478,493 431,854 ‐ ‐ ‐ ‐ 0.0%
Transportation 4,841,955 4,346,631 5,110,639 4,698,057 5,164,058 4,747,163 4,662,744 84,419 1.8%
Debt Service 4,263,739 1,263,039 4,176,822 1,165,568 4,494,945 1,528,024 1,528,024 ‐ 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 4,293,054 5,169,426 3,730,125 4,817,981 3,797,041 2,894,082 902,959 23.8%
Total Operating Expenditures 95,171,399 82,966,699 97,203,328 84,916,734 106,294,348 94,011,708 90,731,559 3,280,149 3.5%
Total Ending Fund Balance 11,816,561$ 12,470,762$ 11,955,285$ 18,457,901$ 11,245,093$ 17,378,429$ 19,269,827$ 1,891,398 10.9%
1Facilities was included in Community Services Admin in 2009. The reason for the defecit in 2010 is due to insurance internal service fund charges for Parks, Parks Planning, Recreation, and Community Resources & Events
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 November 2010
Page 1 of 35
Monthly Financial Report November 2010
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through November 30, 2010. Except as
noted, year‐to‐date budgeted revenues and operating expenditures are generally based on the collection/disbursement
patterns for the same period of the preceding year. The table on the previous page summarizes the general governmental
fund revenues and expenditures.
Revenues
Taxes
The combined collection of property tax, sales/use tax, utility tax, gambling, admissions, and real estate excise tax
represents 69% of all resources supporting general governmental activities. The following section provides detail
information on property, sales, utility, and other taxes.
Property Tax
November’s collection is $7.3
million, making the total year‐to‐
date collection $31.6 million or
101% of the total budget. In
comparison to the previous year,
the City collected $1.3 million or
4% more. Compared to the
budget, the City is above
projections by $614k or 2%. Since
the City receipted more of the
second half of property taxes in
November than October of 2009,
the 2010 monthly budget is
skewed. The City has met the 2010
budget for property taxes.
Sales Tax
November 2010 sales tax receipts
totaled $1.5 million. Compared to
the same month last year, it is $68k
or 5% more. Compared to the
projected current month’s budget, it
is below projections by $128k or 8%.
The year‐to‐date collection is $15.8
million or 85% of the sales tax
budget. This is $688k less than last
year and $1.3 million 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 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 491,642 241,346 96% 235,598 92%
Oct 5,770,027 5,902,536 7,060,074 1,290,046 22% 1,157,538 20%
Nov 8,275,695 8,465,747 7,288,083 (987,612) ‐12% (1,177,664) ‐14%
Dec 343,945 351,844
YTD Total 30,316,577$ 31,012,799$ 31,626,558$ 1,309,981$ 4% 613,759$ 2%
Annual Total 30,660,522$ 31,364,643$
Property Tax Revenues
Year to Date through November
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 1,408,876 (45,674) ‐3% (164,658) ‐10%
Oct 1,560,217 1,610,574 1,447,338 (112,879) ‐7% (163,236) ‐10%
Nov 1,440,143 1,636,255 1,508,617 68,474 5% (127,638) ‐8%
Dec 1,512,506 1,524,146 ‐
YTD Total 16,483,331$ 17,084,854$ 15,795,188$ (688,143)$ ‐4% (1,289,666)$ ‐8%
Annual Total 17,995,836$ 18,609,000$
2010 vs. Budget2010 vs. 2009
Month
Year to Date through November
Local Retail Sales Tax Revenues
Page 2 of 35
Monthly Financial Report November 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 2009 2010 Bgt YTD Act Change 2010/2009 2010 Act vs Bgt
New Construction 2,703,620$ 2,597,755$ 2,064,255$ (639,365)$ ‐24%$ (533,500)‐21%
Auto Sales 2,969,580 3,120,492 2,781,167 (188,413) ‐6% (339,325)‐11%
General Retail 5,376,239 5,563,309 5,519,826 143,587 3% (43,483)‐1%
Manufacturing 864,378 860,841 717,767 (146,611) ‐17% (143,074)‐17%
Wholesale 840,424 910,443 846,718 6,294 1% (63,726)‐7%
Service 3,298,526 3,518,770 3,386,991 88,465 3% (131,779)‐4%
Other 430,564 513,244 478,464 47,900 11% (34,780)‐7%
Total 16,483,331$ 17,084,854$ 15,795,188$ (688,143) ‐4%(1,289,666)$ ‐8%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility tax
November utility tax revenues are $1.1
million, which is $22k or 2% higher than
the same month last year and ahead of
the budget by $48k or 5%. The year‐to‐
date collection of $13.2 million is above
the budget by $318k or 2% but is $3k
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. The City is projecting utility
tax to meet the 2010 budget at 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 2009 2010 Bgt YTD Act Change 2010/2009 2010 Act vs Bgt
Electrical 4,535,698$ 4,706,455$ 4,543,890$ 8,191$ 0%$ (162,565)‐3%
Natural Gas 1,947,021 1,697,684 1,586,001 (361,020) ‐19% (111,683)‐7%
Cell 1,749,181 1,639,205 2,048,458 299,277 17% 409,253 25%
Phone 950,599 879,274 961,905 11,306 1% 82,631 9%
Cable 1,146,478 1,134,011 1,174,364 27,886 2% 40,353 4%
Transfer Station 237,829 192,618 263,595 25,766 11% 70,977 37%
City Utilities 2,631,892 2,639,591 2,617,783 (14,109) ‐1% (21,808)‐1%
YTD Total 13,198,698$ 12,878,306$ 13,195,997$ (2,702)$ 0%307,158$ 2%
Annual Total 14,581,971$ 14,228,000$
YTD as % of 91% 91%
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 1,082,231 14,197 1%40,123 4%
Oct 1,079,380 1,053,179 1,138,457 59,077 5% 85,279 8%
Nov 1,090,897 1,064,416 1,112,608 21,711 2% 48,192 5%
Dec 1,383,272 1,349,694
YTD Total 13,198,698$ 12,878,306$ 13,195,997$ (2,702)$ 0% 317,691$ 2%
Annual Total 14,581,971$ 14,228,000$
2010 vs. Budget2010 vs. 2009
Year to Date through November
Utility Tax Revenues
Month
Page 3 of 35
Monthly Financial Report November 2010
Other Taxes
Real Estate Excise Tax
The City collected $105k in Real Estate
Excise Tax revenues (REET) in
November. This is $115k or 52% below
current month’s budget and $117k or
53% behind the same month last year.
Year‐to‐date collection of $1.9 million is
$331k or 15% behind the budget and is
also $348k or 15% below 2009. We’ve
also received December’s distribution of
$535k which is substantially higher than
normal. We believe the rush of sales is
due to the uncertainty at the time when
Congress was deciding whether the
housing capital gain tax rate will be
renewed. With this infusion of higher
transaction amounts, we will be meeting
the $2.4 million REET budget for 2010.
Gambling Tax
November’s Gambling Tax
collections total $122k. Year‐to‐
date total of $1.4 million is $577k
or 29% below the year before;
and $444k or 24% below budget.
The lower tax collection is due to
cross‐the‐board reduction in
gambling activities. Pull tabs
overall reduced by 27%, partially
due to the change in business at
Cascade Lanes; and card‐rooms
are seeing 30% lower in activities.
Because of these changes, the City
is anticipating around $475k 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 $1.2 million. This
is $184k or 16% above the
projected year‐to‐date budget
and $138k or 13% higher than
2009. 2009’s May collection
should have been recorded in
April. The City has met the
franchise fees 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 123,054 (84,992) ‐41% (83,418) ‐40%
Oct 209,975 208,368 183,333 (26,642) ‐13% (25,035) ‐12%
Nov 222,052 220,344 105,277 (116,774) ‐53% (115,067) ‐52%
Dec 121,614 120,696
YTD Total 2,296,843$ 2,279,304$ 1,948,750$ (348,093)$ ‐15% (330,554)$ ‐15%
Annual Total 2,418,456$ 2,400,000$
Real Estate Excise Tax Revenues
Year to Date through November
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 105,323 (68,423) ‐39% (56,926) ‐35%
Oct 176,490 164,811 126,396 (50,093) ‐28% (38,415) ‐23%
Nov 146,960 137,236 121,757 (25,203) ‐17% (15,479) ‐11%
Dec 137,979 128,849 ‐
YTD Total 2,003,741$ 1,871,151$ 1,426,905$ (576,837)$ ‐29% (444,247)$ ‐24%
Annual Total 2,141,720$ 2,000,000$
Gambling Tax Revenue
Month
Year to Date through November
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%
Apr ‐ 102,746 274,268 274,268 100% 171,521 167%
May 258,593 132,005 ‐ (258,593) (132,005)
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 289,316 29,517 11% 30,469 12%
Nov ‐ ‐ ‐
Dec ‐ 21,683 ‐
YTD Total 1,039,031$ 1,018,317$ 1,177,275$ 138,244$ 13% 183,680$ 16%
Annual Total 1,039,031$ 1,040,000$
Franchise Fees Revenue
Year to Date through November
Month
2010 vs. 2009 2010 vs. Budget
Page 4 of 35
Monthly Financial Report November 2010
Admission Tax
Admission Tax returns are due
quarterly in January, April, July,
and October each year. October
2010 collections represent
activities conducted during the 3rd
quarter of 2010.
The report shows an increase of
$31k or 12% from the year before
and $31k or 12% 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 82% of the revenue in this category. As of the end of
November, we have collected 89% of the projected revenue from licenses and permits. Licenses and Permits totaled $2.1
million by the end of November, which is $37k less than the budget. The following sections provide detail information for
Building Permits and Business Licenses revenues.
Building Permits and Fees revenues
totaled $81k in November. 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.3 million is $111k or 8% less than
the budget and is also $12k or 1% lower
than 2009. The City is projecting
building permits and fees to be under
the 2010 budget by $125k.
Business Licenses totaled $430k since the start
of the year, which is 2% above last year but 6%
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 $29k but $9k 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%
Aug ‐ ‐ 485 485 100% 485 100%
Oct 70,729 67,414 73,073 2,344 3% 5,660 8%
Nov 520 295 462 (58) ‐11% 167 56%
YTD Total 260,269$ 260,000$ 291,399$ 31,130$ 12% 31,399$ 12%
Annual Total 260,269$ 260,000$
Year to Date through November
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 106,602 5,515 5%(2,029) ‐2%
Oct 131,899 141,742 91,156 (40,742) ‐31% (50,586) ‐36%
Nov 82,516 88,674 80,585 (1,931) ‐2% (8,089) ‐9%
Dec 169,581 182,237 ‐
YTD Total 1,324,012$ 1,422,822$ 1,311,792$ (12,220)$ ‐1% (111,030)$ ‐8%
Annual Total 1,493,593$ 1,605,059$
Building Permits and Fees
Year to Date through November
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 4,475 2,729 156%2,570 135%
Oct 84,002 91,653 83,639 (363) 0% (8,014) ‐9%
Nov 18,937 20,662 22,288 3,351 18% 1,626 8%
Dec 3,922 4,279 ‐
YTD Total 420,491$ 458,788$ 429,698$ 9,207$ 2% (29,090)$ ‐6%
Annual Total 424,413$ 463,067$
Business Licenses
Month
Year to Date through November
2010 vs. Budget2010 vs. 2009
Page 5 of 35
Monthly Financial Report November 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 84%
of the total revenues in this category. The year‐to‐date total Intergovernmental revenue is $10.6 million or 90% of the
budget. All grant revenues also have corresponding expenditures which have been added to the City’s budget through the
2010 carry forward, 2nd Quarter budget adjustment, and the upcoming Year‐End budget adjustment.
State Shared Revenue collections
totaled $3.7 million since the start
of 2010. Compared to the
projected budget, State Shared
Revenues are above by $69k or 2%.
Compared to the prior year, the
City is collecting $65k more or up
by 2%. The actual collection that
lags budget is 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 75% of the total revenue in this category. The year‐to‐date total charges for services are $5.7 million or 88% of
the budget. This is 3% 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 $808k
since the start of the year. Compared to the
budget, the City is collecting $79k or 11%
more than anticipated revenue. Compared
to the prior year, the City is collecting $242k
or 43% more. The large increases in May,
July, and October are due to payments
related to an environmental impact
statement. The City is projecting plan review
and inspection fees to exceed the 2010
budget.
2009 2010 2010
Actual Budget Actual $ % $ %
Crim Just Sales Tax 1,520,057$ 1,605,392$ 1,489,606$ (30,451)$ ‐2% (115,786)$ ‐7%
Judicial Contribution 29,810 12,000 28,507 (1,303)$ ‐4% 16,507 138%
Crim Just ‐ Pop 17,815 ‐ 18,818 1,002 6% 18,818 100%
Crim Just ‐ Spec Prog 68,011 66,098 71,284 3,273 5% 5,186 8%
State DUI 26,990 14,668 15,677 (11,313) ‐42% 1,009 7%
Liquor Profits 447,317 472,347 514,215 66,898 15% 41,868 9%
Liquor Excise Tax 403,630 413,000 419,052 15,422 4% 6,052 1%
Fuel Tax 1,115,717 1,041,017 1,137,199 21,482 2% 96,182 9%
YTD Total 3,629,347$ 3,624,523$ 3,694,358$ 65,011$ 2% 69,835$ 2%
Annual Total 3,986,791$ 3,988,931$
State Shared Revenues
2010 vs. 2009
Revenue
Year to Date through November
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 34,245 (2,264) ‐6% (12,767) ‐27%
Oct 67,095 86,397 124,857 57,761 86% 38,460 45%
Nov 59,883 77,110 35,118 (24,765) ‐41% (41,992) ‐54%
Dec 109,397 140,867 ‐
YTD Total 565,994$ 728,816$ 808,048$ 242,054$ 43% 79,232$ 11%
Annual Total 675,391$ 869,683$
2010 vs. Budget
Year to Date through November
Plan Review / Inspection
Month
2010 vs. 2009
Intergovernmental 2009 2010 Bgt YTD Act Change 2010/2009 2010 Act vs Bgt
Fire District #25 681,675$ 1,368,978$ 1,368,978$ 687,303$ 101% $ ‐ 0%
Fire District #40 5,187,523 3,883,899 3,883,899 (1,303,624) ‐25% ‐ 0%
State Shared Revenue 3,629,347 3,624,523 3,694,358 65,011 2% 69,835 2%
Federal Grants 434,996 608,559 608,559 173,563 40% ‐ 0%
State Grants 185,971 210,241 210,241 24,271 13% ‐ 0%
Other Grants 733,784 202,222 202,222 (531,562) ‐72% ‐ 0%
ARRA Grants 147,435 671,795 671,795 524,360 356% ‐ 0%
Total Rev YTD 11,000,730$ 10,570,216$ 10,640,051$ (360,679)$ ‐3%69,835$ 1%
Total Rev Annual 11,340,480$ 11,804,803$
YTD %97% 90% 90%
Note: Includes CJ Sales Tax.
Page 6 of 35
Monthly Financial Report November 2010
Recreation revenues totaled $1.4 million
since the start of the year. Compared to
the projected monthly budget, the City
collected $8k or 13% less. Compared to
the same month the prior year, the City
collected $10k or 17% less. Based on the
current month’s collection, the City is
projecting Recreation revenues to be
under the budget projection for 2010 by
$148k.
The year‐to‐date collections for Interfund
Service revenues are $2.9 million.
Compared to the projected budget, the
revenues are below by $146k or 5%.
Compared to the prior year, the revenues
are under by $45k or 2%. Interfund
Services is projected to be slightly under
the budget projection for 2010. The
majority of these revenues are related to
indirect cost allocation, which are internal
administrative costs. The remaining costs
consist of Development Services division’s
inspection fees, Transportation division’s
capital investment program
reimbursements, and Maintenance
division’s street maintenance
reimbursements.
Fines and Penalties
These revenue sources contain civil
(penalties, infractions, and parking),
criminal (traffic, non‐traffic, and costs),
and non‐court fines, forfeitures, and
penalties. The table on the next page
breaks down these fines by type. The
year‐to‐date total fines and penalties is
$3.1 million. This is $363k or 11%
lower than a year ago and $154k or 5%
under budget. This difference also
includes $83k higher than budgeted
Seizure Funds received this year. The
use of Seizure Funds is restricted to
drug enforcement only and not
available for general operating
purposes. Backing out this amount, we
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 111,952 (11,486) ‐9% (7,004) ‐6%
Oct 79,452 76,566 77,544 (1,907) ‐2% 978 1%
Nov 61,971 59,720 51,672 (10,298) ‐17% (8,048) ‐13%
Dec 73,842 71,161 ‐
YTD Total 1,557,644$ 1,501,079$ 1,359,462$ (198,181)$ ‐13% (141,617)$ ‐9%
Annual Total 1,631,486$ 1,572,240$
Recreation
Year to Date through November
2010 vs. 2009
Month
2010 vs. Budget
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 238,713 (27,189) ‐10% (36,251) ‐13%
Oct 266,313 275,389 241,403 (24,910) ‐9% (33,986) ‐12%
Nov 281,154 290,736 255,986 (25,168) ‐9% (34,750) ‐12%
Dec 273,599 282,923 ‐
YTD Total 2,952,146$ 3,052,754$ 2,907,085$ (45,061)$ ‐2% (145,670)$ ‐5%
Annual Total 3,225,745$ 3,335,677$
2010 vs. 2009 2010 vs. Budget
Month
Interfund Services
Year to Date through November
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 231,632 (37,567) ‐14% (17,298) ‐7%
Oct 318,272 297,259 267,539 (50,734) ‐16% (29,721) ‐10%
Nov 368,928 345,541 314,160 (54,768) ‐15% (31,381) ‐9%
Dec 372,972 342,568 ‐
YTD Total 3,444,036$ 3,234,625$ 3,080,324$ (363,712)$ ‐11% (154,301)$ ‐5%
Annual Total 3,817,008$ 3,577,193$
2010 vs. Budget2010 vs. 2009
Year to Date through November
Fines and Penalties by Month
Month
Page 7 of 35
Monthly Financial Report November 2010
are currently $238k or 7% below budget in Fines and Penalties and we expect to be $181k 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
19% in October and 17% in November when compared with the same periods in 2009.
Year to Date through November
2009 2010 2010
Actual Budget Actual $ % $ %
Civil Penalties 15,089$ 12,922$ 14,395$ (694)$ ‐5% 1,473$ 11%
Civil Infraction Penalties 717,709 651,546 733,686 15,977 2% 82,140 13%
Civil Parking Infraction Penalties 149,701 128,219 127,334 (22,368) ‐15% (885) ‐1%
Photo Enforcement Program 2,184,653 2,075,675 1,770,040 (414,614) ‐19% (305,636) ‐15%
Criminal Traffic Misdemeanor Fines 93,206 74,448 84,177 (9,029) ‐10% 9,729 13%
Criminal Non‐Traffic Fines 42,721 39,763 33,062 (9,658) ‐23% (6,700) ‐17%
Criminal Costs 91,325 78,376 92,116 792 1% 13,740 18%
Seizure Funds ‐ Federal/State/Local 99,844 130,693 214,093 114,249 114% 83,400 64%
Non‐Court Fines, Forfeitures and Penalties 49,787 42,983 11,421 (38,366) ‐77% (31,562) ‐73%
YTD Total 3,444,036$ 3,234,625$ 3,080,324$ (363,712)$ ‐11% (154,301)$ ‐5%
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.8 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 82% of
the total revenue in this category. The
year‐to‐date total miscellaneous is $1.2
million. Compared to the projected year‐
to‐date budget, the revenues are under by
$12k or 1%. Compared to last year, the
revenues are under by $120k or 9%.
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 143,245$ 127,631$ 170,998$ 27,753$ 19% 43,367$ 34%
Feb 192,680 181,886 86,124 (106,555) ‐55% (95,762) ‐53%
Mar 59,923 65,165 115,122 55,199 92% 49,957 77%
Apr 100,349 93,113 99,376 (974) ‐1% 6,263 7%
May 156,161 139,519 101,909 (54,252) ‐35% (37,610) ‐27%
Jun 100,207 98,090 148,339 48,132 48% 50,249 51%
Jul 219,671 188,995 158,134 (61,537) ‐28% (30,861) ‐16%
Aug 80,681 79,488 93,081 12,399 15% 13,593 17%
Sep 131,358 115,050 110,810 (20,548) ‐16% (4,240) ‐4%
Oct 76,125 69,672 73,018 (3,107) ‐4% 3,346 5%
Nov 73,002 66,318 56,175 (16,827) ‐23% (10,142) ‐15%
Dec 196,289 153,054 ‐
YTD Total 1,333,402$ 1,224,926$ 1,213,085$ (120,317)$ ‐9% (11,841)$ ‐1%
Annual Total 1,529,692$ 1,377,980$
Year to Date through November
Month
2010 vs. Budget2010 vs. 2009
Miscellaneous Revenues by Month
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 92,140 69,700 67,555 24,585
Oct 188,205 160,378 69,347 67,454 92,923
Nov 240,433 211,295 70,269 67,892 143,402
Dec 174,325 ‐ 73,194 ‐ ‐
YTD Total 2,075,675$ 1,770,040$ 768,770$ 726,950$ 1,043,090$
Annual Total 2,250,000$ 841,964$
1Actuals of Revenues and Expenses
Revenues Expenses
Photo Enforcement Program
Year to Date through November
Month
Page 8 of 35
Monthly Financial Report November 2010
2009 2010 2010
Actual Budget Actual $ % $ %
Interests and Other Earnings 487,560$ 395,558$ 303,077$ (184,483)$ ‐38% (92,481)$ ‐23%
Rents, Leases, and Concessions 643,713 684,370 695,028 51,315 8% 10,658 2%
Contributions/Donations from Private Sources 130,706 97,243 129,404 (1,301) ‐1% 32,161 33%
Other 71,423 47,756 85,576 14,153 20% 37,821 79%
YTD Total 1,333,402$ 1,224,926$ 1,213,085$ (120,317)$ ‐9% (11,841)$ ‐1%
Annual Total 1,529,692$ 1,377,980$
2010 vs. Budget
Miscellaneous Revenues by Type
Year to Date through November
Revenue
2010 vs. 2009
EXPENSES
Overall the City has expended 85% of its budgeted general governmental expenditures at the end of November. This is
3.5% or $3.3 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 3.5% we
currently have.
The Finance Department appears to be under budget by $293k. 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 Hearing Examiner is under budget by $24k or 13% due to expending less in contracted professional services.
The City Clerk division is under budget by $109k due to lower than anticipated elections costs. The City is expecting a total
of $127k in election costs, which will be $87k under the projected amount of $214k.
Community Services is under budget in total by $809k due to expending less in temporary/intermittent/seasonal help (for
Parks, Recreation, and Museum) and supplies.
Page 9 of 35
Monthly Financial Report November 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 ‐ ‐ ‐ ‐ 45,782 35,250 ‐
Grants 76,722 ‐ 144 2,699 ‐ 566,584 ‐
Charges for services 48,290 1,695,331 13,695,317 9,753,751 15,816,450 4,553,601 ‐
Interdepartmental services ‐ ‐ 1,969 214,464 142,700 477,815 ‐
Rents, leases, and misc fees 1,735,050 351,165 72,000 85,924 ‐ ‐ ‐
Interest and other misc 13,357 14,776 114,472 449,009 491,368 273,950 158
TOTAL REVENUES 1,873,419 2,061,272 13,883,902 10,505,847 16,496,300 5,907,200 158
EXPENSES:
Utility billing ‐ ‐ 129,236 109,399 98,091 153,235 ‐
Utility systems ‐ ‐ 12,271,444 2,341,697 2,089,181 1,904,616 ‐
Utility maintenance ‐ ‐ 248,546 4,026,791 11,289,543 1,521,697 ‐
Transportation 959,638 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 1,559,472 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 959,638 1,559,472 12,649,226 6,477,887 13,476,815 3,579,548 ‐
AMOUNT AVAILABLE FOR DEBT SERVICE 913,781 501,800 1,234,676 4,027,960 3,019,485 2,327,652 158
DEBT SERVICE:
Principal 88,579 21,163 ‐ 1,246,675 815,776 151,840 ‐
Interest and other debt service costs 16,625 57,742 ‐ 480,938 250,164 194,229 ‐
TOTAL DEBT SERVICE 105,204 78,905 ‐ 1,727,613 1,065,940 346,069 ‐
CAPITAL PROJECTS 464,688 172,985 ‐ 2,064,595 3,396,757 1,642,135 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ ‐ ‐ (710,774) ‐
CHANGE IN FUND BALANCE 343,889 249,910 1,234,676 235,752 (1,443,212) (371,326) 158
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, November 30, 2010 1,392,972 1,335,711 1,560,710 7,392,860 1,332,326 3,611,516 15,763
Page 10 of 35
Monthly Financial Report November 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:
Technology Fee ‐ 935 ‐ ‐ ‐ ‐ ‐
Grants ‐ 986 ‐ ‐ ‐ ‐ ‐
Charges for services
Equipment rental m&o 1,961,140 1,798,969 ‐ ‐ ‐ ‐ ‐
Telecommunications ‐ 262,004 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 98,434 ‐ 309,390 ‐ ‐ ‐
Communications ‐ ‐ ‐ 495,038 ‐ ‐ ‐
Facilities ‐ ‐ 3,828,201 ‐ ‐ ‐ ‐
Data cards and ce ll phones ‐ 103,102 ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ 229,918 ‐ ‐ ‐ ‐ ‐
Interest and other misc 58,018 18,713 2,280 917 68,049 61,034 32,341
Internal service fund misc:
Vehicle/equipment capital recovery 1,320,811 913,730 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 2,024,849 ‐ ‐
Worker's compensation / unemployment ‐ ‐ ‐ ‐ 1,276,252 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 9,463,438 1,459,611
Other misc 1,393 ‐ 2,414 ‐ 3,611 443,458 ‐
Disposal of capital assets ‐ ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 147,081 105,511 32,458
TOTAL REVENUES 3,341,362 3,426,791 3,832,895 805,345 3,519,842 10,073,441 1,524,410
EXPENSES:
Communications 438,062
Equipment rental 2,014,980
Facilities 3,793,673
Healthcare 8,730,438
Information technology 2,716,847
Print and mail 363,662
Retiree healthcare 850,739
Risk management
Risk management 1,257,971
Unemployment 368,927
Worker's compensation 1,146,546
TOTAL EXPENSES 2,014,980 2,716,847 3,793,673 801,724 2,773,444 8,730,438 850,739
AMOUNT AVAILABLE FOR CAPITAL 1,326,382 709,944 39,222 3,621 746,398 1,343,003 673,671
CAPITAL PROJECTS 696,273 392,671 25,000 29,408 ‐ ‐ ‐
TRANSFERS IN ‐ ‐ 149,990 ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 630,109 317,273 164,212 (25,787) 746,398 1,343,003 673,671
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, November 30, 2010 5,223,508 1,965,204 255,387 86,031 6,785,907 6,135,455 3,494,144
Page 11 of 35
Monthly Financial Report November 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 ‐
Other intergovernmental revenue 2,291,423
Interest and other misc 286,561
Bond proceeds ‐
Tax Credit (BABs) 837,545
TOTAL REVENUES 3,422,529
EXPENSES:
Salaries and wages 172,645
Benefits 56,043
Supplies 40,914
Professional services 1,694,520
Intergovernmental 3,090,871
Construction 42,185,797
TOTAL EXPENSES 47,240,790
AMOUNT AVAILABLE FOR DEBT SERVICE (43,818,261)
DEBT SERVICE:
Principal ‐
Interest and other debt service costs 3,439,680
TOTAL DEBT SERVICE 3,439,680
CHANGE IN FUND BALANCE (47,257,941)
BEGINNING FUND BALANCE, January 1, 2010 80,644,637
ENDING FUND BALANCE, November 30, 2010 33,386,696
Page 12 of 35
Monthly Financial Report November 2010
FUND BALANCE
Page 14 shows the ending fund balance as of November 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 November, the City has $19.3 million reported in combined general governmental fund balance of the current
year’s operating budget, which is approximately 18% of budgeted operating expenditures. This is an increase of $7.3
million from the beginning balance of January 1, 2010. November’s ending fund balance is over the anticipated General
Governmental Fund Balance of $17.4 million by $1.9 million. 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 35
Monthly Financial Report November 2010
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through November 30, 2010
Funds
Balance
01/01/2010
Budgeted
Revenue
Revenue
11/30/10
Total Funds
Available
Budgeted
Expenditure
Expenditure
11/30/10 Ending Balance
GENERAL GOVERNMENT FUNDS:11,955,285 105,584,156 98,046,101 110,001,386 106,294,348 90,731,559 19,269,827
000 General 8,535,013 74,693,168 68,494,522 77,029,535 72,750,777 63,073,467 13,956,068
001 Community Services 958,009 9,557,924 8,777,055 9,735,064 10,492,749 8,851,933 883,131
003 Street 1,391,648 7,456,240 6,895,606 8,287,254 8,549,762 7,755,682 531,572
004 Community Dev Block Grant (6,528) 532,635 342,084 335,556 532,227 413,267 (77,711)
005 Museum 64,705 192,621 193,186 257,891 194,120 175,177 82,714
006 Library 706,011 1,888,252 1,630,995 2,337,006 2,607,263 2,287,744 49,262
009 Farmers Market 60,571 44,280 47,715 108,286 34,311 29,017 79,269
010 Fire Memorial 936 ‐ 315 1,251 ‐ ‐ 1,251
011 Fire Health & Wellness 4,303 25,000 21,862 26,165 25,000 4,054 22,111
031 Pa rk Memorial 175,066 ‐ 1,800 176,866 ‐ ‐ 176,866
201 Ltd GO Bonds Gen Govt Debt 1,448 2,033,177 2,107,448 2,108,896 1,984,625 318,588 1,790,308
215 Gen Govt Misc Debt Service 64,103 9,160,859 9,533,513 9,597,616 9,123,514 7,822,630 1,774,986
SPECIAL REVENUE FUNDS:
102 Arterial Street 200,686 620,000 539,885 740,571 620,000 620,000 120,571
108 Leased City Properties 837,613 1,669,586 1,280,158 2,117,771 1,511,561 1,376,620 741,151
110 Hotel Motel 247,828 245,000 242,544 490,372 310,000 291,888 198,484
118 Reserve for Paths & Trails 3,264 ‐ 37 3,301 ‐ ‐ 3,301
125 1% For Art 143,796 35,000 14,714 158,510 50,000 15,218 143,292
127 Cable Communication 89,391 85,000 131,935 221,326 85,674 49,007 172,319
135 Springbrook Wetlands Bank 459,528 ‐ 200,695 660,223 ‐ ‐ 660,223
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 275,954 1,342,547 ‐ ‐ 1,342,547
304 Fire Mitigation 2,363,522 100,000 84,571 2,448,093 560,000 519,996 1,928,097
305 Transportation Mitigation 2,167,133 200,000 85,522 2,252,655 1,810,000 1,140,000 1,112,655
316 Municipal Facilities CIP 6,933,186 1,333,553 1,024,378 7,957,564 7,681,771 1,928,131 6,029,433
317 Transportation CIP 2,892,341 31,412,816 10,837,616 13,729,957 33,183,734 8,846,395 4,883,562
318 So Lake WA Infrastructure Proj 114,039 ‐ 928 114,967 114,000 56,471 58,496
326 Housing Opportunity 201,653 ‐ 2,061 203,714 200,000 40,000 163,714
ENTERPRISE FUNDS:
402 Airport 415,929 1,917,163 1,791,173 2,207,102 1,001,800 959,638 1,247,464
403 Solid Waste Utility 326,034 15,027,000 13,883,901 14,209,935 15,037,130 12,649,226 1,560,709
404 Golf Course 798,278 2,483,545 2,059,283 2,857,561 2,566,837 1,830,851 1,026,710
422 Airport Capital 633,154 1,578,000 82,246 715,400 1,831,485 569,891 145,509
424 Golf Course Capital 287,523 150,000 151,988 439,511 302,499 130,510 309,001
INTERNAL SERVICE FUNDS:
501 Equipment Repair/Replacement 4,593,399 3,631,241 3,341,362 7,934,761 3,414,047 2,711,253 5,223,508
502 Insurance 6,039,509 3,287,584 3,519,842 9,559,351 4,170,106 2,773,443 6,785,908
503 Information Services 1,647,931 4,194,774 3,426,791 5,074,722 4,841,706 3,109,518 1,965,204
504 Facilities 91,175 4,705,475 3,982,885 4,074,060 4,326,200 3,818,673 255,387
505 Communications 111,818 1,049,671 805,345 917,163 877,560 831,132 86,031
512 Insurance, Healthcare 4,792,452 12,358,471 10,073,441 14,865,893 12,462,810 8,730,438 6,135,455
522 Insurance, Leoff1 Retirees HC 2,820,473 2,235,684 1,524,409 4,344,882 2,248,907 850,739 3,494,143
FIDUCIARY FUNDS:
611 Firemen's Pension 4,332,817 300,000 318,005 4,650,822 550,475 339,274 4,311,548
Funds
Balance
01/01/2010
Budgeted
Revenue
Revenue
11/30/10
Total Funds
Available
Budgeted
Expenditure
Expenditure
11/30/10 Ending Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 13,931,093 45,033,520 34,109,505 48,040,598 51,412,468 35,688,131 12,352,467
405 Water Utility 4,294,833 11,316,910 10,292,328 14,587,161 11,712,205 8,221,579 6,365,582
406 Waste Water Utility 1,887,815 6,065,737 5,285,302 7,173,117 6,837,864 5,639,014 1,534,103
407 Surface Water Utility 2,448,845 5,788,148 5,165,802 7,614,647 6,695,464 3,925,616 3,689,031
416 King County Metro 46,504 11,211,935 10,755,850 10,802,354 11,211,935 10,103,740 698,614
425 Water Utility Construction 2,862,275 3,460,000 213,519 3,075,794 5,510,000 2,048,516 1,027,278
426 Waste Water Construction 841,219 3,153,781 1,655,148 2,496,367 3,995,000 3,396,757 (900,390)
427 Surface Water Construction 1,533,997 4,037,009 741,398 2,275,395 5,450,000 2,352,909 (77,514)
461 Waterworks Bond Reserve ‐ ‐ ‐ ‐ ‐ ‐ ‐
471 Waterworks Rate Stabilization 15,605 ‐ 158 15,763 ‐ ‐ 15,763
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 35
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 71,408,888 76,025,654 (4,616,767) 7,338,518
October 83,848,462 83,169,404 679,058 12,634,343
November 98,046,101 90,731,559 7,314,542 19,269,827
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 35
City of Renton
Monthly Revenue Analysis ‐ 2010 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 4,901,598 4,881,556 ‐0.41%
Feb 11,015,425 10,472,029 ‐4.93%
Mar 16,604,575 15,590,071 ‐6.11%
Apr 29,697,444 27,747,760 ‐6.57%
May 48,814,541 48,191,829 ‐1.28%
Jun 56,141,918 55,079,253 ‐1.89%
Jul 61,619,393 60,897,449 ‐1.17%
Aug 67,543,287 66,585,570 ‐1.42%
Sep 72,338,363 71,408,888 ‐1.28%
Oct 83,773,923 83,848,462 0.09%
Nov 99,107,011 98,046,101 ‐1.07%
Dec 105,584,156
Percent of budget 92.86%
Property Tax Budget
YTD
Actual
Annual %
over (under)
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
Millions
Total Revenue
General Government
Budget
Actual
Last Year
$30
$33
Millions Property Tax
Budget
Actual
py g ()
Jan 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 17,278,401 3.81%
Oct 22,547,053 24,338,474 7.95%
Nov 31,012,799 31,626,558 1.98%
Dec 31,364,643
Percent of budget 100.84%
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
Millions Total Revenue
General Government
Budget
Actual
Last Year
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
Millions Property Tax
Budget
Actual
Last Year
Page 16 of 35
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 14,350,473 ‐8.18%
Oct 17,436,835 15,969,376 ‐8.42%
Nov 18,929,142 17,656,063 ‐6.73%
Dec 20,857,000
Percent of budget 84.65%
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 10,944,931 1.71%
Oct 11,813,935 12,083,388 2.28%
Nov 12,878,332 13,195,997 2.47%
Dec 14,228,000
Percent of budget 92.75%
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 35
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 1,761,961 0.16%
Oct 2,024,220 1,975,179 ‐2.42%
Nov 2,153,967 2,117,026 ‐1.72%
Dec 2,386,376
Percent of budget 88.71%
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 371,847 371,847 0.00%
Feb 1,023,691 1,023,691 0.00%
Mar 1,536,757 1,536,757 0.00%
Apr 2,128,407 2,128,407 0.00%
May 2,963,839 2,963,839 0.00%
Jun 5,426,368 5,426,368 0.00%
Jul 5,897,632 5,897,632 0.00%
Aug 6,543,985 6,543,985 0.00%
Sep 7,081,151 7,081,151 0.00%
Oct 7,809,560 7,809,560 0.00%
Nov 10,733,543 10,733,543 0.00%
Dec 11,804,803
Percent of budget 90.93%
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 35
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 4,791,514 ‐2.86%
Oct 5,419,322 5,288,635 ‐2.41%
Nov 5,880,908 5,671,266 ‐3.56%
Dec 6,425,185
Percent of budget 88.27%
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 260,504 239,080 ‐8.22%
Feb 534,119 467,413 ‐12.49%
Mar 880,487 746,724 ‐15.19%
Apr 1,188,597 1,041,335 ‐12.39%
May 1,477,369 1,317,878 ‐10.80%
Jun 1,785,647 1,691,502 ‐5.27%
Jul 2,106,126 1,947,727 ‐7.52%
Aug 2,342,895 2,267,132 ‐3.23%
Sep 2,591,825 2,500,251 ‐3.53%
Oct 2,889,084 2,768,039 ‐4.19%
Nov 3,234,625 3,082,783 ‐4.69%
Dec 3,577,193
Percent of budget 86.18%
$‐
$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 35
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 4,349,606 ‐5.12%
Oct 5,408,386 5,191,983 ‐4.00%
Nov 5,791,753 5,482,767 ‐5.33%
Dec 6,297,095
Percent of budget 87.07%
Misc Budget
YTD
Actual
Annual %
over (under)$1.60
Millions Miscellaneous
Budget
Al
$0
$1
$2
$3
$4
$5
$6
$7
Millions Other Taxes
Budget
Actual
Last Year
g ()
Jan 127,631 170,998 33.98%
Feb 309,517 257,122 ‐16.93%
Mar 374,682 372,244 ‐0.65%
Apr 467,795 471,619 0.82%
May 607,314 573,528 ‐5.56%
Jun 705,404 721,867 2.33%
Jul 894,399 880,001 ‐1.61%
Aug 973,887 973,082 ‐0.08%
Sep 1,088,937 1,083,891 ‐0.46%
Oct 1,158,609 1,156,910 ‐0.15%
Nov 1,224,926 1,213,085 ‐0.97%
Dec 1,377,980
Percent of budget 88.03%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
Millions Miscellaneous
Budget
Actual
Last Year
$0
$1
$2
$3
$4
$5
$6
$7
Millions Other Taxes
Budget
Actual
Last Year
Page 20 of 35
City of Renton
Monthly Revenue Analysis ‐ 2010 Budget Year
Other
Financing Budget
YTD
Actual
Annual %
over (under)
Jan 727 ‐ 0.00%
Feb 105 105 0.00%
Mar 138 138 0.00%
Apr 245 245 0.00%
May 6,613,769 6,613,769 0.00%
Jun 6,614,434 6,614,434 0.00%
Jul 6,614,088 6,614,088 0.00%
Aug 7,266,578 7,266,578 0.00%
Sep 7,266,711 7,266,711 0.00%
Oct 7,266,920 7,266,920 0.00%
Nov 7,267,015 7,267,015 0.00%
Dec 7,265,881
Percent of budget 100.02%
REET Budget
YTD
Actual
Annual %
over (under)
$2.50
Millions Real Estate Excise Tax
Budget
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
$7.00
$8.00
Millions Other Financing Sources
Budget
Actual
Last Year
g ()
Jan 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 1,660,140 ‐10.29%
Oct 2,058,960 1,843,473 ‐10.47%
Nov 2,279,304 2,046,564 ‐10.21%
Dec 2,400,000
Percent of budget 85.27%
Note: Combines Funds 201, 215, 316, and 318
$0.00
$0.50
$1.00
$1.50
$2.00
$2.50
Millions Real Estate Excise Tax
Budget
Actual
Last Year
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
$7.00
$8.00
Millions Other Financing Sources
Budget
Actual
Last Year
Page 21 of 35
City of Renton
Monthly Expenditure Analysis ‐ 2010 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,273,691 7,161,528 ‐1.54%
Feb 15,442,680 15,011,456 ‐2.79%
Mar 23,129,139 22,695,538 ‐1.87%
Apr 30,707,378 29,817,438 ‐2.90%
May 45,202,677 43,949,015 ‐2.77%
Jun 53,492,544 52,299,100 ‐2.23%
Jul 62,152,697 60,400,225 ‐2.82%
Aug 70,248,670 68,336,283 ‐2.72%
Sep 78,117,501 76,025,654 ‐2.68%
Oct 86,123,086 83,169,404 ‐3.43%
Nov 94,177,200 90,731,559 ‐3.66%
Dec 106,294,349
Percent of budget expended 85.36%
Legislative Budget
YTD
Actual
Annual %
over (under)
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
Millions
Total Expenditures
General Government
Budget
Actual
Last Year
$300,000
Legislative
Budget
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 195,351 ‐3.52%
Oct 224,540 214,315 ‐4.55%
Nov 246,799 236,316 ‐4.25%
Dec 267,957
Percent of budget expended 88.19%
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
Millions
Total Expenditures
General Government
Budget
Actual
Last Year
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
Legislative
Budget
Actual
Last Year
Page 22 of 35
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 1,510,390 0.11%
Oct 1,677,249 1,657,900 ‐1.15%
Nov 1,836,905 1,825,471 ‐0.62%
Dec 2,016,361
Percent of budget expended 90.53%
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 1,198,078 ‐2.26%
Oct 1,370,153 1,322,666 ‐3.47%
Nov 1,499,437 1,450,539 ‐3.26%
Dec 1,635,047
Percent of budget expended 88.72%
$‐
$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 35
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 1,420,711 ‐16.47%
Oct 1,832,622 1,562,272 ‐14.75%
Nov 2,006,095 1,712,099 ‐14.66%
Dec 2,164,890
Percent of budget expended 79.08%
City Attorney Budget
YTD
Actual
Annual %
over (under)
$1.60
$1.80
Millions City Attorney
Budget
At l
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
$2.00
$2.20
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 1,190,659 ‐4.36%
Oct 1,384,635 1,306,058 ‐5.67%
Nov 1,520,418 1,432,643 ‐5.77%
Dec 1,621,295
Percent of budget expended 88.36%
$‐
$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.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
$2.00
$2.20
Millions Finance
Budget
Actual
Last Year
Page 24 of 35
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 650,356 ‐6.74%
Oct 773,457 710,580 ‐8.13%
Nov 845,873 772,857 ‐8.63%
Dec 918,169
Percent of budget expended 84.17%
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.00
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 389,451 ‐1.32%
Oct 441,919 429,145 ‐2.89%
Nov 483,769 471,654 ‐2.50%
Dec 518,399
Percent of budget expended 90.98%
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.20
$0.40
$0.60
$0.80
$1.00
Millions Public Works
Budget
Actual
Last Year
Page 25 of 35
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 2,583,527 ‐22.47%
Oct 3,741,593 2,784,616 ‐25.58%
Nov 4,083,716 2,890,028 ‐29.23%
Dec 4,792,981
Percent of budget expended 60.30%
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 20,577,677 0.08%
Oct 22,762,743 22,423,952 ‐1.49%
Nov 25,377,250 24,919,572 ‐1.80%
Dec 28,022,582
Percent of budget expended 88.93%
$‐
$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 35
City of Renton
Monthly Expenditure Analysis ‐ 2010 Budget Year
Fire & Emerg
Svc Budget
YTD
Actual
Annual %
over (under)
Jan 1,838,304 1,768,398 ‐3.80%
Feb 4,052,252 4,239,777 4.63%
Mar 5,756,484 5,943,458 3.25%
Apr 7,466,012 7,607,800 1.90%
May 9,173,406 9,312,143 1.51%
Jun 10,975,448 11,038,448 0.57%
Jul 12,792,783 12,790,432 ‐0.02%
Aug 14,560,495 14,548,321 ‐0.08%
Sep 16,397,404 16,288,868 ‐0.66%
Oct 18,085,144 17,883,348 ‐1.12%
Nov 19,884,908 19,761,222 ‐0.62%
Dec 21,922,009
Percent of budget expended 90.14%
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 553,461 ‐23.46%
Oct 781,484 685,906 ‐12.23%
Nov 843,676 735,170 ‐12.86%
Dec 931,014
Percent of budget expended 78.96%
$‐
$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 35
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 552,661 ‐3.01%
Oct 693,393 640,780 ‐7.59%
Nov 748,914 710,301 ‐5.16%
Dec 874,359
Percent of budget expended 81.24%
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 131,145 ‐12.74%
Oct 166,956 144,975 ‐13.17%
Nov 183,659 159,823 ‐12.98%
Dec 200,440
Percent of budget expended 79.74%
$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 35
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 5,005,024 ‐1.76%
Oct 5,674,356 5,510,153 ‐2.89%
Nov 6,234,493 5,995,770 ‐3.83%
Dec 6,865,275
Percent of budget expended 87.33%
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 52,247,359 ‐2.14%
Oct 59,166,024 57,276,666 ‐3.19%
Nov 65,394,946 63,073,467 ‐3.55%
Dec 72,750,777
Percent of budget expended 86.70%
$‐
$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 35
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 7,315,110 ‐6.37%
Oct 8,658,616 8,057,325 ‐6.94%
Nov 9,532,347 8,851,933 ‐7.14%
Dec 10,492,749
Percent of budget expended 84.36%
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 6,313,022 0.27%
Oct 7,009,949 7,077,725 0.97%
Nov 7,716,929 7,755,682 0.50%
Dec 8,549,762
Percent of budget expended 90.71%
$‐
$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 35
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 332,974 ‐10.21%
Oct 429,422 374,878 ‐12.70%
Nov 467,929 413,267 ‐11.68%
Dec 532,227
Percent of budget expended 77.65%
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 173,794 173,794 0.00%
Feb 229,125 229,125 0.00%
Mar 500,663 500,663 0.00%
Apr 505,911 505,911 0.00%
May 1,067,015 1,067,015 0.00%
Jun 1,067,015 1,067,015 0.00%
Jul 1,628,119 1,628,119 0.00%
Aug 1,628,119 1,628,119 0.00%
Sep 1,721,320 1,721,320 0.00%
Oct 2,280,221 2,280,221 0.00%
Nov 2,287,744 2,287,744 0.00%
Dec 2,607,263
Percent of budget expended 87.75%
$‐
$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 35
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 143,470 ‐3.30%
Oct 164,641 159,284 ‐3.25%
Nov 180,555 175,177 ‐2.98%
Dec 194,120
Percent of budget expended 90.24%
Note: Prior to 2009, Museum was part of the Library Fund
Farmer's
Market Fund Budget
YTD
Actual
Annual %
over (under)
$‐
$20,000
$40,000
$60,000
$80,000
$100,000
$120,000
$140,000
$160,000
$180,000
$200,000
Museum Fund
Budget
Actual
Last Year
$30 000
$35,000
Farmer's Market Fund
Budget
At l
g ()
Jan 682 56 ‐91.83%
Feb 1,530 462 ‐69.84%
Mar 2,581 1,308 ‐49.32%
Apr 3,794 1,665 ‐56.11%
May 6,315 2,277 ‐63.95%
Jun 11,385 19,122 67.96%
Jul 17,724 24,521 38.35%
Aug 23,587 28,913 22.58%
Sep 25,232 33,200 31.58%
Oct 28,890 23,602 ‐18.30%
Nov 29,897 29,017 ‐2.95%
Dec 34,311
Percent of budget expended 84.57%
$‐
$20,000
$40,000
$60,000
$80,000
$100,000
$120,000
$140,000
$160,000
$180,000
$200,000
Museum Fund
Budget
Actual
Last Year
$‐
$5,000
$10,000
$15,000
$20,000
$25,000
$30,000
$35,000
Farmer's Market Fund
Budget
Actual
Last Year
Page 32 of 35
City of Renton
Monthly Expenditure Analysis ‐ 2010 Budget Year
Health &
Wellness Budget
YTD
Actual
Annual %
over (under)
Jan 873 ‐ 0.00%
Feb 1,756 ‐ 0.00%
Mar 2,240 ‐ 0.00%
Apr 21,725 ‐ 0.00%
May 21,870 ‐ 0.00%
Jun 21,870 600 ‐97.26%
Jul 22,616 1,180 ‐94.78%
Aug 22,616 1,770 ‐92.17%
Sep 23,034 2,191 ‐90.49%
Oct 24,096 2,696 ‐88.81%
Nov 24,669 4,054 ‐83.57%
Dec 25,000
Percent of budget expended 16.21%
LTGO Funds Budget
YTD
Actual
Annual %
over (under)
$11.00
$12.00
Millions LTGO Funds
Budget
Actual
$‐
$5,000
$10,000
$15,000
$20,000
$25,000
$30,000
$35,000
$40,000
$45,000
Fire Health & Wellness Fund
Budget
Actual
Last Year
g ()
Jan ‐ ‐ N/A
Feb 126,390 126,390 0.00%
Mar 126,390 126,390 0.00%
Apr 126,471 126,471 0.00%
May 6,739,665 6,739,665 0.00%
Jun 7,540,445 7,540,445 0.00%
Jul 7,540,445 7,540,445 0.00%
Aug 7,917,008 7,917,008 0.00%
Sep 7,917,008 7,917,008 0.00%
Oct 7,917,008 7,917,008 0.00%
Nov 8,141,218 8,141,218 0.00%
Dec 11,108,139
Percent of budget expended 73.29%
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
$7.00
$8.00
$9.00
$10.00
$11.00
$12.00
Millions LTGO Funds
Budget
Actual
Last Year
$‐
$5,000
$10,000
$15,000
$20,000
$25,000
$30,000
$35,000
$40,000
$45,000
Fire Health & Wellness Fund
Budget
Actual
Last Year
Page 33 of 35
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 36,506,420 32,642,468
Oct 36,734,374 40,859,646 36,031,261
Nov 40,547,974 45,383,184 39,339,175
Dec 45,924,856
Percent of budget expended 85.66%
Note: Operations only, excludes bond proceeds and transfers to capital.
Airport Budget Revenue Expense
$0
$5
$10
$15
$20
$25
$30
$35
$40
$45
$50
Millions Utilities
Budget
Revenue
Expense
$1.80
$2.00
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 1,343,124 790,707
Oct 838,546 1,565,756 869,630
Nov 913,982 1,791,173 959,638
Dec 1,001,800
Percent of budget expended 95.79%
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
$1.60
$1.80
$2.00
Millions Airport
Budget
Revenue
Expense
Page 34 of 35
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 1,845,213 1,432,398
Oct 1,857,389 1,992,703 1,563,528
Nov 1,994,766 2,059,283 1,830,851
Dec 2,566,837
Percent of budget expended 71.33%
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 35 of 35