Question: Booster Shot also runs a different LP for another one of their products. This product uses a mix of three peppers as well, but includes
Booster Shot also runs a different LP for another one of their products. This product uses a mix of three peppers as well, but includes slightly different constraints. After finding the optimal solution, the following sensitivity report was produced by Excel:
| Variable Cells | |||||||
| Final | Reduced | Objective | Allowable | Allowable | |||
| Cell | Name | Value | Cost | Coefficient | Increase | Decrease | |
| $C$12 | # kg of Chipotle | 0 | 4.60 | 11.75 | 4.60 | ||
| $D$12 | # kg of Ancho | 78.57 | 0 | 6.5 | 3.05 | 1E+30 | |
| $E$12 | # kg of Serano | 21.43 | 0 | 9.55 | 21.45 | 3.05 | |
| Constraints | |||||||
| Final | Shadow | Constraint | Allowable | Allowable | |||
| Cell | Name | Value | Price | R.H. Side | Increase | Decrease | |
| $C$16 | Total production | 100 | 9.77 | 100 | 1100 | 14.72 | |
| $F$5 | capsaicin model output | 778.57 | 0 | 500 | 278.57 | 1E+30 | |
| $F$6 | smokiness model output | 2007.14 | 0 | 2000 | |||
| $F$7 | texture model output per | 6000 | -0.04 | 6000 | 1500 | 21.74 |
1. How many kg of Ancho peppers are there in the optimal solution?
2. What is the total cost (for 100kg) of the optimal solution?
3. Based on the above sensitivity report, what is the highest cost/kg for Anchopeppers that would result in the same optimal solution?
4. By how much would the target cell increase if the cost/kg of Seranopeppers increased by $20?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
