Home Software Development Forecasting demand at bol.com in the course of the COVID-19 pandemic | Weblog | bol.com

Forecasting demand at bol.com in the course of the COVID-19 pandemic | Weblog | bol.com

Forecasting demand at bol.com in the course of the COVID-19 pandemic | Weblog | bol.com


Bol.com is a retail platform with over 12 million prospects within the Netherlands and Belgium. To serve the wants of those prospects, it’s important that our group supplies correct forecasts to empower enterprise selections on a day after day foundation. With the outbreak of the COVID-19 pandemic, on-line purchasing behaviour went by means of a serious shift and demand for important and non-essential merchandise swiftly elevated (see cbs).

After months of scuffling with producing any cheap forecasts, we managed to design a function which is ready to describe the dynamic adjustments related to the COVID-19 pandemic. The addition of this function permits us to supply dependable forecasts within the quick time period and roll-out situation forecasting for the long run, supporting totally different domains throughout the enterprise. Our method is well interpretable and explainable to stakeholders, main to raised knowledge pushed selections.

In our forecasting panorama, we offer various kinds of gross sales forecasting, each on complete degree and likewise on product degree. These forecasts are then used on their very own for various functions throughout the organisation but additionally utilized by our group as the primary drivers for operational planning forecasting. The totally different forecasts depend on totally different time-series modelling methods, from linear fashions to gradient boosting algorithms. As such, it was essential for us to have an one-size-fits-all answer which may scale throughout the totally different modelling approaches.

We began with an in depth knowledge evaluation and studying on the data relating to COVID-19 restrictions to comprise the unfold of the virus. With this info we developed a severity index that translated the impression of the pandemic on our gross sales patterns. Our severity index ranges between 0 and 12, the place a 0 represents no COVID-19 associated restrictions and a 12 represents the tightest restrictions we encountered in the course of the pandemic. Determine 1. reveals a illustration of the COVID-19 severity index.

Figure 1.

This COVID-19 severity index is just like the publicly obtainable COVID-19 stringency index (obtainable right here). The primary distinction is that our severity index is tailor-made to the actual dynamics of the affect of the pandemic on our gross sales knowledge, which isn’t simply depending on the kind of restrictions in place. For instance, the implementation of obligatory mouth masks in public transport, or the short-term closing of bodily outlets has the next impact on our gross sales sample than what the already obtainable stringency index would recommend. Creating our severity index additionally permits us to extra simply translate the brand new info on restrictions from press-conferences right into a future trying index, which is key for forecasting. As well as, we’re capable of create higher and decrease bounds for the severity index based mostly on the earlier months knowledge and with this allow situation forecasting.

For the reason that COVID-19 severity index is only a time-series function, it’s simple to implement it throughout the totally different modelling approaches in our panorama. The outcomes of including the severity index to our fashions have been spectacular, the place we noticed as much as 40% relative enchancment on the imply absolute error of the validation interval (from March 2020 to Jan 2021). On high of that, the ahead trying forecasts additionally started to be far more in keeping with expectations, which gave our stakeholders a significant forecast accounting for the newest pandemic dynamics and because of this additionally elevated their belief in our predictions.

For long run planning, we additionally aided our stakeholders by offering totally different situation forecasts, every one based mostly on a special doable final result of the pandemic. On this course of, stakeholders may request a situation based mostly on a reference interval for which we’d then prolong the severity index utilizing the identical values of that interval and forecast the gross sales accordingly, see Determine 2.

Figure 2.

Throughout this era, we labored in even nearer collaboration with our stakeholders than earlier than, ensuring to take their skilled information under consideration to resolve on the longer term values for the severity index. The truth that the severity index is well comprehensible makes this method very clear which resulted in a swift adoption of the improved forecasts.

From provide chain to logistics operations and customer support planning, our answer to forecasting demand throughout a pandemic has allowed us to supply dependable forecasts to empower enterprise selections within the quick time period, and roll-out situation forecasting for the long run. We could not know but what the way forward for the pandemic appears like, however we at the moment are significantly better ready.

*This work was developed as a joint effort from Crew Forecasting at bol.com by Asparuh Hristov, Bjarnthor Egilsson, Cátia Silva, Erik Mulder , Eryk Lewinson, Roberto Carcangiu, Susanne Tak, Tavis Gravatt, Thijs Roukens and Wander Wadman.



  1. I am a website designer. Recently, I am designing a website template about gate.io. The boss’s requirements are very strange, which makes me very difficult. I have consulted many websites, and later I discovered your blog, which is the style I hope to need. thank you very much. Would you allow me to use your blog style as a reference? thank you!


Please enter your comment!
Please enter your name here