In: Statistics and Probability
A grocery store is open 24 hours a day, seven days a week. It has the following daily requirements for cashiers:
Time Minimum # of cashiers
0100 – 0400 7
0400 – 0700 4
0700 – 1000 9
1000 – 1300 12
1300 – 1600 15
1600 – 1900 17
1900 – 2200 19
2200 – 0100 13
A cashier may start work at the beginning of any one of the shifts and, having begun, works 9 consecutive hours. Each cashier is paid $15 per hour.
Formulate the employee scheduling problem that minimizes the
total daily cost, meeting the minimum level of
each shift’s requirements. Implement this problem into excel and
solve for the optimal solutions.
What is optimal number of people working for shift 0100-0400?
(Please type ONLY NUMBERS with NO
ROUNDING in the answer box)