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

  Waiting time t between successive occurrences of an event e

waiting time T between successive occurrences of an event E

  Air-standard cycle with variable specific heats

An air-standard cycle with variable specific heats is executed in a closed system with 0.003 kg of air and consists of the following three processes:

  Considering the comfort and safety of passengers

When considering the comfort and safety of passengers why are women ignored in this case?

  Expression of error variance in an anova

Question 1: Which statistic is the best expression of error variance in an ANOVA?

  Assignment to five commercial banks

Five analyst have recently been hired for assignment to five commercial banks on one-to-one basis. The cost of each analyst in each bank is given in the following table. Determine the lowest cost of assignment.

  Ounces of potassium while minimizing cost

Ingredient 1 costs $3 per pound and ingredient 2 costs $5 per pound.  The company wants to know how many pounds of each chemical ingredient to put into a bag of fertilizer to meet the minimum requirements of 20 ounces of nitrogen, 36 ounces of pho..

  Center of circular table of diameter

Problem: A light is located over the center of circular table of diameter d = 8 feet (see figure). Find the height h of the light source such that the illumination I at the perimeter of the table is maximum when:

  Assemble in order to get maximum profit

Because of the popularity of the sport, the store is able to sell as many bicycles as they decide to assemble. How many bicycles of each model should they assemble in order to get the maximum profit?

  Determining the critical value

1.) My computer program offers two types of t-tests. One is a called independent groups ttest, and the other is called dependent groups t-test. When should I use which one? 2.) How does a one-tail test compare with a two-tail test for determining t..

  Overview of the descriptive statistics

Hypotheses - List the statistical notation and written explanations for the null and alternative hypotheses for the study. Variables - Identify the variables and each of their attributes: discrete or continuous, quantitativ..

  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.

  Create a 3 x 3 matrix

For the three vectors in Part 11, find the corresponding values of λ1, λ2, and λ3 and find a matrix E such that A2 = X E

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