|
City of Mounds ViewWater Utility 2010 Rate Study4.95% 3.00% 3.00% 3.00% 3.00%ActualActualActual Budget Projected Projected Projected Projected Projected2007 2008 2009 2010 2011 2012 2013 2014 2015ExpensesPersonnel services 284,860$ 272,944$ 280,284$ 298,647$ 300,140$ 309,144$ 318,419$ 327,971$ 337,810$ Supplies & materials 40,308 54,186 56,103 61,711 62,328 64,198 66,124 68,108 70,151 Contractual services 173,169 153,371 180,996 205,617 207,673 213,903 220,320 226,930 233,738 Water service line repairs 39,935 55,824 41,271 50,000 50,000 51,500 53,045 54,636 56,275 Depreciation 208,320 209,839 230,375 215,000 228,000 230,000 240,000 245,000 245,000 Debt service - interest 42,349 37,431 30,919 28,195 21,475 14,380 6,725 - - Transfers to other funds 76,422 108,115 169,859 181,655 223,505 225,410 227,372 229,393 231,475 Contingency - - - 15,000 15,000 15,000 15,000 15,000 15,000 Total Expenses865,363 891,710 989,807 1,055,825 1,108,122 1,123,536 1,147,005 1,167,038 1,189,450 Revenues6.25% 2.94% 2.86% 2.78% 0.00%Metered water sales 710,279 734,709 764,101 787,052 841,235 865,978 890,720 915,462 915,462 Meter charge44,305 1,859 2,451 - - - - - - Water tower space rental55,480 60,390 62,832 59,197 67,959 70,677 73,504 76,445 79,502 Water service line repair fee47,310 47,587 50,547 51,500 51,500 51,500 51,500 51,500 51,500 Investment income107,137 72,980 33,770 31,250 22,181 14,822 9,955 6,719 10,668 Miscellaneous revenues4,906 5,964 5,288 3,250 3,250 3,348 3,448 3,551 3,658 Capital contributions- - 42,475 - - - - - - Transfers from vehicle fund- - - - 389,000 30,000 28,000 - - Total Revenues969,417 923,489 961,464 932,249 1,375,126 1,036,324 1,057,128 1,053,677 1,060,791 Net Income104,054 31,779 (28,343) (123,576) 267,004 (87,211) (89,877) (113,361) (128,659) Net assets - begining of year4,467,968 4,572,022 4,603,801 4,575,458 4,451,882 4,718,886 4,631,675 4,541,797 4,428,436 Net assets - end of year4,572,022$ 4,603,801$ 4,575,458$ 4,451,882$ 4,718,886$ 4,631,675$ 4,541,797$ 4,428,436$ 4,299,777$ Cash flowsDeduct:Capital outlays - equipment 28,644$ 341,323$ 47,836$ 13,000$ 100,000$ 30,000$ 28,000$ -$ -$ Construction - 17,530 - 393,700 800,000 60,000 - - 144,000 Debt service - principal 185,000 190,000 200,000 205,000 210,000 215,000 230,000 - - Add back:Depreciation208,320 209,839 230,375 215,000 228,000 230,000 240,000 245,000 245,000 Change in receivables/payables15,473 (7,378) (12,227) - - - - - - Cash - Beginning of Year1,887,772 2,001,975 1,687,362 1,629,331 1,109,055 494,059 331,848 223,971 355,609 Cash - End of Year2,001,975$ 1,687,362$ 1,629,331$ 1,109,055$ 494,059$ 331,848$ 223,971$ 355,609$ 327,950$ ResidentialWater rate 1st 15,000 gallons used 1.50$ 1.55$ 1.60$ 1.60$ 1.70$ 1.75$ 1.80$ 1.85$ 1.85$ Water rate 2nd 15,000 gallons used 1.76 1.87 1.93 1.98 2.04 2.04 Water rate over 30,000 gallons used 2.02 2.15 2.21 2.28 2.34 2.34 Residential annual based on 20,000 gal. per quarter 120.00 124.00 128.00 131.20 139.40 143.50 147.60 151.70 151.70 18
|