Shift allocation
system
We built a spreadsheet system for a major transport
company who needed a system to allocate staff to shift
patterns without double booking the staff or to have a
member of staff booked on overlapping trips.
The
system monitors the number of hours a person is booked
to work in a day and over a week ensuring that the hours
worked are within the regulations.
Shift
details are printed out for each member of staff and for
shift managers.
Management reports are produced.
Staff
complete timesheets which are then entered into the
spreadsheets against booked shifts.
Variation
reports are produced and more importantly reports for
the payroll department so that the staff can get paid.
