Sensitivity Report Variable Cells Cell $C$3 $C$4 $C$5 $C$6 Name X1 X2 X3 X4 Final Reduced Objective Value Cost Coefficient 400 0 15 200 0 10 400 0 9 0 7 7 Allowable Increase 1E+30 2 1E+30 1E+30 Allowable Decrease 3.5 1E+30 4 7 Constraints Final Shadow Constraint Allowable Cell Name Value Price R.H. Side Increase $K$3 Production 1000 30 1000 66.67 $K$4 Labor 3000 0 3300 1E+30 $K$5 Material 4000 -5 4000 300 $K$6 Plant 3 Min 400 4 400 100 Allowable Decrease 100 300 200 400 Using the report ONLY, let's answer the following questions: Q: A new plant is being designed that will use only one hour of labor and 4 units of raw material What is the maximum cost it can have in order for us to consider using it? By how much can the costs at plant 1 increase before we would not produce there? Sensitivity Report Variable Cells Cell $C$3 $C$4 $C$5 $C$6 Name X1 X2 X3 X4 Final Reduced Objective Value Cost Coefficient 400 0 15 200 0 10 400 0 9 0 7 7 Allowable Increase 1E+30 2 1E+30 1E+30 Allowable Decrease 3.5 1E+30 4 7 Constraints Final Shadow Constraint Allowable Cell Name Value Price R.H. Side Increase $K$3 Production 1000 30 1000 66.67 $K$4 Labor 3000 0 3300 1E+30 $K$5 Material 4000 -5 4000 300 $K$6 Plant 3 Min 400 4 400 100 Allowable Decrease 100 300 200 400 Using the report ONLY, let's answer the following questions: Q: A new plant is being designed that will use only one hour of labor and 4 units of raw material What is the maximum cost it can have in order for us to consider using it? By how much can the costs at plant 1 increase before we would not produce there