Use Solver to create a Sensitivity Report for question 23 at the end of Chapter 3 and answer the following questions.

a. What is the maximum level profit that can be achieved for this problem?

b. Are there alternate optimal solutions to this problem? If so, identify the solution that allows the most grade 5 oranges to be used in fruit baskets while still achieving the maximum profit identified in part a.

c. If Holiday could acquire 1,000 more pounds of grade 4 oranges at a cost of $2.65 per 100 pounds, should they do it? Why?

d. Create a Spider Table and Plot showing the change in the total profit obtained by changing the required grade of fruit baskets and juice from 90% to 110% in 1% increments. If the department of agriculture wants to increase the required rating of one of these products, which product should the company lobby for?