Question: Consider the following sensitivity report. Do not try to recreate the optimization. Only answer the questions using the information provided in the sensitivity report. Variable
Consider the following sensitivity report. Do not try to recreate the optimization. Only answer the questions using the information provided in the sensitivity report.
Variable Cells
|
|
| Final | Reduced | Objective | Allowable | Allowable |
| Cell | Name | Value | Cost | Coefficient | Increase | Decrease |
| $B$4 | Solution Value X | 2.00 | 0.00 | 4.00 | 1.00 | 1.50 |
| $C$4 | Solution Value Y | 4.00 | 0.00 | 5.00 | 3.00 | 1.00 |
Constraints
| Cell | Name | Final Value | Shadow Price | Constraint R.H. Side | Allowable Increase | Allowable Decrease |
| $D$7 | Labor | 10.00 | 1.00 | 10.00 | 2.00 | 2.00 |
| $D$8 | Material | 36.00 | 0.50 | 36.00 | 4.00 | 6.00 |
| $D$9 | Storage | 32.00 | 0.00 | 40.00 | 1E+30 | 8.00 |
| $D$10 | Admin Support | 15.00 | 0.00 | 20.00 | 1.00 | 3.00
|
Explain the implications of the following actions. Each question is independent of the other questions.
You acquire 2 additional pounds of material.
You acquire 1.5 additional hours of labor.
You give up 1 hour of labor and get 1.5 pounds of material.
The profit contributions of both products X and Y are changed to $4.75 each.
Name the binding constraint(s).
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
