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

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 Solution

★★★★★

3.37 Rating (153 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Instructions Assuming you have an Excel workbook with the model for question 38 at the end of Chapter 3including the objective function and constraints Go to the Data tab and select Solver or Solve AddIn in older versions a Degeneracy In the Solver dialog boxcheck the box next to Show Progress before solving Solve the model In the Solver Results dialog boxlook for any values under Reduced Cost that are very close to zero egwithin 00001 Interpretation If there are any values close to zero in Reduced Cost the solution might be degenerate Degeneracy can indicate potential issues with the model and might affect the sensitivity analysis b Unique Solution Look at the number of iterations it took Solver to find the optimal solution Interpretation If Solver found the optimal solution in a very low number of iterations eg 1 or 2 theres a higher chance the solution might be unique However a higher number of iterations doesnt necessarily guarantee multiple solutions c Profit Decrease for Commodity 1 Go back to the Solver dialog box Set the objective function cell total profit to be Equal to a specific value egthe current optimal profit Add a constraint ... 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

Students Have Also Explored These Related Spreadsheet Modeling And Decision Analysis Questions!

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...

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 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...

Use Solver to create a Sensitivity Report for question 3 8 at the end of chapter 3 and answer the following questions. Is the solution degenerate? Is the solution unique? How much can the profit per...

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....

How can policy makers anticipate the future of work and navigate those implications before they arise, rather than after? Is it possible for policy makers to serve as innovators in the future of...

Entries for Issuing Bonds Thomson Co. produces and distributes semiconductors for use by computer manufacturers. Thomson Co. issued $870,000 of 10-year, 10% bonds on May 1 of the current year at face...

a . The inheritance changes Grace's overall portfolio and she is deciding whether to keep the ABC stock. Assuming Grace keeps the ABC stock, calculate the: i . Expected return of her new portfolio...

Round the following to the indicated place values: a. 132.1356 to the nearest tenth b. 2.8525 to the nearest whole number c. $85.4273 to the nearest cent d. $34.9861 to the nearest cent Determine the...

a. On average, how many customers per hour does each sales person process? b. What is the expected value of each call to VIs toll free line? c. Suppose VI pays it phone reps $12 per hour. How many...

This chapter presented the problem of having to decide between two job offers. The decision maker could accept the job with company A, accept the job with company B, or reject both offers and hope...

To determine the feasible region associated with less than or equal to constraints or greater than or equal to constraints, we graphed these constraints as if they were equal to constraints. Why is...

Van Rushing Hunting Goods fiscal year ends on December 31. At the end of the 2021 fiscal year, the company had notes payable of $6.5 million due on February 8, 2022. Rushing sold 5.0 million shares...

Can someone please help and show work? Given the above information, at what average price per share must the shares (stock) have been ssued at in 2022

A company has the following results