Most fast-moving consumer goods companies can present a strong suite of planning deliverables, including annual operating plans, demand forecasts, financial outlooks and category strategies. Yet when one looks behind the slides, something worrying often appears.

The revenue plan uses one customer hierarchy, the demand plan uses another, and the trade promotion system uses a third. Finance has its own chart of accounts and product groupings. Sustainability teams are working with different product and supplier definitions for packaging, emissions and waste reporting. Manufacturing plants and distribution centres sit in spreadsheets that do not match what appears in the enterprise resource planning system.

When master data is inconsistent in this way, planning outputs may look aligned at a high level, but the underlying numbers and assumptions differ. Meetings are spent arguing over whose data is “right” rather than deciding what to do. Scenario models take weeks to assemble and are hard to repeat. Root-cause analysis of performance issues is slow because data does not line up across functions.

By contrast, when there is a single, trusted master data backbone, integrated business planning becomes both faster and more reliable. Commercial, supply chain, finance and sustainability decisions can be connected through shared definitions of products, customers, suppliers, locations and organisational structures. The result is less friction, more credible plans and a far tighter link between strategy and daily execution.

1) Why integrated business planning matters in fast-moving consumer goods

Integrated business planning is about more than scheduling a monthly meeting. For fast-moving consumer goods businesses, it is the mechanism that converts strategy into coordinated action across categories, channels and regions.

Retailers expect suppliers to respond rapidly to shifts in demand, promotional opportunities and on-shelf performance. Consumers change preferences quickly, especially around health, sustainability and value. Input costs and currency rates can move sharply. In this context, decisions made by one function are never isolated. A promotional deal agreed by sales affects demand planning, production runs, logistics capacity, working capital and, increasingly, emissions profiles.

Properly implemented, integrated business planning connects these decisions through a single set of numbers and assumptions. It allows executive teams to answer questions such as:

• What happens to margin and cash flow if we increase the promotion depth on a key pack in modern trade?
• How will a packaging change affect unit costs, carbon footprint and retailer compliance?
• Which customers, products and channels are driving forecast error and service challenges?

However, all of this depends on the underlying data being structurally aligned. If customers, products and locations are defined differently in each system feeding the planning process, any attempt at integration becomes fragile. Master data is therefore not a technical detail; it is the structural skeleton of integrated business planning.

2) What master data really means in this context

Master data is often misunderstood as simply “lists kept in the system”. In a fast-moving consumer goods setting, it is far more strategic.

At its core, master data encompasses the key entities the business uses to describe and run itself:

• Products and packs – with attributes such as brand, sub-brand, flavour, size, packaging type, returnable or non-returnable, shelf-life and regulatory information.
• Customers and channels – from global key accounts and wholesalers to informal traders and e-commerce partners, including hierarchies, banners and segments.
• Suppliers – with source locations, risk ratings, sustainability metrics and commercial terms.
• Locations – plants, warehouses, distribution centres, depots and markets, with consistent addressing and routing information.
• Organisational structures – business units, categories, regions and profit centres.

Master data defines how these entities relate to each other: which products belong to which brand and category, which customers sit under which retailer or channel, which suppliers serve which plants, and how all of this rolls up into group reporting. It also embeds business rules such as pricing logic, pack substitution, customer eligibility, tax treatment and sustainability tags.

When master data is coherent and well-governed, every planning and analytic process can draw on the same shared definitions, regardless of the technology being used. When it is fragmented or duplicated, the business is effectively running multiple versions of itself in parallel.

3) Common data fractures that undermine planning

Executives who sense that planning is more complex than it should be are often dealing with hidden fractures in master data. Some of the most common include:

• Multiple product hierarchies that cannot be reconciled quickly. Marketing, sales, finance and manufacturing often build their own views of categories and brands. These may all be valid, but are rarely linked through a standard reference structure.
• Customer records that differ by system. The same retailer may appear under different names, identifiers, and hierarchies across trade promotion, order management, and finance. When this happens, it is challenging to see the true profitability or service performance of that customer.
• Proliferation of local codes and descriptions. Plants, depots and sales offices often create local product or customer codes in spreadsheets or legacy systems, then manually map them to central codes for reporting. Over time, these mappings become complex and brittle.
• Missing or inconsistent attributes. Key data such as pack size, unit of measure, tax status, brand family, carbon footprint or allergen information may be incomplete or held in unstructured documents.
• Unclear ownership and governance. No one is accountable for approving changes, resolving duplicates or ensuring that new products, customers or suppliers are set up correctly across systems.

These fractures create tangible planning, execution and performance issues across the business. Stale or misclassified data skew forecasting models. Trade promotion analyses show different results depending on which system is used. Finance cannot reconcile volume, revenue and margin at the level needed to make precise decisions. Sustainability teams cannot reliably trace the impact of packaging and sourcing decisions across the value chain.

Integrated business planning surfaces these issues because it attempts to connect the dots. Master data is the way to fix the underlying structure rather than repeatedly patching outputs.

4) Connecting commercial, supply chain and finance through shared master data

The true power of master data lies in its ability to connect functions. Consider three core pillars of a fast-moving consumer goods business: commercial, supply chain and finance.

• Commercial teams think in terms of categories, brands, channels and customers. They design promotional calendars, negotiate terms and plan innovation.
• Supply chain teams think in terms of materials, plants, production lines, warehouses, routes and service levels. They balance capacity, inventory and logistics.
• Finance teams think in terms of revenue, margin, cost centres, profit centres and working capital. They translate operational decisions into financial outcomes.

Without a shared master data backbone, each pillar builds its own picture of the business. When plans are brought together, reconciling them is laborious. When things go wrong, finding the root cause involves multiple rounds of matching, reclassification and debate.

With a unified master data foundation, the story changes. The same product, pack and customer definitions flow through commercial planning, demand forecasting, production scheduling, procurement and financial reporting. Assumptions applied in one area are visible and traceable in others.

For example, a new pack introduced to serve an emerging value segment can be tracked consistently from commercial rationale through manufacturing impact to customer performance and profitability. Master data makes these connections possible without constant manual intervention.

5) Demand planning that trusts its own numbers

Demand planning is often the most visible test of whether master data is under control. Forecasts that appear accurate at the aggregate level can conceal significant errors at the level where decisions are actually made: by product, pack, channel and customer.

When product and customer master data is inconsistent:

• Historical sales patterns do not line up with current hierarchies, breaking statistical models.
• Promotions cannot be appropriately tagged and normalised, making uplift estimates unreliable.
• Volume is double-counted or omitted when customers or products have duplicates across systems.
• Demand signals from e-commerce, wholesale and informal channels are hard to merge.

A robust master data backbone allows demand planners to work with clean, reconciled views of history and forward plans. New products are linked correctly to predecessors. Product and customer hierarchies are stable but adaptable so that segmentation changes can be managed deliberately rather than through ad hoc manual work.

This has two major benefits. First, forecast accuracy improves because models are trained on trustworthy data. Second, the organisation starts to believe the numbers. When sales, supply chain and finance can all see the lineage of a forecast from raw data through to planning outputs, discussions move from debating basic facts to exploring intelligent scenarios.

6) Trade promotion and revenue growth management built on solid master data

Trade promotion and broader revenue growth management are heavy users of master data, even though they are sometimes treated as separate domains.

Promotions need to be associated with:

• The correct product and pack combinations, including variants and substitutes.
• The right customer entities and hierarchies, including multi-banner retailers and independent outlets.
• The correct time periods, territories and execution constraints.

If master data is weak, promotions are inconsistently set up. Some are tagged at too granular a level, others at too broad a level, and many are missing data entirely. Analysis of promotion effectiveness then becomes unreliable: uplift calculations differ across systems; it is unclear whether volume spikes are due to promotions, price changes, or distribution gains; and the same promotion may be counted differently across reports.

A strong master data backbone enables consistent identification of promotions, price changes and assortment moves across customers and channels. This makes it possible to answer strategic questions such as:

• Which combinations of pack, price point and mechanic drive profitable growth by channel?
• Where are we over-investing in promotions that generate volume but destroy value?
• How can we harmonise conditions across customers without losing the ability to tailor?

For executives, this is not just about sharper analysis. It is about negotiating power. When a fast-moving consumer goods company walks into a joint business planning session with a retailer and can present clean, evidence-based views of what actually happened by promotion, customer and pack, the discussion is very different.

7) Synchronising supply, manufacturing and procurement decisions

On the operations side, master data serves as the bridge between commercial intent and physical execution. Plants, warehouses, distribution centres, materials, bills of material, and routings all depend on consistent, accurate master data.

When master data is fragmented, several issues arise:

• Production plans do not align with real demand because product variants are mis-mapped or missing.
• Bills of material contain outdated or incorrect components, complicating cost and sustainability calculations.
• Route-to-market decisions are made without a clear view of the interplay between plant, warehouse and customer locations.
• Procurement cannot consolidate volumes or risks across suppliers because materials and vendors are not harmonised.

A unified master data backbone allows operations teams to simulate and execute changes with confidence. For example:

• A decision to shift volume from one plant to another can be modelled using consistent product and location data, showing the impact on cost, service and emissions.
• Sourcing changes can be assessed by linking supplier attributes to products, materials and markets.
• Inventory policies can be designed based on a single view of stock and lead times across the network.

This level of synchronisation is fundamental when companies pursue initiatives such as near-shoring, network redesign or plant specialisation. Without strong master data, these transformations become risky and slow; with it, they become repeatable and scalable.

8) Linking sustainability and compliance data into planning

Sustainability and regulatory compliance have become central to strategy in the fast-moving consumer goods sector. Packaging choices, ingredient sourcing, transport modes and waste management all influence both brand equity and licence to operate.

Yet sustainability teams are often forced to operate with their own data structures because core master data is not designed to carry environmental and social attributes. For example:

• Packaging material types and recyclability are captured in technical documents but not in structured product attributes.
• Supplier emissions and labour practices are stored in separate systems that are not linked to mainstream procurement and planning.
• Route-to-market emissions are estimated at the aggregate level rather than by product, customer and lane.

By extending master data to include sustainability attributes, businesses can integrate environmental and social considerations into day-to-day planning. This enables:

• Scenario analysis that compares not only cost and service but also carbon and waste impact.
• Product and packaging decisions that are traceable back to source materials and suppliers.
• Retailer collaborations that are grounded in robust, auditable data rather than estimates.

In other words, sustainability stops being an after-the-fact report and becomes part of the integrated planning conversation. Master data is what makes that shift possible.

9) Enabling scenario modelling and decision intelligence

Executive teams increasingly want to move beyond single-number plans towards richer scenario analysis. Questions such as “What if a major retailer changes listing fees?”, “What if we rebase our portfolio towards value packs?” or “What if we accelerate reformulation to healthier options?” require accurately consolidated data.

Decision intelligence combines advanced analytics, artificial intelligence and human expertise to support such questions at scale. However, its effectiveness is limited by the quality and consistency of the underlying master data.

When master data is well-structured:

• Analytical models can be applied consistently across products, customers and regions.
• Scenario simulations can be repeated and refined because the inputs are standardised.
• Insights can be translated back into operational actions without losing traceability.

For example, a decision intelligence model might identify that certain product and channel combinations in a specific market deliver a strong margin but are constrained by distribution. Acting on this insight requires reliable mapping between product, customer, route and cost data. If that mapping does not exist, the model remains an interesting slide rather than a practical guide.

Emergent Africa’s own work in decision intelligence repeatedly shows that master data is the accelerator, or brake, on these advanced capabilities. Companies that invest in their master data backbone can use decision intelligence to challenge assumptions, test strategies, and institutionalise learning, not just to produce clever dashboards.

10) Master Data Management as a Service: a pragmatic route for FMCG

Building and sustaining a robust master data backbone can feel daunting, particularly for organisations that have grown through acquisitions or operate across many markets. Traditional programmes offer to “fix everything” but can become lengthy, technology-heavy and disconnected from day-to-day planning realities.

Master Data Management as a Service provides a more pragmatic route. Rather than treating master data as a one-off project, it is approached as an ongoing managed capability that combines:

• Proven technology platforms hosted and operated by specialists.
• Data governance processes, workflows and quality rules tailored to the business.
• A multidisciplinary team that understands both fast-moving consumer goods operations and data management.
• Clear service levels for the timeliness, completeness and accuracy of master data domains.

For executives, this model has several advantages. It lowers the barrier to entry by avoiding large up-front infrastructure investments. It accelerates time-to-value by enabling initial domains – such as product and customer – to be brought under control quickly. It also provides a predictable operating cost for keeping master data current, rather than relying on sporadic clean-up efforts.

Most importantly, it aligns master data work with business outcomes. The service can be structured around the needs of integrated business planning cycles: which entities and attributes must be reliable, by when, and for which decisions. Emergent Africa’s approach, for example, starts by mapping master data requirements to specific planning processes and performance questions, so that value is visible early and often.

11) Governance, ownership and operating model

Technology and services alone are not enough. A master data backbone only remains strong if governance and ownership are transparent.

Key principles include:

• Business ownership, supported by specialist expertise. Master data exists to serve business decisions. Ownership should therefore sit with business leaders who understand the implications of definitions and hierarchies, supported by data management professionals.
• Clear roles and responsibilities. Data owners, stewards, approvers and users need defined responsibilities for each domain. This includes who can request changes, who approves them and who monitors quality.
• Standardised processes for data change. New products, customers and suppliers should follow structured workflows, with validation against business rules and avoidance of duplicates.
• Data quality metrics linked to planning performance. Rather than measuring quality in abstract terms, track its impact on forecast accuracy, service levels, margin analysis and decision lead times.
• Training and culture. Commercial, operations, finance and sustainability teams should understand why master data matters and how their actions affect it.

In many organisations, these elements are partially in place but scattered. A service-based model can help by providing a coherent operating framework, while still respecting local nuances. The goal is not rigid centralisation, but disciplined flexibility built on a shared backbone.

12) A practical roadmap for FMCG leaders

Executives do not need another theoretical framework. They need a practical path that connects master data improvements to tangible business outcomes. A phased roadmap might look like this:

1. Frame the business case in planning terms. Start by identifying where integrated business planning is currently fragile: forecast disputes, promotion analysis that no one trusts, sustainability commitments that are hard to quantify, and slow reactions to retailer demands. Quantify the impact on margin, working capital and service.

2. Map critical master data dependencies. For the most crucial planning processes, document which master data domains and attributes they rely on. Focus on products, customers, suppliers, locations and hierarchies, as well as sustainability attributes where relevant.

3. Assess current state and risks. Evaluate the level of duplication, inconsistency and missing data. Identify where local codes, shadow spreadsheets and manual reconciliations are doing the heavy lifting.

4. Design the target master data model and governance. Define standard entities, hierarchies, attributes and relationships, with clear ownership and approval mechanisms. Ensure the design supports both current planning needs and anticipated future scenarios.

5. Implement Master Data Management as a Service for priority domains. Rather than waiting for perfection, bring high-value domains into a managed service quickly. Establish quality rules, workflows and integration points with planning systems.

6. Align integrated business planning processes around the new backbone. Update planning calendars, meeting agendas, and decision rights to ensure the latest master data foundation is used consistently. This may include revising how forecasts are created, how promotions are set up and how scenarios are modelled.

7. Measure impact and refine. Track improvements in forecast accuracy, promotion evaluation, time to produce scenarios, and confidence in planning numbers. Use these results to refine the master data model and extend it to additional domains.

8. Embed decision intelligence. Once the backbone is stable, layer on advanced analytics and decision intelligence capabilities that exploit the integrated data. Focus initially on a handful of high-impact use cases and expand from there.

This roadmap does not require a disruptive big-bang transformation. It requires clarity of intent, the right partners and a disciplined focus on linking master data to integrated business planning outcomes.

Conclusion: From fragmented views to a single planning backbone

Fast-moving consumer goods companies operate under intense pressure. Retailer demands are growing, consumers are more discerning, supply chains are under strain and sustainability expectations are rising. In this environment, integrated business planning is not optional; it is the mechanism that keeps strategy, execution and performance aligned.

Yet integrated planning cannot succeed if the business is running on fragmented master data. Without a single, trusted backbone for products, customers, suppliers, locations and hierarchies, every planning cycle sits on shifting sand. Executives may feel they are making informed decisions, but the numbers beneath them often tell a conflicting story.

Treating master data as a strategic asset, and investing in robust, service-based Master Data Management, changes this picture. Commercial, supply chain, finance and sustainability teams can finally work from the same version of the truth. Scenario modelling and decision intelligence can move from theoretical capability to daily practice. Retailers and other partners experience the business as coherent and reliable, not fragmented and reactive.

For leaders, the question is no longer whether master data matters. The real question is how quickly the organisation can turn it into a competitive advantage and make it the backbone of integrated business planning.