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.
Reading books is a great way to learn. Here are some of the books we recommend.
Go to the Data tab. Under Forcast group click at the What-if analysis and choose Scenario Manager.
Pop-up model will be shown. Click on the Summary button which is at the bottom side of right hand side.
Select Scenario PivotTable report in report tyle. Make sure the value in recult cellls is B17:F17 and hit Ok.
Go to the newly created worksheet. To remove the filter. right click and select remove $b$6...
Now, select all numbers from B4:F6. In the Home tab, under number group click at the expand icon. Choose Currency from the category of left hand side.
Make sure there is 2 in Decimal places and $ in Symbol.
Hit OK.
That's all!
Video explanation: