Start Excel. Open the downloaded file named Excel_CH10_PS1_FrontDesk.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 FrontDeskShifts worksheet contains a template for the next two day schedule. The employee preferences are listed in the table in cells C8:G12. Cells C15:G19 contains a template for two days worth of shifts at the front desk. These cells should contain a 1 if a given employee from column C works a shift and a 0 if they do not. This range will need to be changed to fulfill the scheduling needs. Each employee must be scheduled to work two shifts over the course of the schedule. In cell H16, enter a formula that will calculate the total number of shifts from cells D16:G16. Copy the formula down to cell H19.
3	Each shift must have two employees assigned to it. In cell D20, calculate the total number of employees scheduled, using the range D16:D19. Copy the formula across to cell G20.
4	Each employee can only work a single shift per day. In cell D25 enter a formula that calculates the number of Day 1 shifts for Stewart. Fill the formula down to cell D28 using fill without formatting.
5	In cell E25 calculate the total number of Day 2 shifts for Stewart. Fill the formula down to cell E28 using fill without formatting.
6	In order to construct a schedule that meets the employees most preferred shifts, calculate the total preference rating in D30. This calculation should multiply each cell from the range D9:G12 with the corresponding cells in D16:G19. This can be accomplished with several Excel functions. It may be most effective to multiply the range D9:G12 with D16:G19 within a sum function.
7	Using Solver, minimize the Preference Total by determining which shift each employee works. Remember these points as you complete the Solver Parameters dialog box. Each employee must work two shifts. Each shift must have two employees assigned. The number of shifts per day for each employee must be less than or equal to one. Solve the model using Simplex LP and keep the Solver Solution.
8	On the Forecast sheet, in cell C9, insert a formula to calculate the gross revenue from spa appointments and product sales.
9	In cell G10, insert a formula to calculate the total fixed costs from employee salaries and operating costs.
10	In cell G13, insert a formula to calculate the employee commissions from the value in F13 and the revenue from spa appointments.
11	In cell G14, insert a formula to calculate the total expenses from the total fixed costs and the employee commissions.
12	In cell B15, insert a formula to calculate the net income from gross revenue and total expenses.
13	Create three scenarios based on the values in the Forecast sheet. The spa management would like to consider scenarios where the revenue from spa appointments and product sales, and operating costs could vary. The first scenario is based on the values already in the sheet. Name this scenario Best Case Create a new scenario named Most Likely where the revenue from the spa appointments is $145,000, the revenue from the Product Sales is $60,000, and Operating Costs are $20,000. Create a final scenario named Worst Case where the revenue from the spa appointments is $130,000, the revenue from the Product Sales is $50,000, and Operating Costs are $25,000.
14	Display the results of the three scenarios created in the prior step by creating a Scenario PivotTable report using the net income as the results cell.
15	On the Scenario PivotTable sheet, replace the text in A1 with Spa Forecast and in cell A2 enter the text Scenario PivotTable Report and change the font to be bold and 14 point. Merge and center cell A2 across cell B2. Adjust the width of the columns to display all text. Format cells B4:B6 as Currency. Replace the text in cell A3 with Scenarios and replace the text in cell B3 with Net Income
16	Save and close Excel_Ch10_PS1_Schedule.xlsx. Exit Excel. Submit your files as directed.

Can you please provide a step-by-step walk through of each step and where to go to input and how to set up the formulas for each specific calculation. Please do not repeat the instructions. Thank you