Wages Calculator – Weekly Cost

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.

{filelink=9}