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)