Back to Blog
AI & Technology 5 min read

Reorder Prediction: What a Forecasting Model Needs That a Rule Doesn’t

Everyone wants a model that predicts what a retailer will order next. Almost nobody has the data it would need to be right.

FlowKartAI Team · Editorial
Published 6 August 2026
Demand Forecasting Reorder Point Inventory Planning FMCG India

The rule that already works for most SKUs

A reorder point needs three numbers: average daily demand, supplier lead time, and a safety buffer for the days demand runs above average or the supplier runs late. Multiply, add, done — the full mechanics are in reorder point and safety stock in practice, and the Reorder Point Calculator does the arithmetic in seconds.

For a SKU that sells a fairly steady quantity every cycle — the biscuit that moves the same dozen cartons a week, rain or shine — this rule is not a stopgap until you afford a model. It is the correct tool, permanently. It is auditable by anyone in the office, it degrades gracefully when an input is slightly wrong, and it costs nothing beyond the inventory turnover discipline you should have anyway.

The question worth asking before reaching for a forecasting model is not "would a model help" — a model can always fit something to historical data. The question is whether this SKU has a genuine pattern worth learning, or whether it is noise that a rule already handles at a fraction of the cost.

What "genuine pattern" actually means

A pattern a model can learn needs two things: a repeated signal, and enough history across that signal to separate it from noise.

A repeated signal means demand moves with something you can name and measure — a festival calendar, a scheme period, a price change, a competitor's stockout. "Demand is unpredictable" is usually not a statement about the world; it is a statement that nobody logged the events that explain the swings.

Enough history means several cycles of that signal, not one. A single Diwali spike is an anecdote. Three Diwalis with the scheme dates, competitor activity and weather noted alongside the sales numbers is a dataset.

Most distributors have neither, not because the business lacks pattern, but because nobody wrote down the why next to the what. Sell-in data — what left your warehouse — exists in every billing system. Sell-out data — what the retailer actually sold to the end consumer — almost never does, and it is sell-out that a forecasting model actually needs to learn real demand rather than your own dispatch habits.

A worked comparison

Numbers to re-run with your own, not a benchmark.

Take a SKU selling roughly 120 units a day with a 5-day supplier lead time and a 200-unit safety stock — the exact inputs the Reorder Point Calculator takes. The reorder point rule says: reorder when stock hits 800 units (120 × 5 + 200). It will be right most weeks, and wrong in a small, bounded way around genuine demand shifts — which is exactly what the safety stock exists to absorb.

Now take the same SKU during a two-week scheme period where volume typically doubles. The rule alone will under-order, because it has no way to know a scheme is running. A model could catch this — but only if scheme start and end dates were logged against past sales as a labelled event. Without that log, a model trained on the same order history the rule already uses will not outperform the rule; it will just add a training and maintenance cost on top of arithmetic that already worked.

SituationRight toolWhy
Steady-selling SKU, no scheme calendarReorder point ruleLow variation, nothing for a model to learn beyond the average
SKU with a real seasonal pattern, events loggedForecasting modelRepeated, measurable signal across several cycles
SKU with real swings, but no event logNeither, yetThe data a model needs does not exist — logging is the actual first project
New SKU, under 3 months of historyReorder point ruleNo model earns its cost on a few weeks of data

The sequencing that actually pays off

The temptation is to buy a forecasting tool before the reorder point discipline is even in place everywhere. That inverts the order that pays off.

  1. 1.Get every SKU onto a reorder point rule first. This alone removes most stockouts and most emergency orders, and it is the baseline a model would have to beat to be worth its cost.
  2. 2.Start logging the events, not just the sales. Scheme start/end dates, festival windows, price changes, competitor stockouts you hear about on the beat — against the SKUs they affect.
  3. 3.After a few cycles, look at variation by SKU. The ones with real swings tied to logged events are candidates for forecasting. The ones that are just noisy are usually a data-entry problem, not a demand problem.
  4. 4.Model the handful of SKUs where it earns its cost, not the whole catalogue. Most distribution catalogues have a small number of high-volume, high-variation lines and a long tail of steady ones — the tail should stay on the rule indefinitely.

This is the same sequencing argument made about AI generally in AI in B2B distribution: capture clean data first, automate the deterministic parts, and reserve the model for the place where variation is genuinely unbounded and the data to learn from actually exists.

The honest test before buying a forecasting tool

Three questions, and if the answer to any of them is no, a reorder point rule is still the right tool for that SKU.

Can you point to the events that would explain the demand swings? Not "it varies" — the specific dates and reasons. If you cannot name them, a model has nothing to learn from and will fit noise.

Do you have several cycles of that event, not one? One Diwali is a story. Three, with numbers, is a pattern.

Is the SKU's volume high enough that getting it wrong matters? Forecasting a slow-moving SKU more precisely saves very little. The working capital tied up in over-ordering scales with volume — model where the volume is.

FAQ

The questions that come up before a distributor buys a forecasting tool.

Do I need a forecasting model to avoid stockouts?+

No. A reorder point rule — average daily demand, lead time and a safety buffer — handles the common case using arithmetic, not a model, and it is auditable by anyone in the office. A forecasting model earns its cost on top of that rule, for SKUs where demand genuinely varies with a signal you can measure, like a festival calendar or a scheme period.

What data does demand forecasting actually require?+

Clean sell-out by SKU by outlet, over enough cycles to show a pattern, plus the events that explain the variation — schemes running, festivals, a competitor stockout, a price change. Most distributors have sell-in data (what left the warehouse) but not sell-out (what the retailer actually sold), and a model trained on sell-in alone learns your dispatch habits, not real demand.

How do I know if a SKU is worth forecasting rather than just reordering on a rule?+

Look at the coefficient of variation in its order history — a SKU that sells a steady quantity every cycle gains almost nothing from a model, while one that swings hard around festivals or schemes has a real pattern for a model to learn, provided you have logged the events that drive the swing. If demand looks like noise with no explanatory event behind it, a model will fit the noise, not the reason.

FlowKartAI Team
Editorial

The FlowKartAI team builds WhatsApp-native ordering for Indian B2B distributors and the kirana stores they serve. We write about distribution economics, GST compliance, and the practical side of putting AI in front of retailers who have never opened an app.

Free tools for this

🤖

Ready to Automate Your WhatsApp Orders?

FlowKartAI parses natural language WhatsApp messages into ERP-ready orders in seconds.

Try Free Demo

Related Articles