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

  Find the current in time domain and calculate its value

Find the Current in Laplace domain(s domain).(show all your work). Find the Current in time domain and calculate its value at t=5ms

  Types of antihistamine formulations

A company makes two types of antihistamine formulations: one for daytime use and one for nighttime use. The net profit for the daytime formulation is 20 cents per pill and the net profit for the nighttime formulation is 25 cents per pill.

  Operation of simplistic electric train

The April 2015 stories at the main FCP site: (1) I spent many hours trying to work out the operation of this simplistic electric train that only recently appeared on YouTube:

  1bsp consider the sinusoidal signalxt 8 sin6pit

1.nbsp consider the sinusoidal signalxt 8 sin6pit phi0.assume phi0 pi4 for this question andnbspphi0 0 for the

  Write complete addition and multiplication tables for field

You should give sufficient detail for the arithmetic operations to be carried out but you do not need to write down the complete addition and multiplication tables for the field.

  Single-phase queuing system and multiphase queuing system

Compare and contrast the differences between a single-phase queuing system and multiphase queuing system. Describe your answer in full.

  Determine system life cycle cost and spares policies

How can methods of improving system reliability be studied using simulation - when and how can simulation be applied to problems such as determining system life cycle cost and spares policies?

  Find the power developed across a load

Find the power developed across a load of 100 ohms due to this AM wave and find the power developed across a load of 100 ohms due to this AM wave.

  How many degrees of freedom are there

How many degrees of freedom are there? Would each respondent need to evaluate each product combination to obtain good results?

  Determining the confidence intervals

The vast majority of the world uses a 95% confidence in building confidence intervals. Give your opinion on why 95% confidence is so commonplace. Justify your response.

  Find coordinates of each corner point of the feasible region

Find the coordinates of each corner point of the feasible region. Define the slack and surplus variables. What do they represent? What is (are) the difference(s) between a slack and a surplus variable?

  Find stress,strain and modulus of elasticity

A metallic rectangular rod 1.5m long,40mm wide and 25mm thick is subjected to axial tensile load of 120KN.Elongation of rod is 0.9mm.Find stress,strain and modulus of elasticity.

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