Set up a staff rota template which runs over 12 months.

The rota will need to have the following functions:
• Show the shifts covered each day of the month for up to 16 staff
• Ability to be planned monthly over a 12 month period
• Identify up to 4- 6 shift patterns and be able to adjust the start and end times, I.E start time and total duration of an early shift is from 8.00 am ends 3.30pm (Duration 7 ½ hours) The shifts required are as follows : Early shift : Day shift: Late shift: Long day: Night shift:
• Identify staff by profession, grade, and shift allocation on leave or sick
• Show total number of hours worked over rota period by each staff member and whole team.
• The monthly rota must be able to be printed on an A4 sheet.

In terms of additional formulas the basic principles are as follows. The unit will need to be covered 24 hours per day x 7 days per week, the work will need to be divided between up to 16 staff and will take into account each staff member will require 22 days annual leave and 10 days training a total of 32 days when they will be unavailable to work on the rota. The staff are also contracted to work 37.5 hours per week a total of 150 hours per month, they may work over the hours in one week but will balance out over the month.
A typical shift pattern based on eight staff would be as follows:
Day shift x 2 staff: Early shift x 1 staff: Late shift 1x staff; Night x 1 staff