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
Mary Makarchuk
Mary MakarchukRetail Optimization Expert
Average daily usage

A competitive advantage for retailers today is the timely response to fluctuations in demand for their goods. Customers who choose the LEAFIO AI Retail Platform 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 number of sales over a certain time 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 the frequency of their sales:

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 created 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:

The wholesale criterion for infrequent and average sales can be chosen from the following values: 0; 5; 10; 15; 20; 40 (in units of goods). If there are more sales than the specified quantity on any given day, that day will be excluded from the calculation of the average sale.

Since ADU for frequently sold items is not limited in the maximum possible value and can be higher than the selected criterion for this group, wholesale is determined by a different logic, namely: you must specify how many times the sale for the day must be greater than the current average sale for the system not to consider that day as valid. The selectable criteria are 0; 10; 20; ... 300 times. For example, if we have a current average sales value of 5, the criterion of 20 times selected and 120 items were sold on the day, then this day is excluded from ADU calculation.

Leafio also has an option to exclude days with predictably irregular demand. This includes the days before March 8th, Thanksgiving, Easter, etc. These days are date-dependent and they can be predicted in advance. The customer chooses the days with irregular demand, which will be excluded for all products when calculating the cleared average sales.

By dividing products into 3 groups and being able to specify your settings for each group, our customers get flexible functionality for calculating average sales, which in turn allows them to react quickly to changes in demand in today's retail environment.


Mary Makarchuk
Mary MakarchukRetail Optimization Expert

RELATED ARTICLES

SUBSCRIBE TO OUR NEWSLETTER

Don't miss our weekly news letter

34.239.173.144
;