Purchase Solution

Blending Problem - Linear Programming

Not what you're looking for?

Ask Custom Question

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

Purchase this Solution

Solution Summary

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

Purchase this Solution


Free BrainMass Quizzes
Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.