She just knows
Every week your buyer looks at a spreadsheet of stock levels, glances at last year, thinks about which customers are about to place their seasonal orders, remembers that the red version never sells in spring, and places orders. She has done it for years and is usually right. When she is on holiday, someone else tries to follow her approach and the warehouse ends up with the wrong things.
Now she has mentioned retirement, or cutting her hours, and you have realised that nobody else can do what she does. The knowledge is not written down anywhere. There is no formula to hand over. Demand forecasting in your business is one person's memory and instinct, and it is about to walk out of the door.
Why this knowledge never got written down
Experienced buyers work from patterns they have absorbed over years: seasonality, which customers order early, the effect of a price change, the products that sell together. Much of it is genuinely hard to explain. Ask them why they ordered a certain amount and the honest answer is often "it felt right".
Businesses also rarely ask. While the buyer is there and results are fine, there is no pressure to formalise anything. The spreadsheet grows columns only she understands. The process works until the day it has to be done by someone else.
What the dependency costs
| While forecasting depends on one person | The effect |
|---|---|
| Holidays and sickness | Orders placed by someone guessing, leading to gaps or excess |
| Succession | No way to train a replacement except years of shadowing |
| Growth in product range | One person can only give real attention to so many lines |
| No record of reasoning | When a forecast is wrong, nobody can learn why |
| Hard conversations | Challenging the buyer's numbers feels like challenging the person |
There is also a quieter cost. Because one person can only focus on so much, the top sellers get careful attention and the long tail of slower lines gets ordered by habit.
How we turn one person's judgement into a shared forecast
- We pull your sales and stock history from your ERP, stock system or Shopify, together with price changes, promotions and stockout periods, so the model knows when low sales meant low stock rather than low demand.
- We spend time with the buyer and write down the rules she applies: seasonal patterns, customer ordering habits, products that move together, events that matter. Many of these become inputs to the model.
- We build a forecasting model per product, or per group of similar products, that predicts demand for the coming weeks with a range rather than a single number, so low-confidence forecasts are visible.
- We backtest it against the buyer's own past decisions to show where the model does well and where her judgement still adds something the data does not capture.
- We present the forecast in a simple screen or spreadsheet with a suggested order quantity, the reasons behind it, and space for the buyer or her successor to override with a note.
- We log overrides and outcomes, so over time the business learns which adjustments help and the model is retrained with that knowledge.
The goal is not to replace the buyer's judgement with a black box. It is to give her a starting point for every line, and to capture enough of what she knows that someone else can pick it up.
What changes for the team
Every product has a forecast, not just the ones the buyer has time for. When she is away, whoever covers starts from the same numbers and the same reasoning. Her adjustments are recorded with a note, which becomes a training record for whoever takes over.
And the conversation changes. Instead of "why did you order that many?", it becomes "the model suggested this, you adjusted it for that reason, and here is what happened". That is a much easier thing to learn from.
For the buyer, it usually means less time on routine lines and more on the decisions that need her experience, such as new products, big customer negotiations and supplier problems. For the business, it means succession is a hand-over rather than a leap of faith.
Is this your situation?
- One person decides what stock to order, largely from experience.
- Orders go wrong when that person is away.
- Nobody could explain the buying logic well enough to train someone else.
- You have several years of sales history in a system or spreadsheets.
- A retirement, reduction in hours or resignation is on the horizon.