A B C D E F
1 GAS BLENDING
2 GASSO
3 INPUTS Maximum Octane Vapor Cost
4 Available Rating Pressure $/barrel
5 Isopentane 220,000 85 5.2 $22.55
6 Cat Cracked 200,000 95 4.7 $29.30
7
8 OUTPUTS Regular Plus Premium
9 Minimum Required 85,000 210,000 120,000
10 Minimum Octane 87 89 92
11 Max Vapor Pressure 5.3 5.0 4.8
12 Process $/barrel $1.80 $2.10 $2.50
13
14 Costs Regular Plus Premium
15 Isopentane $24.35 $24.65 $25.05 Total
16 Cat Cracked $31.10 $31.40 $31.80 $11,582,000
17
18 Variables Regular Plus Premium Totals Max Avail
19 Isopentane 68,000 126,000 24,000 218,000 220,000
20 Cat Cracked 17,000 84,000 96,000 197,000 200,000
21 Totals 85,000 210,000 120,000 415,000
22 Min Req'd 85,000 210,000 120,000
23 Octane >= 0 0 0 120,000
24 Vap Press = 0 Regular 0 1 0 30000 20000
21 $C$23 Octane >= 0 Plus 0 0 0 0 1E+30
22 $D$23 120,000
Octane >= 0 Premium 0 0 120000 1E+30
23 $B$24 -17,000
Vap Press Totals Regular 85,000 $25.70 0 85,000 87,500
41 > Totals Plus 210,000 $27.35 0.00 210,000 213,333
42 > Totals Premium 120,000 $30.45 0.00 120,000 123,750
43 > Octane >= 0 Regular 0 $0.68 -20,000 0 30,000
44 > Octane >= 0 Plus 0 $0.00 -1E+30 0 0
45 > Octane >= 0 Premium 120,000 $0.00 -1E+30 0 120,000
46 = 0 =SUMPRODUCT(B19:B20,$C$5:$C$6)-B21*C10
24 Vap Press = 0 Regular
21 =SUM(B21:D21) $C$23 Octane >= 0 Plus
22 $D$23 Octane >= 0 Premium
23 $B$24 Vap Press =I17 =+J17
41 > =I18 =+J18
42 > =I19 =+J19
43 > =I20 =+J20
44 > =I21 =+J21
45 > =I22 =+J22
46 < =I23 =+J23
47 < =I24 =+J24
48 < =I25 =+J25
49 Minimize =SUMPRODUCT(I30:I35,L30:L35)
J K L M N
1
2
3 Final Reduced Objective Allowable Allowable
4 Value Cost Coefficient Increase Decrease
5 68000 0 24.350000000011 6.75000000066917 32.1250000001643
6 126000 0 24.6500000001131 6.74999999992591 45.5833333334725
7 24000.0000000005 0 25.0500000002354 6.74999999980681 152.250000000593
8 17000 0 31.1000000006136 1E+30 6.75000000065473
9 83999.9999999997 0 31.4000000000385 1E+30 6.74999999992581
10 96000.0000000003 0 31.8000000000657 1E+30 6.74999999981179
11
12
13 Final Shadow Constraint Allowable Allowable
14 Value Price R.H. Side Increase Decrease
15 218000 0 220000 1E+30 2000.00000000225
16 197000 0 200000 1E+30 2999.99999999782
17 85000 25.7000000001315 85000 2500.0000000071 85000
18 210000 27.3500000000877 210000 3333.33333333709 209999.999999964
19 120000.000000001 30.4500000000912 120000 3750.00000000173 120000.000000019
20 0 0.675000000038028 0 30000.0000015061 20000.0000009128
21 0 0 0 0 1E+30
22 119999.999999998 0 0 120000.000000381 1E+30
23 -17000 0 0 1E+30 17000
24 -13.4999999996074
2.3283064365387E-10 0 0 1500.0000000263
25 -13.4999999998621
2.3283064365387E-10 0 999.999999977072 1499.99999997396
26
27
28 Marginal Lower Original Upper
29 Value Bound Value Bound
30 =+K5 =+L5-N5 =+L5 =+L5+M5
31 =+K6 =+L6-N6 =+L6 =+L6+M6
32 =+K7 =+L7-N7 =+L7 =+L7+M7
33 =+K8 =+L8-N8 =+L8 =+L8+M8
34 =+K9 =+L9-N9 =+L9 =+L9+M9
35 =+K10 =+L10-N10 =+L10 =+L10+M10
36 Marginal Lower Original Upper
37 Value Bound Value Bound
38 =+K15 =+L15-N15 =+L15 =+L15+M15
J K L M N
39 =+K16 =+L16-N16 =+L16 =+L16+M16
40 =+K17 =+L17-N17 =+L17 =+L17+M17
41 =+K18 =+L18-N18 =+L18 =+L18+M18
42 =+K19 =+L19-N19 =+L19 =+L19+M19
43 =+K20 =+L20-N20 =+L20 =+L20+M20
44 =+K21 =+L21-N21 =+L21 =+L21+M21
45 =+K22 =+L22-N22 =+L22 =+L22+M22
46 =+K23 =+L23-N23 =+L23 =+L23+M23
47 =+K24 =+L24-N24 =+L24 =+L24+M24
48 =+K25 =+L25-N25 =+L25 =+L25+M25
49 Cost