Question: Answer the following questions using the sensitivity report shown below. a) Report the optimal solution and the objective function, what is the range of optimality

Answer the following questions using the sensitivity report shown below. a) Report the optimal solution and the objective function, what is the range of optimality for coefficient of x? (4 marks) b) Report the range of feasibility associated with each constraint and Explain what constraints are binding and which one(s) are non-binding. (5 marks) c) Will the optimal solution remain optimal if the coefficient of x changes to 7? Explain (1 marks) d) If the coefficient of changes to 2 and the coefficient of y changes to 6 simultaneously, will the optimal solution remain optimal? Explain (4 marks) Variable Cells Final Reduced Allowable Allowable Objective Coefficient Cell Name Value Cost Increase Decrease Type A 10 0 3 8 1 Type B Y 5 0 5 2 5 Type C z 0 -6.5 2 6.5 1E+30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease Wood 1 15 1 15 20 10 Steel 30 1.5 30 110 30 2. 3 hours 15 0 70 1E+30 55
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
