Required:

Complete the income projection in columns I and J$,$ using SUMPRODUCT.

Create appropriate range names for the cells: C$16,$ D$16,$ E$16,$ C$22,$ D$22,$ E$22.$

Create four scenarios, using the scenario information located to the right of the income statement.

Create a scenario report for the four scenarios, showing Sales, Contribution Margin, Income after Taxes for each. Edit the report so the appearance is professional.

Starting in column L build a two$-$dimensional da a table that sho vs Income after tax at a variety of Casual Selling prices and

marginal tax rates. No need to chanse the units of other products.