Question: I need some help figuring out how to properly do these Excel Scenarios Create three scenarios based only on a variation in part-time hours. The
I need some help figuring out how to properly do these Excel Scenarios
| Create three scenarios based only on a variation in part-time hours. The number given is the expected hours needed for next year. The actual hours are expected to vary between 90% and 110% of the projected hours. Create three scenarios that show the effect on a Min, Avg, or Max usage of hours on the Total PT Wage Expense. Create and name the scenarios (in this order) as Min Hours, Avg Hours, and Max Hours. |
| Create three new scenarios for the same three levels of hours usage but with a 3% increase in the wage rate (to 10.61). Create and name these three scenarios (in this order) as Min Hours w/Raises, Avg Hours w/Raises, and Max Hours w/Raises. |

I have already made the first 3 scenarios (named them properly) but they do not function right.
What is it that I need to type in here/each one to fix them?

Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools D13 4A B C D E F G H I J K L M N O P R S Painted Paradise RESORT & SPA 4 Expenses Average Part-time hours Average Hourly Rate Benefit % 8 Total PT Wage Expense 210600 $10.30 28.00% $2,169,180 Scenario Manager Scenarios: Min Hours Avg Hours Max Hours Add... Delete Edit... Merge... Summary... Changing cells: SESS Edit Scenario Scenario name: Min Hours Changing cells: Ctrl+click cells to select non-adjacent changing cells. Comment: Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools D13 4A B C D E F G H I J K L M N O P R S Painted Paradise RESORT & SPA 4 Expenses Average Part-time hours Average Hourly Rate Benefit % 8 Total PT Wage Expense 210600 $10.30 28.00% $2,169,180 Scenario Manager Scenarios: Min Hours Avg Hours Max Hours Add... Delete Edit... Merge... Summary... Changing cells: SESS Edit Scenario Scenario name: Min Hours Changing cells: Ctrl+click cells to select non-adjacent changing cells. Comment
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
