language

How Anaplan helped to set up a truly Integrated business planning process for beverages company

Client
Alcoholic beverages distributor
Industry
Beverages, Distribution and Logistics
Functional area
Financial Planning & Analysis (FP&A), Sales and Operations Planning (S&OP), Promo Planning, Integrated Business Planning (IBP)
Solution
Anaplan
How Anaplan helped to set up a truly Integrated business planning process for beverages company

“The key to the success of a business automation project is to maximize business participation with a minimal IT involvement. Anaplan brings this formula to perfection.”

CIO
01
BUSINESS CHALLENGE

One of the largest alcohol company and vodka producer in Central and Eastern Europe made their financial and operational planning in Excel© which led to wasted time and significant labor costs. A “what-if analysis” of various functional blocks was carried out using multiple poorly connected spreadsheets which did not allow for synchronization and simultaneous user work in real time.

One of the largest alcohol company and vodka producer in Central and Eastern Europe made their financial and operational planning in Excel© which led to wasted time and significant labor costs. A “what-if analysis” of various functional blocks was carried out using multiple poorly connected spreadsheets which did not allow for synchronization and simultaneous user work in real time.

02
SOLUTION

The implementation of Anaplan streamlined planning of product sales with the subsequent calculation of production volumes, cost of goods sold (COGS) and distribution of total costs down to the level of SKU and customer.

The process of integrated scenario planning of various functional units within a single model was introduced: sales, promo, COGS, logistics, OPEX.

Currently, Planingo (as part of the roadmap for developing an already launched solution) is implementing an automation of demand forecasting and Trade promo planning in Anaplan. The goal of the project is to link Sales and Promo planning with the existing financial model and thereby accommodate a comprehensive automation of the Sales & Operations planning (S&OP) process on a single platform.

As part of the ongoing project, individual customer forecasting models, regional planning, an integrated solution for collecting inputs from all process participants (brand marketing, trade marketing, sales department, finance), online P&L recalculation, scenario planning will be brought to life.

The company s commercial team will receive an effective tool for demand planning and promo activities, and the Financial team will be able to work quickly with P&L in any necessary detail (up to the client, SKU) with a set of scenario components for each of the articles. An emphasis will be given to analyzing the effect of promo activities (Trade spend), ultimately deriving data from the price on the shelf to Net contribution of brand / counterpart.

The implementation of Anaplan streamlined planning of product sales with the subsequent calculation of production volumes, cost of goods sold (COGS) and distribution of total costs down to the level of SKU and customer.

The process of integrated scenario planning of various functional units within a single model was introduced: sales, promo, COGS, logistics, OPEX.

Currently, Planingo (as part of the roadmap for developing an already launched solution) is implementing an automation of demand forecasting and Trade promo planning in Anaplan. The goal of the project is to link Sales and Promo planning with the existing financial model and thereby accommodate a comprehensive automation of the Sales & Operations planning (S&OP) process on a single platform.

As part of the ongoing project, individual customer forecasting models, regional planning, an integrated solution for collecting inputs from all process participants (brand marketing, trade marketing, sales department, finance), online P&L recalculation, scenario planning will be brought to life.

The company s commercial team will receive an effective tool for demand planning and promo activities, and the Financial team will be able to work quickly with P&L in any necessary detail (up to the client, SKU) with a set of scenario components for each of the articles. An emphasis will be given to analyzing the effect of promo activities (Trade spend), ultimately deriving data from the price on the shelf to Net contribution of brand / counterpart.

03
BUSINESS VALUE
  • A significant increase in the speed of budget preparation, an increase of accuracy and a reduced number of errors.
  • Multi-scenario planning capability. The preparation period of each budget scenario / version has been reduced from 2 weeks to 2-4 hours.
  • As a result of the project, the company receives the budget at the most detailed level on real time basis, with the possibility to carry out flexible what-if analyses as well as viewing the causes of deviations at the level of the entire planning contour.
  • A significant increase in the speed of budget preparation, an increase of accuracy and a reduced number of errors.
  • Multi-scenario planning capability. The preparation period of each budget scenario / version has been reduced from 2 weeks to 2-4 hours.
  • As a result of the project, the company receives the budget at the most detailed level on real time basis, with the possibility to carry out flexible what-if analyses as well as viewing the causes of deviations at the level of the entire planning contour.

GET IN TOUCH WITH US

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: