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

a. Is the solution unique?

b. If Sentry wants to increase their production capacity to meet more of the demand for their product, which plant should they use? Explain.

c. If the cost of shipping from Phoenix to Tacoma increased to $1.98 per unit, would the solution change? Explain.

d. Could the company make more money if they relaxed the restriction that each distributor must receive at least 80% of the predicted demand? Explain.

e. How much extra should the company charge the distributor in Tacoma if this distributor insisted on receiving 8,500 units?