Incline Electronics produces three different products in a plant that is open 40 hours per week. Each product requires the following processing times (in hours) on each of three machines.

                           Product 1                product 2               product 3   

Machine 1                2                              2                             1

Machine 2                 3                              4                            6

Machine 3                 4                              6                            5

Each machine must be run by one of 19 cross-trained  workers who are each available 35 hours per week. The plant has 10 type 1 machines available, 6 type 2 machines available , and  8 type 3 machines available . Products 1,2, and 3 contribute $90,$120,and $150,respectively, in marginal profit per unit produced.

a. Formulate an LP model for this problem,

b. Implement your model in a spreadsheet and solve it .

c. What is the optimal solution?

d. How many workers should be assigned to each type of machine?