|
City of Mounds ViewWater Utility 2009 Rate Study0% 3% 3% 3% 3%ActualActualActual Budget Projected Projected Projected Projected Projected2006 2007 2008 2009 2010 2011 2012 2013 2014ExpensesPersonnel services 209,350$ 284,860$ 272,944$ 306,777$ 308,311$ 309,852$ 319,148$ 328,722$ 338,584$ Supplies & materials 38,549 40,308 54,186 62,928 62,928 64,816 66,760 68,763 70,826 Contractual services 129,429 173,169 153,371 288,948 288,948 297,616 306,545 315,741 325,214 Rehabilitate wells & tanks - - - - 60,000 - 60,000 - - Water service line repairs 51,991 39,935 55,824 45,000 45,000 46,350 47,741 49,173 50,648 Depreciation 230,125 208,320 209,839 220,000 223,000 225,000 240,000 245,000 245,000 Debt service - interest 46,941 42,349 37,431 34,475 28,070 21,375 14,305 6,675 - Transfers to other funds 73,735 76,422 108,115 79,859 81,655 85,503 85,409 87,371 89,392 Contingency- - - 15,000 15,000 15,000 15,000 15,000 15,000 Total Expenses780,120 865,363 891,710 1,052,987 1,112,912 1,065,513 1,154,908 1,116,446 1,134,664 RevenuesMetered water sales 736,624 710,279 734,709 764,717 793,730 840,420 887,110 933,800 980,490 Meter charge 39,267 44,305 1,859 - - - - - - Water tower space rental 68,940 55,480 60,390 60,007 65,407 68,024 70,745 73,574 76,517 Water service line repair fee 46,977 47,310 47,587 51,500 51,500 51,500 51,500 51,500 51,500 Investment income 68,238 107,137 72,980 46,875 29,054 2,162 (3,990) (10,323) (14,503) Miscellaneous revenues 585,976 4,906 5,964 3,250 3,250 3,348 3,448 3,551 3,658 Transfers from vehicle fund - - - - 253,000 - 30,000 28,000 - Total Revenues1,546,022 969,417 923,489 926,349 1,195,942 965,453 1,038,812 1,080,103 1,097,662 Net Income 765,902 104,054 31,779 (126,638) 83,030 (100,060) (116,095) (36,343) (37,002) Net assets - begining of year 3,702,066 4,467,968 4,572,022 4,603,801 4,477,163 4,560,193 4,460,133 4,344,037 4,307,694 Net assets - end of year4,467,968$ 4,572,022$ 4,603,801$ 4,477,163$ 4,560,193$ 4,460,133$ 4,344,037$ 4,307,694$ 4,270,693$ Cash flowsDeduct:Capital outlays - equipment 18,649$ 28,644$ 341,323$ 38,000$ 253,000$ -$ 30,000$ 28,000$ -$ Construction - - 17,530 90,000 1,228,700 120,000 90,000 90,000 180,000 Debt service - principal 180,000 185,000 190,000 200,000 205,000 210,000 215,000 230,000 - Add back:Depreciation 230,125 208,320 209,839 220,000 223,000 225,000 240,000 245,000 245,000 Change in receivables/payables(92,689) 15,473 (7,378) - - - - - - Cash - Beginning of Year1,183,083 1,887,772 2,001,975 1,687,362 1,452,724 72,054 (133,006) (344,101) (483,444) Cash - End of Year1,887,772$ 2,001,975$ 1,687,362$ 1,452,724$ 72,054$ (133,006)$ (344,101)$ (483,444)$ (455,446)$ Water rate per 1,000 gallons used 1.50$ 1.50$ 1.55$ 1.60$ 1.70$ 1.80$ 1.90$ 2.00$ 2.10$ Annual based on 20,000 gal. per quarter120.00 120.00 124.00 128.00 136.00 144.00 152.00 160.00 168.00 17
|