|
City of Mounds View
<br />Sewer Utility 2016 Rate Study
<br />2.5%2.5%3%3%3%
<br />Actual Actual Actual Budget Projected Projected Projected Projected Projected
<br />2012 2013 2014 2015 2016 2017 2018 2019 2020
<br />Expense
<br />Personnel services 282,758$ 293,644$ 317,133$ 350,953$ 359,727$ 368,720$ 379,782$ 391,175$ 402,910$
<br />Supplies & materials 30,976 19,347 28,738 36,354 37,263 38,194 39,340 40,520 41,736
<br />Contractual services 50,016 109,405 75,053 114,127 116,980 119,905 123,502 127,207 131,023
<br />MCES disposal charges 760,913 816,267 827,962 832,084 852,886 874,208 900,435 927,448 955,271
<br />Depreciation 165,698 166,533 165,752 167,000 167,000 167,000 167,000 167,000 167,000
<br />Transfers to other funds 247,807 249,361 230,962 249,611 240,309 102,028 103,829 105,684 107,595
<br />Contingency - - - 15,000 15,000 15,000 15,000 15,000 15,000
<br />Total Expenses 1,538,168 1,654,557 1,645,600 1,765,129 1,789,165 1,685,055 1,728,887 1,774,034 1,820,535
<br />1,600,150 1,682,622
<br />Revenues 4.00%5.00%6.00%8.00%6.00%4.00%4.00%5.00%
<br />Sanitary sewer service 1,191,406 1,234,628 1,324,800 1,416,821 1,526,422 1,606,086 1,670,329 1,737,142 1,823,999
<br />Service availability charges 350 850 1,200 - - - - - -
<br />Investment income 31,367 (79,782) 128,383 30,000 25,302 24,246 31,573 42,967 52,252
<br />Miscellaneous revenues 750 - 30,000 - - - - - -
<br />Transfers from vehicle fund - - - - 60,000 - - 140,000 -
<br />Total Revenues 1,223,873 1,155,696 1,484,383 1,446,821 1,611,724 1,630,331 1,701,902 1,920,109 1,876,252
<br />Change in net position (314,295) (498,861) (161,217) (318,308) (177,441) (54,724) (26,985) 146,075 55,716
<br />Net position - beginning of year 5,228,379 4,914,084 4,415,223 4,254,006 3,935,698 3,758,258 3,703,533 3,676,548 3,822,623
<br />Net position - end of year 4,914,084 4,415,223 4,254,006 3,935,698 3,758,258 3,703,533 3,676,548 3,822,623 3,878,340
<br />Cash Flows
<br />Change in net position (314,295) (498,861) (161,217) (318,308) (177,441) (54,724) (26,985) 146,075 55,716
<br />Deduct:
<br />Capital outlays - equipment (7,492) - (7,308) (14,750) (60,000) - - (140,000) -
<br />Construction - - - (600,000) - (150,000) - (150,000) -
<br />Add back:
<br />Depreciation 165,698 166,533 165,752 167,000 167,000 167,000 167,000 167,000 167,000
<br />Change in receivables/payables 53,561 (2,320) (90,532) - - - - - -
<br />Cash - Beginning of Year 2,983,355 2,880,827 2,546,179 2,452,874 1,686,816 1,616,375 1,578,651 1,718,666 1,741,741
<br />Cash - End of Year 2,880,827$ 2,546,179$ 2,452,874$ 1,686,816$ 1,616,375$ 1,578,651$ 1,718,666$ 1,741,741$ 1,964,457$
<br />Residential equivalent connection rate 60.79$ 63.22$ 66.38$ 70.36$ 75.99$ 80.55$ 83.77$ 87.13$ 91.48$
<br />Residential fixed rate 24.75 25.74 27.03 28.65 30.94 32.80 34.11 35.47 37.25
<br />Residential variable rate 1.97 2.05 2.15 2.28 2.46 2.61 2.72 2.83 2.97
<br />Annual based on 20,000 gal. per quarter 256.60 266.96 280.31 297.13 320.90 340.15 353.76 367.91 386.30
<br />MCES Rate increase -1.95%7.27%1.43%0.50%2.50%2.50%3.00%3.00%3.00%18
|