Use Solver to create a Sensitivity Report for question 35 at the end of Chapter 3 and
Question:
Use Solver to create a Sensitivity Report for question 35 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 1 decrease before the optimal solution would change?
d. Create a Spider Table and 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?
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
ICC Ship Loading Commodity Total Max Total 1 2 3 4 weight weight volume Forward 3000 0 0 0 3000 3000 120000 Center 1800 780 1200 300 4080 6000 180000 ...View the full answer
Answered By
Bhartendu Goyal
Professional, Experienced, and Expert tutor who will provide speedy and to-the-point solutions. I have been teaching students for 5 years now in different subjects and it's truly been one of the most rewarding experiences of my life. I have also done one-to-one tutoring with 100+ students and help them achieve great subject knowledge. I have expertise in computer subjects like C++, C, Java, and Python programming and other computer Science related fields. Many of my student's parents message me that your lessons improved their children's grades and this is the best only thing you want as a tea...
2+ Reviews
10+ Question Solved
Related Book For 
Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science
ISBN: 978-0324656633
5th edition
Authors: Cliff T. Ragsdale
Question Posted:
