Harmanjeet Kauf.001 Siraz 5) Answer the following questions using the sensitivity report shown below: (12 min) a) Report the optimal solution and the optimal value of the objective function. what is the range of optimality for coefficient of y? (6 marks) b) Report and interpret the reduced cost associated with variable "z" and explain what constraints are binding and which one(s) are non-binding? (5 marks) Variable Cells Final Reduced Objective Allowable Allowable c) Considering. "Steel to be sunk cost, how much should the company Type Ax pay for an additional 55 units of Type By Type Cz "steel". (5 marks) Cell Name Value 7 4 0 Cost Coefficient increase Decrease 0 9 3 2 0 4 5 3 -3.5 5 3.5 1E+30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease Wood 1 32 1.5 32 20 10 Steel 2 40 2.5 30 45 30 hours 3 15 0 38 1E+30 25 Nm Harmanjeet Kauf.001 Siraz 5) Answer the following questions using the sensitivity report shown below: (12 min) a) Report the optimal solution and the optimal value of the objective function. what is the range of optimality for coefficient of y? (6 marks) b) Report and interpret the reduced cost associated with variable "z" and explain what constraints are binding and which one(s) are non-binding? (5 marks) Variable Cells Final Reduced Objective Allowable Allowable c) Considering. "Steel to be sunk cost, how much should the company Type Ax pay for an additional 55 units of Type By Type Cz "steel". (5 marks) Cell Name Value 7 4 0 Cost Coefficient increase Decrease 0 9 3 2 0 4 5 3 -3.5 5 3.5 1E+30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease Wood 1 32 1.5 32 20 10 Steel 2 40 2.5 30 45 30 hours 3 15 0 38 1E+30 25 Nm