Explore BrainMass

Blending Problem - Linear Programming

A drug company produces the drug NasaMist from four chemicals. Today, the company must produce 1000 pounds of the drug. The three active ingredients in NasaMist are A, B, and C. By weight, at least 8% of NasaMist must consist of A, at least 4% of B, and at least 2% of C. The cost per pound of each chemicals and the amount of each active ingredient in 1 pound of each chemical are given in a different file (information included below). It is necessary that at least 100 pounds of chemical to be used.

a. Determine the cheapest way of producing today's batch of NasaMist.

Cost/lb of chemicals
Chemical 1 8.00
Chemical 2 10.00
Chemical 3 11.00
Chemical 4 14.00

Ingredient/lb of chemical
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

Solution Summary

This posting provides solution to a blending problem for a linear programming model for minimizing the cost of production with Excel Solver.