Syntha Lab RU

Stock turnover and dead stock

The document shows how fast stock turns into money, where it has stalled and what storage costs. It decides what to sell off and with what depth of price reduction, what to reorder, what write-down reserve to create and when to stop carrying an item in the assortment.

Commerce and buying Brand and retail Verified: 2026-11-13

Open interactively →

Why this document

Stale goods cost money twice: cash is frozen in them and missing for new purchases, and each month they must be sold cheaper. Turnover shows the problem before it becomes a loss: by category, size and season it reveals what sits beyond the norm. The commercial director plans the clearance by it, the finance director creates the write-down reserve, and the buyer decides what not to reorder. Without it dead stock builds up for years and shows only at stocktaking.

At a glance

What is this document and why is it needed?
The document shows how fast stock turns into money, where it has stalled and what storage costs. It decides what to sell off and with what depth of price reduction, what to reorder, what write-down reserve to create and when to stop carrying an item in the assortment.
Who owns the document and how often is it rebuilt?
Retailer: financial controller and category manager, monthly and per season. Brand: planner and finance director, monthly; sale decisions are made by the commercial director.
What mistakes are the most common?
Turnover from the last-date balance → distortion from the peak → use the monthly average. One figure for the whole chain → problem categories are hidden → compute by category and age. Dead stock is set by term without season → well-selling core lands in dead stock → separate rules for core and fashion.

For whom

Brand
A brand reviews turnover by season and channel: warehouse, wholesale, own stores; it counts stock at partners (consignment) separately. Age matters by collection season: leftovers of last autumn-winter lose value faster than basic styles. Dead stock is assessed with carryover and sale channels (outlet, stock partners) in mind.
Retail
A retailer computes turnover by category and store, stock age from the receipt date and ABC-XYZ by revenue and demand stability. Repricing and transfers between stores follow age and WOS; a reserve is created for stock older than the set term.

What it consists of

The main table

  • Category or SKU: average stock at cost, cost of goods sold (COGS) for the year, turnover, days inventory (DIO), GMROI.
  • Age buckets: 0-90, 91-180, 181-365, over 365 days; the share of each in money and units.

ABC-XYZ

  • ABC: contribution to revenue or margin (A is roughly 80% of cumulative contribution, B up to 95%, C the rest: the thresholds are editable).
  • XYZ: the coefficient of variation of demand: X stable, Y moderately volatile, Z unstable (thresholds editable).

Reserve and safety stock

  • Reserve for price reduction: stock older than the term × reserve rate; the rate is set by policy.
  • Safety stock: weekly demand sigma, lead time and the target service level (the “Reorder point and safety stock” calculation).

ABC-XYZ and GMROI in numbers

  • The rule: ABC by cumulative revenue share (A up to 80%, B up to 95%, C the rest; an item belongs to the group by the cumulative share before it), XYZ by the coefficient of variation CV = standard deviation ÷ mean of monthly sales: X for CV up to 0.3, Y up to 0.6, Z above; the standard deviation uses the divisor n (the number of months), as in the platform ABC-XYZ matrix calculation, and the 30 and 60% limits are the same as there. The thresholds are editable hints, not norms: change them in the calculation if your range has a different volatility.
  • Basic tee: RUB 4.89 million over 6 months, share 28.6%, cumulative 28.6%, class A; CV 0.02, class X; zone AX. Monthly sales, RUB thousand: 820, 790, 840, 810, 800, 830.
  • Jeans: RUB 3.75 million over 6 months, share 21.9%, cumulative 50.5%, class A; CV 0.07, class X; zone AX. Monthly sales, RUB thousand: 610, 650, 560, 700, 640, 590.
  • Jacket: RUB 3.2 million over 6 months, share 18.7%, cumulative 69.2%, class A; CV 0.85, class Z; zone AZ. Monthly sales, RUB thousand: 0, 40, 260, 780, 1,180, 940.
  • Midi dress: RUB 2.34 million over 6 months, share 13.7%, cumulative 82.9%, class A; CV 0.43, class Y; zone AY. Monthly sales, RUB thousand: 300, 520, 180, 640, 220, 480.
  • Sneakers: RUB 1.265 million over 6 months, share 7.4%, cumulative 90.2%, class B; CV 0.06, class X; zone BX. Monthly sales, RUB thousand: 210, 200, 230, 190, 220, 215.
  • Sweater: RUB 950 thousand over 6 months, share 5.6%, cumulative 95.8%, class B; CV 0.08, class X; zone BX. Monthly sales, RUB thousand: 140, 150, 160, 170, 150, 180.
  • Bag: RUB 600 thousand over 6 months, share 3.5%, cumulative 99.3%, class C; CV 0.37, class Y; zone CY. Monthly sales, RUB thousand: 90, 60, 140, 70, 160, 80.
  • Scarf: RUB 120 thousand over 6 months, share 0.7%, cumulative 100%, class C; CV 1.03, class Z; zone CZ. Monthly sales, RUB thousand: 5, 0, 30, 60, 20, 5.
  • What to do by zone: AX and BX are held with deep stock and auto-replenishment; AZ (the seasonal jacket with CV 0.85) is ordered by the season plan without replenishment; CZ is cleared and not reordered. For fashion the weekly demand σ per SKU is undefined (the item lives one collection), so safety stock z × σ × √(L+R) is computed at the level of core items and categories, while for fashion the category forecast error is used.
  • GMROI = gross profit ÷ average stock at cost (a table column): the gross profit of a category is COGS × margin ÷ (1 − margin); the chain has 2.7. The denominator is the average stock, not the closing balance: the example table uses the average.

Brand and retailer: what is computed differently

  • Brand: turnover is computed by collection season and channel (warehouse, wholesale, own stores), with stock at consignment partners separately; the leftover of the past autumn-winter loses value faster than core items, so age buckets are tied to the collection.
  • Brand: the brand dead stock is handled by returning materials to the supplier, moving to the outlet and own site or selling to partners at a discount; the reserve is created on the remainder that will not pass through these channels.
  • Retailer: turnover is computed by category and store, stock age by receipt date, ABC-XYZ by revenue and demand stability; transfers between stores and markdowns follow age and WOS.
  • Retailer: the reserve is created on stock older than the policy term; GMROI by category shows where money in stock works worse, and clearance and a purchase review are aimed there.

Brand: how the document differs and what to add

  • Brand: brand turnover is computed by collection and channel: warehouse, wholesale, own stores, consignment; a total DIO hides that last-collection remnants age faster than basics.
  • Brand: brand ABC-XYZ is built by model and color: a color may be class C within a class A model, and the SKU decision differs from the model one.
  • Brand: brand dead stock is handled by returning materials to the supplier, moving to the outlet and own site or selling to partners at a discount; the reserve is created on what will not pass through these channels.
  • Brand: brand GMROI is computed by line: a high margin with long stock can give lower GMROI than a basic line with a lower margin.
  • Brand: brand safety stock depends on production time and MOQ: with a 90-day cycle safety stock in weeks is higher than at the retailer.
  • Brand: consignment stock at partners is included in brand DIO, otherwise the metric looks better than reality.

Retailer: how the document differs and what to add

  • Retailer: retailer turnover is computed by category and store: stock age by receipt date, ABC-XYZ by revenue and demand stability.
  • Retailer: transfers between stores and price reductions follow age and WOS: first transfer, then price reduction, then clearance.
  • Retailer: the reserve is created on stock older than the policy term by category; GMROI shows where money in stock works worse, and clearance is aimed there.
  • Retailer: seasonal categories (outerwear, footwear) are compared within the season: annual turnover of seasonal goods is distorted by the off-season.
  • Retailer: the distribution center and stores are counted separately: warehouse stock awaits distribution and must not hide store overload.
  • Retailer: seasonal clearance is planned by age in weeks from shelf entry; growth of stock older than the policy term starts the price reduction ladder.

How to read the result and which decisions follow

  • Category GMROI below 1.0 (a guide): a rouble of stock brings less than a rouble of gross profit; cut orders, speed up sales, revisit the category assortment.
  • AZ SKUs (high contribution, unstable demand): order by the seasonal plan without automatic replenishment; do not replenish CZ and clear them.
  • The share of stock older than the policy term is above 15% of the category (a guide): create a reserve and a clearance plan before the season ends; later the price will fall further.

Control checks

  • ABC shares: the cumulative share of the last item 100%, items in the matrix 8 of 8; stock by category 18 + 26 + 9 + 22 + 7 + 8 = RUB 90 m, COGS RUB 233 m, chain turnover 2.59 times = 141 days; chain GMROI 2.7 = gross profit 242.9 ÷ stock RUB 90 m.
  • Average stock is computed from balances within the period, not only the end; COGS and stock are valued the same way (with or without reserve).
  • ABC classes add up to 100% of revenue, the number of SKUs in the matrix equals the number in the calculation.
  • Typical traps: turnover on closing stock, CV of a seasonal item over the whole year, GMROI without the average markup, a reserve without the tax caveat.

Where the data comes from

Data sourceFields
Warehouse recordsStock at cost at the end of each month, the receipt date of each batch.
SalesCOGS by category and SKU; weekly sales for XYZ.
Accounting policyThe dead-stock term and reserve rates; agree with your accountant.

How to build it step by step

  1. Step 1. Build average stock: the average of opening and closing balances of each month (not only the last date).
  2. Step 2. Compute turnover and days inventory by category.
  3. Step 3. Split stock by age: batch receipt date against the computation date.
  4. Step 4. Run ABC by revenue and XYZ by weekly sales; highlight the AZ and CZ zones.
  5. Step 5. Define dead stock: no sales for 6-12 months (the term is set by policy, not by a norm).
  6. Step 6. Estimate the reserve for price reduction: dead stock × reserve rate; compare it with the markdown market.
  7. Step 7. Decide per zone: sell down, move to the outlet, return to the supplier, reorder.
  8. Step 8. Show the owner: money in stock, age, reserve and the cash release plan.

Formulas

MeasureFormulasNote
TurnoverTurnover = Annual COGS ÷ Average stock (at cost)The “Average stock for the year and turnover” calculation.
Days inventoryDIO = 365 ÷ TurnoverFor a seasonal business compute per season, not per year.
GMROIGMROI = Annual gross profit ÷ Average stock at costThe “GMROI” calculation.
ReserveReserve = Stock older than the term × Reserve rateThe rate depends on policy and the sale channel; 30% in the example is a hint (not a norm).
Safety stockSS = z × σ(weekly demand) × √(lead time + review period)z sets the service level, for example 1.65 for 95%.
Coefficient of variationCV = √(Σ(x_i − x̄)² ÷ n) ÷ x̄On monthly item sales over 6 to 12 months; compare seasonal items within the season, otherwise CV rises only because of seasonality.

Formulas in notation

Days of inventory
DIO = 365 / T
Average days from receipt to sale; computed by category.

Worked example

Retailer: turnover for six categories for a year, RUB m at cost (an independent example, not tied to Models B and R)

CategoryAverage stock (mean of month-start and month-end balances)Annual COGSTurnover, timesDays inventoryStock over 12 months oldOld share, %Reserve at 30%GMROI, RUB per RUB of stock
Dresses and skirts18613.391081.68.90.483.67
Outerwear26481.851984.416.91.321.85
Knitwear9364910.55.60.155.09
Footwear22522.361543.917.71.172.01
Bags and accessories7121.712131.115.70.332.37
Kids82431221.2150.362.77
Total902332.5914112.714.13.812.7

Stock of RUB 90 m turns 2.59 times a year (141 days). Outerwear and footwear hold the largest share of old stock (16.9% and 17.7%): clearance and purchase reviews are aimed there. The reserve of RUB 3.81 m is shown as an order of magnitude; the real rate is set by accounting policy. Chain GMROI is RUB 2.7 of gross profit per rouble of stock: the lowest GMROI is in “Outerwear” (1.85), the highest in “Knitwear” (5.09); footwear 2.01: money in the weakest categories works worst and clearance and a purchase review go there; no category is below one. For tax purposes a reserve for inventory impairment is not recognized as an expense, so a temporary difference arises in accounting; in the management report it is shown separately.

Figures

ABC-XYZ matrix: number of SKUs per zone
Heat map: 3×3; min 0, max 2XXYYZZAA2A / X: 21A / Y: 11A / Z: 1BB2B / X: 20B / Y: 00B / Z: 0CC0C / X: 01C / Y: 11C / Z: 1
  • 0 … 2 articles
Data as a table
XYZ
A211
B200
C011

ABC-XYZ matrix: number of SKUs per zone. The row is contribution to revenue (A: up to 80%, B: up to 95%), the column is demand stability (X, Y, Z by coefficient of variation); AX and BX zones are kept deep in stock, CZ is cleared.

GMROI by category
Bar chart: Dresses and skirts 3.67, Outerwear 1.85, Knitwear 5.09, Footwear 2.01, Bags and accessories 2.37, Kids 2.770123456Dresses and skirtsDresses and skirtsGMROI: 3.673.67OuterwearOuterwearGMROI: 1.851.85KnitwearKnitwearGMROI: 5.095.09FootwearFootwearGMROI: 2.012.01Bags and accessoriesBags and accessoriesGMROI: 2.372.37KidsKidsGMROI: 2.772.77×
Data as a table
MeasureGMROI
Dresses and skirts3.67
Outerwear1.85
Knitwear5.09
Footwear2.01
Bags and accessories2.37
Kids2.77

GMROI by category. How much gross profit a rouble of average stock yields: below one a category holds money in stock without return; in the example none is below one, the weakest is outerwear.

Days of inventory (DIO) by category
Bar chart: Dresses and skirts 108, Outerwear 198, Knitwear 91, Footwear 154, Bags and accessories 213, Kids 122050100150200250Dresses and skirtsDresses and skirtsDIO: 108108OuterwearOuterwearDIO: 198198KnitwearKnitwearDIO: 9191FootwearFootwearDIO: 154154Bags and accessoriesBags and accessoriesDIO: 213213KidsKidsDIO: 122122days
Data as a table
MeasureDIO
Dresses and skirts108
Outerwear198
Knitwear91
Footwear154
Bags and accessories213
Kids122

Days of inventory (DIO) by category. 365 days divided by turns: the taller the bar, the longer money lies on the shelf; in the example accessories and outerwear stay longest.

Specifics by category

Apparel
Count turnover by collection season: the annual figure hides imbalance. Stock older than a season is valued at the reduced price; basics can carry over without loss, fashion cannot.
Footwear
Turnover is lower than in apparel: a wide size run holds stock in extreme sizes. Dead stock is often sizes; options: transfers between stores, supplier returns, clearance of size remaining stock. The old share is high (see the example).
Accessories
Turnover is lower, but dead stock is cheaper to hold (no sizes, no seasonal spoilage); bags and belts are often carried over. Shrink is higher, so “missing” stock is often wrongly counted as dead.
Kids
Stock by size and age loses value faster: the child outgrows the size, and the school and winter seasons are tied to dates. Reserves are created earlier and clearance is planned for the end of the season.
Men
Higher turnover of basics and repeat sales: dead stock is mostly seasonal fashion items. Basics stock carries over without loss.
Women
More fashion and more dead stock; turnover differs strongly between core and fashion, so analysis by group is mandatory. Micro-seasons call for weekly age monitoring.

Common mistakes

  • Turnover from the last-date balance → distortion from the peak → use the monthly average.
  • One figure for the whole chain → problem categories are hidden → compute by category and age.
  • Dead stock is set by term without season → well-selling core lands in dead stock → separate rules for core and fashion.
  • The reserve is created retroactively at year end → a sudden profit hit → create it quarterly by rule.
  • The cost of holding and frozen money is not counted → a markdown looks like a “loss” → compare with the cost of money (key rate) and warehouse space.

Russian specifics

  • Inventory is valued at the lower of cost and net realizable value (FSBU 5/2019); discuss the impairment provision with your accountant.
  • For corporate income tax a reserve for inventory impairment is not recognized as an expense (unlike a doubtful debts reserve): a temporary difference arises between accounting and tax profit. The norm in the register was matched by title only: not checked against the text. Rule: Tax Code Art. 284: Tax Code, Art. 284 (corporate income tax rates) (rule check not completed).
  • Clearance of unmarked stock is limited by the marking dates; plan clearance before the set dates. Rule: Decree 2129 of 25.12.2025: Government Decree of 25.12.2025 No. 2129 (amendments to Decree No. 1956; fourth marking wave).

Open interactively →