Max Capacity 43,000 Income Statement Units Price per unit Variable expense per unit Total Fixed Costs Product A 36, eee $ 12.00 $ 4.00 $2e, eee Product B 5,000 $ 9.00 $ 3.00 $48, eee Product C 2,000 $50.00 $ 15.00 $10,000 Required: 2. Using the Data Table What-lf Analysis tool in Excel, determine the Units and Operating Income (Loss) for each pro based on the following scenarios. (Hint Don't forget that the warehouse can only hold up to 43,000 units.) Scenario 1 Pete wants to find the mix of units that will result in the highest overall Operating income, perform this an using a two variable data table Product A can vary between 33,000 units and a maximum of 38,000 units. Products vary between 3,000 units and a maximum of 8,000 units. Both Products A and B are manufactured in 1.000-unit incre The production level of Product C is the same each month at 2,000 units. Units Operating Income (Loss) SCENARIO 1 Product A Product B Product C 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. Units Operating Income (Loss) SCENARIO 2 Product A Product B Product C 3. Based on your calculations above, which scenario creates the highest overall Operating Income for the company Scenario 1 Scenario 2