A firm has decided to discontinue production of an unprofitable product. This will create excess capacity, and

Question:

A firm has decided to discontinue production of an unprofitable product. This will create excess capacity, and the firm is considering one or more of three possible new products: A, B, and C. The available daily hours in the plant will be 477 hours in tool and die, 350 hours on the drill presses, and 150 hours on lathes. The hours of production required in each of these areas are as follows for each of the products.

Tool and Die Drill Press Lathe 3 4 3 0.5 2

Furthermore, the sales department foresees no limitations on the sale of products A and C but anticipates sales of only 20 or fewer per day for product B. If the unit profits expected are $30 for A, $9 for B, and $15 for C, how many of each should be produced to maximize overall profit? What is the maximum profit?
Use Excel to solve each linear programming problem.