How to conduct assortment analysis
Define the object of analysis of the assortment. As the test unit may be any product category, item unit, group or subgroup of products. If your company is engaged in wholesale sales, explore clients, debtors and suppliers. Please note that if your goal is to manage the assortment, it is best to analyze items, i.e. any item. If you are interested in the structure of the assortment, pay special attention to the product category.
Select the parameter that will be further analyzed. They may be gross revenue, sales volume, average commodity ordering, the total number of orders and their volume. They can be evaluated according to several parameters simultaneously. In this case, the data obtained for each parameter are compared with other results. Calculate the total value of the selected attribute.
Determine the percentage of each position relative to the final result. This will clearly demonstrate to you which commodity group or nomenclature unit brings the greatest revenue, requires high costs, etc.
Spread the ranking of the analysis objects. Arrange for descending research positions. The principle that is responsible for the position of a category will be the parameter you select.
Calculate the concentration with the result of the accumulation of analysis. For that opposite to the top categories, check the value of the share identified in the previous steps. Opposite the second category to its immediate share add previous value, etc. In the end, the bottom line is you should have 100%.
Distribute product categories into groups. The most common are from 2 to 4 populations. From the fact in which group you will take this or that category, its further destiny and ways of its management depend.