Skip to main content
Retail math · By category

Retail Math Formulas by Category

The category cut of retail math groups every formula by the part of the business the number describes, rather than by the job title that runs it. It is the cut to use when you are diagnosing a problem instead of doing a task: a season that is missing margin sends you to the margin formulas, whoever owns them.

5 categories, 40 formulas. Each formula page carries the equation, a live calculator, and a worked apparel example. The same formulas are also available in the role cut, which groups them by the job that owns the decision.

How To Read The Category Cut

Each formula sits in exactly one category — the thing it measures, not the thing it influences. Markdown percent is a margin formula even though it moves sell-through, and weeks of supply is an inventory formula even though it is read off sales. One formula, one category, several roles.

That single assignment is what makes the categories useful as a diagnostic path. When a symptom shows up in one category, the formulas next to it are the ones that explain it: a turn problem lives beside the sell-through and plan-variance math, not beside the cost negotiation.

5 categories
Sales
8 formulas

The top line read at the level decisions are made — category mix, achieved retail and unit cost, units and dollars per transaction, returns, and the gross-to-net bridge underneath reported sales.

Category Mix % · Average Unit Cost (AUC) · Average Unit Retail (AUR) · Door-Level Demand Index
MerchandiserBuyerAnalyticsAllocatorExecutive
Sales Formulas →
Productivity
5 formulas

How hard each inventory dollar works between receipt and sell-through: return on the margin those dollars earn, turn speed, and how far the plan has drifted from actual.

Sell-Through Rate · Gross Margin Return on Investment (GMROI) · Inventory Turns · Plan vs Actual Variance %
AnalyticsExecutiveSupply Chain / OpsPlanner
Productivity Formulas →
Growth
1 formula

Period-against-period comparison — comparable store sales, which separates real expansion from calendar shifts and door-count changes.

Comparable Store Sales (Comps) %
Analytics
Growth Formulas →
Inventory
17 formulas

What to buy, when receipts land, and how much cover sits behind the plan: open-to-buy, stock-to-sales, weeks of supply, receipt flow, BOP and EOP, safety stock and fill rate.

Open-to-Buy (OTB) · Weeks of Supply (WOS) · Forward Weeks of Supply (FWOS) · Fill Rate
PlannerAllocatorDesigner / Product DevBuyerSupply Chain / Ops
Inventory Formulas →
Margin
9 formulas

The profitability of the season from first cost to final markdown — initial and maintained markup, markdown, allowances, cost of goods, and target costing.

Initial Markup % (IMU) · Maintained Markup % (MMU) · Markdown % · Target Costing
MerchandiserDesigner / Product DevSupply Chain / OpsExecutive
Margin Formulas →

Diagnose the season, not the spreadsheet.

RetailNorthstar calculates and tracks this math inside a connected apparel planning workflow, so a margin question is answered in the plan rather than rebuilt in a new tab.

No credit card. No commitments.

Connected merchandise planning — live in weeks, not quarters.