Skip to content

GMROII

What is GMROII?

GMROII (Gross Margin Return on Inventory Investment) measures how much gross profit you earn for every dollar of inventory you have on the floor. It combines two things that buyers often look at separately — margin and turn rate — into a single number that tells you whether your inventory is actually working hard for you.

The formula:

Net Profit ÷ Average Inventory Cost

A GMROII of 2.00 means you generated $2.00 in net profit for every $1.00 of average inventory. A GMROII of 1.00 means you broke even — your profit exactly equals your average inventory investment. Below 1.00, the department is not earning back its cost. (Net Profit here is gross profit after inventory adjustments — shrink, trash, store use, and count variances count against the department.)

Tip

GMROII is most useful as a comparison tool — comparing departments to each other, or the same department across different years.

What's on the Page?

Reports → Inventory → GMROII

The GMROII report shows each department's return on inventory investment for a chosen period, with a chart at the top (average inventory as bars, net profit and GMROII as lines) and a sortable table below. Click the download icon to export the table as a CSV file.

Report options:

  1. Period — choose Day, WTD, MTD, QTD, YTD (default), TTM (trailing twelve months), or Custom.
  2. For a custom range, enter dates in the two date boxes (start and end); the Period switches to Custom automatically.
  3. Group by — view results by Department (default) or by Department Head (the primary employee assigned to each department).
  4. Click View.

Columns:

  • Department (or Dept. Head) — the department (or department head) being measured
  • Avg Cost — the average cost-value of inventory on hand across the period, not just the ending snapshot. The report samples the inventory level monthly (weekly for periods under about 12 weeks) and averages the samples; the exact sample dates used are listed under the table.
  • Sales $ — net sales for the period, with % (share of total sales) beside it. Click a department's Sales $ to open the item-level sales for that department.
  • COGS — cost of goods sold for the period
  • Profit $ — Sales $ minus COGS, with % (share of total profit) beside it
  • Margin — Profit $ as a percentage of Sales $
  • Adjust $ — inventory adjustment (variance) dollars for the period: shrink, trash, store use, count variances. Usually negative. Click it to open the department's adjustment drill-down.
  • % (of Sales) — Adjust $ as a percentage of Sales $
  • Net Profit — Profit $ plus Adjust $ (adjustments count against the department)
  • GMROII — Net Profit ÷ Avg Cost
  • Turns — COGS ÷ Avg Cost: how many times the period's sales turned over the average inventory
  • Stock-Sales % — Avg Cost ÷ Sales $: how many dollars of inventory were carried per dollar of sales
  • Profit $/sf — Net Profit divided by the department's stocked square footage (only populated when square footage is entered for the department)

GMROII by Sub Department

Reports → Inventory → GMROII Sub. Depts.

The GMROII Sub. Depts. report is the same GMROII calculation broken out one row per department + sub department combination, so you can see which parts of a department are earning their keep. Rows with a - in the Sub. Department column are the items in that department that have no sub department assigned.

  1. Choose a Period — Day, WTD, MTD, QTD, YTD (default), TTM, or Custom (enter dates in the two date boxes).
  2. Click View.

The columns are the same as the department-level GMROII report (Avg Cost, Sales $, %, COGS, Profit $, %, Margin, Adjust $, % (of Sales), Net Profit, GMROII, Turns, Stock-Sales %), without the chart and without Profit $/sf. Click the download icon to export the table as a CSV file.

Warning

Because average inventory is sampled for every sub department separately, this report can take noticeably longer to load than the department-level version — especially for long periods.

How to Read the Results

GMROII is driven by exactly two levers: margin and turn. Almost every result you see traces back to one of them.

Situation What it means Where to look
High GMROII Department earns well per dollar invested Healthy — use as a benchmark
Low GMROII, good turn Items move quickly but aren't earning much Pricing problem — margin is too thin
Low GMROII, slow turn Margin is fine but inventory sits too long Purchasing problem — too much on hand
Very high GMROII Possibly understocked — leaving sales on the table Check on-hand levels

The Two Levers

Margin is the percentage you keep after cost. If a department's GMROII is low even though product is moving steadily, the issue is almost always pricing — items are priced too close to cost, or markdowns are frequent.

Turn rate is how often you sell through your average inventory in a given period. A department with strong margins but low GMROII has a purchasing problem: you're buying more than you're selling in a reasonable time, tying up capital that could be deployed elsewhere.

Info

A quick way to isolate the problem: check the Best/Worst Selling report for the same department and period. If your worst sellers are concentrated in the low-GMROII category, it's a purchasing problem. If everything moves but the number is still low, it's a pricing problem.

Practical Uses

Identify hidden underperformers. A department can look busy and still have a low GMROII if margins are thin or if the category carries a lot of slow inventory that never gets counted against it in simpler reports.

Find departments punching above their weight. Smaller, lean departments sometimes show excellent GMROII because they turn quickly with good margins. These are worth investing more in.

Guide seasonal buying decisions. Run GMROII for last season to understand which departments earned well and which tied up cash. Use that to adjust your Open to Buy budgets and Order Planning priorities for the coming year.

Diagnose pricing inconsistencies. If GMROII is unusually low or high compared to similar categories, check whether prices are set correctly. Mis-priced items (especially on cost updates that didn't trigger a price change) show up clearly here.

Relationship to Other Reports

  • Open to Buy — Use GMROII to set turn-rate targets for your OTB budget
  • Best/Worst Selling — Identifies specific items driving low turn in a department
  • Inventory Graphs — Visualize average inventory levels over time to understand the "average inventory" component
  • Buyer's Guide — Full workflow for using GMROII alongside other buying tools