|
City of Mounds View
<br />Sewer Utility Rate Study
<br />3%3%3%3%3%
<br />Actual Actual Actual Budget Projected Projected Projected Projected Projected
<br />2016 2017 2018 2019 2020 2021 2022 2023 2024
<br />Expense
<br />Personnel services 341,972$ 312,310$ 302,497$ 372,773$ 383,956$ 395,475$ 407,339$ 419,559$ 432,146$
<br />Supplies & materials 16,378 16,590 35,407 31,502 32,447 33,420 34,423 35,456 36,519
<br />Contractual services 58,830 56,166 78,565 117,919 121,457 125,100 128,853 132,719 136,700
<br />MCES disposal charges (avg. since 2007 3.56%)898,621 916,035 974,798 997,993 1,037,913 1,079,429 1,122,606 1,167,511 1,214,211
<br />Depreciation 85,388 95,362 101,597 95,000 96,000 96,000 96,000 96,000 96,000
<br />Transfers to other funds 240,309 98,058 109,860 132,446 137,859 140,345 142,905 145,542 145,542
<br />Contingency - - - 15,000 15,000 15,000 15,000 15,000 15,000
<br />Total Expenses 1,641,498 1,494,521 1,602,724 1,762,633 1,824,632 1,884,770 1,947,127 2,011,787 2,076,119
<br />Revenues 8.00%6.00%6.00%5.00%4.00%4.00%4.00%4.00%3.50%
<br />Sanitary sewer service 1,470,099 1,595,904 1,676,325 1,655,618 1,789,923 1,861,520 1,935,980 2,013,420 2,083,889
<br />Service availability charges 1,202 2,301 1,839 - - - - - -
<br />Investment income 21,359 25,073 31,077 21,000 31,582 34,452 33,096 31,955 31,046
<br />Miscellaneous revenues 1,215 1,306 1,362 - - - - - -
<br />Transfers from vehicle fund 60,000 - - 100,000 - - - - -
<br />Total Revenues 1,553,875 1,624,584 1,710,603 1,776,618 1,821,505 1,895,971 1,969,076 2,045,374 2,114,936
<br />Change in net position (87,623) 130,063 107,879 13,985 (3,126) 11,201 21,949 33,588 38,817
<br />Accounting change (GASB 68 pension)
<br />Net position - beginning of year 3,872,946 3,785,323 3,915,386 4,023,265 4,037,250 4,034,124 4,045,325 4,067,274 4,100,862
<br />Net position - end of year 3,785,323 3,915,386 4,023,265 4,037,250 4,034,124 4,045,325 4,067,274 4,100,862 4,139,678
<br />Cash Flows
<br />Change in net position (87,623) 130,063 107,879 13,985 (3,126) 11,201 21,949 33,588 38,817
<br />Deduct:
<br />Capital outlays - equipment (43,064) - - (190,000) - - - - -
<br />Construction (150,317) (64,286) (4,150) (304,000) (175,000) (175,000) (175,000) (175,000) (175,000)
<br />Add back:
<br />Depreciation 85,388 95,362 101,597 95,000 96,000 96,000 96,000 96,000 96,000
<br />Change in receivables/payables 186,017 (46,990) (187,841) - - - - - -
<br />Cash - Beginning of Year 2,067,687 2,058,088 2,172,237 2,189,722 1,804,707 1,722,580 1,654,782 1,597,731 1,552,319
<br />Cash - End of Year 2,058,088$ 2,172,237$ 2,189,722$ 1,804,707$ 1,722,580$ 1,654,782$ 1,597,731$ 1,552,319$ 1,512,135$
<br />Residential equivalent connection rate 75.99$ 80.55$ 85.38$ 89.65$ 93.24$ 96.97$ 100.85$ 104.88$ 108.55$
<br />Residential fixed rate 30.94 32.80 34.76 36.50 37.96 39.48 41.06 42.70 44.20
<br />Residential variable rate 2.46 2.61 2.77 2.91 3.02 3.14 3.27 3.40 3.52
<br />Annual based on 18,000 gal. per quarter 301.17 319.24 338.40 355.32 369.53 384.31 399.68 415.67 430.22
<br />MCES Rate increase 7.33%1.94%6.41%2.38%3.24%4.00%4.00%4.00%4.00%18
|