|
City of Mounds View
<br />Water Utility 2012 Rate Study
<br />2.00%3.00%3.00%3.00%3.00%
<br />Actual Actual Actual Budget Projected Projected Projected Projected Projected
<br />2009 2010 2011 2012 2013 2014 2015 2016 2017
<br />Expenses
<br />Personnel services 280,284$ 286,099$ 296,227$ 314,894$ 321,192$ 330,828$ 340,752$ 350,975$ 361,504$
<br />Supplies & materials 56,103 58,433 61,031 75,541 62,777 64,660 66,600 68,598 70,656
<br />Contractual services 180,996 178,083 208,128 194,639$ 198,532 204,488 210,622 216,941 223,449
<br />Water service line repairs 41,271 32,654 65,267 50,000 51,000 52,530 54,106 55,729 57,401
<br />Depreciation 230,375 229,199 213,184 240,000 225,000 225,000 225,000 225,000 223,000
<br />Debt service - interest 30,919 24,432 18,550 13,680 6,725 - - - -
<br />Transfers to other funds 169,859 181,655 221,505 223,410 227,372 229,393 231,475 138,619 136,475
<br />Contingency - - - 15,000 15,000 15,000 15,000 15,000 15,000
<br />Total Expenses 989,807 990,555 1,083,892 1,127,164 1,107,598 1,121,899 1,143,556 1,070,862 1,087,486
<br />Revenues
<br />Metered water sales 764,101 762,106 772,655 787,052 863,505 908,952 931,676 954,400 977,124
<br />Meter charge 2,451 4,090 3,859 - 1,500 1,500 1,500 1,500 1,500
<br />Water tower space rental 62,832 62,539 - - - - - - -
<br />Water service line repair fee 50,547 52,092 52,258 51,500 51,500 51,500 51,500 51,500 51,500
<br />Investment income 33,770 20,946 23,536 31,250 (723) (3,629) (4,047) (8,821) (5,700)
<br />Miscellaneous revenues 5,288 8,134 9,929 3,000 3,060 3,152 3,246 3,344 3,444
<br />Capital contributions 42,475 - (153) - - - - - -
<br />Transfers from vehicle & equipment fund - - - 289,000 - - 128,000 - -
<br />Total Revenues 961,464 909,907 862,084 1,161,802 918,842 961,475 1,111,875 1,001,923 1,027,868
<br />Net Income (28,343) (80,648) (221,808) 34,638 (188,756) (160,423) (31,680) (68,939) (59,617)
<br />Net assets - begining of year 4,603,801 4,575,458 4,494,810 4,273,002 4,307,640 4,118,885 3,958,461 3,926,781 3,857,841
<br />Net assets - end of year 4,575,458$ 4,494,810$ 4,273,002$ 4,307,640$ 4,118,885$ 3,958,461$ 3,926,781$ 3,857,841$ 3,798,224$
<br />Cash flows
<br />Deduct:
<br />Capital outlays - equipment 47,836$ -$ 82,389$ 52,200$ -$ -$ 128,000$ -$ -$
<br />Construction - 121,903 126,772 1,097,700 - 25,000 304,000 - -
<br />Debt service - principal 200,000 205,000 210,000 215,000 230,000 - - - -
<br />Add back:
<br />Depreciation 230,375 229,199 213,184 240,000 225,000 225,000 225,000 225,000 223,000
<br />Change in receivables/payables (12,227) (65,148) 84,034 - - - - - -
<br />Cash - Beginning of Year 1,687,362 1,629,331 1,385,831 1,042,080 (48,182) (241,937) (202,361) (441,041) (284,980)
<br />Cash - End of Year 1,629,331$ 1,385,831$ 1,042,080$ (48,182)$ (241,937)$ (202,361)$ (441,041)$ (284,980)$ (121,598)$
<br />Residential 0.00%6.25%5.88%5.56%5.26%2.50%2.44%2.38%
<br />Water rate 1st 15,000 gallons used 1.60$ 1.60$ 1.70$ 1.80$ 1.90$ 2.00$ 2.05$ 2.10$ 2.15$
<br />Water rate 2nd 15,000 gallons used 1.76 1.87 1.98 2.09 2.20 2.26 2.31 2.37
<br />Water rate over 30,000 gallons used 2.02 2.15 2.28 2.40 2.53 2.59 2.66 2.72
<br />Residential annual based on 20,000 gal. per quarter 128.00 131.20 139.40 147.60 155.80 164.00 168.10 172.20 176.30
<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 1,904.90 16
|