Item Aggregation and Column Generation for Online-Retail Inventory Placement

33 Pages Posted: 15 Oct 2019

See all articles by Annie Chen

Annie Chen

University of Southern California - Data Sciences and Operations

Stephen C. Graves

Massachusetts Institute of Technology (MIT) - Sloan School of Management

Date Written: October 1, 2019

Abstract

1. Problem Definition: This paper studies an online retailer's problem of choosing fulfillment centers in which to place items. We formulate the problem as a mixed-integer program that models thousands or millions of items to be placed in dozens of fulfillment centers and shipped to dozens of customer regions. The objective is to minimize the sum of shipping and fixed costs over one planning period.

2. Academic/Practical Relevance: A good placement plan can significantly reduce the operational cost, which is crucial for online retail businesses because they often have a low profit margin. The placement problem can be difficult to solve with existing techniques or off-the-shelf software, due to the large number of items and the fulfillment center fixed costs and capacity constraints.

3. Methodology: We propose a large-scale optimization framework that aggregates items into clusters, solves the cluster-level problem with column generation, and disaggregates the solution into item-level placement plans. We develop an a priori bound on the optimality gap, and also apply the framework to a numerical example that consists of 1,000,000 items.

4. Results: The a priori bound provides insights on how to select the appropriate aggregation criteria. For the numerical example, our framework produces a near-optimal solution in a few hours, significantly outperforming a sequential placement heuristic that approximates the status quo.

5. Managerial Implications: Our study provides a computationally efficient approach for solving online-retail inventory placement as well as similar large-scale optimization problems in practice.

Keywords: online retail; inventory placement; column generation; aggregation

Suggested Citation

Chen, Annie and Graves, Stephen C., Item Aggregation and Column Generation for Online-Retail Inventory Placement (October 1, 2019). Available at SSRN: https://ssrn.com/abstract=3464278 or http://dx.doi.org/10.2139/ssrn.3464278

Annie Chen

University of Southern California - Data Sciences and Operations ( email )

701 Exposition Blvd
Los Angeles, CA
United States

Stephen C. Graves (Contact Author)

Massachusetts Institute of Technology (MIT) - Sloan School of Management ( email )

E62-579
77 Massachusetts Avenue
Cambridge, MA MA 02139
United States
617-253-6602 (Phone)
617-253-1462 (Fax)

HOME PAGE: http://web.mit.edu/sgraves/www/

Do you have negative results from your research you’d like to share?

Paper statistics

Downloads
250
Abstract Views
1,329
Rank
222,563
PlumX Metrics