Restaurant Analytics: Use Your Data to Cut Costs and Grow Revenue

Restaurant analytics transforms the data you already have into decisions that improve profitability. Most owners have more data than they realize — and use almost none of it. Your POS records every transaction. Your invoices tell you exactly what food costs. Your scheduling system knows labor hours by shift.

Taken together, this data can tell you which dishes are killing your margins, which days you're overstaffed, and where food waste is costing you money you can't see.

---

Why Restaurant Data Analysis Matters More Than Ever

Restaurants have always run on thin margins. The average full-service restaurant operates at 3–9% net profit. A 1% improvement in food cost on $800,000 in annual revenue is $8,000 in additional profit. That's real money.

But most operators still make key decisions based on intuition — "I think the salmon dish is popular," "Thursday is usually slow." Data turns these guesses into facts. And facts let you act with precision instead of hope.

---

The Four Core Restaurant Metrics

1. Food Cost Percentage

Formula: (Food Cost / Food Revenue) x 100. Target: 28–35% depending on concept.

2. Labor Cost Percentage

Formula: (Total Labor Cost / Total Revenue) x 100. Target: 28–35% for most concepts.

3. Prime Cost

Formula: Food Cost + Total Labor Cost. If prime cost exceeds 60–65% of total revenue, you're likely not profitable.

4. Revenue Per Available Seat Hour (RevPASH)

Formula: Total Revenue / (Available Seats x Hours Open). Tells you how efficiently you're using your dining room.

---

Using POS Data: Menu Engineering

Your POS item mix report shows how many of each item sold in a given period. Build a menu engineering matrix:

• Stars: High popularity + high margin — protect these
• Plowhorses: High popularity + low margin — consider repricing or reformulating
• Puzzles: Low popularity + high margin — investigate placement, price point, server recommendations
• Dogs: Low popularity + low margin — candidates for removal

Run this analysis quarterly. It will meaningfully improve your menu's financial performance over time.

Sales by Daypart and Day of Week

Break your revenue down by daypart and day of week. You'll likely find 2–3 peak days generating 50%+ of weekly revenue and 1–2 slow days where you're consistently overstaffed. Use this to make smarter staffing decisions and identify promotional opportunities.

Inventory and Food Cost Variance

Do a weekly inventory count of your top 10–15 highest-cost items. Compare what you used to what you sold. A 5% variance on $10,000 of weekly food cost is $500/week — $26,000 per year.

Every menu item should have a documented recipe with a calculated cost. If your ingredient prices increase 15%, your food cost drifts unless you adjust pricing or portions. Recipe costing makes those changes visible before they silently erode margins.

Labor Analytics: Matching Staff to Revenue

Sales-Per-Labor-Hour (SPLH): Total Revenue / Total Labor Hours. Target $50–80 for most casual dining. If you're doing $45 SPLH on Tuesday nights, you have too many people relative to revenue.

Compare your scheduled hours to your clocked-in hours weekly. If servers are consistently clocking out 30–45 minutes late, your labor cost exceeds what your schedule predicts.

Void and Comp Report

High void rates from specific servers may indicate training issues. High comp rates may indicate food quality problems. Patterns in void timing can reveal ticket management issues. Smart operators look at who is voiding and when — not just the total.

---

Building a Simple Weekly Dashboard

Track these every week in a spreadsheet:

1. Total revenue (by daypart if possible)
2. Food cost % (from inventory)
3. Labor cost % (from payroll)
4. Prime cost %
5. Top 5 and bottom 5 selling items

Review every Monday for the prior week. Make one operational decision based on what you see. Over 90 days, patterns emerge that would never be visible in your head.

---

FAQ: Restaurant Analytics and Reporting

What data should a restaurant track every week?

At minimum: total revenue by daypart, food cost percentage from weekly inventory, labor cost percentage from payroll, and prime cost. Your top and bottom 5 selling items from your POS item mix report rounds out a basic operational dashboard.

What is prime cost and why does it matter for restaurants?

Prime cost is food cost plus labor cost. It's the most important profitability metric because it captures your two largest variable costs. Most successful restaurants keep prime cost at or below 60–65% of total revenue.

What is menu engineering and how does it work?

Menu engineering plots each dish on a matrix of popularity (how often it's ordered) vs. profitability (gross margin per dish). Stars are high-popularity, high-margin items to protect. Dogs are low on both dimensions and are removal candidates. Run this analysis quarterly.

How do I calculate food cost variance for my restaurant?

Compare your theoretical food cost (based on recipes and POS sales data) against your actual food cost (from inventory). The gap is your variance. A variance above 3% indicates operational problems — most commonly portioning errors, waste, or theft.

---

Ready to take control of your food costs? Try CostLab free for 14 days →