Startup Idea: Employee Schedule Randomizer for Multiple Disciplines
I'm looking for a way to randomize a schedule for employees who can work in either 1 or 2 of 3 disciplines and keep it fair across the board for everyone. For instance there are 32 employees on a shift (however there are 4 total shifts so 128 employees total) who can work either 1 or 2 jobs; we'll call them jobs A B and C.
Job A requires 6 employees, Job B requires 14, and Job C requires 12.
Below is what each employee (per shift) can work:
4 employees can only work Job A 6 employees can only work Job B 6 employees can only work Job C
4 employees are promoted and can work both Jobs A & B 3 employees are promoted and can work both Jobs A & C 9 employees are promoted and can work both Jobs B & C
With this information I want to randomize a schedule in which everyone is assigned a schedule and the promoted employees are assigned both jobs in the month fairly.
I'd like to be able to add an employee by name and be able to edit their parameters to work specific jobs and also move employees from shift to shift as needed. Other options that would be beneficial are:
-
locking promoted employees to work only 1 job; this occurs when they are training 1 job employees to work a second job.
-
keeping track of 2 job employees over a given time frame to make sure their time has been split evenly. Handwriting this schedule is a nightmare and takes me forever. Going back and keeping track of multi-job employee hours is an even bigger headache.
Submitter: Chris - (view contact info)