Linear programming model for ore extraction

Reference no: EM1397246

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

Reference no: EM1397246

Questions Cloud

What will be the theoretical yield of bromobenzene : what will be the theoretical yield of bromobenzene in given reaction as C6H6 + Br2 → C6H5Br + HBr also find out percentage yield when actual yield of bromobenzene was found 56.7 g?

Linear programming problem-print media advertising : Print Media Advertising (PMA) has been given a contract to market Buzz Cola via newspaper ads in a major southern newspaper. Full-page ads in the weekday editions (Monday through Saturday) cost $2000, whereas on Sunday a full-page ad costs $8000.

Calculate empirical formula of compound : Calculate empirical formula of this compound & molecular formula and calculate the molality of solution of sulfuric acid?

What is the mean rate of flagellar regeneration : The return of motility is sudden. What does this suggest about flagellar function in these organisms?

Linear programming model for ore extraction : Formulate and LP model for this problem using Excel. Sketch the feasible region for this problem using Excel. Find the optimal solution

Marketing analyst can use inependent samples : Explain how the marketing analyst can use independent samples to collect the data.

Calculate the molecular weight of the compound : Calculate the molecular weight of the compound? Given that Kf=1.86 and the compound in not ionic.

Find out what will be the mole fraction of ethanol : calculate how much CaCN2 is required to form 12.6 moles of ammonia? Given that the percent yield is 65.8%?

Describe the logistical requirements for awards at dinner : Describe the logistical requirements related with giving out awards at dinner and how they can be included into overall event plan and budget.

User Account

All Pages