A grocery store is open 24 hours a day, seven days a week. It has the following
Question:
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 theshifts and, having begun, works 9 consecutivehours. Each cashier is paid $15 perhour.
Formulate the employee scheduling problem that minimizes thetotal daily cost, meeting the minimum level ofeach shift’s requirements. Implement this problem into excel andsolve for the optimal solutions.
What is optimal number of people working for shift0100-0400? (Please type ONLYNUMBERS with NO ROUNDING inthe answer box)
Managerial Decision Modeling With Spreadsheets
ISBN: 9780136115830
3rd Edition
Authors: Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair