Question: QUESTION 5: Sensitivity Analysis (25 Points) The following linear programming problem has been solved by Excel's Solver. Use the output to answer the questions. Consider
QUESTION 5: Sensitivity Analysis (25 Points) The following linear programming problem has been solved by Excel's Solver. Use the output to answer the questions. Consider the following linear program MAX 3x1 +4n IL 11+30 312 21+x258 Variate Cells Final Reduced Objective Allowable Name Value Cost Coefficient incase XI 24 0 3 5 3.2 0 4 5 Mewable Decrease 1.67 2.5 ns3 Constraints Final Shadow Constraint Allowable Allowable Name Value Price R. Side Increase Decrease 3 12 1 12 12 3 2 3 1 8 1 3 24 0 3 1E 30 0.6 11, 2220 a What is the optimal solution including the optimal value of the objective function? b. Suppose the profit oax is increased to $7. Is the above solution still optimal? If simultaneously the profit on it was raised to $55 and the profit oax) was reduced to $3, would the current solution still semain optimal? c
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
