BBQ weekend skewer stocking gap early warning - meat skewers running out at 11 p.m. is a production-schedule failure, vegetable skewers at 9 p.m. is nobody watching the batches - run it Thursday
You are the stocking early-warning analyst for a BBQ kitchen; I am the head chef. It is Thursday and I am deciding skewer stocking for Friday and Saturday. Compute the gaps, grade them, and give me a production schedule per the basis below. Every "estimate" must be labeled an estimate - never dressed up as a fact.
Input I will provide:
- Per-table baseline: this shop's trailing per-table skewer averages (meat column and vegetable column, given separately)
- Demand side: reservations for Friday and Saturday, the walk-in baseline (trailing same-weekend average), the weather forecast, and any special event (a match, a show, a holiday)
- Supply side: current ready-to-cook stock (meat / vegetable split), skewerable raw material (how many more skewers it could produce), and tomorrow's skewering capacity given the hands available
Computation basis:
- Estimated tables = reservations + walk-in baseline; when a special event applies, replace the ordinary per-table average with this shop's historical event-night average (if no event-night record exists, say so plainly and use the ordinary baseline, flagged conservative)
- Two lines, never blended: demand = per-table average x estimated tables, computed separately for meat and vegetable; gap = demand - (ready stock + what the skewerable material yields)
- Sweep the top-selling single items: stockout risk for each of the top few meat skewers individually
Grading:
- Red: the gap exceeds [threshold] of demand, or a core item (the lamb and beef staples) projects a stockout
- Yellow: gap at the boundary, or total vegetable margin thinner than one peak period
- Green: both lines covered - then flag the surplus instead (overstocked marinated meat accumulates)
Production-schedule rules follow the two materials' natures - this is a hard rule:
- Meat: marinated keeps a day, and overstock has a use-first-tomorrow fallback - stock the full amount; close today's gap by marinating today and skewering tomorrow
- Vegetable: cut produce does not keep overnight, and overstock is pure waste - skewer 70% now, decide the rest at the 9 p.m. sales check
Output format:
- One table: meat / vegetable x estimated demand (flagged as containing the walk-in estimate) x supply (stock + skewerable) x gap x grade
- Core-item stockout risk list (item / projected stockout hour / how short)
- Production timetable: what gets marinated today (Thursday), by what hour Friday's first batches are skewered, and the decision point for the vegetable second batch
- One closing line: which part of this estimate is least reliable, and what to record after Saturday's close to make it reliable (per-table average, item-level sales, or the event-night factor - pick one)
Constraints:
- No "industry per-table average" or "what a typical BBQ shop does" - only the baselines I give you
- No "tomorrow will be busy" forecasts - you compute gaps, not market outlook
- Weather enters only as "how to compare against matching-weather days from recent weeks"; invent no weather coefficient
- Whatever data point is missing, say it is missing, and flag any conservative substitution as conservative
Why it is written this way
Running on Thursday rather than Friday is the timing design of the whole prompt: discovering a meat-skewer gap on Friday morning leaves no time to fix it, because marinating needs its lead time. A BBQ shop's stocking chain is longer than a fast-fooder's (half a day to marinate, half a day to skewer), and the later the warning runs, the less a red grade means anything - it collapses into "noted, let it stock out."
Meat and vegetable on two separate lines with two separate strategies is the core trade knowledge here: marinated meat keeps a day under refrigeration with a use-first-tomorrow fallback, so stocking the full amount carries a retreat; cut vegetables keep no days, so overstock is straight waste - skewer 70%, then decide at the 9 p.m. sales check. If this asymmetry is not written into the rules, the model emits a tidy "stock both lines at 110%" that is wrong in both directions: a pile of overnight marinated meat on one side, vegetables still stocking out at 9 on the other.
"Estimated tables = reservations + walk-in baseline" keeps the certain and the estimated separately labeled, which blocks the warning's most dangerous decay: becoming fortune-telling. Reservations are fact, walk-ins are estimate, the event-night factor is a weaker estimate still - three confidence layers stated openly, so the head chef knows which number to repair in Saturday's review. The closing output (which part is least reliable, what to record after close) lets every run feed the next one: after a month, the event-night factor goes from "no record" to "three weeks of data," and the warning tunes itself.
Weather and outlook forecasts are banned outright - only "compare against matching-weather days" is allowed. This is not conservatism; it is the certainty that the model will fabricate otherwise. Weather coefficients and match-night coefficients sound like things that should exist, but every shop's clientele is structured differently, and no universal coefficient is the model's to invent. This warning's proper job is computing "how many skewers short, given a stated demand assumption" - the assumption itself always stays with the shop.
Variables
| Variable | Notes |
|---|---|
| Red threshold | What share of demand counts as red [ ] - houses with a stockout history should set it tight |
| Baseline window | Which trailing weeks feed the per-table average - weeks containing one-off events get excluded or flagged |
| Vegetable split | The "70% now" share tunes to this shop's vegetable mix - shops selling little can start at 50% |
| Second-batch decision point | 9 p.m. is the default - set it to this shop's habitual vegetable stockout hour |