PrepSheet

Labour Cost & Wage % Calculator

Excel (.xlsx) — also opens in Google Sheets & Numbers

Your second-biggest cost after food. List your team's hours and rates, add on-costs, and see your true labour cost and wage % against sales.

What's inside

  • Wage cost per person + on-costs (NI, pension, holiday)
  • Wage % of sales vs your target
  • Catch overstaffing before payday
  • Worked example built in

What it does

Labour is your second-biggest cost after food, and the on-costs are where it hides. List your team's hours and rates, add NI, pension and holiday, and see your true labour cost and wage percentage against sales — compared to your target.

The point is timing: seeing the wage % mid-week, while the rota can still change, instead of at payroll.

Who it's for

Restaurants, cafés and pubs writing their own rotas. A worked example is built in so you can see a full week before entering your own.

Goes well with

Try the numbers first, free: the food cost & GP calculator and the recipe costing tool run in your browser.