Use Solver to create a Sensitivity Report for question 18 at the end of chapter 3 and

Question:

Use Solver to create a Sensitivity Report for question 18 at the end of chapter 3 and answer the following questions:

a. Is the solution degenerate?
b. Would the solution change if the price of raisins was $2.80 per pound?
c. Would the solution change if the price of peanuts was $3.25 per pound?
d. If you could relax one of the nutritional constraints which one would you choose? Why?
e. Create a Spider Plot summarizing the impact on total cost of varying the cost per pound of each ingredient between 90% and 110% of its base case value in 2% increments. What does this chart reveal and what are the managerial implications?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: