ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Nursing shifts (https://www.excelbanter.com/excel-programming/303476-nursing-shifts.html)

Scooby Doo

Nursing shifts
 
Can anyone help with this problem, its for my wife who works at the local
hospital and they want to optimise the staffing levels.

If you need any further questions pls do not hesitate to ask.

Thanks all


Shift patterns
Early (E) - 7.5 hrs
Late (L) - 7.5 hrs
Night (N) - 10 hrs

Each member of staff has two days off per week, 36 days holiday and 10 days
study leave (part time pro rata).

Normal shift numbers would be on a Mon, Wed, Thur Sat & Sun.
Two qualified members of staff and three unqualified staff are required on
the E shift.
Tue & Fri would require three qualified and two unqualified on the E shift.

L shift would require two qualified and two unqualified.
N shift would require two qualified and one unqualified.

Ward has 18 patients, with 4 patients per nurse per shift on average
(excluding night shift).

Current staffing levels a
9 staff working 37.5 hrs per week
1 staff working 20 hrs
(1 staff on maternity leave at 37.5 hrs per week)
(1 staff currently on sick leave = 37.5 hrs per week)

Unqualified
2 staff on 36 hrs
3 staff on 37.5 hrs
1 staff on 30 hrs
1 staff on 20 hrs

1) How many staff would be required to cover the above criteria?
2) How many beds would need to close for the above criteria to be met?








Tom Ogilvy

Nursing shifts
 
Use

http://www.google.com

to search for freeware shift scheduling software or perhaps a commercial
package. I would expect there is plenty out there that will do what you
need.

--
Regards,
Tom Ogilvy

"Scooby Doo" wrote in message
...
Can anyone help with this problem, its for my wife who works at the local
hospital and they want to optimise the staffing levels.

If you need any further questions pls do not hesitate to ask.

Thanks all


Shift patterns
Early (E) - 7.5 hrs
Late (L) - 7.5 hrs
Night (N) - 10 hrs

Each member of staff has two days off per week, 36 days holiday and 10

days
study leave (part time pro rata).

Normal shift numbers would be on a Mon, Wed, Thur Sat & Sun.
Two qualified members of staff and three unqualified staff are required on
the E shift.
Tue & Fri would require three qualified and two unqualified on the E

shift.

L shift would require two qualified and two unqualified.
N shift would require two qualified and one unqualified.

Ward has 18 patients, with 4 patients per nurse per shift on average
(excluding night shift).

Current staffing levels a
9 staff working 37.5 hrs per week
1 staff working 20 hrs
(1 staff on maternity leave at 37.5 hrs per week)
(1 staff currently on sick leave = 37.5 hrs per week)

Unqualified
2 staff on 36 hrs
3 staff on 37.5 hrs
1 staff on 30 hrs
1 staff on 20 hrs

1) How many staff would be required to cover the above criteria?
2) How many beds would need to close for the above criteria to be met?










Kim[_12_]

Nursing shifts shift scheduling software
 
"Scooby Doo" wrote in message ...
Can anyone help with this problem, its for my wife who works at the local
hospital and they want to optimise the staffing levels.


Hello

If you ar looking for a Shift scheduling program, designed
for nursing houses, take a look at
http://www.cibit.fi/en/shiftscheduling.php
to get a free demo.
The software also calculates the salarybase according to
your collective bargain agreement, so you can see the costs
directly....
Its also possible to define the staffing levels for different
weekdays.

Sincerely Kim


All times are GMT +1. The time now is 08:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com