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. Explain the value of the shadow price associated with Machine 1.
c. If the plant could hire another cross-trained worker would you recommend they do so? Why?
d. Suppose the marginal profit for each product was computed using estimated costs. If you could get more accurate profit estimates for these products which one(s) would be of greatest interest to your? Why?
e. If all the 19 workers are present and work 35 hours per week, the company should have 665 total hours of labor available. Suppose the manager of this company is concerned about workers calling in sick or missing work for other reasons. Prepare a Solver Table that summarizes what happens to the optimal product mix and total profit as the total labor hours available varies from 600 to 665 hours in 5 hour increments. What does this analysis reveal and what are the managerial implications?