ABC Analysis of Product Range
ABC Analysis categorizes your products into three groups based on their contribution to results:
- Group A: Top-selling items (generate the most revenue/volume).
- Group B: Mid-level items.
- Group C: Least important, outliers.
The analysis is conducted simultaneously based on two criteria: Revenue (in rubles) and Number of Sales (in units).
How to Generate a Report
-
Go to the Analytics section, find and toggle on the «ABC» switch.
-
Select the desired period and click the «Generate Report» button.
-
Filtering: You can click on any group (A, B, or C) on the distribution color indicator to display only products from that category on the screen.
-
Saving: You can download the ready report to an Excel file using the «Download XLS» button.
What do the data and indicators in the table mean?
Next to each product name, two colored circle indicators are displayed:
-
O Indicator (Turnover): The product's contribution to total revenue.
-
K Indicator (Quantity): The product's contribution to physical sales volume.
-
Marker colors: A (High), B (Medium), C (Low).
Strategy Matrix: What to Do with Products (ABC Combinations)
Comparing a group by Sales (first letter) and Quantity (second letter) helps you choose the right strategy for each product.
Zone A (Top Drivers)
-
AA (High Ticket + High Units) — Absolute Leaders
- What to do: Ensure constant stock availability. Allocate the maximum budget for advertising. Maintain a high level of service.
- Pricing: Use dynamic pricing, test price premiums (increases during peak demand), and implement loyalty bonuses.
-
AB (High Ticket + Medium Units) — High-Margin Stable Products
- What to do: Carefully plan purchases to avoid tying up excess capital, but also prevent stockouts.
- Pricing: Launch targeted promotions and bundles ("discount on the second item") to boost sales volumes.
-
AC (Very High Ticket + Low Units) — Exclusive or High-End Products
- What to do: Target advertising to the right audience. Minimize logistics costs (e.g., store on your own warehouse, not on the marketplace).
- Pricing: Reduce prices only within planned promotions, create attractive bundles to stimulate unit sales.
Zone B (Mid-range and Potential)
-
BA (Average Check + High Units) — Mass Market / Traffic Generators
- What to do: Purchase frequently and flexibly to meet high demand. Focus on customer retention and repeat sales.
- Price: You can slightly lower the price for even higher sales volume or launch wholesale discounts.
-
BB (Average Check + Average Units) — Stable Assortment
- What to do: Don't keep huge stock levels. Regularly review product listings — perhaps some items can be moved to Group A.
- Price: Show flexibility, adjust the price based on seasonality.
-
BC (Average Check + Low Units) — Slow-moving Items
- What to do: Optimize purchases based on accurate forecasts, identify reasons for low demand (issues with graphics, reviews).
- Price: Conduct price experiments, launch sales ("2+1 free") to clear inventory.
Zone C (Problematic Products)
-
CA (Low Ticket + Many Units) — Cheap Trinkets
- What to do: Ensure low-cost storage and frequent deliveries to avoid stockouts.
- Pricing: Gradually and smoothly increase prices while leveraging high popularity or sell only in bundles (sets of several units).
-
CB (Low Ticket + Moderate Units) — Low-Efficiency Products
- What to do: Moderate purchases, strict control of storage costs to prevent the product from eating into profits.
- Pricing: Conduct A/B testing of prices to find a balance between margin and sales volume.
-
CC (Low Ticket + Few Units) — Dead Stock and Candidates for Removal
- What to do: Completely stop new purchases. Do not spend budget on marketing. Freeze working capital.
- Pricing: Maximize price reduction, organize a hard sale to quickly liquidate inventory and free up warehouse space. If it doesn't help, completely remove from the catalog.
Product Recommendations for ABC Analysis Compliance
When we consider combinations of classification by turnover and sales volume
- this allows for a more detailed approach to inventory management, sales, and logistics.
Depending on how a product falls into different groups
- by turnover (revenue)
- sales volume
the approaches to handling it and strategies can vary.
Let's examine all possible combinations of ABC classifications for turnover and sales volume:
AA
Characteristics:
- High turnover
- High number of sales
Typical Actions:
- Intensive marketing:
- Maximum attention to marketing campaigns to maintain high popularity.
- Supply optimization:
- Ensuring uninterrupted supplies and availability of products in the required quantities.
- High level of customer service:
- Products with high sales and turnover require excellent service, fast delivery, and special attention to customers.
Price Management:
- Price premium:
- For such products, a higher price can be set because they have high demand. Consumers are willing to pay more for popular and in-demand products.
- Discounts for loyal customers:
- To retain customers, discounts or bonuses can be offered to regular customers to encourage repeat purchases.
- Dynamic pricing:
- Use a dynamic pricing strategy, adjusting the price based on market conditions, seasonality, or demand.
- Marketing promotions: Organizing promotional events, such as discounts on bulk purchases, can further stimulate sales.
AB
Characteristics:
- High turnover
- Moderate sales volume
Typical Actions:
- Inventory Management:
- Given the high turnover, it's crucial to monitor stock levels to avoid shortages.
- Purchase Planning:
- Purchases can be planned based on sales intensity, but considering that the product isn't always sold in large quantities will help prevent overstocking.
- Marketing Efforts:
- Implement targeted marketing campaigns to boost sales.
Pricing Management:
- Price adjustments to increase sales:
- Since the product has high turnover but moderate sales volume, lowering the price can stimulate higher demand.
- Attractive Offers:
- Introducing promotions like "buy one, get one free" or "bundle deals" can drive additional demand.
- Liquidity Issues:
- If the product sells quickly, prices can be increased based on demand (e.g., as the season ends or during sales).
- Promotional Campaigns:
- Offering temporary discounts or special offers can encourage increased purchases.
AC
Indicators:
- High turnover
- Low sales volume
Typical Actions:
- High level of service:
- Since the product has high turnover, it's important to provide high-quality service and increase its presence in the warehouse.
- Sales through high-margin channels:
- It's important to use a strategy focused on minimizing logistics and storage costs for products with low sales volume.
- Marketing and promotion:
- Active use of marketing to increase the number of sales, promotions, or campaigns.
- Demand analysis:
- Evaluate why the product has high turnover but low sales — it might be very expensive or seasonal.
- Marketing:
- Since the product sells less, efforts can be directed towards advertising, improving product visibility in the market, and stimulating demand through discounts or offers.
- Price management:
- Reduce the price or create promotions to stimulate purchases, for example, discounts for buying multiple units of the product.
BA
Characteristics:
- Average turnover
- High number of sales
Typical Actions:
- Increase purchase volume:
- Products with high sales but average turnover require a more flexible purchasing strategy to meet high demand.
- Marketing for repeat purchases:
- Strategies aimed at customer retention, regular promotions, discounts, or bonuses to encourage repeat purchases.
- Inventory management:
- Ensuring sufficient stock to meet stable demand.
- Analyze customer preferences:
- Assessing what makes the product popular among customers for use in future strategies.
Pricing Management:
- Considering high demand, prices can be reduced to increase sales volume and make the product more accessible to a broader audience.
- Applying discounts or promotions to attract a larger number of customers.
BB
Characteristics:
- Average turnover
- Average number of sales
Typical Actions:
- Regular review of the product range:
- Analyze sales to identify which products in Group B require additional attention or marketing to boost demand.
- Purchase optimization:
- Purchase products in Group B based on more flexible and medium-term forecasts to avoid overstocking or shortages.
- Reduce inventory:
- Do not hold large inventories for these products, as they do not generate as high revenue as Group A, but they are still in demand.
- Monitor discounts:
- Use discounts or promotions if necessary to increase sales volume.
Pricing Management:
- Flexibility in pricing:
- Use a combination of discounts and promotions to stimulate higher sales volume.
- Adjust prices based on seasonality.
- Implement time-limited discount strategies to boost sales.
BC
Indicators:
- Average turnover
- Low sales volume
Typical Actions:
- Purchase optimization:
- Purchase smaller quantities based on more accurate forecasts.
- Marketing efforts to stimulate demand:
- Use discounts, promotions, or improve product positioning in sales points to increase sales volume.
- Demand analysis:
- Identify reasons for low demand — perhaps the product does not fully meet consumer preferences.
- Minimize excess inventory:
- Since the product has average turnover, it's important to avoid overstocking in the warehouse.
Price Management:
- Price reduction:
- Since the product has low sales volume, reducing the price can stimulate greater interest and increase demand. This is especially relevant if the product does not enjoy the same high demand as other products in Group B or A.
- Discounts and promotions:
- Temporary discounts or promotions like "buy 2, get 1 free" or "discount on the second item" can help stimulate demand and increase sales.
- Price experiments:
- Try different price levels to identify the optimal price at which sales will start to grow and turnover will improve.
CA
Characteristics:
- Low turnover
- High number of sales
Typical Actions:
- Reduce storage costs:
- Products with low turnover require minimal storage costs, but given the high number of sales, it's important to maintain their availability in stock.
- Frequent deliveries:
- Make regular deliveries and have a stock management system to avoid shortages.
- Marketing activity:
- Evaluate which marketing channels attract a large number of customers to adapt sales and improve marketing efforts.
Pricing Management:
- Attractive offers:
- Offer discounts on purchasing multiple units of a product, as well as promotions to stimulate larger sales volumes.
- If a product has a stable high demand, its price can be gradually increased, following the rise in popularity.
CB
Characteristics:
- Low turnover
- Moderate sales volume
Typical Actions:
- Purchase Planning:
- Purchases and supplies should be moderate to avoid buying low-turnover items in large quantities.
- Marketing Strategies to Boost Sales:
- Use cost-effective but effective marketing strategies to increase sales volume.
- Inventory Monitoring:
- Ensure that the product does not remain in inventory for too long to avoid additional storage costs.
Pricing Management:
- Conduct A/B testing to determine which price is most attractive to consumers and drives increased sales.
- At low turnover, it's important to find a balance between price, sales volume, and profitability.
CC
Characteristics:
- Low turnover
- Low sales volume
Typical Actions:
- Minimize inventory:
- Maintain minimal stock of these products to avoid tying up capital in poorly selling items.
- Plan less frequent purchases:
- Often, purchases for Group C items are made as needed to avoid excess inventory on the shelf.
- Liquidity issues:
- Group C items are frequently at higher risk of obsolescence due to low demand and may need to be liquidated at a discount or removed from the catalog.
- Limited marketing efforts:
- Limited attention from marketing since they do not generate significant revenue or profit.
Pricing Management:
- Reduce price for liquidation:
- If a product has low sales and low turnover, it's advisable to reduce the price to accelerate liquidation.
- Promotions to stimulate demand:
- Organize sales or large discount offers to quickly clear the warehouse.
- Redistribute the catalog:
- If a product is not selling, it may be necessary to adjust the price or remove it from the catalog.