Question: Switch to the All Types worksheet. Use the Scenario Manager to create a Scenario Summary report that summarizes the effect of the Status Quo, Third
Switch to the All Types worksheet. Use the Scenario Manager to create a Scenario Summary report that summarizes the effect of the Status Quo, Third Party, and Raise Rates scenarios. Use the range B:D as the result cells.
Switch back to the All Types worksheet. Use the Scenario Manager as follows to compare the profit per hour in each scenario:
a Create a Scenario PivotTable report for result cells B:D
b Remove the Filter field from the PivotTable.
c Change the Number format of the ProfitPerHourContractedMana, ProfitPerHourContractedChan, and ProfitPerHourContractedProc fields Jlocated in the Values box of the PivotTable Field List to Currency with Decimal places and $ as the Symbol.
d Use Management as the row label value in cell B Change as the value in cell C and Process as the value in cell D
e In cell A use Profit Per Hour Contracted as the report title.
f Format the report title using the Title cell style.
g Resize columns AD to
Add a PivotChart to the Scenario PivotTable worksheet as follows:
a Create a Clustered Column PivotChart based on the PivotTable.
b Resize and reposition the chart so that it covers the range A:D
c Hide the field buttons in the chart. Mac Hint: The Field Buttons option is not available on Excel for the Mac, so Mac users can ignore this instruction
I need more detailed explanation on how to go about it on excel
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
