FREE TEMPLATE
Restaurant Labor Cost Schedule: Free Weekly Template (Excel, CSV, Printable)
Free restaurant labor cost schedule: a weekly staff schedule in Excel that totals hours and wages per employee and shows labor cost % vs projected sales. Plus CSV and printable.
Download Excel (.xlsx) Download CSV (Google Sheets) Printable version
Free. No signup, no email. The Excel file has working formulas and opens in Google Sheets, Numbers and LibreOffice.
How to use the labor cost schedule template
- Enter projected sales for the week, your payroll taxes & benefits % and your target labor cost %.
- Add each employee with their role and hourly rate, then the scheduled hours for each day.
- The sheet totals hours per day and per person; wages = total hours x hourly rate.
- Total labor cost = wages + taxes & benefits, and labor cost % = total labor cost / projected sales, compared with your target and the labor budget it allows.
Or calculate it right here
Same formula, live in your browser: Labor Cost Percentage Calculator for Restaurants.
Related calculators: Sales per Labor Hour Calculator (SPLH).
Formula
Wages = total hours x hourly rate. Total labor cost = wages x (1 + payroll taxes & benefits %). Labor cost % = total labor cost / projected sales x 100.
Labor cost % = (wages + payroll taxes + benefits) ÷ sales × 100.