A "product mix" problem can be solved quite easily by hand, as long as there is only one constraint (i.e. one resource in which demand > capacity). However, when there are multiple constraints it becomes quite complex. In the lab, we used Solver to find the product mix that results in the highest profit, subject to capacity constraints for each resource, and the constraint that we would not make more than the demand for any given product. Set up a model based on what was done in the lab to find the optimal product mix for the problem in the attached spreadsheet. What was the resulting total profit? less than $30,000 between $30,000 and $30,250 between $30,250 and $30,500 between $30,500 and $30,750 between $30,750 and $31,000 more than $31,000