Formulate a linear program to determine the most profitable product mix.

Solve the linear programming model using Excel. **SOLVER**

4. A company manufactures three products; A, B, and C. Each unit of product A requires 1 hour of engineering service, 10 hours of direct labor, and 3 pounds of material. To produce one unit of product B, it requires 2 hours of engineering, 4 hours of direct labor, and 2 pounds of material. Each unit of product C requires 1 hour of engineering, 5 hours of direct labor, and 1 pound of material. There are 100 hours of engineering, 700 hours of labor, and 400 pounds of material available. Since the company offers discounts for bulk purchases, the profit figures are as shown below: Product A Product B Product C Sales (Units) Unit Profit ($) Sales (Units). Unit Profit Sales (Units) Unit Profit ($) ($) 10 9 0-50 50-100 Over 100 6 4 0-100 Over 100 0-40 40-100 100-150 Over 150 Aul 8