|
City of Mounds View
<br /> Sewer Utility 2007 Rate Study
<br /> 3% 3% 3% 3% 3%
<br /> Actual Actual Budget Projected Projected Projected Projected Projected
<br /> 2005 2006 2007 2008 2009 2010 2011 2012
<br /> Expenditures
<br /> Personnel services $ 233,846 $ 229,442 $ 256,006 $ 263,686 $ 271,597 $ 279,745 $ 288,137 $ 296,781
<br /> Supplies&materials 16,043 12,516 22,910 23,597 24,305 25,034 25,785 26,559
<br /> Contractual services 69,457 56,525 162,772 64,713 66,654 68,654 70,713 72,835
<br /> MCES disposal charges 654,806 638,631 637,078 656,190 675,876 696,152 717,037 738,548
<br /> Depreciation 185,426 166,369 190,000 195,700 201,571 207,618 213,847 220,262
<br /> Transfers to other funds 74,690 78,560 80,688 82,029 83,409 84,832 86,297 87,806
<br /> Contingency - - 15,000 15,000 15,000 15,000 15,000 15,000
<br /> Total Expenditures 1,234,267 1,182,043 1,364,454 1,300,916 1,338,412 1,377,035 1,416,816 1,457,791
<br /> Revenues
<br /> Sanitary sewer service 1,074,531 1,091,937 1,116,659 1,121,514 1,169,238 1,216,962 1,264,686 1,312,410
<br /> Contractual wastewater 37,336 36,219 39,027 55,035 57,377 59,719 62,061 64,403
<br /> Service availability charges (16,238) 104,000 4,000 4,120 4,244 4,371 4,502 4,502
<br /> Investment income 72,257 147,868 90,000 96,925 99,819 105,544 111,976 119,107
<br /> Miscellaneous revenues 16,355 490,064 500 6,807 7,011 7,222 7,438 7,662
<br /> Capital contributions - 29,027 - - - - -
<br /> Transfers from vehicle fund - 30,000 280,000 - - 30,000
<br /> Total Revenues 1,184,240 1,899,115 1,280,186 1,564,402 1,337,689 1,393,818 1,480,664 1,508,084
<br /> Net Income (50,027) 717,072 (84,268) 263,486 (723) 16,783 63,847 50,293
<br /> Net assets-beginning of year 5,018,228 4,968,201 5,685,273 5,685,273 5,948,759 5,948,036 5,964,818 6,028,666
<br /> Net assets-end of year $4,968,201 $596859273 $596019005 $599489759 $599489036 $599649818 $690289666 $69078,958
<br /> Cash Flows
<br /> Net Income $ (50,027) $ 717,072 $ (84,268) $ 263,486 $ (723) $ 16,783 $ 63,847 $ 50,293
<br /> Deduct:
<br /> Capital outlays-equipment (1,322) (2,516) (33,000) (280,000) - - (30,000) -
<br /> Construction - (500,219) - (10,000) (10,000) (10,000) (10,000) (10,000)
<br /> Add back:
<br /> Depreciation 185,426 166,369 190,000 195,700 201,571 207,618 213,847 220,262
<br /> Change in receivables/payables (128,468) 4,787 - - - - - -
<br /> Cash-Beginning of Year 2,767,008 2,772,617 3,158,110 3,158,110 3,327,296 3,518,144 3,732,544 3,970,238
<br /> Cash-End of Year $2,772,617 $3,1589110 $3,230,842 $3,3279296 $3,5189144 $3,732,544 $399709238 $4,2309793
<br /> Residential fixed rate $ 21.58 $ 21.58 $ 21.58 $ 21.58 $ 22.00 $ 22.90 $ 23.80 $ 24.69
<br /> Residential variable rate $ 1.72 $ 1.72 $ 1.72 $ 1.72 $ 1.79 $ 1.86 $ 1.94 $ 2.01
<br /> Annual based on 20,000 gallons per quarter $ 224 $ 224 $ 231 $ 241 $ 250 $ 260
<br />
|