Spreadsheet: theresa_staab__39623__Enron Invoice Check
Sheet: June01

Greeley Gas Company
Enron Worksheet
Northeast Colorado
June, 2001
Gas Cost Section
 |  |  |  |  |  |  |  |  |  |  | Day | Qty | Price | Amt.
A. Baseload Volume and Cost - System Supply |  |  |  |  |  |  |  |  |  |  | 1 | 1000 | 2.68
 |  |  |  |  |  |  |  |  |  |  | 2 | 1000 | 2.62
 |  |  |  |  |  |  |  |  |  |  | 3 | 1000 | 2.62
 | Baseload Price |  |  |  |  |  |  |  |  |  | 4 | 1000 | 2.62
 | CIG: Rocky Mountian Index Price |  |  | 2.43 |  |  |  |  |  |  | 5 | 1000 | 2.76
 | Discount |  |  | -0.0125 |  |  |  |  |  |  | 6 | 1000 | 2.84
 |  |  |  |  |  |  |  |  |  |  | 7 | 3000 | 2.57
 |  |  |  |  |  |  |  |  |  |  | 8 | 3000 | 2.205
 |  |  |  |  |  |  |  |  |  |  | 9 | 3000 | 1.625
 | Baseload | Days in | Monthly |  | Baseload |  |  |  |  |  | 10 | 3000 | 1.625
 | Nomination | Month | [NAME] | Rate | Amount |  |  |  |  |  | 11 | 3000 | 1.625
 | 2637 | 30 |  |  |  |  | Daily Deliveries to Owl Creek=2,600 |  |  |  | 12 | 3000 | 2.22
 |  |  |  |  |  |  |  |  |  |  | 13 | 3000 | 2.495
 |  |  |  |  |  |  |  |  |  |  | 14 | 1500 | 2.855
[NAME] and Cost - System Supply (See Daily Swing Pricing Sheet For Details) |  |  |  |  |  |  |  |  |  |  | 15 | 1500 | 2.885
 |  |  |  |  |  |  |  |  |  |  | 16 | 1500 | 2.26
 |  |  | Total |  |  |  |  |  |  |  | 17 | 1500 | 2.26
 |  |  | Swing |  | Swing |  |  |  |  |  | 18 | 1500 | 2.26
 |  |  | [NAME] | Rate | Amount |  |  |  |  |  | 19 | 1500 | 3.07
 |  |  | 53248 |  |  |  | Total Swing deliveries to Owl Creek=52,499 |  |  |  | 20 | 1500 | 2.995
 |  |  |  |  |  |  |  |  |  |  | 21 | 1500 | 2.5
 |  |  |  |  |  |  |  |  |  |  | 22 | 1500 | 2.19
A. Baseload Volume and Cost - Planned Storage |  |  |  |  |  |  |  |  |  |  | 23 | 1500 | 2.02
 |  |  |  |  |  |  |  |  |  |  | 24 | 1500 | 2.02
 |  |  |  |  |  |  |  |  |  |  | 25 | 1500 | 2.02
 | Baseload Price |  |  |  |  |  |  |  |  |  | 26 | 1499 | 2.68
 | CIG: Rocky Mountian Index Price |  |  | 2.43 |  |  |  |  |  |  | 27 | 1500 | 2.17
 | Discount |  |  | -0.0125 |  |  |  |  |  |  | 28 | 1500 | 2.33
 |  |  |  |  |  |  |  |  |  |  | 29 | 1500 | 2.3
 |  |  |  |  |  |  |  |  |  |  | 30 | 1500 | 2.3
 | Planned |  | Planned |  |  |  |  |  |  |  | 31
 | Daily | Days in | Monthly |  | Storage
 | Injections | Month | Injections | Rate | Amount
 | 5074 | 30 |  |  |  |  | Daily Deliveries to Owl Creek=5,000
Total Gas Costs - System Supply & Storage
Transportation Section
A. Colorado Interstate Gas - Contract No. 33222000
Demand Charges
Demand Capacity |  | 20000 |  |  |  |  | CIG Fuel | 0
Demand Rate |  | 0.075 |  |  |  |  | CIG L&U | 0.0078157
Days in Month |  | 30 |  |  |  |  | CIG Fuel & LU Deductions
 |  |  |  |  |  |  | CIG Fuel & LU Coefficent
Monthly Demand Charge
 |  |  |  |  |  |  | Delivered at WIC Baxter
Third Party Utilization Volumes |  | 43014 |  |  |  |  | Delivered into CIG
Third Party Utilization Rate |  | -0.01 |  |  |  |  | Divided by Co-efficient
Third Party Utilization Credits
Total Monthly Reservation Charges
Commodity Charges
Commodity Volumes
Commodity Rate |  | 0.0245
Commodity ACA |  | 0.0022
CIG Commodity Rate
Monthly Commodity Charge
Total CIG Transportation Charges
B. Wyoming Interstate Gas - Contract No. 41059001
Demand Charges
Demand Capacity |  | 20000
Demand Rate |  | 2.9414 |  |  |  |  | WIC Fuel | 0.0063233
[NAME] |  | -0.0988 |  |  |  |  | WIC L&U | 0
 |  |  |  |  |  |  | WIC Fuel & LU Deductions
Reservation Charge |  |  |  |  |  |  | WIC Fuel & LU Co-efficent
[NAME]
Monthly Demand Fee |  |  |  |  |  |  | Deliveries at Owl Creek
 |  |  |  |  |  |  | Baseload Gas | 80600
Third Party Utilization Volumes |  | 0 |  |  |  |  | Swing Gas | 52499
Third Party Utilization Rate |  | -0.01 |  |  |  |  | Storage Injections | 150000
Third Party Utilization Credits
 |  |  |  |  |  |  | Delivered at WIC Baxter
Total Monthly Reservation Charges |  |  |  |  |  |  | Divided by Co-efficient
Commodity Charges
Commodity |  | 0.0026
Comodity ACA |  | 0.0022
Commodity GRI |  | 0.007
Commodity Rate
Commodity Volumes
Monthly Commodity Charge
Total WIC Transportation Charges
Total Transportation Costs
Young Storage and Associated Transportation (Per Storage Plan)
A. Colorado Interstate Gas - Contract No. 33191011
Demand Charges
Demand Capacity |  | 28679 |  |  |  |  | Deliveries to Owl Creek | 150000
Demand Rate |  | 2.941 |  |  |  |  | PSCo Fuel | 0
[NAME] |  | 0 |  |  |  |  | Deliveries to CIG
 |  |  |  |  |  | 0.0366 | CIG Fuel
Reservation Charge |  |  |  |  |  |  | Deliveries to YCS
[NAME]
Monthly Demand Fee |  |  |  |  |  | 0.0266 | Young Injection Fuel
 |  |  |  |  |  |  | Net Planned Injections
Commodity Charges
Commodity |  | 0.0245
Comodity ACA |  | 0
Commodity GRI |  | 0
Commodity Rate
Planned Net Storage Injections
Monthly Commodity Charge
Total CIG Transportation Charges
[NAME] No. 17003002
Demand Charges
Demand Capacity |  | 28219
Storage Capacity |  | 747811
Demand Capacity Fee |  | 1.562
Storage Capacity Fee |  | 0.059
Reservation Charge
Storage Charge
Monthly Demand Fee
Commodity Charges
Injection Fee |  | 0.02
Comodity ACA |  | 0.0022
Planned Net Storage Injections
Monthly Commodity Charge
Total Young Storage Charges
Total Young Storage and Associated Transportation Costs
Total Commodity Gas,Transportation, & Storage  Costs
Adjustment - Demand Fees on CIG 33222000
Per Enron Invoice |  |  |  |  | 958475.12
Difference
Reconcilation Items
CIG Demand Fee |  |  |  |  | 0
Penalty Credit |  |  |  |  | 0
Gas Cost Calculations (1) |  |  |  |  | 0
Unknown Amount
(1)  Gas Costs Calculations
Greeley (Commodity Gas Costs + CIG & WIC Variable Transpt Costs) |  |  |  |  | 0
Enron Invoice |  |  |  |  | 0
Difference