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

Predicting retailer orders with POS and order data: The inventory balance effect

Author

Listed:
  • Williams, Brent D.
  • Waller, Matthew A.
  • Ahire, Sanjay
  • Ferrier, Gary D.

Abstract

Despite advances in retail point-of-sale (POS) data sharing, retailers’ suppliers struggle to effectively use POS data to improve their fulfillment planning processes. The challenge lies in predicting retailer orders. We present evidence that retail echelon inventory processes translate into a long-run balance or equilibrium between orders and POS, which we refer to as the inventory balance effect, allowing for more accurate order forecasting. Based on the inventory balance effect, this research prescribes a forecasting approach which simultaneously uses both sources of information (retailer order history and POS data) to predict retailer orders to suppliers. Using data from a consumable product category, this approach is shown to outperform approaches based singularly on order or POS data, by up to 125%. The strength of this novel approach – significantly improved forecast accuracy with minimal additional analysis – make it a candidate for widespread adoption in retail supply chain collaborative planning and forecasting initiatives with corresponding impact on fulfillment performance and related operating costs.

Suggested Citation

  • Williams, Brent D. & Waller, Matthew A. & Ahire, Sanjay & Ferrier, Gary D., 2014. "Predicting retailer orders with POS and order data: The inventory balance effect," European Journal of Operational Research, Elsevier, vol. 232(3), pages 593-600.
  • Handle: RePEc:eee:ejores:v:232:y:2014:i:3:p:593-600
    DOI: 10.1016/j.ejor.2013.07.016
    as

    Download full text from publisher

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

    File URL: https://libkey.io/10.1016/j.ejor.2013.07.016?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. Karel H. van Donselaar & Vishal Gaur & Tom van Woensel & Rob A. C. M. Broekmeulen & Jan C. Fransoo, 2010. "Ordering Behavior in Retail Stores and Implications for Automated Replenishment," Management Science, INFORMS, vol. 56(5), pages 766-784, May.
    2. Hau L. Lee & Kut C. So & Christopher S. Tang, 2000. "The Value of Information Sharing in a Two-Level Supply Chain," Management Science, INFORMS, vol. 46(5), pages 626-643, May.
    3. Srinivasan Raghunathan, 2001. "Information Sharing in a Supply Chain: A Note on its Value when Demand Is Nonstationary," Management Science, INFORMS, vol. 47(4), pages 605-610, April.
    4. Bourland, Karla E. & Powell, Stephen G. & Pyke, David F., 1996. "Exploiting timely demand information to reduce inventories," European Journal of Operational Research, Elsevier, vol. 92(2), pages 239-253, July.
    5. Susan Cohen Kulp & Hau L. Lee & Elie Ofek, 2004. "Manufacturer Benefits from Information Integration with Retail Customers," Management Science, INFORMS, vol. 50(4), pages 431-444, April.
    6. Kang, Jae-Hun & Kim, Yeong-Dae, 2012. "Inventory control in a two-level supply chain with risk pooling effect," International Journal of Production Economics, Elsevier, vol. 135(1), pages 116-124.
    7. Granger, C W J & Lee, T H, 1989. "Investigation of Production, Sales and Inventory Relationships Using Multicointegration and Non-symmetric Error Correction Models," Journal of Applied Econometrics, John Wiley & Sons, Ltd., vol. 4(S), pages 145-159, Supplemen.
    8. Robert L. Bray & Haim Mendelson, 2012. "Information Transmission and the Bullwhip Effect: An Empirical Investigation," Management Science, INFORMS, vol. 58(5), pages 860-875, May.
    9. Yu, Yugang & Hong, Zhaofu & Zhang, Linda L. & Liang, Liang & Chu, Chengbin, 2013. "Optimal selection of retailers for a manufacturing vendor in a vendor managed inventory system," European Journal of Operational Research, Elsevier, vol. 225(2), pages 273-284.
    10. John D. Sterman, 1989. "Modeling Managerial Behavior: Misperceptions of Feedback in a Dynamic Decision Making Experiment," Management Science, INFORMS, vol. 35(3), pages 321-339, March.
    11. Saravanan Kesavan & Vishal Gaur & Ananth Raman, 2010. "Do Inventory and Gross Margin Data Improve Sales Forecasts for U.S. Public Retailers?," Management Science, INFORMS, vol. 56(9), pages 1519-1533, September.
    12. Fang, Xin & Zhang, Cheng & Robb, David J. & Blackburn, Joseph D., 2013. "Decision support for lead time and demand variability reduction," Omega, Elsevier, vol. 41(2), pages 390-396.
    13. Y. Yu & Z. Hong & L. Zhang & L. Liang & C. Chu, 2013. "Optimal selection of retailers for a manufacturing vendor in a vendor managed inventory system," Post-Print hal-00846452, HAL.
    14. Maurice E. Schweitzer & Gérard P. Cachon, 2000. "Decision Bias in the Newsvendor Problem with a Known Demand Distribution: Experimental Evidence," Management Science, INFORMS, vol. 46(3), pages 404-420, March.
    15. Guan, Ruoxi & Zhao, Xiaobo, 2010. "On contracts for VMI program with continuous review (r, Q) policy," European Journal of Operational Research, Elsevier, vol. 207(2), pages 656-667, December.
    16. Luong, Huynh Trung, 2007. "Measure of bullwhip effect in supply chains with autoregressive demand process," European Journal of Operational Research, Elsevier, vol. 180(3), pages 1086-1097, August.
    17. Nicole DeHoratius & Ananth Raman, 2008. "Inventory Record Inaccuracy: An Empirical Analysis," Management Science, INFORMS, vol. 54(4), pages 627-641, April.
    18. Donna F. Davis & John T. Mentzer & Teresa M. Mccarthy & Susan L. Golicic, 2006. "The evolution of sales forecasting management: a 20-year longitudinal study of forecasting practices," Journal of Forecasting, John Wiley & Sons, Ltd., vol. 25(5), pages 303-324.
    19. Stephen C. Graves, 1999. "A Single-Item Inventory Model for a Nonstationary Demand Process," Manufacturing & Service Operations Management, INFORMS, vol. 1(1), pages 50-61.
    20. Gérard P. Cachon & Marshall Fisher, 2000. "Supply Chain Inventory Management and the Value of Shared Information," Management Science, INFORMS, vol. 46(8), pages 1032-1048, August.
    21. Soon Ang & Sandra Slaughter & Kok Yee Ng, 2002. "Human Capital and Institutional Determinants of Information Technology Compensation: Modeling Multilevel and Cross-Level Interactions," Management Science, INFORMS, vol. 48(11), pages 1427-1445, November.
    22. Hau L. Lee & V. Padmanabhan & Seungjin Whang, 1997. "Information Distortion in a Supply Chain: The Bullwhip Effect," Management Science, INFORMS, vol. 43(4), pages 546-558, April.
    23. Frank Chen & Zvi Drezner & Jennifer K. Ryan & David Simchi-Levi, 2000. "Quantifying the Bullwhip Effect in a Simple Supply Chain: The Impact of Forecasting, Lead Times, and Information," Management Science, INFORMS, vol. 46(3), pages 436-443, March.
    24. Yossi Aviv, 2001. "The Effect of Collaborative Forecasting on Supply Chain Performance," Management Science, INFORMS, vol. 47(10), pages 1326-1343, October.
    25. Yossi Aviv, 2007. "On the Benefits of Collaborative Forecasting Partnerships Between Retailers and Manufacturers," Management Science, INFORMS, vol. 53(5), pages 777-794, May.
    26. Choi, Tsan-Ming & Sethi, Suresh, 2010. "Innovative quick response programs: A review," International Journal of Production Economics, Elsevier, vol. 127(1), pages 1-12, September.
    27. Srinagesh Gavirneni & Roman Kapuscinski & Sridhar Tayur, 1999. "Value of Information in Capacitated Supply Chains," Management Science, INFORMS, vol. 45(1), pages 16-24, January.
    28. Piramuthu, Selwyn & Farahani, Poorya & Grunow, Martin, 2013. "RFID-generated traceability for contaminated product recall in perishable food supply networks," European Journal of Operational Research, Elsevier, vol. 225(2), pages 253-262.
    29. Sodhi, ManMohan S. & Tang, Christopher S., 2011. "The incremental bullwhip effect of operational deviations in an arborescent supply chain with requirements planning," European Journal of Operational Research, Elsevier, vol. 215(2), pages 374-382, December.
    30. Dejonckheere, J. & Disney, S. M. & Lambrecht, M. R. & Towill, D. R., 2004. "The impact of information enrichment on the Bullwhip effect in supply chains: A control engineering perspective," European Journal of Operational Research, Elsevier, vol. 153(3), pages 727-750, March.
    31. Sterman, John D., 1989. "Misperceptions of feedback in dynamic decision making," Organizational Behavior and Human Decision Processes, Elsevier, vol. 43(3), pages 301-335, June.
    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. Chiang, Chung-Yean & Qian, Zhuang & Chuang, Chia-Hung & Tang, Xiao & Chou, Chia-Ching, 2023. "Examining demand and supply-chain antecedents of inventory dynamics: Evidence from automotive industry," International Journal of Production Economics, Elsevier, vol. 259(C).
    2. Kefeng Xu & Yang Dong & Yu Xia, 2014. "‘Too Little’ or ‘Too Late’: The Timing of Supply Chain Demand Collaboration," Working Papers 0203mss, College of Business, University of Texas at San Antonio.
    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. Ma, Shaohui & Fildes, Robert, 2017. "A retail store SKU promotions optimization model for category multi-period profit maximization," European Journal of Operational Research, Elsevier, vol. 260(2), pages 680-692.
    5. Tian, Xin & Cao, Shasha & Song, Yan, 2021. "The impact of weather on consumer behavior and retail performance: Evidence from a convenience store chain in China," Journal of Retailing and Consumer Services, Elsevier, vol. 62(C).
    6. Hartzel, Kathleen S. & Wood, Charles A., 2017. "Factors that affect the improvement of demand forecast accuracy through point-of-sale reporting," European Journal of Operational Research, Elsevier, vol. 260(1), pages 171-182.
    7. Fildes, Robert & Ma, Shaohui & Kolassa, Stephan, 2019. "Retail forecasting: research and practice," MPRA Paper 89356, University Library of Munich, Germany.
    8. Ma, Shaohui & Fildes, Robert, 2020. "Forecasting third-party mobile payments with implications for customer flow prediction," International Journal of Forecasting, Elsevier, vol. 36(3), pages 739-760.
    9. Van Belle, Jente & Guns, Tias & Verbeke, Wouter, 2021. "Using shared sell-through data to forecast wholesaler demand in multi-echelon supply chains," European Journal of Operational Research, Elsevier, vol. 288(2), pages 466-479.
    10. Sagaert, Yves R. & Aghezzaf, El-Houssaine & Kourentzes, Nikolaos & Desmet, Bram, 2018. "Tactical sales forecasting using a very large set of macroeconomic indicators," European Journal of Operational Research, Elsevier, vol. 264(2), pages 558-569.
    11. Badorf, Florian & Hoberg, Kai, 2020. "The impact of daily weather on retail sales: An empirical study in brick-and-mortar stores," Journal of Retailing and Consumer Services, Elsevier, vol. 52(C).
    12. Naragain Phumchusri & Warot Kosawanitchakarn & Sirawich Chawanapranee & Sirawish Srimook, 2023. "Evaluating promotional pricing effectiveness using convenience store daily sales data," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 22(5), pages 362-373, October.
    13. Yuya Ieiri & Kaishu Yamaki & Reiko Hishiyama, 2024. "Community-based management for low-digitalized communities using cross-cutting purchasing behavior," Palgrave Communications, Palgrave Macmillan, vol. 11(1), pages 1-12, December.
    14. Mervegül Kirci & Olov Isaksson & Ralf Seifert, 2022. "Managing Perishability in the Fruit and Vegetable Supply Chains," Sustainability, MDPI, vol. 14(9), pages 1-24, April.

    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. Wang, Xun & Disney, Stephen M., 2016. "The bullwhip effect: Progress, trends and directions," European Journal of Operational Research, Elsevier, vol. 250(3), pages 691-701.
    2. Li Chen & Hau L. Lee, 2009. "Information Sharing and Order Variability Control Under a Generalized Demand Model," Management Science, INFORMS, vol. 55(5), pages 781-797, May.
    3. Ojha, Divesh & Sahin, Funda & Shockley, Jeff & Sridharan, Sri V., 2019. "Is there a performance tradeoff in managing order fulfillment and the bullwhip effect in supply chains? The role of information sharing and information type," International Journal of Production Economics, Elsevier, vol. 208(C), pages 529-543.
    4. Li Chen & Hau L. Lee, 2012. "Bullwhip Effect Measurement and Its Implications," Operations Research, INFORMS, vol. 60(4), pages 771-784, August.
    5. Zhang, Xiaolong & Burke, Gerard J., 2011. "Analysis of compound bullwhip effect causes," European Journal of Operational Research, Elsevier, vol. 210(3), pages 514-526, May.
    6. Hau L. Lee & V. Padmanabhan & Seungjin Whang, 2004. "Comments on "Information Distortion in a Supply Chain: The Bullwhip Effect"," Management Science, INFORMS, vol. 50(12_supple), pages 1887-1893, December.
    7. QU, Zhan & RAFF, Horst, 2023. "Two-part tariffs, inventory stockpiling, and the bullwhip effect," European Journal of Operational Research, Elsevier, vol. 308(1), pages 201-214.
    8. Ouyang, Yanfeng, 2007. "The effect of information sharing on supply chain stability and the bullwhip effect," European Journal of Operational Research, Elsevier, vol. 182(3), pages 1107-1121, November.
    9. Tang, Christopher S., 2006. "Perspectives in supply chain risk management," International Journal of Production Economics, Elsevier, vol. 103(2), pages 451-488, October.
    10. Ruomeng Cui & Gad Allon & Achal Bassamboo & Jan A. Van Mieghem, 2015. "Information Sharing in Supply Chains: An Empirical and Theoretical Valuation," Management Science, INFORMS, vol. 61(11), pages 2803-2824, November.
    11. Yossi Aviv, 2003. "A Time-Series Framework for Supply-Chain Inventory Management," Operations Research, INFORMS, vol. 51(2), pages 210-227, April.
    12. Yanfeng Ouyang & Carlos Daganzo, 2006. "Characterization of the Bullwhip Effect in Linear, Time-Invariant Supply Chains: Some Formulae and Tests," Management Science, INFORMS, vol. 52(10), pages 1544-1556, October.
    13. Sodhi, ManMohan S. & Tang, Christopher S., 2011. "The incremental bullwhip effect of operational deviations in an arborescent supply chain with requirements planning," European Journal of Operational Research, Elsevier, vol. 215(2), pages 374-382, December.
    14. Robert L. Bray & Haim Mendelson, 2012. "Information Transmission and the Bullwhip Effect: An Empirical Investigation," Management Science, INFORMS, vol. 58(5), pages 860-875, May.
    15. Anantaram Balakrishnan & Joseph Geunes & Michael S. Pangburn, 2004. "Coordinating Supply Chains by Controlling Upstream Variability Propagation," Manufacturing & Service Operations Management, INFORMS, vol. 6(2), pages 163-183, July.
    16. Ouyang, Yanfeng & Li, Xiaopeng, 2010. "The bullwhip effect in supply chain networks," European Journal of Operational Research, Elsevier, vol. 201(3), pages 799-810, March.
    17. Caridi, Maria & Moretto, Antonella & Perego, Alessandro & Tumino, Angela, 2014. "The benefits of supply chain visibility: A value assessment model," International Journal of Production Economics, Elsevier, vol. 151(C), pages 1-19.
    18. Chatfield, Dean C. & Pritchard, Alan M., 2013. "Returns and the bullwhip effect," Transportation Research Part E: Logistics and Transportation Review, Elsevier, vol. 49(1), pages 159-175.
    19. Paulo Gonçalves & Mohammad Moshtari, 2021. "The impact of information visibility on ordering dynamics in a supply chain: a behavioral perspective," System Dynamics Review, System Dynamics Society, vol. 37(2-3), pages 126-154, April.
    20. B D Williams & M A Waller, 2011. "Estimating a retailer's base stock level: an optimal distribution center order forecast policy," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 62(4), pages 662-666, April.

    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:232:y:2014:i:3:p:593-600. 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.