Linear programming blending problem using Excel Solver Table.
Not what you're looking for?
NewAge data
Cost/lb of chemicals
Chemical 1 $8
Chemical 2 $10
Chemical 3 $11
Chemical 4 $14
Ingredient/lb of chemical
A B C
Chemical 1 0.03 0.02 0.01
Chemical 2 0.06 0.04 0.01
Chemical 3 0.10 0.03 0.04
Chemical 4 0.12 0.09 0.04
The Mist pharmacy produce four chemicals, today the company must produce 1000 pounds of the drug. The three active ingredients in Mist are A,B, and C. By weight, at least 8% of Mist must consist A, at least 4 % of B, and 2% of C. The cost per pound of each chemical and amount of each active ingredient in 1 pound of each chemical are given above. It is necessary that at least 100 pound of chemical 2 be used
1. Determine the cheapest way of producing today's batch of Mist
2. Use SolverTable to see how much the percentage of requirement of A is really costing Mist. Let the percentage required vary from 6% to 12%.
Purchase this Solution
Solution Summary
The solution examines linear programming blending problems using the Excel Solver Table. The cost of chemicals per pound and the ingredient per pound of chemicals is also examined.
Purchase this Solution
Free BrainMass Quizzes
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.
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.
Probability Quiz
Some questions on probability
Graphs and Functions
This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.