4.1 Use solver to create Answer and Sensitivity Reports for question 24 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 additional 20 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?
Categories: