Demand forecast models for online supermarkets

J.M. Evers, Lorant Tavasszy, Ron van Duin, Dingena Schott, Frank Gorte

Research output: Chapter in Book/Conference proceedings/Edited volumeConference contributionScientificpeer-review

1182 Downloads (Pure)

Abstract

Food waste and incomplete orders at online supermarkets mainly occur due to inaccurate demand forecasting which leads to incorrect ordering of products. The objective of this study is to develop an accurate demand forecast model at product-level based on historical customer order data, give recommendations on implementation and describe impact on logistical planning at an online supermarket in the Netherlands. The product of research in this case study was bread, because of the habitual order behaviour of customers.

It is found that, using historical customer behaviour, model accuracy can be increased by forecasting the bread order probability for every customer individually compared to a total order regression. Decision regression trees and random forest regression models are implemented to forecast product sales on short term and show high accuracy. The forecast accuracy of predicting the number of breads per day is about 99.9 percent, given the number of customers that is going to order. This implies that it is feasible to order bread directly at supplier with a significant level of reliability such that waste due to overprediction and incomplete orders due to underprediction can be reduced to acceptable levels.

The main advantages of using tree models for demand forecasting of products for an online supermarkets is the fast run time, accurate forecasts and easy interpretation. Within a few seconds, thousands of customers are analysed and conclusions can be drawn on the future demand of bread based on historical demand of each customer. Average breads per order in historical orders and number of orders are main predictors for future demand. Decision trees and random forest regression outperform linear regression in this case study.
Original languageEnglish
Title of host publicationE-groceries, digitalization and sustainability: Which governance, planning and regulation mix do our cities need?
PublisherMolde University
Pages1
Number of pages12
Publication statusPublished - 2018
EventNectar Cluster 2: E-groceries, digitalization and sustainability: Which governance, planning and regulation mix do our cities need? - Molde, Norway
Duration: 11 Oct 201812 Oct 2018

Conference

ConferenceNectar Cluster 2
Country/TerritoryNorway
CityMolde
Period11/10/1812/10/18

Fingerprint

Dive into the research topics of 'Demand forecast models for online supermarkets'. Together they form a unique fingerprint.

Cite this