This Question is from the book Spreadsheet Modeling and Decision Analysis Chapte

Question

This Question is from the book Spreadsheet Modeling and Decision Analysis Chapter 4.

15. Use Solver to create a Sensitivity Report for question 16 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 that action? 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? 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. Pre- pare 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?

Explanation / Answer

the question is not at all clear and no description is given how can we solve the problem

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.