IDEAS home Printed from https://ideas.repec.org/a/inm/orijoc/v35y2023i1p158-177.html
   My bibliography  Save this article

Machine Learning Methods for Data-Driven Demand Estimation and Assortment Planning Considering Cross-Selling and Substitutions

Author

Listed:
  • Zhen-Yu Chen

    (School of Business Administration, Northeastern University, Shenyang 110169, China)

  • Zhi-Ping Fan

    (School of Business Administration, Northeastern University, Shenyang 110169, China)

  • Minghe Sun

    (Carlos Alvarez College of Business, The University of Texas at San Antonio, San Antonio, Texas 78249)

Abstract

This study develops machine learning methods for the data-driven demand estimation and assortment planning problem by addressing three subproblems, that is, demand forecasting simultaneously considering cross-selling and substitutions, estimation of the cross-selling and substitution effects, and assortment optimization. These three subproblems are transformed into three sequentially related machine learning problems: collective demand forecasting, demand inference for cross-selling and substitutions, and assortment rule mining. For collective demand forecasting, related product features are introduced to consider both the cross-selling and substitution effects, and a collaborative coordinate descent method with a good convergence property is developed to make distributed demand forecasting and a global update of related product features. Using the results, demand inference adopts transfer and semisupervised learning methods to tackle the challenge of missing data in quantifying the cross-selling and substitution effects. For assortment rule mining, the assortment rules bridge the gap between prediction and optimization, and the developed heuristics obtain the best assortment using the prior knowledge discovered in demand inference. The computational results on a real-world database and a semisynthetic database show that collective demand forecasting obtained far better results than the standard demand forecasting methods and some popular graph learning methods, and the developed heuristics identified much better assortments than those obtained with the baseline methods.

Suggested Citation

  • Zhen-Yu Chen & Zhi-Ping Fan & Minghe Sun, 2023. "Machine Learning Methods for Data-Driven Demand Estimation and Assortment Planning Considering Cross-Selling and Substitutions," INFORMS Journal on Computing, INFORMS, vol. 35(1), pages 158-177, January.
  • Handle: RePEc:inm:orijoc:v:35:y:2023:i:1:p:158-177
    DOI: 10.1287/ijoc.2022.1251
    as

    Download full text from publisher

    File URL: http://dx.doi.org/10.1287/ijoc.2022.1251
    Download Restriction: no

    File URL: https://libkey.io/10.1287/ijoc.2022.1251?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
    ---><---

    References listed on IDEAS

    as
    1. Gah-Yi Ban & Cynthia Rudin, 2019. "The Big Data Newsvendor: Practical Insights from Machine Learning," Operations Research, INFORMS, vol. 67(1), pages 90-108, January.
    2. Gustavo Vulcano & Garrett van Ryzin & Richard Ratliff, 2012. "Estimating Primary Demand for Substitutable Products from Sales Transaction Data," Operations Research, INFORMS, vol. 60(2), pages 313-334, April.
    3. Talebian, Masoud & Boland, Natashia & Savelsbergh, Martin, 2014. "Pricing to accelerate demand learning in dynamic assortment planning for perishable products," European Journal of Operational Research, Elsevier, vol. 237(2), pages 555-565.
    4. Marshall Fisher & Ramnath Vaidyanathan, 2014. "A Demand Estimation Procedure for Retail Assortment Optimization with Results from Implementations," Management Science, INFORMS, vol. 60(10), pages 2401-2415, October.
    5. Shin, Hojung & Park, Soohoon & Lee, Euncheol & Benton, W.C., 2015. "A classification of the literature on the planning of substitutable products," European Journal of Operational Research, Elsevier, vol. 246(3), pages 686-699.
    6. Gotoh, Jun-ya & Takano, Yuichi, 2007. "Newsvendor solutions via conditional value-at-risk minimization," European Journal of Operational Research, Elsevier, vol. 179(1), pages 80-96, May.
    7. Vivek F. Farias & Srikanth Jagabathula & Devavrat Shah, 2013. "A Nonparametric Approach to Modeling Choice with Limited Data," Management Science, INFORMS, vol. 59(2), pages 305-322, December.
    8. Haengju Lee & Yongsoon Eun, 2016. "Estimating Primary Demand for a Heterogeneous-Groups Product Category under Hierarchical Consumer Choice Model," IISE Transactions, Taylor & Francis Journals, vol. 48(6), pages 541-554, June.
    9. Vishal Gaur & Dorothée Honhon, 2006. "Assortment Planning and Inventory Decisions Under a Locational Choice Model," Management Science, INFORMS, vol. 52(10), pages 1528-1543, October.
    10. Hübner, Alexander & Kuhn, Heinrich & Kühn, Sandro, 2016. "An efficient algorithm for capacitated assortment planning with stochastic demand and substitution," European Journal of Operational Research, Elsevier, vol. 250(2), pages 505-520.
    11. Siddharth Mahajan & Garrett van Ryzin, 2001. "Stocking Retail Assortments Under Dynamic Consumer Substitution," Operations Research, INFORMS, vol. 49(3), pages 334-351, June.
    12. A. Gürhan Kök & Marshall L. Fisher & Ramnath Vaidyanathan, 2015. "Assortment Planning: Review of Literature and Industry Practice," International Series in Operations Research & Management Science, in: Narendra Agrawal & Stephen A. Smith (ed.), Retail Supply Chain Management, edition 2, chapter 0, pages 175-236, Springer.
    13. Felipe Caro & Jérémie Gallien, 2007. "Dynamic Assortment with Demand Learning for Seasonal Consumer Goods," Management Science, INFORMS, vol. 53(2), pages 276-292, February.
    14. Wan, Mingchao & Huang, Yihui & Zhao, Lei & Deng, Tianhu & Fransoo, Jan C., 2018. "Demand estimation under multi-store multi-product substitution in high density traditional retail," European Journal of Operational Research, Elsevier, vol. 266(1), pages 99-111.
    15. Alexandre Belloni & Robert Freund & Matthew Selove & Duncan Simester, 2008. "Optimizing Product Line Designs: Efficient Methods and Comparisons," Management Science, INFORMS, vol. 54(9), pages 1544-1552, September.
    16. A. Gürhan Kök & Marshall L. Fisher, 2007. "Demand Estimation and Assortment Optimization Under Substitution: Methodology and Application," Operations Research, INFORMS, vol. 55(6), pages 1001-1021, December.
    17. Dimitris Bertsimas & Nathan Kallus, 2020. "From Predictive to Prescriptive Analytics," Management Science, INFORMS, vol. 66(3), pages 1025-1044, March.
    18. Huber, Jakob & Müller, Sebastian & Fleischmann, Moritz & Stuckenschmidt, Heiner, 2019. "A data-driven newsvendor problem: From data to decision," European Journal of Operational Research, Elsevier, vol. 278(3), pages 904-915.
    19. Chan, Rebecca & Li, Zhaolin & Matsypura, Dmytro, 2020. "Assortment optimisation problem: A distribution-free approach," Omega, Elsevier, vol. 95(C).
    20. Xue Bai & Sudip Bhattacharjee & Fidan Boylu & Ram Gopal, 2015. "Growth Projections and Assortment Planning of Commodity Products Across Multiple Stores: A Data Mining and Optimization Approach," INFORMS Journal on Computing, INFORMS, vol. 27(4), pages 619-635, November.
    21. Duncan Simester & Artem Timoshenko & Spyros I. Zoumpoulis, 2020. "Targeting Prospective Customers: Robustness of Machine-Learning Methods to Typical Data Challenges," Management Science, INFORMS, vol. 66(6), pages 2495-2522, June.
    22. Jianqing Fan & Jinchi Lv, 2008. "Sure independence screening for ultrahigh dimensional feature space," Journal of the Royal Statistical Society Series B, Royal Statistical Society, vol. 70(5), pages 849-911, November.
    23. Paat Rusmevichientong & Zuo-Jun Max Shen & David B. Shmoys, 2010. "Dynamic Assortment Optimization with a Multinomial Logit Choice Model and Capacity Constraint," Operations Research, INFORMS, vol. 58(6), pages 1666-1680, December.
    24. Stephen A. Smith & Narendra Agrawal, 2000. "Management of Multi-Item Retail Inventory Systems with Demand Substitution," Operations Research, INFORMS, vol. 48(1), pages 50-64, February.
    25. Gubela, Robin M. & Lessmann, Stefan & Jaroszewicz, Szymon, 2020. "Response transformation and profit decomposition for revenue uplift modeling," European Journal of Operational Research, Elsevier, vol. 283(2), pages 647-661.
    26. Afshin Oroojlooyjadid & Lawrence V. Snyder & Martin Takáč, 2020. "Applying deep learning to the newsvendor problem," IISE Transactions, Taylor & Francis Journals, vol. 52(4), pages 444-463, April.
    27. Nan Liu & Yuhang Ma & Huseyin Topaloglu, 2020. "Assortment Optimization Under the Multinomial Logit Model with Sequential Offerings," INFORMS Journal on Computing, INFORMS, vol. 32(3), pages 835-853, July.
    28. Qi Feng & J. George Shanthikumar, 2018. "How Research in Production and Operations Management May Evolve in the Era of Big Data," Production and Operations Management, Production and Operations Management Society, vol. 27(9), pages 1670-1684, September.
    29. Hübner, Alexander H. & Kuhn, Heinrich, 2012. "Retail category management: State-of-the-art review of quantitative research and software applications in assortment and shelf space management," Omega, Elsevier, vol. 40(2), pages 199-209, April.
    30. Chen, Zhen-Yu & Fan, Zhi-Ping & Sun, Minghe, 2019. "Individual-level social influence identification in social media: A learning-simulation coordinated method," European Journal of Operational Research, Elsevier, vol. 273(3), pages 1005-1015.
    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. Zhao, Meng & Xu, Chang & Zhao, Wenxian & Lin, Mingwei, 2023. "New energy vehicle online selection method considering attribute compensation relationship and aspiration strength," Journal of Retailing and Consumer Services, Elsevier, vol. 75(C).

    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. Mou, Shandong & Robb, David J. & DeHoratius, Nicole, 2018. "Retail store operations: Literature review and research directions," European Journal of Operational Research, Elsevier, vol. 265(2), pages 399-422.
    2. Hans Corsten & Michael Hopf & Benedikt Kasper & Clemens Thielen, 2018. "Assortment planning for multiple chain stores," OR Spectrum: Quantitative Approaches in Management, Springer;Gesellschaft für Operations Research e.V., vol. 40(4), pages 875-912, October.
    3. Qiu, Jiaqing & Li, Xiangyong & Duan, Yongrui & Chen, Mengxi & Tian, Peng, 2020. "Dynamic assortment in the presence of brand heterogeneity," Journal of Retailing and Consumer Services, Elsevier, vol. 56(C).
    4. Transchel, Sandra & Buisman, Marjolein E. & Haijema, Rene, 2022. "Joint assortment and inventory optimization for vertically differentiated products under consumer-driven substitution," European Journal of Operational Research, Elsevier, vol. 301(1), pages 163-179.
    5. Hübner, Alexander & Schaal, Kai, 2017. "An integrated assortment and shelf-space optimization model with demand substitution and space-elasticity effects," European Journal of Operational Research, Elsevier, vol. 261(1), pages 302-316.
    6. Pol Boada-Collado & Victor Martínez-de-Albéniz, 2020. "Estimating and Optimizing the Impact of Inventory on Consumer Choices in a Fashion Retail Setting," Manufacturing & Service Operations Management, INFORMS, vol. 22(3), pages 582-597, May.
    7. Menezes, Mozart B.C. & Pinto, Roberto, 2022. "Product proliferation, cannibalisation, and substitution: A first look into entailed risk and complexity," International Journal of Production Economics, Elsevier, vol. 243(C).
    8. Çömez-Dolgan, Nagihan & Fescioglu-Unver, Nilgun & Cephe, Ecem & Şen, Alper, 2021. "Capacitated strategic assortment planning under explicit demand substitution," European Journal of Operational Research, Elsevier, vol. 294(3), pages 1120-1138.
    9. Çömez-Dolgan, Nagihan & Moussawi-Haidar, Lama & Jaber, Mohamad Y. & Cephe, Ecem, 2022. "Capacitated assortment planning of a multi-location system under transshipments," International Journal of Production Economics, Elsevier, vol. 251(C).
    10. Wan, Mingchao & Huang, Yihui & Zhao, Lei & Deng, Tianhu & Fransoo, Jan C., 2018. "Demand estimation under multi-store multi-product substitution in high density traditional retail," European Journal of Operational Research, Elsevier, vol. 266(1), pages 99-111.
    11. Çömez-Dolgan, Nagihan & Dağ, Hilal & Fescioglu-Unver, Nilgun & Şen, Alper, 2023. "Multi-plant manufacturing assortment planning in the presence of transshipments," European Journal of Operational Research, Elsevier, vol. 310(3), pages 1033-1050.
    12. Mehrani, Saharnaz & Sefair, Jorge A., 2022. "Robust assortment optimization under sequential product unavailability," European Journal of Operational Research, Elsevier, vol. 303(3), pages 1027-1043.
    13. Victor Martínez-de-Albéniz & Sumit Kunnumkal, 2022. "A Model for Integrated Inventory and Assortment Planning," Management Science, INFORMS, vol. 68(7), pages 5049-5067, July.
    14. Yang, Cheng-Hu & Wang, Hai-Tang & Ma, Xin & Talluri, Srinivas, 2023. "A data-driven newsvendor problem: A high-dimensional and mixed-frequency method," International Journal of Production Economics, Elsevier, vol. 266(C).
    15. Transchel, Sandra, 2017. "Inventory management under price-based and stockout-based substitution," European Journal of Operational Research, Elsevier, vol. 262(3), pages 996-1008.
    16. Fernando Bernstein & A. Gürhan Kök & Lei Xie, 2015. "Dynamic Assortment Customization with Limited Inventories," Manufacturing & Service Operations Management, INFORMS, vol. 17(4), pages 538-553, October.
    17. Ding, Xiaohui & Chen, Caihua & Li, Chongshou & Lim, Andrew, 2021. "Product demand estimation for vending machines using video surveillance data: A group-lasso method," Transportation Research Part E: Logistics and Transportation Review, Elsevier, vol. 150(C).
    18. Hübner, Alexander & Kuhn, Heinrich & Kühn, Sandro, 2016. "An efficient algorithm for capacitated assortment planning with stochastic demand and substitution," European Journal of Operational Research, Elsevier, vol. 250(2), pages 505-520.
    19. Marshall Fisher & Ramnath Vaidyanathan, 2014. "A Demand Estimation Procedure for Retail Assortment Optimization with Results from Implementations," Management Science, INFORMS, vol. 60(10), pages 2401-2415, October.
    20. Hense, Jonas & Hübner, Alexander, 2022. "Assortment optimization in omni-channel retailing," European Journal of Operational Research, Elsevier, vol. 301(1), pages 124-140.

    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:inm:orijoc:v:35:y:2023:i:1:p:158-177. 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: Chris Asher (email available below). General contact details of provider: https://edirc.repec.org/data/inforea.html .

    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.