Part a.

Product 1 currently requires 6 hours of labor, 2 hours on machine 1, 5 hours on machine 2, and 20 feet of sheet metal. Company engineers believe the amount of labor required to make Product 1 will decrease over time. What would the labor requirement have to be to make Product 1 profitable? Briefly explain your reasoning.

Part b.

The company just received an order from their best customer for 10 units of Product 1. As specifically as possible, explain the impact of fulfilling this order. Also, briefly explain why the impact is either positive, negative or neutral.

Changing Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$4 Product 1 0 -30 110 30 1E+30 $C$4 Product 2 58 0 150 50 70 $D$4 Product 3 0 -13 100 13 1E+30 $E$4 Product 4 27 0 200 75 30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $G$8 Labor, Hours 1,000 7.5 1,000 1,250 470 $G$9 Machine 1, Hours 200 10.0 200 175 150 $G$10 Machine 2, Hours 300 15.0 300 20 10 $G$11 Sheet Metal, Feet 3,500 0.0 5000 1E+30 1,500