Planning by numbers

Enhancing a consumer goods giant’s ability to identify growth opportunities.‍

With over 3 billion people using one of their products daily, the amount of data available to analyze long-term growth projections across their product portfolio for this global consumer goods company is immense.
We created a strategy and market analysis application to help streamline the process to deliver insights that enable strategic data-driven decision-making.

pages of analysis

product categories

countries

The challenge

A multinational company selling fast-moving consumer goods in 191 countries with 400+ brands and annual revenues of more than €50 billion needed to enhance their ability to identify areas of opportunity or risk in its 5 to 10 year strategic plans in both its current and adjacent categories and markets. The existing process (using spreadsheets and presentation software to create and share the analysis with senior stakeholders) for validating its strategy and long-range planning assumptions against global growth projections across both the markets and categories it operates in, was highly manual, time-consuming, and difficult to digest.

The solution

Working with the strategy team to understand the business requirements the strategy and analysis application was configured so it provides guided analysis, answering critical business questions that support the company’s strategic decision-making.

Designed to support long-range (5-10 years) strategic analysis and planning the application included the following features:

  • A single application integrating internal and external and historical and forecast data sets.
  • Historical financial performance in the context of external economic, category and competitor data to determine relative market share.
  • A combination of historical actuals, and economic and category growth forecasts to highlight areas of opportunity and calculate implied future revenues across geographies and product lines based on defined methodologies.

Using the application, users can automatically publish 45 different pages of targeted analysis across over 100 countries segmented by region and developing vs developed markets, as well as across 15 product categories which would otherwise need to be created on a case-by-case basis using Microsoft Excel. This has not only reduced the time taken to produce the analysis, but has also delivered both an improved user and process experience for both the analyst and stakeholder.

The impact

Enables effective decision-making: utilizing intuitive analysis and visuals, emerging trends, and opportunities to enter new markets or high-growth adjacent categories are communicated, quickly and easily to senior decision-makers.

Enhanced team contribution across the enterprise: the ability to answer key strategic questions quickly and clearly enables the strategy team to support senior management in validating long-range strategy and planning assumptions, rather than spending their time creating manual analysis.

Improved stakeholder confidence and buy-in: ensuring this highly responsive analysis is based on defined calculation methodologies, empirical data and trusted third-party market forecasts significantly increases the trust that the senior team have in the insights produced.