HomeMy WebLinkAbout201303, March.pdfADMINISTRATIVE SERVICES
DEPARTMENT
M E M O R A N D U M
DATE: April 24, 2013
TO: Randy Corman, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: March 2013 Financial Status Report
At the end of March, general governmental revenues show $508k or 3% over budget.
Revenues sources that are higher than expected are: sales tax ($376k); sales tax annexation
credit ($79k); REET ($57k), building permits & development service fees ($304k); state shared
revenues ($246k); interfund/inter‐departmental services ($125k); rents leases and concessions
($57k); and other miscellaneous ($74k). On the down side, the revenue sources that are
underperforming the year to date budget are: property taxes ($107k below); utility taxes
($527k below); gambling taxes ($77k below); culture & recreation ($56k) and seizure funds
($52k below).
General government expenditures showed unfavourable variance of $151k or 0.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 1,586,980 33,466,364 1,115,068 31,741,366 1,204,989 1,097,866 (107,123) ‐8.9%
Sales Tax 17,729,731 4,621,165 18,564,670 4,555,081 18,604,000 4,744,036 5,119,838 375,801 7.9%
Sales Tax ‐ Annexation Credit 2,033,954 515,376 2,208,492 548,776 2,119,680 526,708 605,458 78,750 15.0%
Criminal Justice Sales Tax 1,809,757 433,145 1,924,470 469,776 1,932,500 471,736 522,217 50,481 10.7%
Natural Gas Use Tax 249,407 81,939 272,530 135,319 300,000 98,561 83,570 (14,992) ‐15.2%
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 315,362 15,490 5.2%
Electricity Tax 5,166,711 1,471,764 5,211,111 1,522,488 5,468,000 1,597,541 1,367,581 (229,960) ‐14.4%
Natural Gas Utility Tax 1,848,806 743,650 1,669,967 698,786 1,656,000 692,941 581,317 (111,625) ‐16.1%
Transfer Station 297,474 62,236 330,607 66,603 300,000 60,437 99,887 39,450 65.3%
TV Cable 1,385,275 313,748 1,423,664 315,052 1,477,648 326,998 332,857 5,859 1.8%
Telephone 966,827 251,762 1,056,420 236,098 1,000,000 223,489 177,601 (45,888) ‐20.5%
Cellular Phone 2,054,183 534,865 2,183,853 563,415 2,200,000 567,581 389,133 (178,448) ‐31.4%
City Utilities 3,516,179 832,175 3,806,281 882,471 3,849,014 892,378 901,280 8,902 1.0%
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 389,297 1,691,209 418,076 1,600,000 395,528 318,528 (77,001) ‐19.5%
Real Estate Excise Tax 2,074,059 403,288 2,811,902 495,352 2,600,000 566,930 624,405 57,475 10.1%
Less: Municipal Facilities CIP REET (400,000) (72,016) (943,792) (97,847) (500,000) (120,083) (120,083) ‐ 0.0%
EMS Levy 868,873 ‐ 885,781 ‐ 900,000 ‐ ‐ ‐ 0.0%
Business License Fees 442,451 111,073 444,680 117,854 533,067 141,280 148,480 7,201 5.1%
Animal Licenses and Spec Events Permits 232,534 43,772 242,668 66,324 90,000 28,738 27,038 (1,701) ‐5.9%
Building Permits & Development Svc Fees 2,772,779 540,074 3,401,537 621,236 3,080,188 558,693 862,909 304,215 54.5%
Intergovt'l (Grants, State Shared, etc)4,737,323 936,670 4,593,185 767,775 2,670,330 1,054,229 1,249,516 195,287 18.5%
Fire District 25 and 40 Contracts 6,110,668 278,286 6,155,621 152,200 5,574,526 16,707 16,707 ‐ 0.0%
Public Safety 484,985 90,072 485,899 85,430 670,759 331,723 331,723 ‐ 0.0%
Culture and Recreation 1,493,540 243,967 1,494,165 226,174 1,633,486 247,263 191,197 (56,066) ‐22.7%
Interfund/Interdept‐Services 3,070,506 724,768 3,311,715 743,213 3,004,214 751,054 876,233 125,180 16.7%
Fines and Forfeits 1,163,602 218,547 1,046,246 181,611 1,108,500 191,357 213,349 21,992 11.5%
Photo Enforcement 1,897,782 527,825 1,976,203 475,558 1,950,000 469,253 462,103 (7,150) ‐1.5%
Seizure Funds ‐ Federal/State/Local 83,220 ‐ 37,941 11,738 180,693 55,902 3,491 (52,411) ‐93.8%
Interests and Other Earnings 107,183 17,599 342,424 20,892 645,300 39,371 18,593 (20,778) ‐52.8%
Rents, Leases, and Concessions 744,834 219,861 822,428 260,753 657,929 208,599 265,202 56,604 27.1%
Contributions and Donations 196,586 43,874 124,082 37,447 87,000 26,256 19,028 (7,228) ‐27.5%
Other Miscellaneous 529,147 74,534 564,571 119,752 516,369 115,909 190,133 74,224 64.0%
Other Financing Sources (Transfer‐In, etc) 1,073,507 3,175 5,118,188 5,494 250,000 268 6,974 6,706 2502.1%
Total Operating Revenues 100,476,431 16,654,842 108,457,170 16,218,914 99,613,569 16,883,784 17,392,180 508,395 3.0%
OPERATING EXPENDITURES
Council 271,236 67,521 278,768 68,811 289,114 71,664 72,806 (1,142) ‐1.6%
Executive 1,566,906 346,789 1,377,109 312,540 1,318,832 295,360 297,118 (1,758) ‐0.6%
Hearing Examiner 59,878 23,616 60,368 16,343 40,000 13,293 2,525 10,768 81.0%
City Attorney 1,596,609 395,280 1,706,320 419,219 1,872,973 461,873 427,953 33,920 7.3%
Court Services 2,084,170 490,833 2,074,980 504,905 2,009,664 481,131 468,698 12,434 2.6%
Community and Eco Dvlpmnt Admin 929,814 232,560 942,071 239,249 1,017,853 256,550 256,405 145 0.1%
Development Services 2,810,736 716,400 3,103,568 715,648 2,966,891 718,382 768,135 (49,753) ‐6.9%
Economic Development 659,981 175,015 529,043 149,151 546,986 149,126 109,135 39,991 26.8%
Planning 1,447,781 348,727 1,482,233 377,067 1,454,717 360,348 350,721 9,627 2.7%
Finance 2,134,667 467,036 2,221,882 476,115 1,952,608 422,721 437,042 (14,321) ‐3.4%
City Clerk 736,880 154,386 937,067 170,116 1,016,822 197,115 199,840 (2,725) ‐1.4%
Human Resources 888,252 221,683 937,412 227,236 971,207 238,813 212,385 26,429 11.1%
Police 24,737,346 6,305,557 25,004,580 6,012,336 24,833,698 6,149,718 6,243,286 (93,568) ‐1.5%
Jail Services 6,206,735 769,664 3,489,616 294,683 3,750,000 953,517 953,517 ‐ 0.0%
Fire 22,511,597 5,900,678 24,173,315 6,539,657 24,043,143 6,406,883 6,673,347 (266,464) ‐4.2%
Community Services Admin 416,284 102,208 434,558 108,727 448,556 111,203 111,667 (464) ‐0.4%
Parks 3,829,676 799,401 4,004,054 862,246 4,109,908 871,770 851,150 20,620 2.4%
Parks Planning & Natural Resources 551,423 109,668 577,934 124,284 662,852 137,313 142,461 (5,148) ‐3.7%
Recreation 4,974,002 1,058,705 4,982,229 999,673 5,070,152 1,048,217 1,002,907 45,309 4.3%
Human Services 1,247,294 177,533 1,193,871 266,033 1,124,509 204,326 218,002 (13,675) ‐6.7%
Neighborhoods, Resources, & Events 675,534 115,475 701,673 144,802 884,968 167,249 171,351 (4,101) ‐2.5%
Library 2,030,000 7,619 278,604 7,500 ‐ ‐ ‐ ‐ 0.0%
Museum 210,620 51,915 216,887 53,787 209,903 51,899 51,213 686 1.3%
Public Works Admin 452,538 111,889 470,051 119,164 479,503 120,087 119,866 220 0.2%
Street Maintenance 3,534,025 894,017 3,755,640 935,153 4,264,927 1,070,183 937,528 132,655 12.4%
Transportation 4,509,066 1,101,787 4,615,160 1,000,881 4,531,004 1,044,165 1,074,529 (30,364) ‐2.9%
Debt Service 4,822,566 390,380 9,752,337 250,317 8,001,433 250,317 250,317 ‐ 0.0%
Non‐Departmental and Other 4,930,383 1,784,740 4,637,555 886,227 1,741,350 1,009,438 1,009,438 ‐ 0.0%
Total Operating Expenditures 100,825,999 23,321,083 103,938,882 22,281,867 99,613,569 23,262,662 23,413,342 (150,680) ‐0.6%
Total Ending Fund Balance 11,057,551$ 4,740,878$ 15,575,840$ 4,994,598$ 10,751,945$ 4,373,067$ 9,554,677$ 5,181,610$ 118.5%
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 March 2013
Page 1 of 37
Monthly Financial Report March 2013
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through March 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
March’s collection is $918k,
making the total year‐to‐date
collection $1.1 million or 3.5% of
the total budget. In comparison to
the previous year, the City
collected $17k or 2% less.
Compared to the budget, the City
is below projections by $107k or
9%. 2013’s monthly budgets are
based on 2010 through 2012
collections. The City is projecting
property taxes to meet the budget
at year‐end.
Sales Tax
March 2013 sales tax receipts totalled
$1.5 million. Compared with the same
month last year, it is $233k or 18%
more. Compared to the projected
current month’s budget, it is $144k or
10% above. The year‐to‐date
collection of $5.1 million is $565k or
12% more than the prior year and is
also $376k or 8% 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 917,901 37,521 4% 169,966 23%
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 1,115,068$ 1,204,989$ 1,097,866$ (17,202)$ ‐2% (107,123)$ ‐9%
Annual Total 33,466,364$ 31,741,366$
Property Tax Revenues
Year to Date through March
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 1,536,397 232,577 18% 143,960 10%
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 4,555,081$ 4,744,036$ 5,119,838$ 564,756$ 12% 375,801$ 8%
Annual Total 18,564,670$ 18,604,000$
2013 vs. Budget2013 vs. 2012
Month
Year to Date through March
Local Retail Sales Tax Revenues
Page 2 of 37
Monthly Financial Report March 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 398,607$ 398,363$ 737,881$ 339,274$ 85%$ 339,518 85%
Auto Sales 800,860 812,063 866,045 65,185 8% 53,982 7%
General Retail 1,688,543 1,732,503 1,728,270 39,726 2% (4,233) 0%
Manufacturing 251,433 308,581 301,821 50,388 20% (6,760)‐2%
Wholesale 283,392 302,735 284,188 796 0% (18,547)‐6%
Service 1,046,461 1,090,655 1,061,981 15,520 1% (28,674)‐3%
Other 85,786 99,135 139,652 53,866 63% 40,517 41%
Total 4,555,081$ 4,744,036$ 5,119,838$ 564,756$ 12%375,801$ 8%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility tax
March utility tax revenues are $1.2
million, which is $245k or 17% lower
than the same month last year and is
also behind the budget by $275k or
19%. The year‐to‐date collection is
$3.9 million, which is $487k or 11%
lower than the prior year and is also
$527k or 12% lower than the budget.
The City is projecting utility tax
revenues to be under budget at year‐
end.
The table below breaks out Utility Tax by source. The Electrical/Natural Gas variance is due a change in the billing cycle for
industrial customers (which should catch up in the following months). Cell and Phone variances are due the timing of
receipts compared to 2012 (which should catch up at the end of the year).
Utility Tax by Type 2012 2013 Bgt YTD Act Change 2013/2012 2013 Act vs Bgt
Electrical 1,522,488$ 1,597,541$ 1,367,581$ (154,907)$ ‐10%$ (229,960)‐14%
Natural Gas 834,105 791,503 664,886 (169,219) ‐20% (126,616)‐16%
Cell 563,415 567,581 389,133 (174,282) ‐31% (178,448)‐31%
Phone 236,098 223,489 177,601 (58,497) ‐25% (45,888)‐21%
Cable 315,052 326,998 332,857 17,805 6% 5,859 2%
Transfer Station 66,603 60,437 99,887 33,284 50% 39,450 65%
City Utilities 882,471 892,378 901,280 18,809 2% 8,902 1%
YTD Total 4,420,232$ 4,459,927$ 3,933,225$ (487,007)$ ‐11%(526,702)$ ‐12%
Annual Total 15,954,432$ 16,250,662$
YTD as % of 28% 27%
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 1,469,178$ 1,494,708$ 1,277,860$ (191,318)$ ‐13% (216,848)$ ‐15%
Feb 1,512,539 1,497,446 1,462,236 (50,302) ‐3% (35,210) ‐2%
Mar 1,438,515 1,467,773 1,193,129 (245,387) ‐17% (274,644) ‐19%
Apr 1,384,240 1,412,358
May 1,394,109 1,423,158
Jun 1,108,588 1,140,870
Jul 1,340,939 1,370,103
Aug 1,153,724 1,180,346
Sep 1,301,158 1,332,309
Oct 1,126,772 1,153,538
Nov 1,196,932 1,213,641
Dec 1,527,740 1,564,412
YTD Total 4,420,232$ 4,459,927$ 3,933,225$ (487,007)$ ‐11% (526,702)$ ‐12%
Annual Total 15,954,432$ 16,250,662$
2013 vs . Budget2013 vs. 2012
Year to Date through March
Utility Tax Revenues
Month
Page 3 of 37
Monthly Financial Report March 2013
Other Taxes
Real Estate Excise Tax
The City collected $228k in Real Estate
Excise Tax revenues (REET) for March.
This is $24k or 12% ahead of the same
month last year and is right on target
with the current month’s budget. The
year‐to‐date collection is $624k, which is
$129k or 26% more than the prior year
and is also $57k or 10% above the
budget. The City is projecting REET to
meet the budget at year‐end.
Gambling Tax
March’s Gambling Tax collections
totalled $111k, which is $13k or
13% above the same month last
year and is also $18k or 20%
above the current month’s
budget. The tear‐to‐date total of
$319k is $100k or 24% below the
year before and is also $77k or
19% 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 20%
decrease, bingo decreased by
16%, and card‐rooms are seeing
36% lower in activities when
compared to the prior year.
Franchise Fees
Franchise Fees are due quarterly
and the year‐to‐date revenue
collections are $315k or 25% of
the budget. This is $15k 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$ 95,818$ 134,099$ 56,468$ 73% 38,281$ 40%
Feb 214,137 243,603 262,229 48,092 22% 18,627 8%
Mar 203,583 227,510 228,077 24,494 12% 568 0%
Apr 194,868 193,074
May 253,446 251,113
Jun 347,179 343,982
Jul 177,839 176,202
Aug 222,933 220,880
Sep 173,212 171,617
Oct 326,027 291,462
Nov 370,123 242,230
Dec 250,922 142,510
YTD Total 495,352$ 566,930$ 624,405$ 129,054$ 26% 57,475$ 10%
Annual Total 2,811,902$ 2,600,000$
Month
2013 vs. Budget2013 vs. 2012
Real Estate Excise Tax Revenues
Year to Date through March
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 111,294 13,014 13% 18,315 20%
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 418,076$ 395,528$ 318,528$ (99,548)$ ‐24% (77,001)$ ‐19%
Annual Total 1,691,209$ 1,600,000$
2013 vs. 2012 2013 vs. Budget
Gambling Tax Revenue
Month
Year to Date through March
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%
Mar ‐ ‐ 892 892 100% 892 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$ 315,362$ 14,969$ 5% 15,490$ 5%
Annual Total 1,262,188$ 1,260,000$
Franchise Fees Revenue
Year to Date through March
Month
2013 vs . 2012 2013 vs. Budget
Page 4 of 37
Monthly Financial Report March 2013
Admission Tax
Admission Tax returns are due
quarterly in January, April, July,
and October of 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 $305k in
March. The year‐to‐date development
fees revenue of $863k is $269k or 45%
more than the year before and is also
$304k or 54% higher than budget. The
higher than expected fees are due to
collecting more in general building
permits, electrical permits, street
excavations, 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 $12k for March,
which is $8k or 153% above the same month
last year and is also $7k or 111% above the
current month’s budget. The year‐to‐date
Business Licenses revenue of $148k is $31k or
26% above the prior year and is $7k or 5%
higher than 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 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 March
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 154,777$ 147,164$ 327,644$ 172,867$ 112% 180,481$ 123%
Feb 185,509 178,524 230,104 44,595 24% 51,580 29%
Mar 253,914 233,006 305,160 51,246 20% 72,154 31%
Apr 252,351 238,083
May 277,438 232,544
Jun 284,208 241,019
Jul 294,286 273,052
Aug 360,657 341,546
Sep 189,832 168,584
Oct 400,995 376,250
Nov 271,519 257,098
Dec 406,375 393,318
YTD Total 594,201$ 558,693$ 862,909$ 268,708$ 45% 304,215$ 54%
Annual Total 3,331,862$ 3,080,188$
Building Permits and Development Service Fees
Year to Date through March
2013 vs. Budget2013 vs. 2012
Month
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 12,441 7,515 153% 6,535 111%
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 117,854$ 141,280$ 148,480$ 30,626$ 26% 7,201$ 5%
Annual Total 444,680$ 533,067$
Business Licenses
Month
2013 vs. 2012
Year to Date through March
2013 vs. Budget
Page 5 of 37
Monthly Financial Report March 2013
Intergovernmental
These revenue sources
include federal (direct
and indirect) grants,
state grants, state
shared revenues, local
grants, and
entitlements. State
shared revenues and
Fire Districts’ 25 and 40
contracts compose 64%
of the total revenues in this category. The year‐to‐date total Intergovernmental revenue is $1.8 million or 18% of the
budget.
State Shared Revenues
State Shared Revenue
collections totalled $1.1 million
since the start of the year.
Compared to the prior year,
State Shared Revenues are
above by $50k or 5%.
Compared to the projected
budget, the City is collecting
$246k or 28% more. The
higher than expected
collection is due to collecting
more than anticipated Criminal
Justice Sales Tax, the low
budget of Criminal Justice’s High Crime and the higher than expected collections for Liquor Profits. 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 60% of the total revenue in this category. The year‐to‐date total charges for services are $1.8 million or 28% of
the budget. This is 15% above budget projections. The following sections provide detail information for Public Safety,
Recreation, and Interfund Services.
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 1,081,467 885,217 1,130,985 49,518 5% 245,768 28%
Federal Grants 77,003 505,125 505,125 428,121 556% (0) 0%
State Grants 30,646 10,373 10,373 (20,274) ‐66% (0) 0%
Other Grants/Intgovt 48,434 11,079 11,079 (37,355) ‐77%‐ 0%
ARRA Grants ‐ 114,171 114,171 114,171 100%‐ 0%
Total Rev YTD 1,389,752$ 1,542,672$ 1,788,440$ 398,689$ 29%245,768$ 16%
Total Rev Annual 12,673,276$ 10,177,356$
YTD %11% 15% 18%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
2012 2013 2013
Actual Budget Actual $ % $ %
Crim Just Sales Tax 469,776$ 471,736$ 522,217$ 52,442$ 11% 50,481$ 11%
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 123,076 84,809 211,723 88,646 72% 126,913 150%
Liquor Excise Tax 109,021 ‐ ‐ (109,021) 0%‐ N/A
Fuel Tax 298,472 296,551 309,969 11,497 4% 13,418 5%
YTD Total 1,081,467$ 885,217$ 1,130,985$ 49,518$ 5% 245,768$ 28%
Annual Total 4,825,202$ 4,208,000$
2013 vs. Budget
State Shared Revenues
2013 vs. 2012
Revenue
Year to Date through March
Page 6 of 37
Monthly Financial Report March 2013
Public Safety Services
Public Safety Services totalled $332k
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 collecting
$246k or 288% more. The City is right on
target with the year‐to‐date budget. The
City is projecting public safety services
revenues to meet the budget at year‐
end. The reason for the large favourable
variance with the prior year 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
$332k receipted for Public Safety Services, $228k is for intergovernmental.
Recreation
Recreation revenues totalled $79k for the
current month. Compared to the same
month the prior year, the City collected
$25k or 24% less. Compared to the
projected monthly budget, the City
collected $35k or 31% 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 $45k in the Recreation Division
of the Community Services Department.
Interfund Services
The year‐to‐date collections for Interfund
Services revenues are $876k. Compared
to the prior year, the revenues are over
by $133k or 18%. Compared to the
projected budget, the revenues are above
by $125k or 17%. 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, Parks Planning and
Natural Resources division’s capital
investment program reimbursements,
Transportation division’s capital
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 15,229$ 32,322$ 32,322$ 17,093$ 112%‐$ 0%
Feb 34,848 262,321 262,321 227,473 653%‐ 0%
Mar 35,353 37,079 37,079 1,726 5%‐ 0%
Apr 68,426 57,930 ‐
May 42,979 36,386 ‐
Jun 31,486 26,656 ‐
Jul 54,883 46,464 ‐
Aug 34,742 29,413 ‐
Sep 36,019 30,494 ‐
Oct 37,300 31,578 ‐
Nov 33,025 27,959 ‐
Dec 61,608 52,158 ‐
YTD Total 85,430$ 331,723$ 331,723$ 246,292$ 288%‐$ 0%
Annual Total 485,899$ 670,759$
Month
2013 vs. 2012
Year to Date through March
Public Safety Services
2013 vs. 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 51,160 (8,167) ‐14% (13,699) ‐21%
Mar 104,775 114,544 79,491 (25,283) ‐24% (35,053) ‐31%
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 226,174$ 247,263$ 191,197$ (34,976)$ ‐15% (56,066)$ ‐23%
Annual Total 1,494,165$ 1,633,486$
Recreation
Year to Date through March
2013 vs. Budget2013 vs. 2012
Month
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 237,384$ 250,351$ 265,873$ 28,489$ 12% 15,522$ 6%
Feb 234,758 250,351 292,362 57,604 25% 42,011 17%
Mar 271,071 250,351 317,998 46,927 17% 67,647 27%
Apr 253,070 250,351 ‐
May 291,941 250,351 ‐
Jun 275,112 250,351 ‐
Jul 217,828 250,351 ‐
Aug 345,690 250,351 ‐
Sep 273,570 250,351 ‐
Oct 338,304 250,351 ‐
Nov 276,902 250,351 ‐
Dec 296,085 250,351 ‐
YTD Total 743,213$ 751,054$ 876,233$ 133,020$ 18% 125,180$ 17%
Annual Total 3,311,715$ 3,004,214$
Interfund Services
Year to Date through March
2013 vs. 2012 2013 vs. Budget
Month
Page 7 of 37
Monthly Financial Report March 2013
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 $675k. This is $7k or 1%
higher than a year ago and is also $15k
or 2% above the budget. The City is
projecting fines and penalties to meet
the budget at year‐end.
Year to Date through March
2012 2013 2013
Actual Budget Actual $ % $ %
Civil Penalties 1,667$ 2,778$ 1,281$ (386)$ ‐23% (1,497)$ ‐54%
Civil Infraction Penalties 111,839 108,790 110,878 (961) ‐1% 2,088 2%
Civil Parking Infraction Penalties 24,788 28,047 32,564 7,776 31% 4,517 16%
Photo Enforcement Program 475,558 469,253 462,103 (13,456) ‐3% (7,150) ‐2%
Criminal Traffic Misdemeanor Fines 16,774 19,343 19,181 2,406 14% (162) ‐1%
Criminal Non‐Traffic Fines 4,364 7,973 4,938 575 13%(3,034) ‐38%
Criminal Costs 22,054 20,796 25,844 3,790 17% 5,048 24%
Seizure Funds ‐ Federal/State/Local1 11,738 ‐ ‐ (11,738) 0%‐ N/A
Non‐Court Fines, Forfeitures and Penalties 125 3,630 18,664 18,539 14831% 15,033 414%
YTD Total 668,907$ 660,610$ 675,452$ 6,545$ 1% 14,842$ 2%
Annual Total 3,060,389$ 3,058,500$
1Seizure Funds are categorized in Miscellaneous for 2013 and on.
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 $462k. 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
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 275,222 30,842 13% 28,259 11%
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 668,907$ 660,610$ 675,452$ 6,545$ 1% 14,842$ 2%
Annual Total 3,060,389$ 3,058,500$
2013 vs . Budget2013 vs. 2012
Year to Date through March
Fines and Penalties by Month
Month
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 152,959 74,226 60,184 92,775
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 469,253$ 462,103$ 223,263$ 180,723$ 281,380$
Annual Total 1,950,000$ 841,964$
1 Actuals of Revenues and Expenses
Revenues Expenses
Photo Enforcement Program
Year to Date through March
Month
Page 8 of 37
Monthly Financial Report March 2013
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 70%
of the total revenue in this category.
The year‐to‐date total miscellaneous is
$404k. Compared to last year, the
revenues are over by $10k or 2%.
Compared to the projected year‐to‐
date budget, the revenues are over by
$25k or 7%. The table below breaks out
miscellaneous revenues by type:
2012 2013 2013
Actual Budget Actual $ % $ %
Interests and Other Earnings 20,892$ 39,371$ 18,593$ (2,299)$ ‐11% (20,778)$ ‐53%
Rents, Leases, and Concessions 260,753 208,599 265,202 4,449 2% 56,604 27%
Contributions/Donations from Private Sources 37,447 26,256 19,028 (18,419) ‐49% (7,228) ‐28%
Other 75,302 48,540 97,734 22,432 30% 49,194 101%
Seizure Funds ‐ Federal/State/Local1 ‐ 55,902 3,491 3,491 100% (52,411) ‐94%
YTD Total 394,394$ 378,667$ 404,049$ 9,655$ 2% 25,382$ 7%
Annual Total 1,630,922$ 1,761,922$
1Seizure Funds are categorized in Miscellaneous for 2013 and on.
2013 vs. Budget
Miscellaneous Revenues by Type
Year to Date through March
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 and miscellaneous reimbursements for Fire.
Seizure funds are lower than the budget due to the timing of activity.
EXPENSES
Overall the City has expended 24% of its budgeted general governmental expenditures at the end of March. This is $151k
or 0.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 $1k or 1.6% due to overspending on travel, training,
meals and incidentals. We will monitor these items to determine if a budget amendment is needed at year‐end.
Administrative Services department is over the projected year‐to‐date budget by $17k or 2.8%. This is due to overspending
on professional services, travel, training, and miscellaneous. We will monitor these items to determine if a budget
amendment is needed at year‐end.
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 206,151$ 161,881$ 179,743$ (26,408)$ ‐13% 17,861$ 11%
Feb 83,823 130,300 76,397 (7,425) ‐9% (53,903) ‐41%
Mar 104,421 86,486 147,909 43,488 42% 61,423 71%
Apr 98,164 111,457
May 145,213 108,920
Jun 93,832 115,282
Jul 112,316 95,231
Aug 143,389 121,046
Sep 89,588 103,406
Oct 91,608 75,516
Nov 64,705 56,202
Dec 397,713 596,195
YTD Total 394,394$ 378,667$ 404,049$ 9,655$ 2% 25,382$ 7%
Annual Total 1,630,922$ 1,761,922$
Ye ar to Date through March
Month
2013 vs. Budget2013 vs. 2012
Miscellaneous Revenues by Month
Page 9 of 37
Monthly Financial Report March 2013
Police department is over the year‐to‐date budget by $94k or 1.5%. This is due to the timing of invoices for
intergovernmental services (Valley Communications Center) paid in 2013 compared to 2012.
Fire department is over the year‐to‐date budget by $266k or 4.2%. This is mainly due to over spending in salaries and
benefits ($84k), overtime ($65k), supplies ($80k), and intergovernmental ($24k). We will monitor these items to determine
if a budget amendment is needed at year‐end.
CASH AND INVESTMENTS – 1ST
QUARTER
The current cash and
investments (C&I) portfolio
is provided in the table to
the right. The City’s
current C&I balance is
$101 million, of this
amount; $1.2 million is an
interfund loan investment
(Res 4070) from the
insurance fund (502) to
the golf course fund (404).
This interfund loan is due
in full on December 1st
2015.
Currently the majority of
the portfolio is located in
cash deposits (US Bank).
The rest is spread out
between the State
Investment Pool, US Federal Agency Securities, various certificates of deposits, and the interfund loan.
The existing portfolio yield is approximately .58%. The majority (.38%) is within the cash at US Bank.
US Bank ‐Cash
57%
State Investment Pool
10%
US Federal Agency
Securities*
2%
Golf Course Interfund
Loan
1%
First Savings Bank
Northwest
10%
Columbia Bank
5%Fortune Bank (incl.
CDARS)
3%
Umpqua Bank
5%
Commencement Bank
(incl. CDARS)
7%
Commercial Paper
0%
Allocation by Institution
(show as a percent of the blended Portfolio)
Deposit Total Maturity Date APY Weighted Yield
Current
Allocation of Cash
and Investments
Allowed
by Policy
Current Principal
Balance
Cash US Bank ‐ Cash 58,040,257 overnight 0.45% 0.38%57%N/A 58,040,257
GOLF '13 375,000 12/1/2013 2.25% 0.03%
GOLF '14 395,000 12/1/2014 2.25% 0.03%
GOLF '15 410,000 12/1/2015 2.25% 0.03%
US Treasury Securities
none ‐ N/A N/A 0.00%0% 100%‐
Local Government Investment Pool
3920 State Investment Pool 9,916,523 4/1/2013 0.18% 0.03%10% 75%9,916,523
US Federal Agency Securities *
312159a FNMA (Callable) 2,500,000 4/17/2013 0.75% 0.06%2%
Certificates of Deposit
113154A First Savings Bank Northwest 5,000,000 2/4/2015 0.92% 0.14%
113164A First Savings Bank Northwest 5,000,000 2/4/2016 1.02% 0.15%
112147a Columbia Bank 2,768,975 1/11/2014 0.69% 0.06%
111167a Columbia Bank 2,015,400 11/9/2016 0.99% 0.06%
212145a Fortune Bank (CDARS) 1,516,108 6/14/2014 0.70% 0.03%
212145b Fortune Bank (CDARS) 1,000,685 12/18/2014 0.65% 0.02%
112145a Fortune Bank (traditional) 252,980 12/23/2014 0.85% 0.01%0% 20%
112146a Umpqua Bank 5,209,717 5/18/2014 0.85% 0.13%
211133a Commencement Bank (CDARS) 5,100,192 9/6/2013 1.00% 0.15%
111133a Commencement Bank (traditional)500,000 10/27/2013 1.00% 0.02%
212143a Commencement Bank (CDARS) 1,030,141 9/20/2014 0.65% 0.02%
Commercial Paper
none ‐ N/A N/A 0.00%0.00% 5%‐
TOTAL CASH & INVESTMENTS 101,030,977$ 101,030,977$
100%2,500,000
1,180,000
7% 20%6,630,333
20%3%
20%5%5,209,717
2,769,772
Institution
*Held in our safekeeping account at BNY Trust and Custody
Golf Interfund Loan
1% N/A
20%10%
20%5%
10,000,000
4,784,375
Page 10 of 37
Monthly Financial Report March 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 ‐ ‐ ‐ ‐ 12,472 8,479 ‐
Grants / intergovernmental 431,672 ‐ 104,987 ‐ ‐ 489,715 ‐
Charges for services 25,689 236,019 3,837,306 3,750,083 2,289,469 2,188,364 3,692,719
Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐
Fines and penalties 785 ‐ ‐ ‐ 67 ‐ ‐
Rents, leases, and misc fees 573,717 42,759 19,018 31,766 ‐ ‐ ‐
Interest and other misc 1,699 380 4,439 65,572 159,434 42,543 998
TOTAL REVENUES 1,033,562 279,158 3,965,750 3,847,421 2,461,442 2,729,101 3,693,717
EXPENSES:
Utility billing ‐ ‐ 28,842 27,649 20,861 33,810 ‐
Utility systems ‐ ‐ 2,854,301 768,375 688,660 606,267 ‐
Utility maintenance ‐ ‐ 69,800 1,135,300 296,190 506,612 3,564,805
Transportation 367,468 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 387,132 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 367,468 387,132 2,952,943 1,931,324 1,005,711 1,146,689 3,564,805
AMOUNT AVAILABLE FOR DEBT SERVICE 666,094 (107,974) 1,012,807 1,916,097 1,455,731 1,582,412 128,912
DEBT SERVICE:
Principal ‐ ‐ ‐ ‐ ‐ ‐ ‐
Interest ‐ ‐ ‐ ‐ ‐ ‐ ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ ‐ ‐ ‐ ‐
CAPITAL PROJECTS 184,472 4,387 ‐ 1,558,725 208,955 365,816 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ 7,526 (3,763) (3,763) ‐
CHANGE IN FUND BALANCE 481,622 (112,361) 1,012,807 364,898 1,243,013 1,212,833 128,912
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, Mar 31 2,824,546 427,453 2,536,688 10,211,206 4,439,747 7,227,307 1,874,799
Page 11 of 37
Monthly Financial Report March 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 Communication
s Insurance Healthcare Retiree
Healthcare
REVENUES:
Technology Fee ‐ 25,596 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ ‐ ‐ ‐ ‐ ‐ 32,467
Charges for services
Equipment rental m&o 689,805 763,428 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 28,106 ‐ 100,182 ‐ ‐ ‐
Communications ‐ 1,500 ‐ 127,250 ‐ ‐ ‐
Facilities ‐ ‐ 1,069,677 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 35,109 ‐ ‐ ‐ ‐ ‐
IT service contracts ‐ 109,670 ‐ ‐ ‐ ‐ ‐
Interest and other misc 2,280 1,124 565 180 2,522 4,911 3,749
Internal service fund misc:
Vehicle / equipment capital recovery 352,696 42,489 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 397,975 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 372,253 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 2,894,068 426,844
Other misc 134 50 8,895 ‐ 5 24,918 ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets 16,400 ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries 25,000 ‐ ‐ ‐ 36,756 5,651 ‐
TOTAL REVENUES 1,086,315 1,007,072 1,079,137 227,612 809,511 2,929,548 463,060
EXPENSES:
Communications 116,723
Equipment rental 518,334
Facilities 858,665
Healthcare 2,549,888
Information technology 770,767
Print and mail 89,767
Retiree healthcare 289,931
Risk management
Risk management 950,751
Unemployment 13,620
Worker's compensation 401,814
TOTAL EXPENSES 518,334 770,767 858,665 206,490 1,366,185 2,549,888 289,931
AMOUNT AVAILABLE FOR CAPITAL 567,981 236,305 220,471 21,122 (556,674) 379,660 173,129
CAPITAL PROJECTS 76,116 90,394 63,185 ‐ ‐ ‐ ‐
TRANSFERS IN ‐ ‐ 551 ‐ ‐ ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 491,865 145,911 157,837 21,122 (556,674) 379,660 173,129
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, Mar 31 4,214,366 2,002,883 1,007,309 324,599 4,430,133 8,278,730 6,655,294
Page 12 of 37
Monthly Financial Report March 2013
FUND BALANCE
Page 14 shows the ending fund balance as of March 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 March, the City has $9.6 million reported in the combined general governmental fund balance of the current
year’s operating budget, which is approximately 10% of budgeted operating expenditures. This is a decrease of $6 million
from the year’s beginning balance. March’s ending fund balance is over the anticipated General Governmental Fund
Balance of $4.4 million by $5.2 million or 118.5%. 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 13 of 37
Monthly Financial Report March 2013
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through March 31, 2013
Funds
Balance
01/01/2013
Budgeted
Revenue
Revenue
03/31/13
Total Funds
Available
Budgeted
Expenditure
Expenditure
03/31/13
Ending
Balance
GENERAL GOVERNMENT FUNDS:15,575,839 99,613,569 17,392,180 32,968,019 99,613,569 23,413,342 9,554,677
000 General 10,575,369 70,913,379 13,462,465 24,037,834 71,125,807 18,764,104 5,273,730
001 Community Services 1,891,966 11,239,691 1,842,371 3,734,337 11,095,120 2,273,049 1,461,288
003 Street 1,585,553 8,877,257 1,331,855 2,917,408 8,795,931 2,012,057 905,350
004 Community Dev Block Grant (13,145) 265,506 86,254 73,109 279,061 50,484 22,625
005 Museum 52,369 209,903 12 52,381 209,903 51,213 1,168
009 Farmers Market 90,520 81,400 7,924 98,444 81,314 6,486 91,958
011 Fire Health & Wellness 55,483 25,000 10,856 66,339 25,000 5,630 60,709
031 Park Memorial 178,367 ‐ 101 178,468 ‐ ‐ 178,468
201 Ltd GO Bonds Gen Govt Debt 829,784 1,749,305 487 830,271 1,749,305 ‐ 830,271
215 Gen Govt Misc Debt Service 329,573 6,252,128 649,855 979,428 6,252,128 250,317 729,110
SPECIAL REVENUE FUNDS:
102 Arterial Street 168,514 643,000 146,017 314,531 640,000 ‐ 314,531
108 Leased City Properties 527,677 797,289 126,128 653,805 749,656 114,523 539,282
110 Hotel Motel 111,256 245,000 99,142 210,398 245,000 36,755 173,643
125 1% For Art 116,142 15,000 66 116,208 50,000 ‐ 116,208
127 Cable Communication 257,372 85,674 53,967 311,339 85,674 20,544 290,795
135 Springbrook Wetlands Bank 665,828 ‐ 376 666,204 ‐ ‐ 666,204
CAPITAL PROJECT FUNDS (CIP):
303 Community Dev Mitigation 1,540,154 60,000 21,575 1,561,729 ‐ ‐ 1,561,729
304 Fire Mitigation 797,417 25,000 22,478 819,895 250,000 ‐ 819,895
305 Transportation Mitigation 292,627 40,000 53,213 345,840 183,000 ‐ 345,840
316 Municipal Facilities CIP 3,474,517 2,485,000 405,361 3,879,878 2,722,725 196,823 3,683,055
317 Transportation CIP (391,159) 25,258,120 3,411,264 3,020,105 25,257,711 5,023,870 (2,003,765)
318 So Lake WA Infrastructure Proj 52,073 ‐ 20 52,093 ‐ 53,523 (1,430)
326 Housing Opportunity 84,359 ‐ 59 84,418 ‐ ‐ 84,418
336 New Library Development 19,143,344 ‐ 10,724 19,154,068 ‐ 146,997 19,007,071
ENTERPRISE FUNDS:
402 Airport 331,939 1,408,843 600,647 932,586 1,379,685 367,468 565,118
403 Solid Waste Utility 1,523,881 15,700,852 3,965,751 5,489,632 16,170,067 2,952,943 2,536,689
404 Golf Course 291,978 2,453,669 279,014 570,992 2,465,769 402,187 168,805
422 Airport Capital 2,010,985 10,340,092 432,914 2,443,899 10,340,092 184,472 2,259,427
424 Golf Course Capital 247,836 50,000 12,641 260,477 50,000 1,830 258,647
INTERNAL SERVICE FUNDS:
501 Equipment Repair/Replacement 3,722,501 4,169,724 1,086,316 4,808,817 4,013,931 594,450 4,214,367
502 Insurance 4,986,807 3,713,764 809,510 5,796,317 3,058,068 1,366,185 4,430,132
503 Information Services 1,856,972 4,082,323 1,007,071 2,864,043 4,078,959 861,161 2,002,882
504 Facilities 849,472 4,276,112 1,079,688 1,929,160 4,230,522 921,850 1,007,310
505 Communications 303,477 877,773 227,612 531,089 886,184 206,490 324,599
512 Insurance, Healthcare 7,899,070 9,329,364 2,929,549 10,828,619 10,902,577 2,549,888 8,278,731
522 Insurance, Leoff1 Retirees HC 6,482,165 1,735,684 463,059 6,945,224 1,737,606 289,931 6,655,293
FIDUCIARY FUNDS:
611 Firemen's Pension 4,556,003 300,000 1,240 4,557,243 240,475 51,701 4,505,542
Funds
Balance
01/01/2013
Budgeted
Revenue
Revenue
03/31/13
Total Funds
Available
Budgeted
Expenditure
Expenditure
03/31/13
Ending
Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 20,803,403 52,161,152 12,739,208 33,542,611 47,912,993 9,789,552 23,753,059
405 Water Utility 5,449,029 12,668,096 2,900,195 8,349,224 10,994,985 1,942,614 6,406,610
406 Waste Water Utility 1,363,629 6,247,645 1,963,070 3,326,699 5,490,418 1,009,474 2,317,225
407 Surface Water Utility 2,269,771 7,934,708 2,005,546 4,275,317 6,116,887 1,150,453 3,124,864
416 King County Metro 1,745,887 15,126,703 3,693,718 5,439,605 15,126,703 3,564,805 1,874,800
425 Water Utility Construction 4,381,380 3,745,000 954,744 5,336,124 3,745,000 1,547,435 3,788,689
426 Waste Water Construction 1,833,105 3,250,000 498,371 2,331,476 3,250,000 208,955 2,122,521
427 Surface Water Construction 3,744,703 3,189,000 723,555 4,468,258 3,189,000 365,816 4,102,442
471 Waterworks Rate Stabilization 15,899 ‐ 9 15,908 ‐ ‐ 15,908
Note: Waterworks Utility Funds are managed as a system and are designated by the dotted lines.
Page 14 of 37
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 17,392,180 23,413,342 (6,021,162) 9,554,677
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 15 of 37
City of Renton
Monthly Revenue Analysis ‐ 2013 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 5,350,564 5,592,172 4.52%
Feb 11,525,209 11,590,564 0.57%
Mar 16,883,784 17,392,180 3.01%
Apr 31,153,743
May 45,185,830
Jun 50,240,758
Jul 56,182,296
Aug 61,206,488
Sep 66,293,936
Oct 79,788,210
Nov 93,243,035
Dec 99,613,569
Percent of budget 17.46%
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 1,097,866 ‐8.89%
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 3.46%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
$36
Budget
Actual
Last Year
Page 16 of 37
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 5,725,296 8.62%
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 27.63%
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,494,708 1,277,860 ‐14.51%
Feb 2,992,154 2,740,096 ‐8.42%
Mar 4,459,927 3,933,225 ‐11.81%
Apr 5,872,284
May 7,295,443
Jun 8,436,312
Jul 9,806,416
Aug 10,986,762
Sep 12,319,071
Oct 13,472,609
Nov 14,686,250
Dec 16,250,662
Percent of budget 24.20%
Note: Includes Natural Gas Use Tax.
$0
$2
$4
$6
$8
$10
$12
$14
$16
Budget
Actual
Last Year
Page 17 of 37
City of Renton
Monthly Revenue Analysis ‐ 2013 Budget Year
Licenses &
Permits Budget
YTD
Actual
Annual %
over (under)
Jan 219,087 325,005 48.34%
Feb 384,853 547,949 42.38%
Mar 574,699 747,996 30.15%
Apr 853,049
May 1,034,613
Jun 1,227,006
Jul 1,538,622
Aug 1,830,518
Sep 1,987,449
Oct 2,371,160
Nov 2,574,250
Dec 2,863,828
Percent of budget 26.12%
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 479,441 565,532 17.96%
Feb 1,232,413 1,321,568 7.23%
Mar 1,542,672 1,771,733 14.85%
Apr 2,409,017
May 4,717,382
Jun 5,303,462
Jul 5,718,316
Aug 6,179,298
Sep 6,646,414
Oct 7,809,889
Nov 10,108,746
Dec 10,177,356
Percent of budget 17.57%
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 18 of 37
City of Renton
Monthly Revenue Analysis ‐ 2013 Budget Year
Charges for
Services Budget
YTD
Actual
Annual %
over (under)
Jan 400,630 485,115 21.09%
Feb 1,060,073 1,196,439 12.86%
Mar 1,551,420 1,798,689 15.94%
Apr 2,118,856
May 2,647,247
Jun 3,172,983
Jul 3,870,948
Aug 4,536,972
Sep 4,986,282
Oct 5,506,028
Nov 5,964,758
Dec 6,473,255
Percent of budget 27.53%
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 675,452 2.25%
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 22.08%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Budget
Actual
Last Year
Page 19 of 37
City of Renton
Monthly Revenue Analysis ‐ 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 1,230,900 ‐0.72%
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 19.50%
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 161,881 179,743 11.03%
Feb 292,182 256,140 ‐12.34%
Mar 378,667 404,049 6.70%
Apr 490,124
May 599,045
Jun 714,327
Jul 809,557
Aug 930,604
Sep 1,034,009
Oct 1,109,525
Nov 1,165,727
Dec 1,761,922
Percent of budget 22.93%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80 Budget
Actual
Last Year
Page 20 of 37
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 6,974 2502.14%
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 624,405 36.33%
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 24.02%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
Millions
Budget
Actual
Last Year
Page 21 of 37
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 23,262,662 23,413,342 0.65%
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 23.50%
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 72,806 1.59%
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 25.18%
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
Budget
Actual
Last Year
Page 22 of 37
City of Renton
Monthly Expenditure Analysis ‐ 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 297,118 0.60%
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 22.53%
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 2,525 ‐81.01%
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 6.31%
$‐
$10,000
$20,000
$30,000
$40,000
$50,000
$60,000
Budget
Actual
Last Year
Page 23 of 37
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 427,953 ‐7.34%
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 22.85%
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 468,698 ‐2.58%
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 23.32%
$‐
$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 24 of 37
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 256,405 ‐0.06%
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 25.19%
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 768,135 6.93%
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 25.89%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions
Budget
Actual
Last Year
Page 25 of 37
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 109,135 ‐26.82%
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 19.95%
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 350,721 ‐2.67%
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 24.11%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
Millions
Budget
Actual
Last Year
Page 26 of 37
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 437,042 3.39%
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 22.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 122,708 ‐3.53%
Mar 197,115 199,840 1.38%
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 19.65%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Budget
Actual
Last Year
Page 27 of 37
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 212,385 ‐11.07%
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 21.87%
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,103,235 7,196,803 1.32%
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 25.18%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
Budget
Actual
Last Year
Page 28 of 37
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 6,673,347 4.16%
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 27.76%
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 111,667 0.42%
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 24.89%
$‐
$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 29 of 37
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 851,150 ‐2.37%
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 20.71%
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 142,461 3.75%
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 21.49%
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
$0.70
Budget
Actual
Last Year
Page 30 of 37
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 1,002,907 ‐4.32%
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 19.78%
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 218,002 6.69%
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 19.39%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Budget
Actual
Last Year
Page 31 of 37
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 171,351 2.45%
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 19.36%
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 ‐ ‐ N/A
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 32 of 37
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 51,213 ‐1.32%
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 24.40%
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 119,866 ‐0.18%
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 25.00%
$‐
$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 33 of 37
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 937,528 ‐12.40%
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 21.98%
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 1,074,529 2.91%
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 23.72%
$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 34 of 37
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 250,317 250,317 0.00%
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 1,009,438 1,009,438 0.00%
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 57.97%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00 Budget
Actual
Last Year
Page 35 of 37
City of Renton
Monthly Enterprise Fund Financial Report ‐ 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 16,704,949 12,742,494
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 23.68%
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 1,033,561 551,940
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 4.71%
Note: Operations and Capital
$‐
$2.00
$4.00
$6.00
$8.00
$10.00
$12.00
$14.00
Budget
Revenue
Expense
Page 36 of 37
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 291,654 404,017
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 16.06%
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 37 of 37