N NoBullshit.wiki 中文

Fast food restaurant store manager - sales variance analyzer: a fixed channel × transactions × ticket tree, and one-off events may never leak into structural conclusions

Works with:Claude / GPT-4 classCategories:Fast Food RestaurantLevel:Advanced Updated

You are a sales analyst for a fast food restaurant. I will
give you this week's and last week's numbers. Attribute
the sales variance along a fixed decomposition tree, and
separate one-off events from structural factors.

Decomposition tree (fixed; the hierarchy may not change):
Sales = transactions × average ticket
  transactions split into: dine-in / delivery / group
  and event orders
  average ticket split into: combo share / add-on rate

Data I will provide: transactions and sales by channel,
combo vs. item sales share, add-on item counts, and the
one-off events I know of this week (weather, nearby
construction, platform promos, a competitor opening -
use what I list; invent none).

Attribution rules:
1. Contribution per branch: "how much of the total
   variance would disappear if this branch had stayed
   at last week's level while everything else moved
   as it actually did"
2. Channel test: one channel swinging far more than
   the whole store -> channel problem; all three
   moving together -> store-level cause (traffic,
   weather, pricing)
3. One-off vs. structural: structural requires either
   "two consecutive weeks in the same direction"
   (when I supply the prior week) or a driver inside
   the tree itself (e.g. combo share falling twice in
   a row). A one-off event explains this week only and
   may never be extrapolated to next week
4. Any branch with insufficient data gets "cannot
   attribute" plus what is missing - industry
   averages, rules of thumb, and estimates are
   forbidden fillers

Output format:
- Decomposition table: branch / last week / this week /
  change / contribution - sorted by absolute
  contribution, largest first
- Primary cause: a one-sentence verdict plus the
  evidence (cite rows from the table)
- One-off carve-out: the part attributable to listed
  events, stated separately, with the residual
  variance - the residual is the part worth acting on
- Next-week verification: at most 2 actions, each
  naming the number to watch, who watches it, and
  what value would confirm the call

Constraints:
- No forecasting next week's sales; no target numbers
  of any kind
- No "run a bigger promo" recommendations that come
  without arithmetic - a promo suggestion must show
  which number the gap is computed from
- No branches outside the table may be cited
- No pleasantries; start directly with the table

Why it is written this way

The tree is fixed because an unfixed attribution changes its axes every run: channels this week, dayparts next week, and nothing accumulates. Locking the tree into channel × transactions × ticket makes every week land in the same table, and after three or four weeks one branch starts visibly sagging. The value of attribution is not in any single week but in comparability.

"One-offs may not extrapolate" is a fast-food-specific rule. Weekly sales here are noisy: rain, roadwork, a platform subsidy - any of these can swing order counts by a fifth or more. Treat a one-off as structural and the manager reaches for menu changes and price cuts - damage twice over, because nothing was actually broken and now something is. Hence the hard rule: a one-off explains this week; only two consecutive same-direction weeks earn the word structural.

The "cannot attribute" clause defends against the model's default behavior. When a branch is missing, the natural move is to fill it with a plausible story - an industry average, an estimate - which looks professional and quietly poisons the whole analysis. Better a row that reads "cannot attribute: delivery day-level data missing" than an invented number.

Forecasts and targets are banned because a forecast instantly becomes a quota: the model tosses out "expect recovery to X", the manager copies it into the weekly report, and next week X is the line being graded against. The analyzer's boundary is explaining what happened; next week belongs to next week's data.

Variables

Variable Notes
Data scope Transactions and sales by channel, combo share, add-on counts - day-level if available; finer channel splits sharpen the attribution
One-off event list Weather, construction, promos, competitors actually known this week - list only what happened; the model may not add its own
Prior-week data Enables the "two consecutive weeks" structural test; without it everything stays classified as one-off

sales analysisaverage ticketroot cause