A plastic parts supplier produces two types of plastic parts used for electronics. Type 1 requires 20minutes of labor and 35 minutes of machine time. Type 2 requires 50 minutes of machine hours and 78 minutes of labor. There are 500 hours available per week of labor and 750 machine hours available. Type 1 has a profit margin of $25 a unit and Type 2 has a profit margin of $45 a unit. The plastic parts supplier must choose the quantity of Type 1 and Type 2 to produce which maximizes profit.

(a) Formulate this as a linear programming problem.

(b) Find the solution that gives the maximum profit using Excel Solver.