Retail
Retail Solutions

Assortment Optimization
Shopper Segmentation
Proactive Retention for Club Shoppers
Design of Experiments
Markdown Optimization
Market Basket Analysis

 


 

Assortment Optimizationgo to top

 

Business Problem: The number of SKUs that retailers carry has increased exponentially over the years. The average grocery store carries between 40,000-60,000 SKUs. While this increased choice is valuable to consumers, it also causes confusion in their minds. SKU proliferation is a big source of cost escalation for manufacturers and retailers because of the complexity it creates in manufacturing and supply chain management. Retailers and manufacturers both want to understand which SKUs add incremental sales and whether the incremental sales justify continuing the SKU.

Solution: By applying analytics to POS and panel data, companies can measure the incremental demand that a SKU addresses. This is also known as demand transferability. In other words, retailers and manufacturers are trying to understand if a particular SKU is not present, will consumers buy another product (transfer the demand), or will they go to another store to purchase the product.

Deliverables:

  • Understand affinity and cannibalization relationships between SKUs
  • Identify SKUs which are not catering to any additional demand, and hence can be rationalized
  • Understand the impact of removing a SKU from the assortment
  • Identification of SKUs that have high incremental demand and must be kept in stock

 

Shopper Segmentationgo to top

 

Business Problem: Retailers want to understand the different segments of shoppers who shop at their stores, so that they can target their pricing, promotional, and marketing strategies to cater to each specific group.

Solution: By applying analytics to POS data, loyalty card data, and demographic data for the store's catchment area, we can identify the common attributes of shoppers who shop at a particular retailer, including the differences in these attributes by region. Shoppers can be clustered along specific attributes, and pricing and promotional strategies can be targeted for each group.

Deliverables:

  • Segmentation scheme and algorithm for segmentation
  • List of shoppers assigned to each segment by region
  • Profile of each segment
  • Segment-level promotional recommendations
    • Promotional strategies for every segment
    • Business impact ( i.e. ROI calculation for the strategy)

 

Proactive Retention for Club Shoppersgo to top

 

Business Problem: Loyalty card data provides retailers with detailed information about the preferences, past frequency, and amount of purchases of each of their loyalty customers.  Retailers would like to understand how they can use this information to create strategies to retain these customers.

Solution: By analyzing historical POS data at the basket-level, in conjunction with customer loyalty data, we can model historical loyalty customer spend behavior. Using these models, we can forecast how each customer would behave in the future. This forecasted purchase information can be used to create strategies for retaining loyalty customers.

Deliverables:

  • Shopper attrition report that provides customer attrition analysis on a model-based shopper attrition timeline
  • Proactive retention framework developed specifically on the basis of the analysis, which includes promotional activities customized to each individual shopper
  • Summary analysis report which includes the financial  impact of recommendations

 

Design of Experimentsgo to top

 

Business Problem: Retailers want to introduce new concepts, products, ideas, pricing and promotion strategies, merchandizing strategies etc. within their stores. Typically, they would introduce these over a subset of the stores and depending on certain success criteria they would make a decision on whether to scale these across all their stores or not. Retailers want to understand how to identify a representative sample from a set of stores. Also, the sales of a store depends on a lot of different variables and it is hard to single out the impact of a specific strategy to overall sales. Retailers want to be able to measure the impact of tests conducted on key KPIs and to define the success or failure of the test.

Retailers want to introduce new concepts, products, ideas, pricing and promotion strategies, merchandizing strategies etc. within their stores. Typically, they would introduce these over a subset of the stores and depending on certain success criteria they would make a decision on whether to scale these across all their stores or not. Retailers want to understand how to identify a representative sample from a set of stores. Also, the sales of a store depends on a lot of different variables and it is hard to single out the impact of a specific strategy to overall sales. Retailers want to be able to measure the impact of tests conducted on key KPIs and to define the success or failure of the test.

Solution: We use historical POS data in conjunction with demographic data to identify test and control stores which trend very similarly and which are also representative of the market being studied. Comparison of sales data pre and post test between test and control stores would give a measure of the impact of the test. Demand models can be created against historical POS data which would enable adjustment of the sales data for differences in pricing, promotions, merchandizing etc between test and contol stores.We use historical POS data in conjunction with demographic data to identify test and control stores which trend very similarly and which are also representative of the market being studied. Comparison of sales data pre and post test between test and control stores would give a measure of the impact of the test. Demand models can be created against historical POS data which would enable adjustment of the sales data for differences in pricing, promotions, merchandizing etc between test and contol stores.

Deliverables:

  • List of test stores and markets where study should be conducted
  • Optimal  control store assignment for each test store
  • A list of top 5 control stores for each test store from which the user can choose
  • Quantification of the impact of tests conducted across the test stores

 

Markdown Optimizationgo to top

 

Business Problem: Short lifecycle product retailers (for example, fashion retailers or electronics retailers) have products which go out of trend/fashion/usability very quickly, and as such, they have a very short timeframe to sell their products. They want to achieve the best possible results on the relevant sales KPIs (i.e. units, revenue, average unit price, GM %, sell-thru %) within this duration. One of the key decisions is to determine the optimal markdown price for the products, so that the products run out of inventory within the specified out dates, while maximizing sales KPIs during the sales lifecycle of the product.

Solution: We model historical POS data to identify key product parameters such as price sensitivity, seasonal decay of demand, promotional effectiveness, etc. These model parameters can forecast future sales KPIs, which can be used to find the optimal markdown prices which will maximize these KPIs.

Deliverables:

  • Report on performance of historical markdowns, and comparison against optimal markdowns which could have been taken
  • Optimal markdowns for each product within each store or store group
  • Forecasted impact of markdowns on key KPIs such as revenue, GM, GM %, sell-thru %, etc.

 

Market Basket Analysisgo to top

 

Business Problem: Retailers want to understand which products/brands sell together (affinity) and which products/brands cannibalize each other. They also want to quantify the impact of these affinity and cannibalization results on financial metrics, and identify how they can use this information to price and promote products effectively.

Solution: Applying analytics to historical POS data at he basket-level, we can track affinity and cannibalization relationships between various products/brands/categories across different countries/regions/stores. We can quantify the financial impact of these relationships, and also recommend promotional and pricing strategies specific to a product relationship.

Deliverables:

  • Report on affinity and cannibalization relationships between products
  • Recommendations for pricing and promotional strategies at the product-level based on affinity and cannibalization relationships
  • Quantified impact of pricing and promotional strategies