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

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!