|
City of Mounds View
<br />Sewer Utility 2012 Rate Study
<br />2.0%3%3%3%3%
<br />Actual Actual Actual Budget Projected Projected Projected Projected Projected
<br />2009 2010 2011 2012 2013 2014 2015 2016 2017
<br />Expense
<br />Personnel services 248,314$ 268,220$ 268,609$ 294,971$ 300,870$ 309,897$ 319,193$ 328,769$ 338,632$
<br />Supplies & materials 15,421 16,016 21,672 24,070 24,551 25,288 26,047 26,828 27,633
<br />Contractual services 62,134 37,717 104,802 97,389 68,218 70,265 72,372 74,544 76,780
<br />MCES disposal charges 733,120 776,845 776,066 760,913 776,131 799,415 823,398 848,100 873,543
<br />Depreciation 157,989 156,757 161,512 160,000 163,000 165,000 165,000 165,000 165,000
<br />Transfers to other funds 233,411 244,833 246,298 247,807 249,360 250,962 252,611 92,611 94,309
<br />Contingency - - - 15,000 15,000 15,000 15,000 15,000 15,000
<br />Total Expenses 1,450,389 1,500,388 1,578,959 1,600,150 1,597,131 1,635,826 1,673,621 1,550,851 1,590,897
<br />Revenues 4.24%4.00%4.00%4.00%4.00%3.00%
<br />Sanitary sewer service 1,150,058 1,166,489 1,181,097 1,257,770 1,307,099 1,359,383 1,413,759 1,470,309 1,514,418
<br />Contractual wastewater 74 - - - - - - - -
<br />Service availability charges (15,480) 420 1,043 4,000 4,120 4,244 4,371 4,502 4,637
<br />Investment income 77,662 47,990 59,917 45,000 53,729 78,519 77,658 77,273 82,260
<br />Miscellaneous revenues 2,125 - 30,204 - - - - - -
<br />Capital contributions 42,475 - - - - - - - -
<br />Transfers from vehicle fund - - 300,000 - - - - 30,000 -
<br />Total Revenues 1,256,914 1,214,899 1,572,261 1,306,770 1,364,949 1,442,146 1,495,788 1,582,085 1,601,316
<br />Net Income (193,475) (285,489) (6,698) (293,380) (232,182) (193,680) (177,833) 31,233 10,419
<br />Net assets - beginning of year 5,714,041 5,520,566 5,235,077 5,228,379 4,934,999 4,702,817 4,509,137 4,331,304 4,362,537
<br />Net assets - end of year 5,520,566 5,235,077 5,228,379 4,934,999 4,702,817 4,509,137 4,331,304 4,362,537 4,372,956
<br />Cash Flows
<br />Net Income (193,475) (285,489) (6,698) (293,380) (232,182) (193,680) (177,833) 31,233 10,419
<br />Deduct:
<br />Capital outlays - equipment (42,475) (8,174) (311,684) (163,500) - - - (30,000) -
<br />Construction - - - - - - - - -
<br />Add back:
<br />Depreciation 157,989 156,757 161,512 160,000 163,000 165,000 165,000 165,000 165,000
<br />Change in receivables/payables (74,456) (4,225) 3,127 - - - - - -
<br />Cash - Beginning of Year 3,430,646 3,278,229 3,137,098 2,983,355 2,686,475 2,617,293 2,588,612 2,575,779 2,742,012
<br />Cash - End of Year 3,278,229$ 3,137,098$ 2,983,355$ 2,686,475$ 2,617,293$ 2,588,612$ 2,575,779$ 2,742,012$ 2,917,432$
<br />Residential equivalent connection rate 54.06$ 55.14$ 58.45$ 60.79$ 63.22$ 65.75$ 68.38$ 71.12$ 73.25$
<br />Residential fixed rate 22.01 22.45 23.80 24.75 25.74 26.77 27.84 28.95 29.82
<br />Residential variable rate 1.75 1.79 1.90 1.97 2.05 2.13 2.22 2.30 2.37
<br />Annual based on 20,000 gal. per quarter 228.04 232.96 247.20 256.60 266.86 277.54 288.64 300.19 309.19
<br />MCES Rate increase 5.33%5.96%-0.10%-1.95%2.00%3.00%3.00%3.00%3.00%17
|