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

a. How much excess wiring and testing capacity exists in the optimal solution?

b. What is the company’s total profit if it has 10 additional hours of wiring capacity?

c. By how much does the profit on alternators need to increase before their production is justified?

d. Does the optimal solution change if the marginal profit on generators decreases by $50 and the marginal profit on alternators increases by $75?

e. Suppose the marginal profit on generators decreases by $25. What is the maximum profit that can be earned on alternators without changing the optimal solution?

f. Suppose the amount of wiring required on alternators is reduced to 1.5 hours. Does this change the optimal solution? Why or why not?