Restaurant labor cost percentage is labor cost divided by sales, multiplied by 100. To use it before publishing a schedule, compare the cost of the shifts you plan to staff with sales you expect during the same period. After the week closes, repeat the calculation with actual figures.
This guide uses a fictional restaurant and a wage-only budget. It shows how to turn a dollar limit into hours without treating a percentage target as proof that the restaurant is adequately staffed.
Choose what your labor cost includes
Write the definition above your worksheet. A wage-only view might include hourly wages, planned premiums and allocated management wages. A fully loaded view can also include employer taxes, benefits and other employment costs. These are different measures; label them clearly and compare like with like.
Use the same date range for sales and labor. A Monday-to-Sunday schedule should not be divided by sales from a calendar month. Decide consistently how you treat refunds and other adjustments in your sales figure, too.
Calculate the percentage with a weekly example
| Input | Amount |
|---|---|
| Forecast sales | $24,000 |
| Hourly scheduled wages | $5,400 |
| Allocated management wages | $1,200 |
| Total planned wages | $6,600 |
| Wage-only percentage | 27.5% |
The calculation is $6,600 ÷ $24,000 × 100 = 27.5%. In Excel, if B2 contains sales and B3 contains wages, enter =B3/B2 and format the result as Percentage. Do not multiply by 100 as well when using Percentage formatting. If sales are zero, the percentage is undefined; flag it instead of displaying a misleading zero.
To prepare the hours behind the wage figure, use the work hours calculator. If staff receive different premiums, review the shift differential calculation separately rather than assigning one rate to every shift.
Turn a target percentage into an hours budget
Suppose this restaurant chooses a 28% wage-only planning target. This is an example assumption, not a recommended target for every restaurant. Its weekly allowance is $24,000 × 28% = $6,720. After subtracting $1,200 of management wages, $5,520 remains for hourly shifts.
At an assumed blended hourly wage of $20, that allowance represents 276 paid hours: $5,520 ÷ $20. A draft schedule of 270 hours at the same rate costs $5,400, leaving a $120 buffer. That is only six hours at $20, so a small change can consume it.
A blended rate is a rough planning aid. Before approving the roster, price each person’s shifts using the correct rate and any applicable premiums. Do not count overtime premiums twice or assume every additional hour has the same cost.
Check the service requirement before cutting hours
A weekly allowance does not tell you whether a cook, cashier or supervisor is present at the right time. Allocate hours to preparation, service, closing and handover. Then compare the staffed roles with demand during each interval. Start with weekly coverage hours and check coverage by skill.
For example, moving a two-hour preparation shift to the dinner rush preserves total hours but may leave nobody preparing food before service. Cutting two overlapping shifts can also remove planned break relief. Use the break coverage guide before changing overlap.
Stress-test a slower sales week
If sales reach only $21,000 and wages remain $6,600, the wage-only percentage becomes 31.43%. No extra shift is needed to cause that increase: the denominator fell. Record both the sales shortfall and any wage overspend so the manager can distinguish a forecast problem from a scheduling problem.
Compare the original forecast, final schedule and actual result. The scheduled versus actual hours worksheet explains how to investigate the difference without overwriting the original plan.
A five-minute review before publication
- Confirm the sales period and cost definition match.
- Price named employees rather than relying only on a blended rate.
- Check essential roles, preparation, closing and break relief.
- Test a lower-sales scenario and record your assumptions.
- Save the approved schedule as the comparison baseline.
If you want to keep the roster, planned hours and weekly labor-cost review in one Excel workbook, see Intious Shift Planner Pro. It supports manual planning and review; it does not forecast restaurant sales or replace payroll.
Common questions
Is a lower percentage always better?
No. A lower figure can reflect better sales, but it can also hide missing coverage. Evaluate service capacity and the cost definition alongside the percentage.
Should I compare daily or weekly results?
Use daily figures to spot uneven demand, then review the whole week. The weekly percentage is total weekly labor cost divided by total weekly sales, not the unweighted average of seven daily percentages.
Reference: 7shifts’ labor budget documentation describes the labor-cost-to-sales calculation. All figures and the worksheet example above are original illustrative calculations.