I have the task of creating a 9/80's work schedule and quite honestly need help. I have provided details below:
9hr Shifts, Flex Day being 8hrs (1 Being AM Shift from 5AM-2:30PM and 1 Being PM Shift from 7:30AM-5:00PM). I need 4 Employees assigned to AM and 4 Employees assigned to PM and only need 2 Employees on Saturday and 2 Employees on Sunday working.
Hours of Operation from 5AM to 5PM
7 Days a Week Operation
I am looking for a shift bid schedule type excel spreadsheet to outline the above information in an Excel 2007 format. The "Flex" day meaning every other week the employee will have 3 days off and can vary. If possible I would like everyone to at least have 1 full weekend off..and then rotates. I am looking for this shift bid/schedule to start on Sunday March 31, 2013 and end on June 1, 2013.