Question: Consider the sensitivity report below for a cost minimization problem: Variable Cells Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease $B$11
Consider the sensitivity report below for a cost minimization problem:
| Variable Cells | ||||||
|---|---|---|---|---|---|---|
| Cell | Name | Final Value | Reduced Cost | Objective Coefficient | Allowable Increase | Allowable Decrease |
| $B$11 | Pounds used in Ingredient 1 | 4 | 0 | 3 | 2 | 3 |
| $C$11 | Pounds used in Ingredient 2 | 2 | 0 | 5 | 1E + 30 | 2 |
| Constraints | ||||||
| Cell | Name | Final Value | Reduced Cost | Objective Coefficient | Allowable Increase | Allowable Decrease |
| $B$14 | Nitrogen Ounces in Fertilizer | 44 | 0 | 20 | 24 | 1E + 30 |
| $B$15 | Phosphate Ounces in Fertilizer | 36 | 0.5 | 36 | 1E + 30 | 14.4 |
| $B$16 | Potassium Ounces in Fertilizer | 2 | 2 | 2 | 3 | 2 |
**Please Note: If an answer is positive infinity then answer it with: 1E + 30. But If an answer is negative infinity, answer it with -1E +30. **
Part 1). What is the value of the objective function for the optimal solution?
Part 2). What will be the change in the objective value if the phosphate required in the fertilizer is increased by 100 units? (round answer to 1 decimal place)
Part 3). What will be the change in the objective value if the potassium required in the fertilizer is increased by 1.5 units? (round answer to 1 decimal place)
Part 4). What will be the new total cost if the cost per unit of Ingredient 1 increases by 1.43? (round answer to 2 decimal places)
Part 5). What is the range of cost per unit of Ingredient 1 within which the current optimal solution will not change?
Lower Limit: _____ Upper Limit: _____
Part 6). What is the range of cost per gram of Ingredient 2 within which the current optimal solution will not change?
Lower Limit:_____ Upper Limit: _____
Part 7). If you increase the amount of nitrogen required by the maximum allowed increase without changing its shadow price, what will be the change in the total cost?
Part 8).If you increase the amount of potassium required by the maximum allowed increase without changing its shadow price, what will be the change in the total cost?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
