Tarmac Chemical Corporation produces a special chemical compoundcalled CHEMIXthat is used extensively in high school chemistry classes.
Question:
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.
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 optimalsolution?
A Corporation is a legal form of business that is separate from its owner. In other words, a corporation is a business or organization formed by a group of people, and its right and liabilities separate from those of the individuals involved. It may...
Step by Step Answer:
Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science
ISBN: 978-0324656633
5th edition
Authors: Cliff T. Ragsdale