Linear programming model for the problem

Assignment Help Engineering Mathematics
Reference no: EM13962298

Colorado Gem and Mineral Co. (CGM) purchases two unprocessed ores from Philippines 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 CGM's cost per 100 pounds are given in the following table.

Ore

Copper per 100 pounds

Zinc per 100 pounds

Iron per 100 pounds

Waste per 100 pounds

Cost per 100 pounds

Manila 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 from Excel.

Reference no: EM13962298

Questions Cloud

Research the importance of information systems : Research the importance of information systems and information security in the work environment
Consider a straight section of wire of length l : Show that the magnetic field at a point P a distance R from the wire along its perpendicular bisector is B = (muI/2piR) * L/(L^2 + 4R^2)^1/2
What type of information they should document : From the case study "Relax, It's Only a Little Paperwork", propose an HR strategy that would help ensure mangers know what type of information they should document and what information they should avoid putting in an employee file
How much zinc in pounds was available for sale : Accountants frequently refer to "goods available for sale."  Is this concept the same as ending inventory?  How much zinc, in pounds, was "available for sale?"
Linear programming model for the problem : 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 from Excel.
Find the magnetic field at point q whose coordinates (2a,-a) : Use the law of Biot and savart to find the magnetic field at the point P(a,-a)in the x-y plane. Then find the magnetic field at the point Q whose coordinates are (2a, -a).
Show how a switch and resistor can be used to create a logic : Show how a switch and resistor can be used to create a logic level 1 or 0 for a digital input circuit. Obtain a data sheet for a Passive Infra Red Detector and show how it can be configured to provide a logic level 1 when it detects the presence of a..
Determine the general solution of this differential equation : Suppose that, when the particle is at its equilibrium position, it is given a blow so that its speed instantaneously becomes vo in the downward direction. The particle is observed just to reach the fixed point B in its subsequent motion. Use your an..
Determining the proportion of the amount : Suppose Annabelle decides to change her risk-balancing formula by eliminating the restriction that the proportion of the amount she invests s in the index fund to the amount that she invests in the Internet fund must be at least one-third. What wi..

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