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

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?

Step by Step Solution

★★★★★

3.37 Rating (172 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

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 full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

167-B-M-L-M-D-A (116).xlsx

300 KBs Excel File

Students Have Also Explored These Related Management Leadership Questions!

Use Solver to create a Sensitivity Report for question 15 at the end of Chapter 3, and answer the following questions: a. Is the solution degenerate? b. Is the solution unique? c. Explain the signs...

Use Solver to create a Sensitivity Report for question 16 at the end of Chapter 3, and answer the following questions: a. Is the solution degenerate? b. Explain the value of the shadow price...

Use Solver to create a Sensitivity Report for question 17 at the end of Chapter 3, and answer the following questions: a. Is the solution degenerate? b. Would the solution change if the price of...

The rate constant for the decomposition of N 2 O 5 at various temperatures is given below : Draw a graph between In k and 1/7 and calculate the value of A and Ea. Predict the rate constant at 30C and...

hapter 4 Sensitivity Analysis and the Simplex Method 14. Use Solver to create a Sensitivity Report for question 15 at the end of Chapter 3 answer the following questions: a. Is the solution...

Use this question 3 4 to answer question 2 3 The Pelletier Corporation has just discovered that it will not have enough warehouse space for the next 5 months. The additional warehouse space...

I need to solve excel on the same excel format please as soon as possible 14. Use Solver to create a Sensitivity Report for question 15 at the end of Chapter 3, and answer the following questions: a....

Use Solver to create a Sensitivity Report for question 15 at the end of Chapter 3, and answer the following questions: a. Is the solution degenerate? * I believe the answer is no because there are no...

Use Solver to create a Sensitivity Report for question 15 at the end of chapter 3, and answer the following questions: a. Is the solution degenerate? b. Is the solution unique? c. Explain the signs...

Use Solver to create a Sensitivity Report for question 3 4 at the end of chapter 3 and answer the following questions. The Pelletier Corporation has just discovered that it will not have enough...

Choose one of the following financial fraud scheme cases from Ch 12 of Principles of Fraud Examination You may also choose a fraud scheme case that is not in the text with instructor approval

Explain why changes in value stream profitability may be better information than individual product cost for certain decisions.

Alice bought office supplies at Staples for $ 8 5 . 8 9 . Track office supply purchases to Office Expenses. Date: 2 2 nd of last month. 3 . Jon purchased lawn maintenance supplies at Johnson Supply....

44. Park Co. uses the equity method to account for its January 1, year 1 purchase of Tun Inc.s common stock. On January 1, year 1, the fair values of Tuns FIFO inventory and land exceeded their...

If you were presented with several different models of a given decision problem, which would you be most inclined to use? Why?

Are the following objective functions for an LP model equivalent? That is, if they are both used, one at a time, to solve a problem with exactly the same constraints, will the optimal values for X1...

Howie Jones used the following information to calculate the profit coefficients for Aqua-Spas and Hydro-Luxes: pumps cost $225 each, labor costs $12 per hour, tubing costs $2 per foot. In addition to...

Exercise 9. (10pts) Selecting a Jury The grade appeal process at a university requires that a jury be structured by selecting five individuals ran- domly from a pool of eight students and ten...

Type 2D: You are a consultant to a firm evaluating an expansion of its current business. The cash-flow forecasts (in millions of dollars) for the project are as follows. Year 0: initial outlay of...

An oil drilling company must choose between two mutually exclusive extraction projects, and each costs $12.8 million. Under Plan A, all the oil would be extracted in 1 year, producing a cash flow at...