The URL can be used to link to this page

Home My WebLink About6.a.ii. Sanitary Sewer Rate AnalysisSanitary Sewer Rate Analysis Description 2015 Projected 2015 Actual 2016 Projected 2017 Budgeted 2018 2019 2020 2021 2022 2023 2024 2025 2026 1 Water Demand (MG)870.00 813.08 833.65 854.23 875.36 897.18 919.56 942.51 966.02 990.10 1,014.85 1,040.17 1,066.06 1 2 Q1 Water Demand (MG) (~14% of total demand)121.80 118.05 116.71 119.59 122.55 125.61 128.74 131.95 135.24 138.61 142.08 145.62 149.25 2 3 Sanitary Sewer Flows (MG) *527.37 504.80 540.55 553.89 567.60 581.76 596.29 611.19 626.46 642.11 658.13 674.52 691.28 3 4 Estimated Growth (from water spreadsheet)2.0%1.6%2.5%2.5%2.5%2.5%2.5%2.5%2.5%2.5%2.5%2.5%2.5%4 5 Residential Accounts (includes multi-family)6,920 6,898 7,070 7,245 7,425 7,610 7,800 7,995 8,195 8,400 8,610 8,825 9,045 5 6 Commercial / Ind / Inst Accounts 185 180 185 189 193 198 203 208 213 218 223 228 233 6 7 Sanitary Sewer Fixed Charge ($/account/quarter)23.00$ 23.00$ 23.50$ 24.00$ 24.50$ 25.00$ 25.50$ 26.00$ 26.50$ 27.00$ 27.50$ 28.00$ 28.50$ 7 8 Scenario 1 rates (6% starting in 2017)1.73$ 1.73$ 1.80$ 1.91$ 2.02$ 2.14$ 2.27$ 2.41$ 2.55$ 2.71$ 2.87$ 3.00$ 3.13$ 8 9 Scenario 2 rates (30% in 2017, 7% thereafter)2.00$ 2.35$ 2.51$ 2.69$ 2.88$ 3.08$ 3.30$ 3.53$ 3.77$ 4.04$ 4.26$ 9 10 Sewer Utility Fund Beginning Balance - Scenario 1 1,895,157.82$ 1,895,157.82$ 1,884,795.74$ 1,781,395.74$ 1,629,515.48$ 1,456,872.10$ 1,340,171.01$ 1,357,841.43$ 1,450,426.60$ 1,626,655.55$ 1,861,020.53$ 2,234,316.14$ 2,687,773.76$ 10 11 Fixed Charges 653,660.00$ 713,664.00$ 746,564.00$ 780,800.00$ 816,306.00$ 853,112.00$ 891,248.00$ 930,744.00$ 971,630.00$ 1,013,936.00$ 1,057,692.00$ 11 12 Sewer Use Charges (~73% of total water demand is billed)1,083,672.00$ 1,189,270.94$ 1,291,821.76$ 1,403,458.25$ 1,524,777.73$ 1,656,596.49$ 1,799,797.32$ 1,955,334.68$ 2,124,477.05$ 2,275,469.20$ 2,437,040.62$ 12 13 Miscellaneous Revenue (~8% of usage revenue)138,986.56$ 152,234.80$ 163,070.86$ 174,740.66$ 187,286.70$ 200,776.68$ 215,283.63$ 230,886.29$ 247,688.56$ 263,152.42$ 279,578.61$ 13 14 Total Revenue 1,876,318.56$ 1,690,900.00$ 1,957,200.00$ 2,055,169.74$ 2,201,456.62$ 2,358,998.91$ 2,528,370.42$ 2,710,485.17$ 2,906,328.95$ 3,116,964.98$ 3,343,795.61$ 3,552,557.62$ 3,774,311.23$ 14 15 Sewer Utility Fund Beginning Balance - Scenario 2 1,895,157.82$ 1,895,157.82$ 1,884,795.74$ 1,781,395.74$ 1,524,196.78$ 1,287,612.50$ 1,115,088.90$ 1,087,074.66$ 1,146,435.97$ 1,304,566.12$ 1,539,004.99$ 1,934,027.26$ 2,470,105.45$ 15 16 Fixed Charges 653,660.00$ 713,664.00$ 746,564.00$ 780,800.00$ 816,306.00$ 853,112.00$ 891,248.00$ 930,744.00$ 971,630.00$ 1,013,936.00$ 1,057,692.00$ 16 17 Sewer Use Charges (billed for Q1 water usage x 4)974,400.00$ 1,124,161.04$ 1,232,617.22$ 1,351,770.74$ 1,482,477.11$ 1,625,833.65$ 1,783,039.17$ 1,955,403.10$ 2,144,594.32$ 2,351,968.81$ 2,543,077.14$ 17 18 Miscellaneous Revenue (~8% of usage revenue)130,244.80$ 147,026.00$ 158,334.50$ 170,605.66$ 183,902.65$ 198,315.65$ 213,942.97$ 230,891.77$ 249,297.95$ 269,272.38$ 288,061.53$ 18 19 Pro-rated credit for 2nd meters purchased 2012 or later (35,000.00)$ -$ -$ -$ -$ -$ -$ -$ 1.00$ 2.00$ 19 20 Total Revenues 1,758,304.80$ 1,690,900.00$ 1,957,200.00$ 1,949,851.04$ 2,137,515.71$ 2,303,176.40$ 2,482,685.76$ 2,677,261.31$ 2,888,230.15$ 3,117,038.87$ 3,365,522.27$ 3,635,178.19$ 3,888,832.67$ 20 21 100's - Salaries and Benefits (4%) (add 1 shared pos. in 2019)449,600.00$ 469,574.00$ 492,500.00$ 526,100.00$ 547,200.00$ 609,100.00$ 633,500.00$ 658,900.00$ 685,300.00$ 712,800.00$ 741,400.00$ 771,100.00$ 802,000.00$ 21 22 200's - Materials and Equipment 13,800.00$ 8,006.00$ 13,800.00$ 19,000.00$ 19,600.00$ 20,200.00$ 20,900.00$ 21,600.00$ 22,300.00$ 23,000.00$ 23,700.00$ 24,500.00$ 25,300.00$ 22 23 300's - Communications, Computer, Eng, Prof Svcs 117,700.00$ 80,171.00$ 101,400.00$ 96,700.00$ 99,700.00$ 102,700.00$ 105,800.00$ 109,000.00$ 112,300.00$ 115,700.00$ 119,200.00$ 122,800.00$ 126,500.00$ 23 24 400's - Training, Conferences, Contracted Repair, Misc 11,600.00$ 26,126.00$ 11,600.00$ 36,750.00$ 37,900.00$ 39,100.00$ 40,300.00$ 41,600.00$ 42,900.00$ 44,200.00$ 45,600.00$ 47,000.00$ 48,500.00$ 24 25 500's - Buildings, Machinery, Furniture, Equipment 21,000.00$ 119.00$ 21,000.00$ 21,000.00$ 21,700.00$ 12,400.00$ 12,800.00$ 13,200.00$ 13,600.00$ 14,100.00$ 14,600.00$ 15,100.00$ 15,600.00$ 25 26 530.03 - CRP of Sewer Main 150,000.00$ -$ 150,000.00$ 150,000.00$ 150,000.00$ 150,000.00$ 150,000.00$ 150,000.00$ 150,000.00$ 150,000.00$ 150,000.00$ 150,000.00$ 150,000.00$ 26 27 602 - Sewer Service Charges (5% per year starting 2018)1,077,415.00$ 1,077,415.00$ 1,185,400.00$ 1,285,000.00$ 1,349,300.00$ 1,416,800.00$ 1,487,700.00$ 1,562,100.00$ 1,640,300.00$ 1,722,400.00$ 1,808,600.00$ 1,899,100.00$ 1,994,100.00$ 27 28 611 - Interest on Lease Payments -$ 1,773.00$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 28 29 710.00 - Transfers for Other Improvements -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 29 30 Utility Equipment Purchases (from CIP)-$ -$ -$ 18,000.00$ 92,500.00$ 67,500.00$ -$ -$ -$ 35,000.00$ -$ -$ -$ 30 31 Lift Station Expenses (9 facilities)40,100.00$ 26,146.00$ 84,900.00$ 54,500.00$ 56,200.00$ 57,900.00$ 59,700.00$ 61,500.00$ 63,400.00$ 65,400.00$ 67,400.00$ 69,500.00$ 71,600.00$ 31 32 Total Expenses 1,881,215.00$ 1,689,330.00$ 2,060,600.00$ 2,207,050.00$ 2,374,100.00$ 2,475,700.00$ 2,510,700.00$ 2,617,900.00$ 2,730,100.00$ 2,882,600.00$ 2,970,500.00$ 3,099,100.00$ 3,233,600.00$ 32 33 Year End Balance 1,890,261.38$ 1,884,795.74$ 1,781,395.74$ 1,629,515.48$ 1,456,872.10$ 1,340,171.01$ 1,357,841.43$ 1,450,426.60$ 1,626,655.55$ 1,861,020.53$ 2,234,316.14$ 2,687,773.76$ 3,228,485.00$ 33 34 Balance change (4,896.44)$ (103,400.00)$ (151,880.26)$ (172,643.38)$ (116,701.09)$ 17,670.42$ 92,585.17$ 176,228.95$ 234,364.98$ 373,295.61$ 453,457.62$ 540,711.23$ 34 35 % change -0.26%-5.49%-8.53%-10.59%-8.01%1.32%6.82%12.15%14.41%20.06%20.30%20.12%35 36 Year End Balance 1,772,247.62$ 1,884,795.74$ 1,781,395.74$ 1,524,196.78$ 1,287,612.50$ 1,115,088.90$ 1,087,074.66$ 1,146,435.97$ 1,304,566.12$ 1,539,004.99$ 1,934,027.26$ 2,470,105.45$ 3,125,338.12$ 36 37 Balance change (122,910.20)$ (103,400.00)$ (257,198.96)$ (236,584.29)$ (172,523.60)$ (28,014.24)$ 59,361.31$ 158,130.15$ 234,438.87$ 395,022.27$ 536,078.19$ 655,232.67$ 37 38 % change -6.49%-5.49%-14.44%-15.52%-13.40%-2.51%5.46%13.79%17.97%25.67%27.72%26.53%38 * New for 2017: Sewer Service Charges (line 27) are sent to us from the MCES in August for the following budget year. The charge is based on the flows from the prior calendar year. For example: flows from Jan 1 - Dec 31, 2015 are used to determine our 2017 rates. MCES charges per 1,000 gallons $2.13434 $2.31995 Percent change from previous year 1.190%8.70% Scenario 2 Projected Demands and Connections Expenses Scenario 1 Proposed Rates Revenue Scenario 1 Current Revenue Scenario 2 Winter Quarter Credit (Q1) G:\Utilities\Rates\Sewer Rates 20160919 Model