Syntha Lab RU

Excess stock

Actual stock − (sales ÷ days × target days of inventory), at cost

Open interactively →

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

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.

Open interactively →