Assortment optimization for Retail chain

data

Objective

Retail client wants to standardize and optimize the product assortment and display in each of its 400 retail stores.

Key requirements:

  • Individual configuration of store layout/assortment for each product group for up to 10 store categories
  • Complex simulation of impact of new assortment (based on multiple effects, e.g. cross-selling, price sensitivity)
  • Flexible reporting allowing the creation of multiple charts with detailed filtering and configuration
2

Technical solution

Local Access back-end:

  • Importing data for selected product group: transactional data, warehouse situation, product base data, competitor prices
  • Storing simulation parameters and new store layout per store category
  • Running simulation of new assortment structure based on entered parameters

Excel front-end to:

  • Analyse performance of current store configuration based on central data
  • Enter/modify simulation parameters and assortment per store category
  • Trigger simulation
  • Create multiple detailed reports/charts
  • Export reports to PowerPoint and PDF
impact

Result

  • Tools allowed client to quickly redesign overall store layout by breaking the overall project into several smaller product group projects
Industry
Other industries
Tool type
Custom-made tools
Project duration
6 months
d2i effort
50 MDs
Data volume
1.0-4.5M records of sales data for each product group
Up to 20,000 products
10 product level hierarchies
Tools involved
Excel
PowerPoint
Access
No images found.
Cookies make it easier for us to provide you with our services. With the usage of our services you permit us to use cookies.
Ok