Variable Cells Cell $C$5 SD$5 SE$5 $C$6 $D$6 SES6 SC$7 SD$7 SES7 SCS8 $D$8 SE$8 Constraints Name Brazilian Special Brazilian Dark Brazilian Regular Mocha Special Mocha Dark Mocha Regular Colombian Special Colombian Dark Colombian Regular Mild Special Mild Dark Mild Regular Brazilian Use Mocha Use Colombian Use Mild Use O Special Brazilian Final Reduced Objective Allowable Value Coefficient Increase Cost 3 4.5 3 0 3.25 1.18 1.75 8.88178E-16 3.75 3 2.5 8.88178E-16 6.167 1E+30 4.625 4.625 1E+30 10.625 2.5 O Regular 0 64.8 Colombian 45.2 60 0 10 80 Final Shadow Cell Name Value Price -7.625 -3 SGS13 Special requirements 0 SGS14 Regular requirements 0 SGS15 Dark requirements SGS16 Mocha requirements 0 SGS17 Regular requirements 0 21.6 0 3 3 $G$18 Mild requirements 3.8 0 $G$5 110 3.55 $G$6 70 2.8 SGS7 80 7.28 $G$8 150 0.85 60 7.2 82.8 0 0 -8.88178E-16 4.6 -4.6 0 0 1 3.6 2.35 0.85 4.8 3.55 2.05 Constraint Allowable R.H. Side Increase 0 8.44 0 10.00 0 21.60 19.00 3.17 3.80 190.00 3.73 13.33 90.00 0 0 110 70 80 150 Allowable Decrease 1E+30 8.88178E-16 1.181 6.167 1E+30 8.88178E-16 4.625 1E+30 W 1E+30 HADER 3 2.5 0.787 If the Corner Coffee Shop can acquire more of one of the additional types of coffee, it should be Allowable Decrease 13.33 3.17 1E+30 36 1E+30 60 10 6.03 21.11

If the Corner Coffee Shop can acquire more of one of the additional types of coffee, it should be Special Brazilian Regular Colombian If the Corner Coffee Shop can acquire more of one of the additional types of coffee, it should be Special Brazilian Regular Colombian