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...

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