I am trying to create an employee schedule with the following parameters.
1. I need to be able to enter each employees school schedule (times they cannot work)
2. I need to be able to enter preferred times of work.
3. I need the work shifts to be a maximum of three hours long at a time.
4. I need to enter the hours of operation for the job.
5. I need to enter in how many hours each employee is allowed
6. The schedule would need to make sure we have coverage etc.
For example:
John Doe is in class from 8-11 am on monday wednesday and friday and in class 11-12:45pm tuesday thursday.
John prefers to work mondays at 12-9, etc.
The idea is to enter in the employee, their school schedule (when they cannot work), their preferred working hours(which the schedule makes as much of a priority as possible), and the amount of hours the employee is allowed, and the schedule program schedules the employee for shifts no longer than 3 hours (this can be an entered parameter if needed) for the week and gives even coverage for all hours of operation. I have no idea how to start this so if anyone has any ideas it would be greatly appreciated.