Question: 5) Answer the following questions using the sensitivity report shown below: a) Report the optimal solution and the optimal value of the objective function. what

 5) Answer the following questions using the sensitivity report shown below:

5) Answer the following questions using the sensitivity report shown below: 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 c) Considering "Steel" to be sunk Final Reduced Objective Allowable Allowable Cell Name Value cost, how much should the company Cost Coefficient increase Decrease Type pay for an additional 55 units of Type By "steel". (5 marks) Type C2 3.5 15.30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease Wood 1 32 1.5 32 20 Steel 2 40 2.5 30 30 hours 3 15 0 38 1E+30 25 7 4 0 0 0 -3.5 9 4 5 3 5 2 3 10 45 o un 5) Answer the following questions using the sensitivity report shown below: 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 c) Considering "Steel" to be sunk Final Reduced Objective Allowable Allowable Cell Name Value cost, how much should the company Cost Coefficient increase Decrease Type pay for an additional 55 units of Type By "steel". (5 marks) Type C2 3.5 15.30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease Wood 1 32 1.5 32 20 Steel 2 40 2.5 30 30 hours 3 15 0 38 1E+30 25 7 4 0 0 0 -3.5 9 4 5 3 5 2 3 10 45 o un

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!