language

How Carlsberg automated forecasting and cost of materials analysis with Anaplan in the Eastern Europe

Client
Carlsberg Group
Industry
Manufacturing, Beverages
Functional area
Purchasing Planning
Solution
Anaplan
How Carlsberg automated forecasting and cost of materials analysis with Anaplan in the Eastern Europe

The project that we implemented jointly with the consultants was not accidentally called "Compass". The Carlsberg Group has a wide range of products, many production sites, and the cost of raw materials and packaging is an important aspect of our business. The level of uncertainty caused by external economic factors in this area is high, and to make effective decisions on the company's profitability management we needed a flexible and, at the same time, reliable tool for forecasting and analyzing the costs of raw materials and packaging. At the same time, we were interested in using a common model for the five countries of the Eastern Europe cluster, which greatly simplifies the work of regional teams in charge of finance and purchasing.

Given our previous experience with Anaplan P&L model development, we were confident that the second project with consultants would be successful too. The team exceeded our expectations, delivered the model on time, and enabled us to continue optimizing our financial support process in the countries where we operate.

Operations Function Controlling Director of Eastern Europe, Carlsberg Group
01
Business challenge

Carlsberg Group is one of the world’s leading breweries, supplying more than 100 countries worldwide. Due to the high level of volatility and influence of external factors on raw materials and packaging costs, which is a significant part of the production cost overall, the business required a reliable, fast and flexible IT solution for forecasting and analyzing the cost of materials in order to make effective decisions in managing our profitability.

Carlsberg Group is one of the world’s leading breweries, supplying more than 100 countries worldwide. Due to the high level of volatility and influence of external factors on raw materials and packaging costs, which is a significant part of the production cost overall, the business required a reliable, fast and flexible IT solution for forecasting and analyzing the cost of materials in order to make effective decisions in managing our profitability.

02
Solution

The automation of the Carlsberg’s materials forecasting and cost analysis process was implemented in five months using Anaplan, a cloud-based integrated planning platform:

  • A real-time material cost calculation tool for five countries in the Eastern Europe cluster was created, taking into account the specifics of each country;
  • A single data warehouse for five cluster countries was set up;
  • A new functionality of variance analysis calculation for all target indicators was implemented;
  • Models for calculation of forecasted purchase prices for key categories were configured;
  • The assumptions management and direct cost calculation module was configured;
  • Financial month-end closing process was automated;
  • Various reporting options as part of the targeting process were automated.

The automation of the Carlsberg’s materials forecasting and cost analysis process was implemented in five months using Anaplan, a cloud-based integrated planning platform:

  • A real-time material cost calculation tool for five countries in the Eastern Europe cluster was created, taking into account the specifics of each country;
  • A single data warehouse for five cluster countries was set up;
  • A new functionality of variance analysis calculation for all target indicators was implemented;
  • Models for calculation of forecasted purchase prices for key categories were configured;
  • The assumptions management and direct cost calculation module was configured;
  • Financial month-end closing process was automated;
  • Various reporting options as part of the targeting process were automated.
03
Business value
  • An integrated process for quarterly and annual cost planning of purchased materials was built for five countries;
  • Time for cost planning of procured materials was reduced;
  • The process became transparent to all participants;
  • Accuracy and reliability of forecasts were significantly improved;
  • Probability of errors was minimized;
  • Key drivers of changes in material costs were visualized;
  • Additional opportunities for cost optimization were identified;
  • The work of regional finance and procurement teams was significantly simplified.
  • An integrated process for quarterly and annual cost planning of purchased materials was built for five countries;
  • Time for cost planning of procured materials was reduced;
  • The process became transparent to all participants;
  • Accuracy and reliability of forecasts were significantly improved;
  • Probability of errors was minimized;
  • Key drivers of changes in material costs were visualized;
  • Additional opportunities for cost optimization were identified;
  • The work of regional finance and procurement teams was significantly simplified.

GET IN TOUCH WITH US

BOOK A DEMO
ASK A QUESTION
Join us in LinkedIn

    ASK A QUESTION

    I have a question in mind

    First Name
    Last Name
    Country
    Company
    Position
    Email
    Phone
    I'm particularly interested in hearing more about:

      CONTACT US

      FIRST NAME
      LAST NAME
      COMPANY
      PHONE
      e-mail
      COMMENTS

        BOOK A DEMO

        I'd be interested in seeing a quick demo

        First Name
        Last Name
        Country
        Company
        Industry
        Position
        Email
        I'd be interested in having a chat and seeing a quick demo: