Linear Programming and Using Solver
Not what you're looking for?
Working with chemists at Virginia Tech and George Washington Universities, landscape contractor Kenneth Golding blended his own fertilizer, calling it 'Golding-Grow.' It consists of four chemical compounds, C-30, C-92, D-21, E-11. The cost per pound for each compound is indicated as follows:
Chemical Compound Cost Per Pound ($)
C-30 .12
C-92 .09
D-21 .11
E-11 .04
The specifications for Golding-Grow are as follows: (1) E-11 must constitute at least 15% of the blend, (2) C-92 and C-30 must together constitute at least 45% of the blend, (3) D-21 and C-92 can together constitute no more than 30% of the blend; and (4) Golding-Grow is packaged and sold in 50 pound bags.
A) Formulate an LP problem to determine what blend of the four chemicals will allow Golding to minimize the cost of a 50 pound bag of the fertilizer.
B) Solve using the computer LP approach.
Purchase this Solution
Solution Summary
This solution provides the student with guidelines for formulating the LP program and using Excel Solver to solve. Answer, sensitivity and limits reports are included.
Solution Preview
Working with chemists at Virginia Tech and George Washington Universities, landscape contractor Kenneth Golding blended his own fertilizer, calling it 'Golding-Grow.' It consists of four chemical compounds, C-30, C-92, D-21, E-11. The cost per pound for each compound is indicated as follows:
Chemical ...
Purchase this Solution
Free BrainMass Quizzes
Probability Quiz
Some questions on probability
Know Your Linear Equations
Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.
Geometry - Real Life Application Problems
Understanding of how geometry applies to in real-world contexts
Graphs and Functions
This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.