Man maths help please cos I is a dense wotsit
Discussion
Can anyone help me get a rough idea of staffing levels required to run this business scenario. (i'm just after a very gueste-estimate)
A unit has 100 residents on a 4 to 1 patient/nurse arrangement during the 'day'.
Staffing levels required 25 staff on day shifts 7am until 9pm
Staffing levels require 11 staff on night shifts 9pm until 7am
Staff cannot work more than 32 hours per week.
Annual holiday is 5 weeks a year.
So far the estimates i'm coming out with show somewhere near 75-80 staff (but I suspect my maths is somewhat lacking)
Cheers,
Thicky McThicky
Edit: Mods, please move to lounge or somewhere else seemingly suitable for this post. Ta
A unit has 100 residents on a 4 to 1 patient/nurse arrangement during the 'day'.
Staffing levels required 25 staff on day shifts 7am until 9pm
Staffing levels require 11 staff on night shifts 9pm until 7am
Staff cannot work more than 32 hours per week.
Annual holiday is 5 weeks a year.
So far the estimates i'm coming out with show somewhere near 75-80 staff (but I suspect my maths is somewhat lacking)
Cheers,
Thicky McThicky
Edit: Mods, please move to lounge or somewhere else seemingly suitable for this post. Ta
Edited by drivin_me_nuts on Saturday 9th November 15:42
Say you have a 100 staff including the nights. That's 5yrs annual leave a year plus let's say you have a 2 percent sick rate that's 2yrs sick too.
I'd look at having a 12 hr shift roster, possibly push the hours to 36 and have built in relief.
Perhaps one extra person on duty per shift to cover for sick and leave?
I'd look at having a 12 hr shift roster, possibly push the hours to 36 and have built in relief.
Perhaps one extra person on duty per shift to cover for sick and leave?
R0G said:
Many care homes are now doing the same as nurses shifts - 12 hour days and 12 hour nights with each shift being 12.5 hours for changeovers
Way too long IMO
Yup and designed by highly paid management consultants who aren't having to work the shifts, dealing with the stresses of the job, and relatively low wages!Way too long IMO
drivin_me_nuts said:
aaah, I forgot to explain that bit. Sorry, the max shift is 7 hours long.
Max shift has to be longer than 7 hours as you cant do a handover as 2 7 hour shifts is 14 hours which is the day shift with no handover. Also night shift is longer than 7 hours.However: -
32 hours a week gives 4 7 hour day shifts with 4 hours left
32 hours gives 3 10 hour night shifts with 2 left over.
You have 14 day shifts to cover in a week and 7 night shifts so you need 3.5 staff to cover day shifts and 2.33 staff to cover the night shifts so that gives 87.5 day staff in a week and 25.6 night staff to cover night shifts. However they spend 10% of their time on holiday so you need 96.25 staff to cover day shifts and 28.16 to cover night shifts, but if any go sick you are stuffed!
Chrisgr31 said:
Max shift has to be longer than 7 hours as you cant do a handover as 2 7 hour shifts is 14 hours which is the day shift with no handover. Also night shift is longer than 7 hours.
However: -
32 hours a week gives 4 7 hour day shifts with 4 hours left
32 hours gives 3 10 hour night shifts with 2 left over.
You have 14 day shifts to cover in a week and 7 night shifts so you need 3.5 staff to cover day shifts and 2.33 staff to cover the night shifts so that gives 87.5 day staff in a week and 25.6 night staff to cover night shifts. However they spend 10% of their time on holiday so you need 96.25 staff to cover day shifts and 28.16 to cover night shifts, but if any go sick you are stuffed!
Thanks for this - I was sure I was underestimating when I did my back of a fag packet calculation. So, about 115 staff assuming no leeway. Interestingly enough this place is looking at 75 permanent staff and the rest filled by bank. I think the bank staff will be very much in demand.However: -
32 hours a week gives 4 7 hour day shifts with 4 hours left
32 hours gives 3 10 hour night shifts with 2 left over.
You have 14 day shifts to cover in a week and 7 night shifts so you need 3.5 staff to cover day shifts and 2.33 staff to cover the night shifts so that gives 87.5 day staff in a week and 25.6 night staff to cover night shifts. However they spend 10% of their time on holiday so you need 96.25 staff to cover day shifts and 28.16 to cover night shifts, but if any go sick you are stuffed!
Cheers.
I designed a rota on a computer for a care home where my wife was the manager - before I did it they were using an A3 size piece of paper with tippex for any changes
The night staff had a 10 hours shift and were contracted for 140 hours in every 4 weeks
The day staff did either early or late shifts at 7.5 hours but 0.5 was unpaid for lunch break so it was a 7 hour shift
Some staff were contracted at 140 hours per 4 weeks so average 35 per week
Other staff were part time at 84 hours per 4 weeks so average 21 per week
There were also other staff as weekend only workers
Every member of staff had to have every other weekend off
There were minimum staffing levels on days and nights to be maintained
It was not that tricky to design the basic rota but hellish to balance out all those factors
I have auto counts designed into the spreadsheet so I could keep track of the numbers on each shift and the total shifts done by each member of staff
I found that using the LOTUS 123 spreadsheet was better than the excel one
The night staff had a 10 hours shift and were contracted for 140 hours in every 4 weeks
The day staff did either early or late shifts at 7.5 hours but 0.5 was unpaid for lunch break so it was a 7 hour shift
Some staff were contracted at 140 hours per 4 weeks so average 35 per week
Other staff were part time at 84 hours per 4 weeks so average 21 per week
There were also other staff as weekend only workers
Every member of staff had to have every other weekend off
There were minimum staffing levels on days and nights to be maintained
It was not that tricky to design the basic rota but hellish to balance out all those factors
I have auto counts designed into the spreadsheet so I could keep track of the numbers on each shift and the total shifts done by each member of staff
I found that using the LOTUS 123 spreadsheet was better than the excel one
To add to my last post ...
I made one master rota covering 4 weeks and then 13 x 4 week rotas covering the rest of the year so that holidays could be planned into them
I could also produce weekly sheets for the staff room etc so that staff could see any changes
I was good at punching the numbers but when it came to asking staff to change shifts or cover then my mrs the care home manager did that
OH - and I was not employed by the company she worked for - I did it for fun and to help out the wife = seriously
My own job at the time was as a LGV instructor
I made one master rota covering 4 weeks and then 13 x 4 week rotas covering the rest of the year so that holidays could be planned into them
I could also produce weekly sheets for the staff room etc so that staff could see any changes
I was good at punching the numbers but when it came to asking staff to change shifts or cover then my mrs the care home manager did that
OH - and I was not employed by the company she worked for - I did it for fun and to help out the wife = seriously
My own job at the time was as a LGV instructor
Gassing Station | Business | Top of Page | What's New | My Stuff