Question: Implement the following LP problem in a spreadsheet. Use Solver to solve the problem and create a Sensitivity Report. Use this information to answer the

Implement the following LP problem in a spreadsheet. Use Solver to solve the problem and create a Sensitivity Report. Use this information to answer the following questions:
MAX: 5x1+3x2
Subject to: 2x1+4x220
3x1+5x215
x1,x20
The objective function coefficient for variable x1 can decrease by or increase by without changing the optimal solution.
(b) Is the optimal solution to this problem unique, or are there alternate optimal solutions?
Some of the allowable increase or decrease values for the objective coefficients are zero, so there are alternate optimal solutions.
We cannot determine if the optimal solution is unique based on our sensitivity report because the solution is degenerate.
None of the allowable increase or decrease values for the RHS values are zero, so the optimal solution is unique.
Some of the allowable increase or decrease values for the RHS values are zero, so there are alternate optimal solutions.
None of the allowable increase or decrease values for the objective coefficients are zero, so the optimal solution is unique.
(c) How much does the objective function coefficient for variable x2 have to increase before it enters the optimal solution at a strictly positive level? (Round your answer to three decimal places.)
(d) What is the optimal objective function value if x2 equals 1?(Round your answer to three decimal places.)
(e) What is the optimal objective function value if the RHS value for the second constraint changes from 15 to 20?(Round your answer to three decimal places.)
(f) Is the current solution still optimal if the coefficient for x2 in the second constraint changes from 5 to 1? Explain. (Round your answer to three decimal places.)
If we change this coefficient from 5 to 1, then the new reduced cost for x2 for our current solution would be
. Therefore, it -- Select---vv be profitable to increase the value of x2 and the current solution would
be optimal.
 Implement the following LP problem in a spreadsheet. Use Solver to

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!