Free Restaurant Labor Cost Excel Template

Introduction

Labor consistently ranks as one of the largest controllable expenses in restaurant operations. According to the National Restaurant Association's 2025 Operations Data Abstract, median labor costs have risen to 36.5% for full-service restaurants and 31.7% for limited-service operations — well above the historical 28–35% range many operators aim for.

Many single-location and small multi-unit operators rely on Excel to track labor costs — and a well-built template can do more than you might expect. This guide covers everything you need to get it working:

• What belongs in a labor cost spreadsheet and how to structure it
• Step-by-step setup with exact formulas for automatic labor cost percentage
• Practical tips for cutting costs once you have clear visibility into your numbers

TLDR

• Labor cost covers wages, overtime, payroll taxes, benefits, and other employee expenses beyond hourly pay
• A free Excel template tracks all components per employee and calculates labor cost percentage automatically
• Core formula: Labor Cost % = (Total Labor Cost ÷ Total Revenue) × 100
• Most restaurants target 28–35%, though profitable full-service operators run closer to 34% while unprofitable ones average 43%
• Consistent tracking is the foundation of cost reduction; the spreadsheet gives you a place to begin

What Is Restaurant Labor Cost (and Why It Matters)

Restaurant labor cost represents the total of all employee-related expenses, not just base wages. This includes:

• Hourly wages and salaries
• Overtime premiums
• Employer-paid payroll taxes (FICA, FUTA, SUTA)
• Health insurance and benefits
• Paid time off and sick leave
• Training and onboarding costs

Labor typically represents 30–40% of total restaurant expenses, making it one of the most controllable cost categories in the business. Unlike fixed expenses like rent or insurance, labor can be adjusted daily based on forecasted sales volume — which is exactly why tracking it closely pays off.

Prime Cost: Your Critical Guardrail

The most important metric in restaurant operations is Prime Cost, defined as Total Labor Cost + Total Cost of Goods Sold (COGS). Industry standards recommend keeping Prime Cost between 55–65% of total sales, depending on your service model. Exceeding 65% makes profitability extremely difficult regardless of sales volume.

Labor Benchmarks by Restaurant Type

Labor cost standards vary significantly by segment:

Critical insight: According to NRA research, profitable full-service operators maintain labor costs at 34.2%, while unprofitable ones average 42.9%. For a restaurant with $1.5M in annual sales, that 8.7 percentage point difference represents roughly $130,000 in profit.

What to Include in Your Restaurant Labor Cost Excel Template

Accurate labor cost percentages depend on tracking every labor dollar — wages, taxes, and benefits alike. Miss any category and your numbers will mislead you.

Core Employee Data Fields

• Employee name and ID
• Job role/position (front-of-house vs. back-of-house) — tracking by role reveals which departments run over budget
• Regular hours worked
• Overtime hours
• Hourly wage rate

Gross Pay Calculation Fields

Your template should automatically calculate:

• Regular pay = Regular hours × hourly rate
• Overtime pay = Overtime hours × (hourly rate × 1.5)

Note: Federal law requires 1.5× pay for hours over 40 per week. Some states like California require daily overtime (1.5× after 8 hours in a day, 2× after 12 hours). Verify your state's overtime rules and adjust formulas accordingly.

Additional Cost Columns Beyond Base Wages

Employer payroll taxes — These are mandatory costs that scale with wages:

• FICA (Social Security + Medicare): 7.65% of wages (6.2% Social Security + 1.45% Medicare)
• FUTA (Federal Unemployment Tax): 0.6% on first $7,000 per employee
• SUTA (State Unemployment Tax): Varies by state

Benefits and other costs:

• Health insurance contributions
• Paid time off and sick leave accrual
• Training and onboarding costs

Excluding these taxes understates your true labor cost by at least 8%. On a $500,000 annual payroll, that's a $40,000 accounting error.

Summary-Level Columns

• Total labor cost per employee (wages + overtime + taxes + benefits)
• Total labor cost per day/week/period
• Total revenue for that period
• Scheduled vs. actual hours — this comparison immediately surfaces costly over-scheduling or unexpected overtime

How to Set Up Your Restaurant Labor Cost Spreadsheet Step by Step

Step 1: Choose Your Tracking Period

Set up your template to track weekly (most useful for scheduling decisions) with a separate summary tab that rolls up to monthly. Weekly tracking catches overtime and overstaffing faster than monthly reviews, letting you correct course before small overages become expensive problems.

Step 2: Build Your Employee Data Table

Create your foundational table with these columns:

• Date
• Employee name
• Position
• Clock-in time
• Clock-out time
• Hours worked
• Hourly pay rate
• Regular pay
• Overtime hours
• Overtime pay
• Payroll taxes
• Benefits
• Total labor cost

Color-code input cells (yellow) vs. formula cells (gray) — this prevents accidentally overwriting formulas when entering data.

Step 3: Add Overtime Logic with an IF Formula

Use Excel's IF function to automatically flag and calculate overtime:

For the overtime hours column:

=IF(total_hours>40, total_hours-40, 0)

For the overtime premium column:

=IF(total_hours>40, (total_hours-40)*hourly_rate*1.5, 0)

For total gross pay:

=MIN(total_hours, 40)*hourly_rate + IF(total_hours>40, (total_hours-40)*hourly_rate*1.5, 0)

Regular pay covers the first 40 hours; anything beyond triggers the 1.5× premium.

Step 4: Add a Revenue Row and the Labor Cost % Formula

Place your total revenue input in a clearly labeled cell at the top of your worksheet, separate from the data table. This should be a manual input cell where you enter weekly sales.

Labor cost percentage formula:

=(SUM_of_total_labor_costs / revenue_input_cell) * 100

This percentage is your primary benchmark. Check it weekly to know whether labor costs are on target before the numbers compound.

Step 5: Build a Summary Dashboard Tab

Create a second worksheet tab that pulls key totals from your data tab using SUMIF formulas:

• Total labor cost by role (FOH vs. BOH)
• Overall labor cost %
• Week-over-week comparison showing whether labor % is trending up or down
• Scheduled hours vs. actual hours variance

A dedicated dashboard tab keeps decision-relevant numbers front and center, separate from raw data rows.

How to Calculate Labor Cost Percentage in Excel

The formula is simple and universal:

Labor Cost % = (Total Labor Cost ÷ Total Revenue) × 100

Worked Example

A restaurant has:

• Weekly labor costs: $12,000 (including wages, overtime, taxes, and benefits)
• Weekly revenue: $40,000

Calculation:

($12,000 ÷ $40,000) × 100 = 30%

This 30% labor cost percentage falls within the healthy range for most full-service restaurants.

What Counts as "Total Labor Cost"

Your numerator must include:

• All wages and salaries
• Overtime premiums
• Employer-paid payroll taxes (FICA, FUTA, SUTA)
• Benefits (health insurance, PTO, etc.)

If you only count take-home pay, your percentage will be misleadingly low by 8–10 percentage points.

What Counts as "Total Revenue"

Use gross sales (before discounts and comps), not net sales. Industry accounting standards recommend gross sales because using net sales artificially inflates your labor percentage. Run a 50% off promotion and your labor % doubles mathematically — even if you staffed correctly for the actual customer volume. That's a distorted number, not an operational problem.

Track discounts and comps as a separate marketing expense line, not as a reduction in your revenue denominator.

With both inputs defined clearly, you're ready to wire them into Excel.

Set Up a Dynamic Labor Cost % Cell

In your summary dashboard, create a formula cell that references:

• Your total labor cost cell (from the data tab)
• Your revenue input cell

=(Data!Total_Labor_Cost / Data!Revenue) * 100

Format this cell as a percentage with one decimal place. As you enter hours and revenue throughout the week, your labor cost % updates automatically — giving you a live read on where you stand before the week closes.

How to Reduce Restaurant Labor Costs (Beyond the Spreadsheet)

Your spreadsheet gives you visibility — but reducing costs requires action. The top levers are:

Schedule to Sales, Not Guesswork

Align staff levels with forecasted sales volumes using historical data from the past 8–12 weeks. Improper staffing can result in a 10–25% loss of gross revenue per location. Forecast-based scheduling implementations report labor cost reductions in the 8–15% range by minimizing unnecessary hours during slow periods and avoiding overtime during surges.

Action: Use your spreadsheet to identify your busiest and slowest days/dayparts, then build schedules that match those patterns.

Monitor Overtime Proactively

Catch overtime before it happens, not after. Review your weekly hours mid-week and adjust remaining schedules to keep employees under 40 hours. Every hour of overtime costs 1.5× your regular rate — five hours of avoidable overtime per week costs you roughly $3,000–$5,000 annually per employee.

Cross-Train Staff

Cross-training employees to cover multiple roles (server + host, line cook + prep cook) lets you run leaner on slow shifts without sacrificing service quality. Instead of scheduling separate employees for each role, one cross-trained employee can flex between positions as needed.

Focus on Retention

High turnover is a hidden labor cost that doesn't show up in your weekly wage lines but absolutely hits your bottom line. The restaurant industry's annual turnover rate is 65.8%, and replacing a single front-line employee costs approximately $5,864 when you account for recruiting, onboarding, training time, and lost productivity.

Action: Track turnover separately in your spreadsheet and calculate the annual replacement cost — it's often eye-opening.

Cut Utility and Waste Costs Alongside Labor

Labor is the biggest cost lever — but it's not the only one. Operators who also address water, utility, and food waste spending see faster bottom-line improvement than those focused on scheduling alone. For example, replacing the traditional running-faucet defrost method with a closed-loop system like CNSRV's DC:02 cuts defrosting time in half and significantly reduces water costs — savings that stack directly on top of any labor gains you've already made.

Frequently Asked Questions

How to calculate restaurant labor cost in Excel?

Set up columns for employee hours, wage rates, overtime, payroll taxes, and benefits. Use the formula =(Total Labor Cost / Total Revenue) × 100 to calculate labor cost percentage automatically. The spreadsheet updates in real-time as you enter data.

How to cut labor costs in a restaurant?

Use your labor cost spreadsheet to identify overstaffing and excessive overtime before they compound. Schedule based on sales forecasts rather than fixed templates, and cross-train staff to cover multiple roles. Retention is worth investing in — turnover costs far more than a wage increase.

What is a good labor cost percentage for a restaurant?

Most restaurants target 28–35%, but the right benchmark varies by segment. QSR operations often run 20–25% while full-service restaurants typically run 30–36%. Profitable full-service operators maintain 34.2% while unprofitable ones average 42.9%.

What should be included in a restaurant labor cost spreadsheet?

At minimum, include employee names and roles, regular and overtime hours, hourly wage rates, employer payroll taxes (FICA at 7.65%, FUTA, SUTA), health insurance and benefits, and a labor cost percentage column tied to revenue.

What is the formula for labor cost percentage?

Labor Cost % = (Total Labor Cost ÷ Total Revenue) × 100. Total labor cost must include all employee-related expenses (wages, overtime, payroll taxes, benefits), not just base wages, or your percentage will be misleadingly low.

How often should I track restaurant labor costs?

Track weekly at minimum for active management decisions, with monthly rollups for trend analysis. Weekly visibility lets you catch overtime and overstaffing before they become expensive problems. Daily tracking is ideal for high-volume operations.