|
City of Mounds View
<br />Sewer Utility Rate Study
<br />2.5%2.5%3%3%3%
<br />Actual Actual Actual Budget Projected Projected Projected Projected Projected
<br />2014 2015 2016 2017 2018 2019 2020 2021 2022
<br />Expense
<br />Personnel services 317,133$ 330,082$ 341,972$ 366,598$ 375,763$ 387,036$ 398,647$ 410,606$ 422,925$
<br />Supplies & materials 28,738 16,608 16,378 31,112 31,890 32,687 33,668 34,678 35,718
<br />Contractual services 75,053 39,299 58,830 108,909 111,632 114,423 117,855 121,391 125,033
<br />MCES disposal charges (est 5-7% thru 2022)827,962 837,241 898,621 918,137 973,225 1,031,619 1,093,516 1,159,127 1,228,674
<br />Depreciation 165,752 151,592 85,388 153,000 86,000 86,000 86,000 86,000 86,000
<br />Transfers to other funds 230,962 249,611 240,309 98,058 109,860 111,684 113,595 115,563 115,563
<br />Contingency - - - 15,000 15,000 15,000 15,000 15,000 15,000
<br />Total Expenses 1,645,600 1,624,433 1,641,498 1,690,814 1,703,370 1,778,448 1,858,281 1,942,365 2,028,913
<br />Revenues 5.00%6.00%8.00%6.00%6.00%5.00%4.00%5.00%5.00%
<br />Sanitary sewer service 1,324,800 1,398,187 1,470,099 1,617,944 1,702,384 1,787,504 1,859,004 1,951,954 2,049,552
<br />Service availability charges 1,200 1,900 1,202 1,957 2,016 2,066 2,128 2,192 2,258
<br />Investment income 128,383 26,380 21,359 31,015 19,505 24,980 28,218 31,090 30,168
<br />Miscellaneous revenues 30,000 - 1,215 - - - - - -
<br />Transfers from vehicle fund - - 60,000 - - 140,000 - - -
<br />Total Revenues 1,484,383 1,426,467 1,553,875 1,650,917 1,723,905 1,954,550 1,889,349 1,985,236 2,081,977
<br />Change in net position (161,217) (197,966) (87,623) (39,897) 20,536 176,102 31,069 42,871 53,064
<br />Accounting change (GASB 68 pension)(183,094)
<br />Net position - beginning of year 4,415,223 4,254,006 3,872,946 3,872,946 3,833,049 3,853,584 4,029,686 4,060,755 4,103,626
<br />Net position - end of year 4,254,006 3,872,946 3,785,323 3,833,049 3,853,584 4,029,686 4,060,755 4,103,626 4,156,690
<br />Cash Flows
<br />Change in net position (161,217) (197,966) (87,623) (39,897) 20,536 176,102 31,069 42,871 53,064
<br />Deduct:
<br />Capital outlays - equipment (7,308) - (44,750) - - (140,000) - - -
<br />Construction - (228,745) (250,000) (150,000) (175,000) (175,000) (175,000) (175,000) (175,000)
<br />Add back:
<br />Depreciation 165,752 151,592 85,388 153,000 86,000 86,000 86,000 86,000 86,000
<br />Change in receivables/payables (90,532) (110,068) - - - - - - -
<br />Cash - Beginning of Year 2,546,179 2,452,874 2,067,687 1,770,702 1,733,804 1,665,340 1,612,442 1,554,510 1,508,382
<br />Cash - End of Year 2,452,874$ 2,067,687$ 1,770,702$ 1,733,804$ 1,665,340$ 1,612,442$ 1,554,510$ 1,508,382$ 1,472,446$
<br />Residential equivalent connection rate 66.38$ 70.36$ 75.99$ 80.55$ 85.38$ 89.65$ 93.24$ 97.90$ 102.79$
<br />Residential fixed rate 27.03 28.65 30.94 32.80 34.76 36.50 37.96 39.86 41.85
<br />Residential variable rate 2.15 2.28 2.46 2.61 2.77 2.91 3.02 3.17 3.33
<br />Annual based on 18,000 gal. per quarter 263.08 278.86 301.17 319.24 338.40 355.32 369.53 388.01 407.41
<br />MCES Rate increase 1.43%1.12%7.33%2.17%6.00%6.00%6.00%6.00%6.00%19
|