Four products are processed sequentially on three machines. The following table gives the pertinent data of the problem:

Machine Cost per hour Product Product 2 Product 3 Product 4 Capacity 1 10 2 3 4 2 500

2 5 3 2 1 2 380

3 4 7 3 2 1 450

Unit Selling Price () 75 70 55 45

a) Formulate the problem as a linear program. b) Use Excel Solver to solve your linear program c) Write a report explaining the steps you take in approaching the above problems, and interpret your solution.