HomeMy WebLinkAbout201306, June.pdfADMINISTRATIVE SERVICES
DEPARTMENT
M E M O R A N D U M
DATE: July 25, 2013
TO: Randy Corman, Council President
Members of the Renton City Council
CC: Denis Law, Mayor
Administrators
FROM: Hai Nguyen, Sr. Finance Analyst
SUBJECT: June 2013 Financial Status Report
At the end of June, general governmental revenues show $1.6 million or 3.1% over budget.
Revenues sources that are higher than expected are: property tax ($319k); sales tax ($640k);
sales tax annexation credit ($141k); building permits & development service fees ($624k); state
shared revenues ($290k); interfund services ($95k); rents, leases, and concessions ($85k); and
other miscellaneous ($113k). On the down side, the revenue sources that are underperforming
the year to date budget are: utility taxes ($429k below); gambling taxes ($124k below);
culture/recreation ($98k below) and seizure funds ($87k below).
General government expenditures showed a favorable variance of $947k or 1.9%. See page 10
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$ 15,575,839$ 15,575,839$ 15,575,839$ ‐ 0.0%
OPERATING REVENUES
Property Tax 32,357,894 17,109,916 33,466,364 17,301,729 31,741,366 16,534,715 16,854,032 319,317 1.9%
Sales Tax 17,729,731 8,835,025 18,564,670 9,007,790 18,604,000 9,274,866 9,914,656 639,790 6.9%
Sales Tax ‐ Annexation Credit 2,033,954 995,394 2,208,492 1,075,526 2,119,680 1,032,274 1,173,493 141,218 13.7%
Criminal Justice Sales Tax 1,809,757 888,626 1,924,470 910,648 1,932,500 914,448 1,000,904 86,457 9.5%
Natural Gas Use Tax 249,407 159,509 272,530 204,786 300,000 191,866 151,197 (40,669) ‐21.2%
Admission Tax 308,200 134,870 311,054 154,705 308,000 153,186 152,751 (435) ‐0.3%
Franchise Fees 1,234,448 600,206 1,262,188 599,927 1,260,000 598,887 627,348 28,461 4.8%
Electricity Tax 5,166,711 2,701,582 5,211,111 2,760,541 5,468,000 2,896,626 2,705,889 (190,737) ‐6.6%
Natural Gas Utility Tax 1,848,806 1,253,927 1,669,967 1,130,252 1,656,000 1,120,799 1,015,621 (105,178) ‐9.4%
Transfer Station 297,474 123,452 330,607 147,380 300,000 133,736 195,483 61,747 46.2%
TV Cable 1,385,275 668,805 1,423,664 678,526 1,477,648 704,255 712,128 7,873 1.1%
Telephone 966,827 492,589 1,056,420 472,440 1,000,000 447,208 410,588 (36,620) ‐8.2%
Cellular Phone 2,054,183 1,067,301 2,183,853 1,076,921 2,200,000 1,084,884 912,334 (172,550) ‐15.9%
City Utilities 3,516,179 1,690,696 3,806,281 1,836,322 3,849,014 1,856,938 1,904,012 47,074 2.5%
Leasehold Excise Tax 162,593 82,413 158,849 80,019 145,000 73,043 82,442 9,399 12.9%
Gambling Excise Tax 1,671,414 862,008 1,691,209 803,034 1,600,000 759,725 635,917 (123,807) ‐16.3%
Real Estate Excise Tax 2,074,059 900,300 2,811,902 1,290,845 2,600,000 1,444,441 1,455,902 11,461 0.8%
Less: Municipal Facilities CIP REET (400,000) (160,768) (943,792) (254,982) (500,000) (279,995) (279,995) ‐ 0.0%
EMS Levy 868,873 ‐ 885,781 221,445 900,000 229,090 229,090 ‐ 0.0%
Business License Fees 442,451 219,109 444,680 212,880 533,067 255,193 290,183 34,990 13.7%
Animal Licenses and Spec Events Permits 232,534 96,739 242,668 112,697 90,000 51,637 52,903 1,266 2.5%
Building Permits & Development Svc Fees 2,772,779 1,185,601 3,401,537 1,457,045 3,123,413 1,288,368 1,912,104 623,736 48.4%
Intergovt'l (Grants, State Shared, etc) 4,737,323 1,845,254 4,593,185 2,012,340 3,469,005 1,721,976 1,925,151 203,175 11.8%
Fire District 25 and 40 Contracts 6,110,668 3,037,491 6,155,621 3,001,928 5,574,526 2,649,073 2,649,073 ‐ 0.0%
Public Safety 484,985 224,410 485,899 228,321 670,759 480,661 480,661 ‐ 0.0%
Culture and Recreation 1,493,540 675,880 1,494,165 651,581 1,618,486 705,796 607,732 (98,063) ‐13.9%
Interfund/Interdept‐Services 3,070,506 1,427,844 3,311,715 1,563,336 3,313,830 1,656,915 1,752,065 95,150 5.7%
Fines and Forfeits 1,163,602 524,488 1,046,246 455,531 1,108,500 486,708 519,031 32,324 6.6%
Photo Enforcement 1,897,782 1,038,171 1,976,203 1,091,249 1,950,000 1,076,780 1,022,773 (54,007) ‐5.0%
Seizure Funds ‐ Federal/State/Local 83,220 ‐ 37,941 25,614 180,693 121,985 34,567 (87,419) ‐71.7%
Interests and Other Earnings 107,183 49,324 342,424 49,775 745,300 108,338 52,161 (56,177) ‐51.9%
Rents, Leases, and Concessions 744,834 401,045 822,428 449,066 650,929 355,423 440,405 84,982 23.9%
Contributions and Donations 196,586 81,792 124,082 70,614 93,100 52,983 43,186 (9,797) ‐18.5%
Other Miscellaneous 529,147 207,039 564,571 264,438 516,369 245,465 358,563 113,098 46.1%
Other Financing Sources (Transfer‐In, etc) 1,073,507 168,166 5,118,188 144,143 250,000 7,040 13,343 6,303 89.5%
Total Operating Revenues 100,476,431 49,588,204 108,457,170 51,288,412 100,849,185 50,435,331 52,007,692 1,572,361 3.1%
OPERATING EXPENDITURES
Council 271,236 134,795 278,768 138,621 290,291 144,309 145,113 (804) ‐0.6%
Executive 1,566,906 729,119 1,377,109 660,020 1,322,364 623,960 614,036 9,924 1.6%
Hearing Examiner 59,878 33,294 60,368 30,050 40,000 21,071 8,966 12,106 57.5%
City Attorney 1,596,609 790,004 1,706,320 844,781 1,915,103 947,880 872,824 75,056 7.9%
Court Services 2,084,170 1,040,289 2,074,980 1,045,629 2,026,149 1,016,165 978,124 38,041 3.7%
Community and Eco Dvlpmnt Admin 929,814 465,217 942,071 476,538 1,020,208 513,272 514,481 (1,209) ‐0.2%
Development Services 2,810,736 1,431,566 3,103,568 1,465,542 3,308,299 1,620,563 1,589,997 30,566 1.9%
Economic Development 659,981 333,750 529,043 271,554 570,280 290,316 211,913 78,402 27.0%
Planning 1,447,781 685,502 1,482,233 738,072 1,541,592 748,996 728,944 20,052 2.7%
Finance 2,134,667 930,622 2,221,882 995,643 2,242,682 991,610 942,750 48,861 4.9%
City Clerk 736,880 420,930 937,067 343,072 1,061,505 484,479 627,223 (142,743) ‐29.5%
Human Resources 888,252 417,784 937,412 459,361 977,094 469,447 439,470 29,977 6.4%
Police 24,737,346 12,310,617 25,004,580 12,465,453 25,376,701 12,639,940 12,358,254 281,685 2.2%
Jail Services 6,206,735 1,735,928 3,489,616 1,744,484 3,750,000 1,907,023 1,907,023 ‐ 0.0%
Fire 22,511,597 11,333,418 24,173,315 12,628,919 24,188,120 12,415,229 12,459,420 (44,190) ‐0.4%
Community Services Admin 416,284 204,042 434,558 215,856 450,911 222,528 225,313 (2,784) ‐1.3%
Parks 3,829,676 1,750,372 4,004,054 1,823,313 4,153,621 1,894,848 1,862,252 32,596 1.7%
Parks Planning & Natural Resources 551,423 256,105 577,934 275,550 755,638 355,723 310,633 45,090 12.7%
Recreation 4,974,002 2,128,093 4,982,229 2,133,041 5,130,300 2,195,700 2,075,334 120,366 5.5%
Human Services 1,247,294 560,790 1,193,871 546,207 1,196,052 542,375 496,606 45,769 8.4%
Neighborhoods, Resources, & Events 675,534 276,544 701,673 293,480 914,955 378,699 362,006 16,692 4.4%
Library 2,030,000 1,815,119 278,604 263,606 ‐ ‐ ‐ ‐ 0.0%
Museum 210,620 104,539 216,887 108,238 211,080 105,057 104,728 329 0.3%
Public Works Admin 452,538 224,646 470,051 236,629 483,035 241,508 237,314 4,194 1.7%
Street Maintenance 3,534,025 1,755,569 3,755,640 1,857,066 4,294,894 2,128,477 1,924,036 204,441 9.6%
Transportation 4,509,066 2,164,571 4,615,160 2,150,841 4,562,797 2,158,029 2,113,464 44,565 2.1%
Debt Service 4,822,566 1,285,140 9,752,337 1,905,620 8,001,433 1,776,589 1,776,589 ‐ 0.0%
Non‐Departmental and Other 4,930,383 3,412,280 4,637,555 1,597,673 4,141,350 2,587,016 2,587,016 ‐ 0.0%
Total Operating Expenditures 100,825,999 48,730,646 103,938,882 47,714,859 103,926,454 49,420,812 48,473,829 946,983 1.9%
Total Ending Fund Balance 11,057,551$ 12,264,677$ 15,575,840$ 14,631,104$ 12,498,570$ 16,590,359$ 19,109,703$ 2,519,344$ 15.2%
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 June 2013
Page 1 of 39
Monthly Financial Report June 2013
OVERVIEW
This financial overview reflects the City’s overall financial position for the fiscal year through June 30, 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 75% of
all resources supporting general governmental activities. The following section provides detail information on property,
sales, utility, and other taxes.
Property Tax
June’s collection is $88k, making the total
year‐to‐date collection $16.9 million or
53.1% of the total budget. In comparison
to the previous year, the City collected
$448k or 3% less. Compared to the
budget, the City is above projections by
$319k or 2%. 2013’s monthly budgets
are based on 2010 through 2012
collections. The variance from the
monthly budget is due the timing of
collections. The City is projecting
property taxes to meet the budget by
year‐end.
Sales Tax
June 2013 sales tax receipts totalled $1.6
million. Compared with the same month
last year, it is $70k or 5% more.
Compared to the projected current
month’s budget, it is $81k or 6% above.
The year‐to‐date collection of $9.9 million
is $907k or 10% more than the prior year
and is also $640k or 7% more than
budgeted. The increase is primarily
attributed to several major projects
underway in both Building Construction
and Heavy and Civil projects, which
account for $440k of the budget variance.
Another item is a 1‐time audit correction
in the manufacturing sector for 2012 that
reduced activity in 2012 by $132k. Lastly, the other (miscellaneous) sector is performing well due to growth within the
insurance category. If we remove all of these items, we are $337k or 4% over 2012 and $70k or 1% more than 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 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 9,887,324 (124,683) ‐1% 1,434,659 17%
May 6,131,450 6,807,499 5,780,361 (351,089) ‐6% (1,027,138) ‐15%
Jun 43,203 69,561 88,480 45,277 105% 18,919 27%
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 17,301,729$ 16,534,715$ 16,854,032$ (447,698)$ ‐3% 319,317$ 2%
Annual Total 33,466,364$ 31,741,366$
Property Tax Revenues
Year to Date through June
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 1,509,953 139,222 10% 76,159 5%
May 1,599,184 1,625,701 1,732,058 132,874 8% 106,357 7%
Jun 1,482,794 1,471,334 1,552,807 70,013 5% 81,473 6%
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 9,007,790$ 9,274,866$ 9,914,656$ 906,866$ 10% 639,790$ 7%
Annual Total 18,564,670$ 18,604,000$
2013 vs. Budget2013 vs. 2012
Month
Year to Date through June
Local Retail Sales Tax Revenues
Page 2 of 39
Monthly Financial Report June 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 810,381$ 885,557$ 1,329,527$ 519,146$ 64%$ 443,970 50%
Auto Sales 1,635,512 1,645,943 1,786,638 151,126 9% 140,695 9%
General Retail 3,230,726 3,275,560 3,255,213 24,487 1% (20,347)‐1%
Manufacturing 532,022 562,707 626,581 94,560 18% 63,875 11%
Wholesale 580,979 581,972 574,256 (6,724) ‐1% (7,716)‐1%
Service 2,030,491 2,122,069 2,079,716 49,226 2% (42,353)‐2%
Other 187,680 201,058 262,724 75,044 40% 61,666 31%
YTD Total 9,007,790$ 9,274,866$ 9,914,656$ 906,866$ 10%639,790$ 7%
Note: Excludes Annexation Credit and Criminal Justice Sales Tax revenue.
Utility tax
June utility tax revenues are $1.2
million, which is $81k or 7% higher than
the same month last year and is also
ahead of the budget by $49k or 4%. The
year‐to‐date collection is $8 million,
which is $300k or 4% lower than the
prior year and is also $429k or 5% 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 to warmer weather
year‐to‐date than the prior year and we are projecting a combined unfavorable variance of $364k or 5%. Cell and Phone
variances are due the timing of receipts compared to 2012 (which should mostly catch up at the end of the year, but we are
projecting a combined unfavorable budget variance of $281k or 9%).
Utility Tax by Type 2012 2013 Bgt YTD Act Change 2013/2012 2013 Act vs Bgt
Electrical 2,760,541$ 2,896,626$ 2,705,889$ (54,652)$ ‐2%$ (190,737)‐7%
Natural Gas 1,335,038 1,312,665 1,166,818 (168,220) ‐13% (145,847)‐11%
Cell 1,076,921 1,084,884 912,334 (164,587) ‐15% (172,550)‐16%
Phone 472,440 447,208 410,588 (61,852) ‐13% (36,620)‐8%
Cable 678,526 704,255 712,128 33,602 5% 7,873 1%
Transfer Station 147,380 133,736 195,483 48,103 33% 61,747 46%
City Utilities 1,836,322 1,856,938 1,904,012 67,690 4% 47,074 3%
YTD Total 8,307,168$ 8,436,312$ 8,007,252$ (299,916)$ ‐4%(429,060)$ ‐5%
Annual Total 15,954,432$ 16,250,662$
YTD as % of 52% 52%
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 1,545,257 161,017 12% 132,899 9%
May 1,394,109 1,423,158 1,338,923 (55,185) ‐4% (84,235) ‐6%
Jun 1,108,588 1,140,870 1,189,847 81,259 7% 48,977 4%
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 8,307,168$ 8,436,312$ 8,007,252$ (299,916)$ ‐4% (429,060)$ ‐5%
Annual Total 15,954,432$ 16,250,662$
2013 vs. Budget2013 vs. 2012
Year to Date through June
Utility Tax Revenues
Month
Page 3 of 39
Monthly Financial Report June 2013
Other Taxes
Real Estate Excise Tax
The City collected $348k in Real Estate
Excise Tax revenues (REET) for June. This is
right on target with the same month last
year but is $32k or 8% lower than the
current month’s budget. The year‐to‐date
collection is $1.5 million, which is $165k or
13% more than the prior year and is also
$11k or 1% above the budget. The City is
projecting REET to meet the budget at
year‐end.
Gambling Tax
June’s Gambling Tax collections
totalled $60k, which is $67k or 53%
below the same month last year and
is also $60k or 50% below the current
month’s budget. The year‐to‐date
total of $636k is $167k or 21% below
the year before and is also $124k or
16% below budget. The decline in
revenue is mainly due to payment
plans with two (2) establishments
that will be paid in full by year‐end.
The City is also seeing a decline in
overall activity.
Pull tabs overall had an 11%
decrease, bingo decreased by 11%,
and card‐rooms are seeing 38% lower in activities when compared to the prior year.
Franchise Fees
Franchise Fees are due quarterly and
the year‐to‐date revenue collections
are $627k or 50% of the budget. This
is $27k or 5% higher than the prior
year and is also $28k 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 213,798 197,659 2,791 1% (16,140) ‐8%
May 253,446 283,619 285,948 32,501 13% 2,329 1%
Jun 347,179 380,093 347,890 711 0% (32,203) ‐8%
Jul 177,839 171,646
Aug 222,933 215,169
Sep 173,212 167,179
Oct 326,027 277,044
Nov 370,123 208,827
Dec 250,922 115,695
YTD Total 1,290,845$ 1,444,441$ 1,455,902$ 165,057$ 13% 11,461$ 1%
Annual Total 2,811,902$ 2,600,000$
Real Estate Excise Tax Revenues
Year to Date through June
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 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 159,655 3,158 2% 11,598 8%
May 101,088 95,636 97,660 (3,428) ‐3% 2,024 2%
Jun 127,372 120,502 60,074 (67,298) ‐53% (60,428) ‐50%
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 803,034$ 759,725$ 635,917$ (167,116)$ ‐21% (123,807)$ ‐16%
Annual Total 1,691,209$ 1,600,000$
Year to Date through June
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%
Feb ‐ ‐ 200 200 100% 200 100%
Mar ‐ ‐ 892 892 100% 892 100%
Apr 299,534 299,015 311,986 12,452 4% 12,971 4%
Jul 305,065 304,536 ‐
Oct 309,001 308,466 ‐
Dec 48,195 48,111 ‐
YTD Total 599,927$ 598,887$ 627,348$ 27,421$ 5% 28,461$ 5%
Annual Total 1,262,188$ 1,260,000$
Month
2013 vs. 2012 2013 vs. Budget
Franchise Fees Revenue
Year to Date through June
Page 4 of 39
Monthly Financial Report June 2013
Admission Tax
Admission Tax returns are due
quarterly in January, April, July, and
October of each year. April 2013
collections represent activities
conducted during the 1st quarter of
2013. The year‐to‐date collection of
$153k is $1k or 1% less than the prior
year but is right on target with the
budget. 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 $293k in June. The
year‐to‐date development fees revenue of
$1.9 million is $504k or 36% more than the
year before and is also $624k or 48% 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 $6k for June, which is
$2k or 69% above the same month last year and
is also $2k or 41% above the current month’s
budget. The year‐to‐date Business Licenses
revenue of $290k is $77k or 36% above the prior
year and is also $35k or 14% higher than the
budget. The variance for May is due to a
correction done in May of 2012, which would
skew the May 2013 budget. If we remove the
correction, May’s collection is only $20k or 142%
more than the prior year and $14k or 75% above
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 70,311 (10,041) ‐12% (9,252) ‐12%
Jul 81,104 80,307 ‐
Oct 74,001 73,275 ‐
Dec 1,244 1,232 ‐
YTD Total 154,705$ 153,186$ 152,751$ (1,020)$ ‐1% 489$ 0%
Annual Total 311,054$ 308,000$
Month
2013 vs. 2012 2013 vs. Budget
Admission Tax Revenue
Year to Date through June
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 154,777$ 149,263$ 327,644$ 172,867$ 112% 178,381$ 120%
Feb 185,509 181,341 230,104 44,595 24% 48,763 27%
Mar 253,914 236,021 305,160 51,246 20% 69,139 29%
Apr 252,351 241,884 367,285 114,934 46% 125,401 52%
May 277,438 235,755 388,525 111,087 40% 152,770 65%
Jun 284,208 244,103 293,386 9,178 3% 49,282 20%
Jul 294,286 277,438
Aug 360,657 345,432
Sep 189,832 169,797
Oct 400,995 382,373
Nov 271,519 260,912
Dec 406,375 399,094
YTD Total 1,408,197$ 1,288,368$ 1,912,104$ 503,907$ 36% 623,736$ 48%
Annual Total 3,331,862$ 3,123,413$
Building Permits and Development Service Fees
Year to Date through June
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 102,648 13,644 15% (4,047) ‐4%
May 2,645 3,171 33,354 30,709 1161% 30,183 952%
Jun 3,377 4,048 5,701 2,324 69% 1,653 41%
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 212,880$ 255,193$ 290,183$ 77,303$ 36% 34,990$ 14%
Annual Total 444,680$ 533,067$
2013 vs. 2012
Year to Date through June
2013 vs. Budget
Business Licenses
Month
Page 5 of 39
Monthly Financial Report June 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 87%
of the total revenues in this
category. The year‐to‐date
total Intergovernmental revenue is $5.6 million or 51% of the budget.
State Shared Revenues
State Shared Revenue collections
totalled $2.2 million since the start
of the year. Compared to the
prior year, State Shared Revenues
are below by $196k or 8%.
Compared to the projected
budget, the City is collecting
$290k or 15% more. The higher
than expected (but lower than
prior year) 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 64% of the total revenue in this category. The year‐to‐date total charges for services are $3.7 million or 54% of
the budget. This is 10% 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 672,812$ 565,310$ 565,310$ (107,501)$ ‐16% $ ‐ 0%
Fire District #40 2,329,117 2,083,763 2,083,763 (245,354) ‐11%‐ 0%
State Shared Revenue 2,417,929 1,932,758 2,222,390 (195,539) ‐8% 289,632 15%
Federal Grants 217,586 515,719 515,719 298,132 137% (0) 0%
State Grants 72,344 51,897 51,897 (20,447) ‐28% (0) 0%
Other Grants/Intgovt 81,190 21,259 21,259 (59,931) ‐74% (0) 0%
ARRA Grants 133,939 114,792 114,792 (19,147) ‐14% (0) 0%
Total Rev YTD 5,924,916$ 5,285,497$ 5,575,129$ (349,787)$ ‐6%289,632$ 5%
Total Rev Annual 12,673,276$ 10,976,031$
YTD % 47% 48% 51%
Note: Includes CJ Sales Tax and FD25 & FD40 contracts
2012 2013 2013
Actual Budget Actual $ % $ %
Crim Just Sales Tax 910,648$ 914,448$ 1,000,904$ 90,257$ 10% 86,457$ 9%
Judicial Contribution 11,316 11,250 11,398 82 1% 148 1%
Crim Just ‐ High Crime 93,724 ‐ 102,994 9,270 10% 102,994 100%
Crim Just ‐ Pop 10,194 ‐ 10,797 603 6% 10,797 100%
Crim Just ‐ Spec Prog 38,473 43,906 40,452 1,979 5% (3,454) ‐8%
State DUI 8,895 9,204 8,515 (381) ‐4% (689) ‐7%
Liquor Profits 506,059 348,716 423,384 (82,675) ‐16% 74,668 21%
Liquor Excise Tax 229,464 ‐ ‐ (229,464) 0%‐ N/A
Fuel Tax 609,156 605,235 623,946 14,790 2% 18,711 3%
YTD Total 2,417,929$ 1,932,758$ 2,222,390$ (195,539)$ ‐8% 289,632$ 15%
Annual Total 4,825,202$ 4,208,000$
Year to Date through June
State Shared Revenues
2013 vs. 2012
Revenue
2013 vs. Budget
Page 6 of 39
Monthly Financial Report June 2013
Public Safety Services
Public Safety Services totalled $481k 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 $252k or 111% 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
$481k receipted for Public Safety Services, $251k is for intergovernmental.
Recreation
Recreation revenues totalled $150k for the
current month. Compared to the same
month the prior year, the City collected $1k
or 1% more. Compared to the projected
monthly budget, the City collected $11k or
7% 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 $120k in the Recreation Division of the
Community Services Department.
Interfund Services
The year‐to‐date collections for Interfund
Services revenues are $1.8 million.
Compared to the prior year, the revenues
are over by $189k or 12%. Compared to the
projected budget, the revenues are above by
$95k or 6%. 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 investment program
reimbursements, and Maintenance division’s
street maintenance reimbursements.
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 64,009 64,009 (4,418) ‐6%‐ 0%
May 42,979 47,985 47,985 5,007 12%‐ 0%
Jun 31,486 36,945 36,945 5,459 17%‐ 0%
Jul 54,883 40,505 ‐
Aug 34,742 25,641 ‐
Sep 36,019 26,583 ‐
Oct 37,300 27,528 ‐
Nov 33,025 24,373 ‐
Dec 61,608 45,468 ‐
YTD Total 228,321$ 480,661$ 480,661$ 252,340$ 111%‐$ 0%
Annual Total 485,899$ 670,759$
Month
2013 vs. 2012
Year to Date through June
Public Safety Services
2013 vs. Budget
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 62,072$ 67,237$ 60,546$ (1,526)$ ‐2% (6,690)$ ‐10%
Feb 59,327 64,264 51,160 (8,167) ‐14% (13,104) ‐20%
Mar 104,775 113,492 79,491 (25,283) ‐24% (34,001) ‐30%
Apr 137,257 148,678 170,541 33,284 24% 21,863 15%
May 139,013 150,580 95,710 (43,303) ‐31% (54,870) ‐36%
Jun 149,137 161,546 150,284 1,147 1% (11,262) ‐7%
Jul 260,363 282,026 ‐
Aug 262,038 283,841 ‐
Sep 107,879 116,855 ‐
Oct 85,973 93,126 ‐
Nov 65,863 71,343 ‐
Dec 60,467 65,498 ‐
YTD Total 651,581$ 705,796$ 607,732$ (43,849)$ ‐7% (98,063)$ ‐14%
Annual Total 1,494,165$ 1,618,486$
Recreation
Year to Date through June
2013 vs. Budget2013 vs. 2012
Month
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 237,384$ 276,153$ 265,873$ 28,489$ 12% (10,279)$ ‐4%
Feb 234,758 276,153 292,362 57,604 25% 16,209 6%
Mar 271,071 276,153 317,998 46,927 17% 41,846 15%
Apr 253,070 276,153 288,610 35,541 14% 12,458 5%
May 291,941 276,153 299,652 7,711 3% 23,499 9%
Jun 275,112 276,153 287,569 12,457 5% 11,417 4%
Jul 217,828 276,153 ‐
Aug 345,690 276,153 ‐
Sep 273,570 276,153 ‐
Oct 338,304 276,153 ‐
Nov 276,902 276,153 ‐
Dec 296,085 276,153 ‐
YTD Total 1,563,336$ 1,656,915$ 1,752,065$ 188,728$ 12% 95,150$ 6%
Annual Total 3,311,715$ 3,313,830$
2013 vs. Budget
Month
Interfund Services
Year to Date through June
2013 vs. 2012
Page 7 of 39
Monthly Financial Report June 2013
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 below breaks down
these fines by type. The year‐to‐date total
fines and penalties is $1.5 million. This is
$31k or 2% lower than a year ago and is
also $22k or 1% below the budget. The
City is projecting fines and penalties to
meet the budget at year‐end.
Year to Date through June
2012 2013 2013
Actual Budget Actual $ % $ %
Civil Penalties 4,179$ 6,965$ 3,705$ (474)$ ‐11% (3,260)$ ‐47%
Civil Infraction Penalties 271,252 263,857 289,144 17,891 7% 25,287 10%
Civil Parking Infraction Penalties 66,633 75,395 76,160 9,527 14% 765 1%
Photo Enforcement Program 1,091,249 1,076,780 1,022,773 (68,476) ‐6% (54,007) ‐5%
Criminal Traffic Misdemeanor Fines 42,619 49,144 49,732 7,113 17% 588 1%
Criminal Non‐Traffic Fines 12,580 22,983 19,159 6,580 52% (3,824) ‐17%
Criminal Costs 57,791 54,496 60,465 2,674 5% 5,969 11%
Seizure Funds ‐ Federal/State/Local 1 25,614 ‐ ‐ (25,614) 0%‐ N/A
Non‐Court Fines, Forfeitures and Penalties 478 13,868 20,667 20,190 4228% 6,799 49%
YTD Total 1,572,394$ 1,563,488$ 1,541,804$ (30,590)$ ‐2% (21,684)$ ‐1%
Annual Total 3,060,389$ 3,058,500$
1 Seizure Funds are categorized in Miscellaneous for 2013 and on.
2013 vs. 2012
Revenue
2013 vs. Budget
Fines and Penalties by Type
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
$1 million. The budget shortfall in January 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 budget shortfall in June is due to
temporary shutting down cameras in construction
areas. These revenues should pick up after
construction is near completion.
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.
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 318,235 39,264 14% 38,648 14%
May 306,424 310,705 278,783 (27,641) ‐9% (31,922) ‐10%
Jun 318,091 312,586 269,334 (48,758) ‐15% (43,252) ‐14%
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 1,572,394$ 1,563,488$ 1,541,804$ (30,590)$ ‐2% (21,684)$ ‐1%
Annual Total 3,060,389$ 3,058,500$
Month
2013 vs. Budget2013 vs. 2012
Year to Date through June
Fines and Penalties by 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 217,923 71,127 60,187 157,736
May 212,766 181,018 74,599 60,361 120,657
Jun 218,587 161,729 74,570 56,521 105,208
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 1,076,780$ 1,022,773$ 443,559$ 357,791$ 664,982$
Annual Total 1,950,000$ 841,964$
1 Actuals of Revenues and Expenses
Expenses
Photo Enforcement Program
Year to Date through June
Month
Revenues
Page 8 of 39
Monthly Financial Report June 2013
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 67% of the total
revenue in this category. The year‐to‐date
total miscellaneous is $739k. Compared to
last year, the revenues are above by $7k or
1%. Compared to the projected year‐to‐date
budget, the revenues are over by $11k or 1%.
The table below breaks out miscellaneous
revenues by type:
2012 2013 2013
Actual Budget Actual $ % $ %
Interests and Other Earnings 49,775$ 108,338$ 52,161$ 2,385$ 5% (56,177)$ ‐52%
Rents, Leases, and Concessions 449,066 355,423 440,405 (8,660) ‐2% 84,982 24%
Contributions/Donations from Private Sources 70,614 52,983 43,186 (27,428) ‐39% (9,797) ‐18%
Other 162,149 89,784 168,763 6,615 4% 78,980 88%
Seizure Funds ‐ Federal/State/Local1 ‐ 121,985 34,567 34,567 100% (87,419) ‐72%
YTD Total 731,604$ 728,512$ 739,082$ 7,478$ 1% 10,569$ 1%
Annual Total 1,630,922$ 1,861,022$
1 Seizure Funds are categorized in Miscellaneous for 2013 and on.
2013 vs. Budget
Miscellaneous Revenues by Type
Year to Date through June
Revenue
2013 vs. 2012
Rents, leases and concessions are higher than the prior year and budget due to higher than expected fitness area rentals at
the community center and food concession payments at Coulon Park.
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.
2012 2013 2013
Actual Budget Actual $ % $ %
Jan 206,151$ 163,044$ 179,743$ (26,408)$ ‐13% 16,699$ 10%
Feb 83,823 132,653 76,397 (7,425) ‐9% (56,256) ‐42%
Mar 104,421 88,693 147,909 43,488 42% 59,216 67%
Apr 98,164 114,071 92,872 (5,291) ‐5% (21,199) ‐19%
May 145,213 112,039 118,719 (26,494) ‐18% 6,681 6%
Jun 93,832 118,012 123,441 29,609 32% 5,429 5%
Jul 112,316 97,424
Aug 143,389 124,005
Sep 89,588 105,170
Oct 91,608 78,260
Nov 64,705 58,620
Dec 397,713 669,031
YTD Total 731,604$ 728,512$ 739,082$ 7,478$ 1% 10,569$ 1%
Annual Total 1,630,922$ 1,861,022$
Year to Date through June
Month
2013 vs. Budget2013 vs. 2012
Miscellaneous Revenues by Month
Page 9 of 39
Monthly Financial Report June 2013
EXPENSES
Overall the City has expended 47% of its budgeted general governmental expenditures at the end of June. This is $947k or
1.9% below year‐to‐date budgeted expenditures. See below for summary of unfavorable items for general governmental
departments.
Council department is over the projected year‐to‐date budget by $804 or 0.6% due to overspending on salaries/benefits,
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 $94k or 6.4% due to the timing of
elections and voter registration expenses. These expenses were paid in July last year and therefore would skew the current
year budget. This variance will correct itself after July.
Fire department is over the year‐to‐date budget by $44k or 0.4%. This is mainly due to overspending in overtime ($122k),
supplies ($210k), intergovernmental ($39k), and under spending on salaries and benefits ($42k), general professional
services ($50k) and capital ($179k). We will monitor these items to determine if a budget amendment is needed at year‐
end.
Page 10 of 39
Monthly Financial Report June 2013
CASH AND INVESTMENTS – 2ND
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
$115.8 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, various certificates of deposits, and the interfund loan.
The existing portfolio yield is approximately .55%. The majority (.29%) is within the cash at US Bank.
Cash
65%
Local Government
Investment Pool
9%
US Federal Agency
Securities
0%Certificates of
Deposit
25%
INTERFUND
INVESTMENT
1%
Distribution by Instrument
(Percent of Cash and Investment Portfolio)
Deposit Total Maturity Date APY
Weighted Yield Current Allocation of
Cash and Investments
Allowed
by Policy
Current Principal
Balance
Cash US Bank ‐ Cash 75,314,886 overnight 0.45% 0.40%65%N/A 75,314,886
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,917,884 5/31/2013 0.13% 0.02%9% 75%9,917,884
US Federal Agency Securities *
312159a FNMA (Callable)‐ 0%
Certificates of Deposit
113154A First Savings Bank Northwest 5,000,000 2/4/2015 0.92% 0.15%
113164A First Savings Bank Northwest 5,000,000 2/4/2016 1.02% 0.17%
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.07%
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.14%
211133a Commencement Bank (CDARS) 5,100,192 9/6/2013 1.00% 0.17%
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 115,806,967$ 115,806,967$
Institution
Golf Interfund Loan
1% N/A
20%9%
20%4%
10,000,000
4,784,375
100%‐
1,180,000
6% 20% 6,630,333
20%2%
20%4% 5,209,717
2,769,772
Page 11 of 39
Monthly Financial Report June 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 ‐ ‐ ‐ ‐ 26,635 21,018 ‐
Grants / intergovernmental 1,025,690 ‐ 104,987 ‐ ‐ 623,644 ‐
Charges for services 57,957 838,323 7,848,585 7,356,869 4,571,698 4,422,663 7,403,578
Interdepartmental services ‐ ‐ ‐ ‐ ‐ ‐ ‐
Fines and penalties 4,277 ‐ ‐ ‐ 522 ‐ ‐
Rents, leases, and misc fees 1,148,513 146,524 38,037 64,802 ‐ ‐ ‐
Interest and other misc 4,091 1,090 6,491 163,953 354,982 126,206 2,578
TOTAL REVENUES 2,240,528 985,937 7,998,100 7,585,624 4,953,837 5,193,531 7,406,156
EXPENSES:
Utility billing ‐ ‐ 57,409 63,670 41,906 68,376 ‐
Utility systems ‐ ‐ 6,882,721 1,585,489 1,408,538 1,198,037 ‐
Utility maintenance ‐ ‐ 137,963 2,263,923 618,808 996,284 7,148,879
Transportation 715,669 ‐ ‐ ‐ ‐ ‐ ‐
Golf ‐ 878,625 ‐ ‐ ‐ ‐ ‐
TOTAL EXPENSES 715,669 878,625 7,078,093 3,913,082 2,069,252 2,262,697 7,148,879
AMOUNT AVAILABLE FOR DEBT SERVICE 1,524,859 107,312 920,007 3,672,542 2,884,585 2,930,834 257,277
DEBT SERVICE:
Principal ‐ ‐ ‐ 269,750 124,500 20,750 ‐
Interest ‐ ‐ ‐ 325,811 164,909 145,590 ‐
TOTAL DEBT SERVICE ‐ ‐ ‐ 595,561 289,409 166,340 ‐
CAPITAL PROJECTS 1,415,672 10,958 ‐ 3,012,333 1,091,813 1,119,177 ‐
TRANSFERS IN/(OUT)‐ ‐ ‐ 7,526 (3,763) (8,967) ‐
CHANGE IN FUND BALANCE 109,187 96,354 920,007 72,174 1,499,600 1,636,350 257,277
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, Jun 30 2,452,111 636,168 2,443,888 9,918,482 4,696,334 7,650,824 2,003,164
Page 12 of 39
Monthly Financial Report June 2013
INTERNAL SERVICE FUNDS
The table below gives an analysis of all City Internal Service Funds. Displayed are the year‐to‐date revenues and
expenditures for each internal service. Included in each fund are the capital revenues and expenditures.
Equipment
Rental
Information
Technology Facilities Communications Insurance Healthcare Retiree
Healthcare
REVENUES:
Technology Fee ‐ 56,264 ‐ ‐ ‐ ‐ ‐
Grants / intergovernmental ‐ ‐ ‐ ‐ ‐ ‐ 32,467
Charges for services
Equipment rental m&o 1,375,592 1,526,868 ‐ ‐ ‐ ‐ ‐
Print and mail ‐ 56,207 ‐ 200,349 ‐ ‐ ‐
Communications ‐ 3,000 ‐ 254,530 ‐ ‐ ‐
Facilities ‐ ‐ 2,139,363 ‐ ‐ ‐ ‐
Data cards and cell phones ‐ 70,209 ‐ ‐ ‐ ‐ ‐
IT service co ntracts ‐ 219,392 ‐ ‐ ‐ ‐ ‐
Interest and other misc 5,852 2,784 1,444 450 19,964 11,018 9,354
Internal service fund misc:
Vehicle / equipment capital recovery 709,062 84,993 ‐ ‐ ‐ ‐ ‐
Insurance premiums ‐ ‐ ‐ ‐ 795,994 ‐ ‐
Worker's comp/unemployment ‐ ‐ ‐ ‐ 761,709 ‐ ‐
Benefit premiums ‐ ‐ ‐ ‐ ‐ 4,129,845 853,696
Other misc 6,131 11,853 9,128 ‐ 133 55,629 ‐
Interfund Loan ‐ ‐ ‐ ‐ 136,852 ‐ ‐
Capital contributions ‐ ‐ ‐ ‐ ‐ ‐ ‐
Disposal of capital assets 91,261 ‐ ‐ ‐ ‐ ‐ ‐
Insurance recoveries 25,000 ‐ ‐ ‐ 57,743 5,651 ‐
TOTAL REVENUES 2,212,898 2,031,570 2,149,935 455,329 1,772,395 4,202,143 895,517
EXPENSES:
Communications 234,809
Equipment rental 1,076,104
Facilities 1,765,904
Healthcare 5,439,740
Information technology 1,500,621
Print and mail 184,986
Retiree healthcare 505,091
Risk management
Ri sk management 1,202,052
Unemployment 33,260
Worker's compensation 659,591
TOTAL EXPENSES 1,076,104 1,500,621 1,765,904 419,795 1,894,903 5,439,740 505,091
AMOUNT AVAILABLE FOR CAPITAL 1,136,794 530,949 384,032 35,534 (122,508) (1,237,597) 390,426
CAPITAL PROJECTS 526,675 288,154 201,522 ‐ ‐ ‐ ‐
TRANSFERS IN 5,204 29,682 551 ‐ 2,000,000 ‐ ‐
TRANSFERS (OUT)‐ ‐ ‐ ‐ ‐ ‐ ‐
CHANGE IN FUND BALANCE 615,323 272,477 183,061 35,534 1,877,492 (1,237,597) 390,426
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, Jun 30 4,337,824 2,129,449 1,032,533 339,011 6,864,299 6,661,473 6,872,591
Page 13 of 39
Monthly Financial Report June 2013
FUND BALANCE
Page 15 shows the ending fund balance as of June 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 June, the City has $19.1 million reported in the combined general governmental fund balance of the current
year’s operating budget, which is approximately 18% of budgeted operating expenditures. This is an increase of $3.5
million from the year’s beginning balance. June’s ending fund balance is over the anticipated General Governmental Fund
Balance of $16.6 million by $2.5 million or 15.2%. Although the ending fund balance is above projections, it is consistent
with the prior years’ trends since the City receipted the first half of 2013 property taxes in April/May and will receipt the
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 14 of 39
Monthly Financial Report June 2013
City of Renton
All Funds ‐ Revenue, Expenditures and Fund Balances
Cash Basis through June 30, 2013
Funds
Balance
01/01/2013
Budgeted
Revenue
Revenue
06/30/13
Total Funds
Available
Budgeted
Expenditure
Expenditure
06/30/13
Ending
Balance
GENERAL GOVERNMENT FUNDS:15,575,839 100,849,185 52,007,692 67,583,531 103,926,454 48,473,829 19,109,703
000 General 10,575,369 71,979,735 37,867,747 48,443,116 75,128,756 37,603,523 10,839,592
001 Community Services 1,891,966 11,328,945 5,531,911 7,423,877 11,325,011 4,814,741 2,609,136
003 Street 1,585,553 8,877,257 4,373,592 5,959,145 8,857,691 4,037,501 1,921,644
004 Community Dev Block Grant (13,145) 367,512 86,254 73,109 297,069 102,227 (29,118)
005 Museum 52,369 209,903 105,001 157,370 211,080 104,728 52,641
009 Farmers Market 90,520 59,400 21,317 111,837 80,414 20,797 91,040
011 Fire Health & Wellness 55,483 25,000 16,921 72,404 25,000 13,722 58,682
031 Park Memorial 178,367 ‐ 248 178,615 ‐ ‐ 178,615
201 Ltd GO Bonds Gen Govt Debt 829,784 1,749,305 876,282 1,706,066 1,749,305 134,500 1,571,566
215 Gen Govt Misc Debt Service 329,573 6,252,128 3,128,420 3,457,993 6,252,128 1,642,089 1,815,904
SPECIAL REVENUE FUNDS:
102 Arterial Street 168,514 643,000 294,091 462,605 600,000 ‐ 462,605
108 Leased City Properties 527,677 797,289 292,298 819,975 752,011 275,512 544,463
110 Hotel Motel 111,256 245,000 163,992 275,248 291,000 105,252 169,996
125 1% For Art 116,142 16,000 152 116,294 50,000 13,650 102,644
127 Cable Communication 257,372 85,674 66,756 324,128 85,674 36,503 287,625
135 Springbrook Wetlands Bank 665,828 ‐ 927 666,755 ‐ ‐ 666,755
CAPITAL PROJECT FUNDS (CIP):
303 Community Dev Mitigation 1,540,154 60,000 43,043 1,583,197 700,000 ‐ 1,583,197
304 Fire Mitigation 797,417 25,000 44,999 842,416 250,000 ‐ 842,416
305 Transportation Mitigation 292,627 40,000 144,820 437,447 100,000 ‐ 437,447
316 Municipal Facilities CIP 3,474,517 4,191,506 992,216 4,466,733 7,557,385 791,302 3,675,431
317 Transportation CIP (391,159) 29,684,866 7,587,613 7,196,454 29,272,465 11,175,339 (3,978,885)
318 So Lake WA Infrastructure Proj 52,073 44,874 44,894 96,967 96,947 59,258 37,709
326 Housing Opportunity 84,359 ‐ 127 84,486 75,000 ‐ 84,486
336 New Library Development 19,143,344 300,000 26,437 19,169,781 19,443,344 265,852 18,903,929
ENTERPRISE FUNDS:
402 Airport 331,939 1,264,418 1,211,836 1,543,775 1,432,346 715,669 828,106
403 Solid Waste Utility 1,523,881 15,700,852 7,998,100 9,521,981 16,177,073 7,078,092 2,443,889
404 Golf Course 291,978 2,453,669 985,578 1,277,556 2,476,366 906,181 371,375
422 Airport Capital 2,010,985 15,325,895 1,028,693 3,039,678 17,308,384 1,415,672 1,624,006
424 Golf Course Capital 247,836 50,000 25,358 273,194 156,482 8,400 264,794
INTERNAL SERVICE FUNDS:
501 Equipment Repair/Replacement 3,722,501 4,247,724 2,218,101 5,940,602 4,281,528 1,602,779 4,337,823
502 Insurance 4,986,807 5,713,764 3,772,394 8,759,201 3,060,718 1,894,902 6,864,299
503 Information Services 1,856,972 4,188,823 2,061,252 3,918,224 5,326,336 1,788,774 2,129,450
504 Facilities 849,472 4,276,112 2,150,486 2,999,958 4,468,879 1,967,426 1,032,532
505 Communications 303,477 877,773 455,329 758,806 893,249 419,795 339,011
512 Insurance, Healthcare 7,899,070 9,329,364 4,202,143 12,101,213 10,904,461 5,439,740 6,661,473
522 Insurance, Leoff1 Retirees HC 6,482,165 1,735,684 895,517 7,377,682 1,737,782 505,091 6,872,591
FIDUCIARY FUNDS:
611 Firemen's Pension 4,556,003 300,000 131,952 4,687,955 240,475 100,822 4,587,133
Funds
Balance
01/01/2013
Budgeted
Revenue
Revenue
06/30/13
Total Funds
Available
Budgeted
Expenditure
Expenditure
06/30/13
Ending
Balance
ENTERPRISE FUNDS: COMBINED UTILITIES 20,803,403 57,376,403 25,146,673 45,950,076 60,603,334 21,681,272 24,268,804
405 Water Utility 5,449,029 13,402,096 6,546,742 11,995,771 11,034,019 4,537,412 7,458,359
406 Waste Water Utility 1,363,629 6,758,645 4,274,943 5,638,572 5,505,490 2,362,423 3,276,149
407 Surface Water Utility 2,269,771 7,963,326 4,255,531 6,525,302 6,180,122 2,438,004 4,087,298
416 King County Metro 1,745,887 15,126,703 7,406,157 9,152,044 15,126,703 7,148,879 2,003,165
425 Water Utility Construction 4,381,380 3,745,000 1,046,385 5,427,765 8,007,000 2,983,564 2,444,201
426 Waste Water Construction 1,833,105 3,300,000 678,893 2,511,998 4,870,000 1,091,813 1,420,185
427 Surface Water Construction 3,744,703 7,080,633 938,000 4,682,703 9,880,000 1,119,177 3,563,526
471 Waterworks Rate Stabilization 15,899 ‐ 22 15,921 ‐ ‐ 15,921
Note: Waterworks Utility Funds are managed as a system and are designated by the dotted lines.
Page 15 of 39
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 33,559,062 31,631,530 1,927,532 17,503,371
May 46,893,848 39,883,684 7,010,164 22,586,003
June 52,007,692 48,473,829 3,533,864 19,109,703
July
August
September
October
November
December
1,000,000
2,000,000
3,000,000
4,000,000
5,000,000
6,000,000
7,000,000
8,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)
(3,000,000)
(2,000,000)
(1,000,000)
‐
1,000,000
‐
10,000,000
20,000,000
30,000,000
40,000,000
50,000,000
60,000,000
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Page 16 of 39
City of Renton
Monthly Revenue Analysis ‐ 2013 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 5,379,004 5,592,172 3.96%
Feb 11,584,025 11,590,564 0.06%
Mar 16,972,572 17,392,180 2.47%
Apr 31,221,729 33,559,062 7.49%
May 45,394,794 46,893,848 3.30%
Jun 50,435,331 52,007,692 3.12%
Jul 56,472,655
Aug 61,515,377
Sep 66,624,751
Oct 80,195,885
Nov 93,774,604
Dec 100,849,185
Percent of budget 51.57%
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 10,985,190 13.75%
May 16,465,154 16,765,551 1.82%
Jun 16,534,715 16,854,032 1.93%
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 53.10%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
$33
$36
Budget
Actual
Last Year
Page 17 of 39
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 7,413,785 8.06%
May 8,668,156 9,351,345 7.88%
Jun 10,307,140 11,088,148 7.58%
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 53.50%
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 5,478,482 ‐6.71%
May 7,295,443 6,817,405 ‐6.55%
Jun 8,436,312 8,007,252 ‐5.09%
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 49.27%
Note: Includes Natural Gas Use Tax.
$0
$2
$4
$6
$8
$10
$12
$14
$16
Budget
Actual
Last Year
Page 18 of 39
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 1,091,568 27.96%
May 1,034,613 1,368,619 32.28%
Jun 1,227,006 1,596,317 30.10%
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 55.74%
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,788,440 15.93%
Apr 2,351,298 2,655,993 12.96%
May 4,754,215 5,073,346 6.71%
Jun 5,285,497 5,575,129 5.48%
Jul 5,773,693
Aug 6,226,962
Sep 6,692,220
Oct 7,902,800
Nov 10,297,764
Dec 10,976,031
Percent of budget 50.79%
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 19 of 39
City of Renton
Monthly Revenue Analysis ‐ 2013 Budget Year
Charges for
Services Budget
YTD
Actual
Annual %
over (under)
Jan 427,908 485,115 13.37%
Feb 1,115,373 1,196,439 7.27%
Mar 1,634,485 1,781,982 9.02%
Apr 2,236,225 2,466,853 10.31%
May 2,803,832 3,095,181 10.39%
Jun 3,367,245 3,689,131 9.56%
Jul 4,086,824
Aug 4,776,133
Sep 5,247,463
Oct 5,794,219
Nov 6,278,318
Dec 6,811,096
Percent of budget 54.16%
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 993,688 5.69%
May 1,250,902 1,272,471 1.72%
Jun 1,563,488 1,541,804 ‐1.39%
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 50.41%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Budget
Actual
Last Year
Page 20 of 39
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 1,963,238 0.60%
May 2,504,949 2,520,946 0.64%
Jun 2,978,377 2,903,455 ‐2.52%
Jul 3,899,830
Aug 4,250,535
Sep 4,560,560
Oct 5,292,403
Nov 5,586,764
Dec 6,313,000
Percent of budget 45.99%
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 163,044 179,743 10.24%
Feb 295,698 256,140 ‐13.38%
Mar 384,390 404,049 5.11%
Apr 498,462 496,921 ‐0.31%
May 610,500 615,640 0.84%
Jun 728,512 739,082 1.45%
Jul 825,936
Aug 949,941
Sep 1,055,111
Oct 1,133,371
Nov 1,191,991
Dec 1,861,022
Percent of budget 39.71%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80 Budget
Actual
Last Year
Page 21 of 39
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 13,343 3003.03%
May 7,030 13,343 89.80%
Jun 7,040 13,343 89.53%
Jul 7,083
Aug 7,110
Sep 7,833
Oct 7,925
Nov 44,338
Dec 250,000
Percent of budget 5.34%
$‐
$1.00
$2.00
$3.00
$4.00
$5.00
$6.00
Millions Other Financing Sources
Budget
Actual
Last Year
Page 22 of 39
City of Renton
Monthly Revenue Analysis ‐ 2013 Budget Year
REET Budget
YTD
Actual
Annual %
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 822,064 28.81%
May 872,560 1,108,012 26.98%
Jun 1,193,556 1,455,902 21.98%
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 56.00%
Bldg Permits &
Devlpmt Svc YTD Annual %
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
Millions
Real Estate Excise Tax
Budget
Actual
Last Year
Millions Building Permits and Development Service
Fees Budget Actual over (under)
Jan 149,263 327,644 119.51%
Feb 330,604 557,749 68.71%
Mar 566,625 862,909 52.29%
Apr 808,509 1,230,194 52.16%
May 1,044,264 1,618,718 55.01%
Jun 1,288,368 1,912,104 48.41%
Jul 1,565,806
Aug 1,911,238
Sep 2,081,035
Oct 2,463,407
Nov 2,724,319
Dec 3,123,413
Percent of budget 61.22%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions Fees
Budget
Actual
Last Year
Page 23 of 39
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
General
Government Budget
YTD
Actual
Annual %
over (under)
Jan 7,444,301 7,563,322 1.60%
Feb 16,221,403 15,996,818 ‐1.38%
Mar 23,711,420 23,413,342 ‐1.26%
Apr 32,025,206 31,631,530 ‐1.23%
May 40,641,884 39,883,684 ‐1.87%
Jun 49,420,812 48,473,829 ‐1.92%
Jul 60,165,457
Aug 68,874,788
Sep 77,517,469
Oct 86,043,550
Nov 94,525,882
Dec 103,926,454
Percent of budget expended 46.64%
YTD Annual %
$‐
$10
$20
$30
$40
$50
$60
$70
$80
$90
$100
$110
Millions
Total Expenditures
General Government
Budget
Actual
Last Year
$300 000
Legislative
Legislative Budget Actual over (under)
Jan 23,231 23,354 0.53%
Feb 47,551 47,686 0.28%
Mar 71,956 72,806 1.18%
Apr 95,878 97,646 1.84%
May 120,148 121,071 0.77%
Jun 144,309 145,113 0.56%
Jul 168,859
Aug 192,896
Sep 217,082
Oct 241,441
Nov 265,573
Dec 290,291
Percent of budget expended 49.99%
$‐
$50,000
$100,000
$150,000
$200,000
$250,000
$300,000
Budget
Actual
Last Year
Page 24 of 39
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Executive Budget
YTD
Actual
Annual %
over (under)
Jan 84,700 78,944 ‐6.80%
Feb 190,135 186,330 ‐2.00%
Mar 296,151 297,118 0.33%
Apr 407,614 419,061 2.81%
May 516,918 528,321 2.21%
Jun 623,960 614,036 ‐1.59%
Jul 735,658
Aug 847,425
Sep 953,811
Oct 1,064,489
Nov 1,170,013
Dec 1,322,364
Percent of budget expended 46.43%
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 6,671 ‐57.06%
May 18,668 8,371 ‐55.16%
Jun 21,071 8,966 ‐57.45%
Jul 23,545
Aug 27,015
Sep 29,700
Oct 31,542
Nov 36,403
Dec 40,000
Percent of budget expended 22.41%
$‐
$10,000
$20,000
$30,000
$40,000
$50,000
$60,000
Budget
Actual
Last Year
Page 25 of 39
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
City Attorney Budget
YTD
Actual
Annual %
over (under)
Jan 155,027 141,744 ‐8.57%
Feb 314,005 285,967 ‐8.93%
Mar 472,262 427,953 ‐9.38%
Apr 633,182 584,735 ‐7.65%
May 787,132 724,478 ‐7.96%
Jun 947,880 872,824 ‐7.92%
Jul 1,105,337
Aug 1,263,381
Sep 1,421,095
Oct 1,593,003
Nov 1,749,576
Dec 1,915,103
Percent of budget expended 45.58%
YTD Annual % $2 20
Millions Court Services
$‐
$0.40
$0.80
$1.20
$1.60
$2.00
$2.40
Millions City Attorney
Budget
Actual
Last Year
Court Services Budget Actual over (under)
Jan 161,056 152,280 ‐5.45%
Feb 321,721 310,767 ‐3.40%
Mar 485,078 468,698 ‐3.38%
Apr 650,782 643,564 ‐1.11%
May 824,039 795,263 ‐3.49%
Jun 1,016,165 978,124 ‐3.74%
Jul 1,185,948
Aug 1,354,731
Sep 1,519,505
Oct 1,684,389
Nov 1,852,716
Dec 2,026,149
Percent of budget expended 48.28%
$‐
$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 26 of 39
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
CED Admin Budget
YTD
Actual
Annual %
over (under)
Jan 85,577 85,287 ‐0.34%
Feb 171,360 170,570 ‐0.46%
Mar 257,144 256,405 ‐0.29%
Apr 344,608 344,293 ‐0.09%
May 428,940 428,857 ‐0.02%
Jun 513,272 514,481 0.24%
Jul 597,689
Aug 682,197
Sep 766,581
Oct 850,349
Nov 934,318
Dec 1,020,208
Percent of budget expended 50.43%
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 263,464 272,362 3.38%
Feb 532,470 515,474 ‐3.19%
Mar 801,048 768,135 ‐4.11%
Apr 1,070,001 1,060,776 ‐0.86%
May 1,359,141 1,319,207 ‐2.94%
Jun 1,620,563 1,589,997 ‐1.89%
Jul 1,901,116
Aug 2,169,138
Sep 2,450,976
Oct 2,739,546
Nov 3,020,135
Dec 3,308,299
Percent of budget expended 48.06%
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
Millions
Budget
Actual
Last Year
Page 27 of 39
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Economic
Development Budget
YTD
Actual
Annual %
over (under)
Jan 54,655 75,717 38.54%
Feb 109,521 81,391 ‐25.68%
Mar 155,477 109,135 ‐29.81%
Apr 198,321 146,523 ‐26.12%
May 246,022 175,487 ‐28.67%
Jun 290,316 211,913 ‐27.01%
Jul 339,634
Aug 384,572
Sep 428,840
Oct 472,869
Nov 524,583
Dec 570,280
Percent of budget expended 37.16%
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 118,936 112,247 ‐5.62%
Feb 265,596 237,260 ‐10.67%
Mar 381,868 350,721 ‐8.16%
Apr 509,685 480,129 ‐5.80%
May 630,402 603,248 ‐4.31%
Jun 748,996 728,944 ‐2.68%
Jul 870,176
Aug 1,024,050
Sep 1,159,558
Oct 1,279,389
Nov 1,405,692
Dec 1,541,592
Percent of budget expended 47.29%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
$1.40
$1.60
$1.80
Millions
Budget
Actual
Last Year
Page 28 of 39
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Finance Budget
YTD
Actual
Annual %
over (under)
Jan 158,336 144,010 ‐9.05%
Feb 323,142 284,066 ‐12.09%
Mar 485,519 437,042 ‐9.98%
Apr 646,871 610,911 ‐5.56%
May 815,548 775,564 ‐4.90%
Jun 991,610 942,750 ‐4.93%
Jul 1,157,861
Aug 1,335,063
Sep 1,499,653
Oct 1,643,469
Nov 1,786,254
Dec 2,242,682
Percent of budget expended 42.04%
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 64,284 61,226 ‐4.76%
Feb 132,790 122,708 ‐7.59%
Mar 205,777 199,840 ‐2.89%
Apr 343,675 270,581 ‐21.27%
May 414,549 573,204 38.27%
Jun 484,479 627,223 29.46%
Jul 688,755
Aug 762,679
Sep 835,208
Oct 907,934
Nov 981,746
Dec 1,061,505
Percent of budget expended 59.09%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Budget
Actual
Last Year
Page 29 of 39
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Human
Resources Budget
YTD
Actual
Annual %
over (under)
Jan 83,400 64,230 ‐22.99%
Feb 161,123 134,784 ‐16.35%
Mar 240,261 212,385 ‐11.60%
Apr 311,770 288,203 ‐7.56%
May 382,831 357,200 ‐6.70%
Jun 469,447 439,470 ‐6.39%
Jul 552,148
Aug 635,001
Sep 713,975
Oct 797,946
Nov 885,037
Dec 977,094
Percent of budget expended 44.98%
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,428,756 2,521,995 3.84%
Feb 4,822,410 4,737,466 ‐1.76%
Mar 7,237,703 7,196,803 ‐0.57%
Apr 9,708,499 9,460,145 ‐2.56%
May 11,922,640 11,645,035 ‐2.33%
Jun 14,546,962 14,265,277 ‐1.94%
Jul 17,110,436
Aug 19,351,851
Sep 21,759,242
Oct 24,136,681
Nov 26,544,437
Dec 29,126,701
Percent of budget expended 48.98%
$‐
$3
$6
$9
$12
$15
$18
$21
$24
$27
$30
Budget
Actual
Last Year
Page 30 of 39
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Fire &
Emergency
Services Budget
YTD
Actual
Annual %
over (under)
Jan 1,888,720 2,045,002 8.27%
Feb 4,532,143 4,729,656 4.36%
Mar 6,445,515 6,673,347 3.53%
Apr 8,335,243 8,636,731 3.62%
May 10,507,156 10,518,427 0.11%
Jun 12,415,229 12,459,420 0.36%
Jul 14,332,466
Aug 16,378,589
Sep 18,352,651
Oct 20,268,263
Nov 22,198,986
Dec 24,188,120
Percent of budget expended 51.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,606 37,025 ‐4.09%
Feb 74,909 74,364 ‐0.73%
Mar 111,787 111,667 ‐0.11%
Apr 148,344 150,854 1.69%
May 185,868 187,590 0.93%
Jun 222,528 225,313 1.25%
Jul 259,410
Aug 295,998
Sep 332,176
Oct 367,946
Nov 405,451
Dec 450,911
Percent of budget expended 49.97%
$‐
$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 31 of 39
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Parks Budget
YTD
Actual
Annual %
over (under)
Jan 284,059 269,811 ‐5.02%
Feb 571,759 563,088 ‐1.52%
Mar 881,042 851,150 ‐3.39%
Apr 1,213,451 1,192,965 ‐1.69%
May 1,544,269 1,515,905 ‐1.84%
Jun 1,894,848 1,862,252 ‐1.72%
Jul 2,261,158
Aug 2,638,492
Sep 3,030,537
Oct 3,420,829
Nov 3,789,095
Dec 4,153,621
Percent of budget expended 44.83%
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 80
Millions Parks Planning and Natural Resources
Resources Budget Actual over (under)
Jan 47,101 42,639 ‐9.47%
Feb 95,269 88,359 ‐7.25%
Mar 156,534 142,461 ‐8.99%
Apr 214,184 196,871 ‐8.08%
May 286,142 258,947 ‐9.50%
Jun 355,723 310,633 ‐12.68%
Jul 415,823
Aug 476,926
Sep 545,276
Oct 620,182
Nov 690,040
Dec 755,638
Percent of budget expended 41.11%
$‐
$0.10
$0.20
$0.30
$0.40
$0.50
$0.60
$0.70
$0.80
Budget
Actual
Last Year
Page 32 of 39
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Recreation Budget
YTD
Actual
Annual %
over (under)
Jan 343,076 305,989 ‐10.81%
Feb 697,923 650,023 ‐6.86%
Mar 1,060,652 1,002,907 ‐5.44%
Apr 1,435,547 1,371,571 ‐4.46%
May 1,810,378 1,698,203 ‐6.20%
Jun 2,195,700 2,075,334 ‐5.48%
Jul 2,787,526
Aug 3,446,454
Sep 3,960,958
Oct 4,343,623
Nov 4,714,526
Dec 5,130,300
Percent of budget expended 40.45%
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 55,141 45,984 ‐16.61%
Feb 122,303 128,054 4.70%
Mar 217,326 218,002 0.31%
Apr 381,767 340,261 ‐10.87%
May 479,318 431,038 ‐10.07%
Jun 542,375 496,606 ‐8.44%
Jul 674,923
Aug 744,460
Sep 805,315
Oct 959,873
Nov 1,030,967
Dec 1,196,052
Percent of budget expended 41.52%
$‐
$0.20
$0.40
$0.60
$0.80
$1.00
$1.20
Budget
Actual
Last Year
Page 33 of 39
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Neighborhoods
, Resources,
and Events Budget
YTD
Actual
Annual %
over (under)
Jan 55,854 56,917 1.90%
Feb 109,166 108,774 ‐0.36%
Mar 172,916 171,351 ‐0.91%
Apr 236,903 231,744 ‐2.18%
May 298,441 288,076 ‐3.47%
Jun 378,699 362,006 ‐4.41%
Jul 470,110
Aug 555,842
Sep 632,165
Oct 703,188
Nov 803,370
Dec 914,955
Percent of budget expended 39.57%
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 ‐ ‐ N/A
May ‐ ‐ N/A
Jun ‐ ‐ N/A
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 34 of 39
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Museum Fund Budget
YTD
Actual
Annual %
over (under)
Jan 17,250 16,898 ‐2.04%
Feb 34,747 34,090 ‐1.89%
Mar 52,190 51,213 ‐1.87%
Apr 69,816 69,807 ‐0.01%
May 87,358 87,136 ‐0.25%
Jun 105,057 104,728 ‐0.31%
Jul 122,568
Aug 140,200
Sep 158,058
Oct 175,778
Nov 193,585
Dec 211,080
Percent of budget expended 49.62%
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,394 39,971 ‐1.05%
Feb 80,618 79,912 ‐0.88%
Mar 120,971 119,866 ‐0.91%
Apr 161,356 163,297 1.20%
May 201,472 202,081 0.30%
Jun 241,508 237,314 ‐1.74%
Jul 281,724
Aug 322,247
Sep 363,226
Oct 402,909
Nov 442,662
Dec 483,035
Percent of budget expended 49.13%
$‐
$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 35 of 39
City of Renton
Monthly Expenditure Analysis ‐ 2013 Budget Year
Street
Maintenance Budget
YTD
Actual
Annual %
over (under)
Jan 333,344 302,270 ‐9.32%
Feb 713,983 641,518 ‐10.15%
Mar 1,077,703 937,528 ‐13.01%
Apr 1,405,768 1,294,196 ‐7.94%
May 1,756,371 1,600,743 ‐8.86%
Jun 2,128,477 1,924,036 ‐9.61%
Jul 2,485,951
Aug 2,826,956
Sep 3,174,309
Oct 3,531,791
Nov 3,898,668
Dec 4,294,894
Percent of budget expended 44.80%
YTD Annual %
$‐
$0.50
$1.00
$1.50
$2.00
$2.50
$3.00
$3.50
$4.00
$4.50
$5.00
Millions Street Maintenance
Budget
Actual
Last Year
$5 0
Millions Transportation
Transportation Budget Actual over (under)
Jan 298,525 311,908 4.48%
Feb 675,318 670,659 ‐0.69%
Mar 1,051,492 1,074,529 2.19%
Apr 1,429,100 1,512,690 5.85%
May 1,797,203 1,819,302 1.23%
Jun 2,158,029 2,113,464 ‐2.07%
Jul 2,553,346
Aug 2,923,438
Sep 3,300,485
Oct 3,687,132
Nov 4,071,164
Dec 4,562,797
Percent of budget expended 46.32%
$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 36 of 39
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 835,676 835,676 0.00%
May 835,676 835,676 0.00%
Jun 1,776,589 1,776,589 0.00%
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 22.20%
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 1,221,630 1,221,630 0.00%
May 2,385,254 2,385,254 0.00%
Jun 2,587,016 2,587,016 0.00%
Jul 2,415,788
Aug 2,760,900
Sep 3,106,013
Oct 3,451,125
Nov 3,796,238
Dec 4,141,350
Percent of budget expended 62.47%
$‐
$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 37 of 39
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2013 Budget Year
Utilities Budget Revenue Expense
Jan 3,829,376 5,451,016 3,091,235
Feb 8,589,616 10,484,839 7,162,971
Mar 13,047,174 16,704,949 12,742,494
Apr 17,968,338 21,897,618 17,525,965
May 22,562,679 27,540,401 22,717,408
Jun 29,148,341 33,144,751 28,759,364
Jul 35,053,685
Aug 40,236,656
Sep 45,248,315
Oct 51,131,985
Nov 56,094,010
Dec 76,780,407
Percent of budget expended 39.50%
Note: Operations and Capital
$0
$10
$20
$30
$40
$50
$60
$70
$80
$90
Millions Utilities
Budget
Revenue
Expense
$20 00
Millions Airport
Airport Budget Revenue Expense
Jan 935,162 197,380 132,655
Feb 2,083,969 816,583 272,568
Mar 3,069,357 1,033,561 551,940
Apr 4,275,510 1,326,892 679,773
May 5,852,168 1,542,344 1,344,469
Jun 7,982,426 2,240,528 2,131,340
Jul 8,966,127
Aug 10,412,537
Sep 11,390,616
Oct 13,465,777
Nov 14,454,537
Dec 18,740,730
Percent of budget expended 11.37%
Note: Operations and Capital
$‐
$2.00
$4.00
$6.00
$8.00
$10.00
$12.00
$14.00
$16.00
$18.00
$20.00
Budget
Revenue
Expense
Page 38 of 39
City of Renton
Monthly Enterprise Fund Financial Report ‐ 2013 Budget Year
Golf Course Budget Revenue Expense
Jan 138,483 59,391 129,801
Feb 283,549 161,197 254,957
Mar 587,345 291,654 404,017
Apr 749,859 505,367 579,467
May 958,900 747,089 721,090
Jun 1,133,021 1,010,936 914,581
Jul 1,331,819
Aug 1,513,051
Sep 1,688,936
Oct 1,864,635
Nov 2,024,142
Dec 2,632,848
Percent of budget expended 34.74%
Note: Operations and Capital
$‐
$0.30
$0.60
$0.90
$1.20
$1.50
$1.80
$2.10
$2.40
$2.70
$3.00
Millions Golf Course
Budget
Revenue
Expense
Page 39 of 39