I am having problems figuring out where to place the data so that I can run the excel solver.....
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. Refer to the Excel spreadsheet "Benchmark Assignment - Data Analysis Case Study Linear Programming Template."