Stock that does not sell ties up cash, and stock that sells out too fast loses sales. The sell-through rate shows the balance. This sell-through rate calculator takes the units available, the units sold and the days in the period to give the sell-through rate, the units left, the daily sales pace and the days and weeks of supply left.
How the calculation works
- Sell-through rate = units sold ÷ units available × 100, where units available = opening stock + deliveries during the period.
- Units left = units available − units sold.
- Units sold per day = units sold ÷ days in the period.
- Days of supply = units left ÷ units sold per day, and weeks of supply = days ÷ 7.
Example
A shop had 600 units available (opening stock plus deliveries) and sold 420 of them in 30 days. The sell-through rate is 420 ÷ 600 = 70.0 %, 180 units are left, and the pace is 14 units a day. At that pace the remaining stock lasts 180 ÷ 14 = 12.9 days, or 1.8 weeks.
Why it matters
Retailers, e-commerce sellers and wholesalers use sell-through to decide what to reorder, what to discount and how much space to give each product. A strong rate early in a season justifies a reorder, and a weak one tells you to mark down before the end of season, when demand is gone.
Good to know
Use the same period and the same units for sales and for stock. Opening stock plus deliveries is the usual base, but some businesses use the stock at the start only, so define it and keep to it. The days of supply assumes that the pace stays constant, which is rarely true around promotions, seasons and holidays. A high sell-through with a long wait for new stock can hide lost sales. Compare the rate across products and weeks rather than reading one number alone, and combine it with margin.
Related tools
The inventory turnover calculator measures annual stock rotation, the reorder point calculator tells you when to order again and the markup calculator sets the selling price from cost.