Restaurant Prime Cost & Weekly KPI Dashboard

Know the numbers that need attention without living inside a spreadsheet.

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.

Automatically calculates:

• 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.