language

Anaplan helped Unilever Finance team to save 30% on financial planning

Client
Unilever
Industry
FMCG
Functional area
Financial Planning & Analysis (FP&A)
Solution
Anaplan
Anaplan helped Unilever Finance team to save 30% on financial planning

“The solution has been a great success as I am able to make changes in real time while previously, we had to run a python script that took too much time. It has been a really easy, integrated process in which anyone can utilize the platform without the hassle of making human errors.”

Associate Finance Manager
01
BUSINESS CHALLENGE

Unilever USA is the biggest market for Unilever with a broad portfolio of brands across dozens of product categories and businesses such as beauty and personal care, home care, tea and many more. Managing such a complex and diverse portfolio posed a challenge during the pandemic as teams needed a flexible planning tool to enable the fastest reaction to constantly changing market signals.
The finance team, partnering with the Unilever S&OP team, was looking for a solution to streamline and accelerate their so-called Cash-up process which reconciles the volume from the Anaplan Demand Planning Module into Oracle PBCS in order to accurately reflect the financial numbers within the P&L. The difficulty was that the process was largely manual and hard to maintain and utilize which precluded the team from doing more value-adding activities like analysis and scenario planning.

Unilever USA is the biggest market for Unilever with a broad portfolio of brands across dozens of product categories and businesses such as beauty and personal care, home care, tea and many more. Managing such a complex and diverse portfolio posed a challenge during the pandemic as teams needed a flexible planning tool to enable the fastest reaction to constantly changing market signals.
The finance team, partnering with the Unilever S&OP team, was looking for a solution to streamline and accelerate their so-called Cash-up process which reconciles the volume from the Anaplan Demand Planning Module into Oracle PBCS in order to accurately reflect the financial numbers within the P&L. The difficulty was that the process was largely manual and hard to maintain and utilize which precluded the team from doing more value-adding activities like analysis and scenario planning.

02
SOLUTION

The Anaplan Connected Planning Platform was chosen to automate the cash-up process which was built on a heavy Python script and multiple Excels. The project was delivered by a blended team consisting of the Anaplan experts and business experts from Unilever which was instrumental in launching an MVP (minimum viable product) in a record time of only two months.
The main functional specifics of the tool are as follows:

  • The tool replaced the script-dependent calculation logic making it simple for any business user to maintain a newly automated process.
  • Anaplan contains 3 crucial product hierarchies at a time and 6 data sources including the plan in volumes, trade rates, price lists, etc.
  • It allows users to audit each cell of the calculation and trace down each assumption changed within the process.
  • End users can adjust the loaded data manually and add additional assumptions to the calculations whether it be adding volume, changing the volumes to get GSV (gross sales value) rates to a smaller variance or to analyze Promo Families to SKU level to ensure all has been accounted for.
  • The functionality supports analytics and decision-making for trade terms management and the yearly plan execution.

The Anaplan Connected Planning Platform was chosen to automate the cash-up process which was built on a heavy Python script and multiple Excels. The project was delivered by a blended team consisting of the Anaplan experts and business experts from Unilever which was instrumental in launching an MVP (minimum viable product) in a record time of only two months.
The main functional specifics of the tool are as follows:

  • The tool replaced the script-dependent calculation logic making it simple for any business user to maintain a newly automated process.
  • Anaplan contains 3 crucial product hierarchies at a time and 6 data sources including the plan in volumes, trade rates, price lists, etc.
  • It allows users to audit each cell of the calculation and trace down each assumption changed within the process.
  • End users can adjust the loaded data manually and add additional assumptions to the calculations whether it be adding volume, changing the volumes to get GSV (gross sales value) rates to a smaller variance or to analyze Promo Families to SKU level to ensure all has been accounted for.
  • The functionality supports analytics and decision-making for trade terms management and the yearly plan execution.
03
BUSINESS VALUE
  • The process speed was increased, reducing time between 30% to 40%.
  • A total of 3-5 hours are saved within each S&OP cycle (monthly) for each Division.
  • A number of errors and discrepancies in calculations decreased by 10% to 20%.
  • Increased transparency of calculation and ability to make scenarios in real time.
  • The process speed was increased, reducing time between 30% to 40%.
  • A total of 3-5 hours are saved within each S&OP cycle (monthly) for each Division.
  • A number of errors and discrepancies in calculations decreased by 10% to 20%.
  • Increased transparency of calculation and ability to make scenarios in real time.

GET IN TOUCH WITH US

Join us in LinkedIn

    ЕСТЬ ВОПРОС?

    Да, у меня есть вопрос!

    Имя
    Фамилия
    Страна
    Компания
    Позиция
    Email
    Телефон
    Было бы интересно узнать больше о следующем:

      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:

        FRAGE STELLEN

        Ich habe eine spezielle Frage

        Vorname
        Nachname
        Land
        Firma
        Position
        Email
        Telefon
        Es wäre interessant, mehr über die folgenden Punkte zu erfahren:

          BİR SORU SORUN

          Aklımda bir soru var

          İlk isim
          Soyadı
          Ülke
          Şirket
          Pozisyon
          Email
          Telefon
          Özellikle şunun hakkında daha fazla şey duymak istiyorum:

            НАПИСАТЬ НАМ

            Имя
            Фамилия
            Компания
            Телефон
            e-mail
            комментарий

              CONTACT US

              FIRST NAME
              LAST NAME
              COMPANY
              PHONE
              e-mail
              COMMENTS

                SCHREIB UNS

                VORNAME
                NACHNAME
                UNTERNEHMEN
                TELEFON
                e-mail
                KOMMENTAR

                  BİZE YAZIN

                  İLK ADI
                  SOY İSİM
                  ŞİRKET
                  TELEFON
                  e-mail
                  YORUM

                    ЗАПРОСИТЬ ДЕМО

                    Хотелось бы посмотреть демо

                    Имя
                    Фамилия
                    Страна
                    Компания
                    Индустрия
                    Позиция
                    Email
                    Мне было бы интересно пообщаться и увидеть быструю демонстрацию:

                      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:

                        DEMO BUCHEN

                        Ich würde gerne eine kurze Demo sehen

                        Vorname
                        Nachname
                        Land
                        Firma
                        Industrie
                        Position
                        Email
                        Ich wäre an einem Gespräch und einer kurzen Demo interessiert:

                          DEMO İSTEYİN

                          Hızlı bir demo görmek isterim

                          İlk isim
                          Soyadı
                          Ülke
                          Şirket
                          Endüstri
                          Pozisyon
                          Email
                          Sohbet etmek ve hızlı bir demo görmek isterim: