Retail calculators
Free Retail Calculators for Margin, Sell-Through and Stock
Five free retail calculators for buyers, planners and analysts: margin and markup, sell-through rate, stock turn and weeks of cover, GMROI and open-to-buy. Each one shows the formula under the result, a worked example and the mistakes I see most often in fashion retail files.
Margin Calculator
Gross margin, markup and gross profit from cost and price, plus the price you need for a target margin.
=02Sell-Through Rate Calculator
Sell-through on available stock and on receipts, with returns taken out of sales.
=03Stock Turn and Weeks of Cover Calculator
Stock turn, days of stock and weeks of cover from cost of goods sold, inventory and weekly sales.
=04GMROI Calculator
Gross margin return on inventory investment from gross margin and average inventory at cost.
=05Open-to-Buy Calculator
The budget left to buy for a period, from planned sales, markdowns, stock and orders.
Free Retail Calculators FAQ
Yes. All five calculators are free and need no sign-up. The numbers you type stay in your browser and are not sent or stored anywhere.
Each calculator uses the standard retail formula and prints it under the result: gross margin on the selling price, markup on cost, sell-through on available stock, stock turn on cost of goods sold, GMROI on average inventory at cost and open-to-buy from planned sales, markdowns and stock. Every page explains the formula with a worked example.
Yes. Enter category or season totals instead of unit values and the result is the category figure. Use totals rather than averaging product results, because an average of percentages overweights small styles.
Need These Retail KPIs in a Power BI or Excel Model?
A calculator answers one question at a time. If you need margin, sell-through and stock cover calculated every week for every category and market, I can build the model with your team.
Tatsiana