Use the Scenario Manager as follows to create a PivotTable that compares the profit per unit in each scenario as follows

: a. Create a Scenario PivotTable report using the profit per unit sold (range B17:F17) as the result cells.

b. Remove the Filter field from the PivotTable.

c. Change the number format of the value fields to Currency with 2 decimal places and the $ symbol