Formulate and lp model for the problem using excel


Blacktop Refining extracts minerals from ore mined at two different sites in Montana.

Each ton of ore type 1 contains 20% copper, 20% zinc and 15% magnesium.
Each ton of ore type 2 contains 30% copper, 25% zinc and 10% magnesium.

Ore type 1 cost $90 per ton.
Ore type 2 cost $120 per ton.

Blacktop would like to buy enough ore to extract at least 8 tons of copper, 6 tons of zinc, and 5 tons of magnesium in the least costly manner

A. Formulate and LP model for this problem using excel
B. Sketch the feasible region for this problem using excel
C. Find the optimal solution.

Request for Solution File

Ask an Expert for Answer!!
Operation Management: Formulate and lp model for the problem using excel
Reference No:- TGS090624

Expected delivery within 24 Hours