Loading...
Item 4C - MemoM E M O R A N D U M September 5, 2023 To: Shana Yelverton, City Manager From: Nick Cornelius, Management Assistant, Finance 4C Subject: Item 4C - Resolution No. 23-019, approving a negotiated settlement between the Atmos Cities Steering Committee & Atmos Energy Corp., Mid-Tex Division regarding the 2023 Rate Review Mechanism Filing Action Requested: Background Information: Approval of Resolution No. 23-019, approving a negotiated settlement between the Atmos Cities Steering Committee & Atmos Energy Corp., Mid-Tex Division regarding the 2023 Rate Review Mechanism Filing The City of Southlake, along with 181 other Mid-Texas cities, are served by Atmos Energy Corporation Mid-Tex Division and are members of the Atmos Cities Steering Committee (ACSC). The ACSC undertakes activities on behalf of its city members and their citizens such as participation in rate cases, rulemakings, advocacy and legislative efforts that impact natural gas rates. In 2007, ACSC and Atmos Mid-Tex settled a rate application filed by the Company pursuant to Section 104.301 of the Texas Utilities Code for an interim rate adjustment commonly referred to as a GRIP filing (arising out of the Gas Reliability Infrastructure Program legislation). That settlement created a substitute rate review process, referred to as Rate Review Mechanism (“RRM”), as a substitute for future filings under the GRIP statute. Since 2007, there have been several modifications to the original RRM Tariff. The most recent iteration of an RRM Tariff was reflected in a resolution adopted by ACSC members in 2018. On March 1st, 2023, the Company filed a rate request pursuant to the RRM Tariff adopted by ACSC members. The Company claimed that its cost-of- service in a test year ending December 31, 2022, entitled it to additional system-wide revenues of $165.9 million. Resolution No. 22-023 and the subsequent attachments are the results of the negotiation between the ACSC Executive Committee and Atmos to resolve issues identified during the review and evaluation of the Atmos filing. The proposed settlement agreement for Council approval does the following: Approves rates that will increase Atmos’ revenues by $142 million which is $23.9 million less than original requested by Atmos in the rate request: Typical residential customer will see a monthly increase of $6.47 (or about 7.31% increase) Typical commercial customer will see an increase of $24.72 (or about 5.19% increase) Requires Atmos to reimburse Cities for reasonable rate-making costs associated with reviewing and processing the rate filing Establishes a benchmark for pensions and retiree medical benefits to be used in future rate cases or RRM filings The ACSC Executive Committee, ACSC legal counsel and consultants recommend that all cities adopt the resolution approving the negotiated settlement agreement resolving the 2023 filing and implement the rate change. If approved, the proposed rates would go into effect on October 1, 2023. Financial Considerations: None Strategic Link: This item is specifically linked to the City’s Strategy Map through B2: Collaborate with select partners to implement service solutions. Citizen Input/ Board Review: None required. Legal Review: Lloyd Gosselink Rochelle & Townsend, P.C. prepared this resolution. The Legislature’s GRIP process allowed gas utilities to receive annual rate increases associated with capital investments. The RRM process has proven to result in a more efficient and less costly (both from a consumer rate impact perspective and from a ratemaking perspective) than the GRIP process. Given Atmos Mid-Tex’s claim that its historic cost of service should entitle it to recover $165.9 million in additional system-wide revenues, the RRM settlement at $142 million for ACSC Cities reflects substantial savings to ACSC Cities. Settlement at $142 million is fair and reasonable. The ACSC Executive Committee consisting of city employees of 181 ACSC members urges all ACSC members to pass the resolution before September 30, 2023. New rates become effective October 1, 2023. Alternatives: Deny the resolution which would result in another contested case hearing on appeal of the 2023 filing and permits Atmos Energy to implement rates at the original amount requested (subject to refund) until a resolution is passed. Staff Recommendation: Approval of Resolution 23-019, approving a negotiated settlement between the Atmos Cities Steering Committee (ACSC) and Atmos Energy Corp., Mid-Tex Division. Supporting Documents: Resolution 23-019 New Tariffs (Exhibit A) Benchmark for pensions for RRM filing (Exhibit B) Average Bill Comparison – Base Rates (Exhibit C) Staff Contacts: Nick Cornelius (817) 748-8286 RESOLUTION NO. 23-019 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF SOUTHLAKE, TEXAS, APPROVING A NEGOTIATED SETTLEMENT BETWEEN THE ATMOS CITIES STEERING COMMITTEE (“ACSC”) AND ATMOS ENERGY CORP., MID-TEX DIVISION REGARDING THE COMPANY’S 2023 RATE REVIEW MECHANISM FILING; DECLARING EXISTING RATES TO BE UNREASONABLE; ADOPTING TARIFFS THAT REFLECT RATE ADJUSTMENTS CONSISTENT WITH THE NEGOTIATED SETTLEMENT; FINDING THE RATES TO BE SET BY THE ATTACHED SETTLEMENT TARIFFS TO BE JUST AND REASONABLE AND IN THE PUBLIC INTEREST; APPROVING AN ATTACHMENT ESTABLISHING A BENCHMARK FOR PENSIONS AND RETIREE MEDICAL BENEFITS; REQUIRING THE COMPANY TO REIMBURSE ACSC’S REASONABLE RATEMAKING EXPENSES; DETERMINING THAT THIS RESOLUTION WAS PASSED IN ACCORDANCE WITH THE REQUIREMENTS OF THE TEXAS OPEN MEETINGS ACT; ADOPTING A SAVINGS CLAUSE; DECLARING AN EFFECTIVE DATE; AND REQUIRING DELIVERY OF THIS RESOLUTION TO THE COMPANY AND THE ACSC’S LEGAL COUNSEL. WHEREAS, the City of Southlake, Texas (“City”) is a gas utility customer of Atmos Energy Corp., Mid-Tex Division (“Atmos Mid-Tex” or “Company”), and a regulatory authority with an interest in the rates, charges, and services of Atmos Mid-Tex; and WHEREAS, the City is a member of the Atmos Cities Steering Committee (“ACSC”), a coalition of similarly-situated cities served by Atmos Mid-Tex (“ACSC Cities”) that have joined together to facilitate the review of, and response to, natural gas issues affecting rates charged in the Atmos Mid-Tex service area; and WHEREAS, ACSC and the Company worked collaboratively to develop a Rate Review Mechanism (“RRM”) tariff that allows for an expedited rate review process by ACSC Cities as a substitute to the Gas Reliability Infrastructure Program (“GRIP”) process instituted by the 2 Legislature, and that will establish rates for the ACSC Cities based on the system-wide cost of serving the Atmos Mid-Tex Division; and WHEREAS, the current RRM tariff was adopted by the City in a rate ordinance in 2018; and WHEREAS, on about March 1, 2023, Atmos Mid-Tex filed its 2023 RRM rate request with ACSC Cities based on a test year ending December 31, 2022; and WHEREAS, ACSC coordinated its review of the Atmos Mid-Tex 2023 RRM filing through its Executive Committee, assisted by ACSC’s attorneys and consultants, to resolve issues identified in the Company’s RRM filing; and WHEREAS, the Executive Committee, as well as ACSC’s counsel and consultants, recommend that ACSC Cities approve an increase in base rates for Atmos Mid-Tex of $142 million on a system-wide basis with an Effective Date of October 1, 2023; and WHEREAS, ACSC agrees that Atmos’ plant-in-service is reasonable; and WHEREAS, with the exception of approved plant-in-service, ACSC is not foreclosed from future reasonableness evaluation of costs associated with incidents related to gas leaks; and WHEREAS, the attached tariffs (Attachment 1) implementing new rates are consistent with the recommendation of the ACSC Executive Committee, are agreed to by the Company, and are just, reasonable, and in the public interest; and WHEREAS, the settlement agreement sets a new benchmark for pensions and retiree medical benefits (Attachment 2); and WHEREAS, the RRM Tariff contemplates reimbursement of ACSC’s reasonable expenses associated with RRM applications; and 3 WHEREAS, the RRM Tariff includes Securitization Interest Regulatory Asset amount of $19.5 million; NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF SOUTHLAKE, TEXAS: Section 1. That the findings set forth in this Resolution are hereby in all things approved. Section 2. That, without prejudice to future litigation of any issue identified by ACSC, the City Council finds that the settled amount of an increase in revenues of $142 million on a system-wide basis represents a comprehensive settlement of gas utility rate issues affecting the rates, operations, and services offered by Atmos Mid-Tex within the municipal limits arising from Atmos Mid-Tex’s 2023 RRM filing, is in the public interest, and is consistent with the City’s authority under Section 103.001 of the Texas Utilities Code. Section 3. That despite finding Atmos Mid-Tex’s plant-in-service to be reasonable, ACSC is not foreclosed in future cases from evaluating the reasonableness of costs associated with incidents involving leaks of natural gas. Section 4. That the existing rates for natural gas service provided by Atmos Mid-Tex are unreasonable. The new tariffs attached hereto and incorporated herein as Attachment 1, are just and reasonable, and are designed to allow Atmos Mid-Tex to recover annually an additional $142 on a system-wide basis, over the amount allowed under currently approved rates. Such tariffs are hereby adopted. Section 5. That the ratemaking treatment for pensions and retiree medical benefits in Atmos Mid-Tex’s next RRM filing shall be as set forth on Attachment 2, attached hereto and incorporated herein. 4 Section 6. That Atmos Mid-Tex shall reimburse the reasonable ratemaking expenses of the ACSC in processing the Company’s 2023 RRM filing. Section 7. That to the extent any resolution or ordinance previously adopted by the Council is inconsistent with this Resolution, it is hereby repealed. Section 8. That the meeting at which this Resolution was approved was in all things conducted in strict compliance with the Texas Open Meetings Act, Texas Government Code, Chapter 551. Section 9. That if any one or more sections or clauses of this Resolution is adjudged to be unconstitutional or invalid, such judgment shall not affect, impair, or invalidate the remaining provisions of this Resolution, and the remaining provisions of the Resolution shall be interpreted as if the offending section or clause never existed. Section 10. That consistent with the City Ordinance that established the RRM process, this Resolution shall become effective from and after its passage with rates authorized by attached tariffs to be effective for bills rendered on or after September 30, 2023. Section 11. That a copy of this Resolution shall be sent to Atmos Mid-Tex, care of Chris Felan, Vice President of Rates and Regulatory Affairs Mid-Tex Division, Atmos Energy Corporation, 5420 LBJ Freeway, Suite 1862, Dallas, Texas 75240, and to Thomas Brocato, General Counsel to ACSC, at Lloyd Gosselink Rochelle & Townsend, P.C., 816 Congress Avenue, Suite 1900, Austin, Texas 78701. 5 DULY PASSED AND APPROVED BY THE CITY COUNCIL OF THE CITY OF SOUTHLAKE, TEXAS, ON THIS THE 5TH DAY OF SEPTEMBER 2023. John Huffman, Mayor ATTEST: Amy Shelley, TRMC City Secretary APPROVED AS TO FORM: ______________________________ City Attorney MID-TEX DIVISION ATMOS ENERGY CORPORATION RATE SCHEDULE: R – RESIDENTIAL SALES APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION UNDER THE RRM TARIFF EFFECTIVE DATE: Bills Rendered on or after 10/01/2023 Application Applicable to Residential Customers for all natural gas provided at one Point of Delivery and measured through one meter. Type of Service Where service of the type desired by Customer is not already available at the Point of Delivery, additional charges and special contract arrangements between Company and Customer may be required prior to service being furnished. Monthly Rate Customer's monthly bill will be calculated by adding the following Customer and Ccf charges to the amounts due under the riders listed below: Charge Amount Customer Charge per Bill $ 22.25 per month Rider CEE Surcharge $ 0.05 per month 1 Total Customer Charge $ 22.30 per month Commodity Charge – All Ccf $0.48567 per Ccf 2 Gas Cost Recovery: Plus an amount for gas costs and upstream transportation costs calculated in accordance with Part (a) and Part (b), respectively, of Rider GCR. Weather Normalization Adjustment: Plus or Minus an amount for weather normalization calculated in accordance with Rider WNA. Franchise Fee Adjustment: Plus an amount for franchise fees calculated in accordance with Rider FF. Rider FF is only applicable to customers inside the corporate limits of any incorporated municipality. Tax Adjustment: Plus an amount for tax calculated in accordance with Rider TAX. Surcharges: Plus an amount for surcharges calculated in accordance with the applicable rider(s). Agreement An Agreement for Gas Service may be required. Notice Service hereunder and the rates for services provided are subject to the orders of regulatory bodies having jurisdiction and to the Company’s Tariff for Gas Service. 1Reference Rider CEE - Conservation and Energy Efficiency as approved in GUD 10170. Surcharge billing effective July 1, 2023. 2The commodity charge includes the base rate amount of $0.46724 per Ccf and Securitization Regulatory Asset amounts related to financing costs in the amount of $0.01843 per Ccf until recovered. Exhibit A MID-TEX DIVISION ATMOS ENERGY CORPORATION RATE SCHEDULE: C – COMMERCIAL SALES APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION UNDER THE RRM TARIFF EFFECTIVE DATE: Bills Rendered on or after 10/01/2023 Application Applicable to Commercial Customers for all natural gas provided at one Point of Delivery and measured through one meter and to Industrial Customers with an average annual usage of less than 30,000 Ccf. Type of Service Where service of the type desired by Customer is not already available at the Point of Delivery, additional charges and special contract arrangements between Company and Customer may be required prior to service being furnished. Monthly Rate Customer's monthly bill will be calculated by adding the following Customer and Ccf charges to the amounts due under the riders listed below: Charge Amount Customer Charge per Bill $ 72.00 per month Rider CEE Surcharge ($ 0.02) per month 1 Total Customer Charge $ 71.98 per month Commodity Charge – All Ccf $ 0.18280 per Ccf 2 Gas Cost Recovery: Plus an amount for gas costs and upstream transportation costs calculated in accordance with Part (a) and Part (b), respectively, of Rider GCR. Weather Normalization Adjustment: Plus or Minus an amount for weather normalization calculated in accordance with Rider WNA. Franchise Fee Adjustment: Plus an amount for franchise fees calculated in accordance with Rider FF. Rider FF is only applicable to customers inside the corporate limits of any incorporated municipality. Tax Adjustment: Plus an amount for tax calculated in accordance with Rider TAX. Surcharges: Plus an amount for surcharges calculated in accordance with the applicable rider(s). Agreement An Agreement for Gas Service may be required. Notice Service hereunder and the rates for services provided are subject to the orders of regulatory bodies having jurisdiction and to the Company’s Tariff for Gas Service. Presumption of Plant Protection Level For service under this Rate Schedule, plant protection volumes are presumed to be 10% of normal, regular, historical usage as reasonably calculated by the Company in its sole discretion. If a customer believes it needs to be modeled at an alternative plant protection volume, it should contact the company at mdtx.plantprotection@atmosenergy.com. 1 Reference Rider CEE - Conservation and Energy Efficiency as approved in GUD 10170. Surcharge billing effective July 1, 2023. 2The commodity charge includes the base rate amount of $0.16437 per Ccf and Securitization Regulatory Asset amounts related to financing costs in the amount of $0.01843 per Ccf until recovered. MID-TEX DIVISION ATMOS ENERGY CORPORATION RATE SCHEDULE: I – INDUSTRIAL SALES APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION UNDER THE RRM TARIFF EFFECTIVE DATE: Bills Rendered on or after 10/01/2023 Application Applicable to Industrial Customers with a maximum daily usage (MDU) of less than 200 MMBtu per day for all natural gas provided at one Point of Delivery and measured through one meter. Service for Industrial Customers with an MDU equal to or greater than 200 MMBtu per day will be provided at Company's sole option and will require special contract arrangements between Company and Customer. Type of Service Where service of the type desired by Customer is not already available at the Point of Delivery, additional charges and special contract arrangements between Company and Customer may be required prior to service being furnished. Monthly Rate Customer's monthly bill will be calculated by adding the following Customer and MMBtu charges to the amounts due under the riders listed below: Charge Amount Customer Charge per Meter $ 1,382.00 per month First 0 MMBtu to 1,500 MMBtu $ 0.7484 per MMBtu 1 Next 3,500 MMBtu $ 0.5963 per MMBtu1 All MMBtu over 5,000 MMBtu $ 0.2693 per MMBtu1 Gas Cost Recovery: Plus an amount for gas costs and upstream transportation costs calculated in accordance with Part (a) and Part (b), respectively, of Rider GCR. Franchise Fee Adjustment: Plus an amount for franchise fees calculated in accordance with Rider FF. Rider FF is only applicable to customers inside the corporate limits of any incorporated municipality. Tax Adjustment: Plus an amount for tax calculated in accordance with Rider TAX. Surcharges: Plus an amount for surcharges calculated in accordance with the applicable rider(s). Curtailment Overpull Fee Upon notification by Company of an event of curtailment or interruption of Customer’s deliveries, Customer will, for each MMBtu delivered in excess of the stated level of curtailment or interruption, pay Company 200% of the midpoint price for the Katy point listed in Platts Gas Daily published for the applicable Gas Day in the table entitled “Daily Price Survey.” Replacement Index In the event the “midpoint” or “common” price for the Katy point listed in Platts Gas Daily in the table entitled “Daily Price Survey” is no longer published, Company will calculate the applicable imbalance fees 1 The tiered commodity charges include the base rate amounts of $0.5684, $0.4163, and $0.0893 per MMBtu, respectively, plus Securitization Regulatory Asset amounts related to financing costs in the amount of $0.1800 per MMBtu until recovered. MID-TEX DIVISION ATMOS ENERGY CORPORATION RATE SCHEDULE: I – INDUSTRIAL SALES APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION UNDER THE RRM TARIFF EFFECTIVE DATE: Bills Rendered on or after 10/01/2023 utilizing a daily price index recognized as authoritative by the natural gas industry and most closely approximating the applicable index. Agreement An Agreement for Gas Service may be required. Notice Service hereunder and the rates for services provided are subject to the orders of regulatory bodies having jurisdiction and to the Company’s Tariff for Gas Service. Special Conditions In order to receive service under Rate I, Customer must have the type of meter required by Company. Customer must pay Company all costs associated with the acquisition and installation of the meter. Presumption of Plant Protection Level For service under this Rate Schedule, plant protection volumes are presumed to be 10% of normal, regular, historical usage as reasonably calculated by the Company in its sole discretion. If a customer believes it needs to be modeled at an alternative plant protection volume, it should contact the company at mdtx.plantprotection@atmosenergy.com. MID-TEX DIVISION ATMOS ENERGY CORPORATION RATE SCHEDULE: T – TRANSPORTATION APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION UNDER THE RRM TARIFF EFFECTIVE DATE: Bills Rendered on or after 10/01/2023 Application Applicable, in the event that Company has entered into a Transportation Agreement, to a customer directly connected to the Atmos Energy Corp., Mid-Tex Division Distribution System (Customer) for the transportation of all natural gas supplied by Customer or Customer’s agent at one Point of Delivery for use in Customer's facility. Type of Service Where service of the type desired by Customer is not already available at the Point of Delivery, additional charges and special contract arrangements between Company and Customer may be required prior to service being furnished. Monthly Rate Customer's bill will be calculated by adding the following Customer and MMBtu charges to the amounts and quantities due under the riders listed below: Charge Amount Customer Charge per Meter $ 1,382.00 per month First 0 MMBtu to 1,500 MMBtu $ 0.5684 per MMBtu Next 3,500 MMBtu $ 0.4163 per MMBtu All MMBtu over 5,000 MMBtu $ 0.0893 per MMBtu Upstream Transportation Cost Recovery: Plus an amount for upstream transportation costs in accordance with Part (b) of Rider GCR. Retention Adjustment: Plus a quantity of gas as calculated in accordance with Rider RA. Franchise Fee Adjustment: Plus an amount for franchise fees calculated in accordance with Rider FF. Rider FF is only applicable to customers inside the corporate limits of any incorporated municipality. Tax Adjustment: Plus an amount for tax calculated in accordance with Rider TAX. Surcharges: Plus an amount for surcharges calculated in accordance with the applicable rider(s). Imbalance Fees All fees charged to Customer under this Rate Schedule will be charged based on the quantities determined under the applicable Transportation Agreement and quantities will not be aggregated for any Customer with multiple Transportation Agreements for the purposes of such fees. Monthly Imbalance Fees Customer shall pay Company the greater of (i) $0.10 per MMBtu, or (ii) 150% of the difference per MMBtu between the highest and lowest “midpoint” price for the Katy point listed in Platts Gas Daily in the table entitled “Daily Price Survey” during such month, for the MMBtu of Customer’s monthly Cumulative Imbalance, as defined in the applicable Transportation Agreement, at the end of each month that exceeds 10% of Customer’s receipt quantities for the month. MID-TEX DIVISION ATMOS ENERGY CORPORATION RATE SCHEDULE: T – TRANSPORTATION APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION UNDER THE RRM TARIFF EFFECTIVE DATE: Bills Rendered on or after 10/01/2023 Curtailment Overpull Fee Upon notification by Company of an event of curtailment or interruption of Customer’s deliveries, Customer will, for each MMBtu delivered in excess of the stated level of curtailment or interruption, pay Company 200% of the midpoint price for the Katy point listed in Platts Gas Daily published for the applicable Gas Day in the table entitled “Daily Price Survey.” Replacement Index In the event the “midpoint” or “common” price for the Katy point listed in Platts Gas Daily in the table entitled “Daily Price Survey” is no longer published, Company will calculate the applicable imbalance fees utilizing a daily price index recognized as authoritative by the natural gas industry and most closely approximating the applicable index. Agreement A transportation agreement is required. Notice Service hereunder and the rates for services provided are subject to the orders of regulatory bodies having jurisdiction and to the Company’s Tariff for Gas Service. Special Conditions In order to receive service under Rate T, customer must have the type of meter required by Company. Customer must pay Company all costs associated with the acquisition and installation of the meter. MID-TEX DIVISION ATMOS ENERGY CORPORATION RIDER: WNA – WEATHER NORMALIZATION ADJUSTMENT APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION UNDER THE RRM TARIFF EFFECTIVE DATE: Bills Rendered on or after 10/01/2023 Provisions for Adjustment The Commodity Charge per Ccf (100 cubic feet) for gas service set forth in any Rate Schedules utilized by the cities of the Mid-Tex Division service area for determining normalized winter period revenues shall be adjusted by an amount hereinafter described, which amount is referred to as the "Weather Normalization Adjustment." The Weather Normalization Adjustment shall apply to all temperature sensitive residential and commercial bills based on meters read during the revenue months of November through April. The five regional weather stations are Abilene, Austin, Dallas, Waco, and Wichita Falls. Computation of Weather Normalization Adjustment The Weather Normalization Adjustment Factor shall be computed to the nearest one-hundredth cent per Ccf by the following formula: (HSFi x (NDD-ADD) ) WNAFi = Ri (BLi +(HSFi x ADD) ) Where i = any particular Rate Schedule or billing classification within any such particular Rate Schedule that contains more than one billing classification WNAFi = Weather Normalization Adjustment Factor for the ith rate schedule or classification expressed in cents per Ccf Ri = Commodity Charge rate of temperature sensitive sales for the ith schedule or classification. HSFi = heat sensitive factor for the ith schedule or classification divided by the average bill count in that class NDD = billing cycle normal heating degree days calculated as the simple ten-year average of actual heating degree days. ADD = billing cycle actual heating degree days. Bli = base load sales for the ith schedule or classification divided by the average bill count in that class The Weather Normalization Adjustment for the jth customer in ith rate schedule is computed as: WNA i = WNAF i x q ij Where q ij is the relevant sales quantity for the jth customer in ith rate schedule. MID-TEX DIVISION ATMOS ENERGY CORPORATION RIDER: WNA – WEATHER NORMALIZATION ADJUSTMENT APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION UNDER THE RRM TARIFF EFFECTIVE DATE: Bills Rendered on or after 10/01/2023 Base Use/Heat Use Factors Residential Commercial Base use Heat use Base use Heat use Weather Station Ccf Ccf/HDD Ccf Ccf/HDD Abilene 9.51 0.1415 88.91 0.7010 Austin 8.87 0.1213 213.30 0.7986 Dallas 12.54 0.2007 185.00 0.9984 Waco 8.81 0.1325 125.26 0.7313 Wichita Falls 10.36 0.1379 122.10 0.6083 Weather Normalization Adjustment (WNA) Report On or before June 1 of each year, the company posts on its website at atmosenergy.com/mtx-wna, in Excel format, a Weather Normalization Adjustment (WNA) Report to show how the company calculated its WNAs factor during the preceding winter season. Additionally, on or before June 1 of each year, the company files one hard copy and an Excel version of the WNA Report with the Railroad Commission of Texas' Gas Services Division, addressed to the Director of that Division. Line No.Description Pension Account Plan Post- Employment Benefit Plan Pension Account Plan Post- Employment Benefit Plan Supplemental Executive Benefit Plan Adjustment Total (a)(b)(c)(d)(e)(f)(g) 1 Proposed Benefits Benchmark - Fiscal Year 2023 Willis Towers Watson Report as adjusted (1) (2) (3)1,434,339$ (518,336)$ 2,336,419$ (2,678,818)$ 267,917$ 2 Allocation Factor 44.92%44.92%78.74%78.74%100.00% 3 Proposed Benefits Benchmark Costs Allocated to Mid-Tex (Ln 1 x Ln 2)644,336$ (232,848)$ 1,839,667$ (2,109,267)$ 267,917$ 4 O&M and Capital Allocation Factor 100.00%100.00%100.00%100.00%100.00% 5 Proposed Benefits Benchmark Costs to Approve (Ln 3 x Ln 4)644,336$ (232,848)$ 1,839,667$ (2,109,267)$ 267,917$ 409,804$ 6 7 O&M Expense Factor (WP_F-2.3, Ln 2)78.60%78.60%39.63%39.63%11.00% 8 9 Summary of Costs to Approve (1): 10 Total Pension Account Plan 506,464$ 729,006$ 1,235,469$ 11 Total Post-Employment Benefit Plan (183,024)$ (835,840)$ (1,018,864) 12 Total Supplemental Executive Benefit Plan 29,471$ 29,471 13 Total (Ln 10 + Ln 11 + Ln 12)506,464$ (183,024)$ 729,006$ (835,840)$ 29,471$ 246,076$ ATMOS ENERGY CORP., MID-TEX DIVISION MID-TEX RATE REVIEW MECHANISM PENSIONS AND RETIREE MEDICAL BENEFITS FOR CITIES APPROVAL TEST YEAR ENDING DECEMBER 31, 2022 Shared Services Mid-Tex Direct Exhibit B Line No.Current Proposed Amount Percent (b)(c)(d)(e) 1 Rate R @ 43.6 Ccf 2 Customer charge 21.55$ 3 Consumption charge 43.6 CCF X 0.36223$ =15.79 4 Rider GCR Part A 43.6 CCF X 0.63625$ =27.74 5 Rider GCR Part B 43.6 CCF X 0.41732$ =18.20 6 Subtotal 83.28$ 7 Rider FF & Rider TAX 83.28$ X 0.06237 =5.19 8 Total 88.47$ 9 10 Customer charge 22.25$ 11 Consumption charge 43.6 CCF X 0.48567$ =21.18 12 Rider GCR Part A 43.6 CCF X 0.63625$ =27.74 13 Rider GCR Part B 43.6 CCF X 0.41732$ =18.20 14 Subtotal 89.37$ 15 Rider FF & Rider TAX 89.37$ X 0.06237 =5.57 16 Total 94.94$ 6.47$ 7.31% 17 (a) ATMOS ENERGY CORP., MID-TEX DIVISION MID-TEX RATE REVIEW MECHANISM AVERAGE BILL COMPARISON - BASE RATES TEST YEAR ENDING DECEMBER 31, 2022 Change Description Line No.Current Proposed Amount Percent (b)(c)(d)(e)(a) ATMOS ENERGY CORP., MID-TEX DIVISION MID-TEX RATE REVIEW MECHANISM AVERAGE BILL COMPARISON - BASE RATES TEST YEAR ENDING DECEMBER 31, 2022 Change Description 18 Rate C @ 356.6 Ccf 19 Customer charge 63.50$ 20 Consumption charge 356.6 CCF X 0.14137$ =50.41 21 Rider GCR Part A 356.6 CCF X 0.63625$ =226.86 22 Rider GCR Part B 356.6 CCF X 0.30202$ =107.69 23 Subtotal 448.46$ 24 Rider FF & Rider TAX 448.46$ X 0.06237 =27.97 25 Total 476.43$ 26 27 Customer charge 72.00$ 28 Consumption charge 356.6 CCF X 0.18280$ =65.18 29 Rider GCR Part A 356.6 CCF X 0.63625$ =226.86 30 Rider GCR Part B 356.6 CCF X 0.30202$ =107.69 31 Subtotal 471.73$ 32 Rider FF & Rider TAX 471.73$ X 0.06237 =29.42 33 Total 501.15$ 24.72$ 5.19% 34 Exhibit C Line No.Current Proposed Amount Percent (b)(c)(d)(e)(a) ATMOS ENERGY CORP., MID-TEX DIVISION MID-TEX RATE REVIEW MECHANISM AVERAGE BILL COMPARISON - BASE RATES TEST YEAR ENDING DECEMBER 31, 2022 Change Description 35 Rate I @ 1720 MMBTU 36 Customer charge 1,204.50$ 37 Consumption charge 1,500 MMBTU X 0.4939$ =740.85 38 Consumption charge 220 MMBTU X 0.3617$ =79.64 39 Consumption charge 0 MMBTU X 0.0776$ =- 40 Rider GCR Part A 1,720 MMBTU X 6.2134$ =10,688.12 41 Rider GCR Part B 1,720 MMBTU X 0.6267$ =1,078.08 42 Subtotal 13,791.19$ 43 Rider FF & Rider TAX 13,791.19$ X 0.06237 =860.17 44 Total 14,651.36$ 45 46 Customer charge 1,382.00$ 47 Consumption charge 1,500 MMBTU X 0.7484$ =1,122.62 48 Consumption charge 220 MMBTU X 0.5963$ =131.30 49 Consumption charge 0 MMBTU X 0.2693$ =- 50 Rider GCR Part A 1,720 MMBTU X 6.2134$ =10,688.12 51 Rider GCR Part B 1,720 MMBTU X 0.6267$ =1,078.08 52 Subtotal 14,402.12$ 53 Rider FF & Rider TAX 14,402.12$ X 0.06237 =898.28 54 Total 15,300.40$ 649.04$ 4.43% 55 Line No.Current Proposed Amount Percent (b)(c)(d)(e)(a) ATMOS ENERGY CORP., MID-TEX DIVISION MID-TEX RATE REVIEW MECHANISM AVERAGE BILL COMPARISON - BASE RATES TEST YEAR ENDING DECEMBER 31, 2022 Change Description 56 Rate T @ 4720 MMBTU 57 Customer charge 1,204.50$ 58 Consumption charge 1,500 MMBTU X 0.4939$ =740.85 59 Consumption charge 3,220 MMBTU X 0.3617$ =1,164.50 60 Consumption charge 0 MMBTU X 0.0776$ =- 61 Rider GCR Part B 4,720 MMBTU X 0.6267$ =2,957.85 62 Subtotal 6,067.70$ 63 Rider FF & Rider TAX 6,067.70$ X 0.06237 =378.45 64 Total 6,446.15$ 65 66 Customer charge 1,382.00$ 67 Consumption charge 1,500 MMBTU X 0.5684$ =852.60 68 Consumption charge 3,220 MMBTU X 0.4163$ =1,340.29 69 Consumption charge 0 MMBTU X 0.0893$ =- 70 Rider GCR Part B 4,720 MMBTU X 0.6267$ =2,957.85 71 Subtotal 6,532.74$ 72 Rider FF & Rider TAX 6,532.74$ X 0.06237 =407.45 73 Total 6,940.19$ 494.04$ 7.66%