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?

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter8: Evolutionary Solver: An Alternative Optimization Procedure
Section8.3: Introduction To Evolutionary Solver
Problem 2P
icon
Related questions
Question

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.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 9 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,