Interaction between Shelf Layout and Marketing Effectiveness and its Impact on Optimizing Shelf Arrangements

38 Pages Posted: 23 Dec 2006

See all articles by Erjen van Nierop

Erjen van Nierop

Carnegie Mellon University - David A. Tepper School of Business; Erasmus Research Institute of Management (ERIM); Tinbergen Institute

D. Fok

Erasmus Research Institute of Management (ERIM); Econometric Institute - Erasmus University Rotterdam; Tinbergen Institute Rotterdam

Philip Hans Franses

Erasmus University Rotterdam (EUR) - Department of Econometrics

Date Written: March 27, 2006

Abstract

Allocating the proper amount of shelf space to stock keeping units [SKUs] is an increasingly relevant and difficult topic for managers. Shelf space is a scarce resource and it has to be distributed across a larger and larger number of items. It is in particular important because the amount of space allocated to a specific item has a substantial impact on the sales level of that item. This relation between shelf space and sales has been widely documented in the literature. However, besides the amount of space, the exact location of the SKU on the shelf is also an important moderator of sales. At the same time, the effectiveness of marketing instruments of an SKU may also depend on the shelf layout. In practice, retailers recognize that these dependencies exist. However, they often revert to rules of thumb to actually arrange their shelf layout. We propose a new model to optimize shelf arrangements in which we use a complete set of shelf descriptors. The goal of the paper is twofold. First of all, we aim to gain insight into the dependencies of SKU sales and SKU marketing effectiveness on the shelf layout. Second, we use these insights to improve the shelf layout in a practical setting. The basis of our model is a standard sales equation that explains sales from item-specific marketing-effect parameters and intercepts. In a Hierarchical Bayes fashion, we augment this model with a second equation that relates the effect parameters to shelf and SKU descriptors. We estimate the parameters of the two-level model using Bayesian methodology, in particular Gibbs sampling. Next, we optimize the total profit over the shelf arrangement. Using the posterior draws from our Gibbs sampling algorithm, we can generate the probability distribution of sales and profit in the optimization period for any feasible shelf arrangement. To find the optimal shelf arrangement, we use simulated annealing. This heuristic approach has proven to be able to effectively search an enormous solution space. Our results indicate that our model is able to fit and forecast the sales levels quite accurately. Next, when applying the simulated annealing algorithm to the shelf layout, we appear to be able to increase profits for all the stores analyzed. We compare our approach to commonly used shelf optimization rules of thumb. Most sensible rules of thumb also increase expected profits (although not as much as our optimization algorithm). In particular, it is beneficial to put high-margin items close to the beginning of the aisle (or the “racetrack"). Finally, we provide managerial implications and directions for further research.

Keywords: Markov Chain Monte Carlo, Hierarchical Bayes, Sales Models, Shelf Management, Simulated Annealing

Suggested Citation

van Nierop, Erjen and Fok, Dennis and Fok, Dennis and Franses, Philip Hans, Interaction between Shelf Layout and Marketing Effectiveness and its Impact on Optimizing Shelf Arrangements (March 27, 2006). ERIM Report Series Reference No. ERS-2006-013-MKT, Available at SSRN: https://ssrn.com/abstract=902742

Erjen Van Nierop (Contact Author)

Carnegie Mellon University - David A. Tepper School of Business ( email )

5000 Forbes Avenue
Pittsburgh, PA 15213-3890
United States

Erasmus Research Institute of Management (ERIM)

P.O. Box 1738
3000 DR Rotterdam
Netherlands

Tinbergen Institute ( email )

P.O. Box 1738
3000 DR Rotterdam
Netherlands

Dennis Fok

Erasmus Research Institute of Management (ERIM) ( email )

P.O. Box 1738
3000 DR Rotterdam
Netherlands
+31 10 408 1333 (Phone)
+31 10 408 9162 (Fax)

Econometric Institute - Erasmus University Rotterdam ( email )

P.O. Box 1738
3000 DR Rotterdam
Netherlands

Tinbergen Institute Rotterdam ( email )

P.O. Box 1738
3000 DR Rotterdam
Netherlands

Philip Hans Franses

Erasmus University Rotterdam (EUR) - Department of Econometrics ( email )

P.O. Box 1738
3000 DR Rotterdam
Netherlands
+31 10 408 1278 (Phone)
+31 10 408 9162 (Fax)