Roster query

Hi parry1234

Welcome to the forum

I am not sure that what you want can be achieved. I am sure that what you want cannot be achieved from what you have given us!

Your item 5 gives the minimum headcount. Ignoring 11:00 am - 5:00pm (as you have!) (ie assuming no headcount), the remaining hours total 124 man-hours. You have 11 employees who each work a 9 hour shift (a reasonable assumption, I think). 11 x 9 = 99 man hours, so you are a little (20%) short to start with. If your head count has to take into account when people are on a break, the shortage increases. You say that "5 days working" (I am guessing that this per week) so the shortage gets worse on their 2 days off. It gets worse still when they take "2 weeks off" (I am guessing that this is per year?).

A person works a 9 hour shift with 1 hour out for 5 days a week = 40 hours. Over a year this is 40 x (52 - 2) 2,000.
Your headcount requires 124 per day, x7 = 868 per week over a 52 week year = 45,136. You will see that you need 22.568 employees who are infinitely accommodating about the hours they work and never go sick.

Your example is not particularly helpful as poor old Ashish Paul works continuously from 30 Dec 13 to 31 Mar 14 with no break at all !

Back to the drawing board, perhaps?

Regards
Alastair

Alastair I could have made some mistake or may you got me confused a little or maybe I did not explain my shift system in the right manner. Would you be able to ask me particular questions that you are looking to get an answer for?

Regards,

Hi parry1234

What I am saying is that it is not possible to achieve your requirements of headcount with the number of persons available.

If your headcount requirements are as you state, then this can only be achieved by a minimum of 22.568 employees. This number will have to be increased if you want anyone to cover the 11:00 am - 5:00 pm period.

I could ask particular questions, but I need to know what your restrictions are. Either you have to increase the staff available or you need to decrease the headcount requirement.

Happy Christmes
(and I appreciate that you may not be Christian, but I can still wish you a happy time )

Alastair

Hi Alastair,

I think I have not been able to communicate the shift layout correctly. I am mentioning the requirements in a rather more simpler way below for your consideration.

5:00PM to 2:00AM - 2 People
7:00PM to 4:00AM - 3 People
10:00PM to 7:00AM - 4 People
2:00AM to 11:00AM - 3 People

Total Employees = 15

5:00PM to 2:00AM - 2 (They will have support of the people ending shift @ 4AM & 7AM)
7:00PM to 4:00AM - 3 (They will have support of the people ending shift @ 2AM)
10:00PM to 7:00AM - 4 People (They will have support of the people ending shift @ 4AM)
2:00AM to 11:00AM - 3 People (They will have support of the people ending shift @ 7AM)

Does this work out? Head Count taken upto 15 rest of the things remain as I posted in my first post.

Regards,

PARRY1234

Hi parry1234

Closer - but it still will not work.

I attach a spreadsheet setting out my understanding of your post #5. Even though

rest of the things remain as I posted in my first post.

I have ignored the minimum requirements, but still the headcount is not enough.

On my tab "Given Headcount" you will the you require 17.472 people to support the headcount in #5. I have not checked how to accommodate the 2 days off - so this might mean more even people required.

On my tab "Given employees" I show how an approach using 15 people might be accommodated. Note that there is nobody covering 11:00 am to 5:00pm.

In your first post you mention breaks. Do these have to be taken into consideration or is it just additional information?
In your first post you mention

Shift Rollover should be every 15 days.

How do these work?

As you can see I am trying to understand, but it is stretching me

I still stand by my second sentence, but let's try and prove me wrong (as I have been so many times in the past )

Regards
Alastair (note I shall be offline 25 December for a few days)

Just to give you some idea what will work and not work. Using the information you have supplied in this thread I have generated the best outcome based on the staff

cover for these shifts. It confirms 'Aydeegee' observation that 15 staff is unworkable, so you can stop pursuing that line of enquiry. The attached pattern delivers the staff distribution you want on these shifts viz:

1. Maximum daily hours 9;
2. Average daily hours 9;
3. Maximum hours per rolling week 54;
4. Average hours per rolling week 42;
5. Minimum rest period between shifts 15 hours;
6. Average rest period between shifts 15:24 hours;
7. 12 staff working each day;
8. 18 staff required;
9. Shift pattern cycle 54 days before repeating;
10. Fast rotating pattern based on a 3 day cycle (though bear in mind you have 4 times as many staff working nights than 5pm 2am evenings for example).

I have assumed a 6 days on 3 days off ration to get these weekly hours. A 5 days on and 2 days off ratio doesn't work as far as rotating days off go. That means staff always have the same day off, great if its weekends not so great if it is weekedays. There are several permutations but this is as close as you are going to get with these shifts and staff distribution goals outlined above.