Syntha Lab RU

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.

Assortment and sizes For whom: Category managers, product managers, buyers and CFOs who buy and sell swimwear and lingerie.

Calculate on your data →

At a glance

What question does it answer?
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.
What data is needed?
The price, the cost, the channel commission and the logistics there and back.
How to read the result?
Example on the default values (price 4,200 with VAT, cost 1,300, commission 18%, six size groups): the average return rate 28.5%, the margin per ordered unit RUB 779 against RUB 1,403 without returns; the return threshold 64.1%. Example on the default values: Weighted return rate: 28.5%; Returned, units: 285; Written off as unsellable, units: 100; Margin per kept unit: RUB 1,523. The figures are illustrative: enter your own to see your result.

Why and how to reason

For swimwear and lingerie a return costs more than for a T-shirt for two reasons: there are more sizes and mistakes in them are more frequent, and part of the returned goods cannot be sold again. So the margin is counted not per sold unit but per ordered unit: from it logistics to the buyer, the way back, processing and the write-off of the unsellable part are subtracted. The size run gives the average return rate: for each group its share of orders and its returns are taken. On the default values the shelf price of 4,200 with 22% VAT gives 3,443 without VAT; after the 18% commission and the cost of 1,300, 1,523 is left per kept unit. The average return rate is 28.5%, so an ordered unit brings 779 instead of 1,403 without returns: returns eat 44.5% of the margin. The return threshold at which the margin falls to zero is 64.1%.

When to use it

Use it before ordering a season, when reviewing the size run and when choosing a channel with expensive reverse logistics. It suits lingerie, swimwear, shapewear and hosiery where part of a return cannot be resold. It does not suit items without hygiene limits: there the share of the unsellable is set close to zero. Assumptions: commission is taken only on the items kept, the resale of a return is not included, the shares are taken from the data of the last season.

How to read the result

First compare the average return rate with the threshold: the closer to the threshold, the more fragile the order. Then look at the loss from returns per ordered unit: if it is more than half of the margin without returns, it is cheaper to work on returns than on a discount. The table by size groups shows which sizes pull the margin down: on the default values in XXL an ordered unit brings 572 and in M 878. For such groups add a size prompt, review the patterns or leave the size only by pre-order. Check also the share of write-offs: every 100 unsellable units out of 1,000 cost money that is not in what is sold.

Common mistakes

Typical mistakes: taking one return rate for the whole run when the edges are returned noticeably more often; counting the margin per sold units and losing the logistics there and back; taking all returns as saleable. Another mistake is entering the commission without VAT against a price with VAT. The share of the unsellable and the return rules are taken from your own facts and the current sales rules.

What data is needed?

  • The price, the cost, the channel commission and the logistics there and back.
  • The size run: the share of orders and the return rate by group.
  • The share of the returned that cannot be resold, by the facts of the season.

Inputs

FieldUnitValue in the exampleMeaning
Shelf price with VAT₽4,200The price at which the item is bought, with VAT. If you do not pay VAT, set 0 in the VAT field below. The example value is illustrative.
VAT%22The VAT rate in the shelf price: the general 22%; for children’s underwear a reduced rate by a list is possible, check the goods code. The example value is illustrative.
Cost in the warehouse₽1,300The full cost of a unit in the warehouse without VAT: fabric, sewing, import, marking, packing in hygienic film. The example value is illustrative.
Channel commission%18The share of the price without VAT taken by the sales channel: a marketplace, a partner, acquiring. Suppose 18%; take it from the offer. It is charged only on the items the buyer keeps. The example value is illustrative.
Logistics to the buyer per ordered unit₽120Storage, picking and delivery of one ordered unit: it is paid also for those that are returned later. The example value is illustrative.
Return logistics per returned unit₽150The cost of the way back of one returned unit to your warehouse. The example value is illustrative.
Return processing₽60Checking, cleaning, steaming and repacking of one returned unit. The example value is illustrative.
Share of returns that cannot be resold%35What part of the returned lingerie and swimwear is written off: the liner is removed, signs of wear, no packaging. Take it from your own facts for the season. The example value is illustrative.
Ordered, unitspcs1,000How many units buyers ordered in the period: the total is multiplied by it. The example value is illustrative.

How it is calculated

StepFormula
Price without VATN = shelf price ÷ (1 + VAT)
Margin per kept unitm = N × (1 − commission) − cost
Average return rateρ = Σ(order share × return rate) ÷ Σ order share
Margin per ordered unitM = (1 − ρ) × m − L₁ − ρ × (L₂ + P) − ρ × h × C
Return thresholdρ* = (m − L₁) ÷ (m + L₂ + P + h × C)

Worked numbers

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

Weighted return rate
28.5 %
Returned, units
285
Written off as unsellable, units
100
Margin per kept unit
1,523 ₽The price without VAT less commission and cost, before logistics and returns.
Margin per ordered unit without returns
1,403 ₽
Margin per ordered unit with returns
779 ₽
Loss from returns per ordered unit
624 ₽
Share of margin eaten by returns
44.5 %
Return rate at which the margin is zero
64.1 %If the average return rate is above the threshold, every ordered unit makes a loss.
Total margin of the order
778,510 ₽
Margin in the worst size group
572 ₽
Margin in the best size group
878 ₽
Return rate by size group, %
Bar chart: XS 34, S 28, M 24, L 27, XL 33, XXL 38010203040XSXSReturns: 3434SSReturns: 2828MMReturns: 2424LLReturns: 2727XLXLReturns: 3333XXLXXLReturns: 3838%
Data as a table
MeasureReturns
XS34
S28
M24
L27
XL33
XXL38
Margin per ordered unit by group
Bar chart: XS 659, S 790, M 878, L 812, XL 681, XXL 57202004006008001,000XSXSMargin: 659659SSMargin: 790790MMMargin: 878878LLMargin: 812812XLXLMargin: 681681XXLXXLMargin: 572572₽
Data as a table
MeasureMargin
XS659
S790
M878
L812
XL681
XXL572

Size run and margin

GroupOrdered, unitsReturns, %Returned, unitsMargin per unit
XS803427659 ₽
S2202862790 ₽
M2802467878 ₽
L2202759812 ₽
XL1203340681 ₽
XXL803830572 ₽

The calculation is simple: commission is taken only on the items kept, logistics to the buyer is paid on all ordered units, a return costs the way back and processing, and the unsellable part of a return is written off at cost. A resold return counts as the next order and is not included here. For footwear, accessories and children’s the values are different: take the data of your category and check the return rules and the list of goods that cannot be exchanged or returned.

Nuances and limits

  • Counting the margin by what is sold and not by what is ordered: returns and logistics disappear from view.
  • Taking one return rate for the whole run: the extreme sizes are returned noticeably more often.
  • Counting all returns as saleable: part of lingerie and swimwear is written off.

Terms used

Calculate on your data →