Average stock
Average of stock at the end of several months (or weeks) at cost
- Formula
Average of stock at the end of several months (or weeks) at cost- Unit
- RUB
- Aggregation rule
- Average over dates
- Source system
- Warehouse and stock system; ERP and accounting system
- Owning role
- Chief financial officer
- Frequency
- Monthly
Passport
- Grain
- Store or warehouse × snapshot date, then period
- Numerator
- Sum of stock at snapshot dates, at cost
- Denominator
- Number of snapshots
- At zero or no data
- No snapshots in the period: show “—”.
- Limits
- Include the start and end of the period and several dates between. One date distorts a seasonal business. Cost, not retail.
- Check example
- Opening stock, RUB: 11000000; First mid-period stock, RUB: 13000000; Second mid-period stock, RUB: 12000000; Closing stock, RUB: 12000000.
(a+b+c+d)/4. Result: RUB 12,000,000 - Related metrics
Version 1.0 · valid from 2026-11-16 · checked 2026-11-16
Related pages
- Term: Average stock
- Calculation: Average stock for the year and turnover
Definition
The average balance of goods over a period, calculated from several dates rather than one.
For a seasonal business a one-date balance misleads; use the average by month or by week.