Loading...
HomeMy WebLinkAbout7.a. UC Water Sewer Storm RatesG:\MEETINGS\UTILITY COMMISSION\UC Items and Packets\2019\20190819\20190819 UC Water Sewer Storm Rates.docx E X E C U T I V E S U M M A R Y Utility Commission Meeting: August 19, 2019 AGENDA ITEM: Water, Sewer and Stormwater Rate Review AGENDA SECTION: New Business PREPARED BY: Christine Watson, Public Works Coordinator AGENDA NO. 7.a. ATTACHMENTS: Rate Models; Sample APPROVED BY: BLE RECOMMENDED ACTION: Motion to Recommend City Council Approval of Water and Sewer Rate Changes for 2020 BACKGROUND WATER UTILITY RATES Staff has completed its annual review of the Water Utility Fund activity and adjusted the model to reflect the proposed changes for 2020 and beyond. Based on this review, staff is proposing changes that will result in a net decrease of 1.1% to the water portion of the utility bill for the average residential water customer, as shown in the attached sample. The attached water rate model includes the following items of note: LINES 7-16: Reduced the fixed rate for the second year of the three-year phase out. Usage rates will increase 10% to make up the difference in revenue. Future rate increases are expected to be 5% or less for the next 10+ years. LINES 17-20: Includes 0.5% annual increase to surcharge which began in 2017 to increase revenue in the Capital Investment Fund (had not been adjusted for many years prior to that). The CIF is programmed to contribute 20% towards the annual debt service beginning in 2022, or sooner if needed. LINES 21-23: Includes 3% annual increase to the meter maintenance fee for ¾” meters (which is 86% of all meters), and a 0.5% annual increase to all other meters. Ideally, revenue from meter maintenance fees (Lines 35-38) should offset the cost of meter replacements (LINE 44). LINE 41: Includes 1/3 of the funding for a maintenance FTE in 2020 and 2021 (split with Sewer and Storm) and another in 2022 for a water treatment plant operator (100% funded by Water). LINE 50: Includes water tower painting, new generators, etc. as scheduled in our Long-Term Plan LINE 51: Reflects planned utility equipment purchases to match Capital Improvement Plan (CIP) LINE 56: Starting in 2022, water treatment plant costs will be shared 75% from Utility fund, 25% from Core/CIF funds G:\MEETINGS\UTILITY COMMISSION\UC Items and Packets\2019\20190819\20190819 UC Water Sewer Storm Rates.docx  LINE 64: Connection cost for a ¾” meter was $2300 for 2017, $2400 for 2018, and will include a $25 annual increase thereafter (had not been adjusted for many years prior to 2017)  LINE 72: Starting in 2022, add $679,000/year to existing debt to cover a portion of the water treatment plant and Well 17 debt Although it is not shown on the printed spreadsheet, the model is extended through 2035 to ensure that the Water Utility Fund remains viable through the duration of all of the anticipated debt payments. The year-end balance in 2035 is estimated to be $5.07 million. The year with the lowest year-end balance is expected to be 2030 ($2.11 million). SEWER UTILITY RATES Staff has completed its annual review of the Sewer Utility Fund activity and adjusted the model to reflect the proposed changes for 2020 and beyond. Based on this review, staff is proposing changes that will result in a net increase of 10.8% to the sewer portion of the utility bill for the average residential water customer, as shown in the attached sample. The attached sewer rate model includes the following items of note:  LINE 8: Reduced the fixed rate for the second year of the three-year phase out. Usage rates will increase 25% to make up the difference in revenue. Future rate increases are expected to be 5% or less for the next 10+ years.  LINE 21: Includes 1/3 of the funding for a Utility Supervisor in 2020 and an additional maintenance FTE in 2021 (split with Water and Storm Utility funds).  LINE 25: Includes funding in 2020 for SCADA upgrades and new control cabinets at two lift stations. STORMWATER UTILITY RATES Staff has completed its annual review of the Stormwater Utility Fund activity and adjusted the model to reflect the proposed changes for 2020 and beyond. The annual increase was 5% from 2002 through 2016, 4% in 2017 and 3% in 2018-2019. Based on staff review, no rate increase is needed at this time. The current rates should be sufficient to maintain a viable year-end balance for next 10 years and beyond, assuming no major unplanned expenditures are needed. Staff is working to develop a stormwater system maintenance plan to identify high-priority stormwater improvement projects. With a current balance of $4.8 million, there is enough funding at this time to begin these projects, but rates may need to be adjusted in the future depending on the timing and the cost of the projects that are identified in the plan. There is currently $200,000 per year in Line 32 dedicated to these improvements (starting in 2020). As we review the model next year with a specific plan in progress, we will adjust the model accordingly. G:\MEETINGS\UTILITY COMMISSION\UC Items and Packets\2019\20190819\20190819 UC Water Sewer Storm Rates.docx SUMMARY Staff is requesting Utility Commission recommendation to the City Council to approve the proposed water and sewer rate changes. These changes will result in an overall net increase of 5.0% for the average residential customer (see the impact to other customers in the table below). If that is the recommendation from the Commission, the changes will be reflected in the 2020 Fee Resolution that is presented to City Council for approval in December. Utility Bill Comparison Total Utility Bill Charges 2018 Actual 2019 Actual 2020 Proposed % Change 2019 to 2020 $$ Change 2019 to 2020 (Per Quarter) Low User $325.60 $272.24 $250.32 -8.1% ($5.48) Average User $515.24 $519.24 $545.40 5.0% $6.54 High User $817.27 $906.25 $1,002.16 10.6% $23.98 Com / Ind / Inst Average User $1,790.19 $2,095.32 $2,365.50 12.9% $67.55 Water Rate Analysis 3.00%3.00%18.00%10.00%5.00%4.00%4.00%4.00%4.00%5.00%5.00%5.00%5.00% Description 2018 Projected 2018 Actual 2019 Projected 2020 Budgeted 2021 2022 2023 2024 2025 2026 2027 2028 2029 1 Water Demand (MG)966.770 871.274 875.000 896.875 919.297 942.279 965.836 989.982 1,014.732 1,040.100 1,066.103 1,092.755 1,120.074 2 Estimated Growth 2.5%2.4%2.5%2.5%2.5%2.5%2.5%2.5%2.5%2.5%2.5%2.5%2.5% 3 Residential Accounts (excluding association irrigation)6,885 6,886 7,058 7,235 7,415 7,601 7,791 7,986 8,185 8,390 8,600 8,815 9,035 4 Commercial Accounts (excluding irrigation)131 126 129 132 136 139 143 146 150 154 157 161 165 5 Institutional / Industrial Accounts (excluding irrigation)48 47 48 49 51 52 53 55 56 57 59 60 62 6 Irrigation-only Accounts (excluding single family)126 125 128 131 135 138 141 145 149 152 156 160 164 7 Water Fixed Charge ($/account/quarter)13.15$ 13.15$ 6.50$ 3.00$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 8 Residential Tier 1 (0 - 12,000 gal)1.19$ 1.19$ 1.40$ 1.54$ 1.62$ 1.69$ 1.75$ 1.82$ 1.90$ 1.99$ 2.09$ 2.20$ 2.31$ 9 Residential Tier 2 (13,000 - 24,000 gal)1.49$ 1.49$ 1.76$ 1.93$ 2.03$ 2.11$ 2.19$ 2.28$ 2.37$ 2.49$ 2.61$ 2.75$ 2.88$ 10 Residential Tier 3 (25,000 - 48,000 gal)1.86$ 1.86$ 2.19$ 2.41$ 2.53$ 2.64$ 2.74$ 2.85$ 2.96$ 3.11$ 3.27$ 3.43$ 3.60$ 11 Residential Tier 4 (> 48,000 gal)2.79$ 2.79$ 3.29$ 3.62$ 3.80$ 3.95$ 4.11$ 4.28$ 4.45$ 4.67$ 4.90$ 5.15$ 5.41$ 12 Irrigation Meters (Multi Fam / Comm / Ind / Inst)2.79$ 2.79$ 3.29$ 3.62$ 3.80$ 3.95$ 4.11$ 4.28$ 4.45$ 4.67$ 4.90$ 5.15$ 5.41$ 13 Comm / Ind / Inst Tier 1 (0 - 80,000 gal)1.38$ 1.38$ 1.63$ 1.79$ 1.88$ 1.96$ 2.03$ 2.12$ 2.20$ 2.31$ 2.43$ 2.55$ 2.67$ 14 Comm / Ind / Inst Tier 2 (81,000 - 160,000 gal)1.73$ 1.73$ 2.04$ 2.24$ 2.35$ 2.45$ 2.54$ 2.64$ 2.75$ 2.89$ 3.03$ 3.18$ 3.34$ 15 Comm / Ind / Inst Tier 3 (161,000 - 250,000 gal)2.16$ 2.16$ 2.54$ 2.80$ 2.94$ 3.06$ 3.18$ 3.31$ 3.44$ 3.61$ 3.79$ 3.98$ 4.18$ 16 Comm / Ind / Inst Tier 4 ( > 250,000 gal)2.79$ 2.79$ 3.29$ 3.62$ 3.80$ 3.95$ 4.11$ 4.28$ 4.45$ 4.67$ 4.90$ 5.15$ 5.41$ 17 Surcharge - Single Family 3/4" ($/account)8.88$ 8.88$ 8.93$ 8.97$ 9.02$ 9.06$ 9.11$ 9.15$ 9.20$ 9.25$ 9.29$ 9.34$ 9.39$ 18 Surcharge - Multi Family 3/4" ($/account)6.86$ 6.86$ 6.90$ 6.93$ 6.97$ 7.00$ 7.04$ 7.07$ 7.11$ 7.14$ 7.18$ 7.22$ 7.25$ 19 Surcharge - 1" ($/account)13.64$ 13.64$ 13.71$ 13.77$ 13.84$ 13.91$ 13.98$ 14.05$ 14.12$ 14.19$ 14.26$ 14.34$ 14.41$ 20 Surcharge - 1.5" ($/account)28.28$ 28.28$ 28.42$ 28.56$ 28.71$ 28.85$ 28.99$ 29.14$ 29.29$ 29.43$ 29.58$ 29.73$ 29.88$ 21 Meter Maintenance - 3/4" ($/meter/quarter) (3% annual inc)1.00$ 1.00$ 1.02$ 1.05$ 1.08$ 1.11$ 1.15$ 1.18$ 1.22$ 1.25$ 1.29$ 1.33$ 1.37$ 22 Meter Maintenance - 1" ($/meter/quarter) (0.5% annual inc)6.31$ 6.31$ 6.34$ 6.37$ 6.41$ 6.44$ 6.47$ 6.50$ 6.54$ 6.57$ 6.60$ 6.63$ 6.67$ 23 Meter Maintenance - 1.5" ($/meter/quarter) (0.5% annual inc)11.37$ 11.37$ 11.42$ 11.48$ 11.54$ 11.60$ 11.65$ 11.71$ 11.77$ 11.83$ 11.89$ 11.95$ 12.01$ 24 601 49400 Water Utility Fund Beginning Balance 7,546,474.50$ 7,546,474.50$ 8,061,199.67$ 7,784,744.99$ 8,529,479.30$ 9,289,289.19$ 8,181,095.79$ 7,236,357.58$ 6,349,597.75$ 5,591,942.48$ 4,131,473.33$ 2,806,138.82$ 2,410,460.82$ 25 Calculated Fixed Charges 378,283.16$ 191,453.60$ 90,572.28$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 26 Residential Tier 1 (0 - 12,000 gal)104,872.32$ 137,803.30$ 155,373.22$ 167,220.43$ 178,256.97$ 190,021.93$ 202,563.38$ 215,932.57$ 232,397.42$ 250,117.73$ 269,189.20$ 289,714.88$ 27 Residential Tier 2 (13,000 - 24,000 gal)230,391.38$ 249,362.12$ 281,155.80$ 302,593.92$ 322,565.12$ 343,854.42$ 366,548.81$ 390,741.04$ 420,535.04$ 452,600.84$ 487,111.65$ 524,253.91$ 28 Residential Tier 3 (25,000 - 48,000 gal)174,944.24$ 244,183.60$ 256,962.54$ 276,555.93$ 294,808.63$ 314,265.99$ 335,007.55$ 357,118.05$ 384,348.30$ 413,654.86$ 445,196.04$ 479,142.24$ 29 Residential Tier 4 (> 48,000 gal)404,547.02$ 442,429.46$ 498,839.22$ 536,875.71$ 572,309.50$ 610,081.93$ 650,347.34$ 693,270.26$ 746,132.12$ 803,024.69$ 864,255.33$ 930,154.80$ 30 Irrigation Meters (Multi Fam / Comm / Ind / Inst)278,906.25$ 329,109.38$ 362,020.31$ 380,121.33$ 395,326.18$ 411,139.23$ 427,584.80$ 444,688.19$ 466,922.60$ 490,268.73$ 514,782.17$ 540,521.27$ 31 Comm / Ind / Inst Tier 1 (0 - 80,000 gal)16,799.79$ 19,927.05$ 23,705.11$ 25,512.62$ 27,196.45$ 28,991.42$ 30,904.85$ 32,944.58$ 35,456.60$ 38,160.16$ 41,069.88$ 44,201.46$ 32 Comm / Ind / Inst Tier 2 (81,000 - 160,000 gal)14,675.11$ 18,771.86$ 22,011.89$ 23,690.29$ 25,253.85$ 26,920.61$ 28,697.37$ 30,591.39$ 31,657.68$ 35,434.44$ 38,136.31$ 41,044.21$ 33 Comm / Ind / Inst Tier 3 (161,000 - 250,000 gal)24,118.82$ 25,374.50$ 26,896.18$ 28,947.01$ 30,857.52$ 32,894.11$ 35,065.12$ 37,379.42$ 37,502.17$ 43,297.11$ 46,598.51$ 50,151.65$ 34 Comm / Ind / Inst Tier 4 ( > 250,000 gal)217,229.96$ 232,923.37$ 262,621.10$ 282,645.96$ 301,300.59$ 321,186.43$ 342,384.73$ 364,982.13$ 385,726.15$ 422,763.93$ 454,999.68$ 489,693.41$ 35 Meter Maintenance Revenue - 3/4"27,400.00$ 28,690.56$ 30,299.30$ 31,987.41$ 33,771.82$ 35,657.47$ 37,649.51$ 39,753.34$ 41,974.61$ 44,319.22$ 46,793.34$ 49,403.44$ 36 Meter Maintenance Revenue - 1"20,524.67$ 21,033.25$ 21,342.40$ 21,654.12$ 21,968.43$ 22,311.22$ 22,656.89$ 23,005.45$ 23,356.94$ 23,711.37$ 24,068.75$ 24,429.12$ 37 Meter Maintenance Revenue - 1.5"9,957.10$ 10,006.88$ 10,148.76$ 10,291.81$ 10,436.03$ 10,581.44$ 10,728.04$ 10,875.85$ 11,024.86$ 11,175.09$ 11,326.55$ 11,479.24$ 38 Meter Maintenance Revenue - All Other Sizes 10,109.76$ 10,381.39$ 10,507.36$ 10,634.33$ 10,762.31$ 10,891.30$ 11,021.31$ 11,152.35$ 11,284.42$ 11,417.54$ 11,551.71$ 11,686.93$ 39 Misc Water Revenues (antenna, interest, new meter sales)331,500.00$ 341,995.00$ 368,338.85$ 380,139.02$ 392,403.19$ 405,039.28$ 418,055.46$ 431,560.12$ 445,461.93$ 459,869.79$ 474,692.88$ 490,040.67$ 40 Total Usage Revenue (excluding surcharge)2,244,259.58$ 2,381,577.00$ 2,303,445.32$ 2,420,794.31$ 2,478,869.89$ 2,617,216.60$ 2,763,836.79$ 2,919,215.17$ 3,083,994.73$ 3,273,780.84$ 3,499,815.49$ 3,729,772.00$ 3,975,917.22$ 41 100's - Salaries & Benefits (4%) (add FTE in 2021, 2022)534,000.00$ 562,407.00$ 514,500.00$ 578,700.00$ 641,900.00$ 787,600.00$ 819,200.00$ 852,000.00$ 886,100.00$ 921,600.00$ 958,500.00$ 996,900.00$ 1,036,800.00$ 42 200's - Office Materials and Supplies 36,700.00$ 33,642.00$ 32,600.00$ 45,600.00$ 47,000.00$ 48,500.00$ 50,000.00$ 51,500.00$ 53,100.00$ 54,700.00$ 56,400.00$ 58,100.00$ 59,900.00$ 43 216.00 - Chemicals (subject to growth and price increases)75,000.00$ 43,035.00$ 75,000.00$ 75,000.00$ 78,000.00$ 81,100.00$ 84,300.00$ 87,700.00$ 91,200.00$ 94,800.00$ 98,600.00$ 102,500.00$ 106,600.00$ 44 220.01 - Water Meter Purchases (replacements)65,000.00$ 71,822.00$ 67,000.00$ 75,000.00$ 77,300.00$ 79,700.00$ 82,100.00$ 84,600.00$ 87,200.00$ 89,900.00$ 92,600.00$ 95,400.00$ 98,300.00$ 45 220.02 - Water Meter Purchases (new homes)55,000.00$ 47,296.00$ 57,200.00$ 75,000.00$ 78,000.00$ 81,200.00$ 84,500.00$ 87,900.00$ 91,500.00$ 95,200.00$ 99,100.00$ 103,100.00$ 107,300.00$ 46 300's - GIS, Legal, Office, Computer, Eng, Prof Svcs 210,600.00$ 147,740.00$ 205,600.00$ 225,900.00$ 232,700.00$ 239,700.00$ 246,900.00$ 254,400.00$ 262,100.00$ 270,000.00$ 278,100.00$ 286,500.00$ 295,100.00$ 47 400's - Training, Conferences, Contracted Repair 101,600.00$ 99,233.00$ 86,300.00$ 107,200.00$ 110,500.00$ 113,900.00$ 117,400.00$ 121,000.00$ 124,700.00$ 128,500.00$ 132,400.00$ 136,400.00$ 140,500.00$ 48 500's - Buildings, Office Equip, Furniture, Misc Improvements 161,100.00$ 82,348.00$ 81,100.00$ 51,500.00$ 53,100.00$ 54,700.00$ 56,400.00$ 58,100.00$ 59,900.00$ 61,700.00$ 63,600.00$ 65,600.00$ 67,600.00$ 49 530.03 - CRP of Water Main 50,000.00$ 50,000.00$ 50,000.00$ 55,000.00$ 50,000.00$ 60,000.00$ 60,000.00$ 60,000.00$ 50,000.00$ 60,000.00$ 65,000.00$ 50,000.00$ 50 530.04 - Well and Tower Maintenance (long-term schedule)715,000.00$ 12,835.00$ 845,000.00$ 100,000.00$ 40,000.00$ 190,000.00$ 40,000.00$ 115,000.00$ 75,000.00$ 900,000.00$ 900,000.00$ 110,000.00$ 165,000.00$ 51 540, 548, 550, 580 - Equipment Purchase & Lease (from CIP)68,600.00$ 41,738.00$ 168,800.00$ 11,360.00$ 16,360.00$ 16,110.00$ 69,375.00$ 19,375.00$ 19,950.00$ 19,950.00$ 20,450.00$ 22,450.00$ 23,000.00$ 52 611.00 - Interest -$ 476.00$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 53 710.00 - Transfers for Other Improvements -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 54 Well and Tower Expenses (combined)287,100.00$ 256,427.00$ 396,800.00$ 280,800.00$ 289,200.00$ 297,900.00$ 306,800.00$ 316,000.00$ 325,500.00$ 335,300.00$ 345,400.00$ 355,800.00$ 366,500.00$ 55 WTP Operating Expenses -$ -$ -$ -$ 220,000.00$ 226,600.00$ 233,400.00$ 240,400.00$ 247,600.00$ 255,000.00$ 262,700.00$ 270,600.00$ 56 WTP Debt $22M 15 years @ 4.0% (75% share of $1,953,000)-$ -$ -$ -$ 1,465,000.00$ 1,465,000.00$ 1,465,000.00$ 1,465,000.00$ 1,465,000.00$ 1,465,000.00$ 1,465,000.00$ 1,465,000.00$ 57 Future PW/PD Facility -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 58 Total Expenses 2,359,700.00$ 1,398,999.00$ 2,579,900.00$ 1,676,060.00$ 1,719,060.00$ 3,725,410.00$ 3,708,575.00$ 3,805,975.00$ 3,841,650.00$ 4,734,250.00$ 4,825,150.00$ 4,125,450.00$ 4,252,200.00$ 59 Year End Balance (before debt service)7,431,034.08$ 8,529,052.50$ 7,784,744.99$ 8,529,479.30$ 9,289,289.19$ 8,181,095.79$ 7,236,357.58$ 6,349,597.75$ 5,591,942.48$ 4,131,473.33$ 2,806,138.82$ 2,410,460.82$ 2,134,178.04$ 60 Balance change amount (115,440.42)$ 982,578.00$ (276,454.68)$ 744,734.31$ 759,809.89$ (1,108,193.40)$ (944,738.21)$ (886,759.83)$ (757,655.27)$ (1,460,469.16)$ (1,325,334.51)$ (395,678.00)$ (276,282.78)$ 61 Balance change %-1.53%13.02%-3.43%9.57%8.91%-11.93%-11.55%-12.25%-11.93%-26.12%-32.08%-14.10%-11.46% Revenue Projected Demands and Connections Proposed Rates and Fixed Charges Expenses G:\Utilities\RATE MODELS\2019\Rate Model Water 20190801 Debt Service Impact Description 2018 Projected 2018 Actual 2019 Projected 2020 Budgeted 2021 2022 2023 2024 2025 2026 2027 2028 2029 62 Water Core Fund Beginning Balance 870,965.55$ 1,733,059.32$ 1,869,948.07$ 2,029,459.76$ 2,656,700.86$ 2,476,967.67$ 2,604,021.67$ 2,748,390.08$ 2,910,616.23$ 3,151,260.08$ 3,550,898.74$ 3,970,126.90$ 63 Revenue - Developer Agreements ($6500/ac)694,000.00$ 507,900.00$ 300,000.00$ 300,000.00$ 300,000.00$ 300,000.00$ 300,000.00$ 300,000.00$ 300,000.00$ 300,000.00$ 300,000.00$ 300,000.00$ 64 Revenue - New Connections (3/4-inch and 1-inch included)400,800.00$ 577,488.75$ 511,511.69$ 527,241.11$ 543,466.80$ 570,254.01$ 587,568.41$ 605,426.15$ 623,843.86$ 642,838.65$ 662,428.16$ 682,630.53$ 65 Capital Investment Fund Beginning Balance 640,821.52$ 988,275.52$ 1,277,073.16$ 1,574,667.29$ 1,881,295.80$ 2,061,403.54$ 2,251,098.40$ 2,450,640.25$ 2,660,296.56$ 2,895,342.57$ 3,176,061.59$ 3,467,745.18$ 66 Surcharge Revenue 3/4" - Single Family (98%)239,777.45$ 247,036.62$ 254,478.60$ 262,144.77$ 270,041.88$ 278,176.89$ 286,556.97$ 295,189.50$ 304,082.08$ 313,242.55$ 322,678.99$ 332,399.69$ 67 Surcharge Revenue 3/4" - Multi Family (2%)3,780.77$ 3,895.24$ 4,012.58$ 4,133.46$ 4,257.98$ 4,386.25$ 4,518.39$ 4,654.50$ 4,794.72$ 4,939.16$ 5,087.95$ 5,241.23$ 68 Surcharge Revenue - 1"44,350.29$ 45,449.23$ 46,117.26$ 46,790.83$ 47,469.99$ 48,210.70$ 48,957.63$ 49,710.83$ 50,470.33$ 51,236.19$ 52,008.44$ 52,787.13$ 69 Surcharge Revenue - 1.5"24,773.89$ 24,897.76$ 25,250.77$ 25,606.68$ 25,965.51$ 26,327.30$ 26,692.05$ 27,059.80$ 27,430.55$ 27,804.34$ 28,181.18$ 28,561.09$ 70 Surcharge Revenue - All Other Sizes 17,049.85$ 17,518.79$ 17,734.93$ 17,952.78$ 18,172.37$ 18,393.71$ 18,616.81$ 18,841.68$ 19,068.33$ 19,296.78$ 19,527.03$ 19,759.11$ 71 Total Water Surcharge Revenue 329,732.25$ 338,797.64$ 347,594.13$ 356,628.52$ 365,907.74$ 375,494.86$ 385,341.85$ 395,456.31$ 405,846.02$ 416,519.02$ 427,483.59$ 438,748.24$ 72 Estimated Debt Service *242,000.00$ 250,000.00$ 250,000.00$ 250,000.00$ 929,000.00$ 929,000.00$ 929,000.00$ 929,000.00$ 854,000.00$ 679,000.00$ 679,000.00$ 679,000.00$ 73 CIF Contribution to Debt or Other Projects (20% in 2018+)48,400.00$ 50,000.00$ 50,000.00$ 50,000.00$ 185,800.00$ 185,800.00$ 185,800.00$ 185,800.00$ 170,800.00$ 135,800.00$ 135,800.00$ 135,800.00$ 74 Core Contribution to Debt or Other Projects (80% in 2018+)493,600.00$ 948,500.00$ 652,000.00$ 200,000.00$ 1,023,200.00$ 743,200.00$ 743,200.00$ 743,200.00$ 683,200.00$ 543,200.00$ 543,200.00$ 543,200.00$ 75 Capital Investment Fund Year End Balance 922,153.77$ 988,275.52$ 1,277,073.16$ 1,574,667.29$ 1,881,295.80$ 2,061,403.54$ 2,251,098.40$ 2,450,640.25$ 2,660,296.56$ 2,895,342.57$ 3,176,061.59$ 3,467,745.18$ 3,770,693.42$ 76 Water Core Fund Year End Balance 1,472,165.55$ 1,733,059.32$ 1,869,948.07$ 2,029,459.76$ 2,656,700.86$ 2,476,967.67$ 2,604,021.67$ 2,748,390.08$ 2,910,616.23$ 3,151,260.08$ 3,550,898.74$ 3,970,126.90$ 4,409,557.44$ 77 Water Utility Fund Year End Balance 7,431,034.08$ 8,061,199.67$ 7,784,744.99$ 8,529,479.30$ 9,289,289.19$ 8,181,095.79$ 7,236,357.58$ 6,349,597.75$ 5,591,942.48$ 4,131,473.33$ 2,806,138.82$ 2,410,460.82$ 2,134,178.04$ 9,825,353.40$ 10,782,534.51$ 10,931,766.22$ 12,133,606.35$ 13,827,285.86$ 12,719,467.00$ 12,091,477.65$ 11,548,628.08$ 11,162,855.27$ 10,178,075.98$ 9,533,099.14$ 9,848,332.90$ 10,314,428.90$ Well 16 debt begins in 2017 (avg $176,000 per year for 10 years) WTP debt begins in 2022 ($488,000 per year for 15 years) (25% share here, 75% share in Water Utility) Well 17 debt begins in 2022 ($191,000 per year for 10 years) ($1.5M @ 5% over 10 years) * Line 71 Details Year End Fund Balances Capital Investment Fund Revenue Debt Service Core Fund Revenue G:\Utilities\RATE MODELS\2019\Rate Model Water 20190801 Sanitary Sewer Rate Analysis 25.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0% Description 2018 Projected 2018 Actual 2019 Projected 2020 Budgeted 2021 2022 2023 2024 2025 2026 2027 2028 2029 1 Water Demand (MG)966.748 871.274 875.000 896.875 919.297 942.279 965.836 989.982 1,014.732 1,040.100 1,066.103 1,092.755 1,120.074 1 2 Q1 Water Demand (MG) (~15% of total demand)145.012 125.299 131.250 134.531 137.895 141.342 144.875 148.497 152.210 156.015 159.915 163.913 168.011 2 3 Sanitary Sewer Flows (MG) *528.490 TBD 541.702 555.245 569.126 583.354 597.938 612.886 628.209 643.914 660.012 676.512 693.425 3 4 Estimated Growth (from water spreadsheet)2.5%2.4%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,885 6,886 7,058 7,235 7,415 7,601 7,791 7,986 8,185 8,390 8,600 8,815 9,035 5 6 Commercial / Ind / Inst Accounts 179 173 177 182 186 191 196 201 206 211 216 221 227 6 7 Sanitary Sewer Fixed Charge ($/account/quarter)24.50$ 24.50$ 12.25$ 6.00$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 7 8 Rate per 1000 gallons (39% then 25% then 5% therafter)2.02$ 2.02$ 2.80$ 3.50$ 3.68$ 3.86$ 4.05$ 4.25$ 4.47$ 4.69$ 4.92$ 5.17$ 5.43$ 8 10 Sewer Utility Fund Beginning Balance 1,756,314.80$ 1,756,314.80$ 2,005,252.92$ 1,790,091.20$ 1,660,227.63$ 1,492,618.84$ 1,408,841.01$ 1,332,454.99$ 1,398,173.41$ 1,565,940.66$ 1,740,319.06$ 2,138,281.58$ 2,671,511.56$ 10 11 Fixed Charges 692,272.00$ 354,538.28$ 177,992.69$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 11 12 Sewer Use Charges (~70% of total water demand is billed)1,366,981.67$ 1,715,000.00$ 2,197,343.75$ 2,364,891.21$ 2,545,214.17$ 2,739,286.75$ 2,948,157.36$ 3,172,954.36$ 3,414,892.13$ 3,675,277.65$ 3,955,517.57$ 4,257,125.79$ 12 13 Miscellaneous Revenue 123,555.22$ 120,000.00$ 120,000.00$ 123,600.00$ 127,308.00$ 131,127.24$ 135,061.06$ 139,112.89$ 143,286.28$ 147,584.86$ 152,012.41$ 156,572.78$ 13 14 Total Revenue 2,182,808.89$ 2,011,115.00$ 2,189,538.28$ 2,495,336.44$ 2,488,491.21$ 2,672,522.17$ 2,870,413.99$ 3,083,218.42$ 3,312,067.25$ 3,558,178.40$ 3,822,862.52$ 4,107,529.98$ 4,413,698.57$ 14 21 100's - Salaries & Benefits (4%) (add 1 shared pos. in 2021)527,300.00$ 560,212.00$ 508,700.00$ 572,500.00$ 635,400.00$ 660,900.00$ 687,400.00$ 714,900.00$ 743,500.00$ 773,300.00$ 804,300.00$ 836,500.00$ 870,000.00$ 21 22 200's - Materials and Equipment 19,300.00$ 14,332.00$ 16,400.00$ 16,900.00$ 17,500.00$ 18,100.00$ 18,700.00$ 19,300.00$ 19,900.00$ 20,500.00$ 21,200.00$ 21,900.00$ 22,600.00$ 22 23 300's - Communications, Computer, Eng, Prof Svcs 149,600.00$ 136,209.00$ 147,600.00$ 150,400.00$ 155,000.00$ 159,700.00$ 164,500.00$ 169,500.00$ 174,600.00$ 179,900.00$ 185,300.00$ 190,900.00$ 196,700.00$ 23 24 400's - Training, Conferences, Contracted Repair, Misc 36,800.00$ 34,748.00$ 77,000.00$ 77,100.00$ 79,500.00$ 81,900.00$ 84,400.00$ 87,000.00$ 89,700.00$ 92,400.00$ 95,200.00$ 98,100.00$ 101,100.00$ 24 25 500's - Buildings, Machinery, Furniture, Equipment 21,000.00$ -$ 71,000.00$ 201,000.00$ 75,000.00$ 77,300.00$ 79,700.00$ 82,100.00$ 84,600.00$ 87,200.00$ 89,900.00$ 92,600.00$ 95,400.00$ 25 26 530.03 - CRP of Sewer Main 150,000.00$ -$ 150,000.00$ 150,000.00$ 160,000.00$ 150,000.00$ 175,000.00$ 175,000.00$ 175,000.00$ 150,000.00$ 185,000.00$ 190,000.00$ 150,001.00$ 26 27 602 - Sewer Service Charges (5% annual increase)1,300,124.64$ 1,300,125.00$ 1,304,000.00$ 1,390,000.00$ 1,459,500.00$ 1,532,500.00$ 1,609,200.00$ 1,689,700.00$ 1,774,200.00$ 1,863,000.00$ 1,956,200.00$ 2,054,100.00$ 2,156,900.00$ 27 28 611 - Interest on Lease Payments -$ 476.00$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 28 29 710.00 - Transfers for Other Improvements -$ 65,000.00$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 29 30 Utility Equipment Purchases (540, 550, 580) and Leases 41,700.00$ 24,754.00$ 67,300.00$ 4,700.00$ 9,700.00$ 9,400.00$ 59,400.00$ 9,400.00$ 10,000.00$ 142,500.00$ 10,500.00$ 10,500.00$ 11,000.00$ 30 31 Lift Station Expenses (9 facilities)279,400.00$ 50,454.00$ 62,700.00$ 62,600.00$ 64,500.00$ 66,500.00$ 68,500.00$ 70,600.00$ 72,800.00$ 75,000.00$ 77,300.00$ 79,700.00$ 82,100.00$ 31 32 Future PW/PD Facility -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 32 33 Total Expenses 2,525,224.64$ 2,186,310.00$ 2,404,700.00$ 2,625,200.00$ 2,656,100.00$ 2,756,300.00$ 2,946,800.00$ 3,017,500.00$ 3,144,300.00$ 3,383,800.00$ 3,424,900.00$ 3,574,300.00$ 3,685,801.00$ 33 34 Year End Balance 1,413,899.05$ 2,005,252.92$ 1,790,091.20$ 1,660,227.63$ 1,492,618.84$ 1,408,841.01$ 1,332,454.99$ 1,398,173.41$ 1,565,940.66$ 1,740,319.06$ 2,138,281.58$ 2,671,511.56$ 3,399,409.14$ 34 35 Balance change (342,415.75)$ 248,938.12$ (215,161.73)$ (129,863.57)$ (167,608.79)$ (83,777.83)$ (76,386.01)$ 65,718.42$ 167,767.25$ 174,378.40$ 397,962.52$ 533,229.98$ 727,897.57$ 35 36 % change -19.50%14.17%-10.73%-7.25%-10.10%-5.61%-5.42%4.93%12.00%11.14%22.87%24.94%27.25%36 * 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, 2016 are used to determine our 2018 rates. MCES charges per 1,000 gallons $2.46007 Percent change from previous year -1.26% Projected Demands and Connections Expenses Scenario 1 Proposed Rates Revenue G:\Utilities\RATE MODELS\2019\Rate Model Sewer 20190801 Model Storm Water Rate Analysis Description 2018 Projected 2018 Actual 2019 Projected 2020 Budgeted 2021 2022 2023 2024 2025 2026 2027 2028 2029 1 Growth (residential, rural only)2.5%5.5%2.5%2.5%2.5%2.5%2.5%2.5%2.5%2.5%2.5%2.5%2.5%1 2 Residential / Muliti-family 6886 7241 7422 7608 7798 7993 8193 8397 8607 8822 9043 9269 9501 2 3 Rural Residential / Agricultural 665 616 631 647 663 680 697 714 732 751 769 789 808 3 4 Park / Golf Course / Cemetery (Cat 3)5 7 7 7 7 7 7 7 7 7 7 7 7 4 5 Undeveloped / Unplatted (Cat 4)202 135 135 135 135 135 135 135 135 135 135 135 135 5 6 Apt / Church / School / Govt / Mobile Home Park (Cat 5)183 192 192 192 192 192 192 192 192 192 192 192 192 6 7 Commercial / Industrial (add 2 annually) (Cat 6)198 197 199 201 203 205 207 209 211 213 215 217 219 7 8 Exceptions (split fee accounts)14 19 19 19 19 19 19 19 19 19 19 19 19 8 9 Rate Increase %3.0%3.0%3.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%9 10 Residential / Muliti-family (per unit)17.83$ 17.83$ 18.36$ 18.36$ 18.36$ 18.36$ 18.36$ 18.36$ 18.36$ 18.36$ 18.36$ 18.36$ 18.36$ 10 11 Rural Residential / Agricultural (per lot)18.77$ 18.77$ 19.33$ 19.33$ 19.33$ 19.33$ 19.33$ 19.33$ 19.33$ 19.33$ 19.33$ 19.33$ 19.33$ 11 12 Park / Golf Course / Cemetery (per acre)3.81$ 3.81$ 3.93$ 3.93$ 3.93$ 3.93$ 3.93$ 3.93$ 3.93$ 3.93$ 3.93$ 3.93$ 3.93$ 12 13 Undeveloped / Unplatted (per acre)0.214$ 0.214$ 0.221$ 0.221$ 0.221$ 0.221$ 0.221$ 0.221$ 0.221$ 0.221$ 0.221$ 0.221$ 0.221$ 13 14 Apt / Church / School / Govt / Mobile Home Park (per acre)66.20$ 66.20$ 68.18$ 68.18$ 68.18$ 68.18$ 68.18$ 68.18$ 68.18$ 68.18$ 68.18$ 68.18$ 68.18$ 14 15 Commercial / Industrial (per acre)82.56$ 82.56$ 85.04$ 85.04$ 85.04$ 85.04$ 85.04$ 85.04$ 85.04$ 85.04$ 85.04$ 85.04$ 85.04$ 15 16 Exceptions (split fee accounts)-$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 16 17 603 49500 Beginning Storm Water Utility Fund Balance 4,050,306.16$ 4,050,306.16$ 4,794,744.47$ 5,138,666.61$ 5,531,761.77$ 5,693,417.04$ 5,844,918.95$ 5,935,188.46$ 6,063,410.24$ 6,178,231.18$ 6,146,758.75$ 6,122,559.38$ 6,157,656.73$ 17 18 Residential / Muliti-family 491,086.67$ 545,197.58$ 558,827.52$ 572,798.21$ 587,118.17$ 601,796.12$ 616,841.02$ 632,262.05$ 648,068.60$ 664,270.31$ 680,877.07$ 697,899.00$ 18 19 Rural Residential / Agricultural 49,936.05$ 48,818.83$ 50,039.30$ 51,290.29$ 52,572.54$ 53,886.86$ 55,234.03$ 56,614.88$ 58,030.25$ 59,481.01$ 60,968.03$ 62,492.23$ 19 20 Park / Golf Course / Cemetery 2,441.87$ 2,441.87$ 2,441.87$ 2,441.87$ 2,441.87$ 2,441.87$ 2,441.87$ 2,441.87$ 2,441.87$ 2,441.87$ 2,441.87$ 2,441.87$ 20 21 Undeveloped / Unplatted 12,791.22$ 12,791.22$ 12,791.22$ 12,791.22$ 12,791.22$ 12,791.22$ 12,791.22$ 12,791.22$ 12,791.22$ 12,791.22$ 12,791.22$ 12,791.22$ 21 22 Apt / Church / School / Govt / Mobile Home Park 137,961.26$ 137,961.26$ 137,961.26$ 137,961.26$ 137,961.26$ 137,961.26$ 137,961.26$ 137,961.26$ 137,961.26$ 137,961.26$ 137,961.26$ 137,961.26$ 22 23 Commercial / Industrial (1% annual growth, plus rate inc)718,260.85$ 718,260.85$ 725,443.46$ 732,697.90$ 740,024.88$ 747,425.13$ 754,899.38$ 762,448.37$ 770,072.85$ 777,773.58$ 785,551.32$ 793,406.83$ 23 24 Exceptions (split fee accounts)28,668.80$ 148,550.52$ 148,550.52$ 148,550.52$ 148,550.52$ 148,550.52$ 148,550.52$ 148,550.52$ 148,550.52$ 148,550.52$ 148,550.52$ 148,550.52$ 24 25 Interest / Assessments / Other 59,500.00$ 124,391.00$ 73,600.00$ 75,440.00$ 77,326.00$ 79,259.15$ 81,240.63$ 83,271.64$ 85,353.44$ 87,487.27$ 89,674.45$ 91,916.31$ 94,214.22$ 25 26 Total Revenues 1,500,646.73$ 1,392,315.00$ 1,687,622.14$ 1,711,495.16$ 1,735,857.27$ 1,760,719.61$ 1,786,093.60$ 1,811,990.94$ 1,838,423.61$ 1,865,403.85$ 1,892,944.23$ 1,921,057.61$ 1,949,757.16$ 26 27 100's - Salaries and Benefits (4% annual increase)294,100.00$ 289,482.00$ 494,100.00$ 536,600.00$ 578,064.00$ 601,186.56$ 625,234.02$ 650,243.38$ 676,253.12$ 703,303.24$ 731,435.37$ 760,692.79$ 791,120.50$ 27 28 200's - Materials and Equipment 16,900.00$ 18,410.00$ 19,200.00$ 25,700.00$ 26,471.00$ 27,265.13$ 28,083.08$ 28,925.58$ 29,793.34$ 30,687.14$ 31,607.76$ 32,555.99$ 33,532.67$ 28 29 300's - Communications, Computer, Eng, Prof Svcs 159,400.00$ 168,377.00$ 93,400.00$ 94,700.00$ 97,541.00$ 100,467.23$ 103,481.25$ 106,585.68$ 109,783.25$ 113,076.75$ 116,469.06$ 119,963.13$ 123,562.02$ 29 30 400's - Contracted Repairs, Training/Cert 74,500.00$ 45,776.00$ 97,300.00$ 138,500.00$ 142,655.00$ 146,934.65$ 151,342.69$ 155,882.97$ 160,559.46$ 165,376.24$ 170,337.53$ 175,447.66$ 180,711.09$ 30 31 405.xx - MS4 Permit Compliance 170,000.00$ 34,624.00$ 110,000.00$ 110,000.00$ 113,300.00$ 116,699.00$ 120,199.97$ 123,805.97$ 127,520.15$ 131,345.75$ 135,286.13$ 139,344.71$ 143,525.05$ 31 32 530.01 & 530.02 - CRP and Improvements 350,000.00$ -$ 60,000.00$ 200,000.00$ 200,000.00$ 200,000.00$ 200,000.00$ 200,000.00$ 200,000.00$ 200,000.00$ 200,000.00$ 200,000.00$ 200,000.00$ 32 33 540/550/580 - Equipment / Leases (from CIP)91,700.00$ 56,468.00$ 194,000.00$ 187,200.00$ 9,700.00$ 9,400.00$ 59,400.00$ 9,400.00$ 9,900.00$ 142,400.00$ 120,400.00$ 45,400.00$ 11,000.00$ 33 34 500's - Other 1,000.00$ 81.00$ 1,000.00$ 1,000.00$ 1,030.00$ 1,060.90$ 1,092.73$ 1,125.51$ 1,159.27$ 1,194.05$ 1,229.87$ 1,266.77$ 1,304.77$ 34 35 700's - P&I Payments / Transfers -$ 43,887.00$ 250,000.00$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 35 36 $30M Pipe to River (4.5% over 25 years) ($2M/yr)-$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 36 37 $10M Project (4.0% over 20 years) ($760k/yr) (split w/Core)-$ -$ -$ 380,000.00$ 380,000.00$ 380,000.00$ 380,000.00$ 380,000.00$ 380,000.00$ 380,000.00$ 380,000.00$ 380,000.00$ 37 38 Future PW/PD Facility -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 38 39 Lift Station Expenses 22,700.00$ 11,462.00$ 24,700.00$ 24,700.00$ 25,441.00$ 26,204.23$ 26,990.36$ 27,800.07$ 28,634.07$ 29,493.09$ 30,377.88$ 31,289.22$ 32,227.90$ 39 40 Total Expenses 1,180,300.00$ 668,567.00$ 1,343,700.00$ 1,318,400.00$ 1,574,202.00$ 1,609,217.70$ 1,695,824.10$ 1,683,769.16$ 1,723,602.67$ 1,896,876.28$ 1,917,143.60$ 1,885,960.26$ 1,896,984.00$ 40 41 Year End Balance 4,370,652.89$ 4,794,744.47$ 5,138,666.61$ 5,531,761.77$ 5,693,417.04$ 5,844,918.95$ 5,935,188.46$ 6,063,410.24$ 6,178,231.18$ 6,146,758.75$ 6,122,559.38$ 6,157,656.73$ 6,210,429.89$ 41 42 Balance change 320,346.73$ 744,438.31$ 343,922.14$ 393,095.16$ 161,655.27$ 151,501.91$ 90,269.51$ 128,221.79$ 114,820.94$ (31,472.43)$ (24,199.37)$ 35,097.35$ 52,773.16$ 42 43 % change 7.91%18.38%7.17%7.65%2.92%2.66%1.54%2.16%1.89%-0.51%-0.39%0.57%0.86%43 1,267,924.00$ Expenses Customer Groups Revenue Rates G:\Utilities\RATE MODELS\2019\Rate Model Storm 20190801 Model G:\Utilities\RATE MODELS\2019\Utility Rate Estimator 2019 v. 2020 Comparison 2018: usage charges + $13.15 fixed charge + $8.88 surcharge + $1.00 maintenance fee 2019: usage charges + $6.50 fixed charge + $8.93 surcharge + $1.02 maintenance fee 2020: usage charges + $3.00 fixed charge + $8.97 surcharge + $1.05 maintenance fee Usage (1000s)2018 Actual 2019 Actual 2020 Proposed Q1 12 $37.31 $33.25 $31.50 Q2 21 $50.72 $49.09 $48.87 Q3 28 $62.63 $63.13 $64.30 Q4 15 $41.78 $38.53 $37.29 76 $192.44 $184.00 $181.96 2018: $2.02 usage charge + $24.50 fixed charge 2019: $2.80 usage charge + $12.25 fixed charge 2020: $3.50 usage charge + $6.00 fixed charge 2018 Actual 2019 Actual 2020 Proposed Quarter 1 $48.74 $45.85 $48.00 Quarter 2 $66.92 $71.05 $79.50 Quarter 3 $81.06 $90.65 $104.00 Quarter 4 $54.80 $54.25 $58.50 Total $251.52 $261.80 $290.00 2018: Includes $17.82 stormwater fees 2019: Includes $18.36 stormwater fees 2020: Includes $18.36 stormwater fees 2018 Actual 2019 Actual 2020 Proposed Quarter 1 $103.87 $97.46 $97.86 Quarter 2 $135.46 $138.50 $146.73 Quarter 3 $161.51 $172.14 $186.66 Quarter 4 $114.40 $111.14 $114.15 Total $515.24 $519.24 $545.40 0.8%5.0% 5.9% Sewer Rates Total Proposed Utility Bill Water Rates Utility Bill Comparison 2018 - 2020 (AVERAGE User) 2018: usage charges + $13.15 fixed charge + $8.88 surcharge + $1.00 maintenance fee 2019: usage charges + $6.50 fixed charge + $8.93 surcharge + $1.02 maintenance fee 2020: usage charges + $3.00 fixed charge + $8.97 surcharge + $1.05 maintenance fee Usage (1000s)2018 Actual 2019 Actual 2020 Proposed Q1 5 $28.98 $23.45 $20.72 Q2 5 $28.98 $23.45 $20.72 Q3 5 $28.98 $23.45 $20.72 Q4 5 $28.98 $23.45 $20.72 20 $115.92 $93.80 $82.88 2018: $2.02 usage charge + $24.50 fixed charge 2019: $2.80 usage charge + $12.25 fixed charge 2020: $3.50 usage charge + $6.00 fixed charge 2018 Actual 2019 Actual 2020 Proposed Quarter 1 $34.60 $26.25 $23.50 Quarter 2 $34.60 $26.25 $23.50 Quarter 3 $34.60 $26.25 $23.50 Quarter 4 $34.60 $26.25 $23.50 Total $138.40 $105.00 $94.00 2018: Includes $17.82 stormwater fees 2019: Includes $18.36 stormwater fees 2020: Includes $18.36 stormwater fees 2018 Actual 2019 Actual 2020 Proposed Quarter 1 $81.40 $68.06 $62.58 Quarter 2 $81.40 $68.06 $62.58 Quarter 3 $81.40 $68.06 $62.58 Quarter 4 $81.40 $68.06 $62.58 Total $325.60 $272.24 $250.32 -16.4%-8.1% -23.1% Utility Bill Comparison 2018 - 2020 (LOW User) Water Rates Sewer Rates Total Proposed Utility Bill G:\Utilities\RATE MODELS\2019\Utility Rate Estimator 2019 v. 2020 Comparison 2018: usage charges + $13.15 fixed charge + $8.88 surcharge + $1.00 maintenance fee 2019: usage charges + $6.50 fixed charge + $8.93 surcharge + $1.02 maintenance fee 2020: usage charges + $3.00 fixed charge + $8.97 surcharge + $1.05 maintenance fee Usage (1000s)2018 Actual 2019 Actual 2020 Proposed Q1 15 $41.78 $38.53 $37.29 Q2 40 $84.95 $89.41 $93.22 Q3 70 $161.21 $179.31 $192.14 Q4 25 $57.05 $56.56 $57.07 150 $344.99 $363.81 $379.72 2018: $2.02 usage charge + $24.50 fixed charge 2019: $2.80 usage charge + $12.25 fixed charge 2020: $3.50 usage charge + $6.00 fixed charge 2018 Actual 2019 Actual 2020 Proposed Quarter 1 $54.80 $54.25 $58.50 Quarter 2 $105.30 $124.25 $146.00 Quarter 3 $165.90 $208.25 $251.00 Quarter 4 $75.00 $82.25 $93.50 Total $401.00 $469.00 $549.00 2018: Includes $17.82 stormwater fees 2019: Includes $18.36 stormwater fees 2020: Includes $18.36 stormwater fees 2018 Actual 2019 Actual 2020 Proposed Quarter 1 $114.40 $111.14 $114.15 Quarter 2 $208.07 $232.02 $257.58 Quarter 3 $344.93 $405.92 $461.50 Quarter 4 $149.87 $157.17 $168.93 Total $817.27 $906.25 $1,002.16 10.9%10.6% 22.6% Utility Bill Comparison 2018 - 2020 (HIGH User) Water Rates Sewer Rates Total Proposed Utility Bill G:\Utilities\RATE MODELS\2019\Utility Rate Estimator 2019 v. 2020 Comparison 2018: usage charges + $13.15 fixed charge + $13.64 surcharge + $6.31 maintenance fee (1-inch meter) 2019: usage charges + $6.50 fixed charge + $13.71 surcharge + $6.34 maintenance fee (1-inch meter) 2020: usage charges + $3.00 fixed charge + $13.77 surcharge + $6.37 maintenance fee (1-inch meter) Usage (1000s)2018 Actual 2019 Actual 2020 Proposed Q1 72 $132.46 $143.91 $152.02 Q2 90 $160.80 $177.35 $188.74 Q3 115 $204.05 $228.35 $244.74 Q4 80 $143.50 $156.95 $166.34 357 $640.81 $706.56 $751.84 2018: $2.02 usage charge + $24.50 fixed charge 2019: $2.80 usage charge + $12.25 fixed charge 2020: $3.50 usage charge + $6.00 fixed charge 2018 Actual 2019 Actual 2020 Proposed Quarter 1 $169.94 $213.85 $258.00 Quarter 2 $206.30 $264.25 $321.00 Quarter 3 $256.80 $334.25 $408.50 Quarter 4 $186.10 $236.25 $286.00 Total $819.14 $1,048.60 $1,273.50 2018: Includes $82.56 stormwater fees (1 acre) 2019: Includes $85.04 stormwater fees (1 acre) 2020: Includes $85.04 stormwater fees (1 acre) 2018 Actual 2019 Actual 2020 Proposed Quarter 1 $384.96 $442.80 $495.06 Quarter 2 $449.66 $526.64 $594.78 Quarter 3 $543.41 $647.64 $738.28 Quarter 4 $412.16 $478.24 $537.38 Total $1,790.19 $2,095.32 $2,365.50 17.0%12.9% 32.1% Utility Bill Comparison 2018 - 2020 (Com / Ind / Inst AVG User) Water Rates Sewer Rates Total Proposed Utility Bill G:\Utilities\RATE MODELS\2019\Utility Rate Estimator 2019 v. 2020 Comparison