Sell-through formula measures how much inventory a business sells relative to what it had on hand — typically expressed as a percentage or ratio.
What does sell-through mean?
Sell-through is the percentage of inventory sold to customers compared to the total inventory received or available
For instance, if a store gets 1,000 units of a product and moves 650 units in a month, that’s a 65% sell-through. This number tells retailers whether demand is strong or stock is piling up. Businesses lean on sell-through to decide if they should reorder hot items or clear out sluggish inventory. Investopedia points out that a high sell-through usually means customers can’t get enough and merchandising is on point.
How do you calculate sell-through in Excel?
In Excel, calculate sell-through by entering =Units Sold / (Units On-Hand + Units Sold) and formatting the result as a percentage
Say you moved 120 units and had 80 left at month’s end. Plug in =120/(80+120) and you’ll get 60%. You can even set up named ranges and conditional formatting to flag slow sellers automatically. Microsoft Support has templates ready to track these metrics across product lines.
What’s considered a good sell-through?
A good sell-through typically falls between 40% and 80%, depending on product category and seasonality
Seasonal items like holiday decor should clear over 80% before the season ends. Electronics and apparel usually land between 50–70%. Drop below 30%, and you’re likely sitting on too much stock or facing weak demand. The National Retail Federation recommends tweaking prices or running promotions if sell-through stalls for two straight periods.
What exactly is a sell-through percentage?
Sell-through percentage is the ratio of units sold to total units available, multiplied by 100
This percentage tells retailers how quickly inventory converts to revenue. Selling 300 units from an initial stock of 500? That’s a 60% sell-through. Anything below 20% over three months usually signals excess inventory. Tracking this weekly lets businesses pivot faster when trends shift. Shopify suggests pairing sell-through with inventory turnover for a clearer picture.
How do you calculate sellout?
Sellout is calculated by dividing units sold by units received from the supplier, then multiplying by 100
Take a store that received 2,000 units and sold 1,400. The sellout rate is (1,400 / 2,000) × 100 = 70%. Wholesalers and distributors use this to judge product performance. Retailers often set sellout targets to keep cash flowing and avoid dead stock. Retail Dive advises checking sellout data monthly to catch trends early.
How is rate of sale calculated?
Rate of sale is calculated by dividing units sold by the average inventory level during the period, then multiplying by 100
Sold 480 units over 30 days with an average inventory of 800? That’s (480 / 800) × 100 = 60%. This shows how fast stock is moving relative to what’s on hand. A rate below 40% might mean markdowns or better marketing are needed. IMS recommends using rate of sale to plan restocking.
What’s the difference between sell-in and sell-through?
Sell-in refers to when a retailer buys inventory from a supplier, while sell-through is when the retailer sells that inventory to the end customer
Imagine a manufacturer selling 5,000 units to a retailer (sell-in), and the retailer moves 3,000 units to shoppers (sell-through). Sell-in is all about supply; sell-through measures demand. Getting both right helps businesses balance production and sales. Gartner notes sell-in shapes future orders, while sell-through guides pricing and promotions.
What does sell-in mean?
Sell-in is the process where suppliers sell products to retailers or distributors for resale to consumers
You’ll hear this a lot in consumer goods and automotive, where manufacturers rely on retailers to push inventory. High sell-in without matching sell-through can leave shelves packed. Retailers often negotiate sell-in deals based on expected sell-through rates. Mercatus points out that sell-in agreements may include volume discounts or return policies.
What are sell-in and sell-out?
Sell-in is sales from manufacturers to distributors or retailers; sell-out is sales from retailers to consumers
Picture a toy manufacturer selling 10,000 units to a distributor (sell-in), the distributor moving 8,000 to toy stores (intermediate sell-out), and stores selling 6,000 to shoppers (final sell-out). Tracking both helps spot where inventory gets stuck. Companies with tight sell-in and sell-out alignment tend to carry less dead stock, according to McKinsey.
What’s a good Amazon sell-through rate?
As of 2026, a good Amazon sell-through rate is one that keeps your Inventory Performance Index (IPI) score above 450
Amazon’s IPI blends sell-through, excess inventory, and stranded inventory into one score. Fall below 450, and you risk storage limits and higher fees. Aim for 60–80% sell-through to keep inventory turning over smoothly. Selling 600 units from 1,000 in stock gives you a 60% rate, which supports a solid IPI. Amazon Seller Central offers tools to watch sell-through and adjust restocking.
What is a sell rate?
A sell rate is the price at which a product is sold to consumers, often used in retail and hospitality
In retail, the sell rate is the sticker price on a shirt or TV. In hotels, it’s the nightly room rate. This number drives revenue and profits directly. Retailers tweak sell rates based on demand, competition, and inventory levels. Hotel News Now suggests using dynamic pricing tools to optimize sell rates in real time.
What’s a good rate of sale?
A good rate of sale is typically above 80% for most retail products, with 40–80% considered acceptable
A grocery store selling 85% of its fresh produce in a week? That’s a strong rate of sale. Drop below 40%, and you’re likely overstocked or facing weak demand. Seasonal products might show lower rates if timing is off. Retail Doc recommends pairing rate of sale with turnover ratios to fine-tune inventory plans.
How do you calculate retail sales growth?
To calculate retail sales growth, subtract last month’s sales from this month’s, divide by last month’s sales, then multiply by 100
Last month’s sales were $50,000, this month’s hit $55,000. Growth is (55,000 – 50,000)/50,000 × 100 = 10%. This metric helps retailers gauge performance and plan orders. Three straight months of negative growth? Time to run promotions or spruce up the store. The U.S. Census Bureau publishes monthly retail sales data to compare against.
Can you give a retail store example?
A retail store is a business that sells goods directly to consumers, such as Target, Walmart, or Best Buy
These stores operate physical locations and often sell online too. Specialty retailers like Apple Stores and boutique clothing shops curate their selections carefully. Grocery stores like Kroger mix food retail with in-store dining. The National Retail Federation calls retail the final step in the supply chain before shoppers buy.
What’s a good GMROI?
A good Gross Margin Return on Investment (GMROI) is 3.2 or higher, covering costs and generating profit
Invest $10,000 in inventory and earn $32,000 in gross profit? Your GMROI is 3.2. This metric helps retailers check if inventory investments are paying off. A GMROI below 2.0 usually signals overstocking or thin margins. Retail Dive suggests reviewing GMROI quarterly to adjust buying and pricing strategies.
