Malban Manufacturing produces a final product by assembling three different parts. Each of two Departments is capable of producing these parts, albeit at different rates. The Table below provides the relevant data.

		Time needed to Produce (Hours)
Department	Weekly Capacity (Hours)	Part 1	Part 2	Part 3
1	1000	8	5	10
2	800	6	12	4

Management wishes to designate Department 1 to be the primary producer of Part 1 and Department 2 to be the primary producer of Part 2. A department is a primary producer of a part if it never produces of it less than the total amount it produces of the other two parts.

1. Build and solve a linear programming Excel model to maximize the integer number of units of the final product and write down the production plan. [20 Points]

(Hint: Since each of the parts goes into making the final product, it is only possible to make of the final product as many units as there of any of the parts, i.e., the task resolves to maximizing the minimum of units produced of the parts.)