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

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!