Question: Suppose that you want to increase all three of the

Suppose that you want to increase all three of the resource availabilities in the product mix model simultaneously by the same percentage. You want this percentage to vary from -25% to 50% in increments of 5%. Modify the spreadsheet model slightly so that this sensitivity analysis can be performed with a one-way Solver Table, using the percentage change as the single input. Keep track of the computers produced in row 21, the hours used in the range B26:B28, and the total profit. Discuss the results.


View Solution:


Sale on SolutionInn
Sales0
Views85
Comments
  • CreatedApril 01, 2015
  • Files Included
Post your question
5000