|
City of Mounds View
<br />Water Utility 2011 Rate Study
<br />2.50%3.00%3.00%3.00%3.00%
<br />Actual Actual Actual Budget Projected Projected Projected Projected Projected
<br />2008 2009 2010 2011 2012 2013 2014 2015 2016
<br />Expenses
<br />Personnel services 272,944$ 280,284$ 286,099$ 302,077$ 309,629$ 318,918$ 328,485$ 338,340$ 348,490$
<br />Supplies & materials 54,186 56,103 58,433 70,626 72,392 74,563 76,800 79,104 81,477
<br />Contractual services 153,371 180,996 178,083 208,146 213,350$ 219,750 226,343 233,133 240,127
<br />Water service line repairs 55,824 41,271 32,654 50,000 51,500 53,045 54,636 56,275 57,964
<br />Depreciation 209,839 230,375 229,199 225,000 240,000 240,000 240,000 240,000 240,000
<br />Debt service - interest 37,431 30,919 24,432 21,450 14,380 6,725 - - -
<br />Transfers to other funds 108,115 169,859 181,655 220,505 222,410 224,372 226,393 228,475 130,619
<br />Contingency - - - 15,000 15,000 15,000 15,000 15,000 15,000
<br />Total Expenses 891,710 989,807 990,555 1,112,804 1,138,660 1,152,373 1,167,658 1,190,328 1,113,677
<br />Revenues
<br />Metered water sales 734,709 764,101 762,106 787,052 870,276 918,625 966,974 991,148 1,015,322
<br />Meter charge 1,859 2,451 4,090 - - - - - -
<br />Water tower space rental 60,390 62,832 62,539 - - - - - -
<br />Water service line repair fee 47,587 50,547 52,092 51,500 51,500 51,500 51,500 51,500 51,500
<br />Investment income 72,980 33,770 20,946 31,250 15,109 6,148 1,261 3,371 (2,776)
<br />Miscellaneous revenues 5,964 5,288 8,134 3,000 3,090 3,183 3,278 3,377 3,478
<br />Capital contributions - 42,475 - - - - - - -
<br />Transfers from vehicle fund - - - 289,000 - - - 128,000 -
<br />Total Revenues 923,489 961,464 909,907 1,161,802 939,975 979,456 1,023,013 1,177,396 1,067,524
<br />Net Income 31,779 (28,343) (80,648) 48,998 (198,685) (172,917) (144,645) (12,932) (46,153)
<br />Net assets - begining of year 4,572,022 4,603,801 4,575,458 4,494,810 4,543,808 4,345,123 4,172,206 4,027,561 4,014,629
<br />Net assets - end of year 4,603,801$ 4,575,458$ 4,494,810$ 4,543,808$ 4,345,123$ 4,172,206$ 4,027,561$ 4,014,629$ 3,968,476$
<br />Cash flows
<br />Deduct:
<br />Capital outlays - equipment 341,323$ 47,836$ -$ 28,500$ -$ -$ -$ 128,000$ -$
<br />Construction 17,530 - 121,903 917,700 125,000 - 25,000 304,000 -
<br />Debt service - principal 190,000 200,000 205,000 210,000 215,000 230,000 - - -
<br />Add back:
<br />Depreciation 209,839 230,375 229,199 225,000 240,000 240,000 240,000 240,000 240,000
<br />Change in receivables/payables (7,378) (12,227) (65,148) - - - - - -
<br />Cash - Beginning of Year 2,001,975 1,687,362 1,629,331 1,385,831 503,629 204,944 42,027 112,382 (92,550)
<br />Cash - End of Year 1,687,362$ 1,629,331$ 1,385,831$ 503,629$ 204,944$ 42,027$ 112,382$ (92,550)$ 101,297$
<br />Residential 5.88%5.56%5.26%2.50%2.44%
<br />Water rate 1st 15,000 gallons used 1.55$ 1.60$ 1.60$ 1.70$ 1.80$ 1.90$ 2.00$ 2.05$ 2.10$
<br />Water rate 2nd 15,000 gallons used 1.76 1.87 1.98 2.09 2.20 2.26 2.31
<br />Water rate over 30,000 gallons used 2.02 2.15 2.28 2.40 2.53 2.59 2.66
<br />Residential annual based on 20,000 gal. per quarter 124.00 128.00 131.20 139.40 147.60 155.80 164.00 168.10 172.20
<br />C/I annual based on 215,000 gal. per quarter 1,417.60 1,506.20 1,594.80 1,683.40 1,772.00 1,816.30 1,860.60 18
|