Dear All,
I am facing a challenge in making a roster for my three-member team to handle a 24x7 environment. Below are the constraints. Is there any tool by which we can do the scheduling automatically for staff? Please help.
1) Number 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 a weekly off after 5/6 working days
6) Weekly off should be consecutive
7) A reliever of these shifts is provided, but he will do only morning and evening shifts.
Kindly help me out. It's very urgent.
From India, Mumbai
Acknowledge(0)
Amend(0)
I am facing a challenge in making a roster for my three-member team to handle a 24x7 environment. Below are the constraints. Is there any tool by which we can do the scheduling automatically for staff? Please help.
1) Number 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 a weekly off after 5/6 working days
6) Weekly off should be consecutive
7) A reliever of these shifts is provided, but he will do only morning and evening shifts.
Kindly help me out. It's very urgent.
From India, Mumbai
Acknowledge(0)Amend(0)
Dear Rahul,
Please check the attached XL file. Normally, a reliever is supposed to cover any of the three shifts. However, your requirement states that he would only work the morning and afternoon shifts. I am not aware of any specific tool. Kindly provide further details regarding the XL file.
Once you have developed this for a few months, you can gain a fair idea of the process. Eventually, it will become repetitive and easier to manage.
V. Raghunathan
From India
Acknowledge(0)Amend(0)
1366Please check the attached XL file. Normally, a reliever is supposed to cover any of the three shifts. However, your requirement states that he would only work the morning and afternoon shifts. I am not aware of any specific tool. Kindly provide further details regarding the XL file.
Once you have developed this for a few months, you can gain a fair idea of the process. Eventually, it will become repetitive and easier to manage.
V. Raghunathan
From India
Acknowledge(0)Amend(0)
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.
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
Dear Mr. Rahul,
I wish you had tried once before making a request. In the schedule given by me earlier, the maximum working days between two OFF days was only SIX and not seven as you have mentioned. Anyway, 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 into use.
Good luck,
V. Raghunathan
From India
Acknowledge(0)Amend(0)
I wish you had tried once before making a request. In the schedule given by me earlier, the maximum working days between two OFF days was only SIX and not seven as you have mentioned. Anyway, 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 into use.
Good luck,
V. Raghunathan
From India
Acknowledge(0)Amend(0)
You cannot make the roster with three persons; it requires three and half persons.
From India, Kochi
Acknowledge(0)Amend(0)
From India, Kochi
Acknowledge(0)Amend(0)
Dear Mr. Venu,
You are right, Mr. Venu. Theoretically, three and a half persons are required for one spot operating 24/7 on all days. However, to overcome this unrealistic 'three and a half' person scenario, a fourth person is taken as a reliever. He works the general shift for three days and covers relieving shifts for the next three days, with the seventh day designated as his weekly off day.
In operating plants, we consider seven persons for two spots so that the seventh person can act as a reliever for both spots. If there is only one spot, obviously a fourth person has to be there, working three days of shift duty and three days of general shift duty.
Rahul's case is different, though. He has a reliever who only covers the morning and afternoon shifts. Additionally, he prefers to limit any individual to a maximum of three consecutive night shifts. Therefore, effective planning spread over several days is necessary.
Please refer to Sr. No. 7 in the first post by Rahul. Also, review the Excel file and provide your suggestions to Rahul.
V. Raghunathan
From India
Acknowledge(0)Amend(0)
You are right, Mr. Venu. Theoretically, three and a half persons are required for one spot operating 24/7 on all days. However, to overcome this unrealistic 'three and a half' person scenario, a fourth person is taken as a reliever. He works the general shift for three days and covers relieving shifts for the next three days, with the seventh day designated as his weekly off day.
In operating plants, we consider seven persons for two spots so that the seventh person can act as a reliever for both spots. If there is only one spot, obviously a fourth person has to be there, working three days of shift duty and three days of general shift duty.
Rahul's case is different, though. He has a reliever who only covers the morning and afternoon shifts. Additionally, he prefers to limit any individual to a maximum of three consecutive night shifts. Therefore, effective planning spread over several days is necessary.
Please refer to Sr. No. 7 in the first post by Rahul. Also, review the Excel file and provide your suggestions to Rahul.
V. Raghunathan
From India
Acknowledge(0)Amend(0)
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)
From India, Mumbai
Acknowledge(0)Amend(0)
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)
From India, Mumbai
Acknowledge(0)Amend(0)Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
Shift Roster Sample.docx
Shift Roster.xls