State College Parts produces two types of saw table stabilizers for at home customers. The production process requires milling and turning. Each type 1 part requires 6 minutes of milling and 4 minutes of turning. Each type 2 part requires 4 minutes of milling and 8 minutes of turning. There are 36 hours of milling time and 40 hours of turning time available. Type 1 parts generate $30 of profit and type 2 parts generate $40 of profit. Demand for type 2 parts is limited so at most 800 will be produced.
a. Formulate an LP model for this problem that maximizes the total profit.
b. Solve using Excel solver.