Sell-Through Rate Calculator

What does this sell-through calculator estimate?

Sell-through rate measures the share of inventory received or made available during a period that was sold during that same period. It is a practical inventory-management indicator for retailers, wholesalers, brands, distributors, and other businesses that sell physical goods. The calculator also shows the units remaining, the number of units corresponding to a chosen planning target, and the additional sales required to reach that target.

Sell-through rate = units sold ÷ units received × 100

The numerator and denominator must describe the same product scope, unit of measure, and time window. Mixing weekly sales with monthly receipts, eaches with cases, or one SKU’s sales with a category’s receipts can produce a mathematically valid but operationally misleading result.

How should each input be completed?

Product or category

This optional text field labels the analysis in the live interpretation and exported workbook. Use a SKU, product family, brand, store department, or channel name. The label does not affect the math. Leaving it blank simply produces a generic inventory summary.

Analysis period

Select the week, month, quarter, season, or year covered by both sold and received units. The period changes the wording of the interpretation, not the formula. Short periods are useful for fast-moving goods and promotions; longer periods can be more appropriate for seasonal or durable products. A common mistake is changing the period without refreshing both input datasets.

Number of units sold

Enter completed unit sales recorded during the chosen period. Use a nonnegative count and keep returns treatment consistent with your internal reporting. Higher sold units increase the rate and reduce remaining inventory. If sold units exceed received units, the calculator preserves the resulting rate above 100% and flags the excess. That situation often indicates beginning inventory, transfers, returns, or timing differences that are missing from the received figure.

Number of units received

Enter inventory received or otherwise made available during the same period. This value must be greater than zero for a defined rate. Depending on your process, “received” may mean only new inbound receipts or total available inventory, including beginning on-hand stock. Choose one definition and use it consistently across periods. Increasing receipts without increasing sales lowers the sell-through rate and usually increases remaining units.

Planning target

Enter an optional percentage from 0% to 100%. The target calculates how many units would need to sell from the current receipt base and the remaining unit gap. A higher target raises the required sales level. The field is a scenario assumption rather than a universal benchmark, because appropriate rates vary by product lifecycle, lead time, gross margin, seasonality, and markdown strategy.

How should the results be interpreted?

Sell-through rate

The primary result shows the percentage of received units that sold. A rate of 65% means 65 of every 100 received units sold during the selected period. A zero rate means receipts were recorded but no units sold. A rate above 100% is possible when sales draw on beginning stock or when receipts and sales are not reconciled on the same basis; it should prompt a data-definition review rather than an automatic correction.

Units remaining

This is received units minus sold units, floored at zero. It approximates the unsold portion of the period’s receipt base. It is not necessarily ending inventory if beginning stock, shrinkage, transfers, returns, or adjustments are excluded. Pair this result with your inventory ledger before making replenishment decisions.

Units at target and additional sales needed

Units at target equals received units multiplied by the target percentage. Additional sales needed is the positive difference between target units and current sold units. When current performance already meets or exceeds the target, the gap is zero and the calculator reports the number of units above target.

Sales above receipts

This reconciliation metric equals sold units minus received units when the difference is positive. It does not imply an error by itself, but it indicates that the simple receipt-based denominator does not capture all inventory sources. Review beginning inventory, interlocation transfers, returns to stock, backorders, and cut-off timing.

What do the chart and tables add?

The donut chart separates units sold from units remaining and, when necessary, shows sales above receipts as a third category. The legend and data table expose the exact same values and percentages used to draw the chart. This makes the visualization useful for quick review while preserving an auditable numeric breakdown.

The current-versus-target table converts the target percentage into units, remaining inventory, and a percentage-point difference. It helps merchandising and purchasing teams discuss the operational size of a gap instead of relying on the rate alone. Changing the target does not alter current performance; it only changes the comparison scenario.

How can sell-through support better inventory decisions?

Track the metric on a consistent cadence and compare like with like: the same SKU scope, locations, channel, period length, and receipt definition. A declining rate may support reviewing price, placement, assortment depth, marketing, or replenishment quantities. A very high rate can indicate strong demand, but it may also signal underbuying and lost sales if stockouts occur.

Sell-through should not be used alone. Combine it with margin, stockout frequency, weeks of supply, inventory turnover, return rates, and carrying costs. The U.S. Census Bureau retail data can provide broader market context, while the U.S. Small Business Administration’s financial-management guidance explains why inventory and cash-flow discipline are connected. For additional inventory-management context, see Investopedia’s inventory-management overview.

Common mistakes include using purchase orders rather than physically received units, ignoring beginning inventory when sales draw from it, mixing gross and net sales, comparing periods of different lengths without context, and treating a target as an industry rule. The most useful benchmark is usually your own clean historical data, segmented by product class and lifecycle stage.