Forecast Dashboard
Multi-tab ECharts dashboard with KPIs, trends, labor efficiency, and variance analysis
Overview
The Forecast Dashboard provides a visual, multi-tab analytics experience for reviewing forecasting performance across locations. Built with ECharts for full interactivity, it surfaces the key metrics restaurant operators need at a glance.
Navigation
Navigate to Forecasting > Dashboard from the sidebar. The dashboard loads the current (or most recent completed) week by default. Use the date picker and location filter to adjust the view.
Dashboard Tabs
Overview Tab
The Overview tab provides a high-level snapshot of forecasting KPIs:
KPI Cards (top row):
| Metric | Description | Calculation |
|---|---|---|
| Forecast Sales | Total projected sales for the period | Sum of all daily forecasts |
| Actual Sales | Total recorded sales | Sum of sales actuals |
| Variance $ | Dollar difference | Actual − Forecast |
| Variance % | Percentage difference | (Actual − Forecast) ÷ Forecast × 100 |
| Labor % | Labor cost as % of sales | Labor Cost ÷ Sales × 100 |
| SPLH | Sales Per Labor Hour | Sales ÷ Total Labor Hours |
| Guest Count | Total guests served | Sum of daily guest counts |
| Avg Check | Average transaction value | Total Sales ÷ Guest Count |
| OT Hours | Total overtime across all positions | Sum of hours > 40/wk/employee |
Charts:
- Forecast vs Actual (Bar + Line) — Daily bar chart of forecast with actuals overlaid as a line
- SPLH / Labor % Trend (Dual Axis) — Daily SPLH on left axis, labor % on right axis
Sales Performance Tab
Detailed sales analysis:
- Daily Sales Table — Date, forecast, actual, variance, guest count, avg check
- Location Comparison Chart — Stacked bar comparing sales across locations
- Week-over-Week Trend — How this week compares to prior weeks
Labor Efficiency Tab
Labor-focused metrics and visualizations:
- Labor % Gauge — Visual gauge showing current labor % vs. 25–30% target range
- Position Breakdown (Stacked Bar) — Hours by position across the week
- Daily Labor Table — Date, forecasted hours, actual hours, labor cost, SPLH
- Efficiency Score — Composite metric combining SPLH, labor %, and OT hours
Variance Analysis Tab
Identifies where forecasts deviated most:
- Location Heatmap — Red-to-green grid showing variance by location × day
- Variance Detail Table — Sortable table with all locations, days, and variance metrics
- Root Cause Indicators — Flags days with events vs. unexplained deviations
Metrics Catalog Tab
Reference for all available metrics:
| Status | Meaning |
|---|---|
| Live (Green) | Metric is calculated and displayed with current data |
| Placeholder (Amber) | Metric defined but requires additional data from Snowflake |
Live Metrics:
- Forecast Sales, Actual Sales, Variance $, Variance %
- SPLH, EPLH, Labor %, OT Hours
- Guest Count, Avg Check, Covers Per Labor Hour
- Prime Cost % (labor + COGS, placeholder for COGS component)
Placeholder Metrics (require Snowflake data):
- COGS %, Food Cost %, Beverage Cost %
- Theoretical vs Actual Food Cost
- Revenue Per Available Seat Hour (RevPASH)
- Server Sales Per Hour
Filters
All tabs support these filters:
| Filter | Options |
|---|---|
| Week | Date picker for the forecast week |
| Location | All locations, or select specific |
| Comparison | vs. Forecast, vs. Prior Week, vs. Same Week Last Year |
Exporting
Dashboard data can be exported:
- CSV — Raw data table export for further analysis
- PDF — Formatted report with charts (coming soon)