A manufacturer can sell product 1 at a profit of $20 per unit and product 2 at a profit of $40 per unit. Three units of raw material are needed to manufacture one unit of product 1, and six units of raw material are needed to manufacture one unit of product 2. A total of 15,000 units of raw material are available. If any product 1 is produced, a setup cost of 20,000 is incurred; if any of product 2 is produced, a setup cost of $35,000 is incurred.

In Excel, determine how to maximize the manufacturers profit.

If either of the products is not produced in the optimal solution, use SolverTable to see how much this products unit profit must be before it will be produced, and then use SolverTable again to see how much this products fixed cost must be decreased before it will be produced.