Labour Cost Calculation Excel Template

Sample Labour Cost Calculator in Excel. Created for catering but can be adapted for use.

by Fáilte Ireland
National Tourism Development AuthorityFollow 27

44 reviews23,524 views|Start the discussion!|Bookmark download for free

Description
This is a spreadsheet in excel to calculate your total cost of labour. It's a template and so can be tailored for your needs. It can be used in two ways to raise awareness of your true labour costs and to improve your profitability:

1. Enter total hours worked and what each team member is paid hourly. Put this against the total revenue for the week for actual labour cost percentage.

2. Enter total hours worked for an individual event or function against total revenues from all of the F&B dpts to provide an individual labour cost percentage. From this you can work out the profitability of each individual event that was held.

*Orginally shared on FáilteIreland.ie*

This Best Practice includes
1 Calculator in Excel