Page 179 -

BLENDING, DIET AND FEED-MIX PROBLEMS 159

Figure 4.4 (continued)

ADJUSTABLE CELLS
Final Reduced Objective Allowable Allowable
Name Value Cost Coefficient Increase Decrease
----- ---------- ----------- ---------- ---------- ----------
P1 6824.858757 0 10 0.35 1.692307692
P2 1751.412429 0 9 1.833333333 0.304347826
b1 6100 0 0 7.457627119 0.790960452
b2 4559.887006 0 0 0 0.663507109
b3 8050.847458 0 0 1.794871795 4.782608696
b4 1549.152542 0 0 7.373737374 1.794871795
t12 0 -8.248587571 0 8.248587571 1E+30
t13 400 0 0 1E+30 7.457627119
t23 650.8474576 0 0 0 4.782608696
t24 149.1525424 0 0 4.782608696 0
t34 0 0 0 0 1E+30
t41 0 -7.457627119 0 7.457627119 1E+30
t42 0 -8.248587571 0 8.248587571 1E+30

CONSTRAINTS
Final Shadow Constraint Allowable Allowable
Name Value Price R.H. Side Increase Decrease
--------- ----------- ---------- --------- ---------- ----------
Dept. 1 1.81899E-12 0.790960452 0 536.9668246 338.4615385
Dept. 2 0 0 0 4559.887006 640.1129944
Dept. 3 1.81899E-12 8.248587571 0 1192.307692 2266
Dept. 4 -2.27374E-13 8.248587571 0 133.3333333 581.8181818
Balance 1 6500 0.790960452 6500 536.9668246 338.4615385
Balance 2 5359.887006 0 6000 1E+30 640.1129944
Balance 3 7000 8.248587571 7000 1192.307692 2266
Balance 4 1400 8.248587571 1400 133.3333333 581.8181818
Transfer 1 400 7.457627119 400 266.6666667 400
Transfer 2 800 8.248587571 800 892.1259843 581.8181818
Transfer 3 0 0 100 1E+30 100
Transfer 4 0 0 200 1E+30 200

EXCEL file
The total number of litres of each type of fuel produced is the sum of the number of
McCormick
litres produced using each of the three petroleum components.
Total litres Produced

Regular fuel ¼ x 1r þ x 2r þ x 3r
Premium fuel ¼ x 1p þ x 2p þ x 3p
The total litres of each petroleum component are calculated in a similar fashion.
Total Petroleum Component Use

Component 1 ¼ x 1r þ x 1p
Component 2 ¼ x 2r þ x 2p
Component 3 ¼ x 3r þ x 3p

Copyright 2014 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s). Editorial review has
deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.