Use Solver to create a Sensitivity Report for question 28 at the end of Chapter 3 and answer the…

Use Solver to create a Sensitivity Report for question 28 at the end of Chapter 3 and answer the following questions: a. What total profit level is realized if 100 extra hours of labor are available? b. Assume a marginal labor cost of $11 per hour in determining the unit profits of each of the three products. How much should management pay to acquire 100 additional labor hours? c. Interpret the reduced cost value for tuners. Why are more tuners not being produced?