A Modeling Framework for Category Assortment Planning

The complexity of managing a category assortment has grown tremendously in recent years due to the increased product turnover and proliferation rates in most categories. It is an increasingly difficult task for managers to find an effective assortment due to uncertain consumer preferences and the exponential number of possible assortments. This paper presents an empirically based modeling framework for managers to assess the revenue and lost sales implication of alternative category assortments. Coupled with a local improvement heuristic, the modeling framework generates an alternative category assortment with higher revenue.This framework, which consists of a category-purchase-incidence model and a brand-share model, is calibrated and validated using 60,000 shopping trips and purchase records. Specifically, the purchase-incidence model predicts the probability of an individual customer who purchases (and who does not purchase) from a given product category during a shopping trip. The no-purchase probability enables us to estimate lost sales due to assortment changes in the category. The brand-share model predicts which brand the customer chooses if a purchase incidence occurs in the category. Our brand-share model extends the classical Guadagni and Little model (1983) by utilizing three new brand-width measures that quantify the similarities among products of different brands within the same category.We illustrate how our modeling framework is used to reconfigure the category assortment in eight food categories for five stores in our data set. This reconfiguration exercise shows that a reconfigured category assortment can have a profit improvement of up to 25.1% with 32 products replaced. We also demonstrate how our modeling framework can be used to gauge lost sales due to assortment changes. We find the level of lost sales could range from 0.9% to 10.2% for a period of 26 weeks.

[1]  S. Grossberg,et al.  Psychological Review , 2003 .

[2]  D. McFadden Conditional logit analysis of qualitative choice behavior , 1972 .

[3]  P. K. Kannan,et al.  Modeling and Testing Structured Markets: A Nested Logit Approach , 1991 .

[4]  安川 文明,et al.  予防歯科プログラムの選考に関する Discrete Choice Analysis , 2002 .

[5]  Marshall L. Fisher,et al.  Strategies for Product Variety: Lessons From the Auto Industry , 1995 .

[6]  W. W. Muir,et al.  Regression Diagnostics: Identifying Influential Data and Sources of Collinearity , 1980 .

[7]  Pradeep K. Chintagunta,et al.  Investigating Purchase Incidence, Brand Choice and Purchase Quantity Decisions of Households , 1993 .

[8]  David A. Belsley,et al.  Regression Analysis and its Application: A Data-Oriented Approach.@@@Applied Linear Regression.@@@Regression Diagnostics: Identifying Influential Data and Sources of Collinearity , 1981 .

[9]  Marshall L. Fisher,et al.  Supply Chain Inventory Management and the Value of Shared Information , 2000 .

[10]  John A. Quelch,et al.  Extend Profits, Not Product Lines , 1994 .

[11]  J. Chiang A Simultaneous Approach to the Whether, What and How Much to Buy Questions , 1991 .

[12]  Wagner A. Kamakura,et al.  A Parsimonious Model of SKU Choice: Familiarity-based Reinforcement and Response Sensitivity , 1999 .

[13]  Christopher S. Tang,et al.  The Value of Information Sharing in a Two-Level Supply Chain , 2000 .

[14]  Eric T. Bradlow,et al.  The Variety of an Assortment , 1999 .

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

[16]  Marshall L. Fisher,et al.  The Impact of Product Variety on Automobile Assembly Operations: Empirical Evidence and Simulation Analysis , 1999 .

[17]  Donald R. Lehmann,et al.  Hierarchical representations of market structures and choice processes through preference trees , 1986 .

[18]  B. Kahn Variety: From the Consumer’s Perspective , 1998 .

[19]  Christopher S. Tang,et al.  Product variety management : research advances , 1998 .

[20]  A. Taudes,et al.  A Multivariate Polya Model of Brand Choice and Purchase Incidence , 1986 .