- Print
- DarkLight
- PDF
How do I view the turnover rate and what can I do with it?
The turnover rate can be requested through the extended statistics.
600: statistics, inventory, and turnover rate per cash group
601: statistics, inventory, and turnover rate per supplier
602: statistics, inventory, and turnover rate per product
This turnover rate indicates how long inventory remains in the store. The higher this value, the shorter these products are in stock.
For example, this is also a way to identify "slow-moving items" in the inventory, which will have a low turnover rate or even a value of 0.
Several values are important for calculating the turnover rate. RetailVista does this automatically, but it is good to know howthis value is determined.
Average inventory= inventory per day added up : number of days used in the period.
For example, over a period of 10 days:
3 days with an inventory of 10 = 30
4 days with an inventory of 7 = 28
3 days with an inventory of 4 = 12
30 + 28 + 12 = 70 : 10 = average inventory of 7
Average number sold/day = total sold in the period : number of days in the period.
The period is variable, of course.
Turnover rate = Average number sold/day * 365 (extrapolated on an annual basis) : Average inventory
So how often is the average inventory sold in quantities.
A "slow-moving item" will therefore have a very low turnover rate or even 0. See the example below of 2 products.
This is the result of statistic 602 over a period of one year. Both products have a turnover rate of 0. On average, these products have an inventory of 3 and 6 respectively in this period, but neither of them were sold in a whole year.