MASTER Assignment
Improving decision making in a warehouse: data-driven forecasting and storage simulation
Type : Master M-BIT
Period: Jun, 2023 - Nov, 2023
Student : Li, J. (Jiayu, Student M-BIT)
Date Final project: November 23, 2023
Supervisors:
Abstract:
The thesis presents a data-driven solution that utilises a data warehouse and several software tools to help decision making in warehousing business. The solution consists of the forecasting service and the storage simulator service. In warehousing, forecasting is often desired to predict the daily workload to meet the demand for picking and to have an appropriate number of workers available for the day. Storage policy is a method to allocate products in different sections of the storage primarily based on their demand in order for pickers to reach these products faster. Forecasting the picking demand with higher accuracy and choosing a suitable storage policy help improve efficiency and reduce costs in warehousing operations. We illustrated how these two services are realised with an architecture based on a data warehouse. Use cases of the services were created to help warehousing managers and supervisors make improved data-driven decisions.