How do I do this on Excel? A Production$-$Mix Problem 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 this table: DEPARTMENT ODUCT WIRING DRILLING ASSEMBLY INSPECTION UNIT PROFITAPPROACH Formulate this production$-$mix situation as an LP problem. The production manager first specifies production levels for each product for the coming month. He lets: X$1$ number of units of XJ$201$ produced X$2=$ number of units of XM$897$ produced X$3$ number of units of TR$29$ produced X$4$number of units of BR$788$ produced$28\%$ C$+\}$ Mon $2$:$13$ PM Teresa $,$ Tools Data Window Help ch She Insert Page Layout Formulas Data Review View $$ Share $^$ Conditional Formatting Format onal able a ting $"$ Cell Styles $\%$ a Cells Editing A$..-..$ Screen Shot $.$ ro Paste Font AlignmentNumber $-03-4\mathrm{.}47$ p Office Update To keep up$-$to$-$date with security updtartes, fixes, and improvements,.c$..$ Check for Updates road trip.mp Department ctic $2$ INSPECTIONUNIT PROFT $0\mathrm{.}5$ WIRING DRILLING ASSEMIBLY X$/201$ XM$897$ TR$290\mathrm{.}51\mathrm{.}51\mathrm{.}5$ $$12$ $$15$ $$11$ muma $0\mathrm{.}5$ elessDiagnos $02$R$.\mathrm{.}40.$tar.g DEPARTMENT CAPACTTY PRODUCT MINIMUM PRODUCTION LEVEL $1,500$ XU$201$ ber $\backslash$sigma $112350$ xM$8972600$ TR$29200$ BR$788$ ber o $1314$ ber $15$ ber o $1718$ ormu profit $23+1\mathrm{.}5$X$,27+1$x $+4$X$2+11$; Sheet$1$ Ready F$7$