Grupo Boticário has more than doubled in size over the last few years, so it has clearly been highly successful in spite of these challenges. However, this growth has also brought with it increased complexity, and to sustain expansion, it needed to continue out-pacing its competitors and delighting its consumers.
“Everything we do—from which products we choose to manufacture to how we market them—comes down to whether someone wants to buy what we’re selling,” sums up Donald Neumann. “So by getting to the bottom of what drives demand for our consumers, we can efficiently deliver the right products through the right channels at just the right times.
“But in order to build the predictive models that would help us achieve these aims, we first needed a better handle on our sales data. With so many lines of business, channels, and franchisees, collecting and consolidating this information was something that we knew we could do better.”
Finding a more sophisticated approach to forecasting
Aware that its complex business environment made demand forecasting a unique challenge, Grupo Boticário dived into a 14-month selection process for a new solution. The group narrowed down its initial list of potential solutions from seven to two, and initiated proof of concept exercises with IBM and another major vendor of integrated planning software.
“The solution we were looking for would be the first of its kind, so it was vital to us that we could prove that it would work before we made the investment,” says Donald Neumann. “We chose the IBM solution over the competing option because it was much more flexible; this was a key requirement to help us adapt the technology to our business model. Also, IBM offered us an analytics landscape that could be managed by the business, rather than IT. We wanted to give the ownership of the solution to the people who are actually using it: our analysts and line-of-business teams.”
Grupo Boticário engaged IBM Premier Business Partner CTI Global to help in building a prototype and, ultimately, rolling out the entire solution. By taking IBM® Planning Analytics (formerly known as IBM Cognos® TM1®), which provides a fast, in-memory analytics engine for financial and operational planning, and combining it with IBM SPSS® Modeler and R solutions for advanced predictive modeling, the combined project team developed a solution that solves the demand forecasting challenge.
“When you are stepping into the unknown, you need good partners, and IBM and CTI Global have certainly delivered,” recalls Donald Neumann. “CTI provided very experienced solution developers who worked seamlessly with the IBM infrastructure and software experts and a senior business and analytics team from our company to create a solution tailored to our needs.”
Using the solution, Grupo Boticário’s analysts can log into IBM Planning Analytics and view the sales and product data collected from the company’s operational systems. When they want to create a new forecast, they simply press a button to execute a forecasting stream in IBM SPSS Modeler, which is further enhanced with R scripts. Grupo Boticário uses IBM Planning Analytics to prepare the data, which is displayed online for analysts to view using their planning cockpits. Then, the prepared data flows into IBM SPSS via the company’s IBM DB2® database software. Finally, the SPSS solution creates a new model in real-time using a sophisticated custom forecasting algorithm, which the company’s data scientists have developed using the R statistical programming language, and the results are fed back into IBM Planning Analytics.
This forecast is based on modeling the combined effects of known demand drivers, such as advertising and marketing campaigns, pricing and discounts, seasonality and sales cycles, as well as market data from external sources.
Once the forecast has been loaded back into IBM Planning Analytics, the analysts can apply their own unique business knowledge to adjust the results where necessary. This enables them to take additional factors into account—for example, the impact of a completely unpredictable event such as an unexpected celebrity endorsement, which cannot be factored into the model.
Donald Neumann describes: “Our analysts now have the tools they need to isolate demand drivers and create more effective forecasts. For example, they can identify whether price discounts or channel dynamics play a bigger role in creating demand for a specific product, and they can continually adjust and refine their forecasts as new information comes in.
“We are also able to distinguish between the buying behaviors of our franchisees and our end-customers, which gives us a much clearer view of the real demand. And we can even incorporate macroeconomic indicators such as GDP forecasts to see how the wider economy is expected to affect our sales. Furthermore, the solution is IBM Watson® ready! Meaning that we can introduce Watson cognitive intelligence to the process without major changes for the business analysts.”
Fulfilling customers’ desires
Even though adoption of the new solution is still in its early stages, impressive results are already on the horizon for Grupo Boticário, putting the group in a strong position to defend and extend its market share.
“Using IBM Analytics solutions, we expect to lift the accuracy of our forecasts by 20 percent compared to traditional time-series approaches,” explains Donald Neumann. “By enabling us to align demand from end-customers and franchisees more precisely, the software will help us minimize stock-out situations without the need to inflate our inventory levels across the supply chain. The result will be higher sales and lower costs, a win-win situation that helps us stay ahead of our competitors. We can also pass on these insights to our franchisees so that the benefits ripple out across our entire supply network.”
By basing its marketing plans on a more accurate understanding of consumer demand, Grupo Boticário can achieve better results.
“The project with IBM and CTI Global has changed the relationship between our analysts and marketing teams—they are now speaking the same language,” says Donald Neumann. “We have already noticed in meetings that our analysts have started to speak about customer demand and behavior, rather than the demand and behavior of franchisees—so we’re getting much closer to the real audience we want to address.
“Through the data-driven decision-making enabled by IBM Planning Analytics, we can design marketing plans that bring more people to stores to buy our products. As a result, we will put our marketing spend to the best possible use for maximum returns.”
With a better understanding of ever-evolving consumer demand patterns, Grupo Boticário is finding the recipe for prolonged success: fulfilling the desires that consumers don’t even know they have.
Donald Neumann concludes: “Cosmetics and fragrance purchasing is highly emotional, and IBM Analytics solutions are helping us understand the myriad factors that make consumers choose one product over another. By putting these insights to work, we can ensure that we are the ones bringing beauty to buyers’ lives, rather than our competitors.”