The sensitivity report using solver.

Question

Want to see the full answer?

Answer 1

Question

Chapter 4, Problem 8QP

Summary Introduction

To determine: The sensitivity report using solver.

a)

Summary Introduction

To determine: The change in the optimal solution when the profit of Bike R decreased to $35.

b)

Summary Introduction

To determine: The change in the optimal solution when the profit of Bike Z decreased to $35.

c)

Summary Introduction

To interpret: The shadow price for the supply of polymer.

d)

Summary Introduction

To determine: The justification for the given statement.

e)

Summary Introduction

To determine: The new optimal level of profit for the given condition.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Using Excel Solve the following LP Maximize $4x + $5y Subject to 2x + 3y ≤ 20 (labor, in hours) 6x + 6y ≤ 36 (materials, in pounds) 4x + 4y ≤ 40 (storage, in square feet) x, y ≥ 0 a) Write the original optimal solution and objective function value. b) What is the optimal solution and objective function value if you acquire 2 additional pounds of material? c) What is the optimal solution and objective function value if you acquire 1.5 additional hours of labor?

I will need the excel "solver" solution to be able to solve. #4) Solve the following LP Maximize $5x + $6y Subject to 2x + 3y ≤ 10 (labor, in hours) 6x + 6y ≤ 36 (materials, in pounds) 7x + 5y ≤ 40 (storage, in square feet) x, y ≥ 0 a) Write the original optimal solution and objective function value. b) What is the optimal solution and objective function value if you acquire 2 additional pounds of material? c) What is the optimal solution and objective function value if you acquire 1.5 additional hours of labor? d) What is the optimal solution and objective function value if you give up 1 hour of labor and get 1.5 pounds of material? e) What is the optimal solution and objective function value if you introduce a new product that has a profit contribution of $2? Each unit of this product will use 1 hour of labor, 1 pound of material, and 2 square feet of storage space.

Chapter 6. Solve the following Linear Program using the Solver method and answer the questions given below (round to two decimal places): Maximize 12A + 15B s.t. 3A + 7B <= 250 5A + 2B <= 200 B <= 25 A, B >= 0 a. The optimal value of A is 31.03 and the optimal value of B is 22.41. b. The maximized function yields a solution of 708.62. Chapter 7. For the problem you solved in Q1, obtain the Sensitivity Report, and answer the following questions. Remember to round to two digits and you can enter “infinity” for unlimited regions: The range for Variable A is from ????? to ????? The range for Variable B is from ????? to ????? The range for Constraint 1 is from ????? to ????? The range for Constraint 2 is from ????? to ????? The range for Constraint 3 is from ????? to ?????

Answer 2

Question

Chapter 4, Problem 8QP

Summary Introduction

To determine: The sensitivity report using solver.

a)

Summary Introduction

To determine: The change in the optimal solution when the profit of Bike R decreased to $35.

b)

Summary Introduction

To determine: The change in the optimal solution when the profit of Bike Z decreased to $35.

c)

Summary Introduction

To interpret: The shadow price for the supply of polymer.

d)

Summary Introduction

To determine: The justification for the given statement.

e)

Summary Introduction

To determine: The new optimal level of profit for the given condition.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Question

Chapter 4, Problem 8QP

Summary Introduction

To determine: The sensitivity report using solver.

a)

Summary Introduction

To determine: The change in the optimal solution when the profit of Bike R decreased to $35.

b)

Summary Introduction

To determine: The change in the optimal solution when the profit of Bike Z decreased to $35.

c)

Summary Introduction

To interpret: The shadow price for the supply of polymer.

d)

Summary Introduction

To determine: The justification for the given statement.

e)

Summary Introduction

To determine: The new optimal level of profit for the given condition.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Question

Chapter 4, Problem 8QP

Summary Introduction

To determine: The sensitivity report using solver.

a)

Summary Introduction

To determine: The change in the optimal solution when the profit of Bike R decreased to $35.

b)

Summary Introduction

To determine: The change in the optimal solution when the profit of Bike Z decreased to $35.

c)

Summary Introduction

To interpret: The shadow price for the supply of polymer.

d)

Summary Introduction

To determine: The justification for the given statement.

e)

Summary Introduction

To determine: The new optimal level of profit for the given condition.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Chapter 4, Problem 8QP

Summary Introduction

To determine: The sensitivity report using solver.

a)

Summary Introduction

To determine: The change in the optimal solution when the profit of Bike R decreased to $35.

b)

Summary Introduction

To determine: The change in the optimal solution when the profit of Bike Z decreased to $35.

c)

Summary Introduction

To interpret: The shadow price for the supply of polymer.

d)

Summary Introduction

To determine: The justification for the given statement.

e)

Summary Introduction

To determine: The new optimal level of profit for the given condition.

Answer 6

Chapter 4, Problem 8QP

Summary Introduction

To determine: The sensitivity report using solver.

Answer 7

Chapter 4, Problem 8QP

Summary Introduction

To determine: The sensitivity report using solver.

Answer 8

a)

Summary Introduction

To determine: The change in the optimal solution when the profit of Bike R decreased to $35.

Answer 9

a)

Summary Introduction

To determine: The change in the optimal solution when the profit of Bike R decreased to $35.

Answer 10

b)

Summary Introduction

To determine: The change in the optimal solution when the profit of Bike Z decreased to $35.

Answer 11

b)

Summary Introduction

To determine: The change in the optimal solution when the profit of Bike Z decreased to $35.

Answer 12

c)

Summary Introduction

To interpret: The shadow price for the supply of polymer.

Answer 13

c)

Summary Introduction

To interpret: The shadow price for the supply of polymer.

Answer 14

d)

Summary Introduction

To determine: The justification for the given statement.

Answer 15

d)

Summary Introduction

To determine: The justification for the given statement.

Answer 16

e)

Summary Introduction

To determine: The new optimal level of profit for the given condition.

Answer 17

e)

Summary Introduction

To determine: The new optimal level of profit for the given condition.

Answer 18

Expert Solution & Answer

Answer 19

Expert Solution & Answer

Answer 20

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 21

Ch. 4 - Prob. 1QP Ch. 4 - Prob. 2QP Ch. 4 - Prob. 3QP Ch. 4 - Prob. 4QP Ch. 4 - Prob. 5QP Ch. 4 - Prob. 6QP Ch. 4 - Prob. 7QP Ch. 4 - Prob. 8QP Ch. 4 - Prob. 9QP Ch. 4 - Prob. 10QP

The sensitivity report using solver.

Concept explainers

To determine: The sensitivity report using solver.

To determine: The change in the optimal solution when the profit of Bike R decreased to $35.

To determine: The change in the optimal solution when the profit of Bike Z decreased to $35.

To interpret: The shadow price for the supply of polymer.

To determine: The justification for the given statement.

To determine: The new optimal level of profit for the given condition.

Want to see the full answer?

Chapter 4 Solutions