Please create model formulation and use excel solver. Thank you.

Failsafe Electronics Corporation primarily manufactures four highly technical products, which 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, assembly, and inspection. The time requirements

in each department $($in hours$)$ for each unit produced and its corresponding profit value are summarized

in the table below.

Department

Product Wiring Drilling Assembly Inspection Unit profit

XJ$2010\mathrm{.}5320\mathrm{.}5$ $$9$

XM$8971\mathrm{.}5141\mathrm{.}0$ $$12$

TR$291\mathrm{.}5210\mathrm{.}5$ $$15$

BR$7881\mathrm{.}0320\mathrm{.}5$ $$11$

The production time 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 $1500$ XJ$201150$

Drilling $2350$ XM$897100$

Assembly $2600$ TR$29200$

Inspection $1200$ BR$788400$

Formulate and solve Failsafe Electronics$$ profit maximization problem as a linear program.