Topline
Automated Franchise Intelligence
Week Ending Feb 17, 2025
Apex Restaurant Group · 8 Stores
The greeting is personalized to each recipient. The operator gets this view; DMs get a version focused on their stores; GMs get their individual action card — all sent from the same automated run.
Net Sales
$384K
+2.1% vs LY
Portfolio SOS
247s
Goal <250s
Labor vs Budget
+1.8%
~$4,200/wk excess
Store Status
●● ●●●● ●●
2 green · 4 watch · 2 red
OT Hours
157h
↑ 38h vs last wk
Five KPIs across the top — glanceable in under 5 seconds. The operator knows if it's a good week or bad week before reading a single word. Labor vs Budget shows dollars, not just a percentage.
⚠️ Top 3 Issues This Week — Action Required
Issue #1 — Smyrna: Drive-Thru SOS Critical (421s)
3rd consecutive week
SOS at Smyrna has trended from 287s (8 weeks ago) to 421s — a 47% deterioration. Pattern analysis suggests understaffing at the window position during lunch and dinner dayparts. Smyrna's void rate is simultaneously elevated at 2.4%, indicating order accuracy problems causing remakes that extend car times. This is not a one-week anomaly; it is an operational pattern that will continue costing throughput revenue until the root cause is addressed.
Recommended Actions — Marcus (DM):
- Conduct a daypart observation at Smyrna this week — specifically the window position during 11:30am–1:30pm and 5pm–7pm.
- Review last 4 weeks of schedule at Smyrna for window position — compare staffed hours to transaction volume by daypart.
- Coach the GM on pre-build discipline: window times correlate with grill positioning. Confirm the bagging process is consistent.
Issue #2 — Woodstock: Labor 4.4pts Over Budget (28.4%)
Unacknowledged — 3 days
Woodstock's labor is at 28.4% against a 24% budget — $1,248 excess labor dollars this week alone. Elevated OT (35h) is the primary driver. This alert was generated Thursday and has not been acknowledged by Sandra or the Woodstock GM. At current pace, Woodstock will contribute $64,896 in excess annual labor cost if not corrected.
Recommended Actions — Sandra (DM):
- Acknowledge this alert — log the action you're taking so the accountability loop closes next Monday.
- Review Woodstock's schedule for the coming week. Identify which employees are driving OT and cap at 38h.
- If volume has dropped, the schedule hasn't adjusted. Check planned vs. actual hours for last 3 weeks.
Issue #3 — Kennesaw: Overtime Doubling (28h → this week)
Escalating · Watch
OT at Kennesaw jumped from 14h last week to 28h this week. Labor is 26.3%, already 2.3pts over budget. At the current OT trajectory, Kennesaw crosses into red territory next week. This is typically a coverage gap pattern — one or two employees being held over rather than scheduling additional part-time coverage.
Recommended Actions — Marcus (DM):
- Review Kennesaw's schedule Monday morning. Identify the two employees driving OT and confirm it's a coverage gap, not a staffing shortage.
- Set a hard cap: no Kennesaw employee above 38h without DM approval this week.
This is the AI-written narrative section — the most valuable part of the email. Not just "labor is over budget" but WHY, what pattern it fits, what it'll cost if unaddressed, and exactly what to do about it. This is what replaces Sunday-night Excel work.
👥 DM Accountability Snapshot
📍 Marcus 4 stores
2 red · 2 yellow
Smyrna — SOS 421s🔴 Critical
Kennesaw — OT rising🟡 Watch
Acworth — SOS 278s🟡 Watch
Marietta — SOS 162s✅ On track
Action logged on Smyrna (3 days ago). Kennesaw, Acworth pending.
📍 Sandra 4 stores
1 red · 2 yellow
Woodstock — Labor 28.4%🔴 Critical
Canton — SOS 245s🟡 Watch
Roswell — Labor +0.6%🟡 Watch
Alpharetta — SOS 175s✅ On track
⚠ No action logged on Woodstock. Alert unacknowledged 3 days.
The accountability snapshot tells the operator at a glance whether their DMs responded to last week's issues. "No action logged on Woodstock — 3 days" is the kind of visibility that didn't exist before. This is the Monday morning coaching tool.
Full reports ready in your dashboard.
SOS Trend (12 weeks) · Inventory Variance · All 8 GM Action Cards · Full Alert History
View Full Dashboard →