Optimizing Retail Assortments

Retailers face the problem of finding the assortment that maximizes category profit. This is a challenging task because the number of potential assortments is very large when there are many stock-keeping units SKUs to choose from. Moreover, SKU sales can be cannibalized by other SKUs in the assortment, and the more similar SKUs are, the more this happens. This paper develops an implementable and scalable assortment optimization method that allows for theory-based substitution patterns and optimizes real-life, large-scale assortments at the store level. We achieve this by adopting an attribute-based approach to capture preferences, substitution patterns, and cross-marketing mix effects. To solve the optimization problem, we propose new very large neighborhood search heuristics. We apply our methodology to store-level scanner data on liquid laundry detergent. The optimal assortments are expected to enhance retailer profit considerably 37.3%, and this profit increases even more to 43.7% when SKU prices are optimized simultaneously.

[1]  Peter E. Rossi,et al.  Bayesian Statistics and Marketing , 2005 .

[2]  Robert C. Blattberg,et al.  Shrinkage Estimation of Price and Promotional Elasticities: Seemingly Unrelated Equations , 1991 .

[3]  Carl F. Mela,et al.  The Dynamic Effect of Innovation on Market Structure , 2004 .

[4]  Koen Pauwels,et al.  Winners and Losers in a Major Price War , 2008 .

[5]  D. W. Goodall.  A New Similarity Index Based on Probability , 1966 .

[6]  Edward J. Fox,et al.  Why is Assortment Planning so Difficult for Retailers? A Framework and Research Agenda , 2009 .

[7]  Peter E. Rossi,et al.  A Bayesian analysis of the multinomial probit model with fully identified parameters , 2000 .

[8]  A. Tversky.  Elimination by aspects: A theory of choice. , 1972 .

[9]  M. Fisher,et al.  Assortment Planning: Review of Literature and Industry Practice , 2008 .

[10]  Dick R. Wittink,et al.  Decomposing the Sales Promotion Bump with Store Data , 2004 .

[11]  Joshua D. Angrist,et al.  Mostly Harmless Econometrics: An Empiricist's Companion , 2008 .

[12]  Marshall L. Fisher,et al.  Demand Estimation and Assortment Optimization Under Substitution: Methodology and Application , 2007, Oper. Res..

[13]  Aviv Nevo.  A Practitioner's Guide to Estimation of Random‐Coefficients Logit Models of Demand , 2000 .

[14]  Darrell K. Rigby,et al.  Localization--the revolution in consumer markets. , 2006, Harvard business review.

[15]  Ioannis Ioannou,et al.  The Effects of Capacity on Sales Under Alternative Vertical Contracts , 2008 .

[16]  P. Verhoef,et al.  The Short- and Long-Term Impact of an Assortment Reduction on Category Sales , 2006 .

[17]  Aviv Nevo.  Measuring Market Power in the Ready-to-Eat Cereal Industry , 1998 .

[18]  Edward J. Fox,et al.  Consumer Shopping and Spending across Retail Formats , 2004 .

[19]  S. Axsäter.  Using the deterministic EOQ formula in stochastic inventory control , 1996 .

[20]  Pradeep K. Chintagunta,et al.  Endogeneity and Heterogeneity in a Probit Demand Model: Estimation Using Aggregate Data , 2001 .

[21]  Fred M. Feinberg,et al.  Reality Check: Combining Choice Experiments with Market Data to Estimate the Importance of Product Attributes , 2010, Manag. Sci..

[22]  Christopher M. Miller,et al.  Optimizing and Evaluating Retail Assortments for Infrequently Purchased Products , 2010 .

[23]  Leigh McAlister,et al.  Consumers’ Perceptions of the Assortment Offered in a Grocery Category: The Impact of Item Reduction: , 1998 .

[24]  Pradeep Chintagunta,et al.  Structural Workshop Paper - Discrete-Choice Models of Consumer Demand in Marketing , 2011, Mark. Sci..

[25]  P. Naert,et al.  SH.A.R.P.: Shelf Allocation for Retailers' Profit , 1988 .

[26]  Bradley P. Carlin,et al.  Bayesian measures of model complexity and fit , 2002 .

[27]  Ashish Sinha,et al.  Practice Prize Paper - Category Optimizer: A Dynamic-Assortment, New-Product-Introduction, Mix-Optimization, and Demand-Planning System , 2013, Mark. Sci..

[28]  Peter Boatwright,et al.  Reducing Assortment: An Attribute-Based Approach , 2001 .

[29]  Christopher S. Tang,et al.  A Modeling Framework for Category Assortment Planning , 2001, Manuf. Serv. Oper. Manag..

[30]  A Parducci,et al.  The category effect with rating scales: number of categories, number of stimuli, and method of presentation. , 1986, Journal of experimental psychology. Human perception and performance.

[31]  Timothy L. Urban.  An inventory-theoretic approach to product assortment and shelf-space allocation , 1998 .

[32]  Lee G. Cooper,et al.  Standardizing Variables in Multiplicative Choice Models , 1983 .

[33]  Harald J. van Heerde,et al.  Similarity-Based Spatial Methods to Estimate Shelf Space Elasticities , 2004 .

[34]  Peter E. Rossi,et al.  Bayesian Statistics and Marketing: Rossi/Bayesian Statistics and Marketing , 2006 .

[35]  Sunil Gupta,et al.  Commercial Use of UPC Scanner Data: Industry and Academic Perspectives , 1999 .

[36]  Bart J. Bronnenberg,et al.  Tilburg University An empirical analysis of assortment similarities across U . S . supermarkets , 2010 .

[37]  Lee G. Cooper,et al.  Voting for a Political Candidate Under Conditions of Minimal Information , 1974 .

[38]  A. Parducci.  Category judgment: a range-frequency model. , 1965, Psychological review.

[39]  Paul Farris,et al.  A sensitivity analysis of retailer shelf management models , 1995 .

[40]  Bart J. Bronnenberg,et al.  Estimating Demand Heterogeneity Using Aggregated Data: An Application to the Frozen Pizza Category , 2009, Mark. Sci..

[41]  Peter E. Rossi,et al.  A Bayesian Approach to Estimating Household Parameters , 1993 .

[42]  Christopher M. Miller,et al.  The selection and pricing of retail assortments: an empirical approach , 1999 .

[43]  Els Gijsbrechts,et al.  Should retailers adjust their micro-marketing strategies to type of outlet? An application to location-based store space allocation in limited and full-service grocery stores , 2004 .

[44]  Kusum L. Ailawadi,et al.  An Empirical Analysis of the Determinants of Retail Margins: The Role of Store-Brand Share , 2004 .

[45]  Joffre Swait,et al.  Enriching Scanner Panel Models with Choice Experiments , 2003 .

[46]  Stephen J. Hoch,et al.  Shelf management and space elasticity , 1994 .

[47]  K. Lancaster,et al.  Consumer Demand. A New Approach. , 1972 .

[48]  Joseph C. Nunes,et al.  The Effect of Product Assortment Changes on Customer Retention , 2005 .

[49]  P. Farris,et al.  A Model for Determining Retail Product Category Assortment and Shelf Space Allocation , 1994 .

[50]  Dennis Fok,et al.  Interaction Between Shelf Layout and Marketing Effectiveness and Its Impact on Optimizing Shelf Arrangements , 2006, Mark. Sci..

[51]  Robert E. McCulloch,et al.  Account-Level Modeling for Trade Promotion: An Application of a Constrained Parameter Hierarchical Model , 1999 .

[52]  Carl F. Mela,et al.  Consumer Packaged Goods in France: National Brands, Regional Chains, and Local Branding , 2007 .

[53]  Yu-Sheng Zheng.  On properties of stochastic inventory systems , 1992 .

[54]  Peter E. Rossi,et al.  Determinants of Store-Level Price Elasticity , 1995 .

[55]  Tammo H. A. Bijmolt,et al.  New Empirical Generalizations on the Determinants of Price Elasticity , 2005 .

[56]  Narendra Agrawal,et al.  Management of Multi-Item Retail Inventory Systems with Demand Substitution , 2000, Oper. Res..

[57]  J. Sample,et al.  Attitude and Prediction of Behavior , 1973 .

[58]  Peter S. Fader,et al.  Modeling Consumer Choice among SKUs , 1996 .

[59]  Tammo H. A. Bijmolt,et al.  Incorporating Context Effects into a Choice Model , 2010 .

[60]  Ann Verhetsel,et al.  The impact of location factors on the attractiveness and optimal space shares of product categories , 2000 .

[61]  Garrett J. van Ryzin,et al.  Stocking Retail Assortments Under Dynamic Consumer Substitution , 2001, Oper. Res..

[62]  A. Montgomery.  Creating Micro-Marketing Pricing Strategies Using Supermarket Scanner Data , 1997 .

[63]  Abraham P. Punnen,et al.  A survey of very large-scale neighborhood search techniques , 2002, Discret. Appl. Math..