A forecast that can't explain itself isn't a forecast, it's a guess with a chart

FMCG operators build demand forecasts by combining data that comes from genuinely different worlds: point-of-sale figures from modern trade, informal estimates from traditional trade outlets that don't have electronic registers, promotional calendars, and advertising spend data. Each of these has different reliability, different collection lag, and different failure modes. A forecasting model that blends them into a single number without preserving which inputs drove that number is producing an output nobody in the business can actually interrogate when the forecast turns out to be wrong.

That's the recurring failure: not that the forecast missed, but that when it missed, nobody could reconstruct why quickly enough to correct course before the next planning cycle.

Where the traceability breaks down

Traditional trade data is usually the weakest link and the least examined one. It's frequently built on field agent estimates, informal retailer surveys, or extrapolation from a sample — reasonable as a methodology, but only if the model downstream knows it's working with an estimate rather than a measurement and weights it accordingly. Treating traditional trade figures with the same confidence as modern trade point-of-sale data is a common, quiet source of forecast error that never gets diagnosed because the blend obscures which side of the model actually failed.

Promotional and advertising data adds a second layer of ambiguity: a promotion's effect on demand is inferred, not measured directly, and that inference depends on assumptions about baseline demand that are rarely documented anywhere the forecasting team can revisit later.

What a traceable forecast actually requires

Building a forecast a business can trust means preserving the lineage of every input all the way through the blend: traditional trade estimates tagged as estimates, with their collection methodology documented; modern trade figures tagged as measured, with their own lag and reconciliation process; and promotional effects tagged as inferred, with the baseline assumption stated explicitly rather than buried in a model parameter nobody remembers setting. When the forecast misses, this is what lets a team locate the miss in minutes instead of re-running an investigation from scratch.

Why this matters more as more players enter African FMCG markets

New entrants and existing operators alike are making market entry and expansion decisions based on these forecasts — where to place inventory, which channels to invest promotional spend in, which markets show real demand versus estimated demand that hasn't been tested. A forecast built on an untraceable blend gives false confidence to exactly the decisions that carry the most capital risk. A forecast built with preserved lineage gives a business the ability to trust the number for the decisions that matter, and to know quickly when it shouldn't.

The technical difference between these two forecasts is often small — the same data, modeled with attention to what each input actually is rather than treating everything as equally solid. The business difference is whether a bad forecast costs a quarter of wasted inventory or gets caught and corrected before it does.