Groups

    Anyone good at staff rostering?

    Trying to devise a new roster for work, my head's bursting with it.

    Rep for any help, details in next post.

    26 Comments

    Original Poster

    Requirements:
    1. 6 man roster Sun-Sat, 3 people dayshift 3 people backshift to rotate each week.
    2. Requirement to cover 2 shift times - dayshift (06:00-13:00) and backshift (13:00-20:00).
    3. Based on a 5 day 35 hour working week with 2 rest days per week.
    4. 4 people to be out mon-fri (2 dayshift 2 backshift), 3 on a sat (2 dayshift, 1 backshift) , 2 on a sunday (1 dayshift, 1 backshift).

    EDIT: forgot to add, where possible, people to stay on the same side of the shift for the week (i.e dayshift all week)
    Oh, and the 4 out during the week is a minimum, 5 or 6 out on the one day is fine too

    Good luck with this Rex, I do staff rota's but not as complex.
    I normally cheat by asking them what hours they prefer and that sometimes sorts it out easily.

    I'm too tired now - but if you havent had any help before you go tonight send me a pm and I'll take a look tomorrow.

    may i ask what this one means then i will try to help, though cant say il be any good

    4 people to be out mon-fri (2 dayshift 2 backshift), 3 on a sat (2 dayshift, 1 backshift) , 2 on a sunday (1 dayshift, 1 backshift).

    Original Poster

    allstar2;3754310

    may i ask what this one means then i will try to help, though cant say il … may i ask what this one means then i will try to help, though cant say il be any good4 people to be out mon-fri (2 dayshift 2 backshift), 3 on a sat (2 dayshift, 1 backshift) , 2 on a sunday (1 dayshift, 1 backshift).



    mon-fri, 4 people out in total (other 2 would be rest day) split into 2 out dayshift, 2 out backshift
    Sat, 3 people out in total , 2 dayshift, 1 backshift
    Sun 2 people out in total, 1 dayshift, 1 backshift
    :thumbsup:

    just had a quick look and based on above shift pattern, you are struggling for Saturday if all are on a 5 day week you can only have on a Sat,

    Original Poster

    FredBloggs1966;3754373

    just had a quick look and based on above shift pattern, you are … just had a quick look and based on above shift pattern, you are struggling for Saturday if all are on a 5 day week you can only have on a Sat,



    The 5 days can be split up with rest days i.e out sun-tue, off wed+thurs, in fri+sat :thumbsup:

    sorry cant help you then

    Is the working times on sunday the same as the rest of the week?

    Original Poster

    leefal;3754411

    Is the working times on sunday the same as the rest of the week?



    yeah, just a 6-1 and a 1-8 shift :thumbsup:

    Have you thought of extending the hours ?
    I used to do 3 earlys,three lates and three off - I then changed it to three double shifts with six days off.Its a killer,but if anyone went sick there were plenty of takers for the OT.

    Is it your job to be devising these rosters? If it is you might want to sort it out for yourself. After all, you can't be asking on here each time they need to be changed.

    You can get rostering software (haven't tried any though) - you could try and find a trial or shareware version....

    Original Poster

    Monkeybumcheeks;3754443

    Have you thought of extending the hours ?I used to do 3 earlys,three … Have you thought of extending the hours ?I used to do 3 earlys,three lates and three off - I then changed it to three double shifts with six days off.Its a killer,but if anyone went sick there were plenty of takers for the OT.



    Can't do it - requirements of the business and all that. :?

    Basically been told to get a roster in place for myself and 5 colleagues (area managers) or else we're going to get shafted with something which will have one of us out to midnight each night, and 4 out of the 6 of us out on both Saturdays and Sundays. Have until Monday to come up with something, but everything I look at simply doesn't balance. :x

    OH, and we have an overtime ban on lol :roll:

    Original Poster

    deek72;3754465

    Is it your job to be devising these rosters? If it is you might want to … Is it your job to be devising these rosters? If it is you might want to sort it out for yourself. After all, you can't be asking on here each time they need to be changed.



    Not really my job, and once in place, they won't be getting changed.

    gari189;3754482

    You can get rostering software (haven't tried any though) - you could try … You can get rostering software (haven't tried any though) - you could try and find a trial or shareware version....



    Tried a couple of things, VERY complex to use and don't seem to be geared towards what I'm trying to achieve.

    ill give it a go 2morra... just to do rota for work quiet easy when you know how

    use to do 2 x 12 hrs sat and sun as the rota never worked out once.

    I do it they work 5 days outta 7 yea? .. 2 days off ? do these need to be together?

    grex9101;3754502

    Can't do it - requirements of the business and all that. :?Basically been … Can't do it - requirements of the business and all that. :?Basically been told to get a roster in place for myself and 5 colleagues (area managers) or else we're going to get shafted with something which will have one of us out to midnight each night, and 4 out of the 6 of us out on both Saturdays and Sundays. Have until Monday to come up with something, but everything I look at simply doesn't balance. :xOH, and we have an overtime ban on lol :roll:



    Do you work at my place LOL - I reckon there must be some enormous (secret) meeting of company directors rubbing there greedy hands together because of the credit crunch.The [email protected]@rds !

    I sympathise with you cause they want more than their pound of flesh now and can use scare/bully boy tactics to get what they want - we had a similar thing after 9/11 even though revenue went through the roof.

    i dont know if this helps clarify but you got 25 shifts to fill with enough staff to fill 30 shifts

    ie more staff than shifts


    thats right , right grex or am i that drunk lol

    Original Poster

    Disco;3754554

    ill give it a go 2morra... just to do rota for work quiet easy when you … ill give it a go 2morra... just to do rota for work quiet easy when you know howuse to do 2 x 12 hrs sat and sun as the rota never worked out once. I do it they work 5 days outta 7 yea? .. 2 days off ? do these need to be together?



    Days off don't need to be together, though would be nice!

    Monkeybumcheeks;3754568

    Do you work at my place LOL - I reckon there must be some enormous … Do you work at my place LOL - I reckon there must be some enormous (secret) meeting of company directors rubbing there greedy hands together because of the credit crunch.The [email protected]@rds !I sympathise with you cause they want more than their pound of flesh now and can use scare/bully boy tactics to get what they want - we had a similar thing after 9/11 even though revenue went through the roof.



    Yeah, it's pathetic. We had our "no more overtime" meeting a few weeks ago, next day a company memo came out announcing record profits!!! :x

    DIVA1977;3754579

    i dont know if this helps clarify but you got 25 shifts to fill with … i dont know if this helps clarify but you got 25 shifts to fill with enough staff to fill 30 shiftsie more staff than shifts



    Plenty of bodies, just trying to work something with a good work/life balance that will tumble easily week to week and give a fair spread of shifts to all involved

    DIVA1977;3754579

    i dont know if this helps clarify but you got 25 shifts to fill with … i dont know if this helps clarify but you got 25 shifts to fill with enough staff to fill 30 shiftsie more staff than shiftsthats right , right grex or am i that drunk lol



    No you're right, grex you're gonna have to have days probably during the week (busiest days?) when there's more than 2 in the morn and 2 in the evenin', assuming they're all on 35hr contracts.

    Can I ask when you say "out" do you mean "working" or "off"???

    Original Poster

    leefal;3754770

    No you're right, grex you're gonna have to have days probably during the … No you're right, grex you're gonna have to have days probably during the week (busiest days?) when there's more than 2 in the morn and 2 in the evenin', assuming they're all on 35hr contracts.



    You're right, that's fine. All 6 of us can be out if need be - 4 during the week is a minimum number.

    alfie73;3754773

    Can I ask when you say "out" do you mean "working" or "off"???



    Sorry, "out" working!!! :oops:

    What type of work is it, what are your busy days?

    Original Poster

    alfie73;3754838

    What type of work is it, what are your busy days?



    transport sector, as with most businesses, monday can be busy, but as long as there's a minimum of 2 out either side of the shift, there's no real problem :thumbsup:

    i also used to do rota's and i can safelly say this cant be done ! you would have to let someone go ! an easy calculation tells you that , let me explain !

    6 staff X 35 hours = 210 hours needed

    then going by your requirements !

    sunday 2 staff = 14 hours
    monday 4 staff =28 hours
    tuesday 4 staff =28 hours
    wednesday 4 staff = 28 hours
    thursday 4 staff = 28 hours
    friday 4 staff = 28 hours
    sat 3 staff = 21 hours
    Total = 175 hours

    therefore 210 - 175 = 35 hours to many = 1 staff member goes bye bye

    Original Poster

    geedub;3755277

    i also used to do rota's and i can safelly say this cant be done ! you … i also used to do rota's and i can safelly say this cant be done ! you would have to let someone go ! an easy calculation tells you that , let me explain !6 staff X 35 hours = 210 hours needed then going by your requirements !sunday 2 staff = 14 hoursmonday 4 staff =28 hourstuesday 4 staff =28 hourswednesday 4 staff = 28 hoursthursday 4 staff = 28 hoursfriday 4 staff = 28 hours sat 3 staff = 21 hours Total = 175 hours therefore 210 - 175 = 35 hours to many = 1 staff member goes bye byeunless you have 5 in mon-fri



    Totally get what you're saying mate, don't think it's to reduce body count, more to produce a more "robust" weekday roster.

    Alfie73 has helped me out over pm (thanks again) so I'm looking at a workable roster now.

    Thanks to all who've helped, repped as many as I can :thumbsup:
    Post a comment
    Avatar
    @
      Text
      Top Discussions
      1. help: windows 10 wifi issue13
      2. Golf DSG GTD Real MPG?11
      3. word survey34
      4. Do cheeky drivers annoy you when they park outside your house and leave it …915

      See more discussions