Sell-through, weeks of supply, inventory turns, GMROI, markdown impact, margin and markup in one place.
Buyers, merchandisers and boutique owners use the same handful of numbers to decide what to reorder, what to mark down and how well inventory is paying for itself. This Apparel Search toolkit calculates them from your own figures and shows the formula behind each one. Each section works on its own, and the results update as you type. Everything runs in your browser, and nothing you enter is saved.
Please read: definitions vary by company. These metrics have common formulas, but retailers define some of them differently, for example sell-through on received units or on sold plus on-hand units, and inventory turns on cost or on retail value. Each section states the formula it uses. The results are only as good as the figures you enter and assume steady sales, so they are planning aids, not forecasts or advice. Check them against your own company's definitions.
Sell-through rate
Sell-through = units sold / (beginning inventory + units received). Weeks of supply = ending inventory / average weekly sales.
Weeks of supply and reorder point
Reorder point = weekly sales x (lead time + safety weeks), compared with on hand plus on order. Units to order = weekly sales x target weeks - on hand - on order. This assumes sales stay steady.
Inventory turnover and GMROI
Turns = COGS / average inventory at cost, annualized by 12 / months. Days of inventory = 365 / annualized turns. GMROI = annualized gross margin dollars / average inventory at cost.
Markdown impact
Extra volume needed = original margin per unit / new margin per unit - 1, to earn the same total gross profit as before the markdown.
Margin and markup
Margin = (price - cost) / price. Markup = (price - cost) / cost. A 50% margin is a 100% markup (a multiplier of 2.0).
Save your numbers
Estimates only. Confirm against your own company's definitions and records.
Why these metrics matter
Sell-through shows how much of what you bought has actually sold, which guides reorders and markdown timing.
Weeks of supply tells you how long your stock will last at the current pace, so you can order before you run out.
Turns and GMROI show how hard your inventory dollars are working, and whether slow movers are tying up cash.
Markdown math shows how much extra volume a discount has to bring in just to break even on profit, which is often more than expected.
There is no single right target. Good sell-through, turns and margins vary by category, season, price point and business model, so use these numbers to compare against your own history and goals.
Estimates only. This tool is provided for general planning and informational purposes. Results depend on the information you enter, on the definitions used and on assumptions that may not match your business. Apparel Search does not guarantee accuracy or completeness of any result. Confirm figures with your own records, accountant or other qualified professionals before making buying, pricing or inventory decisions. See our Legal page for terms of use.