DUE 2/27 PLEASE ANSWER!! Assignment Problem 2* Missouri Mineral Products (MMP) p
ID: 2959750 • Letter: D
Question
DUE 2/27 PLEASE ANSWER!!
Assignment Problem 2*
Missouri Mineral Products (MMP) purchases two unprocessed ores from Bolivia Mining, which it uses in the production of various compounds. Its current needs are for 800 pounds copper, 600 pounds of zinc, and 500 pounds of iron. The amount of each mineral found in each 100 pounds of the unprocessed ores and MMP’s cost per 100 pounds are given in the following table.
Ore Copper per 1K lbs Zinc per 1K lbs Iron per 1K lbs Waste per 1K lbs Cost per 1K lbs
La Paz ore 20 20 20 40 $100
Sucre ore 40 25 10 25 $140
The objective is to determine the amount of each ore that should be purchased in order to minimize the total purchasing cost.
a) Formulate the linear programming model for the problem.
b) Use the Graphical method to find the optimal solution. Show all steps.
c) Use Excel Solver to find the optimal solution. Copy and paste your spreadsheet and the Answer report in its entirety from Excel. Remember to not delete/modify any part of the Answer Report.
Explanation / Answer
let x be amt of la paz ore bought and y be amt of sucre ore bought. x nd y in 1k increments.
for copper: .2X+.4y>800
for zinc: .2x+.25y>600
for iron: .2x+.1y>500
x>0
y>0
Want to minimize x(100)+y(140)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.