Labour cost calculator for Excel
Plan the week before it starts. Type hours per person and day, see the labour cost and labour % against your forecast, and the sales you need to hit your target. Then log what happened and watch the trend.
Price and release date will be announced when the Etsy shop opens.
- Format
- .xlsx workbook (Excel)
- Works with
- Microsoft Excel, desktop or 365
- Capacity
- 40 staff, 26 weeks of history
- Language
- English
- Licence
- One business
- Status
- In final checks, price to be announced
What you get
Fully-loaded hourly cost
Hourly pay plus your on-costs, set once in Settings.
Weekly schedule with overtime
Hours per day, regular and overtime hours, and the cost of each person.
Labour % against target
A clear OK, WATCH or HIGH for the planned week and for every logged week.
Sales needed to hit your target
The sales figure at which this schedule fits your labour target.
Sales per labour hour and prime cost
Productivity and the labour plus food cost number every operator watches.
Cost by role and trend
Kitchen, floor, bar and management, plus a labour % chart by week.
Inside the workbook
Planning tool, not accounting, tax or legal advice. Example data is invented.
| Sheet | What it does |
|---|---|
| Settings | On-costs, overtime rule, target labour % and roles |
| Staff | People, roles, hourly pay and loaded cost |
| Schedule | Weekly hours, overtime and cost |
| Weekly Log | Actual sales, labour, hours, covers and results |
| Dashboard | Planned labour %, cost by role and trend |
What the plan shows
A week with 321 scheduled hours costs about 5,856 with on-costs. With a forecast of 20,000 in sales that is a labour cost of 29.3%, inside a 30% target. The sheet also tells you the sales you would need if you wanted the plan to sit exactly on target.
Questions
Can it handle salaried staff?
Yes. Divide the weekly cost by the weekly hours to get an equivalent hourly rate, and enter that.
Does it follow my country's overtime rules?
You set the weekly hours threshold and the multiplier. Check the rule that applies where you work.
Is it a payroll tool?
No. It is for planning and checking. Payroll rules and taxes vary, so use your payroll software or accountant for pay.
While you wait
The recipe costing spreadsheet and the free food cost calculator are the first tools of the toolkit.