Inventory Turnover and Ageing: Formulas and Traps
Inventory turnover and ageing ask the same question in two ways. Formula choices, average-stock and days-idle traps, and the definitions Floemdata actually uses.

Money is waiting in the warehouse. How much, for how long, and in which items? Two measures answer these questions: turnover shows how many times a year the stock cycles, and ageing shows how much of it has not moved, and for how long. Both look simple, and in both the choice of definition changes the result.
Turnover: two common definitions
The usual definition is the cost of goods sold in a period divided by the average stock value of that period. In practice, when average stock data is missing, the closing stock is used. The two definitions give different numbers, and the gap is noticeable when stock grows or shrinks during the year. State which one the report uses, or two reports will contradict each other on the same item.
A close relative is days of cover: for how many days does the stock on hand last at the daily cost of outflow? When turnover is high, days of cover is low; they are two faces of the same information.
Ageing: ageing by what?
Stock ageing is usually split into buckets such as 0–30, 31–60 and 61–90 days. The real question is what the bucket counts:
- Days since the last movement: simple and easy to compute, but an item looks fresh even if part of it sold yesterday and the rest has sat for years.
- Age by receipt date (by batch or layer): more accurate, but it needs batch or layer information and depends on the valuation method.
Items past a threshold get a dead stock label. The threshold (365 days, say) is an industry choice; for a seasonal product a quiet year can be normal.
Traps to watch
- An item with no outflow: turnover is zero and days of cover is undefined. Do not write the undefined value as 0; leave it blank and say why.
- Valuation method: average cost, FIFO and standard cost value the same stock differently, so comparing items is misleading in a company that mixes methods.
- Warehouse split: an item that looks healthy in total may be piled up in one warehouse and sold out in another.
- Snapshot: stock status says 'now'. To compare ageing over time you have to store the measurement yourself.
Where Floemdata stands
Floemdata's Gold layer holds a stock status table at item-by-warehouse level. According to the project code, turnover is the cost of outflow over the last 12 months divided by the current stock value (the current value, not an average), and days of cover is the stock value divided by the daily outflow cost (12-month outflow divided by 365). The age buckets are 0–30, 31–60, 61–90, 91–180, 181–365 and 365+ days, measured as days since the last movement; an item past 365 days counts as dead stock. For an item with no outflow, days of cover stays empty. The valuation method is carried per item as a label.
These calculations run on mock SAP data; we did not separately verify the results on real customer data for this article. Stock status is a snapshot. The anomaly layer stores the measurement for such tables per day in its own history table, but we did not find this offered in the stock report as a historical ageing comparison.
To begin, pick the ten items holding the most stock value and compute days of cover for each. Questions are welcome at info@floemdata.com or via Floemdata.