The URL can be used to link to this page

2018-022 Approving a Netogiated Settlement between the Atmos Cities Steering committee and Atmos Energy Corp. Regardint he Company's 2018 Rate ReviewRESOLUTION NO. 2018-022 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PARIS, TEXAS, APPROVING A NEGOTIATED SETTLEMENT BETWEEN THE ATMOS CITIES STEERING COMMITTEE ("ACSC") AND ATMOS ENERGY CORP., MID-TEX DIVISION REGARDING THE COMPANY'S 2018 RATE REVIEW MECHANISM FILINGS; 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; 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 Paris, 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 and charges 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 new 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 RRM tariff was adopted by the City in a rate ordinance earlier this year; and WHEREAS, on about April 1, 2018, Atmos Mid -Tex filed its 2018 RRM rate request with ACSC Cities based on a test year ending December 31, 2017; and WHEREAS, ACSC coordinated its review of the Atmos Mid -Tex 2018 RRM filing through its Executive Committee, assisted by ACSC's attorneys and consultants, to resolve issues identified in the Company's RRM filing; and 1 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 $24.9 million on a system -wide basis ($17.8 million of which is applicable to ACSC members); 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 Exhibit A rate tariffs incorporate the federal income tax rates that became effective January 1, 2018; 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 (Exhibit C); and WHEREAS, the RRM Tariff contemplates reimbursement of ACSC's reasonable expenses associated with RRM applications; NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF PARIS, TEXAS: Section 1. That the findings set forth in this Resolution are hereby in all things approved. Section 2. That the City Council finds that the settled amount of an increase in revenues of $24.9 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 2018 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 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 $24.9 million in revenue on a system -wide basis over the amount allowed under currently approved rates. Such tariffs are hereby adopted. Section 4. 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 5. That amortization of regulatory liability shall be consistent with the schedule found in attached Exhibit C attached hereto and incorporated herein. 2 Section 6. That Atmos Mid -Tex shall reimburse the reasonable ratemaking expenses of the ACSC in processing the Company's 2018 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 B. 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 October 1, 2018. 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 LJB 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. PASSED AND APPROVED this 10th day of September, 2018. ice Ellis, City Clerk : tevei, : Clifford, M.11, Mayor APPROVED AS TO FORM: SiJpfll' nie H. Harris, City Attorney 3 Rate Tariffs Effective October 1, 2018 EXHIBIT A MID-TEX DIVISION RRC Tariff No: ATMOS ENERGY CORPORATION RATE SCHEDULE R RESIDENTIAL SALES DALLAS AND UNINCORPORATED A APPLICABLE TO:ALL CUSTOMERS IN THE ID-TEX DIVISION EXCEPT THE CITY OF REAS ��......� TE: Bills �....�� w... or after 10/01/2018 PAGE: 12 EFFECTIVE DA. .......... �� Rendered on 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 $ 18.85 per month Rider CEE Surcharge $ 0.03 per month' Total Customer Charge $ 18.88 per month Commodity Charge — All Ccf $0.14846 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 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. 'Reference Rider CEE - Conservation and Energy Efficiency as approved in GUD 10170. Surcharge billing effective July 1, 2018. EXHIIBIT A MID-TEX DIVISION RRC Tariff No: ATMOS ENERGY CORPORATION ........... �....... .._ _� RATE SCHEDULE: C — COMMERCIAL SALES ALLD . THE.....�� ....... ... -- .------ _ ._...., ....-. �. �e.a EFFECTIVE DATE: Bills Rendered on or after 10101/2018 PAGE: 13 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 $ 43.50 per month Rider CEE Surcharge $ (0.03) per month' Total Customer Charge $ 43.47 per month Commodity Charge — All Ccf $ 0.09165 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 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. 'Reference Rider CEE -Conservation and Energy Efficiency as approved in GUD 10170. Surcharge billing effective July 1, 2018. EXHIBIT A Application Applicable to Industrial Customers with a maximum daily usage (MDU) of less than 3,500 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 3,500 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 $ 784.00 per month First 0 MMBtu to 1,500 MMBtu $ 0.3312 per MMBtu Next 3,500 MMBtu $ 0.2425 per MMBtu All MMBtu over 5,000 MMBtu so. 0520 per 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 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 Platfs 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. EXHIBIT A MID-TEX DIVISION RRC Tariff No: ATMOS ENERGY CORPORATION RATE SCHEDULE: I — INDUSTRIAL SALES APPLICABLE TO: EXCEPT THE ALL CUSTOMERS IN THE MID-TEX DIVISION CI.._.. TY OF DALLAS AND UNINCORPORATED AREAS _......_.m .................... P EFFECTIVE DATE: Bills Rendered on or after 1010112018 AGE: 15 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. EXHIBIT A MID-TEX DIVISION RRC Tariff No: ATMOS ENERGY CORPORATION RATE SCHEDULE: I — INDUSTRIAL SALES APPLICABLE DALL ALLAS CUSTOMERS OMAND UNINCORPORATED CITY ..... PPLICABLE TO: ME IN THE MID-TEX DIVISION EXCEPT THE CITY OF AREAS EFFECTIVE DATE Bills Rendered on or after 10/01/2018.... PAGE: 16. .. _.. ,��. ....' Exhibit A The rates were effective for the following Cities on 311512018: ABILENE DENISON KILLEEN ADDISON DENTON KRUM ALBANY DESOTO LAKE WORTH ALLEN DRAPER AKA CORRAL CITY LAKESIDE ALVARADO DUNCANVI LLE LEWISVILLE ANGUS EASTLAND LINCOLN PARK (ANNEXED WITH LITTLE ELM) ANNA EDGECLIFF VILLAGE LITTLE ELM ARGYLE EMORY LORENA ARLINGTON ENNIS MADISONVILLE AUBREY EULESS MALAKOFF AZLE EVERMAN MANSFIELD BEDFORD FAIRVIEW MCKINNEY BELLMEAD FARMERS BRANCH MELISSA BENBROOK FARMERSVILLE MESQUITE BEVERLY HILLS FATE MIDLOTHIAN BLOSSOM FLOWER MOUND MURPHY BLUE RIDGE FOREST HILL NEWARK BOWIE FORNEY NOCONA BOYD FORT WORTH NORTH RICHLAND HILLS BRIDGEPORT FRISCO NORTHLAKE BROWNWOOD FROST OAK LEAF BUFFALO GAINSVILLE OVILLA BURKBURNETT GARLAND PALESTINE BURLESON GARRETT PANTEGO CADDO MILLS GRAND PARAIRIE PARIS CANTON GRAPEVINE PARKER CARROLLTON GUNTER PECAN HILL CEDAR HILL HALTOM CITY PETROLIA CELESTE HARKER HEIGHTS PLANO CELINA HASKELL PONDER CENTERVILLE HASLET POTTSBORO CISCO HEWITT PROSPER CLARKSVILLE HIGHLAND PARK QUITMAN CLEBURNE HIGHLAND VILLAGE RED OAK CLYDE HONEY GROVE RENO (PARKER COUNTY) COLLEGE STATION HURST RHOME COLLEYVILLE IOWA PARK RICHARDSON COLORADO CITY IRVING RICHLAND COMANCHE JUSTIN RICHLAND HILLS COOLIDGE KAUFMAN RIVER OAKS COPPELL KEENE ROANOKE CORINTH KELLER ROBINSON CRANDALL KEMP ROCKWALL CROWLEY KENNEDALE ROSCOE DALWORTHINGTON GARDENS KERRVILLE ROWLETT EXHIBIT A MID-TEX DIVISION RRC Tariff No: ATMOS ENERGY CORPORATION RATE SCHEDULE: I — INDUSTRIAL SALES .� ...—_ ..._.... ... �... _. �__.....ww . APPLICABLE TO ALL CUSTOMERS IN THE MID-TEX DIVISION EXCEPT THE CITY OF DALLAS AND UNINCORPORATED AREAS EFFECTIVE DATE: Bilis Rendered on or after 10/01/2018 PAGE: 17 Cities with Rate Effective 3/15/2018 (Continued) ROYSE CITY SULPHUR SPRINGS WATAUGA SACHSE SWEETWATER WAXAHACHIE SAGINAW TEMPLE WESTLAKE SANSOM PARK TERRELL WESTOVER HILLS SEAGOVILLE THE COLONY WHITE SETTLEMENT SHERMAN TROPHY CLUB WHITESBORO SNYDER TYLER WICHITA FALLS SOUTHLAKE UNIVERSITY PARK WOODWAY SPRINGTOWN VENUS WYLIE STAMFORD VERNON STEPHENVI LLE WACO The rates were effective for the following Cities on 4/01/2018: ABBOTT BRUCEVILLE-EDDY DEPORT ALBA BRYAN DETROIT ALMA BUCKHOLTS DODD CITY ALVORD BUFFALO GAP DOUBLE OAK ANNONA BURNET DUBLIN ANSON BYERS EARLY ARCHER CITY CALDWELL ECTOR ATHENS CALVERT EDOM AURORA CAMERON ELECTRA AUSTIN CAMPBELL EMHOUSE AVERY CARBON EUSTACE BAIRD CASHION COMMUNITY EVANT BALCH SPRINGS CEDAR PARK FAIRFIELD BALLINGER CHANDLER FERRIS BANDERA CHICO FRANKLIN BANGS CHILDRESS FRANKSTON BARDWELL CHILLICOTHE FREDERICKSBURG BARRY CLIFTON GATESVILLE BARTLETT COCKRELL HILL GEORGETOWN BARTONVILLE COLEMAN GLEN ROSE BELLEVUE COLLINSVILLE GLENN HEIGHTS BELLS COMMERCE GODLEY BELTON COMO GOLDTHWAITE BENJAMIN COOPER GOODLOW BERTRAM COPPER CANYON GORDON BLACKWELL COPPERAS COVE GOREE BLANKET CORSICANA GORMAN BLOOMING GROVE COVINGTON GRANBURY BLUE MOUND COYOTE FLATS GRANDVIEW BLUM CRAWFORD GRANGER BOGATA CROSS ROADS GREENVILLE BONHAM CUMBY GROESBECK BREMOND DAWSON GUSTINE BRONTE DECATUR HAMLIN BROWNSBORO DELEON HAMILTON MID-TEX DIVISION RRC Tariff No: ATMOS ENERGY CORPORATION RATE SCHEDULE: I - INDUSTRIAL SALES ALL CUSTOMERS IN THE MID-TEX DIVISIONCI EXCEPT THE .... APPLICABLE TO. TY OF DALLAS AND UNINCORPORATED AREAS EFFECTIVE DATE Bills Rendered on 10/01/2018 PAGE: 18 L . . . .or _ __ _ Cities with Rate Effective 4/0112018 (Continued) HAWLEY MALONE RANGER HEARNE MANOR RAVENNA HEATH MARBLE FALLS RENO (LAMAR COUNTY) HEBRON MARLIN RETREAT HENRIETTA MART RICE HICKORY CREEK MAYPEARL RIESEL HICO MCGREGOR RIO VISTA HILLSBORO MCLENDON-CHISHOLM ROBERT LEE HOLLAND MEGARGEL ROBY HOLLIDAY MERIDIAN ROCHESTER HOWE MERKEL ROCKDALE HUBBARD MEXIA ROGERS HUTCHINS MIDWAY ROSEBUD HUTTO MILES ROSS IMPACT MILFORD ROTAN IREDELL MILLSAP ROUND ROCK ITALY MOBILE CITY ROXTON ITASCA MOODY RULE JEWETT MORAN RUNAWAY BAY JOSEPHINE MORGAN SADLER JOSHUA MUENSTER SAINT JO KERENS MUNDAY SAN ANGELO KNOLLWOOD MURCHISON SAN SABA KNOX CITY NEVADA SANCTUARY KOSSE NEW CHAPEL HILL SANGER KURTEN NEWCASTLE SANTA ANNA LACY-LAKEVI EW NOLANVI LLE SAVOY LADONIA NORMANGEE SCURRY LAKE DALLAS NOVICE SEYMOUR LAKEPORT OAK POINT SHADY SHORES LAMPASAS OAKWOOD SOMERVILLE LANCASTER O'BRIEN CO-OP GIN SOUTH MOUNTAIN LAVON OGLESBY SOUTHMAYD LAWN OLNEY STAR HARBOR LEANDER PALMER STOCKTON BEND LEONA PARADISE STRAWN LEONARD PECAN GAP STREETMAN LEXINGTON PENELOPE SUN VALLEY LINDSAY PFLUGERVILLE SUNNYVALE LIPAN PILOT POINT TALTY LITTLE RIVER ACADEMY PLEASANT VALLEY TAYLOR LLANO POINT TEAGUE LOMETA POST OAK BEND TEHUACANA LONE OAK POWELL THORNDALE LONGVIEW POYNOR THORNTON LORAINE PRINCETON THRALL LOTT PUTNAM THROCKMORTON LUEDERS QUANAH TIOGA MABANK QUINLAN TOCO EXHIBIT A MID-TEX DIVISION RRC Tariff No: ATMOS ENERGY CORPORATION RATE SCHEDULE: I — INDUSTRIAL SALES CUSTOMERSALL IN THE MID-TEX DIVISION EXCEPT THE CITY O APPLICABLE TO: F DALLAS AND UNINCORPORATED AREAS EFFECTIVE DATE ..........Bills ......_ r or after 10/01/2018 PAGE 19 Rendered on I Cities with Rate Effective 4101/2018 (Continued) TOM BEAN VALLEY VIEW WHITNEY TRENT VAN ALSTYNE WILMER TRENTON WALNUT SPRINGS WINDOM TRINIDAD WEINERT WINTERS TROY WEST WIXON VALLEY TUSCOLA WESTWORTH VILLAGE WOLFE CITY TYE WHITEHOUSE WORTHAM VALLEY MILLS WHITEWRIGHT YANTIS EXHIBIT A 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 $ 784.00 per month First 0 MMBtu to 1,500 MMBtu $ 0.3312 per MMBtu Next 3,500 MMBtu $ 0.2425 per MMBtu All MMBtu over 5,000 MMBtu $ 0.0520 per MMBtu ::I 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. EXHIBIT A MID-TEX DIVISION RRC Tariff No: ATMOS ENERGY CORPORATION RATE SCHEDULE: T — TRANSPORTATION APPLICABLE T ALL CUSTOMERS IN THE MID -TE DIVISION DALLASAND UNINCORPORATE X DIVISION EXCEPT THE CITY OF O' D AREAS EFFECTIVE DATE ' Bills Rendered on or after 10!0112018 PAGE. 17 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. EXHIBIT A Exhibit A The rates were effective for the following Cities on 3/15/2018, ABILENE DENISON KILLEEN ADDISON DENTON KRUM ALBANY DESOTO LAKE WORTH ALLEN DRAPER AKA CORRAL CITY LAKESIDE ALVARADO DUNCANVILLE LEWISVILLE ANGUS EASTLAND LINCOLN PARK (ANNEXED WITH LITTLE ELM) ANNA EDGECLIFF VILLAGE LITTLE ELM ARGYLE EMORY LORENA ARLINGTON ENNIS MADISONVILLE AUBREY EULESS MALAKOFF AZLE EVERMAN MANSFIELD BEDFORD FAIRVIEW MCKINNEY BELLMEAD FARMERS BRANCH MELISSA BENBROOK FARMERSVILLE MESQUITE BEVERLY HILLS FATE MIDLOTHIAN BLOSSOM FLOWER MOUND MURPHY BLUE RIDGE FOREST HILL NEWARK BOWIE FORNEY NOCONA BOYD FORT WORTH NORTH RICHLAND HILLS BRIDGEPORT FRISCO NORTHLAKE BROWNWOOD FROST OAK LEAF BUFFALO GAINSVILLE OVILLA BURKBURNETT GARLAND PALESTINE BURLESON GARRETT PANTEGO CADDO MILLS GRAND PARAIRIE PARIS CANTON GRAPEVINE PARKER CARROLLTON GUNTER PECAN HILL CEDAR HILL HALTOM CITY PETROLIA CELESTE HARKER HEIGHTS PLANO CELINA HASKELL PONDER CENTERVILLE HASLET POTTSBORO CISCO HEWITT PROSPER CLARKSVILLE HIGHLAND PARK QUITMAN CLEBURNE HIGHLAND VILLAGE RED OAK CLYDE HONEY GROVE RENO (PARKER COUNTY) COLLEGE STATION HURST RHOME COLLEYVILLE IOWA PARK RICHARDSON COLORADO CITY IRVING RICHLAND COMANCHE JUSTIN RICHLAND HILLS COOLIDGE KAUFMAN RIVER OAKS COPPELL KEENE ROANOKE CORINTH KELLER ROBINSON CRANDALL KEMP ROCKWALL CROWLEY KENNEDALE ROSCOE DALWORTHINGTON GARDENS KERRVILLE ROWLETT EXHIBIT A MID-TEX DIVISION BRUCEVILLE-EDDY RRC Tariff No: ATMOS ENERGY CORPORATION BRYAN DETROIT ALMA BUCKHOLTS RATE SCHEDULE: T - TRANSPORTATION BUFFALO GAP TO: APPLICABLEDALLAS DIVISION EXCEPT THE CITY E OF NTHEMID-UNINCORPORATED BURNET ANDCUSTOMERSALL AREAS _ EFFECTIVE DATE: .. �..._........� Is Rendered on or after ._ 70/01/2018 ARCHER CITY PAGE: 19 mm ....__. Cities with Rate Effective 3/15/2018 (Continued) ATHENS ROYSE CITY SULPHUR SPRINGS WATAUGA SACHSE SWEETWATER WAXAHACHIE SAGINAW TEMPLE WESTLAKE SANSOM PARK TERRELL WESTOVER HILLS SEAGOVILLE THE COLONY WHITE SETTLEMENT SHERMAN TROPHY CLUB WHITESBORO SNYDER TYLER WICHITA FALLS SOUTHLAKE UNIVERSITY PARK WOODWAY SPRINGTOWN VENUS WYLIE STAMFORD VERNON BARRY STEPHENVILLE WACO BARTLETT The rates were effective for the following Cities on 410112018: ABBOTT BRUCEVILLE-EDDY DEPORT ALBA BRYAN DETROIT ALMA BUCKHOLTS DODD CITY ALVORD BUFFALO GAP DOUBLE OAK ANNONA BURNET DUBLIN ANSON BYERS EARLY ARCHER CITY CALDWELL ECTOR ATHENS CALVERT EDOM AURORA CAMERON ELECTRA AUSTIN CAMPBELL EMHOUSE AVERY CARBON EUSTACE BAIRD CASHION COMMUNITY EVANT BALCH SPRINGS CEDAR PARK FAIRFIELD BALLINGER CHANDLER FERRIS BANDERA CHICO FRANKLIN BANGS CHILDRESS FRANKSTON BARDWELL CHILLICOTHE FREDERICKSBURG BARRY CLIFTON GATESVILLE BARTLETT COCKRELL HILL GEORGETOWN BARTONVILLE COLEMAN GLEN ROSE BELLEVUE COLLINSVILLE GLENN HEIGHTS BELLS COMMERCE GODLEY BELTON COMO GOLDTHWAITE BENJAMIN COOPER GOODLOW BERTRAM COPPER CANYON GORDON BLACKWELL COPPERAS COVE GOREE BLANKET CORSICANA GORMAN BLOOMING GROVE COVINGTON GRANBURY BLUE MOUND COYOTE FLATS GRANDVIEW BLUM CRAWFORD GRANGER BOGATA CROSS ROADS GREENVILLE BONHAM CUMBY GROESBECK BREMOND DAWSON GUSTINE BRONTE DECATUR HAMLIN BROWNSBORO DELEON HAMILTON EXHIBIT A MID-TEX DIVISION RRC Tariff No: ATMOS ENERGY CORPORATION RATE SCHEDULE: T — TRANSPORTATION AP..�..... ME ALL TO _DALLAS ....... APPLICABLE TO: MERS IN THE MID-TEX DIVISION EXCEPT THE CITY OF D UNINCORPORATED AREAS ....,. .... �m. EFFECTIVE DATE: Bills Rendered on or after 10/01/20101 8 P —-- AGE: 20 Cities with Rate Effective 4101/2018 (Continued) HAWLEY MALONE RANGER HEARNE MANOR RAVENNA HEATH MARBLE FALLS RENO (LAMAR COUNTY) HEBRON MARLIN RETREAT HENRIETTA MART RICE HICKORY CREEK MAYPEARL RIESEL HICO MCGREGOR RIO VISTA HILLSBORO MCLENDON-CHISHOLM ROBERT LEE HOLLAND MEGARGEL ROBY HOLLIDAY MERIDIAN ROCHESTER HOWE MERKEL ROCKDALE HUBBARD MEXIA ROGERS HUTCHINS MIDWAY ROSEBUD HUTTO MILES ROSS IMPACT MILFORD ROTAN IREDELL MILLSAP ROUND ROCK ITALY MOBILE CITY ROXTON ITASCA MOODY RULE JEWETT MORAN RUNAWAY BAY JOSEPHINE MORGAN SADLER JOSHUA MUENSTER SAINT JO KERENS MUNDAY SAN ANGELO KNOLLWOOD MURCHISON SAN SABA KNOX CITY NEVADA SANCTUARY KOSSE NEW CHAPEL HILL SANGER KURTEN NEWCASTLE SANTA ANNA LACY-LAKEVIEW NOLANVILLE SAVOY LADONIA NORMANGEE SCURRY LAKE DALLAS NOVICE SEYMOUR LAKEPORT OAK POINT SHADY SHORES LAMPASAS OAKWOOD SOMERVILLE LANCASTER O'BRIEN CO-OP GIN SOUTH MOUNTAIN LAVON OGLESBY SOUTHMAYD LAWN OLNEY STAR HARBOR LEANDER PALMER STOCKTON BEND LEONA PARADISE STRAWN LEONARD PECAN GAP STREETMAN LEXINGTON PENELOPE SUN VALLEY LINDSAY PFLUGERVILLE SUNNYVALE LIPAN PILOT POINT TALTY LITTLE RIVER ACADEMY PLEASANT VALLEY TAYLOR LLANO POINT TEAGUE LOMETA POST OAK BEND TEHUACANA LONE OAK POWELL THORNDALE LONGVIEW POYNOR THORNTON LORAINE PRINCETON THRALL LOTT PUTNAM THROCKMORTON LUEDERS QUANAH TIOGA MABANK QUINLAN TOCO EXHIBIT A MID-TEX DIVISION RRC Tariff No: ATMOS ENERGY CORPORATION RATE SCHEDULE: T - TRANSPORTATION [DALLAS AND UN �........ _......_......... APPLICABLE TO:AC dd§f6ii S IN THE MID-TEX DIVISION EXCEPT THE CITY OF INCORPORATED AREAS EFFECTIVE DATE Billsm Rendered on or after 10/01I201µ 1 8 WWYwYmmm PAGE: 2 - --- .. . Cities with Rate Effective 4/01/2018 (Continued) TOM BEAN VALLEY VIEW WHITNEY TRENT VAN ALSTYNE WILMER TRENTON WALNUT SPRINGS WINDOM TRINIDAD WEINERT WINTERS TROY WEST WIXON VALLEY TUSCOLA WESTWORTH VILLAGE WOLFE CITY TYE WHITEHOUSE WORTHAM VALLEY MILLS WHITEWRIGHT YANTIS EXHIBIT A 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: BillsIs Rendered on or aft n. er 11101 w.. PAGE � 12018 1 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. Com utation of Weather Normalization Ad'ustment 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; = WNAFi x qij Where q;j is the relevant sales quantity for the jth customer in ith rate schedule. EXHIBIT A Base Use/Heat Use Factors Weather Normalization AdJustment �W®NA_ Rqe o_rt 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. Residential Commercial Base use Heat use Base use Heat use Weather Station Ccf Ccf/HDD Ccf Ccf/HDD Abilene 9.77 0.1201 99.33 0.5737 Austin 10.38 0.1493 201.46 0.8942 Dallas 13.17 0.2062 183.71 1.0046 Waco 9.26 0.1323 124.57 0.6398 Wichita 11.62 0.1278 114.97 0.5226 Falls Weather Normalization AdJustment �W®NA_ Rqe o_rt 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. Pensions and Retiree Medical Benefits ATMOS ENERGY CORP., MID-TEX DIVISION PENSIONS AND RETIREE MEDICAL BENEFITS FOR CITIES APPROVAL TEST YEAR ENDING DECEMBER 31, 2017 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Summary of Costs to Approve (1): O&M Expense Factor (WP—F-2.3, Ln 2) Total Pension Account Plan Total Post -Employment Benefit Plan Total Supplemental Executive Benefit Plan Total (Ln 13 + Ln 14 + Ln 15) 80.15% 80.15% 40.05% 19.03% 40.05% $ 1,425,108 $ 1,987,133 $ 3,412,241 $ 943,775 $ 1,062,621 2,006,396 $ 35,837 35,837 $ 1,425,108 $ 943,775 $ 1,987,133 $ 35,837 $ 1,062,621 $ 5,454,474 Note: 1. Mid -Tex is proposing that the fiscal year 2018 Willis Towers Watson actuarial amounts shown on WP_F-2.3 and WP_F-2.3.1, be approved by the RRM Cities as the benchmark amounts to be used to calculate the regulatory asset or liability for future periods. The Company is requesting that the benchmark amount approved by the RRM Cities for future periods include only the expense amount. The amount attributable to capital would continue to be recorded to utility plant through the overhead process as described in the CAM. Shared Services Mid -Tex Direct Post- Supptemental Post - Line Pension Employment Pension Executive Benefit Employment Adjustment No. Description Account Plan Benefit Plan Account Plan Plan Benefit Plan Total (a) (b) (c) (d) (e) (I) (g) 1 Fiscal Year 2018 Willis Towers Watson Report, as adjusted $ 4,082,906 $ 2,703,898 $ 6,964,307 $ 188,360 $ 3,724,168 2 Allocation to Mid -Tex 43.55% 43.55% 71.24% 100.00% 71.24% Fiscal Year 2018 Actuarially Determined Benefit Costs (Ln 1 x Ln 2) 3 $ 1,778,092 $ 1,177,539 $ 4,961,241 $ 188,360 $ 2,653,027 4 O&M and Capital Allocation Factor 100.00% 100.00% 100.00% 100.00% 100.00% - Fiscal Year 2018 Willis Towers Watson Benefit Costs To Approve 5 (Excluding Removed Cost Centers) (Ln 3 x Ln 4) $ 1,778,092 $ 1,177,539 $ 4,961,241 $ 188,360 $ 2,653,027 $ 10,758,260 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 Summary of Costs to Approve (1): O&M Expense Factor (WP—F-2.3, Ln 2) Total Pension Account Plan Total Post -Employment Benefit Plan Total Supplemental Executive Benefit Plan Total (Ln 13 + Ln 14 + Ln 15) 80.15% 80.15% 40.05% 19.03% 40.05% $ 1,425,108 $ 1,987,133 $ 3,412,241 $ 943,775 $ 1,062,621 2,006,396 $ 35,837 35,837 $ 1,425,108 $ 943,775 $ 1,987,133 $ 35,837 $ 1,062,621 $ 5,454,474 Note: 1. Mid -Tex is proposing that the fiscal year 2018 Willis Towers Watson actuarial amounts shown on WP_F-2.3 and WP_F-2.3.1, be approved by the RRM Cities as the benchmark amounts to be used to calculate the regulatory asset or liability for future periods. The Company is requesting that the benchmark amount approved by the RRM Cities for future periods include only the expense amount. The amount attributable to capital would continue to be recorded to utility plant through the overhead process as described in the CAM. Exhibit C Amortization of Regulatory Liability ATMOS ENERGY CORP., MID-TEX DIVISION RATE BASE ADJUSTMENTS TEST YEAR ENDING DECEMBER 31, 2017 AMORTIZATION OF REGULATORY LIABILITY Beginning of Year End of Year Rate Base Rate Base Line Year Ended Adjustment Annual Adjustment No. Dec. 31 Amount Amortization (1 Amount (a) (b) (c) (d) 1 2017 $ 289,813,479 2 2018 $ 289,813,479 $ 12,075,562 277,737,918 3 2019 277,737,918 12,075,562 265,662,356 4 2020 265,662,356 12,075,562 253,586,795 5 2021 253,586,795 12,075,562 241,511,233 6 2022 241,511,233 12,075,562 229,435,671 7 2023 229,435,671 12,075,562 217,360,110 8 2024 217,360,110 12,075,562 205,284,548 9 2025 205,284,548 12,075,562 193,208,986 10 2026 193,208,986 12,075,562 181,133,425 11 2027 181,133,425 12,075,562 169,057,863 12 2028 169,057,863 12,075,562 156,982,301 13 2029 156,982,301 12,075,562 144,906,740 14 2030 144,906,740 12,075,562 132,831,178 15 2031 132,831,178 12,075,562 120,755,616 16 2032 120,755,616 12,075,562 108,680,055 17 2033 108,680,055 12,075,562 96,604,493 18 2034 96,604,493 12,075,562 84,528,932 19 2035 84,528,932 12,075,562 72,453,370 20 2036 72,453,370 12,075,562 60,377,808 21 2037 60,377,808 12,075,562 48,302,247 22 2038 48,302,247 12,075,562 36,226,685 23 2039 36,226,685 12,075,562 24,151,123 24 2040 24,151,123 12,075, 562 12, 075, 562 25 2041 12,075,562 12,075,562 (0) 26 27 Note: 28 1. The annual amortization of a 24 year recovery period is has -ed on the 29 Reverse South Georgia Method. Balance as of December 31, 2017 (e) $ 289,813,479 August 24, 2018 MODEL STAFF REPORT BACKGROUND AND SUMMARY The City, along with 171 other Mid -Texas cities served by Atmos Energy Corporation, Mid - Tex Division ("Atmos Mid -Tex" or "Company"), is a member of the Atmos Cities Steering Committee ("ACSC"). 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 an ordinance adopted by ACSC members earlier this year. On or about April 1, 2018, 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, 2017, entitled it to additional system -wide revenues of $42.0 million, Application of the standards set forth in ACSC's RRM Tariff required Atmos to reduce its request to $27.4 million. After review of the consultants' report, the Company offered to settle for a system -wide increase of $25.9 million. Following further negotiations, ACSC's Executive Committee agreed to recommend a system -wide rate increase of $24.9 million. That increase when allocated to ACSC members results in an increase of $17.8 million. The Effective Date for new rates is October 1, 2018. ACSC members should take action approving the Resolution before the end of September. 1 PROOF OF REVENUES Atmos generated proof that the rate tariffs attached to the Resolution will generate $24.9 million in additional revenues on a system -wide basis. That proof is attached as Attachment 1 to this Staff Report. ACSC consultants have agreed that Atmos' Proof of Revenues is accurate. BILL IMPACT Given the fact that ACSC demanded that Atmos reflect reduced federal income taxes in its cost -of -service, as reflected in the RRM Tariff adopted earlier this year, Atmos reduced its rates in March. The rate increase associated with the Resolution is largely offset by the lowered federal income tax rates, such that out-of-pocket expense to consumers should be roughly the same under new rates as what was experienced by consumers last winter. A bill impact comparison is attached as Attachment 2. SUMMARY OF ACSC'S OBJECTION TO THE UTILITIES CODE SECTION 104.301 GRIP PROCESS ACSC strongly opposed the GRIP process because it constitutes piecemeal ratemaking by ignoring declining expenses and increasing revenues while rewarding the Company for increasing capital investment on an annual basis. The GRIP process does not allow any review of the reasonableness of capital investment and does not allow cities to participate in the Railroad Commission's review of annual GRIP filings or allow recovery of Cities' rate case expenses. The Railroad Commission undertakes a mere administrative review of GRIP filings (instead of a full hearing) and rate increases go into effect without any material adjustments. In ACSC's view, the GRIP process unfairly raises customers' rates without any regulatory oversight. In contrast, the RRM process has allowed for a more comprehensive rate review and annual evaluation of expenses and revenues, as well as capital investment. EXPLANATION OF "BE IT ORDAINED" PARAGRAPHS 1. This section approves all findings in the Resolution. 2 2. This section adopts the RRM rate tariffs and finds the adoption of the new rates to be just, reasonable, and in the public interest. 3. This section finds that existing rates are unreasonable. Such finding is a necessary predicate to establishment of new rates. The new tariffs will permit Atmos Mid -Tex to recover an additional $24.9 million on a system -wide basis. Settling Cities will be responsible for $17.8 million of the $24.9 million. 4. This section approves an exhibit that establishes a benchmark for pensions and retiree medical benefits to be used in future rate cases or RRM filings. 5. This section approves an exhibit to be used in future rate cases or RRM filings regarding recovery of regulatory liabilities, such as excess deferred income taxes. 6. This section requires the Company to reimburse the City for expenses associated with review of the RRM filing, settlement discussions, and adoption of the Resolution approving new rate tariffs. 7. This section repeals any resolution or ordinance that is inconsistent with the Resolution. 8. This section finds that the meeting was conducted in compliance with the Texas Open Meetings Act, Texas Government Code, Chapter 551. 9. This section is a savings clause, which provides that if any section is later found to be unconstitutional or invalid, that finding shall not affect, impair, or invalidate the remaining provisions of this Resolution. This section further directs that the remaining provisions of the Resolution are to be interpreted as if the offending section or clause never existed. 10. This section provides for an effective date upon passage. 11. This section directs that a copy of the signed Resolution be sent to a representative of the Company and legal counsel for ACSC. 3 CONCLUSION 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 $42 million in additional system -wide revenues, the RRM settlement at $24.9 million reflects savings of $17.1 million. ACSC's consultants produced a report indicating that Atmos had justified increased revenues of at least $21.7 million. Settlement at $24.9 million is fair and reasonable. The ACSC Executive Committee consisting of city employees of 18 ACSC members urges all ACSC members to pass the Resolution before September 30, 2018. New rates become effective October 1, 2018. 2557/30/7718885 4 Attachment 1 ATMOS ENERGY CORP., MID-TEX DIVISION PROPOSED TARIFF STRUCTURE (BEFORE RATE CASE EXPENSE RECOVERY) TEST YEAR ENDING DECEMBER 31, 2017 Line No. i'a... (b) of ��d. �tek ...._ Sf �...... t*a9 ¢hp �!�.......... .�.d� dk).. 1 Proposed Change In Rates: $ 24,900,000 Schedule A 2 Proposed Change In Rates without Revenue Related Taxes: $ 23,357,466 Ln 1 divided by Tax factor on WP -F-5.1 3 4 5 6 7 Residential 8 Commercial 9 Industrial and Transportation 10 Net Revenue Requirements GUD No. 10170 11 12 13 14 15 116 7 Increase to Customer Classes per GUD 101' 18 Customer Chanes 19 20 Residential Base Charge 21 Residential Consumption Charge 22 Commercial Base Charge 23 Commercial Consumption Charge 24 I&T Base Charge 25 I&T Consumption Charge Tier 1 MMBTU 26 I&T Consumption Charge Tier 2 MMBTU 27 I&T Consumption Charge Tier 3 MMBTU 28 Total 29 Revenue Requirements Allocations $ 338,431,486 77.95% 84,223,622 19.40% 11,490,316 2.65% $ 434,145,424 100.00% Per GUD 10170 Final Order Per GUD 10170 Final Order Per GUD 10170 Final Order al Order: I IlCustomer Charges Rounded Off and residential base charge increase for 2018 limited to $0.60 per RRM tariff Proposed Changeln Proposed Current Prosfrectivme m Revenues Customer Charges_, � ...... � Proposed Change Revenues Rates Proposed Revenues $ 18.35 $ 0.50 $ 9,103,979 Residential Base Charge $ 0.50 $ 9,156,798 $ 18.85 $ 345,211,285 $ 0.13734 $ 0.01118 9,103,979 Residential Consumption Charge $ 0.01112 9,051,844 $ 0.14846 120,848,626 $ 41.95 $ 1.54 2,265,658 Commercial Base Charge $ 1,55 2,278,481 $ 43.50 63,944,478 $ 0.08746 $ 0.00421 2,265,658 Commercial Consumption Charge $ 0.00419 2,253,573 $ 0.09165 49,293,546 $ 752.00 $ 32.12 309,095 I&T Base Charge $ 32.00 307,968 $ 784.00 7,545,216 $ 0.3172 $ 0.0140 144,188 I&T Consumption Charge Tier 1 MMBTU $ 0.0140 144,244 $ 0.3312 3,412,408 $ 0.2322 $ 0.0102 118,338 AT Consumption Charge Tier 2 MMBTU $ 0.0103 118,980 $ 0.2425 2,801,237 $ 0.0498 $ 0.0022 46,570 AT Consumption Charge Tier 3 MMBTU $ 0.0022 46,631 $ 0.0520 1,102,180 WP J-5 Page 2 of 7 Line CURRENT 1 Rate R 45 Ccf 2 Customer charge 3 Consumption charge 4 Rider GCR Part A 5 Rider GCR Part B 6 Subtotal 7 Rider FF & Rider TAX 8 Total 9 10 Customer charge 11 Consumption charge 12 Rider GCR Part A 13 Rider GCR Part B 14 Subtotal 15 Rider FF & Rider TAX 16 Total 17 18 19 Rate C d 346.5 Ccf 20 Customer charge 21 Consumption charge 22 Rider GCR Part A 23 Rider GCR Part B 24 Subtotal 25 Rider FF & Rider TAX 26 Total 27 28 Customer charge 29 Consumption charge 30 Rider GCR Part A 31 Rider GCR Part B 32 Subtotal 33 Rider FF & Rider TAX 34 Total 35 ATMOS ENERGY CORP., MID-TEX DIVISION AVERAGE BILL COMPARISON - BASE RATES TEST YEAR ENDING DECEMBER 31, 2017 CURRENT $ 18.35 45.0 CCF X $ 0.13734 = 6.18 45.0 CCF X $ 0.28533 = 12.84 45.0 CCF X $ 0.30630 = 13.78 $ 51.15 $ 51.15 X 0.06604 = 3.38 $ 54.53 45.0 CCF X $ 0.14846 = 45.0 CCF X $ 0.28533 = 45.0 CCF X $ 0.30630 = $ 52.15 X 0.06604 = 346.5 CCF 346.5 CCF 346.5 CCF $ 247.74 346.5 CCF 346.5 CCF 346.5 CCF $ 250.74 X $ 0.09165 = X $ 0.28533 = X $ 0.22105 = X 0.06604 = Attachment 2 October 1, 2018 PROPOSED CHANGE $ CURRENT $ 41.95 X $ 0.08746 = 30.31 X $ 0.28533 = 98.88 X $ 0.22105 = 76.60 $ 247.74 X 0.06604 = 16.36 $ 264.10 X $ 0.09165 = X $ 0.28533 = X $ 0.22105 = X 0.06604 = Attachment 2 October 1, 2018 PROPOSED CHANGE $ 18.85 6.68 12.84 13.78 $ 52.15 3.44 $ 55.59 $ PROPOSED $ 43.50 31.76 98.88 76.60 $ 250.74 16.56 $ 267.30 $ 1.06 1.94% CHANGE 3.20 1.21% 36 Rate I Ccs 3907 MMBTU 37 Customer charge 38 Consumption charge 39 Consumption charge 40 Consumption charge 41 Rider GCR Part A 42 Rider GCR Part B 43 Subtotal 44 Rider FF & Rider TAX 45 Total 46 = 558.79 47 Customer charge 48 Consumption charge 49 Consumption charge 50 Consumption charge 51 Rider GCR Part A 52 Rider GCR Part B 53 Subtotal 54 Rider FF & Rider TAX 55 Total 56 57 Rate T 3907 MMBTU 58 Customer charge 59 Consumption charge 60 Consumption charge 61 Consumption charge 62 Rider GCR Part B 63 Subtotal 64 Rider FF & Rider TAX 65 Total 66 67 Customer charge 68 Consumption charge 69 Consumption charge 70 Consumption charge 71 Rider GCR Part B 72 Subtotal 73 Rider FF & Rider TAX 74 Total 75 MMBTU Attachment 2 CURRENT PROPOSED CHANGE $ 752.00 1,500 MMBTU X $ 0.3172 = 475.80 2,407 MMBTU X $ 0.2322 = 558.79 0 MMBTU X $ 0.0498 = - 3,907 MMBTU X $ 0.2922 = 1,141.41 3,907 MMBTU X $ 0.4881 = 1,906.68 $ 4,834.68 $ 4,834.68 X 0.06604 = 319.28 $ 5,153.96 $ 784.00 1,500 MMBTU X $ 0.3312 = 496.80 2,407 MMBTU X $ 0.2425 = 583.58 0 MMBTU X $ 0.0520 = _ 3,907 MMBTU X $ 0.2922 = 1,141.41 3,907 MMBTU X $ 0.4881 = 1,906.68 $ 4,912.47324.42 $ 4,912.47 X 0.06604 = 5,236.89 $ 82.93 1.61% CURRENT PROPOSED CHANGE $ 752.00 1,500 MMBTU X $ 0.3172 = 475.80 2,407 MMBTU X $ 0.2322 = 558.79 0 MMBTU X $ 0.0498 = - 3,907 MMBTU X $ 0.4881 = 1,906.68 $ 3,693.27 $ 3,693.27 X 0.06604 = 243.90 $ 3,937.17 $ 784.00 1,500 MMBTU X $ 0.3312 = 496.80 2,407 MMBTU X $ 0.2425 = 583.58 0 MMBTU X $ 0.0520 = _ 3,907 MMBTU X $ 0.4881 = 1,906.68 $ 3,771.06249.04 $ 3,771.06 X 0.06604 = $ 4,020.10 $ 82.93 2.11%