Demand Estimation and Assortment Optimization Under Substitution: Methodology and Application

Authors:
A. Gürhan Kök;Marshall L. Fisher
Affiliations:
Fuqua School of Business, Duke University, Durham, North Carolina 27708;The Wharton School, University of Pennsylvania, Philadelphia, Pennsylvania 19104
Venue:
Operations Research
Year:
2007

Citing 0
Cited 10

Dynamic Pricing and Inventory Control of Substitute Products

Manufacturing & Service Operations Management
OR FORUM--Rocket Science Retailing: The 2006 Philip McCord Morse Lecture

Operations Research
Structural Estimation of the Effect of Out-of-Stocks

Management Science
An Empirical Analysis of Assortment Similarities Across U.S. Supermarkets

Marketing Science
Assortment Planning and Inventory Decisions Under Stockout-Based Substitution

Operations Research
The Role of Component Commonality in Product Assortment Decisions

Manufacturing & Service Operations Management
Optimal and Competitive Assortments with Endogenous Pricing Under Hierarchical Consumer Choice Models

Management Science
Estimating Primary Demand for Substitutable Products from Sales Transaction Data

Operations Research
Practice Prize Paper---Category Optimizer: A Dynamic-Assortment, New-Product-Introduction, Mix-Optimization, and Demand-Planning System

Marketing Science
Optimizing Retail Assortments

Marketing Science

Quantified Score

Hi-index	0.00

Visualization

Abstract

Assortment planning at a retailer entails both selecting the set of products to be carried and setting inventory levels for each product. We study an assortment planning model in which consumers might accept substitutes when their favorite product is unavailable. We develop an algorithmic process to help retailers compute the best assortment for each store. First, we present a procedure for estimating the parameters of substitution behavior and demand for products in each store, including the products that have not been previously carried in that store. Second, we propose an iterative optimization heuristic for solving the assortment planning problem. In a computational study, we find that its solutions, on average, are within 0.5% of the optimal solution. Third, we establish new structural properties (based on the heuristic solution) that relate the products included in the assortment and their inventory levels to product characteristics such as gross margin, case-pack sizes, and demand variability. We applied our method at Albert Heijn, a supermarket chain in The Netherlands. Comparing the recommendations of our system with the existing assortments suggests a more than 50% increase in profits.