Applying Excel - Data Tables: Excel Worksheet (Part 1 of 2) Oownioad the Applying Eucei form below. Foliow the tutorial on the first tab and then complete the questions using fxcel tools and formulas on the lecond tab. hold ug to 50000 unts Far Scenario 1, create a fwo-yanibble dats lable to find the number of unats and Operating inceme abss) for each product in Scenario t. For Scenano 2, create a one vanable data table to find the number of Unts and Operating incorte flawi) far each product in 5 icenario ? Check yout worksheet sedup and data table tesuits. For Scenanio t, you should have calculated 45 .ooo unita for Product A. For Scenario 2, you should howe calculated a final fotal Cperabing income luess of 5320000 for all the produtis. If you itid not get these arawers, nedo the Dats Table What A Analyint for both scenarios by referencing the glven informaben iabie formulas. For Save your completed Apphing Excel form to your computer and then upload it here by clicking "Diocwse", Nent chick "Sarve", You will vie this worksheet to answer questions inpart 2. Applying Excel-Data Tables: Exercise (Part 2 of 2) On the Dath Tables - Student tab in your Excel spreadsheet. updste the given information section of the income Statemem far Helio Company with the data below: Required: 2. Using the Data Table What if Aralysis tool in Excel, determine the Units and Operating income (toss) for each product barsed on the following scenarios. (Hint Don't forget that the warehouse can only hold up to 44.000 units) Scenano t: Pete wants to find the mix of units that will result in the highest overoll Operating income. perform this analysis using a two variable dato table. Product A can vary between 35.000 units and a maximum of 40.000 units. Product 9 can vary between 2.000 unifs and a maximum of 7,000 units. Both Products A and B are manufactured in 1000 -unit increments. The production level of Product C is the same each month at 2,000 units Applying Excel - Data Tables: Excel Worksheet (Part 1 of 2) Oownioad the Applying Eucei form below. Foliow the tutorial on the first tab and then complete the questions using fxcel tools and formulas on the lecond tab. hold ug to 50000 unts Far Scenario 1, create a fwo-yanibble dats lable to find the number of unats and Operating inceme abss) for each product in Scenario t. For Scenano 2, create a one vanable data table to find the number of Unts and Operating incorte flawi) far each product in 5 icenario ? Check yout worksheet sedup and data table tesuits. For Scenanio t, you should have calculated 45 .ooo unita for Product A. For Scenario 2, you should howe calculated a final fotal Cperabing income luess of 5320000 for all the produtis. If you itid not get these arawers, nedo the Dats Table What A Analyint for both scenarios by referencing the glven informaben iabie formulas. For Save your completed Apphing Excel form to your computer and then upload it here by clicking "Diocwse", Nent chick "Sarve", You will vie this worksheet to answer questions inpart 2. Applying Excel-Data Tables: Exercise (Part 2 of 2) On the Dath Tables - Student tab in your Excel spreadsheet. updste the given information section of the income Statemem far Helio Company with the data below: Required: 2. Using the Data Table What if Aralysis tool in Excel, determine the Units and Operating income (toss) for each product barsed on the following scenarios. (Hint Don't forget that the warehouse can only hold up to 44.000 units) Scenano t: Pete wants to find the mix of units that will result in the highest overoll Operating income. perform this analysis using a two variable dato table. Product A can vary between 35.000 units and a maximum of 40.000 units. Product 9 can vary between 2.000 unifs and a maximum of 7,000 units. Both Products A and B are manufactured in 1000 -unit increments. The production level of Product C is the same each month at 2,000 units