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

Answer rating: 100% (QA)

Based on these factors recommend t... View the full answer