Loading...
HomeMy WebLinkAboutORD 2020-049 ORDINANCE NO. 2020-049 AN ORDINANCE OF THE CITY COUNCIL OF THE CITY OF GRAPEVINE, TEXAS, APPROVING A NEGOTIATED SETTLEMENT BETWEEN THE ATMOS CITIES STEERING COMMITTEE ("ACSC") AND ATMOS ENERGY CORP., MID-TEX DIVISION REGARDING THE COMPANY'S 2020 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 ATTACHED EXHIBIT ESTABLISHING A BENCHMARK FOR PENSIONS AND RETIREE MEDICAL BENEFITS; APPROVING AN ATTACHED EXHIBIT REGARDING AMORTIZATION OF REGULATORY LIABILITY; REQUIRING THE COMPANY TO REIMBURSE ACSC'S REASONABLE RATEMAKING EXPENSES; DETERMINlNG THAT THIS ORDINANCE 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 ORDINANCE TO THE COMPANY AND THE ACSC'S LEGAL COUNSEL; DECLARING AN EMERGENCY AND PROVIDING AN EFFECTIVE DATE WHEREAS, the City of Grapevine, 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 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 31, 2020, Atmos Mid-Tex filed its 2020 RRM rate request with ACSC Cities based on a test year ending December 31, 2019; and WHEREAS, ACSC coordinated its review of the Atmos Mid-Tex 2020 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 $90 million applicable to ACSC Cities with an Effective Date of December 1, 2020; 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 two month delayed Effective Date from October 1 to December 1 will save ACSC ratepayers approximately $9 million off new rates imposed by the attached tariffs (Exhibit A), the impact on ratepayers should approximate the reasonable value of the rate filing found by the ACSC Consultants' Report, which was $81 million; and WHEREAS, the attached tariffs "Exhibit A" 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 "Exhibit B"; and WHEREAS, the settlement agreement establishes an amortization schedule for regulatory liability prepared by Atmos Mid-Tex "Exhibit C"; and WHEREAS, the RRM Tariff contemplates reimbursement of ACSC's reasonable expenses associated with RRM applications; and WHEREAS, all constitutional and statutory prerequisites for the approval of this Ordinance have been met, including but not limited to the Open Meetings Act; and WHEREAS, the City Council hereby declares that the approval of this Ordinance is in the best interests of the health, safety, and welfare of the public. NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF GRAPEVINE, TEXAS: Ordinance No. 2020-049 2 Section 1. That all matters stated hereinabove are found to be true and correct and are incorporated herein by reference as if copied in their entirety. Section 2. That the findings set forth in this Ordinance are hereby in all things approved. Section 3. 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$90 million for ACSC Cities 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 2020 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 4. 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 5. That the existing rates for natural gas service provided by Atmos Mid- Tex are unreasonable. The new tariffs attached hereto and incorporated herein as Exhibit A, are just and reasonable, and are designed to allow Atmos Mid-Tex to recover annually an additional $90 million from customers in ACSC Cities, over the amount allowed under currently approved rates. Such tariffs are hereby adopted. Section 6. That the ratemaking treatment for pensions and retiree medical benefits in Atmos Mid-Tex's next RRM filing shall be as set forth on Exhibit B, attached hereto and incorporated herein. Section 7. That subject to any future settlement or decision regarding the balance of Excess Deferred Income Tax to be refunded to ratepayers, the amortization of regulatory liability shall be consistent with the schedule found in Exhibit C, attached hereto and incorporated herein. Section 8. That Atmos Mid-Tex shall reimburse the reasonable ratemaking expenses of the ACSC in processing the Company's 2020 RRM filing. Section 8. That to the extent any resolution or Ordinance previously adopted by the Council is inconsistent with this Ordinance, it is hereby repealed. Section 10. That the meeting at which this Ordinance was approved was in all things conducted in strict compliance with the Texas Open Meetings Act, Texas Government Code, Chapter 551. Section 11. That if any one or more sections or clauses of this Ordinance is adjudged to be unconstitutional or invalid, such judgment shall not affect, impair, or Ordinance No. 2020-049 3 invalidate the remaining provisions of this Ordinance, and the remaining provisions of the Ordinance shall be interpreted as if the offending section or clause never existed. Section 12. That consistent with the City Ordinance that established the RRM process, this Ordinance shall become effective from and after its passage with rates authorized by attached tariffs to be effective for bills rendered on or after December 1, 2020. Section 13. That a copy of this Ordinance 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 Geoffrey Gay, General Counsel to ACSC, at Lloyd Gosselink Rochelle&Townsend, P.C., 816 Congress Avenue, Suite 1900, Austin, Texas 78701. Section 14. That the fact that the present ordinances and regulations of the City of Grapevine, Texas, are inadequate to properly safeguard the health, safety, morals, peace and general welfare of the inhabitants of the City of Grapevine, Texas, creates an emergency for the immediate preservation of the public business, property, health, safety and general welfare of the public which requires that this ordinance shall become effective from and after the date of its final passage, and it is accordingly so ordained. DULY PASSED AND APPROVED BY THE CITY COUNCIL OF THE CITY OF GRAPEVINE, TEXAS, by a vote of 7 to�, on this the 3rd day of November, 2020. APPROVED: William D. Tate Mayor ATTEST: �����t?�PFL�2 ;� i �t� �� �' �� �� �.;,� � m Tara Brooks ��\ A` ��� City Secretary �, �� �`��� APPROVED AS TO FORM: � City Attorney Ordinance No. 2020-049 4 Exhibit A to 2020 RRM Resolution or Ordinance Mid-Tex Tariffs Effective December 1,2020 MID TEX DIVISION RRC Tariff No: ATMOS ENER�3Y CORPORATION RATE.SCHEDUL-E: R—RESIDEPITIAL SALES APPLICABLE TO: ALL CUSTOMERS IN THE MID TEX DIVISION UNDER THE RRM TARIFF EFFECTIVE DATE: Bills Rendered on or after 12/01�2020 PAGE: Appllcation 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, addifional charges and special contract.arrangements between Company and Customer may be required prior to service being furnished. Monthly Rate Customer's morrthly 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 $20.25 per month Rider CEE Surcharge $ 0.05 pe�month' Total Custom�r Charge $20.30 per month Commodity Charge—All Ccf $0.26651 per Ccf Gas.Cost Recovery: Plus an amount for gas costs and upstream Vansportation costs calculated in accordance with Part(a)and.Part(by, 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 accflrdance with Rider FF. Rider FE 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). Agr�emant An Agreement for Gas Service may be required. Notice Senrice hereunder and the. rates for services provided are subject to the orders. of regulatory bodies having jurisdiction and to fhe Company's Tariff for Gas Service. �Reference Rider.CEE-Conservation and Energy Efficiency as approved in GUD 10170. Surcharge billing effective July 1,2020. MID TEX DNISION RRC Tariff No: ATMOS ENERGY CORPORATION RATE SCHEDULE: C-COMMERCIAL SALES APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION UNDER THE RRM TARIFF EFFECTNE DATE: Bil{s Rendered on or after 1210712020 PAGE: 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 desi�ed 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 fumished. 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 $54:50� per month Rider CEE Surcharge $ 0,02 per month' Total Custom�r Charge $54.52 pe�month Commodity Charge—All Ccf $0.11728 per Ccf 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 franohise fees calcufated in accordance with Rider FF, Rlder FF is only applicable to customers inside the corporate limits of any incorporated municipaliry. 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 Agceement for Gas Service may be required. Notic� 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. 'Reference Rider CEE-Conservation and Energy Efficiency as.approved in GUD 10170. Surcharge billing effective July 1,2020. MID TEX DIVISION RRC Tariif No: ATMOS ENERGY CORPORATION RATE SCHEDULE: I—INDUSTRIAL SALES APPLICABLE TO: ALL CUSTOMERS IN THE MID TEX DIVISION UNDER THE RRM TARIFF EFFECTIVE DATE: Bills R�ndorod on or after 12I0112020 PAGE: Application Applicable to lndustrial Custamers witfi a maximum daily usage(MDU)of less than 3,500 MMBtu per day for all naturai gas provided at one Point of Delivery and measured tbrough one meter. Service for Industrial Customers with an MDU �qual to or greater than 3,500 MMBtu per day will be pro�ided at Company's sole option and will requlre special contract arrangements between Company and Customer. Type of Service Where seroice 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 seroice being furnished. Monthly Rate Customer's monthly bill will be calculated by adding the following C.ustomer and MMBtu charges to the amounts due under the riders listed below: Charge_ Amount _ Customer Charge per Meter $1,014.50 per month First 0 MMBtu to 1,500 MMBtu $0.4157 per MMBtu Next 3,500_MMBtu $0.3U44 per MMBtu All MMBtu over 5,000 MMBtu $OA653 pe�MMBtu 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 cafculated in accordance with the applicable rider(s). Curtailment Overpull Fee Upon noffication by Company of an event of curtailment or inte�ruption of Customers deliveries, Customer will, for each MMBtu delivered in eiccess of the stated level of curtailment or interruption, pay Company 200% of the midpoint price for the Katy p.oint listed in Platts Gas Daily published for the applicable Gas Day in the table entitled°Daily Price Suroey." Replacement Index In the event the "midpoinY' o� "common" price for the Katy point listed in Platts Gas Daify 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. MID TEX DNISION RRC Tariff No: ATMOS ENERGY CORPORATION RATE SCHEDULE: I—INDUSTRIAL SALES APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DNISION UNDER THE RRM TARIFF EFFECTIVE DATE: Bills Rendered on or after 12/0112020 PAGEc Agreemant An Agreement for Gas Seroice 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 Condilions In order to receive service under Rate I, Customer must have the typ� of ineter required by Company. Customer must pay Company all costs associated with.the acquisition and instailation of the meter. MID TEX DIVISION RRC Tariff No: ATMOS ENERGY CORPORATION RATE SCHEDULE: T—TRANSPORTATION APPLICABLE TO: ALL CUSTOMERS.IN THE MID TEX DMSION UNDER THE RRM TARIFF EFFECTIVE DATE: Bills Rendered on or aft�r 12101l2020 PAGE: Application Applicable, in the event that Company has entered into a Transportation Agreement, to a customer directiy connected to the Atmos Energy Corp:, Mid-Tex Divisian Distribution System (Customer) for the transportation of ail natural gas supplied by Customer or Customer's agent at one Point of Delivery for use in Customer's facil'ity. Type of Service Where service of the type desired by Customer is nct 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,014.50 per month First 0 MMBtu to 1;500 MMBtu $0.4157 per MMBtu Next 3,500 MMBtu $0.3044 per MMBtu All MMBtu over 5,000 MMBtu $0,0653 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 accoriiance 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 amounf for tax calculated in accordance with Rider TAX. Surcharges: Plus an amount for surcharges calculated in accordance with the applicable rider(s). Imbalanc�Faes , 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 Plaits Gas Dairy in the table entitled °Daily Price Survey" during such month, for the MMBtu of Customer's monthly Cumulative Imbalance,as defined-in the applicable TranspotNation Agreement, at the end of each month that exceeds 10%of Customer's receipt quantities for the month. MID TEX DNISION RRC Tariff No: ATMOS ENERGY CORPORATION RATESCHEDULE: T—TRANSPORTATION APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION UNDER THE RRM.TARIFF EFFECTIVE DATE: Bilfs R�ndored on or after 12/01/2020 PAGE: Curtailmont Overpull Fee Upon notifcation 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°/a of the midpoint price for the Katy point listed in P/afts Gas Daily published for the applicable Gas Day in the table entitled"Daily Price Survey:° Replacement Index In tlie event the "midpoint" or "common" price for the Kary�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 badies having jurisdiction and to the Company's Tariff for.Gas$ervice. Special Conditions In order to receive service under Rate T, customer must have the type of ineter required by Company. Customer must pay Company all costs associated with the acquisition end installation of the meter. MID=TEX DNISION ATMOS EIdERGY CORPORATION RIDER: WNA—WEATHER NORMALIZATION ADJUSTMENT APPLICABLE TO: ALL CUSTOMERS IN THE MID-TEX DIVISION UNDER TNE RRM TARIFF EFFECTIVE DATE: Bills Render�d on or after 12/01I2020 PAGE: Provisions for Adiustment 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 Adiustment The Weather Normalization Adjustment Factor shall be computed to the nearest one-hundredth cent pe�Ccf by the following formuia: (HSF� x (NDD-ADD) ) WNAFi = Ri (BLi + (HSF� x ADD) ) Whe�e i = any,particular Rate Schedule or billing classification within any such particular Rate Schedule that contains more than one billing classification WNAF� = Weather Normalization Adjusiment 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 i�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: WNAi= WNAF� x q�� Where q��is the relevant sales quantity for the jth customer in ith rate schedule. MID TEX DIVISION ATMOS ENERGY CORPORATION RIDER: WNA—WEATHER.NORMALIZATlON ADJUSTMENT APPLICABLE TO: ALL CUSTOMERS IN THE MID TEX DIVISION UNDER THE RRM.TARIFF 6FFECTNE DATE: Bills R�nd�red on or after 12101/2020 PAGE: Base Use/Heat Use Factors Residential_ Commercial Base use Heat use Base use Heat use Weather Station Ccf Ccf/HDD Ccf Ccf/HDD Abilene 10.73 0.1545 94.79 0.7284 Austin 9:53 0.1489 211.76 0:9405 Dallas 15.77 0.1792 199.74� 0.9385 Waco 9:99 0.1341 145.27 0.7110 Wichita 11.61 d.1402 120.34 0.5747 Falis Weather Normalization Adiustment(WNA)Reaort On or before June 1 of each year, the company posts on its website at atmosenergy.com/mtx wna, in Excel format, a Weather IVormalization Adjusfinenf(WNA) Report to show how the.company calculated its WNAs factor during the preceding winter season. Additionaliy, on or before June 1 of each year, the company files one Fiard copy and an Excel version of the WNA Reporf with the Railroad Commission of Texas'Gas Services Division,addressed to the Director of that Division. Exhibit B to 2020 RRM Resolution or Ordinance Mid-Tex 2020 Benchmark for Pensions and Retiree Benefits ATMOS ENERGY CORP.,MID-TEX DIVISION PENSIONS AND RETIREE MEDICAL BENEFITS FOR ClTIES APPROVAL TEST YEAR ENDING DECEMBER 31,2019 Shared Services M'id-Tex Dtrect ost- upplernental Post- Line Pension Employment . Pension Executive Benefit Employment Adjustment No. Desc�i ion Acoount Plan Benefit Plan Account�an Pian Benefit Plan Total (a) @) (�) (d) (8) (� (9) Proposed Benefrts Benchmark-Fiscal Year 2020 Willis Towers 1 lNatson Report as adjusted(1)(2)(3) $ 3,460;135 $ 3,695;384 $ 6;132,704 $ 280,578 S 4,992,449 2 AlloqtlOn t0 Mld-TeX 43.29% 43.29% 76.59% 100.OD% 76.59% Proposed Benef�s Benchmark Costs Allocated.to Mid-Tex(Ln 1 x Ln 3 2) $ 1,497;774 $ 9,599,6fl5 $ 4,697,072 $ 280,578 $ 3,823,744 4 O&M and Capital Allocatlon Factor 100:Q0% 100.00% 100.00% 100.00% 100.00% 5 Prop�sed Benefds Benchmark Costs to Approve(Ln 3.x Ln 4)(3) $ 1,497,774 .$ 1,599,605. $ 4,697,072 $ . . 280,578 .$ 3,823,744 ,$ 11,898,774 6 7 8 Summary of Costs to Approve(1): 9 10 O&M Expense Factor(WP F-2.3,Ln 2) 79.55% 79.559�0 37.83�0 11.67% 37.83% 71 12 13 Total Pension Account Plan $ 1,191,410 $ 1,777,056 $ 2,968,466 14 Total Post-EmploymeM Benefit Plan $ 1,272,412 $ 1,446,647 2,719,060 15 Total Supplemental Executive Benefit Plan $ . 32,754 32,754 16 Total.(Ln 13+�n 14+l.n 15) $ 1,191,410 $ 1,272,412 $ 1,777,056 $ 32,754 $ 1,446,647 $ 5,720,280 17 18 Notes: 19 1.Studies not applicable to Mid-Tex or Shared Services are omitted. 20 2.Mid-Tex is proposing that the Fiscal Year 2020 Willis Towers Watson actuarial amounts shown on WP_F-2.3 and WP_F-2.3.7,be approved 6y the RRM Cities as the 21 benchmark amourtits to be used to calculate.the regulatory asset or liabillry for future periods. The benchmark amouM approved by the RRM Cities for future periods ?2 includes only the expe�ue amaunt. The amount attrfbutable to capital is'recorded to utility plant through the overhead process as described in the CAM. 23 3.SSU amounts exctude cost cer�ters which do not allocate to Mid Tex for rate.making.purposes. _ _ - Exhibit C to 2020 RRM Resolution or Ordinance Mid-Tex 2020 Schedule for Amortization for Regulatory Liability ATMOS ENERGY CORP.,MID-TEX DIVISION RATE BASE ADJUSTMENTS TEST YEAR ENDING DECEMBER 31;2019 AMORTIZATION OF REGULATORY LIABILITY Beginning of Year End of Year Rate Base Rate Base Correated Balanae Line Year Ended Adjustrnent Annual Adjustment for December 31, No. . _ Dec.31 Amount Amortization-(1) Amount(2) 2017(3) (a) (b) (o) (d)� (e} 1 2017 $ - $ 292,268,881 $ 292,268,881 2 2018 292,268,881 12,075,562 280,193,319 3 2019 280,193,319 12;065;165 268,108,955 4 2020 268,108,155 11,171;173 256;936,882 5 2021 256;936.,982 11,171,173 245,765,809 6 2022 245,765,809 11,171,173 234,594,635 7 2023 234,594,635 11,171,173 223,423,462 8 2024 223,423,462 11,171,173 212;252,289 9 2025 212,252,289 11,171,173 201,081,116 10 2026 201,081,118 11,171,173 189,909,943 11 2027 189,909,943 11,171,173 178,738,770 12 2028 178,738,Z7Q 11,171,173 167,567,597 13 2029 167,567;597 11,171,173 156,396,424 1.4 2030 156,396,424 11,1.7'1,173 145,225,25'I 95 2031 145,225,251 11,171,173 134,054,077 16 2032 134,054,077 11,171,173 122,882,904 17 2U33 122,882;904 11,171,173 111,711,731 18 2034 111;711,731 11,171,173 100,540,558 19 2035 100,540,558 11,171,173 89,369,385 20 2036 89,369,985 11,171,173 78,198,212 21 2037 78,198,212 11,1.71,173 67,027,039 22 2038 67,027,039 11,171,173 55,855,866 23 2039 55;855;866 11,171,173 44;684,692 24 2040 44,684,692 11,171,173 33,513,519 25 2041 33,513,519 11,171,173 22,342,346 26 2042 22,342,346 11,171,173 11,171,173 27 2043 11,171,173 11,171,173 (0) 28 29 Revenue Related Tax Factor 7.16% See WP F=5.1 Revenue Related Taxes on Annual Amortization"Tax 30 Amortization $ 799,924 Factor 31 Amortization Including Revenue $ 11,971;097 Amortization-+Taxes 32 33 (Votes: . 34 1.The annual amortization of a 26 year reco�ery period is based on the 35 Reverse South Georgia Method. 36 2.The Regulatory Liability is recorded to FERC Account 253, Sub Account 27909. 37 3.This is the final Mid-Tex liability balance filing the Fiscal Year 2018 tax return.