Question: How do we get 40 and 60? PLEASE explain to me how I get it? Get External Data Refresh Stocks Geogra... Sort & Filter AN

How do we get 40 and 60? PLEASE explain to me how I get it?

Get External Data Refresh Stocks Geogra... Sort & Filter AN Data Tools Outline What if Analysis Data Analys ? Solver G34 fx B D G H AC Column2 1 Columni 2 Maximize WIRING TIME DRILLING TIME C FAN 25 3 2 15 Calculations RHS 1900 240 140 2 Equation form Max 25AC15FAN 240 3AC - 2FAN 240 140 2AC + FAN 140 How Many to Produce 40 60 Profit will be 1900 Paste ANSWER REPORT FROM SOLVER BELOW 11 12 13 14 15 16 *7-14 The Electrocomp Corporation manufactures two electrical products: air conditioners and large tans. The assembly process for each is similar in that both require a certain amount of wiring and drilling. Each air conditioner takes 3 hours of wiring and 2 hours of drilling. Each tan must go through 2 hours of wiring and 1 hour of drilling. During the next production period, 240 hours of wiring time are avaiable 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 proft. 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

please help! here you are, sorry about that i dont know the equations to fill the chart 14. Use the data in the Loan Worksheet sheet to run a what-it scenario for a client to show loan payments for a...

SShow EXCEL steps please. AutoSave OFF BESU- Housing Units Home Insert Draw Page Layout Formulas Data Review View Shape Format Tell me Share Comments Clear +3 Show Detail 18. Connections B:...

I am having trouble with finding the specific effect size and the formula to get to that, when I try mean 1-mean 2 divided by SD, It does not work for me. Any guidance would be greatly appreciated-...

Data Review View Tell me v . Connections Properties Edit Links 5 Get External Data Refresh All Stecks Geography 31 Sort Filter Reapoly Advanced Data Validation Remove Duplicates & Consolidate Text to...

Depreciation using Excel's Absolute Cell Referencing, SLN and DDB Functions Sullivan Ranch Corporation has purchased a new tractor and has provided the information related to this purchase and its...

what am i doing worng here? Iternal ata 13 apply Refresh AI U Sort Filter Stocks Geograd Edit Links fx =$D$7/($D$4-F5) Advanced Text to Columns What Analy X B D E E 150,000 A Robert's Clinic Annual...

CAN YOU PLEASE SHOW THE STEP BY STEP ON EXCEL.. ( so I know where to click) thank you! Step Instructions Point Value 1 0 Start Excel. Download and open the file named...

3 5 You want to use the Subtotal feature to display the average total deposit by number of bedrooms for each apartment complex. Use the Subtotal feature to insert subtotal rows by Apartment Complex...

Create a two-way data table after referencing total profit (calculated in cell F12) and using the values in cells B49:B69 (Price) and C48:E48 (Advertising Budget) to analyze the relationships among...

12. Enter a formula in cell K5 of the SalesTrans sheet that uses an IF function and VLOOKUP functions to find the Product_ID in the Inventory sheet and return either the Card_Price or the...

Address each of the following: Brainstorm and create a list of knowledge and skills needed to enter into and advance in your chosen profession. Consider the categories below and identify at least one...

The following two tables could be used to store the data in Figure 5-15 in a database. ChoirMember (LastName, FirstName, Email, Phone, Part) MusicalWork (NameOfWork, Composer, Part, CopyNumber) This...

Solve this MCQ A right-of-use asset in a lease arrangement is___? (Accounting) a. Never depreciated b. Only depreciated if purchase option exists c. Depreciated over lease term or useful life d....

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...