Calculator Margin Collection and Sell-Through Rate
Calculate the sell-through rate (STR%), seasonal inventory margin and residual storage cost. Essential KPIs for buyers, store managers and fashion retailers.
Configure
Result
No results
Enter values and press the button to calculate.
Frequently Asked Questions
What is the sell-through rate in fashion retail?
Sell-through rate (sales turnover rate) is the percentage of goods purchased that are actually sold within a certain period (typically a season). Formula: STR = units sold / units purchased × 100. A 70% STR means that 70 out of 100 purchased items were sold. It is the primary indicator for evaluating the quality of purchasing planning and the effectiveness of the collection.
What is a good sell-through rate in fashion?
A sell-through of ≥ 70% is generally considered good in the fashion retail industry. Above 80% is excellent but may indicate stock shortages (insufficient sales due to inventory depletion). Below 60% indicates planning issues: excessive inventory sold requires aggressive markdowns that erode profit margins. Benchmarks vary by segment: luxury accepts lower STR (50–60%), fast fashion targets 80%+.
What is the collection margin and how is it calculated?
Margin of collection (or seasonal margin) is the difference between total revenue and total costs: Margin = Revenue - Costs. Costs include: purchase of goods, incoming logistics, visual merchandising, sales staff, customer discounts. Expressing this in percentage of revenue becomes the margin percentage, allowing for comparison of seasons and collections with varying volumes.
What is Markdown and when is it applied?
Markdown is the price reduction applied to unsold inventory at the end of the season (discounts, promotions, outlet sales). The goal is to increase sell-through and recover merchandise inventory costs, avoiding negative stock levels in the next season. The optimal strategy is to minimize markdown through better purchase planning (buy plan), but a 20-30% markdown on remaining inventory is normal in fashion retail.
What does residual storage mean (markdown residue)?
Remaining inventory (or residual stock) is the amount of unsold goods at the end of the season. Its cost (inventory × unit purchase price) represents the fixed capital that must be recovered through markdown, outlet sales, return to supplier or inventory devaluation. This calculator provides the cost of remaining inventory as an indicator of the risk of markdown faced at the end of the season.
How does sell-through differ from rotation stock?
Sell-through measures the percentage of sold goods compared to purchased inventory over a season (static metric on a defined period). Stock turnover (or stock turn) measures how often inventory is replenished in a year: STR = revenue / average cost per unit. A high stock turnover (3-6 times/year in fashion) indicates efficient warehouse management and healthy liquidity. The two KPIs are complementary: good seasonal sell-through contributes to maintaining high stock turnover.
How is it used?
- Insert units purchased and sold
Insert total units purchased at the start of the season and actual units sold. The sell-through rate is the percentage ratio between these two values.
- Insert costs, revenues and unit price
Indicate the total collection costs (purchase of goods, logistics, visual merchandising) and total revenue (full-price sales plus discounts). The unit purchase price helps estimate the remaining inventory cost.
- Calculate and interpret KPIs
Click "Calculate" to get: sell-through rate, inventory units, collection value margin, and remaining stock cost percentage. A sell-through rate of 70% or higher indicates good performance for the fashion retail industry.
- Plan your Markdown strategy
If sell-through is below 70%, consider promotional discounts, end-of-season sales, or outlet deals to reduce inventory and recover liquidity before the next season.
Sell-through and Collection Margin: Fundamental KPIs for Fashion Retail
Sell-through rate (STR) is one of the most important indicators to evaluate a season's performance in fashion retail. It measures the percentage of purchased goods sold to the end customer: STR = units sold / units purchased × 100. A 70% STR means that 70 out of 100 purchased items found a buyer, leaving 30 items unsold to be cleared with negative markups (markdown).
Collection margin (or seasonal margin) complements the sell-through by measuring the actual profitability of the season: Margin = Revenue - Costs. The costs include the purchase of goods (cost of inventory), logistics in, visual merchandising, sales staff, promotions and discounts applied. A high margin with low sell-through may indicate prices that are too high; a high sell-through with low margin may indicate high cost of purchase or excessive markdowns.
Residual inventory cost (residual stockout at end of season) is the invisible cost of planning. Each sold item represents fixed capital that must be recovered through markdowns, outlet sales, returns to suppliers, or inventory valuation. This calculator quantifies the residual inventory cost as Residual Unit Quantity × Unit Purchase Price, providing the value of goods to be cleared in the next season.
Market benchmarks vary by segment: fast fashion (H&M, Zara) targets 80-90% sell-through with rapid rotation (4-6 orders/year). Mid-market (department store) accepts 65-75%. Luxury (Gucci, Prada) operates at STR 50-65% with higher unit margins. Market sell-through calculation is automatically integrated into POS and ERP systems in modern retail, but this tool is useful for quick analysis, buy plan simulations, and supplier presentations.
All calculations occur in the browser - no data is sent to external servers. The tool is designed for buyers, store managers, area managers, commercial directors, and fashion consultants who want a quick calculation without accessing the main system.
Practical example
- Spring/Summer Collection: 100 items purchased at $50/item (purchase cost $5,000)
- Seventy items sold at full price ($120) + five items sold at discounted price ($80) = Profit $8,800
- Total cost: $5,000 purchase + $800 logistics + $200 VAT = $6,000
- Sell-Through = 75 / 100 × 100 = 70% - Margin = €8,800 - €6,000 = €2,800 (31.8%) - Residual stock 25 pcs × €50 = €1,250
Vocabulary Dictionary
- Sales Throughput Ratio
- Purchase efficiency rate - the percentage of purchased goods sold to the end customer in a season. Formula: STR = units sold / units purchased × 100. Key Performance Indicator (KPI) to measure buy plan effectiveness. Benchmark: ≥70% good, ≥80% excellent in mass market.
- Collection Margin
- Difference between seasonal total revenues and sustained total costs (merchandise purchase + logistics + VM + personnel + discounts). Indicates the actual seasonality profitability. Expressed as a percentage of revenues allows for comparisons between different seasons.
- Markdown
- Discount applied to unsold inventory (sales, promotions, outlet) to increase sell-through and recover liquidity. Markdown reduces profit margin: a 30% stockout by year-end may require discounts of 40-60% to clear it.
- Residual stock
- Inventory remaining unsold at the end of the season. Its cost (inventory x purchase unit price) is the capital to recover. Excessive inventory compromises cash flow and occupies space for the new collection.
- Buy a Plan
- Seasonal purchase plan that determines how many units to buy for each item/category. A precise buy plan minimizes remaining inventory and maximizes sell-through. It is based on historical sell-through data, traffic predictions, and market trends.
- Sell-through at full price
- Full-price sales only (excludes discounted sales). Harsher indicator of collection quality and pricing: a high full-price STR (>60%) indicates customers buy without waiting for sales.
Do you need a custom analysis?
This tool is free and informative. For in-depth analysis with AI on-prem - private data, zero cloud - contact Federico.