Days of inventory and excess stock
Shows how many days of sales sit in stock for each category, how much money is frozen above target, and what carrying that excess costs. For seasonal businesses first calculate average stock in Average stock for the year: here you enter the average stock of each category for the period, and categories are compared with each other.
At a glance
- What question does it answer?
- How many days of sales sit in stock for each category and how much money is frozen above target.
- What data is needed?
- Sales at cost for the period by category.
- How to read the result?
- Look at days of inventory and excess by category: a red excess means stock is longer than the target. If days of inventory grow faster than sales, buying outruns demand. Read the carrying cost as a lower estimate: storage and shrinkage are not included. Example on the default values: stock covers 137 days of sales against a target of 120 days, turnover 2.67. RUB 2.22m (11% of stock) lies above target: footwear (164 days) and outerwear (161 days) are above it, while accessories have their own target of 150 days and sit below it. The excess by category with shortfalls not netted is RUB 3.12m and holding it at 18% a year costs about RUB 0.56m a year.
Why and how to reason
Stock cannot be judged in roubles: RUB 5 m of goods is a lot for dresses that sell RUB 100 k a month and little for shoes that sell RUB 500 k. So the calculation converts roubles into days: how many days of sales sit on the shelf. We take sales at cost (stock is valued at cost too, so the basis is the same), divide by the days of the period and get the daily “burn” of stock. Stock divided by daily burn is days of inventory.
Then we compare with a target. Each category has its own: a coat with a long lead time needs more than a T-shirt. The excess is counted per category, because surplus coats are not offset by a shortage of accessories: the cash is still frozen in coats.
Example on the default values. Outerwear sells RUB 12.5 m in 365 days and holds RUB 5.5 m: 5.5 / 12.5 x 365 is about 161 days against a target of 120, so about RUB 1.39 m is surplus. Footwear is at 164 days, surplus about RUB 1.73 m. Knitwear and dresses are below target. We multiply the frozen surplus by the 18% cost of capital: 3.12 m x 0.18 is about RUB 0.56 m a year.
When to use it
It fits when you must decide where to cut buying and what to clear, and when categories sell at different speeds. It suits a regular monthly review. It is a poor single measure for strongly seasonal ranges: a balance on one date in October and in July gives different days, so take the yearly average stock first. The assumption is that the next weeks of sales resemble the period average. If you are preparing for a peak, high days of inventory can be a deliberate choice.
How to read the result
Look at three numbers. Network days of inventory (137 in the example) show the overall level; compare with the target. Surplus net of shortages (RUB 2.22 m) shows the net deviation, while the gross excess (RUB 3.12 m) shows how much cash really sits spare inside individual categories: for clearing decisions rely on the second. The carrying cost (RUB 0.56 m a year) turns surplus into roubles of loss. Decision: categories with the biggest excess go to clearance or have reorders stopped, while categories below target are checked for undersupply. Next step: look at stock age and GMROI for the same categories.
Common mistakes
A frequent error is to enter stock at selling price while sales are at cost: days of inventory are then overstated by the markup. Another is to take one season of sales and divide by 365 days. A third is to give every category the same target and punish a category with a long lead time. A fourth is to celebrate low days of inventory without checking that sizes are actually missing.
What data is needed?
- Sales at cost for the period by category.
- Average stock at cost for the same period (an average over dates, not one date’s balance).
- Target days of inventory and cost of capital.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Days in the sales period | days | 365 | A year is 365 days, a season about 182. Sales in the table must be for the same period. |
| Target days of inventory | days | 120 | How many days of sales you are willing to hold. You can set a separate target per category in the table. The default is set for apparel; for footwear, accessories and children’s take your own data. |
| Cost of capital | % a year | 18 | Illustrative 18% a year: replace it with your loan rate or the return you give up. |
How it is calculated
| Step | Formula |
|---|---|
| Days of stock | Stock ÷ (Sales ÷ days in period) |
| Target stock | Sales ÷ days in period × target days |
| Excess | Actual stock − target stock |
| Carrying cost | Sum of category excesses × cost of capital |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Days of stock
- 137 daysStock ÷ average daily sales, at cost.
- Turnover
- 2.67×How many times a year the stock sells through and is replaced.
- Excess stock
- 2.22 m ₽Stock above (or below) the target across included categories.
- Excess by category, shortfalls not netted
- 3.12 m ₽The sum of excess only in categories where stock is above target. The carrying cost is based on it.
- Yearly cost of carrying the excess
- 562,192 ₽Excess by category (shortfalls not netted) × cost of capital; excluding storage and shrinkage.
By category
| Category | Days | Target, days | Target stock | Excess (+) / shortfall (−) |
|---|---|---|---|---|
| Outerwear | 161 | 120 | 4.11 m ₽ | 1.39 m ₽ |
| Knitwear | 112 | 120 | 4.27 m ₽ | −273,973 ₽ |
| Dresses | 111 | 120 | 3.78 m ₽ | −280,822 ₽ |
| Accessories | 122 | 150 | 1.85 m ₽ | −349,315 ₽ |
| Footwear | 164 | 120 | 4.77 m ₽ | 1.73 m ₽ |
2.22 m ₽ (11 % of stock) sits above target. First find where it came from: buying, seasonality or a slow category. A discount clears it but costs margin.
Nuances and limits
- Do not use one date’s balance for a seasonal business: at peak it is deceptively low, after season high.
- The goal differs by category: shorter for basics, longer for seasonal apparel. Set your own target in the table.