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. 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.
    2. 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.
    3. 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.
    4. 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.
    5. 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.
    6. 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.
    7. 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.
    8. 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.
    9. 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.
    10. 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.
    11. Dixit, Avinash K., 1990. "Optimization in Economic Theory," OUP Catalogue, Oxford University Press, edition 2, number 9780198772101.
    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. 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.
    3. 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.
    4. 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.
    5. 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.
    6. 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.
    7. 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.
    8. 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.
    9. Borga Deniz, 2012. "Inventory Control with Advance Demand Information When Demand is Intermittent," Business and Management Research, Business and Management Research, Sciedu Press, vol. 1(4), pages 35-45, December.
    10. 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.
    11. Hekimoğlu, Mustafa & Sevim, Ismail & Aksezer, Çağlar & Durmuş, İpek, 2019. "Assortment optimization with log-linear demand: Application at a Turkish grocery store," Journal of Retailing and Consumer Services, Elsevier, vol. 50(C), pages 199-214.
    12. 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.
    13. 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.
    14. Ruxian Wang & Zizhuo Wang, 2017. "Consumer Choice Models with Endogenous Network Effects," Management Science, INFORMS, vol. 63(11), pages 3944-3960, November.
    15. Nathan C. Craig & Ananth Raman, 2016. "Improving Store Liquidation," Manufacturing & Service Operations Management, INFORMS, vol. 18(1), pages 89-103, February.
    16. 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.
    17. Rainer Schlosser, 2016. "Stochastic dynamic multi-product pricing with dynamic advertising and adoption effects," Journal of Revenue and Pricing Management, Palgrave Macmillan, vol. 15(2), pages 153-169, April.
    18. 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.
    19. Hongmin Li, 2020. "Optimal Pricing Under Diffusion-Choice Models," Operations Research, INFORMS, vol. 68(1), pages 115-133, January.
    20. Bernardo Bertoldi & Chiara Giachino & Alberto Pastore, 2016. "Strategic pricing management in the omnichannel era," MERCATI & COMPETITIVIT?, FrancoAngeli Editore, vol. 2016(4), pages 131-152.

    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.