Should Only Popular Products Be Stocked? Warehouse Assortment Selection for E-Commerce Companies

Manufacturing & Service Operations Management

49 Pages Posted: 13 Sep 2022 Last revised: 19 Apr 2024

See all articles by Xiaobo Li

Xiaobo Li

National University of Singapore

Hongyuan Lin

University of Science and Technology of China (USTC)

Fang Liu

Durham University Business School

Date Written: September 7, 2022

Abstract

Problem definition: This paper studies the single-warehouse assortment selection problem that aims to minimize the order fulfillment cost under the cardinality constraint. We propose two fulfillment-related cost functions corresponding to spillover fulfillment and order-splitting, respectively. This problem includes the fill rate maximization problem as a special case. We show that although the objective function is submodular for a broad class of cost functions, the fill rate maximization problem with the largest order size being two is NP- hard.

Methodology: To make the problem tractable to solve, we formulate the general warehouse assortment problem under the two types of cost functions as mixed integer linear programs (MILPs). We also provide a dynamic programming algorithm to solve the problem in polynomial time if orders are non-overlapping. Furthermore, we propose a simple heuristic called the marginal choice indexing (MCI) policy that allows the warehouse to store the most popular products. This policy is easy to compute and hence is scalable to large-size problems. Although the performance of MCI can be arbitrarily bad in some extreme scenarios, we find a general condition under which it is optimal. This condition is satisfied by many multi-purchase choice models.

Managerial implications: Through extensive numerical experiments on a real-world dataset from RiRiShun Logistics, we find that the MCI policy is surprisingly near-optimal in all the settings we tested. Simply applying the MCI policy, the fill rate is estimated to improve by 9.18% on average compared to the current practice for the local transfer centers (LTCs) on the training data set. More surprisingly, the MCI policy outperforms the MILP optimal solution in 14 out of 25 cases on the test data set, illustrating its robustness against demand fluctuations.

Keywords: warehouse assortment selection, demand choice models, submodular functions, marginal choice probability

Suggested Citation

Li, Xiaobo and Lin, Hongyuan and Liu, Fang, Should Only Popular Products Be Stocked? Warehouse Assortment Selection for E-Commerce Companies (September 7, 2022). Manufacturing & Service Operations Management, Available at SSRN: https://ssrn.com/abstract=4212027 or http://dx.doi.org/10.2139/ssrn.4212027

Xiaobo Li

National University of Singapore ( email )

10 Kent Ridge Crescent
Singapore, 115260
Singapore

Hongyuan Lin (Contact Author)

University of Science and Technology of China (USTC) ( email )

96, Jinzhai Road
Hefei, Anhui 230026
China

HOME PAGE: http://bs.ustc.edu.cn/chinese/profile-2335.html

Fang Liu

Durham University Business School ( email )

Mill Hill Lane
Durham, DH1 3LB
United Kingdom

Do you have a job opening that you would like to promote on SSRN?

Paper statistics

Downloads
392
Abstract Views
1,366
Rank
152,479
PlumX Metrics