Assortment Planning and Recommendation: Optimizing Product Selection for Retail Success

What is Assortment Planning?

Assortment planning involves choosing products for local and seasonal collections through a detailed analysis. Throughout this process, store managers and retail professionals select items by considering past customer orders and other data gathered about their customer demographics.

Assortment Recommendation

Assortment recommendation involves recommending the products to be stocked at the store level for a given time-period. The recommendations are typically at the store-level to leverage the real-time demographic information. Here both the choice of products to be recommended and their quantity are critical for prediction. Min-max replenishment can be leveraged throughout, and especially for extending the same assortment for a longer period, in a rolling fashion i.e. replenishing when quantity falls below minimum. For the store owner, it would be extremely beneficial to know the new product ranges which have been recommended and the profits in gross margin he can visualize by making the recommended decisions. From any resulting assortment recommendation, it is now possible to analyse the same by comparing with the current state of inventory. This can give insights into understocked or overstocked inventory.

Further by creating a hierarchy over the store (such as distribution centres, zones, regions) one can gain aggregate actionable insights at these various levels.

AI/Machine Learning in assortment planning

Demand Forecasting

Machine learning algorithms can analyse historical sales data, market trends, seasonality, and other factors to forecast demand for different products. This helps retailers make informed decisions about which products to stock and in what quantities to meet customer demand effectively.

Customer Segmentation

Machine learning can segment customers based on their buying behaviour, preferences, demographics, and other relevant factors. By understanding customer segments, retailers can personalize assortments, promotions, and pricing strategies to target different customer groups more effectively.

Product Segmentation

Segmentation of the products too is useful because such a grouping could be mapped to the aggregate demand for that group of products thus increasing the serviceability to the customer.

Assortment Analysis

Actuals versus real is determined by comparing the predicted assortment with actual sales. This is carried out both for range of products recommended and their quantities. If the range of products are not determined accurately or if their quantities are not sufficient, it would result in “misses” and hence customer dissatisfaction. Analysing the miss data and revenue lost due to the same is a critical component in this case.

Metrics

Here are some metrics that can be used to measure the success of an assortment plan:

• Sales performance: The primary measure of an assortment plan's success is sales performance, commonly assessed through comparing actual sales to planned sales. Retailers use this comparison to pinpoint successful areas and areas requiring improvement.
• Productivity: Productivity gauges how effectively a retailer utilizes resources to drive sales. Comparing sales to inventory investment allows retailers to assess productivity, revealing top-performing products and those that aren’t generating significant revenue.
• Sell-through rate: The sell-through rate represents the portion of inventory sold within a defined timeframe. Retailers monitor this rate to gauge the speed of product sales, aiding in inventory management and informed purchasing choices.
• Gross margin: The gross margin denotes the gap between sales revenue and the cost of goods sold. Retailers use this metric to assess profitability, enabling them to fine-tune pricing and promotions to boost margins.
• New product recommendations: In industries where the product variety is huge, for instance pharma where a same molecule could have multiple brand names, and further there exists a huge number of molecules, it is critical to understand what percentage of recommendations cater to the new products recommended for a given store/location.

Triple bottom-line

Assortment planning plays a role in reducing environmental impact by avoiding wasteful logistical back-and-forth activities such packing, storage, transportation etc. This in a scale of daily operations, could help avoid major harm to the environment via carbon footprint.

Analytics

Over a period, the data involving both the actual sales, and the predicted assortment range and quantities, accumulate, thus giving some valuable insights. Insights such as model bias, historical sales could be visualized to better serve the future assortment predictions, and the impact of changes on the bottom-line. Further aggregate performance indicators of tops brands, manufacturers, suppliers etc could be tracked.

Technology

Assortment planning as a domain requires at times to predict for huge number of SKU across product lines, across the entire historical data. The ideas of distributed computation, parallelization, efficient model training and inference catering to each type of model (time-series, neural networks, graph networks), efficient ETL and finally big-data handling are crucial.