Please show calculations or cell references (calculations of the percentages in the chart as well)

The show Shoes Division of True North Corporation produces and markets two snow shoes for use in the snow: Extreme and Premium. The following data were gathered on activities for February 2022: Sales in units Selling price per unit Variable production costs per unit Traceable fixed production costs Variable selling expenses per unit Traceable fixed selling expenses Allocated division administrative expenses $ $ $ $ $ $ A A A A Extreme 2.445 55.45 20.00 12.000 2.00 2,000 40,000 Premium 9,445 $ 25.45 $ 5.00 $ 33,000 $ 1.00 $ 3,000 $ 72,000 Required: 1. Prepare a properly formatted segmented income statement for last month, showing both "amount" and "percentages" (where applicable) for the division as a whole and for each product. Display the percentages to the nearest 1 decimal place. enter your answers in the not True North Corporation highlighted cells using proper cell Segmented Income Statement referencing. NOT ALL CELLS NECESSARILY NEED TO BE USED For the month ended February 28, 2022 Total Extreme Premium $ $ $ % Sales cal Operating income (loss) 2. Calculate the breakeven points in sales dollars for each of the product lines. i.e. breakeven for each product line would be where their respective segment margins equal zero. Extreme Premium Breakeven sales dollars 3. The sales manager wants to run a special promotional campaign on one of the product lines next month. A marketing study indicates the cost of such a campaign and the corresponding potential increase in sales of the product line as follows: Extreme Premium Projected increase in sales $ 22,000 $ 20.000 The promotional campaign is estimated to cost $ 10,000 Show your calculations to determine which product line should be chosen Increase (decrease) in segment margin Which product line do you recommend they focus the campaign on