Blog · Board and management reporting · Hospitality
Restaurant operations manager KPIs compare sales, food cost, labor, and waste across locations and weeks. This worked example shows the export columns, calculations, reconciliation, and operating questions behind a useful location review.
A useful KPI for a restaurant operations manager connects location sales with food cost, labor, and waste for the same operating week. Track the dollars and the ratios together, then investigate which location, shift, or menu category explains the difference. A group sales increase can conceal a location whose costs are consuming most of its revenue.
The operations manager needs to decide where to investigate scheduling, purchasing, preparation, and sales execution. Each location manager should explain the local exceptions; finance should confirm the reconciliation. The report should distinguish a verified cost increase from an incomplete inventory count or a payroll file that arrived late.
| KPI | Formula | File it comes from | Decision it supports |
|---|---|---|---|
| Net sales | Sales after the defined discounts and reversals | Closed sales export | Where demand or realized revenue changed |
| Food cost percentage | Food consumption cost / net sales | Inventory and purchasing exports | Where to examine usage, prices, or menu mix |
| Labor percentage | Included labor cost / net sales | Payroll and sales exports | Where staffing cost needs explanation |
| Prime cost percentage | (Consumption cost + labor cost) / net sales | Reconciled cost workbook | Where operating contribution is under pressure |
| Sales per paid labor hour | Net sales / paid labor hours | Timekeeping and sales exports | Where staffing and demand need closer review |
| Average check | Net sales / completed checks | Sales export | Whether transaction value helps explain sales |
| Recorded waste share | Waste cost / food consumption cost | Waste and inventory logs | Which losses merit investigation |
For a hotel manager comparing banquet, bar, and dining outlets within one property, use food and beverage manager KPIs. This example instead compares separate restaurant locations with the same food-focused operating format. If beverages are material, retain their consumption and sales separately before building the combined prime-cost view.
Use a common location code and week-ending date across sales, timekeeping, payroll, purchasing, inventory, and waste files. Keep paid hours separate from labor dollars. The former captures scheduling volume; the latter also reflects wage rates, overtime, benefits, and the cost categories you include.
Purchases are not automatically the food used that week. The IRS cost-of-goods-sold explanation shows the inventory principle: subtract closing inventory from goods available for sale. For this operating workbook, calculate opening inventory plus purchases plus net transfers received minus closing inventory. Retain the inventory valuation policy in the workbook notes; the broader cost of goods sold guide covers that distinction.
Record wasted food by location, item, reason, quantity, and cost. The EPA provides food-waste tracking logs specifically for recording quantity and reason. A cost total without reasons cannot distinguish overproduction from spoilage or preparation loss.
A US restaurant group closes the same operating week at North, South, and West. Food consumption includes recorded food waste. All labor costs follow the same policy; all paid hours include the staff whose costs appear in that policy. Money is USD.
| Location | Net sales (USD) | Food consumption (USD) | Labor cost (USD) | Waste within food cost (USD) | Paid hours | Completed checks |
|---|---|---|---|---|---|---|
| North | 70,000 | 21,000 | 24,500 | 1,050 | 1,400 | 2,800 |
| South | 50,000 | 16,000 | 19,000 | 800 | 1,000 | 2,000 |
| West | 30,000 | 10,500 | 13,500 | 900 | 750 | 1,500 |
| Total | 150,000 | 47,500 | 57,000 | 2,750 | 3,150 | 6,300 |
The calculated comparison follows. Percentages and dollar rates are rounded to two decimal places; use full precision before rounding the final display.
| Location | Food cost | Labor cost | Prime cost | Sales per paid hour (USD) | Average check (USD) | Waste / food consumption |
|---|---|---|---|---|---|---|
| North | 30.00% | 35.00% | 65.00% | 50.00 | 25.00 | 5.00% |
| South | 32.00% | 38.00% | 70.00% | 50.00 | 25.00 | 5.00% |
| West | 35.00% | 45.00% | 80.00% | 40.00 | 20.00 | 8.57% |
| Total | 31.67% | 38.00% | 69.67% | 47.62 | 23.81 | 5.79% |
West's prime cost is (10,500 + 13,500) / 30,000 = 80.00%. Its sales per paid hour are 30,000 / 750 = $40.00, and average check is 30,000 / 1,500 = $20.00. These figures identify a review priority; they do not establish that any particular shift has too many employees.
The group prime cost is 47,500 + 57,000 = $104,500. Dividing by $150,000 gives 69.67%. Calculate the group average check as 150,000 / 6,300 = $23.81, rather than averaging the location averages.
Use the same sites, equivalent operating days, and the same sales definition for the previous-week comparison. Keep new openings, closures, and unusual operating interruptions visible rather than quietly changing the location population.
| Location | Previous-week sales (USD) | Current-week sales (USD) | Change (USD) | Change |
|---|---|---|---|---|
| North | 65,000 | 70,000 | 5,000 | 7.69% |
| South | 52,000 | 50,000 | (2,000) | -3.85% |
| West | 30,000 | 30,000 | 0 | 0.00% |
| Total | 147,000 | 150,000 | 3,000 | 2.04% |
Group growth is (150,000 - 147,000) / 147,000 = 2.04%. North's gain offsets South's decline; West's sales are unchanged. Do not infer a labor trend from this table, because previous-week labor is absent. Request that file before saying whether scheduling improved or worsened.
First tie the $150,000 sales total to the closed sales ledger and the $57,000 labor total to the included payroll allocation. Tie $47,500 of consumption to inventory movement. Recorded waste of $2,750 stays within consumption and is not deducted again.
The remaining amount after prime cost is $150,000 - $104,500 = $45,500. It also equals North's $24,500, South's $15,000, and West's $6,000 added together. This is before rent, utilities, and other excluded costs; it is not net profit. The gross profit margin guide explains why accounting cost classification must remain explicit.
Ask West's manager to explain check value, labor coverage, and waste reasons together. Ask South's manager which days or channels account for the sales decline. Give each review an owner, a file to inspect, and a follow-up date; operations manager KPIs extends that accountability pattern across other site operations.
Upload a file or Google Sheet with location sales, labor, consumption, and waste; Covirage maps the columns, and its tools compute and check the weekly comparisons. The external AI model explains the differences with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.
See Covirage for hospitality for the industry context.
Prime cost combines the included food and beverage consumption cost with the included labor cost. Its percentage divides that combined amount by net sales. State whether labor includes payroll taxes, benefits, salaried managers, and contract staff so that comparisons use the same definition.
Use ratios alongside dollars: labor percentage, consumption percentage, sales per paid hour, and average check. Then review opening hours, service format, menu, and delivery mix. A smaller location should not receive the same sales target simply because it belongs to the same group.
Daily data helps managers examine shifts and dayparts. A closed weekly view makes location comparisons easier when weekdays and inventory cutoffs align. Mark partial weeks and preliminary costs, and avoid comparing a full operating week with a location that was closed for part of it.