Formulate and lp model for this problem using excel. sketch, Ask an Expert

Statistics

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

View complete question

Statistics and Probability, Statistics

Category:- Statistics and Probability
Reference No.:- M9367489

Have any Question?Write your Review or question?

Related Questions in Statistics and Probability

Many manufacturing problems involve the accurate matching

Many manufacturing problems involve the accurate matching of machine parts, such as shafts, that fit into a valve hole. A particular design requires a shaft with a diameter of 22.000 mm, but shafts with diameters betwe ...

Peter and maryam take turns throwing one dart at the

Peter and Maryam take turns throwing one dart at the dartboard. Peter hits the bullseye with probability 1/5 and Maryam hits the bullseye with probability 1/3. Each throw is independent of the last. Whoever hits the bull ...

Describe the theoretical problems of ethics 3 the

Describe the theoretical problems of ethics (3), the objectives to solving them.

Financial management how can a financial manager use the

Financial Management How can a financial manager use the time value of money(TVM) concept to accomplish this goal?

Determine the margin of error for an 80 confidence interval

Determine the margin of error for an 80?% confidence interval to estimate the population mean when s? = 36 for the sample sizes below. ?a)n=12 ?b)n=26 ?c)n=54 ?a) The margin of error for an 80?% confidence interval when ...

We have a normal distribution with a mean of 71 and a

We have a normal distribution with a mean of 71 and a standard deviation of 11 What is the Z value of the value 62? Round to three decimal digits. show workings please

A factory makes parts for laptop computers including screws

A factory makes parts for laptop computers, including screws. The screws are required to have the right length. The lengths of the screws obey a normal distribution with mean μ=4.25 millimeters and standard deviation σ=0 ...

Income can have significant effects on peoples spending

Income can have significant effects on people's spending patterns. Research studies have revealed that consumer expenditure is influenced by various factors such as their income, gender, age and level of education. In or ...

What is a financial and economic issue in the healthcare

What is a financial and economic issue in the healthcare industry?

A sample of 100 people is classified by gender malefemale

?A sample of 100 people is classified by gender (male/female) and by whether they are registered voters. The sample consists of 80 females and 20 males, and has a total of 60 registered voters. If these data are used for ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Statistics and Probability Expert