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 product 2 is produced, a setup cost of

$35,000 is incurred.

a. Determine how to maximize the manufacturer’s profit.

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