Start Excel. Open the downloaded file named Excel_CH10_PS2_Schedule.xlsx. Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files.	0
2	The Schedule worksheet has the possible schedules each employee can work (rows 511). The 1s represent the days worked, and the 0s represent the days off (so each schedule has two days in a row off). The range D5:D11 contains the number of employees assigned to the schedule in the corresponding row. This range will need to be changed to fulfill the scheduling needs. In cell F13 of the Schedule worksheet, enter a formula that will calculate the total number of employees scheduled to work Sunday for all schedules A-G. Begin by multiplying the number of employees for schedule A, in cell D5, by the value representing whether or not employees are working that day in cell F5. Be sure to make the reference to cell D5 an absolute cell reference so that, when finished, the formula can be copied across the row. So far the result of the formula is 0 because schedule A has people scheduled off on Sunday. Next, add to the product, the number of employees scheduled to work Sunday for schedule B. Continue with the formula by adding a similar calculation for schedules C-G, making an absolute cell reference for each cell in column D.	10
3	Copy the formula from cell F13 to the right through cell L13.	5
4	Insert a SUM function in D18 that adds all the shifts scheduled in the range F13:L13.	10
5	Enter a formula in cell D20 that calculates the payroll for the week, which is the Total shifts scheduled multiplied by Pay/Employee/Day.	8
6	Using Solver, minimize the Payroll/Week for the resort by changing the values in cells D5:D11. Remember these points as you complete the Solver Parameters dialog box: The number of employee work days in the range F13:L13 must be greater than or equal to the demand (range F15:L15), so there are enough people working for that days needs. The number of employees scheduled in D5:D11 must be >=1.	11
7	Solve this model using the Simplex LP method and keep the Solver solution.	5
8	In the Part-Time Expenses sheet, insert into cell E8 a formula to calculate the total annual part-time expense. The Benefit % is an estimate in the form of a percentage of total wages and needs to be added to the cost of wages based on the average part-time hours multiplied by the average hourly rate.	5
9	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 85% and 120% 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.	12
10	Create three new scenarios for the same three levels of hours usage but with a 3.5% increase in the wage rate. Create and name these three scenarios (in this order) as Min Hours w/Raises, Avg Hours w/Raises, and Max Hours w/Raises.	12
11	Create three new scenarios with the same three levels of hours but a 3% increase in wage ratew (rounded) and a Benefit % of 35% . Create and name these three scenarios (in this order) Min Hours w/Raises&Benefits, Avg Hours w/Raises&Benefits, and Max Hours w/Raises&Benefits. Ensure that the Avg Hours scenario is shown.	12
12	Display the results of the nine scenarios by creating a scenario summary.	6
13	Label the rows (in B6:B8 respectively) as Part Time Hours, Part Time Wage, and Part Time Benefits. The expense row (in B10) needs to be named PT Wage Expense. Delete the existing values in C6:C8 and C10.	4
14	Save and close Excel_Ch10_PS1_Schedule.xlsx. Exit Excel. Submit your files as directed.	0