Linear programming blending problem using Excel Solver Table.

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%.

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.

... Sets up and solves a Linear programming problem using excel... Gas 3. Each type is produced by blending three type ... The crude oil blended to create Gas 1 must have ...

... The Metaleo Company desires to blend a new alloy of 40 percent tin ... four components of the model has formulated the following linear programming model (in ...

... by-step example of formulating a linear programming model for ... Fiber 0.038832 0.05 2. Blending Problem (20%): Determine ... 0.08 90.0 Formulate this problem into a ...

... _____6) Which is not a linear program network flow problem? a. Transportation. ... c. Blending. ... Set up the linear program in the following box (Give the model). ...

Linear programming. ... Wineco owns a blending plant with a production capacity of 200 gallons per day ... in the blend produced must be 2.5:1 3.The blend produced must ...

... 7 Points Linear programming model showing the objective function and ... Chapter 4 Problem 42 Blend Problem... A refinery blends four petroleum components into ...

... types of coffee to produce the blends - Brazilian, mocha ... to know the amount of each blend it should ... a. Formulate a linear programming model for this problem b ...

... Consider the following general form of a linear programming problem: ... is characteristic of the LP problem type know ... b. Labor planning c. Assignment d. Blending. ...

... B.1 Solve the following linear programming problem graphically: Maximize ... 5 Solve the following LP problem graphically: Minimize ... the least-cost blend of compost ...