Syntha Lab RU

Assortment and sizes

What brings revenue and how to split a buy across sizes.

For retail Planning and buying

Open interactively →

About the topic

An assortment is the set of goods you offer, and the size curve and store allocation decide where and in what quantity you end up with exactly what is needed. The topic “Range and sizes” answers three buyer questions before ordering and when goods arrive: what forms the core that brings the main money; how to split the buy by size so you do not end up with a tail of extreme sizes; and how to divide a shipment between stores so goods do not have to be driven around town later.

Start with the core. ABC analysis ranks SKUs by contribution to revenue or margin and divides them into groups: A are those that together give about 80% of the result, B the next 15% or so, C the rest. Illustrative example: out of 200 SKUs, 28 give 80% of revenue. That is the core: it must not be left without sizes and should be reordered first. The 110 SKUs of group C give only a few percent and they dilute the range, add work and stock. But the conclusion “drop all of C” is too simple: some items hold the brand image or new arrivals have not had time to sell.

The size curve shows the share of sales by size. Illustrative example for women’s shoes, a buy of 1,000 pairs: from history size 36 is 5%, 37 is 10%, 38 is 20%, 39 is 25%, 40 is 20%, 41 is 12%, 42 is 8%. The order is then split 50, 100, 200, 250, 200, 120, 80 pairs. If you buy 143 pairs of each, the extreme sizes remain in stock and the middle sizes run out in the second week. The curve must be specific to category, style and channel: sneakers, boots and ankle boots sell in different sizes, and a region’s share of large sizes may differ from the capital’s.

Allocation by store divides the shipment between points. The simple rule is by sales share, but a new store has no history, a store under renovation has had a temporary dip, and a flagship has many tourists. So shares are adjusted and part of the shipment stays in the warehouse for replenishment: if everything is sent out at once, the error goes to all stores at once and has to be fixed with transfers.

Start with ABC on one metric, then build the size curve for the core, then allocate the shipment with adjustment. Typical traps: splitting by different metrics in one list, putting into the core items that sold only in promotion, buying on the average curve of the whole chain and forgetting that a size is not a label but a different demand.

Key ideas

ABC: the core of the range

The choice of metric decides who enters the core. A basic T-shirt sold RUB 2.0 million at a 30% margin, so it gives 0.6 million; a jacket sold 1.5 million at a 55% margin and gives 0.825 million. By revenue the T-shirt leads, by margin the jacket. The metric is fixed before the calculation, not picked afterwards, otherwise the list is built to fit the desired conclusion.

The size curve

A curve built from sales is distorted by stockouts: a size that was not on the shelf “sold” less than it could. Size 39 sold 50 pairs but was in stock only 2 weeks out of 6. The pace when available is 25 pairs a week, over all 6 weeks it would have been about 150, three times the recorded figure. Count shares over the weeks with stock or adjust them for the shortage.

Store clusters

Stores with similar demand are grouped into clusters and each gets its own curve. If large sizes are 30% in the capital and 15% in a region, a common curve errs in both. There are usually 3–5 clusters: more becomes too noisy.

Allocation with a reserve

A shipment of 600 units: 450 to stores by sales share with adjustment, 150 held in the warehouse. The warehouse protects against allocation error and serves hits. A 25% reserve looks cautious but costs less than transfers.

Breadth and depth

Breadth is how many different styles, depth is how many units of each. With a fixed budget of RUB 44 million you can buy many styles shallowly or few styles deeply. The core deserves depth, experiments deserve small runs.

Margin after returns decides how many swimsuits to buy

Where a garment is tried on at home, sales before returns mislead. An order of 1,000 swimsuits at a weighted return rate of 28.5% brings back 285 units, of which 100 units are written off as hygiene scrap. The margin per kept unit is RUB 1,523, but per ordered unit after returns it is RUB 779 instead of RUB 1,403: returns eat 44.5% of the margin. The order total is RUB 778,510. The margin would reach zero at a return rate of 64.1%; the reserve is large but melts: each point of returns costs RUB 21.9 per ordered unit. The core and the depth of such a category are chosen by the margin per ordered unit, not by units sold.

Formula: Margin per ordered unit = (1 − ρ) × m − delivery − ρ × (return + handling) − ρ × scrap share × cost

What to do: Choose the depth by the margin per ordered unit and keep returns below the threshold, not by sales before returns.

Think first: Returns 28.5%, shelf price 4,200 ₽ with VAT. Do they eat a quarter of the margin or almost a half?

Answer: Almost a half: 44.5%. The margin per ordered unit falls from RUB 1,403 to RUB 779.

The assortment tail is estimated in roubles

Fixed costs per SKU and the flow of sales decide the fate of a band: on illustrative data it pays to cut 240 SKUs with a benefit of 6.18 m RUB.

Formula: Cutting benefit = fixed × SKUs − (1 − flow-over) × contribution

What to do: Do not cut image SKUs by the formula and repeat the estimate every season.

How to work through it

  1. Pick the ABC metric: revenue, margin or quantity, and do not change it during analysis.
  2. Exclude promotion periods or check that they did not distort the core list.
  3. Define groups A, B, C and decide for each: reorder, hold, cut.
  4. Build the size curve from history for the core and for each category separately.
  5. Group stores into clusters and get a curve for each.
  6. Split the buy by size and by cartons, accounting for the factory’s minimum quantities.
  7. When the shipment arrives, allocate to stores with adjustment and keep a reserve in the warehouse.
  8. Check the result against run completeness during the season.

Where to start

First ABC analysis shows the core range, then the size curve and clusters split the buy by size and finally allocation splits the run across stores. Calculations of the topic in order: “ABC analysis of the range”, “Size curve: how to split a buy across sizes”, “Size curve by store cluster and pack composition”, “Allocation of stock across stores”, “Size recommendation: payback of the tool”, “ABC-XYZ matrix: a SKU’s contribution to sales and demand stability”, “Choosing items under the buying budget and the shelf: a greedy set and an exact scan”, “Swimwear and lingerie: returns by size run, hygiene write-offs and margin per ordered unit”, “Store clusters: productivity and mix profile”, “Cost of assortment complexity: the SKU tail”. See also (their primary topic is another one): “Size-run completeness and core sizes”, “SKU classification: ABC and sell-through, bestsellers, slow sellers, no-sale”.

Calculations in this topic

  • ABC analysis of the range

    Splits styles or groups into A, B and C by contribution to revenue or margin: what feeds the business, the middle, and what can be cut.

    Which items give most revenue or margin and which can be cut.

  • Size curve: how to split a buy across sizes

    Uses sales by size to compute each size’s share and splits the quantity to buy across sizes. Compares with a flat split and shows how many units would end up in the wrong sizes.

    How to split the quantity to buy across sizes using historical sales.

  • Size curve by store cluster and pack composition

    Splits the buy across store clusters and sizes using each cluster’s past sales, picks the composition of a ready pack (prepack) for the cluster’s curve, rounds the buy to whole packs and shows how many pieces end up in the wrong sizes. Compares a pack per cluster with one pack for the whole chain, and picking to order with a ready pack.

    How many pieces of which sizes to send to each store cluster and which pack to choose.

  • Allocation of stock across stores

    Splits an incoming run across stores in proportion to their sales taking existing stock and capacity into account, keeping part at the warehouse for replenishment.

    How to split an incoming run across stores and how much to keep at the warehouse.

  • Size recommendation: payback of the tool

    Calculates whether an online size-recommendation tool (a widget, a measurement-based hint, a size chart) pays back: how many size returns it removes, what one return costs, the net effect per month and the payback of the launch cost. Shows the reduction in returns at which the tool breaks even.

    Whether a size-recommendation tool pays back and at which reduction in returns it breaks even.

  • ABC-XYZ matrix: a SKU’s contribution to sales and demand stability

    From a table of SKU sales over several periods splits them into classes A, B, C by contribution to sales and X, Y, Z by demand stability (the coefficient of variation), shows the matrix of sales shares and the number of SKUs and suggests a stock policy for each SKU.

    Which SKUs bring sales, which of them are stable, and what stock policy to assign to them.

  • Choosing items under the buying budget and the shelf: a greedy set and an exact scan

    From a list of items (each taken whole) chooses the set with the highest expected margin under the buying budget and shelf limits: a greedy set by margin per unit of scarcity and the exact set by scan, the gap between them, the use of the budget and the shelf and the value of an extra 10% of budget.

    Which items to take whole so that expected margin is highest under the budget and shelf limits and how far the simple greedy layout falls short of the best.

  • Swimwear and lingerie: returns by size run, hygiene write-offs and margin per ordered unit

    From the price, the cost, the channel commission, the logistics and a table of size groups (share of orders and share of returns) it counts the weighted return rate and the margin per ordered unit including returned goods that cannot be resold (the hygiene liner is removed, the item has been worn). It shows the loss caused by returns, returns in units, the return rate at which the margin falls to zero and the size groups that pull the margin down. Check the requirements for returning lingerie and swimwear and the list of items that cannot be resold after a return against the current sales rules; the share that cannot be resold and all default values are illustrative.

    How many returns the margin of a lingerie or swimwear item can bear, which size groups pull it down and how much goods is written off after a return.

  • Store clusters: productivity and mix profile

    Groups stores by the productivity index (sales per m² to the network average) and by the similarity of the category profile to the network profile. The result is clusters A, B, D and the “special profile” flag for the size curve, display and replenishment.

    Which stores are productive per m², which are weak and which have a category profile different from the network.

  • Cost of assortment complexity: the SKU tail

    For assortment bands (by revenue) counts the contribution, the fixed cost per SKU and the net result; shows what is better: to cut a band or to keep it if part of its sales moves to the remaining SKUs.

    Whether the assortment tail brings more than the fixed cost of its SKUs and what is better: to cut or to keep.

  • Size-run completeness and core sizes

    Finds the core sizes of a style, shows whether the run is intact, how many weeks of sales each size covers and which sizes to top up or redistribute.

    Whether a style’s size run is intact, which sizes to top up and which to redistribute.

  • SKU classification: ABC and sell-through, bestsellers, slow sellers, no-sale

    Ranks SKUs by net sales, assigns class A, B or C by the cumulative share and compares it with sell-through. A bestseller is class A with a high sell-through, a slow seller is one with a low sell-through, “no-sale” is a SKU with no sales. You set the thresholds; the calculation shows the quartiles of your data as a hint.

    Which SKUs are bestsellers, which are slow sellers and which do not sell at all, and how much stock lies in them.

Self-check questions

  • Is ABC calculated on one metric and for a period without distorting promotions?
  • Is the decision for group C made per item, not by a general rule?
  • Is the size curve built on your sales, not on general tables?
  • Does the curve account for returns and sales with gaps in the run, when sizes were missing?
  • Are stores grouped by demand, not by region on the map?
  • Does the new store avoid a “mature” share in the allocation?
  • Is part of the shipment left in the warehouse?
  • Does the order account for minimum quantities and cartons?

Knowledge check

Multiple-choice questions. The correct answer and the explanation follow each question.

  1. Items in descending order give 40, 25, 18, 8, 6 and 3% of revenue. The ABC thresholds are 80 and 95% of the cumulative share; an item is in A while the cumulative share before it is below the threshold. Which class is the third item?

    • A. A: 65% is accumulated before it, which is below 80%
    • B. B: with it the cumulative share is 83%, which is above 80%
    • C. C: its share is below 20%
    • D. It cannot be determined without stock levels

    Correct answer: A. A: 65% is accumulated before it, which is below 80%. Before the third item 40 + 25 = 65% is accumulated, which is below 80%, so it is in A (and the three A items give 83% of revenue). The fourth starts at 83% and goes to B, the fifth (from 91%) is also B, the sixth (from 97%) is C. Someone who looks at the cumulative share including the item itself will put the third into B. The size of the share alone does not set the class, and stock levels are not part of revenue-based ABC.

  2. Sales of an item over six periods: 20, 60, 40, 80, 60 and 40 units. XYZ thresholds by the coefficient of variation: X up to 30%, Y up to 60%, Z above (sample standard deviation, n − 1). Which class is it?

    • A. X: the standard deviation is about 21 units, which is small
    • B. Z: the range of 60 units is above the mean of 50, that is 120%
    • C. Y: CV is about 42%
    • D. It cannot be determined without the item price

    Correct answer: C. Y: CV is about 42%. The mean is 300 / 6 = 50. The sum of squared deviations is 900 + 100 + 100 + 900 + 100 + 100 = 2,200, the variance 2,200 / 5 = 440, the standard deviation ≈ 21. CV = 21 / 50 ≈ 42% (between 30 and 60), class Y. The answer “X” appears if the deviation of 21 is read as a percentage. The answer “Z” appears if the range (80 − 20) / 50 = 120% is used instead of the deviation. Price does not take part in XYZ: the class depends only on demand stability.

  3. Size shares are 8, 22, 28, 22, 12 and 8%, returns 34, 28, 24, 27, 33 and 38%. What is the weighted return rate?

    • A. 30.7%
    • B. 28.5%
    • C. 24%
    • D. 38%

    Correct answer: B. 28.5%. The sum of shares times returns ÷ the sum of shares: 28.5%. A simple average of the rows (30.7%) overstates: it ignores that the extreme sizes are bought less often. Covered in: Margin after returns decides how many swimsuits to buy.

  4. At what average return rate would the margin per ordered unit fall to zero at the same prices and costs?

    • A. 28.5%
    • B. 44.5%
    • C. 100%
    • D. 64.1%

    Correct answer: D. 64.1%. The threshold ρ* = (m − delivery) ÷ (m + return + handling + scrap share × cost) gives 64.1%. The current 28.5% is not the threshold; 44.5% of the margin is already eaten. Covered in: Margin after returns decides how many swimsuits to buy.

  5. The margin per kept unit is RUB 1,523. What is the margin per ORDERED unit after returns?

    • A. 1,523 ₽
    • B. 1,403 ₽
    • C. 624 ₽
    • D. 779 ₽

    Correct answer: D. 779 ₽. An ordered unit pays delivery, and a returned one also handling and scrap: RUB 779. RUB 1,403 is the margin without returns, RUB 624 the loss from them. Covered in: Margin after returns decides how many swimsuits to buy.

  6. What does the store productivity index show?

    • A. The total sales of the store
    • B. The number of employees
    • C. Sales per m² to the network average
    • D. The rent size

    Correct answer: C. Sales per m² to the network average. Clusters are built per m², not by total sales. Covered in: The assortment tail is estimated in roubles.

  7. When does cutting a band pay?

    • A. When the fixed costs exceed the part of the contribution that does not flow over
    • B. When revenue is small
    • C. When there are many SKUs
    • D. Always

    Correct answer: A. When the fixed costs exceed the part of the contribution that does not flow over. This is a cutting benefit above zero. Covered in: The assortment tail is estimated in roubles.

Common mistakes

  • Mistake: Classifying by different metrics in one list

    What it costs: High-revenue, low-margin SKUs enter the core

    How to avoid: One metric per analysis, the second as a check.

  • Mistake: Including promotional sales in the core

    What it costs: The core consists of discounted items

    How to avoid: Look at full price separately.

  • Mistake: Buying on the chain-average curve

    What it costs: Stores have shortages and excesses of different sizes

    How to avoid: Clusters.

  • Mistake: Allocating by sales share without adjusting for new stores

    What it costs: New points are short-changed

    How to avoid: Adjust for format and traffic.

  • Mistake: Sending out the whole shipment at once

    What it costs: The error reaches all stores

    How to avoid: Keep a warehouse reserve.

  • Mistake: The swimsuit core is picked by sales

    What it costs: The best-selling sizes give the worst margin after returns The margin lost from returns on the order: RUB 624,441.

    How to avoid: Rank by the margin per ordered unit Count the margin after returns per size group and move the depth to groups with a better fit and description.

    What it looks like (illustrative figures): Size M at returns of 24% gives RUB 878 per ordered unit, and XXL at 38% only RUB 572; by units both look equally “fast”.

  • Calling the tail loss-making by revenue

    What it looks like (illustrative figures): Fixed costs and flow-over are not counted.

Russia and the EAEU

Size charts in Russia are not entirely uniform: a Russian clothing size (for example 46) corresponds to a certain girth under interstate standards, but each brand has its own patterns and marketplace tables differ. For footwear the Russian Mondopoint or European scale is used; keep the conversion in a reference and always confirm it against the specific brand’s table. GOST numbers for sizes are not quoted in Lab: check the current edition before citing them in documents.

For marked goods in the Chestny ZNAK system a code is assigned to each unit together with the GTIN of the model and size: so the size curve directly determines the number of codes and the time to obtain them. A delay with codes for a popular size means lost sales. If goods are sold on marketplaces, size and color are set up as separate cards or variants, and size-related non-redemptions are higher there: a size table in the card reduces returns.

Regional differences in Russia are tangible: in cold-climate regions the share of bulky outerwear and large sizes is higher, in megacities the share of trend items is higher. Build clusters on your own sales, not on federal districts.

The principles are the same; size habits and demand differ. As a guide, check against your own sales: in Central Asia and Armenia European, Turkish and Chinese scales are more common, while Russia and Belarus rely on their own tables; for Kazakhstan, Kyrgyzstan and Armenia Lab has no confirmed uniform scale. The Customs Union technical regulations for clothing, footwear and textiles (TR CU 007, 017, 019) are common to all EAEU countries, but size tables and the size mark on the label remain the manufacturer’s matter. Allocation to stores in another country adds customs clearance time, not just transport: build it into the warehouse reserve.

Categories and audiences

Apparel
Apparel splits into size groups (XS–XL or 40–54), and the curve differs for tops, bottoms and dresses. The curve is broader than in footwear but varies more by brand and cut. Clusters are needed for plus sizes and niche sizes, where demand is concentrated in a few stores.
Footwear
Footwear is the toughest size category: half-size steps, a run for each style, and a missing size means a lost pair. The curve is built per style and extreme sizes are held at minimum stock. Size returns are high, so a fitting aid pays back.
Accessories
Accessories are mostly sizeless, so there is no curve and the range questions are about breadth, price and color. Exceptions: belts, gloves, hats, rings. ABC works well, but there are many low-sales items: check C for seasonal and gift items.
Kids
The children’s size run is built on height, not girth, and each size lives one season: the child outgrows it. A tail of slow sizes costs a lot because goods do not carry over to next year. The curve depends on the age of the target group and the region.
Men
In men’s trousers, jeans and suits size has two parameters: chest or waist and height or length (for example, 50 and 182). One curve by size is not enough here: shortage arises on a “size x length” cell while the overall stock by size looks fine. For T-shirts one scale is enough, for trousers the curve is built by the pair.
Women
In the women’s line the label “M” on different cuts means different shoppers: a loose dress and a fitted one in “M” sell in different shares. So the curve is built by cut or brand, not by letter size. Plus sizes and small sizes need a separate calculation, otherwise the common curve will not show them.

Questions this topic answers

  • Which items are the core of the range?
  • How to split the buy by size?
  • How to allocate a run across stores?
  • Which size and which store are under-bought and where is the excess?

Key measures and terms

Study first

What next

Next step: “Size runs, stores and range in season”, “Range: width, depth and price tiers”. Related: “Buying budget and cash”, “Replenishment and stock cover”, “Season, price and discounts”.

Documents on this topic

Open interactively →