Spreadsheet: tracy_geaccone__40433__PLAN_FORECAST_DESIGN_MASTER_WITH_STRETCH_Rev_10_08
Sheet: Annual Fuel Calc Alt

 |  | 31 | 28 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 | 365 |  | 365 | 365
Transwestern Pipeline Company
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2002
 |  | January | February | March | April | May | June | July | August | September | October | November | December | Total | Average | 2003 | 2004
2002 PLAN
All Commodity Deliveries per Fin. Planning Model
Deliveries by Applicable Fuel Percent:
East to West (5%) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4531 | 4999
Thor to West (4.5%) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4524 | 4524
IG/SJ to West (4.75%) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3953 | 7778
IG to [NAME] (.25%) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12360 | 12360
IG to Blanco Hub and SJ to Thor (.25%)
IG/SJ to East (1.56%) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
East to East (1.31%) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5044 | 5044
Negoti. Deals Adjustment to Fuel Retainage Calc.(sj to wot)
Fuel Percentages
East to West (5%) |  | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 |  |  | 0.05 | 0.05
Thor to West (4.5%) |  | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 | 0.045 |  |  | 0.045 | 0.045
IG/SJ to West (4.75%) |  | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 | 0.0475 |  |  | 0.0475 | 0.0475
IG to [NAME] (.25%) |  | 0.0025 | 0.0025 | 0.0025 | 0.0025 | 0.0025 | 0.0025 | 0.0025 | 0.0025 | 0.0025 | 0.0025 | 0.0025 | 0.0025 |  |  | 0.0025 | 0.0025
IG to Blanco Hub and SJ to Thor (.25%) |  | 0.0025 | 0.0025 | 0.0025 | 0.0025 | 0.0025 | 0.0025 | 0.0025 | 0.0025 | 0.0025 | 0.0025 | 0.0025 | 0.0025
IG/SJ to East (1.56%) |  | 0.0156 | 0.0156 | 0.0156 | 0.0156 | 0.0156 | 0.0156 | 0.0156 | 0.0156 | 0.0156 | 0.0156 | 0.0156 | 0.0156 |  |  | 0.0156 | 0.0156
East to East (1.31%) |  | 0.0131 | 0.0131 | 0.0131 | 0.0131 | 0.0131 | 0.0131 | 0.0131 | 0.0131 | 0.0131 | 0.0131 | 0.0131 | 0.0131 |  |  | 0.0131 | 0.0131
Calculated Receipts (Daily)
East to West
Thor to West
IG/SJ to West
IG to EP Blanco
IG to Blanco Hub and SJ to Thor
IG/SJ to East
East to East
Total Daily Receipts
Back off: |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 5221 | 5221
San Juan to Thoreau/ Ignacio to Blanco Hub Del. Vols. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2900 | 2900
Adjusted Total Daily Receipts
Total Monthly Receipts
Calculated Retainage (Daily)
East to West
Thor to West
IG/SJ to West
IG to [NAME] (.25%)
IG to Hub and SJ to Thor (.25%)
IG/SJ to East
East to East
Total Daily Retainage
Fuel Used (Calculated on Deliveries)
UAF Operations
UAF Accounting
Total Retained $ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Less: Adjustment for Hedging (15/d) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Additional Revenue from Selling Hedged Volumes
Less: Fuel Used |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
UAF Price Differential |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Less: UAF Operations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Less: UAF Accounting |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Calculated Total Fuel Upside
Unhedged Price |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.37 | 2.37
UAF %  Operations |  | 0.0004 | 0.0004 | 0.0004 | 0.0004 | 0.0004 | 0.0004 | 0.0004 | 0.0004 | 0.0004 | 0.0004 | 0.0004 | 0.0004 | 0.0006 |  | 0.002 | 0.002
UAF %  Accounting |  | 0.0002 | 0.0002 | 0.0002 | 0.0002 | 0.0002 | 0.0002 | 0.0002 | 0.0002 | 0.0002 | 0.0002 | 0.0002 | 0.0002
UAF Price
Burned %  (Calculated on Deliveries) |  | 0.018 | 0.018 | 0.018 | 0.018 | 0.018 | 0.022 | 0.022 | 0.022 | 0.022 | 0.022 | 0.022 | 0.022
Hedged Volumes
Additional Revenue from Selling Hedged Volumes
Unhedged [NAME]
UAF Unhedged volumes
Less: Total UAF
Calculated Total Fuel Upside
Additional Fuel Information
Factor being used |  | 0.0006
UAF Volume
Price |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.37 | 2.37
UAF Dollar
2001 Plan UAF Calculation |  | 0.0006
UAF Volume |  | 34.41372000000001 | 30.64487999999999 | 33.52278 | 30.8988 | 32.82899999999999 | 32.4774 | 29.5833 | 31.15128 | 29.0034 | 31.69254 | 31.3884 | 34.37466
Price |  | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5
UAF Dollar
Volume
Excess Fuel Volumes
Hedged volumes |  | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15
Unhedged [NAME] available
 |  | January | February | March | April | May | June | July | August | September | October | November | December | Total | Average | 2003 | 2004
FUEL BURNED ASSUMING 100% EAST RETAINAGE BURNT
Retainage Monthly MMBTU
EAST Retainage
WEST Retainage
Total Retainage
Deliveries MMBTU/Day
East Deliveries
West Deliveries
Burned Alternate Method Monthly MMBTU
East 110% of Retainage
West(.018/.022 of Deliveries)
Burned .018 /.022Of Deliveries-Old method
Difference Alt Method and Old Method MMBTU
Fuel Index Price
Difference Alt Method and Old Method  $
Breakdown Information:
I to I Usage Calculation
I to I Fuel Usage Volume
I to I Fuel Usage @ Plan Index Price
Red Rock Usage Calculation
Total Deliveries  West (Commodity)
Total Red Rock Deliveries EOT to WOT (Commodity)
Net West Deliveries without Red Rock
West Burned for Non-Red Rock @ .018
Total Burned inclusive of Red Rock (line133)
Net Usage attributable to Red Rock
Net Usage attributable to Red Rock @ Index Price