Microsoft Excel 10.

0 Sensitivity Report
Worksheet: [Case 4.1 AMARCO.xls]Solution
Report Created: 5/23/2008 8:07:20 AM

Adjustable Cells
Final Reduced Objective Allowable
Cell Name Value Cost Coefficient Increase
$C$6 Values of Variables X11 2175.3424658 0 15 0.2411894276
$D$6 Values of Variables X12 0 -1.746229E-05 15.99998213 1.746229E-05
$E$6 Values of Variables X13 5424.6575342 0 16.5 0
$F$6 Values of Variables X21 0 -1.818849E-06 14.9999978 1.818849E-06
$G$6 Values of Variables X22 6780.8219178 0 16 0
$H$6 Values of Variables X23 6219.1780822 0 16.5 0.1929515421
$I$6 Values of Variables X31 8523.1164384 0 15 0
$J$6 Values of Variables X32 5476.8835616 0 16 2.425132E-06
$K$6 Values of Variables X33 0 -1.362414E-05 16.49998594 1.362414E-05
$L$6 Values of Variables X41 2301.5410959 0 15 0
$M$6 Values of Variables X42 742.29452055 0 16 7.275396E-06
$N$6 Values of Variables X43 356.16438356 0 16.5 0
$O$6 Values of Variables X1 6400 0 17 34.906862813
$P$6 Values of Variables X2 0 -1.9000000005 14.5 1.9000000005
$Q$6 Values of Variables X3 0 -3.7000000003 13.5 3.7000000003
$R$6 Values of Variables X4 7600 0 14 3

Constraints
Final Shadow Constraint Allowable
Cell Name Value Price R.H. Side Increase
$S$10 Gas A LHS 7.275958E-12 0.2 0 32630.136986
$S$11 Gas B LHS -7.275958E-12 0.2 0 11108.397856
$S$12 Gas C LHS 0 0.2 0 79200
$S$14 Alkalyte LHS 14000 17 14000 1E+030
$S$15 Cat Crack Gas LHS 13000 16.4 13000 925.69982132
$S$16 Str Run Gas LHS 14000 17.2 14000 694.27486599
$S$17 Isopentane LHS 11000 14 11000 1E+030
$S$19 Gas A LHS 13000 0 12000 1000
$S$20 Gas B LHS 13000 -2.2000000002 13000 3692.3076923
$S$21 Gas C LHS 12000 -0.1000000001 12000 7384.6153846
$S$22 Marketing LHS -2.046363E-12 -1.6000000001 0 7384.6153846
$S$24 Gas A LHS 13839.212329 0 0 13839.212329
$S$25 Gas B LHS 4273.1164384 0 0 4273.1164384
$S$26 Gas C LHS -1.818989E-12 0 0 13515.217391
 Allowable
Decrease
0
1E+030
1E+030
1E+030
1.818849E-06
0
2.425132E-06
0
1E+030
7.275396E-06
0
3.0206896556
0.1153846155
1E+030
1E+030
0.750000001

Allowable
Decrease
34523.116438
3255.7077626
5379.3103448
6400
5697.4885845
6000
7600
1E+030
456.30044771
1786.1520782
979.18955156
1E+030
1E+030
26000
Case 4.1 AMARCO
Alkylate Catalytic Cracked Gasoline Straight Run Gasoline Isopentane
blended in gasoline blended in gasoline blended in gasoline blended in gasoline
A B C A B C A B C A B
Variables X11 X12 X13 X21 X22 X23 X31 X32 X33 X41 X42
Values of Variables 2175 0 5425 0 6780.82 6219.18 8523 5477 0 2302 742
Objective function 15 16 16.5 15 16 16.5 15 16 16.5 15 16
Constraints
Reid Vapor Pressure
Gas A -2 1 -3 13
Gas B -2 1 -3 13
Gas C -2 1 -3
Availability
Alkalyte 1 1 1
Cat Crack Gas 1 1 1
Str Run Gas 1 1 1
Isopentane 1 1
Demand
Gas A 1 1 1 1
Gas B 1 1 1 1
Gas C 1 1 1
Marketing 1 -1 1 -1 1 -1 1 -1
Octane
Gas A 14 3 -6 15
Gas B 16.5 2 -4 17
Gas C 7.5 -7 -13
 Isopentane
blended in gasoline Feedstock
C not blended in gasoline
X43 X1 X2 X3 X4 LHS Sign RHS
356 6400 0 0 7600
16.5 17 14.5 13.5 14 816200

0 ≤ 0
7.28E-12 ≤ 0
13 -2.7E-12 ≤ 0

1 14000 ═ 14000
1 13000 ═ 13000
1 14000 ═ 14000
1 1 11000 ═ 11000

13000 ≥ 12000
13000 ≥ 13000
1 12000 ≥ 12000
1.59E-12 ≥ 0

13839.21 ≥ 0
4273.116 ≥ 0
8 4.55E-12 ≥ 0
Case 4.1 AMARCO
Alkylate Catalytic Cracked Gasoline Straight Run Gasoline Isopentane
blended in gasoline blended in gasoline blended in gasoline blended in gasoline
A B C A B C A B C A B
Variables X11 X12 X13 X21 X22 X23 X31 X32 X33 X41 X42
Values of Variables 0 4844 9156 9750 3250 0 3250 3583 7167 0 1322
Objective function 30 32 33 30 32 33 30 32 33 30 32
Constraints
Reid Vapor Pressure
Gas A -2 1 -3 13
Gas B -2 1 -3 13
Gas C -2 1 -3
Availability
Alkalyte 1 1 1
Cat Crack Gas 1 1 1
Str Run Gas 1 1 1
Isopentane 1 1
Demand
Gas A 1 1 1 1
Gas B 1 1 1 1
Gas C 1 1 1
Marketing 1 -1 1 -1 1 -1 1 -1
Octane
Gas A 14 3 -6 15
Gas B 16.5 2 -4 17
Gas C 7.5 -7 -13
 Isopentane
lended in gasoline Feedstock
C not blended in gasoline
X43 X1 X2 X3 X4 LHS Sign RHS
3062 0 0 0 6615
33 17 14.5 13.5 14 1538308

0.003793 ≤ 0
-0.00024 ≤ 0
13 0.000109 ≤ 0

1 14000 ═ 14000
1 13000 ═ 13000
1 14000 ═ 14000
1 1 11000 ═ 11000

13000 ≥ 12000
13000 ≥ 13000
1 19384.62 ≥ 12000
0.000124 ≥ 0

9750.009 ≥ 0
94576.92 ≥ 0
8 0.000254 ≥ 0
Case 4.1 AMARCO
Alkylate Catalytic Cracked Gasoline Straight Run Gasoline Isopentane
blended in gasoline blended in gasoline blended in gasoline blended in gasoline
A B C A B C A B C A B
Variables X11 X12 X13 X21 X22 X23 X31 X32 X33 X41 X42
Values of Variables 2175 0 5425 0 6780.82 6219.18 8523 5477 0 2302 742
Objective function 30 32 33 30 32 33 30 32 33 30 32
Constraints
Reid Vapor Pressure
Gas A -2 1 -3 13
Gas B -2 1 -3 13
Gas C -2 1 -3
Availability
Alkalyte 1 1 1
Cat Crack Gas 1 1 1
Str Run Gas 1 1 1
Isopentane 1 1
Demand
Gas A 1 1 1 1
Gas B 1 1 1 1
Gas C 1 1 1
Marketing 1 -1 1 -1 1 -1 1 -1
Octane
Gas A 14 3 -6 15
Gas B 16.5 2 -4 17
Gas C 7.5 -7 -13
 Isopentane
blended in gasoline Feedstock
C not blended in gasoline
X43 X1 X2 X3 X4 LHS Sign RHS
356 6400 0 0 7600
33 34 29 27 28 1632400

7.3E-12 ≤ 0
-7E-12 ≤ 0
13 0 ≤ 0

1 14000 ═ 14000
1 13000 ═ 13000
1 14000 ═ 14000
1 1 11000 ═ 11000

13000 ≥ 12000
13000 ≥ 13000
1 12000 ≥ 12000
-2E-12 ≥ 0

13839.2 ≥ 0
4273.12 ≥ 0
8 -2E-12 ≥ 0
Case 4.1 AMARCO
Alkylate Catalytic Cracked Gasoline Straight Run Gasoline Isopentane
blended in gasoline blended in gasoline blended in gasoline blended in gasoline
A B C A B C A B C A B
Variables X11 X12 X13 X21 X22 X23 X31 X32 X33 X41 X42
Values of Variables 6775 0 5425 0 4780.82 6219.18 3117 5883 0 1762 990
Objective function 30 32 33 30 32 33 30 32 33 30 32
Constraints
Reid Vapor Pressure
Gas A -2 1 -3 13
Gas B -2 1 -3 13
Gas C -2 1 -3
Availability
Alkalyte 1 1 1
Cat Crack Gas 1 1 1
Str Run Gas 1 1 1
Isopentane 1 1
Demand
Gas A 1 1 1 1
Gas B 1 1 1 1
Gas C 1 1 1
Marketing 1 -1 1 -1 1 -1 1 -1
Octane
Gas A 14 3 -6 15
Gas B 16.5 2 -4 17
Gas C 7.5 -7 -13
 Isopentane
blended in gasoline Feedstock
C not blended in gasoline
X43 X1 X2 X3 X4 LHS Sign RHS
356 0 0 0 7892
33 34 29 27 28 1339523
0

4.81E-08 ≤ 0
2.36E-09 ≤ 0
13 9.09E-13 ≤ 0

1 12200 ═ 12200
1 11000 ═ 11000
1 9000 ═ 9000
1 1 11000 ═ 11000

11653.85 ≥ 12000
11653.85 ≥ 13000
1 12000 ≥ 12000
-2.17E-08 ≥ 0

102578.2 ≥ 0
2857.251 ≥ 0
8 6.82E-12 ≥ 0
Case 4.1 AMARCO
Alkylate Catalytic Cracked Gasoline Straight Run Gasoline Isopentane
blended in gasoline blended in gasoline blended in gasoline blended in gasoline
A B C A B C A B C A B
Variables X11 X12 X13 X21 X22 X23 X31 X32 X33 X41 X42
Values of Variables 2175 0 5425 0 6780.8 6219.2 8523 5477 0 2302 742
Objective function 10 11 11.5 10 11 11.5 10 11 11.5 10 11
Constraints
Reid Vapor Pressure
Gas A -2 1 -3 13
Gas B -2 1 -3 13
Gas C -2 1 -3
Availability
Alkalyte 1 1 1
Cat Crack Gas 1 1 1
Str Run Gas 1 1 1
Isopentane 1 1
Demand
Gas A 1 1 1 1
Gas B 1 1 1 1
Gas C 1 1 1
Marketing 1 -1 1 -1 1 -1 1 -1
Octane
Gas A 14 3 -6 15
Gas B 16.5 2 -4 17
Gas C 7.5 -7 -13
 Isopentane
blended in gasoline Feedstock
C not blended in gasoline
X43 X1 X2 X3 X4 LHS Sign RHS
356 6400 0 0 7600
11.5 17 14.5 13.5 14 626200

7.28E-12 ≤ 0
5.46E-12 ≤ 0
13 3.64E-12 ≤ 0

1 14000 ═ 14000
1 13000 ═ 13000
1 14000 ═ 14000
1 1 11000 ═ 11000

13000 ≥ 12000
13000 ≥ 13000
1 12000 ≥ 12000
1.59E-12 ≥ 0

13839.2 ≥ 0
4273.117 ≥ 0
8 0 ≥ 0
Case 4.1 AMARCO
Alkylate Catalytic Cracked Gasoline Straight Run Gasoline Isopentane
blended in gasoline blended in gasoline blended in gasoline blended in gasoline
A B C A B C A B C A B
Variables X11 X12 X13 X21 X22 X23 X31 X32 X33 X41 X42
Values of Variables 0 0 7600 3250 9750 0 8125 3250 2625 1625 0
Objective function 10 11 11.5 10 11 11.5 10 11 11.5 10 11
Constraints
Reid Vapor Pressure
Gas A -2 1 -3 13
Gas B -2 1 -3 13
Gas C -2 1 -3
Availability
Alkalyte 1 1 1
Cat Crack Gas 1 1 1
Str Run Gas 1 1 1
Isopentane 1 1
Demand
Gas A 1 1 1 1
Gas B 1 1 1 1
Gas C 1 1 1
Marketing 1 -1 1 -1 1 -1 1 -1
 Isopentane
blended in gasoline Feedstock
C not blended in gasoline
X43 X1 X2 X3 X4 LHS Sign RHS
1775 6400 0 0 7600
11.5 17 14.5 13.5 14 626200

0 ≤ 0
0 ≤ 0
13 0 ≤ 0

1 14000 ═ 14000
1 13000 ═ 13000
1 14000 ═ 14000
1 1 11000 ═ 11000

13000 ≥ 12000
13000 ≥ 13000
1 12000 ≥ 12000
0 ≥ 0
Case 4.1 AMARCO
Alkylate Catalytic Cracked Gasoline Straight Run Gasoline Isopentane
blended in gasoline blended in gasoline blended in gasoline blended in gasoline
A B C A B C A B C A B
Variables X11 X12 X13 X21 X22 X23 X31 X32 X33 X41 X42
Values of Variables 3133 684.2 6316 2250 6328.95 4421.05 6750 5987 1263 867 0
Objective function 15 16 16.5 15 16 16.5 15 16 16.5 15 16
Constraints
Reid Vapor Pressure
Gas A -1 2 -2 14
Gas B -1 2 -2 14
Gas C -1 2 -2
Availability
Alkalyte 1 1 1
Cat Crack Gas 1 1 1
Str Run Gas 1 1 1
Isopentane 1 1
Demand
Gas A 1 1 1 1
Gas B 1 1 1 1
Gas C 1 1 1
Marketing 1 -1 1 -1 1 -1 1 -1
Octane
Gas A 14 3 -6 15
Gas B 16.5 2 -4 17
Gas C 7.5 -7 -13
 Isopentane
blended in gasoline Feedstock
C not blended in gasoline
X43 X1 X2 X3 X4 LHS Sign RHS
0 3867 0 0 10133
16.5 17 14.5 13.5 14 808600

-7.28E-12 ≤ 0
-3.64E-12 ≤ 0
14 -2.73E-12 ≤ 0

1 14000 ═ 14000
1 13000 ═ 13000
1 14000 ═ 14000
1 1 11000 ═ 11000

13000 ≥ 12000
13000 ≥ 13000
1 12000 ≥ 12000
0 ≥ 0

23116.67 ≥ 0
-7.28E-12 ≥ 0
8 -7.28E-12 ≥ 0
Case 4.1 AMARCO
Alkylate Catalytic Cracked GasolineStraight Run Gasoline Isopentane
blended in gasoline blended in gasoline blended in gasoline blended in gasoline
A B C A B C A B C A B
Variables X11 X12 X13 X21 X22 X23 X31 X32 X33 X41 X42
Values of Variables 2175 0 5425 0 6780.8 6219.2 8523 5477 0 2302 742
Objective function 15 16 16.5 15 16 16.5 15 16 16.5 15 16
Constraints
Reid Vapor Pressure
Gas A -2 1 -3 13
Gas B -2 1 -3 13
Gas C -2 1 -3
Availability
Alkalyte 1 1 1
Cat Crack Gas 1 1 1
Str Run Gas 1 1 1
Isopentane 1 1
Demand
Gas A 1 1 1 1
Gas B 1 1 1 1
Gas C 1 1 1
Marketing 1 -1 1 -1 1 -1 1 -1
Octane
Gas A 14 3 -6 15
Gas B 16.5 2 -4 17
Gas C 7.5 -7 -13

New MKT constraint

1 1 -1 1 1 -1 1 1 -1 1 1
 Isopentane
blended in gasoline Feedstock
C not blended in gasoline
X43 X1 X2 X3 X4 LHS Sign RHS
356 6400 0 0 7600
16.5 17 14.5 13.5 14 816200

7.28E-12 ≤ 0
3.64E-12 ≤ 0
13 8.19E-12 ≤ 0

1 14000 ═ 14000
1 13000 ═ 13000
1 14000 ═ 14000
1 1 11000 ═ 11000

13000 ≥ 12000
13000 ≥ 13000
1 12000 ≥ 12000
-1.59E-12 ≥ 0

13839.21 ≥ 0
4273.116 ≥ 0
8 3.64E-11 ≥ 0

-1 14000 ≥ 0