Use Solver to create Answer and Sensitivity Reports for question 25 at the end of chapter 2 and answer the following questions:

a. If the profit on doors increased to $700 would the optimal solution change?
b. If the profit on windows decreased to $200 would the optimal solution change?
c. Explain the shadow price for the finishing process.
d. If 20 additional hours of cutting capacity became available how much additional profit could the company earn?
e. Suppose another company wanted to use 15 hours of Sanderson’s sanding capacity and was willing to pay $400 per hour to acquire it? Should Sanderson agree to this? How (if at all) would your answer change if the company instead wanted 25 hours of sanding capacity?