Bewiched Dashboards

Enter the password for this page

Incorrect password
Store & area dashboards
Refreshed weekly · Mondays 9:30am

Company

Whole-company rollup — all 21 stores on one page, same seven tabs. The overview lists every store traffic-lit, and the visit section shows SMT site presence (Matt, Kel & Claire) from the Weekly SMT Visit Diary in place of a single coach's pattern.

Whole company · 21 stores

Bewiched — Company

All three areas combined · Jon · Ian · Rich
Estate sales, wages forecast, wastage, mix, F1 & sentiment in one view
SMT visit tables: Matt · Kel · Claire
🚦 Overview📈 Sales📅 Forecast♻️ Wastage🧺 Mix🏁 F1💬 Sentiment
Open company dashboard→

Weekly Scorecard

The company-level EOS Scorecard — the 13 measurables with an owner and a plan, traffic-lit binary (green ≥ plan, red below) on a Weekly tab, an identical Quarterly (QTD) tab, and a full quarter-week grid.

Company · EOS Scorecard

EOS Scorecard — Weekly & Quarterly

Traffic-light widgets · plan vs actual · two tabs
Weekly: Google & Rate-My-Shift health, Brew Crew kudos, SPH labour, bench
Quarterly: YoY sales & transactions, brand audit, F1, NPAT, food GP%
🗓️ Weekly📅 Quarterly🚦 On/off plan
Open EOS scorecard→
Store · Star Card

Bewiched Star Card — Store Scorecard

Per-store gold-star rating · two tabs · QTD / YTD
Tab 1 — Store Card: pick any of the 21 stores — overall Star Score with vs-YTD trend, four pillars (Team, Ops, Customers, Profit) as standardised widgets (headline + vs-last-week + vs-last-quarter), plus Brand foundations & Urgent support.
Tab 2 — Leaderboard: all 21 ranked by Star Score with pillar sub-scores and real-data completeness.
⭐ Store Card🏆 Leaderboard📅 QTD / YTD
Open Star Card→
Franchise · HoE / Ian’s

Franchise Fees Scale

Royalty fees linked to brand execution · monthly
Month dropdown × per-store view for the franchise stores (Attleborough, Glenvale DT, Balsall Common; Warwick Market Sq opening soon). Shows Brand score, Remote score, Combined /5 & /100, the royalty tier, Royalty %, Marketing %, Total Fee %, and the £ fee for the month — plus the full five-tier fee scale.
Open Franchise Fees→

Commercial & Range

Category & supplier analysis. Simply Lunch — June 2026 lunch-range performance (spend, EPOS, wastage, August refresh). Select Catering — the supplier-facing range review; note this one is external / supplier-facing, with its own separate password and site-level revenue removed.

Commercial · Range

Simply Lunch — June 2026

Lunch range · spend, EPOS, wastage, outliers
Simply Lunch spend by site, EPOS units by product, wastage & outlier actions across the estate.
📊 Spend🥙 EPOS🗑️ Wastage⚡ Outliers
Open Simply Lunch→
Commercial · Range · ⚠️ EXTERNAL / supplier-facing

Select Catering — Supplier Range (June)

Supplier-facing · separate password · revenue removed
Select Catering itemised spend, SKU range review, over-ordering outliers and a margin-probe list. Shared externally with the supplier — site-level revenue is stripped and it uses its own password (not the internal one).
📊 Overview🏬 By site🧾 SKUs💷 Probes
Open Select Catering→
Commercial · Range

Fresh Ideas — June 2026

Bakery / food sundries / ice cream supplier
Fresh Ideas spend by site, revenue cross-ref, all 172 SKUs — plus bakery EPOS sales (traybake, cake & pastry) as a buy-vs-sell view.
📊 Spend💷 Revenue🧾 SKUs🥐 Bakery sales
Open Fresh Ideas→

Maintenance

Estate maintenance — planned visits, reactive jobs (assigned vs completed, open by store) and the maintenance items raised in Claire's monthly audit action plans.

Estate maintenance

Maintenance

Planned visits · reactive jobs · audit action plans
Open reactive jobs, completion rate & open-by-store
Planned visits by store · audit maintenance items
🗓️ Planned⚙️ Reactive🔩 Issues📋 Audit actions
Open maintenance dashboard→

Area Dashboards

Area-level rollups for each coach — every store on one page. Each carries seven tabs: Area overview (traffic-lit scorecard + visit movements), Sales (last week & YoY, daypart & day-of-week growth), Forecast & hours (3-week sales & planned-hours forecast, CPH from the Store Targets sheet), Wastage & Yield, Mix & opportunity, Op's Excellence (F1 race + constructors' championship) and Sentiment (live Google ratings, team RMS, sickness & return-to-work). Live from BigQuery, the polling & F1 sheets, the visit rota, HRP and Google My Business.

Area · 9 stores

Jon's Area

Rushden Lakes · Kettering · Fletton · Corby · Bridge St · Olney · Burton · Higham · Rothwell
Area Coach Jon · constructor P3
£283k / 4 wks · Google 4.63★
🚦 Overview📈 Sales📅 Forecast♻️ Wastage🧺 Mix🏁 F1💬 Sentiment
Open area dashboard→
Area · 3 stores

Ian's Area

Glenvale DT · Balsall Common · Attleborough
Area Coach Ian · constructor P1
£122k / 4 wks · Google 4.87★
🚦 Overview📈 Sales📅 Forecast♻️ Wastage🧺 Mix🏁 F1💬 Sentiment
Open area dashboard→
Area · 9 stores

Rich's Area

Northampton DT · Mkt Harborough · Northampton · Billing DT · Leam Parade · Rugby · Train Stn · Wellingborough · Lower Heathcote
Area Coach Rich · constructor P2
£369k / 4 wks · Google 4.77★
🚦 Overview📈 Sales📅 Forecast♻️ Wastage🧺 Mix🏁 F1💬 Sentiment
Open area dashboard→

Engagement Coaches

Company-wide engagement view for each Engagement Coach — tab one is that coach's own movements (visit-pattern heatmap from the Weekly SMT Visit Diary), and tabs 2–7 are the same whole-company rollup as the Company dashboard: Sales, Forecast & Hours, Wastage & Yield, Mix, Op's Excellence (F1) and Sentiment across all 21 stores.

Engagement Coach · company-wide

Kel

All 21 stores + Leam Retail · SMT visit diary
Engagement Coach Kel · ~25% avg weekly site coverage
Tab one: her movements · tabs 2–7 company-wide
🧭 Movements📈 Sales📅 Forecast♻️ Wastage🧺 Mix🏁 F1💬 Sentiment
Open engagement dashboard→
Engagement Coach · company-wide

Claire

All 21 stores + Leam Retail · SMT visit diary
Engagement Coach Claire · ~35% avg weekly site coverage
Tab one: her movements · tabs 2–7 company-wide
🧭 Movements📈 Sales📅 Forecast♻️ Wastage🧺 Mix🏁 F1💬 Sentiment
Open engagement dashboard→

Store Performance Dashboards

Live performance for six Bewiched sites — three new openings, two established drive-thrus and an established high-street café. Each dashboard carries five tabs — Sales & Hours, Wastage, Sales mix & capture, Op's Excellence (F1) and Sentiment — and refreshes automatically every Monday from BigQuery, the F1 audit sheet, Google reviews and RMS.

High-street store

Olney

38 Market Place, Olney
Area Coach Jon · opened early 2026
Mirrored against HOE Balsall Common
📈 Sales♻️ Wastage🧺 Mix🏁 F1💬 Sentiment
Open dashboard→
High-street store

Attleborough

Attleborough, Norfolk
Area Coach Ian · opened 23 Apr 2026
Settled high (~£6.1k/wk) — a strong site
📈 Sales♻️ Wastage🧺 Mix🏁 F1💬 Sentiment
Open dashboard→
Drive-thru

Billing Drive-Thru

3 The Causeway, Great Billing
Area Coach Rich · newest site
Benchmarked vs Northampton & Glenvale DTs
📈 Sales♻️ Wastage🧺 Mix🏁 F1💬 Sentiment
Open dashboard→
Drive-thru · mature

Northampton Drive-Thru

Moulton Park, Northampton
Area Coach Rich · est. May 2021
#2 in the estate · +8.3% YoY · £75 CPH
📈 Sales♻️ Wastage🧺 Mix🏁 F1💬 Sentiment
Open dashboard→
Drive-thru · mature

Glenvale Drive-Thru

Glenvale Park, Wellingborough
Area Coach Ian · est. Nov 2024
#3 in the estate · +31% YoY · £67 CPH
📈 Sales♻️ Wastage🧺 Mix🏁 F1💬 Sentiment
Open dashboard→
High-street parade café

Leamington Parade

The Parade, Royal Leamington Spa
Area Coach Rich · lunch-led café
#8 in the estate · +22% YoY · £58 CPH · F1 P1
📈 Sales♻️ Wastage🧺 Mix🏁 F1💬 Sentiment
Open dashboard→
How to read these. New sites forecast sales from their opening curve; the mature drive-thrus show recent actuals + a forward forecast with real year-on-year growth. F1 is the unannounced Qualifying & Race audit. Sentiment pairs the live Google customer rating with the team's RMS "Rate My Shift" scores. Where a signal is thin or dipping, the dashboards say so rather than smoothing it over.