Net sales
599,607
Target 625,800
Below target, usual paceDashboard · Power BI rebuild
Eight coffee shops, 21 months of sales. Four report pages: where we stand, how each store's week went, where growth comes from, and whether delivery pays. Data to 30 September 2026.
Demo data: Bean & Brew, a made-up coffee chain. Rebuilt in HTML from my Power BI report.
Stores reads whole weeks up to 30 September 2026, so the year and months do not apply here.
2026 · Jan to Sep · All 8 stores
599,607
Target 625,800
Below target, usual pace71.9%
Last year 71.8%
Above normal, good29.95
Last year 30.14
Within normal1.97%
Last year 2.01%
Within normal19.3%
Last year 20.0%
Within normalCoffee is 62% of net sales.
By design: 89% of the gap is our normal pace.
9 of 9 months below target. The plan asks 3.7 pts more than we usually reach.
Downtown and Old Town hold 45% of the gap.
| What it is | Open | |||
|---|---|---|---|---|
| Re-base the plan, or fund the growth it assumesThe plan sits 3.7 pts above our normal pace | Gap built into the plan | Finance and leadership | ||
| Renegotiate delivery commissionEach 5 pts is 5.8K. Delivery keeps 52% vs 72% in store | Commission paid | Partnerships | ||
| Target discounts instead of spreading themEvery loyalty tier gets the same mix. Spread 1.5 pts | Discounts given | Marketing | ||
| Reprice or bundle Chicken Wrap and Fruit SmoothieGrowing slower than the company (+10.6%) | Lost against the company pace | Menu team | ||
| Recover Old Town2 of the last 4 weeks below its normal range. −18.6% vs plan | Short of plan, last 4 weeks | Area manager, South | ||
| Recover Tech Park3 of the last 4 weeks below its normal range. −15.8% vs plan | Short of plan, last 4 weeks | Area manager, South | ||
| Capture customer ID on delivery orders54% of delivery sales can't be called new or moved | Data gap, no amount | Ops and IT |
Week of 21 Sep · All 8 stores
−7.3%
Normal −7.6 to +2.4%
Within normal−11.2%
Normal −7.6 to +2.4%
Below normal610
Normal 424 to 473
Above normal, good28.16
Normal 29.42 to 30.62
Below normal20.2%
Normal 17.7 to 20.3%
Within normalLast 4 full weeks, net sales by store. Tap a store to focus on it.
The chain: every week inside the range, but the last 4 together run below normal.
Shaded: the last 4 full weeks. Hollow dot: this week so far.
Peak 11:00, quietest 20:00. Last 4 full weeks.
| Normal range | Next step | ||||
|---|---|---|---|---|---|
| Below normal | −15.8% | −10.4 to +6.3% | 3 of 4 | Visit this week. Agree a recovery plan. | |
| Below normal | −18.6% | −22.6 to +11.9% | 2 of 4 | Visit this week. Agree a recovery plan. | |
| Within normal | −2.5% | −9.2 to +12.8% | 1 of 4 | Usual pace, below plan. Review the plan. | |
| Within normal | −8.0% | −21.7 to +18.4% | 2 of 4 | Usual pace, below plan. Review the plan. | |
| Within normal | −0.3% | −10.0 to +18.3% | 0 of 4 | Usual pace, below plan. Review the plan. | |
| Within normal | −3.7% | −25.0 to +11.7% | 0 of 4 | Usual pace, below plan. Review the plan. | |
| Within normal | +3.6% | −16.6 to +12.5% | 0 of 4 | Hold. | |
| Above normal | −0.6% | −17.7 to 0.0% | 0 of 4 | Find what changed. Repeat it. |
2026 · Jan to Sep · All 8 stores
19.3%
−0.7 pts vs last year
23,158
+6.8% vs last year
3,920
+9.6% vs last year
29.54
−2.6% vs last year
51.8%
+0.2 pts vs last year
Delivery orders by category. An order with two categories counts in both.
Break-even on proven new sales only at 3.0% commission.
At 20% commission, delivery needs 27.9% of its sales to be new to break even.
Per order: delivery keeps 71% of what dine-in keeps.
At 20% commission, each delivery order pays 5.91 to the app. Cost of goods per order is about the same in every channel, so commission makes the difference.
| Focus | |||||
|---|---|---|---|---|---|
| 19.5% | 51.5% | 3.5% | Capture customer ID. Margin below the chain | ||
| 19.1% | 52.2% | 4.4% | Capture customer ID | ||
| 20.4% | 51.6% | 5.8% | Capture customer ID. Leans on delivery more than the chain. More new customers | ||
| 19.3% | 52.0% | 1.9% | Capture customer ID | ||
| 20.4% | 51.5% | 4.0% | Capture customer ID. Leans on delivery more than the chain. Margin below the chain | ||
| 18.5% | 52.0% | 4.6% | Capture customer ID | ||
| 18.1% | 52.1% | 5.7% | Capture customer ID. More new customers | ||
| 18.6% | 52.2% | 5.2% | Capture customer ID |