NEED HELP!!! Need ehlp solving in Excel please!!
Problems Q. 7-14 The Electrocomp Corporation manufactures ttwo electrical products: air conditioners and large fans. The assembly process for each is similar in that both require a certain amount of wiring and driling. 3 hours of wiring and 2 hours of air conditioner takes 3 hours of wo through 2 hours of wiring drilling. Each fan must go through 2 hours of wiring and 1 hour of drilling, During the are available, and up to 140 hours of drilling time may be used. Each air conditioner sold yields a profit of $25. Each fan assembled may be sold for a $15 profit. Formulate and solve this LP production mix situation to find the best combination of air conditioners and fans that yields the highest profit. Use the corner point graphical approach. NOTE: This section is for formulating your LP in written form Decision Uariables (Variable Chosen) [Clescription] Constraints Label Solution ('witten statement of what the decision maker should do) 7.14 SOLVE USING CORNER POINT HETHOD Use of Resourees Wiring Drilling \begin{tabular}{|c|c|} \hlineX & Y \\ \hline & \\ \hline & \\ \hline \end{tabular} Resources Wiring Wiring Drilling Drilling \begin{tabular}{|c|c|c|} \hlineX & Y & Available) \\ \hline 0 & & \\ \hline & 0 & \\ \hline 0 & & \\ \hline & 0 & \\ \hline \end{tabular} Set X to 0 and Solve Constraints, then Set Y to 0 and Solve Contstaints Profit at Point A Profit at Point B Profit at Point C Profit at Point D \begin{tabular}{|c|c|c|} \hlineX & Y & Profit \\ \hline 0 & 0 & \\ \hline 0 & & \\ \hline & 0 & \\ \hline & & \\ \hline \end{tabular} Highlight the profit and coordinates for the optimal product mis solution Profitper Unit SOLVE AGAIN USIHG SOLVER METHOD \begin{tabular}{l|c|c|c|} \multicolumn{1}{c|}{X} & Y & \\ \cline { 1 - 2 } Quantity to produce & & \multicolumn{1}{c}{ Profit } \\ \hline Qbjective Function & & \end{tabular} Constraints \begin{tabular}{|l|l|l|l|l|} \hline \multicolumn{1}{l|}{} & LHS & z=5 & RHS \\ \hline & & & & \\ \hline & & & & \\ \hline \end{tabular} Insert Soatterplot (wistraight lines and markers) in the shaded area below NOTE: "Insert Shape" and add a dot for two of the points: 0,0 AND ONE MORE