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:

Question Posted: