Data and AI
With a yearly turnover of 240 mil EURO, Bakker Goedhart is by far the largest bakery in the Netherlands. Early every morning, the organization’s 300 trucks deliver approximately two million freshly baked loaves to 1,200 supermarkets.
In order to predict the consumer demand per day per retailer, Bakker Goedhart asked Xebia to develop a predictive sales planning model. This machine learning model optimizes the availability of fresh bread products while at the same time minimizing leftovers. The sales forecast enables Bakker Goedhart to produce more efficiently and plan further ahead.
- Agile development and feedback loops
- Determining and influencing demand using machine learning techniques
- Taking the artificial intelligence model into production
- Maturing the artificial intelligence model
In the past year, Bakker Goedhart started improving its ordering process with the aim of optimizing the availability of bread throughout the day. Leftover products are a major cost factor for supermarkets, Bakker Goedhart’s primary customer group.
As the leftover products can’t be sold the day after, retailers have the tendency to order less than they expect to sell. Product unavailability is a large cause of dissatisfaction amongst customers, which often goes unnoticed by the retailer. By using information technology and artificial intelligence Bakker Goedhart aims at optimizing turnover and service levels.
Producing bread on a large scale requires a flexible organization.
“Retailers tend to order their bread products just in time, and during the production process we still regularly receive changes. In the remaining production time, we need to produce the exact numbers up to our quality standards. These business dynamics require a well-developed problem-solving capacity from our staff.
Not only do we have to deal with changes in demand, fluctuations in the production process, caused by numerous factors, occur regularly as well. Short-cycled modifications and feedback loops have always been business-as-usual for us. Besides looking at the here and now, to ensure business continuity, it is crucial to look at the long-term as well.”
Determining and Influencing Demand Using Machine Learning Techniques
Early Spring 2015, Bakker Goedhart turned to Xebia asking if it was possible to predict demand for bread products at supermarkets.
Xebia started developing an artificial intelligence model that determines the ideal amount of fresh bread products per supermarket per day over a longer period by analyzing transaction details combined with external data. The model provides Bakker Goedhart with the right data to automatically produce the ideal amount of bread for every supermarket, based on demand and the specific assortment preferences of the retailer.
An additional advantage is the insight in predicted demand over longer periods of time. Once the production need is known upfront, the bakery can suggest promotion slots to retailers, and thus stimulate demand in times of overcapacity.
“The immediate and outstanding results of Xebia's sales planning model showcased the tremendous value that exists within our data. This has led to an increased awareness of the value of data within our management and the rest of our organization”, adds Boersma.
To improve data quality, Xebia implemented a data cleaning process. This process, for example, filters mistakes made at the cash register, like transactions of large amounts of bread that are flushed immediately after they have been registered. Also, the process matches retailers’ own codes with Bakker Goedhart’s product codes. After going live at one supermarket, optimizing the model lead to a decrease of sold-out products and the minimization of leftover products. As the model in first instance recognizes patterns, feedback from the retailers is crucial in training the model. By combining input from retailers and the increasing amount of data, the model’s predictions become more accurate, which in turn leads to retailers building confidence and trust in the model. Anticipation on individual customer requests will always remain important.
On a given Wednesday, a customer was not able to find her type of bread. After carefully studying the data, it turned out that this customer was the only person who bought this type of bread, and she always came in on Thursdays. Now, the supermarket manager and the customer discussed that when she plans to come to the store on a different day, she contacts the supermarket beforehand, so they can order the bread she likes so much especially for her.
Maturing the Artificial Intelligence Model
The initial results of the model are hopeful, already after the first period the model improved the availability and sales figures, without an increase in leftovers. After the first implementation, the model has been rolled out to another 25 supermarkets. In the upcoming period the goal is to connect all supermarkets nationwide. The next step is to use sales analysis to include profit margins in the model too. By using this data as a feature in the model, it will become possible to optimize the profit per retailer by steering on the availability of specific bread types.
“The immediate and outstanding results of Xebia's sales planning model showcased the tremendous value that exists within our data. This has led to an increased awareness of the value of data within our management and the rest of our organization.” - Hein Boersma, ICT Manager, Bakker Goedhart