What Is Retail Math and Why It Matters
Retail math is a set of calculations that power smart merchandising, pricing, and inventory decisions. From forecasting demand and managing markdowns to tracking sales performance and margins, these formulas help retailers make data-driven decisions that directly impact profitability.
They're strategic tools used daily by planners, buyers, and store teams to stay aligned and agile.
Mastering retail math helps you:
- Forecast and replenish with confidence
- Protect margins with smart pricing
- Improve sell-through and inventory turn
- Plan more effectively across channels
Knowing these formulas is essential for profitable, scalable growth.
Your Quick Reference for Key Retail Math Formulas
Below, we've compiled the most essential retail math formulas across sales, inventory, productivity, and profitability metrics. Whether you're checking your Average Unit Retail (AUR), calculating Cost of Goods Sold (COGS), or analyzing Weeks of Supply (WOS), these formulas will help you confidently evaluate your merchandising strategies and take action.
(Pro tip: Keep this guide handy as a reference and if you're new to some of the terminology, check out our companion post on Retail Terms You Should Know.)
Most-Used Retail Math Formulas (With Interactive Calculators)
The formulas in this section are the ones retail planners reach for daily. Each includes an interactive calculator. Enter your own numbers and get an instant answer.
Sell-Through Rate (ST%)
Formula:
ST% = Units Sold ÷ BOP Units On Hand × 100
The percent of inventory sold in a given period, most commonly a week. Track both full-price sell-through and overall sell-through. Full-price tells you how healthy your initial buy was; overall tells you how well you managed the category through markdowns.
Worked example: You start the week with 500 units of a denim jacket. You sell 175. ST% = 175 ÷ 500 × 100 = 35%.
When to act: If full-price sell-through falls below 40% by week 6 of a seasonal item's run, initiate a markdown review before the window closes.
Gross Margin Return on Investment (GMROI)
Formula:
GMROI = Gross Margin $ ÷ Average Inventory at Cost
The gross margin dollars returned for every dollar invested in inventory. GMROI is one of the best cross-category benchmarks in retail because it normalizes for both profitability and inventory productivity. Learn more in our complete guide to GMROI.
Worked example: Your category generated $200,000 in gross margin on an average inventory cost of $125,000. GMROI = $200,000 ÷ $125,000 = $1.60. For every dollar invested in inventory, you generated $1.60 in gross margin.
When to act: A GMROI below $1.00 means the category is not covering its inventory cost. Below $1.50 warrants a review of buy depth, pricing, or sell-through strategy. Benchmarks vary significantly by category. See our GMROI guide for vertical-specific targets.
Initial Markup (IMU) and Maintained Markup (MMU)
IMU Formula:
IMU = Ticket Price − COGS
IMU%:
(Ticket Price − COGS) ÷ Ticket Price × 100
MMU Formula:
MMU = Ticket Price − COGS − Allowances
MMU%:
MMU ÷ Ticket Price × 100
IMU is the markup you planned. MMU is the markup you actually kept after markdowns and discounts. The gap between the two tells you how much promotional activity is eroding your margin. See our post on IMU vs. MMU for a full breakdown.
Worked example: A jacket costs $40 to produce and is ticketed at $120. IMU = ($120 − $40) ÷ $120 × 100 = 66.7%. If you take a $20 markdown before the sale, MMU = ($120 − $40 − $20) ÷ $120 × 100 = 50.0%. You planned 66.7 points but kept only 50.
When to act: If MMU is running more than 5–8 points below IMU consistently, your promotional cadence or buy depth is misaligned with demand. Open-to-buy planning is the most direct lever to address this.
Weeks of Supply (WOS) and Forward Weeks of Supply (FWOS)
WOS Formula:
WOS = On-Hand Inventory Units ÷ Average Weekly Unit Sales
FWOS Formula:
FWOS = On-Hand Inventory Units ÷ Forecasted Average Weekly Unit Sales
WOS tells you how long your current inventory will last at the trailing rate of sale. FWOS uses forward-looking demand forecasting instead of trailing sales, making it significantly more accurate for seasonal items. For a deep dive on target-setting and benchmarks, see our guide on how to calculate Weeks of Supply.
Worked example: You have 800 units on hand. Your trailing 4-week average weekly sales rate is 100 units. WOS = 800 ÷ 100 = 8 weeks. But your forecast shows sales accelerating to 160 units/week. FWOS = 800 ÷ 160 = 5 weeks; a meaningfully different picture for your reorder decision.
When to act: For replenishable basics, target WOS within your lead time buffer plus safety stock. For seasonal items, WOS should track toward zero by the end of the selling period. If FWOS falls below your reorder lead time, trigger a replenishment review immediately.
Gross Margin
Formula:
Gross Margin $ = Gross Sales − COGS
Gross Margin % = (Gross Sales − COGS) ÷ Gross Sales × 100
The revenue you retain after accounting for the cost of your products. Gross margin % is the foundational profitability metric. Every markdown, promotion, and inventory optimization decision should be evaluated against its gross margin impact.
Worked example: A category generates $500,000 in gross sales with $300,000 in COGS. Gross Margin = $500,000 − $300,000 = $200,000. Gross Margin % = $200,000 ÷ $500,000 × 100 = 40%.
When to act: If gross margin % is declining period-over-period despite stable sales, the cause is usually rising COGS, deeper markdowns, or mix shift toward lower-margin SKUs. SKU rationalization and open-to-buy adjustments are the primary fixes.
Markdown %
Formula:
Markdown % = Markdown $ ÷ Net Sales × 100
The percentage of net sales that went toward markdowns. This is one of the most closely watched metrics in merchandise financial planning because it directly ties promotional activity to margin erosion.
Worked example: You took $45,000 in markdowns during a quarter with $300,000 in net sales. Markdown % = $45,000 ÷ $300,000 × 100 = 15%. If your plan called for 10%, you've spent 5 points of margin you didn't budget for.
When to act: Compare markdown % to plan weekly on seasonal categories. A markdown rate running more than 2–3 points above plan typically signals an over-bought position or a demand forecasting miss that needs to be corrected in the next buy. See our post on markdowns vs. discounts for strategy guidance.
Sales Metrics
Average Dollar Sales (ADS)
Formula:
ADS = Net Sales $ ÷ Number of Transactions
The average dollar transaction during a period of time.
Worked example: $150,000 in net sales over 3,000 transactions = ADS of $50.00.
When to act: ADS trending down may signal a mix shift to lower-priced items, increased returns, or a promotional environment pulling average ticket down.
Average per Week (APW)
Formula:
APW = Gross Sales Units ÷ Number of Weeks
Number of units sold per week for an item over a specific period. APW is a rate-of-sale indicator used to predict near-term replenishment needs.
Worked example: 520 units sold over 13 weeks = APW of 40 units/week.
When to act: Compare APW to plan. If APW is running 20%+ below plan, review buy depth and selling history assumptions for the next season.
Average Order Value (AOV)
Also known as Average Transaction Value (ATV)
Formula:
AOV = Net Sales ÷ Number of Transactions
The average amount a customer spends per transaction. Useful for evaluating cart and checkout experience effectiveness.
Worked example: $80,000 in net sales across 2,000 transactions = AOV of $40.00.
Average Unit Cost (AUC)
Sales AUC:
AUC = COGS ÷ Units Sold
Inventory AUC:
AUC = Inventory at Cost ÷ Units OH
The average amount paid per unit of inventory.
Worked example: $60,000 COGS on 3,000 units sold = Sales AUC of $20.00/unit.
Average Unit Retail (AUR)
Sales AUR:
AUR = Net Sales $ ÷ Units Sold
Inventory AUR:
AUR = Retail Inventory ÷ Units OH
The average selling price of an item. Declining AUR typically signals promotional pressure or unfavorable mix shift.
Worked example: $90,000 in net sales on 3,000 units = AUR of $30.00.
Cost of Goods Sold (COGS)
Formula:
COGS = (BOP Inventory + Net Purchases + Cost of Labor + Materials and Supplies + Other Costs) − EOP Inventory
The cost of inventory sold within a specified period. COGS is typically the largest cost a retailer incurs and is foundational to every gross margin calculation.
Markdown
A permanent reduction in the price of an item. If products are not moving as expected, a retailer reduces the price to stimulate demand. See our post on markdowns vs. discounts for strategy and timing guidance.
Discount
The reduction in price applied at the point of purchase. Temporary or one-off, unlike a permanent markdown. A 20% promotional event or employee discount falls here.
Allowances
Formula:
Allowances = Discount $ + Markdown $
Total reductions off Ticket Price in a transaction.
Gross Sales
Also known as top-line or gross revenue. The total proceeds of all sales within a period. Typically sourced from the accounting system.
Initial Markup (IMU)
(See calculator section above for worked example and action guidance.)
Formula:
IMU = Ticket Price − COGS
IMU%:
(Ticket Price − COGS) ÷ Ticket Price × 100
Typical IMU percentages vary by vertical; vertically integrated apparel retailers often target 80%+, while general merchandise can run 20–30%. For a deeper breakdown, see our post on IMU vs. MMU.
Maintained Markup (MMU)
(See calculator section above for worked example and action guidance.)
Formula:
MMU = Ticket Price − COGS − Allowances
MMU%:
MMU ÷ Ticket Price × 100
Markup % (MU%)
Formula:
MU% = (Ticket Price − COGS) ÷ COGS
How much the price was marked up from cost, expressed as a percent of cost. Ranges from ~10–20% at Costco to 400–500% in vertically integrated apparel.
Worked example: Ticket price $100, COGS $40. MU% = ($100 − $40) ÷ $40 = 150%.
Net Sales
Formula:
Net Sales = Gross Sales − Returns $
Sales generated after removing returns.
Return Rate %
Formula:
Return Rate % = Return Units ÷ Sales Units × 100
Return rates vary significantly by channel and category. Apparel sees 20–30% online returns vs. ~3% in-store. Managing returns is closely tied to in-stock rate and fit/sizing accuracy.
Sale Price
Formula:
Sale Price = Ticket Price − Allowances
The price at which the product ultimately sells after markdowns and discounts.
Ticket Price
The price initially placed on a product's label; the starting point before any allowances are applied.
Units per Transaction (UPT)
Also known as average basket size.
Formula:
UPT = Units Sales ÷ Number of Transactions
Average units sold per transaction. Higher in general merchandise and consumables; lower in high-ticket or fashion categories.
Worked example: 4,500 units across 1,500 transactions = UPT of 3.0.
Store Productivity Metrics for Retail Planners
These formulas are used daily by store operations teams, regional managers, and planners evaluating physical retail performance.
Sales per Square Foot
Formula:
Sales per Square Foot = Net Sales ÷ Total Selling Square Footage
The most widely used measure of physical retail productivity. Higher-performing retailers in specialty apparel typically target $300–$500+ per sq ft annually; value and off-price formats run lower.
Worked example: A store generates $1,200,000 in net sales with 4,000 sq ft of selling floor. Sales per sq ft = $1,200,000 ÷ 4,000 = $300/sq ft.
When to act: If a store's sales per sq ft is declining while comp-store traffic holds, the issue is likely assortment mix, space allocation, or floor productivity. If traffic is also declining, it's a demand forecasting or site-level demand problem.
Conversion Rate
Formula:
Conversion Rate = Number of Transactions ÷ Foot Traffic × 100
The percentage of store visitors who make a purchase. A key diagnostic for separating traffic problems from in-store execution problems.
Worked example: 800 transactions from 4,000 store visitors = Conversion Rate of 20%.
When to act: If traffic holds but conversion drops, investigate in-store experience, product availability, and in-stock rate. If both decline together, investigate external factors (marketing, competition, location).
Sales per Employee (Labor Productivity)
Formula:
Sales per Employee = Net Sales ÷ Number of Employees (or Hours Worked)
Measures how efficiently labor is converting to revenue. Typically calculated on an annualized or period basis.
Worked example: A store with 8 employees generates $960,000 in annual net sales. Sales per employee = $960,000 ÷ 8 = $120,000/employee.
When to act: If sales per employee is declining while headcount is flat, it signals a productivity or assortment problem. Commonly used alongside store clustering for allocation planning.
Foot Traffic
The total number of customer visits to a store in a given period. Not a formula per se, but the foundational input for conversion rate, sales per sq ft analysis, and store-level allocation decisions.
When to act: Use foot traffic trends alongside sell-through data to calibrate per-store inventory depth. High-traffic stores with high conversion should receive higher initial allocation. See our guide on store clustering.
Productivity Metrics
Sell-Through Rate (ST%)
(See calculator section above for worked example and action guidance.)
Formula:
ST% = Units Sold ÷ BOP Units On Hand × 100
Gross Margin
(See calculator section above for worked example and action guidance.)
Gross Margin Return on Investment (GMROI)
(See calculator section above for worked example and action guidance.)
Learn more in our complete guide to GMROI.
Growth Metrics
Build
Formula:
Build = Total Sales ÷ Previous Total Sales
A measure of growth from one period to the next. Used for week-over-week or month-over-month comparisons.
Worked example: $110,000 this week vs. $100,000 last week = Build of 1.10 (10% growth).
Comparable Store Sales (Comps)
Formula:
Comps = (Total Sales ÷ Previous Same Store Total Sales − 1) × 100
Measures organic growth across stores open more than one year, excluding new store openings. One of the most important metrics for evaluating the health of an existing store base. See our complete guide to comparable store sales reporting.
Worked example: Same stores generated $5.2M this year vs. $5.0M last year. Comps = ($5.2M ÷ $5.0M − 1) × 100 = +4.0%.
When to act: Negative comps for two or more consecutive periods signal a structural issue, often inventory mix, pricing, or store experience, rather than a temporary one.
Inventory Metrics
Average Inventory
Formula:
Average Inventory = (Sum of all BOP Inventory + EOP of last period) ÷ Number of Periods
The average inventory held over time, calculated in cost, units, or retail value.
Worked example: BOP inventory across 4 months: $100K, $110K, $95K, $105K, plus a final EOP of $108K. Average = ($100K + $110K + $95K + $105K + $108K) ÷ 5 = $103,600.
Beginning of Period Inventory (BOP)
The total inventory owned at the beginning of a period. BOP directly constrains achievable sales — you can only sell what you have. Calculated in units, cost, or retail dollars. Called Beginning of Week (BOW) or Beginning of Month (BOM) depending on cadence.
End of Period Inventory (EOP)
Formula:
EOP (Period 1) = BOP (Period 2)
The total inventory at end of period. The EOP of any period equals the BOP of the next, since inventory carries over. Central to open-to-buy planning and merchandise financial planning.
Fill Rate
Formula (Line Item):
Fill Rate = Number of Line Items Shipped ÷ Number of Line Items Ordered
Formula (Order):
Fill Rate = Number of Orders Shipped ÷ Total Number of Orders
Quantifies the ability to fulfill customer orders — or, when applied to supplier POs, the reliability of your vendor. A low supplier fill rate is one of the leading causes of in-stock rate problems.
Worked example: A vendor ships 380 of 400 ordered line items. Fill rate = 380 ÷ 400 = 95%.
When to act: A supplier fill rate below 95% should trigger a review of that vendor's lead time assumptions in your replenishment plan.
Stock to Sales (S/S)
Formula:
S/S = Inventory at BOP ÷ Prior Week Sales
The ratio of inventory to sales. Higher S/S means more inventory overhead relative to sales velocity. Generally lower in fast-moving categories and higher in discretionary ones like fashion and home.
Worked example: BOP inventory of $400,000 with prior week sales of $80,000 = S/S of 5.0.
When to act: S/S ratios running significantly above plan indicate an over-bought position. Use in conjunction with open-to-buy to course-correct.
Inventory Turn
Also known as Turn.
Formula:
Turn = COGS ÷ Average Inventory (Cost $ or Units)
How many times average inventory is sold and replaced in a period. Higher turn = more productive inventory investment. A cornerstone of the GMROI equation.
Worked example: $1,200,000 COGS on average inventory cost of $300,000 = Turn of 4.0x.
When to act: Declining turn without declining sales usually means inventory is building. Fften a sign of over-buying or missed sales going undetected.
Weeks of Supply (WOS) and Forward Weeks of Supply (FWOS)
(See calculator section above for worked examples and action guidance.)
Feels Like a Lot to Monitor?
That's because it is. Toolio helps you crunch these numbers so you can save time, reduce errors, remove guesswork, and focus on the fun stuff. When you're working with billions of data points, it's hard to know exactly how to use that information in order to offer your customers the right products, in the right place, at the right time, for the right price.
That's why we've created this list of the most important retail math formulas you should constantly be monitoring, and built interactive calculators to make them instantly actionable.
