The Restaurant KPI Dashboard

Enter one week of numbers and see seven key numbers against the benchmark for your concept.

By Rob Bruni, founder of OpsEdge Hospitality, twenty years running restaurants, bars, clubs and resorts. Updated November 2026.

A restaurant KPI dashboard puts the handful of numbers that decide the week on one screen, next to the range they should be in. Pick your concept, enter one week of numbers, and the scorecard below shows seven key numbers with a status for each. Nothing is saved or sent anywhere.

Your concept

One week of numbers

NumberThis weekTarget rangeStatus
Prime cost62.8%60 to 65%On target
Food cost (of food sales)31.1%28 to 34%On target
Beverage cost (of beverage sales)22.0%18 to 24%On target
Labor cost34.0%30 to 35%On target
Sales per labor hour$57.69$45 to $75On target
Average check per guest$37.50$25 to $45In range
Comps and voids1.5%Under 2%On target

Total sales $30,000. Every number is inside its range this week.

Target ranges come from our benchmarks by concept. They are planning ranges, not rules. Your own trend over several weeks matters more than any single week against a benchmark. Watch means within two points above the range.

The seven numbers and what each one tells you

NumberFormulaWhat it tells you
Prime cost(Food cost + beverage cost + labor) ÷ total salesWhether the restaurant can make money. The number to watch first.
Food costFood cost ÷ food salesPricing, portions, waste and purchasing
Beverage costBeverage cost ÷ beverage salesOver pouring, giveaways and bar pricing
Labor costTotal labor ÷ total salesWhether the schedule matched the sales
Sales per labor hourTotal sales ÷ hourly labor hoursProductivity, independent of wage rates
Average checkTotal sales ÷ guestsMenu mix, selling and pricing
Comps and voidsComps and voids ÷ total salesMistakes, guest recovery and control at the register

Getting the inputs right

  • Food and beverage cost come from counts, not from purchases alone: opening inventory plus purchases minus closing inventory. A weekly count of your key items is enough to start. The inventory guide shows the method.
  • Labor is fully loaded. Hourly wages, salaried managers, payroll taxes, benefits and workers' compensation. Leaving out the burden flatters the number by five to eight points.
  • Use net sales. Sales after discounts and comps, before sales tax and tips.
  • Use the same week for everything. Monday to Sunday, counted on the same day each week.

How to read the dashboard

  1. Start with prime cost. If it is in range, the week was sound even if one part is off.
  2. If prime is high, find which part moved. Food, beverage or labor. It is usually one.
  3. Check sales against the forecast. A high labor percent on a slow week is a forecasting problem before it is a scheduling problem.
  4. Compare to your last four weeks, not only to the benchmark. A two point move in a week is worth a conversation.
  5. Pick one action. One number, one owner, one thing to change this week.
If this is overLook here first
Food costPortioning on the line, waste and spoilage, price increases on invoices, menu mix. See the food cost guide.
Beverage costOver pouring, unrecorded comps, draft waste, drinks not rung in. See the pour cost guide.
Labor costThe schedule against the forecast, overtime, early clock ins, slow nights without cuts. See the labor cost guide.
Comps and voidsWho is approving them, the reasons on the manager log, and whether one server or one shift stands out.

Build your own weekly dashboard

The scorecard above shows one week. A working dashboard shows the trend. You can build one in a spreadsheet in an hour.

  1. One row per week, with the eight inputs above.
  2. Formulas for the seven numbers in the columns to the right.
  3. A target for each number, set from your own actuals. The KPI targets guide shows how.
  4. Color the cells green, yellow or red against the target.
  5. Add a four week average so one odd week does not send you chasing noise.
  6. Review it every Monday with your managers. The weekly routine guide has the meeting agenda.

The dashboard, already built

The Restaurant P&L Statement and Prime Cost Dashboard shows prime cost, budget against actual, cash flow and three year trends in one workbook. Need several locations on one screen? The Custom KPI Dashboard is built around the logbook you already run.

See the P&L and Prime Cost Dashboard See the Custom KPI Dashboard

FAQ

What is a restaurant KPI dashboard?

A one screen summary of the key numbers that show how a restaurant is performing, usually weekly: prime cost, food cost, beverage cost, labor cost, sales per labor hour, average check and comps, each shown against a target.

What KPIs should a restaurant track?

At a minimum, sales against forecast, prime cost, food cost, beverage cost, labor cost and sales per labor hour. Average check, comps and voids, and guest counts add useful detail.

What is a good prime cost for a restaurant?

As planning ranges: 55 to 60 percent of sales for quick service, 60 to 65 percent for full service, 50 to 55 percent for bars and 62 to 68 percent for fine dining and clubs. Above 70 percent there is little room for rent and profit.

How often should restaurant KPIs be reviewed?

Weekly for cost and labor numbers, on the same day each week, with sales and labor checked daily. A monthly P&L alone arrives too late to fix a problem.

How do you calculate sales per labor hour?

Divide net sales by the hourly labor hours worked in the same period. $30,000 in sales with 520 hours is about $58 per labor hour.

Can I build a restaurant KPI dashboard in Excel?

Yes. Use one row per week with sales, costs, labor, hours and guests, add formulas for each KPI, set a target for each, and color the cells against the target. Add a four week average to see the trend.