Sell-Through Rate Calculator measures how much available inventory sold during a chosen period. It reports net sell-through after returns, compares received-only and total-available methods, checks ending inventory, measures a target gap, estimates sales velocity and weeks of supply, and evaluates revenue, gross profit, and a markdown scenario.
Enter retail inventory data
Sell-Through Rate Calculator formulas
The Sell-Through Rate Calculator uses total available inventory as its primary denominator because opening stock and current-period receipts were both available for sale. It also shows the received-only version used by some retail reports. Always label the method when comparing products, channels, stores, or reporting systems.
How to use the Sell-Through Rate Calculator
Choose a consistent reporting period, such as a week, month, season, or promotion. Enter beginning sellable inventory and all units received during that period. Enter gross units sold and subtract only customer returns that became sellable again. Damaged returns should not be treated as resellable stock.
Add actual ending inventory to reconcile sales movement against the physical or system balance. Then enter the period length and your target sell-through rate. Optional price, cost, and markdown fields allow the Sell-Through Rate Calculator to connect inventory movement with revenue and estimated gross profit. Use average realized selling price rather than list price when promotions or discounts were material.
Worked Sell-Through Rate Calculator example
A retailer begins with 400 units, receives 600, sells 700, and accepts 20 resellable returns. Total available inventory is 1,000 units and net units sold are 680. The primary sell-through rate is therefore 68%. Using receipts alone produces 113.33%, which exceeds 100% because some opening inventory also sold.
With a 70% target, the retailer needs 700 net units sold, leaving a gap of 20 units. Expected ending stock is 320 units, matching the entered actual ending inventory. Over 30 days, net sales average 22.67 units per day. The 320 units remaining represent about 2.02 weeks of supply at the same pace.
At a $25 average selling price and $12 unit cost, estimated net revenue is $17,000 and estimated gross profit is $8,840. A 15% markdown reduces price to $21.25. Because actual ending stock is 20 units above the 300-unit target ending level, selling those 20 units at the markdown price could produce $425 revenue and $185 gross profit before other variable expenses.
| Example measure | Calculation | Result |
|---|---|---|
| Available inventory | 400 + 600 | 1,000 units |
| Net units sold | 700 − 20 | 680 units |
| Sell-through rate | 680 ÷ 1,000 | 68.00% |
| Units to target | 1,000 × 70% − 680 | 20 units |
| Gross profit | 680 × ($25 − $12) | $8,840 |
Total-available versus received-only sell-through
Retailers do not always use the same denominator. A purchase-order or vendor view may compare units sold with units received from that shipment. A store, category, or seasonal view may compare net sales with beginning inventory plus receipts. The first method can exceed 100% when opening stock contributes to sales; the second cannot exceed 100% when inventory records are complete and sales do not exceed available units.
The Sell-Through Rate Calculator displays both rates so users can reconcile reports instead of assuming one is wrong. Use the total-available method for a complete period stock pool. Use received-only only when the business deliberately measures the performance of receipts and can isolate the related sales. Record the formula beside every target and benchmark.
Returns and ending-inventory reconciliation
Returns reduce net units sold only when they come back into sellable inventory. If a returned product is damaged, discarded, quarantined, or sent to a vendor, record it through the relevant inventory adjustment rather than treating it as resellable. Mixing return treatments can distort sell-through and ending stock.
Expected ending inventory equals available inventory minus net units sold. The Sell-Through Rate Calculator compares that result with actual ending stock. A non-zero variance can indicate timing differences, transfers, receiving errors, unrecorded damage, shrinkage, overselling, unit-of-measure problems, or count errors. Investigate the variance before relying on weeks of supply or markdown recommendations.
Targets, velocity, and weeks of supply
A sell-through target must match the period, product lifecycle, replenishment model, and business objective. A 70% monthly target cannot be compared directly with a 70% seasonal target. Fast replenishment can support a lower on-hand buffer, while long supplier lead times may require more ending stock. New, seasonal, perishable, fashion, and evergreen items should not automatically share one target. The Sell-Through Rate Calculator makes the selected target visible beside the measured result.
Average daily sales equal net units sold divided by days in the period. Average weekly sales multiply the daily pace by seven. Weeks of supply divides actual ending inventory by that weekly pace. These figures assume the recent sales rate continues, so use scenario ranges when demand is volatile or the period contains promotions, stockouts, holidays, or unusual weather.
Revenue, profit, and markdown planning
High sell-through does not automatically mean strong profit. Aggressive discounts can move units quickly while weakening margin. The Sell-Through Rate Calculator multiplies net sold units by the average realized price and subtracts estimated unit cost to show gross profit. It does not deduct payment fees, fulfillment, commissions, advertising, labor, occupancy, returns processing, or overhead.
The markdown scenario applies the entered discount only to units above the target ending stock. This is a planning estimate, not a recommendation to discount automatically. Before acting, consider product age, demand elasticity, season end, storage cost, vendor return rights, transfer opportunities, bundle strategies, and whether a lower price could cannibalize full-price demand.
Related business calculators
Sell-Through Rate Calculator frequently asked questions
What is a good sell-through rate?
There is no universal good rate. The appropriate target depends on the reporting period, product lifecycle, replenishment time, margins, seasonality, and business strategy. Use the Sell-Through Rate Calculator with a target defined for the same period and product type.
Can sell-through be greater than 100%?
The received-only method can exceed 100% when sales include opening inventory. A full available-stock method should not exceed 100% if the records and period boundaries are complete.
Should returns reduce units sold?
Resellable returns normally reduce net units sold because the units return to available stock. Damaged or non-sellable returns require separate treatment.
Should sell-through use units or inventory value?
Sell-through is usually unit based. Value-based analysis can be useful, but it may be distorted by product-mix and price differences and should be labeled separately.
What is the difference between sell-through and inventory turnover?
Sell-through measures the share of an available stock pool sold during a period. Inventory turnover measures how many times average inventory is sold or used, commonly using cost of goods sold and average inventory value.
Why reconcile ending inventory?
Reconciliation helps detect transfers, shrinkage, receiving errors, timing differences, damaged stock, and other movements that could make the calculated rate unreliable.
Why use the Sell-Through Rate Calculator?
The Sell-Through Rate Calculator connects one retail percentage with the stock, target, velocity, reconciliation, revenue, profit, and markdown questions that managers actually face. Use the Sell-Through Rate Calculator consistently across SKUs and periods, and document the denominator so teams compare like with like.