Restaurant Prime Cost & Weekly KPI Dashboard

This restaurant prime cost spreadsheet is an Excel dashboard for managers who need a clear weekly view of food cost, labor and sales performance. Enter daily sales and labor figures plus weekly inventory inputs to calculate prime cost and review results against your own targets.

A manager-first Excel system that turns daily sales and labor entries plus a few weekly inventory inputs into a clear weekly operating pulse.

Enter daily: food sales, beverage sales, other sales, covers, labor hours and labor cost.

Enter weekly: beginning inventory, purchases and ending inventory.

Restaurant KPIs calculated

• Total sales and average check

• Labor %

• COGS and COGS %

• Prime cost and prime cost %

• Sales per labor hour

• Sales vs target

• Prior-week and week-over-week change

• Manager attention status

Includes a plain-English KPI Guide and user-defined targets rather than forced generic benchmarks.

Excel • No macros • No subscription. Management aid only; use accounting-system figures and methods that match your business.

Related tools

For related workflows, explore Restaurant Manager Operations Dashboard PRO; Restaurant & Cafe.