Labor Cost Percentage

Excel Formulas › Restaurant & Hospitality

All versions

Labor cost percentage measures total payroll against sales — the other half of restaurant cost control. Total labor cost divided by total sales, watched alongside food cost.


Quick formula: labor cost % from labor and sales:
=total_labor_cost / total_sales
All wages, taxes, and benefits over total sales. Full-service restaurants often run 25–35%.

The example

$10,500 labor on $35,000 sales.

AB
1ItemValue
2Labor cost10500
3Sales35000 → 30%

The formula

The formula:

=B2 / B3 // labor ÷ sales

How it works

How it works:

  1. Total labor cost includes wages, payroll taxes, and benefits — not just hourly pay.
  2. Divide by total sales for the period and format as a percentage.
  3. Full-service often runs 25–35%; quick-service is lower.
  4. Combine with food cost for prime cost — the number that really drives profit.

Labor cost is controllable in real time. Unlike rent, you can flex staffing to forecasted covers. Many operators track labor as a percentage per shift or daypart, comparing scheduled hours against projected sales, so they can send someone home when it’s slow — before the daily number slips.

Try it: interactive demo

Live demo

Total labor cost and sales.

Labor cost:

Variations

Labor per cover

Cost per guest:

=total_labor_cost / covers

Sales per labor hour

Productivity:

=total_sales / labor_hours

Target labor budget

At a target %:

=forecast_sales * target_pct

Pitfalls & errors

Fully loaded. Include taxes and benefits, not just wages, for a true labor cost.

Same period. Labor and sales must align in time.

Daypart it. A daily average can hide an over-staffed slow shift.

Practice workbook

📊
Download the free Labor Cost Percentage practice workbook
A labor-cost sheet with the per-cover, sales-per-hour, and target-budget variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I calculate labor cost percentage in Excel?
Divide total labor cost by total sales: =total_labor_cost / total_sales. Full-service restaurants often run 25–35%.
What's included in labor cost?
Wages plus payroll taxes and benefits — the fully loaded cost, not just hourly pay.
How do I manage labor cost in real time?
Track it per shift or daypart against forecasted sales so you can adjust staffing before the number slips.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related formulas: Food cost percentage · Prime cost · Gross to net pay