Use Solver to create a Sensitivity Report for question 38 at the end of chapter 3 and
Question:
Use Solver to create a Sensitivity Report for question 38 at the end of chapter 3 and answer the following questions.
a. Is the solution degenerate?
b. Is the solution unique?
c. How much can the profit per ton on commodity one decrease before the optimal solution would change?
d. Create a Spider Plot showing the change in the total profit obtained by changing the profit per ton on each commodity from 95% to 105% in 1% increments. If the shipping company wanted to increase the price of transporting one of the commodities, which one would have the greatest influence on total profits?
Step by Step Answer:
Related Book For
Spreadsheet Modeling And Decision Analysis A Practical Introduction To Business Analytics
ISBN: 9781305947412
8th Edition
Authors: Cliff T. Ragsdale
Question Posted: