Spreadsheet: michelle_lokay__26673__Astra
Sheet: Astra's

 | 2001-06-01 00:00:00
 | TW/Astra 50,000 MMBtu/d East Capacity Block
 | Fee Calculations
 | CR #27495
 | Gas Daily Midpoint |  |  |  | TW | Spread to TW |  |  |  |  |  |  |  |  |  |  |  |  |  | Transwestern System Rate Calc.
 |  |  |  | Adj | E to E | less Resv |  |  | Delivered Vol, mmbtu |  |  |  |  |  |  |  |  | Contract
 |  |  | TW | TW | Resv | Cost,  $/mmbtu |  | Commodity | PGE | SCG |  | Calculated Total Theoretical Profit, $ |  |  | Profit Share |  |  | Demand | Contract System Rates * |  | Revenues
Day | PGE | SCG | Perm | Perm | Rate | PGE | SCG | Floor | 56698 | 10487 | Total | PGE | SCG | Total | Astra 70% | TW 30% |  | [NAME] | Demand | Commodity | Demand | Commodity | Total
1 | 4.535 | 9.92 | 3.59 |  | 0.0325 |  |  |  | 0 | 8087 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 3.05 | 7.915 | 3.375 |  | 0.0325 |  |  |  | 0 | 14866 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 3.05 | 7.915 | 3.375 |  | 0.0325 |  |  |  | 0 | 21339 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 3.05 | 7.915 | 3.375 |  | 0.0325 |  |  |  | 0 | 13326 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 3.51 | 8.95 | 3.845 |  | 0.0325 |  |  |  | 0 | 14976 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 3.945 | 9.425 | 3.875 |  | 0.0325 |  |  |  | 0 | 12388 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 3.08 | 7.985 | 3.55 |  | 0.0325 |  |  |  | 0 | 12022 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 3.15 | 5.82 | 3.4 |  | 0.0325 |  |  |  | 0 | 10650 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 2.915 | 3.535 | 3.245 |  | 0.0325 |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 2.915 | 3.535 | 3.245 |  | 0.0325 |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 2.915 | 3.535 | 3.245 |  | 0.0325 |  |  |  | 0 | 21930 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 3.385 | 6.735 | 3.615 |  | 0.0325 |  |  |  | 0 | 13104 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 3.89 | 7.595 | 3.795 |  | 0.0325 |  |  |  | 0 | 33378 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 3.64 | 8.47 | 4.125 |  | 0.0325 |  |  |  | 0 | 12373 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 3.515 | 6.9 | 4.125 |  | 0.0325 |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 3.015 | 3.735 | 3.51 |  | 0.0325 |  |  | 0.0246 | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 3.015 | 3.735 | 3.51 |  | 0.0325 |  |  | 0.0246 | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 3.015 | 3.735 | 3.51 |  | 0.0325 |  |  | 0.0246 | 0 | 19021 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 4.315 | 8.25 | 3.71 |  | 0.0325 |  |  |  | 0 | 11383 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 4.065 | 7.335 | 3.92 |  | 0.0325 |  |  |  | 0 | 13318 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 4.125 | 6.89 | 3.755 |  | 0.0325 |  |  |  | 0 | 4153 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 4.48 | 6.54 | 3.495 |  | 0.0325 |  |  |  | 0 | 4917 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 3.76 | 3.88 | 3.445 |  | 0.0325 |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 3.76 | 3.88 | 3.445 |  | 0.0325 |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 3.76 | 3.88 | 3.445 |  | 0.0325 |  |  |  | 0 | 18897 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 3.995 | 6.055 | 3.45 |  | 0.0325 |  |  |  | 0 | 13457 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 3.39 | 4.685 | 3.325 |  | 0.0325 |  |  |  | 0 | 16713 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 2.955 | 4.68 | 3.205 |  | 0.0325 |  |  |  | 0 | 11199 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 2.99 | 4.31 | 2.99 |  | 0.0325 |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 2.99 | 4.31 | 2.99 |  | 0.0325 |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | Commodity Floor |  |  |  |  |  | Reservation Charges |  |  |  |  |  |  | Summary |  |  |  |  | Difference between Total amt. Due to System Rates
 | Delivered Volume, mmbtu |  |  |  |  |  | Contracted Vol, mmbtu/d |  |  |  | 50000 |  |  | TW Profit Share, $ |  |  |  |  | Total Amt due TW, $
 | [NAME], $/mmbtu |  |  | 0.0246 |  |  | Days in month |  |  |  | 30 |  |  |  |  |  |  |  | Reservation Charge, $
 | Total [NAME], $ |  |  |  |  |  | Resv Charge, $/mmbtu |  |  |  | 0.0325 |  |  |  |  |  |  |  | Commodity Costs, $
 |  |  |  |  |  |  | [NAME], $ |  |  |  |  |  |  |  |  |  |  |  | Difference to Model Calculation
 |  | Commodity Floor of .0246; Can't go below rate of .0246
 |  | Notes: "Adj TW Per" is the fuel adjusted price = (TW Per) / 0.95