Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed
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:Subjectto:4X1+2X22X1+4X2203X1+5X215X1,X20 a. What rance of values can the objective function coefficient for variable X1 assume without changing the optimal solution? b. Is the optimal solution to this problem unique, or are there alternate optimal solutions? 1. Unique. Only available solution. II. Not unique. One alternative solution. III. Not unique. Two alternative solutions. c. How much does the objective function coefficient for variable X2 have to increase before it enters the optimal solution at a strictly positive lever? Round vour answer to two decimal places. It has to increase by at least d. What is the optimal objective function value if X2 equals 1? Round your answer to two decimal places. e. What is the optimal objective function value if the AHS 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 1 ? the solution would be optimal. We would to re-solve the problem to find the new optimal solution

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Logistics And Supply Chains In Emerging Markets

Authors: John Manners Bell, Thomas Cullen, Cathy Roberson

1st Edition

0749472405, 978-0749472405

More Books

Students also viewed these General Management questions