This excel template allows you to project the wages cost to be business of the rostered wages (i.e. gross wages plus employer PRSI). This is particularly useful when rostering part-time staff to draw attention to varying staff rates per hour and staff being charged at overtime rates.
It is assumed in the template that part-time staff receive an 8% holiday allowance each week. While this may not be the case in your business, 8% of hours worked is the most common method of calculating holidays due to part-time staff and therefore will remain the relevant cost for comparison regardless of when the allowance is actually paid.
Also encluded on the second tab is a basic roster sheet. You may wish to tailor to your own needs including split shifts, lunch alllowances etc.
Updated for change in mileage rates, March 2009.
This is an excel template which may be completed electronically or printed off for manual completion.
A common payroll question – what are employees entitled in relation to bank holiday pay? We have summarised your requirements as an employer in the attached.