M Maker Label Studio

Sell-Through Rate Calculator

Calculate retail sell-through, weeks-of-supply, and reorder flags for each SKU over a selected selling period.

Cited category: Finance & Supply Chain. Formula: sell-through % = units sold / (beginning inventory + receipts) x 100.

Inputs

Receipts can be left at zero when no new inventory arrived during the period.

Used in export files and printed report.
Weeks used for weeks-of-supply.
Flag reorder when sell-through meets or exceeds this %.
SKU / Item Units sold Beginning inventory Receipts Action

Results

Results update as you edit the inputs.

Weighted sell-through 0.0%
Units sold 0
Available units 0
Weeks of supply 0.0
Reorder flags 0
SKU / Item Sell-through Ending inventory Weeks-of-supply Reorder flag

Self-Tests

Runs golden checks against the core sell-through percentage and reorder flag functions.

About the Sell-Through Rate Calculator

Sell-through rate gives retailers and wholesale operators a clean read on how much available inventory actually moved during a period. By comparing units sold against beginning stock plus receipts, the calculator highlights slow movers, broken size curves, and items that may need reorder, markdown, or replenishment action before cash gets tied up in aging stock.

How it works

  1. Enter beginning inventory for the period.
  2. Add units received during the same period.
  3. Enter units sold, excluding returns if your reporting policy nets them out.
  4. Review the sell-through percentage, weeks of supply, and reorder flag.

Frequently asked questions

What is the standard sell-through formula?

A common retail formula is units sold divided by beginning inventory plus receipts for the period. Some teams use available units net of returns or transfers, so the inputs should match your reporting policy.

Is high sell-through always good?

High sell-through can indicate strong demand, but it may also show that inventory was too shallow and sales were lost. Pair it with stockouts, margin, and replenishment lead time before deciding to reorder.

How is sell-through different from inventory turnover?

Sell-through focuses on unit movement during a defined selling period. Inventory turnover usually compares cost of goods sold with average inventory value over a financial period.

Should markdown units count as sold units?

Yes, if the goal is to measure how much inventory left the shelf. Track full-price and markdown sell-through separately when margin quality matters.

What period should I use for seasonal products?

Use a period that matches the buying and selling cycle, such as launch week, month-to-date, or season-to-date. Seasonal goods often need more frequent reads because late markdowns have less time to recover cash.

References