Spreadsheet: michelle_lokay__26674__Astra
Sheet: Astra's

 | 2001-05-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 |  | PGE | SCG |  | Calculated Total Theoretical Profit, $ |  |  | Profit Share |  |  | Demand | Contract System Rates * |  | Revenues
Day | PGE | SCG | Perm | Perm | Rate | PGE | SCG | 56698 | 10487 | Total | PGE | SCG | Total | Astra 70% | TW 30% |  | [NAME] | Demand | Commodity | Demand | Commodity | Total
1 | 11.94 | 14.51 | 4.575 |  | 0.0325 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 10.365 | 13.2 | 4.55 |  | 0.0325 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 9.075 | 12.9 | 4.39 |  | 0.0325 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 8.345 | 12.715 | 4.29 |  | 0.0325 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 7.74 | 12.385 | 4.32 |  | 0.0325 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 7.74 | 12.385 | 4.32 |  | 0.0325 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 7.74 | 12.385 | 4.32 |  | 0.0325 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 7.235 | 12.73 | 4.155 |  | 0.0325 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 8.6 | 12.57 | 4.03 |  | 0.0325 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 8.305 | 12.43 | 4 |  | 0.0325 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 6.42 | 12.335 | 3.93 |  | 0.0325 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 4.18 | 11.92 | 4.08 |  | 0.0325 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 4.18 | 11.92 | 4.08 |  | 0.0325 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 4.18 | 11.92 | 4.08 |  | 0.0325 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 5.095 | 11.255 | 4.115 |  | 0.0325 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 5.84 | 10.705 | 4.28 |  | 0.0325 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 5.955 | 10.575 | 4.295 |  | 0.0325 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 4.465 | 9.96 | 3.855 |  | 0.0325 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 3.96 | 9.98 | 3.785 |  | 0.0325 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 3.96 | 9.98 | 3.785 |  | 0.0325 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 3.96 | 9.98 | 3.785 |  | 0.0325 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 7.69 | 12.605 | 3.945 |  | 0.0325 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 9.245 | 13.25 | 3.83 |  | 0.0325 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 9.135 | 13.83 | 3.9 |  | 0.0325 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 8.67 | 12.615 | 3.915 |  | 0.0325 |  |  | 0 | 3102 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 4.235 | 10.295 | 3.615 |  | 0.0325 |  |  | 0 | 11632 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 4.235 | 10.295 | 3.615 |  | 0.0325 |  |  | 0 | 6922 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 4.235 | 10.295 | 3.615 |  | 0.0325 |  |  | 0 | 1472 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 4.235 | 10.295 | 3.615 |  | 0.0325 |  |  | 0 | 842 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 3.595 | 11.125 | 3.61 |  | 0.0325 |  |  | 0 | 19143 |  |  |  |  |  |  |  |  | 0.0325 | 0.0246
 | 5.97 | 10.195 | 3.465 |  | 0.0325 |  |  |  | 6881 |  |  |  |  |  |  |  |  | 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 |  |  | 31 |  |  |  |  |  |  |  | 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