Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

NEED HELP!!! Need ehlp solving in Excel please!!
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Management Principles And Practice

Authors: Timothy Gallagher

6th Edition

1930789157, 978-1930789159

More Books

Students also viewed these Finance questions