Average stock for the year and turnover
Calculates average stock from monthly balances, turnover and days of inventory and shows how far a one-date balance distorts the picture in a seasonal business.
At a glance
- What question does it answer?
- What our average stock is over the year, how fast it turns and how far a one-date balance distorts the picture.
- What data is needed?
- Month-end balance at cost for each month.
- How to read the result?
- Compare turnover on average stock with turnover on the last-date balance: a large gap means the date balance is atypical. The range between peak and low is the seasonal cash need. Then look at days of inventory by category in “Days of inventory and excess capital”. Example on the default values: average stock over the year is RUB 21m, turnover 2.67 turns, which is 137 days of inventory; the last date’s balance alone (RUB 25m in December) would give 2.24 turns, a change caused only by the chosen date. The stock range over the year is RUB 11m.
Why and how to reason
A balance on one date misleads in a seasonal business: in October the warehouse is full before the peak, in January after clearance it is almost empty. If you judge by October, turnover looks understated, by January overstated. So the average stock is used: the sum of month-end balances / number of months.
Turnover = annual sales at cost / average stock: how many times a year the stock “turns over”. Days of inventory = days in a year / turnover.
Example. Month-end balances sum to RUB 252 m, so average stock is RUB 21 m. Annual cost of sales RUB 56 m: turnover 2.67, days of inventory 137. If computed from the December balance (RUB 25 m), turnover is 2.24, a worse picture. The range from 16 to 27 m (RUB 11 m) shows the strength of seasonality: the peak needs 1.7 times more cash than January.
When to use it
It is useful before comparing turnover of categories or periods and before computing GMROI and the cash conversion cycle. Suitable for seasonal businesses. Assumption: month-end balances reflect the average level inside the month. With sharp spikes inside a month add weekly data. Take sales at cost, like stock. For accuracy take balances at both the end and the start of the period.
How to read the result
Compare turnover with your target, if you set one, and with last year. The stock range shows how much cash is needed at the peak: financing must cover it. The difference between turnover on the average and on the last balance shows how much the report date misleads you. Decision: use average stock for plans and comparisons, and the stock peak for planning cash. Be sure to compare with the turnover target, if any, and with last year for the same months. Check in which months stock is above the norm and look for the cause: early arrivals, weak sales or overbuying. Then carry the result into GMROI and the cash cycle.
Common mistakes
Typical trap: mixing beginning and end month balances; computing sales at selling price; including 13 balances instead of 12; ignoring goods in transit. Also: comparing turnover of seasonal and year-round categories. Also: averaging without allowing for different month lengths and delivery periods; the differences are small but accumulate.
What data is needed?
- Month-end balance at cost for each month.
- Sales at cost for the same months.
- Optional: target turnover per year.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Days in a year | days | 365 | How many days of the year to use for days of inventory: 365 or 366. |
| Target turnover per year (optional) | turns | 0 | If set we show how much stock is surplus to the target. The default is set for apparel; for footwear, accessories and children’s take your own data. Optional. Empty: the field is ignored (counted as zero in sums). |
How it is calculated
| Step | Formula |
|---|---|
| Average stock | Σ month-end balances ÷ number of months |
| Turnover | Annual sales at cost ÷ average stock |
| Days of stock | Days in year ÷ turnover |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Average stock
- 21 m ₽
- Turnover per year
- 2.67× turns
- Days of stock
- 137 days
- Turnover on the last-date balance
- 2.24×Differs from average by 16 %: the closing balance is above average.
- Stock range
- 11 m ₽ · January → OctoberThe difference between peak and low: how much the cash need rises at the peak.
Balance and cover by month
| Month | Balance | Sales | Cover, days |
|---|---|---|---|
| January | 16 m ₽ | 3.6 m ₽ | 133 |
| February | 16.5 m ₽ | 3.4 m ₽ | 146 |
| March | 18 m ₽ | 4.2 m ₽ | 129 |
| April | 21 m ₽ | 4.4 m ₽ | 143 |
| May | 20 m ₽ | 4.2 m ₽ | 143 |
| June | 18.5 m ₽ | 3.8 m ₽ | 146 |
| July | 18 m ₽ | 3.6 m ₽ | 150 |
| August | 21 m ₽ | 4.4 m ₽ | 143 |
| September | 25 m ₽ | 5.6 m ₽ | 134 |
| October | 27 m ₽ | 6.4 m ₽ | 127 |
| November | 26 m ₽ | 6.6 m ₽ | 118 |
| December | 25 m ₽ | 5.8 m ₽ | 129 |
For a seasonal business use average monthly balances: a one-date balance at the peak understates days of stock and after the season overstates them.
Nuances and limits
- Do not average the opening and closing balances for a seasonal business: the peak between them disappears.
- Take sales and balance on one basis, at cost, not at selling price.