Table 1 An optimal schedule
From: Personnel scheduling using an integer programming model- an application at Avanti Blue-Nile Hotels
Shift ID | Employee ID | Number of | ||||||
|---|---|---|---|---|---|---|---|---|
employees | ||||||||
assigned | ||||||||
Day | Shift | 1 | 2 | 3 | 4 | 5 | ||
1 | Monday | Morning | 1 | 1 | 2 | |||
2 | Afternoon | 1 | 1 | |||||
3 | Night | 1 | 1 | |||||
4 | Tuesday | Morning | 1 | 1 | ||||
5 | Afternoon | 1 | 1 | 1 | 3 | |||
6 | Night | 1 | 1 | |||||
7 | Wednesday | Morning | 1 | 1 | ||||
8 | Afternoon | 1 | 1 | 2 | ||||
9 | Night | 1 | 1 | |||||
10 | Thursday | Morning | 1 | 1 | ||||
11 | Afternoon | 1 | 1 | |||||
12 | Night | 1 | 1 | 2 | ||||
13 | Friday | Morning | 1 | 1 | 2 | |||
14 | Afternoon | 1 | 1 | |||||
15 | Night | 1 | 1 | |||||
16 | Saturday | Morning | 1 | 1 | ||||
17 | Afternoon | 1 | 1 | 2 | ||||
18 | Night | 1 | 1 | |||||
19 | Sunday | Morning | 1 | 1 | 2 | |||
20 | Afternoon | 1 | 1 | 2 | ||||
21 | Night | 1 | 1 | |||||
No of shifts assigned | 6 | 6 | 6 | 6 | 6 | |||