Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can you answer this for me please 12. Switch to the All Types worksheet. Use the Scenario Manager to create a Scenario Summary report that

can you answer this for me please
image text in transcribed
image text in transcribed
12. 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 B17:D17 as the result cells. 13. 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 B17:D17. b. Remove the Filter field from the PivotTable. c. Change the Number format of the Profit_Per_Hour_Contracted_Mana, Profit_Per_Hour_Contracted_Chan, and Profit_Per_Hour_Contracted_Proc fields (located in the Values box of the PivotTable Field List) to Currency with 2 Decimal places and $ as the Symbol. d. Use Management as the row label value in cell B3, Change as the value in cell C3, and Process as the value in cell D3. e. In cell A1, use Profit Per Hour Contracted as the report title. f. Format the report title using the Title cell style. g. Resize columns A-D to 15.00 . Cairo Consulting - Product Mix 12. 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 B17:D17 as the result cells. 13. 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 B17:D17. b. Remove the Filter field from the PivotTable. c. Change the Number format of the Profit_Per_Hour_Contracted_Mana, Profit_Per_Hour_Contracted_Chan, and Profit_Per_Hour_Contracted_Proc fields (located in the Values box of the PivotTable Field List) to Currency with 2 Decimal places and $ as the Symbol. d. Use Management as the row label value in cell B3, Change as the value in cell C3, and Process as the value in cell D3. e. In cell A1, use Profit Per Hour Contracted as the report title. f. Format the report title using the Title cell style. g. Resize columns A-D to 15.00 . Cairo Consulting - Product Mix

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Auditing

Authors: Graham Cosserat

1st Edition

0471810584, 9780471810582

More Books

Students also viewed these Accounting questions