Abstract
Our paper attempts to improve the order distribution for a logistics service provider who accepts order from retailers for fast moving consumer goods. Due to the fluctuations in orders on a day to day basis, the logistics provider will need the maximum number of trucks to cater for the maximum order day, resulting in idle trucks on other days. By performing data analysis of the orders from the retailers, the inventory ordering policy of these retailers can be inferred and new order intervals proposed to smooth out the number of orders, so as to reduce the total number of trucks needed. An average of 20 % reduction of the total number of trips made can be achieved. Complementing the proposed order intervals, the corresponding new proposed order size is computed using moving average from historical order sizes, and shown to satisfy the retailers’ capacity constraints within reasonable limits. We have successfully demonstrated how insights can be obtained and new solutions can be proposed by integrating data analytics with decision analytics, to reduce distribution cost for a logistics company.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Cheng, T. C. E., & Wu, Y. N. (2005). The impact of information sharing in a two-level supply chain with multiple retailers. The Journal of the Operational Research Society, 56(10), 1159–1165.
Gaur, V., Giloni, A., & Seshadri, S. (2005). Information sharing in a supply chain under ARMA demand. Management Science, 51(6), 961–969.
Hausman, W. H., & Sides, R. S. G. (1973). Mail-order demands for style goods: Theory and data analysis. Management Science, 20(2, Application Series), 191–202.
Johnston, F. R., Boylan, J. E., & Shale, E. A. (2003). An examination of the size of orders from customers, their characterisation and the implications for inventory control of slow moving items. The Journal of the Operational Research Society, 54(8), 833–837.
Lee, H. L., So, K. C., & Tang, C. S. (2000). The value of information sharing in a two-level supply chain. Management Science, 46(5), 626–643.
Raghunathan, S. (2001). Information sharing in a supply chain: A note on its value when demand is nonstationary. Management Science, 47(4), 605–610.
Steckel, J. H., Gupta, S., & Banerji, A. (2004). Supply chain decision making: Will shorter cycle times and shared point-of-sale information necessarily help? Management Science, 50(4), 458–464, Special issue on marketing and operations management interfaces and coordination.
Williams, B. D., & Waller, M. A. (2010). Creating order forecasts: Point-of-sale or order history? Journal of Business Logistics, 31(2), 231–251.
Yu, C. Z., Yan, H., & Cheng, T. C. E. (2002). Modelling the benefits of information sharing-based partnerships in a two-level supply. The Journal of the Operational Research Society, 53(4), 436–446.
Author information
Authors and Affiliations
Corresponding authors
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2015 Springer International Publishing Switzerland
About this chapter
Cite this chapter
Cheong, M.L.F., Choy, M. (2015). Data Analysis of Retailer Orders to Improve Order Distribution. In: Iyer, L.S., Power, D.J. (eds) Reshaping Society through Analytics, Collaboration, and Decision Support. Annals of Information Systems, vol 18. Springer, Cham. https://doi.org/10.1007/978-3-319-11575-7_15
Download citation
DOI: https://doi.org/10.1007/978-3-319-11575-7_15
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-11574-0
Online ISBN: 978-3-319-11575-7
eBook Packages: Business and EconomicsBusiness and Management (R0)