Hi, I just watched the solver video which gives a basic introduction on how to use it and I would like some advice is solver can perform in the following scenario
Here's a sample set of data for part 1.
<tbody>
</tbody>
And here is a sample set of data for the staffs choices as backup
<tbody>
</tbody>
As you can see each staff member has picked, at least, or more than, their current workload figures. I now need to distribute each staff member as the backup making sure that they do not conflict with the primary support and everyone gets a single backup.
I hope I have explained the question correctly and please feel free to give me some pointers on how I can achieve this.
- Each year 25 customers are distributed between the 5 staff members based on a workload ability
- Next the staff pick and equal or greater number of customers who they feel their skill set will help as a backup, As there are a greater number of Backup choices there will be some overlap.
- Finally the staff are allocated their backup customers ensuring they meet at least their workload ability quota,
Here's a sample set of data for part 1.
Staff | Customers | ||||||
Name | Workload | Name | Primary Support | Backup | |||
Bennie | 5 | Ada | Gita | ||||
Marchelle | 3 | Awilda | Marchelle | ||||
Gita | 7 | Beula | Gita | ||||
Albert | 4 | Brenna | Bennie | ||||
Cecil | 6 | Delora | Bennie | ||||
Elisha | Albert | ||||||
Esta | Marchelle | ||||||
Janis | Albert | ||||||
Jann | Gita | ||||||
Julissa | Cecil | ||||||
Kareem | Cecil | ||||||
Lacy | Gita | ||||||
Maida | Gita | ||||||
Marta | Cecil | ||||||
Nadene | Bennie | ||||||
Nanci | Cecil | ||||||
Precious | Albert | ||||||
Rebbeca | Cecil | ||||||
Rene | Gita | ||||||
Roy | Albert | ||||||
Sherie | Cecil | ||||||
Soo | Bennie | ||||||
Soraya | Gita | ||||||
Suzi | Marchelle | ||||||
Wilmer | Bennie |
<tbody>
</tbody>
And here is a sample set of data for the staffs choices as backup
Bennie | Ada | Elisha | Janis | Kareem | Lacy | Nanci | |||
Marchelle | Beula | Brenna | Delora | Julissa | Maida | Precious | Rene | Soo | Suzi |
Gita | Ada | Delora | Esta | Julissa | Marta | Nadene | Roy | Soo | |
Albert | Awilda | Esta | Jann | Julissa | Maida | Nadene | Rebbeca | Sherie | Wilmer |
Cecil | Beula | Elisha | Esta | Lacy | Nadene | Precious | Rene | Soraya |
<tbody>
</tbody>
As you can see each staff member has picked, at least, or more than, their current workload figures. I now need to distribute each staff member as the backup making sure that they do not conflict with the primary support and everyone gets a single backup.
I hope I have explained the question correctly and please feel free to give me some pointers on how I can achieve this.