2) Martha Manufacturing makes three products. Each product requires manufacturing operations in three departments: A, B, and C. The labor-hour requirements, by department, are as follows:

Department Product 1 Product 2 Product 3

A 1.0 2.5 1.00

B 1.50 1.75 2.00

C 1.25 0.5 2.5

During the next production period, the labor-hours available are 250 in department A, 350 in department B, and 180 in department C. The profit contributions per unit are $27 for product1, $28 for product 2, and $30 for product 3.

a) Formulate a linear programming model for maximizing total profit contribution. (4 marks)

b) Solve the linear program formulated in part (a). How much of each product should be produced, and what is the projected total profit contribution? (5 marks)

PLEASE SOLVE IN EXCEL