Academy
The importance of a correct approach to calculating average daily inventory sales
Academy

The importance of a correct approach to calculating average daily inventory sales

5 min read
Maryna Makarchuk
Maryna MakarchukHead of Implementation
Average daily usage

A competitive advantage for retailers today is the timely response to fluctuations in demand for their goods. Customers who choose Leafio to manage their stock can adapt quickly to changes in demand, as the average daily usage (ADU), which reflects the current demand for goods, is used as a basic calculation when generating an auto-order. In our system, this ADU (average daily usage) is the cleared average sales on current days over a certain period.

When calculating the average sales per item, it is very important to get the period required for the statistics right. If the period is too long for a product with frequent sales, the average sales indicator will react slowly to changes in demand, resulting in an order that does not match demand (lags). Conversely, if a short period is used for rare sales, the average will be inaccurate (the amount of goods in the order will not match the demand). If you have one day in a period with an occasional large sale, the ADU will be overestimated. Conversely, if there is not a single sale in the period, the average sale will be 0. To reduce the impact of such situations, Leafio assigns items to three groups according to their sales frequency:

The customer can decide which average sales value will correspond to each group or can use the default value.

Average daily usage (ADU)

Average daily usage (ADU)

Average sales indicator ADU

For the order to be formed correctly, for each product group the ADU inventory is recalculated by the system after a certain period, which is set in the settings. 

Also, according to the group, the system determines which period to take the sales for ADU calculation. The less often an item is sold, the longer the period needed to calculate the correct average sales value. These periods can be set separately for each group in the individual company settings:

ADU is calculated for all active products with active schedules for which orders are automatically generated.

What can the minimum ADU value be used for?

To avoid cases where the calculated value is very small or equal to zero, it is possible to specify by an additional setting the minimum ADU value below which the system will not set the average sale. The minimum selling average can be selected from the following options: 0; 0.01; 0.02; ... 0.05; 0.1.

Valid days for calculating average sales 

To correctly calculate the average sales for a given period, the system will identify valid days and exclude from them those days that may in some way artificially lower or raise it. The criteria for determining such days are as follows:


Maryna Makarchuk
Maryna MakarchukHead of Implementation

Related articles

SUBSCRIBE TO OUR NEWSLETTER

Don't miss our weekly news letter

3.238.204.31
;