Product Assortment Decisions for a Network of Retail Stores using Data Mining with Optimization

Sudip Bhattacharjee, Fidan Boylu, Ram Gopal

Abstract

This paper presents a model for product assortment optimization for a network of retail stores operating in various locations of a company. Driven by the local market information of each retail store, the model determines the right products to include in a store’s assortment and which stores to ship from in the store network. The model first learns the global patterns of the frequent itemsets based on association rule mining to extract patterns of products with corresponding sales benefits. It then encodes the pattern information into the development of a global optimization formulation, which maximizes the revenue of the company in aggregate and identifies the optimal solution for each local store by taking into account the possibility of shipments in the network. We use the transactional level data from an industry leading plastics manufacturer and retailer in the United States to demonstrate the utility of the model.

References

  1. Agarwal, R., Imielinski, T., Swami, A., 1993, Mining association Rules Between Sets of Items in massive databases, Proceedings of the ACM/SIGMOD International Conference on Management of Data, pp. 207-216
  2. Agrawal, R., Srikant. R. (1994) Fast algorithms for mining association rules. Proceedings of the 20th International Conference on Very Large Data Bases, VLDB, pp. 487-499.
  3. Agarwal, R., Aggarwal C. C., Prasad V. V. V. (2000). A tree projection algorithm for generation of frequent itemsets. Journal of Parallel and Distributed Computing. 61. pp. 350-371
  4. Bai, X., Bhattacharjee, S., Boylu, F., Gopal, R. (2012) A Data Mining and Optimization Methodology for Improving Branch Product Portfolio and Performance, under review
  5. Brin, S., Motwani, R., Ullman, Tsur. J. D., (1997). Dynamic itemset counting and implication rules for market basket data. In SIGMOD 1997, Proceedings ACM SIGMOD International Conference on Management of Data, pp. 255-264.
  6. Caro, F., J. Gallien. (2007). Dynamic assortment with demand learning for seasonal consumer goods. Management Science. 53(2) 276-292.
  7. Caro, F., J. Gallien. (2010). Inventory Management of a Fast-fashion Retail Network. Operations Research. 58(2) 250-273.
  8. Gaur, V., D. Honhon. (2006). Assortment planning and inventory decisions under a locational choice model. Management Science. 52(10) 1528-1543.
  9. Han, J. A. (2000). Mining frequent patterns by pattern growth: Methodology and Implications. ACM SIGKDD Explorations Newsletter. 2(2) pp. 14-20.
  10. Malik, H. H. (2006). Clustering web images using association rules, interestingness measures, and hypergraph partitions. Proceedings of the 6th International Conference on Web Engineering (ICWE 7806). pp. 48-55.
Download


Paper Citation


in Harvard Style

Bhattacharjee S., Boylu F. and Gopal R. (2012). Product Assortment Decisions for a Network of Retail Stores using Data Mining with Optimization . In Proceedings of the International Conference on Knowledge Discovery and Information Retrieval - Volume 1: KDIR, (IC3K 2012) ISBN 978-989-8565-29-7, pages 319-323. DOI: 10.5220/0004106703190323


in Bibtex Style

@conference{kdir12,
author={Sudip Bhattacharjee and Fidan Boylu and Ram Gopal},
title={Product Assortment Decisions for a Network of Retail Stores using Data Mining with Optimization},
booktitle={Proceedings of the International Conference on Knowledge Discovery and Information Retrieval - Volume 1: KDIR, (IC3K 2012)},
year={2012},
pages={319-323},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0004106703190323},
isbn={978-989-8565-29-7},
}


in EndNote Style

TY - CONF
JO - Proceedings of the International Conference on Knowledge Discovery and Information Retrieval - Volume 1: KDIR, (IC3K 2012)
TI - Product Assortment Decisions for a Network of Retail Stores using Data Mining with Optimization
SN - 978-989-8565-29-7
AU - Bhattacharjee S.
AU - Boylu F.
AU - Gopal R.
PY - 2012
SP - 319
EP - 323
DO - 10.5220/0004106703190323