IDEAS home Printed from https://ideas.repec.org/a/eee/ejores/v269y2018i3p860-869.html
   My bibliography  Save this article

A greedy aggregation–decomposition method for intermittent demand forecasting in fashion retailing

Author

Listed:
  • Li, Chongshou
  • Lim, Andrew

Abstract

In this study, we solve a real-world intermittent demand forecasting problem for a fashion retailer in Singapore, where it has been operating retail stores and a warehouse for several decades. The demand for each stock keeping unit (SKU) at each store on each day needs to be determined to develop an effective and efficient inventory and logistics system for the retailer. The SKU-store-day demand is highly intermittent. In order to solve this challenging intermittent demand forecasting problem, we propose a greedy aggregation–decomposition method. It involves a new hierarchical forecasting structure and utilizes both aggregate and disaggregate forecasts, which differs from the classical bottom-up and top-down approach. The method is investigated on the real-world SKU-store-day demand database from this retailer in Singapore, and significantly outperforms other widely used intermittent demand forecasting methods. The proposed method also serves as a general self-improvement procedure for any intermittent time series forecasting method taking dual source of variations into account. Moreover, we introduce a revised mean absolute scaled error (RMASE) as a new accuracy measure for intermittent demand forecasting. It is a relative error measure, scale-independent, and compares with the error of zero forecasts.

Suggested Citation

  • Li, Chongshou & Lim, Andrew, 2018. "A greedy aggregation–decomposition method for intermittent demand forecasting in fashion retailing," European Journal of Operational Research, Elsevier, vol. 269(3), pages 860-869.
  • Handle: RePEc:eee:ejores:v:269:y:2018:i:3:p:860-869
    DOI: 10.1016/j.ejor.2018.02.029
    as

    Download full text from publisher

    File URL: http://www.sciencedirect.com/science/article/pii/S0377221718301449
    Download Restriction: Full text for ScienceDirect subscribers only

    File URL: https://libkey.io/10.1016/j.ejor.2018.02.029?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. Boylan, J.E. & Syntetos, A.A., 2007. "The accuracy of a Modified Croston procedure," International Journal of Production Economics, Elsevier, vol. 107(2), pages 511-517, June.
    2. Snyder, Ralph, 2002. "Forecasting sales of slow and fast moving inventories," European Journal of Operational Research, Elsevier, vol. 140(3), pages 684-699, August.
    3. Petropoulos, Fotios & Kourentzes, Nikolaos & Nikolopoulos, Konstantinos, 2016. "Another look at estimators for intermittent demand," International Journal of Production Economics, Elsevier, vol. 181(PA), pages 154-161.
    4. Fotios Petropoulos & Nikolaos Kourentzes, 2015. "Forecast combinations for intermittent demand," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 66(6), pages 914-924, June.
    5. Hyndman, Rob J. & Ahmed, Roman A. & Athanasopoulos, George & Shang, Han Lin, 2011. "Optimal combination forecasts for hierarchical time series," Computational Statistics & Data Analysis, Elsevier, vol. 55(9), pages 2579-2589, September.
    6. F R Johnston & J E Boylan & E A Shale, 2003. "An examination of the size of orders from customers, their characterisation and the implications for inventory control of slow moving items," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 54(8), pages 833-837, August.
    7. Snyder, Ralph D. & Ord, J. Keith & Beaumont, Adrian, 2012. "Forecasting the intermittent demand for slow-moving inventories: A modelling approach," International Journal of Forecasting, Elsevier, vol. 28(2), pages 485-496.
    8. Syntetos, A. A. & Boylan, J. E., 2001. "On the bias of intermittent demand estimates," International Journal of Production Economics, Elsevier, vol. 71(1-3), pages 457-466, May.
    9. Dangerfield, Byron J. & Morris, John S., 1992. "Top-down or bottom-up: Aggregate versus disaggregate extrapolations," International Journal of Forecasting, Elsevier, vol. 8(2), pages 233-241, October.
    10. Teunter, Ruud & Sani, Babangida, 2009. "On the bias of Croston's forecasting method," European Journal of Operational Research, Elsevier, vol. 194(1), pages 177-183, April.
    11. Hyndman, Rob J. & Koehler, Anne B., 2006. "Another look at measures of forecast accuracy," International Journal of Forecasting, Elsevier, vol. 22(4), pages 679-688.
    12. Kourentzes, Nikolaos & Petropoulos, Fotios & Trapero, Juan R., 2014. "Improving forecasting by estimating time series structural components across multiple frequencies," International Journal of Forecasting, Elsevier, vol. 30(2), pages 291-302.
    13. Willemain, Thomas R. & Smart, Charles N. & Schwarz, Henry F., 2004. "A new approach to forecasting intermittent demand for service parts inventories," International Journal of Forecasting, Elsevier, vol. 20(3), pages 375-387.
    14. Athanasopoulos, George & Hyndman, Rob J. & Kourentzes, Nikolaos & Petropoulos, Fotios, 2017. "Forecasting with temporal hierarchies," European Journal of Operational Research, Elsevier, vol. 262(1), pages 60-74.
    15. Leven, Erik & Segerstedt, Anders, 2004. "Inventory control with a modified Croston procedure and Erlang distribution," International Journal of Production Economics, Elsevier, vol. 90(3), pages 361-367, August.
    16. K Nikolopoulos & A A Syntetos & J E Boylan & F Petropoulos & V Assimakopoulos, 2011. "An aggregate–disaggregate intermittent demand approach (ADIDA) to forecasting: an empirical proposition and analysis," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 62(3), pages 544-554, March.
    17. Athanasopoulos, George & Ahmed, Roman A. & Hyndman, Rob J., 2009. "Hierarchical forecasts for Australian domestic tourism," International Journal of Forecasting, Elsevier, vol. 25(1), pages 146-166.
    18. Kourentzes, Nikolaos, 2013. "Intermittent demand forecasts with neural networks," International Journal of Production Economics, Elsevier, vol. 143(1), pages 198-206.
    19. Gutierrez, Rafael S. & Solis, Adriano O. & Mukhopadhyay, Somnath, 2008. "Lumpy demand forecasting using neural networks," International Journal of Production Economics, Elsevier, vol. 111(2), pages 409-420, February.
    20. Syntetos, Aris A. & Boylan, John E., 2005. "The accuracy of intermittent demand estimates," International Journal of Forecasting, Elsevier, vol. 21(2), pages 303-314.
    21. Petropoulos, Fotios & Makridakis, Spyros & Assimakopoulos, Vassilios & Nikolopoulos, Konstantinos, 2014. "‘Horses for Courses’ in demand forecasting," European Journal of Operational Research, Elsevier, vol. 237(1), pages 152-163.
    22. Rob J. Hyndman & Lydia Shenstone, 2005. "Stochastic models underlying Croston's method for intermittent demand forecasting," Journal of Forecasting, John Wiley & Sons, Ltd., vol. 24(6), pages 389-402.
    23. Wang, Wenbin & Syntetos, Aris A., 2011. "Spare parts demand: Linking forecasting to equipment maintenance," Transportation Research Part E: Logistics and Transportation Review, Elsevier, vol. 47(6), pages 1194-1209.
    24. Willemain, Thomas R. & Smart, Charles N. & Shockor, Joseph H. & DeSautels, Philip A., 1994. "Forecasting intermittent demand in manufacturing: a comparative evaluation of Croston's method," International Journal of Forecasting, Elsevier, vol. 10(4), pages 529-538, December.
    25. Teunter, Ruud H. & Syntetos, Aris A. & Zied Babai, M., 2011. "Intermittent demand: Linking forecasting to inventory obsolescence," European Journal of Operational Research, Elsevier, vol. 214(3), pages 606-615, November.
    26. R H Teunter & L Duncan, 2009. "Forecasting intermittent demand: a comparative study," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 60(3), pages 321-329, March.
    27. Bahman Rostami‐Tabar & M. Zied Babai & Aris Syntetos & Yves Ducq, 2013. "Demand forecasting by temporal aggregation," Naval Research Logistics (NRL), John Wiley & Sons, vol. 60(6), pages 479-498, September.
    28. R Fildes & K Nikolopoulos & S F Crone & A A Syntetos, 2008. "Forecasting and operational research: a review," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 59(9), pages 1150-1172, September.
    29. A H C Eaves & B G Kingsman, 2004. "Forecasting for the ordering and stock-holding of spare parts," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 55(4), pages 431-437, April.
    30. J W Taylor, 2003. "Short-term electricity demand forecasting using double seasonal exponential smoothing," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 54(8), pages 799-805, August.
    31. Edward A. Silver, 1981. "Operations Research in Inventory Management: A Review and Critique," Operations Research, INFORMS, vol. 29(4), pages 628-645, August.
    32. Bacchetti, Andrea & Saccani, Nicola, 2012. "Spare parts classification and demand forecasting for stock control: Investigating the gap between research and practice," Omega, Elsevier, vol. 40(6), pages 722-737.
    33. Babai, M. Zied & Ali, Mohammad M. & Nikolopoulos, Konstantinos, 2012. "Impact of temporal aggregation on stock control performance of intermittent demand estimators: Empirical analysis," Omega, Elsevier, vol. 40(6), pages 713-721.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Svetunkov, Ivan & Chen, Huijing & Boylan, John E., 2023. "A new taxonomy for vector exponential smoothing and its application to seasonal time series," European Journal of Operational Research, Elsevier, vol. 304(3), pages 964-980.
    2. Kourentzes, Nikolaos & Athanasopoulos, George, 2021. "Elucidate structure in intermittent demand series," European Journal of Operational Research, Elsevier, vol. 288(1), pages 141-152.
    3. Fildes, Robert & Ma, Shaohui & Kolassa, Stephan, 2022. "Retail forecasting: Research and practice," International Journal of Forecasting, Elsevier, vol. 38(4), pages 1283-1318.
    4. Pinçe, Çerağ & Turrini, Laura & Meissner, Joern, 2021. "Intermittent demand forecasting for spare parts: A Critical review," Omega, Elsevier, vol. 105(C).
    5. Shuyun Ren & Hau-Ling Chan & Tana Siqin, 2020. "Demand forecasting in retail operations for fashionable products: methods, practices, and real case study," Annals of Operations Research, Springer, vol. 291(1), pages 761-777, August.
    6. Berry, Lindsay R. & Helman, Paul & West, Mike, 2020. "Probabilistic forecasting of heterogeneous consumer transaction–sales time series," International Journal of Forecasting, Elsevier, vol. 36(2), pages 552-569.
    7. Fildes, Robert & Ma, Shaohui & Kolassa, Stephan, 2019. "Retail forecasting: research and practice," MPRA Paper 89356, University Library of Munich, Germany.
    8. Boysen, Nils & de Koster, René & Füßler, David, 2021. "The forgotten sons: Warehousing systems for brick-and-mortar retail chains," European Journal of Operational Research, Elsevier, vol. 288(2), pages 361-381.
    9. Zeynep Hilal Kilimci & A. Okay Akyuz & Mitat Uysal & Selim Akyokus & M. Ozan Uysal & Berna Atak Bulbul & Mehmet Ali Ekmis, 2019. "An Improved Demand Forecasting Model Using Deep Learning Approach and Proposed Decision Integration Strategy for Supply Chain," Complexity, Hindawi, vol. 2019, pages 1-15, March.
    10. Che-Yu Hung & Chien-Chih Wang & Shi-Woei Lin & Bernard C. Jiang, 2022. "An Empirical Comparison of the Sales Forecasting Performance for Plastic Tray Manufacturing Using Missing Data," Sustainability, MDPI, vol. 14(4), pages 1-21, February.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Pinçe, Çerağ & Turrini, Laura & Meissner, Joern, 2021. "Intermittent demand forecasting for spare parts: A Critical review," Omega, Elsevier, vol. 105(C).
    2. Petropoulos, Fotios & Apiletti, Daniele & Assimakopoulos, Vassilios & Babai, Mohamed Zied & Barrow, Devon K. & Ben Taieb, Souhaib & Bergmeir, Christoph & Bessa, Ricardo J. & Bijak, Jakub & Boylan, Joh, 2022. "Forecasting: theory and practice," International Journal of Forecasting, Elsevier, vol. 38(3), pages 705-871.
      • Fotios Petropoulos & Daniele Apiletti & Vassilios Assimakopoulos & Mohamed Zied Babai & Devon K. Barrow & Souhaib Ben Taieb & Christoph Bergmeir & Ricardo J. Bessa & Jakub Bijak & John E. Boylan & Jet, 2020. "Forecasting: theory and practice," Papers 2012.03854, arXiv.org, revised Jan 2022.
    3. Jože Martin Rožanec & Blaž Fortuna & Dunja Mladenić, 2022. "Reframing Demand Forecasting: A Two-Fold Approach for Lumpy and Intermittent Demand," Sustainability, MDPI, vol. 14(15), pages 1-21, July.
    4. Pennings, Clint L.P. & van Dalen, Jan & van der Laan, Erwin A., 2017. "Exploiting elapsed time for managing intermittent demand for spare parts," European Journal of Operational Research, Elsevier, vol. 258(3), pages 958-969.
    5. Kourentzes, Nikolaos & Athanasopoulos, George, 2021. "Elucidate structure in intermittent demand series," European Journal of Operational Research, Elsevier, vol. 288(1), pages 141-152.
    6. Kourentzes, Nikolaos, 2014. "On intermittent demand model optimisation and selection," International Journal of Production Economics, Elsevier, vol. 156(C), pages 180-190.
    7. Syntetos, Aris A. & Zied Babai, M. & Gardner, Everette S., 2015. "Forecasting intermittent inventory demands: simple parametric methods vs. bootstrapping," Journal of Business Research, Elsevier, vol. 68(8), pages 1746-1752.
    8. Teunter, Ruud H. & Syntetos, Aris A. & Zied Babai, M., 2011. "Intermittent demand: Linking forecasting to inventory obsolescence," European Journal of Operational Research, Elsevier, vol. 214(3), pages 606-615, November.
    9. Hu, Qiwei & Boylan, John E. & Chen, Huijing & Labib, Ashraf, 2018. "OR in spare parts management: A review," European Journal of Operational Research, Elsevier, vol. 266(2), pages 395-414.
    10. Evangelos Spiliotis & Spyros Makridakis & Artemios-Anargyros Semenoglou & Vassilios Assimakopoulos, 2022. "Comparison of statistical and machine learning methods for daily SKU demand forecasting," Operational Research, Springer, vol. 22(3), pages 3037-3061, July.
    11. Kourentzes, Nikolaos, 2013. "Intermittent demand forecasts with neural networks," International Journal of Production Economics, Elsevier, vol. 143(1), pages 198-206.
    12. Babai, M. Zied & Ali, Mohammad M. & Nikolopoulos, Konstantinos, 2012. "Impact of temporal aggregation on stock control performance of intermittent demand estimators: Empirical analysis," Omega, Elsevier, vol. 40(6), pages 713-721.
    13. Mariusz Doszyn, 2020. "Accuracy of Intermittent Demand Forecasting Systems in the Enterprise," European Research Studies Journal, European Research Studies Journal, vol. 0(4), pages 912-930.
    14. Babai, M.Z. & Dallery, Y. & Boubaker, S. & Kalai, R., 2019. "A new method to forecast intermittent demand in the presence of inventory obsolescence," International Journal of Production Economics, Elsevier, vol. 209(C), pages 30-41.
    15. Zhu, Sha & Dekker, Rommert & van Jaarsveld, Willem & Renjie, Rex Wang & Koning, Alex J., 2017. "An improved method for forecasting spare parts demand using extreme value theory," European Journal of Operational Research, Elsevier, vol. 261(1), pages 169-181.
    16. Ducharme, Corey & Agard, Bruno & Trépanier, Martin, 2021. "Forecasting a customer's Next Time Under Safety Stock," International Journal of Production Economics, Elsevier, vol. 234(C).
    17. Nikolopoulos, Konstantinos, 2021. "We need to talk about intermittent demand forecasting," European Journal of Operational Research, Elsevier, vol. 291(2), pages 549-559.
    18. Bacchetti, Andrea & Saccani, Nicola, 2012. "Spare parts classification and demand forecasting for stock control: Investigating the gap between research and practice," Omega, Elsevier, vol. 40(6), pages 722-737.
    19. Aiping Jiang & Qiuguo Chi & Junjun Gao & Maoguo Wu, 2019. "An Integrated Approach to Forecasting Intermittent Demand for Electric Power Materials," Computational Economics, Springer;Society for Computational Economics, vol. 53(4), pages 1309-1335, April.
    20. Sarlo, Rodrigo & Fernandes, Cristiano & Borenstein, Denis, 2023. "Lumpy and intermittent retail demand forecasts with score-driven models," European Journal of Operational Research, Elsevier, vol. 307(3), pages 1146-1160.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:eee:ejores:v:269:y:2018:i:3:p:860-869. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Catherine Liu (email available below). General contact details of provider: http://www.elsevier.com/locate/eor .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.