IDEAS home Printed from https://ideas.repec.org/a/inm/ormksc/v32y2013i5p699-715.html
   My bibliography  Save this article

Optimizing Retail Assortments

Author

Listed:
  • Robert P. Rooderkerk

    (TiasNimbas Business School and Tilburg School of Economics and Management, Tilburg University, 5000 LE Tilburg, The Netherlands; and Tuck School of Business at Dartmouth, Hanover, New Hampshire 03755)

  • Harald J. van Heerde

    (School of Communication, Journalism, and Marketing, Massey University, Auckland 0745, New Zealand; and CentER, Tilburg University, 5000 LE Tilburg, The Netherlands)

  • Tammo H. A. Bijmolt

    (Faculty of Economics and Business, University of Groningen, 9700 AB Groningen, The Netherlands)

Abstract

Retailers face the problem of finding the assortment that maximizes category profit. This is a challenging task because the number of potential assortments is very large when there are many stock-keeping units (SKUs) to choose from. Moreover, SKU sales can be cannibalized by other SKUs in the assortment, and the more similar SKUs are, the more this happens. This paper develops an implementable and scalable assortment optimization method that allows for theory-based substitution patterns and optimizes real-life, large-scale assortments at the store level. We achieve this by adopting an attribute-based approach to capture preferences, substitution patterns, and cross-marketing mix effects. To solve the optimization problem, we propose new very large neighborhood search heuristics. We apply our methodology to store-level scanner data on liquid laundry detergent. The optimal assortments are expected to enhance retailer profit considerably (37.3%), and this profit increases even more (to 43.7%) when SKU prices are optimized simultaneously.

Suggested Citation

  • Robert P. Rooderkerk & Harald J. van Heerde & Tammo H. A. Bijmolt, 2013. "Optimizing Retail Assortments," Marketing Science, INFORMS, vol. 32(5), pages 699-715, September.
    • Handle: RePEc:inm:ormksc:v:32:y:2013:i:5:p:699-715
    DOI: 10.1287/mksc.2013.0800
    as

    Download full text from publisher

    File URL: http://dx.doi.org/10.1287/mksc.2013.0800
    Download Restriction: no
    File URL: https://libkey.io/10.1287/mksc.2013.0800?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. CAMPO, Katia & GIJSBRECHTS, Els & GOOSSENS, T. & VERHETSEL, Ann, "undated". "The impact of location-specific factors on attractiveness and performance of product categories," Working Papers 1999012, University of Antwerp, Faculty of Business and Economics.
    2. Nakanishi, Masao & Cooper, Lee G & Kassarjian, Harold H, 1974. "Voting for a Political Candidate under Conditions of Minimal Information," Journal of Consumer Research, Journal of Consumer Research Inc., vol. 1(2), pages 36-43, Se.
    3. 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.
    4. Nevo, Aviv, 2001. "Measuring Market Power in the Ready-to-Eat Cereal Industry," Econometrica, Econometric Society, vol. 69(2), pages 307-342, March.
    5. Cooper, Lee G & Nakanishi, Masao, 1983. "Standardizing Variables in Multiplicative Choice Models," Journal of Consumer Research, Journal of Consumer Research Inc., vol. 10(1), pages 96-108, June.
    6. 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.
    7. Erjen van Nierop & Dennis Fok & Philip Hans Franses, 2008. "Interaction Between Shelf Layout and Marketing Effectiveness and Its Impact on Optimizing Shelf Arrangements," Marketing Science, INFORMS, vol. 27(6), pages 1065-1082, 11-12.
    8. Pradeep K. Chintagunta & Harikesh S. Nair, 2011. "Structural Workshop Paper --Discrete-Choice Models of Consumer Demand in Marketing," Marketing Science, INFORMS, vol. 30(6), pages 977-996, November.
    9. Paulo Albuquerque & Bart J. Bronnenberg, 2009. "Estimating Demand Heterogeneity Using Aggregated Data: An Application to the Frozen Pizza Category," Marketing Science, INFORMS, vol. 28(2), pages 356-372, 03-04.
    10. Alan L. Montgomery, 1997. "Creating Micro-Marketing Pricing Strategies Using Supermarket Scanner Data," Marketing Science, INFORMS, vol. 16(4), pages 315-337.
    11. Eleanor McDonnell Feit & Mark A. Beltramo & Fred M. Feinberg, 2010. "Reality Check: Combining Choice Experiments with Market Data to Estimate the Importance of Product Attributes," Management Science, INFORMS, vol. 56(5), pages 785-800, May.
    12. Joshua D. Angrist & Jörn-Steffen Pischke, 2009. "Mostly Harmless Econometrics: An Empiricist's Companion," Economics Books, Princeton University Press, edition 1, number 8769.
    13. Harald J. van Heerde & Peter S. H. Leeflang & Dick R. Wittink, 2004. "Decomposing the Sales Promotion Bump with Store Data," Marketing Science, INFORMS, vol. 23(3), pages 317-334, December.
    14. Ioannis Ioannou & Julie Holland Mortimer & Richard Mortimer, 2011. "The Effects Of Capacity On Sales Under Alternative Vertical Contracts," Journal of Industrial Economics, Wiley Blackwell, vol. 59(1), pages 117-154, March.
    15. Joffre Swait & Rick L. Andrews, 2003. "Enriching Scanner Panel Models with Choice Experiments," Marketing Science, INFORMS, vol. 22(4), pages 442-460, September.
    16. Sharad Borle & Peter Boatwright & Joseph B. Kadane & Joseph C. Nunes & Shmueli Galit, 2005. "The Effect of Product Assortment Changes on Customer Retention," Marketing Science, INFORMS, vol. 24(4), pages 616-622, July.
    17. Minha Hwang & Bart J. Bronnenberg & Raphael Thomadsen, 2010. "An Empirical Analysis of Assortment Similarities Across U.S. Supermarkets," Marketing Science, INFORMS, vol. 29(5), pages 858-879, 09-10.
    18. 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.
    19. David J. Spiegelhalter & Nicola G. Best & Bradley P. Carlin & Angelika Van Der Linde, 2002. "Bayesian measures of model complexity and fit," Journal of the Royal Statistical Society Series B, Royal Statistical Society, vol. 64(4), pages 583-639, October.
    20. Randolph E. Bucklin & Sunil Gupta, 1999. "Commercial Use of UPC Scanner Data: Industry and Academic Perspectives," Marketing Science, INFORMS, vol. 18(3), pages 247-273.
    21. Yu-Sheng Zheng, 1992. "On Properties of Stochastic Inventory Systems," Management Science, INFORMS, vol. 38(1), pages 87-103, January.
    22. 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.
    23. Ashish Sinha & Anna Sahgal & Sharat K. Mathur, 2013. "Practice Prize Paper ---Category Optimizer: A Dynamic-Assortment, New-Product-Introduction, Mix-Optimization, and Demand-Planning System," Marketing Science, INFORMS, vol. 32(2), pages 221-228, March.
    24. Pradeep K. Chintagunta, 2001. "Endogeneity and Heterogeneity in a Probit Demand Model: Estimation Using Aggregate Data," Marketing Science, INFORMS, vol. 20(4), pages 442-456, December.
    25. Siddharth Mahajan & Garrett van Ryzin, 2001. "Stocking Retail Assortments Under Dynamic Consumer Substitution," Operations Research, INFORMS, vol. 49(3), pages 334-351, June.
    26. Mantrala, Murali K. & Levy, Michael & Kahn, Barbara E. & Fox, Edward J. & Gaidarev, Peter & Dankworth, Bill & Shah, Denish, 2009. "Why is Assortment Planning so Difficult for Retailers? A Framework and Research Agenda," Journal of Retailing, Elsevier, vol. 85(1), pages 71-83.
    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. 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. 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.
    4. 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.
    5. 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.
    6. 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.
    7. 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.
    8. 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.
    9. 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).
    10. Hense, Jonas & Hübner, Alexander, 2022. "Assortment optimization in omni-channel retailing," European Journal of Operational Research, Elsevier, vol. 301(1), pages 124-140.
    11. Gielens, Katrijn & Gijsbrechts, Els & Dekimpe, Marnik G., 2014. "Gains and losses of exclusivity in grocery retailing," International Journal of Research in Marketing, Elsevier, vol. 31(3), pages 239-252.
    12. Çö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.
    13. Çö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).
    14. Çö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.
    15. Stelios Tsafarakis & Charalampos Saridakis & Nikolaos Matsatsinis & George Baltas, 2016. "Private labels and retail assortment planning: a differential evolution approach," Annals of Operations Research, Springer, vol. 247(2), pages 677-692, December.
    16. 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.
    17. Minha Hwang & Bart J. Bronnenberg & Raphael Thomadsen, 2010. "An Empirical Analysis of Assortment Similarities Across U.S. Supermarkets," Marketing Science, INFORMS, vol. 29(5), pages 858-879, 09-10.
    18. 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.
    19. 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.
    20. Keun Hee Lee & Mali Abdollahian & Sergei Schreider & Sona Taheri, 2023. "Supply Chain Demand Forecasting and Price Optimisation Models with Substitution Effect," Mathematics, MDPI, vol. 11(11), pages 1-28, May.

    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:ormksc:v:32:y:2013:i:5:p:699-715. 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.