We made a great step forward: I can now make changes in real time, whereas previously we had to manage a system consisting of many Excel files, which took up a lot of our team’s time. Now we have an easy, integrated process that holds all our reports in one place, connects all the team members and excludes human factors.
The USA is Unilever’s biggest market. They have a broad portfolio of brands across dozens of product categories and businesses, including personal care, beauty, food and much more. Managing such a complex and diverse portfolio is a challenge because of the multidimensional reporting needed for such a wide range of products.
The Supply Chain Finance team needed a technology solution to accelerate and improve the Gross Margin Variance Analysis (GMVA) process. The existing process was data management-centric and built on numerous Excel files, which greatly slowed down the team’s work and overcomplicated the analysis. Moreover, it took a lot of time to create and maintain a file for a new report every month, and to locate a specific data element to answer a particular business question.
The GMVA process on the Anaplan cloud platform is multifaceted: adjustments to the existing forecast can be made, different forecast scenarios can be created, and the actual data and forecast data can be calculated and compared using a set of different drivers. Now, Unilever is able to understand why the gross margin has changed.
As a result of the joint efforts of a blended team of experts from Planingo and Unilever, the following functional features were created: