What Every FMCG Supply Chain Needs Before AI

An FMCG company with 400 SKUs and distribution across 12 markets invests $800,000 in an AI demand planning platform. Eighteen months later, their stockout rate has improved from 9% to 8.5%. The platform vendor declares this a success. The supply chain director disagrees.

This story is common. The platform is not the problem - the data it was trained on is. AI demand planning models are only as good as the signals they receive. When those signals come from siloed, inconsistently formatted, partially reconciled systems, the model amplifies the noise rather than reducing it.

The industry has developed a dangerous assumption: that AI is a remedy for poor data quality. It is not. It is an amplifier. Give it clean, connected, consistent signals and it will materially improve forecast accuracy. Give it fragmented, delayed, and contradictory signals and it will confidently produce wrong forecasts - faster than any spreadsheet could.

A typical mid-size FMCG company runs 7–12 operational systems relevant to supply chain: an ERP for procurement and financials, a DMS (Distributor Management System) for secondary sales, a WMS for warehouse management, a TMS for logistics, a trade promotion management system, and various Excel files bridging the gaps between them.

Each of these systems has its own SKU master, its own customer hierarchy, and its own definition of "stock on hand." When the AI demand planning platform ingests these systems, it sees multiple versions of reality that have never been reconciled. The model has to guess which version is correct - and it cannot.

The result is demand signals that are systematically biased by whichever data source dominates the training set. If the ERP data dominates, the model ignores distributor sell-out signals. If DMS data dominates, the model misses the promotional uplifts that only appear in the trade promotion system. The model is doing its job. The data architecture is failing it.

The core issue is master data fragmentation. In most FMCG organisations, the same SKU exists under different codes in the ERP, DMS, and WMS. The same customer is recorded differently across sales, logistics, and finance. Without a unified master data layer, any cross-system analysis requires manual reconciliation - which is slow, error-prone, and impossible to automate.

Beyond master data, the timing problem compounds the quality problem. ERP data updates overnight. DMS data may be a day or two behind distributor reconciliation cycles. WMS data is often near real-time but disconnected from the financial system. When you train a demand model on data that arrives at different frequencies and different levels of completeness, the model learns the reconciliation lag, not the demand signal.

One client in the GCC was running replenishment off demand signals that had a 72-hour lag built into them - not because the systems were slow, but because the reconciliation process between DMS and ERP required human intervention three times per week. The AI model had learned to predict the reconciliation lag, not customer demand.

A data foundation for FMCG supply chain has three layers. The first is a unified master data management (MDM) layer that establishes a single, governed definition of SKU, customer, location, and supplier - and enforces it across all consuming systems. Without this, every cross-system analysis is a reconciliation exercise in disguise.

The second layer is a unified ingestion layer that pulls from ERP, DMS, WMS, TMS, and promotional systems into a single governed data platform - typically a lakehouse architecture - where data arrives with consistent schemas, timestamps, and quality markers. This is where change data capture (CDC) replaces batch exports, and data quality rules are enforced at ingestion rather than at reporting.

The third layer is a demand signal layer that aggregates sell-out data (from DMS or POS), inventory positions (from WMS), promotional calendars, and external signals (weather, seasonality, competitor activity) into a single analytical model. This is the layer where AI adds genuine value - but only when layers one and two are reliable.

The right sequence is: master data first, integration layer second, analytics and AI third. Most organisations try to reverse this - buying the AI platform first because it is visible, exciting, and easy to demonstrate to a board - and then discovering that the data foundation work was the hard part all along.

Master data rationalisation takes three to six months for a mid-size FMCG business. Integration layer build-out, depending on complexity and systems involved, takes four to eight months. AI model development, once the foundation is in place, is often the fastest phase - three to four months to a production-ready model with a meaningful reduction in forecast error.

The total timeline is 10–18 months to a genuinely functioning AI demand planning capability. The organisations that try to shortcut to the AI without the foundation spend the same time - or more - in failed implementations, re-implementations, and manual reconciliation loops that never quite close.