computation of purchased gas commodity cost per mc1 · national fuel gas distribution corporation...

NATIONAL FUEL GAS DISTRIBUTION CORPORATION Pennsylvania Division

Computation of Purchased Gas Commodity Cost Per Mc1 On and After August 1, 2013

Computation Year: Twelve Months Ended July 2014

Line No. Description

1 Purchased Gas Commodity Costs = (CC · E) + S

2

3

4

5

6

7

8

9

10

11

12

CC = Commodity Cost of Gas (Exhibit 3)

S = Projected Sales for the Computation Year

(See Exhibit 22)

Unit Commodity Cost (Line 2/ Line 3)

Storage Interest (Exhibit 21 B, Sheet 2)

Total Commodity Cost (Line 4 + Line 5)

E = Experienced Net Overcollection to be Refunded (See Schedule 5 - COMMODITY)

S = Projected Sales for the Computation Year (See Exhibit 22)

Projected SATe' Volumes for Computation Year

Total Volumes for Recovery of Commodity E - Factor (Une 8 + Une 9)

Unit Commodity E-Factor Rate (Line 7/ LIne 10)

Projected Sales Commodity Cost per Met (Line 6 - LIne 11)

PGC Exhibtt 21 Schedule 1 Sheet 1 COMMODITY

89,821 ,650

18,335,882

4.8987

(0.0075)

4.8912

3 ,883,552

18,335,882

o

18,335,882

0.2118

4.6794

Line No.

1

2

3

4

5

6

7

8


Computation of Purchased Gas Demand Cost Per Met On and After August 1, 2013

Computation Year: Twelve Months Ended July 201 4

Description

Purchased Gas Demand Costs = DC + S

DC = Demand Cost of Gas - Natural Gas Supply (Exhibit 3)

Projected Sales for Computation Year (Exhibit 22)

Unit Demand Cost (Line 2/ Line 3)

E = Exp~rienced Net Overcollection to be Refunded (See Schedule 2 - DEMAND - NGS)

S = Projected Sales for the Computation Year (Exhibit 22)

Unit Demand E-Factor Rate (Line 5/ Line 6)

Projected Sales Demand Cost per Met (Line 4 - Line 7)

PGC ExhiM 21 Schedule 1 Sheet 2 DEMAND - NGS

30,398,042

18,335,882

1.6578

1,032,349

18,335,882

0.0563

1.6015

Line No.

1

2

3

4

5

6

7

8

9

10

NATIONAL FUEL GAS DISTRIBUTION CORPORATION

Pennsylvania Division Computation of Purchased Gas Demand Cost Per Met

On and After August 1, 2013

Computation Year: Twelve Months Ended July 2014

Description

Purchased Gas Demand Costs = DC + S

DC = Demand Cost of Gas - Distribution Charge (Exhibit 3)

Projected Sales for Computation Year (Exhibit 22)

Projected SATC Volumes for Computation Year

Total Volumes for Recovery of Demand Costs - Distribution Charge

Unit Demand Cost (Line 2J Line 5)

E = Experienced Net Undercotlection to be Recovered (See Schedule 2 - DEMAND - DC)

Total Volumes for Recovery of Demand Costs - Distribution Charge

Unit Demand E-Factor Rate

Projected Sales Demand Cost per Met (Line 6 - Line 9)

PGC Exhibit 21 Schedule 1 Sheet 3 D EMAND -DC

5 ,424,569

18,335,882

2,385,520

20,721,402

0.2618

(62,998)

20,721,402

(0.0030)

0,2648

Projected Gas Costs Demand Commodity Total Projected Gas Costs

Current Gas Costs (11'12)

Increase (Decrease)


Recovery of Gas Costs Under 2013 1307(~

(1)

Natural Gas Supply Charge

$

1.6578 4.8912 6.5490

6.1100

0.4390

(2)

Gas Adjustment Charge

$

(0.0563) (0.21 18) (0.2681)

(0.7533)

0.4852

(3)

Distribution Charoe

$

0.2648 0.0000 0.2648

0.2712

(0-D064l

(4)

Total Gas Costs

$

1.8663 4.6794 6.5457

5.6279

0.9178

VH.f'" ""0G) ro "" 0 m m -o.m ""ex

'""" ....... 5' ~.

'" -


Statement Showing the Development of Experienced Net Over or (Under) Collections


1 Estimated Overcol1ection of gas cost for the twelve month period 2 August 2012 through July 2013 to be Refunded (Schedule 3)

3 Reconciliation of estimated Undercollection of gas cost for llie 4 twelve month period August 2011 through July 2012 (Schedule 7)

5 Aeconciliation of Undercollection of gas cost balances for the 6 twelve month period August 2010 through July 2011 7 (Schedule 8, Sheet 1)

8 Estimated Undercoliection of gas cost for the 9 twelve month period August 2011 through July 2012 10 to be Refunded for the twelve months ended July 2013 (Schedule 8, Sheet 2)

11 Reconciliation of refund balances for the twelve month period 12 August 2011 • July 2012 (Schedule 9, Sheet 1)

13 Estimated balance of refunds/surcharges for the twelve month period 14 August 2012 - July 2013 (Schedule 9, Sheet 2)

15 Refunds Received and included in PGC 2013 (Schedule 4)

16 Total Amount to be Refunded

PGC Exhibit 21 Schedule 2 DEMAND-NGS

Amount $

1,042,946

o

o

24,106

o

(34,703)

o

1,032,349



Line No, Description

1 Estimated Undercollection of gas cost for the twelve month period 2 August 2012 through July 2013 to be Recovered (Schedule 3)

3 Reconciliation of estimated Undercollection of gas cost for the 4 twelve month period August 2011 through July 2012 (Schedule 7)

5 Reconciliation of estimated Overcollection of gas cost balances for the 6 twelve month period August 2010 through July 2011 7 for the twelve months ended July 2012 ( Schedule 8, Sheet 1)

8 Estimated Undercollection of gas cost for the 9 twelve month period August 2011 through July 2012 10 to be Recovered for the twelve months ended July 2013 (Schedule 8, Sheet 2)

11 Reconciliation of refund balances for the twelve month period 12 August 2011 - July 2012 (Schedule 9, Sheet 1)

13 Estimated balance of refunds/surcharges for the twelve month period 14 August 2012 • July 2013 (Schedule 9, Sheet 2)

15 Total Amount to be Recovered

PGC Exhibit 21 Schedule 2 DEMAND -DC

Amount $

(62,594)

o

o

(10,731)

o

10,327

(62,998)

NATIONAL FUEL GAS DISTRIBUTION CORPORATION PENNSYLVANIA DIVISION

STATEMENT OF TOTAL OVER(UNDER) COLLECTIONS TWELVE MONTHS ENDED JULY 2013

PGC PGC Cost of Over(Under) Interest Interest Interest Sales Rate Revenue Fuel Qollections Rate Weight Amount Md $/Mel $ $ $ % $ (1 ) (2) (3:1x2) (4) (5: 3-4) (6) (7) (8:5x6x7)

2012 August 166,806 1.6891 281 ,752 148,617 1.6656 247,536

Standby/Priority 21 ,514 Standby Overruns 574 LBS - Demand 267 0.9461 253 Overdelivery/Upstream Cap. Surcharge 38,004

315,423 589,633 907,902 (318,269) 8.00% 18 I 12 (38,192)

September 373,499 1.6656 622,100 Standby/Priority 25,789 Standby Overruns 164 LBS - Demand 267 0.9204 246 OverdeliveryNpstream Cap. Surcharge 35,055

373,499 683,354 481,959 201 ,395 8.00% 17 / 12 22,825

October 764,384 1.6656 1,273,158 Standby/Priority 46,772 Standby Overruns 103 LBS - Demand 267 0.9204 246 Overdelivery!Upstream Cap. Surcharge 32,145

764,384 1,352,424 1,818,112 (465,668) 8.00% 16 I 12 (49,673)

November 792,606 1.6656 1,320,165 644,528 1.7032 1,097,760

Standby/Priority 73,652 Standby Overruns 151 o cncn'"U

m:::T°G) LBS - Demand 267 0.9204 246 !1:::mffio Overdelivery/Upstream Cap. Surcharge 32,948 l::-~ m ..... 5..><

1,437,134 2,524,922 4,125,770 (1,600,848) 8.00% 15 I 12 (160,085) '" .. " to)C' Z ~

G) N -en


STATEMENT OF TOTAL OVER{UNDER) COLLECTIONS TWELVE MONTHS ENDED JULY 201 3

PGC PGC Cost of Over(Under) Interest Interest Interest Sales Rate Revenue Fuel QolJections Rate Weight Amount Met $/Met $ $ $ % $ (1 ) (2) (3:1><2) (4) (5:3-4) (6) (7) (8:5<6<7)

December 2,475,257 1.7032 4,215,858 Standby/Priority 76,707 Standby Overruns 379 LBS · Demand 0 0.9384 0 Overdelivery/Upstream Cap. Surcharge 59,877

2,475 ,257 4,352 ,821 5,468,217 (1 ,115,396) 8.00% 14 / 12 (104,104)

2013 January 3,306,873 1.7032 5,632,266 Standby/Priority 85,621 Standby Overruns 0 LBS· Demand 0 0.9384 0 Overdelivery/Upstream Cap. Surcharge

3,306,873 5,775,203 7,091 ,266 (1,316,063) 8.00% 13 / 12 (114,059)

February 3,211 ,390 1.7032 5,469,639 Standby/Priority 71 ,276 Standby Overruns 92 LBS· Demand 0 0.9384 0 Overdelivery/Upstream Cap. Surcharge 38,242

3,211 ,390 5,579,249 6,175,634 (596,385) B.OO% 12 / 12 (47,711)

March 2,B49,104 1.7032 4,852,594 Standby/Priority 69,131 ocncn-u Standby Overruns 192 m::::rnG)

~~::::r() LBS · Demand 0 0.9384 0 »-g,m OverdeliveryNpstream Cap. Surcharge 46 ,787 ZN£)(

0 $~

2,849,104 4,968,704 5,022,088 (53,384) 8.00% 11 / 12 (3,915) (0)0' z ~

G) '" en



PGC PGC Cost of Over(Under) Interest Interest Interest ~ Rate Bevenue Fuel CQllections Rate Weight AmQU!Jt Met $/Met $ $ $ % $ (1 ) (2) (3=1x2) (4) (5=3-4) (6) (7) (8=5x6x7)

April 2,1 10,767 1.7032 3,595,058 StandbylPriority 47,456 Standby Overruns 226 LBS - Demand 0 0.9384 0 OverdeliverylUpstream Cap. Surcharge 38,671

2,1 t o,767 3,681 ,411 1,952 ,889 1,728,522 8.00% 10 I 12 115,235

May 1,156,607 1.7032 1,969,933 Standby/Priority 33.004 Standby Overruns 21 LBS - Demand 0 0.9384 0 Overdelivery/Upstream Cap. Surcharge 38,131

1,156,607 2,041,089 197,146 1,843,943 8.00% 9 / 12 11 0,637

June 554,931 1.7032 945,158 StandbylPriority 20,043 Standby Overruns 458 LBS - Demand 0 0.938.4 0 Overdelivery/Upstream Cap. Surcharge 40,240

554,931 1,005,899 (461 .023) 1,466,922 8.00% 8 / 12 78,236

July 328.132 1.7032 558,874 Standby/Priority 15,970 Standby Overruns 37 LBS - Demand 0 0.938.4 0 OverdeliverylUpstream Cap. Surcharge 28,844 O CllCll -C

m ::YDGl 328,132 603,725 (790.226) 1,393,951 8.00% 7 / 12 65,051 ~ m l ()

» .... a.~ Total 18,883,501 33,158,434 31,989,734 1,168,701

Z(") S, (125,755) 0 m ~

(.,)0' Z '" G> '" -(f)



PGe PGe Cost of Over(Under) Interest Interest Interest Sales Rate Revenue Fuel QolI~ions Rate Weight Amount Met $/Met $ $ $ % $ (1) (2) (3=1><2) (4) (5=3-4) (6) (7) (8=5x6x7)

201 2 August 166,806 0.2896 48,307 148,617 0.2892 42,980

SATe 20,797 0.2896 6,023 SATe 18,611 0.2892 5,382

354,831 102,692 512,384 (409,692) 6.00% 18 I 12 (36,872)

September 373,499 0.2892 108,016 SATC 47,719 0.2892 13,800

421,218 121,816 512,384 (390,566) 6.00% 17 I 12 (33,1 98)

October 764,384 0.2892 221,060 SATe 99,720 0.2892 28,839

864,104 249,899 512,384 (262,485) 6.00% 16 I 12 (20,999)

November 792,606 0.2892 229,222 644,528 0.2902 187,042

SATe 104,910 0.2892 30,340 SATe 81 ,799 0.2902 23,738

1,623,843 470,342 512,384 (42,042) 6.00% 15 I 12 (3,153)

December 2,475,257 0.2902 718,320 SATe 301 ,473 0.2902 87,487

2,n6,730 805,807 512,384 293,423 0.08% 14 I 12 274

Q IJlIJl m"' o

2013 January 3,306,873 0.2902 959,655 ;;::m'" »!!!~

SATe 422.530 0.2902 122,618 z ...... £ 1,082,273 512.384 569,889 0.08% 13 I 0 m

12 494 '" 0

0


STATEMENT OF TOTAL OVER(UNOER) COLLECTIONS TWELVE MONTHS ENDED JULY 2013

PGC PGC Cost of Over(Under) Interest Interest Interest Sales Rate Revenue Fuel Collections Rate Weight Amount Met $/Met $ $ $ % $ (1 ) (2) (3=1x2) (4) (5=3-4) (6) (7) (8=5x6x7)

February 3,21 1,390 0.2902 931,945 SATC 4 10,362 0.2902 119,087

1,051,032 512,384 538,848 0.08% 12 / 12 431

March 2,849,104 0.2902 826,810 SATC 362,934 0.2902

3,212,038 932,133 512,384 419,749 0.08% 11 / 12 308

April 2,110,767 .0.2902 612,545 SATC 269,500 0.2902 78,209

2,380,267 690,754 5 12,384 178,370 0.08% 10 / 12 119

May 1,156.607 0.2902 335,647 SATC 151 .506 0.2902 43.967

1,308,113 379.614 512,384 (132,770) 0.08% 9 / 12 (80)

June 554,931 0.2902 161,041 SATC n,082 0.2902 22,369

632,01 3 183,410 512,384 (328,974) 0.08% 8 / 12 (175)

July 328,132 0.2902 95,224 SATC 48,441 0.2902

512,384 (403,102) 0.08% 7 / 12 (188)

Total 21 ,300,885 6,179,054 6, 148,608 30,446 O(J) (J)

(93,040) m '" 0 ;Oro", >s~ z",C 0 ro

'" 0 0

Refund From

A.

NATIONAL FUEL GAS DISTRIBUTION CORPORATION Pennsytvania Division

Refunds From and Payments to Gas Suppliers

Date Received

Refund Amount

$

Rate

INTEREST

Weight Amount $

o 6.00% o / 12 0

TOTAL o o

Total Refund Plus Interesl

$

o

o

DOl"O mnGl :s::~(') »c. m Z!:.. x OeD=: , ... ~ z ;:;: Gl ~ Ol




1 Estimated Overcollection of gas cost for the twelve month period 2 August 2012 through July 2013 to be Refunded (Schedule 6)

3 Reconciliation of estimated Overcollection of gas cost for the 4 twelve month period August 2011 through July 2012 (Schedule 7)

5 Reconciliation of Overcollection of gas cost for the 6 twelve month period August 2010 through July 2011 7 (Schedule 8, Sheel 1)

8 Reconci1fation of estimated Qvercollection of gas cost for the 9 twelve month period August 2011 through July 2012 10 to be Recovered for the twelve months ended July 2013 (Schedule 8, Sheet 2)

11 Reconciliation of refunds for the twelve month period 12 Augu'l 201 1 . July 2012 (Schedule 9, Sheel 1)

13 Estimated balance of refunds for the twelve month period 14 August 2012 - July 2013 (Schedule 9, Sheet 2)

15 Refunds Received and included in PGC 2013 (Schedule 10)

16 Reconciliation of C-Factor Storage Interest Expense!(lncome) orginating in 17 PGC 2011 for the twelve months ended July 2012 (Schedule 11 , Sheet 1)

18 Actual C-Factor Storage Interest Expense!(lncome) orginating in 19 PGC 2012 for the twelve months ended July 2013 (Schedule 11 , Sheet 2)

PGC Exhibit 21 Schedule 5 COMMODITY

Amount $

3,794,829

o

o

(220,302)

o

(2,438)

o

952

o

20 Reconcilation of Storage Interest refund balance for the period August 2011 - July 2012 21 (recovered)!passed back August 2012 - July 2013 (Schedule 1,1, Sheet 3) 5,244

22 Estimated C-Factor interest expense/(income) originating in PGC 2012 23 for the 12 month period ended July 2013 (Schedule 11 , Sheet 4) 305,267

24 Total Amount to be Refunded 3,883,552

NATIONAL FUEL GAS rnSTRIBUTION CORPORATION PGC Exhibit 21 PENNSYLVANIA DM SION """""'06

STATEMENT OF TOTAL OVER(UNDERI COLLECTlONS COMMODnY TWELVE MONTHS ENDED JULY 2013

PGC PGC eo.. 01 Over(Underl Interest Interest Interest liolIli - Ilm!!lii ElIol Collections - Weight AmouOl Md $lMd $ • $ " $ (1) (2) (3=1)(2) (4) (5_3_4) (6) tn (a,,5x6x7)

2012 August 166,806 3.1213 520,652 148,617 4.0540 602,493

Storage Inventory Reoovery 91,550 Reimbursement of NFGSC Transfer Fee I. Mar1(et Rate Differential 0 City Gale Imbalance 3,147 Sales Cashout 133 NGV 112 4.0674 456 lBS • Commodity 1,213 3.1213 3,786

316,748 1,222,236 1,518,888 (296,652) .. - 18 I 12 (35,598)

September 373,499 4.0540 1,514,165 Storage tnvenlofy Recovery 138,010 Reimbursement of NFGSC Transfef Fee 12 Market Rate Differential 0 City Gate Imbalance 0 Sales cashout 54,630 NGV 99 4.9744 4.2 lBS - Commodity '&'6 4.0540

374,814 1,712,239 1,633,3 17 78,922 •. - 17 12 .,945

Oetober 764,384 4.0540 3,098,813 Storage Inventory Recovery 96,390 Reimbursement 01 NFGSC Transfer Fee 12 Market Rate Differentlal 0 City Gate Imbalance 0 Sales Cashout 6,168 NGV 524 4.9744 2,607 LBS • Commodity 1,884 4.0540 7,638

3,211,628 2,602,424 609,204 ..... I. 12 64,982

November 792,606 4.0540 3,213,225 644,528 4.4305 2,855,581

Storage Inventory Recovery 440,447 Reimbursement of NFGSC Transfer Fee 12 Mme! Rate Differ9fltiaJ 0 City Gate Imbalance 293 Sales Cashout 26,650 Oc.nc.n-o NGV 427 4.9744 2,124 O::roG> LBS - Commodity no 4.0540 3,'22 ~g:~()

1,438,331 6,541,454 9,195,185 (2,653,731) ...... 15 12 (265,373) 3:-o.m O"'s'x o CD =: - "'~ --i ;:::;: -< '" -



PGG PGG Cost of ~ B1!lo Rev~Du~ flIo! Mel $!Mel $ $ (1) (2) (3.1><2) (4)

December 2,475,257 4.4305 10,966,626 NGV 0 5.3691 0 lBS - Commodity 0 4.4305 0

2,475,257 10,966,626 12,109,330

2013 January 3,306,873 4.4305 14,651,101 NGV 0 5.3691 0 LBS - Commodity 0 4.4305 0

3,306,873 14,651 ,101 14,598,663

February 3,211 ,390 4.4305 14,228,063 NGV 0 5.3691 0 LBS - Commodity 0 4.4305 0

3,211,390 14,228,063 13,033 ,744

March 2,849,104 4.4305 12,622,955 NGV 0 5.3691 0 LBS - Commodity 0 4.4305 0

2,849,104 12,622,955 11,224,954

Over(Under) Interest CollectiQ!li B1!lo

$ " (5=3-4) (6)

(1,142,704) 0.08%

52,238 0.06%

1,194,319 0.08%

1,398,001 0.08%

Interest Weight

(7)

14 I 12

13 I 12

12 I 12

11 I 12

Interest ~

$ (8=5x6x7)

(1 ,067)

45

955

1,025

() (JHn"U O::ro(j) s::~~() ~""'a.m Ol\)!:.x o CD:r. - "''' --i ;::+

-< '"

NATIONAL FUEL GAS DISTRIBUTION CORPORATION PENNSYLVANIA DMSION

STATEMENT OF TOTAL OVER(UNOER) COLLECTIONS TWELVE MONTHS ENDED JULY 2013

PGC PGC Cost of - Bl!l< Rfd:ifdnu!i! Ell<! Met $!Met $ $ (1 ) (2) (3;;1x2) (4)

April 2,1 10,761 4.4305 9,351,753 NGV 0 5.3691 0 LBS - Commodity 0 4.4305 0

2,110,767 9,35 1,753 6,510,849

May 1,156,607 4.4305 5,124,347 NGV 0 5.3691 0 LBS - Commodity 0 4.4305 0

1,156,601 5,124,347 3,504,836

June 554,931 4.4305 2,458,622 NGV 0 5.3691 0 l BS - Commodity 0 4.4305 0

554,931 2,458,622 1,826,436

July 328,132 4.4305 1,453,789 NGV 0 5.3691 0 LBS - Commodity 0 4.4305 0

328,132 1,453,789 1,768,130

Total 18,889,746 83,544,813 79,526,955

Over(Uncler) Interest CoIIII£tiQn§, Bl!l<

$ " (5z 3-4) (6)

2,840,904 0._

1,6 19,511 0.08%

632,186 0._

(314,341 ) 0._

4,017,858

Interest Wllight

(7)

10 I 12

9 I 12

• I 12

7 I 12

Interest -$ (8=5x6x7)

1,894

972

337

(147)

(223,029)

OCll Cll 1) O :::r oG) ~~ :::r () ;: - i'l m 0(..)5..>< CI CD 2: - """ -I ;::+

-< '" -


Reconciliation of Interest on Over(Under) Collections Twelve Months Ended July 2012

Estimated Overcollection of gas cost for the twelve month period August 2011 through July 2012 calculated in PGC 2011 (Schedule 7, Pages 2·4)

Net Interest Expense (Income) to be refunded (Schedule 7, Pages 2 · 4)

Total Estimate For the Twelve Months Ended July 2012

Actual Overcoliection of gas cost for the twelve month period August 2011 through July 2012 (Schedule 7, Pages 5 - 7)

Net Interest Expense (Income) to be refunded (SChedule 7, Pages 5 - 7)

Total Actual For the Twelve Months Ended July 2012

PGC Exhibit 21 Schedule 7 Sheet 1 COMMODITY

Amount $

17,101,259

1,325.489

18.426,748

17,101 ,259

1,325.489

18,426,748

o


STATEMENT OF TOTAL OVER(UNDER) COLLECTIONS TWELVE MONTHS ENDED JULY 2012 (ESTIMATE)

PGC PGC Cost of OVer (Under) Interest Interest Interest ~ Rate Rilv!i!n!.!e Fuel CoIl!i!~tiQ[!s Rate W!!9l1! Amount

Mcf $IMcf $ $ $ " $ (I) (2) (3 .. 1x2) (4) (5::3-4) (6) (7) (8=5x6x7)

2011 August 168,974 5.1438 869,168 160,582 5.2854 848,740

Storage Inventory Recovery 162,669 Reimbursement of NFGSC Transfer Fee 15 Market Rate Differential 0 City Gate Imbalance 0 NOV 60 5.9322 356 LBS - Commodity 1,012 5.1438 5,206

330,628 1,886,154 2,072,384 (186,230) 8.00% 18 / 12 (22,348)

September 0 0.0000 0 398,454 5.2854 2,105,989

Storage Inventory Recovery 289,994 Reimbursement of NFGSC Transfer Fee 15 Market Rate Differential 0 City Gate Imbalance 261 NOV 198 6.2578 1,239 LBS - Commodity 2,056 5.2854 10,867

400,708 2,408,365 (4,169,153) 6,sn,518 8.00% 17 / 12 745,452

October 661,444 5.2854 3,495,996 Storage Inventory Recovery 39,091 Reimbursement of NFGSC Transfer Fee 23 Market Aate Differential 0 City Gate Imbalance 23 NOV 604 6.2578 LBS - Commodity 2,731 5.2854

664,779 3,553,347 4,961 ,842 (1 ,408,495) 8.00% 16 / 12 (150,239)

November nl,799 5.2854 4,079,266 622,795 4.5184 2,814,037

Storage Inventory Recovery 37,435 Reimbursement of NFGSC Transfer Fee 23 Market Rate Differential 0 City Gate Imbalance 4,522 NGV 407 6.2578 2,547 ocncn1l LBS - Commodity l z 135 5.2854 51999 O::::ro(j)

1,396,136 6,943,829 7,202,286 (258,457) 8.00% IS / 12 (25,846) s::~~() s::-a.m ON£.x o Q) 2: _ -..0-

-< " -< '" -



December

Sales Mcf (1)

3,866 2,216,714

Storage Inventory Recovery Reimbursement of NFGSC Transfer Fee Market Rale Differential City Gale Imbalance NGV LBS • Commodity

510 628

2,221 ,718

PGC Rate $IMcf

(2)

5.2854 4.5184

PGC Reyenue

$ (3:1x2)

20,433 10,016,001

63,658 1. o

208 5.4137 2,761 4.5184 2,838

10,105,918

201 2 January 3,126,035 4.5184 14,124,6n Storage Inventory Recovery 36, I 43 Reimbursement of NFGSC Transfer Fee 4 Market Rate Differential 0 City Gate Imbalance 22 NGV 448 5.4137 2,425 LBS· Commodity 0 4.5184 0

3 , I 26,483 14,163,271

February 1,473,190 1,523,289

Storage Inventory Recovery Reimbursement of NFGSC Transfer Fee Market Rate Dlfferenlial City Gate Imbalance NGV 582 LBS • Commodity 0

2,997,061

4.5184 3.6215

6,656,462 5,516,591

5,470 4 o o

5.4137 3,151 4 .5184 0

12,181,678

March 2,371 ,740 3.6215 8,589,256 1. 4 o o

Storage Inventory Recovery Reimbursement of NFGSC Transfer Fee Market Rate Differential City Gale Imbalance NGV LBS • Commodity

664 4.5158 2,998 -;;-r;;;""",O~ 3.6215 0

2,372 ,404 8,592,277

Cost of Fuel

$ (4)

12,047,756

13,335,092

11,309,597

6,150,208

Over(Under) Collections

$ (5.3-4)

(1,941 ,838)

828,179

872,081

2,442,069

Interest Rate

" (6)

Interest

~

(7)

8.00% 14 I 12

8.00% 13 f 12

8.00% 12 I 12

8.00% 11 I 12

Interest Amount

$ (8:5x6x7)

{181 ,238)

71 ,776

69,766

179,085

() (f.) Cf.)"'O O :::ToG) ~m~() ~""'o. m O(,,)!:.x Om:!. _ -<C"

~ ~



PGC PGC Cost of Over(Under) Interest Interest Interest - BlIlo B!i!vfj:n!.!!i! flOO QQII!i!!<IiQOli BlIlo Weight iIllli>l!nl Me! $lMe! $ $ $ " $ (I) (2) (3=1x2) (4) (5z 3-4) (6) (7) (8=5x6x7)

April 1,715,596 3.6215 6,213,031 Storage Inventory Recovery 0 Reimbursement of NFGSC Transfer Fee 0 Market Rate Differential 0 City Gate Imbalance 0 NGV 690 4.5158 3,116 LBS • Commodity 276 3.6215 1.000

1,716,562 6 ,217,1 47 (127,615) 6 ,344,762 8.00% 10 f 12 422,984

May 626,645 3.6215 2,269,395 439,890 3.1213 1,373,029

Storage Inventory Recovery 7,217 Reimbursement of NFGSC Transfer Fee 19 Market Rate Differential 0 City Gate Imbalance 0 NGV 666 4.5158 3,008 LBS • Commodity 167 3.6215 605

1,067,368 3,653,273 1,102,292 2,550,981 8.00% 9 f 12 153,059

June 436,089 3.1213 1,361 ,165 Storage Inventory Recovery 35,720 Reimbursement of NFGSC Transfer Fee I S Market Rate Differential 0 City Gate Imbalance 300 NGV 58. 4.0674 2,375 LBS • Commodity 415 3.1213 1,295

437,088 1,400,870 909.969 490,901 •. 00% • f 12 26,181

July 303,794 3.1213 948,232 Storage Inventory Recovery 40,499 Reimbursement of NFGSC Transfer Fee 27 Market Rate Differential 0 City Gate Imbalance 626 Sales Cash out 6,089 NGV 278 4.0674 1,131 LBS - Commodity 969 3.1213 3,025

305,041 999,629 209,841 789,788 8.00% 7 f 12 36,857 ()oocn -o O::::ToG)

Total 17,035,976 72,105,758 55,004,499 17,101 ,259 1,325,489 s::g:~O s::-a.W o""'s. a (J):!: =i --Jg -< '" -


STATEMENT OF TOTAL OVER (UNDER) COLLECTIONS TWELVE MONTHS ENDED JULY 2012 (ACTUAL)

PGC PGC Cost of Over(Under) Interest Interest Interest Sales Rate Re~n!.!!il - CollectlQ[!s Rate ~ Am2Y!l1 Met $IMet $ $ $ " $ (t) (2) (3=1x2) (4) (5=3-4) (6) (7) (8:5x6x7)

2011 August 168,974 5.1438 869,168 160,582 5.2854 848,740

Storage Inventory Recovery 162,669 Reimbursement of NFGSC Transfer Fee t5 Market Rate Differential 0 City Gate Imbalance 0 NGV 60 5.9322 356 LBS - Commodity ' 1°'2 5.1438 51206

330,628 1,886,154 2,072,384 (186,230) 8.00% 16 I 12 (22,348)

September 0 0.0000 0 398,454 5.2854 2,105,989

Storage Inventory Recovery 289,994 Reimbursement of NFGSC Transfer Fee 15 Market Rate Differential 0 City Gate Imbalance 261 NGV 196 6.2578 1,239 lBS • Commodity 21°56 5.2854 101867

400,708 2,408,365 (4,169,153) 6,5n,518 6.""" 17 I 12 745,452

October 661,444 5.2854 3,495,996 Storage Inventory Recovery 39,091 Reimbursement of NFGSC Transfer Fee 23 Market Rate Differential 0 City Gate Imbalance 23 NGV 604 6.2578 3,760 LBS - Commodity 21731 5.2854 141434

664,m 3,553,347 4,961,842 (1,408,495) 8.00% 16 I 12 (150,239)

November 771,799 5.2654 4,079,266 622,795 4.5184 2,814,037

Storage Inventory Recovery 37,435 Reimbursement of NFGSC Transfer Fee 23 Markel Rate Differential 0 City Gate Imbalance 4,522 NGV 407 6.2578 2,547 0(/)(/)1) lBS - Commodity 1,135 5.2854 5,999 O~(')G)

1,396,136 6,943,829 7,202,286 (258,457) 8.00% 15 I 12 (25,846) s:~[() 5:Ulc: m o -x o CD =. - ...,,, -I ;:+ -< '"


STATEMENT OF TOTAL OVER(UNDER) COLLECTIONS TWELVE MONTHS ENDED JULY 2012 (ACTUAL)

PGC PGC Cost of Over(Under) Interest Interest Interest Sales Rate Rev!i!nue Fuel CoIl!i!!t.liQns Rate ~ Amount Mol $/Mct $ $ $ " $ (') (2) (3:'><2) (4) (5: 3-4) (6) (7) (8:5x6xn

December 3,866 5.2854 20,433 2,216,714 4.5184 10,016,001

Storage Inventory Recovery 63,658 Reimbursement of NFGSC Transfer Fee ,. Market Rate Differential 0 City Gate Imbalance 208 NGV 5'0 5.4137 2,761 LBS • Commodity 828 4.5184 21838

2,221 ,718 10,105,918 12,047,756 (1,941,838) 8.00% '4 / '2 (181,238)

2012 January 3,126,035 4.5184 14,1 24,6n Storage Inventory Recovery 36,143 Reimbursement of NFGSC Transfer Fee 4 Market Rate Differential 0 City Gate Imbalance 22 NGV 448 5.4137 2,425 LBS • Commodity 0 4.5184 0

3,126,483 14,163,271 13,335,092 828,179 8.00% 13 / 12 71 ,n6

February 1,473,190 4.5184 6,656,462 1,523,289 3.6215 5,516,591

Storage Inventory Recovery 5,470 Reimbursement of NFGSC Transfer Fee 4 Market Rate Differential 0 City Gate Imbalance 0 NGV 5B2 5.4137 3,151 LBS • Commodity 0 4.5184 0

2,997,061 12,181 ,678 11,309,597 872,081 8.00% 12/ '2 69,766

March 2,371 ,740 3.6215 8,589,256 Storage Inventory Recovery

,. Reimbursement of NFGSC Transfer Fee 4 Market Aate Differential 0 City Gate Imbalance 0 NGV 664 4.5158 2,998 ClC/lC/l 1l LBS • Commodity 0 3.6215 0 O:::roG') ""0 2,372,404 8,592,2n 6,150,208 2,442,069 8.00% " / 12 179,085 ;:"i'i

3:;;;c~ a (ii'::r o - -=i -..Jg -< ~ -



PGC PGC Coot of Over(Under) Interest Interest Interest - - R!!~ou§: EJIO! Collectionll; - Weight IIml!lml Mol $lMoI $ $ $ " $ (1) (2) (3."x2) (4) (5::3-4) (6) (7) (8:5XSX7)

April 1,715,596 3.6215 6,213,031 Storage Inventory Recovery 0 Reimbursement of NFGSC Transfer Fee 0 Markel Rate Differential 0 City Gate Imbalance 0 NGV 690 4.5158 3,116 lBS - Commodity 276 3.6215 1,000

1,716,562 6,217,147 (127,615) 6,344,762 B.OO% 10 I 12 422.984

May 626,645 3.6215 2,269,395 439.890 3.1213 1,373,029

Storage Invenlory Recovery 7,217 ReimbulSen'lent of NFGSC Transfer Fee I. Market Rate Differential 0 City Gate Imbalance 0 NGV 666 4.5158 3,006 LBS - Commodity 167 3.6215 605

1,067,368 3.653.273 1.102,292 2,550,981 8.00% • I 12 153,059

Jone 436,089 3.1213 1,361,165 Storage tnventory Recovery 35.720 Reimbursement of NFGSC Transfer Fee 15 Markel Rate Differential 0 City Gate Imbalance 300 NGV 584 4.0674 2,375 lBS - Commodity 415 3.1213 1,295

437.088 1,400,870 909,969 490,901 B.OO% 8 I 12 26,181

July 303,794 3 .1213 948,232 Storage Inventory Recovery 40,499 Reimbursement of NFG$C Transfer Fee 27 Market Rate Differential 0 City Gate Imbalance 626 Sales cashout 6,089 NGV 278 4.0674 1,131 lBS - Commodity 969 3.1213 3,025

305,041 999,629 209,841 789,788 8.00% 7 I 12 36,857 ()(JJ(JJ 1J O=r°Q

Total 17,035.976 72.105.758 55,004,499 17,101 ,259 1,325,489 ~milo ~:::; g. m o _x o (D ~ - -.0' --I ~.

-< '"



Estimated Undercollection of gas cost for the twelve month period August 2011

PGC Exhibit 21 Schedule 7 Sheet 1 DEMAND· NGS

Amount $

through July 2012 calculated in PGC·2012 (Schedule 7, Pages 2·4) (4,676,738)

Net Interest Income to be collected (Schedule 7, Pages 2 . 4) (530,626)

Total Estimate For the Twelve Months Ended July 2012 (5,207,364)

Actual Undercollection of gas cost for the twelve month period August 2011 through July 2012 (Schedule 7, Pages 5·7) (4,676,738)

Net Interest Income to be collected (Schedule 7, Pages 5 . 7) (530,626)

Total Actual For the Twelve Months Ended July 2012 (5,207,364)

o

2011 August

Standby/Priority Standby Overruns LBS · Demand



PGG Sales Rate Mcf $/Mcf (1) (2)

168,974 1.4307 160,582 1.7711

0 0.7884

PGG Revenue

$ (3.1><2)

241 ,751 284,407

25,191 358

0

Cost of -$ (4)

Over(Under) Collections

$ (5.3-4)

Overdelivery!Upstream Cap. Surcharge 32,782 329,556 584,489 1,922,751 (1,338,262)

September 0 398,454 1.7711 705,702

Standby/priority 30,359 Standby Overruns 88 LBS· Demand 0 0.9724 0 Overdelivery/Upstream Cap. Surcharge 27,994

398,454 764,143 1,046,731 (282,588)

October 661,444 1.7711 1,171,483 Standby/priority 54,918 Standby Overruns (210) LBS · Demand 0 0.9724 0 Overdelivery/Upstream Cap. Surcharge 31 ,610

661 ,444 1,257,801 1,969,107 (71 1,306)

November 771 ,799 1.7711 1,366,933 622,795 1.6082 1,001,579

Standby/priority 65,787

Standby Overruns 49 LBS · Demand 0 0.9724 0 Overdelivery!Upstream Cap. Surcharge

1,394 ,594 3,563,470 (1,093,889)

Interest !lruo.

" (6)

Interest Weight

(7)

8.00% 18 I 12

8.00% 17 I 12

8.00% 16 I 12

8.00% 15 I 12

Interest Amount

$ (8=5x6x7)

(160,591)

(32,027)

(75,873)

(109,389)

o cncn'U m::rOG) 3:g:ffio "-"-m zNC>c o (D'::r

-....Ie' z Gl (JJ

~

'" -

NATIONAL FUEL GAS DISTRIBUTION CORPORATION PENNSYLVANIA OIVISION


PGC PGC Cost of Sates Rate Reven!.:!i Fuel Mel $/Mel $ $ (1 ) (2) (3=1)(2) (4)

December 3,866 1.n11 6,847 2,216,714 1.6082 3,564,919

Standby/Priority 87 ,514 Standby Overruns 2,397 LBS - Demand 0 0.8953 0 Overdelivery/Upstream Cap. Surcharge 44,739

2,220,580 3,706,416 5,016,826

2012 January 3,126,035 1.6082 5,027,289 Standby/priority 103,529 Standby Overruns 604 lBS - Demand 0 0.8953 0 Overdetivery/Upstream Cap. Surcharge 43,714

3,126,035 5,175,136 6,307,089

February 1,473,190 1.6082 2,369,184 1,523,289 1.5993 2,436,196

Standby/Priority 93,768 Standby Overruns 5,378 LBS - Demand 0 0.8953 0 Overdelivery/Upstream Cap. Surcharge 43,119

2,996,479 4,947,645 5,907,837

March 2,371,740 1.5993 3,793,124 Standby/Priority 67,878 Standby Overruns 1,281 LBS - Demand 0 0.8943 0 Overdelivery/Upstream Gap. Surcharge 51 ,247

2,371,740 3,913,530 3,991,385

Over(Under) Interest Interest CoIJ~tiorls Rate ~

$ % (5:3-4) (6) (7)

(1 ,310,410) 8.00% 14 I 12

(1 ,131,953) 8.00% 13 I 12

(960,192) 8.00% 12 / 12

(n,855) 8.00% 11 / 12

Interest Amount

$ (8=5x6x7)

(122,305)

(98,103)

(76,815)

(5,709)

O(n(n""O m:T°(j) ~g:~() » ...... O"m zc:.>5.x o <> ~

-...0' z Gl (f)

~

'" -


STATEMENT OF TOTAL OVER(UNDER} COLLECTIONS TWELVE MONTHS ENDED JULY 2012 (ESTIMATE)

PGC PGC Cost of Over(Under) Interest Interest Interest ~ Rate Revenu§: Eldo! CoII~ti2ns Rate Weight Amount Mcf $/Mcf $ $ $ % $ (1) (2) (3:1><2) (4) (5: 3-4) (6) (7) (8=5x6x7)

April 1,715,596 1.5993 2,743,753 Standby/priority 63,600 Standby Overruns 50 LBS - Demand 267 0.8943 23. Overdelivery/Upstream Gap. Surcharge 51 1223

1,715,596 2,858,865 1,071 ,962 1,786,903 8.00% 10 f 12 119,127

May 626,645 1.5993 1,002,193 439,890 1.6891 743,018

Standby/priority 35,125 Standby Overruns 12 LBS· Demand 267 0.8943 23. Overdelivery/Upstream cap. Surcharge

1,066,535 1,819,933 921 ,756 898,177 8.00% • f 12 53,891

June 436,089 1.6891 736,598 Standby/priority 24,411 Standby Overruns 11 lBS· Demand 0 0.9461 0 Overdelivery/Upstream Gap. Surcharge 37,774

436,089 798,794 1,036,014 (237,220) 8.00% 8 f 12 (12,652)

July 303,794 1.6891 513,138 Standby/Priority 20,216 Standby Overruns 15 lBS - Demand 267 0.9461 253 Overdelivery/Upstream Gap_ Surcharge 32.633

303,794 566,255 784,399 (218,144) 8.00% 7 f 12 (10,180)

Total 17,020,896 28,862,588 33,539,325 (4,676,738) (530,626)

0(1)(1) '"C m::TcG) s::m::T() ):> ...... !lm Z.A~x o CD 2:

"cr Z ~

Q '" -(IJ



PGC PGC Cost of Over(Under) Interest Inlerest Interest Sales Rate R~enue Fuel ColiectiQ[!s ~ Weight Amount Mel $,Mel $ $ $ % $ (1 ) (2) (3=1><2) (4) (5=3-4) (6) (7) (8=5x6x7)

2011 August 168,974 1.4307 241 ,751 160,582 1.7711 284,407

Standby/Priority 25,191 Standby Overruns 358 LBS + Demand 0 0.7884 0 Overdelivery/Upstream Cap. Surcharge 32,782

329,556 584,489 1,922,751 (1,338,262) 8.00% 18 / 12 (160,591)

September 0 0

398,454 1.7711 705,702 Standby/priority 30,359 Standby Overruns 88 LBS· Demand 0 0.9724 0 Overdelivery/Upstream Cap. Surcharge 27z994

398,454 764,143 1,046,731 (282,588) 8.00% 17 / 12 (32,027)

October 661,444 1.7711 1,171,483 Sfandby/priority 54,918 Standby Overruns (210) LBS · Demand 0 0.9724 0 Overdelivery/Upstream Cap. Surcharge 31,610

661,444 1,257,801 1,969,100 (711 ,305) 8 .00% 16 I 12 (75,873)

November 771,799 1.771 1 1,366,933 622,795 1.6082 1,001,579

Standby/Priority 65,787 Standby Overruns 49 LBS · Demand 0 0.9724 0 OverdeHvery/Upstream Cap. Surcharge 35z233

1,394,594 2,469,581 3,563,470 (1,093,889) 8.00% 15 I 12 (109,389)

o cncn "U m~ nG)

s::*~() :> ...... c.. m ZO'I£x o (II:!:

"" Z ~

G> '" '"



= PGG l&llif Qver(Under) Interest Interest Interest Sales Rate Revenue Fuel Collections Rate Weight Amount Mcf $/Mcf $ $ $ % $ (1) (2) (3=1><2) (4) (5=3-4) (6) (7) (B. 5x6x7)

December 3,866 1.7711 6,847 2 ,216,714 1.6082 3 ,564,919

Standby/priority 87,514 Standby Overruns 2 ,397 lBS - Demand 0 0.8953 0 Overdelivery/Upstream Cap. Surcharge 44,739

2,220,580 3,706,416 5,016,827 (1 ,31 0 ,41 1) 8.00% 14 / 12 (122,305)

201 2 January 3,126,035 1.6082 5,027,289 Standby/priority 103,529 Standby Overruns 604 LBS - Demand 0 0.8953 0 Overdelivery/Upstream Cap. Surcharge 43,714

3 ,126,035 5,175,136 6,307,090 (1,131,954) 8.00% 13 / 12 (98.103)

February 1,473,190 1.6082 2 ,369,184 1,523,289 1.5993 2,436,196

Standby/Priority 93,768 Standby Overruns 5,378 LBS - Demand 0 0.8953 0 Overdelivery/Upstream Cap. Surcharge 43,11 9

2 ,996,479 4,947,645 5,907,837 (960.192) 8 .00% 12 / 12 (76,815)

March 2,371,740 1.5993 3 ,793,124 Standby/Priority 67,878 Standby Overruns 1,281 LBS - Demand 0 0.8943 0 Overdelivery/Upstream Cap. Surcharge 51,247

2,371,740 3 ,913,530 3,991,385 (77 ,B55) 8.00% 11 f 12 (5,709)

o men'll rn::r o G) s::<tI~(') :>Sa. m zC»£x 0 ~~

..... fr z ~

Gl '" -en



PGC PGC Cost of Over(Under) Interest Interest Interest Sal .. Rate Revenue Fuel Collections Rate Weight Amount

Mcf $!Mcf $ $ $ % $ (1 ) (2) (3:1 ><2) (4) (5: 3-4) (6) (7) (8",5x6x7)

April 1,71 5,596 1.5993 2,743,753 Standby/priority 63,SOO Standby Overruns 50 LBS - Demand 267 0.8943 239 OverdeliveryJUpstream Gap. Surcharge 51 t223

1,715,596 2 ,858,865 1,071 ,962 1,786,903 8.00% 10 / 12 119,127

May 626,645 1.5993 1,002,193 439,890 1.6891 743,018

Standby/Priority 35,125 Standby Overruns 12 LBS - Demand 267 0 .8943 239 Overdelivery/Upstream Cap. Surcharge 39,346

1,066,535 1,819,933 921,756 898,177 8.00% 9 I 12 53,891

June 436,089 1.6891 736,598 Standby/Priority 24,411 Standby OV9111Jns 11 LBS - Demand 0 0.9461 0 Overdetivery/Upstream Cap. Surcharge 37,774

436,089 798,794 1,036,014 (237,220) 8 .00% 8 I 12 (12,652)

July 303,794 1.6891 513,138 Standby/Priority 20,216 Standby Overruns 15 LBS - Demand 267 0 .9461 253 Overdelivery/Upstream Cap. Surcharge 32,633

303,794 566,255 784,399 (218,144) 8 .00% 7 I 12 (10 ,180)

Total 17,020,896 28,862,588 33,539,325 (4,676,738) (530 ,626) 0 00 00-0 m::r oG) s::~ffiC"l :>-a.m Z -.I£')( 0 m~

-.., ~ Z -G> '" (j)

NATIONAL FUEL GAS OISTRIBUTION CORPORATION Pennsylvania Division


Estimated Undercollection of gas cost for the twelve month period August 2011 through July 2012 calculated in PGC 2012 (Schedule 7, Pages 2 . 3)

Net Interest Expense to be refunded (Schedule 7, Pages 2 . 3)

Total Estimate For the Twelve Months Ended July 2012

Actual Overcollection of gas cost for the twelve month period August 2011 through July 2012 (Schedule 7, Pages 4·5)

Net Interest Expense to be refunded (Schedule 7, Pages 4·5)

Total Actual For the Twelve Months Ended July 2012

Amount to be Refunded

PGC Exhibit 21 Schedule 7 Sheet 1 DEMAND · DC

Amount $

(966,490)

(64,648)

(1 ,031,138)

(966,490)

(64,648)

(1,031,138)

o



PGC PGC Cost of Over(Under) Interest Interest Interest Sales Rate Rmn!,!e - QQllection§ Rate ~ Amount Mo' $lMoI $ $ $ " $ (1) (2) (3_1x2) (4) (5:3-4) (6) (7) (8;;5x6x7)

2011 August 168,974 0.2276 38,458 160,582 0.2627 42,185

SATC 17,739 0.2276 4,037 SATe 15,982 0.2627 4,198

363,2n 88,878 466,888 (378,010) 6._ 1. / 12 (34,021)

September 0 0.2276 0

398,454 0.2627 104,674 SATC 0 0.2276 0 SATe 39,109 0.2627

----437,563 114,948 466,888 (351,940) 6.00% 17 / 12 (29,915)

October 661,444 0.2627 173,761 SATC 72,218 0.2627 18,972

733,662 192,733 521,142 (328,409) 6._ 16 / 12 (26,273)

November nl ,799 0.2627 202,752 622,795 0.2643 164,605

SATe 86,124 0.2627 22,625 SATC 67,957 0.2643 17,961

1,548,675 407,943 521,142 (113,199) 6._ 15 / 12 (8,490)

December 3,866 0.2627 1,016 2,216,714 0.2643 585,878

SATC 401 0.2627 lOS SATe 245,331 0.2643 64,841

651,840 521,144 130,696 6.00% 14 / 12 9,149

2012 January 3,126,035 0.2643 826,211 SATe 348,200 0.2643 92,029

o c.nc.n "U m :::roG)

3,474,235 918,240 521,080 397,160 6._ 13 I 12 25,815 s:::m~o ;t> ..... Q. m Z l\) ~ x a m ~

-.I e' a '" '" 0 -



PGC PGC Cost of Over(Ullder) Interest Interest Interest Sales Rate Revenue Fuel ColiectiQQ§ Rate ~ Amount Met $/Met $ $ $ % $ (1 ) (2) (3=1x2) (4) (5=3·4) (6) (7) (8=5x6x7)

February 1,473,190 0.2643 389,364 1,523,289 0.2711 412,964

SATC 165,774 0.2643 43,814 SATC 170,475 0.271 1 461216

3,332,728 892,358 521 ,669 370,689 6.00% 12 I 12 22,241

March 2,371,740 0.2711 642,979 SATC 2661741 0.2711 721313

2,638,481 715,292 521,669 193,623 6.00% 11 I 12 10,649

April 1,715,596 0.2711 465,098 SATe 1961598 0.2711 53,298

1,912,194 518,396 467,148 51,248 6.00% 10 I 12 2,562

May 626,645 0.2711 169,883 439,890 0.2896 127,392

SATe 74,321 0.2711 20,148 SATe 51 1840 0.2896 151°13

1,192,696 332,436 503,807 (171.371) 6.00% 9 I 12 (7,712)

June 436,089 0.2896 126,291 SATe 52,738 0.2896 151273

488,827 141 ,564 503,697 (362,133) 6.00% 8 I 12 (14,485)

July 303,794 0.2896 87,979 SATC 37,549 0.2896 10,874

341,343 98,853 503,697 (404,844) 6.00% 7 I 12 (14,170) o (J)(J) ""c m ::ToC)

Total ~g: ::T ()

18,929,993 5,073,481 6,039,971 (966,490) (84,648) ;to-~ m z(o) £ x 0 m~

..... 2: 0 -0 '"


STATEMENT OF TOTAL OVER(UNDER} COLLECTIONS TWELVE MONTHS ENDED JULY 2012 (ACTUAL)

PGC PGC Cost of Over(Under) Interest Interest Interest Sales Rate Revenue Fuel Collection§: Rate Weight Amount

Mel $!Mel $ $ $ " $ (1) (2) (3.,x2) (4) (5.3-4) (6) (7) (8:5xSx7)

2011 August 168,974 0.2276 38,458 160,582 0.2627 42,185

SATe 17,739 0.2276 4,037 SATe 15,982 0.2627 4,198

363,277 88,878 466,888 (378,010) 6.00% 18 / 12 (34,021)

September 0 0.2276 0

398,454 0.2627 104,674 SATC 0 0.2276 0 SATe 39,109 0.2627 10,274

437,563 114,948 466,888 (351,940) 6.00% 17 / 12 (29,915)

October 661,444 0.2627 173,761 SATC 72,218 0.2627 18,972

733,662 192,733 521,142 (328,409) 6.00% 16 / 12 (26,273)

November 771,799 0.2627 202,752 622,795 0.2643 164,605

SATC 86,124 0.2627 22,625 SATe 67,957 0.2643 17,961

1,548,675 407,943 521 ,142 (113,199) 6 .00% 15 / 12 (8,490)

December 3,866 0.2627 1,016 2,216,714 0.2643 585,878

SATe 401 0.2627 105 SATC 245,331 0.2643 64,841

2,466,312 651 ,840 521 ,144 130,696 6.00% 14 I 12 9,149 ocncn-u

January m ::T0G)

2012 3,126,035 0.2643 826,211 s::m::T(") SATC 348,200 0.2643 92,029 l>-a m

3,474,235 918,240 Z~S.x

521,080 397,160 6.00% 13 / 12 25,815 o <1I:r. ,,~

0 '" () '"



PGC PGC Cost of Over(Under) Interest Interest Interest Sales Rate Revenue Fuel Collections Rate ~ Amount Met $/Met $ $ $ " $ (1 ) (2) (3:1 ><2) (4) (5: 3-4) (6) (7) (8=5x6x7)

February 1,473,190 0.2643 389,364 1,523,289 0.2711 4 12,964

SATC 165,774 0.2643 43,814 SATC 170,475 0.2711

3,332,728 892,358 521 ,669 370 ,689 6.00% 12 / 12 22,241

March 2,371,740 0.271 1 642,979 SATC 266,741 0.271 1 72 ,313

2,638,481 7 15,292 521,669 193,623 6.00% 11 / 12 10,649

April 1,715,596 0.2711 465,098 SATC 196,598 0.2711 53,298

1,912,194 518,396 467,148 5 1,248 6.00% 10 / 12 2,562

May 626,645 0.2711 169,883 439,890 0.2896 127,392

74 ,321 0.2711 20 ,148 SATC 51,840 0.2896 15,013

1,192,696 332,436 503 ,807 (171,371) 6.00% 9 / 12 (7,712)

June 436,089 0.2896 126,291 SATC 52,738 0.2896 15,273

488,827 141,564 503 ,697 (362,133) 6.00% 8 / 12 (14,485)

July 303,794 0.2896 87,979 SATC 37,549 0.2896 10,874

341 ,343 98,853 503,697 (404,844) 6.00% 7 / 12 (14 ,170) 0 00(/)"""0 m ::rC">G) ~g:::r()

Total 18,929,993 5 ,073,481 6,039,971 (966,490) (64 ,648) "'-!'m Zt11 £ x 0 .. ~

-...10' 0 ~

0 '" ~


Calculation of Qver(Under) Collection Balances Included In the PGC 201 3

Description

Reconciliation of over/(under)collectlon of gas cost for the twelve month period August 2010 through July 2011 originating In PGC 11

Estimated amount re1unded/(recovered) during the period August 2011 lhrough July 2012

Amount $

Actual amount refunded/(recovered) during the period August 201 1 through July 2012

SALES Bale Mel Refundl'S:urch~lge) August 2011 0.4678 361 ,992 169,340 September 201 1 0.0855 436,397 37,312 October 201 1 0.0855 727,650 62,214 November 201 1 0.1214 1,501,558 182,289 December 2011 0.1658 2,349,839 389,603 January - July 2012 0.1659 12,435,151

t7,812,587 MIGRATION August 2011 0.4847 5,747 2,785 September 2011 0.0855 9,433 807 October 2011 0.0855 9,982 853 November 2011 0.1205 19,979 2,407 December 2011 0.1648 29,307 4,830 January - July 2012 0.1659 140,937 23,381

215,384 35,064


Amount $

2 ,938,814

2 ,938,814

0

NATIONAL FUEL GAS DISTRI BUTION CORPORATION Pennsylvania Division

Calculation 01 Over(Under) Collection Balances Included In the PGC 201 3

Description Amount $

Estimated balance of over!(under)collection of gas cost for the twelve month period August 2011 through July 2012 originating In PGC 12

Estimated over!(under)collections of gas cost for the twelve month period August 2012 through July 2013

Estimated amount refunded/(recovered) during the period August 2012 through July 2013

SALES August 2012 September 201 2 October 2012 November 2012 December 2012 January - July 201 3

MIGRATION August 2012 September 201 2 October 2012 November 2012 December 2012 January - July 2013

Amount to be Recovered

Rate 0.5530 0.9908 0.9908 1.0092 1.0317 1.0317

0.5087 0.9908 0.9908 1.0066 1.0317 1.0317

Met 327,267 386,718 789,217

1,478,217 2,475,257

13,517,804 18,974,480

4,556 5,222 7,383

13,035 0 0

30,195

In PGC 2013

Refundl{Sur~harge)

180,979 383,160 781 ,956

1,491 ,817 2,553,723

13,946,31 8 19,337,953

2,317 5, 174 7,315

13,121 0 0

27,927


Amount $

19,145,578

19,365,880

!220,302l


Calculation of Over{Under) Collection Balances Included In the PGC 2013

Description

Reconciliation of over!(under)collection of gas cost lor the twelve month period August 2010 through July 2011 originating In PGC 11

Estimated amount refundedl(recovered) during the period August 201 1 through July 2012

Amount $

Actual amount refunded/(surcharged) during the period August 2011 through July 2012

SALES ~ Ml;! Refundl(Sur!;;h!;!lQ!;!:) August 2011 (0.0186) 360,920 (6,713) September 2011 0.0611 434,143 26,526 October 2011 0.0611 724,315 44,256 November 2011 0.0181 1,500,01 6 27,150 December 2011 (0.0352) 2,348,701 (82,674) January · July 2012 (0.0354) 12t429,412 (44O,OOll

17,797,507 (431,456) LBS&NGV August 2010 (0.0446) 60 (3) September - November 2010 0.0293 1,209 35 December 2010 . July 2011 (0.0 169) 5,223 (88l

6,492 (56) MIGRATION August 2010 (0.0221) 5,747 (127) September 2010 0.0611 9,433 576 October 2010 0.0611 9,982 610 November 2010 0.01 92 19,979 384 December 2010 (0.0341 ) 29,307 January - July 201 1 (0.0354) 140,937

215,384

PGC Exhibit 21 Schedule 8 Sheet 1 DEMAND _ NGS

Amount $

(436,058)

(436,058l 0


Calculation of Over(Under) Collection Balances Included In the PGC 2013

Description Amount $

Estimated balance ot over!{under)collectlon of gas cost for the twelve month period August 2011 through July 2012 originating In PGC 12

Estimated over{(under)coUection of gas cost for the twelve month period August 2012 through July 2013

Estimated amount refundedJ(recovered) during the period August 2012 through July 2013

SALES ~ Met Refund August 2012 (0.1456) 325,942 (47,457) September 2012 (0.2702) 385,403 (104,136) October 2012 (0.2702) 786,809 (212,596) November 2012 (0.2832) 1,477,020 (418,292) December 2012 (0.2992) 2,475,257 (740,597) January - July 2013 (0.2992) 13,517,804 (4,044,5271

18,968,235 (5,567,605) LBS & NGV

August 2012 (0.0169) 379 (6) September - November 2012 (0.1271) 1,851 (235) December 2012 - July 2013 (0.1408) 0 0

2,230 (241) MIGRATION August 2012 (0.1329) 4,556 (605) September 2012 (0.2702) 5,222 (1,411) October 2012 (0.2702) 7,383 (1,995) November 2012 (0.2813) 13,035 (3,667) December 2012 (0.2992) 0 0 January· July 2013 (0.2992) 0 0

30,195 (7,678)

Amount to be Refunded In PGC 2013

PGC Exhibit 21 Schedule 8 Sheet 2 DEMAND- NGS

Amount $

(5,551,418)

(5,575,5241

24,106


Calculation of Over(Under) Collection Balances Included In the PGe 2013

Description

Reconciliation of over!(undercollectlon) of gas cost for the twelve month period August 2010 through July 2011 originating In PGe 11


Amount $

Actual amount refundedl(recovered) during the period August 2011 through July 2012

SALES Rate Met RefundllSurch5i!,r9§) August 201 1 (0.0030) 363,277 (1,090) September · October 2011 0.0108 1,171 ,225 12,649 November 2011 0.0117 1,548,674 18,120 December 2011· July 2012 0.0128 15,846,818 202,839

18,929,994 232,519 LBS & NGV August 201 1 (0.0076) 60 (0) September - November 2011 0.0051 1,209 6 December 2011 - July 2012 0.0062 5,223 32

6,492 39

PGC Exhibtt 21 Schedule 8 Sheet 1 DEMAND· DC

Amount $

232,558

232,558

0


Calculation of Over(Under) Collection Balances Included In the PGC 2013

Description

Estimated balance of over/(under)collectlon of gas cost for the twelve month period August 2011 through July 2012 originating In PGC 12

Estimated over/(under)collect;ons 01 gas cost for the twelve month period August 2012 through July 2013

Amount $

Estimated amount refunded(recovered) during the period August 2012 through July 2013

SALES Bl!m Met R~fundl(~ur~h~rg~l August 2012 (0.0152) 354,839 (5,394) September 2012 (0.0468) 421,218 (19,713) October 2012 (0.0468) 864,104 (40,440) November 2012 (0.0470) 1,623,843 (76,321) December 2012 (0.0472) 2,776,730 (131,062) January 2013 . July 2013 (0.0472) (720,28Ol

(993,210) LBS& NGV

August 2012 0.0062 379 2 September · November 2012 (0.0221) 1,851 (41 ) December 2012 - July 2013 (0.0223) 0 0

2,230 (39)

Amount to be Recovered In PGC 2013

PGC Exhibtt 21 Schedule 8 S heet 2 DEMAND- DC

Amount $

(1,003,980)

(993,249l

!10,731 l



Calculation of Refund or (Surcharge) Balances Included in the PGC 2013

Description

Reconciliation of refund/(surcharge) established In PGC 12


Actual amount refunded/(recovered) during the period August 2011 through July 2012

Amount $

SALES Rate MIl! Refyndl(Surchargel August 2011 0.0000 361 ,992 0 September 201 1 0.0000 436,397 0 October 2011 0.0000 727,650 0 November 2011 0.0000 1,501 ,558 0 December 2011 0.0000 2,349,839 0 January~July 2012 0.0000 12,435,151 0

17,812,587 0 MIGRATION August 2011 0.0000 5,747 0 September 2011 0.0000 9,433 0 October 2011 0.0000 9,982 0 November 2011 0.0000 19,979 0 December 2011 0.0000 29,307 0 January ~ July 2012 0.0000 140,937 0

215,384 0

Amount $

o

o

0

o



Calculation of Refund or (Surcharge) Balances Included In the PGC 2013

Description

Reconciliation of refund/(surcharge) established in PGC 12


Estimated amount refunded/(recovered) during the period August 201 1 through July 2012

Amount $

SALES Rate Met Refyndl(Surcharge) August 2012 0.0023 327,267 753 September 2012 0.0050 386,718 1,934 October 2012 0.0050 789,217 3,946 November 2012 0.0050 1,478,217 7,391 December 2012 0.0050 2,475,257 12,376 January · July 2013 0.0050 13,517,804

18,974,480 MIGRATION August 2012 0.0021 4,556 10 September 2012 0.0050 5,222 26 October 2012 0.0050 7,383 37 November 2012 0.0050 13,035 65 December 2012 0.0050 0 0 January - July 2013 0.0050 0 0

30,195 138


Amount $

91,689

94,127

(2,438)


Calculation of Refund or Surcharge Balances Included In the PGC 2013

D~~[iQti2!3 -$ Reconciliation of refund or (surcharge) established In PGC 11

Estimated amount refundedJ{recovered) during the period August 2011 through July 2012

Actual amount refunded/(recovered) during the period August 2011 through July 2012

SALES lliIlo M<J Bifl.![!~(~!.!rSlbi!rge} August 201 1 0.1014 360,920 36,597 September 2011 0.1 483 434,143 64,383 October 2011 0.1483 724,315 107,416 November 2011 0.1483 1,500,016 222,452 December 2011 0.1484 2,348,701 348,547 January - July 2012 0.1484 1214291412 118441525

17,797,507 2,623,921 LBS&NGV August 2011 0.0272 60 2 September· November 2011 0.0710 1,209 66 December2011-July2012 0.0710 51223 371

6,492 456

MIGRATION August 201 1 0.0994 5,747 571 September 2011 0.1483 9,433 1,399 October 201 1 0.1 483 9,982 1,480 November 2011 0.1 483 19,979 2,963 December 2011 0.1484 29,307 4,349 January - July 2012 0.1484 140 1937 201915

215,384 31,678

PGC Exhibit 21 Schedule 9 Sheet 1 DEMAND · NGS

Ar:Dl2!..!!3t $

2,656,057

2z656.057

0

NATIONAL FUEL GAS DISTRIBUTION CORPORATION Pennsyfvania Division

Calculation of Refund or Surcharge Balances Included In the PGC 2013

D!!:§s;;ril2tiQn Amount $

Reconciliation of refund or (surcharge) established In PGC 12



SALES f!Oli Mol A!!:fi.!!ldl{Syrs;;bS!.rg!!:) August 2012 0.0943 325,942 30,736 September 2012 0.0331 385,403 12,757 October 2012 0.0331 786,809 26,043 November 2012 0.0331 1,477,020 48,889 December 2012 0.0332 2,475,257 82,179 January • July 2013 0.0332 13,5171804 4481791

18,968,235 649,396 LBS&NGV August 2012 0.0710 379 27 September· November 2012 0.0156 1,851 29 December 2011 • July 2013 0.0156 0 0

2,230 56

MIGRATION August 2012 0.1005 4,556 458 September 2012 0.0331 5,222 173 October 2012 0.0331 7,383 244 November 2012 0.0331 13,035 431 December 2012 0.0332 0 0 January · July 2013 0.0332 0 0

30,195 1,307


PGC Exhibit 21 Schedule 9 Sheet 2 DEMAND-NGS

8!l!Q!'![l1 $

616,055

650?58

(34,703)

Refund From

A.

TOTAL


Refunds From and Payments to Gas Suppliers

Date Received

Refund Amount

$

Rate

INTEREST

Weight Amount

o 6.00% o I 12 0

o o

Total Refund Plus Interest

o

o

O(J) 1l O°G) ~i() ;::c. m o£x om:. _ _ C"

-10;::0:

-< '" -

Description


PGC Exhibit 21 Schedule 11 Sheet 1 COMMODITY - STORAGE

Calculation of Reconciliation 01 Interest on Storage InjectlonslWithdrawals

Amoum $

Reconcil iation of Interest expense/(lncome) due to/(from) customers lor the twelve month perfod August 2011 through July 2012 originating In PGC 12 (PGC 2010 · Ree. e. factor)

Estimated amount passed back/(recovered) during the period August 2011 through July 2012 In E Factor (77,939)

Actual amount passed back/(recovered) during the period August 2011 through July 2012 in E-Faclor

SALES August 2011 September 20 11 October 2011 November 2011 December 2011 January - July 2012

MIGRATION AugUSI2011 September 2011 October 2011 November 2011 December 2011 January - July 2012

!lo!o (0.0029) (0.0060) (0.0060) (O.0052) (O.OO42) (0.0042)

(0.0028) (0.0060) (0.0060) (0.0052) (0.0042) (0.0042)


Ml<! 361,992 436,397 727,650

1,501,558 2,349,839

Aefundl(Surcharcel (1,050) (2,618) (4,366) (7,808)

5,747 (16) 9,433 (57) 9,982 (60)

19,979 (104) 29,307 (123)

ll!!.l!ilZ ___ _ ~15,,9"'2):----"'== 215,384 (951) (78,891)

952

DescdotiQn

NATIONAL FUEL GAS DISTRIBUTION CORPORATION Pennsylvania DivisIon

PGC Exhibit 21 Schedule 11 Sheet 2 COMMODITY· STORAGE

Calculation of ReconciliatIon of Interest on Storage InJectlons/Wlthdrawals

Amount $

Estimated Interest expense/(lncome) due lo/(from) customers for the twelve month period August 2011 through July 2012 in C-FacIOf (PGC 2011 - C Factor) 259,253

Actual amount passed back/(recovered) during the period August 2011 through July 2012 in C Factor

SALES August 201 t September 2011 October 2011 November 2011 December 2011 January 201 2 February 2012 March 2012 April 2012 May 2012 June - July 2012

Amount to be Refunded

~ ~ Aefunclf(Surcharael 0.0102 330,628 3,372 0.0187 400,708 7,493 0.0187 664 ,779 12,431 0.0213 1,396,136 29,738 0.0245 2,221,718 54,432 0.0245 3,126,483 76,599 0.0158 2,997,061 47,354 0.0074 2,372,404 17,556 0.0074 1,716,562 12,703 0.0019 1,067,368 2,026

(0.0060) _=,7C;4~2,~'29~ ___ -,,!1~4,,,45?3"-1 17,035,976 259,253

in PGC 2013

259,253

o


PGC Exhibit 21 Schedule 11 Sheet 3 COMMODITY - STORAGE

Calculation of Aeconclllation of Interest on Storage lnjectrons/Withdrawals

Description

Estimated balance of interest expense/(income) due to/(lrom) customer for the twelve month period August 2011 through July 2012 originating In PGC 12 (PGe 2011- Ree. E-factor)

Estimated Interest expenseJ(income) due to/{from) customers lor the twelve month period August 20t , through July 2012 in C/E Factor

Estimated amount passed back/(recovered) during the period AuguSI 2012 Ihrough July 2013 In E Factor

SALES Bl!!O Mol Rm!'![l!;!lll2!.!r!Ot!",rg~l AugUSI2012 (0.0106) 327,267 (3,469) September 2012 (0.0177) 386,718 (6,845) October 2012 (0.0177) 789,217 (t3,969) November 2012 (0.0176) 1,47B,21 7 (26,017) December 2012 (0.0 174) 2,475,257 (43,069) January - July 2013 (0.0174) 1315171804 {235,210}

1B,974,4BO (32B,579)

MfGRATION August 2012 (0.0098) 4,556 (45) September 2012 (0.0177) 5,222 (92) October 2012 (0.0177) 7,383 (13 1) November 2012 (0.0 176) 13,035 (229) December 2012 (0.0 174) 0 0 January - July 2013 (0.0174) 0 0

30,195 (497)


Amount $

(323,832)

(329,076)

51244

NATIONAL FUEL GAS DISTAIBUTION CORPORATION Pennsylvania Division

PGC Exhibit 21 Schedule 11 Sheet 4

COMMODITY - STORAGE

Calculation of Reconciliation of Interest on Storage InJectlona,IWithdrawals

Description

Estimated Interest expense/(lncome) due IO/(from) customers for the twelve month period August 2012 through July 2013 in C-Factor (PGC 2012 - C factor)

Estimated amount passed backl(recovered) during the period August 2012 through July 2013 In C Factor

SALES Bo!o MJ:j Befl.!n!i!l(~y~hi!rg!l:l August 2012 0.0022 316,748 697 September 2012 0.0114 374,814 4,273 October 2012 0.0114 766,792 8,741 November 2012 0.0169 1,438,331 24,308 December 20 12 0.0237 2,475,257 58,664 January 2013 0.0237 3,306,873 78,373 February 2013 0.0237 3,211,390 76,110 March 2013 0.0237 2,649,104 67,524 April 2013 0.0237 2,110,767 50,025 May 2013 0.0237 1,156,607 27,412 June - July 2013 0.0237

Amount to be Refunded In PGe 2013

Amount $

722,321

417,054

3051267

computation of purchased gas commodity cost per mc1 · national fuel gas distribution corporation...

Documents