Introduction to Management Science 12th Edition Chapter 2, Problem 10P *** I nee

Question

Introduction to Management Science 12th Edition

Chapter 2, Problem 10P

*** I need to know how to enter this correctly into Excel's Solver (Please include details or screen shot if possible) ***

The Elixer Drug Company produces a drug from two ingredients. Each ingredient contains the same three antibiotics in different proportions. One gram of ingredient 1 contributes 3 units, and ingredient 2 contributes 1 unit of antibiotic 1; the drug requires 6 units. At least 4 units of antibiotic 2 are required, and the ingredients each contribute 1 unit per gram. At least 12 units of antibiotic 3 are required; a gram of ingredient 1 contributes 2 units, and a gram of ingredient 2 contributes 6 units. The cost for a gram of ingredient 1 is $80, and the cost for a gram of ingredient 2 is $50. The company wants to formulate a linear programming model to determine the number of grams of each ingredient that must go into the drug in order to meet the antibiotic requirements at the minimum cost. a. Formulate a linear programming model for this program. b. solve this model by using graphical analysis

Explanation / Answer

3x+2y =6 y>= 4 z>=12 2x+6y 80x+50y --minimise

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.