Question
Linear, Integer and Mixed Integer Programming: The third evaluation concerns staff scheduling. Some of the customers have complained that service is slow. The restaurant is
Linear, Integer and Mixed Integer Programming: The third evaluation concerns staff scheduling. Some of the customers have complained that service is slow. The restaurant is open from 11:00 a.m. to midnight every day of the week. Tony divided the workday into five shifts. The table below shows the minimum number of workers needed during the five shifts of time into which the workday is divided. Shift Time # of Staff Required 1 10:00 a.m. – 1:00 p.m. 3 2 1:00 p.m. – 4:00 p.m. 4 3 4:00 p.m. – 7:00 p.m. 6 4 7:00 p.m. – 10:00 p.m. 7 5 10:00 p.m. – 1:00 a.m. 4 The owners must find the right number of staff to report at each start time to ensure that there is sufficient coverage. The organization is trying to keep costs low and balance the number of staff with the size of the restaurant, so the total number of workers is constrained to 15. Based on these factors, recommend the staff for each shift to accommodate the minimum requirements for customer service. Use Excel to show work.
Shift | Time | # of Staff Required |
1 | 10:00 a.m. – 1:00 p.m. | 3 |
2 | 1:00 p.m. – 4:00 p.m. | 4 |
3 | 4:00 p.m. – 7:00 p.m. | 6 |
4 | 7:00 p.m. – 10:00 p.m. | 7 |
5 | 10:00 p.m. – 1:00 a.m. | 4 |
Step by Step Solution
3.45 Rating (164 Votes )
There are 3 Steps involved in it
Step: 1
Based on these factors recommend t...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started