HomeMy WebLinkAboutItem 12 - Atmos EnergyMEMO TO: HONORABLE MAYOR AND MEMBERS OF THE CITY COUNCIL
FROM: BRUNO RUMBELOW, CITY MANAGER
MEETING DATE: MAY 17, 2016
SUBJECT: ATMOS ENERGY SETTLEMENT
RECOMMENDATION:
City Council to consider and ordinance approving a rate settlement with Atmos Energy.
Ic3_T41 e7 Q111,1111
The City, along with other similarly situated cities served by Atmos Energy Corp., Mid -
Tex Division is a member of the Atmos Cities Steering Committee (ACSC). The Rate
Review Mechanism (RRM) tariff was originally adopted by ACSC member cities in 2007
as an alternative to the Gas Reliability Infrastructure Program (GRIP), the statutory
provision that allows Atmos to bypass the City's rate regulatory authority to increase its
rates annually to recover capital investments. The RRM Tariff has been modified several
times, most recently in 2013.
The 2016 RRM filing is the fourth RRM filing under the renewed RRM Tariff. On
March 1, 2016, Atmos made a filing requesting $35.4 million additional revenues on a
system -wide basis. Because the City of Dallas has a separate rate review process,
exclusion of Dallas results in the Company requesting $28.6 million from other
municipalities.
ACSC and the Company have reached an agreement, reflected in the ordinance, to
reduce the Company's request by $5.5 million, such that the ordinance approving new
rates reflects an increase of $29.9 million on a system -wide basis, or $21.9 million for
Mid -Tex Cities, exclusive of the City of Dallas. If the Company had used the GRIP
process rather than the RRM process it would have received a $41 million increase, or
about $11 million more than will be approved by the ordinance.
The tariffs attached to the ordinance approve rates that will increase the Company's
revenues by $29.9 million for the Mid -Tex Rate Division, effective for bills rendered on or
after June 1, 2016. The monthly residential customer charge will be $19.10. The
consumption charge will be $0.11378 per Ccf. The monthly bill impact for the typical
residential customer consuming 46.8 Ccf will be an increase of $1.26, or about 2.43%.
The typical commercial customer will see an increase of $3.81, or 1.43%.
May 11, 2016 (9:59AM)
The ACSC Executive Committee and its designated legal counsel recommend that all
Cities adopt the ordinance with its attachments approving the negotiated rate settlement
resolving the 2016 RRM filing, and implementing the rate change. The alternative to
settlement at the Texas Railroad Commission which has been historically less favorable
for consumers.
Staff and the City Council Utilities Committee recommend approval.
JCH
May 11, 2016 (9:59AM)
i',, �•� i .� ..
iilk
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 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, on March 1, 2016, Atmos Mid -Tex filed its 2016 RRM rate request
with ACSC Cities; and
WHEREAS, ACSC coordinated its review of the Atmos Mid -Tex 2016 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 $29.9 million on a system -wide basis; and
WHEREAS, the attached tariffs 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 RRM Tariff contemplates reimbursement of ACSC's reasonable
expenses associated with RRM applications;
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 deems the adoption of this Ordinance to be in the
best interests of the health, safety, and welfare of the public.
NOW, •' BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY
OF GRAPEVINE, TEXAS:
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 the City Council finds that the settled amount of an increase in
revenues of $29.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 2016 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 the existing rates for natural gas service provided by Atmos Mid -
Tex are unreasonable. The new tariffs attached hereto and incorporated herein as
Attachment "A", are just and reasonable, and are designed to allow Atmos Mid -Tex to
recover annually an additional $29.9 million in revenue over the amount allowed under
currently approved rates, as shown in the Proof of Revenues attached hereto and
incorporated herein as Attachment "B"; such tariffs are hereby adopted.
Section 5. That the ratemaking treatment for pensions and other post -employment
benefits in Atmos Mid-Tex's next RRM filing shall be as set forth on Attachment C,
attached hereto and incorporated herein.
Section 6. That Atmos Mid -Tex shall reimburse the reasonable ratemaking
expenses of the ACSC in processing the Company's 2016 RRM filing.
Ordinance No. 2
Section 7. That to the extent any resolution or ordinance previously adopted by
the Council is inconsistent with this Ordinance, it is hereby repealed.
Section 8. 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 9. 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
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 10. 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 June 1, 2016.
Section 11. 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 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.
0:1 0171.
William D. Tate
Mayor
FTAN 0 9 :601
Tara Brooks
City Secretary
John F. Boyle, Jr.
City Attorney
Ordinance No. 3
2557/26/7087606
Ordinance No.
Attachment A
MID-TEX DIVISION RRC Tariff No:
ATMOS ENERGY CORPORATION
II III
..TE SCHEDULE:
R — RESIDENTIAL SALES
APPLICABLE TO:
I
ALL CUSTOMERS IN THE MID-TEk DIVISION EXCEPT THE CITY OF
DALLAS AND UNINCORPORATED AREAS
III III
EFFECTIVE DATE:
Bills d on or after 06/01/2016
Total Customer Charge
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
$ 19.10 per month
Rider CEE Surcharge
$ 0.02 per month'
Total Customer Charge
$ 19.12 per month
Commodity Charge — All Ccf
$0.11378 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, 2015.
• DIVISION
• • ••- •
Attachment A
RRC Tariff No:
RATE • • E:
COMMERCIAL
I
APPLICABLE TO:
ALL
•A • - • • • OF
• UNINCORPORATED.-
EFFECTIVE DATE: ■Bills
Rendered on or after06/01/2016•.
IIII III
c
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
$ 41.75 per month
Rider CEE Surcharge
$ 0.02 per month'
Total Customer Charge
$ 41.77 per month
Commodity Charge — All Ccf
$ 0.08494 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.
1 Reference Rider CEE - Conservation and Energy Efficiency as approved in GUD 10170. Surcharge billing effective July 1, 2015.
Attachment A
ID-TEX DIVISION RRC Tariff No:
ATMOS ENERGY CORPORATION
SCHEDULE:RATE
Amount
APPLICABLE IIIALL
CUSTOMERS. • OF
DALLAS AND UNINCORPORATED AREAS
EFFECTIVE II IIIA III I TATE: �I L
d on or after 0.
•.
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
$ 738.00 per month
First 0 MMBtu to 1,500 MMBtu
$ 0.3096 per MMBtu
Next 3,500 MMBtu
$ 0.2267 per MMBtu
All MMBtu over 5,000 MMBtu
$ 0.0486 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 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.
MID-TEX DIVISION
Attachment A
RRC Tariff No:
RATE SCHEDULE:
I — INDUSTRIAL SALES
APPLICABLE TO:
ALL CUSTOMERS IN THE MID-TEX DIVISION EXCEPT THE CITY OF
DALLAS AND UNINCORPORATED AREAS
EFFECTIVE DATE:
Bills Rendered on or after 0610112016
�PAGE: 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 ofmeter required by Company.
Attachment A
MID-TEX DIVISION RRC Tariff No:
ATMOS ENERGY CORPORATION
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
APPLICABLE 111IITO:
• • • • •
EFFECTIVE 1ATE:
$ 0.3096 per MMBtu
Next 3,500 MMBtu
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
$ 738.00 per month
First 0 MMBtu to 1,500 MMBtu
$ 0.3096 per MMBtu
Next 3,500 MMBtu
$ 0.2267 per MMBtu
All MMBtu over 5,000 MMBtu
$ 0.0486 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.
Attachment A
M|D'TEX DIVISION RRC Tariff No:
ATMOS ENERGY CORPORATION
RATE SCHEDULE:
T —TRANSPORTATION
APPLICABLE TO:
ALL CUSTOMERS IN THE MID-TEX DIVISION EXCEPT THE CITY OF
DALLAS AND UNINCORPORATED AREAS
EFFECTIVE DATE:
Bills Rendered on or after 06101/2016
A
Curtailment Overpull Fee
Upon notification by Company of on event of curtailment or interruption of Customer's deliveries,
Customer will, for each MK0Btu delivered in excess of the stated |ava| of curtailment or interruption, pay
Company 20096 of the midpoint price for the Katy point |ieh*d in F9mtta Gas Daily published for the
applicable Gam 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
Sen/ice hereunder and the nabae for services provided are subject to the orders ofregulatory 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 ofmeter required by Company.
Attachment A
rDIVISION
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:
WNAFi Ri
(HSFi x (NDD-ADD) )
=
(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 q;i.
Where q;j is the relevant sales quantity for the jth customer in ith rate schedule.
WNA — WEATHER NORMALIZATION
APPLICABLE T
ALL CUSTOMERS IN THE MID-TEX• OF
DALLAS AND UNINCORPORATED AREAS
EFFECTIVE IIII
•
on or after 11/01/2016
�
PAGE: 41
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:
WNAFi Ri
(HSFi x (NDD-ADD) )
=
(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 q;i.
Where q;j is the relevant sales quantity for the jth customer in ith rate schedule.
Attachment A
MID-TEX DIVISION
Flyi, -701#k
Base Use/Heat Use Factors
WNA — WEATHER NORMALIZATION ADJUSTMENT
APPLICABLE TO-
ALL CUSTOMERS IN THE MID-TEX DIVISION EXCEPT THE CITY OF
DALLAS AND UNINCORPORATED -AREAS
1"I"a Mid
:
Base use
Base Use/Heat Use Factors
Weather Normalization Ad)uabnord0W4A>Reoort
On or before June 1 of each year, the company posts on its website at atmoaenergy.00n/mb+vvna. in
Excel format, a Weather Normalization Adjustment /N/NA\ Report to show how the company calculated
ibaVVNAo factor during the preceding winter season. Additiona|k/, on or before June 1 of each year, the
company files one hand copy and an Excel version of the NVVA Report with the Railroad Commission of
Texas' Gas Gen/iooa Division, addressed to the Director ofthat Division.
Residential
Commercial
Base use
Heatmse
Base use
Heat use
Weather Station
Ccf
Cof
Abilene
10.09
0.1392
88.01
0.6440
Austin
11.21
0A551
203.38
0.8564
Dallas
13.72
0.2048
189.83
0.9884
Waco
9.88
0.1411
129.75
0.8685
V0ohdo
11.49
0.1500
122.35
0.5967
Falls
Weather Normalization Ad)uabnord0W4A>Reoort
On or before June 1 of each year, the company posts on its website at atmoaenergy.00n/mb+vvna. in
Excel format, a Weather Normalization Adjustment /N/NA\ Report to show how the company calculated
ibaVVNAo factor during the preceding winter season. Additiona|k/, on or before June 1 of each year, the
company files one hand copy and an Excel version of the NVVA Report with the Railroad Commission of
Texas' Gas Gen/iooa Division, addressed to the Director ofthat Division.
File Date: March 1. 2016
ATMOS ENERGY CORP., MID-TEX DIVISION
PROPOSED TARIFF STRUCTURE (BEFORE RATE CASE EXPENSE RECOVERY)
Current
TEST YEAR ENDING DECEMBER 31, 2015
Revenues
Residential Base Charge
(a)
(b)
(c)
1 Proposed Change In Rates:
Residential Consumption Charge
$ 29,603,205
2 Proposed Change In Rates without Revenue Related Taxes:
$ 27,447,850
3
Commercial Base Charge
$
4
$ 1.81
2,662,423
5
$
0.08020
6
Revenue Requirements
Allocations
7 Residential
$ 338,431,486
77.95%
8 Commercial
84,223,622
19.40%
9 Industrial and Transportation
11,490,316
2.65%
10 Net Revenue Requirements GUD No. 10170
$ 434,145,424
0.2151
11
139,070
I&T Consumption Charge Tier 3 MMBTU
12
0.0461
$ 0.0026
13
7,039,815
I&T Consumption Charge Tier 1 MMBTU
14
$
27,447,850
15
3,215,747
I&T Consumption Charge Tier 2 MMBTU
16
17
1
1
2
2
2
2
2
2
2
2
2
2.
(d) (e) (f)
Schedule A
In 1 divided by factor on WP_F-5.1
Per GUD 10170 Final Order
Per GUD 10170 Final Order
Per GUD 10170 Final Order
With Proportional Increase all classes but Residential and a 40% residential base charge increase:
Current
Prospective
Revenues
Residential Base Charge
$
18.56
$ 0.48 $
8,558,622
Residential Consumption Charge
$
0.09931
$ 0.01540
12,837,933
Commercial Base Charge
$
39.87
$ 1.81
2,662,423
Commercial Consumption Charge
$
0.08020
$ 0.00480
2,662,423
I&T Base Charge
$
697.35
$ 38.03
363,224
I&T Consumption Charge Tier 1 MMBTU
$
0.2937
$ 0.0166
172,167
I&T Consumption Charge Tier 2 MMBTU
$
0.2151
$ 0.0121
139,070
I&T Consumption Charge Tier 3 MMBTU
$
0.0461
$ 0.0026
51,988
7,039,815
I&T Consumption Charge Tier 1 MMBTU
$
$
27,447,850
(g)
Attachment B
Proof of Revenues
(h) (i) Q) (k)
With Customer Charges Rounded Off and residential base charge increase for 2015 limited to $0.50 per RRM tariff:
Proposed
Change In
Proposed
Proposed Change
Revenues
Rates
Proposed Revenues
Residential Base Charge
$
0.52 $
9,335,278
$ 19.08
$ 339,813,673
Residential Consumption Charge
$
0.01447
12,061,297
$ 0.11378
94,839,970
Commercial Base Charge
$
1.83
2,697,162
$ 41.70
61,390,268
Commercial Consumption Charge
$
0.00474
2,626,475
$ 0.08494
47,065,984
I&T Base Charge
$
39.65
378,728
$ 737.00
7,039,815
I&T Consumption Charge Tier 1 MMBTU
$
0.0159
165,150
$ 0.3096
3,215,747
I&T Consumption Charge Tier 2 MMBTU
$
0.0116
132,888
$ 0.2267
2,597,042
I&T Consumption Charge Tier 3 MMBTU
$
0.0025
49,955
$ 0.0486
971,117
$
27,446,933
$ 556,933,616
WP J-5
Page 2 of 4
File Date: March 1, 2016
ATMOS ENERGY CORP., MID-TEX DIVISION
PENSIONS AND RETIREE MEDICAL BENEFITS ADJUSTMENT
TEST YEAR ENDING DECEMBER 31, 2015
Attachment C
WP F-2.3
Page 1 of 2
Shared Services
Mid -Tex Direct
Post-
Post -
Pension
Retirement
Pension
Supplemental
Retirement
Line
Account Plan Medical Plan
Account Plan
Executive Benefit
Medical Plan
Adjustment
No.
Description
"PAP")
("FAS 106")
("PAP"
Plan "SERP"
"FAS 106"
Total
(a)
(b)
(c)
(d)
(e)
(0
(g)
1
Fiscal Year 2016 Towers Watson Report as adjusted (1), (3)
$ 5,101,680 $
2,896,450
$ 7,840,683
$ 150,433
$ 4,466,430
2
O&M Expense Factor (2)
96.41%
96.41%
37.42%
20.77%
37.42%
3
Fiscal Year 2016 Actuarially Determined O&M Benefits (Ln 1 x Ln 2)
$ 4,918,540 $
2,792,473
$ 2,933,599
$ 31,249
$ 1,671,119
4
Allocation to Mid -Tex (2)
40.56%
40.56%
71.52%
100.00%
71.52%
5
Mid -Tex Benefits Expense Included in Rates - Proposed (Ln 3 x Ln 4)
1,995,016 $
1,132,659
$ 2,098,222
$ 31,249
$ 1,195,248
$ 6,452,393
6
Mid -Tex Benefits Expense per GUD 10359 and RRM Test Year Ending
7
December 31, 2014 Benchmark (4)
$ 2,831,859 $
2,013,260
$ 2,925,600
$ 34,809
$ 2,695,721
$ 10,501,250
8
9
Test Year Adjustment (Line 5 minus Line 7)
$ (836,844) $
(880,601)
$ (827,379)
$ (3,561)
$ 1,500,472
( )
$ (4,048,856)
10
11
Adjustment Summary:
12
Account 922
$ (836,844) $
(880,601)
$ -
$ -
$ -
$ (1,717,445)
13
Account 926
(827,379)
(3,561)
(1,500,472)
(2,331,412)
14
Total (Ln 12 plus Ln 13)
$ (836,844) $
(880,601)
$ (827,379) $ (3,561) $
(1,522,472) $ (4,048,856)
15
16
17
Notes:
18
1. Studies not applicable to Mid -Tex or Shared Services are omitted.
19
2. The factors on Lines 2 and 4 are based on the factors in 2016 RRM (Test Year Ending December 31,2015).
20
3. SSU amounts exclude cost centers which do not allocate to Mid -Tex for rate
making purposes.
21
4. GUD No. 10359 is the benchmark for January -May which is the same benchmark as used in the RRM TYE December
31, 2014 for
June -December.
WP F-2.3
Page 1 of 2
ATMOS ENERGY CORP., MID-TEX DIVISION
PENSIONS AND RETIREE MEDICAL BENEFITS FOR CITIES APPROVAL
TEST YEAR ENDING DECEMBER 31, 2015
Line
No. Description
(a)
Fiscal Year 2016 Towers Watson Report (excluding Removed Cost
1 Centers)
2 Allocation to Mid -Tex
FY16 Towers Watson Benefit Costs (excluding Removed Cost
3 Centers) Allocated to MTX (Ln 1 x Ln 2)
4 O&M and Capital Allocation Factor
FY16 Towers Watson Benefit Costs To Approve (excluding
5 Removed Cost Centers) (Ln 3 x Ln 4)
6
7
8 Summary of Costs to Approve:
9
10 Total Pension Account Plan ("PAP")
11 Total Post -Retirement Medical Plan ("FAS 106")
12 Total Supplemental Executive Retirement Plan ("SERP")
13 Total (Ln 10 + Ln 11 + Ln 12)
14
15
16 O&M Expense Factor
17
18 Expense Portion (Ln 13 x Ln 16)
19
20 Capital Factor
21
22 Capital Portion (Ln 13 x Ln 20)
23
24 Total (Ln 18 + Ln 22)
Attachment C
rect
Pension
Post -Retirement
Pension
Supplemental
Post -Retirement
Account Plan
Medical Plan
Account Plan
Executive Benefit
Medical Plan
Adjustment
"PAP"
"FAS 106"
("PAP")
Plan "SERP")
("FAS 106°')
Total
(b)
(c)
(d)
(e)
(f)
(g)
$ 5,101,680
$ 2,896,450
$ 7,840,683
$ 150,433
$ 4,466,430
40.56%
40.56%
71.52%
100.00%
71.52%
$ 2,069,299 $
$ 2,069,299
$ 1,174,833
$ 5,607,955
$ 150,433
$ 3,194,561
100.00%
100.00%
100.00%
100.00%
100.00%
$ 2,069,299
$ 1,174,833
$ 5,607,955
$ 150,433
$ 3,194,561
$ 12,197,081
$ 2,069,299 $ 5,607,955 $ 7,677,254
$ 1,174,833 $ 3,194,561 4,369,394
$ 150,433 150,433
$ 2,069,299 $ 1,174,833 $ 5,607,955 $ 150,433 $ 3,194,561 $ 12,197,081
96.41%
96.41%
37.42%
20.77%
37.42%
$ 1,995,016 $
1,132,659 $
2,098,222 $
31,249 $
1,195,248 $ 6,452,393
3.59%
3.59%
62.58%
79.23%
62.58%
$ 74,283 $
42,174 $
3,509,733 $
119,184 $
1,999,313 $ 5,744,687
$ 2,069,299 $
1,174,833 $
5,607,955 $
150,433 $
3,194,561 $ 12,197,081