INDIVIDUAL ASSIGNMENT MDM

Topics: Chemical compound, Chemical element, Chemistry Pages: 2 (299 words) Published: April 23, 2015
INDIVIDUAL ASSIGNMENT (MDM) 
Management Decision Making
 
Deadline: 19 Oct 2014
 
Tarmac Chemical Corporation produces a special chemical compound—called    CHEMIX—that is used extensively in high school chemistry classes. This compound must contain at  least 20% sulfur, at least 30% iron oxide, and at least 30% but no more than 45% potassium. Tarmac’s marketing department has estimated that it will need at least 600 pounds of this compound to meet the expected demand during the coming school session. Tarmac can buy three compounds to mix together to produce CHEMIX. The makeup of these compounds is shown in the following table.   

Compound
Sulfur
Iron Oxide
Potassium
1
20%
60%
20%
2
40%
30%
30%
3
10%
40%
50%
 
Compounds 1, 2, and 3 cost $5.00, $5.25, and $5.50 per pound, respectively. Tarmac wants to use an LP model to determine the least costly way of producing enough CHEMIX to meet the demand expected for the coming year. a. Formulate an LP model for this problem.

b. Create a spreadsheet model for this problem and solve it using Solver. c. What is the optimal solution?  Use Solver to create a Sensitivity Report for question 22 at the end of Chapter 3 and answer the following questions. d.  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? e.  How does the solution change if the maximum amount of potassium allowed decreases from 45% to 40%? f.  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.)
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Assignment PCC101 Individual Behavior Research Paper
  • individual assignment Essay
  • Individual Assignment Essay
  • Essay on Individual Assignment
  • individual assignment Essay
  • Essay on Individual Assignment
  • Essay on Individual Assignment
  • Individual Assignment Essay

Become a StudyMode Member

Sign Up - It's Free