HomeMy WebLinkAbout201301, January.pdfADMINISTRATIVE SERVICES
DEPARTMENT
M E M O R A N D U M
DATE: March 8, 2013
TO: Randy Corman, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: January 2013 Financial Status Report
At the end of January, general governmental revenues show $364k or 7% over budget.
Revenues sources that are higher than expected are: sales tax ($194k); sales tax annexation
credit ($33k); REET ($38k), building permits & development service fees ($181k);
intergovernmental ($160k); interfund/inter‐departmental services ($51k); and rents leases and
concessions ($32k). On the down side, the revenue sources that are underperforming the year
to date budget are: property taxes ($64k below); utility taxes ($220k below); gambling taxes
($33k below); and fines and forfeitures ($29k below).
General government expenditures showed unfavourable variance of $263k or 3.6%. 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 505,501 33,466,36 4 149,112 31,741,366 218,452 154,945 (63,506) ‐29.1%
Sales Tax 17,729,731 1,339,658 18,564,670 1,327,548 18,604,000 1,426,729 1,620,555 193,826 13.6%
Sales Tax ‐ Annexation Credit 2,033,954 158,398 2,208,492 165,474 2,119,680 158,820 191,830 33,01 0 20.8%
Criminal Justice Sales Tax 1,809,757 132,724 1,924,470 145,992 1,932,500 146,601 166,533 19,932 13.6%
Natural Gas Use Tax 249,407 22,911 272,53 0 28,093 300,000 30,925 ‐ (30,925) ‐100.0%
Admission Tax 308,200 70,405 311,054 73,420 308,000 72,699 82,440 9,741 13.4%
Franchise Fees 1,234,448 305,646 1,262,188 300,392 1,260,000 299,872 314,269 14,397 4.8%
Electricity Tax 5,166,711 476,061 5,211,111 493,043 5,468,000 517,348 493,666 (23,683) ‐4.6%
Natural Gas Utility Tax 1,848,806 218,308 1,669,967 233,174 1,656,000 231,224 200,623 (30,601) ‐13.2%
Transfer Statio n 297,474 20,780 330,607 17,157 300,000 15,569 26,817 11,249 72.3%
TV Cable 1,385,275 118,469 1,423,664 118,851 1,477,648 123,358 125,429 2,072 1.7%
Telephone 966,827 73,415 1,056,420 75,154 1,000,000 71,141 23,518 (47,623) ‐66.9%
Cellular Phone 2,054,183 179,272 2,183,853 221,778 2,200,000 223,418 125,795 (97,623) ‐43.7%
City Utilities 3,516,179 253,808 3,806,281 281,927 3,849,014 285,092 282,011 (3,081) ‐1.1%
Leasehold Excise Tax 162,593 ‐ 158,849 ‐ 145,000 ‐ ‐ ‐ 0.0%
Gambling Excise Tax 1,671,414 118,304 1,691,209 175,959 1,600,000 166,470 133,504 (32,965) ‐19.8%
Real Estate Excise Tax 2,074,059 161,911 2,811,902 77,631 2,600,000 78,153 134,099 55,946 71.6%
Less: Munici pal Facilities CIP REE T (400,000) (28,006) (943,792) (15,335) (500,000) (8,124) (25,789) (17,665) 217.4%
EMS Levy 868,873 ‐ 885,781 ‐ 900,000 ‐ ‐ ‐ 0.0%
Business License Fees 442,451 84,109 444,680 88,676 533,067 106,302 95,381 (10,921) ‐10.3%
Other Licenses and Permits 232,534 14,017 242,668 23,034 ‐ ‐ ‐ ‐ 0.0%
Building Permits & Development Svc Fees 2,772,779 132,621 3,401,537 160,750 3,170,188 154,260 335,749 181,490 117.7%
Intergovt'l (Grants, State Shared, etc)4,737,323 431,946 4,593,185 305,199 2,670,330 259,349 398,999 139,649 53.8%
Fire District 25 and 40 Contracts 6,110,668 1,173 6,155,621 11,673 5,574,526 ‐ ‐ ‐ 0.0%
Public Safety 484,985 18,824 485,899 15,229 670,759 21,023 32,322 11,299 53.7%
Culture and Recreation 1,493,540 61,933 1,494,165 62,072 1,633,486 67,860 60,546 (7,314) ‐10.8%
Interfund/Interdept‐Services 3,070,506 190,881 3,311,715 237,384 3,004,214 215,343 265,873 50,531 23.5%
Fines and Forfeits 1,163,602 25 1,046,246 25 1,108,500 726 2,605 1,879 258.8%
Photo Enforcement 1,897,782 165,696 1,976,203 183,453 1,950,000 181,020 150,459 (30,561) ‐16.9%
Seizure Funds ‐ Federal/State/Local 83,220 ‐ 37,941 ‐ ‐ ‐ ‐ ‐ 0.0%
Interests and Other Earnings 107,183 5,160 342,42 4 3,560 645,300 6,708 2,727 (3,981) ‐59.3%
Rents, Leases, and Concessions 744,834 122,667 822,428 146,205 657,929 116,962 149,192 32,23 0 27.6%
Contributions and Donations 196,586 6,055 124,082 27,820 87,000 19,506 200 (19,306) ‐99.0%
Other Misc ellaneou s 52 9,147 16,337 564,571 34,684 697,062 21,280 47,872 26,591 125.0%
Other Financing Sources (Transfer‐In, etc) 1,073,507 ‐ 5,118,188 ‐ 250,000 ‐ ‐ ‐ 0.0%
Total Operating Revenues 100,476,431 5,379,006 108,457,170 5,169,136 99,613,569 5,228,084 5,592,172 364,089 7.0%
OPERATING EXPENDITURES
Council 271,236 22,021 278,768 21,995 289,114 23,137 23,354 (216) ‐0.9%
Executive 1,566,906 112,718 1,377,109 75,851 1,318,832 84,474 78,944 5,529 6.5%
Hearin g Examiner 59,878 14,189 60,368 1,731 40,000 5,296 ‐ 5,296 100.0%
City Attorney 1,596,609 130,446 1,706,320 136,926 1,872,973 151,617 141,744 9,873 6.5%
Court Services 2,084,170 163,613 2,074,980 166,993 2,009,664 159,746 152,280 7,466 4.7%
Community and Eco Dvlpmnt Admin 929,814 77,455 942,071 79,562 1,017,853 85,379 85,287 93 0.1%
Development Services 2,810,736 231,587 3,103,568 239,412 2,966,891 236,275 272,362 (36,087) ‐15.3%
Economic Development 659,981 67,025 529,043 46,930 546,986 52,423 75,717 (23,294) ‐44.4%
Planning 1,447,781 104,320 1,482,233 121,734 1,454,717 112,233 112,247 (14) 0.0%
Finance 2,134,667 155,421 2,221,882 152,157 1,952,608 137,857 144,010 (6,154) ‐4.5%
City Clerk 736,880 49,604 937,067 51,770 1,016,822 61,578 61,226 352 0.6%
Human Resources 888,252 86,565 937,412 69,265 971,207 82,898 64,230 18,667 22.5%
Police 24,737,346 2,232,881 25,004,580 1,904,823 24,833,698 2,065,752 2,204,160 (138,407) ‐6.7%
Jail Services 6,206,735 136,293 3,489,616 193 3,750,000 317,835 317,835 ‐ 0.0%
Fire 22,511,597 1,754,253 24,173,315 1,891,121 24,043,143 1,877,400 2,045,002 (167,602) ‐8.9%
Community Services Admi n 416,284 33,774 434,558 39,072 448,556 38,404 37,025 1,379 3.6%
Parks 3,829,676 261,191 4,004,054 274,545 4,109,908 281,070 269,811 11,259 4.0%
Parks Planning & Natural Resources 551,423 34,349 577,93 4 36,047 662,852 41,317 42,639 (1,322) ‐3.2%
Recreation 4,974,002 361,259 4,982,229 304,539 5,070,152 339,053 305,989 33,06 4 9.8%
Human Services 1,247,294 53,756 1,193,871 58,787 1,124,509 51,842 45,984 5,858 11.3%
Nei ghborhoods, Resources, & Events 675,534 37,850 701,673 46,222 884,968 54,023 56,917 (2,894) ‐5.4%
Library 2,030,000 2,619 278,604 2,500 ‐ ‐ ‐ ‐ 0.0%
Museum 210,620 17,146 216,887 17,791 209,903 17,154 16,898 256 1.5%
Public Works Admin 452,538 37,289 470,051 39,864 479,503 40,099 39,971 128 0.3%
Street Maintenance 3,534,025 279,841 3,755,640 285,940 4,264,927 331,018 302,270 28,748 8.7%
Transportation 4,509,066 308,560 4,615,160 288,400 4,531,004 296,445 311,908 (15,463) ‐5.2%
Debt Service 4,822,566 4,600 9,752,337 ‐ 8,001,433 ‐ ‐ ‐ 0.0%
Non ‐Departmental and Other 4,930,383 219,534 4,637,555 313,245 1,741,350 355,512 355,512 ‐ 0.0%
Total Operating Expenditures 100,825,999 6,990,159 103,938,882 6,667,414 99,613,569 7,299,837 7,563,322 (263,485) ‐3.6%
Total Ending Fund Balanc e 11,057,551$ 9,795,967$ 15,575,840$ 9,559,274$ 10,751,945$ 8,680,191$ 13,604,689$ 4,924,498$ 56.7%
Summary of Sources and Uses Annual Actual YTD Actual Favorable (Unfavorable)
2011 2012 2013 Variance
Annual Actual YTD Actual Annual Budget YTD Budget YTD Actual
Monthly Financial Report January 2013
Page 1 of 36
Monthly Financial Report January 2013
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through January 31, 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 69% 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 $155k, making
the total year‐to‐date collection
0.49% of the total budget. In
comparison to the previous year, the
City collected $6k or 4% more.
Compared to the budget, the City is
below projections by $64k or 29%.
2013’s monthly budgets are based on
2010 through 2012 collections.
Sales Tax
January 2013 sales tax receipts totalled
$1.6 million. Compared with the same
month last year, it is $293k or 22% more.
Compared to the projected current
month’s budget, it is $194k or 14% above.
The year‐to‐date collection is 9% of the
total sales tax budget.
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 149,112$ 218,452$ 154,945$ 5,834$ 4% (63,506)$ ‐29%
Feb 85,577 238,602
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 149,112$ 218,452$ 154,945$ 5,834$ 4% (63,506)$ ‐29%
Annual Total 33,466,364$ 31,741,366$
Property Tax Revenues
Year to Date through January
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 ‐
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 ‐
Sep 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 1,327,548$ 1,426,729$ 1,620,555$ 293,007$ 22% 193,826$ 14%
Annual Total 18,564,670$ 18,604,000$
2013 vs. Budget2013 vs. 2012
Month
Year to Date through January
Local Retail Sales Tax Revenues
Page 2 of 36
Monthly Financial Report January 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 Act Change 2013/2012 2013 Act vs Bgt
New Construction 142,780$ 128,300$ 250,801$ 108,021$ 76%$ 122,501 95%
Auto Sales 282,084 262,312 283,093 1,008 0% 20,780 8%
General Retail 532,447 540,266 538,390 5,943 1% (1,876) 0%
Manufacturing (59,726) 44,934 94,295 154,020 ‐258% 49,361 110%
Wholesale 81,319 88,073 90,636 9,316 11% 2,562 3%
Service 319,720 332,115 321,401 1,681 1% (10,715)‐3%
Other 28,923 30,727 41,939 13,016 45% 11,212 36%
Total 1,327,548$ 1,426,729$ 1,620,555$ 293,007$ 22%193,826$ 14%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
The negative amount for the Manufacturing sector (2012) is 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 32% above 2012 and 27% above our
monthly budget.
Utility tax
January utility tax revenues are $1.3
million, which is $191k or 13% lower
than the same month last year and is
also behind the budget by $220k or 15%.
The year‐to‐date collection is 8% the
total budget.
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 ($52k and $75k, respectively) of January’s receipts in
February.
Utility Tax by Type 2012 2013 Bgt YTD Act Change 2013/2012 2013 Act vs B gt
Electrical 493,043$ 517,348$ 493,666$ 623$ 0% $ (23,683)‐5%
Natural Gas 261,267 262,149 200,623 (60,645) ‐23% (61,526)‐23%
Cell 221,778 223,418 125,795 (95,983) ‐43% (97,623)‐44%
Phone 75,154 71,141 23,518 (51,637) ‐69% (47,623)‐67%
Cable 118,851 123,358 125,429 6,578 6% 2,072 2%
Transfer Station 17,157 15,569 26,817 9,661 56% 11,249 72%
City Utilities 281,927 285,092 282,011 84 0% (3,081)‐1%
YTD Total 1,469,178$ 1,498,074$ 1,277,860$ (191,318)$ ‐13%(220,215)$ ‐15%
Annual Total 15,954,432$ 16,250,662$
YTD as % of 9% 9%
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
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 1,469,178$ 1,498,074$ 1,277,860$ (191,318)$ ‐13% (220,215)$ ‐15%
Annual Total 15,954,432$ 16,250,662$
2013 vs. Budget2013 vs. 2012
Year to Da te through January
Utility Tax Revenues
Month
Page 3 of 36
Monthly Financial Report January 2013
Other Taxes
Real Estate Excise Tax
The City collected $134k in Real Estate
Excise Tax revenues (REET) for January.
This is $56k or 73% ahead of the same
month last year and is also $56k or 72%
above the current month’s budget. The
year‐to‐date collection is 5% of the total
budget.
Gambling Tax
January’s Gambling Tax collections
totalled $134k, which is 8% of the
total budget. This is $42k or 24%
below the same month last year and
is also $33k or 20% below the current
month’s budget. Pull tabs overall had
a 5% decrease, bingo increased by
21%, and card‐rooms are seeing 8%
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 $14k or 5% above the
projected year‐to‐date budget.
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 77,631$ 78,153$ 134,099$ 56,468$ 73% 55,946$ 72%
Feb 214,137 215,578
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 77,631$ 78,153$ 134,099$ 56,468$ 73% 55,946$ 72%
Annual Total 2,811,902$ 2,600,000$
Real Estate Excise Tax Revenues
Year to Date through January
Month
2013 vs. Budget2013 vs. 2012
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 175,959$ 166,470$ 133,504$ (42,455)$ ‐24% (32,965)$ ‐20%
Feb 143,837 136,080 ‐
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 175,959$ 166,470$ 133,504$ (42,455)$ ‐24% (32,965)$ ‐20%
Annual Total 1,691,209$ 1,600,000$
Year to Date through January
2013 vs. 2012 2013 vs. Budget
Gambling Tax Revenue
Month
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 300,392$ 299,872$ 314,269$ 13,877$ 5% 14,397$ 5%
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,269$ 13,877$ 5% 14,397$ 5%
Annual Total 1,262,188$ 1,260,000$
Month
2013 vs. 2012 2013 vs. Budget
Franchise Fees Revenue
Year to Date through January
Page 4 of 36
Monthly Financial Report January 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 report shows an increase of $9k or
12% from the year before and is also $10k
or 13% more than anticipated.
Licenses and Permits
Building Permits and Development Service Fees
Building Permits and Development
Service Fee revenues totalled $336k in
January, which is 8% of the total budget.
This is $175k or 109% more than the
prior year and is also $181k or 118%
higher than budget. The higher than
expected fees are due to collecting more
in general building permits, electrical
permits, and plan check fees.
Business Licenses
Business Licenses totalled $95k for January,
which is $7k or 8% above the same month last
year, but $11k or 10% below the current month’s
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 73,420$ 72,699$ 82,440$ 9,020$ 12% 9,741$ 13%
Annual Total 311,054$ 308,000$
Month
2013 vs. 2012 2013 vs. Budget
Admission Tax Revenue
Year to Date through January
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 88,676$ 106,302$ 95,381$ 6,705$ 8% (10,921)$ ‐10%
Feb 24,251 29,071 ‐
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 88,676$ 106,302$ 95,381$ 6,705$ 8% (10,921)$ ‐10%
Annual Total 444,680$ 533,067$
2013 vs. 2012
Ye a r to Date through January
2013 vs. Budget
Business Licenses
Month
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 160,750$ 154,260$ 335,749$ 174,999$ 109% 181,490$ 118%
Feb 197,549 192,175
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 160,750$ 154,260$ 335,749$ 174,999$ 109% 181,490$ 118%
Annual Total 3,401,537$ 3,170,188$
Building Permits and Development Service Fees
Year to Date through January
2013 vs. Budget2013 vs. 2012
Month
Page 5 of 36
Monthly Financial Report January 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 62%
of the total revenues in this
category. The year‐to‐date total Intergovernmental revenue is $566k or 6% of the budget.
State Shared Revenues
State Shared Revenue collections
totalled $351k since the start of
the year. Compared to the prior
year, State Shared Revenues are
below by $124k or 26%.
Compared to the projected
budget, the City is collecting $34k
or 11% more. The higher than
expected collection is due to 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 67% of the total revenue in this category. The year‐to‐date total charges for services are $485k or 7% of the
budget. This is 37% above budget projections. The following sections provide detail information for Public Safety,
Recreation, and Interfund Services.
Public Safety Services
Public Safety Services totalled $32k since
the start of the year. These services include
private security, adult probation services,
and monitoring of prisoners. Compared to
the prior year, the City is $17k or 112%
more. Compared to the budget, the City
has collected $11k or 54% more than the
anticipated revenue.
Intergovernmental 2012 2013 Bgt YTD Act Change 2013/2012 2013 Act vs Bgt
Fire District #25 ‐$ ‐$ ‐$ ‐$ N/A $ ‐ N/A
Fire District #40 11,673 ‐ ‐ (11,673) 0%‐ N/A
State Shared Revenue 475,186 316,875 351,205 (123,981) ‐26% 34,331 11%
Federal Grants 2,007 89,076 89,076 87,069 4338%‐ 0%
State Grants ‐ ‐ ‐ ‐ N/A ‐ N/A
Other Grants/Intgovt 26,094 ‐ 11,079 (15,014) ‐58% 11,079 100%
ARRA Gra nts ‐ ‐ 114,171 114,171 100% 114,171 100%
Total Rev YTD 514,960$ 405,950$ 565,532$ 50,572$ 10%159,581$ 39%
Total Rev Annual 12,673,276$ 10,177,356$
YTD % 4%4%6%
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 ‐
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 15,229$ 21,023$ 32,322$ 17,093$ 112% 11,299$ 54%
Annual Total 485,899$ 670,759$
Month
2013 vs . 2012
Year to Date through January
Public Safety Services
2013 vs. Budget
2012 2013 2013
Actual Budget Actual $ % $ %
Crim Just Sales Tax 145,992$ 146,601$ 166,533$ 20,541$ 14% 19,932$ 14%
Judicial Contribution ‐ ‐ ‐ ‐ N/A ‐ N/A
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 144,709 143,778 103,296 (41,414) ‐29% (40,482) ‐28%
YTD Total 475,186$ 316,875$ 351,205$ (123,981)$ ‐26% 34,331$ 11%
Annual Total 4,825,202$ 4,208,000$
Year to Date through January
State Shared Revenues
2013 vs. 2012
Revenue
2013 vs. Budget
Page 6 of 36
Monthly Financial Report January 2013
Recreation
Recreation revenues totalled $61k for the
current month. Compared to the same
month the prior year, the City collected $2k
or 2% less. Compared to the projected
monthly budget, the City collected $7k or
11% 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 $33k in the
Recreation Division of the Community
Services Department.
Interfund Services
The year‐to‐date collections for Interfund
Services revenues are $266k. Compared to
the prior year, the revenues are over by
$28k or 12%. Compared to the projected
budget, the revenues are above by $51k or
23%. 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
$153k. This is $30k or 17% lower than a
year ago and is also $29k or 16% under the
budget.
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 62,072$ 67,860$ 60,546$ (1,526)$ ‐2% (7,314)$ ‐11%
Feb 59,327 64,859 ‐
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 62,072$ 67,860$ 60,546$ (1,526)$ ‐2% (7,314)$ ‐11%
Annual Total 1,494,165$ 1,633,486$
Recreation
Year to Date through January
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 ‐
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 237,384$ 215,343$ 265,873$ 28,489$ 12% 50,531$ 23%
Annual Total 3,311,715$ 3,004,214$
2013 vs. Budget
Month
Interfund Services
Year to Date through January
2013 vs. 2012
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 183,478$ 181,746$ 153,064$ (30,413)$ ‐17% (28,682)$ ‐16%
Feb 241,050 231,901
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 183,478$ 181,746$ 153,064$ (30,413)$ ‐17% (28,682)$ ‐16%
Annual Total 3,060,389$ 3,058,500$
Month
2013 vs. Budget2013 vs. 2012
Year to Date through January
Fines and Penalties by Month
Page 7 of 36
Monthly Financial Report January 2013
Year to Date through January
2012 2013 2013
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 183,453 181,020 150,459 (32,994) ‐18% (30,561) ‐17%
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 726 2,605 2,580 10322% 1,879 259%
YTD Total 183,478$ 181,746$ 153,064$ (30,413)$ ‐17% (28,682)$ ‐16%
Annual Total 3,060,389$ 3,058,500$
2013 vs. 2012
Revenue
2013 vs. Budget
Fines and Penalties by Type
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 $150k. 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 85% of the
total revenue in this category. The year‐
to‐date total miscellaneous is $180k.
Compared to last year, the revenues are
under by $26k or 13%. Compared to the
projected year‐to‐date budget, the
revenues are over by $25k or 16%. 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 ‐ 74,412 ‐ ‐
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 181,020$ 150,459$ 74,626$ 60,422$ 90,037$
Annual Total 1,950,000$ 841,964$
1 Actuals of Revenues and Expenses
Expenses
Photo Enforcement Program
Year to Date through January
Month
Revenues
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 206,151$ 155,115$ 179,743$ (26,408)$ ‐13% 24,628$ 16%
Feb 83,823 70,460
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 206,151$ 155,115$ 179,743$ (26,408)$ ‐13% 24,628$ 16%
Annual Total 1,630,922$ 1,761,922$
Year to Date through January
Month
2013 vs. Budget2013 vs. 2012
Miscellaneous Revenues by Month
Page 8 of 36
Monthly Financial Report January 2013
2012 2013 2013
Actual Budget Actual $ % $ %
Interests and Other Earnings 3,560$ 6,708$ 2,727$ (833)$ ‐23% (3,981)$ ‐59%
Rents, Leases, and Concessions 146,205 116,962 149,192 2,987 2% 32,230 28%
Contributions/Donations from Private Sources 27,820 19,506 200 (27,620) ‐99% (19,306) ‐99%
Other 28,566 11,939 27,624 (943) ‐3% 15,684 131%
YTD Total 206,151$ 155,115$ 179,743$ (26,408)$ ‐13% 24,628$ 16%
Annual Total 1,630,922$ 1,761,922$
2013 vs. Budget
Miscellaneous Revenues by Type
Year to Date through January
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 8% of its budgeted general governmental expenditures at the end of January. This is $263k
or 3.6% 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 $216 or 0.9% 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 $59k or 12.2%. This is
due to a correction in recording a vacation payout that will be fixed in February and limited term construction inspectors’
budgets that will need to be carry forward from 2012.
Administrative Services department is over the year‐to‐date budget by $6k or 2.9%. This is due to the timing of professional
services payments in the Finance division compared to 2012. Overall professional budget will correct itself later on in the
year.
Police department is over the year‐to‐date budget by $138k or 6.7%. This is due to the timing of Valley Communications
Center payment made in 2013 compared to 2012. Overall intergovernmental budget will correct itself later on in the year.
Fire department is over the year‐to‐date budget by $168k or 8.9%. This is due to over spending in salaries and benefits
($33k), overtime ($51k), supplies ($14k), professional services ($28k), and intergovernmental ($36k). We will monitor these
items to determine if a budget amendment is needed at year‐end.
Page 9 of 36
Monthly Financial Report January 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 ‐ ‐ ‐ ‐ 3,013 2,263 ‐
Grants / intergovernmental ‐ ‐ ‐ ‐ ‐ 26,226 ‐
Charges for services 7,155 44,321 1,327,078 1,237,915 776,543 779,406 1,230,573
Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐
Fines and penalties ‐ ‐ ‐ ‐ 19 ‐ ‐
Rents, leases, and misc fees 189,775 10,771 6,339 9,742 ‐ ‐ ‐
Interest and other misc 450 136 3,469 7,041 25,438 8,100 326
TOTAL REVENUES 197,380 55,228 1,336,887 1,254,698 805,013 815,995 1,230,899
EXPENSES:
Utility billing ‐ ‐ 8,027 9,512 5,351 8,027 ‐
Utility systems ‐ ‐ 536,389 237,190 225,543 202,272 ‐
Utility maintenance ‐ ‐ 22,490 302,613 91,528 141,219 1,188,268
Transportation 123,790 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 124,502 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 123,790 124,502 566,906 549,315 322,422 351,518 1,188,268
AMOUNT AVAILABLE FOR DEBT SERVICE 73,590 (69,274) 769,981 705,383 482,591 464,477 42,631
DEBT SERVICE:
Principal ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest ‐ ‐ ‐ ‐ ‐ ‐ ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ ‐ ‐ ‐ ‐
CAPITAL PROJECTS 8,866 1,136 ‐ 49,014 8,444 47,821 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ 7,526 (3,763) (3,763) ‐
CHANGE IN FUND BALANCE 64,724 (70,410) 769,981 663,895 470,384 412,893 42,631
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, Jan 31 2,407,648 469,404 2,293,862 10,510,203 3,667,118 6,427,367 1,788,518
Page 10 of 36
Monthly Financial Report January 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
Technolo gy Facilities Communication
s Insurance Healthcare
Retiree
Healthcare
REVENUES:
Technology Fee ‐ 9,514 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ ‐ ‐ ‐ ‐ ‐ ‐
Charges for services
E quipment rental m&o 216,046 254,468 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 9,372 ‐ 33,404 ‐ ‐ ‐
Communications ‐ 1,500 ‐ 47,730 ‐ ‐ ‐
Facilities ‐ ‐ 356,553 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 11,709 ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ 36,522 ‐ ‐ ‐ ‐ ‐
Interest and other misc 70 5 373 181 59 776 1,631 1,211
Internal service fund misc:
Vehicle / equipment capital recovery 117,56 4 14,153 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 133,087 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 124,026 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 965,940 142,276
Other misc ‐ 50 1,561 ‐ ‐ 6,570 ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets ‐ ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries ‐ ‐ ‐ ‐ 11,812 ‐ ‐
TOTAL REVENUES 334,31 5 337,661 358,295 81,193 269,701 974,141 143,487
EXPENSES:
Communications 38,514
Equipment rental 155,00 5
Facilities 224,559
Healthcare 756,064
Information technology 239,288
Print and mail 25,561
Retiree healthcare 60,545
Risk management
Risk management 792,223
Unemployment 13,620
Worker's compensation 143,784
TOTAL EXPENSES 155,005 239,288 224,559 64,075 949,627 756,064 60,545
AMOUNT AVAILABLE FOR CAPITAL 179,310 98,373 133,736 17,118 (679,926) 218,077 82,942
CAPITAL PROJECTS 66,671 7,883 (3,873) ‐ ‐ ‐ ‐
TRANSFERS IN ‐ ‐ ‐ ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 112,63 9 90,490 137,609 17,118 (679,926) 218,077 82,942
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, Jan 31 3,835,140 1,947,462 987,081 320,595 4,306,881 8,117,147 6,565,107
Page 11 of 36
Monthly Financial Report January 2013
FUND BALANCE
Page 13 shows the ending fund balance as of January 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 January, the City has $13.6 million reported in the combined general governmental fund balance of the
current year’s operating budget, which is approximately 14% of budgeted operating expenditures. This is a decrease of $2
million from the year’s beginning balance. January’s ending fund balance is over the anticipated General Governmental
Fund Balance of $8.7 million by $4.9 million or 56.7%. 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 January 2013
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through January 31, 2013
Funds
Balance
01/01/2013
Budgeted
Revenue
Revenue
01/31/13
Total Funds
Available
Budgeted
Expenditure
Expenditure
01/31/13
Ending
Balance
GENERAL GOVERNMENT FUNDS:15,575,839 99,613,569 5,592,172 21,168,011 99,613,569 7,563,322 13,604,689
000 General 10,575,369 70,913,379 4,293,138 14,868,507 71,125,807 6,205,757 8,662,750
001 Community Services 1,891,966 11,239,691 706,900 2,598,866 11,095,120 706,316 1,892,551
003 Street 1,585,553 8,877,257 390,561 1,976,114 8,795,931 614,178 1,361,936
004 Community Dev Block Grant (13,145) 265,506 86,254 73,109 279,061 13,369 59,740
005 Museum 52,369 209,903 6 52,375 209,903 16,898 35,477
006 Library ‐ ‐ ‐ ‐ ‐ ‐ ‐
009 Farmers Market 90,520 81,400 15 90,535 81,314 6,066 84,470
010 Fire Memorial ‐ ‐ ‐ ‐ ‐ ‐ ‐
011 Fire Health & Wellness 55,483 25,000 6,723 62,206 25,000 738 61,468
031 Park Memorial 178,367 ‐ 33 178,400 ‐ ‐ 178,400
201 Ltd GO Bonds Gen Govt Debt 829,784 1,749,305 151 829,935 1,749,305 ‐ 829,935
215 Gen Govt Misc Debt Service 329,573 6,252,128 108,390 437,963 6,252,128 ‐ 437,963
SPECIAL REVENUE FUNDS:
102 Arterial Street 168,514 643,000 48,649 217,163 640,000 ‐ 217,163
108 Leased City Properties 527,677 797,289 20,532 548,209 749,656 13,443 534,766
110 Hotel Motel 111,256 245,000 31,318 142,574 245,000 12,308 130,266
118 Reserve for Paths & Trails ‐ ‐ ‐ ‐ ‐ ‐ ‐
125 1% For Art 116,142 15,000 21 116,163 50,000 ‐ 116,163
127 Cable Communication 257,372 85,674 13,857 271,229 85,674 ‐ 271,229
135 Springbrook Wetlands Bank 665,828 ‐ 122 665,950 ‐ ‐ 665,950
DEBT SERVICE FUNDS:
219 1989 Unlimited GO Bonds ‐ ‐ ‐ ‐ ‐ ‐ ‐
CAPITAL PROJECT FUNDS (CIP):
303 Community Dev Mitigation 1,540,154 60,000 1,343 1,541,497 ‐ ‐ 1,541,497
304 Fire Mitigation 797,417 25,000 1,122 798,539 250,000 ‐ 798,539
305 Transportation Mitigation 292,627 40,000 1,489 294,116 183,000 ‐ 294,116
316 Municipal Facilities CIP 3,474,517 2,485,000 155,372 3,629,889 2,722,725 19,120 3,610,769
317 Transportation CIP (391,159) 25,258,120 407,617 16,458 25,257,711 68,110 (51,652)
318 So Lake WA Infrastructure Proj 52,073 ‐ 9 52,082 ‐ 198 51,884
326 Housing Opportunity 84,359 ‐ 15 84,374 ‐ ‐ 84,374
336 New Library Development 19,143,344 ‐ 3,493 19,146,837 ‐ 20,192 19,126,645
ENTERPRISE FUNDS:
402 Airport 331,939 1,408,843 197,013 528,952 1,379,685 123,790 405,162
403 Solid Waste Utility 1,523,881 15,700,852 1,336,887 2,860,768 16,170,067 566,906 2,293,862
404 Golf Course 291,978 2,453,669 55,183 347,161 2,465,769 128,665 218,496
422 Airport Capital 2,010,985 10,340,092 367 2,011,352 10,340,092 8,866 2,002,486
424 Golf Course Capital 247,836 50,000 4,209 252,045 50,000 1,136 250,909
INTERNAL SERVICE FUNDS:
501 Equipment Repair/Replacement 3,722,501 4,169,724 334,316 4,056,817 4,013,931 221,676 3,835,141
502 Insurance 4,986,807 3,713,764 269,701 5,256,508 3,058,068 949,627 4,306,881
503 Information Services 1,856,972 4,082,323 337,661 2,194,633 4,078,959 247,171 1,947,462
504 Facilities 849,472 4,276,112 358,295 1,207,767 4,230,522 220,686 987,081
505 Communications 303,477 877,773 81,193 384,670 886,184 64,075 320,595
512 Insurance, Healthcare 7,899,070 9,329,364 974,141 8,873,211 10,902,577 756,064 8,117,147
522 Insurance, Leoff1 Retirees HC 6,482,165 1,735,684 143,487 6,625,652 1,737,606 60,545 6,565,107
FIDUCIARY FUNDS:
611 Firemen's Pension 4,556,003 300,000 406 4,556,409 240,475 17,234 4,539,175
Funds
Balance
01/01/2013
Budgeted
Revenue
Revenue
01/31/13
Total Funds
Available
Budgeted
Expenditure
Expenditure
01/31/13
Ending
Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 20,803,403 52,161,152 4,114,132 24,917,535 47,912,993 2,524,329 22,393,206
405 Water Utility 5,449,029 12,668,096 1,256,376 6,705,405 10,994,985 560,605 6,144,800
406 Waste Water Utility 1,363,629 6,247,645 779,925 2,143,554 5,490,418 326,186 1,817,368
407 Surface Water Utility 2,269,771 7,934,708 784,333 3,054,104 6,116,887 355,281 2,698,823
416 King County Metro 1,745,887 15,126,703 1,230,900 2,976,787 15,126,703 1,188,268 1,788,519
425 Water Utility Construction 4,381,380 3,745,000 5,846 4,387,226 3,745,000 37,724 4,349,502
426 Waste Water Construction 1,833,105 3,250,000 25,088 1,858,193 3,250,000 8,444 1,849,749
427 Surface Water Construction 3,744,703 3,189,000 31,661 3,776,364 3,189,000 47,821 3,728,543
471 Waterworks Rate Stabilization 15,899 ‐ 3 15,902 ‐ ‐ 15,902
461 Waterworks Bond Reserve ‐ ‐ ‐ ‐ ‐ ‐ ‐
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
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
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,228,084 5,592,172 6.96%
Feb 10,918,069
Mar 16,298,149
Apr 30,621,991
May 44,550,349
Jun 49,585,315
Jul 55,506,284
Aug 60,611,353
Sep 65,677,541
Oct 79,244,344
Nov 92,691,567
Dec 99,613,569
Percent of budget 5.61%
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
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.49%
$‐
$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
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 8.75%
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
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 7.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
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 11.35%
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 405,950 565,532 39.31%
Feb 936,846
Mar 1,268,497
Apr 2,120,412
May 4,277,025
Jun 4,854,646
Jul 5,262,707
Aug 5,716,650
Sep 6,182,695
Oct 7,328,769
Nov 9,575,409
Dec 10,177,356
Percent of budget 5.56%
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
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 7.49%
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
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 5.00%
$‐
$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
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 10.11%
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
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 10.20%
$‐
$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
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 0.00%
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
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 5.16%
$‐
$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 16,423,750
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 7.59%
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
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 8.08%
$‐
$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
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 5.99%
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
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 0.00%
$‐
$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
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 7.57%
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
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 7.58%
$‐
$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
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 8.38%
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
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 9.18%
$‐
$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
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 13.84%
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
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 7.72%
$‐
$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
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 7.38%
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
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 6.02%
$‐
$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
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 6.61%
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,722,142
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 8.82%
$‐
$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
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 8.51%
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
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 8.25%
$‐
$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
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 6.56%
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
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 6.43%
$‐
$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
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 6.04%
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
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 4.09%
$‐
$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
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 6.43%
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 ‐
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
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 8.05%
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
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 8.34%
$‐
$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
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 7.09%
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
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 6.88%
$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 1,333,572
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 0.00%
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 290,225
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 20.42%
$‐
$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
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 4.06%
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
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 1.13%
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
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 5.16%
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