Question: Use Solver to create a Sensitivity Report for question 22 at the end of Chapter 3 and answer the following questions. a. Suppose the cost

Use Solver to create a Sensitivity Report for question 22 at the end of Chapter 3 and answer the following questions.

a. Suppose the cost of the first two compounds increases by $1.00 per pound and the cost of the third compound increases by $0.50 per pound. Does the optimal solution change?

b. How does the solution change if the maximum amount of potassium allowed decreases from 45% to 40%?

c. How much does the cost of the mix increase if the specifications for CHEMIX change to require at least 31% sulfur? (Hint: Remember that the shadow price indicates the impact on the objective function if the RHS value of the associated constraint increases by 1.)

Step by Step Solution

3.26 Rating (152 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Maxture Report Tarmac Chemical Corporation Compound Sulfur Iron Oxide Potassium Cost in Mix 1 20 60 ... View full answer

blur-text-image
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)

Excel file Icon

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

300 KBs Excel File

Students Have Also Explored These Related Management Leadership Questions!