On the Data Tables Student tab in your Excel spreadsheet, update the given information section of the Income Statement for Hello Company with the data below:
tableIncome Statement,Product AProduct BProduct CtableMaxCapacityUnitsPrice per unit,$$$Variable expense per unit,$$$Total Fixed Costs,$$$
Required:
Using the Data Table WhatIf Analysis tool in Excel, determine the Units and Operating Income Loss for each product based on the following scenarios. Hint: Don't forget that the warehouse can only hold up to units.
Scenario : Pete wants to find the mix of units that will result in the highest overall Operating Income, perform this analysis using a two variable data table. Product A can vary between units and a maximum of units. Product can vary between units and a maximum of units. Both Products A and B are manufactured in unit increments. The production level of Product C is the same each month at units.
tableSCENARIO Units,tableOperatingIncome LossProduct AProduct BProduct C
