Spreadsheet: tracy_geaccone__40432__PLAN_FORECAST_DESIGN_MASTER
Sheet: Red Rock & New Ks

Transwestern Pipeline Company
2002 Plan
Red Rock Contracts, Resubscribed Contracts and Rate Increases
Inclusion Key |  | Y |  | Y = Yes, include in 2002 Plan.     N = No, not included in 2002 Plan.
#  Days |  |  |  |  |  |  |  |  |  | 31 |  |  | 28 |  |  | 31 |  |  | 30 |  |  | 31 |  |  | 30 |  |  | 31 |  |  | 31 |  |  | 30 |  |  | 31 |  |  | 30 |  |  | 31
 |  |  |  |  |  |  |  | January |  |  | February |  |  | March |  |  | April |  |  | May |  |  | June |  |  | July |  |  | August |  |  | September |  |  | October |  |  | November |  |  | December
 |  | Start Term/ | Term |  | Dem/D | Comm | Total Rate | Demand | Demand | Demand |  |  | Demand |  |  | Demand |  |  | Demand |  |  | Demand |  |  | Demand |  |  | Demand |  |  | Demand |  |  | Demand |  |  | Demand |  |  | Demand |  |  | Demand |  | CFC RATE | TOTAL BY
CR# | Company | Description | End | MDQ | $ | $ | $ | Volume | Rate | $ Revenue |  |  | $ Revenue |  |  | $ Revenue |  |  | $ Revenue |  |  | $ Revenue |  |  | $ Revenue |  |  | $ Revenue |  |  | $ Revenue |  |  | $ Revenue |  |  | $ Revenue |  |  | $ Revenue |  |  | $ Revenue |  | INCREASE | CONTRACT
EOT to EOT
24198 | [NAME] (Resubscribe) | 2002-06-01 00:00:00 | 2002-12-31 00:00:00 | 35714 | 0.05 | One -part | One -part | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 35714 |  |  | 35714 |  |  | 35714 |  |  | 35714 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0
24198*SC | Richardson | 1995-06-01 00:00:00 | 2002-05-31 00:00:00 | -35714 | 0.104 | One -part | One -part | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.0407
27377 | Agave | 2002-03-01 00:00:00 | 2002-12-31 00:00:00 | 10000 | 0.05 | One -part | One -part
27600 | Sid/Bass | 2002-06-01 00:00:00 | 2002-12-31 00:00:00 | 0 | 0.09 | One -part | One -part
27606 | PNM | 2001-10-01 00:00:00 | 2006-09-30 00:00:00 | 80000 | 0.08 | One -part | One -part | 80000 |  |  | 80000 |  |  | 35000 |  |  | 35000 |  |  | 20000 |  |  | 20000 |  |  | 20000 |  |  | 20000 |  |  | 20000 |  |  | 35000 |  |  | 80000 |  |  | 80000
27291 | Duke ([NAME]) | 2002-08-01 00:00:00 | 2002-12-31 00:00:00 | 20000 | 0.02 | One -part | One -part | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 20000 |  |  | 20000 |  |  | 20000 |  |  | 20000 |  |  | 20000
27579 | Duke ([NAME]) | 2002-06-01 00:00:00 | 2002-12-31 00:00:00 | 20000 | 0.06 | One -part | One -part | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 20000 |  |  | 20000 |  |  | 20000 |  |  | 20000 |  |  | 20000 |  |  | 20000 |  |  | 20000
25374 | KN Processing (Resubscribe) | 2002-01-01 00:00:00 | 2002-12-31 00:00:00 | 23000 | 0.05 | One -part | One -part | 23000 |  |  | 23000 |  |  | 23000 |  |  | 23000 |  |  | 23000 |  |  | 23000 |  |  | 23000 |  |  | 23000 |  |  | 23000 |  |  | 23000 |  |  | 23000 |  |  | 23000
 |  |  |  |  |  |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
TOTAL EOT TO EOT
IGNACIO - TO EL PASO BLANCO
27370 | BP Energy | 2001-01-01 00:00:00 | 2002-12-31 00:00:00 | 22000 | 0.105 | 0.0033 |  | 22000 | 0.105 |  | 22000 | 0.105 |  | 22000 | 0.105 |  | 22000 | 0.105 |  | 22000 | 0.105 |  | 22000 | 0.105 |  | 22000 | 0.105 |  | 22000 | 0.105 |  | 22000 | 0.105 |  | 22000 | 0.105 |  | 22000 | 0.105 |  | 22000 | 0.105
Unsubscribed |  | 2002-07-01 00:00:00 | 2002-09-30 00:00:00 | 29000 | 0.08 | one-part | one-part |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 0
TOTAL IGNACIO TO EL PASO BLANCO
IGNACIO - TO EL PASO BLANCO
27342 | Sempra Energy | 2001-01-01 00:00:00 | 2001-12-31 00:00:00 | 30000 | 0.06 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22000 | 0.105
TOTAL IGNACIO TO BLANCO
SJ to THOR
20835 | Conoco, Inc. |  | 2002-02-28 00:00:00 | 20000 |  | CFC Rate Increase |  | 0 |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0
20715 | SoCal |  | 20/31/05 | 200000 |  | CFC Rate Increase |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
21165 | PG&E |  | 2007-03-31 00:00:00 | 150000 |  | CFC Rate Increase |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
26678 | El Paso Energy |  | 2007-03-31 00:00:00 | 25000 |  | CFC Rate Increase |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
26372 | Duke Energy |  | 2007-03-31 00:00:00 | 25000 |  | CFC Rate Increase |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
25924 | Texaco Natural Gas |  | 2006-04-30 00:00:00 | 20000 |  | CFC Rate Increase |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
20834 | Citizens Utilities Co. |  | 2007-02-28 00:00:00 | 25000 |  | CFC Rate Increase |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0
TOTAL THOR TO WOT
EOT to WOT
27649 | PPL | Red Rock | 2007-05-31 00:00:00 | 7500 | 0.225 | One -part | One -part | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 7500 |  |  | 7500 |  |  | 7500 |  |  | 7500 |  |  | 7500 |  |  | 7500 |  |  | 7500
Unsubscribed |  | Red Rock | 2002-12-31 00:00:00 | 13300 | 0.1 | One -part | One -part | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0
27641 | PPL | Red Rock | 2032-06-30 00:00:00 | 20000 | 0.38 | One -part | One -part | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 20000 |  |  | 20000 |  |  | 20000 |  |  | 20000 |  |  | 20000 |  |  | 20000 |  |  | 20000
27608 | Western | Red Rock | 2017-05-31 00:00:00 | 10000 | 0.385 | One -part | One -part | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 10000 |  |  | 10000 |  |  | 10000 |  |  | 10000 |  |  | 10000 |  |  | 10000 |  |  | 10000
27607 | Oneok | Red Rock | 2004-03-31 00:00:00 | 1700 | 1.75 | One -part | One -part | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 1700 |  |  | 1700 |  |  | 1700 |  |  | 1700 |  |  | 1700 |  |  | 1700 |  |  | 1700
27642 | Calpine | Red Rock | 2017-05-31 00:00:00 | 40000 | 0.38 | One -part | One -part | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 40000 |  |  | 40000 |  |  | 40000 |  |  | 40000 |  |  | 40000 |  |  | 40000
27622 | US Gypsum | Red Rock | 2014-08-31 00:00:00 | 4500 | 0.42 | One -part | One -part | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 4500 |  |  | 4500 |  |  | 4500 |  |  | 4500 |  |  | 4500 |  |  | 4500 |  |  | 4500
27609 | BP Energy | Red Rock | 2012-05-31 00:00:00 | 15000 | 0.38 | One -part | One -part | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 15000 |  |  | 15000 |  |  | 15000 |  |  | 15000 |  |  | 15000 |  |  | 15000 |  |  | 15000
27604 | [NAME] | Red Rock | 2003-05-31 00:00:00 | 5300 | 2.2 | One -part | One -part | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 5300 |  |  | 5300 |  |  | 5300 |  |  | 5300 |  |  | 5300 |  |  | 5300 |  |  | 5300
27605 | [NAME] | Red Rock | 2017-05-31 00:00:00 | 2700 | 0.38 | One -part | One -part | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 2700 |  |  | 2700 |  |  | 2700 |  |  | 2700 |  |  | 2700 |  |  | 2700 |  |  | 2700
Subtotal Red Rock
26683 | APS | 2002-04-01 00:00:00 | 2003-03-31 00:00:00 | 8000 | 0.3453 | 0.0246 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  |  |  | 8000 |  |  | 8000 |  |  | 8000 |  |  | 8000 |  |  | 8000 |  |  | 8000 |  |  | 8000 |  |  | 8000
8255 | SoCal |  | 20/31/05 | 306000 |  | CFC Rate Increase |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
27581 | MAVRIX TRANSPORTATION TRADING COMPANY | 2001-11-01 00:00:00 | 2003-10-31 00:00:00 | 0 | 0.3473 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
27581 | MAVRIX TRANSPORTATION TRADING COMPANY | 2001-11-01 00:00:00 | 2003-10-31 00:00:00 | 0 | 0.1 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0
27340 | Oneok ([NAME]) |  | 2002-01-31 00:00:00 | 10000 | 0.3473 | One -part | One -part | 0 |  | 0
27340 | Oneok ([NAME]) |  | 2002-01-31 00:00:00 | 10000 | 0.1 | One -part | One -part | 0 |  | 0
26511 | PG&E (Resubscribe) | 2002-11-01 00:00:00 | 2002-12-31 00:00:00 | 21000 | 0.2 | One -part | One -part |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0
25841 | PG&E (Resubscribe) | 2002-11-01 00:00:00 | 2002-12-31 00:00:00 | 40000 | 0.1 | One -part | One -part | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0
Subtotal Other
TOTAL EOT TO WOT
THOR to WOT
20747 | Conoco, Inc. |  | 2002-02-28 00:00:00 | 10000 |  | CFC Rate Increase |  | 0 |  |  | 0 |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0
20748 | Conoco, Inc. |  | 2002-02-28 00:00:00 | 10000 |  | CFC Rate Increase |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
21165 | PG&E |  | 2007-03-31 00:00:00 | 150000 |  | CFC Rate Increase |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
26678 | El Paso Energy |  | 2007-03-31 00:00:00 | 25000 |  | CFC Rate Increase |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
26372 | Duke Energy |  | 2007-03-31 00:00:00 | 25000 |  | CFC Rate Increase |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
25924 | Texaco Natural Gas |  | 2006-04-30 00:00:00 | 20000 |  | CFC Rate Increase |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
20822 | Citizens Utilities Co. |  | 2007-02-28 00:00:00 | 25000 |  | CFC Rate Increase |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0
TOTAL THOR TO WOT
WOT to WOT
27583 | North Star Steel |  | 2002-06-01 00:00:00 | 1300 | 0.05 | one part rate |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0
TOTAL WOT TO WOT