Syntha Lab RU

Size demand corrected for stock-outs

Restores the true size curve: divides the sales of each size by the days it was in stock. Shows which sizes are understated in the curve by sales, how many units were lost and how to split the purchase.

Size runs, stores and range in season For whom: Buyers and category managers of footwear and apparel who split a purchase by sizes.

Calculate on your data →

At a glance

What question does it answer?
What the true size curve is if some sizes were not in stock for the whole period, and how many sales were lost.
What data is needed?
Sales by size over the period.
How to read the result?
Compare the columns “by sales” and “true”: for sizes where the true share is higher, availability was limited. Lost units show the price of the shortage. Example on the default values: Size with the largest understated share: XL; Understatement of its share, pp: 10.6; Units lost to missing sizes: 65; Lost units to actual sales, %: 40.6%. The figures are illustrative: enter your own to see your result.

Why and how to reason

A curve by sales understates sizes that were out of stock. The rate of a size over its in-stock days shows the real demand. In the example sales are 10, 40, 60, 35, 15 with 60, 60, 60, 30 and 20 in-stock days: by sales L gives 21.9%, the true share is 31.1%, XL 9.4% and 20.0%; 65 units were lost, a purchase of 1,000 units is split 44, 178, 267, 311, 200.

When to use it

Apply before buying by size and when analyzing the season results, especially for large sizes where shortages are more frequent. The split by given shares is done by sizecurve, here the shares are restored.

How to read the result

Compare the columns of the share by sales and the true one: where the true one is higher availability was limited. Read sizes with a window of a few in-stock days carefully.

Common mistakes

The curve is built from sales at incomplete availability, in-stock days are taken by the warehouse and not by the store, sizes in stock for a few days are taken as they are.

What data is needed?

  • Sales by size over the period.
  • In-stock days for each size where it sells.
  • The total purchase and the box multiple.

Inputs

FieldUnitValue in the exampleMeaning
Total purchase, unitspcs1,000How many units of the model or group are split across sizes. The example value is illustrative.
Length of the period, daysdays60Over how many days the sales and in-stock days are collected. In-stock days cannot exceed it. The example value is illustrative.
Minimum in-stock days for a reliable estimatedays7A size that was in stock for fewer days than this is flagged: a rate over a few days is random. The example value is illustrative.
Box multiple, unitspcs1The purchase is split in whole boxes; a remainder smaller than a box stays unallocated. 1 means no rounding. The example value is illustrative.

How it is calculated

StepFormula
Size ratev(s) = sales(s) ÷ in-stock days(s)
True shared(s) = v(s) ÷ sum of v
Share by sales and shifto(s) = sales(s) ÷ sum of sales; shift = d(s) − o(s)
Lost unitsv(s) × (60 − in-stock days(s))
Purchase of a sizetotal purchase × d(s); in whole boxes by the largest remainder

Worked numbers

Default values from the app; in the interactive version you enter your own.

Size with the largest understated share
XL
Understatement of its share, p.p.
10.6
Units lost to missing sizes
65
Lost units to actual sales, %
40.6 %
Purchased by the corrected curve, units
1,000
Unallocated because of the box, units
0
Sizes with a short in-stock window
0
Size share: by sales and true, %
Bar chart: XS 6.3, S 25, M 37.5, L 21.9, XL 9.4010203040XSXSBy sales: 6.3True: 4.4SSBy sales: 25True: 17.8MMBy sales: 37.5True: 26.7LLBy sales: 21.9True: 31.1XLXLBy sales: 9.4True: 20
  • By sales
  • True
Data as a table
MeasureBy salesTrue
XS6.34.4
S2517.8
M37.526.7
L21.931.1
XL9.420

The size curve

SizeSalesIn-stock daysRate, units/dayShare by salesTrue shareShift, p.p.Lost unitsPurchase
XS10600.176.3 %4.4 %−1.8044
S40600.6725 %17.8 %−7.20178
M6060137.5 %26.7 %−10.80267
L35301.1721.9 %31.1 %9.235311
XL15200.759.4 %20 %10.630200

The curve by sales understates sizes L, XL: they were not in stock the whole period. A purchase by observed shares would leave them without stock.

What to do with the result: buy by the true curve, not by sales; the lost units show how much demand was lost because sizes were missing and justify a wider size run.

A typical mistake: building the curve from sales when the size was in stock for half the period and counting in-stock days by the warehouse, not by the store.

Nuances and limits

  • Building the curve from sales with incomplete availability.
  • Taking in-stock days by the warehouse and not by the store.
  • Overlooking sizes with a few in-stock days.

Terms used

Calculate on your data →