Loading...
HomeMy WebLinkAbout1 - Original Submission_ ATTACHMENT J 2 RATE ESCALATION 2024 N44255-21-C-1004N44255-21-C-1004 ATTACHMENT J.2 METHODOLOGY FOR ADJUSTMENT OF WATER AND WASTEWATER RATES Water Wastewater Fixed Volumetric Fixed Volumetric Year 1 - 2021 Base Yr 9,397,535$ 11,201,856$ 91,277$ 1.83$ 109,695$ 4.70$ Year 2 - 2022 9,396,807$ 11,202,393$ 91,270$ 1.83$ 109,700$ 4.70$ Escalation Percentage -0.01%0.00% Year 3 - 2023 9,783,834$ 11,624,081$ 95,029$ 1.91$ 113,830$ 4.88$ Escalation Percentage 4.12%3.76% Year 4 - 2024 10,121,272$ 12,029,600$ 98,307$ 1.97$ 117,801$ 5.05$ Escalation Percentage 3.45%3.49% Year 5 - 2025 10,102,382$ 12,029,600$ 98,307$ 1.97$ 117,801$ 5.05$ Escalation Percentage 0.00%0.00% Year 6 - 2026 6,560,730$ 11,827,241$ 63,843$ 1.28$ 115,819$ 4.96$ Escalation Percentage -35.06%-1.68% Year 7 - 2027 6,583,646$ 11,827,380$ 64,066$ 1.28$ 115,820$ 4.96$ Escalation Percentage 0.35%0.00% Year 8 - 2028 6,838,580$ 11,634,366$ 66,546$ 1.33$ 113,930$ 4.88$ Escalation Percentage 3.87%-1.63% Year 9 - 2029 6,843,281$ 11,036,270$ 66,592$ 1.34$ 108,073$ 4.63$ Escalation Percentage 0.07%-5.14% Year 10 - 2030 6,845,378$ 11,036,270$ 66,613$ 1.34$ 108,073$ 4.63$ Escalation Percentage 0.03%0.00% Determination of Rate Adjustment %Rates CLIN 0001 - WATER CLIN 0002 - SEWAGE DocuSign Envelope ID: 10849FAE-07C9-4649-8F6F-1F8A4DF8DA3A ATTACHMENT J.2 Year 1 Base Year Calculations - Water 2020 ACTIVE SERVICE COUNT 2021 Rates Billable Units (Hcf or Revenue Inside Outside Inside Outside Inside Outside Base Charge 5/8 x 3/4 inches 14.73$ 22.08$ 1 9,949 6,178 11 1,758,585$ 1,636,923$ 1-inch 16.83 25.26 2 1,080 178 12 218,117 53,955 1-1/2-inch 23.93 35.90 3 270 100 13 77,533 43,080 2-inch 32.15 48.21 4 262 44 14 101,080 25,455 3-inch 61.00 91.48 5 55 6 15 40,260 6,587 4-inch 113.34 170.00 6 32 6 16 43,523 12,240 6-inch 402.98 604.47 7 8 1 17 38,686 7,254 8-inch 1,472.00 2,208.02 8 1 - 18 17,664 - 10-inch 5,250.01 7,875.00 9 - - 19 - - 12-inch 19,736.47 29,604.69 10 - - 20 - - Base Sub-total 2,295,447$ 1,785,493$ Residential Commodity Charge (per HCF) Per HCF/Month $2.54 $3.81 75 678,806 469,218 76 1,724,167$ 1,787,721$ - - Non-residential Commodity Charge (per HCF)$2.30 $3.44 65 581,605 124,681 66 1,337,692 428,903 Commodity Sub-total 3,061,859$ 2,216,623$ Low-Income Senior and Low-Income Disabled Citizen 2020 ACTIVE SERVICE COUNT Base Charge (5/8" x 3/4")$8.84 $13.25 195 246 71 193 26,096$ 11,289$ Base Charge (1")$10.10 $15.16 185 3 2 184 364$ 364$ Commodity Charge $1.52 $2.29 195a 12,438 4,293 193a Per HCF/Month 1.08 1.62 - - Low-Income Sub-total 26,459$ 11,653$ Totals 5,383,766$ 4,013,769$ Grand Total 9,397,535$ 2020 CONSUMPTION 2020 CONSUMPTION DocuSign Envelope ID: 10849FAE-07C9-4649-8F6F-1F8A4DF8DA3A Year 2 Rate Adjustment Calculations - Water 2022 Rates Billable Units (Hcf or Revenue Inside Outside Inside Outside Inside Outside Base Charge 5/8 x 3/4 inches 14.73$ 22.08$ 9,949 6,178 1,758,585$ 1,636,923$ 1-inch 16.83$ 25.26$ 1,080 178 218,117 53,955 1-1/2-inch 23.93$ 35.90$ 270 100 77,533 43,080 2-inch 32.15$ 48.21$ 262 44 101,080 25,455 3-inch 61.00$ 91.48$ 55 6 40,260 6,587 4-inch 113.34$ 170.00$ 32 6 43,523 12,240 6-inch 402.98$ 604.47$ 8 1 38,686 7,254 8-inch 1,472.00$ 2,208.02$ 1 - 17,664 - 10-inch 5,250.01$ 7,875.00$ - - - - 12-inch 19,736.47$ 29,604.69$ - - - - Base Sub-total 2,295,447$ 1,785,493$ Residential Commodity Charge (per HCF) Per HCF/Month $2.54 $3.81 678,806 469,218 1,724,167$ 1,787,721$ Non-residential Commodity Charge (per HCF)$2.30 $3.44 581,605 124,681 1,337,692 428,903 Commodity Sub-total 3,061,859$ 2,216,623$ Low-Income Senior and Low-Income Disabled Citizen Base Charge (5/8" x 3/4")$8.84 $13.25 246 71 26,096$ 11,289$ Base Charge (1")$0.00 $0.00 246 71 Commodity Charge - - 1.08 1.62 - - - - Per HCF/Month 0.00 0.00 - - - - Low-Income Sub-total 26,096$ 11,289$ Totals 5,383,402$ 4,013,406$ Grand Total 9,396,807$ ESCALATOR -0.01% DocuSign Envelope ID: 10849FAE-07C9-4649-8F6F-1F8A4DF8DA3A Year 3 No Rate Adjustment - Water 2023 Rates Billable Units (Hcf or Revenue Inside Outside Inside Outside Inside Outside Base Charge 5/8 x 3/4 inches 15.28$ 22.91$ 9,949 6,178 1,824,249$ 1,698,456$ 1-inch 17.46$ 26.21$ 1,080 178 226,282 55,985 1-1/2-inch 24.83$ 37.25$ 270 100 80,449 44,700 2-inch 33.36$ 50.02$ 262 44 104,884 26,411 3-inch 63.29$ 94.91$ 55 6 41,771 6,834 4-inch 117.59$ 176.38$ 32 6 45,155 12,699 6-inch 418.09$ 627.14$ 8 1 40,137 7,526 8-inch 1,527.20$ 2,290.82$ 1 - 18,326 - 10-inch 5,446.89$ 8,170.31$ - - - - 12-inch 20,476.59$ 30,714.87$ - - - - Base Sub-total 2,381,252$ 1,852,609$ Residential Commodity Charge (per HCF) Per HCF/Month $2.64 $3.95 678,806 469,218 1,792,048$ 1,853,411$ Non-residential Commodity Charge (per HCF)$2.39 $3.57 581,605 124,681 1,390,036 445,111 Commodity Sub-total 3,182,084$ 2,298,522$ Low-Income Senior and Low-Income Disabled Citizen Base Charge (5/8" x 3/4")$9.17 $13.75 246 71 27,070$ 11,715$ Base Charge (1")$10.48 $15.73 3 2 377$ 378$ Commodity Charge $1.58 $2.37 12,438 4,293 19,652 10,174 Per HCF/Month Low-Income Sub-total 47,099$ 22,267$ Totals 5,610,435$ 4,173,399$ Grand Total 9,783,834$ ESCALATOR 4.12% DocuSign Envelope ID: 10849FAE-07C9-4649-8F6F-1F8A4DF8DA3A DocuSign Envelope ID: 10849FAE-07C9-4649-8F6F-1F8A4DF8DA3A Year 4 Rate Adjustment Calculations - Water 2024 Rates Billable Units (Hcf or Revenue Inside Outside Inside Outside Inside Outside Base Charge 5/8 x 3/4 inches 15.81$ 23.71$ 9,949 6,178 1,887,524$ 1,757,765$ 1-inch 18.07$ 27.13$ 1,080 178 234,187 57,950 1-1/2-inch 25.70$ 38.55$ 270 100 83,268 46,260 2-inch 34.53$ 51.77$ 262 44 108,562 27,335 3-inch 65.51$ 98.23$ 55 6 43,237 7,073 4-inch 121.71$ 182.55$ 32 6 46,737 13,144 6-inch 432.72$ 649.09$ 8 1 41,541 7,789 8-inch 1,580.65$ 2,371.00$ 1 - 18,968 - 10-inch 5,637.53$ 8,456.27$ - - - - 12-inch 21,193.27$ 31,789.89$ - - - - Base Sub-total 2,464,024$ 1,917,314$ Residential Commodity Charge (per HCF) 0 - 10 HCF/Month $2.73 $4.09 678,806 469,218 1,853,140$ 1,919,102$ Non-residential Commodity Charge (per HCF)$2.47 $3.69 581,605 124,681 1,436,564 460,073 Commodity Sub-total 3,289,705$ 2,379,175$ Low-Income Senior and Low-Income Disabled Citizen Base Charge (5/8" x 3/4")$9.49 $14.23 246 71 28,014$ 12,124$ Base Charge (1")10.84 16.28 Commodity Charge $1.64 $2.45 12,438 4,293 20,398 10,518 Per HCF/Month Low-Income Sub-total 48,413$ 22,642$ Totals 5,802,141$ 4,319,130$ Grand Total 10,121,272$ ESCALATOR 3.45% DocuSign Envelope ID: 10849FAE-07C9-4649-8F6F-1F8A4DF8DA3A Year 5 Rate Adjustment Calculations - Water 2025 Rates Billable Units (Hcf or Revenue Inside Outside Inside Outside Inside Outside Base Charge 5/8 x 3/4 inches 15.81$ 23.70$ 9,949 6,178 1,887,524$ 1,757,023$ 1-inch 18.07$ 27.13$ 1,080 178 234,187 57,950 1-1/2-inch 25.70$ 38.56$ 270 100 83,268 46,272 2-inch 34.54$ 51.77$ 262 44 108,594 27,335 3-inch 65.51$ 98.23$ 55 6 43,237 7,073 4-inch 121.72$ 182.56$ 32 6 46,740 13,144 6-inch 432.73$ 649.10$ 8 1 41,542 7,789 8-inch 1,580.65$ 2,371.00$ 1 - 18,968 - 10-inch 5,637.53$ 8,456.26$ - - - - 12-inch 21,193.28$ 31,789.90$ - - - - Base Sub-total 2,464,060$ 1,916,586$ Residential Commodity Charge (per HCF) 0 - 10 HCF/Month $2.74 $4.10 678,806 469,218 1,859,928$ 1,923,794$ Over 10 HCF/Month $0.01 $0.00 - - - - Non-residential Commodity Charge (per HCF)$2.47 $3.70 581,605 124,681 1,436,564 461,320 Commodity Sub-total 3,296,493$ 2,385,114$ Low-Income Senior and Low-Income Disabled Citizen Base Charge (per account)$9.49 $14.22 246 71 28,014$ 12,115$ Commodity Charge 0 - 5 HCF/Month $0.00 $0.00 12,438 4,293 - - 5 - 10 HCF/Month $1.65 $2.46 - - - - Over 10 HCF/Month $0.01 $0.00 - - - - Low-Income Sub-total 28,014$ 12,115$ Totals 5,788,567$ 4,313,814$ Grand Total 10,102,382$ ESCALATOR 0.00% DocuSign Envelope ID: 10849FAE-07C9-4649-8F6F-1F8A4DF8DA3A Year 6 Rate Adjustment Calculations - Water 2026 Rates Billable Units (Hcf or Revenue Inside Outside Inside Outside Inside Outside Base Charge 5/8 x 3/4 inches 10.24$ 15.36$ 9,949 6,178 1,222,533$ 1,138,729$ 1-inch 11.71$ 17.57$ 1,080 178 151,762 37,530 1-1/2-inch 16.64$ 24.96$ 270 100 53,914 29,952 2-inch 22.36$ 33.53$ 262 44 70,300 17,704 3-inch 42.41$ 63.62$ 55 6 27,991 4,581 4-inch 78.82$ 118.23$ 32 6 30,267 8,513 6-inch 280.25$ 420.38$ 8 1 26,904 5,045 8-inch 1,023.68$ 1,535.52$ 1 - 12,284 - 10-inch 3,651.00$ 5,476.49$ - - - - 12-inch 13,725.30$ 20,587.94$ - - - - Base Sub-total 1,595,954$ 1,242,052$ Residential Commodity Charge (per HCF) 0 - 10 HCF/Month $1.77 $2.66 678,806 469,218 1,201,487$ 1,248,120$ Over 10 HCF/Month $1.77 $2.66 - - - - Non-residential Commodity Charge (per HCF)$1.60 $2.40 581,605 124,681 930,568 299,234 Commodity Sub-total 2,132,055$ 1,547,354$ Low-Income Senior and Low-Income Disabled Citizen Base Charge (per account)$10.24 $15.36 246 71 30,228$ 13,087$ Commodity Charge 0 - 5 HCF/Month $0.00 $0.00 12,438 4,293 - - 5 - 10 HCF/Month $1.77 $2.66 - - - - Over 10 HCF/Month $1.77 $2.66 - - - - Low-Income Sub-total 30,228$ 13,087$ Totals 3,758,237$ 2,802,493$ Grand Total 6,560,730$ ESCALATOR -35.06% DocuSign Envelope ID: 10849FAE-07C9-4649-8F6F-1F8A4DF8DA3A Year 7 Rate Adjustment Calculations - Water 2027 Rates Billable Units (Hcf or Revenue Inside Outside Inside Outside Inside Outside Base Charge 5/8 x 3/4 inches 10.24$ 15.36$ 9,949 6,178 1,222,533$ 1,138,729$ 1-inch 11.71$ 19.14$ 1,080 178 151,762 40,883 1-1/2-inch 18.14$ 27.21$ 270 100 58,774 32,652 2-inch 22.36$ 36.56$ 262 44 70,300 19,304 3-inch 46.23$ 69.35$ 55 6 30,512 4,993 4-inch 85.91$ 128.87$ 32 6 32,989 9,279 6-inch 305.47$ 458.21$ 8 1 29,325 5,499 8-inch 1,115.81$ 1,673.72$ 1 - 13,390 - 10-inch 3,979.59$ 5,969.39$ - - - - 12-inch 14,960.58$ 22,440.87$ - - - - Base Sub-total 1,609,584$ 1,251,338$ Residential Commodity Charge (per HCF) 0 - 10 HCF/Month $1.77 $2.66 678,806 469,218 1,201,487$ 1,248,120$ Over 10 HCF/Month $1.77 $2.66 - - - - Non-residential Commodity Charge (per HCF)$1.60 $2.40 581,605 124,681 930,568 299,234 Commodity Sub-total 2,132,055$ 1,547,354$ Low-Income Senior and Low-Income Disabled Citizen Base Charge (per account)$10.24 $15.36 246 71 30,228$ 13,087$ Commodity Charge 0 - 5 HCF/Month $0.00 $0.00 12,438 4,293 - - 5 - 10 HCF/Month $1.77 $2.66 - - - - Over 10 HCF/Month $1.77 $2.66 - - - - Low-Income Sub-total 30,228$ 13,087$ Totals 3,771,867$ 2,811,779$ Grand Total 6,583,646$ ESCALATOR 0.35% DocuSign Envelope ID: 10849FAE-07C9-4649-8F6F-1F8A4DF8DA3A Year 8 Sample Calculations - Water 2028 Rates Billable Units (Hcf or Revenue Inside Outside Inside Outside Inside Outside Base Charge 5/8 x 3/4 inches 10.24$ 15.36$ 9,949 6,178 1,222,533$ 1,138,729$ 1-inch 13.84$ 19.14$ 1,080 178 179,366 40,883 1-1/2-inch 18.14$ 27.21$ 270 100 58,774 32,652 2-inch 22.36$ 39.66$ 262 44 70,300 20,940 3-inch 46.23$ 69.35$ 55 6 30,512 4,993 4-inch 85.91$ 128.87$ 32 6 32,989 9,279 6-inch 305.47$ 497.15$ 8 1 29,325 5,966 8-inch 1,115.81$ 1,815.98$ 1 - 13,390 - 10-inch 3,979.59$ 6,476.78$ - - - - 12-inch 14,960.58$ 22,440.87$ - - - - Base Sub-total 1,637,189$ 1,253,442$ Residential Commodity Charge (per HCF) 0 - 10 HCF/Month $1.77 $3.14 678,806 469,218 1,201,487$ 1,473,345$ Over 10 HCF/Month $1.77 $3.14 - - - - Non-residential Commodity Charge (per HCF)$1.60 $2.40 581,605 124,681 930,568 299,234 Commodity Sub-total 2,132,055$ 1,772,579$ Low-Income Senior and Low-Income Disabled Citizen Base Charge (per account)$10.24 $15.36 246 71 30,228$ 13,087$ Commodity Charge 0 - 5 HCF/Month $0.00 $0.00 12,438 4,293 - - 5 - 10 HCF/Month $1.77 $3.14 - - - - Over 10 HCF/Month $1.77 $3.14 - - - - Low-Income Sub-total 30,228$ 13,087$ Totals 3,799,472$ 3,039,108$ Grand Total 6,838,580$ ESCALATOR 3.87% DocuSign Envelope ID: 10849FAE-07C9-4649-8F6F-1F8A4DF8DA3A Year 9 Sample Calculations - Water 2029 Rates Billable Units (Hcf or Revenue Inside Outside Inside Outside Inside Outside Base Charge 5/8 x 3/4 inches 10.24$ 15.36$ 9,949 6,178 1,222,533$ 1,138,729$ 1-inch 13.84$ 19.14$ 1,080 178 179,366 40,883 1-1/2-inch 18.14$ 27.21$ 270 100 58,774 32,652 2-inch 22.36$ 39.66$ 262 44 70,300 20,940 3-inch 46.23$ 76.18$ 55 6 30,512 5,485 4-inch 85.91$ 128.87$ 32 6 32,989 9,279 6-inch 335.57$ 497.15$ 8 1 32,215 5,966 8-inch 1,225.78$ 1,815.98$ 1 - 14,709 - 10-inch 3,979.59$ 6,476.78$ - - - - 12-inch 14,960.58$ 24,652.69$ - - - - Base Sub-total 1,641,398$ 1,253,934$ Residential Commodity Charge (per HCF) 0 - 10 HCF/Month $1.77 $3.14 678,806 469,218 1,201,487$ 1,473,345$ Over 10 HCF/Month $1.77 $3.14 - - - - Non-residential Commodity Charge (per HCF)$1.60 $2.40 581,605 124,681 930,568 299,234 Commodity Sub-total 2,132,055$ 1,772,579$ Low-Income Senior and Low-Income Disabled Citizen Base Charge (per account)$10.24 $15.36 246 71 30,228$ 13,087$ Commodity Charge 0 - 5 HCF/Month $0.00 $0.00 12,438 4,293 - - 5 - 10 HCF/Month $1.77 $3.14 - - - - Over 10 HCF/Month $1.77 $3.14 - - - - Low-Income Sub-total 30,228$ 13,087$ Totals 3,803,681$ 3,039,600$ Grand Total 6,843,281$ ESCALATOR 0.07% DocuSign Envelope ID: 10849FAE-07C9-4649-8F6F-1F8A4DF8DA3A Year 10 Sample Calculations - Water 2030 Rates Billable Units (Hcf or Revenue Inside Outside Inside Outside Inside Outside Base Charge 5/8 x 3/4 inches 10.24$ 15.36$ 9,949 6,178 1,222,533$ 1,138,729$ 1-inch 13.84$ 19.14$ 1,080 178 179,366 40,883 1-1/2-inch 18.14$ 27.21$ 270 100 58,774 32,652 2-inch 22.36$ 39.66$ 262 44 70,300 20,940 3-inch 46.23$ 76.18$ 55 6 30,512 5,485 4-inch 85.91$ 148.29$ 32 6 32,989 10,677 6-inch 335.57$ 497.15$ 8 1 32,215 5,966 8-inch 1,284.01$ 1,815.98$ 1 - 15,408 - 10-inch 4,579.50$ 6,476.78$ - - - - 12-inch 14,960.58$ 25,823.70$ - - - - Base Sub-total 1,642,097$ 1,255,332$ Residential Commodity Charge (per HCF) 0 - 10 HCF/Month $1.77 $3.14 678,806 469,218 1,201,487$ 1,473,345$ Over 10 HCF/Month $1.77 $3.14 - - - - Non-residential Commodity Charge (per HCF)$1.60 $2.40 581,605 124,681 930,568 299,234 Commodity Sub-total 2,132,055$ 1,772,579$ Low-Income Senior and Low-Income Disabled Citizen Base Charge (per account)$10.24 $15.36 246 71 30,228$ 13,087$ Commodity Charge 0 - 5 HCF/Month $0.00 $0.00 12,438 4,293 - - 5 - 10 HCF/Month $1.77 $3.14 - - - - Over 10 HCF/Month $1.77 $3.14 - - - - Low-Income Sub-total 30,228$ 13,087$ Totals 3,804,380$ 3,040,998$ Grand Total 6,845,378$ ESCALATOR 0.03% DocuSign Envelope ID: 10849FAE-07C9-4649-8F6F-1F8A4DF8DA3A ATTACHMENT J.2 2020 ACTIVE SERVICE COUNT Year 1 Base Year Calculations - Wastewater 2021 Rates Billable Units (Hcf or Revenue Inside Outside Inside Outside Inside Outside Single-Family Base Charge (per account)$37.23 $55.85 120 8,314 626 121 3,714,363$ 419,545$ Commodity Charge (per HCF)5.00 7.49 120a 514,154 41,531 121a 2,570,770 311,067 Duplex on 1 Meter or 2 Buildings on 1 Meter Base Charge (per unit)$29.48 $44.23 125 864 12 127 305,649$ 6,369$ Commodity Charge (per HCF)5.00 7.49 125a 90,770 1,820 127a 453,850 13,632 Multifamily Base Charge (per unit)$29.48 $44.23 115 431 9 117 152,471$ 4,777$ Commodity Charge (per HCF)5.00 7.49 115a 259,523 6,227 117a 1,297,615 46,640 Commercial I Base Charge (per account)$55.04 $82.56 140 633 35 141 418,084$ 34,675$ Commodity Charge (per HCF)5.15 7.71 140a 134,024 3,220 141a 690,224 24,826 Commercial II Base Charge (per account)$55.44 $83.16 151 114 2 152 75,842$ 1,996$ Commodity Charge (per HCF)6.59 9.89 151a 44,880 295 152a 295,759 2,918 Commercial III Base Charge (per account)$55.99 $84.00 146 52 1 147 34,938$ 1,008$ Commodity Charge (per HCF)8.05 12.07 146a 26,287 - 147a 211,610 - Low-Income Senior and Low-Income Disabled Citizen Base Charge (per account)$22.34 $33.51 196 242 19 194 64,875$ 7,640$ Commodity Charge (per HCF) Per HCF/Month 3.00 4.49 196a 11,946 1,086 194a 35,838 4,876 Totals 10,321,887$ 879,970$ Grand Total 11,201,856$ 2020 CONSUMPTION DocuSign Envelope ID: 10849FAE-07C9-4649-8F6F-1F8A4DF8DA3A Year 2 Rate Adjustment Calculations - Wastewater 2022 Rates Billable Units (Hcf or Revenue Inside Outside Inside Outside Inside Outside Single-Family Base Charge (per account)$37.23 $55.85 8,314 626 3,714,363$ 419,545$ Commodity Charge (per HCF)5.00 7.50 514,154 41,531 2,570,770 311,483 Duplex on 1 Meter or 2 Buildings on 1 Meter Base Charge (per unit)$29.48 $44.23 864 12 305,649$ 6,369$ Commodity Charge (per HCF)5.00 7.50 90,770 1,820 453,850 13,650 Multifamily Base Charge (per unit)$29.48 $44.23 431 9 152,471$ 4,777$ Commodity Charge (per HCF)5.00 7.50 259,523 6,227 1,297,615 46,703 Commercial I Base Charge (per account)$55.04 $82.56 633 35 418,084$ 34,675$ Commodity Charge (per HCF)5.15 7.72 134,024 3,220 690,224 24,858 Commercial II Base Charge (per account)$55.44 $83.17 114 2 75,842$ 1,996$ Commodity Charge (per HCF)6.59 9.88 44,880 295 295,759 2,915 Commercial III Base Charge (per account)$55.99 $84.00 52 1 34,938$ 1,008$ Commodity Charge (per HCF)8.05 12.07 26,287 - 211,610 - Low-Income Senior and Low-Income Disabled Citizen Base Charge (per account)$22.34 $33.51 242 19 64,875$ 7,640$ Commodity Charge (per HCF) 0 - 5 HCF/Month 0.00 0.00 - - -$ -$ Over 5 HCF/Month 3.00 4.50 11,946 1,086 35,838 4,887 Totals 10,321,887$ 880,506$ Grand Total 11,202,393$ ESCALATOR 0.00% DocuSign Envelope ID: 10849FAE-07C9-4649-8F6F-1F8A4DF8DA3A Year 3 No Rate Adjustment - Wastewater 2023 Rates Billable Units (Hcf or Revenue Inside Outside Inside Outside Inside Outside Single-Family Base Charge (per account)$38.63 $57.94 8,314 626 3,854,038$ 435,245$ Commodity Charge (per HCF)5.19 7.77 514,154 41,531 2,668,459 322,696 Duplex on 1 Meter or 2 Buildings on 1 Meter Base Charge (per unit)$30.59 $45.89 864 12 317,157$ 6,608$ Commodity Charge (per HCF)5.19 7.77 90,770 1,820 471,096 14,141 Multifamily Base Charge (per unit)$30.59 $45.89 431 9 158,211$ 4,956$ Commodity Charge (per HCF)5.19 7.77 259,523 6,227 1,346,924 48,384 Commercial I Base Charge (per account)$57.10 $85.66 633 35 433,732$ 35,977$ Commodity Charge (per HCF)5.34 8.00 134,024 3,220 715,688 25,760 Commercial II Base Charge (per account)$57.52 $86.28 114 2 78,687$ 2,071$ Commodity Charge (per HCF)6.84 10.26 44,880 295 306,979 3,027 Commercial III Base Charge (per account)$58.09 $87.15 52 1 36,248$ 1,046$ Commodity Charge (per HCF)8.35 12.52 26,287 - 219,496 - Low-Income Senior and Low-Income Disabled Citizen Base Charge (per account)$23.18 $34.76 242 19 67,315$ 7,925$ Commodity Charge (per HCF) Per HCF/Month 3.11 4.66 11,946 1,086 37,152 5,061 Totals 10,711,184$ 912,897$ Grand Total 11,624,081$ ESCALATOR 3.76% DocuSign Envelope ID: 10849FAE-07C9-4649-8F6F-1F8A4DF8DA3A Year 4 No Rate Adjustment - Wastewater 2024 Rates Billable Units (Hcf or Revenue Inside Outside Inside Outside Inside Outside Single-Family Base Charge (per account)$39.98 $59.97 8,314 626 3,988,725$ 450,495$ Commodity Charge (per HCF)5.37 8.04 514,154 41,531 2,761,007 333,909 Duplex on 1 Meter or 2 Buildings on 1 Meter Base Charge (per unit)$31.66 $47.50 864 12 328,251$ 6,840$ Commodity Charge (per HCF)5.37 8.04 90,770 1,820 487,435 14,633 Multifamily Base Charge (per unit)$31.66 $47.50 431 9 163,746$ 5,130$ Commodity Charge (per HCF)5.37 8.04 259,523 6,227 1,393,639 50,065 Commercial I Base Charge (per account)$59.10 $88.66 633 35 448,924$ 37,237$ Commodity Charge (per HCF)5.53 8.28 134,024 3,220 741,153 26,662 Commercial II Base Charge (per account)$59.53 $89.30 114 2 81,437$ 2,143$ Commodity Charge (per HCF)7.08 10.62 44,880 295 317,750 3,133 Commercial III Base Charge (per account)$60.12 $90.20 52 1 37,515$ 1,082$ Commodity Charge (per HCF)8.64 12.96 26,287 - 227,120 - Low-Income Senior and Low-Income Disabled Citizen Base Charge (per account)$23.99 $35.98 242 19 69,667$ 8,203$ Commodity Charge (per HCF)3.22 4.82 11,946 1,086 38,466 5,235 Totals 11,084,833$ 944,767$ Grand Total 12,029,600$ ESCALATOR 3.49% DocuSign Envelope ID: 10849FAE-07C9-4649-8F6F-1F8A4DF8DA3A Year 5 No Rate Adjustment - Wastewater 2025 Rates Billable Units (Hcf or Revenue Inside Outside Inside Outside Inside Outside Single-Family Base Charge (per account)$39.98 $59.97 8,314 626 3,988,725$ 450,495$ Commodity Charge (per HCF)5.37 8.04 514,154 41,531 2,761,007 333,909 Duplex on 1 Meter or 2 Buildings on 1 Meter Base Charge (per unit)$31.66 $47.50 864 12 328,251$ 6,840$ Commodity Charge (per HCF)5.37 8.04 90,770 1,820 487,435 14,633 Multifamily Base Charge (per unit)$31.66 $47.50 431 9 163,746$ 5,130$ Commodity Charge (per HCF)5.37 8.04 259,523 6,227 1,393,639 50,065 Commercial I Base Charge (per account)$59.10 $88.66 633 35 448,924$ 37,237$ Commodity Charge (per HCF)5.53 8.28 134,024 3,220 741,153 26,662 Commercial II Base Charge (per account)$59.53 $89.30 114 2 81,437$ 2,143$ Commodity Charge (per HCF)7.08 10.62 44,880 295 317,750 3,133 Commercial III Base Charge (per account)$60.12 $90.20 52 1 37,515$ 1,082$ Commodity Charge (per HCF)8.64 12.96 26,287 - 227,120 - Low-Income Senior and Low-Income Disabled Citizen Base Charge (per account)$23.99 $35.98 242 19 69,667$ 8,203$ Commodity Charge (per HCF) 0 - 5 HCF/Month 0.00 0.00 - - -$ -$ Over 5 HCF/Month 3.22 4.82 11,946 1,086 38,466 5,235 Totals 11,084,833$ 944,767$ Grand Total 12,029,600$ ESCALATOR 0.00% DocuSign Envelope ID: 10849FAE-07C9-4649-8F6F-1F8A4DF8DA3A Year 6 Rate Adjustment Calculations - Wastewater 2026 Rates Billable Units (Hcf or Revenue Inside Outside Inside Outside Inside Outside Single-Family Base Charge (per account)$39.98 $46.89 8,314 626 3,988,725$ 352,238$ Commodity Charge (per HCF)5.37 6.29 514,154 41,531 2,761,007 261,230 Duplex on 1 Meter or 2 Buildings on 1 Meter Base Charge (per unit)$31.66 $37.14 864 12 328,251$ 5,348$ Commodity Charge (per HCF)5.37 6.29 90,770 1,820 487,435 11,448 Multifamily Base Charge (per unit)$31.66 $37.14 431 9 163,746$ 4,011$ Commodity Charge (per HCF)5.37 6.29 259,523 6,227 1,393,639 39,168 Commercial I Base Charge (per account)$59.10 $69.32 633 35 448,924$ 29,114$ Commodity Charge (per HCF)5.53 6.48 134,024 3,220 741,153 20,866 Commercial II Base Charge (per account)$59.53 $70.52 114 2 81,437$ 1,692$ Commodity Charge (per HCF)7.08 10.14 44,880 295 317,750 2,991 Commercial III Base Charge (per account)$60.12 $69.83 52 1 37,515$ 838$ Commodity Charge (per HCF)8.64 8.30 26,287 - 227,120 - Low-Income Senior and Low-Income Disabled Citizen Base Charge (per account)$23.99 $29.09 242 19 69,667$ 6,633$ Commodity Charge (per HCF) 0 - 5 HCF/Month 0.00 0.00 - - -$ -$ Over 5 HCF/Month 3.22 6.29 11,946 1,086 38,466 6,831 Totals 11,084,833$ 742,408$ Grand Total 11,827,241$ ESCALATOR -1.68% DocuSign Envelope ID: 10849FAE-07C9-4649-8F6F-1F8A4DF8DA3A Year 7 Rate Adjustment Calculations - Wastewater 2027 Rates Billable Units (Hcf or Revenue Inside Outside Inside Outside Inside Outside Single-Family Base Charge (per account)$39.98 $46.89 8,314 626 3,988,725$ 352,238$ Commodity Charge (per HCF)5.37 6.29 514,154 41,531 2,761,007 261,230 Duplex on 1 Meter or 2 Buildings on 1 Meter Base Charge (per unit)$31.66 $37.14 864 12 328,251$ 5,348$ Commodity Charge (per HCF)5.37 6.29 90,770 1,820 487,435 11,448 Multifamily Base Charge (per unit)$31.66 $37.14 431 9 163,746$ 4,011$ Commodity Charge (per HCF)5.37 6.29 259,523 6,227 1,393,639 39,168 Commercial I Base Charge (per account)$59.10 $69.32 633 35 448,924$ 29,114$ Commodity Charge (per HCF)5.53 6.48 134,024 3,220 741,153 20,866 Commercial II Base Charge (per account)$59.53 $72.63 114 2 81,437$ 1,743$ Commodity Charge (per HCF)7.08 10.44 44,880 295 317,750 3,080 Commercial III Base Charge (per account)$60.12 $69.83 52 1 37,515$ 838$ Commodity Charge (per HCF)8.64 8.30 26,287 - 227,120 - Low-Income Senior and Low-Income Disabled Citizen Base Charge (per account)$23.99 $29.09 242 19 69,667$ 6,633$ Commodity Charge (per HCF) 0 - 5 HCF/Month 0.00 0.00 - - -$ -$ Over 5 HCF/Month 3.22 6.29 11,946 1,086 38,466 6,831 Totals 11,084,833$ 742,547$ Grand Total 11,827,380$ ESCALATOR 0.00% DocuSign Envelope ID: 10849FAE-07C9-4649-8F6F-1F8A4DF8DA3A Year 8 Sample Calculations - Wastewater 2028 Rates Billable Units (Hcf or Revenue Inside Outside Inside Outside Inside Outside Single-Family Base Charge (per account)$39.98 $46.89 8,314 626 3,988,725$ 352,238$ Commodity Charge (per HCF)5.37 6.29 514,154 41,531 2,761,007 261,230 Duplex on 1 Meter or 2 Buildings on 1 Meter Base Charge (per unit)$31.66 $37.14 864 12 328,251$ 5,348$ Commodity Charge (per HCF)5.37 6.29 90,770 1,820 487,435 11,448 Multifamily Base Charge (per unit)$31.66 $37.14 431 9 163,746$ 4,011$ Commodity Charge (per HCF)5.37 6.29 259,523 6,227 1,393,639 39,168 Commercial I Base Charge (per account)$49.50 $69.32 633 35 376,002$ 29,114$ Commodity Charge (per HCF)4.63 6.48 134,024 3,220 620,531 20,866 Commercial II Base Charge (per account)$59.53 $72.63 114 2 81,437$ 1,743$ Commodity Charge (per HCF)7.08 10.44 44,880 295 317,750 3,080 Commercial III Base Charge (per account)$60.12 $74.80 52 1 37,515$ 898$ Commodity Charge (per HCF)8.64 8.30 26,287 - 227,120 - Low-Income Senior and Low-Income Disabled Citizen Base Charge (per account)$23.99 $31.15 242 19 69,667$ 7,102$ Commodity Charge (per HCF) 0 - 5 HCF/Month 0.00 0.00 - - -$ -$ Over 5 HCF/Month 3.22 6.29 11,946 1,086 38,466 6,831 Totals 10,891,290$ 743,076$ Grand Total 11,634,366$ ESCALATOR -1.63% DocuSign Envelope ID: 10849FAE-07C9-4649-8F6F-1F8A4DF8DA3A Year 9 Sample Calculations - Wastewater 2029 Rates Billable Units (Hcf or Revenue Inside Outside Inside Outside Inside Outside Single-Family Base Charge (per account)$34.24 $46.89 8,314 626 3,416,056$ 352,238$ Commodity Charge (per HCF)5.37 6.89 514,154 41,531 2,761,007 286,149 Duplex on 1 Meter or 2 Buildings on 1 Meter Base Charge (per unit)$27.12 $37.14 864 12 281,180$ 5,348$ Commodity Charge (per HCF)5.37 6.89 90,770 1,820 487,435 12,540 Multifamily Base Charge (per unit)$27.12 $37.14 431 9 140,265$ 4,011$ Commodity Charge (per HCF)5.37 6.89 259,523 6,227 1,393,639 42,904 Commercial I Base Charge (per account)$49.50 $69.32 633 35 376,002$ 29,114$ Commodity Charge (per HCF)4.63 6.48 134,024 3,220 620,531 20,866 Commercial II Base Charge (per account)$59.53 $77.24 114 2 81,437$ 1,854$ Commodity Charge (per HCF)7.40 10.44 44,880 295 332,112 3,080 Commercial III Base Charge (per account)$60.12 $74.80 52 1 37,515$ 898$ Commodity Charge (per HCF)8.64 8.30 26,287 - 227,120 - Low-Income Senior and Low-Income Disabled Citizen Base Charge (per account)$23.99 $32.26 242 19 69,667$ 7,355$ Commodity Charge (per HCF) 0 - 5 HCF/Month 0.00 0.00 - - -$ -$ Over 5 HCF/Month 3.22 6.89 11,946 1,086 38,466 7,483 Totals 10,262,431$ 773,838$ Grand Total 11,036,270$ ESCALATOR -5.14% DocuSign Envelope ID: 10849FAE-07C9-4649-8F6F-1F8A4DF8DA3A Year 10 Sample Calculations - Wastewater 2030 Rates Billable Units (Hcf or Revenue Inside Outside Inside Outside Inside Outside Single-Family Base Charge (per account)$34.24 $46.89 8,314 626 3,416,056$ 352,238$ Commodity Charge (per HCF)5.37 6.89 514,154 41,531 2,761,007 286,149 Duplex on 1 Meter or 2 Buildings on 1 Meter Base Charge (per unit)$27.12 $37.14 864 12 281,180$ 5,348$ Commodity Charge (per HCF)5.37 6.89 90,770 1,820 487,435 12,540 Multifamily Base Charge (per unit)$27.12 $37.14 431 9 140,265$ 4,011$ Commodity Charge (per HCF)5.37 6.89 259,523 6,227 1,393,639 42,904 Commercial I Base Charge (per account)$49.50 $69.32 633 35 376,002$ 29,114$ Commodity Charge (per HCF)4.63 6.48 134,024 3,220 620,531 20,866 Commercial II Base Charge (per account)$59.53 $77.24 114 2 81,437$ 1,854$ Commodity Charge (per HCF)7.40 10.44 44,880 295 332,112 3,080 Commercial III Base Charge (per account)$60.12 $74.80 52 1 37,515$ 898$ Commodity Charge (per HCF)8.64 8.30 26,287 - 227,120 - Low-Income Senior and Low-Income Disabled Citizen Base Charge (per account)$23.99 $32.26 242 19 69,667$ 7,355$ Commodity Charge (per HCF) 0 - 5 HCF/Month 0.00 0.00 - - -$ -$ Over 5 HCF/Month 3.22 6.89 11,946 1,086 38,466 7,483 Totals 10,262,431$ 773,838$ Grand Total 11,036,270$ ESCALATOR 0.00% DocuSign Envelope ID: 10849FAE-07C9-4649-8F6F-1F8A4DF8DA3A Water Wastewater Base Commodity Low income Single Family Duplex Multi-Family Commercial Low Income Res Non-res Base Commodity Base Commodity Base Commodity Base Commodity Base Commodity Base Commodity Year 2 - 2022 0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00% Year 3 - 2023 4.12%4.12%4.12%4.12%4.12%3.76%3.76%3.76%3.76%3.76%3.76%3.76%3.76%3.76%3.76% Year 4 - 2024 3.45%3.45%3.45%3.45%3.45%3.49%3.49%3.49%3.49%3.49%3.49%3.49%3.49%3.49%3.49% Year 5 - 2025 0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00% Year 6 - 2026 0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00% Year 7 - 2027 0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00% Year 8 - 2028 0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00% Year 9 - 2029 0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00% Year 10 - 2030 0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00% DocuSign Envelope ID: 10849FAE-07C9-4649-8F6F-1F8A4DF8DA3A