Question: Use Solver to create a Sensitivity Report for question 30 at the end of chapter 3 and answer the following questions: a. Is the solution

Use Solver to create a Sensitivity Report for question 30 at the end of chapter 3 and answer the following questions:

a. Is the solution unique?

b. If Sentry wants to increase their production capacity to meet more of the demand for their product, which plant should they use? Explain.

c. If the cost of shipping from Phoenix to Tacoma increased to $1.98 per unit, would the solution change? Explain.

d. Could the company make more money if they relaxed the restriction that each distributor must receive at least 80% of the predicted demand? Explain.

e. How much extra should the company charge the distributor in Tacoma if this distributor insisted on receiving 8,500 units?

Step by Step Solution

★★★★★

3.35 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Shipping Report Sentry Lock Corp Unit Shipping Costs to Unit Distribution Center in Production Plants Tacoma San Diego Dallas Denver St Louis Tampa Baltimore Cost Macon 250 275 175 200 210 180 165 355... 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 (114).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...

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

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

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

In many malls, fast-food retailers are frequently located together in an area known as a food court. What are this arrangements advantages and disadvantages to the fast-food retailer?

xy" 4xy' + 4y = 4x 6x, y(2) = 4, y'(2) = - 1. | x?y" + 2xy' 6y = 10x, y(1) = 1, y'(1) = -6. %3D %3D %3D

NYSE listing requirements are concerned with all of the following except Profitability of listed companies Broad public ownership of listed companies Insuring investors against loss from risky...

46. Peel Co. received a cash dividend from a common stock investment. Should Peel report an increase in the investment account if it has classified the stock as available-for-sale or uses the equity...

Must a model accurately represent every detail of a decision situation to be useful? Why or why not?

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

Suppose 202 animals are classied into 4 categories as follows: Y = (91:92: 293,314) = (125,18,25,34) The corresponding cell probabilities are known to have the structure 91 62 2(1 61) 1 92 61 ( 3 + 3...

A firm's demand function for product X has the following question: Qx = 1420 -20Px- 10Py + 0.02M + 0.04A where Qx is the quantity purchased, Px is the price of X, Py is the price charged for a...

Huffman Systems has forecasted sales for its new home alarm systems to be 65,000 units per year at $41.00 per unit. The cost to produce each unit is expected to be about 42% of the sales price. The...