Setting up ABC / XYZ product analysis
Copy the link to the article
Copied

In the ABC / XYZ-analysis, the store's sales volume is taken as one. Products are sorted by turnover importance (ABC); and by sales regularity (XYZ): best-selling - at the top, least-sold - at the bottom.

The system calculates ABC according to the following method:

  • a rating list of objects by income from sales is made up;
  • the share of the parameter from the sum of the parameters with a cumulative total is calculated. The cumulative share is calculated by adding the parameter to the sum of the previous parameters;
  • we select groups A, B and C: assign group values ​​to the selected objects.

The system allocates groups A, B and C by default in the proportion of 20, 35 and the remainder, respectively.

The system calculates XYZ according to the following method:

  • determination of the coefficients of variation for the analyzed resources;
  • grouping of resources in accordance with the increase in the coefficient of variation;
  • distribution by categories (X, Y, Z).

The system allocates groups X, Y and Z by default in proportions of 30, 50 and remainder, respectively.

For XYZ, you can additionally set a time step, which should correspond to the average frequency of product purchases.

After saving the settings, the recalculation of indicators begins in the backgroud. Upon completion, the user is notified.

Note

Segments do not include deleted and canceled orders / customers.

Thank you for your feedback.
Was this article helpful?
No
  • Рекомендации не помогли
  • Нет ответа на мой вопрос
  • Текст трудно понять
  • Не нравится описанный функционал
Yes
Previous article
"ABC / XYZ inventory analysis" widget
The ABC component of the analysis segments products by their contribution to total sales. The XYZ component segments products by regularity of sales.
Next article
Universal analytics widget for products
The universal widget allows you to build your own reports on specified parameters.
#}