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

A Demand Estimation Procedure for Retail Assortment Optimization with Results from Implementations

Author

Listed:
  • Marshall Fisher

    (Operations and Information Management Department, The Wharton School, University of Pennsylvania, Philadelphia, Pennsylvania 19104)

  • Ramnath Vaidyanathan

    (Desautels Faculty of Management, McGill University, Montreal, Quebec H3A 1G5, Canada)

Abstract

We consider the problem of choosing, from a set of N potential stock-keeping units (SKUs) in a retail category, K SKUs to be carried at each store to maximize revenue or profit. Assortments can vary by store, subject to a maximum number of different assortments. We view a SKU as a set of attribute levels and also model possible substitutions when a customer's first choice is not in the assortment. We apply maximum likelihood estimation to sales history of the SKUs currently carried by the retailer to estimate the demand for attribute levels and substitution probabilities, and from this, the demand for any potential SKU, including those not currently carried by the retailer. We specify several alternative heuristics for choosing SKUs to be carried in an assortment. We apply this approach to optimize assortments for three real examples: snack cakes, tires, and automotive appearance chemicals. A portion of our recommendations for tires and appearance chemicals were implemented and produced sales increases of 5.8% and 3.6%, respectively, which are significant improvements relative to typical retailer annual comparable store revenue increases. We also forecast sales shares of 1, 11, and 25 new SKUs for the snack cake, tire, and automotive appearance chemical applications, respectively, with mean absolute percentage errors (MAPEs) of 16.2%, 19.1%, and 28.7%, which compares favorably to the 30.7% MAPE for chain sales of two new SKUs reported by Fader and Hardie (1996). This paper was accepted by Yossi Aviv, operations management.

Suggested Citation

  • 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.
  • Handle: RePEc:inm:ormnsc:v:60:y:2014:i:10:p:2401-2415
    DOI: 10.1287/mnsc.2014.1904
    as

    Download full text from publisher

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

    File URL: https://libkey.io/10.1287/mnsc.2014.1904?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. Ravi Anupindi & Maqbool Dada & Sachin Gupta, 1998. "Estimation of Consumer Demand with Stock-Out Based Substitution: An Application to Vending Machine Products," Marketing Science, INFORMS, vol. 17(4), pages 406-423.
    2. Juin-Kuan Chong & Teck-Hua Ho & Christopher S. Tang, 2001. "A Modeling Framework for Category Assortment Planning," Manufacturing & Service Operations Management, INFORMS, vol. 3(3), pages 191-210, January.
    3. Peter M. Guadagni & John D. C. Little, 1983. "A Logit Model of Brand Choice Calibrated on Scanner Data," Marketing Science, INFORMS, vol. 2(3), pages 203-238.
    4. 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.
    5. 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.
    6. Rosen, Sherwin, 1974. "Hedonic Prices and Implicit Markets: Product Differentiation in Pure Competition," Journal of Political Economy, University of Chicago Press, vol. 82(1), pages 34-55, Jan.-Feb..
    7. 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.
    8. Paul E. Green & Abba M. Krieger, 1985. "Models and Heuristics for Product Line Selection," Marketing Science, INFORMS, vol. 4(1), pages 1-19.
    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. Siddharth Mahajan & Garrett van Ryzin, 2001. "Stocking Retail Assortments Under Dynamic Consumer Substitution," Operations Research, INFORMS, vol. 49(3), pages 334-351, June.
    11. 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.
    12. 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.
    13. Lancaster, Kelvin, 1975. "Socially Optimal Product Differentiation," American Economic Review, American Economic Association, vol. 65(4), pages 567-585, September.
    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. 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.
    2. Vidya Mani & Douglas J. Thomas & Saurabh Bansal, 2022. "Estimating Substitution and Basket Effects in Retail Stores: Implications for Assortment Planning," Management Science, INFORMS, vol. 68(7), pages 5002-5024, July.
    3. 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).
    4. Joonkyum Lee & Vishal Gaur & Suresh Muthulingam & Gary F. Swisher, 2016. "Stockout-Based Substitution and Inventory Planning in Textbook Retailing," Manufacturing & Service Operations Management, INFORMS, vol. 18(1), pages 104-121, February.
    5. 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).
    6. Yücel, Eda & Karaesmen, Fikri & Salman, F. Sibel & Türkay, Metin, 2009. "Optimizing product assortment under customer-driven demand substitution," European Journal of Operational Research, Elsevier, vol. 199(3), pages 759-768, December.
    7. 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.
    8. A. Gürhan Kök & Yi Xu, 2011. "Optimal and Competitive Assortments with Endogenous Pricing Under Hierarchical Consumer Choice Models," Management Science, INFORMS, vol. 57(9), pages 1546-1563, February.
    9. 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.
    10. Miller, Christopher M. & Smith, Stephen A. & McIntyre, Shelby H. & Achabal, Dale D., 2010. "Optimizing and Evaluating Retail Assortments for Infrequently Purchased Products," Journal of Retailing, Elsevier, vol. 86(2), pages 159-171.
    11. 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.
    12. 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.
    13. 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.
    14. 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.
    15. Maria Mayorga & Hyun-Soo Ahn & Goker Aydin, 2013. "Assortment and inventory decisions with multiple quality levels," Annals of Operations Research, Springer, vol. 211(1), pages 301-331, December.
    16. Patxi J. Bernales & Yongtao Guan & Harihara Prasad Natarajan & Patricia Souza Gimenez & Mario Xavier Alvarez Tajes, 2017. "Less Is More: Harnessing Product Substitution Information to Rationalize SKUs at Intcomex," Interfaces, INFORMS, vol. 47(3), pages 230-243, June.
    17. 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.
    18. Transchel, Sandra, 2017. "Inventory management under price-based and stockout-based substitution," European Journal of Operational Research, Elsevier, vol. 262(3), pages 996-1008.
    19. 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.
    20. 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.

    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:60:y:2014:i:10:p:2401-2415. 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.