Determining the production of various compounds

Assignment Help Engineering Mathematics
Reference no: EM13961672

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 zinc per iron per waste per cost per
100 lbs 100 lbs 100 lbs 100 lbs 100 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.

Reference no: EM13961672

Questions Cloud

Describe what may have attributed to this : The performance disparity between established managers and new managers was especially sizable in 2008. Describe what may have attributed to this.
Find tb, the magnitude of the tension in string b : If the mass of the block is too large and the block is too close to the left end of the bar (near string B) then the horizontal bar may become unstable (i.e., the bar may no longer remain horizontal). What is the smallest possible value of x such t..
Readings about teaching and learning theories : Personal Philosophy: From your readings about teaching and learning theories, develop and discuss your personal philosophy of teaching in nursing.
Which strategy seems to be most successful at achieving : Based on the returns of the various strategies in Exhibits 15.3 and 15.4, which strategy seems to be most successful at achieving absolute returns?
Determining the production of various compounds : 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 m..
Seeking refreshment at a local coffee shop : adgett, a young male adult, is seeking refreshment at a local coffee shop. While Nadgett is waiting in line for his low-fat latte, Chuffey, an elderly man, accidentally bumps into Nadgett and spills the contents of his coffee cup onto Nadgett's desig..
Assuming the same size and profitability : Assuming the same size and profitability, which fund would you expect to have more in tax liabilities: Active Trading or Activist Investing?
Define code of business conduct : Define “code of business conduct”. Discuss businesses should concern themselves with developing a code of business conduct? If so, what variables should be included? If not, how would the business ensure that their employees were following ethical bu..
Find tb, the magnitude of the tension in string b : If the mass of the block is too large and the block is too close to the left end of the bar (near string B) then the horizontal bar may become unstable (i.e., the bar may no longer remain horizontal). What is the smallest possible value of x such t..

Reviews

Write a Review

Engineering Mathematics Questions & Answers

  Prime number theorem

Dirichlet series

  Proof of bolzano-weierstrass to prove the intermediate value

Every convergent sequence contains either an increasing, or a decreasing subsequence.

  Antisymmetric relations

How many relations on A are both symmetric and antisymmetric?

  Distributed random variables

Daily Airlines fies from Amsterdam to London every day. The price of a ticket for this extremely popular flight route is $75. The aircraft has a passenger capacity of 150.

  Prepare a system of equations

How much money will Dave and Jane raise for charity

  Managing ashland multicomm services

This question is asking you to compare the likelihood of your getting 4 or more subscribers in a sample of 50 when the probability of a subscription has risen from 0.02 to 0.06.]  Talk about the comparison of probabilities in your explanation.

  Skew-symmetric matrices

Skew-symmetric matrices

  Type of taxes and rates in spokane wa

Describe the different type of taxes and their rates in Spokane WA.

  Stratified random sample

Suppose that in the four player game, the person who rolls the smallest number pays $5.00 to the person who rolls the largest number. Calculate each player's expected gain after one round.

  Find the probability density function

Find the probability density function.

  Develop a new linear programming for an aggregate production

Linear programming applied to Aggregate Production Planning of Flat Screen Monitor

  Discrete-time model for an economy

Discrete-time model for an economy

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd