|
City of Mounds View
<br />Sewer Utility 2011 Rate Study
<br />2.5%3%3%3%3%
<br />Actual Actual Actual Budget Projected Projected Projected Projected Projected
<br />2008 2009 2010 2011 2012 2013 2014 2015 2016
<br />Expense
<br />Personnel services 219,075$ 248,314$ 268,220$ 282,411$ 289,471$ 298,155$ 307,100$ 316,313$ 325,802$
<br />Supplies & materials 13,126 15,421 16,016 21,563 22,210 22,876 23,562 24,269 24,997
<br />Contractual services 96,484 62,134 37,717 191,543 64,768 66,711 68,712 70,774 72,897
<br />MCES disposal charges 696,031 733,120 776,845 776,066 795,468 819,332 843,912 869,229 895,306
<br />Depreciation 153,931 157,989 156,757 160,000 165,000 165,000 165,000 165,000 165,000
<br />Transfers to other funds 142,030 233,411 244,833 246,298 247,806 249,360 250,962 252,611 92,611
<br />Contingency - - - - - - - - -
<br />Total Expenses 1,320,677 1,450,389 1,500,388 1,677,881 1,584,723 1,621,434 1,659,249 1,698,196 1,576,614
<br />Revenues 6.00%4.00%4.00%4.00%4.00%4.00%
<br />Sanitary sewer service 1,113,907 1,150,058 1,166,489 1,209,106 1,257,470 1,307,769 1,360,079 1,414,483 1,471,062
<br />Contractual wastewater 12,891 74 - - - - - - -
<br />Service availability charges 7,405 (15,480) 420 300 309 318 328 338 348
<br />Investment income 149,549 77,662 47,990 60,000 57,622 83,004 81,044 79,460 78,292
<br />Miscellaneous revenues 1,789 2,125 - - - - - - -
<br />Capital contributions - 42,475 - - - - - - -
<br />Transfers from vehicle fund - - - 330,000 - - - - 30,000
<br />Total Revenues 1,285,541 1,256,914 1,214,899 1,599,406 1,315,401 1,391,091 1,441,451 1,494,280 1,579,702
<br />Net Income (35,136) (193,475) (285,489) (78,475) (269,322) (230,343) (217,798) (203,916) 3,088
<br />Net assets - beginning of year 5,749,177 5,714,041 5,714,041 5,428,552 5,350,077 5,080,756 4,850,412 4,632,615 4,428,698
<br />Net assets - end of year 5,714,041 5,520,566 5,428,552 5,350,077 5,080,756 4,850,412 4,632,615 4,428,698 4,431,787
<br />Cash Flows
<br />Net Income (35,136) (193,475) (285,489) (78,475) (269,322) (230,343) (217,798) (203,916) 3,088
<br />Deduct:
<br />Capital outlays - equipment (4,758) (42,475) (8,174) (337,500) (10,000) - - - (30,000)
<br />Construction - - - - - - - - -
<br />Add back:
<br />Depreciation 153,931 157,989 156,757 160,000 165,000 165,000 165,000 165,000 165,000
<br />Change in receivables/payables (48,527) (74,456) (4,225) - - - - - -
<br />Cash - Beginning of Year 3,365,136 3,430,646 3,278,229 3,137,098 2,881,123 2,766,801 2,701,458 2,648,660 2,609,744
<br />Cash - End of Year 3,430,646$ 3,278,229$ 3,137,098$ 2,881,123$ 2,766,801$ 2,701,458$ 2,648,660$ 2,609,744$ 2,747,832$
<br />Residential equivalent connection rate 53.00$ 54.06$ 55.14$ 58.45$ 60.79$ 63.22$ 65.75$ 68.38$ 71.11$
<br />Residential fixed rate 21.58 22.01 22.45 23.80 24.75 25.74 26.77 27.84 28.95
<br />Residential variable rate 1.72 1.75 1.79 1.90 1.97 2.05 2.13 2.22 2.31
<br />Annual based on 20,000 gal. per quarter 223.92 228.04 232.96 246.94 256.82 267.09 277.77 288.88 300.44
<br />MCES Rate increase 9.25%5.33%5.96%-0.10%2.50%3.00%3.00%3.00%3.00%19
|