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

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

MAX: 2X1 + 4X2

Subject to:

X1 + 2X2 8

X1 + 2X2 12

X1 + X2 2

X1, X2 0

a. Which of the constraints are binding at the optimal solution?

b. Is the optimal solution to this problem unique, or is there an alternate optimal solution?

c. What is the optimal solution to this problem if the value of the objective function coefficient for variable X1 is zero?

d. How much can the objective function coefficient for variable X2 decrease before changing the optimal solution?

e. Given the objective in this problem, if management could increase the RHS value for any of the constraints for identical costs, which would you choose to increase and why?

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!

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: 4X1 + 2X2 Subject...

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: 4 X 1 + 4 X 2...

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: 4 X 1 + 3 X 2...

3. 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: 4X, + 2x2 Subject...

Please show how to do in excel 1. 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...

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: 4X1 + 2X2 Subject...

Hide Assignment Information Instructions Q 1 . 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: 4 X 1 + 4 X 2...

A flywheel is rigidly attached to a shaft of 30-mm radius that can roll along parallel rails as shown. When released from rest, the system rolls 5 m in 40 s. Determine the centroidal radius of...

Let's say I add a small amount of hydrochloric acid to the buffer outlined in the previous problem. What buffer component would react with the added acid? O H30+ ym O H20 nsv O H2S HS OH

If 1 euro can buy $ 1 . 3 5 : $ 1 can buy 1 . 3 5 euros. 1 euro is worth less than $ 1 . $ 1 can buy 0 . 7 4 euro. $ 1 can buy 0 . 2 6 euro.

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...