Suppose we want to increase all three of the resource availabilities in the product mix model simultaneously
Question:
Suppose we want to increase all three of the resource availabilities in the product mix model simultaneously by the same factor. We want this factor to vary from 0.8 to 2.0 in increments of 0.1. For example, if this factor is 1.0, we get the current model, whereas if the factor is 2.0, the resource availabilities become 8000, 12,000, and 20,000. Modify the spreadsheet model slightly so that this sensitivity analysis can be performed with a one-way SolverTable, using the factor as the single input. Keep track of the values in the changing cells and the target cell. Discuss the results.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Practical Management Science, Revised
ISBN: 9781118373439
3rd Edition
Authors: Wayne L Winston, S. Christian Albright
Question Posted: