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 need some help figuring out how to properly do these Excel

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?

Scenarios Create three scenarios based only on a variation in part-time hours.

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!