HomeMy WebLinkAbout201006, June.pdfFINANCE AND
INFORMATION TECHNOLOGY
M E M O R A N D U M
DATE: August 3, 2010
TO: Don Persson, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Iwen Wang, Administrator
SUBJECT: June 2010 Financial Status Report
Attached is the June 2010 Financial Status Report. Sales tax for the month is for
business activities that occurred in April 2010.
At the end of June, general governmental revenues show $176k or 0.3% under budget.
This includes a $336k 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 $512k or 0.9% below budget. When combined
with the $951k or 1.8% favorable expenditure comparison, the operation shows a net
positive result of $775k, or 1.5% of the YTD expenditure budget.
The fund balance at the end of June is $14.7 million. The ending fund balance is
consistent with prior years. The City normally sees fund balance peaks in May and
November due to property tax collections.
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 12,966,174 30,660,522 15,849,213 31,364,643 16,213,191 16,549,647 336,456 2.1%
Sales Tax 20,825,055 9,867,636 17,995,836 9,033,115 18,609,000 9,054,734 8,650,047 (404,687) ‐4.5%
Sales Tax ‐ Annexation Credit ‐ ‐ 2,132,110 1,067,999 2,248,000 1,126,050 1,013,934 (112,116) ‐10.0%
Criminal Justice Sales Tax 1,755,469 814,294 1,650,350 822,569 1,743,000 868,748 801,402 (67,346) ‐7.8%
Natural Gas Use Tax 253,377 162,939 242,891 124,780 ‐ ‐ 140,295 140,295 100.0%
Admission Tax 197,740 97,253 260,269 118,330 260,000 118,207 141,355 23,148 19.6%
Franchise Fees 998,288 442,071 1,039,031 518,585 1,040,000 490,391 594,746 104,355 21.3%
Electricity Tax 4,580,037 2,260,476 4,963,151 2,691,555 5,150,000 2,792,885 2,590,371 (202,514) ‐7.3%
Gas Tax 1,565,810 981,151 1,891,255 1,372,181 1,858,000 1,348,053 992,781 (355,272) ‐26.4%
Transfer Station 380,961 153,563 283,985 115,425 230,000 93,483 113,722 20,239 21.7%
TV Cable 1,073,168 413,881 1,263,743 623,136 1,250,000 616,360 667,349 50,989 8.3%
Telephone 1,032,048 520,151 1,037,873 504,581 960,000 466,721 525,879 59,158 12.7%
Cellular Phone 1,748,147 833,848 2,027,473 949,633 1,900,000 889,927 1,188,049 298,122 33.5%
City Utilities 2,606,786 1,132,517 2,871,599 1,367,364 2,880,000 1,371,364 1,372,147 783 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,060,980 2,141,720 1,113,458 2,000,000 1,039,779 809,252 (230,528) ‐22.2%
Real Estate Excise Tax 2,800,103 1,551,475 2,418,456 1,144,211 2,400,000 1,135,488 1,178,010 42,522 3.7%
Less: Municipal Facilities CIP REET (450,103) (775,737) (1,000,000) (541,243) (400,000) (216,497) (197,123) 19,375 ‐8.9%
EMS Levy 890,998 85,744 1,170,657 585,329 897,095 ‐ ‐ ‐ 0.0%
Business License Fees 485,537 242,115 424,413 214,946 463,067 234,523 221,313 (13,210) ‐5.6%
Other Licenses and Permits 257,477 141,093 176,851 78,523 157,250 69,820 107,553 37,733 54.0%
Building Permits 2,034,225 1,423,395 1,683,082 878,970 1,766,059 922,303 856,930 (65,373) ‐7.1%
Intergovernmental (Grants, etc)3,734,887 1,394,385 3,820,932 2,084,578 4,355,523 2,116,995 2,116,995 ‐ 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 102,782 187,721 87,232 217,585 101,110 100,583 (527) ‐0.5%
Public Safety 524,565 263,027 521,484 271,735 430,000 224,064 211,924 (12,140) ‐5.4%
Development Service Fees 903,768 501,724 677,955 297,617 696,708 305,850 415,535 109,685 35.9%
Culture and Recreation 1,678,818 738,811 1,631,486 660,502 1,572,240 636,516 655,982 19,466 3.1%
Interfund/Interdept‐Services 3,072,950 1,446,820 3,225,745 1,616,494 3,080,927 1,543,922 1,659,113 115,191 7.5%
Fines and Forfeits 2,110,973 549,697 1,448,878 635,889 1,327,193 582,484 659,820 77,336 13.3%
Photo Enforcement ‐ ‐ 2,368,131 1,273,593 2,250,000 1,210,062 1,031,681 (178,380) ‐14.7%
Interests and Other Earnings 735,910 356,595 535,314 269,424 434,300 218,584 168,428 (50,156) ‐22.9%
Rents, Leases, and Concessions 676,919 394,639 677,960 407,002 720,780 432,708 437,749 5,041 1.2%
Contributions and Donations 175,513 115,247 150,406 42,519 111,900 31,634 55,876 24,242 76.6%
Other Miscellaneous 67,355 41,603 168,567 35,124 262,557 54,708 61,093 6,385 11.7%
Refunding Debt and Premiums ‐ ‐ ‐ ‐ ‐ 6,613,484 6,613,484 ‐ 0.0%
Transfer ‐In 381,364 ‐ 577,004 ‐ 652,398 ‐ ‐ ‐ 0.0%
Total Operating Revenues 93,687,106 41,108,898 97,342,052 48,710,070 98,542,948 55,254,987 55,079,253 (175,734) ‐0.3%
OPERATING EXPENDITURES
Legislative 245,441 126,226 247,225 124,734 267,957 136,495 131,035 5,461 4.0%
City Attorney 1,661,225 833,477 1,248,380 648,527 1,621,295 825,805 799,852 25,953 3.1%
City Clerk 604,844 348,280 646,581 376,007 931,014 538,843 414,558 124,285 23.1%
Court Services 1,744,122 837,110 1,819,731 938,665 2,016,361 1,004,700 990,091 14,609 1.5%
Executive 966,373 460,841 1,499,747 724,211 1,635,047 785,694 800,153 (14,459) ‐1.8%
Hearing Examiner 166,820 82,208 171,911 86,758 200,440 99,983 87,146 12,837 12.8%
Community and Eco Dvlpmnt Admin ‐ ‐ 265,269 136,989 696,149 359,503 292,116 67,386 18.7%
Development Services 4,178,096 1,985,947 3,615,129 1,868,700 2,985,683 1,476,764 1,497,590 (20,826) ‐1.4%
Economic Development 1,875,749 904,092 1,244,175 601,432 1,323,047 638,438 636,436 2,002 0.3%
Planning ‐ ‐ 1,525,460 690,456 1,661,732 752,136 843,999 (91,863) ‐12.2%
Finance 1,909,652 978,042 1,969,936 1,112,201 2,164,890 1,166,399 926,194 240,205 20.6%
Human Resources 981,306 526,844 853,063 417,982 918,169 472,921 428,866 44,055 9.3%
Police 23,894,898 11,258,056 25,833,756 12,639,878 28,022,582 13,466,718 13,574,734 (108,016) ‐0.8%
Fire 21,763,640 10,471,328 20,375,286 10,579,295 21,922,009 11,207,916 11,038,448 169,468 1.5%
Facilities 3,614,850 1,759,577 ‐ (242) ‐ ‐ ‐ ‐ 0.0%
Parks 4,892,441 1,816,771 4,820,336 1,885,525 4,569,001 1,741,602 1,673,049 68,554 3.9%
Parks Planning & Natural Resources ‐ ‐ ‐ ‐ 545,943 272,971 185,783 87,188 31.9%
Recreation 4,383,163 2,032,580 7,878,458 3,853,373 4,970,795 2,386,133 2,300,180 85,953 3.6%
Human Services 1,162,553 493,851 1,194,142 498,258 1,406,586 592,137 525,801 66,336 11.2%
Community Resources & Events 367,627 134,760 348,185 142,451 375,694 145,495 144,336 1,158 0.8%
Library 1,890,886 929,456 2,312,128 1,018,530 2,544,263 1,067,015 1,067,015 ‐ 0.0%
Museum 136,327 69,294 140,801 72,814 194,120 99,542 94,929 4,613 4.6%
Public Works Administration 886,867 466,904 463,533 239,909 518,399 271,335 258,597 12,738 4.7%
Street Maintenance 3,212,111 1,456,218 3,794,716 1,939,251 3,379,080 1,637,483 1,638,385 (902) ‐0.1%
Technical Services 515,708 254,635 478,493 234,056 ‐ ‐ ‐ ‐ 0.0%
Transportation 4,841,955 2,159,616 5,110,639 2,512,585 5,164,058 2,424,244 2,559,547 (135,303) ‐5.6%
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,229,151 5,169,426 2,259,335 4,817,981 2,124,216 1,849,816 274,400 12.9%
Total Operating Expenditures 95,171,399 43,665,063 97,203,328 46,577,024 99,347,239 53,234,934 52,299,100 935,834 1.8%
Total Ending Fund Balance 11,816,561$ 10,744,689$ 11,955,285$ 13,949,608$ 11,150,994$ 13,975,338$ 14,735,438$ 760,099 5.4%
Summary of Sources and Uses Annual Actual YTD Actual Favorable (Unfavorable)
2008 2009 2010 Variance
Annual Actual YTD Actual Annual Budget YTD Budget YTD Actual
Monthly Financial Report June 2010
Page 1 of 34
Monthly Financial Report June 2010
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through June 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 66% of all resources supporting general governmental activities. The following section provides detail
information on property, sales, utility, and other taxes.
Property Tax
June’s collection is $115k, making
the total year‐to‐date collection
$16.5 million or 53% of the total
budget. In comparison to the
previous year, the City collected
$700k or 4% higher. Compared to
the budget, the City is above
projections by $336k or 2%.
Based on distribution we have
received in June, we are
projecting property tax collections
to meet the projections at year
end.
Sales Tax
June 2010 sales tax receipts totaled
$1.4 million. Compared to the same
month last year, it is $20k or 1% more.
Compared to the projected current
month’s budget, it is below projections
by $82k or 6%. The year‐to‐date
collection is $8.7 million or 46% of the
sales tax budget. This is $383k less
than the last year and $405k below
budget. July sales tax receipts (May
actually) of $1.31 million is $238k or
15% below budget and $134k or 9%
below 2009. Based on the year‐to‐date
collection (including July’s), the City is
projecting sales tax revenues to be
$17.4 million by the end of 2010, which
is $1.2 million 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
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,849,213$ 16,213,191$ 16,549,647$ 700,434$ 4% 336,456$ 2%
Annual Total 30,660,522$ 31,364,643$
Property Tax Revenues
Year to Date through June
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 ‐
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 9,033,115$ 9,054,734$ 8,650,047$ (383,068)$ ‐4% (404,687)$ ‐4%
Annual Total 17,995,836$ 18,609,000$
2010 vs. Budget2010 vs. 2009
Month
Year to Date through June
Local Retail Sales Tax Revenues
Page 2 of 34
Monthly Financial Report June 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,405,554$ 1,597,257$ 1,328,950$ 1,192,385$ (404,872)$ ‐25% $ (136,566)‐10%
Auto Sales 1,818,983 1,449,943 1,603,226 1,466,378 16,435 1% (136,848)‐9%
General Retail 2,990,834 2,963,042 2,998,479 2,985,784 22,741 1% (12,696) 0%
Manufacturing 529,792 562,902 490,014 388,649 (174,253) ‐31% (101,365)‐21%
Wholesale 589,414 453,909 494,636 470,013 16,104 4% (24,622)‐5%
Service 1,895,109 1,800,232 1,858,586 1,852,873 52,641 3% (5,713) 0%
Other 206,288 205,824 280,843 293,966 88,142 43% 13,123 5%
Total 10,435,974$ 9,033,110$ 9,054,734$ 8,650,047$ (383,063) ‐4%(404,687)$ ‐4%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility tax
June utility taxes revenue totals $1.2
million, which is $94k higher than the
same month last year and ahead of the
budget by $121k. The year‐to‐date
collection of $7.6 million is above the
budget by $30k but is $158k or 2% below
2009. The unfavorable comparisons in
January and February is primarily due to
higher than normal electrical and natural
gas consumptions during winter months
in 2009 that distorted the budget for
these two months. At this time, the City
is projecting utility tax revenues to 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,260,476 2,691,555 2,736,638 2,590,371 ‐4%‐5%
Natural Gas 1,144,090 1,496,961 987,315 1,133,077 ‐24% 15%
Cell 833,848 949,633 1,009,633 1,188,049 25% 18%
Phone 520,151 504,581 510,131 525,879 4% 3%
Cable 413,881 623,136 664,232 667,349 7% 0%
Transfer Station 153,563 115,425 122,219 113,722 ‐1%‐7%
City Utilities 1,132,517 1,367,364 1,530,392 1,372,147 0%‐10%
YTD Total 6,458,527 7,748,655 7,560,559 7,590,593 ‐2%0%
Annual Total 13,240,334 14,581,971 14,228,000
YTD as % of 49% 53% 53%
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
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 7,748,655$ 7,560,559$ 7,590,593$ (158,061)$ ‐2% 30,034$ 0%
Annual Total 14,581,971$ 14,228,000$
2010 vs. Budget2010 vs. 2009
Year to Date through June
Utility Tax Revenues
Month
Page 3 of 34
Monthly Financial Report June 2010
Other Taxes
Real Estate Excise Tax
The City collected $192k in Real Estate
Excise Tax revenues (REET) in June. This
is $18k below current month’s budget
and $20k behind the same month last
year. Year‐to‐date collection of $1.2
million is $43k or 4% ahead of the
budget and is also $34k or 3% above
2009.
Almost all REET in recent months are
generated from residential property
transactions. The activities appear to be
smaller in amount but steady in volume.
We hope this trend will continue and not
stop once the federal stimulus incentive
expires.
Gambling Tax
June’s Gambling Tax collections
total $142k. Year‐to‐date total of
$809k is $304k or 27% below the
year before; and $231k or 22%
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 $443k less in
gambling tax revenue collection
than budgeted by the end of the year.
Franchise Fees
Franchise Fees are due quarterly
and the year‐to‐date revenue
collections are $594k. This is $104k
or 21% above the projected year‐
to‐date budget and $76k or 15%
higher than 2009. 2009’s May
collection should have been
recorded in April.
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 231,334$ 229,560$ 71,303$ (160,031)$ ‐69% (158,257)$ ‐69%
Feb 69,290 68,760 107,242 37,952 55% 38,482 56%
Mar 183,177 181,800 309,164 125,987 69% 127,364 70%
Apr 141,038 139,944 281,746 140,708 100% 141,802 101%
May 308,077 305,736 216,814 (91,262) ‐30% (88,922) ‐29%
Jun 211,295 209,688 191,741 (19,554) ‐9% (17,947) ‐9%
Jul 201,960 200,400
Aug 310,599 308,232
Sep 208,046 206,472
Oct 209,975 208,368
Nov 222,052 220,344
Dec 121,614 120,696
YTD Total 1,144,211$ 1,135,488$ 1,178,010$ 33,799$ 3% 42,522$ 4%
Annual Total 2,418,456$ 2,400,000$
Real Estate Excise Tax Revenues
Year to Date through June
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 ‐
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,113,458$ 1,039,779$ 809,252$ (304,207)$ ‐27% (230,528)$ ‐22%
Annual Total 2,141,720$ 2,000,000$
2010 vs. Budget
Gambling Tax Revenue
Month
Year to Date through June
2010 vs. 2009
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 259,792$ 255,537$ 45,703$ (214,089)$ ‐82% (209,834)$ ‐82%
Feb 200 102 274,776 274,576 137288% 274,674 269037%
Mar ‐ ‐ ‐
Apr ‐ 102,746 274,268 274,268 100% 171,521 167%
May 258,593 132,005 ‐ (258,593) (132,005)
Jun ‐ ‐ ‐
Jul 260,647 244,359 ‐
Aug ‐ ‐ ‐
Sep ‐ 24,721 ‐
Oct 259,798 258,846 ‐
Nov ‐ ‐ ‐
Dec ‐ 21,683 ‐
YTD Total 518,585$ 490,391$ 594,746$ 76,161$ 15% 104,355$ 21%
Annual Total 1,039,031$ 1,040,000$
Franchise Fees Revenue
Year to Date through June
Month
2010 vs. 2009 2010 vs. Budget
Page 4 of 34
Monthly Financial Report June 2010
Admission Tax
Admission Tax returns are due
quarterly in January, April, July, and
October each year. April 2010
collections represent activities
conducted during the 1th quarter of
2010.
The report shows an increase of
$23k from the year before and
$19k more than anticipated.
Licenses and Permits
These revenue sources reflect the collection of business licenses; building permits; and other licenses, fees, and permits.
Building Permit Fees and General Business Licenses constitute 83% of the revenue in this category. As of the end of June,
we have collected 50% of the projected revenue from licenses and permits. The percentage of year‐to‐date actual to year‐
to‐date budget is 3% less. Licenses and Permits totaled $1.2 million by the end of June. The following sections provide
detail information for Building Permits and Business Licenses revenues.
Building Permits and Fees revenues
totaled $135k in June. 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 $775k is $66k less than the budget
and is also $7k lower than 2009.
Business Licenses totaled $221k 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 $13k but $6k above last year.
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 57,167$ 58,965$ 74,777$ 17,610$ 31% 15,811$ 27%
Feb ‐ ‐ 459 459 100% 459 100%
Apr 61,163 63,415 66,119 4,956 8% 2,704 4%
Jul 70,690 69,911 ‐
Oct 70,729 67,414 ‐
Nov 520 295 ‐
YTD Total 118,330$ 122,381$ 141,355$ 23,026$ 19% 18,975$ 16%
Annual Total 260,269$ 260,000$
Year to Date through June
Month
2010 vs. 2009 2010 vs. Budget
Admission Ta x Revenue
2009 2010 2010
Actual Budget Actual $ % $ %
Jan 106,633$ 114,591$ 285,826$ 179,192$ 168% 171,234$ 149%
Feb 124,555 133,851 46,586 (77,969) ‐63% (87,265) ‐65%
Mar 179,330 192,714 82,637 (96,693) ‐54% (110,076) ‐57%
Apr 114,694 123,254 122,217 7,522 7% (1,037) ‐1%
May 125,344 134,698 102,511 (22,833) ‐18% (32,187) ‐24%
Jun 131,705 141,534 135,295 3,591 3% (6,238) ‐4%
Jul 106,810 114,781 ‐
Aug 119,439 128,352 ‐
Sep 101,087 108,631 ‐
Oct 131,899 141,742 ‐
Nov 82,516 88,674 ‐
Dec 169,581 182,237 ‐
YTD Total 782,262$ 840,641$ 775,072$ (7,190)$ ‐1% (65,570)$ ‐8%
Annual Total 1,493,593$ 1,605,059$
Building Permits and Fees
Year to Date through June
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 ‐
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 214,946$ 234,523$ 221,313$ 6,367$ 3% (13,210)$ ‐6%
Annual Total 424,413$ 463,067$
Business Licenses
Month
Year to Date through June
2010 vs. Budget2010 vs. 2009
Page 5 of 34
Monthly Financial Report June 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.4 million or 47% 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 million since the start of
2010. Compared to the projected
budget, State Shared Revenues are
above by $80k or 4%. Compared to
the prior year, the City is collecting
$77k more or up by 4%. 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 $142k, 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 $5k 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 76% of the total revenue in this category. The year‐to‐date total charges for services are $3 million or 51% of the
budget. This is 8% 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 $413k
since the start of the year. Compared to the
budget, the City is collecting $106k or 34%
more than anticipated revenue. Compared to
the prior year, the City is collecting $115k or
39% more.
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 1,702,239 1,949,635 1,946,177 2,026,589 4% 4%
Federal Grants 382,850 220,314 407,473 407,473 85% 0%
State Grants 12,996 142,628 137,761 137,761 ‐3% 0%
Other Grants 110,595 594,570 108,517 108,517 ‐82% 0%
ARRA Grants ‐ ‐ 238,056 238,056 100% 0%
Total Rev YTD 2,983,941 5,245,373 5,345,956 5,426,368 3% 2%
Total Rev Annual 10,503,905 11,340,480 11,653,246
YTD %28% 46% 46% 47%
Note: Includes CJ Sales Tax.
2009 2010 2010
Actual Budget Actual $ % $ %
Crim Just Sales Tax 822,569$ 868,748$ 801,402$ (21,167)$ ‐3% (67,346)$ ‐8%
Judicial Contribution 23,918 9,628 17,229 (6,689)$ ‐28% 7,601 79%
Crim Just ‐ Pop 8,611 ‐ 9,223 611 7% 9,223 100%
Crim Just ‐ Spec Prog 33,049 32,120 35,060 2,011 6% 2,941 9%
State DUI 7,334 3,986 7,871 537 7% 3,885 97%
Liquor Profits 136,619 144,264 351,048 214,428 157% 206,783 143%
Liquor Excise Tax 347,452 355,518 213,880 (133,572) ‐38% (141,637) ‐40%
Fuel Tax 570,082 531,914 590,876 20,794 4% 58,962 11%
YTD Total 1,949,635$ 1,946,177$ 2,026,589$ 76,954$ 4% 80,412$ 4%
Annual Total 3,986,791$ 3,988,931$
State Shared Revenues
2010 vs. 2009
Revenue
Year to Date through June
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 ‐
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 297,617$ 307,011$ 412,662$ 115,044$ 39% 105,651$ 34%
Annual Total 675,391$ 696,708$
Month
2010 vs. 2009 2010 vs. Budget
Year to Date through June
Plan Review / Inspection
Page 6 of 34
Monthly Financial Report June 2010
Recreation revenues totaled $656k since the
start of the year. Compared to the projected
monthly budget, the City collected $44k or
30% more. Compared to the same month
the prior year, the City collected $39k or 25%
more. Based on the current month’s
collection, the City is projecting Recreation
revenues to meet the budget projection for
2010.
The year‐to‐date collections for Interfund
Service revenues are $1.7 million.
Compared to the projected budget, the
revenues are above by $115k or up by 7%.
Compared to the prior year, the revenues
are over by $43k or up by 3%. 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.7
million. This is $217k lower than a
year ago and $99k under budget. Part
of the difference is due to the timing of
revenue recognition, which contri‐
buted 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 ‐
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 660,502$ 636,516$ 655,982$ (4,520)$ ‐1% 19,466$ 3%
Annual Total 1,631,486$ 1,572,240$
2010 vs. Budget
Recreation
Year to Date through June
2010 vs. 2009
Month
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 ‐
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,616,494$ 1,543,922$ 1,659,113$ 42,620$ 3% 115,191$ 7%
Annual Total 3,225,745$ 3,080,927$
Interfund Services
Year to Date through June
2010 vs. 2009 2010 vs. Budget
Month
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 ‐
Aug 256,668 238,715 ‐
Sep 269,199 250,627 ‐
Oct 318,272 297,690 ‐
Nov 368,928 345,586 ‐
Dec 372,972 346,135 ‐
YTD Total 1,909,482$ 1,790,644$ 1,691,502$ (217,980)$ ‐11% (99,142)$ ‐6%
Annual Total 3,817,008$ 3,577,193$
2010 vs. Budget2010 vs. 2009
Year to Date through June
Fines and Penalties by Month
Month
Page 7 of 34
Monthly Financial Report June 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 23% in May and 7% in June
when compared with the same periods in 2009. At this point, the City is projecting Fines and Penalties to be under budget
by $198k by the end of 2010.
Year to Date through June
2009 2010 2010
Actual Budget Actual $ % $ %
Civil Penalties 7,887$ 6,754$ 7,226$ (661)$ ‐8% 472$ 7%
Civil Infraction Penalties 377,172 342,402 368,247 (8,925) ‐2% 25,845 8%
Civil Parking Infraction Penalties 73,576 63,017 67,780 (5,795) ‐8% 4,763 8%
Photo Enforcement Program 1,273,593 1,210,062 1,031,681 (241,911) ‐19% (178,380) ‐15%
Crim Traffic Misdemeanor Fines 46,961 37,510 42,684 (4,277) ‐9% 5,174 14%
Criminal Non‐Traffic Fines 23,454 21,830 16,411 (7,043) ‐30% (5,419) ‐25%
Criminal Costs 79,526 85,488 146,306 66,781 84% 60,818 71%
Non‐Court Fines, Forfeitures and Penalties 27,313 23,581 11,166 (16,147) ‐59% (12,415) ‐53%
YTD Total 1,909,482$ 1,790,644$ 1,691,502$ (217,980)$ ‐11% (99,142)$ ‐6%
Annual Total 3,817,008$ 3,577,193$
2010 vs. 2009
Revenue
2010 vs. Budget
Fines and Penalties by Type
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 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 84% of the total
revenue in this category. The year‐to‐date
total miscellaneous is $722k. Compared to
the projected year‐to‐date budget, the
revenues are over by $44k or up by 6%.
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 ‐ 69,991 ‐ ‐
Aug 143,576 ‐ 69,525 ‐ ‐
Sep 149,862 ‐ 69,700 ‐ ‐
Oct 188,205 ‐ 69,347 ‐ ‐
Nov 240,433 ‐ 70,269 ‐ ‐
Dec 174,325 ‐ 73,194 ‐ ‐
YTD Total 1,210,062$ 1,031,681$ 419,939$ 402,246$ 629,435$
Annual Total 2,250,000$ 841,964$ 1,408,036$
1Actuals of Revenues and Expenses
Revenues Expenses
Photo Enforcement Program
Year to Date through June
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
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 752,565$ 677,927$ 721,867$ (30,698)$ ‐4% 43,940$ 6%
Annual Total 1,529,692$ 1,377,980$
Year to Date through June
Month
2010 vs. Budget2010 vs. 2009
Miscellaneous Revenues by Month
Page 8 of 34
Monthly Financial Report June 2010
2009 2010 2010
Actual Budget Actual $ % $ %
Interests and Other Earnings 269,424$ 213,663$ 168,428$ (100,996)$ ‐37% (45,236)$ ‐21%
Rents, Leases, and Concessions 407,002 354,603 437,749 30,747 8% 83,146 23%
Contributions/Donations from Private Sources 42,519 55,052 55,876 13,356 31% 824 1%
Other 33,620 54,609 59,815 26,195 78% 5,206 10%
YTD Total 752,565$ 677,927$ 721,867$ (30,698)$ ‐4% 43,940$ 6%
Annual Total 1,529,692$ 1,377,980$
2010 vs. Budget
Miscellaneous Revenues by Type
Year to Date through June
Revenue
2010 vs. 2009
EXPENSES
Overall the City has expended 53% of its budgeted general governmental expenditures at the end of June. This is 1.8% or
$951k below year‐to‐date budgeted expenditures. 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 1.8% we
currently have.
The Executive Department appears to be over budget but this is not the case. The difference is primarily caused by the
change in expenditure pattern between 2008/2009 vs. 2010. The forming of the Communications Division mid last year and
we made a lump‐sum interfund‐payment to the Communications Division in July 2009 after the budget adjustment was
approved by the City Council, thus less amount proportionally was shown as spent in the first half of 2009 in the Executive
Department in 2009. Our budget projection relies on the previous two year’s spending patterns, therefore it appears as if
the Executive Department is over budget this year. We expect the department to be on budget when the year‐to‐date
budget catches up with the annual budget.
Similarly, we expect most of the departments currently showing “unfavorable variances” to be on budget by the end of the
year. We do expect the street light electricity cost (Transportation division) to exceed the $935k budget due to a 3.8% rate
increase that was effective April 2010. The 2010 adopted budget for street light electricity is also lower than 2009 year‐end
actual, which also would contribute to over spending the budget.
On the positive variance side, the Finance Department appears to be under budget by $240k. This is due to the $200,000
banking service fees in the carry forward budget amendment that will not be paid until year‐end. The department had a
couple of temporary vacancies in 2010 which also helped the year‐to‐day status. These positions are now filled and we
expect the banking service fees to be substantially higher than we have budgeted for, therefore staff does not expect
savings in Finance at the end of the year, and we will likely need to make an additional adjustment to cover the higher bank
fees.
Page 9 of 34
Monthly Financial Report June 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 ‐ ‐ ‐ ‐ 30,187 24,600 ‐
Grants 61,220 ‐ ‐ 2,699 ‐ 274,107 ‐
Charges for services 8,360 835,787 7,485,233 4,514,814 8,334,681 2,484,446 ‐
Interdepartmental services ‐ ‐ 1,969 120,158 86,375 278,992 ‐
Rents, leases, and misc fees 643,353 162,323 42,000 53,598 ‐ ‐ ‐
Interest and other misc 7,384 9,457 108,925 228,728 156,587 122,008 96
TOTAL REVENUES 720,317 1,007,567 7,638,127 4,919,997 8,607,830 3,184,153 96
EXPENSES:
Utility billing ‐ ‐ 63,809 54,516 46,541 75,809 ‐
Utility systems ‐ ‐ 6,370,189 1,219,887 1,117,788 1,033,630 ‐
Utility maintenance ‐ ‐ 137,222 2,237,595 6,112,725 840,654 ‐
Transportation 512,611 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 847,341 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 512,611 847,341 6,571,220 3,511,998 7,277,054 1,950,093 ‐
AMOUNT AVAILABLE FOR DEBT SERVICE 207,706 160,226 1,066,907 1,407,999 1,330,776 1,234,060 96
DEBT SERVICE:
Principal ‐ 11,426 ‐ 851,500 349,250 109,250 ‐
Interest and other debt service costs ‐ 57,368 ‐ 451,936 216,451 191,674 ‐
TOTAL DEBT SERVICE ‐ 68,794 ‐ 1,303,436 565,701 300,924 ‐
CAPITAL PROJECTS 162,254 159,439 ‐ 885,003 1,525,841 566,679 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 45,452 (68,007) 1,066,907 (780,440) (760,766) 366,457 96
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, June 30, 2010 1,094,535 1,017,794 1,392,941 6,376,668 2,014,772 4,349,299 15,701
Page 10 of 34
Monthly Financial Report June 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,036,862 981,259 ‐ ‐ ‐ ‐ ‐
Telecommunications ‐ 142,899 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 53,684 ‐ 168,750 ‐ ‐ ‐
Communications ‐ ‐ ‐ 270,018 ‐ ‐ ‐
Facilities ‐ ‐ 2,088,121 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 56,222 ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ 125,398 ‐ ‐ ‐ ‐ ‐
Interest and other misc 28,078 11,288 1,197 600 36,093 35,301 19,354
Internal service fund misc:
Vehicle/equipment capital recovery 720,284 498,380 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 1,104,454 ‐ ‐
Worker's compensation / unemployment ‐ ‐ ‐ ‐ 664,574 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 5,547,840 878,055
Other misc 336 ‐ 2,078 ‐ ‐ 225,371 ‐
Disposal of capital assets ‐ ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 54,009 84,869 27,898
TOTAL REVENUES 1,785,560 1,870,116 2,091,396 439,368 1,859,130 5,893,381 925,307
EXPENSES:
Communications 225,666
Equipment rental 1,055,251
Facilities 1,878,643
Healthcare 4,619,371
Information technology 1,476,652
Print and mail ‐ 214,594
Retiree healthcare 527,530
Risk management
Risk management 922,979
Unemployement 199,255
Worker's compensation 605,622
TOTAL EXPENSES 1,055,251 1,476,652 1,878,643 440,260 1,727,856 4,619,371 527,530
AMOUNT AVAILABLE FOR CAPITAL 730,309 393,464 212,752 (892) 131,274 1,274,010 397,777
CAPITAL PROJECTS 629,179 170,826 25,000 29,408 ‐ ‐ ‐
TRANSFERS IN ‐ ‐ ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 101,130 222,638 187,752 (30,300) 131,274 1,274,010 397,777
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, June 30, 2010 4,694,529 1,870,569 278,927 81,518 6,170,783 6,066,462 3,218,250
Page 11 of 34
Monthly Financial Report June 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 165,705
Bond proceeds ‐
Tax Credit (BABs) 837,545
TOTAL REVENUES 1,010,250
EXPENSES:
Salaries and wages ‐
Benefits ‐
Supplies 3,987
Professional services 912,056
Intergovernmental 642,717
Construction 22,199,634
TOTAL EXPENSES 23,758,394
AMOUNT AVAILABLE FOR DEBT SERVICE (22,748,143)
DEBT SERVICE:
Principal ‐
Interest and other debt service costs 861,814
TOTAL DEBT SERVICE 861,814
CHANGE IN FUND BALANCE (23,609,957)
BEGINNING FUND BALANCE, January 1, 2010 80,644,637
ENDING FUND BALANCE, June 30, 2010 57,034,680
Page 12 of 34
Monthly Financial Report June 2010
FUND BALANCE
Page 14 shows the ending fund balance as of June 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 June, the City has $14.7 million reported in combined general governmental fund balance of the current
year’s operating budget, which is approximately 15% of budgeted operating expenditures. This is an increase of $2.8
million from the beginning balance of January 1, 2010. June’s ending fund balance is over the anticipated General
Governmental Fund Balance of $13.9 million by $775k. 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 June 2010
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through June 30, 2010
Funds
Balance
01/01/2010
Budgeted
Revenue
Revenue
06/30/10
Total Funds
Available
Budgeted
Expenditure
Expenditure
06/30/10 Ending Balance
GENERAL GOVERNMENT FUNDS:11,955,285 98,542,948 55,079,252 67,034,537 99,347,239 52,299,100 14,735,437
000 General 8,535,013 74,520,193 38,189,812 46,724,825 72,517,802 34,922,145 11,802,680
001 Community Services 958,009 9,557,924 4,760,034 5,718,043 10,461,433 4,303,348 1,414,695
003 Street 1,391,648 7,201,490 3,952,562 5,344,210 8,543,138 4,197,932 1,146,278
004 Community Dev Block Grant (6,528) 532,635 81,023 74,495 532,227 153,564 (79,069)
005 Museum 64,705 192,621 96,678 161,383 194,120 94,929 66,454
006 Library 706,011 1,888,252 364,923 1,070,934 2,544,263 1,067,015 3,919
009 Farmers Market 60,571 44,280 24,550 85,121 34,311 19,122 65,999
010 Fire Memorial 936 ‐ 315 1,251 ‐ ‐ 1,251
011 Fire Health & Wellness 4,303 25,000 11,935 16,238 25,000 600 15,638
031 Pa rk Memorial 175,066 ‐ 1,109 176,175 ‐ ‐ 176,175
201 Ltd GO Bonds Gen Govt Debt 1,448 2,033,177 415,185 416,633 1,984,625 318,588 98,045
215 Gen Govt Misc Debt Service 64,103 2,547,376 7,181,126 7,245,229 2,510,320 7,221,857 23,372
SPECIAL REVENUE FUNDS:
102 Arterial Street 200,686 620,000 280,737 481,423 620,000 ‐ 481,423
108 Leased City Properties 837,613 1,669,586 931,657 1,769,270 1,511,561 1,140,074 629,196
110 Hotel Motel 247,828 245,000 146,074 393,902 245,000 150,610 243,292
118 Reserve for Paths & Trails 3,264 ‐ 24 3,288 ‐ ‐ 3,288
125 1% For Art 143,796 35,000 916 144,712 50,000 8,611 136,101
127 Cable Communication 89,391 85,000 26,196 115,587 85,674 11,500 104,087
135 Springbrook Wetlands Bank 459,528 ‐ 2,918 462,446 ‐ ‐ 462,446
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 253,563 1,320,156 ‐ ‐ 1,320,156
304 Fire Mitigation 2,363,522 100,000 29,288 2,392,810 560,000 (40,004) 2,432,814
305 Transportation Mitigation 2,167,133 200,000 (36,899) 2,130,234 1,810,000 ‐ 2,130,234
316 Municipal Facilities CIP 6,933,186 1,333,553 622,492 7,555,678 7,621,771 1,019,915 6,535,763
317 Transportation CIP 2,892,341 30,582,042 5,937,214 8,829,555 32,413,734 6,721,847 2,107,708
318 So Lake WA Infrastructure Proj 114,039 ‐ 670 114,709 114,000 47,825 66,884
326 Housing Opportunity 201,653 ‐ 1,283 202,936 ‐ ‐ 202,936
ENTERPRISE FUNDS:
402 Airport 415,929 1,917,163 655,253 1,071,182 1,001,800 512,611 558,571
403 Solid Waste Utility 326,034 15,025,000 7,638,127 7,964,161 15,025,000 6,571,220 1,392,941
404 Golf Course 798,278 2,483,545 1,006,321 1,804,599 2,566,837 958,609 845,990
422 Airport Capital 633,154 1,578,000 65,065 698,219 1,831,485 162,254 535,965
424 Golf Course Capital 287,523 150,000 1,247 288,770 302,499 116,964 171,806
INTERNAL SERVICE FUNDS:
501 Equipment Repair/Replacement 4,593,399 3,631,241 1,785,560 6,378,959 3,413,927 1,684,430 4,694,529
502 Insurance 6,039,509 3,287,584 1,859,130 7,898,639 4,170,106 1,727,856 6,170,783
503 Information Services 1,647,931 4,194,774 1,870,116 3,518,047 4,841,706 1,647,477 1,870,570
504 Facilities 91,175 4,705,475 2,091,396 2,182,571 4,326,200 1,903,643 278,928
505 Communications 111,818 1,049,671 439,368 551,186 877,560 469,668 81,518
512 Insurance, Healthcare 4,792,452 12,358,471 5,893,381 10,685,833 12,462,810 4,619,371 6,066,462
522 Insurance, Leoff1 Retirees HC 2,820,473 2,235,684 925,307 3,745,780 2,248,907 527,530 3,218,250
FIDUCIARY FUNDS:
611 Firemen's Pension 4,332,817 300,000 121,487 4,454,304 550,475 193,663 4,260,641
Funds
Balance
01/01/2010
Budgeted
Revenue
Revenue
06/30/10
Total Funds
Available
Budgeted
Expenditure
Expenditure
06/30/10 Ending Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 13,931,093 44,912,214 16,712,075 30,643,168 51,150,420 17,886,727 12,756,441
405 Water Utility 4,294,833 11,316,610 4,766,949 9,061,782 11,560,951 4,831,514 4,230,268
406 Waste Water Utility 1,887,815 6,070,737 2,802,240 4,690,055 6,780,650 2,357,063 2,332,992
407 Surface Water Utility 2,448,845 5,783,148 2,822,439 5,271,284 6,641,884 2,251,016 3,020,268
416 King County Metro 46,504 11,211,935 5,666,212 5,712,716 11,211,935 5,485,691 227,025
425 Water Utility Construction 2,862,275 3,460,000 153,049 3,015,324 5,510,000 868,923 2,146,401
426 Waste Water Construction 841,219 3,153,781 139,377 980,596 3,995,000 1,525,841 (545,245)
427 Surface Water Construction 1,533,997 3,916,003 361,713 1,895,710 5,450,000 566,679 1,329,031
461 Waterworks Bond Reserve ‐ ‐ ‐ ‐ ‐ ‐ ‐
471 Waterworks Ra te Stabilization 15,605 ‐ 96 15,701 ‐ ‐ 15,701
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
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
Aug 61,148,855
Sep 65,808,951
Oct 77,111,827
Nov 92,687,526
Dec 98,542,948
Percent of budget 55.89%
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
Aug 16,388,472
Sep 16,644,516
Oct 22,547,053
Nov 31,012,799
Dec 31,364,643
Percent of budget 52.77%
$‐
$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
Aug 13,935,185
Sep 15,628,456
Oct 17,436,835
Nov 18,929,142
Dec 20,857,000
Percent of budget 46.33%
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
Aug 9,718,578
Sep 10,760,779
Oct 11,813,935
Nov 12,878,332
Dec 14,228,000
Percent of budget 53.35%
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
Aug 1,631,518
Sep 1,759,093
Oct 2,024,220
Nov 2,153,967
Dec 2,386,376
Percent of budget 49.69%
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
Aug 6,922,028
Sep 7,390,372
Oct 8,027,921
Nov 11,304,114
Dec 11,653,246
Percent of budget 46.57%
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
Aug 4,145,264
Sep 4,604,070
Oct 5,058,558
Nov 5,489,415
Dec 5,997,460
Percent of budget 50.74%
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
Aug 2,337,154
Sep 2,587,781
Oct 2,885,471
Nov 3,231,058
Dec 3,577,193
Percent of budget 47.29%
$‐
$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
Aug 4,301,294
Sep 4,584,474
Oct 5,408,386
Nov 5,791,753
Dec 6,297,095
Percent of budget 41.16%
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 1,416,302
Aug 1,488,990
Sep 1,066,818
Oct 1,135,400
Nov 1,201,158
Dec 1,377,980
Percent of budget 52.39%
$‐
$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
Aug 1,644,120
Sep 1,850,592
Oct 2,058,960
Nov 2,279,304
Dec 2,400,000
Percent of budget 49.08%
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
Aug 62,948,398
Sep 70,847,497
Oct 78,654,203
Nov 86,699,342
Dec 99,347,239
Percent of budget expended 52.64%
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
Aug 180,456
Sep 202,484
Oct 224,540
Nov 246,799
Dec 267,957
Percent of budget expended 48.90%
$‐
$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
Aug 1,341,545
Sep 1,508,802
Oct 1,677,249
Nov 1,836,905
Dec 2,016,361
Percent of budget expended 49.10%
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
Aug 1,087,274
Sep 1,225,811
Oct 1,370,153
Nov 1,499,437
Dec 1,635,047
Percent of budget expended 48.94%
$‐
$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
Aug 1,525,165
Sep 1,700,824
Oct 1,832,622
Nov 2,006,095
Dec 2,164,890
Percent of budget expended 42.78%
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
Aug 1,108,058
Sep 1,244,944
Oct 1,384,635
Nov 1,520,418
Dec 1,621,295
Percent of budget expended 49.33%
$‐
$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
Aug 620,352
Sep 697,386
Oct 773,457
Nov 845,873
Dec 918,169
Percent of budget expended 46.71%
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
Aug 353,278
Sep 394,646
Oct 441,919
Nov 483,769
Dec 518,399
Percent of budget expended 49.88%
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
Aug 2,956,550
Sep 3,332,176
Oct 3,741,593
Nov 4,083,716
Dec 4,792,981
Percent of budget expended 38.58%
Police Budget
YTD
Actual
Annual %
over (under)
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
Millions Other City Services
Budget
Actual
Last Year
$27
$30
Millions Police
Budget
Actual
g ()
Jan 2,165,025 2,260,619 4.42%
Feb 4,517,801 4,238,853 ‐6.17%
Mar 6,790,712 6,677,267 ‐1.67%
Apr 8,836,921 8,955,690 1.34%
May 11,203,428 11,016,981 ‐1.66%
Jun 13,466,812 13,574,734 0.80%
Jul 15,954,657
Aug 18,080,450
Sep 20,560,448
Oct 22,762,743
Nov 25,377,250
Dec 28,022,582
Percent of budget expended 48.44%
$‐
$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
Aug 14,732,889
Sep 16,560,924
Oct 18,349,790
Nov 20,065,074
Dec 21,922,009
Percent of budget expended 50.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
Aug 661,523
Sep 723,147
Oct 781,484
Nov 843,676
Dec 931,014
Percent of budget expended 44.53%
$‐
$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
Aug 528,908
Sep 569,793
Oct 693,393
Nov 748,914
Dec 874,359
Percent of budget expended 42.57%
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
Aug 133,757
Sep 150,300
Oct 166,956
Nov 183,659
Dec 200,440
Percent of budget expended 43.48%
$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
Aug 4,373,869
Sep 4,921,763
Oct 5,481,795
Nov 6,022,924
Dec 6,632,300
Percent of budget expended 49.02%
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
Aug 47,160,502
Sep 53,217,189
Oct 58,976,553
Nov 65,185,527
Dec 72,517,802
Percent of budget expended 48.16%
$‐
$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
Aug 6,929,653
Sep 7,789,687
Oct 8,632,774
Nov 9,503,898
Dec 10,461,433
Percent of budget expended 41.14%
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
Aug 5,565,769
Sep 6,290,996
Oct 7,004,518
Nov 7,710,951
Dec 8,543,138
Percent of budget expended 49.14%
$‐
$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
Aug 339,295
Sep 370,840
Oct 429,422
Nov 467,929
Dec 532,227
Percent of budget expended 28.85%
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
Aug 1,579,352
Sep 1,772,156
Oct 1,974,603
Nov 2,165,372
Dec 2,544,263
Percent of budget expended 41.94%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
Millions Library Fund
Budget
Actual
Last Year
$‐
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
CDBG
Budget
Actual
Last Year
Page 31 of 34
City of Renton
Monthly Expenditure Analysis ‐ 2010 Budget Year
Museum Fund Budget
YTD
Actual
Annual %
over (under)
Jan 15,829 15,310 ‐3.28%
Feb 32,775 31,141 ‐4.99%
Mar 49,002 46,726 ‐4.64%
Apr 65,543 62,643 ‐4.42%
May 82,433 78,771 ‐4.44%
Jun 99,543 94,929 ‐4.63%
Jul 115,981
Aug 132,242
Sep 148,372
Oct 164,641
Nov 180,555
Dec 194,120
Percent of budget expended 48.90%
Note: Prior to 2009, Museum was part of the Library Fund
LTGO Funds Budget
YTD
Actual
Annual %
over (under)
$7.00
$7.50
$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
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%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
$5.50
$6.00
$6.50
$7.00
$7.50
$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
Aug 27,231,086
Sep 30,252,248
Oct 33,275,236
Nov 36,644,712
Dec 45,650,678
Percent of budget expended 47.09%
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
Aug 688,817
Sep 759,575
Oct 838,546
Nov 913,982
Dec 1,001,800
Percent of budget expended 51.17%
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
Aug 1,384,039
Sep 1,549,779
Oct 1,857,389
Nov 1,994,766
Dec 2,566,837
Percent of budget expended 37.35%
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