Days of inventory
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.
Formula
Stock at cost ÷ (sales at cost ÷ days in the period)
How to read
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.
Where it is discussed
Topics
- Revenue, profit and costs
- Stock and turnover
- Buying budget and cash
- Assortment and sizes
- Collection and range
- Cash and working capital
Calculations
- Quick business check: two periods
- Average stock for the year and turnover
- Days of inventory and excess stock
- Opening stock: stock-to-sales and the monthly buying budget
- ABC analysis of the range
Documents
- Working capital and the cash conversion cycle (CCC = DIO + DSO − DPO)
- Stock turnover and dead stock
- Retail math by segment: IMU, MMU, markdowns, sell-through, GMROI, turnover