Purchase Solution

Carson Metals Company - Linear Programming

Not what you're looking for?

Ask Custom Question

Carson Metals Company produces metal alloys from six different ores it mines. The ores and the metal content of each are described in the table below. The company has an order from a customer to produce an alloy that contains four metals according to the following specifications: at least 21% of metal A, no more than 12% of metal B, no more than 7% of metal C, and between 30% and 65% of metal D. The proportion of the four metals in each of the six ores and the level of impurities in each ore are provided in the table.

(see chart in attached file)

When the metals are processed and refined, the impurities are removed.

a. Formulate a linear programming model that can be used to determine the amount of each ore to use per ton of the alloy while minimizing cost.
b. Determine the optimal solution including the total tonnage of each type of ore used and the total cost per ton of the alloy.

Attachments
Purchase this Solution

Solution Summary

The solution provides detailed explanations and the Excel Solver code for the problem.

Solution Preview

Please see the attached files.

The answer to parts a and b is ...

Purchase this Solution


Free BrainMass Quizzes
Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.