TheABCCorporation manufactures four highly technical products that it supplies to aerospace firms that hold NASA contracts. Each of the products must pass through the following departments before they are shipped: wiring, drilling, assemble, and inspection. The time requirement in hours for each until produced and its corresponding profit value are summarized in the following table:

DEPARTMENT
PRODUCT	WIRING	DRILLING	ASSEMBLE	INSPECTION	UNIT PROFIT ()
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 PRODUCTION LEVEL
WIRING	15000	XJ201	150
DRILLING	17,000	XM897	100
ASSEMBLY	26000	TR29	300
INSPECTION	12000	BR788	400

The production manager has the responsibility of specifying production levels for each product for the coming month. Help by formulating (that is setting up the constraints and objective function) ABCCorporation problem using LP in EXCEL/EXCEL QM.