|
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 />2017 2018 2019 2020 2021 2022 2023 2024 2025
<br />Expense
<br />Personnel services 312,310$ 302,497$ 343,399$ 402,309$ 414,378$ 426,810$ 439,614$ 452,802$ 466,386$
<br />Supplies & materials 16,590 35,407 23,926 28,302 29,151 30,026 30,926 31,854 32,810
<br />Contractual services 56,166 78,565 70,683 111,227 114,564 118,001 121,541 125,187 128,943
<br />MCES disposal charges (avg. since 2007 3.56%)916,035 974,798 991,993 1,030,104 1,071,308 1,114,160 1,158,727 1,205,076 1,253,279
<br />Depreciation 95,362 101,597 97,840 100,000 96,000 96,000 96,000 96,000 96,000
<br />Transfers to other funds 98,058 109,860 132,446 137,859 140,345 142,905 145,542 145,542 145,542
<br />Contingency - - - 15,000 15,000 15,000 15,000 15,000 15,000
<br />Total Expenses 1,494,521 1,602,724 1,660,287 1,824,801 1,880,746 1,942,901 2,007,350 2,071,461 2,137,960
<br />Revenues 6.00%6.00%5.00%4.00%4.00%4.00%4.00%3.50%3.50%
<br />Sanitary sewer service 1,595,904 1,676,325 1,736,097 1,797,923 1,861,520 1,935,980 2,013,420 2,083,889 2,156,825
<br />Service availability charges 2,301 1,839 - - - - - - -
<br />Investment income 25,073 31,077 65,558 24,000 41,271 40,131 39,216 38,541 37,981
<br />Miscellaneous revenues 1,306 1,362 45,506 - - - - - -
<br />Transfers from vehicle fund - - 100,000 - - - - - -
<br />Total Revenues 1,624,584 1,710,603 1,947,161 1,821,923 1,902,790 1,976,112 2,052,635 2,122,431 2,194,806
<br />Change in net position 130,063 107,879 286,874 (2,878) 22,044 33,210 45,285 50,969 56,846
<br />Accounting change (GASB 68 pension)
<br />Net position - beginning of year 3,785,323 3,915,386 4,023,265 4,310,139 4,307,261 4,329,305 4,362,515 4,407,801 4,458,770
<br />Net position - end of year 3,915,386 4,023,265 4,310,139 4,307,261 4,329,305 4,362,515 4,407,801 4,458,770 4,515,617
<br />Cash Flows
<br />Change in net position 130,063 107,879 286,874 (2,878) 22,044 33,210 45,285 50,969 56,846
<br />Deduct:
<br />Capital outlays - equipment - - (182,397) - - - - - -
<br />Construction (64,286) (4,150) (81,750) (330,000) (175,000) (175,000) (175,000) (175,000) (175,000)
<br />Add back:
<br />Depreciation 95,362 101,597 97,840 100,000 96,000 96,000 96,000 96,000 96,000
<br />Change in receivables/payables (46,990) (187,841) (13,881) - - - - - -
<br />Cash - Beginning of Year 2,058,088 2,172,237 2,189,722 2,296,408 2,063,530 2,006,574 1,960,784 1,927,070 1,899,039
<br />Cash - End of Year 2,172,237$ 2,189,722$ 2,296,408$ 2,063,530$ 2,006,574$ 1,960,784$ 1,927,070$ 1,899,039$ 1,876,885$
<br />Residential equivalent connection rate 80.55$ 85.38$ 89.65$ 93.24$ 96.97$ 100.85$ 104.88$ 108.55$ 112.35$
<br />Residential fixed rate 32.80 34.76 36.50 37.96 39.48 41.06 42.70 44.20 45.74
<br />Residential variable rate 2.61 2.77 2.91 3.02 3.14 3.27 3.40 3.52 3.64
<br />Annual based on 18,000 gal. per quarter 319.24 338.40 355.32 369.53 384.31 399.68 415.67 430.22 445.28
<br />MCES Rate increase 1.94%6.41%1.76%3.24%4.00%4.00%4.00%4.00%4.00%16
|