Shift Roster - Xls Download - CiteHR
V.Raghunathan
Process Industry Consultant / Soft Skill
Pvenu1953@gmail.com
Retired Government Servant/advocate
+1 Other

Prime Sponsor - FactoHR.com - Payroll Software with GPS Enabled Attendance, Travel, Performance Management, HRMS. Explore Features
Dear All,
I Am Facing A Challenge In Making A Roster For My THREE Members Team To Handle 24x7 Environment. Below Are The Constraints.
Is There Any Tool By Which We Can Do The Scheduling Automatically For Staff. Please Help.
1) No. Of Employees - 3
2) 24x7 Environment
3) 3 Shifts Per Day, 8 Hours Each
4) Like To Distribute Equal Morning, Afternoon And Night Shifts Between Team Members and it should be rotating
5) Like To Give Weekly Off After 5/6 Working Days
6) Weekly Off Should Be Consecutive
7) A reliever of these shift is provided but he will do only morning and evening shifts.
Kindly help me out. Its very urgent.
Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
Dear Rahul,
Please check the attached XL file.
Normally a reliever is supposed to cover any of the three shifts.
Your requirement says he would do only morning and afternoon shifts.
I am not aware of any tool.
Please extrapolate the XL file further.
Once you develop this for few months you can get a fair idea and at some stage
it will become repetitive and easy.
V.Raghunathan

Attached Files
Membership is required for download. Create An Account First
File Type: xls Typical Shift Roster.xls (14.0 KB, 848 views)

Dear Mr. Raghunathan, 7 continuous night shift won’t work, kindly suggest the roster which will have individual shifts of maximum three days.It would be favorable for employees too.
Dear Mr Rahul,
I wish you had tried once before making a request.
In the schedule give by me earlier, the maximum working days between two OFF days was only SIX
and not seven as you have mentioned.
Any way I have now made a FOUR WEEK schedule keeping all your requirements in mind.
Please extend this for three or four months using the columns so that you will
get practice before putting it in to use.
Goodluck,
V.Raghunathan

Attached Files
Membership is required for download. Create An Account First
File Type: xls Revised Typical Shift Roster.xls (25.0 KB, 655 views)

You cannot make the roster with three persons; it requires three and half persons.
Dear Mr Venu
You are right Mr Venu.
Theoretically three and half persons are required for one spot operating 24 X 7 on all days.
However to overcome this unrealistic 'three and half' person, a
fourth person is taken as a reliever. He does general shift for three days and covers relieving shifts in the next three days. Seventh day becomes his weekly off day.
In operating plants we consider 7 persons for two spots so that the seventh person becomes a reliever in two spots. If the spot is only one, obviously fourth person has to be there, doing three days shift duty and three days general shift duty.
Rahul's case is however different. He has a reliever who would come only in the morning and afternoon shifts. Again he does not want any one to do more than three nights at a stretch. Hence it requires a long planning spread over many days.
Please see Sr No 7 point in the first post of Rahul.
You can also go through the Xl file and give your suggestions to Rahul.
V.Raghunathan
Staff Count in the Call Centre : 160 :
Team of 10 each so 16 Teams
Need to run 3 shifts , 12 hours each, want to create a model of 4 days working 4 days off.
Can anyone help in creating such a model:
Based on Peak hour requirements the following shifts are required.
08.00-10.00 : Min : 4 Teams (40 headcount)
10.00 - 20.00 : 3 Teams (30 headcount)
20.00-08:00 : 3 Teams (30 Headcount)
Prime Sponsor - Talentedge.com "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA. View Courses
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™