HomeMy WebLinkAbout201007, July.pdfFINANCE AND
INFORMATION TECHNOLOGY
M E M O R A N D U M
DATE: September 7, 2010
TO: Don Persson, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Iwen Wang, FIT Administrator
SUBJECT: July 2010 Financial Status Report
At the end of July, general governmental revenues show $448k or 0.7% under budget. This
includes a $317k 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
$765k or 1.2% 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.45 million. Similarly we
expect gambling tax to underperform the budget by $500k; court fines by $300k; real estate
excise tax by $200k, and recreation fees by $150k. This is a combined $2.6 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.4% or $1.5 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 payment 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 think 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 14,275,513 30,660,522 15,953,970 31,364,643 16,320,354 16,637,599 317,245 1.9%
Sales Tax 20,825,055 11,596,885 17,995,836 10,477,006 18,609,000 10,601,947 9,959,476 (642,471) ‐6.1%
Sales Tax ‐ Annexation Credit ‐ ‐ 2,132,110 1,236,994 2,248,000 1,304,231 1,171,816 (132,415) ‐10.2%
Criminal Justice Sales Tax 1,755,469 961,095 1,650,350 950,096 1,743,000 1,003,434 924,177 (79,257) ‐7.9%
Natural Gas Use Tax 253,377 162,939 242,891 124,780 ‐ ‐ 155,964 155,964 100.0%
Admission Tax 197,740 149,716 260,269 189,020 260,000 188,824 217,379 28,555 15.1%
Franchise Fees 998,288 660,113 1,039,031 779,233 1,040,000 734,749 881,269 146,520 19.9%
Electricity Tax 4,580,037 2,701,338 4,963,151 3,034,909 5,150,000 3,149,165 2,984,864 (164,301) ‐5.2%
Gas Tax 1,565,810 1,099,526 1,891,255 1,438,989 1,858,000 1,413,687 1,077,147 (336,540) ‐23.8%
Transfer Station 380,961 193,333 283,985 134,590 230,000 109,005 131,906 22,901 21.0%
TV Cable 1,073,168 514,605 1,263,743 727,404 1,250,000 719,494 782,859 63,365 8.8%
Telephone 1,032,048 601,900 1,037,873 585,115 960,000 541,213 604,440 63,227 11.7%
Cellular Phone 1,748,147 976,033 2,027,473 1,113,852 1,900,000 1,043,821 1,388,254 344,433 33.0%
City Utilities 2,606,786 1,424,909 2,871,599 1,599,625 2,880,000 1,604,304 1,605,573 1,268 0.1%
Leasehold Excise Tax 190,644 53,288 146,002 57,477 100,000 39,367 65,359 25,992 66.0%
Gambling Excise Tax 2,157,029 1,073,512 2,141,720 1,296,309 2,000,000 1,210,531 934,866 (275,665) ‐22.8%
Real Estate Excise Tax 2,800,103 1,795,369 2,418,456 1,346,171 2,400,000 1,335,888 1,327,717 (8,171) ‐0.6%
Less: Municipal Facilities CIP REET (450,103) (897,684) (1,000,000) (642,223) (400,000) (256,889) (222,573) 34,317 ‐13.4%
EMS Levy 890,998 85,744 1,170,657 682,883 897,095 580,473 580,473 ‐ 0.0%
Business License Fees 485,537 273,818 424,413 295,525 463,067 322,440 304,514 (17,926) ‐5.6%
Other Licenses and Permits 257,477 162,670 176,851 91,258 157,250 81,144 126,421 45,277 55.8%
Building Permits 2,034,225 1,580,787 1,683,082 1,002,343 1,766,059 1,051,759 1,013,874 (37,884) ‐3.6%
Intergovernmental (Grants, etc)3,734,887 1,627,788 3,820,932 2,363,458 4,355,523 2,465,483 2,465,483 ‐ 0.0%
Fire District 25 and 40 Contracts 5,013,549 775,262 5,869,198 2,338,225 5,554,723 2,507,971 2,507,971 ‐ 0.0%
Records, Duplicating, and Passport Fees 176,950 115,868 187,721 99,249 217,585 115,038 122,155 7,117 6.2%
Public Safety 524,565 323,122 521,484 331,565 430,000 273,398 268,934 (4,464) ‐1.6%
Development Service Fees 903,768 573,215 677,955 359,158 696,708 369,093 578,052 208,959 56.6%
Culture and Recreation 1,678,818 1,131,649 1,631,486 1,089,561 1,572,240 1,049,995 936,938 (113,057) ‐10.8%
Interfund/Interdept‐Services 3,072,950 1,697,411 3,225,745 1,880,391 3,080,927 1,795,972 1,922,398 126,426 7.0%
Fines and Forfeits 2,110,973 659,685 1,448,878 806,301 1,327,193 738,583 769,617 31,034 4.2%
Photo Enforcement ‐ ‐ 2,368,131 1,424,667 2,250,000 1,353,600 1,178,110 (175,490) ‐13.0%
Interests and Other Earnings 735,910 548,202 535,314 354,535 434,300 287,634 206,357 (81,278) ‐28.3%
Rents, Leases, and Concessions 676,919 467,601 677,960 473,429 720,780 503,331 519,731 16,401 3.3%
Contributions and Donations 175,513 126,489 150,406 692,498 111,900 89,610 89,610 ‐ 0.0%
Other Miscellaneous 67,355 57,896 168,567 53,392 262,557 83,162 65,235 (17,927) ‐21.6%
Refunding Debt and Premiums ‐ ‐ ‐ ‐ ‐ 6,613,484 6,613,484 ‐ 0.0%
Transfer‐In 381,364 66,541 577,004 ‐ 652,398 ‐ ‐ ‐ 0.0%
Total Operating Revenues 93,687,106 47,616,137 97,342,052 54,741,756 98,542,948 61,345,296 60,897,449 (447,847) ‐0.7%
OPERATING EXPENDITURES
Legislative 245,441 146,194 247,225 145,176 267,957 158,474 152,284 6,190 3.9%
City Attorney 1,661,225 1,082,293 1,248,380 763,989 1,621,295 1,028,789 929,609 99,179 9.6%
City Clerk 604,844 387,862 646,581 422,821 931,014 603,119 459,511 143,608 23.8%
Court Services 1,744,122 985,510 1,819,731 1,088,594 2,016,361 1,173,489 1,168,151 5,339 0.5%
Executive 966,373 549,713 1,499,747 861,218 1,635,047 935,453 933,696 1,757 0.2%
Hearing Examiner 166,820 96,367 171,911 101,577 200,440 117,131 101,724 15,407 13.2%
Community and Eco Dvlpmnt Admin ‐ ‐ 265,269 158,841 696,149 416,848 340,807 76,041 18.2%
Development Services 4,178,096 2,336,374 3,615,129 2,179,573 2,985,683 1,800,077 1,733,782 66,295 3.7%
Economic Development 1,875,749 1,087,040 1,244,175 739,134 1,323,047 774,414 739,968 34,447 4.4%
Planning ‐ ‐ 1,525,460 802,336 1,661,732 969,344 982,457 (13,113) ‐1.4%
Finance 1,909,652 1,117,868 1,969,936 1,288,066 2,164,890 1,342,561 1,076,383 266,178 19.8%
Human Resources 981,306 607,959 853,063 486,144 918,169 547,639 505,205 42,433 7.7%
Police 23,894,898 13,512,057 25,833,756 14,801,142 28,022,582 15,954,764 15,859,503 95,261 0.6%
Fire 21,763,640 12,315,573 20,375,286 12,219,385 21,922,009 12,763,866 12,790,432 (26,566) ‐0.2%
Facilities 3,614,850 2,069,463 ‐ (242) ‐ ‐ ‐ ‐ 0.0%
Parks 4,892,441 2,507,005 4,820,336 2,487,766 4,569,001 2,349,597 2,172,070 177,528 7.6%
Parks Planning & Natural Resources ‐ ‐ ‐ ‐ 545,943 318,467 241,477 76,990 24.2%
Recreation 4,383,163 2,486,414 7,878,458 4,579,066 4,970,795 2,864,307 2,724,751 139,556 4.9%
Human Services 1,162,553 616,678 1,194,142 653,513 1,406,586 758,109 748,040 10,070 1.3%
Community Resources & Events 367,627 184,970 348,185 185,060 375,694 194,210 186,433 7,777 4.0%
Library 1,890,886 1,083,455 2,312,128 1,182,074 2,544,263 1,628,119 1,628,119 ‐ 0.0%
Museum 136,327 81,119 140,801 84,455 194,120 115,980 111,161 4,819 4.2%
Public Works Administration 886,867 544,586 463,533 278,733 518,399 316,060 302,033 14,027 4.4%
Street Maintenance 3,212,111 1,732,165 3,794,716 2,324,503 3,379,080 1,956,349 1,915,110 41,239 2.1%
Technical Services 515,708 299,565 478,493 273,421 ‐ ‐ ‐ ‐ 0.0%
Transportation 4,841,955 2,545,225 5,110,639 2,930,438 5,164,058 2,961,068 2,911,581 49,487 1.7%
Debt Service 4,263,739 1,049,799 4,176,822 975,344 4,494,945 927,251 927,251 ‐ 0.0%
Payment of LTGO Refunding Debt ‐ ‐ ‐ ‐ ‐ 6,613,194 6,613,194 ‐ 0.0%
Non‐Departmental and Other 5,011,007 2,674,534 5,169,426 2,288,887 4,817,981 2,348,983 2,145,494 203,489 8.7%
Total Operating Expenditures 95,171,399 52,099,787 97,203,328 54,301,012 99,347,239 61,937,662 60,400,225 1,537,437 2.5%
Total Ending Fund Balance 11,816,561$ 8,817,204$ 11,955,285$ 12,257,305$ 11,150,994$ 11,362,919$ 12,452,510$ 1,089,591 9.6%
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 July 2010
Page 1 of 34
Monthly Financial Report July 2010
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through July 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 66% of all resources supporting general governmental activities. The following section provides detail
information on property, sales, utility, and other taxes.
Property Tax
July’s collection is $88k, making
the total year‐to‐date collection
$16.6 million or 53% of the total
budget. In comparison to the
previous year, the City collected
$684k or 4% higher. Compared to
the budget, the City is above
projections by $317k or 2%.
Based on distribution we have
received in July, we are projecting
property tax collections to meet
the projections at year end.
Sales Tax
July 2010 sales tax receipts totaled $1.3
million. Compared to the same month
last year, it is $134k or 9% less.
Compared to the projected current
month’s budget, it is below projections
by $238k or 15%. The year‐to‐date
collection is $10 million or 54% of the
sales tax budget. This is $518k less
than last year and $642k below budget.
We also have received August’s tax
distributions of $1.47 million, which is
5% below last year and 12% below
budget. Based on the year‐to‐date
collection, the City is projecting sales
tax revenues to be $17.15 million by
the end of 2010, $1.45 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
Sep 250,296 256,044
Oct 5,770,027 5,902,536
Nov 8,275,695 8,465,747
Dec 343,945 351,844
YTD Total 15,953,970$ 16,320,354$ 16,637,599$ 683,629$ 4% 317,245$ 2%
Annual Total 30,660,522$ 31,364,643$
Property Tax Revenues
Year to Date through July
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 ‐
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 10,477,006$ 10,601,947$ 9,959,476$ (517,530)$ ‐5% (642,471)$ ‐6%
Annual Total 17,995,836$ 18,609,000$
2010 vs. Budget2010 vs. 2009
Month
Year to Date through July
Local Retail Sales Tax Revenues
Page 2 of 34
Monthly Financial Report July 2010
The following table breaks out the City’s base sales tax (excluding Criminal Justice and Annexation Credit) by major business
sectors:
Sales Tax by Sector 2008 2009 2010 Bgt YTD Act Chg 10/09 10Act vs Bgt
New Construction 2,889,552$ 1,814,968$ 1,576,417$ 1,311,091$ (503,877)$ ‐28% $ (265,326)‐17%
Auto Sales 2,169,261 1,752,082 1,914,693 1,735,400 (16,682) ‐1% (179,293)‐9%
General Retail 3,498,337 3,437,672 3,500,477 3,480,662 42,990 1% (19,815)‐1%
Manufacturing 605,045 632,746 559,978 443,404 (189,342) ‐30% (116,574)‐21%
Wholesale 676,792 526,793 573,259 541,654 14,862 3% (31,605)‐6%
Service 2,208,819 2,065,986 2,154,063 2,134,238 68,252 3% (19,825)‐1%
Other 240,263 246,761 323,061 313,028 66,267 27% (10,033)‐3%
Total 12,288,069$ 10,477,007$ 10,601,947$ 9,959,476$ (517,531) ‐5%(642,471)$ ‐6%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility tax
July utility taxes revenue totals $1.1
million, which is $130k higher than the
same month last year and ahead of the
budget by $154k. The year‐to‐date
collection of $8.7 million is above the
budget by $184k or 2% but is $28k
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 2,701,338 3,034,909 3,093,561 2,984,864 ‐2%‐4%
Natural Gas 1,262,465 1,563,769 1,116,085 1,233,111 ‐21% 10%
Cell 976,033 1,113,852 1,141,314 1,388,254 25% 22%
Phone 601,900 585,115 576,664 604,440 3% 5%
Cable 514,605 727,404 750,864 782,859 8% 4%
Transfer Station 193,333 134,590 138,159 131,906 ‐2%‐5%
City Utilities 1,424,909 1,599,625 1,729,991 1,605,573 0%‐7%
YTD Total 7,674,582 8,759,264 8,546,637 8,731,006 0%2%
Annual Total 13,240,334 14,581,971 14,228,000
YTD as % of 58% 60% 60%
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
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 8,759,264$ 8,546,637$ 8,731,006$ (28,258)$ 0% 184,369$ 2%
Annual Total 14,581,971$ 14,228,000$
2010 vs. Budget2010 vs. 2009
Year to Date through July
Utility Tax Revenues
Month
Page 3 of 34
Monthly Financial Report July 2010
Other Taxes
Real Estate Excise Tax
The City collected $150k in Real Estate
Excise Tax revenues (REET) in July. This
is $51k below current month’s budget
and $52k behind the same month last
year. Year‐to‐date collection of $1.3
million is $8k or 1% behind the budget
and is also $18k or 1% 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
July’s Gambling Tax collections
total $126k. Year‐to‐date total of
$935k is $361k or 28% below the
year before; and $276k or 23%
below budget.
The lower tax collection is due to
cross‐the‐board reduction in
gambling activities. Pull tabs
overall reduced by 25%, partially
due to the change in business at
Cascade Lanes; and card‐rooms are
seeing over 30% lower in activities.
Because of these changes, the City
is anticipating around $455k 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 $881k. This is $147k
or 20% above the projected year‐
to‐date budget and $102k or 13%
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
Sep 208,046 206,472
Oct 209,975 208,368
Nov 222,052 220,344
Dec 121,614 120,696
YTD Total 1,346,171$ 1,335,888$ 1,327,717$ (18,454)$ ‐1% (8,171)$ ‐1%
Annual Total 2,418,456$ 2,400,000$
Real Estate Excise Tax Revenues
Year to Date through July
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 ‐
Sep 173,745 162,248 ‐
Oct 176,490 164,811 ‐
Nov 146,960 137,236 ‐
Dec 137,979 128,849 ‐
YTD Total 1,296,309$ 1,210,531$ 934,866$ (361,444)$ ‐28% (275,665)$ ‐23%
Annual Total 2,141,720$ 2,000,000$
Gambling Tax Revenue
Month
Year to Date through July
2010 vs. 2009 2010 vs. Budget
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 259,792$ 255,537$ 45,703$ (214,089)$ ‐82% (209,834)$ ‐82%
Feb 200 102 274,776 274,576 137288% 274,674 269037%
Mar ‐ ‐ ‐
Apr ‐ 102,746 274,268 274,268 100% 171,521 167%
May 258,593 132,005 ‐ (258,593) (132,005)
Jun ‐ ‐ ‐
Jul 260,647 244,359 286,523 25,876 10% 42,164 17%
Aug ‐ ‐ ‐
Sep ‐ 24,721 ‐
Oct 259,798 258,846 ‐
Nov ‐ ‐ ‐
Dec ‐ 21,683 ‐
YTD Total 779,233$ 734,749$ 881,269$ 102,037$ 13% 146,520$ 20%
Annual Total 1,039,031$ 1,040,000$
Franchise Fees Revenue
Year to Date through July
Month
2010 vs. 2009 2010 vs. Budget
Page 4 of 34
Monthly Financial Report July 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 July, we
have collected 61% of the projected revenue from licenses and permits. Licenses and Permits totaled $1.4 million by the
end of July, which is $6k less that the budget. The following sections provide detail information for Building Permits and
Business Licenses revenues.
Building Permits and Fees revenues
totaled $137k in July. 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 $912k is $43k or 4% less than the
budget but is $23k or 3% higher than
2009. The City is projecting building
permits and fees to be under the 2010
budget by $72k.
Business Licenses totaled $305k since the start of
the year, which is 3% 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 $18k but $9k above last year.
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 ‐
Sep 101,087 108,631 ‐
Oct 131,899 141,742 ‐
Nov 82,516 88,674 ‐
Dec 169,581 182,237 ‐
YTD Total 889,072$ 955,423$ 912,439$ 23,367$ 3% (42,984)$ ‐4%
Annual Total 1,493,593$ 1,605,059$
Building Permits and Fees
Year to Date through July
2010 vs. Budget2010 vs. 2009
Month
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,379$ 28,359$ 15% 25,088$ 13%
Annual Total 260,269$ 260,000$
Year to Date through July
Month
2010 vs. 2009 2010 vs . Budget
Admission Tax Revenue
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 ‐
Sep 1,746 1,905 ‐
Oct 84,002 91,653 ‐
Nov 18,937 20,662 ‐
Dec 3,922 4,279 ‐
YTD Total 295,525$ 322,440$ 304,514$ 8,989$ 3% (17,926)$ ‐6%
Annual Total 424,413$ 463,067$
Business Licenses
Month
Year to Date through July
2010 vs. Budget2010 vs. 2009
Page 5 of 34
Monthly Financial Report July 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
$5.9 million or 50% 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.4 million since the start
of 2010. Compared to the
projected budget, State Shared
Revenues are above by $85k or 4%.
Compared to the prior year, the
City is collecting $76k 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). Liquor profits appears
to be over budget by $207k and
liquor excise taxes appear to be under budget by $139k, but this is not the case. In 2009, the June payment for liquor
profits was inadvertently recorded in the liquor excise tax account. This error was not fixed until August and until then, the
2010 year‐to‐date budget will be distorted. Had this error not occurred, liquor profits would be $55k or 19% above
projections and liquor excise taxes would be $8k or 3% above projections.
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 $3.8 million or 64% of
the budget. This is 6% above budget projections. The following sections provide detail information for Plan Review with
Inspection Fees, Recreation, and Interfund Services.
Plan Review and Inspection fees are $575k
since the start of the year. Compared to the
budget, the City is collecting $205k or 55%
more than anticipated revenue. Compared to
the prior year, the City is collecting $216k or
60% 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 ‐ 558,243 558,243 100% 0%
Fire District #40 ‐ 2,338,225 1,949,728 1,949,728 ‐17% 0%
State Shared Revenue 2,066,333 2,307,545 2,299,216 2,383,778 3% 4%
Federal Grants 386,850 227,259 413,685 413,685 82% 0%
State Grants 17,996 151,499 168,703 168,703 11% 0%
Other Grants 117,705 627,252 138,675 138,675 ‐78% 0%
ARRA Grants ‐ ‐ 238,056 238,056 100% 0%
Total Rev YTD 3,364,145 5,651,780 5,766,306 5,850,868 4% 1%
Total Rev Annual 10,503,905 11,340,480 11,653,246
YTD %32% 50% 49% 50%
Note: Includes CJ Sales Tax.
2009 2010 2010
Actual Budget Actual $ % $ %
Crim Just Sales Tax 950,096$ 1,003,434$ 924,177$ (25,919)$ ‐3% (79,257)$ ‐8%
Judicial Contribution 23,918 9,628 17,229 (6,689)$ ‐28% 7,601 79%
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 136,619 144,264 351,048 214,428 157% 206,783 143%
Liquor Excise Tax 442,053 452,315 313,158 (128,895) ‐29% (139,157) ‐31%
Fuel Tax 679,895 634,374 699,105 19,210 3% 64,731 10%
YTD Total 2,307,545$ 2,299,216$ 2,383,778$ 76,233$ 3% 84,562$ 4%
Annual Total 3,986,791$ 3,988,931$
State Shared Revenues
2010 vs. 2009
Revenue
Year to Date through July
2010 vs. Budget
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 35,851$ 36,982$ 98,294$ 62,443$ 174% 61,312$ 166%
Feb 45,883 47,331 41,012 (4,871) ‐11% (6,319) ‐13%
Mar 86,425 89,153 64,399 (22,026) ‐25% (24,754) ‐28%
Apr 27,659 28,532 45,065 17,406 63% 16,533 58%
May 58,715 60,569 103,250 44,534 76% 42,681 70%
Jun 43,085 44,445 60,642 17,557 41% 16,197 36%
Jul 61,541 63,483 162,517 100,977 164% 99,034 156%
Aug 43,348 44,716 ‐
Sep 36,509 37,662 ‐
Oct 67,095 69,213 ‐
Nov 59,883 61,773 ‐
Dec 109,397 112,850 ‐
YTD Total 359,158$ 370,494$ 575,179$ 216,021$ 60% 204,685$ 55%
Annual Total 675,391$ 696,708$
2010 vs. Budget
Year to Date through July
Plan Review / Inspection
Month
2010 vs. 2009
Page 6 of 34
Monthly Financial Report July 2010
Recreation revenues totaled $937k since
the start of the year. Compared to the
projected monthly budget, the City
collected $133k or 32% less. Compared to
the same month the prior year, the City
collected $148k or 35% less. Based on the
current month’s collection, the City is
projecting Recreation revenues to be
under the budget projection for 2010 by
$170k.
The year‐to‐date collections for Interfund
Service revenues are $1.9 million.
Compared to the projected budget, the
revenues are above by $126k or up by 7%.
Compared to the prior year, the revenues
are over by $42k or up by 2%. Interfund
Services is projected to meet 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 $1.9
million. This is $283k or 13% lower
than a year ago and $151k or 7% under
budget. Part of the difference is due to
the timing of revenue recognition,
which contributed to the variance in
January and will be caught up at the
end of the year.
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 ‐
Sep 123,439 118,956 ‐
Oct 79,452 76,566 ‐
Nov 61,971 59,720 ‐
Dec 73,842 71,161 ‐
YTD Total 1,089,561$ 1,049,995$ 936,938$ (152,623)$ ‐14% (113,057)$ ‐11%
Annual Total 1,631,486$ 1,572,240$
Recreation
Year to Date through July
2010 vs. 2009
Month
2010 vs. Budget
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 253,147$ 241,782$ 242,658$ (10,489)$ ‐4% 876$ 0%
Feb 243,496 232,565 273,674 30,178 12% 41,110 18%
Mar 286,921 274,040 249,758 (37,163) ‐13% (24,282) ‐9%
Apr 280,094 267,520 348,019 67,925 24% 80,499 30%
May 282,056 269,393 269,154 (12,902) ‐5% (240) 0%
Jun 270,778 258,622 275,850 5,072 2% 17,228 7%
Jul 263,897 252,050 263,285 (612) 0% 11,235 4%
Aug 258,386 246,785 ‐
Sep 265,902 253,965 ‐
Oct 266,313 254,357 ‐
Nov 281,154 268,532 ‐
Dec 273,599 261,316 ‐
YTD Total 1,880,391$ 1,795,972$ 1,922,398$ 42,007$ 2% 126,426$ 7%
Annual Total 3,225,745$ 3,080,927$
2010 vs. 2009 2010 vs. Budget
Month
Interfund Services
Year to Date through July
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 280,849$ 262,296$ 239,080$ (41,769)$ ‐15% (23,215)$ ‐9%
Feb 285,126 270,000 228,332 (56,794) ‐20% (41,668) ‐15%
Mar 370,244 347,334 279,311 (90,933) ‐25% (68,023) ‐20%
Apr 331,546 310,184 294,612 (36,934) ‐11% (15,572) ‐5%
May 310,888 290,518 276,543 (34,345) ‐11% (13,976) ‐5%
Jun 330,829 310,311 373,623 42,794 13% 63,312 20%
Jul 321,486 307,795 256,225 (65,261) ‐20% (51,570) ‐17%
Aug 256,668 238,715 ‐
Sep 269,199 250,627 ‐
Oct 318,272 297,690 ‐
Nov 368,928 345,586 ‐
Dec 372,972 346,135 ‐
YTD Total 2,230,968$ 2,098,439$ 1,947,727$ (283,241)$ ‐13% (150,712)$ ‐7%
Annual Total 3,817,008$ 3,577,193$
2010 vs. Budget2010 vs. 2009
Year to Date through July
Fines and Penalties by Month
Month
Page 7 of 34
Monthly Financial Report July 2010
There are also 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 the change in speed enforcement threshold in
school zones. These factors contributed to the reduction in photo enforcement revenue by 7% in June and 3% in July when
compared with the same periods in 2009. At this point, the City is projecting Fines and Penalties to be under budget by
$257k by the end of 2010.
Year to Date through July
2009 2010 2010
Actual Budget Actual $ % $ %
Civil Penalties 9,389$ 8,040$ 8,673$ (716)$ ‐8% 632$ 8%
Civil Infraction Penalties 445,308 404,256 439,756 (5,552) ‐1% 35,500 9%
Civil Parking Infraction Penalties 84,564 72,429 80,599 (3,965) ‐5% 8,170 11%
Photo Enforcement Program 1,424,667 1,353,600 1,178,110 (246,557) ‐17% (175,490) ‐13%
Crim Traffic Misdemeanor Fines 58,463 46,697 53,531 (4,932) ‐8% 6,834 15%
Criminal Non‐Traffic Fines 27,849 25,921 21,046 (6,803) ‐24% (4,874) ‐19%
Criminal Costs 148,680 159,827 154,816 6,136 4% (5,011) ‐3%
Non‐Court Fines, Forfeitures and Penalties 32,048 27,669 11,196 (20,852) ‐65% (16,473) ‐60%
YTD Total 2,230,968$ 2,098,439$ 1,947,727$ (283,241)$ ‐13% (150,712)$ ‐7%
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.2 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 $880k.
Compared to the projected year‐to‐date
budget, the revenues are over by $4k.
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 30,160 116,269
Aug 143,576 ‐ 69,525 ‐ ‐
Sep 149,862 ‐ 69,700 ‐ ‐
Oct 188,205 ‐ 69,347 ‐ ‐
Nov 240,433 ‐ 70,269 ‐ ‐
Dec 174,325 ‐ 73,194 ‐ ‐
YTD Total 1,353,600$ 1,178,110$ 489,930$ 432,406$ 745,704$
Annual Total 2,250,000$ 841,964$ 1,408,036$
Revenues Expenses
Photo Enforcement Program
Year to Date through July
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
Sep 131,358 118,330
Oct 76,125 68,575
Nov 73,002 65,762
Dec 196,289 176,822
YTD Total 972,235$ 875,811$ 880,001$ (92,235)$ ‐9% 4,190$ 0%
Annual Total 1,529,692$ 1,377,980$
Year to Date through July
Month
2010 vs. Budget2010 vs. 2009
Miscellaneous Revenues by Month
Page 8 of 34
Monthly Financial Report July 2010
2009 2010 2010
Actual Budget Actual $ % $ %
Interests and Other Earnings 354,535$ 276,031$ 206,357$ (148,178)$ ‐42% (69,674)$ ‐25%
Rents, Leases, and Concessions 473,429 458,110 519,731 46,303 10% 61,621 13%
Contributions/Donations from Private Sources 92,498 71,121 89,610 (2,887) ‐3% 18,490 26%
Other 51,774 70,549 64,302 12,528 24% (6,247) ‐9%
YTD Total 972,235$ 875,811$ 880,001$ (92,235)$ ‐9% 4,190$ 0%
Annual Total 1,529,692$ 1,377,980$
2010 vs. Budget
Miscellaneous Re venues by Type
Year to Date through July
Revenue
2010 vs. 2009
EXPENSES
Overall the City has expended 61% of its budgeted general governmental expenditures at the end of July. This is 2.4% or
$1.5 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.4% we
currently have.
The “unfavorable variances” in the transportation division is primarily due to the electrical rate adjustment which occurred
in April this year which would likely raise street lighting costs to above the $935k budgeted. The 2010 adopted budget for
street light electricity is lower than 2009’s year‐end actual, which is another reason that 2010’s cost is likely to exceed the
amount budgeted.
On the positive variance side, the Finance Department appears to be under budget by $266k. 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.
Page 9 of 34
Monthly Financial Report July 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 ‐ ‐ ‐ ‐ 34,553 27,700 ‐
Grants 61,220 ‐ ‐ 2,699 ‐ 498,609 ‐
Charges for services 16,131 1,077,287 8,748,225 5,405,670 9,872,787 2,943,456 ‐
Interdepartmental services ‐ ‐ 1,969 141,736 100,158 320,753 ‐
Rents, leases, and misc fees 926,571 213,283 48,000 53,308 ‐ ‐ ‐
Interest and other misc 9,083 12,158 109,924 254,270 215,999 148,112 116
TOTAL REVENUES 1,013,005 1,302,728 8,908,118 5,857,683 10,223,497 3,938,630 116
EXPENSES:
Utility billing ‐ ‐ 74,352 62,212 54,237 88,352 ‐
Utility systems ‐ ‐ 8,191,383 1,401,774 1,296,344 1,214,384 ‐
Utility maintenance ‐ ‐ 161,872 2,586,817 7,159,795 983,339 ‐
Transportation 604,670 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 998,072 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 604,670 998,072 8,427,607 4,050,803 8,510,376 2,286,075 ‐
AMOUNT AVAILABLE FOR DEBT SERVICE 408,335 304,656 480,511 1,806,880 1,713,121 1,652,555 116
DEBT SERVICE:
Principal ‐ 13,357 ‐ 1,246,675 815,776 151,840 ‐
Interest and other debt service costs ‐ 57,459 ‐ 480,938 250,164 194,229 ‐
TOTAL DEBT SERVICE ‐ 70,816 ‐ 1,727,613 1,065,940 346,069 ‐
CAPITAL PROJECTS 170,556 163,622 ‐ 1,282,431 2,581,916 621,375 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 237,779 70,218 480,511 (1,203,164) (1,934,735) 685,111 116
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, July 31, 2010 1,286,862 1,156,019 806,545 5,953,944 840,803 4,667,953 15,721
Page 10 of 34
Monthly Financial Report July 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,246,974 1,144,801 ‐ ‐ ‐ ‐ ‐
Telecommunications ‐ 166,720 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 62,634 ‐ 196,878 ‐ ‐ ‐
Communications ‐ ‐ ‐ 315,022 ‐ ‐ ‐
Facilities ‐ ‐ 2,436,137 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 65,598 ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ 146,302 ‐ ‐ ‐ ‐ ‐
Interest and other misc 33,910 13,650 1,587 700 43,703 43,744 23,467
Internal service fund misc:
Vehicle/equipment capital recovery 840,474 581,450 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 1,288,533 ‐ ‐
Worker's compensation / unemployment ‐ ‐ ‐ ‐ 797,167 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 6,477,190 1,020,899
Other misc 336 ‐ 2,297 ‐ ‐ 284,207 ‐
Disposal of capital assets ‐ ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 60,251 84,869 27,898
TOTAL REVENUES 2,121,694 2,182,141 2,440,021 512,600 2,189,654 6,890,010 1,072,264
EXPENSES:
Communications 269,220
Equipment rental 1,263,340
Facilities 2,204,600
Healthcare 5,370,821
Information technology 1,771,735
Print and mail ‐ 246,237
Retiree healthcare 628,517
Risk management
Risk management 952,117
Unemployement 327,664
Worker's compensation 747,672
TOTAL EXPENSES 1,263,340 1,771,735 2,204,600 515,457 2,027,453 5,370,821 628,517
AMOUNT AVAILABLE FOR CAPITAL 858,354 410,406 235,421 (2,857) 162,201 1,519,189 443,747
CAPITAL PROJECTS 634,131 202,478 25,000 29,408 ‐ ‐ ‐
TRANSFERS IN ‐ ‐ ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 224,223 207,928 210,421 (32,265) 162,201 1,519,189 443,747
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, July 31, 2010 4,817,622 1,855,859 301,596 79,553 6,201,710 6,311,641 3,264,220
Page 11 of 34
Monthly Financial Report July 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 199,368
Bond proceeds ‐
Tax Credit (BABs) 837,545
TOTAL REVENUES 1,043,913
EXPENSES:
Salaries and wages 11,421
Benefits 937
Supplies 6,654
Professional services 1,077,981
Intergovernmental 673,290
Construction 28,278,404
TOTAL EXPENSES 30,048,687
AMOUNT AVAILABLE FOR DEBT SERVICE (29,004,774)
DEBT SERVICE:
Principal ‐
Interest and other debt service costs 3,439,680
TOTAL DEBT SERVICE 3,439,680
CHANGE IN FUND BALANCE (32,444,454)
BEGINNING FUND BALANCE, January 1, 2010 80,644,637
ENDING FUND BALANCE, July 31, 2010 48,200,183
Page 12 of 34
Monthly Financial Report July 2010
FUND BALANCE
Page 14 shows the ending fund balance as of July 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 July, the City has $12.5 million reported in combined general governmental fund balance of the current year’s
operating budget, which is approximately 13% of budgeted operating expenditures. This is an increase of $497k from the
beginning balance of January 1, 2010. July’s ending fund balance is over the anticipated General Governmental Fund
Balance of $11.4 million by $1.1 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.
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 July 2010
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through July 31, 2010
Funds
Balance
01/01/2010
Budgeted
Revenue
Revenue
07/31/10
Total Funds
Available
Budgeted
Expenditure
Expenditure
07/31/10 Ending Balance
GENERAL GOVERNMENT FUNDS:11,955,285 98,542,948 60,897,449 72,852,734 99,347,239 60,400,225 12,452,509
000 General 8,535,013 74,520,193 42,206,499 50,741,512 72,517,802 40,671,076 10,070,436
001 Community Services 958,009 9,557,924 5,545,852 6,503,861 10,461,433 5,324,731 1,179,130
003 Street 1,391,648 7,201,490 4,271,554 5,663,202 8,543,138 4,826,691 836,511
004 Community Dev Block Grant (6,528) 532,635 80,774 74,246 532,227 272,301 (198,055)
005 Museum 64,705 192,621 96,742 161,447 194,120 111,161 50,286
006 Library 706,011 1,888,252 926,027 1,632,038 2,544,263 1,628,119 3,919
009 Farmers Market 60,571 44,280 33,546 94,117 34,311 24,521 69,596
010 Fire Memorial 936 ‐ 315 1,251 ‐ ‐ 1,251
011 Fire Health & Wellness 4,303 25,000 13,937 18,240 25,000 1,180 17,060
031 Pa rk Memorial 175,066 ‐ 1,331 176,397 ‐ ‐ 176,397
201 Ltd GO Bonds Gen Govt Debt 1,448 2,033,177 467,770 469,218 1,984,625 318,588 150,630
215 Gen Govt Misc Debt Service 64,103 2,547,376 7,253,102 7,317,205 2,510,320 7,221,857 95,348
SPECIAL REVENUE FUNDS:
102 Arterial Street 200,686 620,000 332,339 533,025 620,000 ‐ 533,025
108 Leased City Properties 837,613 1,669,586 747,483 1,585,096 1,511,561 1,188,054 397,042
110 Hotel Motel 247,828 245,000 162,370 410,198 245,000 163,549 246,649
118 Reserve for Paths & Trails 3,264 ‐ 28 3,292 ‐ ‐ 3,292
125 1% For Art 143,796 35,000 1,087 144,883 50,000 8,611 136,272
127 Cable Communication 89,391 85,000 38,728 128,119 85,674 13,145 114,974
135 Springbrook Wetlands Bank 459,528 ‐ 3,501 463,029 ‐ ‐ 463,029
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 255,227 1,321,820 ‐ ‐ 1,321,820
304 Fire Mitigation 2,363,522 100,000 47,694 2,411,216 560,000 (40,004) 2,451,220
305 Transportation Mitigation 2,167,133 200,000 (34,281) 2,132,852 1,810,000 ‐ 2,132,852
316 Municipal Facilities CIP 6,933,186 1,333,553 707,070 7,640,256 7,621,771 1,072,240 6,568,016
317 Transportation CIP 2,892,341 30,582,042 6,964,739 9,857,080 32,413,734 7,411,441 2,445,639
318 So Lake WA Infrastructure Proj 114,039 ‐ 754 114,793 114,000 47,825 66,968
326 Housing Opportunity 201,653 ‐ 1,539 203,192 200,000 ‐ 203,192
ENTERPRISE FUNDS:
402 Airport 415,929 1,917,163 947,272 1,363,201 1,001,800 604,670 758,531
403 Solid Waste Utility 326,034 15,025,000 8,908,118 9,234,152 15,025,000 8,427,607 806,545
404 Golf Course 798,278 2,483,545 1,301,264 2,099,542 2,566,837 1,111,362 988,180
422 Airport Capital 633,154 1,578,000 65,733 698,887 1,831,485 170,556 528,331
424 Golf Course Capital 287,523 150,000 1,464 288,987 302,499 121,147 167,840
INTERNAL SERVICE FUNDS:
501 Equipment Repair/Replacement 4,593,399 3,631,241 2,121,694 6,715,093 3,413,927 1,897,471 4,817,622
502 Insurance 6,039,509 3,287,584 2,189,653 8,229,162 4,170,106 2,027,453 6,201,709
503 Information Services 1,647,931 4,194,774 2,182,141 3,830,072 4,841,706 1,974,213 1,855,859
504 Facilities 91,175 4,705,475 2,440,021 2,531,196 4,326,200 2,229,600 301,596
505 Communications 111,818 1,049,671 512,600 624,418 877,560 544,866 79,552
512 Insurance, Healthcare 4,792,452 12,358,471 6,890,011 11,682,463 12,462,810 5,370,821 6,311,642
522 Insurance, Leoff1 Retirees HC 2,820,473 2,235,684 1,072,264 3,892,737 2,248,907 628,517 3,264,220
FIDUCIARY FUNDS:
611 Firemen's Pension 4,332,817 300,000 123,205 4,456,022 550,475 223,783 4,232,239
Funds
Balance
01/01/2010
Budgeted
Revenue
Revenue
07/31/10
Total Funds
Available
Budgeted
Expenditure
Expenditure
07/31/10 Ending Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 13,931,093 44,912,214 20,019,926 33,951,019 51,150,420 22,472,598 11,478,421
405 Water Utility 4,294,833 11,316,610 5,693,403 9,988,236 11,560,951 5,794,495 4,193,741
406 Waste Water Utility 1,887,815 6,070,737 3,313,799 5,201,614 6,780,650 3,170,399 2,031,215
407 Surface Water Utility 2,448,845 5,783,148 3,329,390 5,778,235 6,641,884 2,632,144 3,146,091
416 King County Metro 46,504 11,211,935 6,713,437 6,759,941 11,211,935 6,405,917 354,024
425 Water Utility Construction 2,862,275 3,460,000 164,280 3,026,555 5,510,000 1,266,352 1,760,203
426 Waste Water Construction 841,219 3,153,781 196,261 1,037,480 3,995,000 2,581,916 (1,544,436)
427 Surface Water Construction 1,533,997 3,916,003 609,240 2,143,237 5,450,000 621,375 1,521,862
461 Waterworks Bond Reserve ‐ ‐ ‐ ‐ ‐ ‐ ‐
471 Wa terworks Rate Stabilization 15,605 ‐ 116 15,721 ‐ ‐ 15,721
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
September
October
November
December
1,000,000
2,000,000
3,000,000
4,000,000
5,000,000
6,000,000
7,000,000
70,000,000
80,000,000
90,000,000
100,000,000
110,000,000
DifferenceRev/Exp Revenues
Expenditures
Difference
(7,000,000)
(6,000,000)
(5,000,000)
(4,000,000)
(3,000,000)
(2,000,000)
(1,000,000)
‐
1,000,000
2,000,000
3,000,000
4,000,000
5,000,000
6,000,000
7,000,000
‐
10,000,000
20,000,000
30,000,000
40,000,000
50,000,000
60,000,000
70,000,000
80,000,000
90,000,000
100,000,000
110,000,000
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
DifferenceRev/Exp Revenues
Expenditures
Difference
Page 15 of 34
City of Renton
Monthly Revenue Analysis ‐ 2010 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 4,913,351 4,881,556 ‐0.65%
Feb 10,850,564 10,472,029 ‐3.49%
Mar 16,350,246 15,590,071 ‐4.65%
Apr 29,228,824 27,747,760 ‐5.07%
May 44,121,619 48,191,829 9.22%
Jun 49,310,891 55,079,253 11.70%
Jul 55,416,612 60,897,449 9.89%
Aug 61,148,855
Sep 65,808,951
Oct 77,111,827
Nov 92,687,526
Dec 98,542,948
Percent of budget 61.80%
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
Sep 16,644,516
Oct 22,547,053
Nov 31,012,799
Dec 31,364,643
Percent of budget 53.05%
$‐
$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
Sep 15,628,456
Oct 17,436,835
Nov 18,929,142
Dec 20,857,000
Percent of budget 53.37%
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
Sep 10,760,779
Oct 11,813,935
Nov 12,878,332
Dec 14,228,000
Percent of budget 61.36%
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
Sep 1,759,093
Oct 2,024,220
Nov 2,153,967
Dec 2,386,376
Percent of budget 60.54%
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
Sep 7,390,372
Oct 8,027,921
Nov 11,304,114
Dec 11,653,246
Percent of budget 50.61%
Note: Includes CJ Sales Tax.
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
$10
$11
$12
Millions Intergovernmental
Budget
Actual
Last Year
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
$2.40
Millions Licenses & Permits
Budget
Actual
Last Year
Page 18 of 34
City of Renton
Monthly Revenue Analysis ‐ 2010 Budget Year
Charges for
Svcs Budget
YTD
Actual
Annual %
over (under)
Jan 391,334 445,172 13.76%
Feb 791,905 869,415 9.79%
Mar 1,295,331 1,336,778 3.20%
Apr 1,774,948 1,954,003 10.09%
May 2,308,362 2,466,435 6.85%
Jun 2,817,547 3,043,138 8.01%
Jul 3,611,251 3,828,477 6.02%
Aug 4,145,264
Sep 4,604,070
Oct 5,058,558
Nov 5,489,415
Dec 5,997,460
Percent of budget 63.83%
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
Sep 2,587,781
Oct 2,885,471
Nov 3,231,058
Dec 3,577,193
Percent of budget 54.45%
$‐
$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
Sep 4,584,474
Oct 5,408,386
Nov 5,791,753
Dec 6,297,095
Percent of budget 60.10%
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
Sep 1,066,818
Oct 1,135,400
Nov 1,201,158
Dec 1,377,980
Percent of budget 63.86%
$‐
$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
Sep 1,850,592
Oct 2,058,960
Nov 2,279,304
Dec 2,400,000
Percent of budget 55.32%
Note: Combines Funds 201, 215, 316, and 318
$0.00
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
Millions Real Estate Excise Tax
Budget
Actual
Last Year
Page 21 of 34
City of Renton
Monthly Expenditure Analysis ‐ 2010 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,163,929 7,161,528 ‐0.03%
Feb 15,254,769 15,011,456 ‐1.59%
Mar 22,794,231 22,695,538 ‐0.43%
Apr 30,497,615 29,817,438 ‐2.23%
May 37,946,671 43,949,015 15.82%
Jun 46,603,790 52,299,100 12.22%
Jul 54,947,964 60,400,225 9.92%
Aug 62,948,398
Sep 70,847,497
Oct 78,654,203
Nov 86,699,342
Dec 99,347,239
Percent of budget expended 60.80%
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
Sep 202,484
Oct 224,540
Nov 246,799
Dec 267,957
Percent of budget expended 56.83%
$‐
$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
Sep 1,508,802
Oct 1,677,249
Nov 1,836,905
Dec 2,016,361
Percent of budget expended 57.93%
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
Sep 1,225,811
Oct 1,370,153
Nov 1,499,437
Dec 1,635,047
Percent of budget expended 57.11%
$‐
$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
Sep 1,700,824
Oct 1,832,622
Nov 2,006,095
Dec 2,164,890
Percent of budget expended 49.72%
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
Sep 1,244,944
Oct 1,384,635
Nov 1,520,418
Dec 1,621,295
Percent of budget expended 57.34%
$‐
$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
Sep 697,386
Oct 773,457
Nov 845,873
Dec 918,169
Percent of budget expended 55.02%
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
Sep 394,646
Oct 441,919
Nov 483,769
Dec 518,399
Percent of budget expended 58.26%
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
Sep 3,332,176
Oct 3,741,593
Nov 4,083,716
Dec 4,792,981
Percent of budget expended 44.74%
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
Sep 20,560,448
Oct 22,762,743
Nov 25,377,250
Dec 28,022,582
Percent of budget expended 56.60%
$‐
$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
Sep 16,560,924
Oct 18,349,790
Nov 20,065,074
Dec 21,922,009
Percent of budget expended 58.35%
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
Sep 723,147
Oct 781,484
Nov 843,676
Dec 931,014
Percent of budget expended 49.36%
$‐
$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
Sep 569,793
Oct 693,393
Nov 748,914
Dec 874,359
Percent of budget expended 54.41%
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
Sep 150,300
Oct 166,956
Nov 183,659
Dec 200,440
Percent of budget expended 50.75%
$0.00
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
$0.70
$0.80
$0.90
$1.00
Millions Human Svcs (Comm Svcs)
Budget
Actual
Last Year
$‐
$20,000
$40,000
$60,000
$80,000
$100,000
$120,000
$140,000
$160,000
$180,000
$200,000
$220,000
Hearing Examiner
Budget
Actual
Last Year
Page 28 of 34
City of Renton
Monthly Expenditure Analysis ‐ 2010 Budget Year
CED Budget
YTD
Actual
Annual %
over (under)
Jan 509,427 555,670 9.08%
Feb 1,079,871 1,097,029 1.59%
Mar 1,636,852 1,602,874 ‐2.08%
Apr 2,163,456 2,116,917 ‐2.15%
May 2,707,968 2,646,710 ‐2.26%
Jun 3,234,971 3,251,020 0.50%
Jul 3,814,567 3,772,492 ‐1.10%
Aug 4,373,869
Sep 4,921,763
Oct 5,481,795
Nov 6,022,924
Dec 6,632,300
Percent of budget expended 56.88%
Note: For comparative purposes history includes Development Svcs division (previously in Public Works).
Note: General Fund only
General Fund Budget
YTD
Actual
Annual %
over (under)$75
Millions General Fund
Budget
$‐
$1.50
$3.00
$4.50
$6.00
$7.50
Millions Community & Economic
Development
Budget
Actual
Last Year
g ()
Jan 5,749,211 5,746,764 ‐0.04%
Feb 12,150,358 11,897,388 ‐2.08%
Mar 17,973,537 17,846,883 ‐0.70%
Apr 23,903,318 23,551,432 ‐1.47%
May 29,556,081 29,019,419 ‐1.82%
Jun 35,401,015 34,922,145 ‐1.35%
Jul 41,520,793 40,671,076 ‐2.05%
Aug 47,160,502
Sep 53,217,189
Oct 58,976,553
Nov 65,185,527
Dec 72,517,802
Percent of budget expended 56.08%
$‐
$15
$30
$45
$60
$75
Millions General Fund
Budget
Actual
Last Year
$‐
$1.50
$3.00
$4.50
$6.00
$7.50
Millions Community & Economic
Development
Budget
Actual
Last Year
Page 29 of 34
City of Renton
Monthly Expenditure Analysis ‐ 2010 Budget Year
Community
Svcs Fund Budget
YTD
Actual
Annual %
over (under)
Jan 628,418 570,605 ‐9.20%
Feb 1,415,327 1,321,394 ‐6.64%
Mar 2,178,593 2,026,750 ‐6.97%
Apr 2,968,536 2,733,709 ‐7.91%
May 3,780,448 3,481,093 ‐7.92%
Jun 4,619,455 4,303,348 ‐6.84%
Jul 5,761,843 5,324,731 ‐7.59%
Aug 6,929,653
Sep 7,789,687
Oct 8,632,774
Nov 9,503,898
Dec 10,461,433
Percent of budget expended 50.90%
Street Fund Budget
YTD
Actual
Annual %
over (under)
$‐
$2
$4
$6
$8
$10
$12
$14
Millions Community Svcs Fund
Budget
Actual
Last Year
$8
$9
Millions Street Fund
Budget
At l
g ()
Jan 600,924 641,040 6.68%
Feb 1,276,345 1,365,252 6.97%
Mar 1,958,856 2,078,338 6.10%
Apr 2,664,177 2,735,391 2.67%
May 3,383,424 3,438,717 1.63%
Jun 4,063,971 4,197,932 3.30%
Jul 4,801,841 4,826,691 0.52%
Aug 5,565,769
Sep 6,290,996
Oct 7,004,518
Nov 7,710,951
Dec 8,543,138
Percent of budget expended 56.50%
$‐
$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
Sep 370,840
Oct 429,422
Nov 467,929
Dec 532,227
Percent of budget expended 51.16%
Library Fund Budget
YTD
Actual
Annual %
over (under)$3.00
Millions Library Fund
Budget
At l
$‐
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
CDBG
Budget
Actual
Last Year
y g ()
Jan 178,200 173,794 ‐2.47%
Feb 369,656 229,125 ‐38.02%
Mar 573,477 500,663 ‐12.70%
Apr 777,934 505,911 ‐34.97%
May 977,023 1,067,015 9.21%
Jun 1,176,467 1,067,015 ‐9.30%
Jul 1,368,254 1,628,119 18.99%
Aug 1,579,352
Sep 1,772,156
Oct 1,974,603
Nov 2,165,372
Dec 2,544,263
Percent of budget expended 63.99%
$‐
$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
Sep 148,372
Oct 164,641
Nov 180,555
Dec 194,120
Percent of budget expended 57.26%
Note: Prior to 2009, Museum was part of the Library Fund
LTGO Funds Budget
YTD
Actual
Annual %
over (under)
$7.00
$8.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 22,250 126,390 468.04%
Apr 22,250 126,471 468.41%
May 22,250 6,739,665 30190.63%
Jun 1,078,472 7,540,445 599.18%
Jul 1,078,472 7,540,445 599.18%
Aug 1,078,472
Sep 1,078,472
Oct 1,290,948
Nov 1,293,331
Dec 4,494,945
Percent of budget expended 167.75%
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
$7.00
$8.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,475,180 3,901,859 2,612,849
Feb 5,573,491 7,676,067 5,998,348
Mar 8,521,156 11,963,798 8,343,902
Apr 10,646,195 15,716,035 12,647,433
May 14,447,983 19,691,324 15,881,194
Jun 18,958,727 23,695,967 21,496,504
Jul 23,155,850 27,958,146 26,430,562
Aug 27,231,086
Sep 30,252,248
Oct 33,275,236
Nov 36,644,712
Dec 45,650,678
Percent of budget expended 57.90%
Note: Operations only, excludes bond proceeds and transfers to capital.
Airport Budget Revenue Expense
$0
$5
$10
$15
$20
$25
$30
$35
$40
$45
$50
Millions Utilities
Budget
Revenue
Expense
$1.20
Millions Airport
Budget
p g p
Jan 66,269 94,268 72,717
Feb 159,667 204,281 156,869
Mar 250,901 310,979 242,660
Apr 329,772 418,081 325,667
May 438,337 517,628 410,185
Jun 517,870 655,253 512,611
Jul 598,355 947,272 604,670
Aug 688,817
Sep 759,575
Oct 838,546
Nov 913,982
Dec 1,001,800
Percent of budget expended 60.36%
Note: Operations only.
$0
$5
$10
$15
$20
$25
$30
$35
$40
$45
$50
Millions Utilities
Budget
Revenue
Expense
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Millions Airport
Budget
Revenue
Expense
Page 33 of 34
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2010 Budget Year
Golf Course Budget Revenue Expense
Jan 129,394 68,826 97,947
Feb 258,326 174,258 215,710
Mar 479,768 309,509 434,186
Apr 618,377 505,332 578,898
May 813,533 717,289 741,203
Jun 1,066,444 1,006,321 958,609
Jul 1,232,903 1,301,264 1,111,362
Aug 1,384,039
Sep 1,549,779
Oct 1,857,389
Nov 1,994,766
Dec 2,566,837
Percent of budget expended 43.30%
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