HomeMy WebLinkAbout201106, June.pdfFINANCE AND
INFORMATION TECHNOLOGY
M E M O R A N D U M
DATE: August 8, 2011
TO: Terri Briere, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: June 2011 Financial Status Report
At the end of June, general governmental revenues show $155k or 0.3% above budget. This is
primarily due to the $272k favorable property tax collection. Sales tax is $53k higher than
budget, which is attributable to one‐time activity that occurred in December 2010 (February
2011 sales tax receipt) and the collection through the state’s sales tax Amnesty Program. Sales
tax activity continues to fluctuate widely from month to month and at this point we anticipate
will meet the budget projection at the end of the year. The revenue sources that underperform
the year to date budget and that are likely to continue this trend for the year are: 1) Permit and
Development fees ($245k below budget at the end of June); 2) REET ($135k below); 3)
Interfund service charges ($296k below, a portion will be processed in July); and 4) Interest
Earnings ($121k below). These underperforming areas are offset by higher than anticipated
utility taxes ($234k); state shared revenues ($338k); and court fines ($53k). Therefore, we
believe the overall revenue collection will be very close to budget for the year.
General government expenditures showed favorable variances of $1.95 million or 3.8%. $1.45
million of the saving is related to SCORE jail start up cost. Most of this savings are due to delay
of billing by SCORE. While we still expect to realize part of the saving this year, it would be
substantially less than the $1.45 million. In addition, part of the jail saving will be needed to
cover the Police department’s pay and benefit budget correction that was approved in August
(2nd Quarter Budget Adjustment). Overall, we anticipate only $500k expenditure savings at the
end of this year.
Some divisions may appear to exceed their budget at the end of June, but most are due to the
timing of various payments. Combined expenditures by department are all within department
budgets.
The attached report provides more detailed discussion of each revenue source and our updated
projections for the year. Please do not hesitate to contact me at x6952 should you have any
questions or any suggestions about the report.
General Governmental Funds
$%
Beginning Fund Balance 11,816,561$ 11,816,561$ 11,955,285$ 11,955,285$ 11,407,119$ 11,407,119$ 11,407,119$ ‐$ 0.0%
OPERATING REVENUES
Property Tax 30,660,522 15,849,213 31,497,128 16,549,647 32,046,525 16,838,318 17,109,916 271,598 1.6%
Sales Tax 17,995,836 9,033,115 17,198,220 8,650,047 17,759,600 8,781,672 8,835,025 53,353 0.6%
Sales Tax ‐ Annexation Credit 2,132,110 1,067,999 2,025,660 1,013,934 2,119,680 1,060,995 995,394 (65,601) ‐6.2%
Criminal Justice Sales Tax 1,650,350 822,569 1,620,479 801,402 1,804,005 892,165 888,626 (3,539) ‐0.4%
Natural Gas Use Tax 242,891 124,780 228,514 140,295 258,750 158,859 159,509 650 0.4%
Admission Tax 260,269 118,330 291,399 141,355 280,000 135,826 134,870 (956) ‐0.7%
Franchise Fees 1,039,031 518,585 1,222,444 594,746 1,260,000 613,018 600,206 (12,811) ‐2.1%
Electricity Tax 4,963,151 2,691,555 5,036,907 2,590,371 4,968,000 2,554,933 2,701,582 146,649 5.7%
Natural Ga s Utility Tax 1,891,255 1,372,181 1,577,756 992,781 1,656,000 1,042,015 1,253,927 211,912 20.3%
Transfer Station 283,985 115,425 269,912 113,722 238,050 100,298 123,452 23,154 23.1%
TV Cable 1,263,743 623,136 1,296,744 667,349 1,366,200 703,093 668,805 (34,288) ‐4.9%
Telephone 1,037,873 504,581 1,038,009 525,879 1,000,000 506,623 492,589 (14,033) ‐2.8%
Cellular Phone 2,027,473 949,633 2,206,637 1,188,049 2,202,000 1,185,552 1,067,301 (118,251) ‐10.0%
City Utilities 2,871,599 1,367,364 2,853,884 1,372,147 3,477,600 1,672,030 1,690,696 18,666 1.1%
Leasehold Excise Tax 146,002 57,477 138,830 65,359 145,000 68,264 82,413 14,150 20.7%
Gambling Excise Tax 2,141,720 1,113,458 1,546,386 809,252 1,600,000 837,309 862,008 24,699 2.9%
Real Estate Excise Tax 2,418,456 1,144,211 2,464,489 1,178,010 2,240,000 1,071,350 900,300 (171,050) ‐16.0%
Less: Municipal Facilities CIP REET (1,000,000) (541,243) (400,000) (197,123) (400,000) (197,123) (160,768) 36,355 ‐18.4%
EMS Levy 1,170,657 585,329 1,161,114 ‐ 950,921 ‐ ‐ ‐ 0.0%
Business License Fees 424,413 214,946 431,782 221,313 463,067 237,348 219,109 (18,240) ‐7.7%
Other Licenses and Permits 176,851 78,523 262,629 107,553 210,255 86,104 96,739 10,635 12.4%
Building Permits & Development Svc Fees 2,361,037 1,176,587 2,437,270 1,272,465 2,706,044 1,430,422 1,185,601 (244,821) ‐17.1%
Intergovt'l (Grants, State Shared, etc) 3,820,932 2,084,578 4,426,676 2,116,995 3,623,386 1,595,811 1,845,254 249,443 15.6%
Fire District 25 and 40 Contracts 5,869,198 2,338,225 5,252,877 2,507,971 5,928,462 3,037,491 3,037,491 ‐ 0.0%
Public Safety 521,484 271,735 482,343 211,924 426,081 187,205 224,410 37,205 19.9%
Culture and Recreation 1,631,486 660,502 1,424,932 655,982 1,628,486 749,690 675,880 (73,810) ‐9.8%
Interfund/Interdept‐Services 3,225,745 1,616,494 3,190,908 1,659,113 3,314,653 1,723,454 1,427,844 (295,610) ‐17.2%
Fines and Forfeits 1,349,034 608,732 1,291,817 558,127 1,088,750 471,665 524,488 52,822 11.2%
Photo Enforcement 2,368,131 1,273,593 1,925,159 1,031,681 1,900,908 1,018,685 1,038,171 19,486 1.9%
Seizure Funds ‐ Federal/State/Local 99,844 27,157 221,046 101,693 180,693 83,128 ‐ (83,128) ‐100.0%
Interests and Other Earnings 535,314 269,424 327,558 168,428 477,730 245,645 124,693 (120,952) ‐49.2%
Rents, Leases, and Concessions 677,960 407,002 727,338 437,749 698,929 420,651 401,045 (19,606) ‐4.7%
Contributions and Donations 150,406 42,519 133,756 55,876 146,800 61,325 81,792 20,467 33.4%
Other Miscellaneous 355,086 122,080 290,239 161,107 352,218 200,829 131,670 (69,159) ‐34.4%
Refunding Debt and Premiums ‐ ‐ 6,613,484 6,613,484 ‐ ‐ ‐ ‐ 0.0%
Other Financing Sources (Transfer‐In, etc) 578,206 277 653,595 570 529,056 168,166 168,166 ‐ 0.0%
Total Operating Revenues 97,342,052 48,710,070 103,367,918 55,079,253 98,647,849 49,742,817 49,588,204 (154,614) ‐0.3%
OPERATING EXPENDITURES
Legislative 247,225 124,734 259,345 131,035 277,834 140,280 134,795 5,484 3.9%
Executive 1,499,747 724,211 1,578,526 800,153 1,484,762 735,255 729,119 6,136 0.8%
City Clerk 646,581 376,007 789,209 414,558 790,484 435,251 420,930 14,321 3.3%
Hearing Examiner 171,911 86,758 174,447 87,146 171,929 86,324 33,294 53,031 61.4%
City Attorney 1,248,380 648,527 1,565,597 799,852 1,600,531 823,807 790,004 33,803 4.1%
Court Services 1,819,731 938,665 2,007,599 990,091 2,148,421 1,082,682 1,040,289 42,392 3.9%
Community and Eco Dvlpmnt Admin 265,269 136,989 579,396 292,116 929,263 472,083 465,217 6,866 1.5%
Development Services 3,615,129 1,868,700 2,946,413 1,497,590 3,164,064 1,623,270 1,431,566 191,704 11.8%
Economic Development 1,244,175 601,432 1,322,004 636,436 745,313 359,523 357,808 1,714 0.5%
Planning 1,525,460 690,456 1,774,508 843,999 1,545,279 718,541 685,502 33,039 4.6%
Finance 1,969,936 1,112,201 2,214,458 926,194 2,101,797 1,023,874 930,622 93,253 9.1%
Human Resources 853,063 417,982 861,221 428,866 977,884 483,070 417,784 65,286 13.5%
Police 22,515,895 11,067,372 23,946,386 12,045,128 23,988,409 11,932,950 12,310,617 (377,667) ‐3.2%
Jail Services 3,317,861 1,572,505 3,539,035 1,529,606 7,043,820 3,186,678 1,735,928 1,450,750 45.5%
Fire 20,378,891 10,619,746 21,554,792 11,039,048 22,045,916 11,386,741 11,333,418 53,323 0.5%
Community Services Admin 1 4,459,381 2,269,052 1,063,011 527,399 412,476 208,871 204,042 4,829 2.3%
Parks 3,894,745 1,749,330 3,421,424 1,570,808 3,928,721 1,782,886 1,750,372 32,515 1.8%
Parks Planning & Natural Resources ‐ ‐ 448,574 185,783 582,186 291,093 256,105 34,988 12.0%
Recreation 4,374,668 1,724,274 4,433,420 1,875,022 5,178,448 2,116,097 2,128,093 (11,996) ‐0.6%
Human Services 1,194,142 498,258 1,326,778 525,801 1,363,272 553,794 560,790 (6,996) ‐1.3%
Neighborhoods, Resources, & Events 348,185 142,451 331,222 144,336 688,984 290,830 252,486 38,344 13.2%
Library 2,321,878 1,018,530 2,289,692 1,067,015 2,030,000 1,815,119 1,815,119 ‐ 0.0%
Museum 140,801 72,814 191,090 94,929 208,407 105,332 104,539 794 0.8%
Public Works Admin 1 942,026 473,965 514,858 258,597 454,179 228,374 224,646 3,728 1.6%
Street Maintenance 3,794,716 1,939,251 3,412,892 1,638,385 3,693,925 1,833,551 1,755,569 77,982 4.3%
Transportation 5,110,639 2,512,585 5,215,309 2,559,547 4,606,639 2,262,793 2,164,571 98,222 4.3%
Debt Service 4,176,822 975,344 11,320,584 7,540,445 4,715,035 1,285,140 1,285,140 ‐ 0.0%
Non‐Departmental and Other 5,126,072 2,214,884 4,834,296 1,849,216 3,820,946 3,412,280 3,412,280 ‐ 0.0%
Total Operating Expenditures 97,203,328 46,577,024 103,916,084 52,299,100 100,698,925 50,676,491 48,730,646 1,945,844 3.8%
Total Ending Fund Balance 11,955,285$ 13,949,608$ 11,407,119$ 14,735,438$ 9,356,043$ 10,473,446$ 12,264,677$ 1,791,231 17.1%
1Facilities was included in Community Services Admin and Technical Services was included in Public Works Admin in 2009
Favorable (Unfavorable)
2009 2010 2011 Variance
Annual Actual YTD Actual Annual Budget YTD Budget YTD ActualSummary of Sources and Uses Annual Actual YTD Actual
Monthly Financial Report June 2011
Page 1 of 37
Monthly Financial Report June 2011
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through June 30, 2011. 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, sales/use, utility, gambling, admissions, and real estate excise taxes represents 76% 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 $55k, making the
total year‐to‐date collection $17.1
million or 53% of the total budget. In
comparison to the previous year, the
City collected $560k or 3% more.
Compared to the budget, the City is
above projections by $272k or 2%.
The City is projecting property taxes
to meet the 2011 budget at year‐end.
The April/May variance is due to the
timing of collections. When the two
months are combined, the City is
$198k or 1% behind budget but $70k
ahead of last year.
Sales Tax
June 2011 sales tax receipts totalled
$1.4 million. Compared to the same
month last year, it is $14k or 1% less.
Compared to the projected current
month’s budget, it is below projections
by $49k or 3%. The year‐to‐date
collection is $8.8 million or 50% of the
sales tax budget, which is $185k or 2%
more than the prior year and $53k or
1% higher than the budget. Based on
the year‐to‐date collection, the City
projected sales tax revenues to be very
close to budget projection at the end
of 2011.
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 218,705$ 222,520$ 505,501$ 286,797$ 131% 282,981$ 127%
Feb 270,809 275,532 336,193 65,385 24% 60,661 22%
Mar 547,632 557,184 745,285 197,653 36% 188,101 34%
Apr 6,660,829 6,777,012 7,618,492 957,664 14% 841,480 12%
May 8,736,691 8,889,083 7,849,481 (887,210) ‐10% (1,039,602) ‐12%
Jun 114,982 116,988 54,963 (60,019) ‐52% (62,025) ‐53%
Jul 87,952 89,486
Aug 149,160 151,761
Sep 491,642 500,217
Oct 7,060,074 7,183,221
Nov 7,288,083 7,029,490
Dec (129,429) 254,031
YTD Total 16,549,647$ 16,838,318$ 17,109,916$ 560,269$ 3% 271,597$ 2%
Annual Total 31,497,128$ 32,046,525$
Property Tax Revenues
Year to Date through June
2011 vs. 2010 2011 vs. Budget
Month
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 1,289,364$ 1,408,501$ 1,339,658$ 50,295$ 4% (68,843)$ ‐5%
Feb 1,728,588 1,737,756 1,982,269 253,682 15% 244,513 14%
Mar 1,289,589 1,341,244 1,299,237 9,648 1% (42,007) ‐3%
Apr 1,461,123 1,350,144 1,254,867 (206,257) ‐14% (95,277) ‐7%
May 1,499,335 1,526,532 1,590,780 91,446 6% 64,248 4%
Jun 1,382,049 1,417,495 1,368,213 (13,835) ‐1% (49,282) ‐3%
Jul 1,309,429 1,420,358 ‐
Aug 1,470,881 1,542,957 ‐
Sep 1,408,876 1,472,089 ‐
Oct 1,447,338 1,539,380 ‐
Nov 1,508,617 1,530,976 ‐
Dec 1,403,032 1,472,168 ‐
YTD Total 8,650,047$ 8,781,672$ 8,835,025$ 184,978$ 2% 53,353$ 1%
Annual Total 17,198,220$ 17,759,600$
2011 vs. Budget2011 vs. 2010
Month
Year to Date through June
Local Retail Sales Tax Revenues
Page 2 of 37
Monthly Financial Report June 2011
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 2010 2011 Bgt YTD Act Change 2011/2010 2011 Act vs Bgt
New Construction 1,192,385$ 854,011$ 700,577$ (491,808)$ ‐41%$ (153,434)‐18%
Auto Sales 1,466,378 1,643,354 1,577,774 111,395 8% (65,581)‐4%
General Retail 2,985,784 3,127,456 3,063,981 78,198 3% (63,474)‐2%
Manufacturing 388,649 425,003 621,573 232,924 60% 196,570 46%
Wholesale 470,013 537,088 553,349 83,336 18% 16,261 3%
Service 1,852,873 1,917,723 1,952,272 99,399 5% 34,548 2%
Other 293,966 277,038 365,500 71,534 24% 88,462 32%
Total 8,650,047$ 8,781,672$ 8,835,025$ 184,978$ 2%53,353$ 1%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility tax
June utility tax revenues are $1.2
million, which is $38k or 3% higher than
the same month last year but behind
the budget by $18k or 1%. The year‐to‐
date collection is $8.2 million, which is
$567k or 7% higher than the prior year
and is also $234k or 3% higher than the
budget. Based on collections so far the
City is projecting utility taxes to meet
the 2011 budget at the end of the year.
The table below breaks out Utility Tax
by source:
Utility Tax by Type 2010 2011 Bgt YTD Act Change 2011/2010 2011 Act vs Bgt
Electrical 2,590,371$ 2,554,933$ 2,701,582$ 111,211$ 4%$ 146,649 6%
Natural Gas 1,133,077 1,200,874 1,413,436 280,359 25% 212,562 18%
Cell 1,188,049 1,185,552 1,067,301 (120,748) ‐10% (118,251)‐10%
Phone 525,879 506,623 492,589 (33,290) ‐6% (14,033)‐3%
Cable 667,349 703,093 668,805 1,456 0% (34,288)‐5%
Transfer Station 113,722 100,298 123,452 9,730 9% 23,154 23%
City Utilities 1,372,147 1,672,030 1,690,696 318,549 23% 18,666 1%
YTD Total 7,590,593$ 7,923,403$ 8,157,861$ 567,268$ 7%234,458$ 3%
Annual Total 14,508,363$ 15,166,600$
YTD as % of 52% 52%
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 1,392,232$ 1,449,257$ 1,363,023$ (29,209)$ ‐2% (86,234)$ ‐6%
Feb 1,245,631 1,302,522 1,448,275 202,644 16% 145,753 11%
Mar 1,295,732 1,346,959 1,480,840 185,108 14% 133,881 10%
Apr 1,260,110 1,321,643 1,370,718 110,608 9% 49,075 4%
May 1,231,700 1,281,842 1,291,530 59,830 5% 9,687 1%
Jun 1,165,188 1,221,180 1,203,475 38,287 3% (17,705) ‐1%
Jul 1,140,413 1,193,031
Aug 1,131,693 1,190,578
Sep 1,082,231 1,136,760
Oct 1,138,457 1,193,046
Nov 1,112,608 1,157,583
Dec 1,312,366 1,372,199
YTD Total 7,590,593$ 7,923,403$ 8,157,861$ 567,268$ 7% 234,458$ 3%
Annual Total 14,508,363$ 15,166,600$
2011 vs. Budget2011 vs. 2010
Year to Date through June
Utility Tax Revenues
Month
Page 3 of 37
Monthly Financial Report June 2011
Other Taxes
Real Estate Excise Tax
The City collected $229k in Real Estate
Excise Tax revenues (REET) in June. This
is $54k or 31% above the current
month’s budget and $37k or 19% ahead
of the same month last year. The year‐
to‐date collection is $900k or 40% of the
total budget, which is $278k or 24% less
than the prior year and is also $171k or
16% below the budget. Based on the
collections so far, the City is projecting
REET to be under the 2011 budget by
year‐end.
Gambling Tax
June’s Gambling Tax collections
total $151k. Year‐to‐date total of
$862k is $53k or 7% above the
year before and is also $25k or 3%
above budget.
Pull tabs overall increased by 3%,
bingo reduced by 42%, and card‐
rooms are seeing 8% higher in
activities when compared to the
prior year.
Franchise Fees
Franchise Fees are due quarterly
and the year‐to‐date revenue
collections are $600k. This is $13k
or 2% below the projected year‐
to‐date budget but $5k or 1%
higher than 2010.
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 71,303$ 64,842$ 161,911$ 90,608$ 127% 97,069$ 150%
Feb 107,242 97,524 99,677 (7,565) ‐7% 2,153 2%
Mar 309,164 281,121 141,700 (167,464) ‐54% (139,421) ‐50%
Apr 281,746 256,194 110,987 (170,759) ‐61% (145,207) ‐57%
May 216,814 197,233 157,519 (59,295) ‐27% (39,714) ‐20%
Jun 191,741 174,436 228,506 36,765 19% 54,070 31%
Jul 149,706 136,195
Aug 209,369 190,471
Sep 123,054 111,936
Oct 183,333 176,560
Nov 203,091 184,761
Dec 417,925 368,726
YTD Total 1,178,010$ 1,071,350$ 900,300$ (277,710)$ ‐24% (171,050)$ ‐16%
Annual Total 2,464,489$ 2,240,000$
Month
2011 vs. Budget2011 vs. 2010
Real Estate Excise Tax Revenues
Year to Date through June
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 135,608$ 140,310$ 118,304$ (17,304)$ ‐13% (22,005)$ ‐16%
Feb 137,736 142,512 135,926 (1,811) ‐1% (6,586) ‐5%
Mar 63,054 134,061 135,067 72,013 114% 1,006 1%
Apr 196,085 134,062 162,459 (33,626) ‐17% 28,397 21%
May 133,979 138,624 159,013 25,034 19% 20,389 15%
Jun 142,790 147,741 151,240 8,450 6% 3,499 2%
Jul 125,614 129,969 ‐
Aug 138,563 143,368 ‐
Sep 105,323 108,974 ‐
Oct 126,396 130,779 ‐
Nov 121,757 125,978 ‐
Dec 119,481 123,624 ‐
YTD Total 809,252$ 837,309$ 862,008$ 52,756$ 7% 24,699$ 3%
Annual Total 1,546,386$ 1,600,000$
2011 vs. 2010 2011 vs. Budget
Gambling Tax Revenue
Month
Year to Date through June
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 320,478$ 330,324$ 305,646$ (14,833)$ ‐5% (24,678)$ ‐7%
Apr 274,268 282,694 294,560 20,293 7% 11,867 4%
Jul 286,523 295,326 ‐
Aug 6,691 6,896 ‐
Oct 289,316 298,204 ‐
Dec 45,169 46,556 ‐
YTD Total 594,746$ 613,018$ 600,206$ 5,460$ 1% (12,811)$ ‐2%
Annual Total 1,222,444$ 1,260,000$
Franchise Fees Revenue
Year to Date through June
Month
2011 vs. 2010 2011 vs. Budget
Page 4 of 37
Monthly Financial Report June 2011
Admission Tax
Admission Tax returns are due
quarterly in January, April, July,
and October each year. April
2011 collections represent
activities conducted during the 1st
quarter of 2011.
The report shows a decrease of
$6k or 5% from the year before
and also a $1k or 1% less than
anticipated.
Licenses and Permits
Building Permits and Development Service Fees
Building Permits and Development
Service Fee revenues totalled $216k in
June. The revenue swing between the
high in January 2010 and the low in
February 2010 is primarily attributable
to the rush of getting permits completed
prior to the new school impact fees
taking effect. The year‐to‐date
development fees revenue of $1.2
million is $245k or 17% less than the
budget and is also $87k or 7% lower
than 2010.
Business Licenses
Business Licenses totalled $4k for June, which is
$1k or 16% below the same month last year and
is also $1k or 22% below the current month’s
budget. The year‐to‐date Business Licenses
revenue is under the budget by $18k or 8% and
is also $2k or 1% below last year.
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 74,777$ 71,852$ 70,405$ (4,372)$ ‐6% (1,447)$ ‐2%
Feb 459 441 477 18 4% 35 8%
Apr 66,119 63,533 63,582 (2,538) ‐4% 49 0%
May ‐ ‐ 407 407 100% 407 100%
Jul 76,024 73,050 ‐
Aug 485 466 ‐
Oct 73,073 70,215 ‐
Nov 462 444 ‐
YTD Total 141,355$ 135,826$ 134,870$ (6,485)$ ‐5% (956)$ ‐1%
Annual Total 291,399$ 280,000$
Month
2011 vs. 2010 2011 vs. Budget
Admission Tax Revenue
Year to Date through June
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 77,955$ 83,603$ 84,109$ 6,154$ 8% 506$ 1%
Feb 33,440 35,863 23,153 (10,287) ‐31% (12,710) ‐35%
Mar 5,687 6,099 3,811 (1,875) ‐33% (2,287) ‐38%
Apr 77,964 83,612 83,930 5,966 8% 317 0%
May 21,558 23,120 20,142 (1,417) ‐7% (2,979) ‐13%
Jun 4,709 5,051 3,964 (745) ‐16% (1,086) ‐22%
Jul 83,201 89,230 ‐
Aug 14,782 15,853 ‐
Sep 4,475 4,799 ‐
Oct 83,639 89,699 ‐
Nov 22,288 23,903 ‐
Dec 2,084 2,235 ‐
YTD Total 221,313$ 237,348$ 219,109$ (2,204)$ ‐1% (18,240)$ ‐8%
Annual Total 431,782$ 463,067$
Business Licenses
Month
2011 vs. 2010
Year to Date through June
2011 vs. Budget
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 394,165$ 454,717$ 132,621$ (261,545)$ ‐66% (322,096)$ ‐71%
Feb 93,037 100,788 141,672 48,634 52% 40,884 41%
Mar 172,096 188,567 265,782 93,686 54% 77,215 41%
Apr 180,514 207,481 190,534 10,020 6% (16,946) ‐8%
May 221,843 238,569 239,018 17,175 8% 448 0%
Jun 210,810 240,300 215,975 5,165 2% (24,325) ‐10%
Jul 319,462 336,067
Aug 167,001 194,145
Sep 158,882 183,653
Oct 223,901 232,210
Nov 125,748 143,854
Dec 169,811 185,693
YTD Total 1,272,465$ 1,430,422$ 1,185,601$ (86,864)$ ‐7% (244,821)$ ‐17%
Annual Total 2,437,270$ 2,706,044$
Building Permits and Development Service Fees
Year to Date through June
2011 vs. Budget2011 vs. 2010
Month
Page 5 of 37
Monthly Financial Report June 2011
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 92%
of the total revenues in this category. The year‐to‐date total Intergovernmental revenue is $5.8 million or 51% of the
budget. All grant revenues also have corresponding expenditures which was added to the City’s budget through the 2011
carry forward budget adjustment.
State Shared Revenues
State Shared Revenue
collections totalled $2.2 million
since the start of 2011.
Compared to the projected
budget, State Shared Revenues
are above by $338k or 18%.
Compared to the prior year, the
City is collecting $221k or 11%
more. The actual collection
that lags budget is primarily
due to the reduced criminal
justice sales tax (King County
countywide sales tax decrease).
The City is projecting State
Shared Revenues to meet the 2011 budget by the end of the year.
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. Recreation and interfund/interdepartmental sales and services
constitute 75% of the total revenue in this category. The year‐to‐date total charges for services are $2.8 million or 44% of
the budget. This is 10% below budget projections. The following sections provide detail information for Public Safety,
Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totalled $224k since
the start of the year. These services include
private security, adult probation services,
and housing/monitoring of prisoners.
Compared to the budget, the City is
collecting $37k or 20% more than
anticipated revenue. Compared to the
prior year, the City is collecting $12k or 6%
more. The City is projecting Public Safety
Service revenues to meet the 2011
projected budget by year‐end.
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 35,994$ 31,795$ 18,824$ (17,169)$ ‐48% (12,971)$ ‐41%
Feb 29,971 26,475 40,902 10,931 36% 14,427 54%
Mar 34,786 30,728 30,346 (4,440) ‐13% (382) ‐1%
Apr 47,687 42,125 52,434 4,746 10% 10,309 24%
May 36,393 32,148 35,609 (784) ‐2% 3,461 11%
Jun 27,093 23,933 46,295 19,202 71% 22,362 93%
Jul 57,010 50,360 ‐
Aug 34,206 30,217 ‐
Sep 42,316 37,380 ‐
Oct 39,487 34,881 ‐
Nov 24,065 21,258 ‐
Dec 73,334 64,780 ‐
YTD Total 211,924$ 187,205$ 224,410$ 12,485$ 6% 37,205$ 20%
Annual Total 482,343$ 426,081$
Month
2011 vs. 2010
Year to Date through June
Public Safety Services
2011 vs. Budget
Intergovernmental 2010 2011 Bgt YTD Act Change 2011/2010 2011 Act vs Bgt
Fire District #25 558,243$ 648,943$ 648,943$ 90,700$ 16% $ ‐ 0%
Fire District #40 1,949,728 2,388,548 2,388,548 438,820 23%‐ 0%
State Shared Revenue 2,026,589 1,910,411 2,247,970 221,381 11% 337,559 18%
Federal Grants 407,473 164,024 164,024 (243,449) ‐60%‐ 0%
State Grants 137,761 83,986 83,986 (53,775) ‐39%‐ 0%
Other Grants/Intgovt 108,517 101,323 101,323 (7,195) ‐7%‐ 0%
ARRA Grants 238,056 136,576 136,576 (101,480) ‐43%‐ 0%
Total Rev YTD 5,426,368$ 5,433,811$ 5,771,371$ 345,003$ 6%337,559$ 6%
Total Rev Annual 11,300,032$ 11,355,853$
YTD %48% 48% 51%
Note: Includes CJ Sales Tax.
2010 2011 2011
Actual Budget Actual $ % $ %
Crim Just Sales Tax 801,402$ 892,165$ 888,626$ 87,223$ 11% (3,539)$ 0%
Judicial Contribution 17,229 7,253 11,234 (5,995)$ ‐35% 3,981 55%
Crim Just ‐ High Crime ‐ ‐ 96,385 96,385 100% 96,385 100%
Crim Just ‐ Pop 9,223 ‐ 9,840 617 7% 9,840 100%
Crim Just ‐ Spec Prog 35,060 32,997 37,165 2,105 6% 4,168 13%
State DUI 7,871 7,475 10,176 2,305 29% 2,701 36%
Liquor Profits 351,048 207,613 355,913 4,865 1% 148,300 71%
Liquor Excise Tax 213,880 213,953 220,756 6,876 3% 6,803 3%
Fuel Tax 590,876 548,956 617,875 26,999 5% 68,920 13%
YTD Total 2,026,589$ 1,910,411$ 2,247,970$ 221,381$ 11% 337,559$ 18%
Annual Total 4,189,298$ 3,874,444$
2011 vs. Budget
State Shared Revenues
2011 vs. 2010
Revenue
Year to Date through June
Page 6 of 37
Monthly Financial Report June 2011
Recreation
Recreation revenues totalled $144k for
the current month. Compared to the
projected monthly budget, the City
collected $77k or 35% less. Compared to
the same month the prior year, the City
collected $49k or 25% less. The year‐to‐
date collection of $676k is $20k or 3%
more than the prior year but $74k or 10%
less than the budget. The City is
projecting Recreation revenues to be
slighting under the 2011 budget by year‐
end.
Interfund Services
The year‐to‐date collections for Interfund
Services revenues are $1.4 million.
Compared to the projected budget, the
revenues are below by $296k or 17%.
Compared to the prior year, the revenues
are under by $231k or 14%. The majority
of these revenues are related to indirect
cost allocations, which are internal
administrative costs. The remaining costs
consist of Development Services
division’s inspection fees, Transportation
division’s capital investment program
reimbursements, and Maintenance
division’s street maintenance
reimbursements.
Fines and Penalties
These revenue sources contain civil
(penalties, infractions, and parking),
criminal (traffic, non‐traffic, and costs),
and non‐court fines, forfeitures, and
penalties. The table on the following
page breaks down these fines by type.
The year‐to‐date total fines and
penalties is $1.5 million. This is $143k
or 8% lower than a year ago and also
$25k or 2% below the budget. This
difference also includes $83k lower
than budgeted Seizure Funds received
this year. The use of Seizure Funds is
restricted to drug enforcement only
and not available for general operating
purposes.
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 62,673$ 71,626$ 61,933$ (740)$ ‐1% (9,693)$ ‐14%
Feb 64,915 74,189 82,497 17,582 27% 8,309 11%
Mar 99,100 113,257 99,537 437 0% (13,720) ‐12%
Apr 152,452 174,230 153,717 1,265 1% (20,513) ‐12%
May 83,760 95,725 134,113 50,354 60% 38,388 40%
Jun 193,082 220,664 144,083 (48,999) ‐25% (76,581) ‐35%
Jul 280,956 321,091 ‐
Aug 181,356 207,263 ‐
Sep 111,952 127,945 ‐
Oct 77,544 88,621 ‐
Nov 51,672 59,054 ‐
Dec 65,469 74,822 ‐
YTD Total 655,982$ 749,690$ 675,880$ 19,898$ 3% (73,810)$ ‐10%
Annual Total 1,424,932$ 1,628,486$
Recreation
Year to Date through June
2011 vs. Budget2011 vs. 2010
Month
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 242,658$ 252,068$ 190,881$ (51,777)$ ‐21% (61,187)$ ‐24%
Feb 273,674 284,288 282,743 9,068 3% (1,545) ‐1%
Mar 249,758 259,444 251,144 1,386 1% (8,300) ‐3%
Apr 348,019 361,516 231,156 (116,864) ‐34% (130,360) ‐36%
May 269,154 279,591 237,043 (32,111) ‐12% (42,549) ‐15%
Jun 275,850 286,548 234,878 (40,972) ‐15% (51,670) ‐18%
Jul 263,285 273,495 ‐
Aug 248,584 258,224 ‐
Sep 238,713 247,970 ‐
Oct 241,403 250,765 ‐
Nov 255,986 265,913 ‐
Dec 283,824 294,831 ‐
YTD Total 1,659,113$ 1,723,454$ 1,427,844$ (231,269)$ ‐14% (295,610)$ ‐17%
Annual Total 3,190,908$ 3,314,653$
Interfund Services
Year to Date through June
2011 vs. 2010 2011 vs. Budget
Month
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 239,080$ 223,938$ 165,721$ (73,360)$ ‐31% (58,218)$ ‐26%
Feb 228,332 210,821 261,655 33,322 15% 50,833 24%
Mar 279,311 259,871 313,067 33,756 12% 53,196 20%
Apr 294,612 273,484 289,767 (4,845) ‐2% 16,283 6%
May 276,543 257,620 255,949 (20,594) ‐7% (1,671) ‐1%
Jun 373,623 347,746 262,444 (111,179) ‐30% (85,301) ‐25%
Jul 256,225 239,290
Aug 319,267 286,019
Sep 231,632 208,702
Oct 267,539 247,930
Nov 314,160 297,164
Dec 352,044 317,767
YTD Total 1,691,502$ 1,573,479$ 1,548,602$ (142,900)$ ‐8% (24,877)$ ‐2%
Annual Total 3,432,368$ 3,170,351$
2011 vs. Budget2011 vs. 2010
Year to Date through June
Fines and Penalties by Month
Month
Page 7 of 37
Monthly Financial Report June 2011
Year to Date through June
2010 2011 2011
Actual Budget Actual $ % $ %
Civil Penalties 7,226$ 6,672$ 5,792$ (1,433)$ ‐20% (880)$ ‐13%
Civil Infraction Penalties 368,247 332,849 330,123 (38,124) ‐10% (2,725) ‐1%
Civil Parking Infraction Penalties 67,780 69,759 52,844 (14,936) ‐22% (16,914) ‐24%
Photo Enforcement Program 1,031,681 1,018,685 1,038,171 6,490 1% 19,486 2%
Criminal Traffic Misdemeanor Fines 42,684 39,044 49,533 6,849 16% 10,489 27%
Criminal Non‐Traffic Fines 16,411 16,721 13,611 (2,800) ‐17% (3,110) ‐19%
Criminal Costs 44,614 4,676 58,287 13,673 31% 53,610 1146%
Seizure Funds ‐ Federal/State/Local 101,693 83,128 ‐ (101,693) 0% (83,128) 0%
Non‐Court Fines, Forfeitures and Penalties 11,166 1,945 240 (10,926) ‐98% (1,705) ‐88%
YTD Total 1,691,502$ 1,573,479$ 1,548,602$ (142,900)$ ‐8% (24,877)$ ‐2%
Annual Total 3,432,368$ 3,170,351$
Revenue
2011 vs. Budget
Fines and Penalties by Type
2011 vs. 2010
Included in the Fines and Penalties revenue budget
is $1.9 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 Services Department 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 $629k. Compared to the
projected year‐to‐date budget, the
revenues are under by $188k or 23%.
Compared to last year, the revenues are
under by $93k or 13%. The table on the
next page breaks out Miscellaneous
revenues by type:
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 170,998$ 181,164$ 143,105$ (27,892)$ ‐16% (38,058)$ ‐21%
Feb 86,124 99,440 70,237 (15,887) ‐18% (29,203) ‐29%
Mar 115,122 132,824 99,131 (15,990) ‐14% (33,692) ‐25%
Apr 99,376 114,159 74,048 (25,327) ‐25% (40,110) ‐35%
May 101,909 116,069 97,083 (4,826) ‐5% (18,986) ‐16%
Jun 148,339 173,389 145,018 (3,321) ‐2% (28,371) ‐16%
Jul 158,134 177,832
Aug 93,081 107,144
Sep 110,810 124,170
Oct 73,018 86,617
Nov 56,175 67,061
Dec 56,503 64,592
YTD Total 721,867$ 817,044$ 628,624$ (93,244)$ ‐13% (188,420)$ ‐23%
Annual Total 1,269,588$ 1,444,459$
Year to Date through June
Month
2011 vs. Budget2011 vs. 2010
Miscellaneous Revenues by Month
Favorable
Budget Actual Budget Actual (Unfavorable)
1
Jan 184,922$ 165,696$ 76,201$ 67,883$ 97,812$
Feb 133,857 163,932 76,693 67,885 96,048
Mar 170,080 198,197 76,201 67,852 130,345
Apr 160,472 177,597 53,048 67,991 109,606
May 154,236 157,076 71,882 67,999 89,077
Jun 215,118 175,673 71,871 67,934 107,739
Jul 144,584 ‐ 72,275 ‐ ‐
Aug 126,504 ‐ 56,688 ‐ ‐
Sep 90,979 ‐ 71,527 ‐ ‐
Oct 158,357 ‐ 71,420 ‐ ‐
Nov 208,633 ‐ 71,884 ‐ ‐
Dec 153,166 ‐ 72,273 ‐ ‐
YTD Total 1,018,685$ 1,038,171$ 425,897$ 407,545$ 630,627$
Annual Total 1,900,908$ 841,964$
1Actuals of Revenues and Expenses
Revenues Expenses
Photo Enforcement Program
Year to Date through June
Month
Page 8 of 37
Monthly Financial Report June 2011
2010 2011 2011
Actual Budget Actual $ % $ %
Interests and Other Earnings 168,428$ 245,645$ 124,693$ (43,735)$ ‐26% (120,952)$ ‐49%
Rents, Leases, and Concessions 437,749 420,651 401,045 (36,704) ‐8% (19,606) ‐5%
Contributions/Donations from Private Sources 55,876 61,325 81,792 25,916 46% 20,467 33%
Other 59,815 89,423 21,094 (38,721) ‐65% (68,329) ‐76%
YTD Total 721,867$ 817,044$ 628,624$ (93,244)$ ‐13% (188,420)$ ‐23%
Annual Total 1,269,588$ 1,444,459$
2011 vs. Budget
Miscellaneous Revenues by Type
Year to Date through June
Revenue
2011 vs. 2010
Rents, Leases, and Concessions are lower than the prior year due to receiving fewer revenues for the Carco Theater, Coulon
boat launches, and Fitness area rentals. Other revenues are lower than the prior year because this type of revenue stream
is one‐time types (unclaimed property, miscellaneous reimbursements for accidents, sale of scrap, etc.), which we would
expect to fluctuate.
EXPENSES
Overall the City has expended 48% of its budgeted general governmental expenditures at the end of June. This is $1.95
million or 3.8% 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 expenditure variances.
The Police Department is over budget by $378k or 3.2%. The majority of this is due to higher than anticipated salaries and
wages (by $263k), overtime (by $190k) and benefits (by $87k) and under spending in professional services (by $211k). Of
the $263k overage for salaries and wages (which includes budgeted uniform allowance), $82k is related to various sick and
vacation buy back/pay outs that was not included in the budget. If we remove this amount, Police would only be $295k or
2.5% over budget. Police salaries and benefits budget was under estimated for the year and a $540k budget adjustment
will be included in the 2nd Quarter amendment to correct this.
The Recreation division of Community Services Department is over budget by $12k or 0.6%. Majority of this is due to a
prior period payment ($28k for 2009) for natural gas for the Henry Moses Aquatic Center. We will monitor their budget to
determine if a budget adjustment is necessary to cover this expense at year‐end.
The Human Services division of Community Services Department is over budget by $7k or 1.3%. This is due to the dollar
amount of professional services contract payments made in 2009 and 2010 compared to 2011. Invoices were lower in
dollar amount in the year for 2009 and 2010 and therefore would skew the current 2011 year‐to‐date budget. The year‐to‐
date budget will correct itself by the end of the year.
Page 9 of 37
Monthly Financial Report June 2011
CASH AND INVESTMENTS – 2ND QUARTER
The current cash and investments (C&I)
portfolio is provided in the table to the
right. The City’s current C&I balance is
$66.6 million, of this amount; $1.875
million is an interfund loan investment (Res
4070) from the general fund (000) to the
golf course fund (404). This interfund loan
is due in full on December 1st 2015.
Currently the majority of the portfolio is
located in the State’s Investment Pool
(43.3%). The rest is spread out between
various certificates of deposits (total of
53.9%) and the interfund loan (2.8%).
State Investment Pool
$28,859,006.36
43%
Golf Course $1,875,000.00
3%
First Savings Bank
Northwest $4,656,952.52
7%
Columbia Bank
$6,750,000.00
10%
Fortune Bank (CDARS)
$3,252,108.27
5%
Sterling Bank
$5,000,000.00
8%
Umpqua Bank
$10,182,635.66
15%
Commencement Bank
(CDARS) $6,062,327.91
9%
Distribution by Institution
(Percent of Portfolio)
Allowed per
policy
Average
interest rate
Current Portfolio
Distribution
Current Principal
Balance
Cash
US Bank N/A 0.50%N/A 8,204,731$
Golf
Interfund Investment N/A 2.25%2.81% 1,875,000$
US Treasury Securities
none 100% N/A 0.00%‐$
Local Government Investment Pool
State Investment Pool 75% 0.16%43.31%28,859,006$
US Federal Agency Securities *
0.00%‐$
Certificate of Deposit
First Savings Bank Northwest 0.92%6.99% 4,656,953$
Columbia Bank 0.86%10.13% 6,750,000$
Fortune Bank (CDARS)0.98%4.88% 3,252,108$
Sterling Bank 0.70%7.50% 5,000,000$
Umpqua Bank 1.05%15.28% 10,182,636$
Commencement Bank (CDARS)1.13%9.10% 6,062,328$
Commercial Paper ‐$
none 5%N/A
100.00% 66,638,031$
Institution
TOTAL INVESTMENTS
20%
Page 10 of 37
Monthly Financial Report June 2011
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
Metro
REVENUES:
Licenses and permits ‐ ‐ ‐ ‐ 16,705 16,300 ‐
Grants / intergovernmental 63,917 ‐ 122,607 ‐ ‐ 41,891 ‐
Charges for services 55,211 768,281 7,458,193 5,404,574 3,685,178 3,273,018 6,354,782
Interdepartmental services ‐ ‐ ‐ 106,388 65,011 204,415 ‐
Fines and penalties ‐ ‐ ‐ ‐ ‐ ‐ ‐
Rents, leases, and misc fees 1,142,287 140,640 41,678 69,387 ‐ ‐ ‐
Interest and other misc 6,007 1,298 8,727 207,158 134,677 83,150 1,378
TOTAL REVENUES 1,267,422 910,219 7,631,205 5,787,507 3,901,571 3,618,774 6,356,160
EXPENSES:
Utility billing ‐ ‐ 57,343 72,382 41,575 67,379 ‐
Utility systems ‐ ‐ 6,371,843 1,383,258 1,220,883 1,052,148 ‐
Utility maintenance ‐ ‐ 119,725 2,185,449 595,482 802,050 6,328,998
Transportation 554,642 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 846,330 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 554,642 846,330 6,548,911 3,641,089 1,857,940 1,921,577 6,328,998
AMOUNT AVAILABLE FOR DEBT SERVICE 712,780 63,889 1,082,294 2,146,418 2,043,631 1,697,197 27,162
DEBT SERVICE:
Principal ‐ 9,984 ‐ 1,048,425 722,526 138,340 ‐
Interest and other debt service costs ‐ 127 ‐ 453,682 233,715 188,446 ‐
TOTAL DEBT SERVICE ‐ 10,111 ‐ 1,502,107 956,241 326,786 ‐
CAPITAL PROJECTS 222,816 124,506 ‐ 504,657 1,415,235 776,422 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 489,964 (70,728) 1,082,294 139,654 (327,845) 593,989 27,162
BEGINNING FUND BALANCE, January 1, 2011 1,361,349 888,604 961,788 6,775,527 681,616 3,273,863 671,616
ENDING FUND BALANCE, June 30, 2011 1,851,313 817,876 2,044,082 6,915,181 353,771 3,867,852 698,778
Page 11 of 37
Monthly Financial Report June 2011
INTERNAL SERVICE FUNDS
The table below gives an analysis of all City Internal Service Funds. Displayed are the year‐to‐date revenues and
expenditures for each internal service. Included in each fund are the capital revenues and expenditures.
Equipment
Rental
Information
Technology Facilities Communications Insurance Healthcare Retiree
Healthcare
REVENUES:
Technology Fee ‐ 32,725 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ ‐ 146,334 ‐ ‐ ‐ 37,673
Charges for services
Equipment rental m&o 1,082,863 1,035,616 ‐ ‐ ‐ ‐ ‐
Telecommunications ‐ 189,878 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 53,337 ‐ 196,554 ‐ ‐ ‐
Communications ‐ ‐ ‐ 287,898 ‐ ‐ ‐
Facilities ‐ ‐ 2,058,492 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 75,068 ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ 156,794 ‐ ‐ ‐ ‐ ‐
Interest and other misc 12,262 4,944 785 218 13,392 14,809 9,917
Internal service fund misc:
Vehicle / equipment capital recovery 559,317 469,391 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 778,113 ‐ ‐
Worker's compensation / unemployment ‐ ‐ ‐ ‐ 672,004 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 5,168,046 1,847,519
Other misc 1,269 1,243 6,476 ‐ 3,234 320,503 ‐
Capital contributions 20,854 ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets 74,955 ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 35,804 7,351 3,695
TOTAL REVENUES 1,751,520 2,018,996 2,212,087 484,670 1,502,547 5,510,709 1,898,804
EXPENSES:
Communications 269,042
Equipment rental 1,161,679
Facilities 2,021,005
Healthcare 4,883,906
Information technology 1,407,620
Print and mail 188,848
Retiree healthcare 411,504
Ri sk management
Risk management 1,285,644
Unemployment 76,962
Worker's compensation 556,792
TOTAL EXPENSES 1,161,679 1,407,620 2,021,005 457,890 1,919,398 4,883,906 411,504
AMOUNT AVAILABLE FOR CAPITAL 589,841 611,376 191,082 26,780 (416,851) 626,803 1,487,300
CAPITAL PROJECTS 350,340 424,481 113,407 ‐ ‐ ‐ ‐
TRANSFERS IN ‐ ‐ ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 239,501 186,895 77,675 26,780 (416,851) 626,803 1,487,300
BEGINNING FUND BALANCE, January 1, 2011 5,293,107 1,949,165 241,046 70,214 6,690,024 6,201,894 3,371,037
ENDING FUND BALANCE, June 30, 2011 5,532,608 2,136,060 318,721 96,994 6,273,173 6,828,697 4,858,337
Page 12 of 37
Monthly Financial Report June 2011
FUND BALANCE
Page 14 shows the ending fund balance as of June 2011. 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 $12.3 million reported in combined general governmental fund balance of the current
year’s operating budget, which is approximately 12% of budgeted operating expenditures. This is an increase of $858k from
the beginning balance of January 1, 2011. June’s ending fund balance is over the anticipated General Governmental Fund
Balance of $10.5 million by $1.8 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 2011 property taxes in April and May. We expect the fund
balance to decrease but be in line with the projected fund balance after June and continue to decrease until we receive the
second half of 2011 property taxes in October and November.
CONTACT INFORMATION
This report is prepared by the Finance Division of the FIT Department. For additional financial information, please also
review our website: http://www.rentonwa.gov/. For any questions about the report, please feel free to contact us at
hnguyen@rentonwa.gov or iwang@rentonwa.gov.
Page 13 of 37
Monthly Financial Report June 2011
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through June 30, 2011
Funds
Balance
01/01/2011
Budgeted
Revenue
Revenue
06/30/11
Total Funds
Available
Budgeted
Expenditure
Expenditure
06/30/11
Ending
Balance
GENERAL GOVERNMENT FUNDS:11,407,119 98,647,849 49,588,206 60,995,325 100,698,924 48,730,648 12,264,677
000 General 9,477,148 71,881,012 30,207,369 39,684,517 74,195,956 36,863,500 2,821,017
001 Community Services 631,801 10,829,491 7,334,881 7,966,682 10,790,815 4,591,097 3,375,585
003 Street 116,298 8,402,117 6,398,446 6,514,744 8,300,564 3,920,141 2,594,603
004 Community Dev Block Grant (55,231) 501,728 117,437 62,206 370,272 118,852 (56,646)
005 Museum 66,830 195,966 196,161 262,991 208,407 104,539 158,452
006 Library 47,347 2,030,000 2,030,843 2,078,190 2,030,000 1,815,119 263,071
009 Farmers Market 81,630 67,500 37,774 119,404 62,875 24,059 95,345
010 Fire Memorial 1,251 ‐ 620 1,871 ‐ ‐ 1,871
011 Fire Health & Wellness 24,072 25,000 11,854 35,926 25,000 8,200 27,726
031 Pa rk Memorial 176,950 ‐ 390 177,340 ‐ ‐ 177,340
201 Ltd GO Bonds Gen Govt Debt 312,938 1,983,075 1,735,569 2,048,507 1,983,075 289,188 1,759,319
215 Gen Govt Misc Debt Service 526,085 2,731,960 1,516,862 2,042,947 2,731,960 995,953 1,046,994
SPECIAL REVENUE FUNDS:
102 Arterial Street 171,720 620,000 291,591 463,311 620,000 ‐ 463,311
108 Leased City Properties 759,594 748,060 303,833 1,063,427 614,457 362,305 701,122
110 Hotel Motel 212,950 245,000 150,784 363,734 275,000 126,633 237,101
118 Reserve for Paths & Trails 3,299 ‐ 7 3,306 ‐ ‐ 3,306
125 1% For Art 136,830 32,000 288 137,118 68,257 15,425 121,693
127 Cable Communication 171,358 85,000 66,331 237,689 221,301 34,137 203,552
135 Springbrook Wetlands Bank 660,524 ‐ 1,475 661,999 ‐ ‐ 661,999
DEBT SERVICE FUNDS:
219 1989 Unlimited GO Bonds ‐ ‐ ‐ ‐ ‐ ‐ ‐
CAPITAL PROJECT FUNDS (CIP):
303 Community Dev Mitigation 1,343,877 60,000 8,827 1,352,704 400,000 ‐ 1,352,704
304 Fire Mitigation 1,929,477 100,000 26,720 1,956,197 529,056 ‐ 1,956,197
305 Transportation Mitigation 1,119,954 250,000 58,064 1,178,018 999,494 ‐ 1,178,018
316 Municipal Facilities CIP 5,759,297 13,948,558 263,997 6,023,294 19,281,499 1,952,940 4,070,354
317 Transportation CIP 3,808,080 24,295,301 6,074,884 9,882,964 28,007,800 6,955,507 2,927,457
318 So Lake WA Infrastructure Proj 58,522 ‐ 120 58,642 58,000 5,241 53,401
326 Housing Opportunity 163,787 ‐ 308 164,095 160,000 17,500 146,595
336 New Library Development ‐ ‐ 1,800,713 1,800,713 ‐ 539,240 1,261,473
ENTERPRISE FUNDS:
402 Airport 1,295,036 432,010 258,712 1,553,748 1,125,756 554,642 999,106
403 Solid Waste Utility 961,788 15,015,942 7,631,205 8,592,993 14,951,710 6,548,910 2,044,083
404 Golf Course 630,924 2,483,545 909,682 1,540,606 2,504,738 920,659 619,947
422 Airport Capital 66,313 3,433,408 1,008,710 1,075,023 3,003,521 222,816 852,207
424 Golf Course Capital 257,680 100,000 50,539 308,219 220,000 110,289 197,930
INTERNAL SERVICE FUNDS:
501 Equipment Repair/Replacement 5,293,107 3,211,401 1,751,519 7,044,626 4,407,337 1,512,019 5,532,607
502 Insurance 6,690,024 3,178,883 1,502,547 8,192,571 3,018,564 1,919,399 6,273,172
503 Information Services 1,949,165 4,119,051 2,018,996 3,968,161 5,633,307 1,832,101 2,136,060
504 Facilities 241,046 4,243,673 2,212,087 2,453,133 4,256,261 2,134,412 318,721
505 Communications 70,214 953,941 484,670 554,884 957,746 457,890 96,994
512 Insurance, Healthcare 6,201,894 11,248,058 5,510,709 11,712,603 10,844,696 4,883,906 6,828,697
522 Insurance, Leoff1 Retirees HC 3,371,037 2,935,684 1,898,803 5,269,840 2,261,732 411,504 4,858,336
FIDUCIARY FUNDS:
611 Firemen's Pension 4,286,248 300,000 118,002 4,404,250 565,475 143,834 4,260,416
Funds
Balance
01/01/2011
Budgeted
Revenue
Revenue
06/30/11
Total Funds
Available
Budgeted
Expenditure
Expenditure
06/30/11
Ending
Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 11,402,622 46,660,496 19,664,012 31,066,634 50,069,800 19,231,053 11,835,581
405 Water Utility 4,695,116 9,680,689 3,456,920 8,152,036 10,521,313 5,152,848 2,999,188
406 Waste Water Utility 681,616 4,931,139 2,436,775 3,118,391 5,141,813 2,814,181 304,210
407 Surface Water Utility 1,462,126 5,353,933 2,259,701 3,721,827 5,092,613 2,248,363 1,473,464
416 King County Metro 671,616 13,156,760 6,356,159 7,027,775 13,156,760 6,328,998 698,777
425 Water Utility Construction 2,064,638 4,997,301 2,330,552 4,395,190 6,067,301 495,006 3,900,184
426 Waste Water Construction ‐ 3,845,000 1,464,796 1,464,796 3,790,000 1,415,235 49,561
427 Surface Water Construction 1,811,737 4,695,674 1,359,074 3,170,811 6,300,000 776,422 2,394,389
461 Waterworks Bond Reserve ‐ ‐ ‐ ‐ ‐ ‐ ‐
471 Waterworks Rate Stabilization 15,773 ‐ 35 15,808 ‐ ‐ 15,808
481 Future W/S Bond Proceeds ‐ ‐ ‐ ‐ ‐ ‐ ‐
Page 14 of 37
City of Renton
General Government Financial Position
2011 Budget Year
General Government Summary
Revenues Expenditures
$ Difference
over (under)
w/beginning
balance
11,407,119
January 5,379,006 6,990,159 (1,611,153) 9,795,966
February 11,050,241 15,756,416 (4,706,175) 6,700,944
March 16,654,842 23,321,083 (6,666,241) 4,740,878
April 30,062,704 30,363,594 (300,889) 11,106,230
May 44,974,654 38,187,393 6,787,261 18,194,380
June 49,588,204 48,730,646 857,557 12,264,676
July
August
September
October
November
December
2,000,000
3,000,000
4,000,000
5,000,000
6,000,000
7,000,000
8,000,000
9,000,000
60,000,000
70,000,000
80,000,000
90,000,000
100,000,000
Change in Fund
Balance
Rev/Exp Revenues
Expenditures
Change in Fund Balance
(9,000,000)
(8,000,000)
(7,000,000)
(6,000,000)
(5,000,000)
(4,000,000)
(3,000,000)
(2,000,000)
(1,000,000)
‐
1,000,000
‐
10,000,000
20,000,000
30,000,000
40,000,000
50,000,000
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Page 15 of 37
City of Renton
Monthly Revenue Analysis ‐ 2011 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 5,718,467 5,379,006 ‐5.94%
Feb 10,948,617 11,050,241 0.93%
Mar 16,340,245 16,654,842 1.93%
Apr 29,160,205 30,062,704 3.09%
May 44,802,036 44,974,654 0.39%
Jun 49,742,818 49,588,204 ‐0.31%
Jul 55,939,182
Aug 61,217,720
Sep 66,128,177
Oct 78,723,867
Nov 93,007,130
Dec 98,647,849
Percent of budget 50.27%
YTD Annual %
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
Millions
Total Revenue
General Government
Budget
Actual
Last Year
$33
Millions Property Tax
Property Tax Budget Actual over (under)
Jan 222,520 505,501 127.17%
Feb 498,052 841,695 69.00%
Mar 1,055,236 1,586,980 50.39%
Apr 7,832,248 9,205,472 17.53%
May 16,721,331 17,054,953 2.00%
Jun 16,838,319 17,109,916 1.61%
Jul 16,927,805
Aug 17,079,566
Sep 17,579,783
Oct 24,763,004
Nov 31,792,494
Dec 32,046,525
Percent of budget 53.39%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
Budget
Actual
Last Year
Page 16 of 37
City of Renton
Monthly Revenue Analysis ‐ 2011 Budget Year
Sales Tax Budget
YTD
Actual
Annual %
over (under)
Jan 1,568,911 1,498,057 ‐4.52%
Feb 3,521,649 3,683,690 4.60%
Mar 5,022,242 5,136,541 2.28%
Apr 6,546,191 6,539,777 ‐0.10%
May 8,255,967 8,305,195 0.60%
Jun 9,842,667 9,830,419 ‐0.12%
Jul 11,428,235
Aug 13,153,559
Sep 14,798,459
Oct 16,517,368
Nov 18,234,679
Dec 19,879,280
Percent of budget 49.45%
Note: Excludes CJ Sales Tax and Natural Gas Use Tax.
YTD Annual %
$‐
$3
$6
$9
$12
$15
$18
$21
Millions Sales Tax
Budget
Actual
Last Year
$16
Millions Utility Tax
Utility Tax Budget Actual over (under)
Jan 1,449,257 1,363,023 ‐5.95%
Feb 2,751,779 2,811,298 2.16%
Mar 4,098,738 4,292,138 4.72%
Apr 5,420,381 5,662,856 4.47%
May 6,702,223 6,954,386 3.76%
Jun 7,923,403 8,157,861 2.96%
Jul 9,116,434
Aug 10,307,012
Sep 11,443,772
Oct 12,636,818
Nov 13,794,401
Dec 15,166,600
Percent of budget 53.79%
Note: Includes Natural Gas Use Tax.
$0
$2
$4
$6
$8
$10
$12
$14
$16
Budget
Actual
Last Year
Page 17 of 37
City of Renton
Monthly Revenue Analysis ‐ 2011 Budget Year
Licenses &
Permits Budget
YTD
Actual
Annual %
over (under)
Jan 469,355 185,889 ‐60.39%
Feb 583,113 322,341 ‐44.72%
Mar 741,647 539,342 ‐27.28%
Apr 1,010,644 778,404 ‐22.98%
May 1,187,535 957,261 ‐19.39%
Jun 1,393,028 1,117,984 ‐19.74%
Jul 1,693,253
Aug 1,895,469
Sep 2,064,907
Oct 2,302,673
Nov 2,462,856
Dec 2,612,987
Percent of budget 42.79%
Note: Includes Fund 318.
YTD Annual % Millions
Intergovernmental
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
$2.40
$2.70
Millions Licenses & Permits
Budget
Actual
Last Year
Intergovt'l Budget Actual over (under)
Jan 560,812 565,843 0.90%
Feb 1,138,089 1,079,643 ‐5.14%
Mar 1,728,228 1,648,102 ‐4.64%
Apr 2,719,803 2,707,888 ‐0.44%
May 5,009,895 5,258,407 4.96%
Jun 5,525,467 5,771,371 4.45%
Jul 5,929,552
Aug 6,606,292
Sep 7,070,836
Oct 7,707,334
Nov 10,890,700
Dec 11,355,853
Percent of budget 50.82%
Note: Includes CJ Sales Tax.
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
$10
$11
$12
Millions
Budget
Actual
Last Year
Page 18 of 37
City of Renton
Monthly Revenue Analysis ‐ 2011 Budget Year
Charges for
Services Budget
YTD
Actual
Annual %
over (under)
Jan 447,067 323,609 ‐27.62%
Feb 884,119 786,123 ‐11.08%
Mar 1,363,364 1,257,415 ‐7.77%
Apr 2,006,320 1,778,657 ‐11.35%
May 2,526,347 2,308,859 ‐8.61%
Jun 3,132,602 2,821,799 ‐9.92%
Jul 3,941,618
Aug 4,487,827
Sep 4,949,440
Oct 5,447,614
Nov 5,842,063
Dec 6,366,817
Percent of budget 44.32%
Fines & YTD Annual %
$‐
$1
$2
$3
$4
$5
$6
$7
Millions Charges for Services
Budget
Actual
Last Year
Millions Fines & Forfeits
Forfeits Budget Actual over (under)
Jan 223,938 165,721 ‐26.00%
Feb 434,759 430,461 ‐0.99%
Mar 694,630 746,372 7.45%
Apr 968,114 1,039,081 7.33%
May 1,225,734 1,297,817 5.88%
Jun 1,573,479 1,562,659 ‐0.69%
Jul 1,812,769
Aug 2,098,788
Sep 2,307,490
Oct 2,555,419
Nov 2,852,584
Dec 3,170,351
Percent of budget 49.29%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Budget
Actual
Last Year
Page 19 of 37
City of Renton
Monthly Revenue Analysis ‐ 2011 Budget Year
Other Taxes Budget
YTD
Actual
Annual %
over (under)
Jan 595,443 628,259 5.51%
Feb 855,646 880,840 2.94%
Mar 1,219,558 1,132,303 ‐7.15%
Apr 1,961,768 1,796,896 ‐8.40%
May 2,361,633 2,186,455 ‐7.42%
Jun 2,528,643 2,419,406 ‐4.32%
Jul 3,613,125
Aug 3,958,169
Sep 4,158,270
Oct 4,951,774
Nov 5,228,432
Dec 6,075,921
Percent of budget 39.82%
YTD Annual % Millions Miscellaneous
$0
$1
$2
$3
$4
$5
$6
$7
Millions Other Taxes
Budget
Actual
Last Year
Misc Budget Actual over (under)
Jan 181,164 143,105 ‐21.01%
Feb 280,604 213,343 ‐23.97%
Mar 413,428 312,474 ‐24.42%
Apr 527,586 386,523 ‐26.74%
May 643,655 483,606 ‐24.87%
Jun 817,044 628,624 ‐23.06%
Jul 994,876
Aug 1,102,019
Sep 1,226,190
Oct 1,312,806
Nov 1,379,867
Dec 1,444,459
Percent of budget 43.52%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60 Budget
Actual
Last Year
Page 20 of 37
City of Renton
Monthly Revenue Analysis ‐ 2011 Budget Year
Other
Financing Budget
YTD
Actual
Annual %
over (under)
Jan ‐ ‐ N/A
Feb 808 808 0.00%
Mar 3,175 3,175 0.00%
Apr 167,151 167,151 0.00%
May 167,716 167,716 0.00%
Jun 168,166 168,166 0.00%
Jul 481,515
Aug 529,019
Sep 529,030
Oct 529,056
Nov 529,056
Dec 529,056
Percent of budget 31.79%
YTD Annual % Millions
Real Estate Excise Tax
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
$7.00
$8.00
Millions Other Financing Sources
Budget
Actual
Last Year
REET Budget Actual over (under)
Jan 64,803 161,911 149.85%
Feb 162,288 261,588 61.19%
Mar 443,274 403,288 ‐9.02%
Apr 699,373 514,275 ‐26.47%
May 896,426 671,794 ‐25.06%
Jun 1,070,698 900,300 ‐15.91%
Jul 1,206,778
Aug 1,397,066
Sep 1,508,909
Oct 1,675,542
Nov 1,860,141
Dec 2,240,000
Percent of budget 40.19%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
Millions
Budget
Actual
Last Year
Page 21 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,065,580 6,990,159 ‐1.07%
Feb 16,776,018 15,756,416 ‐6.08%
Mar 24,390,079 23,321,083 ‐4.38%
Apr 32,049,704 30,363,594 ‐5.26%
May 40,151,324 38,187,393 ‐4.89%
Jun 50,676,491 48,730,646 ‐3.84%
Jul 60,285,490
Aug 68,630,679
Sep 76,668,678
Oct 83,974,651
Nov 91,994,663
Dec 100,698,925
Percent of budget expended 48.39%
YTD Annual %
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
Millions
Total Expenditures
General Government
Budget
Actual
Last Year
$300 000
Legislative
Legislative Budget Actual over (under)
Jan 22,689 22,021 ‐2.94%
Feb 46,076 44,576 ‐3.26%
Mar 69,607 67,521 ‐3.00%
Apr 93,677 89,659 ‐4.29%
May 116,993 112,072 ‐4.21%
Jun 140,280 134,795 ‐3.91%
Jul 163,146
Aug 186,174
Sep 208,887
Oct 230,365
Nov 253,583
Dec 277,834
Percent of budget expended 48.52%
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
Budget
Actual
Last Year
Page 22 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Executive Budget
YTD
Actual
Annual %
over (under)
Jan 107,124 112,718 5.22%
Feb 236,884 229,987 ‐2.91%
Mar 364,848 346,789 ‐4.95%
Apr 492,060 480,072 ‐2.44%
May 616,193 605,772 ‐1.69%
Jun 735,255 729,119 ‐0.83%
Jul 865,752
Aug 985,602
Sep 1,122,608
Oct 1,245,595
Nov 1,362,997
Dec 1,484,762
Percent of budget expended 49.11%
YTD Annual %
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
Millions Executive
Budget
Actual
Last Year
$0 80
Millions City Clerk
City Clerk Budget Actual over (under)
Jan 51,492 49,604 ‐3.67%
Feb 103,964 98,230 ‐5.52%
Mar 160,688 154,386 ‐3.92%
Apr 280,719 315,627 12.43%
May 380,999 369,865 ‐2.92%
Jun 435,251 420,930 ‐3.29%
Jul 485,774
Aug 534,200
Sep 583,630
Oct 678,087
Nov 727,878
Dec 790,484
Percent of budget expended 53.25%
$‐
$0.20
$0.40
$0.60
$0.80
Budget
Actual
Last Year
Page 23 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Hearing
Examiner Budget
YTD
Actual
Annual %
over (under)
Jan 14,528 14,189 ‐2.33%
Feb 28,905 21,908 ‐24.21%
Mar 43,154 23,616 ‐45.27%
Apr 57,736 25,472 ‐55.88%
May 71,939 28,865 ‐59.87%
Jun 86,324 33,294 ‐61.43%
Jul 100,917
Aug 115,153
Sep 129,406
Oct 143,109
Nov 157,369
Dec 171,929
Percent of budget expended 19.36%
YTD Annual % $1 60
Millions City Attorney
$‐
$30,000
$60,000
$90,000
$120,000
$150,000
$180,000
Hearing Examiner
Budget
Actual
Last Year
City Attorney Budget Actual over (under)
Jan 103,073 130,446 26.56%
Feb 244,580 264,464 8.13%
Mar 396,154 395,280 ‐0.22%
Apr 541,694 528,480 ‐2.44%
May 682,825 657,439 ‐3.72%
Jun 823,807 790,004 ‐4.10%
Jul 963,283
Aug 1,105,997
Sep 1,241,400
Oct 1,376,729
Nov 1,510,648
Dec 1,600,531
Percent of budget expended 49.36%
$‐
$0.40
$0.80
$1.20
$1.60 Budget
Actual
Last Year
Page 24 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Court Services Budget
YTD
Actual
Annual %
over (under)
Jan 173,836 163,613 ‐5.88%
Feb 352,836 326,156 ‐7.56%
Mar 539,914 490,833 ‐9.09%
Apr 719,707 661,478 ‐8.09%
May 898,391 831,527 ‐7.44%
Jun 1,082,682 1,040,289 ‐3.92%
Jul 1,266,794
Aug 1,444,260
Sep 1,625,297
Oct 1,787,517
Nov 1,960,773
Dec 2,148,421
Percent of budget expended 48.42%
YTD Annual %
$‐
$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
Millions
Community & Economic
Dl Ad iCED Admin Budget Actual over (under)
Jan 74,575 77,455 3.86%
Feb 157,835 155,007 ‐1.79%
Mar 237,058 232,560 ‐1.90%
Apr 315,978 310,112 ‐1.86%
May 394,187 387,665 ‐1.65%
Jun 472,083 465,217 ‐1.45%
Jul 549,691
Aug 627,009
Sep 704,035
Oct 777,925
Nov 853,594
Dec 929,263
Percent of budget expended 50.06%
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
$0.70
$0.80
$0.90
$1.00
Millions Development Admin
Budget
Actual
Last Year
Page 25 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Development
Services Budget
YTD
Actual
Annual %
over (under)
Jan 283,014 231,587 ‐18.17%
Feb 559,091 474,633 ‐15.11%
Mar 825,857 716,400 ‐13.25%
Apr 1,094,888 953,343 ‐12.93%
May 1,362,438 1,220,807 ‐10.40%
Jun 1,623,270 1,431,566 ‐11.81%
Jul 1,887,072
Aug 2,135,783
Sep 2,409,450
Oct 2,652,185
Nov 2,904,084
Dec 3,164,064
Percent of budget expended 45.24%
Economic YTD Annual %
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions
Development Services
Budget
Actual
Last Year
Millions
Economic Development
Development Budget Actual over (under)
Jan 51,933 68,491 31.88%
Feb 121,356 123,830 2.04%
Mar 181,420 179,805 ‐0.89%
Apr 236,072 234,834 ‐0.52%
May 299,359 297,953 ‐0.47%
Jun 359,523 357,808 ‐0.48%
Jul 429,586
Aug 488,281
Sep 557,248
Oct 615,465
Nov 680,540
Dec 745,313
Percent of budget expended 48.01%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
Millions
Budget
Actual
Last Year
Page 26 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Planning Budget
YTD
Actual
Annual %
over (under)
Jan 110,790 104,320 ‐5.84%
Feb 218,683 258,972 18.42%
Mar 334,314 348,727 4.31%
Apr 439,437 475,330 8.17%
May 559,927 581,947 3.93%
Jun 718,541 685,502 ‐4.60%
Jul 835,766
Aug 973,934
Sep 1,145,112
Oct 1,281,210
Nov 1,381,332
Dec 1,545,279
Percent of budget expended 44.36%
YTD Annual % $2 40
Millions Finance
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
Millions
Planning
Budget
Actual
Last Year
Finance Budget Actual over (under)
Jan 186,686 155,421 ‐16.75%
Feb 341,891 315,453 ‐7.73%
Mar 517,662 467,036 ‐9.78%
Apr 674,058 620,994 ‐7.87%
May 865,088 770,959 ‐10.88%
Jun 1,023,874 930,622 ‐9.11%
Jul 1,187,649
Aug 1,354,267
Sep 1,520,593
Oct 1,632,415
Nov 1,777,248
Dec 2,101,797
Percent of budget expended 44.28%
$‐
$0.40
$0.80
$1.20
$1.60
$2.00
$2.40 Budget
Actual
Last Year
Page 27 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Human
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 78,566 86,565 10.18%
Feb 155,480 155,437 ‐0.03%
Mar 237,774 221,683 ‐6.77%
Apr 319,048 282,721 ‐11.39%
May 399,386 342,697 ‐14.19%
Jun 483,070 417,784 ‐13.51%
Jul 565,498
Aug 647,359
Sep 729,334
Oct 806,895
Nov 882,317
Dec 977,884
Percent of budget expended 42.72%
YTD Annual %
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
Millions Human Resources
Budget
Actual
Last Year
$33
Millions Police
Police Budget Actual over (under)
Jan 2,300,854 2,369,174 2.97%
Feb 4,975,525 4,383,450 ‐11.90%
Mar 7,489,363 7,075,221 ‐5.53%
Apr 9,965,388 8,969,395 ‐9.99%
May 12,372,160 11,112,660 ‐10.18%
Jun 15,119,628 14,046,545 ‐7.10%
Jul 17,670,174
Aug 20,219,584
Sep 22,892,770
Oct 25,166,744
Nov 28,038,602
Dec 31,032,228
Percent of budget expended 45.26%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
Budget
Actual
Last Year
Page 28 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Fire &
Emergency
Services Budget
YTD
Actual
Annual %
over (under)
Jan 1,894,040 1,754,253 ‐7.38%
Feb 4,464,519 4,132,293 ‐7.44%
Mar 6,244,191 5,900,678 ‐5.50%
Apr 7,913,923 7,652,583 ‐3.30%
May 9,636,531 9,538,569 ‐1.02%
Jun 11,386,741 11,333,418 ‐0.47%
Jul 13,170,370
Aug 14,956,836
Sep 16,745,399
Oct 18,390,379
Nov 20,227,278
Dec 22,045,916
Percent of budget expended 51.41%
Community
Services YTD Annual %
$‐
$3
$6
$9
$12
$15
$18
$21
$24
Millions Fire & Emergency Services
Budget
Actual
Last Year
$1 20
Millions Community Services Admin
Admin Budget Actual over (under)
Jan 24,324 33,774 38.85%
Feb 69,640 67,558 ‐2.99%
Mar 104,515 102,208 ‐2.21%
Apr 139,380 136,129 ‐2.33%
May 174,090 170,164 ‐2.26%
Jun 208,871 204,042 ‐2.31%
Jul 243,499
Aug 277,165
Sep 311,080
Oct 344,763
Nov 378,350
Dec 412,476
Percent of budget expended 49.47%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Budget
Actual
Last Year
Page 29 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Parks Budget
YTD
Actual
Annual %
over (under)
Jan 239,087 261,191 9.24%
Feb 514,533 527,048 2.43%
Mar 810,460 799,401 ‐1.36%
Apr 1,116,871 1,109,451 ‐0.66%
May 1,440,935 1,422,731 ‐1.26%
Jun 1,782,886 1,750,372 ‐1.82%
Jul 2,144,016
Aug 2,551,900
Sep 2,893,918
Oct 3,240,517
Nov 3,551,772
Dec 3,928,721
Percent of budget expended 44.55%
Parks
Planning and YTD Annual %
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
Millions Parks
Budget
Actual
Last Year
$0 60
Millions Parks Planning and Natural Resources
Natural Budget Actual over (under)
Jan 48,516 34,349 ‐29.20%
Feb 97,031 69,260 ‐28.62%
Mar 145,547 109,668 ‐24.65%
Apr 194,062 150,610 ‐22.39%
May 242,578 204,169 ‐15.83%
Jun 291,093 256,105 ‐12.02%
Jul 339,609
Aug 388,124
Sep 436,640
Oct 485,155
Nov 533,671
Dec 582,186
Percent of budget expended 43.99%
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
Budget
Actual
Last Year
Page 30 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Recreation Budget
YTD
Actual
Annual %
over (under)
Jan 295,489 361,259 22.26%
Feb 635,715 702,382 10.49%
Mar 1,005,407 1,058,705 5.30%
Apr 1,348,862 1,408,767 4.44%
May 1,717,169 1,763,066 2.67%
Jun 2,116,097 2,128,093 0.57%
Jul 2,772,458
Aug 3,488,144
Sep 3,976,930
Oct 4,329,768
Nov 4,783,906
Dec 5,178,448
Percent of budget expended 41.10%
Human YTD Annual % $1 40
Millions Human Services
$‐
$1
$2
$3
$4
$5
$6
Millions Recreation
Budget
Actual
Last Year
Services Budget Actual over (under)
Jan 59,293 53,756 ‐9.34%
Feb 126,188 118,956 ‐5.73%
Mar 198,582 177,533 ‐10.60%
Apr 390,623 369,358 ‐5.44%
May 474,289 499,658 5.35%
Jun 553,794 560,790 1.26%
Jul 757,937
Aug 837,909
Sep 900,588
Oct 1,060,018
Nov 1,161,722
Dec 1,363,272
Percent of budget expended 41.14%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
Budget
Actual
Last Year
Page 31 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Neighborhood
s, Resources,
and Events Budget
YTD
Actual
Annual %
over (under)
Jan 41,830 36,383 ‐13.02%
Feb 85,281 73,402 ‐13.93%
Mar 128,860 110,686 ‐14.10%
Apr 173,464 157,589 ‐9.15%
May 228,231 198,703 ‐12.94%
Jun 290,830 252,486 ‐13.18%
Jul 376,730
Aug 426,476
Sep 473,127
Oct 511,361
Nov 548,937
Dec 688,984
Percent of budget expended 36.65%
YTD Annual % $2 50
Millions Library Fund
$‐
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
$700,000
Neighborhoods, Resources, and Events
Budget
Actual
Last Year
Library Fund Budget Actual over (under)
Jan 2,619 2,619 0.00%
Feb 5,119 5,119 0.00%
Mar 7,619 7,619 0.00%
Apr 10,119 10,119 0.00%
May 12,619 12,619 0.00%
Jun 1,815,119 1,815,119 0.00%
Jul 1,940,466
Aug 2,000,155
Sep 2,022,539
Oct 2,028,756
Nov 2,029,896
Dec 2,030,000
Percent of budget expended 89.41%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
Budget
Actual
Last Year
Page 32 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Museum Fund Budget
YTD
Actual
Annual %
over (under)
Jan 16,891 17,146 1.51%
Feb 34,473 34,638 0.48%
Mar 51,858 51,915 0.11%
Apr 69,554 69,499 ‐0.08%
May 87,464 86,914 ‐0.63%
Jun 105,332 104,539 ‐0.75%
Jul 122,835
Aug 140,126
Sep 157,397
Oct 174,522
Nov 191,345
Dec 208,407
Percent of budget expended 50.16%
Public Works YTD Annual % $0 60
Millions Public Works Admin
$‐
$30,000
$60,000
$90,000
$120,000
$150,000
$180,000
$210,000
Museum Fund
Budget
Actual
Last Year
Admin Budget Actual over (under)
Jan 36,310 37,289 2.70%
Feb 74,186 74,538 0.47%
Mar 112,901 111,889 ‐0.90%
Apr 154,191 149,219 ‐3.22%
May 191,427 187,166 ‐2.23%
Jun 228,374 224,646 ‐1.63%
Jul 266,290
Aug 306,966
Sep 342,897
Oct 378,232
Nov 415,139
Dec 454,179
Percent of budget expended 49.46%
$‐
$0.20
$0.40
$0.60
Budget
Actual
Last Year
Page 33 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Street
Maintenance Budget
YTD
Actual
Annual %
over (under)
Jan 292,781 279,841 ‐4.42%
Feb 594,598 597,149 0.43%
Mar 892,291 894,017 0.19%
Apr 1,214,569 1,168,482 ‐3.79%
May 1,516,549 1,455,914 ‐4.00%
Jun 1,833,551 1,755,569 ‐4.25%
Jul 2,172,817
Aug 2,501,620
Sep 2,789,645
Oct 3,081,338
Nov 3,362,752
Dec 3,693,925
Percent of budget expended 47.53%
Transportatio YTD Annual %
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
Millions Street Maintenance
Budget
Actual
Last Year
$6
Millions Transportation
n Budget Actual over (under)
Jan 331,107 308,560 ‐6.81%
Feb 719,617 689,957 ‐4.12%
Mar 1,114,917 1,101,787 ‐1.18%
Apr 1,488,522 1,429,170 ‐3.99%
May 1,869,361 1,787,292 ‐4.39%
Jun 2,262,793 2,164,571 ‐4.34%
Jul 2,606,257
Aug 3,030,111
Sep 3,405,716
Oct 3,807,825
Nov 4,176,065
Dec 4,606,639
Percent of budget expended 46.99%
$‐
$1
$2
$3
$4
$5
$6
Budget
Actual
Last Year
Page 34 of 37
City of Renton
Monthly Expenditure Analysis ‐ 2011 Budget Year
Debt Service Budget
YTD
Actual
Annual %
over (under)
Jan 4,600 4,600 0.00%
Feb 254,918 254,918 0.00%
Mar 390,380 390,380 0.00%
Apr 390,380 390,380 0.00%
May 390,380 390,380 0.00%
Jun 1,285,140 1,285,140 0.00%
Jul 2,750,437
Aug 3,143,357
Sep 3,536,276
Oct 3,929,196
Nov 4,322,115
Dec 4,715,035
Percent of budget expended 27.26%
Non‐
Departmental YTD Annual % $5 00
Millions Non‐Departmental Other City Services
$‐
$2
$4
$6
$8
$10
$12
Millions Debt Service
Budget
Actual
Last Year
Other City Budget Actual over (under)
Jan 219,534 219,534 0.00%
Feb 1,557,092 1,557,092 0.00%
Mar 1,784,740 1,784,740 0.00%
Apr 2,214,722 2,214,722 0.00%
May 3,149,818 3,149,818 0.00%
Jun 3,412,280 3,412,280 0.00%
Jul 3,650,668
Aug 3,764,187
Sep 3,806,756
Oct 3,818,581
Nov 3,820,749
Dec 3,820,946
Percent of budget expended 89.30%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00 Budget
Actual
Last Year
Page 35 of 37
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2011 Budget Year
Utilities Budget Revenue Expense
Jan 3,432,048 4,058,961 2,857,743
Feb 7,863,617 8,549,030 7,011,826
Mar 11,121,543 13,634,112 11,834,545
Apr 17,414,953 18,015,133 15,336,879
May 21,543,781 22,882,500 18,961,840
Jun 29,860,612 27,295,181 25,779,962
Jul 37,518,040
Aug 42,011,852
Sep 47,249,783
Oct 52,752,037
Nov 57,466,891
Dec 65,021,510
Percent of budget expended 34.05%
Note: Operations and Capital
$0
$10
$20
$30
$40
$50
$60
$70
Millions Utilities
Budget
Revenue
Expense
$4 50
Millions Airport
Airport Budget Revenue Expense
Jan 218,852 209,097 131,908
Feb 498,982 403,084 236,317
Mar 755,905 600,802 352,561
Apr 985,741 829,701 480,730
May 1,254,433 1,015,908 580,136
Jun 1,548,024 1,267,422 777,458
Jul 1,778,232
Aug 2,062,285
Sep 2,401,670
Oct 3,216,748
Nov 3,508,481
Dec 4,129,277
Percent of budget expended 18.83%
Note: Operations and Capital
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
Budget
Revenue
Expense
Page 36 of 37
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2011 Budget Year
Golf Course Budget Revenue Expense
Jan 152,642 64,531 126,007
Feb 320,835 154,907 258,005
Mar 548,995 255,829 534,432
Apr 693,450 406,663 682,305
May 890,179 680,144 872,514
Jun 1,146,318 960,222 1,030,949
Jul 1,320,887
Aug 1,487,532
Sep 1,662,841
Oct 1,987,022
Nov 2,125,704
Dec 2,724,738
Percent of budget expended 37.84%
Note: Operations and Capital
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
$2.40
$2.70
$3.00
Millions Golf Course
Budget
Revenue
Expense
Page 37 of 37