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
Maxture Report Tarmac Chemical Corporation Compound Sulfur Iron Oxide Potassium Cost in Mix 1 20 60 ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
167-B-M-L-M-D-A (108).xlsx
300 KBs Excel File
