|
City of Mounds ViewSewer Utility 2009 Rate Study0% 3% 3% 3% 3%ActualActualActual Budget Projected Projected Projected Projected Projected2006 2007 2008 2009 2010 2011 2012 2013 2014ExpensePersonnel services 229,442$ 237,048$ 219,075$ 282,630$ 282,630$ 284,043$ 292,564$ 301,341$ 310,382$ Supplies & materials 12,516 19,793 13,126 22,588 22,588 23,266 23,964 24,683 25,423 Contractual services 56,525 62,738 96,484 182,667 182,667 188,147 193,791 199,605 205,593 MCES disposal charges 638,631 637,078 696,031 733,120 740,451 762,665 785,545 809,111 833,384 Depreciation 166,369 153,063 153,931 165,000 165,000 165,000 165,000 165,000 165,000 Transfers to other funds 78,560 80,688 142,030 83,411 84,832 86,297 87,806 89,361 90,962 Contingency- - - - - - - - - Total Expenses1,182,043 1,190,408 1,320,677 1,469,416 1,478,168 1,509,418 1,548,670 1,589,101 1,630,744 RevenuesSanitary sewer service 1,091,937 1,038,677 1,113,907 1,115,828 1,118,324 1,140,690 1,174,911 1,210,159 1,246,463 Contractual wastewater36,219 30,391 12,891 17,000 - - - - - Service availability charges 104,000 (3,251) 7,405 4,000 4,000 4,120 4,120 4,120 4,120 Investment income 147,868 187,916 149,549 108,750 64,246 85,086 74,166 65,768 56,963 Miscellaneous revenues 490,064 579 1,789 500 500 515 530 546 563 Capital contributions 29,027 - - - - - - - - Transfers from vehicle fund - - - - 350,000 30,000 - - - Total Revenues1,899,115 1,254,312 1,285,541 1,246,078 1,537,070 1,260,412 1,253,728 1,280,593 1,308,109 Net Income 717,072 63,904 (35,136) (223,338) 58,902 (249,006) (294,942) (308,508) (322,636) Net assets - beginning of year4,968,201 5,685,273 5,749,177 5,714,041 5,490,703 5,549,605 5,300,599 5,005,657 4,697,149 Net assets - end of year5,685,273 5,749,177 5,714,041 5,490,703 5,549,605 5,300,599 5,005,657 4,697,149 4,374,513 Cash FlowsNet Income717,072 63,904 (35,136) (223,338) 58,902 (249,006) (294,942) (308,508) (322,636) Deduct:Capital outlays - equipment (2,516) (37,455) (4,758) (10,000) (450,000) (130,000) - - - Construction (500,219) - - (150,000) (150,000) (150,000) (150,000) (150,000) (150,000) Add back:Depreciation 166,369 153,063 153,931 165,000 165,000 165,000 165,000 165,000 165,000 Change in receivables/payables4,787 27,514 (48,527) - - - - - - Cash - Beginning of Year2,772,617 3,158,110 3,365,136 3,430,646 3,212,308 2,836,210 2,472,204 2,192,262 1,898,753 Cash - End of Year3,158,110$ 3,365,136$ 3,430,646$ 3,212,308$ 2,836,210$ 2,472,204$ 2,192,262$ 1,898,753$ 1,591,118$ Residential equivalent connection rate 47.00$ 47.00$ 53.00$ 53.00$ 54.06$ 55.14$ 56.80$ 58.50$ 60.25$ Residential fixed rate 21.58 21.58 21.58 21.58 22.01 22.45 23.13 23.82 24.53 Residential variable rate 1.72 1.72 1.72 1.72 1.75 1.79 1.84 1.90 1.96 Annual based on 20,000 gal. per quarter223.92 223.92 223.92 223.92 228.40 232.97 239.96 247.15 254.57 Contractual rate 2.4932 2.4932 2.4932 2.4932 2.4932 2.4932 2.4932 2.4932 2.4932 Contractual useage per month 1,211 1,015 431 570 - - - - - 18
|