Excess stock
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.
Formula
Actual stock − (sales ÷ days × target days)
How to read
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.
Where it is discussed
Topics
Calculations
- Days of inventory and excess stock
- Stock age and price-reduction provision
- Buying plan adherence: receipts, sales and stock
Documents
- Stock turnover and dead stock
- Provision for inventory impairment: FSBU 5/2019, IAS 2, net realizable value