Student data file needed: e05ch10Schedule.xisx You will save your file as: e0Sch10Schedule_LastFirst.xisx Scheduling Employees The Painted Paradise Resort & Spa is working on getting a handle on its expenditures on part-time labor. The management feels that there is some opportunity to improve scheduling to reduce costs in some areas. One area has the requirements that the schedules be five days a week with two days in a row off. With these constraints, they would like to build an optimal schedule (from a cost perspective). Management is also considering the impact of raises and potential benefits increases due to new regulations. a. Open the Excel file, e05ch10Schedule. Save your file as e05ch10Scheduie_Lastfirst using your last and first name. If necessary, enable content. b. The Schedule worksheet has the possible schedules each employee can work (rows 6-12). The is represent the days worked, and the Os represent the days off (so each schedule has two days in a row off). The range D6:D12 contains the number of employees assigned to the schedule in the corresponding row. This range will need to be changed to fulfil the scheduling needs. c In cell F14, enter a formula that will calculate the total number of employees scheduled to work Sunday for all scheduies A-G. Begin by multiplying the number of employees for schedule A, in cell D6, by the value representing whether or not employees are working that day in cell F6. Be sure to make the reference to cell D6 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. d. Copy the formula over to L14. e. In cell D19, calculate the total number of shifts scheduled, using the range F14:114. f. In cell D21, enter a formula that calculates the payroll for the week, which is the product of shifts scheduled and cost per employee per day.

Student data file needed: e05ch10Schedule.xisx You will save your file as: e0Sch10Schedule_LastFirst.xisx Scheduling Employees The Painted Paradise Resort & Spa is working on getting a handle on its expenditures on part-time labor. The management feels that there is some opportunity to improve scheduling to reduce costs in some areas. One area has the requirements that the schedules be five days a week with two days in a row off. With these constraints, they would like to build an optimal schedule (from a cost perspective). Management is also considering the impact of raises and potential benefits increases due to new regulations. a. Open the Excel file, e05ch10Schedule. Save your file as e05ch10Scheduie_Lastfirst using your last and first name. If necessary, enable content. b. The Schedule worksheet has the possible schedules each employee can work (rows 6-12). The is represent the days worked, and the Os represent the days off (so each schedule has two days in a row off). The range D6:D12 contains the number of employees assigned to the schedule in the corresponding row. This range will need to be changed to fulfil the scheduling needs. c In cell F14, enter a formula that will calculate the total number of employees scheduled to work Sunday for all scheduies A-G. Begin by multiplying the number of employees for schedule A, in cell D6, by the value representing whether or not employees are working that day in cell F6. Be sure to make the reference to cell D6 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. d. Copy the formula over to L14. e. In cell D19, calculate the total number of shifts scheduled, using the range F14:114. f. In cell D21, enter a formula that calculates the payroll for the week, which is the product of shifts scheduled and cost per employee per day.

Name: I have an excel project that I'm stuck with. I'm including screen sho
Uploaded: 2024-03-20T06:57:05.000Z
Channel: Bartleby
Description: I have an excel project that I'm stuck with. I'm including screen shots of the project. One screen shot includes all the instructions to follow on the project. The second screen shot includes the excel file needed for it. I have been able (I thin