August 7, Ms. Lisa Felice Executive Secretary Michigan Public Service Commission 7109 West Saginaw Highway Lansing, MI 48917

(1)

August 7, 2020

Ms. Lisa Felice

Executive Secretary

Michigan Public Service Commission

7109 West Saginaw Highway

Lansing, MI 48917

RE: In the matter of the Application of DTE Gas Company for a Gas Cost Recovery

Reconciliation proceeding for the 12 months ending March 31, 2019

MPSC Case No: U-20210

Dear Ms. Felice:

Attached for electronic filing in the above referenced matter is DTE Gas Company’s

Revised Exhibits A-14 and A-19 of Witnesses, Timothy J. Krysinski and Larisa Jennings. On

page 4 of Exhibit A-14; line 5; columns h through l; the usage rate for NEXUS should be zero. It

is corrected on the revised exhibit. There is no impact to the GCR filing amounts. The exhibit is

illustrative and is used to highlight the differences between what was in the Plan filing and what

actually occurred in the Reconciliation filing. Actual transportation costs as shown in Exhibit A-

4 row 17, col. C and more specifically Exhibit A-5, col. I-n (inclusive) are derived from actual

transportation invoices from the counterparties (NEXUS in this case) and were correct throughout

the filings. On page 2 of Exhibit A-19, lines 8-13, column 5 changed from 10.1% to 10.0%. Also

attached is the Proof of Service.

Very truly yours,

Lauren D. Donofrio

LDD/erb

Encl.

cc:

Service List

Lauren D. Donofrio (313) 235-4017 lauren.donofrio@dteenergy.com

DTE Gas Company

One Energy Plaza, 1635 WCB Detroit, MI 48226-1279

Lauren D.

Donofrio

Digitally signed by Lauren D. Donofrio

Date: 2020.08.07 17:31:31 -04'00'

(2)

Michigan Public Service Commission Case No.: U-20210

DTE Gas Company Exhibit: A-14 Revised

Applicable Rates of Interstate Pipeline Transporters Witness: T. J. Krysinski

April 2018 to March 2019 Page: 1 of 4

($/Dth)

(a) (b) (c) (d) (e) (f) (g) (h) (i) (j) (k) (l)

Line

No. April May June July August September October November December January February March

ANR Pipeline Company Contracts

Southwest Maximum Fixed Rate ETS Contracts Nos. 108268, 108304

1 Total Reservation Rate $ 9.7320 $ 9.7320 $ 9.7320 $ 9.7320 $ 9.7320 $ 9.7320 $ 9.7320 $ 9.7320 $ 9.7320 $ 9.7320 $ 9.7320 $ 9.7320

2 Total Usage Rate $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229

3 Fuel 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91%

Southwest to Georgetown Maximum Fixed Rate FTS-1 Contract No. 109511

5 Total Usage Rate $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229

6 Fuel 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91%

7 Discounted Detroit to Group 3 ETS Contract 112110

9 Total Usage Rate $ 0.0114 $ 0.0114 $ 0.0114 $ 0.0114 $ 0.0114 $ 0.0114 $ 0.0114 $ 0.0114 $ 0.0114 $ 0.0114 $ 0.0114 $ 0.0114

Fuel 0.81% 0.81% 0.81% 0.81% 0.81% 0.81% 0.81% 0.81% 0.81% 0.81% 0.81% 0.81%

Marshfield to Menominee Maximum Rate FTS-1 Contract No. 122248

11 Total Usage Rate $ 0.0114 $ 0.0114 $ 0.0114 $ 0.0114 $ 0.0114 $ 0.0114 $ 0.0114 $ 0.0114 $ 0.0114 $ 0.0114 $ 0.0114 $ 0.0114

12 Fuel 0.81% 0.81% 0.81% 0.81% 0.81% 0.81% 0.81% 0.81% 0.81% 0.81% 0.81% 0.81%

(3)

($/Dth) (a) (b) (c) (d) (e) (f) (g) (h) (i) (j) (k) (l)

Line

ANR Pipeline Company Contracts

Alliance to Alpena Maximum Rate FTS-1 GCR Contract No. 122065

2 Total Usage Rate $ 0.0114 $ 0.0114 $ 0.0114 $ 0.0114 $ 0.0114 $ 0.0114 $ 0.0114 $ 0.0114 $ 0.0114 $ 0.0114 $ 0.0114 $ 0.0114

3 Fuel 0.81% 0.81% 0.81% 0.81% 0.81% 0.81% 0.81% 0.81% 0.81% 0.81% 0.81% 0.81%

Southwest to Menominee (Winter) and Willow Run (Summer) Maximum Rate FTS-1 Contract No. 122067

5 Total Usage Rate $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229

6 Fuel 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91%

Southwest to Willow Run Maximum Rate FTS-1 Contract No. 122247

8 Total Usage Rate $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229 $ 0.0229

9 Fuel 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91%

Viking Gas Transmission Contract Maximum Rate FT-A Contract AF0081.

11 Total Usage Rate $ 0.0129 $ 0.0129 $ 0.0129 $ 0.0129 $ 0.0129 $ 0.0129 $ 0.0129 $ 0.0129 $ 0.0129 $ 0.0129 $ 0.0129 $ 0.0129

12 Fuel 0.86% 0.86% 0.86% 0.00% 0.00% 0.00% 0.00% 0.27% 0.27% 0.27% 0.27% 0.27%

(4)

($/Dth)

(a) (b) (c) (d) (e) (f) (g) (h) (i) (j) (k) (l)

Line

Great Lakes Gas Transmission Contracts

Maximum Rate Central Zone Contract No. FT4634

2 Total Usage Rate $ 0.0054 $ 0.0054 $ 0.0054 $ 0.0054 $ 0.0054 $ 0.0054 $ 0.0054 $ 0.0054 $ 0.0054 $ 0.0054 $ 0.0054 $ 0.0054

3 Fuel (Rapid River) 0.76% 1.32% 1.62% 1.76% 1.75% 1.13% 0.83% 0.68% 0.68% 0.72% 0.63% 0.18%

4 Fuel (S.S. Marie, Pellston, and Gaylord) 0.96% 1.60% 1.97% 2.16% 2.16% 1.38% 1.00% 0.81% 0.81% 0.87% 0.78% 0.21%

Maximum Rate Eastern Zone Contract No. FT4635

6 Total Usage Rate $ 0.0108 $ 0.0108 $ 0.0108 $ 0.0108 $ 0.0108 $ 0.0108 $ 0.0108 $ 0.0108 $ 0.0108 $ 0.0108 $ 0.0108 $ 0.0108

7 Fuel (Belle River) 1.25% 2.01% 2.50% 2.75% 2.75% 1.75% 1.25% 1.00% 1.00% 1.10% 1.00% 0.25%

Panhandle Eastern Pipe Line Contracts

Field Zone to MichCon Maximum Rate EFT Contract No. 17908 (801 to 900 Miles)

9 Total Usage Rate $ 0.0439 $ 0.0439 $ 0.0439 $ 0.0439 $ 0.0439 $ 0.0439 $ 0.0439 $ 0.0439 $ 0.0439 $ 0.0439 $ 0.0439 $ 0.0439

10 Fuel 4.52% 4.52% 4.52% 4.52% 4.52% 4.52% 4.52% 4.10% 4.10% 4.10% 4.10% 4.10%

Field Zone to Rouge Maximum Rate FT Contract No. 18474

12 Total Usage Rate $ 0.0436 $ 0.0436 $ 0.0436 $ 0.0436 $ 0.0436 $ 0.0436 $ 0.0436 $ 0.0436 $ 0.0436 $ 0.0436 $ 0.0436 $ 0.0436

13 Fuel 4.52% 4.52% 4.52% 4.52% 4.52% 4.52% 4.52% 4.10% 4.10% 4.10% 4.10% 4.10%

(5)

Michigan Consolidated Gas Company Exhibit: A-14 Revised

($/Dth)

(a) (b) (c) (d) (e) (f) (g) (h) (i) (j) (k) (l)

Line

Panhandle Eastern Pipe Line Contracts

Field Zone to MichCon Discount Rate Winter Only FT Contract No. 45114

1 Total Reservation Rate $ 12.9050 $ 12.9050 $ 12.9050 $ 12.9050 $ 12.9050

2 Total Usage Rate $ 0.0436 $ 0.0436 $ 0.0436 $ 0.0436 $ 0.0436

3 Fuel 4.10% 4.10% 4.10% 4.10% 4.10%

NEXUS Gas Transmission, LLC

Meter # N4995 NEXUS Interconnect with TELP Mainline, Clarington, OH to Meter # N1001 Ypsilanti, MI FT-1 Contract 860003

5 Total Usage Rate $ - $ - $ - $ - $

-6 Fuel 1.91% 1.91% 1.91% 1.91% 1.91%

Meter # N2002 NEXUS/Kensington Head of Phase II Ohio to Meter # N1001 Ypsilanti, MI FT-1 Contract 860003

8 Total Usage Rate $ - $ - $ - $ - $

-9 Fuel 1.32% 1.32% 1.32% 1.32% 1.32%

Vector Pipeline Contract

Vector U.S. Discounted FT Contract No. MCG-5676

11 Total Usage Rate $ 0.0013 $ 0.0013 $ 0.0013 $ 0.0013 $ 0.0013 $ 0.0013 $ 0.0013 $ 0.0013 $ 0.0013 $ 0.0013 $ 0.0013 $ 0.0013

12 Fuel 0.28% 0.23% 0.51% 0.49% 0.76% 1.29% 0.69% 0.55% 0.34% 0.24% 0.21% 0.16%

(6)

DTE GAS COMPANY Case No.: U-20210

Reservation Charge Reconciliation For GCC Customers Only

Exhibit: A-19 Revised

Witness: L. Jennings

April 2018 through March 2019 GCR Reconciliation Page: 1 of 4

(a) (b) (c) (d) (e) (f) (g) (h) (i) (j) (k) (l) (m) (n)

Line 12 Months

No. Description April May June July August September October November December January February March Mar 2019

1 GCC Reservation Charge Volume

3 GCC Rate Schedule Sales (Billed) 3,813,886 2,162,422 825,789 643,274 546,456 566,375 965,475 2,664,167 3,657,411 4,698,936 5,023,258 4,637,659 30,205,108 4 Unbilled - Current Month 1,534,691 641,461 522,770 425,662 444,943 508,355 1,228,797 2,060,426 2,670,111 3,251,094 2,745,723 2,336,018 18,370,051 5 - Prior Month (2,114,787) (1,534,691) (641,461) (522,770) (425,662) (444,943) (508,355) (1,228,797) (2,060,426) (2,670,111) (3,251,094) (2,745,723) (18,148,820) 6 Total GCC Sales (Unbilled) 3,233,790 1,269,192 707,098 546,166 565,737 629,787 1,685,917 3,495,796 4,267,096 5,279,919 4,517,887 4,227,954 30,426,339

7 Billed Reservation Charge $0.20 $0.20 $0.20 $0.20 $0.20 $0.20 $0.20 $0.20 $0.20 $0.20 $0.20 $0.20

8 Billed Resv Surch $765,619 $426,962 $165,490 $126,965 $110,757 $112,567 $192,343 $531,255 $731,477 $942,297 $1,003,284 $925,499 $6,034,515 9 Unbilled - Current Month 306,939 128,291 104,556 85,132 88,989 101,670 245,760 412,085 534,022 650,218 549,145 560,644 3,767,451 10 - Prior Month (422,958) (306,939) (128,291) (104,556) (85,132) (88,989) (101,670) (245,760) (412,085) (534,022) (650,218) (549,145) (3,629,765) 11 Total GCC Reservation Charge (Unbilled) 649,600 248,314 141,755 107,541 114,614 125,248 336,433 697,580 853,414 1,058,493 902,211 936,998 6,172,201

12 Prior Period Over (Under) Collection 922,936 922,936

13 Pipeline Reservation Cost (net of credits) 249,532 290,886 148,967 290,678 290,987 290,987 315,187 620,502 642,522 644,656 620,131 641,128 5,046,162 14 Over (Under) Recovery $ 1,323,004 $ (42,572) $ (7,212) $ (183,137) $ (176,373) $ (165,739) $ 21,246 $ 77,078 $ 210,892 $ 413,837 $ 282,080 $ 295,870 $ 2,048,975

(7)

DTE GAS COMPANY

Case No.: U-20210

GCC RESERVATION CHARGE (RC) INTEREST CALCULATION April 2018 through March 2019 GCR Reconciliation

Witness: L. Jennings Page: 2 of 4

Beginning Balance Current Month Current Month Interest

Over/(Under) Over/(Under) Current Month Base For Interest (Revenue)/

Line Month Recovery Recovery Average Interest Accrual Rate Expense

Col. 1 Col. 2 Col. 3 Col. 4 Col. 5 Col. 6 (Col. 2 * 50%) (Col. 1 + Col. 3)

(Col. 4 * Col. 5 * days in month / 365) 1 3/31/18 Balance $ 922,936 2 April $ 922,936 400,068 $ 200,034 $ 1,122,970 10.100% $ 9,322 3 May 1,323,004 (42,572) (21,286) 1,301,719 10.100% 11,166 4 June 1,280,433 (7,212) (3,606) 1,276,827 10.100% 10,599 5 July 1,273,221 (183,137) (91,569) 1,181,652 10.100% 10,136 6 August 1,090,083 (176,373) (88,186) 1,001,897 10.100% 8,594 7 September 913,711 (165,739) (82,869) 830,841 10.100% 6,897 8 October 747,972 21,246 10,623 758,595 10.000% 6,443 9 November 769,218 77,078 38,539 807,757 10.000% 6,639 10 December 846,296 210,892 105,446 951,742 10.000% 8,083 11 January 19 1,057,188 413,837 206,919 1,264,106 10.000% 10,736 12 February 1,471,025 282,080 141,040 1,612,065 10.000% 12,367 13 March 1,753,105 295,870 147,935 1,901,040 10.000% 16,146 14 TOTAL $ 2,048,975 $ 117,129

15 TOTAL OVER (UNDER) RECOVERY PLUS INTEREST $2,166,104

16

Note:

If the beginning balance for any month plus the current month average balance is positive, the interest rate utilized in Column 5 is the allowed rate of return of 10.1%

If the beginning balance plus the current month average balance is negative, the interest rate is the average short term borrowing rate for the current month.

(8)

DTE GAS COMPANY

Case No.: U-20210

GCC RESERVATION CHARGE (RC) ADJUSTMENT CALCULATION

April 2018 through March 2019

Witness: L. Jennings

Page: 3 of 4

Line No. (a) (b) (c) (d) (e)

1 Gas Year April 2018 thru March 2019 True Up GCR GCC Total

2 Total Sales (MCF)-Unbilled volumes 137,892,122 30,426,339 168,318,461

3 Actual Demand $ recovered via SOLR in 2017-2018 $ 43,575,992 $ 6,172,201

4 Net GCR Revenue $ 395,244,740

5 GCC Prior Period Over (Under) Collection $ 922,936

6 Total Dollars charged April 2018 - March 2019 $ 438,820,732 $ 7,095,137

7 Pipeline Reservation Cost (net of credits) $ 39,879,090

8 Discounted Expense Calculation $ 34,832,928 $ 5,046,162 $ 39,879,090

9 Discounted allocation factor of Reservation Cost Volumes 87.35% 12.65% 100.00%

10 GCR Net Recoverable Cost (excluding Prior Year Over/(Under) Recovery $ 453,835,102

11 GCR Prior Year Over/(Under) Recovery (988,070)

(9)

DTE GAS COMPANY Case No.: U-20210

Reservation Charge Reconciliation (True Up) Exhibit: A-19 Revised

For GCC Customers Only Witness: L. Jennings

April 2018 through March 2019 Page: 4 of 4

(a) (b) (c) (d) (e) (f) (g) (h) (i) (j) (k) (l) (m) (n) (o)

Line No. Monthly

Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Total 1 GCC Sales (Unbilled) $ 3,233,790 $ 1,269,192 $ 707,098 $ 546,166 $ 565,737 $ 629,787 $ 1,685,917 $ 3,495,796 $ 4,267,096 $ 5,279,919 $ 4,517,887 $ 4,227,954 $ 30,426,339

2 GCR Sales (Unbilled) 13,930,326 4,036,337 2,775,618 2,025,394 2,344,205 2,471,814 7,688,406 16,336,246 19,008,037 26,171,521 21,372,744 19,731,474 137,892,122

3 Total 17,164,116 5,305,529 3,482,716 2,571,560 2,909,942 3,101,601 9,374,323 19,832,042 23,275,133 31,451,440 25,890,631 23,959,428 168,318,461 4 Pipeline Reservation Cost (net of credits) 1,972,013 2,298,826 1,177,266 2,297,187 2,299,626 2,299,626 2,490,876 4,903,741 5,077,757 5,094,622 4,900,807 5,066,743 39,879,090

5 Pipeline Reservation Cost w/new SOLRGCC 249,532 290,886 148,967 290,678 290,987 290,987 315,187 620,502 642,522 644,656 620,131 641,128 5,046,162 6 Pipeline Reservation Cost w/new SOLRGCR 1,722,481 2,007,940 1,028,299 2,006,509 2,008,639 2,008,639 2,175,689 4,283,239 4,435,235 4,449,966 4,280,676 4,425,615 34,832,928 7 1,972,013 2,298,826 1,177,266 2,297,187 2,299,626 2,299,626 2,490,876 4,903,741 5,077,757 5,094,622 4,900,807 5,066,743 39,879,090

8 Actual Demand $ recovered via RC 649,600 248,314 141,755 107,541 114,614 125,248 336,433 697,580 853,414 1,058,493 902,211 936,998 6,172,201 Carryover

(10)

STATE OF MICHIGAN

BEFORE THE MICHIGAN PUBLIC SERVICE COMMISSION

In the matter of the Application of

)

DTE GAS COMPANY

)

for a Gas Cost Recovery Reconciliation

)

Case No. U-20210

proceeding for the 12 months ending

)

March 31, 2019

)

PROOF OF SERVICE

STATE OF MICHIGAN )

) ss

COUNTY OF WAYNE )

ESTELLA BRANSON, being duly sworn, deposes and says that on the 7

th

_{day of}

August, 2020, a copy of DTE Gas Company’s Revised Exhibits A-14 and A-19 of Witnesses,

Timothy J. Krysinski and Larisa Jennings, was served upon the persons on the attached service list

via email.

.

ESTELLA BRANSON

Subscribed and sworn to before

me this 7

th

_{day of August, 2020.}

Karyn B. Kazyaka, Notary Public

Macomb County, Michigan

My Commission Expires: 7-21-2023

Acting in Wayne County

Estella R.

Branson

Digitally signed by Estella R. Branson Date: 2020.08.07 17:32:06 -04'00'

Karyn B.

Kazyaka

Digitally signed by Karyn B. Kazyaka Date: 2020.08.07 17:32:30 -04'00'

(11)

August 7, Ms. Lisa Felice Executive Secretary Michigan Public Service Commission 7109 West Saginaw Highway Lansing, MI 48917

Full text

August 7, 2020

Ms. Lisa Felice

Executive Secretary

Michigan Public Service Commission

7109 West Saginaw Highway

Lansing, MI 48917

RE: In the matter of the Application of DTE Gas Company for a Gas Cost Recovery

Reconciliation proceeding for the 12 months ending March 31, 2019

MPSC Case No: U-20210

Dear Ms. Felice:

Attached for electronic filing in the above referenced matter is DTE Gas Company’s

Revised Exhibits A-14 and A-19 of Witnesses, Timothy J. Krysinski and Larisa Jennings. On

page 4 of Exhibit A-14; line 5; columns h through l; the usage rate for NEXUS should be zero. It

is corrected on the revised exhibit. There is no impact to the GCR filing amounts. The exhibit is

illustrative and is used to highlight the differences between what was in the Plan filing and what

actually occurred in the Reconciliation filing. Actual transportation costs as shown in Exhibit A-

4 row 17, col. C and more specifically Exhibit A-5, col. I-n (inclusive) are derived from actual

transportation invoices from the counterparties (NEXUS in this case) and were correct throughout

the filings. On page 2 of Exhibit A-19, lines 8-13, column 5 changed from 10.1% to 10.0%. Also

attached is the Proof of Service.

Very truly yours,

Lauren D. Donofrio

LDD/erb

Encl.

cc:

Service List

Lauren D.

Donofrio

DTE GAS COMPANY

DTE GAS COMPANY

GCC RESERVATION CHARGE (RC) ADJUSTMENT CALCULATION

April 2018 through March 2019

STATE OF MICHIGAN

BEFORE THE MICHIGAN PUBLIC SERVICE COMMISSION

In the matter of the Application of

)

DTE GAS COMPANY

)

for a Gas Cost Recovery Reconciliation

)

Case No. U-20210

proceeding for the 12 months ending

)

March 31, 2019

)

PROOF OF SERVICE

STATE OF MICHIGAN )

) ss

COUNTY OF WAYNE )

ESTELLA BRANSON, being duly sworn, deposes and says that on the 7

day of

August, 2020, a copy of DTE Gas Company’s Revised Exhibits A-14 and A-19 of Witnesses,

Timothy J. Krysinski and Larisa Jennings, was served upon the persons on the attached service list

via email.

.

ESTELLA BRANSON

Subscribed and sworn to before

me this 7

day of August, 2020.

Karyn B. Kazyaka, Notary Public

Macomb County, Michigan

My Commission Expires: 7-21-2023

Acting in Wayne County

Estella R.

Branson

Karyn B.

Kazyaka

SERVICE LIST

MPSC CASE NO. U-20210

ADMINISTRATIVE LAW JUDGE

Honorable Sharon Feldman

Administrative Law Judge Section

7109 West Saginaw Hwy, 3rd Floor

Lansing, MI 48917

sfeldman@michigan.gov

ATTORNEY GENERAL (ENRA)

Joel King

G. Mennen Williams Bldg.

_{day of}

_{day of August, 2020.}