Inventory turnover shows how many times the stock is sold in a year. Days of inventory show the same as a number of days. The figures are useful to follow over time and across categories, but they say nothing about individual products, so those need a figure too.
Inventory turnover
Inventory turnover = cost of goods sold per year / average stock value
Cost of goods sold is the cost price of the products sold. Both figures must be at cost price, otherwise the result will be too high.
A webshop has cost of goods sold of 3,600,000 DKK a year and an average stock value of 900,000 DKK:
3,600,000 / 900,000 = 4 times a year
Days of inventory
Days of inventory = 365 / inventory turnover
At 4 times a year, a product sits in stock for an average of 365 / 4 = 91 days before it is sold.
Use an average over the year
For most webshops the stock value varies a lot over the year. If the stock is filled up for Christmas and you use the value on 1 December, turnover looks low, while the value on 1 February makes it look high. Use the average of the stock value at the end of each month.
Margin per DKK in stock
Inventory turnover does not take margin into account. A product with low margin and high turnover can earn less than a product with high margin that sells more slowly. It can therefore be worth also looking at:
Gross margin per year / average stock value
If the webshop in the example has a gross margin of 2,400,000 DKK, each DKK in stock gives 2.67 DKK in margin per year. Comparing categories shows where the money in stock earns the most.
Days of cover per product
An average for the whole stock can hide that some products are out of stock while others have stock for two years. Per product it is more useful to look at how long the stock will last:
Days of cover = (stock + incoming goods) / expected sales per day
A product with 120 units and expected sales of 4 units a day has 30 days of cover. Compare with the lead time: if the cover is shorter than the lead time, it is probably too late to order, and if it is many times longer, the product probably has overstock.
What is a good figure
It depends on the industry. Fashion and groceries typically have higher turnover than spare parts or furniture, where the range is wide and each product sells rarely. It is probably more useful to compare with yourself last year and between your own categories than with a figure from another industry.
Stock value and cover in lesslater
lesslater shows the stock value at cost price today and what it is expected to be over the coming months based on the forecast and the planned orders. In the product list each product has days of cover based on stock, incoming goods and the forecast, shown as a bar with the lead time marked, so products with less cover than the lead time are shown in red.