Spreadsheet: tracy_geaccone__40432__PLAN_FORECAST_DESIGN_MASTER
Sheet: Summary

DAYS OF MONTH | 31 | 28 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 | 365 |  | 30.33333333333333 | 334.6666666666667 | 365 | #REF! | 365 | 365
 | 5 | 2
[NAME]
2002 PLAN
MARGIN SUMMARY
S:\Marketing\TWFIN\MKT_ANLY\TW\TWFIN\2001\Misc\[PLAN_FORECAST_DESIGN.xls]/Summary
 | Plan | Plan | Plan | Plan | Plan | Plan | Plan | Plan | Plan | Plan | Plan | Plan | Plan | 1st Qtr | 2nd Qtr | [NAME] | [NAME] | 2001 Annual
 | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | TOTAL | Forecast | Forecast | Forecast | Forecast | Forecast | 2002 | 2003
TSPT VOLUME (MMMBTU/DAY)
WEST
WEST: THOREAU
DEMAND
FTS
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS  (incl.West of Thoreau)
TOTAL THOREAU TO WEST
WEST: EAST OF THOREAU
DEMAND
FTS
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LFT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS
TOTAL EAST OF THOREAU TO WEST
WEST: IGNACIO
DEMAND
FTS
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS
TOTAL IGNACIO TO WEST
WEST:  SAN JUAN
DEMAND
FTS
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LFT--San Juan | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS
TOTAL SAN JUAN TO WEST
TOTAL TRANSPORT WEST
TOTAL DEMAND WEST
EAST
EAST: WEST OF THOREAU and Thoreau
DEMAND
FTS
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS
TOTAL THOREAU TO EAST
EAST: EAST TO EAST
DEMAND
FTS
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PNR-East of Thoreau | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS
TOTAL EAST TO EAST
EAST: IGNACIO
DEMAND
FTS
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS
TOTAL IGNACIO TO EAST
EAST: SAN JUAN
DEMAND
FTS
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS
TOTAL SAN JUAN TO EAST
TOTAL TRANSPORT EAST
TOTAL DEMAND EAST
IGNACIO/BLANCO
IGNACIO TO EL PASO BLANCO HUB
DEMAND
FTS
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS
TOTAL IGNACIO TO EL PASO BLANCO
IGNACIO TO BLANCO HUB
DEMAND
FTS
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS
TOTAL IGNACIO TO BLANCO HUB
TOTAL TRANSPORT IGNACIO/BLANCO
TOTAL DEMAND IGNACIO/BLANCO
SAN JUAN
THOREAU:  SAN JUAN
DEMAND
FTS
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS
TOTAL TRANSPORT SAN JUAN
TOTAL SAN JUAN DEMAND
(Total Lateral Demand)
COMPANY TOTAL
DEMAND
FTS
FR
LFT
PNR
ITS
TOTAL COMPANY COMMODITY
TOTAL COMPANY DEMAND
TOTAL COMPANY THROUGHPUT
FUEL RETAINAGE (production month)
FUEL USE (production month)
GAS PRICE
TSPT MARGIN  PER  MMBTU
WEST: THOREAU
DEMAND
FTS
FR
ITS
WEST: EAST OF THOREAU
DEMAND
FTS
FR
ITS
WEST:  IGNACIO
DEMAND
FTS
FR
ITS
WEST:  SAN JUAN
DEMAND
FTS
FR
ITS
EAST:  WEST OF THOREAU
DEMAND
FTS
FR
ITS
EAST:  EAST TO EAST
DEMAND
FTS
FR
ITS
EAST:  IGNACIO TO EAST
DEMAND
FTS
FR
ITS
EAST: SAN JUAN
DEMAND
FTS
FR
ITS
IGNACIO TO EL PASO BLANCO
DEMAND
FTS
FR
ITS
IGNACIO TO BLANCO HUB
DEMAND
FTS
FR
ITS
SAN JUAN TO THOREAU:
DEMAND
FTS
FR
ITS
TSPT REVENUE
WEST
WEST:  THOREAU
DEMAND
FTS
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS
TOTAL THOREAU TO WEST
WEST: EAST OF THOREAU
DEMAND
FTS
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LFT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS
TOTAL EAST OF THOREAU TO WEST
WEST: IGNACIO
DEMAND
FTS
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS
TOTAL IGNACIO TO WEST
WEST: SAN JUAN
DEMAND
FTS
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LFT--San Juan | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS
TOTAL SAN JUAN TO WEST
SUBTOTAL WEST DEMAND
SUBTOTAL WEST COMMODITY
TOTAL WEST
EAST
EAST: WEST OF THOREAU and Thoreau
DEMAND
FTS
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS
TOTAL THOREAU TO EAST
EAST: EAST TO EAST
DEMAND
FTS
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PNR-East of Thoreau | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS
TOTAL EAST TO EAST
EAST: IGNACIO
DEMAND
FTS
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS
TOTAL IGNACIO TO EAST
EAST: SAN JUAN
DEMAND
FTS
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS
TOTAL SAN JUAN TO EAST
SUBTOTAL EAST DEMAND
SUBTOTAL EAST COMMODITY
TOTAL EAST
IGNACIO/BLANCO
IGNACIO TO EL PASO BLANCO
DEMAND
FTS
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS
TOTAL IGNACIO TO EL PASO BLANCO
IGNACIO TO BLANCO HUB
DEMAND
FTS
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS
TOTAL IGNACIO TO BLANCO HUB
SUBTOTAL IGNACIO DEMAND
SUBTOTAL IGNACIO COMMODITY
TOTAL IGNACIO
SAN JUAN
SAN JUAN TO THOREAU:
DEMAND
FTS
FR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ITS
SUBTOTAL SAN JUAN DEMAND
SUBTOTAL SAN JUAN COMMODITY
TOTAL SAN JUAN
COMPANY TOTAL
DEMAND
FTS
FR
PNR
LFT
ITS
TOTAL COMPANY DEMAND
TOTAL COMPANY COMMODITY
TOTAL COMPANY
MARGIN CALCULATION
COST OF TRANSPORT:
TCR  AMORTIZATION EXPENSE
UAF
GRI,ACA EXPENSE
NET FUEL EXPENSE (RETAINED)
TOTAL COST OF TRANSPORT
SW Gas Payment |  |  |  |  |  |  |  |  |  |  |  | -143
SANTA FE SETTLEMENT | -13 | -12.5 | -12.5 | -12.5 | -12.5 | -12.5 | -12.5 | -12.5 | -12.5 | -12.5 | -12.5 | -12.5
Hedging | -17 | -16.865 | -14.9 | -15 | -15 | -15 | -15 | -15 | -15 | -15 | -15 | -15
Alternate Receipt points reserve reversal | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Forecast Adjustment | 0 | 0
TOTAL GROSS MARGIN
COMMODITY SURCHARGES
[NAME]
ACA SURCHARGE - ALL REGIONS
TOTAL COMMODITY SURCHARGES
COMMODITY REVENUE
COMMODITY MARGIN
SHARED COST SETTLEMENT SURCHARGE
THOREAU TO WEST OF THOREAU | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EAST OF THOR. TO WEST OF THOR. | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL SETTLEMENT SURCHARGES
DEMAND SURCHARGES
GRI
WEST OF THOREAU TO EAST | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EAST TO EAST
IGNACIO TO EAST
SAN JUAN TO EAST
IGNACIO TO BLANCO HUB |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
IGNACIO TO EL PASO BLANCO |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
THOREAU TO WEST
SAN JUAN TO WEST | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EAST OF THOREAU TO WEST
SUBTOTAL GRI DEMAND
TCR II
THOREAU TO WEST(Other CFC's) | 43.9425 | 43.9425 | 43.9425 | 43.9425 | 43.9425 | 43.9425 | 43.9425 | 43.9425 | 43.9425 | 43.9425 | 43.9425 | 43.9425 | 527.31
EAST OF THOREAU TO WEST(Socal) | 55.9674 | 55.9674 | 55.9674 | 55.9674 | 55.9674 | 55.9674 | 55.9674 | 55.9674 | 55.9674 | 55.9674 | 55.9674 | 55.9674 | 671.6088000000001
SUBTOTAL TCR II
TOTAL DEMAND SURCHARGES
DEMAND REVENUES
DEMAND MARGIN
COMPANY MARGIN (EXCLUDING FUEL & UAF)
CHECK
FUEL GROSS UP CALCULATION
Thoreau to West
East of Thoreau to West
San Juan (incl.[NAME]) to West
All East flow
San Juan to Thoreau/ Ignacio to Blanco
[NAME] to El Paso Blanco
TOTAL FUEL GROSS UP
LESS FUEL USE
NET FUEL
INDEX PRICE | 2.96 | 2.94 | 2.87 | 2.72 | 2.74 | 2.77 | 2.81 | 2.85 | 2.84 | 2.86 | 3.1 | 3.26
CHECK