|
City of Mounds View
<br />Sewer Utility Rate Study
<br />3.5%3.5%3.5%3.5%3.5%
<br />Actual Actual Actual Budget Projected Projected Projected Projected Projected
<br />2018 2019 2020 2021 2022 2023 2024 2025 2026
<br />Expense
<br />Personnel services 302,497$ 343,399$ 403,553$ 414,384$ 428,887.44$ 443,899$ 459,435$ 475,515$ 492,158$
<br />Supplies & materials 35,407 23,926 17,925 28,302 29,293 30,318 31,379 32,477 33,614
<br />Contractual services 78,565 70,683 72,784 119,936 124,134 128,478 132,975 137,629 142,446
<br />MCES disposal charges 974,798 991,993 1,026,404 1,025,643 1,061,541 1,098,694 1,137,149 1,176,949 1,218,142
<br />Depreciation 101,597 97,840 113,690 100,000 114,000 114,000 114,000 114,000 114,000
<br />Transfers to other funds 109,860 132,446 137,859 140,345 142,905 145,542 148,258 151,056 153,938
<br />Contingency - - - 15,000 15,000 15,000 15,000 15,000 15,000
<br />Total Expenses 1,602,724 1,660,287 1,772,215 1,843,610 1,915,759 1,975,931 2,038,196 2,102,627 2,169,299
<br />Revenues 6.00%5.00%4.00%4.00%4.00%4.00%3.50%3.50%3.50%
<br />Sanitary sewer service 1,676,325 1,736,097 1,855,335 1,871,520 1,935,980 2,013,420 2,083,889 2,156,825 2,232,314
<br />Service availability charges 1,839 - - - - - - - -
<br />Investment income 31,077 65,558 39,503 20,000 12,335 18,289 24,333 36,636 49,444
<br />Miscellaneous revenues 1,362 45,506 11,986 - - - - - -
<br />Transfers from vehicle fund - 100,000 - - - - - - 450,000
<br />Total Revenues 1,710,603 1,947,161 1,906,824 1,891,520 1,948,315 2,031,709 2,108,223 2,193,461 2,731,759
<br />Change in net position 107,879 286,874 134,609 47,910 32,556 55,778 70,027 90,834 562,460
<br />Accounting change (GASB 68 pension)
<br />Net position - beginning of year 3,915,386 4,023,265 4,310,139 4,444,748 4,492,658 4,525,214 4,580,992 4,651,019 4,741,853
<br />Net position - end of year 4,023,265 4,310,139 4,444,748 4,492,658 4,525,214 4,580,992 4,651,019 4,741,853 5,304,313
<br />Cash Flows
<br />Change in net position 107,879 286,874 134,609 47,910 32,556 55,778 70,027 90,834 562,460
<br />Deduct:
<br />Capital outlays - equipment - (182,397) - - - - - - (450,000)
<br />Construction (4,150) (81,750) (109,958) (205,000) (175,000) (175,000) (175,000) (175,000) (175,000)
<br />Add back:
<br />Depreciation 101,597 97,840 113,690 100,000 114,000 114,000 114,000 114,000 114,000
<br />Change in receivables/payables (187,841) (13,881) 89,357 - - - - - -
<br />Cash - Beginning of Year 2,172,237 2,189,722 2,296,408 2,524,106 2,467,016 2,438,572 2,433,350 2,442,377 2,472,211
<br />Cash - End of Year 2,189,722$ 2,296,408$ 2,524,106$ 2,467,016$ 2,438,572$ 2,433,350$ 2,442,377$ 2,472,211$ 2,523,671$
<br />Residential equivalent connection rate 85.38$ 89.65$ 93.24$ 96.97$ 100.85$ 104.88$ 108.55$ 112.35$ 116.28$
<br />Residential fixed rate 34.76 36.50 37.96 39.48 41.06 42.70 44.20 45.74 47.34
<br />Residential variable rate 2.77 2.91 3.02 3.14 3.27 3.40 3.52 3.64 3.77
<br />Annual based on 18,000 gal. per quarter 338.40 355.32 369.53 384.31 399.68 415.67 430.22 445.28 460.86
<br />MCES Rate increase 6.41%1.76%3.24%-0.07%3.50%3.50%3.50%3.50%3.50%
|