[See Steps] Excel Sensitivity Analysis 2 (7.0 points) Using the model and the sensitivity report from the previous problem, a manager is offered the opportunity
Question:
Excel Sensitivity Analysis 2 (7.0 points)
Using the model and the sensitivity report from the previous problem, a manager is offered the opportunity to make a bulk purchase of 150 additional hours for Process 1 at a cost of $1050. Which of the following should the manager do without impacting the current product mix?
-
Refuse because the purchase price per additional hour is greater than the shadow price.
b) Accept because the purchase price for each additional hour is less than the shadow price and this does not impact the current product mix?
c) Refuse because this would impact his current optimal product mix.
Price: $2.99
Solution: The downloadable solution consists of 1 pages
Deliverable: Word Document
Deliverable: Word Document
