IDEAS home Printed from https://ideas.repec.org/a/inm/ormnsc/v68y2022i7p5049-5067.html
   My bibliography  Save this article

A Model for Integrated Inventory and Assortment Planning

Author

Listed:
  • Victor Martínez-de-Albéniz

    (IESE Business School, University of Navarra, 08034 Barcelona, Spain)

  • Sumit Kunnumkal

    (Indian School of Business, Gachibowli, Hyderabad, India)

Abstract

Integrating inventory and assortment planning decisions is a challenging task that requires comparing the value of demand expansion through broader choice for consumers with the value of higher in-stock availability. We develop a stockout-based substitution model for trading off these values in a setting with inventory replenishment, a feature missing in the literature. Using the closed form solution for the single-product case, we develop an accurate approximation for the multiproduct case. This approximated formulation allows us to optimize inventory decisions by solving a fractional integer program with a fixed point equation constraint. When products have equal margins, we solve the integer program exactly by bisection over a one-dimensional parameter. In contrast, when products have different margins, we propose a fractional relaxation that we can also solve by bisection and that results in near-optimal solutions. Overall, our approach provides solutions within 0.1% of the optimal policy and finds the optimal solution in 80% of the random instances we generate.

Suggested Citation

  • 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.
  • Handle: RePEc:inm:ormnsc:v:68:y:2022:i:7:p:5049-5067
    DOI: 10.1287/mnsc.2021.4149
    as

    Download full text from publisher

    File URL: http://dx.doi.org/10.1287/mnsc.2021.4149
    Download Restriction: no

    File URL: https://libkey.io/10.1287/mnsc.2021.4149?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. Wallace J. Hopp & Xiaowei Xu, 2008. "A Static Approximation for Dynamic Demand Substitution with Applications in a Competitive Market," Operations Research, INFORMS, vol. 56(3), pages 630-645, June.
    2. Robert S. Kaplan, 1970. "A Dynamic Inventory Model with Stochastic Lead Times," Management Science, INFORMS, vol. 16(7), pages 491-507, March.
    3. Kalyan Talluri & Garrett van Ryzin, 2004. "Revenue Management Under a General Discrete Choice Model of Consumer Behavior," Management Science, INFORMS, vol. 50(1), pages 15-33, January.
    4. 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.
    5. Vineet Goyal & Retsef Levi & Danny Segev, 2016. "Near-Optimal Algorithms for the Assortment Planning Problem Under Dynamic Substitution and Stochastic Demand," Operations Research, INFORMS, vol. 64(1), pages 219-235, February.
    6. Siddharth Mahajan & Garrett van Ryzin, 2001. "Stocking Retail Assortments Under Dynamic Consumer Substitution," Operations Research, INFORMS, vol. 49(3), pages 334-351, June.
    7. Andrés Musalem & Marcelo Olivares & Eric T. Bradlow & Christian Terwiesch & Daniel Corsten, 2010. "Structural Estimation of the Effect of Out-of-Stocks," Management Science, INFORMS, vol. 56(7), pages 1180-1197, July.
    8. 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.
    9. Garrett van Ryzin & Siddharth Mahajan, 1999. "On the Relationship Between Inventory Costs and Variety Benefits in Retail Assortments," Management Science, INFORMS, vol. 45(11), pages 1496-1509, November.
    10. Dorothée Honhon & Vishal Gaur & Sridhar Seshadri, 2010. "Assortment Planning and Inventory Decisions Under Stockout-Based Substitution," Operations Research, INFORMS, vol. 58(5), pages 1364-1379, October.
    11. Andy A. Tsay & Narendra Agrawal, 2000. "Channel Dynamics Under Price and Service Competition," Manufacturing & Service Operations Management, INFORMS, vol. 2(4), pages 372-391, August.
    12. Jacob B. Feldman & Huseyin Topaloglu, 2017. "Revenue Management Under the Markov Chain Choice Model," Operations Research, INFORMS, vol. 65(5), pages 1322-1342, October.
    13. 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.
    14. Gérard P. Cachon & Santiago Gallino & Marcelo Olivares, 2019. "Does Adding Inventory Increase Sales? Evidence of a Scarcity Effect in U.S. Automobile Dealerships," Management Science, INFORMS, vol. 65(4), pages 1469-1485, April.
    15. Ali Aouad & Retsef Levi & Danny Segev, 2019. "Approximation Algorithms for Dynamic Assortment Optimization Models," Mathematics of Operations Research, INFORMS, vol. 44(2), pages 487-511, May.
    16. Alp Muharremoglu & Nan Yang, 2010. "Inventory Management with an Exogenous Supply Process," Operations Research, INFORMS, vol. 58(1), pages 111-129, February.
    17. Serguei Netessine & Nils Rudi, 2003. "Centralized and Competitive Inventory Models with Demand Substitution," Operations Research, INFORMS, vol. 51(2), pages 329-335, April.
    18. Jose Blanchet & Guillermo Gallego & Vineet Goyal, 2016. "A Markov Chain Approximation to Choice Modeling," Operations Research, INFORMS, vol. 64(4), pages 886-905, August.
    19. Chenhao Du & William L. Cooper & Zizhuo Wang, 2016. "Optimal Pricing for a Multinomial Logit Choice Model with Network Effects," Operations Research, INFORMS, vol. 64(2), pages 441-455, April.
    20. 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.
    21. Urban, Timothy L., 2005. "Inventory models with inventory-level-dependent demand: A comprehensive review and unifying theory," European Journal of Operational Research, Elsevier, vol. 162(3), pages 792-804, May.
    22. 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.
    23. 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.
    24. Gérard P. Cachon & Christian Terwiesch & Yi Xu, 2005. "Retail Assortment Planning in the Presence of Consumer Search," Manufacturing & Service Operations Management, INFORMS, vol. 7(4), pages 330-346, August.
    25. D. Beyer & S. P. Sethi & R. Sridhar, 2001. "Stochastic Multiproduct Inventory Models with Limited Storage," Journal of Optimization Theory and Applications, Springer, vol. 111(3), pages 553-588, December.
    26. Xuanming Su & Fuqiang Zhang, 2008. "Strategic Customer Behavior, Commitment, and Supply Chain Performance," Management Science, INFORMS, vol. 54(10), pages 1759-1773, October.
    27. Dorothée Honhon & Sridhar Seshadri, 2013. "Fixed vs. Random Proportions Demand Models for the Assortment Planning Problem Under Stockout-Based Substitution," Manufacturing & Service Operations Management, INFORMS, vol. 15(3), pages 378-386, July.
    28. Steven A. Lippman & Kevin F. McCardle, 1997. "The Competitive Newsboy," Operations Research, INFORMS, vol. 45(1), pages 54-65, February.
    Full references (including those not matched with items on IDEAS)

    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. 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.
    2. 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.
    3. 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.
    4. Boxiao Chen & Xiuli Chao, 2020. "Dynamic Inventory Control with Stockout Substitution and Demand Learning," Management Science, INFORMS, vol. 66(11), pages 5108-5127, November.
    5. Yalçın Akçay & Yunke Li & Harihara Prasad Natarajan, 2020. "Category Inventory Planning With Service Level Requirements and Dynamic Substitutions," Production and Operations Management, Production and Operations Management Society, vol. 29(11), pages 2553-2578, November.
    6. 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).
    7. Amr Farahat & Joonkyum Lee, 2018. "The Multiproduct Newsvendor Problem with Customer Choice," Operations Research, INFORMS, vol. 66(1), pages 123-136, January.
    8. 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).
    9. Ali Aouad & Retsef Levi & Danny Segev, 2019. "Approximation Algorithms for Dynamic Assortment Optimization Models," Mathematics of Operations Research, INFORMS, vol. 44(2), pages 487-511, May.
    10. 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.
    11. Transchel, Sandra, 2017. "Inventory management under price-based and stockout-based substitution," European Journal of Operational Research, Elsevier, vol. 262(3), pages 996-1008.
    12. 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.
    13. Dorothée Honhon & Vishal Gaur & Sridhar Seshadri, 2010. "Assortment Planning and Inventory Decisions Under Stockout-Based Substitution," Operations Research, INFORMS, vol. 58(5), pages 1364-1379, October.
    14. Çö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.
    15. Çö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).
    16. 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.
    17. Vineet Goyal & Retsef Levi & Danny Segev, 2016. "Near-Optimal Algorithms for the Assortment Planning Problem Under Dynamic Substitution and Stochastic Demand," Operations Research, INFORMS, vol. 64(1), pages 219-235, February.
    18. Lingxiu Dong & Panos Kouvelis & Zhongjun Tian, 2009. "Dynamic Pricing and Inventory Control of Substitute Products," Manufacturing & Service Operations Management, INFORMS, vol. 11(2), pages 317-339, December.
    19. Vashkar Ghosh & Anand Paul & Lingjiong Zhu, 2022. "Stocking Under Random Demand and Product Variety: Exact Models and Heuristics," Production and Operations Management, Production and Operations Management Society, vol. 31(3), pages 1006-1032, March.
    20. Çö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.

    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:ormnsc:v:68:y:2022:i:7:p:5049-5067. 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.