IDEAS home Printed from https://ideas.repec.org/a/inm/orinte/v51y2021i1p76-89.html
   My bibliography  Save this article

A Multiobjective Optimization for Clearance in Walmart Brick-and-Mortar Stores

Author

Listed:
  • Yixian Chen

    (Walmart Labs, Sunnyvale, California 94086;)

  • Prakhar Mehrotra

    (Walmart Labs, Sunnyvale, California 94086;)

  • Nitin Kishore Sai Samala

    (Walmart Labs, Sunnyvale, California 94086;)

  • Kamilia Ahmadi

    (Walmart Labs, Sunnyvale, California 94086;)

  • Viresh Jivane

    (Walmart Labs, Sunnyvale, California 94086;)

  • Linsey Pang

    (Walmart Labs, Sunnyvale, California 94086;)

  • Monika Shrivastav

    (Walmart Labs, Sunnyvale, California 94086;)

  • Nate Lyman

    (Walmart, Bentonville, Arkansas 72716)

  • Scott Pleiman

    (Walmart, Bentonville, Arkansas 72716)

Abstract

We developed a novel multiobjective markdown system and deployed it across many merchandising units at Walmart. The objectives of this system are to (1) clear the stores’ excess inventory by a specified date, (2) improve revenue by minimizing the discounts needed to clear shelves, and (3) reduce the substantial cost to relabel merchandise in the stores. The underlying mathematical approach uses techniques such as deep reinforcement learning, simulation, and optimization to determine the optimal (marked-down) price. Starting in 2019, after six months of extensive testing, we implemented the new approach across all Walmart stores in the United States. The result was a high-performance model with a price-adjustment policy tailored to each store. Walmart increased its sell-through rate (i.e., the number of units sold during the markdown period divided by its inventory at the beginning of the markdown) by 21% and reduced its costs by 7%. Benefits that Walmart accrues include demographics-based store personalization, reductions in operating costs with limited numbers of price adjustments, and a dynamic time window for markdowns.

Suggested Citation

  • Yixian Chen & Prakhar Mehrotra & Nitin Kishore Sai Samala & Kamilia Ahmadi & Viresh Jivane & Linsey Pang & Monika Shrivastav & Nate Lyman & Scott Pleiman, 2021. "A Multiobjective Optimization for Clearance in Walmart Brick-and-Mortar Stores," Interfaces, INFORMS, vol. 51(1), pages 76-89, February.
  • Handle: RePEc:inm:orinte:v:51:y:2021:i:1:p:76-89
    DOI: 10.1287/inte.2020.1065
    as

    Download full text from publisher

    File URL: https://doi.org/10.1287/inte.2020.1065
    Download Restriction: no

    File URL: https://libkey.io/10.1287/inte.2020.1065?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. Vincent C. Li & Yat-wah Wan & Chi-Leung Chu & Yi-Cheng Lin, 2020. "A Dynamic Programming-Based Heuristic for Markdown Pricing and Inventory Allocation of a Seasonal Product in a Retail Chain," Asia-Pacific Journal of Operational Research (APJOR), World Scientific Publishing Co. Pte. Ltd., vol. 37(01), pages 1-30, January.
    2. Felipe Caro & Jérémie Gallien, 2012. "Clearance Pricing Optimization for a Fast-Fashion Retailer," Operations Research, INFORMS, vol. 60(6), pages 1404-1422, December.
    3. Suresh P. Sethi & Feng Cheng, 1997. "Optimality of ( s , S ) Policies in Inventory Models with Markovian Demand," Operations Research, INFORMS, vol. 45(6), pages 931-939, December.
    4. Xiaohuan Wang & Zhi-Ping Fan & Zheng Liu, 2016. "Optimal markdown policy of perishable food under the consumer price fairness perception," International Journal of Production Research, Taylor & Francis Journals, vol. 54(19), pages 5811-5828, October.
    5. Dixit, Avinash K., 1990. "Optimization in Economic Theory," OUP Catalogue, Oxford University Press, edition 2, number 9780198772101.
    6. Gérard P. Cachon & A. Gürhan Kök, 2007. "Implementation of the Newsvendor Model with Clearance Pricing: How to (and How Not to) Estimate a Salvage Value," Manufacturing & Service Operations Management, INFORMS, vol. 9(3), pages 276-290, October.
    7. Gupta, Diwakar & Hill, Arthur V. & Bouzdine-Chameeva, Tatiana, 2006. "A pricing model for clearing end-of-season retail inventory," European Journal of Operational Research, Elsevier, vol. 170(2), pages 518-540, April.
    8. Willemain, Thomas R. & Smart, Charles N. & Schwarz, Henry F., 2004. "A new approach to forecasting intermittent demand for service parts inventories," International Journal of Forecasting, Elsevier, vol. 20(3), pages 375-387.
    9. Guang Li & Paat Rusmevichientong & Huseyin Topaloglu, 2015. "The d -Level Nested Logit Model: Assortment and Price Optimization Problems," Operations Research, INFORMS, vol. 63(2), pages 325-342, April.
    10. Guillermo Gallego & Ruxian Wang, 2014. "Multiproduct Price Optimization and Competition Under the Nested Logit Model with Product-Differentiated Price Sensitivities," Operations Research, INFORMS, vol. 62(2), pages 450-461, April.
    11. Stephen A. Smith & Dale D. Achabal, 1998. "Clearance Pricing and Inventory Policies for Retail Chains," Management Science, INFORMS, vol. 44(3), pages 285-300, March.
    12. Kris Johnson Ferreira & Bin Hong Alex Lee & David Simchi-Levi, 2016. "Analytics for an Online Retailer: Demand Forecasting and Price Optimization," Manufacturing & Service Operations Management, INFORMS, vol. 18(1), pages 69-88, 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. Mitra, Subrata, 2018. "Newsvendor problem with clearance pricing," European Journal of Operational Research, Elsevier, vol. 268(1), pages 193-202.
    2. 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.
    3. Avittathur, Balram & Biswas, Indranil, 2017. "A note on limited clearance sale inventory model," International Journal of Production Economics, Elsevier, vol. 193(C), pages 647-653.
    4. James M. Davis & Huseyin Topaloglu & David P. Williamson, 2017. "Pricing Problems Under the Nested Logit Model with a Quality Consistency Constraint," INFORMS Journal on Computing, INFORMS, vol. 29(1), pages 54-76, February.
    5. Ruxian Wang, 2018. "When Prospect Theory Meets Consumer Choice Models: Assortment and Pricing Management with Reference Prices," Manufacturing & Service Operations Management, INFORMS, vol. 20(3), pages 583-600, July.
    6. Vincent C. Li & Yat-wah Wan & Chi-Leung Chu & Yi-Cheng Lin, 2020. "A Dynamic Programming-Based Heuristic for Markdown Pricing and Inventory Allocation of a Seasonal Product in a Retail Chain," Asia-Pacific Journal of Operational Research (APJOR), World Scientific Publishing Co. Pte. Ltd., vol. 37(01), pages 1-30, January.
    7. Joseph Jiaqi Xu & Peter S. Fader & Senthil Veeraraghavan, 2019. "Designing and Evaluating Dynamic Pricing Policies for Major League Baseball Tickets," Service Science, INFORMS, vol. 21(1), pages 121-138, January.
    8. Torsten J. Gerpott & Jan Berends, 2022. "Competitive pricing on online markets: a literature review," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 21(6), pages 596-622, December.
    9. Namin, Aidin & Soysal, Gonca P. & Ratchford, Brian T., 2022. "Alleviating demand uncertainty for seasonal goods: An analysis of attribute-based markdown policy for fashion retailers," Journal of Business Research, Elsevier, vol. 145(C), pages 671-681.
    10. Mehran Ullah & Irfanullah Khan & Biswajit Sarkar, 2019. "Dynamic Pricing in a Multi-Period Newsvendor Under Stochastic Price-Dependent Demand," Mathematics, MDPI, vol. 7(6), pages 1-15, June.
    11. Zhenzhen Yan & Karthik Natarajan & Chung Piaw Teo & Cong Cheng, 2022. "A Representative Consumer Model in Data-Driven Multiproduct Pricing Optimization," Management Science, INFORMS, vol. 68(8), pages 5798-5827, August.
    12. Ruxian Wang & Zizhuo Wang, 2017. "Consumer Choice Models with Endogenous Network Effects," Management Science, INFORMS, vol. 63(11), pages 3944-3960, November.
    13. Nathan C. Craig & Ananth Raman, 2016. "Improving Store Liquidation," Manufacturing & Service Operations Management, INFORMS, vol. 18(1), pages 89-103, February.
    14. Rui Chen & Hai Jiang, 2020. "Capacitated assortment and price optimization under the nested logit model," Journal of Global Optimization, Springer, vol. 77(4), pages 895-918, August.
    15. Fabrice Etilé & Sebastien Lecocq & Christine Boizot-Szantai, 2018. "The Incidence of Soft-Drink Taxes on Consumer Prices and Welfare: Evidence from the French " Soda Tax"," PSE Working Papers halshs-01808198, HAL.
    16. Hongmin Li, 2020. "Optimal Pricing Under Diffusion-Choice Models," Operations Research, INFORMS, vol. 68(1), pages 115-133, January.
    17. Bernardo Bertoldi & Chiara Giachino & Alberto Pastore, 2016. "Strategic pricing management in the omnichannel era," MERCATI & COMPETITIVIT?, FrancoAngeli Editore, vol. 2016(4), pages 131-152.
    18. Victor Martínez‐de‐Albéniz & Arnau Planas & Stefano Nasini, 2020. "Using Clickstream Data to Improve Flash Sales Effectiveness," Production and Operations Management, Production and Operations Management Society, vol. 29(11), pages 2508-2531, November.
    19. Fabrice Etilé & Sébastien Lecocq & Christine Boizot-Szantai, 2021. "Market heterogeneity and the distributional incidence of soft-drink taxes: evidence from France [Regressive sin taxes, with an application to the optimal soda tax]," European Review of Agricultural Economics, Oxford University Press and the European Agricultural and Applied Economics Publications Foundation, vol. 48(4), pages 915-939.
    20. Kris Johnson Ferreira & Bin Hong Alex Lee & David Simchi-Levi, 2016. "Analytics for an Online Retailer: Demand Forecasting and Price Optimization," Manufacturing & Service Operations Management, INFORMS, vol. 18(1), pages 69-88, February.

    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:orinte:v:51:y:2021:i:1:p:76-89. 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.