IDEAS home Printed from https://ideas.repec.org/a/inm/orinte/v51y2021i1p76-89.html

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. 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.
    3. Dixit, Avinash K., 1990. "Optimization in Economic Theory," OUP Catalogue, Oxford University Press, edition 2, number 9780198772101.
    4. 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.
    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. 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.
    7. 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.
    8. 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.
    9. 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.
    10. 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.
    11. 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.
    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. Victor Martínez-de-Albéniz & Catarina Pinto & Pedro Amorim, 2022. "Driving Supply to Marketplaces: Optimal Platform Pricing When Suppliers Share Inventory," Manufacturing & Service Operations Management, INFORMS, vol. 24(4), pages 2367-2386, July.
    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. 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.
    6. 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.
    7. Alex Tschan & Lars Hetzel & Ralf Eisinger & Carolin Eggen & Claudia Heuser & Victoria Fritz, 2025. "Data-Driven Inventory Control and Integrated Employee Involvement for Special Buys at ALDI SÜD Germany," Interfaces, INFORMS, vol. 55(1), pages 22-35, January.
    8. Hikima, Yuya & Takeda, Akiko, 2025. "Stochastic approach for price optimization problems with decision-dependent uncertainty," European Journal of Operational Research, Elsevier, vol. 322(2), pages 541-553.
    9. 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.
    10. 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.
    11. 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.
    12. Ningyuan Chen & Andre A. Cire & Ming Hu & Saman Lagzi, 2023. "Model-Free Assortment Pricing with Transaction Data," Management Science, INFORMS, vol. 69(10), pages 5830-5847, October.
    13. 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.
    14. 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.
    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. 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.
    17. Yi-Chun Akchen & Felipe Caro, 2026. "On Size Substitution and Its Role in Assortment and Inventory Planning," Manufacturing & Service Operations Management, INFORMS, vol. 28(2), pages 624-642, March.
    18. 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.
    19. Omar Besbes & Adam N. Elmachtoub & Yunjie Sun, 2020. "Pricing Analytics for Rotable Spare Parts," Interfaces, INFORMS, vol. 50(5), pages 313-324, September.
    20. Ikeda, Shunnosuke & Nishimura, Naoki & Sukegawa, Noriyoshi & Takano, Yuichi, 2023. "Prescriptive price optimization using optimal regression trees," Operations Research Perspectives, Elsevier, vol. 11(C).

    More about this item

    Keywords

    ;
    ;
    ;
    ;
    ;

    Statistics

    Access and download statistics

    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.