HomeMy WebLinkAbout201109, September.pdfFINANCE AND
INFORMATION TECHNOLOGY
M E M O R A N D U M
DATE: December 13, 2011
TO: Terri Briere, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: September 2011 Financial Status Report
At the end of September, general governmental revenues show $103k or 0.2% above budget.
On the positive side, we have $136k favorable property tax collection. Sales tax is $62k higher
than budget, which is attributable to one‐time activity that occurred in December 2010
(February 2011 sales tax receipt), the collection through the state’s sales tax Amnesty Program
and a 3.8% ($55k) overpayment from the Washington State Department of Revenue. 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. Additional revenues sources that are higher
than expected are: utility taxes ($247k); state shared revenues ($477k); and public safety ($56k,
mainly due to private security by the police department). On the down side, the revenue
sources that are underperforming the year to date budget and likely to continue this trend for
the year are: REET ($95k below); interfund service charges ($278k below, which includes a
correction that was processed in July); culture and recreation service charges/fees ($122k
below); and interest earnings ($162k below). Therefore, we believe the overall revenue
collection will be very close to budget for the year.
General government expenditures showed favorable variances of $3.2 million or 4.2%. $1.6
million of the saving is related to SCORE jail start up costs. Most of these savings are due to the
delayed payment of billing from SCORE (June, July, and August invoices totalling $1.4 million are
currently under review for payment). While we still expect to realize part of the savings this
year, it will be substantially less than the $1.6 million. In addition, part of the jail savings was
used to cover the Police department’s pay and benefit budget correction that was approved in
the 2nd Quarter Budget Adjustment. Overall, we anticipate only $500k expenditure savings at
the end of this year.
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 16,270,855 31,497,128 17,278,401 32,046,525 17,579,784 17,715,892 136,109 0.8%
Sales Tax 17,995,836 13,482,971 17,198,220 12,839,233 17,759,600 13,217,076 13,279,501 62,425 0.5%
Sales Tax ‐ Annexation Credit 2,132,110 1,599,195 2,025,660 1,511,240 2,119,680 1,581,383 1,513,579 (67,804) ‐4.3%
Criminal Justice Sales Tax 1,650,350 1,235,194 1,620,479 1,210,827 1,804,005 1,347,958 1,361,430 13,472 1.0%
Natural Gas Use Tax 242,891 187,531 228,514 184,158 258,750 208,525 206,447 (2,078) ‐1.0%
Admission Tax 260,269 189,020 291,399 217,864 280,000 209,341 222,088 12,747 6.1%
Franchise Fees 1,039,031 779,233 1,222,444 887,960 1,260,000 915,240 894,644 (20,595) ‐2.3%
Electricity Tax 4,963,151 3,774,422 5,036,907 3,748,337 4,968,000 3,697,057 3,846,982 149,924 4.1%
Natural Gas Utility Tax 1,891,255 1,556,491 1,577,756 1,200,941 1,656,000 1,260,498 1,465,021 204,523 16.2%
Transfer Station 283,985 181,928 269,912 192,341 238,050 169,636 199,986 30,350 17.9%
TV Cable 1,263,743 933,829 1,296,744 1,020,173 1,366,200 1,074,815 1,019,718 (55,097) ‐5.1%
Telephone 1,037,873 770,203 1,038,009 784,427 1,000,000 755,703 731,537 (24,166) ‐3.2%
Cellular Phone 2,027,473 1,464,120 2,206,637 1,679,973 2,202,000 1,676,443 1,585,584 (90,859) ‐5.4%
City Utilities 2,871,599 2,159,896 2,853,884 2,134,582 3,477,600 2,601,095 2,633,503 32,408 1.2%
Leasehold Excise Tax 146,002 103,819 138,830 103,100 145,000 107,682 122,412 14,730 13.7%
Gambling Excise Tax 2,141,720 1,680,291 1,546,386 1,178,752 1,600,000 1,219,619 1,268,562 48,943 4.0%
Real Estate Excise Tax 2,418,456 1,864,816 2,464,489 1,660,140 2,240,000 1,509,953 1,383,144 (126,809) ‐8.4%
Less: Municipal Facilities CIP REET (1,000,000) (901,546) (400,000) (278,956) (400,000) (278,956) (246,990) 31,966 ‐11.5%
EMS Levy 1,170,657 780,438 1,161,114 580,473 950,921 510,544 510,544 ‐ 0.0%
Business License Fees 424,413 317,551 431,782 323,771 463,067 347,230 325,599 (21,631) ‐6.2%
Other Licenses and Permits 176,851 112,597 262,629 172,927 210,255 138,442 143,117 4,675 3.4%
Building Permits & Development Svc Fees 2,361,037 1,695,315 2,437,270 1,917,809 2,706,044 2,144,286 2,113,119 (31,168) ‐1.5%
Intergovt'l (Grants, State Shared, etc) 3,820,932 2,905,826 4,426,676 3,109,861 4,282,204 2,570,293 3,033,325 463,032 18.0%
Fire District 25 and 40 Contracts 5,869,198 3,050,973 5,252,877 2,760,463 5,928,462 3,144,397 3,144,397 ‐ 0.0%
Public Safety 521,484 400,944 482,343 345,457 426,081 305,162 361,137 55,975 18.3%
Culture and Recreation 1,631,486 1,416,222 1,424,932 1,230,246 1,628,486 1,405,989 1,283,581 (122,408) ‐8.7%
Interfund/Interdept‐Services 3,225,745 2,404,679 3,190,908 2,409,695 3,314,653 2,503,144 2,224,652 (278,492) ‐11.1%
Fines and Forfeits 1,349,034 934,774 1,291,817 887,790 1,088,750 751,728 802,240 50,512 6.7%
Photo Enforcement 2,368,131 1,733,511 1,925,159 1,398,367 1,900,908 1,380,752 1,368,117 (12,635) ‐0.9%
Seizure Funds ‐ Federal/State/Local 99,844 88,550 221,046 214,093 180,693 175,009 10,903 (164,106) ‐93.8%
Interests and Other Earnings 535,314 444,212 327,558 256,261 477,730 373,747 211,639 (162,108) ‐43.4%
Rents, Leases, and Concessions 677,960 572,197 727,338 624,556 698,929 600,162 607,276 7,115 1.2%
Contributions and Donations 150,406 105,770 133,756 129,101 146,800 141,691 178,284 36,593 25.8%
Other Miscellaneous 355,086 193,661 290,239 227,815 352,218 280,683 207,909 (72,774) ‐25.9%
Other Financing Sources (Transfer‐In, etc) 578,206 517,920 653,595 653,227 692,123 169,528 169,528 ‐ 0.0%
Total Operating Revenues 97,342,052 65,007,407 96,754,435 64,795,404 99,469,734 65,795,639 65,898,407 102,767 0.2%
OPERATING EXPENDITURES
Legislative 247,225 185,509 259,345 195,351 276,567 207,934 203,409 4,525 2.2%
Executive 1,499,747 1,129,362 1,578,526 1,198,078 1,478,297 1,117,720 1,121,986 (4,266) ‐0.4%
City Clerk 646,581 506,612 789,209 553,461 786,947 581,018 577,202 3,817 0.7%
Hearing Examiner 171,911 129,549 174,447 131,145 170,717 128,494 44,161 84,333 65.6%
City Attorney 1,248,380 991,911 1,565,597 1,190,659 1,588,429 1,232,013 1,189,429 42,584 3.5%
Court Services 1,819,731 1,385,015 2,007,599 1,510,390 2,134,452 1,614,729 1,559,522 55,207 3.4%
Community and Eco Dvlpmnt Admin 265,269 201,954 579,396 437,987 926,674 702,073 698,417 3,656 0.5%
Development Services 3,615,129 2,758,545 2,946,413 2,238,101 3,137,985 2,389,591 2,109,094 280,497 11.7%
Economic Development 1,244,175 938,697 1,322,004 979,958 749,128 560,100 544,936 15,164 2.7%
Planning 1,525,460 1,063,227 1,774,508 1,382,178 1,533,697 1,136,529 1,082,329 54,200 4.8%
Finance 1,969,936 1,606,583 2,214,458 1,420,711 2,088,212 1,510,764 1,425,349 85,415 5.7%
Human Resources 853,063 628,205 861,221 650,356 973,851 726,325 633,893 92,432 12.7%
Police 22,515,895 16,799,161 23,946,386 18,182,421 24,508,179 18,452,277 18,379,946 72,331 0.4%
Jail Services 3,317,861 2,308,350 3,539,035 2,395,256 6,503,114 4,460,923 2,826,495 1,634,428 36.6%
Fire 20,378,891 15,560,474 21,554,792 16,291,059 22,676,137 17,224,095 17,069,616 154,479 0.9%
Community Services Admin 1 4,459,381 3,364,159 1,063,011 800,701 409,872 309,116 306,588 2,528 0.8%
Parks 3,894,745 2,848,691 3,421,424 2,540,440 3,911,658 2,881,349 2,788,379 92,970 3.2%
Parks Planning & Natural Resources ‐ ‐ 448,574 324,354 578,646 433,985 397,535 36,450 8.4%
Recreation 4,374,668 3,349,287 4,433,420 3,415,124 5,177,897 3,976,507 3,855,315 121,192 3.0%
Human Services 1,194,142 779,704 1,326,778 885,635 1,358,385 897,360 846,288 51,071 5.7%
Neighborhoods, Resources, & Events 348,185 232,059 331,222 234,491 685,003 470,393 419,378 51,015 10.8%
Library 2,321,878 1,528,243 2,289,692 1,721,320 2,030,000 1,822,619 1,822,619 ‐ 0.0%
Museum 140,801 107,186 191,090 143,470 207,513 156,721 157,635 (914) ‐0.6%
Public Works Admin 1 942,026 710,472 514,858 389,451 450,620 340,210 339,129 1,081 0.3%
Street Maintenance 3,794,716 2,923,998 3,412,892 2,519,173 3,675,414 2,775,665 2,630,100 145,566 5.2%
Transportation 5,110,639 3,840,186 5,215,309 3,793,849 4,582,866 3,388,140 3,283,394 104,746 3.1%
Debt Service 4,176,822 975,339 4,707,100 1,303,524 4,715,035 1,398,850 1,398,850 ‐ 0.0%
Non‐Departmental and Other 5,126,072 2,924,157 4,834,296 2,583,527 3,984,013 4,273,035 4,273,035 ‐ 0.0%
Total Operating Expenditures 97,203,328 69,776,635 97,302,601 69,412,171 101,299,304 75,168,538 71,984,031 3,184,507 4.2%
Total Ending Fund Balance 11,955,285$ 7,047,333$ 11,407,119$ 7,338,518$ 9,577,549$ 2,034,221$ 5,321,495$ 3,287,274 161.6%
1Facilities was included in Community Services Admin and Technical Services was included in Public Works Admin in 2009
Summary of Sources and Uses Annual Actual YTD Actual Favorable (Unfavorable)
2009 2010 2011 Variance
Annual Actual YTD Actual Annual Budget YTD Budget YTD Actual
Monthly Financial Report September 2011
Page 1 of 37
Monthly Financial Report September 2011
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through September 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 73% of
all resources supporting general governmental activities. The following section provides detail information on property,
sales, utility, and other taxes.
Property Tax
September’s collection is $468k,
making the total year‐to‐date
collection $17.7 million or 55% of
the total budget. In comparison to
the previous year, the City
collected $437k or 3% more.
Compared to the budget, the City is
above projections by $136k or 1%.
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
September 2011 sales tax receipts totaled
$1.5 million. Compared to the same
month last year, it is $64k or 5% more.
Compared to the projected current
month’s budget, it is right on target. The
year‐to‐date collection is $13.3 million or
75% of the sales tax budget. In early
October, we received notice from the
Washington State Department of
Revenue (DOR) that July 2011’s
distribution was overstated by
approximately 3.8% or $55k. This means
we are only $8k more the year‐to‐date
budget and $386k or 3% more than last
year. DOR will correct this error in
November 2011’s distribution. Based on
the revised year‐to‐date collection of $13.2 million, the City projects sales tax revenues to be very close to the budget
projection at the end of 2011.
2010 2011 2011
Actual Budget Actual $ % $ %
Jan 218,705$ 222,520$ 505,501$ 286,797$ 131% 282,982$ 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,024) ‐53%
Jul 87,952 89,486 112,076 24,124 27% 22,590 25%
Aug 149,160 151,761 25,954 (123,205) ‐83% (125,807) ‐83%
Sep 491,642 500,217 467,946 (23,696) ‐5% (32,271) ‐6%
Oct 7,060,074 7,183,221
Nov 7,288,083 7,029,489
Dec (129,429) 254,031
YTD Total 17,278,401$ 17,579,784$ 17,715,892$ 437,492$ 3% 136,109$ 1%
Annual Total 31,497,128$ 32,046,525$
Property Tax Revenues
Year to Date through September
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 1,437,859 128,430 10% 17,501 1%
Aug 1,470,881 1,542,957 1,534,218 63,337 4% (8,739) ‐1%
Sep 1,408,876 1,472,089 1,472,399 63,523 5% 310 0%
Oct 1,447,338 1,539,380 ‐
Nov 1,508,617 1,530,976 ‐
Dec 1,403,032 1,472,168 ‐
YTD Total 12,839,233$ 13,217,076$ 13,279,501$ 440,268$ 3% 62,425$ 0%
Annual Total 17,198,220$ 17,759,600$
2011 vs. Budget2011 vs. 2010
Month
Year to Date through September
Local Retail Sales Tax Revenues
Page 2 of 37
Monthly Financial Report September 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,688,853$ 1,268,525$ 1,108,904$ (579,949)$ ‐34%$ (159,621)‐13%
Auto Sales 2,255,951 2,586,414 2,398,058 142,107 6% (188,356)‐7%
General Retail 4,491,027 4,678,863 4,557,799 66,772 1% (121,064)‐3%
Manufacturing 559,580 616,855 847,752 288,171 52% 230,896 37%
Wholesale 693,099 813,140 864,380 171,281 25% 51,239 6%
Service 2,751,068 2,847,355 2,956,460 205,392 7% 109,105 4%
Other 399,655 405,924 546,149 146,493 37% 140,225 35%
Total 12,839,233$ 13,217,076$ 13,279,501$ 440,268$ 3%62,425$ 0%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility tax
September utility tax revenues are $1.2
million, which is $94k or 9% higher than
the same month last year and also ahead
of the budget by $40k or 3%. The year‐
to‐date collection is $11.7 million, which
is $744k or 7% higher than the prior year
and is also $245k or 2% 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 3,748,337$ 3,697,057$ 3,846,982$ 98,645$ 3%$ 149,924 4%
Natural Gas 1,385,099 1,469,023 1,671,467 286,369 21% 202,445 14%
Cell 1,679,973 1,676,443 1,585,584 (94,389) ‐6% (90,859)‐5%
Phone 784,427 755,703 731,537 (52,890) ‐7% (24,166)‐3%
Cable 1,020,173 1,074,815 1,019,718 (454) 0% (55,097)‐5%
Transfer Station 192,341 169,636 199,986 7,645 4% 30,350 18%
City Utilities 2,134,582 2,601,095 2,633,503 498,921 23% 32,408 1%
YTD Total 10,944,931$ 11,443,772$ 11,688,776$ 743,846$ 7%245,004$ 2%
Annual Total 14,508,363$ 15,166,600$
YTD as % of 75% 75%
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 1,188,526 48,113 4% (4,506) 0%
Aug 1,131,693 1,190,578 1,165,863 34,170 3% (24,715) ‐2%
Sep 1,082,231 1,136,760 1,176,526 94,295 9% 39,766 3%
Oct 1,138,457 1,193,046
Nov 1,112,608 1,157,583
Dec 1,312,366 1,372,199
YTD Total 10,944,931$ 11,443,772$ 11,688,776$ 743,846$ 7% 245,004$ 2%
Annual Total 14,508,363$ 15,166,600$
2011 vs. Budget2011 vs. 2010
Year to Date through September
Utility Tax Revenues
Month
Page 3 of 37
Monthly Financial Report September 2011
Other Taxes
Real Estate Excise Tax
The City collected $206k in Real Estate
Excise Tax revenues (REET) in September.
This is $94k or 84% above the current
month’s budget and $83k or 67% ahead
of the same month last year. The year‐
to‐date collection is $1.4 million or 62%
of the total budget, which is $277k or
17% less than the prior year and is also
$127k or 8% below the budget. The short
fall is due to lower real estate activity for
2011. Based on the collections so far, the
City is projecting REET to be under the
2011 budget by year‐end.
Gambling Tax
September’s Gambling Tax
collections total $126k. Year‐to‐
date total of $1.3 million is $90k or
8% above the year before and is
also $49k or 4% above budget.
Pull tabs overall are in‐line with
prior year, bingo reduced by 47%,
and card‐rooms are seeing 11%
higher in activities when compared
to the prior year.
Franchise Fees
Franchise Fees are due quarterly
and the year‐to‐date revenue
collections are $895k or 71% of
the budget. This is $14k or 2%
below the projected year‐to‐date
budget but $13k or 1% higher
than 2010. January’s budget
variance is due to receipting $45k
of January 2011’s revenues in
December 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 117,567 (32,140) ‐21% (18,628) ‐14%
Aug 209,369 190,471 159,524 (49,846) ‐24% (30,948) ‐16%
Sep 123,054 111,936 205,753 82,699 67% 93,817 84%
Oct 183,333 176,560
Nov 203,091 184,761
Dec 417,925 368,726
YTD Total 1,660,140$ 1,509,953$ 1,383,144$ (276,997)$ ‐17% (126,809)$ ‐8%
Annual Total 2,464,489$ 2,240,000$
Real Estate Excise Tax Revenues
Year to Date through September
Month
2011 vs. Budget2011 vs. 2010
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 136,775 11,161 9% 6,806 5%
Aug 138,563 143,368 144,161 5,597 4% 793 1%
Sep 105,323 108,974 125,618 20,296 19% 16,644 15%
Oct 126,396 130,779 ‐
Nov 121,757 125,978 ‐
Dec 119,481 123,624 ‐
YTD Total 1,178,752$ 1,219,619$ 1,268,562$ 89,810$ 8% 48,943$ 4%
Annual Total 1,546,386$ 1,600,000$
Year to Date through September
2011 vs. 2010 2011 vs. Budget
Gambling Tax Revenue
Month
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 294,438 7,915 3% (888) 0%
Aug 6,691 6,896 ‐
Oct 289,316 298,204 ‐
Dec 45,169 46,556 ‐
YTD Total 887,960$ 915,240$ 894,644$ 13,375$ 1% (13,699)$ ‐2%
Annual Total 1,222,444$ 1,260,000$
Month
2011 vs. 2010 2011 vs. Budget
Franchise Fees Revenue
Year to Date through September
Page 4 of 37
Monthly Financial Report September 2011
Admission Tax
Admission Tax returns are due
quarterly in January, April, July,
and October each year. July 2011
collections represent activities
conducted during the 2nd quarter
of 2011.
The report shows an increase of
$4k or 2% from the year before
and also a $13k or 6% more than
anticipated.
Licenses and Permits
Building Permits and Development Service Fees
Building Permits and Development Service
Fee revenues totaled $322k in September.
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 $2.1
million is $195k or 10% more than 2010 but
is $31k or 1% lower than budget.
Business Licenses
Business Licenses totaled $4k for September,
which is $340 or 8% below the same month last
year and is also $664 or 14% below the current
month’s budget. The year‐to‐date Business
Licenses revenue is under the budget by $22k or
6% and but is $2k or 1% above 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 86,024 10,000 13% 12,974 18%
Aug 485 466 1,194 710 147% 729 157%
Oct 73,073 70,215 ‐
Nov 462 444 ‐
YTD Total 217,864$ 209,341$ 222,088$ 4,224$ 2% 12,747$ 6%
Annual Total 291,399$ 280,000$
Month
2011 vs. 2010 2011 vs. Budget
Admission Tax Revenue
Year to Date through September
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 83,962 761 1% (5,268) ‐6%
Aug 14,782 15,853 18,393 3,611 24% 2,540 16%
Sep 4,475 4,799 4,135 (340) ‐8% (664) ‐14%
Oct 83,639 89,699 ‐
Nov 22,288 23,903 ‐
Dec 2,084 2,235 ‐
YTD Total 323,771$ 347,230$ 325,599$ 1,828$ 1% (21,631)$ ‐6%
Annual Total 431,782$ 463,067$
2011 vs. 2010
Year to Date through September
2011 vs. Budget
Business Licenses
Month
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 211,760 (107,701) ‐34% (124,307) ‐37%
Aug 167,001 194,145 393,797 226,796 136% 199,652 103%
Sep 158,882 183,653 321,961 163,079 103% 138,308 75%
Oct 223,901 232,210
Nov 125,748 143,854
Dec 169,811 185,693
YTD Total 1,917,809$ 2,144,286$ 2,113,119$ 195,309$ 10% (31,168)$ ‐1%
Annual Total 2,437,270$ 2,706,044$
Building Permits and Development Service Fees
Year to Date through September
2011 vs. Budget2011 vs. 2010
Month
Page 5 of 37
Monthly Financial Report September 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 86%
of the total revenues in this category. The year‐to‐date total Intergovernmental revenue is $7.5 million or 63% of the
budget. All grant revenues also have corresponding expenditures which was added to the City’s budget through the 2011
carry forward and 2nd quarter budget adjustment.
State Shared Revenues
State Shared Revenue collections
totaled $3.4 million since the start
of 2011. Compared to the
projected budget, State Shared
Revenues are above by $477k or
16%. Compared to the prior year,
the City is collecting $261k or 8%
more. 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 $4.7 million or 74% of
the budget. This is 5% below budget projections. The following sections provide detail information for Public Safety,
Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totaled $361k 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 $56k or 18%
more than anticipated revenue. Compared to
the prior year, the City is collecting $16k or 5%
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 70,094 13,084 23% 19,733 39%
Aug 34,206 30,217 35,891 1,684 5% 5,674 19%
Sep 42,316 37,380 30,743 (11,573) ‐27% (6,637) ‐18%
Oct 39,487 34,881 ‐
Nov 24,065 21,258 ‐
Dec 73,334 64,780 ‐
YTD Total 345,457$ 305,162$ 361,137$ 15,680$ 5% 55,975$ 18%
Annual Total 482,343$ 426,081$
Month
2011 vs. 2010
Year to Date through September
Public Safety Services
2011 vs. Budget
Intergovernmental 2010 2011 Bgt YTD Act Change 2011/2010 2011 Act vs Bgt
Fire District #25 558,243$ 674,677$ 674,677$ 116,434$ 21% $ ‐ 0%
Fire District #40 2,202,220 2,469,721 2,469,721 267,501 12%‐ 0%
State Shared Revenue 3,105,542 2,889,733 3,366,237 260,695 8% 476,504 16%
Federal Grants 429,021 362,849 362,849 (66,172) ‐15%‐ 0%
State Grants 178,923 120,461 120,461 (58,462) ‐33%‐ 0%
Other Grants/Intgovt 176,290 128,733 128,733 (47,557) ‐27%‐ 0%
ARRA Grants 430,913 416,475 416,475 (14,437) ‐3%‐ 0%
Total Rev YTD 7,081,151$ 7,062,649$ 7,539,153$ 458,002$ 6%476,504$ 7%
Total Rev Annual 11,300,032$ 12,014,671$
YTD %63% 59% 63%
Note: Includes CJ Sales Tax.
2010 2011 2011
Actual Budget Actual $ % $ %
Crim Just Sales Tax 1,210,827$ 1,347,958$ 1,361,430$ 150,604$ 12% 13,472$ 1%
Judicial Contribution 22,868 9,626 16,851 (6,017)$ ‐26% 7,225 75%
Crim Just ‐ High Crime 46,763 ‐ 142,459 95,696 205% 142,459 100%
Crim Just ‐ Pop 14,038 ‐ 14,900 862 6% 14,900 100%
Crim Just ‐ Spec Prog 53,236 50,103 56,257 3,020 6% 6,153 12%
State DUI 11,787 11,193 14,591 2,804 24% 3,398 30%
Liquor Profits 514,215 304,112 485,460 (28,754) ‐6% 181,348 60%
Liquor Excise Tax 313,158 313,265 327,685 14,527 5% 14,420 5%
Fuel Tax 918,650 853,475 946,604 27,954 3% 93,129 11%
YTD Total 3,105,542$ 2,889,733$ 3,366,237$ 260,695$ 8% 476,504$ 16%
Annual Total 4,189,298$ 3,874,444$
Year to Date through September
State Shared Revenues
2011 vs. 2010
Revenue
2011 vs. Budget
Page 6 of 37
Monthly Financial Report September 2011
Recreation
Recreation revenues totaled $142k for the
current month. Compared to the projected
monthly budget, the City collected $14k or
11% more. Compared to the same month
the prior year, the City collected $30k or
27% more. The year‐to‐date collection of
$1.3 million is $53k or 4% more than the
prior year but is $122k or 9% less than the
budget. The City is projecting Recreation
revenues to be slighting under the 2011
budget by year‐end. The budget variance is
due to a warmer June and July of 2010 than
this year.
Interfund Services
The year‐to‐date collections for Interfund
Services revenues are $2.2 million.
Compared to the projected budget, the
revenues are below by $278k or 11%.
Compared to the prior year, the revenues
are under by $185k or 8%. 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. The
budget variance is due to July and August’s
Maintenance activity not being recorded in
August and September (activity will be recorded in October).
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 $2.2 million. This is
$337k or 13% lower than a year ago and also
$146k or 6% below the budget. This
difference is mainly due to $164k lower than
budgeted Seizure Funds received this year.
The use of Seizure Funds is restricted to drug
enforcement only and is not available for
general operating purposes.
2010 2011 2011
ActualBudgetActual $%$%
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 211,388 (69,568) ‐25% (109,703) ‐34%
Aug 181,356 207,263 254,060 72,704 40% 46,797 23%
Sep 111,952 127,945 142,253 30,300 27% 14,308 11%
Oct 77,544 88,621 ‐
Nov 51,672 59,054 ‐
Dec 65,469 74,822 ‐
YTD Total 1,230,246$ 1,405,989$ 1,283,581$ 53,335$ 4% (122,408)$ ‐9%
Annual Total 1,424,932$ 1,628,486$
Recreation
Year to Date through September
2011 vs. Budget2011 vs. 2010
Month
2010 2011 2011
ActualBudgetActual $%$%
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 330,174 66,890 25% 56,679 21%
Aug 248,584 258,224 229,627 (18,957) ‐8% (28,597) ‐11%
Sep 238,713 247,970 237,006 (1,707) ‐1% (10,964) ‐4%
Oct 241,403 250,765 ‐
Nov 255,986 265,913 ‐
Dec 283,824 294,831 ‐
YTD Total 2,409,695$ 2,503,144$ 2,224,652$ (185,043)$ ‐8% (278,492)$ ‐11%
Annual Total 3,190,908$ 3,314,653$
2011 vs. Budget
Month
Interfund Services
Year to Date through September
2011 vs. 2010
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 247,468 (8,757) ‐3% 8,178 3%
Aug 319,267 286,019 184,473 (134,794) ‐42% (101,546) ‐36%
Sep 231,632 208,702 181,000 (50,632) ‐22% (27,702) ‐13%
Oct 267,539 247,930
Nov 314,160 297,164
Dec 352,044 317,767
YTD Total 2,498,625$ 2,307,490$ 2,161,542$ (337,083)$ ‐13% (145,947)$ ‐6%
Annual Total 3,432,368$ 3,170,351$
Month
2011 vs. Budget2011 vs. 2010
Year to Date through September
Fines and Penalties by Month
Page 7 of 37
Monthly Financial Report September 2011
Year to Date through September
2010 2011 2011
Actual Budget Actual $ % $ %
Civil Penalties 11,547$ 10,662$ 8,012$ (3,535)$ ‐31% (2,650)$ ‐25%
Civil Infraction Penalties 589,342 532,690 504,639 (84,702) ‐14% (28,050) ‐5%
Civil Parking Infraction Penalties 105,746 108,832 92,063 (13,684) ‐13% (16,770) ‐15%
Photo Enforcement Program 1,398,367 1,380,752 1,368,117 (30,251) ‐2% (12,635) ‐1%
Criminal Traffic Misdemeanor Fines 68,361 62,532 69,938 1,577 2% 7,406 12%
Criminal Non‐Traffic Fines 26,886 27,394 19,902 (6,984) ‐26% (7,492) ‐27%
Criminal Costs 72,983 7,650 87,184 14,201 19% 79,534 1040%
Seizure Funds ‐ Federal/State/Local 214,093 175,009 10,903 (203,190) ‐95% (164,106) ‐94%
Non‐Court Fines, Forfeitures and Penalties 11,301 1,969 785 (10,516) ‐93% (1,184) ‐60%
YTD Total 2,498,625$ 2,307,490$ 2,161,542$ (337,083)$ ‐13% (145,947)$ ‐6%
Annual Total 3,432,368$ 3,170,351$
2011 vs. 2010
Revenue
2011 vs. Budget
Fines and Penalties by Ty pe
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.4 million. The associated costs
includes the equipment provided by American Traffic
Solutions, Inc. (ATS), dedicated 2 FTEs in the Court
Services Department to process the increased
caseload and 1.1 FTEs in the Police Department for
support services. This staff 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 79% of the total
revenue in this category. The year‐to‐date
total miscellaneous is $1 million. Compared
to the projected year‐to‐date budget, the
revenues are under by $192k or 16%.
Compared to last year, the revenues are
under by $50k or 5%. 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 173,878 15,744 10% (3,954) ‐2%
Aug 93,081 107,144 133,570 40,489 43% 26,426 25%
Sep 110,810 124,170 97,973 (12,837) ‐12% (26,197) ‐21%
Oct 73,018 86,617
Nov 56,175 67,061
Dec 56,503 64,592
YTD Total 1,083,891$ 1,226,190$ 1,034,044$ (49,847)$ ‐5% (192,145)$ ‐16%
Annual Total 1,269,588$ 1,444,459$
Year to Date through September
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 151,820 72,275 67,865 83,954
Aug 126,504 96,296 56,688 67,751 28,545
Sep 90,979 81,830 71,527 67,385 14,444
Oct 158,357 ‐ 71,420 ‐ ‐
Nov 208,633 ‐ 71,884 ‐ ‐
Dec 153,166 ‐ 72,273 ‐ ‐
YTD Total 1,380,752$ 1,368,117$ 626,386$ 610,547$ 757,570$
Annual Total 1,900,908$ 841,964$
1Actuals of Revenues and Expenses
Expenses
Photo Enforcement Program
Year to Date through September
Month
Revenues
Page 8 of 37
Monthly Financial Report September 2011
2010 2011 2011
Actual Budget Actual $ % $ %
Interests and Other Earnings 256,261$ 373,747$ 211,639$ (44,622)$ ‐17% (162,108)$ ‐43%
Rents, Leases, and Concessions 624,556 600,162 607,276 (17,280) ‐3% 7,115 1%
Contributions/Donations from Private Sources 129,101 141,691 178,284 49,183 38% 36,593 26%
Other 73,973 110,590 36,845 (37,128) ‐50% (73,745) ‐67%
YTD Total 1,083,891$ 1,226,190$ 1,034,044$ (49,847)$ ‐5% (192,145)$ ‐16%
Annual Total 1,269,588$ 1,444,459$
2011 vs. Budget
Miscellaneous Revenues by Type
Year to Date through September
Revenue
2011 vs. 2010
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 74% of its budgeted general governmental expenditures at the end of September. This is
$3.2 million or 4.2% 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.
Page 9 of 37
Monthly Financial Report September 2011
CASH AND INVESTMENTS – 3RD 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 $87.7 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 (32.9%). The rest
is spread out between various certificates of
deposits (total of 41%), cash (24%) and the
interfund loan (2.1%).
The existing portfolio yield is approximately
.59%. The majority (.12%) lies within the cash at
US Bank.
US Bank ‐Cash
24%
State Investment Pool
33%
Golf Course Interfund Loan
2%
First Savings Bank Northwest
5%
Columbia Bank
8%
Fortune Bank (CDARS)
4%Sterling Bank
6%
Umpqua Bank
11%
Commencement Bank
(CDARS)
7%
Distribution by Institution
(Percent of Cash & Investment Portfolio)
Deposit Total Maturity Date APY
Weighted
Yield
Current
Allocation of Cash
and Investments
Allowed
by Policy
Cash
US Bank ‐ Cash 21,022,243 overnight 0.50% 0.12% 23.96% N/A
340,000 12/01/2011 2.25% 0.01%
355,000 12/01/2012 2.25% 0.01%
375,000 12/13/2013 2.25% 0.01%
395,000 12/01/2014 2.25% 0.01%
410,000 12/01/2015 2.25% 0.01%
US Treasury Securities
none ‐ N/A N/A 0.00%100%
Local Government Investment Pool
State Investment Pool 28,882,214 overnight 0.13% 0.04%32.92% 75.00%
US Federal Agency Securities *
‐ 0.00% 100.00%
Certificate of Deposit
First Savings Bank Northwest 2,328,105 08/24/2012 0.92% 0.02%
2,328,848 08/24/2012 0.92% 0.02%
Columbia Bank 2,000,000 11/05/2011 0.77% 0.02%
2,750,000 01/03/2012 0.69% 0.02%
2,000,000 11/05/2012 1.12% 0.03%
Fortune Bank (CDARS) 1,500,000 12/15/2011 0.90% 0.02%
1,504,108 06/14/2012 0.80% 0.01%
Fortune Bank 248,000 12/23/2011 1.25% 0.00%
Sterling Bank 5,000,000 06/16/2012 0.70% 0.04%5.70% 20.00%
Umpqua Bank 5,140,000 05/18/2012 0.90% 0.05%
5,042,636 12/25/2012 1.20% 0.07%
Commencement Bank (CDARS) 1,000,000 09/20/2012 1.50% 0.02%
5,100,192 09/06/2013 1.00% 0.06%
Commercial Paper
none N/A 0.00% 5.00%
TOTAL INVESTMENTS 87,721,345$ 0.59% 100.00%
6.95%
20.00%3.71%
20.00%11.61%
20.00%
Institution
Golf Interfund Loan
2.14% N/A
20.00%5.31%
20.00%7.69%
Page 10 of 37
Monthly Financial Report September 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 ‐ ‐ ‐ ‐ 28,430 28,600 ‐
Grants / intergovernmental 82,144 ‐ 122,607 ‐ ‐ 305,896 ‐
Charges for services 94,006 1,467,056 11,288,884 8,929,355 5,772,313 5,061,966 9,869,508
Interdepartmental services ‐ ‐ 186 151,866 112,374 332,203 ‐
Fines and penalties ‐ ‐ ‐ ‐ ‐ ‐ ‐
Rents, leases, and misc fees 1,717,648 287,980 54,000 99,878 ‐ ‐ ‐
Interest and other misc 9,305 4,513 11,719 323,321 223,480 126,384 2,958
TOTAL REVENUES 1,903,103 1,759,549 11,477,396 9,504,420 6,136,597 5,855,049 9,872,466
EXPENSES:
Utility billing ‐ ‐ 85,824 95,765 62,563 101,860 ‐
Utility systems ‐ ‐ 9,834,364 2,112,414 1,846,443 1,581,072 ‐
Utility maintenance ‐ ‐ 206,988 3,381,486 947,715 1,253,496 9,528,541
Transportation 867,861 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 1,325,268 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 867,861 1,325,268 10,127,176 5,589,665 2,856,721 2,936,428 9,528,541
AMOUNT AVAILABLE FOR DEBT SERVICE 1,035,242 434,281 1,350,220 3,914,755 3,279,876 2,918,621 343,925
DEBT SERVICE:
Principal ‐ 9,984 ‐ 1,048,425 722,526 138,340 ‐
Interest and other debt service costs ‐ 127 ‐ 453,878 233,784 188,482 ‐
TOTAL DEBT SERVICE ‐ 10,111 ‐ 1,502,303 956,310 326,822 ‐
CAPITAL PROJECTS 434,914 126,402 ‐ 1,737,136 1,931,644 1,329,383 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 600,328 297,768 1,350,220 675,316 391,922 1,262,416 343,925
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, September 30, 2011 1,961,677 1,186,372 2,312,008 7,450,843 1,073,538 4,536,279 1,015,541
Page 11 of 37
Monthly Financial Report September 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 ‐ 62,691 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ 31,594 150,281 ‐ ‐ ‐ 37,673
Charges for services
Equipment rental m&o 1,628,312 1,553,428 ‐ ‐ ‐ ‐ ‐
Telecommunications ‐ 284,831 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 80,016 ‐ 294,657 ‐ ‐ ‐
Communications ‐ ‐ ‐ 431,889 ‐ ‐ ‐
Facilities ‐ ‐ 3,087,744 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 112,607 ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ 235,208 ‐ ‐ ‐ ‐ ‐
Interest and other misc 19,535 8,089 1,272 369 22,275 24,562 16,874
Internal service fund misc:
Vehicle / equipment capital recovery 838,974 704,096 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 1,167,186 ‐ ‐
Worker's compensation / unemployment ‐ ‐ ‐ ‐ 1,070,701 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 7,805,047 2,400,587
Other misc 8,375 1,377 8,653 21 3,290 453,114 ‐
Capital contributions 20,854 ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets 74,955 ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 273,612 12,428 3,695
TOTAL REVENUES 2,591,005 3,073,937 3,247,950 726,936 2,537,064 8,295,151 2,458,829
EXPENSES:
Communications 409,354
Equipment rental 1,774,001
Facilities 2,967,061
Healthcare 7,191,328
Information technology 2,249,504
Print and mail 283,636
Retiree healthcare 626,327
Risk management
Risk management 1,531,649
Unemployment 110,902
Worker's compensation 856,600
TOTAL EXPENSES 1,774,001 2,249,504 2,967,061 692,990 2,499,151 7,191,328 626,327
AMOUNT AVAILABLE FOR CAPITAL 817,004 824,433 280,889 33,946 37,913 1,103,823 1,832,502
CAPITAL PROJECTS 1,659,717 643,203 188,397 ‐ ‐ ‐ ‐
TRANSFERS IN ‐ 62,970 ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE (842,713) 244,200 92,492 33,946 37,913 1,103,823 1,832,502
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, September 30, 2011 4,450,394 2,193,365 333,538 104,160 6,727,937 7,305,717 5,203,539
Page 12 of 37
Monthly Financial Report September 2011
FUND BALANCE
Page 14 shows the ending fund balance as of September 2011. The City’s fund balance is a combination of current
deficit/surplus of funds which have accrued from unexpended operating budgets, 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 September, the City has $5.3 million reported in the combined general governmental fund balance of the
current year’s operating budget, which is approximately 5% of budgeted operating expenditures. This is a decrease of $6.1
million from the year’s beginning balance. September’s ending fund balance is over the anticipated General Governmental
Fund Balance of $2 million by $3.3 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 September 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 September 2011
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through September 30, 2011
Funds
Balance
01/01/2011
Budgeted
Revenue
Revenue
09/30/11
Total Funds
Available
Budgeted
Expenditure
Expenditure
09/30/11
Ending
Balance
GENERAL GOVERNMENT FUNDS:11,407,119 99,469,734 76,186,023 87,593,142 101,299,304 82,271,647 5,321,495
000 General 9,477,148 72,539,830 46,088,557 55,565,705 74,869,192 54,679,057 886,648
001 Community Services 631,801 10,829,491 7,547,640 8,179,441 10,763,076 7,767,195 412,246
003 Street 116,298 8,402,117 6,064,375 6,180,673 8,258,280 5,913,494 267,179
004 Community Dev Block Grant (55,231) 501,728 228,723 173,492 368,333 189,694 (16,202)
005 Museum 66,830 195,966 196,342 263,172 207,513 157,635 105,537
006 Library 47,347 2,030,000 2,031,202 2,078,549 2,030,000 1,822,619 255,930
009 Farmers Market 81,630 67,500 69,336 150,966 62,875 45,313 105,653
010 Fire Memorial 1,251 ‐ 202 1,453 ‐ ‐ 1,453
011 Fire Health & Wellness 24,072 25,000 18,257 42,329 25,000 10,173 32,156
031 Pa rk Memorial 176,950 ‐ 635 177,585 ‐ ‐ 177,585
201 Ltd GO Bonds Gen Govt Debt 312,938 2,146,142 12,174,442 12,487,380 1,983,075 10,573,258 1,914,122
215 Gen Govt Misc Debt Service 526,085 2,731,960 1,766,312 2,292,397 2,731,960 1,113,209 1,179,188
SPECIAL REVENUE FUNDS:
102 Arterial Street 171,720 620,000 447,038 618,758 620,000 ‐ 618,758
108 Leased City Properties 759,594 748,060 490,683 1,250,277 614,457 543,830 706,447
110 Hotel Motel 212,950 245,000 213,102 426,052 275,000 206,331 219,721
118 Reserve for Paths & Trails 3,299 ‐ 12 3,311 ‐ ‐ 3,311
125 1% For Art 136,830 32,000 457 137,287 68,257 15,540 121,747
127 Cable Communication 171,358 85,000 78,988 250,346 221,301 42,537 207,809
135 Springbrook Wetlands Bank 660,524 ‐ 2,391 662,915 ‐ ‐ 662,915
DEBT SERVICE FUNDS:
219 1989 Unlimited GO Bonds ‐ ‐ ‐ ‐ ‐ ‐ ‐
CAPITAL PROJECT FUNDS (CIP):
303 Community Dev Mitigation 1,343,877 60,000 41,822 1,385,699 400,000 ‐ 1,385,699
304 Fire Mitigation 1,929,477 100,000 64,933 1,994,410 529,056 ‐ 1,994,410
305 Transportation Mitigation 1,119,954 250,000 148,930 1,268,884 999,494 ‐ 1,268,884
316 Municipal Facilities CIP 5,759,297 2,148,558 390,083 6,149,380 7,481,499 2,603,542 3,545,838
317 Transportation CIP 3,808,080 24,295,301 8,872,146 12,680,226 28,007,800 10,050,280 2,629,946
318 So Lake WA Infrastructure Proj 58,522 ‐ 194 58,716 58,000 5,837 52,879
326 Housing Opportunity 163,787 ‐ 505 164,292 160,000 35,000 129,292
336 New Library Development ‐ 19,960,000 19,930,525 19,930,525 11,960,000 664,138 19,266,387
ENTERPRISE FUNDS:
402 Airport 1,295,036 432,010 368,789 1,663,825 1,125,756 867,861 795,964
403 Solid Waste Utility 961,788 15,015,942 11,477,396 12,439,184 14,951,710 10,127,176 2,312,008
404 Golf Course 630,924 2,483,545 1,758,719 2,389,643 2,504,738 1,424,597 965,046
422 Airport Capital 66,313 3,433,408 1,534,315 1,600,628 3,003,521 434,914 1,165,714
424 Golf Course Capital 257,680 100,000 75,830 333,510 220,000 112,186 221,324
INTERNAL SERVICE FUNDS:
501 Equipment Repair/Replacement 5,293,107 3,240,401 2,591,005 7,884,112 4,591,337 3,433,719 4,450,393
502 I nsurance 6,690,024 3,178,883 2,537,063 9,227,087 3,018,564 2,499,151 6,727,936
503 Information Services 1,949,165 4,119,051 3,136,906 5,086,071 5,633,307 2,892,706 2,193,365
504 Facilities 241,046 4,243,673 3,247,950 3,488,996 4,256,261 3,155,458 333,538
505 Communications 70,214 953,941 726,937 797,151 957,746 692,990 104,161
512 Insurance, Healthcare 6,201,894 11,248,058 8,295,151 14,497,045 10,844,696 7,191,328 7,305,717
522 Insurance, Leoff1 Retirees HC 3,371,037 2,935,684 2,458,828 5,829,865 2,261,732 626,327 5,203,538
FIDUCIARY FUNDS:
611 Firemen's Pension 4,286,248 300,000 120,553 4,406,801 565,475 222,446 4,184,355
Funds
Balance
01/01/2011
Budgeted
Revenue
Revenue
09/30/11
Total Funds
Available
Budgeted
Expenditure
Expenditure
09/30/11
Ending
Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 11,402,622 46,660,496 31,368,534 42,771,156 50,069,800 28,694,952 14,076,204
405 Water Utility 4,695,116 9,680,689 6,010,469 10,705,585 10,521,313 7,101,619 3,603,966
406 Waste Water Utility 681,616 4,931,139 3,714,738 4,396,354 5,141,813 3,813,032 583,322
407 Surface Water Utility 1,462,126 5,353,933 3,573,617 5,035,743 5,092,613 3,263,249 1,772,494
416 King County Metro 671,616 13,156,760 9,872,466 10,544,082 13,156,760 9,528,541 1,015,541
425 Water Utility Construction 2,064,638 4,997,301 3,493,896 5,558,534 6,067,301 1,727,484 3,831,050
426 Waste Water Construction ‐ 3,845,000 2,421,859 2,421,859 3,790,000 1,931,644 490,215
427 Surface Water Construction 1,811,737 4,695,674 2,281,432 4,093,169 6,300,000 1,329,383 2,763,786
461 Waterworks Bond Reserve ‐ ‐ ‐ ‐ ‐ ‐ ‐
471 Waterworks Rate Stabilization 15,773 ‐ 57 15,830 ‐ ‐ 15,830
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 55,528,886 56,321,612 (792,726) 10,614,393
August 60,805,281 64,769,227 (3,963,946) 7,443,173
September 65,898,407 71,984,031 (6,085,624) 5,321,495
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,975 5,379,006 ‐5.94%
Feb 10,949,126 11,050,241 0.92%
Mar 16,248,590 16,654,842 2.50%
Apr 29,068,549 30,062,704 3.42%
May 44,710,380 44,974,654 0.59%
Jun 49,651,162 49,588,204 ‐0.13%
Jul 55,628,262 55,528,886 ‐0.18%
Aug 60,924,993 60,805,281 ‐0.20%
Sep 65,795,639 65,898,407 0.16%
Oct 78,896,322
Nov 93,180,036
Dec 99,469,734
Percent of budget 76.59%
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,318 17,109,916 1.61%
Jul 16,927,805 17,221,992 1.74%
Aug 17,079,566 17,247,946 0.99%
Sep 17,579,784 17,715,892 0.77%
Oct 24,763,004
Nov 31,792,494
Dec 32,046,525
Percent of budget 55.28%
$‐
$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 11,435,443 0.06%
Aug 13,153,559 13,145,959 ‐0.06%
Sep 14,798,459 14,793,080 ‐0.04%
Oct 16,517,368
Nov 18,234,679
Dec 19,879,280
Percent of budget 74.41%
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 9,346,387 2.52%
Aug 10,307,012 10,512,250 1.99%
Sep 11,443,772 11,688,776 2.14%
Oct 12,636,818
Nov 13,794,401
Dec 15,166,600
Percent of budget 77.07%
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 1,363,681 ‐19.46%
Aug 1,895,469 1,693,888 ‐10.63%
Sep 2,064,907 1,939,870 ‐6.06%
Oct 2,302,673
Nov 2,462,856
Dec 2,612,987
Percent of budget 74.24%
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 561,321 565,843 0.81%
Feb 1,138,597 1,079,643 ‐5.18%
Mar 1,636,573 1,648,102 0.70%
Apr 2,628,148 2,707,888 3.03%
May 4,918,239 5,258,407 6.92%
Jun 5,433,811 5,771,371 6.21%
Jul 5,896,467 6,317,671 7.14%
Aug 6,638,345 7,081,699 6.68%
Sep 7,062,649 7,539,153 6.75%
Oct 7,699,147
Nov 10,882,963
Dec 12,014,671
Percent of budget 62.75%
Note: Includes CJ Sales Tax.
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
$10
$11
$12
$13
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 3,516,730 ‐10.78%
Aug 4,487,827 4,160,030 ‐7.30%
Sep 4,949,440 4,682,023 ‐5.40%
Oct 5,447,614
Nov 5,842,063
Dec 6,366,817
Percent of budget 73.54%
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 1,812,194 ‐0.03%
Aug 2,098,788 1,998,200 ‐4.79%
Sep 2,307,490 2,181,260 ‐5.47%
Oct 2,555,419
Nov 2,852,584
Dec 3,170,351
Percent of budget 68.80%
$‐
$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,648,277 3,543,760 ‐2.86%
Aug 3,993,321 3,860,151 ‐3.33%
Sep 4,193,423 4,154,780 ‐0.92%
Oct 4,969,350
Nov 5,246,008
Dec 6,075,921
Percent of budget 68.38%
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 802,501 ‐19.34%
Aug 1,102,019 936,071 ‐15.06%
Sep 1,226,190 1,034,044 ‐15.67%
Oct 1,312,806
Nov 1,379,867
Dec 1,444,459
Percent of budget 71.59%
$‐
$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 168,527 168,527 0.00%
Aug 169,086 169,086 0.00%
Sep 169,528 169,528 0.00%
Oct 692,123
Nov 692,123
Dec 692,123
Percent of budget 24.49%
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 1,017,867 ‐15.65%
Aug 1,397,066 1,177,391 ‐15.72%
Sep 1,508,909 1,383,144 ‐8.33%
Oct 1,675,542
Nov 1,860,141
Dec 2,240,000
Percent of budget 61.75%
$‐
$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,124,579 6,990,159 ‐1.89%
Feb 16,881,946 15,756,416 ‐6.67%
Mar 24,548,143 23,321,083 ‐5.00%
Apr 32,233,750 30,363,594 ‐5.80%
May 40,377,780 38,187,393 ‐5.42%
Jun 50,931,591 48,730,646 ‐4.32%
Jul 59,069,604 56,321,612 ‐4.65%
Aug 67,231,846 64,769,227 ‐3.66%
Sep 75,168,538 71,984,031 ‐4.24%
Oct 84,557,209
Nov 92,592,915
Dec 101,299,304
Percent of budget expended 81.22%
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,585 22,021 ‐2.50%
Feb 45,866 44,576 ‐2.81%
Mar 69,289 67,521 ‐2.55%
Apr 93,250 89,659 ‐3.85%
May 116,460 112,072 ‐3.77%
Jun 139,640 134,795 ‐3.47%
Jul 162,401 158,140 ‐2.62%
Aug 185,324 180,746 ‐2.47%
Sep 207,934 203,409 ‐2.18%
Oct 229,314
Nov 252,426
Dec 276,567
Percent of budget expended 73.55%
$‐
$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 106,657 112,718 5.68%
Feb 235,853 229,987 ‐2.49%
Mar 363,260 346,789 ‐4.53%
Apr 489,917 480,072 ‐2.01%
May 613,510 605,772 ‐1.26%
Jun 732,054 729,119 ‐0.40%
Jul 861,982 862,086 0.01%
Aug 981,310 994,268 1.32%
Sep 1,117,720 1,121,986 0.38%
Oct 1,240,172
Nov 1,357,062
Dec 1,478,297
Percent of budget expended 75.90%
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,261 49,604 ‐3.23%
Feb 103,499 98,230 ‐5.09%
Mar 159,969 154,386 ‐3.49%
Apr 279,463 315,627 12.94%
May 379,294 369,865 ‐2.49%
Jun 433,303 420,930 ‐2.86%
Jul 483,600 474,938 ‐1.79%
Aug 531,809 525,691 ‐1.15%
Sep 581,018 577,202 ‐0.66%
Oct 675,052
Nov 724,620
Dec 786,947
Percent of budget expended 73.35%
$‐
$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,425 14,189 ‐1.64%
Feb 28,701 21,908 ‐23.67%
Mar 42,850 23,616 ‐44.89%
Apr 57,329 25,472 ‐55.57%
May 71,432 28,865 ‐59.59%
Jun 85,716 33,294 ‐61.16%
Jul 100,206 37,133 ‐62.94%
Aug 114,341 39,784 ‐65.21%
Sep 128,494 44,161 ‐65.63%
Oct 142,100
Nov 156,260
Dec 170,717
Percent of budget expended 25.87%
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 102,294 130,446 27.52%
Feb 242,731 264,464 8.95%
Mar 393,158 395,280 0.54%
Apr 537,598 528,480 ‐1.70%
May 677,661 657,439 ‐2.98%
Jun 817,578 790,004 ‐3.37%
Jul 955,999 923,755 ‐3.37%
Aug 1,097,634 1,056,642 ‐3.73%
Sep 1,232,013 1,189,429 ‐3.46%
Oct 1,366,319
Nov 1,499,225
Dec 1,588,429
Percent of budget expended 74.88%
$‐
$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 172,706 163,613 ‐5.26%
Feb 350,541 326,156 ‐6.96%
Mar 536,403 490,833 ‐8.50%
Apr 715,028 661,478 ‐7.49%
May 892,550 831,527 ‐6.84%
Jun 1,075,642 1,040,289 ‐3.29%
Jul 1,258,557 1,209,319 ‐3.91%
Aug 1,434,869 1,384,788 ‐3.49%
Sep 1,614,729 1,559,522 ‐3.42%
Oct 1,775,894
Nov 1,948,024
Dec 2,134,452
Percent of budget expended 73.06%
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,367 77,455 4.15%
Feb 157,395 155,007 ‐1.52%
Mar 236,397 232,560 ‐1.62%
Apr 315,098 310,112 ‐1.58%
May 393,089 387,665 ‐1.38%
Jun 470,768 465,217 ‐1.18%
Jul 548,159 542,926 ‐0.95%
Aug 625,262 620,791 ‐0.72%
Sep 702,073 698,417 ‐0.52%
Oct 775,757
Nov 851,215
Dec 926,674
Percent of budget expended 75.37%
$‐
$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 280,682 231,587 ‐17.49%
Feb 554,483 474,633 ‐14.40%
Mar 819,050 716,400 ‐12.53%
Apr 1,085,863 953,343 ‐12.20%
May 1,351,209 1,220,807 ‐9.65%
Jun 1,609,891 1,431,566 ‐11.08%
Jul 1,871,519 1,673,333 ‐10.59%
Aug 2,118,179 1,876,800 ‐11.40%
Sep 2,389,591 2,109,094 ‐11.74%
Oct 2,630,325
Nov 2,880,148
Dec 3,137,985
Percent of budget expended 67.21%
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 52,199 68,491 31.21%
Feb 121,977 123,830 1.52%
Mar 182,348 179,805 ‐1.39%
Apr 237,281 234,834 ‐1.03%
May 300,891 297,953 ‐0.98%
Jun 361,363 357,808 ‐0.98%
Jul 431,784 430,038 ‐0.40%
Aug 490,780 484,313 ‐1.32%
Sep 560,100 544,936 ‐2.71%
Oct 618,615
Nov 684,023
Dec 749,128
Percent of budget expended 72.74%
$‐
$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 109,960 104,320 ‐5.13%
Feb 217,044 258,972 19.32%
Mar 331,808 348,727 5.10%
Apr 436,143 475,330 8.98%
May 555,730 581,947 4.72%
Jun 713,155 685,502 ‐3.88%
Jul 829,502 795,138 ‐4.14%
Aug 966,634 951,339 ‐1.58%
Sep 1,136,529 1,082,329 ‐4.77%
Oct 1,271,607
Nov 1,370,979
Dec 1,533,697
Percent of budget expended 70.57%
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 185,479 155,421 ‐16.21%
Feb 339,681 315,453 ‐7.13%
Mar 514,316 467,036 ‐9.19%
Apr 669,701 620,994 ‐7.27%
May 859,496 770,959 ‐10.30%
Jun 1,017,256 930,622 ‐8.52%
Jul 1,179,972 1,076,398 ‐8.78%
Aug 1,345,514 1,245,218 ‐7.45%
Sep 1,510,764 1,425,349 ‐5.65%
Oct 1,621,863
Nov 1,765,760
Dec 2,088,212
Percent of budget expended 68.26%
$‐
$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,242 86,565 10.64%
Feb 154,839 155,437 0.39%
Mar 236,793 221,683 ‐6.38%
Apr 317,732 282,721 ‐11.02%
May 397,739 342,697 ‐13.84%
Jun 481,078 417,784 ‐13.16%
Jul 563,166 491,235 ‐12.77%
Aug 644,689 561,242 ‐12.94%
Sep 726,325 633,893 ‐12.73%
Oct 803,567
Nov 878,678
Dec 973,851
Percent of budget expended 65.09%
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,318,662 2,369,174 2.18%
Feb 4,980,498 4,383,450 ‐11.99%
Mar 7,509,693 7,075,221 ‐5.79%
Apr 9,978,604 8,969,395 ‐10.11%
May 12,392,962 11,112,660 ‐10.33%
Jun 15,133,567 14,046,545 ‐7.18%
Jul 17,688,902 16,310,772 ‐7.79%
Aug 20,235,790 19,248,778 ‐4.88%
Sep 22,913,200 21,206,441 ‐7.45%
Oct 25,185,431
Nov 28,049,446
Dec 31,011,293
Percent of budget expended 68.38%
$‐
$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,948,185 1,754,253 ‐9.95%
Feb 4,592,145 4,132,293 ‐10.01%
Mar 6,422,692 5,900,678 ‐8.13%
Apr 8,140,156 7,652,583 ‐5.99%
May 9,912,008 9,538,569 ‐3.77%
Jun 11,712,250 11,333,418 ‐3.23%
Jul 13,546,868 13,191,127 ‐2.63%
Aug 15,384,403 15,170,911 ‐1.39%
Sep 17,224,095 17,069,616 ‐0.90%
Oct 18,916,100
Nov 20,805,510
Dec 22,676,137
Percent of budget expended 75.28%
Community YTD Annual %
$‐
$3
$6
$9
$12
$15
$18
$21
$24
Millions Fire & Emergency Services
Budget
Actual
Last Year
$1 20
Millions Community Services Admin
Services Admin Budget Actual over (under)
Jan 24,171 33,774 39.73%
Feb 69,201 67,558 ‐2.37%
Mar 103,855 102,208 ‐1.59%
Apr 138,500 136,129 ‐1.71%
May 172,991 170,164 ‐1.63%
Jun 207,552 204,042 ‐1.69%
Jul 241,961 238,509 ‐1.43%
Aug 275,415 272,651 ‐1.00%
Sep 309,116 306,588 ‐0.82%
Oct 342,587
Nov 375,962
Dec 409,872
Percent of budget expended 74.80%
$‐
$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 238,049 261,191 9.72%
Feb 512,298 527,048 2.88%
Mar 806,940 799,401 ‐0.93%
Apr 1,112,020 1,109,451 ‐0.23%
May 1,434,676 1,422,731 ‐0.83%
Jun 1,775,143 1,750,372 ‐1.40%
Jul 2,134,704 2,093,871 ‐1.91%
Aug 2,540,816 2,435,040 ‐4.16%
Sep 2,881,349 2,788,379 ‐3.23%
Oct 3,226,442
Nov 3,536,345
Dec 3,911,658
Percent of budget expended 71.28%
Parks Planning
and Natural 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
Resources Budget Actual over (under)
Jan 48,221 34,349 ‐28.77%
Feb 96,441 69,260 ‐28.18%
Mar 144,662 109,668 ‐24.19%
Apr 192,882 150,610 ‐21.92%
May 241,103 204,169 ‐15.32%
Jun 289,323 256,105 ‐11.48%
Jul 337,544 301,757 ‐10.60%
Aug 385,764 349,262 ‐9.46%
Sep 433,985 397,535 ‐8.40%
Oct 482,205
Nov 530,426
Dec 578,646
Percent of budget expended 68.70%
$‐
$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,457 361,259 22.27%
Feb 635,648 702,382 10.50%
Mar 1,005,300 1,058,705 5.31%
Apr 1,348,719 1,408,767 4.45%
May 1,716,986 1,763,066 2.68%
Jun 2,115,872 2,128,093 0.58%
Jul 2,772,164 2,702,061 ‐2.53%
Aug 3,487,773 3,341,666 ‐4.19%
Sep 3,976,507 3,855,315 ‐3.05%
Oct 4,329,308
Nov 4,783,398
Dec 5,177,897
Percent of budget expended 74.46%
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,080 53,756 ‐9.01%
Feb 125,735 118,956 ‐5.39%
Mar 197,870 177,533 ‐10.28%
Apr 389,222 369,358 ‐5.10%
May 472,589 499,658 5.73%
Jun 551,809 560,790 1.63%
Jul 755,219 694,753 ‐8.01%
Aug 834,905 770,871 ‐7.67%
Sep 897,360 846,288 ‐5.69%
Oct 1,056,218
Nov 1,157,557
Dec 1,358,385
Percent of budget expended 62.30%
$‐
$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
Neighborhoods
, Resources,
and Events Budget
YTD
Actual
Annual %
over (under)
Jan 41,588 36,383 ‐12.52%
Feb 84,789 73,402 ‐13.43%
Mar 128,116 110,686 ‐13.60%
Apr 172,462 157,589 ‐8.62%
May 226,912 198,703 ‐12.43%
Jun 289,150 252,486 ‐12.68%
Jul 374,553 304,660 ‐18.66%
Aug 424,012 369,016 ‐12.97%
Sep 470,393 419,378 ‐10.85%
Oct 508,406
Nov 545,765
Dec 685,003
Percent of budget expended 61.22%
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,817,619 1,817,619 0.00%
Aug 1,820,119 1,820,119 0.00%
Sep 1,822,619 1,822,619 0.00%
Oct 1,995,437
Nov 2,027,120
Dec 2,030,000
Percent of budget expended 89.78%
$‐
$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,818 17,146 1.95%
Feb 34,325 34,638 0.91%
Mar 51,635 51,915 0.54%
Apr 69,255 69,499 0.35%
May 87,088 86,914 ‐0.20%
Jun 104,880 104,539 ‐0.33%
Jul 122,308 122,204 ‐0.08%
Aug 139,524 139,835 0.22%
Sep 156,721 157,635 0.58%
Oct 173,773
Nov 190,524
Dec 207,513
Percent of budget expended 75.96%
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,025 37,289 3.51%
Feb 73,605 74,538 1.27%
Mar 112,016 111,889 ‐0.11%
Apr 152,983 149,219 ‐2.46%
May 189,927 187,166 ‐1.45%
Jun 226,584 224,646 ‐0.86%
Jul 264,203 262,362 ‐0.70%
Aug 304,561 300,269 ‐1.41%
Sep 340,210 339,129 ‐0.32%
Oct 375,268
Nov 411,886
Dec 450,620
Percent of budget expended 75.26%
$‐
$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 291,313 279,841 ‐3.94%
Feb 591,618 597,149 0.93%
Mar 887,819 894,017 0.70%
Apr 1,208,483 1,168,482 ‐3.31%
May 1,508,949 1,455,914 ‐3.51%
Jun 1,824,363 1,755,569 ‐3.77%
Jul 2,161,928 2,050,768 ‐5.14%
Aug 2,489,084 2,335,142 ‐6.18%
Sep 2,775,665 2,630,100 ‐5.24%
Oct 3,065,897
Nov 3,345,901
Dec 3,675,414
Percent of budget expended 71.56%
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
Transportation Budget Actual over (under)
Jan 329,399 308,560 ‐6.33%
Feb 715,903 689,957 ‐3.62%
Mar 1,109,163 1,101,787 ‐0.66%
Apr 1,480,840 1,429,170 ‐3.49%
May 1,859,714 1,787,292 ‐3.89%
Jun 2,251,115 2,164,571 ‐3.84%
Jul 2,592,807 2,544,732 ‐1.85%
Aug 3,014,474 2,935,188 ‐2.63%
Sep 3,388,140 3,283,394 ‐3.09%
Oct 3,788,174
Nov 4,154,514
Dec 4,582,866
Percent of budget expended 71.64%
$‐
$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 1,285,140 1,285,140 0.00%
Aug 1,408,246 1,408,246 0.00%
Sep 1,398,850 1,398,850 0.00%
Oct 3,929,196
Nov 4,322,115
Dec 4,715,035
Percent of budget expended 29.67%
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,726,837 3,726,837 0.00%
Aug 3,950,614 3,950,614 0.00%
Sep 4,273,035 4,273,035 0.00%
Oct 4,032,183
Nov 3,988,027
Dec 3,984,013
Percent of budget expended 107.25%
$‐
$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,430,390 4,058,961 2,857,743
Feb 7,860,086 8,549,030 7,011,826
Mar 11,116,422 13,634,112 11,834,545
Apr 17,408,265 18,015,133 15,336,879
May 21,535,365 22,882,500 18,961,840
Jun 29,848,986 27,295,181 25,779,962
Jul 37,504,616 32,465,110 30,257,045
Aug 41,995,045 37,273,969 34,189,101
Sep 47,230,328 42,845,872 38,822,126
Oct 52,727,982
Nov 57,440,986
Dec 64,992,510
Percent of budget expended 53.22%
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 1,465,484 906,102
Aug 2,062,285 1,677,627 1,129,146
Sep 2,401,670 1,903,104 1,302,775
Oct 3,216,748
Nov 3,508,481
Dec 4,129,277
Percent of budget expended 31.55%
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 1,265,228 1,211,837
Aug 1,487,532 1,609,624 1,376,743
Sep 1,662,841 1,834,550 1,536,782
Oct 1,987,022
Nov 2,125,704
Dec 2,724,738
Percent of budget expended 56.40%
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