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.5 2.0 1.20

B 1.00 0.75 2.20

C 1.25 0.5 2.001

During the next production period, the labor-hours available are 350 in department A, 350 in department B, and 200 in department C.

The profit contributions per unit are $32 for product1, $28 for product 2, and $35 for product 3.

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

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

please write the excel formulas as well.