HomeMy WebLinkAbout201302, February.pdfADMINISTRATIVE SERVICES
DEPARTMENT
M E M O R A N D U M
DATE: March 22, 2013
TO: Randy Corman, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: February 2013 Financial Status Report
At the end of February, general governmental revenues show $916k or 8.6% over budget.
Revenues sources that are higher than expected are: sales tax ($232k); sales tax annexation
credit ($45k); REET ($57k), building permits & development service fees ($228k);
intergovernmental ($629k); public safety services ($226k); interfund/inter‐departmental
services ($130k); rents leases and concessions ($42k); and other miscellaneous ($56k). On the
down side, the revenue sources that are underperforming the year to date budget are:
property taxes ($277k below); utility taxes ($303k below); and gambling taxes ($95k below).
General government expenditures showed unfavourable variance of $73k or 0.5%. See page 9
of report for further expenditure 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.
This page is intentionally left blank
General Governmental Funds
$%
Beginning Fund Balance 11,407,119$ 11,407,119$ 11,057,551$ 11,057,551$ 10,751,945$ 10,751,945$ 15,575,839$ 4,823,894 44.9%
OPERATING REVENUES
Property Tax 32,357,894 841,695 33,466,364 234,689 31,741,366 457,054 179,965 (277,089) ‐60.6%
Sales Tax 17,729,731 3,321,928 18,564,670 3,251,262 18,604,000 3,351,600 3,583,441 231,841 6.9%
Sales Tax ‐ Annexation Credit 2,033,954 361,762 2,208,492 393,908 2,119,680 378,068 423,264 45,196 12.0%
Criminal Justice Sales Tax 1,809,757 306,150 1,924,470 338,736 1,932,500 340,150 370,353 30,203 8.9%
Natural Gas Use Tax 249,407 51,913 272,530 103,454 300,000 113,882 56,163 (57,718) ‐50.7%
Admission Tax 308,200 70,881 311,054 74,353 308,000 73,623 82,440 8,816 12.0%
Franchise Fees 1,234,448 305,646 1,262,188 300,392 1,260,000 299,872 314,469 14,597 4.9%
Electricity Tax 5,166,711 961,417 5,211,111 1,020,050 5,468,000 1,070,335 1,068,529 (1,805) ‐0.2%
Natural Gas Utility Tax 1,848,806 472,200 1,669,967 482,804 1,656,000 478,766 457,439 (21,327) ‐4.5%
Transfer Station 297,474 42,655 330,607 31,552 300,000 28,631 47,232 18,601 65.0%
TV Cable 1,385,275 196,580 1,423,664 196,557 1,477,648 204,010 209,746 5,735 2.8%
Telephone 966,827 168,190 1,056,420 165,318 1,000,000 156,489 107,863 (48,625) ‐31.1%
Cellular Phone 2,054,183 359,479 2,183,853 398,483 2,200,000 401,429 223,565 (177,864) ‐44.3%
City Utilities 3,516,179 558,864 3,806,281 583,499 3,849,014 590,050 569,559 (20,491) ‐3.5%
Leasehold Excise Tax 162,593 34,846 158,849 26,202 145,000 23,918 10,248 (13,669) ‐57.2%
Gambling Excise Tax 1,671,414 254,230 1,691,209 319,797 1,600,000 302,550 207,234 (95,315) ‐31.5%
Real Estate Excise Tax 2,074,059 261,588 2,811,902 291,768 2,600,000 293,731 396,328 102,597 34.9%
Less: Municipal Facilities CIP REET (400,000) (46,712) (943,792) (57,633) (500,000) (30,533) (76,222) (45,690) 149.6%
EMS Levy 868,873 ‐ 885,781 ‐ 900,000 ‐ ‐ ‐ 0.0%
Business License Fees 442,451 107,262 444,680 112,928 533,067 135,374 136,039 665 0.5%
Other Licenses and Permits 232,534 27,241 242,668 38,378 ‐ ‐ ‐ ‐ 0.0%
Building Permits & Development Svc Fees 2,772,779 274,292 3,401,537 358,299 3,170,188 346,434 574,784 228,349 65.9%
Intergovt'l (Grants, State Shared, etc) 4,737,323 636,857 4,593,185 516,625 2,670,330 336,125 934,509 598,383 178.0%
Fire District 25 and 40 Contracts 6,110,668 136,635 6,155,621 152,200 5,574,526 16,707 16,707 ‐ 0.0%
Public Safety 484,985 59,726 485,899 50,077 670,759 69,129 294,643 225,515 326.2%
Culture and Recreation 1,493,540 144,430 1,494,165 121,399 1,633,486 132,719 111,706 (21,013) ‐15.8%
Interfund/Interdept‐Services 3,070,506 473,624 3,311,715 472,142 3,004,214 428,302 558,235 129,933 30.3%
Fines and Forfeits 1,163,602 100,833 1,046,246 82,132 1,108,500 87,327 91,087 3,760 4.3%
Photo Enforcement 1,897,782 329,628 1,976,203 330,705 1,950,000 326,320 309,144 (17,177) ‐5.3%
Seizure Funds ‐ Federal/State/Local 83,220 ‐ 37,941 11,690 ‐ ‐ ‐ ‐ 0.0%
Interests and Other Earnings 107,183 10,119 342,424 11,673 645,300 21,998 10,244 (11,754) ‐53.4%
Rents, Leases, and Concessions 744,834 160,887 822,428 192,089 657,929 153,668 196,155 42,487 27.6%
Contributions and Donations 196,586 30,480 124,082 35,428 87,000 24,840 1,553 (23,287) ‐93.7%
Other Miscellaneous 529,147 34,107 564,571 74,731 697,062 61,632 117,169 55,536 90.1%
Other Financing Sources (Transfer‐In, etc) 1,073,507 808 5,118,188 90 250,000 5 6,974 6,969 139374.8%
Total Operating Revenues 100,476,431 11,050,241 108,457,170 10,715,775 99,613,569 10,674,204 11,590,564 916,360 8.6%
OPERATING EXPENDITURES
Council 271,236 44,576 278,768 45,516 289,114 47,358 47,686 (328) ‐0.7%
Executive 1,566,906 229,987 1,377,109 193,315 1,318,832 189,627 186,330 3,296 1.7%
Hearing Examiner 59,878 21,908 60,368 3,485 40,000 8,447 856 7,591 89.9%
City Attorney 1,596,609 264,464 1,706,320 277,093 1,872,973 307,098 285,967 21,131 6.9%
Court Services 2,084,170 326,156 2,074,980 334,252 2,009,664 319,103 310,767 8,336 2.6%
Community and Eco Dvlpmnt Admin 929,814 155,007 942,071 159,405 1,017,853 170,965 170,570 395 0.2%
Development Services 2,810,736 474,633 3,103,568 477,272 2,966,891 477,520 515,474 (37,954) ‐7.9%
Economic Development 659,981 122,363 529,043 105,987 546,986 105,048 81,391 23,656 22.5%
Planning 1,447,781 258,972 1,482,233 245,831 1,454,717 250,629 237,260 13,369 5.3%
Finance 2,134,667 315,453 2,221,882 312,270 1,952,608 281,346 284,066 (2,720) ‐1.0%
City Clerk 736,880 98,230 937,067 111,173 1,016,822 127,200 122,708 4,492 3.5%
Human Resources 888,252 155,437 937,412 145,615 971,207 160,152 134,784 25,369 15.8%
Police 24,737,346 4,106,211 25,004,580 4,100,369 24,833,698 4,097,142 4,101,784 (4,642) ‐0.1%
Jail Services 6,206,735 277,239 3,489,616 291,830 3,750,000 635,682 635,682 ‐ 0.0%
Fire 22,511,597 4,132,293 24,173,315 4,615,089 24,043,143 4,504,979 4,729,656 (224,678) ‐5.0%
Community Services Admin 416,284 67,558 434,558 73,790 448,556 74,517 74,364 153 0.2%
Parks 3,829,676 527,048 4,004,054 551,290 4,109,908 565,742 563,088 2,654 0.5%
Parks Planning & Natural Resources 551,423 69,260 577,934 73,127 662,852 83,571 88,359 (4,788) ‐5.7%
Recreation 4,974,002 702,382 4,982,229 652,057 5,070,152 689,740 650,023 39,718 5.8%
Human Services 1,247,294 118,956 1,193,871 130,666 1,124,509 114,987 128,054 (13,067) ‐11.4%
Neighborhoods, Resources, & Events 675,534 74,869 701,673 89,449 884,968 105,588 108,774 (3,187) ‐3.0%
Library 2,030,000 5,119 278,604 5,000 ‐ ‐ ‐ ‐ 0.0%
Museum 210,620 34,638 216,887 35,736 209,903 34,553 34,090 463 1.3%
Public Works Admin 452,538 74,538 470,051 79,440 479,503 80,028 79,912 116 0.1%
Street Maintenance 3,534,025 597,149 3,755,640 614,685 4,264,927 709,001 641,518 67,483 9.5%
Transportation 4,509,066 689,957 4,615,160 660,477 4,531,004 670,613 670,659 (46) 0.0%
Debt Service 4,822,566 254,918 9,752,337 250,317 8,001,433 250,317 250,317 ‐ 0.0%
Non‐Departmental and Other 4,930,383 1,557,092 4,637,555 649,480 1,741,350 862,677 862,677 ‐ 0.0%
Total Operating Expenditures 100,825,999 15,756,416 103,938,882 15,284,017 99,613,569 15,923,630 15,996,818 (73,189) ‐0.5%
Total Ending Fund Balance 11,057,551$ 6,700,944$ 15,575,840$ 6,489,310$ 10,751,945$ 5,502,519$ 11,169,585$ 5,667,066$ 103.0%
Favorable (Unfavorable)
2011 2012 2013 Variance
Annual Actual YTD Actual Annual Budget YTD Budget YTD ActualSummary of Sources and Uses Annual Actual YTD Actual
Monthly Financial Report February 2013
Page 1 of 36
Monthly Financial Report February 2013
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through February 28, 2013. 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 68% of
all resources supporting general governmental activities. The following section provides detail information on property,
sales, utility, and other taxes.
Property Tax
February’s collection is $25k, making
the total year‐to‐date collection $180k
or 0.57% of the total budget. In
comparison to the previous year, the
City collected $55k or 23% less.
Compared to the budget, the City is
below projections by $277k or 61%.
2013’s monthly budgets are based on
2010 through 2012 collections.
Sales Tax
February 2013 sales tax receipts totalled
$2 million. Compared with the same
month last year, it is $39k or 2% more.
Compared to the projected current
month’s budget, it is $38k or 2% above.
The year‐to‐date collection of $3.6 million
is $332k or 10% more than the prior year
and is also $232k or 7% more than
budgeted. The City is projecting sales tax
revenues to meet the budget at year‐end.
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 149,112$ 218,452$ 154,945$ 5,834$ 4% (63,506)$ ‐29%
Feb 85,577 238,602 25,020 (60,557) ‐71% (213,582) ‐90%
Mar 880,380 747,935
Apr 10,012,008 8,452,665
May 6,131,450 6,807,499
Jun 43,203 69,561
Jul 446,717 218,293
Aug (51,143) 13,620
Sep 545,753 415,826
Oct 9,734,384 7,408,344
Nov 5,123,725 6,825,452
Dec 365,200 325,116
YTD Total 234,689$ 457,054$ 179,965$ (54,723)$ ‐23% (277,089)$ ‐61%
Annual Total 33,466,364$ 31,741,366$
Property Tax Revenues
Year to Date through February
2013 vs. 2012 2013 vs. Budget
Month
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 1,327,548$ 1,426,729$ 1,620,555$ 293,007$ 22% 193,826$ 14%
Feb 1,923,714 1,924,871 1,962,886 39,173 2% 38,015 2%
Mar 1,303,820 1,392,437 ‐
Apr 1,370,731 1,433,794 ‐
May 1,599,184 1,625,701 ‐
Jun 1,482,794 1,471,334 ‐
Jul 1,505,142 1,462,124 ‐
Aug 1,583,903 1,588,018 ‐
Se p 1,472,566 1,508,206 ‐
Oct 1,660,941 1,588,803 ‐
Nov 1,709,049 1,622,090 ‐
Dec 1,625,280 1,559,893 ‐
YTD Total 3,251,262$ 3,351,600$ 3,583,441$ 332,179$ 10% 231,841$ 7%
Annual Total 18,564,670$ 18,604,000$
2013 vs. Budget2013 vs. 2012
Mo nth
Year to Date through February
Local Retail Sales Tax Revenues
Page 2 of 36
Monthly Financial Report February 2013
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 2012 2013 Bgt YTD Ac t Change 2013/2012 2013 Act vs Bgt
New Construction 298,972$ 292,000$ 519,128$ 220,156$ 74% $ 227,128 78%
Auto Sales 571,189 564,191 599,127 27,938 5% 34,935 6%
General Retail 1,244,660 1,252,159 1,235,830 (8,830) ‐1% (16,328)‐1%
Manufacturing 158,954 233,378 192,784 33,830 21% (40,594)‐17%
Wholesale 210,413 206,882 194,876 (15,537) ‐7% (12,006)‐6%
Service 705,670 733,857 740,448 34,778 5% 6,590 1%
Other 61,404 69,133 101,248 39,844 65% 32,115 46%
Total 3,251,262$ 3,351,600$ 3,583,441$ 332,179$ 10%231,841$ 7%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility tax
February utility tax revenues are $1.5
million, which is $50k or 3% lower
than the same month last year and is
also behind the budget by $83k or
5%. The year‐to‐date collection is
$2.7 million, which is $242k or 8%
lower than the prior year and is also
$303k or 10% lower than the budget.
The City is projecting utility tax
revenues to be under budget at
yearend.
The table below breaks out Utility Tax by source. The Natural Gas variance is due to warmer weather year‐to‐date than the
prior year. Cell and Phone variances are due to receipting a portion ($105k and $61k, respectively) of February’s receipts in
March.
Utility Tax by Type 2012 2013 Bgt YTD Act Change 2013/2012 2013 Act vs Bgt
Electrical 1,020,050$ 1,070,335$ 1,068,529$ 48,479$ 5%$ (1,805) 0%
Natural Gas 586,258 592,648 513,603 (72,655) ‐12% (79,045)‐13%
Cell 398,483 401,429 223,565 (174,918) ‐44% (177,864)‐44%
Phone 165,318 156,489 107,863 (57,454) ‐35% (48,625)‐31%
Cable 196,557 204,010 209,746 13,188 7% 5,735 3%
Transfer Station 31,552 28,631 47,232 15,680 50% 18,601 65%
City Utilities 583,499 590,050 569,559 (13,940) ‐2% (20,491)‐3%
YTD Total 2,981,716$ 3,043,591$ 2,740,096$ (241,620)$ ‐8%(303,495)$ ‐10%
Annual Total 15,954,432$ 16,250,662$
YTD as % of 19% 19%
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 1,469,178$ 1,498,074$ 1,277,860$ (191,318)$ ‐13% (220,215)$ ‐15%
Feb 1,512,539 1,545,517 1,462,236 (50,302) ‐3% (83,281) ‐5%
Mar 1,438,515 1,466,733
Apr 1,384,240 1,411,149
May 1,394,109 1,416,052
Jun 1,108,588 1,132,348
Jul 1,340,939 1,363,075
Aug 1,153,724 1,174,022
Sep 1,301,158 1,325,509
Oct 1,126,772 1,149,130
Nov 1,196,932 1,223,099
Dec 1,527,740 1,545,953
YTD Total 2,981,716$ 3,043,591$ 2,740,096$ (241,620)$ ‐8% (303,495)$ ‐10%
Annual Total 15,954,432$ 16,250,662$
2013 vs. Budget2013 vs . 2012
Year to Date through February
Utility Tax Revenues
Month
Page 3 of 36
Monthly Financial Report February 2013
Other Taxes
Real Estate Excise Tax
The City collected $262k in Real Estate
Excise Tax revenues (REET) for February.
This is $48k or 22% ahead of the same
month last year and is also $47k or 22%
above the current month’s budget. The
year‐to‐date collection is $396k, which is
$105k or 36% more than the prior year
and is also $103k or 35% above the
budget. The City is projecting REET to
meet the budget at year‐end.
Gambling Tax
February’s Gambling Tax
collections totalled $74k, which is
13% of the total budget.
Year‐to‐date total of $207k is
$113k or 35% below the year
before and is also $95k or 32%
below budget. The decline in
revenue is due to payment plans
with two (2) establishments that
will be paid in full by year‐end.
Pull tabs overall had a 6%
decrease, bingo increased by 20%,
and card‐rooms are seeing 12%
lower in activities when compared
to the prior year.
Franchise Fees
Franchise Fees are due quarterly
and the year‐to‐date revenue
collections are $314k or 25% of
the budget. This is $14k or 5%
higher than the prior year and is
also $15k or 5% above the
projected year‐to‐date budget.
The City is projecting franchise
fees to be very close to the
budget at year‐end
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 77,631$ 78,153$ 134,099$ 56,468$ 73% 55,946$ 72%
Feb 214,137 215,578 262,229 48,092 22% 46,651 22%
Mar 203,583 204,953
Apr 194,868 196,179
May 253,446 255,151
Jun 347,179 349,515
Jul 177,839 179,036
Aug 222,933 224,433
Sep 173,212 174,377
Oct 326,027 300,429
Nov 370,123 263,005
Dec 250,922 159,190
YTD Total 291,768$ 293,731$ 396,328$ 104,560$ 36% 102,597$ 35%
Annual Total 2,811,902$ 2,600,000$
Month
2013 vs. Budget2013 vs . 2012
Real Estate Excise Tax Revenues
Year to Date through February
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 175,959$ 166,470$ 133,504$ (42,455)$ ‐24% (32,965)$ ‐20%
Feb 143,837 136,080 73,730 (70,107) ‐49% (62,350) ‐46%
Mar 98,279 92,979 ‐
Apr 156,498 148,058 ‐
May 101,088 95,636 ‐
Jun 127,372 120,502 ‐
Jul 161,244 152,548 ‐
Aug 146,526 138,623 ‐
Sep 162,540 153,774 ‐
Oct 87,494 82,776 ‐
Nov 177,352 167,787 ‐
Dec 153,019 144,767 ‐
YTD Total 319,797$ 302,550$ 207,234$ (112,562)$ ‐35% (95,315)$ ‐32%
Annual Total 1,691,209$ 1,600,000$
2013 vs. 2012 2013 vs. Budget
Gambling Tax Revenue
Month
Year to Date through February
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 300,392$ 299,872$ 314,269$ 13,877$ 5% 14,397$ 5%
Feb ‐ ‐ 200 200 100% 200 100%
Apr 299,534 299,015 ‐
Jul 305,065 304,536 ‐
Oct 309,001 308,466 ‐
Dec 48,195 48,111 ‐
YTD Total 300,392$ 299,872$ 314,469$ 14,077$ 5% 14,597$ 5%
Annual Total 1,262,188$ 1,260,000$
Franchise Fees Revenue
Year to Date through February
Month
2013 vs. 2012 2013 vs. Budget
Page 4 of 36
Monthly Financial Report February 2013
Admission Tax
Admission Tax returns are due
quarterly in January, April, July,
and October each year. January
2013 collections represent
activities conducted during the 4th
quarter of 2012. The year‐to‐date
collection of $82k is $9k or 11%
more than the prior year and is
also $10k or 12% more than
anticipated. The City is projecting
admission tax revenues to be very close to the budget at year‐end.
Licenses and Permits
Building Permits and Development
Service Fees
Building Permits and Development
Service Fee revenues totalled $239k in
February. The year‐to‐date
development fees revenue of $575k is
$216k or 60% more than the before and
is also $228k or 66% higher than budget.
The higher than expected fees are due
to collecting more in general building
permits, electrical permits, and plan
check fees. The City is projecting
building permits and development
service fees to meet the budget at
year‐end.
Business Licenses
Business Licenses totalled $41k for February,
which is $16k or 68% above the same month
last year and is also $12k or 40% above the
current month’s budget. The year‐to‐date
Business Licenses revenue of $136k is $23k or
20% above the prior year and is right on target
with the budget. The City is projecting
business licenses to be very close with the
budget at year‐end.
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 88,676$ 106,302$ 95,381$ 6,705$ 8% (10,921)$ ‐10%
Feb 24,251 29,071 40,658 16,407 68% 11,587 40%
Mar 4,927 5,906 ‐
Apr 89,003 106,694 ‐
May 2,645 3,171 ‐
Jun 3,377 4,048 ‐
Jul 98,553 118,142 ‐
Aug 14,550 17,442 ‐
Sep 3,197 3,833 ‐
Oct 99,644 119,450 ‐
Nov 12,484 14,965 ‐
Dec 3,372 4,042 ‐
YTD Total 112,928$ 135,374$ 136,039$ 23,112$ 20% 665$ 0%
Annual Total 444,680$ 533,067$
Business Licenses
Month
2013 vs. 2012
Year to Date through February
2013 vs. Budget
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 73,420$ 72,699$ 82,440$ 9,020$ 12% 9,741$ 13%
Feb 934 925 ‐
Apr 80,352 79,563 ‐
Jul 81,104 80,307 ‐
Oct 74,001 73,275 ‐
Dec 1,244 1,232 ‐
YTD Total 74,353$ 73,623$ 82,440$ 9,020$ 11% 9,741$ 12%
Annual Total 311,054$ 308,000$
Month
2013 vs. 2012 2013 vs. Budget
Admission Tax Revenue
Year to Date through February
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 160,750$ 154,260$ 335,749$ 174,999$ 109% 181,490$ 118%
Feb 197,549 192,175 239,034 41,485 21% 46,860 24%
Mar 262,937 243,825
Apr 259,386 246,723
May 285,205 242,003
Jun 291,218 249,754
Jul 299,611 280,051
Aug 368,587 351,869
Sep 182,210 161,555
Oct 407,388 384,881
Nov 276,289 263,473
Dec 410,407 399,620
YTD Total 358,299$ 346,434$ 574,784$ 216,485$ 60% 228,349$ 66%
Annual Total 3,401,537$ 3,170,188$
Building Permits and Development Se rvice Fees
Year to Date through February
2013 vs. Budget2013 vs. 2012
Month
Page 5 of 36
Monthly Financial Report February 2013
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 52% of the total
revenues in this category. The year‐to‐date total Intergovernmental revenue is $1.3 million or 13% of the budget. Of the
$629k favourable variance, $539k is for grants that have specific uses and should not be considered as favourable.
State Shared Revenues
State Shared Revenue
collections totalled $664k since
the start of the year.
Compared to the prior year,
State Shared Revenues are
below by $69k or 9%.
Compared to the projected
budget, the City is collecting
$89k or 16% more. The higher
than expected collection is due
to collecting more than
anticipated Criminal Justice
Sales Tax and the low budget
of Criminal Justice’s High Crime. The reason for the decline in Liquor Excise Tax is also due to the passage of Initiative 1183.
Starting October 2012, the State will divert all Liquor Excise Taxes that would normally be distributed to local governments
to their State General Fund for one year. The City will not receive these excise taxes in January 2013, April 2013 and July
2013. On the October 2013 distribution and on, local governments will start receiving their portions of the excise taxes less
a $10 million (per year) transfer from the State Liquor Excise Tax Fund to the State General Fund.
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 56% of the total revenue in this category. The year‐to‐date total charges for services are $1.2 million or 18% of
the budget. This is 57% above budget projections. The following sections provide detail information for Public Safety,
Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totalled $295k
since the start of the year. These
services include private security, adult
probation services, monitoring of
prisoners, and intergovernmental public
safety services (non‐grants). Compared
to the prior year, the City is $245k or
488% more. Compared to the budget,
the City has collected $226k or 326%
more than the anticipated revenue. The
City is projecting public safety services
revenues to meet the budget at year‐
end. The reason for the large favourable
Intergovernmental 2012 2013 Bgt YTD Act Change 2013/2012 2013 Act vs Bgt
Fire District #25 ‐$ ‐$ ‐$ ‐$ N/A $ ‐ N/A
Fire District #40 152,200 16,707 16,707 (135,494) ‐89%‐ 0%
State Shared Revenue 732,880 574,958 664,113 (68,767) ‐9% 89,155 16%
Federal Grants 66,138 90,944 505,125 438,987 664% 414,181 455%
State Grants 20,385 10,373 10,373 (10,013) ‐49%‐ 0%
Other Grants/Intgovt 35,958 ‐ 11,079 (24,879) ‐69% 11,079 100%
ARRA Grants ‐ ‐ 114,171 114,171 100% 114,171 100%
Total Rev YTD 1,007,561$ 692,982$ 1,321,568$ 314,007$ 31%628,587$ 91%
Total Rev Annual 12,673,276$ 10,177,356$
YTD % 8% 7% 13%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 15,229$ 21,023$ 32,322$ 17,093$ 112% 11,299$ 54%
Feb 34,848 48,106 262,321 227,473 653% 214,216 445%
Mar 35,353 48,803 ‐
Apr 68,426 94,459 ‐
May 42,979 59,330 ‐
Jun 31,486 43,465 ‐
Jul 54,883 75,763 ‐
Aug 34,742 47,960 ‐
Sep 36,019 49,723 ‐
Oct 37,300 51,490 ‐
Nov 33,025 45,589 ‐
Dec 61,608 85,047 ‐
YTD Total 50,077$ 69,129$ 294,643$ 244,567$ 488% 225,515$ 326%
Annual Total 485,899$ 670,759$
Month
2013 vs. 2012
Year to Date through February
Public Safety Services
2013 vs. Budget
2012 2013 2013
Actual Budget Actual $ % $ %
Crim Just Sales Tax 338,736$ 340,150$ 370,353$ 31,617$ 9% 30,203$ 9%
Judicial Contribution 5,658 5,625 5,699 41 1% 74 1%
Crim Just ‐ High Crime 46,747 ‐ 51,491 4,744 10% 51,491 100%
Crim Just ‐ Pop 5,086 ‐ 5,399 314 6% 5,399 100%
Crim Just ‐ Spec Prog 19,194 21,904 20,228 1,035 5% (1,676) ‐8%
State DUI 4,438 4,592 4,258 (180) ‐4% (334) ‐7%
Liquor Profits ‐ ‐ ‐ ‐ N/A ‐ N/A
Liquor Excise Tax 109,021 ‐ ‐ (109,021) 0%‐ N/A
Fuel Tax 204,001 202,688 206,685 2,684 1% 3,997 2%
YTD Total 732,880$ 574,958$ 664,113$ (68,767)$ ‐9% 89,155$ 16%
Annual Total 4,825,202$ 4,208,000$
2013 vs. Budget
State Shared Revenues
2013 vs. 2012
Revenue
Year to Date through February
Page 6 of 36
Monthly Financial Report February 2013
variance is due to a different way of accounting for intergovernmental services. Prior to 2013, the City accounted for these
services as general intergovernmental. Due to the 2013 Budgeting, Accounting, and Reporting System (BARS) Restructuring
Project, the State does not recognize intergovernmental charges for services as separate from charges for services. Of the
$295k receipted for Public Safety Services, $228k is for intergovernmental.
Recreation
Recreation revenues totalled $51k for the
current month. Compared to the same
month the prior year, the City collected
$8k or 14% less. Compared to the
projected monthly budget, the City
collected $14k or 21% less. The primary
reason that recreation fees are lower is
due to the new cost recovery policy
approved by council this year which
reduces or eliminates those programs
that do not meet recovery objectives.
This revenue reduction translates into a
savings of $40k in the Recreation Division
of the Community Services Department.
Interfund Services
The year‐to‐date collections for Interfund
Services revenues are $558k. Compared
to the prior year, the revenues are over
by $86k or 18%. Compared to the
projected budget, the revenues are
above by $130k or 30%. 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 $400k. This is $24k or 6%
lower than a year ago and is also $13k
or 3% under the budget. The City is
projecting fines and penalties to be
slightly under the budget at year‐end.
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 62,072$ 67,860$ 60,546$ (1,526)$ ‐2% (7,314)$ ‐11%
Feb 59,327 64,859 51,160 (8,167) ‐14% (13,699) ‐21%
Mar 104,775 114,544 ‐
Apr 137,257 150,056 ‐
May 139,013 151,975 ‐
Jun 149,137 163,043 ‐
Jul 260,363 284,640 ‐
Aug 262,038 286,471 ‐
Sep 107,879 117,938 ‐
Oct 85,973 93,989 ‐
Nov 65,863 72,005 ‐
Dec 60,467 66,105 ‐
YTD Total 121,399$ 132,719$ 111,706$ (9,693)$ ‐8% (21,013)$ ‐16%
Annual Total 1,494,165$ 1,633,486$
Recreation
Year to Date through February
2013 vs. Budget2013 vs. 2012
Month
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 237,384$ 215,343$ 265,873$ 28,489$ 12% 50,531$ 23%
Feb 234,758 212,960 292,362 57,604 25% 79,402 37%
Mar 271,071 245,901 ‐
Apr 253,070 229,571 ‐
May 291,941 264,834 ‐
Jun 275,112 249,568 ‐
Jul 217,828 197,602 ‐
Aug 345,690 313,592 ‐
Sep 273,570 248,168 ‐
Oct 338,304 306,892 ‐
Nov 276,902 251,191 ‐
Dec 296,085 268,593 ‐
YTD Total 472,142$ 428,302$ 558,235$ 86,093$ 18% 129,933$ 30%
Annual Total 3,311,715$ 3,004,214$
Interfund Services
Year to Date through February
2013 vs. 2012 2013 vs. Budget
Month
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 183,478$ 181,746$ 153,064$ (30,413)$ ‐17% (28,682)$ ‐16%
Feb 241,050 231,901 247,166 6,116 3% 15,265 7%
Mar 244,379 246,962
Apr 278,972 279,587
May 306,424 310,705
Jun 318,091 312,586
Jul 274,243 277,336
Aug 168,187 171,297
Sep 179,166 176,075
Oct 278,866 280,183
Nov 247,607 251,568
Dec 339,926 338,553
YTD Total 424,528$ 413,648$ 400,231$ (24,297)$ ‐6% (13,417)$ ‐3%
Annual Total 3,060,389$ 3,058,500$
2013 vs. Budget2013 vs . 2012
Year to Date through February
Fines and Penalties by Month
Month
Page 7 of 36
Monthly Financial Report February 2013
Year to Date through February
2012 2013 2013
Actual Budget Actual $ % $ %
Civil Penalties 765$ 1,276$ 710$ (56)$ ‐7% (566)$ ‐44%
Civil Infraction Penalties 49,475 48,126 48,812 (662) ‐1% 687 1%
Civil Parking Infraction Penalties 10,276 11,627 16,876 6,600 64% 5,249 45%
Photo Enforcement Program 330,705 326,320 309,144 (21,561) ‐7% (17,177) ‐5%
Criminal Traffic Misdemeanor Fines 8,457 9,752 8,865 408 5% (887) ‐9%
Criminal Non‐Traffic Fines 2,297 4,196 1,964 (332) ‐14% (2,232) ‐53%
Criminal Costs 10,788 10,173 10,854 67 1% 682 7%
Seizure Funds ‐ Federal/State/Local 11,690 ‐ ‐ (11,690) 0%‐ N/A
Non‐Court Fines, Forfeitures and Penalties 75 2,178 3,005 2,930 3907% 827 38%
YTD Total 424,528$ 413,648$ 400,231$ (24,297)$ ‐6% (13,417)$ ‐3%
Annual Total 3,060,389$ 3,058,500$
Revenue
2013 vs. Budget
Fines and Penalties by Type
2013 vs. 2012
Included in the Fines and Penalties revenue budget is
$2 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 $309k. The budget shortfall is due to a
change in receipting operations that resulted in a 1‐
month lag for defendant paid infractions.
December’s receipts will recognize 2 month’s worth
of defendant paid infractions.
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 81%
of the total revenue in this category.
The year‐to‐date total miscellaneous is
$256k. Compared to last year, the
revenues are under by $34k or 12%.
Compared to the projected year‐to‐
date budget, the revenues are over by
$31k or 14%. The table on the next
page breaks out miscellaneous revenues by type:
Favorable
Budget Actual Budget Actual (Unfavorable)
1
Jan 181,020$ 150,459$ 74,626$ 60,422$ 90,037$
Feb 145,300 158,685 74,412 60,116 98,568
Mar 142,933 ‐ 74,226 ‐ ‐
Apr 176,175 ‐ 71,127 ‐ ‐
May 212,766 ‐ 74,599 ‐ ‐
Jun 218,587 ‐ 74,570 ‐ ‐
Jul 186,121 ‐ 74,882 ‐ ‐
Aug 91,365 ‐ 74,285 ‐ ‐
Sep 71,743 ‐ 50,884 ‐ ‐
Oct 191,799 ‐ 65,641 ‐ ‐
Nov 153,910 ‐ 66,315 ‐ ‐
Dec 178,282 ‐ 66,397 ‐ ‐
YTD Total 326,320$ 309,144$ 149,037$ 120,539$ 188,605$
Annual Total 1,950,000$ 841,964$
1Actuals of Revenues and Expenses
Revenues Expenses
Photo Enforcement Program
Year to Date through February
Month
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 206,151$ 155,115$ 179,743$ (26,408)$ ‐13% 24,628$ 16%
Feb 83,823 70,460 76,397 (7,425) ‐9% 5,937 8%
Mar 104,421 79,046
Apr 98,164 163,951
May 145,213 125,421
Jun 93,832 94,821
Jul 112,316 110,509
Aug 143,389 131,553
Sep 89,588 88,102
Oct 91,608 91,654
Nov 64,705 71,597
Dec 397,713 579,694
YTD Total 289,974$ 225,575$ 256,140$ (33,834)$ ‐12% 30,565$ 14%
Annual Total 1,630,922$ 1,761,922$
Year to Date through February
Month
2013 vs. Budget2013 vs. 2012
Miscellaneous Revenues by Month
Page 8 of 36
Monthly Financial Report February 2013
2012 2013 2013
Actual Budget Actual $ % $ %
Interests and Other Earnings 11,673$ 21,998$ 10,244$ (1,429)$ ‐12% (11,754)$ ‐53%
Rents, Leases, and Concessions 192,089 153,668 196,155 4,067 2% 42,487 28%
Contributions/Donations from Private Sources 35,428 24,840 1,553 (33,874) ‐96% (23,287) ‐94%
Other 50,785 25,070 48,188 (2,596) ‐5% 23,118 92%
YTD Total 289,974$ 225,575$ 256,140$ (33,834)$ ‐12% 30,565$ 14%
Annual Total 1,630,922$ 1,761,922$
2013 vs. Budget
Miscellaneous Re venues by Type
Year to Date through February
Revenue
2013 vs. 2012
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 unfavourable due to the timing of donations.
Other miscellaneous revenues are higher than the prior year and budget due to higher than expected utility late payment
penalties.
EXPENSES
Overall the City has expended 16% of its budgeted general governmental expenditures at the end of February. This is $73k
or 0.5% above year‐to‐date budgeted expenditures. See below for summary of unfavourable items for general
governmental departments.
The Council department is over the projected year‐to‐date budget by $328 or 0.7% due to the timing of 2012’s benefit
premiums, which is what the 2013 budget is based on. Overall department budget will correct itself later on in the year.
Community and Economic Development department is over the projected year‐to‐date budget by $535 or 0.1%. This is due
to limited term construction inspectors’ budgets (Development Services) that will need to a budget adjustment in the 2013
Carry Forward Budget Amendment and offsetting savings in Economic Development and Planning.
Police department is over the year‐to‐date budget by $5k or 0.1%. This is due to the timing of invoices for supplies,
professional services, and intergovernmental services paid in 2013 compared to 2012. We will monitor these items to
determine if a budget amendment is needed at year‐end.
Fire department is over the year‐to‐date budget by $225k or 5 %. This is mainly due to over spending in salaries and
benefits ($73k), overtime ($63k), supplies ($47k), professional services ($21k), and intergovernmental ($11k). We will
monitor these items to determine if a budget amendment is needed at year‐end.
Page 9 of 36
Monthly Financial Report February 2013
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 ‐ ‐ ‐ ‐ 9,063 6,128 ‐
Grants / intergovernmental 417,030 ‐ ‐ ‐ ‐ (256) ‐
Charges for services 15,259 126,630 2,459,881 2,508,420 1,484,671 1,468,981 2,359,969
Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐
Fines and penalties ‐ ‐ ‐ ‐ 33 ‐ ‐
Rents, leases, and misc fees 383,110 25,951 12,679 22,024 ‐ ‐ ‐
Interest and other misc 1,184 286 3,968 34,749 77,581 28,757 672
TOTAL REVENUES 816,583 152,867 2,476,528 2,565,193 1,571,348 1,503,610 2,360,641
EXPENSES:
Utility billing ‐ ‐ 19,065 18,748 13,759 22,283 ‐
Utility systems ‐ ‐ 1,616,275 529,792 461,162 376,392 ‐
Utility maintenance ‐ ‐ 46,879 715,021 190,323 317,189 2,376,537
Transportation 235,692 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 244,984 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 235,692 244,984 1,682,219 1,263,561 665,244 715,864 2,376,537
AMOUNT AVAILABLE FOR DEBT SERVICE 580,891 (92,117) 794,309 1,301,632 906,104 787,746 (15,896)
DEBT SERVICE:
Principal ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest ‐ ‐ ‐ ‐ ‐ ‐ ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ ‐ ‐ ‐ ‐
CAPITAL PROJECTS 36,875 1,643 ‐ 97,555 137,664 216,801 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ 7,526 (3,763) (3,763) ‐
CHANGE IN FUND BALANCE 544,016 (93,760) 794,309 1,211,603 764,677 567,182 (15,896)
BEGINNING FUND BALANCE, Jan 1 2,342,924 539,814 1,523,881 9,846,308 3,196,734 6,014,474 1,745,887
ENDING FUND BALANCE, Feb 28 2,886,940 446,054 2,318,190 11,057,911 3,961,411 6,581,656 1,729,991
Page 10 of 36
Monthly Financial Report February 2013
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 ‐ 17,807 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ ‐ ‐ ‐ ‐ ‐ ‐
Charges for services
Equipment rental m&o 479,476 508,948 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 18,739 ‐ 66,793 ‐ ‐ ‐
Communications ‐ 1,500 ‐ 87,490 ‐ ‐ ‐
Facilities ‐ ‐ 713,115 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 23,409 ‐ ‐ ‐ ‐ ‐
IT service co ntracts ‐ 73,096 ‐ ‐ ‐ ‐ ‐
Interest and other misc 1,527 765 379 122 1,721 3,431 2,559
Internal service fund misc:
Vehicle / equipment capital recovery 235,130 28,321 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 265,302 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 248,146 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 1,928,385 284,560
Other misc ‐ 50 8,748 ‐ ‐ 15,562 ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets ‐ ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 32,735 ‐ ‐
TOTAL REVENUES 716,133 672,635 722,242 154,405 547,904 1,947,378 287,119
EXPENSES:
Communications 77,641
Equipment rental 303,542
Facilities 537,731
Healthcare 1,606,601
Information technology 572,783
Print and mail 62,807
Retiree healthcare 160,845
Risk management
Risk management 851,534
Unemployment 13,620
Worker's compensation 295,869
TOTAL EXPENSES 303,542 572,783 537,731 140,448 1,161,023 1,606,601 160,845
AMOUNT AVAILABLE FOR CAPITAL 412,591 99,852 184,511 13,957 (613,119) 340,777 126,274
CAPITAL PROJECTS 69,771 44,705 54,421 ‐ ‐ ‐ ‐
TRANSFERS IN ‐ ‐ ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 342,820 55,147 130,090 13,957 (613,119) 340,777 126,274
BEGINNING FUND BALANCE, Jan 1 3,722,501 1,856,972 849,472 303,477 4,986,807 7,899,070 6,482,165
ENDING FUND BALANCE, Feb 28 4,065,321 1,912,119 979,562 317,434 4,373,688 8,239,847 6,608,439
Page 11 of 36
Monthly Financial Report February 2013
FUND BALANCE
Page 13 shows the ending fund balance as of February 2013. 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 February, the City has $11.2 million reported in the combined general governmental fund balance of the
current year’s operating budget, which is approximately 11% of budgeted operating expenditures. This is a decrease of
$4.4 million from the year’s beginning balance. February’s ending fund balance is over the anticipated General
Governmental Fund Balance of $5.5 million by $5.7 million or 103%. 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 2013 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 February 2013
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through February 28, 2013
Funds
Balance
01/01/2013
Budgeted
Revenue
Revenue
02/28/13
Total Funds
Available
Budgeted
Expenditure
Expenditure
02/28/13
Ending
Balance
GENERAL GOVERNMENT FUNDS:15,575,839 99,613,569 11,590,564 27,166,403 99,613,569 15,996,818 11,169,585
000 General 10,575,369 70,913,379 8,710,778 19,286,147 71,125,807 12,885,877 6,400,271
001 Community Services 1,891,966 11,239,691 1,379,616 3,271,582 11,095,120 1,478,701 1,792,881
003 Street 1,585,553 8,877,257 933,642 2,519,195 8,795,931 1,312,177 1,207,018
004 Community Dev Block Grant (13,145) 265,506 86,254 73,109 279,061 28,359 44,750
005 Museum 52,369 209,903 12 52,381 209,903 34,090 18,291
009 Farmers Market 90,520 81,400 5,524 96,044 81,314 5,907 90,137
011 Fire Health & Wellness 55,483 25,000 8,790 64,273 25,000 1,390 62,884
031 Park Memorial 178,367 ‐ 69 178,436 ‐ ‐ 178,436
201 Ltd GO Bonds Gen Govt Debt 829,784 1,749,305 338 830,122 1,749,305 ‐ 830,122
215 Gen Govt Misc Debt Service 329,573 6,252,128 465,541 795,114 6,252,128 250,317 544,797
SPECIAL REVENUE FUNDS:
102 Arterial Street 168,514 643,000 97,356 265,870 640,000 ‐ 265,870
108 Leased City Properties 527,677 797,289 75,021 602,698 749,656 62,092 540,606
110 Hotel Motel 111,256 245,000 78,473 189,729 245,000 18,810 170,919
125 1% For Art 116,142 15,000 45 116,187 50,000 ‐ 116,187
127 Cable Communication 257,372 85,674 53,915 311,287 85,674 20,544 290,743
135 Springbrook Wetlands Bank 665,828 ‐ 257 666,085 ‐ ‐ 666,085
CAPITAL PROJECT FUNDS (CIP):
303 Community Dev Mitigation 1,540,154 60,000 4,842 1,544,996 ‐ ‐ 1,544,996
304 Fire Mitigation 797,417 25,000 7,474 804,891 250,000 ‐ 804,891
305 Transportation Mitigation 292,627 40,000 7,401 300,028 183,000 ‐ 300,028
316 Municipal Facilities CIP 3,474,517 2,485,000 316,196 3,790,713 2,722,725 114,267 3,676,446
317 Transportation CIP (391,159) 25,258,120 1,418,094 1,026,935 25,257,711 1,117,068 (90,133)
318 So Lake WA Infrastructure Proj 52,073 ‐ 20 52,093 ‐ 248 51,845
326 Housing Opportunity 84,359 ‐ 44 84,403 ‐ ‐ 84,403
336 New Library Development 19,143,344 ‐ 7,325 19,150,669 ‐ 20,376 19,130,293
ENTERPRISE FUNDS:
402 Airport 331,939 1,408,843 398,712 730,651 1,379,685 235,692 494,959
403 Solid Waste Utility 1,523,881 15,700,852 2,476,528 4,000,409 16,170,067 1,682,219 2,318,190
404 Golf Course 291,978 2,453,669 152,769 444,747 2,465,769 253,314 191,433
422 Airport Capital 2,010,985 10,340,092 417,871 2,428,856 10,340,092 36,875 2,391,981
424 Golf Course Capital 247,836 50,000 8,427 256,263 50,000 1,643 254,620
INTERNAL SERVICE FUNDS:
501 Equipment Repair/Replacement 3,722,501 4,169,724 716,133 4,438,634 4,013,931 373,313 4,065,321
502 Insurance 4,986,807 3,713,764 547,904 5,534,711 3,058,068 1,161,023 4,373,688
503 Information Services 1,856,972 4,082,323 672,636 2,529,608 4,078,959 617,488 1,912,120
504 Facilities 849,472 4,276,112 722,242 1,571,714 4,230,522 592,152 979,562
505 Communications 303,477 877,773 154,405 457,882 886,184 140,448 317,434
512 Insurance, Healthcare 7,899,070 9,329,364 1,947,377 9,846,447 10,902,577 1,606,601 8,239,846
522 Insurance, Leoff1 Retirees HC 6,482,165 1,735,684 287,119 6,769,284 1,737,606 160,845 6,608,439
FIDUCIARY FUNDS:
611 Firemen's Pension 4,556,003 300,000 848 4,556,851 240,475 34,467 4,522,384
Funds
Balance
01/01/2013
Budgeted
Revenue
Revenue
02/28/13
Total Funds
Available
Budgeted
Expenditure
Expenditure
02/28/13
Ending
Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 20,803,403 52,161,152 8,008,318 28,811,721 47,912,993 5,480,753 23,330,968
405 Water Utility 5,449,029 12,668,096 2,554,523 8,003,552 10,994,985 1,274,850 6,728,702
406 Waste Water Utility 1,363,629 6,247,645 1,494,554 2,858,183 5,490,418 669,008 2,189,175
407 Surface Water Utility 2,269,771 7,934,708 1,478,355 3,748,126 6,116,887 719,628 3,028,498
416 King County Metro 1,745,887 15,126,703 2,360,640 4,106,527 15,126,703 2,376,537 1,729,990
425 Water Utility Construction 4,381,380 3,745,000 18,190 4,399,570 3,745,000 86,265 4,313,305
426 Waste Water Construction 1,833,105 3,250,000 76,795 1,909,900 3,250,000 137,664 1,772,236
427 Surface Water Construction 3,744,703 3,189,000 25,255 3,769,958 3,189,000 216,801 3,553,157
471 Waterworks Rate Stabilization 15,899 ‐ 6 15,905 ‐ ‐ 15,905
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
2013 Budget Year
General Government Summary
Revenues Expenditures
$ Difference
over (under)
w/beginning
balance
15,575,839
January 5,592,172 7,563,322 (1,971,150) 13,604,689
February 11,590,564 15,996,818 (4,406,254) 11,169,585
March
April
May
June
July
August
September
October
November
December
(3,000,000)
(2,000,000)
(1,000,000)
‐
70,000,000
80,000,000
90,000,000
100,000,000
110,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)
‐
10,000,000
20,000,000
30,000,000
40,000,000
50,000,000
60,000,000
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Page 14 of 36
City of Renton
Monthly Revenue Analysis ‐ 2013 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 5,176,323 5,592,172 8.03%
Feb 10,674,204 11,590,564 8.58%
Mar 16,055,160
Apr 30,391,659
May 44,466,981
Jun 49,508,203
Jul 55,434,510
Aug 60,545,020
Sep 65,611,729
Oct 79,193,640
Nov 92,686,989
Dec 99,613,569
Percent of budget 11.64%
YTD Annual %
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
Millions
Total Revenue
General Government
Budget
Actual
Last Year
$36
Millions Property Tax
Property Tax Budget Actual over (under)
Jan 218,452 154,945 ‐29.07%
Feb 457,054 179,965 ‐60.62%
Mar 1,204,989
Apr 9,657,654
May 16,465,154
Jun 16,534,715
Jul 16,753,008
Aug 16,766,628
Sep 17,182,454
Oct 24,590,798
Nov 31,416,250
Dec 31,741,366
Percent of budget 0.57%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
$36
Budget
Actual
Last Year
Page 15 of 36
City of Renton
Monthly Revenue Analysis ‐ 2013 Budget Year
Sales Tax Budget
YTD
Actual
Annual %
over (under)
Jan 1,585,548 1,812,385 14.31%
Feb 3,729,667 4,006,705 7.43%
Mar 5,270,744
Apr 6,860,537
May 8,668,156
Jun 10,307,140
Jul 11,940,419
Aug 13,708,668
Sep 15,384,395
Oct 17,162,223
Nov 18,978,733
Dec 20,723,680
Percent of budget 19.33%
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,498,074 1,277,860 ‐14.70%
Feb 3,043,591 2,740,096 ‐9.97%
Mar 4,510,325
Apr 5,921,474
May 7,337,525
Jun 8,469,874
Jul 9,832,949
Aug 11,006,972
Sep 12,332,480
Oct 13,481,610
Nov 14,704,709
Dec 16,250,662
Percent of budget 16.86%
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 ‐ 2013 Budget Year
Licenses &
Permits Budget
YTD
Actual
Annual %
over (under)
Jan 219,805 325,005 47.86%
Feb 386,363 547,949 41.82%
Mar 577,527
Apr 857,156
May 1,039,921
Jun 1,233,767
Jul 1,546,809
Aug 1,840,650
Sep 1,982,450
Oct 2,367,908
Nov 2,572,290
Dec 2,863,828
Percent of budget 19.13%
Note: Franchise Fees
YTD Annual % Millions
Intergovernmental
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
Millions Licenses & Permits
Budget
Actual
Last Year
Intergovt'l Budget Actual over (under)
Jan 354,190 565,532 59.67%
Feb 692,982 1,321,568 90.71%
Mar 1,025,508
Apr 1,890,079
May 4,193,657
Jun 4,777,533
Jul 5,190,933
Aug 5,650,317
Sep 6,116,882
Oct 7,278,065
Nov 9,570,831
Dec 10,177,356
Percent of budget 12.99%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
$10
$11
$12
$13
Millions
Budget
Actual
Last Year
Page 17 of 36
City of Renton
Monthly Revenue Analysis ‐ 2013 Budget Year
Charges for
Services Budget
YTD
Actual
Annual %
over (under)
Jan 354,323 485,115 36.91%
Feb 762,158 1,196,439 56.98%
Mar 1,260,779
Apr 1,843,966
May 2,409,783
Jun 2,951,545
Jul 3,626,060
Aug 4,373,872
Sep 4,840,228
Oct 5,436,426
Nov 5,913,626
Dec 6,473,255
Percent of budget 18.48%
Note: Excludes FD25 & FD40 contracts
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 181,746 153,064 ‐15.78%
Feb 413,648 400,231 ‐3.24%
Mar 660,610
Apr 940,197
May 1,250,902
Jun 1,563,488
Jul 1,840,824
Aug 2,012,121
Sep 2,188,195
Oct 2,468,378
Nov 2,719,947
Dec 3,058,500
Percent of budget 13.09%
$‐
$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 ‐ 2013 Budget Year
Other Taxes Budget
YTD
Actual
Annual %
over (under)
Jan 609,070 638,523 4.84%
Feb 963,161 934,497 ‐2.98%
Mar 1,239,788
Apr 1,951,594
May 2,500,859
Jun 2,974,287
Jul 3,897,103
Aug 4,247,808
Sep 4,557,833
Oct 5,289,676
Nov 5,584,037
Dec 6,313,000
Percent of budget 14.80%
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 155,115 179,743 15.88%
Feb 225,575 256,140 13.55%
Mar 304,621
Apr 468,572
May 593,994
Jun 688,814
Jul 799,323
Aug 930,875
Sep 1,018,978
Oct 1,110,631
Nov 1,182,228
Dec 1,761,922
Percent of budget 14.54%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80 Budget
Actual
Last Year
Page 19 of 36
City of Renton
Monthly Revenue Analysis ‐ 2013 Budget Year
Other
Financing Budget
YTD
Actual
Annual %
over (under)
Jan ‐ ‐ N/A
Feb 5 6,974 139374.80%
Mar 268
Apr 430
May 7,030
Jun 7,040
Jul 7,083
Aug 7,110
Sep 7,833
Oct 7,925
Nov 44,338
Dec 250,000
Percent of budget 2.79%
YTD Annual % Millions
Real Estate Excise Tax
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
Millions Other Financing Sources
Budget
Actual
Last Year
REET Budget Actual over (under)
Jan 71,786 134,099 86.80%
Feb 269,776 396,328 46.91%
Mar 458,016
Apr 638,196
May 872,560
Jun 1,193,556
Jul 1,358,006
Aug 1,564,134
Sep 1,724,294
Oct 2,025,764
Nov 2,367,976
Dec 2,600,000
Percent of budget 15.24%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
Millions
Budget
Actual
Last Year
Page 20 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,299,837 7,563,322 3.61%
Feb 15,923,630 15,996,818 0.46%
Mar 24,422,585
Apr 32,586,280
May 41,003,974
Jun 48,978,733
Jul 57,678,507
Aug 66,032,450
Sep 74,319,407
Oct 82,488,481
Nov 90,618,573
Dec 99,613,569
Percent of budget expended 16.06%
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,137 23,354 0.94%
Feb 47,358 47,686 0.69%
Mar 71,664
Apr 95,489
May 119,661
Jun 143,723
Jul 168,174
Aug 192,114
Sep 216,201
Oct 240,462
Nov 264,495
Dec 289,114
Percent of budget expended 16.49%
$‐
$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 ‐ 2013 Budget Year
Executive Budget
YTD
Actual
Annual %
over (under)
Jan 84,474 78,944 ‐6.55%
Feb 189,627 186,330 ‐1.74%
Mar 295,360
Apr 406,525
May 515,537
Jun 622,293
Jul 733,693
Aug 845,161
Sep 951,263
Oct 1,061,646
Nov 1,166,888
Dec 1,318,832
Percent of budget expended 14.13%
Hearing YTD Annual %
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
Millions Executive
Budget
Actual
Last Year
$60 000
Hearing Examiner
Examiner Budget Actual over (under)
Jan 5,296 ‐ 0.00%
Feb 8,447 856 ‐89.87%
Mar 13,293
Apr 15,537
May 18,668
Jun 21,071
Jul 23,545
Aug 27,015
Sep 29,700
Oct 31,542
Nov 36,403
Dec 40,000
Percent of budget expended 2.14%
$‐
$10,000
$20,000
$30,000
$40,000
$50,000
$60,000
Budget
Actual
Last Year
Page 22 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
City Attorney Budget
YTD
Actual
Annual %
over (under)
Jan 151,617 141,744 ‐6.51%
Feb 307,098 285,967 ‐6.88%
Mar 461,873
Apr 619,253
May 769,816
Jun 927,028
Jul 1,081,020
Aug 1,235,588
Sep 1,389,832
Oct 1,557,959
Nov 1,711,087
Dec 1,872,973
Percent of budget expended 15.27%
YTD Annual % $2 20
Millions Court Services
$‐
$0.40
$0.80
$1.20
$1.60
$2.00
Millions City Attorney
Budget
Actual
Last Year
Court Services Budget Actual over (under)
Jan 159,746 152,280 ‐4.67%
Feb 319,103 310,767 ‐2.61%
Mar 481,131
Apr 645,487
May 817,335
Jun 1,007,897
Jul 1,176,299
Aug 1,343,709
Sep 1,507,142
Oct 1,670,684
Nov 1,837,642
Dec 2,009,664
Percent of budget expended 15.46%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
$2.00
$2.20
Budget
Actual
Last Year
Page 23 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
CED Admin Budget
YTD
Actual
Annual %
over (under)
Jan 85,379 85,287 ‐0.11%
Feb 170,965 170,570 ‐0.23%
Mar 256,550
Apr 343,813
May 427,950
Jun 512,087
Jul 596,310
Aug 680,623
Sep 764,811
Oct 848,386
Nov 932,161
Dec 1,017,853
Percent of budget expended 16.76%
Development YTD Annual %
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Millions
Community & Economic
Development Admin
Budget
Actual
Last Year
Millions
Development Services
Services Budget Actual over (under)
Jan 236,275 272,362 15.27%
Feb 477,520 515,474 7.95%
Mar 718,382
Apr 959,579
May 1,218,881
Jun 1,453,325
Jul 1,704,926
Aug 1,945,288
Sep 2,198,041
Oct 2,456,832
Nov 2,708,464
Dec 2,966,891
Percent of budget expended 17.37%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions
Budget
Actual
Last Year
Page 24 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Economic
Development Budget
YTD
Actual
Annual %
over (under)
Jan 52,423 75,717 44.43%
Feb 105,048 81,391 ‐22.52%
Mar 149,126
Apr 190,220
May 235,973
Jun 278,457
Jul 325,761
Aug 368,863
Sep 411,323
Oct 453,554
Nov 503,156
Dec 546,986
Percent of budget expended 14.88%
YTD Annual %
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
Millions
Economic Development
Budget
Actual
Last Year
Millions
Planning
Planning Budget Actual over (under)
Jan 112,233 112,247 0.01%
Feb 250,629 237,260 ‐5.33%
Mar 360,348
Apr 480,962
May 594,876
Jun 706,787
Jul 821,138
Aug 966,341
Sep 1,094,212
Oct 1,207,290
Nov 1,326,475
Dec 1,454,717
Percent of budget expended 16.31%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
Millions
Budget
Actual
Last Year
Page 25 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Finance Budget
YTD
Actual
Annual %
over (under)
Jan 137,857 144,010 4.46%
Feb 281,346 284,066 0.97%
Mar 422,721
Apr 563,203
May 710,063
Jun 863,353
Jul 1,008,100
Aug 1,162,382
Sep 1,305,685
Oct 1,430,899
Nov 1,555,216
Dec 1,952,608
Percent of budget expended 14.55%
YTD Annual % $1 20
Millions City Clerk
$‐
$0.40
$0.80
$1.20
$1.60
$2.00
$2.40
Millions Finance
Budget
Actual
Last Year
City Clerk Budget Actual over (under)
Jan 61,578 61,226 ‐0.57%
Feb 127,200 122,708 ‐3.53%
Mar 197,115
Apr 329,208
May 397,099
Jun 464,085
Jul 659,762
Aug 730,575
Sep 800,051
Oct 869,716
Nov 940,420
Dec 1,016,822
Percent of budget expended 12.07%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Budget
Actual
Last Year
Page 26 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Human
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 82,898 64,230 ‐22.52%
Feb 160,152 134,784 ‐15.84%
Mar 238,813
Apr 309,891
May 380,524
Jun 466,619
Jul 548,821
Aug 631,175
Sep 709,673
Oct 793,138
Nov 879,704
Dec 971,207
Percent of budget expended 13.88%
YTD Annual %
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
Millions Human Resources
Budget
Actual
Last Year
$30
Millions Police
Police Budget Actual over (under)
Jan 2,383,587 2,521,995 5.81%
Feb 4,732,824 4,737,466 0.10%
Mar 7,087,218
Apr 9,506,611
May 11,985,874
Jun 14,244,474
Jul 16,791,120
Aug 18,991,260
Sep 21,353,825
Oct 23,687,079
Nov 26,050,002
Dec 28,583,698
Percent of budget expended 16.57%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
Budget
Actual
Last Year
Page 27 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Fire &
Emergency
Services Budget
YTD
Actual
Annual %
over (under)
Jan 1,877,400 2,045,002 8.93%
Feb 4,504,979 4,729,656 4.99%
Mar 6,406,883
Apr 8,285,283
May 10,444,179
Jun 12,340,816
Jul 14,246,561
Aug 16,280,420
Sep 18,242,650
Oct 20,146,781
Nov 22,065,932
Dec 24,043,143
Percent of budget expended 19.67%
Community YTD Annual %
$‐
$3
$6
$9
$12
$15
$18
$21
$24
Millions Fire & Emergency Services
Budget
Actual
Last Year
$0 50
Millions Community Services Admin
Services Admin Budget Actual over (under)
Jan 38,404 37,025 ‐3.59%
Feb 74,517 74,364 ‐0.21%
Mar 111,203
Apr 147,569
May 184,898
Jun 221,366
Jul 258,055
Aug 294,452
Sep 330,441
Oct 366,025
Nov 403,334
Dec 448,556
Percent of budget expended 16.58%
$‐
$0.05
$0.10
$0.15
$0.20
$0.25
$0.30
$0.35
$0.40
$0.45
$0.50
Budget
Actual
Last Year
Page 28 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Parks Budget
YTD
Actual
Annual %
over (under)
Jan 281,070 269,811 ‐4.01%
Feb 565,742 563,088 ‐0.47%
Mar 871,770
Apr 1,200,681
May 1,528,017
Jun 1,874,907
Jul 2,237,362
Aug 2,610,725
Sep 2,998,644
Oct 3,384,828
Nov 3,749,218
Dec 4,109,908
Percent of budget expended 13.70%
Parks Planning
and Natural YTD Annual %
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
Millions Parks
Budget
Actual
Last Year
$0 70
Millions Parks Planning and Natural Resources
Resources Budget Actual over (under)
Jan 41,317 42,639 3.20%
Feb 83,571 88,359 5.73%
Mar 137,313
Apr 187,884
May 251,006
Jun 312,043
Jul 364,763
Aug 418,363
Sep 478,321
Oct 544,028
Nov 605,308
Dec 662,852
Percent of budget expended 13.33%
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
$0.70
Budget
Actual
Last Year
Page 29 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Recreation Budget
YTD
Actual
Annual %
over (under)
Jan 339,053 305,989 ‐9.75%
Feb 689,740 650,023 ‐5.76%
Mar 1,048,217
Apr 1,418,717
May 1,789,153
Jun 2,169,957
Jul 2,754,845
Aug 3,406,047
Sep 3,914,519
Oct 4,292,698
Nov 4,659,252
Dec 5,070,152
Percent of budget expended 12.82%
Human YTD Annual % $1 20
Millions Human Services
$‐
$1
$2
$3
$4
$5
$6
Millions Recreation
Budget
Actual
Last Year
Services Budget Actual over (under)
Jan 51,842 45,984 ‐11.30%
Feb 114,987 128,054 11.36%
Mar 204,326
Apr 358,931
May 450,648
Jun 509,932
Jul 634,552
Aug 699,930
Sep 757,144
Oct 902,458
Nov 969,299
Dec 1,124,509
Percent of budget expended 11.39%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Budget
Actual
Last Year
Page 30 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Neighborhoods
, Resources,
and Events Budget
YTD
Actual
Annual %
over (under)
Jan 54,023 56,917 5.36%
Feb 105,588 108,774 3.02%
Mar 167,249
Apr 229,138
May 288,660
Jun 366,287
Jul 454,702
Aug 537,625
Sep 611,445
Oct 680,142
Nov 777,040
Dec 884,968
Percent of budget expended 12.29%
YTD Annual % $0 30
Millions Library Fund
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
$0.70
$0.80
$0.90
$1.00
Millions Neighborhoods, Resources, and Events
Budget
Actual
Last Year
Library Fund Budget Actual over (under)
Jan ‐ ‐ N/A
Feb ‐ ‐ N/A
Mar ‐
Apr ‐
May ‐
Jun ‐
Jul ‐
Aug ‐
Sep ‐
Oct ‐
Nov ‐
Dec ‐
Percent of budget expended N/A
$‐
$0.05
$0.10
$0.15
$0.20
$0.25
$0.30
Budget
Actual
Last Year
Page 31 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Museum Fund Budget
YTD
Actual
Annual %
over (under)
Jan 17,154 16,898 ‐1.49%
Feb 34,553 34,090 ‐1.34%
Mar 51,899
Apr 69,426
May 86,870
Jun 104,471
Jul 121,884
Aug 139,418
Sep 157,176
Oct 174,797
Nov 192,505
Dec 209,903
Percent of budget expended 16.24%
Public Works YTD Annual % $500 000
Public Works Admin
$‐
$30,000
$60,000
$90,000
$120,000
$150,000
$180,000
$210,000
$240,000
Museum Fund
Budget
Actual
Last Year
Admin Budget Actual over (under)
Jan 40,099 39,971 ‐0.32%
Feb 80,028 79,912 ‐0.14%
Mar 120,087
Apr 160,176
May 199,999
Jun 239,742
Jul 279,664
Aug 319,891
Sep 360,570
Oct 399,963
Nov 439,425
Dec 479,503
Percent of budget expended 16.67%
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
$350,000
$400,000
$450,000
$500,000
Budget
Actual
Last Year
Page 32 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Street
Maintenance Budget
YTD
Actual
Annual %
over (under)
Jan 331,018 302,270 ‐8.68%
Feb 709,001 641,518 ‐9.52%
Mar 1,070,183
Apr 1,395,959
May 1,744,116
Jun 2,113,626
Jul 2,468,605
Aug 2,807,231
Sep 3,152,161
Oct 3,507,148
Nov 3,871,466
Dec 4,264,927
Percent of budget expended 15.04%
YTD Annual %
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
Millions Street Maintenance
Budget
Actual
Last Year
$5 0
Millions Transportation
Transportation Budget Actual over (under)
Jan 296,445 311,908 5.22%
Feb 670,613 670,659 0.01%
Mar 1,044,165
Apr 1,419,142
May 1,784,680
Jun 2,142,993
Jul 2,535,555
Aug 2,903,068
Sep 3,277,488
Oct 3,661,441
Nov 4,042,797
Dec 4,531,004
Percent of budget expended 14.80%
$0.0
$0.5
$1.0
$1.5
$2.0
$2.5
$3.0
$3.5
$4.0
$4.5
$5.0
Budget
Actual
Last Year
Page 33 of 36
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Debt Service Budget
YTD
Actual
Annual %
over (under)
Jan ‐ ‐ N/A
Feb 250,317 250,317 0.00%
Mar 2,000,358
Apr 2,667,144
May 3,333,930
Jun 4,000,717
Jul 4,667,503
Aug 5,334,289
Sep 6,001,075
Oct 6,667,861
Nov 7,334,647
Dec 8,001,433
Percent of budget expended 3.13%
Non‐
Departmental YTD Annual % $5 00
Millions Non‐Departmental Other City Services
$‐
$1
$2
$3
$4
$5
$6
$7
$8
$9
$10
Millions Debt Service
Budget
Actual
Last Year
Other City Budget Actual over (under)
Jan 355,512 355,512 0.00%
Feb 862,677 862,677 0.00%
Mar 435,338
Apr 580,450
May 725,563
Jun 870,675
Jul 1,015,788
Aug 1,160,900
Sep 1,306,013
Oct 1,451,125
Nov 1,596,238
Dec 1,741,350
Percent of budget expended 49.54%
$‐
$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 ‐ 2013 Budget Year
Utilities Budget Revenue Expense
Jan 3,188,038 5,451,016 3,091,235
Feb 7,305,203 10,484,839 7,162,971
Mar 11,172,089
Apr 15,378,329
May 19,364,938
Jun 24,923,498
Jul 29,994,817
Aug 34,417,265
Sep 38,797,035
Oct 43,854,078
Nov 48,094,320
Dec 64,083,060
Percent of budget expended 9.23%
Note: Operations and Capital
$0
$10
$20
$30
$40
$50
$60
$70
Millions Utilities
Budget
Revenue
Expense
$14 00
Millions Airport
Airport Budget Revenue Expense
Jan 584,817 197,380 132,655
Feb 1,303,239 816,583 272,568
Mar 1,919,465
Apr 2,673,750
May 3,659,735
Jun 4,991,922
Jul 5,607,093
Aug 6,511,625
Sep 7,123,280
Oct 8,421,011
Nov 9,039,347
Dec 11,719,777
Percent of budget expended 2.33%
Note: Operations and Capital
$‐
$2.00
$4.00
$6.00
$8.00
$10.00
$12.00
$14.00
Budget
Revenue
Expense
Page 35 of 36
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2013 Budget Year
Golf Course Budget Revenue Expense
Jan 132,324 59,391 129,801
Feb 270,940 161,197 254,957
Mar 561,227
Apr 716,514
May 916,259
Jun 1,082,637
Jul 1,272,595
Aug 1,445,768
Sep 1,613,831
Oct 1,781,717
Nov 1,934,131
Dec 2,515,769
Percent of budget expended 10.13%
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