Use the Scenario Manager to create a Scenario Summary report that summarizes the effect of the Current, Lower Price, and Raise Price scenarios. Use the total revenue, total expenses, and net income in the range C$24$:C$26$ as thit result cells. Go to the Scenario Summary worksheet and delete column D$,$ which repeats the current values.

Return to the Income Analysis worksheet. Create a Scenario PivotTable report of the three scenarios displaying the total revenue, total expenses, and net income $($range C$24$:C$26)$ for each scenario.

Go to the Scenario PivotTable worksheet. Madhu wants to make the PivotTable easier to interpret. Remove the filter from the PivotTable. Use Total Revenue as the row label in cell B$3,$ use Total Expenses as the row label in cell C$3,$ and use Net Income as the row label in cell D$3.$ Display the Revenue, Expenses, and Net Income values in the Currency number format with no decimal places. Display negative values in red, enclosed in parentheses. Resize columns B:D to their best fit using Autofit.

Madhu also wants to compare the three scenarios in a chart. Create a Clustered Column PivotChart based on the PivotTable. Resize and position the chart so it covers the range A$8$:E$24.$