XYZ Analysis: Find Out When and What Customers Buy
Posted: Thu Dec 26, 2024 4:15 am
The XYZ analysis method helps to calculate how much product should be in stock so that it does not lie around and brings profit. This analysis requires statistics on product sales for several months to understand how stable the demand for the product is in different periods.
Even the most popular products depend on competition, season, new trends and other factors. For example, bread is a product that will always be in demand, but it is also subject to the influence of fashion, grain yield and the economic situation. For example, when Russians' incomes fell, the demand for expensive types of bread decreased, and now people are looking for gluten-free bread.
Target Audience Analysis: How to Find Out Exactly What Your Customers Need
History of impressions for the phrase "gluten-free bread" in Yandex.Wordstat
You can track interest in a product using, for example, the history of search queries over different periods
XYZ analysis identifies products with stable demand. To do ivory coast phone numbers this, it calculates how sales volume changes from month to month. For each product group, a variation coefficient is determined, which shows the fluctuation in demand for a particular period:
X — goods with stable demand. Fluctuation from 0-10%;
Y — average, for example, seasonal goods. Fluctuation 10-25%;
Z — goods with random demand. Fluctuation from 25%.
For XYZ analysis, a list of products and their sales sum for several months is entered into the Excel table. The coefficient of variation by which the rows are sorted in ascending order is A → Z. It is calculated using the formula:
=STDEV(B3:G3)/AVERAGE(B3:G3)
Letter designations are assigned according to the formula:
=IF(H3<=10%;"X";IF(H3<=25%;"Y";IF(H3>=25%;"Z")))
Even the most popular products depend on competition, season, new trends and other factors. For example, bread is a product that will always be in demand, but it is also subject to the influence of fashion, grain yield and the economic situation. For example, when Russians' incomes fell, the demand for expensive types of bread decreased, and now people are looking for gluten-free bread.
Target Audience Analysis: How to Find Out Exactly What Your Customers Need
History of impressions for the phrase "gluten-free bread" in Yandex.Wordstat
You can track interest in a product using, for example, the history of search queries over different periods
XYZ analysis identifies products with stable demand. To do ivory coast phone numbers this, it calculates how sales volume changes from month to month. For each product group, a variation coefficient is determined, which shows the fluctuation in demand for a particular period:
X — goods with stable demand. Fluctuation from 0-10%;
Y — average, for example, seasonal goods. Fluctuation 10-25%;
Z — goods with random demand. Fluctuation from 25%.
For XYZ analysis, a list of products and their sales sum for several months is entered into the Excel table. The coefficient of variation by which the rows are sorted in ascending order is A → Z. It is calculated using the formula:
=STDEV(B3:G3)/AVERAGE(B3:G3)
Letter designations are assigned according to the formula:
=IF(H3<=10%;"X";IF(H3<=25%;"Y";IF(H3>=25%;"Z")))