Free Download · Resources
KPI Checklist
Hospitality & Food
10 essential hospitality KPIs — each with a definition, formula, sector benchmarks and a concrete Power BI implementation tip. Built for restaurant, food service and hospitality businesses that want to manage on margin, labour and guest experience.
10
Hospitality
KPIs
KPIs
About this checklist
Hospitality KPIs that drive decisions
Most hospitality operators know intuitively when it is busy and when the margins feel right — but without measurement, adjusting is guesswork. Food costs running 2% over target, labour that does not scale with occupancy, waste that stays invisible: together those three factors determine the difference between a profitable and a loss-making concept.
Food & beverage cost
Food Cost %, Beverage Cost % and Food Waste — the KPIs that show directly where margin is leaking in the kitchen.
Labour efficiency
Labour Cost % and Covers per Labour Hour — the KPIs that make scheduling optimisation concrete and measurable.
Revenue & guest experience
RevPASH, Average Spend, Table Turnover and Guest Satisfaction — the KPIs that connect occupancy, pricing and loyalty.
The KPIs
10 hospitality & food KPIs — explained
Click any KPI to see the definition, formula, sector benchmarks and Power BI implementation tip.
Food cost
Labour
Revenue
Guest experience
Operations
01
Food Cost %
Ratio of food purchase costs to food revenue — the fundamental measure of kitchen margin control.
Food Cost
Definition & why measure
The ratio of food purchase costs to food revenue. The most fundamental measure of kitchen margin control.
Every percentage point rise in food cost directly erodes margin. High food cost indicates spoilage, over-portioning, poor purchasing discipline, or a menu that has not been optimised for profitability.
Formula
Food purchase cost ÷ Food revenue × 100%Benchmark by concept
QSR / fast food
25–30%
Casual dining
28–35%
Fine dining
30–38%
What does this KPI tell you?
A food cost of 35% at a QSR concept is critical — at fine dining it is normal. Measured against target and sector norm, this KPI immediately directs action toward purchasing, portion control or recipe management.
Power BI implementation tip
Build a daily food cost tracker per menu group. Link purchase invoices to POS revenue data. A threshold alert above 33% (or your own target) automatically triggers a review of portion sizes and recipes.
02
Beverage Cost %
Ratio of beverage purchase costs to beverage revenue — spirits, wine and beer carry very different margins.
Food Cost
Definition & why measure
The ratio of beverage purchase costs to beverage revenue. Spirits, wine and beer carry very different margins and need to be tracked separately.
Beverages typically generate higher margins than food in most hospitality concepts. Drift in beverage cost — through over-pouring, theft or pricing errors — is often invisible without measurement.
Formula
Beverage purchase cost ÷ Beverage revenue × 100%Benchmark by category
Spirits
18–24%
Wine
25–35%
Beer / draught
20–28%
What does this KPI tell you?
A wine cost of 40% is acceptable at a premium wine bar, but alarming at a bistro with a small wine list. Measure per category, not just in total — aggregate numbers hide where the problem actually sits.
Power BI implementation tip
Map draught and bottled beverages to separate product groups in the POS. Compare theoretical versus actual beverage cost weekly — the gap is your over-pour loss or inventory variance.
03
Labour Cost %
Total staff costs as a percentage of revenue — the largest controllable cost in most hospitality businesses.
Labour
Definition & why measure
Total staff costs (including social charges and flexible staff) as a percentage of total revenue. The largest controllable cost item in most hospitality businesses.
Labour costs can spiral quickly with fluctuating occupancy and flexible staffing. Visibility per day and per shift makes correction before month-end possible — not just after the P&L is closed.
Formula
Total labour costs ÷ Total revenue × 100%Benchmark by concept
QSR / fast food
25–30%
Full service
30–35%
Fine dining
35–40%
What does this KPI tell you?
A labour cost ratio of 40% at a QSR concept signals structural over-staffing or inefficient scheduling. At fine dining, 38% is the floor — labour intensity is intrinsic to the format.
Power BI implementation tip
Link scheduling data to POS revenue per hour. Show labour cost per revenue hour per day — this immediately reveals which shifts are efficient and where staffing does not match demand.
04
Covers per Labour Hour
Covers served divided by front-of-house hours worked — a direct measure of service productivity.
Labour
Definition & why measure
The number of covers served divided by total front-of-house staff hours worked. A direct measure of service labour productivity.
Low productivity per hour indicates over-staffing, inefficient floor routes or a shift pattern that does not match demand waves. This is the KPI that makes rota optimisation concrete and measurable.
Formula
Covers served ÷ Front-of-house hours workedBenchmark by concept
Fine dining
2–4×
Casual dining
4–8×
QSR / fast food
8–15×
What does this KPI tell you?
6 covers per hour at a casual dining restaurant can be normal during quiet periods — but if that is the daily average, there is a scheduling problem. Measure per service period, not just per day.
Power BI implementation tip
Segment by service (lunch / dinner / drinks) and day of the week. Combine with revenue per cover to distinguish between busy-but-unprofitable shifts versus efficient services.
05
RevPASH
Revenue Per Available Seat Hour — combines occupancy, average spend and dwell time in one metric.
Revenue
Definition & why measure
Revenue Per Available Seat Hour — the revenue generated per available seat per hour of operation. Combines occupancy, average spend and dwell time into one metric.
RevPASH is the hospitality equivalent of RevPAR in hotels: it measures how efficiently you use your capacity. Two concepts with identical occupancy can have very different RevPASH through pricing or dwell time differences.
Formula
F&B revenue ÷ (Number of seats × Operating hours)Benchmark by concept
Busy lunch
€8–15/seat-hr
Evening restaurant
€12–25/seat-hr
Cocktail bar
€20–40/seat-hr
What does this KPI tell you?
Higher RevPASH is not always better — a fine dining restaurant with low turnover but high spend per cover makes a deliberate choice about this balance. Use as a trend KPI, not as an absolute target.
Power BI implementation tip
Calculate per hour of day to identify peak hours and dead zones. Combine with table turnover rate to diagnose whether low RevPASH is caused by low occupancy or low spend per cover.
06
Average Spend per Cover
Total F&B revenue divided by covers served — includes all food and beverage per guest.
Revenue
Definition & why measure
Total F&B revenue divided by the number of covers served. Includes food, beverages and all served consumption per guest.
Declining average spend is an early signal of menu development failures, falling beverage revenue or a shifting guest mix. This KPI makes trends visible before they show up in the margin.
Formula
Total F&B revenue ÷ Total covers servedBenchmark by concept
Casual lunch
€15–30
Full service dinner
€35–55
Fine dining
€60–120+
What does this KPI tell you?
The absolute value varies widely by concept. What matters is the trend: if spend per cover is falling month on month, there is work to do on the menu, upsell training or the beverage proposition.
Power BI implementation tip
Split food and beverage spend per cover. Track beverage attach rate — beverage spend as a percentage of food spend — as the first indicator of a beverage revenue problem before it appears in total figures.
07
Food Waste %
Value of wasted food as a percentage of total food purchase value — includes spoilage, overproduction and prep waste.
Operations
Definition & why measure
Value of wasted or discarded food as a percentage of total food purchase value. Includes spoilage, overproduction and preparation waste.
Food waste typically costs 4–10% of food purchase value — directly from the margin. Measuring waste is the first step toward better inventory and recipe management that prevents it from recurring.
Formula
(Value of wasted food ÷ Total food purchase value) × 100%Waste levels
Excellent
< 3%
Acceptable
3–6%
Concerning
> 8%
What does this KPI tell you?
8% waste on a food purchase budget of €200,000 is €16,000 in direct losses per year — before operational and sustainability impact. Measurement starts with kitchen weighing at the pass.
Power BI implementation tip
Categorise waste by reason: spoilage, preparation waste, plate returns. Link to purchase date and supplier for root cause analysis. Display as a Pareto chart per product group — that drives recipe changes.
08
Table Turnover Rate
Times a table is occupied per service period — critical for revenue maximisation with fixed opening hours.
Revenue
Definition & why measure
The number of times a table is occupied per service period. A critical KPI for revenue maximisation in concepts with fixed opening hours.
Low turnover at a busy concept is lost revenue. High turnover at an exclusive concept can damage the guest experience. Every 0.1× improvement at 40 seats is immediately visible in daily revenue.
Formula
Total covers per service ÷ Number of available seatsBenchmark by concept
Fine dining
1–1.5×
Casual dining
1.5–2.5×
QSR / lunch
> 3×
What does this KPI tell you?
At a casual dining restaurant with 50 seats and a 4-hour evening service: the difference between 1.5× and 2.0× turnover is 25 extra covers per evening. At €40 average spend, that is €1,000 extra per service.
Power BI implementation tip
Link to reservation system (TheFork, Resy) to compare planned versus actual occupancy. Analyse dwell time per day and service — that reveals where the operation flows smoothly and where it stalls.
09
Guest Satisfaction Score
Composite score from reviews, surveys and/or NPS — the most direct quantitative measure of guest experience.
Guest
Definition & why measure
Composite score based on online reviews, surveys and/or NPS. The most direct quantitative measure of guest experience and perceived quality.
Online reputation is a direct business risk. A drop of 0.1 points on Google is measurable in occupancy rate. The score is also the synthetic indicator for everything that is going operationally right or wrong.
Formula
Weighted avg. review score (1–10) or NPS (−100 to +100)Score levels
Minimum
≥ 7.0
Good
≥ 8.0
Excellent
≥ 9.0
What does this KPI tell you?
8.4 on Google is good — but if the trend has declined from 8.7 to 8.4 over the last three months, that is an early warning signal that needs investigation before the damage becomes structural.
Power BI implementation tip
Aggregate Google, TripAdvisor and internal surveys into one dashboard. Link reviews to date and day of the week to identify patterns. Show the ratio of 5-star to 1–2-star reviews — that gives faster signal than an average.
10
F&B Stock Turnover
How quickly food & beverage inventory converts to revenue — COGS divided by average inventory value.
Operations
Definition & why measure
How quickly food & beverage inventory is converted into revenue. Calculated as cost of goods sold divided by average inventory value.
Low inventory turnover increases spoilage, ties up working capital and raises the risk of quality problems reaching the guest. Too high turnover signals stock shortages that put kitchen operations under pressure.
Formula
F&B COGS ÷ Average F&B inventory valueBenchmark by category
Fresh produce
15–25×
Dry goods
4–8×
Beverages
8–15×
What does this KPI tell you?
Fresh produce with a turnover of 10× (every five weeks) is a quality risk — fresh items should turn every 2–3 days. Dry goods at 2× are a capital problem. Both extremes have different root causes and remedies.
Power BI implementation tip
Calculate per product group (fresh, dry, frozen, beverage). Display as a heat map per delivery weekday — this immediately shows which delivery day causes over-stocking versus which arrives too lean.
Download all 10 KPIs as PDF
Free — no email address required
Frequently asked questions
Hospitality KPIs in Power BI — questions & answers
Which KPIs are most important for a hospitality management dashboard?
For a hospitality management dashboard, Food Cost %, Labour Cost % and Guest Satisfaction Score are the three most critical KPIs. They directly affect margin, operational efficiency and guest retention. Den Otter Solutions implements these three as the standard baseline dashboard for new hospitality clients — and builds outward from there based on concept type and specific pain points.
How do I connect my POS system to Power BI?
Most modern POS systems (Lightspeed, Untill, Square, Toast) have an API or export option to Excel or CSV. Power BI can retrieve those sources automatically via Power Query. Den Otter Solutions connects POS data to purchase invoices, scheduling data and review platforms in one model — so food cost, labour cost and guest satisfaction appear in the same dashboard.
What is a good food cost percentage for a casual dining restaurant?
For casual dining, 28–35% is the standard range. QSR concepts target 25–30%; fine dining accepts 30–38% because average spend per cover is higher. Structurally above 38% at casual dining points to portioning, purchasing or waste problems. Den Otter Solutions always measures per menu group — so it becomes clear which dishes are pulling the margin down.
How long does it take to build a hospitality dashboard in Power BI?
A baseline dashboard covering food cost, labour cost and revenue KPIs typically takes 3–5 working days with a single POS source, or 6–10 days with multiple locations or additional data sources such as reviews or purchasing software. Den Otter Solutions always starts with a Data Start Scan to assess the current state and set a realistic build timeline — avoiding surprises on both sides.
Ready to put these KPIs to work
in your hospitality business?
Den Otter Solutions builds dashboards for hospitality and food businesses that want to manage on margin, labour efficiency and guest experience. From data source to decision dashboard — including all 10 of these KPIs built out in your own Power BI environment.