Days of inventory
A historical measure: average stock at cost for the period ÷ (sales at cost for the same period ÷ days in the period). It looks back; for a forward view use “Weeks of supply”
- Formula
A historical measure: average stock at cost for the period ÷ (sales at cost for the same period ÷ days in the period). It looks back; for a forward view use “Weeks of supply”- Unit
- days
- Aggregation rule
- Ratio of sums
- Source system
- Warehouse and stock system; ERP and accounting system
- Owning role
- Head of buying / buyer
- Frequency
- Weekly
Passport
- Grain
- Category or warehouse × period
- Numerator
- Average stock at cost for the period
- Denominator
- Sales at cost for the period ÷ days in the period (daily usage)
- At zero or no data
- No sales (daily usage is 0): show “no sales”, not infinity and not 0.
- Limits
- A historical measure on average stock: it looks back. Do not compare it with “Weeks of supply” (current stock, forward). Stock and sales use the same cost basis.
- Check example
- Average stock at cost, RUB: 9000000; Sales at cost for the period, RUB: 18000000; Days in the period: 90.
a/(b/c). Result: 45 days - Related metrics
Version 1.0 · valid from 2026-11-16 · checked 2026-11-16
Related pages
- Term: Days of inventory
- Calculation: Days of inventory and excess stock
Definition
Days of inventory: for how many days of sales the current stock lasts. It is counted from cost of sales over a period and shows the “length” of stock; it is compared with the target by category and season. It is used in buying plans and stock control.
Suppose stock is RUB 12 million at cost and sales at cost over 30 days are RUB 4 million: 12 ÷ (4 ÷ 30) = 90 days. If stock grows faster than sales, excess piles up; look by category, not only for the chain.