Use Solver to create a Sensitivity Report for question 17 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?