The Weinberger Electronics Corporation manufactures four highly technical products that it supplies to aerospace forms that hold NASA contract. Each of the products must pass through the following departments before they are shipped: wiring, drilling, assembly, and inspection. The time requirement in hours for each unit produced and its corresponding profit value are summarized in the following table:

Product	Department	Unit profit
Wiring	Drilling	Assembly	Inspection
XJ201	0.5	0.3	0.2	0.5	9
XM897	1.5	1	4	1	12
TR29	1.5	2	1	0.5	15
BR788	1	3	2	0.5	11

The production available in each department each month, and the minimum monthly production requirement to fulfill contracts, are as follows:

Department	Capacity (hours)		Product	Minimum Prod. Level
Wiring	15,000		XJ201	150
Drilling	17,000		XM897	100
Assembly	26,000		TR29	300
Inspection	12,000		BR788	400

Question # 40. The production manager has the responsibility of specifying production levels for each product for the coming month. Help him by formulating ( that is, setting up the constraints and objective function) Weinbergers problem using LP in an Excel spread sheet and an summary explanation.