Uniform Demand Method (XYZ)

[subornaakter20]

This type of research is conducted with the aim of identifying those product categories that will be in constant demand by buyers.

Studying the uniformity of demand will save both financial and time resources by eliminating products with low demand from the range. A very suitable technique for retail.

The scheme of actions in this type food and beverage email list of sales analysis is as follows: summarize in an Excel table the list of all available goods and the volume of revenue for each item. There are special formulas for calculating the coefficient of variation.

The coefficient of variation here refers to the possible fluctuation of indicators. An increase or decrease in demand directly affects sales, and therefore the fulfillment of the planned plan.

After this, all products are divided into categories:

Category X - positions with a coefficient below 10%.

Category Y – positions with a coefficient ranging from 10 to 25%.

Category Z – positions whose coefficient exceeds 25%.

Uniform Demand Method (XYZ)

Sales Analysis by Studying the Receipt Structure
It is carried out in order to obtain data on the quantity of specific product items in the studied trade object. This can be a store, a specific point of sale, a separate shelf.

This is a suitable sales analysis method for federal-scale companies or large distributors of both retail and wholesale trade. The following indicators are studied and taken into account:

The so-called minimum required assortment (MML) is a list that includes several of the most significant SKU (Stock Keeping Unit) items.

Average SKU value, that is, the average number of these specific items in the product list.

Special accounting systems will generate a report showing the average number of SKUs that can be sold through a certain point of sale. A high value of this indicator indicates that the company's products are widely represented on the market. The following formula exists for manual calculation:

Average SKU = Number of S KUs sold in all stores / Number of stores

If this indicator grows, it means that the presence of your products in a specific retail facility is expanding, and demand is increasing. It is important to monitor the dynamics of this indicator.