A sell through rate calculator shows what share of the stock you received you have sold. Enter the units sold and the units received, and the calculator gives the sell-through rate as a percentage, along with the units left. It uses the standard definition, and everything runs in your browser.
How to use the sell through rate calculator
- Enter the number of units sold during the period.
- Enter the number of units received into stock for the same period.
- Press Work out the sell-through rate.
The formula
Sell-through is the percentage of a product that is sold by a retailer after being shipped by its supplier [1]. We work it out as the number of units sold divided by the number of units received, times 100. In our example, a retailer received 1,000,000 units and sold 650,000, so the sell-through rate is 65 percent. The calculator also shows the units that are still in stock, 350,000 in the example, which is 35 percent of what was received.
Why retailers watch it
The sell-through rate shows how fast stock is turning into sales. A high rate means that products are selling well and that stock does not sit for long, which frees cash and reduces the need to mark prices down. A low rate means that stock is building up, which ties up money, takes space and may end in a clearance sale. Buyers use it to decide how much to reorder, and sellers use it to judge a product, a season or a supplier.
Reading the number
There is no single good rate, because it depends on the product and on the length of the period, which is often one month [1]. A fashion item at the end of a season and a food item with a short shelf life are judged differently from a durable item that sells all year. Compare the rate with the same product in earlier periods, with similar products, and with the rate that you planned. A rising rate over the weeks of a season is a good sign, while a flat one means demand has slowed.
Sell-through and inventory turnover
The two ideas are related but not the same. The sell-through rate looks at one batch or period and tells you what share was sold. Inventory turnover measures the number of times an average quantity of inventory was bought and sold during a period [2], and it is worked out as cost of goods sold divided by average inventory [2]. Use the sell-through rate for short, product-level decisions, such as when to run a sale, and use turnover for the overall health of stock.
Worked example
A shop receives 400 jackets at the start of the autumn and sells 260 by the end of October. Its sell-through rate is 260 divided by 400, which is 65 percent, and 140 jackets are left. If the shop planned to sell 80 percent by the end of the month, it is behind its plan and might consider a promotion. After a discount week, it sells another 90, bringing the rate to 87.5 percent. These figures are our own illustration of the formula.
Tips
- Use the same period for sales and receipts.
- Count units, not money, so that price changes do not affect the rate.
- Do it by product or by size, because an overall rate can hide slow lines.
- Include the stock that was on hand at the start if you want the rate of all available stock.
Using the rate to plan buying
If a product sells through quickly in the first weeks, you may want to reorder before it runs out, since a stock-out costs sales. If it sells slowly, you may want to cancel or reduce the next order, and move the stock with a promotion before the season ends. Many buyers set a target rate for each week of a season and compare the real rate with it. When the real rate runs ahead of the target, they order more, and when it runs behind, they act on prices.
Sell-through for different kinds of business
The idea is used well beyond clothing shops. A publisher looks at how many copies of a book were sold out of those sent to bookstores. A food seller looks at how much of a batch was sold before it expired. An online seller looks at how much of a shipment into a warehouse has been bought by customers. In each case, the figure shows how well the supply matched the demand, and the right target depends on how costly it is to have stock left over or to run short.
Limits of the number
A high rate is not always good. A rate close to 100 percent in a short time may mean that you ran out of stock and lost sales that you could have made. A low rate is not always bad either, for example if the product is a new line that you are building up on purpose. Use the rate together with margins, the time that stock has been held and what customers say, and judge each product on its own.
Common mistakes
- Using money instead of units. The rate is about units.
- Mixing periods. Receipts and sales must match in time.
- Judging from a single number. Compare with the plan and the past.
- Ignoring returns. Subtract returned units from the units sold.
What next
Use this often? Add Sell Through to your Home screen.
Frequently asked questions
What is a sell through rate calculator?
A tool that divides the units you sold by the units you received to show what share of your stock has sold.
How do you calculate the sell through rate?
Divide units sold by units received and multiply by 100. For 650,000 sold of 1,000,000 received, it is 65 percent.
What is a good sell through rate?
It depends on the product and the period. Compare with the plan, past periods and similar products.
What is the difference between sell-through rate and inventory turnover?
Sell-through looks at one batch or period. Inventory turnover shows how many times the whole stock is sold and replaced in a year.
Should I use units or money?
Use units, so that price changes do not affect the rate.
Sources
Was this tool helpful?
What went wrong?
We only receive the reason you pick, never what you typed into the tool.
Thanks for your feedback.