Main KPI dashboard
Review weekly performance using clear KPI cards, trend visuals and operating status indicators.
Excel Dashboard
Weekly KPI Dashboard
Track weekly sales, labour cost, food cost, prime cost, covers, average spend and performance trends in one practical Excel dashboard.
Review weekly performance in one dashboard
The Weekly KPI Dashboard helps managers and operators track the numbers that explain weekly performance, cost pressure and operating direction.
It is built for hospitality teams, restaurants, cafés and bars, but the structure can also support other small businesses that need a simple weekly KPI system without complex software.
✓ Excel dashboard
✓ Instant access
✓ Weekly KPIs
✓ No macros
What is included in the Weekly KPI Dashboard?
This Excel dashboard gives managers a simple way to review weekly sales, labour, food cost, prime cost and operating performance without building a reporting system from scratch.
Targets and benchmarks
Set KPI targets and compare actual performance against labour, food cost, prime cost and profitability goals.
Weekly data library
Enter weekly sales, covers, labour cost, food cost and performance data in a structured format.
Dashboard previews
The workbook includes connected sheets for KPI input, targets and dashboard review, helping managers turn weekly numbers into clearer operating decisions.
Main dashboard
Review weekly performance at a glance with sales, labour, food cost, prime cost and trend indicators.
KPI targets
Set performance targets and use simple status indicators to spot which areas need attention.
Data library
Enter weekly data in one structured place so the dashboard can support consistent performance reviews.
What you get
- Excel weekly KPI dashboard workbook.
- Main performance dashboard for weekly review.
- KPI target sheet with status indicators.
- Weekly data library for sales, covers, labour and cost tracking.
- Views for labour cost, food cost, prime cost and performance trends.
- No-macro workbook designed for practical management review.
Who is this dashboard for?
This dashboard is designed for restaurants, cafés, bars, hotels, F&B teams and hospitality operators that want to review weekly performance without relying on scattered spreadsheets.
It can also be adapted by other small businesses that need to track weekly sales, cost pressure, targets and operating performance in Excel.
How to use the dashboard
- Enter weekly sales, covers, labour cost, food cost and operating data.
- Set targets for the KPIs you want to monitor.
- Review status indicators to see what is on track or under pressure.
- Use the dashboard during weekly management reviews.
- Compare trends over time instead of judging one week in isolation.
- Use the results to guide labour, purchasing, pricing and operational actions.
Related tools and resources
Use this dashboard alongside Ops Hospitality calculators and guides to review weekly performance, prime cost, profitability and operating pressure.
Weekly KPI Dashboard FAQs
Is the Weekly KPI Dashboard free?
No. The Weekly KPI Dashboard is a paid Excel dashboard available through Gumroad.
Does the dashboard work only for restaurants?
No. It is built with hospitality operations in mind, but the structure can be adapted by other small businesses that track weekly sales, labour, costs and performance targets.
Can I use the dashboard in Google Sheets?
The workbook is designed for Excel. You may be able to upload it to Google Sheets, but some formatting, formulas or dashboard behaviour may vary.
What KPIs does the dashboard help track?
The dashboard helps track weekly sales, covers, average spend, labour cost, food cost, prime cost, profitability indicators and performance trends.
Get the Weekly KPI Dashboard
Start reviewing weekly sales, labour, food cost, prime cost and performance trends in one Excel dashboard.