How would this be completed in excell? Image attached is data

1. Before starting the Scenario Manager in the next step, name the following cells with appropriate names:

Changing Cells	Name of Cells
B8	SmallUnitPrice
C8	MediumUnitPrice
D8	LargeUnitPrice
B15	SmallMarketing
C15	MediumMarketing
D15	LargeMarketing

Result Cells	Name of Cells
G8	GrossProfit
G11	ContributionMargin
G16	FixedExpenses
G18	MarginalIncome

2. Using the Scenario Manager, create three scenarios using the data in the table below:

	Small	Medium	Large
Current Plan:
Price Per Unit	$120	$128	$132
Marketing Expense	$10,000	$17,000	$18,000
Targeted Plan:
Price Per Unit	$131	$140	$149
Marketing Expense	$8,500	$13,700	$16,400
Optimal Plan:
Price Per Unit	$184	$192	$205
Marketing Expense	$9,200	$10,250	$12,450

3. Create a Scenario Summary by using the Gross Profit, Contribution Margin, Total Fixed Expenses and the Marginal Income before Taxes as your result cells.

Rochester's Widget Sales Forecast (2021) Assumptions: Projections: Small Widget Categories Medem Large Revende Units Sold Price Per Unit 1,750 1,800 1,700 $120.00 $128.00 $132.00 Sales COGS Gross Profit S 664,800.00 $ 375.750,00 $ 289,050.00 Distribution Expenses Contribution Margin $ 26,200.00 $ 262,850,00 0 Variable Expenses (per unit) 1 COGS $ 65.00 $ 70.00 $ 80.00 2 Distribution Costs 5 4.00 5 5.00 5 6.00 3 14 Fixed Expenses 35 Marketing campaign $10,000,00 $17,000.00 $18,000,00 16 Payroll (not grouped by category $57.000,00 17 18 19 20 21 Fixed Expenses Marketing campaign Payroll Total Fixed Expenses $ 45,000.00 $ 57,000.00 $ 102,000.00 Marginal Income Before Taxes $ 160,350.00 26 28 29 30 31 33 35 2021 Sales Forcast a 2 9 . H Rochester's Widget Sales Forecast (2021) Assumptions: Projections: Small Widget Categories Medem Large Revende Units Sold Price Per Unit 1,750 1,800 1,700 $120.00 $128.00 $132.00 Sales COGS Gross Profit S 664,800.00 $ 375.750,00 $ 289,050.00 Distribution Expenses Contribution Margin $ 26,200.00 $ 262,850,00 0 Variable Expenses (per unit) 1 COGS $ 65.00 $ 70.00 $ 80.00 2 Distribution Costs 5 4.00 5 5.00 5 6.00 3 14 Fixed Expenses 35 Marketing campaign $10,000,00 $17,000.00 $18,000,00 16 Payroll (not grouped by category $57.000,00 17 18 19 20 21 Fixed Expenses Marketing campaign Payroll Total Fixed Expenses $ 45,000.00 $ 57,000.00 $ 102,000.00 Marginal Income Before Taxes $ 160,350.00 26 28 29 30 31 33 35 2021 Sales Forcast a 2 9 . H