|
City of Mounds View
<br />Water Utility Rate Study
<br />2.50%2.50%3.00%3.00%3.00%
<br />Actual Actual Actual Budget Projected Projected Projected Projected Projected
<br />2014 2015 2016 2017 2018 2019 2020 2021 2022
<br />Expenses
<br />Personnel services 336,366$ 358,006$ 370,512$ 372,274$ 382,512$ 393,987$ 405,806$ 417,981$ 430,520$
<br />Supplies & materials 86,392 73,378 64,640 74,999 76,874 78,796 81,160 83,594 86,102
<br />Contractual services 211,884 231,748 242,961 254,070 260,422 266,932 274,940 283,188 291,684
<br />Water service line repairs 121,561 71,104 82,048 80,000 80,000 82,000 82,000 84,000 84,000
<br />Depreciation 254,991 277,657 240,583 270,000 241,000 241,000 241,000 241,000 241,000
<br />Debt service - - - - - - - 41,075 97,926
<br />Transfers to other funds 129,393 - - 139,828 144,103 146,446 148,859 151,345 151,345
<br />Contingency - - - 15,000 15,000 15,000 15,000 15,000 15,000
<br />Total Expenses 1,140,587 1,011,893 1,000,744 1,206,171 1,199,910 1,224,161 1,248,765 1,317,184 1,397,578
<br />Revenues
<br />Metered water sales 845,981 869,911 971,654 1,025,376 1,115,301 1,183,558 1,248,824 1,280,804 1,315,608
<br />Meter charge 855 3,208 1,564 - - - - - -
<br />Water service line repair fee 65,848 83,413 87,775 85,000 85,000 85,000 85,000 85,000 85,000
<br />Investment income (charges)8,909 (1,995) (648) 500 1,652 5,160 (3,311) 49,258 17,790
<br />Miscellaneous revenues 64,079 2,598 3,644 4,000 4,120 4,223 4,350 4,480 4,615
<br />Transfers from vehicle & equipment fund 72,000 - - 35,000 - - 125,000 - -
<br />Total Revenues 1,057,672 957,135 1,063,989 1,149,876 1,206,073 1,277,941 1,459,863 1,419,542 1,423,012
<br />Change in net position (82,915) (54,758) 63,245 (56,295) 6,163 53,780 211,097 102,358 25,435
<br />Accounting change (GASB 68 pension)(196,062)
<br />Net position - begining of year 4,075,677 3,992,762 3,741,942 3,805,187 3,748,892 3,755,055 3,808,835 4,019,932 4,122,290
<br />Net position - end of year 3,992,762$ 3,741,942$ 3,805,187$ 3,748,892$ 3,755,055$ 3,808,835$ 4,019,932$ 4,122,290$ 4,147,725$
<br />Cash flows
<br />Change in net position (82,915)$ (54,758)$ 63,245$ (56,295)$ 6,163$ 53,780$ 211,097$ 102,358$ 25,435$
<br />Deduct:
<br />Capital outlays - equipment (83,628) - (29,263) (127,640) - (128,000) - - -
<br />Construction (325,981) (216,802) - (57,000) (50,000) (700,000) (2,150,000) (1,650,000) -
<br />Debt service - principal - - - - - - - (266,753) (269,420)
<br />Add back:
<br />Bonds issued - - - - - - 4,350,000 - -
<br />Depreciation 254,991 277,657 240,583 270,000 241,000 241,000 241,000 241,000 241,000
<br />Change in receivables/payables (cashflow stmt.)148,327 (16,906) (161,548) - - - - - -
<br />Cash - Beginning of Year 104,780 15,574 4,765 117,782 146,847 344,010 (189,210) 2,462,887 889,493
<br />Cash - End of Year 15,574$ 4,765$ 117,782$ 146,847$ 344,010$ (189,210)$ 2,462,887$ 889,493$ 886,507$
<br />Residential 5.26%5.00%15.36%4.44%12.45%7.29%5.28%3.11%3.24%
<br />Base rate per connection -$ -$ 6.00$ 8.00$ 12.00$ 14.00$ 17.00$ 17.00$ 19.00$
<br />Water rate 1st 12,000 gallons used 2.00 2.10 2.10 2.10 2.20 2.30 2.30 2.40 2.40
<br />Water rate 2nd 13,000 gallons used 2.20 2.31 2.31 2.31 2.42 2.53 2.53 2.64 2.64
<br />Water rate over 25,000 gallons used 2.53 2.66 2.66 2.66 2.78 2.91 2.91 3.04 3.04
<br />Residential ann. based on 18,000 gal. per qtr.148.80 156.24 180.24 188.24 211.68 227.12 239.12 246.56 254.56
<br />C/I ann. based on 150,000 gal. per qtr.1,220.00 1,281.00 1,305.00 1,334.00 1,412.00 1,482.00 1,494.00 1,556.00 1,564.00 18
|