Question: Given the following sensitivity report from Excel SOLVER for a maximization LP problem: Variable Cells table [ [ Cell , Name, table [

Given the following sensitivity report from Excel SOLVER for a maximization LP problem:
Variable Cells
\table[[Cell,Name,\table[[Final],[Value]],\table[[Reduced],[Cost]],\table[[Objective],[Coefficient]],\table[[Allowable],[Increase]],\table[[Allowable],[Decrease]]],[C$4,x1,062,0,3,1,1.5],[$D$4,X2,7.2,0,3,3,0.75]]
Constraints
\table[[Cell,Name,\table[[Final],[Value]],\table[[Shadow],[Price]],\table[[Constraint],[R.H. Side]],\table[[Allowable],[Increase]],\table[[Allowable],[Decrease]]],[$E$8,,15,0.6,15,1,9],[$E$9,,24,0.6,24,36,1.5]]
(1) What is the current optimal solution, that is,x1=?x2=? What is the current optimal objective value, that is,z=s?
(2) What is the new optimal objective value (z) if the right-hand-side coefficient of the first constraint (b1) changes to 13?
(3) What is the new optimal objective value (z) if the right-hand-side coefficient of the second constraint (b2) changes to 30?
(4) For what range of the objective coefficient of x1(cl) does the current optimal solution remain optimal?
(5) If the objective coefficient of x2(c2) changes to 3.5, find the new optimal solution ) and the new optimal objective value (z).
 Given the following sensitivity report from Excel SOLVER for a maximization

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 General Management Questions!