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

Implement the following LP problem in a spreadsheet. Use Solver to solve

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: Subject to: 4X + 2X 2X, + 4X, 20 3X, +5X, 15 a. What range of values can the objective function coefficient for variable X assume without changing the optimal solution? Select b. Is the optimal solution to this problem unique, or are there alternate optimal solutions? 1. Unique. Only available solution. 11. Not unique. One alternative solution. 11. Not unique. Two alternative solutions. Select 1 c. How much does the objective function coefficient for variable Xy have to increase before it enters the optimal solution at a strictly positive level? Round your answer to two decimal places. It has to increase by at least d. What is the optimal objective function value if X2 equals 17 Round your answer to two decimal places. e. What is the optimal objective function value if the RHS value for the second constraint changes from 15 to 257 Round your answer to two decimal places. f. Is the current solution still optimal if the coefficient for X2 in the second constraint changes from 5 to 17 Select the solution would select be optimal. We would select 1 to re-solve the problem to find the new optimal solution. C

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!