Variable Cells Cell Name $B$8 Fabricate A $C$8 Fabricate B $D$8 Fabricate C $E$8 Fabricate D $B$9 Purchase A $C$9 Purchase B $D$9 Purchase $E$9 Purchase Final Value 100.00 43.33 0.00 13.33 0.00 36.67 60.00 26.67 Reduced Objective Cost Coefficient 0.00 200 0.00 300 3.89 250 0.00 12.22 250 0.00 360 0.00 305 0.00 220 Allowable Increase 12.22 10.00 1E+30 4.38 1E+30 15.71 3.89 35.00 Allowable Decrease 237.78 15.71 3.89 35.00 12.22 10.00 305.00 4.38 180 Constraints Cell Name $B$10 Delivered Amount A $C$10 Delivered Amount B $D$10 Delivered Amount C $E$10 Delivered Amount D $F$16 Fab Step 1 Hrs Used $F$17 Fab Step 2 Hrs Used Final Value 100 80 60 40 220 350 Shadow Constraint Price R.H. Side 237.78 100 360.00 80 305.00 60 220.00 40 -6.67 220 -15.56 350 Allowable Increase 55.71 1E+30 1E+30 1E+30 40.00 30.00 Allowable Decrease 47.14 36.67 60.00 26.67 20.00 60.00