Goal of the analysis:
The goal of SKU Rationalization and Retail Product Assortment Optimization is to evaluate the performance of individual SKUs to optimize the product assortment, reduce inventory costs, and ensure that the most profitable and high-demand products are prioritized. This analysis helps retailers streamline their product offerings to improve profitability, increase customer satisfaction, and minimize excess inventory.
Data required:
- Sales data per SKU (units sold, revenue generated).
- Profit margin per SKU.
- Inventory levels and turnover rates per SKU.
- SKU-related costs (storage, handling, marketing, etc.).
- Product return rates (optional for quality assessment).
- Customer feedback and preferences (optional for deeper insights).
- Product lead times and replenishment frequency (optional for supply chain analysis).
Detailed step-by-step instruction on how to conduct the analysis:
1. Collect sales and profitability data per SKU
Gather sales volume, revenue, and profit margin data for each SKU over a specific period (e.g., monthly, quarterly). This will help identify high-performing and low-performing products.
2. Calculate SKU profitability.
Use the following equation to calculate the profitability of each SKU:
SKU Profitability = (Revenue per SKU – Cost per SKU)
This shows the actual contribution of each SKU to the company’s bottom line.
3. Analyze SKU inventory turnover.
Measure how frequently each SKU is sold and replenished using the following formula:
SKU Turnover Rate = (Cost of Goods Sold / Average Inventory)
High turnover rates indicate that products are selling quickly, while low turnover rates suggest slow-moving items that may tie up capital.
4. Identify underperforming SKUs.
Review sales, profit margins, and turnover rates to identify SKUs that are underperforming.
Use the following equation to identify slow-moving items:
Slow-Moving SKU (%) = (Number of Slow-Moving SKUs / Total SKUs) x 100
Underperforming SKUs typically have low sales, low-profit margins, and high inventory levels.
5. Segment SKUs by category and contribution.
Group SKUs based on their performance (e.g., high-profit, low-profit, fast-moving, slow-moving) and categorize them by product type. This helps identify which product categories are over- or under-represented in the assortment.
6. Rationalize the assortment.
Based on the performance data, decide which SKUs to keep, promote, or discontinue. For each SKU, consider:
- Should the SKU be retained (high sales, high margin)?
- Should the SKU be replaced with a similar product?
- Should the SKU be discontinued due to poor performance?
7. Optimize product assortment.
After removing underperforming SKUs, ensure the remaining assortment covers customer demand and key product categories. Use customer feedback and sales data to guide decisions about new SKUs to introduce or categories to expand.
8. Test new assortment strategies (optional).
If possible, test the optimized assortment in a few store locations or online before rolling it out across the company. Monitor sales and customer feedback to ensure the new assortment meets customer needs.
Potential complications that can arise with this analysis:
- Seasonality impacts: Some SKUs may perform better in specific seasons. Failing to account for seasonality could lead to discontinuing a product that would otherwise perform well in certain periods.
- Customer demand fluctuations: Sudden changes in customer preferences or trends may cause once-popular SKUs to underperform, or vice versa.
- SKU interdependencies: Certain SKUs may complement one another (e.g., accessories to main products), so discontinuing one SKU may negatively impact the sales of others.
- Data quality issues: Inaccurate or incomplete sales, cost, or inventory data may lead to incorrect conclusions about SKU performance.
Format of the output of analysis:
The output typically includes a SKU rationalization report, showing which SKUs to retain, replace, or discontinue, along with performance metrics such as sales, profitability, and turnover rates. It may also include recommendations for optimizing the overall product assortment.
Example output:
- SKU Performance for Q2 2024:
- SKU A: Sales = $50,000, Profit Margin = 30%, Turnover Rate = 4.5
- SKU B: Sales = $20,000, Profit Margin = 15%, Turnover Rate = 1.8
- SKU C: Sales = $10,000, Profit Margin = 8%, Turnover Rate = 0.5
- Assortment recommendations:
- SKU A: Retain
- SKU B: Promote with discounts
- SKU C: Discontinue
How to interpret results:
- High-performing SKUs: Products with high sales, strong profit margins, and fast turnover rates should be retained and potentially expanded within the assortment.
- Underperforming SKUs: Products with low sales, poor margins, and low turnover rates should be considered for discontinuation or replacement.
- Category balance: Ensure that the assortment covers all key product categories and that high-demand categories are well-represented. Over-representation of slow-moving products should be avoided.
- SKU count reduction: Rationalizing SKUs often leads to a reduction in the total number of products offered, which can simplify inventory management and reduce costs.
Steps a company can take to improve on this measure:
- Streamline product offerings: Focus on high-margin, high-demand SKUs and discontinue or replace underperforming products to improve overall profitability and reduce excess inventory.
- Use customer feedback for assortment decisions: Incorporate customer preferences and feedback into the SKU rationalization process to ensure that the optimized assortment aligns with customer needs and preferences.
- Monitor SKU performance regularly: Conduct SKU rationalization and assortment optimization at regular intervals (e.g., quarterly or annually) to ensure the product assortment remains relevant and profitable.
- Leverage data analytics: Use advanced analytics to predict customer demand, identify emerging trends, and ensure the assortment is aligned with future market needs.
- Test new SKUs strategically: When introducing new SKUs, test them in select locations or online before rolling them out more widely to reduce the risk of underperformance.
- Improve inventory management: With a more streamlined SKU assortment, optimize inventory levels and reduce carrying costs for slow-moving products.
- Work with suppliers: Negotiate better terms with suppliers for high-performing SKUs, such as volume discounts or improved lead times, to further enhance profitability.
Request the PDF Download of How to Analyze a Retail Company
