help

Applying Excel - Data Tables: Exercise (Part 2 of 2) On the Data Tables - Student tab in your Excef speadsheet update the given information section of the income Statement for thello Company with the data below Required: 2. Using the Date Table What Ar Aralysis toot in Excet, determine the Units and operating income (Loss) for eeuch Droduct based on the following scenatios. (Hint. Dont forget that the warehouse can only holit up to 50,000 inits ) Scenano 1 Pete wants to find the mix of units that will result in the hiphest overail operating locome perform this analysis using a twe varable data table. Product A can vary between 37,000 units and a maximan of 42,000 unite Proodes B can vay between 5.000 ants and a maximum of 10,000 units. Both Products A and 8 are manufactured in 1000 unit increments, The prodoction isyer of Product C. is the same eachimonth at 3.000 units. and a maximum of 10,000 units. Both Products A and B are manufactured in 1,000 -unit increments. The production level of Product C. is the same each month at 3.000 units. Scenario 2 Pete wants each product line in the mix to be profitable. Use a One Variable Data Table and then determine the number of units for each product that should be produced (to the nearest thousand) to make each product line profitable. 3. Based on your calculations above, which scenario creotes the highest overail Operating income for the company? Scenario I Scenario 2