Stock age and price-reduction provision
Splits stock by age, shows the share of old goods, the expected loss on clearance and the cost of holding the stock.
At a glance
- What question does it answer?
- How much stock has aged, what it costs to hold and what loss to allow for on clearance.
- What data is needed?
- Stock at cost by age group: up to 3 months, 3–6, 6–12, over a year.
- How to read the result?
- The main figure is the share of old stock. There is no single norm in Russia: enter your own threshold from past seasons and meanwhile compare the share with the previous period: a rising share is a signal to act. The provision shows the order of losses to put in the markdown budget. Take expected losses from the results of past clearances. Example on the default values: stock is RUB 80m, of which RUB 20m (25%) is older than 6 months, average age 4.9 months. The price-reduction provision is RUB 9.7m and holding the stock costs RUB 14.4m a year.
Why and how to reason
Goods “age”: the longer they sit, the lower the chance to sell at full price and the more the price will have to be cut. So stock is split by age and for each group an expected loss on sale is set. Markdown reserve = group stock x expected loss. This is not an actual expense but an estimate of how much you will give to buyers in the future.
Share of old stock is the part aged at least the threshold. Carrying cost = stock x (cost of capital + storage): what it costs to hold the goods for a year.
Example. Stock RUB 80 m: RUB 38 m under 3 months (loss 0), RUB 22 m 3-6 months (10%), RUB 14 m 6-12 (30%), RUB 6 m over a year (55%). Reserve 2.2 + 4.2 + 3.3 = RUB 9.7 m. Old stock (from 6 months) RUB 20 m, which is 25%. Carrying cost 80 x 18% = RUB 14.4 m a year.
When to use it
Reach for it in the monthly stock review and when preparing to close the period: to decide how much to reserve and what to clear. Enter loss percentages from your clearance experience. Assumption: loss depends only on age, though in practice also on category. For seasonal goods compute within the season, otherwise last season’s new arrivals count as old.
How to read the result
Look at the share of old stock: 25% means a quarter of the cash in stock has lain long. The reserve (RUB 9.7 m) shows what its clearance will cost, and if it is not reflected in the plan, profit will be overstated. The average age of 4.9 months helps track dynamics. Decision: define goods for clearance and timing, stop buying in categories with a high share of old stock, and compare with the allowed share if you have set one. Determine which goods in the old groups can be sold before the end of the season at a moderate discount and which must be cleared at once: waiting only makes it costlier.
Common mistakes
The usual mistakes: counting age from the order date rather than receipt at the warehouse; not updating the loss percentages; not separating “does not sell” from “waits for season”. Also: confusing the reserve with an actual write-off. Also: reserving only the oldest groups and forgetting the middle one, where loss also accumulates.
What data is needed?
- Stock at cost by age group: up to 3 months, 3–6, 6–12, over a year.
- The average age of each group in months and the threshold from which stock counts as old.
- Optional: expected value loss by group and storage cost.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Stock is old from | months | 6 | A group counts as old if its lower age bound (column “From age”) is at least this threshold; if the bound is empty, the group’s average age is used. |
| Acceptable share of old stock (optional) | % | — | Leave empty if you have no target: there is no single benchmark in Russia, enter your own data. If set, the indicator is colored against this threshold. |
| Cost of capital | % a year | 18 | Illustrative 18% a year: replace it with your loan rate or the return you give up. |
| Storage and shrinkage (optional) | % of stock value a year | 0 | Warehouse, insurance, shrinkage, mis-picks. Optional. Empty: the field is ignored (counted as zero in sums). |
How it is calculated
| Step | Formula |
|---|---|
| Old stock | Σ stock of groups aged at least the threshold |
| Provision | Σ stock × expected loss |
| Holding | Stock × (cost of capital + storage) |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Total stock
- 80 m ₽
- Share of old stock
- 25 % · 20 m ₽
- Price-reduction provision
- 9.7 m ₽Expected loss of value when the stock is cleared.
- Average stock age
- 4.9 months
- Annual cost of holding the stock
- 14.4 m ₽Of which on old stock: 3.6 m ₽
Stock, losses and holding
| Age | Stock | Share | Loss | Holding a year |
|---|---|---|---|---|
| 0–3 months | 38 m ₽ | 48 % | 0 ₽ | 6.84 m ₽ |
| 3–6 months | 22 m ₽ | 28 % | 2.2 m ₽ | 3.96 m ₽ |
| 6–12 months | 14 m ₽ | 18 % | 4.2 m ₽ | 2.52 m ₽ |
| Over a year | 6 m ₽ | 8 % | 3.3 m ₽ | 1.08 m ₽ |
Old stock is 20 m ₽ (25 %). Decide on it first: clearance, moving to another channel or write-off. Assess the pace and depth of the discount in “Discount payback” and “Sell-through pace”.
Nuances and limits
- Count age from the receipt date, not the order date.
- Do not mix seasonal and basic goods: basics age differently.