|
City of Mounds View
<br />Water Utility 2016 Rate Study
<br />2.50%2.50%3.00%3.00%3.00%
<br />Actual Actual Actual Budget Projected Projected Projected Projected Projected
<br />2013 2014 2015 2016 2017 2018 2019 2020 2021
<br />Expenses
<br />Personnel services 269,496$ 336,366$ 358,006$ 365,080$ 374,207$ 383,562$ 395,069$ 406,921$ 419,129$
<br />Supplies & materials 82,820 86,392 73,378 67,274 68,956 70,680 72,800 74,984 77,234
<br />Contractual services 256,584 211,884 231,748 263,081 269,658 276,399 284,691 293,232 302,029
<br />Water service line repairs 170,240 121,561 71,104 80,000 80,000 80,000 82,000 82,000 84,000
<br />Depreciation 251,946 254,991 277,657 255,000 275,000 275,000 275,000 275,000 275,000
<br />Debt service - interest 680 - - - - - - - -
<br />Transfers to other funds 225,372 129,393 - 162,619 139,828 143,103 145,446 147,859 150,345
<br />Contingency - - - 15,000 15,000 15,000 15,000 15,000 15,000
<br />Total Expenses 1,257,138 1,140,587 1,011,893 1,208,054 1,222,649 1,243,744 1,270,007 1,294,996 1,322,737
<br />Revenues
<br />Metered water sales 858,188 845,981 869,911 966,974 956,876 1,023,448 1,090,020 1,130,642 1,130,642
<br />Meter charge 1,269 855 3,208 1,000 1,000 1,000 1,000 1,000 1,000
<br />Water service line repair fee 54,980 65,848 83,413 85,000 85,000 85,000 85,000 85,000 85,000
<br />Investment income (charges)(8,287) 8,909 (1,995) 1,000 (1,965) (1,651) 634 2,724 6,770
<br />Miscellaneous revenues 8,470 64,079 2,598 2,000 2,676 2,756 2,839 2,924 3,012
<br />Transfers from vehicle & equipment fund - 72,000 - - 156,000 - - 125,000 -
<br />Total Revenues 914,620 1,057,672 957,135 1,055,974 1,199,586 1,110,553 1,179,493 1,347,291 1,226,424
<br />Change in net position (342,518) (82,915) (54,758) (152,080) (23,063) (133,192) (90,514) 52,294 (96,312)
<br />Accounting change (GASB 68 pension)(196,062)
<br />Net position - begining of year 4,418,195 4,075,677 3,992,762 3,741,942 3,589,862 3,566,799 3,433,607 3,343,094 3,395,388
<br />Net position - end of year 4,075,677$ 3,992,762$ 3,741,942$ 3,589,862$ 3,566,799$ 3,433,607$ 3,343,094$ 3,395,388$ 3,299,076$
<br />Cash flows
<br />Change in net position (342,518)$ (82,915)$ (54,758)$ (152,080)$ (23,063)$ (133,192)$ (90,514)$ 52,294$ (96,312)$
<br />Deduct:
<br />Capital outlays - equipment (29,669) (83,628) - (133,708) (156,000) - - (125,000) -
<br />Construction (27,477) (325,981) (216,802) (105,000) (75,000) - (80,000) - -
<br />Debt service - principal (230,000) - - - - - - - -
<br />Add back:
<br />Depreciation 251,946 254,991 277,657 255,000 275,000 275,000 275,000 275,000 275,000
<br />Change in receivables/payables (cashflow stmt.)7,285 148,327 (16,906) - - - - - -
<br />Cash - Beginning of Year 475,213 104,780 15,574 4,765 (131,023) (110,085) 31,723 136,209 338,503
<br />Cash - End of Year 104,780$ 15,574$ 4,765$ (131,023)$ (110,085)$ 31,723$ 136,209$ 338,503$ 517,191$
<br />Residential 5.56%5.26%5.00%15.36%4.44%8.20%7.58%3.40%0.00%
<br />Base rate per connection -$ -$ -$ 6.00$ 8.00$ 10.00$ 12.00$ 12.00$ 12.00$
<br />Water rate 1st 12,000 gallons used (15,000)1.90 2.00 2.10 2.10 2.10 2.20 2.30 2.40 2.40
<br />Water rate 2nd 13,000 gallons used (15,000)2.09 2.20 2.31 2.31 2.31 2.42 2.53 2.64 2.64
<br />Water rate over 25,000 gallons used (30,000)2.40 2.53 2.66 2.66 2.66 2.78 2.91 3.04 3.04
<br />Residential ann. based on 18,000 gal. per qtr.141.36 148.80 156.24 180.24 188.24 203.68 219.12 226.56 226.56 17
|