language

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

Client
Carlsberg Group
Sector
FMCG
Functional area
Purchasing planning
Platforms
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.

Carlsberg: Supply Chain Finance Director 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 ... Read more

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 ... Read more

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 ... Read more
  • 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.