Variable Cells Cell Name Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease $C$2 Ceramic Bowl 100 0 120 200 13 SD$2 Aluminum Steel Water Bottle 120 0 180 50 250 SE$2 Coffee Cup 120 0 220 50 121 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$7 (C1) Stamping (mins) $F$8 (C2) Finishing (mins) $F$9 (C3) Packaging (mins) 2000 2.5 2000 236 91 2020 0 2200 1E+30 180 2200 25 2200 50 533 $F$10 (C4) Min. Total Supply (units) 340 0 300 40 1E+30 $F$11 (C5) Water Bottle > Coffee Cup $F$12 (C6) At least 25% for Ceramic Bowl $F$13 (C7) Aluminum Steel Available 0 -85 0 37.5 77 15 0 1440 0 1500 1E+30 60