Spreadsheet: tracy_geaccone__40543__CE 3-2001
Sheet: Fuel Calc

 |  | 31 | 28 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 | 365 |  | 365 | 365
Transwestern Pipeline Company
UAF Analysis
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |  | 2002 | 2003
2001 Forecast
All Commodity Deliveries per Fin. Planning Model |  | 2468.6 | 2430.3 | 2396 | 2343.5 | 2411.9 | 2416.3 | 2240.2 | 2268.3 | 2234.6 | 2356 | 2390.5 | 2424.4
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
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:
San Juan to Thoreau Delivery Volumes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5221 | 5221
Ignacio to Hub Delivery Volumes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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) |  |  |  |  |  |  |  |  |  | -958
UAF Operations
UAF Accounting
Total Retained $ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Less: Adjustment for Hedging (20/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
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.018 | 0.018 | 0.018 | 0.018 | 0.018 | 0.018 | 0.018
Hedged Volumes
Additional Revenue from Selling Hedged Volumes
Unhedged [NAME]
Less: Total UAF
Revised Total Fuel Upside
2001 Plan Total Fuel Upside |  | 2832 | 2572 | 2566 | 2533 | 2566 | 2115 | 2449 | 2478 | 2571 | 3162 | 2876 | 2525
Revised Plan Adjustment taken against unhedged |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Factor being used |  | 0.0006
UAF Volume
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 |  |  | 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 |  | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
Unhedged [NAME] available
 |  | January | February | March | April | May | June | July | August | September | October | November | December | Total | Average
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 100% of Retainage
West(.018 of Deliveries) or Actals per Fac Plng
Burned .018 Of Deliveries-Old method
Difference Alt Method and Old Method MMBTU
Fuel Index Price
Difference Alt Method and Old Method  $
West Percent Of deliveries
Fuel Used per accounting |  | 994 | 905 | 1026 | 848 | 905