gulf by cuiliqing

VIEWS: 6 PAGES: 2

									Microsoft Excel 9.0 Sensitivity Report
Worksheet: [Gulf Coast Oil - Linear optimisation.xls]Sheet1
Report Created: 2/19/02 01:11:25 PM


Adjustable Cells
                                       Final   Reduced Objective    Allowable   Allowable
   Cell              Name             Value      Cost   Coefficient Increase    Decrease
  $C$5    Domestic Blend Regular         83.33     0.00        530          12         360
  $D$5    Domestic Blend Midgrade     8,706.67     0.00        600         225 10.71428571
  $E$5    Domestic Blend Premium      1,210.00     0.00        750 41.12903226         225
  $C$6    Foreign Blend Regular          16.67     0.00        280          60       1E+30
  $D$6    Foreign Blend Midgrade      4,353.33     0.00        350         200 21.42857143
  $E$6    Foreign Blend Premium       3,630.00     0.00        500 33.33333333         200
  $E$7    Premium additive Premium        0.00 -4420.00     -28600        4420       1E+30

Constraints
                                       Final   Shadow Constraint Allowable      Allowable
   Cell              Name              Value    Price   R.H. Side   Increase    Decrease
  $C$14   Total amount Regular             100      -10        100 9257.142857         100
  $D$14   Total amount Midgrade         13,060        0        100       12960       1E+30
  $E$14   Total amount Premium           4,840        0        100        4740       1E+30
  $C$9    Total Octane Regular           8,700      -30          0        1000         200
  $D$9    Total Octane Midgrade      1,162,340      -30          0       23700 29022.22222
  $E$9    Total Octane Premium         454,960      -30          0        9075       64800
  $F$5    Domestic Blend Total       10,000.00   480.00     10000         5925        7200
  $F$6    Foreign Blend Total         8,000.00   590.00      8000        21600       2962.5
  $F$7    Premium additive Total             0        0         50       1E+30          50
Gulf Coast Oil - Linear optimisation
                                    Amounts ('000s Gals.)
Component                Octane       Regular Midgrade        Premium         Total     Avail.
Domestic Blend            85            83.33      8,706.67    1,210.00   10,000.00 10,000.00
Foreign Blend             97            16.67      4,353.33    3,630.00    8,000.00 8,000.00
Premium additive         900                                       0.00           0        50

Total Octane                              8,700   1,162,340    454,960
Minimum Octane Number                        87          89         94
Total Octane requ.                        8,700   1,162,340    454,960

Minimum Demand                             100        100           100
Total amount                               100     13,060         4,840
Price/gallon                              1.18       1.25          1.40
Revenue                                118,000 16,325,000     6,776,000 23,219,000

Component               Cost/gal.
Domestic Blend           0.65           54,167    5,659,333     786,500
Foreign Blend            0.90           15,000    3,918,000   3,267,000
Premium additive         30.00               0            0           0
                            Cost        69,167    9,577,333   4,053,500 13,700,000

                           Profit       48,833    6,747,667   2,722,500   9,519,000

								
To top