Unit 5 Assignment: Case Study 3 (CIS250 Advanced Excel)
ceteiv
CaseStudy3_Staff.xlsx
Raleigh Schedule
| Weekday Work Schedule |
| Servers |
| Start Time | End Time | Hours Worked | Employees | 10:30 - 11:00 | 11:00 - 12:00 | 12:00 - 1:00 | 1:00 - 2:00 | 2:00 - 3:00 | 3:00 - 4:00 | 4:00 - 5:00 | 5:00 - 6:00 | 6:00 - 7:00 | 7:00 - 8:00 | 8:00 - 9:00 | 9:00 - 10:00 | 10:00 - 10:30 |
| 10:30 AM | 2:00 PM | 3.5 | 4 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 11:00 AM | 3:00 PM | 4 | 4 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 12:00 PM | 4:00 PM | 4 | 4 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 4:00 PM | 8:00 PM | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 |
| 5:00 PM | 9:00 PM | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 |
| 6:00 PM | 10:30 PM | 4.5 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 |
| | | Employees Scheduled | 24 | 4 | 8 | 12 | 12 | 8 | 4 | 4 | 8 | 12 | 12 | 8 | 4 | 4 |
| | | Employees Needed | | 2 | 6 | 12 | 10 | 3 | 2 | 3 | 8 | 12 | 12 | 10 | 3 | 2 |
| | | Surplus or (Shortage) | | 2 | 2 | 0 | 2 | 5 | 2 | 1 | 0 | 0 | 0 | -2 | 1 | 2 |
| | | Total Hours | 96.00 |
