Excess stock
Actual stock − (sales ÷ days × target days of inventory), at cost
- Formula
Actual stock − (sales ÷ days × target days of inventory), at cost- Unit
- RUB
- Aggregation rule
- Sum
- Source system
- Warehouse and stock system; ERP and accounting system
- Owning role
- Head of buying / buyer
- Frequency
- Monthly
Passport
- Grain
- SKU × warehouse × date, total by category
- At zero or no data
- A negative result is a shortage: show excess as 0 and the shortage separately, with no netting.
- Limits
- Target days of inventory are set in advance per category. A new item with no sales history gets no excess figure: there is no base.
- Check example
- Actual stock at cost, RUB: 9000000; Sales at cost for the period, RUB: 18000000; Days in the period: 90; Target days of inventory: 30.
a-b/c*d. Result: RUB 3,000,000 - Related metrics
Version 1.0 · valid from 2026-11-16 · checked 2026-11-16
Related pages
- Term: Excess stock
- Calculation: Days of inventory and excess stock
Definition
Excess stock: the part of the balance above the target level set in days of sales. It is counted at cost for each category or item separately and shows how much money is frozen above the norm and how much will have to be sold at a discount.
This is money frozen above the norm. Suppose monthly sales at cost are RUB 3 million, the target is 60 days and stock is RUB 9 million: the norm is 6m, the excess RUB 3 million. Before cutting the price find the cause: buying, season or a slow category.