HomeMy WebLinkAbout201201, January.pdfFINANCE AND
INFORMATION TECHNOLOGY
M E M O R A N D U M
DATE: March 20, 2012
TO: Rich Zwicker, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: January 2012 Financial Status Report
At the end of January, general governmental revenues show $67k or 1.3% over budget.
Revenues sources that are higher than expected are: utility taxes ($42k); gambling excise taxes
($63k); building permits & development service fees ($48k); state shared revenues ($62k); and
rents, leases, and concessions ($31k). On the down side, the revenue sources that are
underperforming the year to date budget are: property taxes ($106k below); sales tax ($61k
below); franchise fees ($27k below); and real estate excise taxes ($68k below).
General government expenditures showed favorable variances of $492k or 6.9%. $270k of the
saving is due to the timing of payment for communication services provide by Valley
Communications. See page 9 of report for further expenditure savings/over‐spent
explanations.
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,955,285$ 11,955,285$ 11,407,119$ 11,407,119$ 9,338,707$ 9,338,707$ 11,057,551$ 1,718,844$ 18.4%
OPERATING REVENUES
Property Tax 31,497,128 218,705 32,357,894 505,501 32,896,746 255,343 149,112 (106,231) ‐41.6%
Sales Tax 17,198,220 1,289,364 17,729,731 1,339,658 17,864,000 1,388,527 1,327,548 (60,980) ‐4.4%
Sales Tax ‐ Annexation Credit 2,025,660 153,295 2,033,954 158,398 2,101,647 163,670 165,474 1,804 1.1%
Criminal Justice Sales Tax 1,620,479 126,465 1,809,757 132,724 1,867,145 136,932 145,992 9,059 6.6%
Natural Gas Use Tax 228,514 20,459 249,407 22,911 270,394 24,839 28,093 3,254 13.1%
Admission Tax 291,399 74,777 308,200 70,405 350,000 79,953 73,420 (6,534) ‐8.2%
Franchise Fees 1,222,444 45,703 1,234,448 305,646 1,323,000 327,571 300,392 (27,179) ‐8.3%
Electricity Tax 5,036,907 526,090 5,166,711 476,061 5,283,280 486,801 493,043 6,242 1.3%
Natural Ga s Utility Tax 1,577,756 247,250 1,848,806 218,308 1,950,000 230,257 233,174 2,917 1.3%
Transfer Station 269,912 5,937 297,474 20,780 248,762 17,377 17,157 (220) ‐1.3%
TV Cable 1,296,744 ‐ 1,385,275 118,469 1,427,679 122,095 118,851 (3,244) ‐2.7%
Telephone 1,038,009 79,580 966,827 73,415 1,000,000 75,934 75,154 (780) ‐1.0%
Cellular Phone 2,206,637 186,705 2,054,183 179,272 2,309,360 201,542 221,778 20,236 10.0%
City Utilities 2,853,884 216,909 3,516,179 253,808 3,665,728 264,603 281,927 17,324 6.5%
Leasehold Excise Tax 138,830 ‐ 162,593 ‐ 145,000 ‐ ‐ ‐ 0.0%
Gambling Excise Tax 1,546,386 135,608 1,671,414 118,304 1,600,000 113,250 175,959 62,710 55.4%
Real Estate Excise Tax 2,464,489 71,303 2,074,059 161,911 2,025,000 157,987 77,631 (80,356) ‐50.9%
Less: Municipal Facilities CIP REET (400,000) (11,884) (400,000) (28,006) (400,000) (28,006) (15,335) 12,672 ‐45.2%
EMS Levy 1,161,114 ‐ 868,873 ‐ 1,007,976 ‐ ‐ ‐ 0.0%
Business License Fees 431,782 77,955 442,451 84,109 469,817 89,311 88,676 (635) ‐0.7%
Other Licenses and Permits 262,629 20,561 232,534 14,017 213,305 12,858 23,034 10,176 79.1%
Building Permits & Development Svc Fees 2,437,270 394,165 2,772,779 132,621 2,466,063 112,664 160,750 48,086 42.7%
Intergovt'l (Grants, State Shared, etc) 4,426,676 245,381 4,737,323 431,946 4,381,262 252,514 305,199 52,686 20.9%
Fire District 25 and 40 Contracts 5,252,877 ‐ 6,110,668 1,173 6,008,694 11,673 11,673 ‐ 0.0%
Public Safety 482,343 35,994 484,985 18,824 430,635 16,715 15,229 (1,486) ‐8.9%
Culture and Recreation 1,424,932 62,673 1,493,540 61,933 1,660,863 68,872 62,072 (6,800) ‐9.9%
Interfund/Interdept‐Services 3,190,908 242,658 3,070,506 190,881 3,414,200 212,247 237,384 25,137 11.8%
Fines and Forfeits 1,291,817 5,172 1,163,602 25 1,088,750 41 25 (16) ‐38.8%
Photo Enforcement 1,925,159 187,281 1,897,782 165,696 1,944,713 169,793 183,453 13,659 8.0%
Seizure Funds ‐ Federal/State/Local 221,046 46,627 83,220 ‐ 180,693 ‐ ‐ ‐ 0.0%
Interests and Other Earnings 327,558 21,570 294,452 12,157 195,400 8,067 22,742 14,674 181.9%
Rents, Leases, and Concessions 727,338 135,736 744,834 122,667 701,464 115,524 146,205 30,681 26.6%
Contributions and Donations 133,756 3,016 196,586 6,055 105,000 3,234 27,820 24,586 760.3%
Other Miscellaneous 290,239 16,501 341,878 9,339 357,358 9,596 15,502 5,906 61.6%
Other Financing Sources (Transfer‐In, etc) 653,595 ‐ 1,073,507 ‐ 1,037,752 ‐ ‐ ‐ 0.0%
Total Operating Revenues 96,754,435 4,881,556 100,476,431 5,379,006 101,591,685 5,101,783 5,169,136 67,353 1.3%
OPERATING EXPENDITURES
Legislative 259,345 21,032 271,236 22,021 284,087 23,052 21,995 1,057 4.6%
Executive 1,578,526 134,784 1,566,906 112,718 1,468,694 115,566 75,851 39,715 34.4%
Hearing Examiner 174,447 14,619 59,878 14,189 71,025 8,732 1,731 7,001 80.2%
City Attorney 1,565,597 127,162 1,596,609 130,446 1,668,686 135,939 136,926 (987) ‐0.7%
Court Services 2,007,599 168,470 2,084,170 163,613 2,147,819 174,315 166,993 7,322 4.2%
Community and Eco Dvlpmnt Admin 579,396 44,995 929,814 77,455 952,912 77,315 79,562 (2,247) ‐2.9%
Development Services 2,946,413 285,403 2,810,736 231,587 3,181,944 285,738 239,412 46,326 16.2%
Economic Development 1,322,004 92,877 724,970 68,491 735,088 57,949 51,733 6,216 10.7%
Planning 1,774,508 132,451 1,447,781 104,320 1,516,719 111,447 121,734 (10,286) ‐9.2%
Finance 2,214,458 145,053 2,134,667 155,421 1,969,836 136,092 152,157 (16,065) ‐11.8%
City Clerk 789,209 48,025 736,880 49,604 897,889 57,441 51,770 5,671 9.9%
Human Resources 861,221 71,457 888,252 86,565 946,956 85,534 69,265 16,269 19.0%
Police 23,946,386 2,106,661 24,737,346 2,232,881 24,746,366 2,205,827 1,904,823 301,004 13.6%
Jail Services 3,539,035 153,958 6,206,735 136,293 4,740,599 193 193 ‐ 0.0%
Fire 21,554,792 1,768,398 22,511,597 1,754,253 24,056,171 1,923,042 1,891,121 31,921 1.7%
Community Services Admin 1 1,063,011 45,998 416,284 33,774 421,043 22,705 39,072 (16,367) ‐72.1%
Parks 3,421,424 209,312 3,829,676 261,191 4,034,496 261,786 274,545 (12,759) ‐4.9%
Parks Planning & Natural Resources 448,574 14,316 551,423 34,349 595,868 28,998 36,047 (7,049) ‐24.3%
Recreation 4,433,420 279,542 4,974,002 361,259 5,263,801 358,551 304,539 54,013 15.1%
Human Services 1,326,778 54,186 1,247,294 53,756 1,250,561 52,442 58,787 (6,345) ‐12.1%
Neighborhoods, Resources, & Events 331,222 21,438 610,545 36,383 692,698 42,529 41,419 1,110 2.6%
Library 2,289,692 173,794 2,030,000 2,619 230,000 2,500 2,500 ‐ 0.0%
Museum 191,090 15,310 210,620 17,146 213,533 17,252 17,791 (539) ‐3.1%
Public Works Admin 1 514,858 42,532 452,538 37,289 465,889 38,441 39,864 (1,423) ‐3.7%
Street Maintenance 3,412,892 240,463 3,534,025 279,841 3,728,945 279,287 285,940 (6,653) ‐2.4%
Transportation 5,215,309 400,577 4,509,066 308,560 4,711,542 343,583 288,400 55,183 16.1%
Debt Service 4,707,100 ‐ 4,822,566 4,600 6,531,373 ‐ ‐ ‐ 0.0%
Non‐Departmental and Other 4,834,296 348,715 4,930,383 219,534 2,944,248 313,245 313,245 ‐ 0.0%
Total Operating Expenditures 97,302,601 7,161,528 100,825,999 6,990,159 100,468,787 7,159,501 6,667,414 492,087 6.9%
Total Ending Fund Balance 11,407,119$ 9,675,313$ 11,057,551$ 9,795,967$ 10,461,605$ 7,280,989$ 9,559,274$ 2,278,285 31.3%
1Facilities was included in Community Services Admin and Technical Services was included in Public Works Admin in 2010
Favorable (Unfavorable)
2010 2011 2012 Variance
Annual Actual YTD Actual Annual Budget YTD Budget YTD ActualSummary of Sources and Uses Annual Actual YTD Actual
Monthly Financial Report January 2012
Page 1 of 36
Monthly Financial Report January 2012
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through January 31, 2012. 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 72% of
all resources supporting general governmental activities. The following section provides detail information on property,
sales, utility, and other taxes.
Property Tax
January’s collection is $149k,
making the total year‐to‐date
collection $149k or 0.5% of the
total budget. In comparison to
the previous year, the City
collected $356k or 71% less.
Compared to the budget, the City
is below projections by $106k or
42%. 2012’s monthly budgets are
based on 2009 through 2011
collections. The variance from the
prior year is due to a portion
($129k) of 2010’s collection being
receipted in January 2011. Taking
this into consideration, the City is
$227k or 60% behind 2011.
Sales Tax
January 2012 sales tax receipts totalled
$1.3 million. Compared to the same
month last year, it is $12k or 1% less.
Compared to the projected current
month’s budget, it is $61k or 4%
below.
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 505,501$ 255,343$ 149,112$ (356,390)$ ‐71% (106,231)$ ‐42%
Feb 336,193 316,911
Mar 745,285 675,495
Apr 7,618,492 7,776,464
May 7,849,481 8,109,059
Jun 54,963 98,578
Jul 112,076 106,083
Aug 25,954 84,126
Sep 467,946 421,108
Oct 7,014,860 6,907,167
Nov 7,348,025 7,974,601
Dec 279,117 171,812
YTD Total 505,501$ 255,343$ 149,112$ (356,390)$ ‐71% (106,231)$ ‐42%
Annual Total 32,357,894$ 32,896,746$
Property Tax Revenues
Year to Date through January
2012 vs . 2011 2012 vs. Budget
Month
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 1,339,658$ 1,388,527$ 1,327,548$ (12,111)$ ‐1% (60,980)$ ‐4%
Feb 1,982,269 1,787,327 ‐
Mar 1,299,237 1,372,298 ‐
Apr 1,254,867 1,391,509 ‐
May 1,590,780 1,578,875 ‐
Jun 1,368,213 1,422,596 ‐
Jul 1,437,859 1,411,637 ‐
Aug 1,534,218 1,522,536 ‐
Sep 1,472,399 1,468,712 ‐
Oct 1,517,444 1,529,207 ‐
Nov 1,508,954 1,522,978 ‐
Dec 1,423,832 1,467,796 ‐
YTD Total 1,339,658$ 1,388,527$ 1,327,548$ (12,111)$ ‐1% (60,980)$ ‐4%
Annual Total 17,729,731$ 17,864,000$
2012 vs. Budget2012 vs. 2011
Month
Year to Date through January
Local Retail Sales Tax Revenues
Page 2 of 36
Monthly Financial Report January 2012
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 2011 2012 Bgt YTD Act Change 2012/2011 2012 Act vs Bgt
New Construction 125,321$ 108,548$ 142,780$ 17,459$ 14%$ 34,233 32%
Auto Sales 251,874 260,957 282,084 30,211 12% 21,128 8%
General Retail 485,811 522,470 532,447 46,636 10% 9,977 2%
Manufacturing 61,291 56,728 (59,726) (121,017) ‐197% (116,454)‐205%
Wholesale 112,293 90,836 81,319 (30,973) ‐28% (9,517)‐10%
Service 273,275 320,174 319,720 46,444 17% (455) 0%
Other 29,794 28,815 28,923 (871) ‐3% 108 0%
Total 1,339,658$ 1,388,527$ 1,327,548$ (12,111)$ ‐1%(60,980)$ ‐4%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
The Manufacturing sector reported negative total due to a field audit adjustment for prior periods (2007‐2009) which
reduced our receipts by $131k. If we exclude this adjustment, this sector is 16% above 2011 and 26% above our monthly
budget.
Utility tax
January utility tax revenues are $1.5
million, which is $106k or 8% higher
than the same month last year and is
also ahead of the budget by $46k or
3%.
The table below breaks out Utility Tax by source.
Utility Tax by Type 2011 2012 Bgt YTD Act Change 2012/2011 2012 Act vs Bgt
Electrical 476,061$ 486,801$ 493,043$ 16,983$ 4%$ 6,242 1%
Natural Gas 241,219 255,096 261,267 20,049 8% 6,172 2%
Cell 179,272 201,542 221,778 42,506 24% 20,236 10%
Phone 73,415 75,934 75,154 1,739 2% (780)‐1%
Cable 118,469 122,095 118,851 382 0% (3,244)‐3%
Transfer Station 20,780 17,377 17,157 (3,623) ‐17% (220)‐1%
City Utilities 253,808 264,603 281,927 28,119 11% 17,324 7%
YTD Total 1,363,023$ 1,423,448$ 1,469,178$ 106,155$ 8%45,730$ 3%
Annual Total 15,484,862$ 16,155,203$
YTD as % of 9%9%
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 1,363,023$ 1,423,448$ 1,469,178$ 106,155$ 8% 45,730$ 3%
Feb 1,448,275 1,512,984
Mar 1,480,840 1,546,398
Apr 1,370,718 1,433,422
May 1,291,530 1,350,150
Jun 1,203,475 1,256,117
Jul 1,188,526 1,240,117
Aug 1,165,863 1,217,180
Sep 1,176,526 1,225,853
Oct 1,202,559 1,253,072
Nov 1,232,640 1,281,314
Dec 1,360,887 1,415,147
YTD Total 1,363,023$ 1,423,448$ 1,469,178$ 106,155$ 8% 45,730$ 3%
Annual Total 15,484,862$ 16,155,203$
2012 vs. Budget2012 vs. 2011
Year to Date through January
Utility Tax Revenues
Month
Page 3 of 36
Monthly Financial Report January 2012
Other Taxes
Real Estate Excise Tax
The City collected $78k in Real Estate
Excise Tax revenues (REET) in January.
This is $80k or 51% below the current
month’s budget and $84k or 52% behind
the same month last year. The short fall
(from the prior year) is due to lower real
estate activity for 2012.
Gambling Tax
January’s Gambling Tax
collections total $176k. Year‐to‐
date total of $176k is $58k or 49%
above the year before and is also
$63k or 55% above budget. The
increase in January’s collection
from the previous January is due
to payment plans with two
establishments to remit their
monthly portions (starting in
October) of 2011 by year‐end,
which was receipted in the
beginning of 2012. Approximately
$30k collected in January was for
the prior year.
Pull tabs overall had a 4%
increase, bingo reduced by 36%, and card‐rooms are seeing 15% higher in activities when compared to the prior year.
Franchise Fees
Franchise Fees are due quarterly
and the year‐to‐date revenue
collections are $300k or 23% of
the budget. This is $27k or 8%
below the projected year‐to‐date
budget and is also $5k or 2%
lower than 2011.
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 161,911$ 157,987$ 77,631$ (84,280)$ ‐52% (80,356)$ ‐51%
Feb 99,677 97,304
Mar 141,700 138,289
Apr 110,987 108,315
May 157,519 153,728
Jun 228,506 223,006
Jul 117,567 114,737
Aug 159,524 155,683
Sep 205,753 200,800
Oct 189,691 185,125
Nov 335,893 327,808
Dec 165,331 162,219
YTD Total 161,911$ 157,987$ 77,631$ (84,280)$ ‐52% (80,356)$ ‐51%
Annual Total 2,074,059$ 2,025,000$
Month
2012 vs. Budget2012 vs. 2011
Real Estate Ex cise Tax Revenues
Year to Date through January
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 118,304$ 113,250$ 175,959$ 57,655$ 49% 62,710$ 55%
Feb 135,926 130,118 ‐
Mar 135,067 129,296 ‐
Apr 162,459 155,518 ‐
May 159,013 152,219 ‐
Jun 151,240 144,778 ‐
Jul 136,775 130,931 ‐
Aug 144,161 138,001 ‐
Sep 125,618 120,251 ‐
Oct 92,937 88,966 ‐
Nov 139,018 133,078 ‐
Dec 170,897 163,595 ‐
YTD Total 118,304$ 113,250$ 175,959$ 57,655$ 49% 62,710$ 55%
Annual Total 1,671,414$ 1,600,000$
2012 vs. 2011 2012 vs. Budget
Gambling Tax Revenue
Month
Year to Date through January
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 305,646$ 327,571$ 300,392$ (5,254)$ ‐2% (27,179)$ ‐8%
Apr 294,560 315,690 ‐
Jul 294,438 315,560 ‐
Oct 292,692 313,688 ‐
Dec 47,111 50,491 ‐
YTD Total 305,646$ 327,571$ 300,392$ (5,254)$ ‐2% (27,179)$ ‐8%
Annual Total 1,234,448$ 1,323,000$
Franchise Fees Revenue
Year to Date through January
Month
2012 vs. 2011 2012 vs. Budget
Page 4 of 36
Monthly Financial Report January 2012
Admission Tax
Admission Tax returns are due
quarterly in January, April, July,
and October each year. January
2012 collections represent
activities conducted during the 4th
quarter of 2011.
The report shows an increase of
$3k or 4% from the year before
but is $7k or 8% less than
anticipated.
Licenses and Permits
Building Permits and Development Service Fees
Building Permits and Development
Service Fee revenues totalled $161k in
January. The year‐to‐date development
fees revenue of $161k is $28k or 21%
more than 2011 and is also $48k or 43%
higher than budget. The higher than
expected fees is due to collecting more
in electrical permits and zoning/plan
check fees.
Business Licenses
Business Licenses totalled $89k for January,
which is $5k or 5% above the same month last
year but is $635 or 1% below the current
month’s budget.
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 70,405$ 79,953$ 73,420$ 3,015$ 4% (6,534)$ ‐8%
Feb 477 542 ‐
Apr 63,582 72,205 ‐
May 407 462 ‐
Jul 86,024 97,691 ‐
Aug 1,194 1,356 ‐
Oct 86,112 97,791 ‐
YTD Total 70,405$ 79,953$ 73,420$ 3,015$ 4% (6,534)$ ‐8%
Annual Total 308,200$ 350,000$
Month
2012 vs. 2011 2012 vs. Budget
Admission Tax Revenue
Year to Date through January
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 84,109$ 89,311$ 88,676$ 4,568$ 5% (635)$ ‐1%
Feb 23,153 24,585 ‐
Mar 3,811 4,047 ‐
Apr 83,930 89,121 ‐
May 20,142 21,387 ‐
Jun 3,964 4,209 ‐
Jul 83,962 89,155 ‐
Aug 18,393 19,531 ‐
Sep 4,135 4,391 ‐
Oct 95,874 101,804 ‐
Nov 18,291 19,423 ‐
Dec 2,686 2,852 ‐
YTD Total 84,109$ 89,311$ 88,676$ 4,568$ 5% (635)$ ‐1%
Annual Total 442,451$ 469,817$
Business Licenses
Month
2012 vs. 2011
Year to Date through January
2012 vs. Budget
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 132,621$ 112,664$ 160,750$ 28,129$ 21% 48,086$ 43%
Feb 141,672 125,262
Mar 265,782 238,974
Apr 190,534 167,552
May 239,018 215,841
Jun 215,975 195,717
Jul 211,760 187,937
Aug 393,797 351,616
Sep 321,961 289,918
Oct 213,930 189,380
Nov 229,322 196,766
Dec 216,409 194,437
YTD Total 132,621$ 112,664$ 160,750$ 28,129$ 21% 48,086$ 43%
Annual Total 2,772,779$ 2,466,063$
Building Permits and Development Service Fees
Year to Date through January
2012 vs. Budget2012 vs. 2011
Month
Page 5 of 36
Monthly Financial Report January 2012
Intergovernmental
These revenue sources
include federal (direct
and indirect) grants,
state grants, state
shared revenues, local
grants, entitlements,
and intergovernmental.
State shared revenues
and Fire Districts’ 25
and 40 contracts
compose 94% of the total revenues in this category. The year‐to‐date total Intergovernmental revenue is $463k or 4% of
the budget.
State Shared Revenues
State Shared Revenue
collections totalled $423k since
the start of 2012. Compared to
the projected budget, State
Shared Revenues are above by
$62k or 17%. Compared to the
prior year, the City is collecting
$13k or 3% more.
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 80% of the total revenue in this category. The year‐to‐date total charges for services are $374k or 6% of the
budget. This is 10% above budget projections. The following sections provide detail information for Public Safety,
Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totalled $15k 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 $1k or 9% less
than anticipated revenue. Compared to the
prior year, the City is collecting $4k or 19% less.
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 18,824$ 16,715$ 15,229$ (3,595)$ ‐19% (1,486)$ ‐9%
Feb 40,902 36,318 ‐
Mar 30,346 26,945 ‐
Apr 52,434 46,558 ‐
May 35,609 31,619 ‐
Jun 46,295 41,107 ‐
Jul 70,094 62,239 ‐
Aug 35,891 31,868 ‐
Sep 30,743 27,298 ‐
Oct 34,756 30,861 ‐
Nov 42,944 38,131 ‐
Dec 46,148 40,976 ‐
YTD Total 18,824$ 16,715$ 15,229$ (3,595)$ ‐19% (1,486)$ ‐9%
Annual Total 484,985$ 430,635$
Month
2012 vs . 2011
Year to Date through January
Public Safety Services
2012 vs. Budget
Intergovernmental 2011 2012 Bgt YTD Act Change 2012/2011 2012 Act vs Bgt
Fire District #25 ‐$ ‐$ ‐$ ‐$ N/A $ ‐ N/A
Fire District #40 1,173 11,673 11,673 10,500 895%‐ 0%
State Shared Revenue 409,905 361,345 423,091 13,186 3% 61,745 17%
Federal Grants 35,519 2,007 2,007 (33,512) ‐94%‐ 0%
State Grants 27,738 ‐ ‐ (27,738) 0%‐ N/A
Other Grants/Intgovt 28,243 26,094 26,094 (2,150) ‐8%‐ 0%
ARRA Grants 115,360 ‐ ‐ (115,360) 0%‐ N/A
Total Rev YTD 617,938$ 401,119$ 462,865$ (155,073)$ ‐25%61,745$ 15%
Total Rev Annual 12,657,748$ 12,257,101$
YTD %5%3%4%
Note: Includes CJ Sales Tax.
2011 2012 2012
Actual Budget Actual $ % $ %
Crim Just Sales Tax 132,724$ 136,932$ 145,992$ 13,268$ 10% 9,059$ 7%
Judicial Contribution ‐ ‐ ‐ ‐ N/A ‐ N/A
Crim Just ‐ High Crime 47,179 ‐ 46,747 (432) ‐1% 46,747 100%
Crim Just ‐ Pop 4,821 ‐ 5,086 265 5% 5,086 100%
Crim Just ‐ Spec Prog 18,203 16,481 19,194 991 5% 2,713 16%
State DUI 3,924 3,125 4,438 514 13% 1,312 42%
Liquor Profits ‐ ‐ ‐ ‐ N/A ‐ N/A
Liquor Excise Tax 104,651 106,927 109,021 4,369 4% 2,094 2%
Fuel Tax 98,402 97,879 92,614 (5,789) ‐6% (5,266) ‐5%
YTD Total 409,905$ 361,345$ 423,091$ 13,186$ 3% 61,745$ 17%
Annual Total 4,495,551$ 4,437,913$
2012 vs. Budget
State Shared Revenues
2012 vs. 2011
Revenue
Year to Date through January
Page 6 of 36
Monthly Financial Report January 2012
Recreation
Recreation revenues totalled $62k for the
current month. Compared to the
projected monthly budget, the City
collected $7k or 10% less. Compared to
the same month the prior year, the City
collected $138 more.
Interfund Services
The year‐to‐date collections for Interfund
Services revenues are $237k. Compared
to the projected budget, the revenues are
above by $25k or 12%. Compared to the
prior year, the revenues are over by $47k
or 24%. 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 $183k. This is $18k or 11% higher than
a year ago and also $14k or 8% above the
budget.
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 190,881$ 212,247$ 237,384$ 46,503$ 24% 25,137$ 12%
Feb 282,743 314,391 ‐
Mar 251,144 279,256 ‐
Apr 231,156 257,030 ‐
May 237,043 263,576 ‐
Jun 234,878 261,169 ‐
Jul 330,174 367,132 ‐
Aug 229,627 255,330 ‐
Sep 237,006 263,535 ‐
Oct 270,340 300,600 ‐
Nov 266,859 296,730 ‐
Dec 308,654 343,203 ‐
YTD Total 190,881$ 212,247$ 237,384$ 46,503$ 24% 25,137$ 12%
Annual Total 3,070,506$ 3,414,200$
Interfund Services
Ye ar to Date through January
2012 vs. 2011 2012 vs. Budget
Month
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 165,721$ 169,834$ 183,478$ 17,757$ 11% 13,644$ 8%
Feb 261,655 262,221
Mar 313,067 314,171
Apr 289,767 288,252
May 255,949 255,826
Jun 262,444 261,662
Jul 247,468 249,471
Aug 184,473 189,735
Sep 181,000 185,846
Oct 300,431 385,882
Nov 297,580 299,240
Dec 352,911 352,016
YTD Total 165,721$ 169,834$ 183,478$ 17,757$ 11% 13,644$ 8%
Annual Total 3,112,464$ 3,214,156$
2012 vs. Budget2012 vs. 2011
Year to Date through January
Fines and Penalties by Month
Month
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 61,933$ 68,872$ 62,072$ 138$ 0% (6,800)$ ‐10%
Feb 82,497 91,739 ‐
Mar 99,537 110,688 ‐
Apr 153,717 170,938 ‐
May 134,113 149,138 ‐
Jun 144,083 160,224 ‐
Jul 211,388 235,070 ‐
Aug 254,060 282,523 ‐
Sep 142,253 158,189 ‐
Oct 83,540 92,899 ‐
Nov 77,528 86,214 ‐
Dec 48,890 54,368 ‐
YTD Total 61,933$ 68,872$ 62,072$ 138$ 0% (6,800)$ ‐10%
Annual Total 1,493,540$ 1,660,863$
Recreation
Year to Date through January
2012 vs. Budget2012 vs. 2011
Month
Page 7 of 36
Monthly Financial Report January 2012
Year to Date through January
2011 2012 2012
Actual Budget Actual $ % $ %
Civil Penalties ‐$ ‐$ ‐$ ‐$ N/A ‐$ N/A
Civil Infraction Penalties ‐ ‐ ‐ ‐ N/A ‐ N/A
Civil Parking Infraction Penalties ‐ ‐ ‐ ‐ N/A ‐ N/A
Photo Enforcement Program 165,696 169,793 183,453 17,757 11% 13,659 8%
Criminal Traffic Misdemeanor Fines ‐ ‐ ‐ ‐ N/A ‐ N/A
Criminal Non‐Traffic Fines ‐ ‐ ‐ ‐ N/A ‐ N/A
Criminal Costs ‐ ‐ ‐ ‐ N/A ‐ N/A
Seizure Funds ‐ Federal/State/Local ‐ ‐ ‐ ‐ N/A ‐ N/A
Non‐Court Fines, Forfeitures and Penalties 25 41 25 ‐ 0% (16) ‐39%
YTD Total 165,721$ 169,834$ 183,478$ 17,757$ 11% 13,644$ 8%
Annual Total 3,112,464$ 3,214,156$
Revenue
2012 vs. Budget
Fines and Penalties by Type
2012 vs. 2011
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 $183k. 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 82% of the total
revenue in this category. The year‐to‐date
total miscellaneous is $206k. Compared to
the projected year‐to‐date budget, the
revenues are over by $77k or 60%.
Compared to last year, the revenues are
over by $63k or 44%. The table on the next
page breaks out Miscellaneous revenues by
type:
2011 2012 2012
Actual Budget Actual $ % $ %
Jan 143,105$ 129,016$ 206,151$ 63,046$ 44% 77,135$ 60%
Feb 70,237 53,269
Mar 99,131 81,783
Apr 74,048 61,550
May 97,083 83,787
Jun 145,018 115,471
Jul 173,878 130,160
Aug 133,570 106,004
Sep 97,973 82,788
Oct 75,425 62,931
Nov 77,427 64,812
Dec 163,299 151,128
YTD Total 143,105$ 129,016$ 206,151$ 63,046$ 44% 77,135$ 60%
Annual Total 1,350,195$ 1,122,699$
Year to Date through January
Month
2012 vs. Budget2012 vs. 2011
Miscellaneous Revenues by Month
Favorable
Budget Actual Budget Actual (Unfavorable)
1
Jan 169,793$ 183,453$ 76,201$ 68,003$ 115,449$
Feb 167,986 ‐ 76,693 ‐ ‐
Mar 203,098 ‐ 76,201 ‐ ‐
Apr 181,989 ‐ 53,048 ‐ ‐
May 160,960 ‐ 71,882 ‐ ‐
Jun 180,018 ‐ 71,871 ‐ ‐
Jul 155,574 ‐ 72,275 ‐ ‐
Aug 98,678 ‐ 56,688 ‐ ‐
Sep 83,853 ‐ 71,527 ‐ ‐
Oct 145,798 ‐ 71,420 ‐ ‐
Nov 211,430 ‐ 71,884 ‐ ‐
Dec 185,536 ‐ 72,273 ‐ ‐
YTD Total 169,793$ 183,453$ 76,201$ 68,003$ 115,449$
Annual Total 1,944,713$ 841,964$
1Actuals of Revenues and Expenses
Revenues Expenses
Photo Enforcement Program
Year to Date through January
Month
Page 8 of 36
Monthly Financial Report January 2012
2011 2012 2012
Actual Budget Actual $ % $ %
Interests and Other Earnings 12,157$ 8,067$ 22,742$ 10,585$ 87% 14,674$ 182%
Rents, Leases, and Concessions 122,667 115,524 146,205 23,538 19% 30,681 27%
Contributions/Donations from Private Sources 6,055 3,234 27,820 21,765 359% 24,586 760%
Other 2,227 2,190 9,384 7,158 321% 7,194 328%
YTD Total 143,105$ 129,016$ 206,151$ 63,046$ 44% 77,135$ 60%
Annual Total 1,350,195$ 1,122,699$
2012 vs. Budget
Miscellaneous Revenues by Type
Year to Date through January
Revenue
2012 vs. 2011
Interest and other earnings are higher than the prior year and budget due to higher than expected utility late payment
penalties.
Rents, leases and concessions are higher than the prior year and budget due to higher than expected food concession
payments at Coulon Park.
Contributions and donations from private sources are higher than the prior year and budget due to the timing of donations
received.
EXPENSES
Overall the City has expended 7% of its budgeted general governmental expenditures at the end of January. This is $492k
or 6.9% below year‐to‐date budgeted expenditures. While some of these were savings, approximately $270k is for
January/February communications services provided by Valley Communications that was recorded and paid in February.
Taking this into consideration, the City is actually favorable by $222k or 3.1% in expenditure savings. See below for
summary of unfavorable items for general governmental departments.
Administrative Services Department (Finance and City Clerk) is unfavorable by $10k or 5%. This is due to the spending
patterns of January 2012 compared to 2010 and 2011. The year‐to‐date budget should even out in February and/or March.
Page 9 of 36
Monthly Financial Report January 2012
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 ‐ ‐ ‐ ‐ 2,275 1,700 ‐
Grants / intergovernmental ‐ ‐ ‐ ‐ ‐ 131,317 ‐
Charges for services 1,070 44,640 1,249,136 941,391 668,274 642,683 1,108,312
Interdepartmental services ‐ ‐ ‐ 16,339 12,715 32,795 ‐
Fines and penalties ‐ ‐ ‐ ‐ ‐ ‐ ‐
Rents, leases, and misc fees 180,558 12,301 12,000 9,019 ‐ ‐ ‐
Interest and other misc 674 290 3,574 10,582 2,832 15,362 343
TOTAL REVENUES 182,302 57,231 1,264,710 977,331 686,096 823,857 1,108,655
EXPENSES:
Utility billing ‐ ‐ 9,420 7,635 6,879 10,419 ‐
Utility systems ‐ ‐ 575,014 184,749 197,292 175,334 ‐
Utility maintenance ‐ ‐ 18,592 310,951 96,150 135,894 1,079,770
Transportation 95,212 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 106,601 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 95,212 106,601 603,026 503,335 300,321 321,647 1,079,770
AMOUNT AVAILABLE FOR DEBT SERVICE 87,090 (49,370) 661,684 473,996 385,775 502,210 28,885
DEBT SERVICE:
Principal ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest and other debt service costs ‐ ‐ ‐ ‐ ‐ ‐ ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ ‐ ‐ ‐ ‐
CAPITAL PROJECTS 36,351 8,750 ‐ 39,742 92,077 331,066 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 50,739 (58,120) 661,684 434,254 293,698 171,144 28,885
BEGINNING FUND BALANCE, January 1, 2012 2,084,710 615,488 1,734,734 7,642,506 1,209,356 4,210,599 1,077,805
ENDING FUND BALANCE, January 31, 2012 2,135,449 557,368 2,396,418 8,076,760 1,503,054 4,381,743 1,106,690
Page 10 of 36
Monthly Financial Report January 2012
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 ‐ 4,822 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ ‐ 1,915 ‐ ‐ ‐ ‐
Charges for services
Equipment rental m&o 190,383 176,318 ‐ ‐ ‐ ‐ ‐
Telecommunications ‐ 15,510 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 8,872 ‐ 33,074 ‐ ‐ ‐
Communications ‐ ‐ ‐ 49,252 ‐ ‐ ‐
Facilities ‐ ‐ 347,770 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 12,507 ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ 26,316 ‐ ‐ ‐ ‐ ‐
Geographical information systems ‐ 16,410 ‐ ‐ ‐ ‐ ‐
Interest and other misc 1,507 647 138 48 1,866 2,256 1,738
Internal service fund misc:
Vehicle / equipment capital recovery 79,974 78,540 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 130,317 ‐ ‐
Worker's compensation / unemployment ‐ ‐ ‐ ‐ 112,653 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 925,510 183,936
Other misc 153 108 2,362 ‐ ‐ 55,765 ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets ‐ ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 8,141 ‐ ‐
TOTAL REVENUES 272,017 340,050 352,185 82,374 252,977 983,531 185,674
EXPENSES:
Communications 37,145
Equipment rental 177,831
Facilities 212,596
Healthcare 842,037
Information technology 302,870
Print and mail 31,115
Retiree healthcare 65,469
Risk management
Risk management 698,226
Unemployment 42,976
Worker's compensation 103,570
TOTAL EXPENSES 177,831 302,870 212,596 68,260 844,772 842,037 65,469
AMOUNT AVAILABLE FOR CAPITAL 94,186 37,180 139,589 14,114 (591,795) 141,494 120,205
CAPITAL PROJECTS 64,001 144,624 1,754 ‐ ‐ ‐ ‐
TRANSFERS IN ‐ ‐ ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 30,185 (107,444) 137,835 14,114 (591,795) 141,494 120,205
BEGINNING FUND BALANCE, January 1, 2012 4,774,376 2,181,743 300,238 141,120 6,620,437 7,133,996 5,479,399
ENDING FUND BALANCE, January 31, 2012 4,804,561 2,074,299 438,073 155,234 6,028,642 7,275,490 5,599,604
Page 11 of 36
Monthly Financial Report January 2012
FUND BALANCE
Page 13 shows the ending fund balance as of January 2012. 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 January, the City has $9.6 million reported in the combined general governmental fund balance of the current
year’s operating budget, which is approximately 10% of budgeted operating expenditures. This is a decrease of $1.5 million
from the year’s beginning balance. January’s ending fund balance is over the anticipated General Governmental Fund
Balance of $7.3 million by $2.3 million or 31.3%. Although the ending fund balance is above projections, it is consistent
with the prior years’ trends since the City will receipt the first half of 2012 property taxes in April/May and second half in
October/November.
CONTACT INFORMATION
This report is prepared by the Finance Division of the Administrative Services 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 JDThomas@Rentonwa.gov.
Page 12 of 36
Monthly Financial Report January 2012
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through January 31, 2012
Funds
Balance
01/01/2012
Budgeted
Revenue
Revenue
01/31/12
Total Funds
Available
Budgeted
Expenditure
Expenditure
01/31/12
Ending
Balance
GENERAL GOVERNMENT FUNDS:11,057,551 101,591,685 5,169,136 16,226,687 100,468,787 6,667,414 9,559,274
000 General 6,934,747 74,013,147 3,906,135 10,840,882 73,638,578 5,352,142 5,488,741
001 Community Services 1,413,050 11,241,005 719,606 2,132,656 11,007,906 695,623 1,437,034
003 Street 1,264,341 8,953,479 476,498 1,740,839 8,440,487 574,340 1,166,500
004 Community Dev Block Grant 8,339 305,961 ‐ 8,339 303,281 20,216 (11,877)
005 Museum 52,620 216,220 11 52,631 213,533 17,791 34,840
006 Library 48,603 230,000 14 48,617 230,000 2,500 46,117
009 Farmers Market 87,437 75,500 2,026 89,463 78,629 4,803 84,660
010 Fire Memorial 1,953 ‐ ‐ 1,953 ‐ ‐ 1,953
011 Fire Health & Wellness 36,858 25,000 2,157 39,015 25,000 ‐ 39,015
031 Park Memorial 177,758 ‐ 55 177,813 ‐ ‐ 177,813
201 Ltd GO Bonds Gen Govt Debt 591,257 1,982,075 32,778 624,035 1,982,075 ‐ 624,035
215 Gen Govt Misc Debt Service 440,588 4,549,298 29,855 470,443 4,549,298 ‐ 470,443
SPECIAL REVENUE FUNDS:
102 Arterial Street 158,974 630,000 43,645 202,619 630,000 ‐ 202,619
108 Leased City Properties 488,500 971,049 8,395 496,895 876,232 15,301 481,594
110 Hotel Motel 243,556 265,000 14,764 258,320 265,000 22,774 235,546
118 Reserve for Paths & Trails 3,314 ‐ 1 3,315 ‐ ‐ 3,315
125 1% For Art 121,686 15,000 38 121,724 50,000 ‐ 121,724
127 Cable Communication 185,968 85,000 13,799 199,767 85,674 ‐ 199,767
135 Springbrook Wetlands Bank 663,556 ‐ 206 663,762 ‐ ‐ 663,762
DEBT SERVICE FUNDS:
219 1989 Unlimited GO Bonds ‐ ‐ ‐ ‐ ‐ ‐ ‐
CAPITAL PROJECT FUNDS (CIP):
303 Community Dev Mitigation 1,475,050 60,000 458 1,475,508 ‐ ‐ 1,475,508
304 Fire Mitigation 1,492,674 100,000 462 1,493,136 536,926 ‐ 1,493,136
305 Transportation Mitigation 657,187 150,000 203 657,390 400,000 ‐ 657,390
316 Municipal Facilities CIP 3,745,546 760,000 27,786 3,773,332 1,170,000 99,364 3,673,968
317 Transportation CIP 3,422,219 21,418,181 843,471 4,265,690 21,603,852 288,133 3,977,557
318 So Lake WA Infrastructure Proj 52,792 ‐ 16 52,808 ‐ ‐ 52,808
326 Housing Opportunity 130,546 ‐ 439 130,985 ‐ ‐ 130,985
336 New Library Development 19,196,447 ‐ 5,589 19,202,036 8,000,000 138 19,201,898
ENTERPRISE FUNDS:
402 Airport 494,718 1,862,168 181,801 676,519 1,288,846 95,212 581,307
403 Solid Waste Utility 1,734,734 15,004,692 1,264,710 2,999,444 14,972,362 603,026 2,396,418
404 Golf Course 379,997 2,483,545 57,158 437,155 2,542,204 114,938 322,217
422 Airport Capital 1,589,992 3,275,003 501 1,590,493 4,766,203 36,351 1,554,142
424 Golf Course Capital 235,491 100,000 8,410 243,901 100,000 8,750 235,151
INTERNAL SERVICE FUNDS:
501 Equipment Repair/Replacement 4,774,376 3,079,893 272,017 5,046,393 3,145,756 241,832 4,804,561
502 Insurance 6,620,437 3,187,593 252,977 6,873,414 2,930,079 844,772 6,028,642
503 Information Services 2,181,743 4,118,173 340,050 2,521,793 4,409,226 447,494 2,074,299
504 Facilities 300,238 4,324,987 352,185 652,423 4,379,434 214,350 438,073
505 Communications 141,120 974,307 82,374 223,494 991,015 68,260 155,234
512 Insurance, Healthcare 7,133,996 12,014,224 983,532 8,117,528 11,996,739 842,037 7,275,491
522 Insurance, Leoff1 Retirees HC 5,479,399 2,235,684 185,674 5,665,073 2,262,573 65,469 5,599,604
FIDUCIARY FUNDS:
611 Firemen's Pension 4,377,696 300,000 573 4,378,269 550,475 26,346 4,351,923
Funds
Balance
01/01/2012
Budgeted
Revenue
Revenue
01/31/12
Total Funds
Available
Budgeted
Expenditure
Expenditure
01/31/12
Ending
Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 14,140,266 47,683,644 3,595,938 17,736,204 46,070,637 2,667,959 15,068,245
405 Water Utility 3,993,415 11,106,460 976,190 4,969,605 10,662,036 503,335 4,466,270
406 Waste Water Utility 685,178 5,888,574 683,944 1,369,122 5,130,805 300,322 1,068,800
407 Surface Water Utility 1,625,915 5,469,223 809,126 2,435,041 4,968,409 321,647 2,113,394
416 King County Metro 1,077,805 13,209,387 1,108,656 2,186,461 13,209,387 1,079,770 1,106,691
425 Water Utility Construction 3,633,246 5,200,000 1,135 3,634,381 5,350,000 39,742 3,594,639
426 Waste Water Construction 524,178 3,310,000 2,152 526,330 3,250,000 92,077 434,253
427 Surface Water Construction 2,584,684 3,500,000 14,730 2,599,414 3,500,000 331,066 2,268,348
461 Waterworks Bond Reserve ‐ ‐ ‐ ‐ ‐ ‐ ‐
471 Waterworks Rate Stabilization 15,845 ‐ 5 15,850 ‐ ‐ 15,850
481 Future W/S Bond Proceeds ‐ ‐ ‐ ‐ ‐ ‐ ‐
Note: Waterworks Utility Funds are managed as a system and are designated by the dotted lines.
Page 13 of 36
City of Renton
General Government Financial Position
2012 Budget Year
General Government Summary
Revenues Expenditures
$ Difference
over (under)
w/beginning
balance
11,057,551
January 5,169,136 6,667,414 (1,498,278) 9,559,274
February
March
April
May
June
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 14 of 36
City of Renton
Monthly Revenue Analysis ‐ 2012 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 5,101,783 5,169,136 1.32%
Feb 10,615,856
Mar 16,259,977
Apr 29,838,297
May 44,770,150
Jun 49,580,408
Jul 55,653,248
Aug 60,763,893
Sep 66,788,625
Oct 80,202,064
Nov 95,003,784
Dec 101,591,685
Percent of budget 5.09%
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 255,343 149,112 ‐41.60%
Feb 572,253
Mar 1,247,748
Apr 9,024,212
May 17,133,271
Jun 17,231,849
Jul 17,337,932
Aug 17,422,058
Sep 17,843,166
Oct 24,750,333
Nov 32,724,934
Dec 32,896,746
Percent of budget 0.45%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
Budget
Actual
Last Year
Page 15 of 36
City of Renton
Monthly Revenue Analysis ‐ 2012 Budget Year
Sales Tax Budget
YTD
Actual
Annual %
over (under)
Jan 1,552,198 1,493,022 ‐3.81%
Feb 3,549,657
Mar 5,080,681
Apr 6,625,498
May 8,384,823
Jun 9,969,656
Jul 11,554,021
Aug 13,258,722
Sep 14,907,971
Oct 16,615,185
Nov 18,322,808
Dec 19,965,647
Percent of budget 7.48%
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,423,448 1,469,178 3.21%
Feb 2,936,432
Mar 4,482,830
Apr 5,916,252
May 7,266,402
Jun 8,522,519
Jul 9,762,636
Aug 10,979,816
Sep 12,205,670
Oct 13,458,742
Nov 14,740,056
Dec 16,155,203
Percent of budget 9.09%
Note: Includes Natural Gas Use Tax.
$0
$2
$4
$6
$8
$10
$12
$14
$16
Budget
Actual
Last Year
Page 16 of 36
City of Renton
Monthly Revenue Analysis ‐ 2012 Budget Year
Licenses &
Permits Budget
YTD
Actual
Annual %
over (under)
Jan 179,209 218,837 22.11%
Feb 303,772
Mar 495,614
Apr 721,466
May 883,222
Jun 1,025,529
Jul 1,257,216
Aug 1,551,253
Sep 1,768,424
Oct 2,019,748
Nov 2,211,675
Dec 2,403,331
Percent of budget 9.11%
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 401,119 462,865 15.39%
Feb 912,132
Mar 1,467,797
Apr 2,453,834
May 4,709,139
Jun 5,320,553
Jul 5,878,560
Aug 6,403,333
Sep 6,864,172
Oct 8,262,234
Nov 10,655,015
Dec 12,257,101
Percent of budget 3.78%
Note: Includes CJ Sales Tax.
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
$10
$11
$12
$13
$14
Millions
Budget
Actual
Last Year
Page 17 of 36
City of Renton
Monthly Revenue Analysis ‐ 2012 Budget Year
Charges for
Services Budget
YTD
Actual
Annual %
over (under)
Jan 340,863 374,426 9.85%
Feb 836,110
Mar 1,341,354
Apr 1,895,493
May 2,456,930
Jun 3,005,145
Jul 3,747,859
Aug 4,435,671
Sep 4,993,503
Oct 5,488,048
Nov 5,976,544
Dec 6,488,075
Percent of budget 5.77%
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 169,834 183,478 8.03%
Feb 432,054
Mar 746,225
Apr 1,034,478
May 1,290,304
Jun 1,551,967
Jul 1,801,437
Aug 1,991,172
Sep 2,177,018
Oct 2,562,900
Nov 2,862,140
Dec 3,214,156
Percent of budget 5.71%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Budget
Actual
Last Year
Page 18 of 36
City of Renton
Monthly Revenue Analysis ‐ 2012 Budget Year
Other Taxes Budget
YTD
Actual
Annual %
over (under)
Jan 650,754 612,068 ‐5.94%
Feb 891,088
Mar 1,133,369
Apr 1,826,182
May 2,221,338
Jun 2,412,957
Jul 3,643,161
Aug 3,945,386
Sep 4,229,695
Oct 5,134,578
Nov 5,535,483
Dec 6,050,976
Percent of budget 10.12%
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 129,016 206,151 59.79%
Feb 182,285
Mar 264,067
Apr 325,618
May 409,405
Jun 524,875
Jul 655,036
Aug 761,039
Sep 843,828
Oct 906,759
Nov 971,571
Dec 1,122,699
Percent of budget 18.36%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40 Budget
Actual
Last Year
Page 19 of 36
City of Renton
Monthly Revenue Analysis ‐ 2012 Budget Year
Other
Financing Budget
YTD
Actual
Annual %
over (under)
Jan ‐ ‐ N/A
Feb 73
Mar 291
Apr 15,265
May 15,317
Jun 15,359
Jul 15,390
Aug 15,442
Sep 955,178
Oct 1,003,537
Nov 1,003,558
Dec 1,037,752
Percent of budget 0.00%
YTD Annual % Millions
Real Estate Excise Tax
$‐
$2.00
$4.00
$6.00
$8.00
$10.00
$12.00
Millions Other Financing Sources
Budget
Actual
Last Year
REET Budget Actual over (under)
Jan 158,072 77,631 ‐50.89%
Feb 255,393
Mar 393,741
Apr 502,119
May 655,898
Jun 879,012
Jul 993,789
Aug 1,149,532
Sep 1,350,432
Oct 1,535,639
Nov 1,863,587
Dec 2,025,000
Percent of budget 3.83%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
Millions
Budget
Actual
Last Year
Page 20 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,159,501 6,667,414 ‐6.87%
Feb 16,690,091
Mar 24,852,219
Apr 32,885,245
May 41,086,528
Jun 49,407,682
Jul 58,035,836
Aug 66,615,729
Sep 75,130,713
Oct 83,223,433
Nov 91,435,213
Dec 100,468,787
Percent of budget expended 6.64%
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 23,052 21,995 ‐4.59%
Feb 47,250
Mar 71,106
Apr 94,952
May 118,463
Jun 142,332
Jul 166,209
Aug 189,913
Sep 213,507
Oct 235,771
Nov 259,647
Dec 284,087
Percent of budget expended 7.74%
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
Budget
Actual
Last Year
Page 21 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
Executive Budget
YTD
Actual
Annual %
over (under)
Jan 115,566 75,851 ‐34.37%
Feb 234,736
Mar 352,251
Apr 476,167
May 597,036
Jun 714,061
Jul 838,503
Aug 949,052
Sep 1,083,306
Oct 1,204,110
Nov 1,318,583
Dec 1,468,694
Percent of budget expended 5.16%
YTD Annual %
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
Millions Executive
Budget
Actual
Last Year
$1 00
Millions City Clerk
City Clerk Budget Actual over (under)
Jan 57,441 51,770 ‐9.87%
Feb 112,475
Mar 176,816
Apr 320,451
May 434,608
Jun 491,567
Jul 549,792
Aug 606,842
Sep 665,236
Oct 773,721
Nov 833,785
Dec 897,889
Percent of budget expended 5.77%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
Budget
Actual
Last Year
Page 22 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
Hearing
Examiner Budget
YTD
Actual
Annual %
over (under)
Jan 8,732 1,731 ‐80.18%
Feb 15,470
Mar 20,317
Apr 25,330
May 30,687
Jun 36,506
Jul 42,088
Aug 47,349
Sep 53,136
Oct 58,229
Nov 65,292
Dec 71,025
Percent of budget expended 2.44%
YTD Annual % $2 00
Millions City Attorney
$‐
$30,000
$60,000
$90,000
Hearing Examiner
Budget
Actual
Last Year
City Attorney Budget Actual over (under)
Jan 135,939 136,926 0.73%
Feb 280,202
Mar 419,912
Apr 560,129
May 698,477
Jun 838,962
Jul 978,014
Aug 1,116,943
Sep 1,255,965
Oct 1,386,265
Nov 1,523,461
Dec 1,668,686
Percent of budget expended 8.21%
$‐
$0.40
$0.80
$1.20
$1.60
$2.00 Budget
Actual
Last Year
Page 23 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
Court Services Budget
YTD
Actual
Annual %
over (under)
Jan 174,315 166,993 ‐4.20%
Feb 343,541
Mar 519,637
Apr 695,808
May 868,112
Jun 1,065,771
Jul 1,247,962
Aug 1,428,172
Sep 1,611,434
Oct 1,777,831
Nov 1,956,497
Dec 2,147,819
Percent of budget expended 7.77%
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 77,315 79,562 2.91%
Feb 159,341
Mar 239,050
Apr 318,760
May 398,469
Jun 478,179
Jul 557,987
Aug 637,894
Sep 717,523
Oct 794,989
Nov 873,950
Dec 952,912
Percent of budget expended 8.35%
$‐
$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 24 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
Development
Services Budget
YTD
Actual
Annual %
over (under)
Jan 285,738 239,412 ‐16.21%
Feb 554,503
Mar 820,791
Apr 1,084,998
May 1,367,126
Jun 1,618,928
Jul 1,883,093
Aug 2,121,834
Sep 2,402,670
Oct 2,652,859
Nov 2,910,482
Dec 3,181,944
Percent of budget expended 7.52%
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 57,949 51,733 ‐10.73%
Feb 121,700
Mar 174,340
Apr 231,323
May 296,550
Jun 357,043
Jul 420,160
Aug 475,727
Sep 547,604
Oct 604,832
Nov 669,268
Dec 735,088
Percent of budget expended 7.04%
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
$0.70
$0.80
Millions
Budget
Actual
Last Year
Page 25 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
Planning Budget
YTD
Actual
Annual %
over (under)
Jan 111,447 121,734 9.23%
Feb 242,600
Mar 344,794
Apr 461,325
May 568,088
Jun 719,930
Jul 836,707
Aug 990,965
Sep 1,160,034
Oct 1,277,610
Nov 1,377,062
Dec 1,516,719
Percent of budget expended 8.03%
YTD Annual % $2 40
Millions Finance
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
Millions
Planning
Budget
Actual
Last Year
Finance Budget Actual over (under)
Jan 136,092 152,157 11.80%
Feb 272,763
Mar 412,217
Apr 549,019
May 698,320
Jun 841,002
Jul 975,053
Aug 1,125,622
Sep 1,289,057
Oct 1,416,270
Nov 1,546,148
Dec 1,969,836
Percent of budget expended 7.72%
$‐
$0.40
$0.80
$1.20
$1.60
$2.00
$2.40 Budget
Actual
Last Year
Page 26 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
Human
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 85,534 69,265 ‐19.02%
Feb 160,543
Mar 235,703
Apr 306,383
May 377,353
Jun 458,275
Jul 539,353
Aug 617,162
Sep 695,139
Oct 771,451
Nov 853,247
Dec 946,956
Percent of budget expended 7.31%
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,206,020 1,905,016 ‐13.64%
Feb 4,887,591
Mar 7,467,467
Apr 9,802,495
May 12,224,630
Jun 14,750,537
Jul 17,291,458
Aug 19,694,067
Sep 22,140,419
Oct 24,468,872
Nov 26,911,238
Dec 29,486,965
Percent of budget expended 6.46%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
Budget
Actual
Last Year
Page 27 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
Fire &
Emergency
Services Budget
YTD
Actual
Annual %
over (under)
Jan 1,923,042 1,891,121 ‐1.66%
Feb 4,570,376
Mar 6,465,803
Apr 8,330,757
May 10,290,744
Jun 12,213,296
Jul 14,184,171
Aug 16,224,917
Sep 18,211,842
Oct 20,076,333
Nov 22,068,980
Dec 24,056,171
Percent of budget expended 7.86%
Community YTD Annual %
$‐
$3
$6
$9
$12
$15
$18
$21
$24
Millions Fire & Emergency Services
Budget
Actual
Last Year
$0 45
Millions Community Services Admin
Services Admin Budget Actual over (under)
Jan 22,705 39,072 72.09%
Feb 69,191
Mar 104,084
Apr 138,770
May 173,424
Jun 208,186
Jul 243,168
Aug 278,693
Sep 315,161
Oct 349,074
Nov 384,584
Dec 421,043
Percent of budget expended 9.28%
$‐
$0.05
$0.10
$0.15
$0.20
$0.25
$0.30
$0.35
$0.40
$0.45
Budget
Actual
Last Year
Page 28 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
Parks Budget
YTD
Actual
Annual %
over (under)
Jan 261,786 274,545 4.87%
Feb 557,743
Mar 852,218
Apr 1,167,853
May 1,493,714
Jun 1,847,897
Jul 2,216,513
Aug 2,582,645
Sep 2,964,943
Oct 3,339,297
Nov 3,699,232
Dec 4,034,496
Percent of budget expended 6.80%
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 28,998 36,047 24.31%
Feb 69,346
Mar 113,087
Apr 157,789
May 211,609
Jun 263,308
Jul 323,697
Aug 377,022
Sep 430,152
Oct 488,729
Nov 543,900
Dec 595,868
Percent of budget expended 6.05%
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
Budget
Actual
Last Year
Page 29 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
Recreation Budget
YTD
Actual
Annual %
over (under)
Jan 358,551 304,539 ‐15.06%
Feb 717,974
Mar 1,088,468
Apr 1,455,212
May 1,835,186
Jun 2,239,891
Jul 2,849,851
Aug 3,517,178
Sep 4,068,080
Oct 4,447,445
Nov 4,840,555
Dec 5,263,801
Percent of budget expended 5.79%
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 52,442 58,787 12.10%
Feb 112,820
Mar 187,063
Apr 365,554
May 464,165
Jun 527,898
Jul 700,951
Aug 775,728
Sep 841,420
Oct 984,322
Nov 1,072,876
Dec 1,250,561
Percent of budget expended 4.70%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
Budget
Actual
Last Year
Page 30 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
Neighborhoods
, Resources,
and Events Budget
YTD
Actual
Annual %
over (under)
Jan 42,529 41,419 ‐2.61%
Feb 85,318
Mar 128,698
Apr 179,615
May 228,786
Jun 291,874
Jul 361,214
Aug 426,413
Sep 480,940
Oct 526,500
Nov 579,477
Dec 692,698
Percent of budget expended 5.98%
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,500 2,500 0.00%
Feb 38,333
Mar 57,500
Apr 76,667
May 95,833
Jun 115,000
Jul 134,167
Aug 153,333
Sep 172,500
Oct 191,667
Nov 210,833
Dec 230,000
Percent of budget expended 1.09%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
Budget
Actual
Last Year
Page 31 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
Museum Fund Budget
YTD
Actual
Annual %
over (under)
Jan 17,252 17,791 3.12%
Feb 34,965
Mar 52,434
Apr 70,241
May 88,071
Jun 106,029
Jul 124,048
Aug 141,990
Sep 160,056
Oct 177,858
Nov 195,702
Dec 213,533
Percent of budget expended 8.33%
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 38,441 39,864 3.70%
Feb 77,369
Mar 116,179
Apr 154,878
May 193,891
Jun 232,725
Jul 271,807
Aug 311,339
Sep 350,878
Oct 388,230
Nov 426,925
Dec 465,889
Percent of budget expended 8.56%
$‐
$0.20
$0.40
$0.60
Budget
Actual
Last Year
Page 32 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
Street
Maintenance Budget
YTD
Actual
Annual %
over (under)
Jan 279,287 285,940 2.38%
Feb 611,900
Mar 918,371
Apr 1,215,152
May 1,515,424
Jun 1,821,797
Jul 2,128,792
Aug 2,447,569
Sep 2,764,011
Oct 3,088,569
Nov 3,403,987
Dec 3,728,945
Percent of budget expended 7.67%
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
$5
Millions Transportation
Transportation Budget Actual over (under)
Jan 343,583 288,400 ‐16.06%
Feb 732,773
Mar 1,145,011
Apr 1,487,078
May 1,869,588
Jun 2,288,875
Jul 2,643,630
Aug 3,060,278
Sep 3,428,984
Oct 3,846,248
Nov 4,223,516
Dec 4,711,542
Percent of budget expended 6.12%
$‐
$1
$1
$2
$2
$3
$3
$4
$4
$5
$5
Budget
Actual
Last Year
Page 33 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2012 Budget Year
Debt Service Budget
YTD
Actual
Annual %
over (under)
Jan ‐ ‐ N/A
Feb 1,088,562
Mar 1,632,843
Apr 2,177,124
May 2,721,405
Jun 3,265,687
Jul 3,809,968
Aug 4,354,249
Sep 4,898,530
Oct 5,442,811
Nov 5,987,092
Dec 6,531,373
Percent of budget expended 0.00%
Non‐
Departmental YTD Annual % $5 00
Millions Non‐Departmental Other City Services
$‐
$2
$4
$6
$8
$10
$12
$14
$16
Millions Debt Service
Budget
Actual
Last Year
Other City Budget Actual over (under)
Jan 313,245 313,245 0.00%
Feb 490,708
Mar 736,062
Apr 981,416
May 1,226,770
Jun 1,472,124
Jul 1,717,478
Aug 1,962,832
Sep 2,208,186
Oct 2,453,540
Nov 2,698,894
Dec 2,944,248
Percent of budget expended 10.64%
$‐
$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 34 of 36
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2012 Budget Year
Utilities Budget Revenue Expense
Jan 3,164,286 4,860,643 3,270,986
Feb 7,740,013
Mar 13,011,714
Apr 16,907,772
May 20,901,033
Jun 28,637,592
Jul 33,611,835
Aug 37,987,613
Sep 43,191,375
Oct 48,302,115
Nov 53,139,220
Dec 61,042,999
Percent of budget expended 3.39%
Note: Operations and Capital
$0
$10
$20
$30
$40
$50
$60
$70
Millions Utilities
Budget
Revenue
Expense
$7 00
Millions Airport
Airport Budget Revenue Expense
Jan 428,274 182,302 131,563
Feb 767,296
Mar 1,144,707
Apr 1,560,870
May 1,883,605
Jun 2,524,289
Jul 2,941,966
Aug 3,666,150
Sep 4,229,875
Oct 4,976,221
Nov 5,555,023
Dec 6,055,049
Percent of budget expended 2.17%
Note: Operations and Capital
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
$7.00
Budget
Revenue
Expense
Page 35 of 36
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2012 Budget Year
Golf Course Budget Revenue Expense
Jan 60,382 65,568 123,688
Feb 200,592
Mar 339,771
Apr 428,982
May 529,040
Jun 663,065
Jul 759,813
Aug 867,578
Sep 958,975
Oct 1,043,849
Nov 1,209,132
Dec 2,642,204
Percent of budget expended 4.68%
Note: Operations and Capital
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
$2.40
$2.70
Millions Golf Course
Budget
Revenue
Expense
Page 36 of 36