Skip to content
Omnikalc

What is your gross margin return on inventory?

Enter sales, cost of goods sold and opening and closing inventory: get GMROI, the gross margin, the average inventory, turnover and days of inventory.

Updated on
Your inputs
$

Value out of range

$

Value out of range

$

Value out of range

$

Value out of range

Results

GMROI

2.33 $ per $1 of inventory

Above 2: each dollar of inventory earns more than two dollars of gross margin
Gross margin
$420,000
Gross margin percentage
35.0%
Average inventory at cost
$180,000
Inventory turnover
4.33 x
Days of inventory
84 days

A shelf full of goods ties up cash. GMROI, the gross margin return on inventory investment, tells you how much gross margin that cash earns. It combines two ideas that retailers and wholesalers watch separately, the margin on each sale and the speed at which stock sells, into a single number you can compare across products, departments or stores.

How the calculation works

  • Gross margin = net sales − cost of goods sold
  • Average inventory = (opening inventory + closing inventory) ÷ 2, valued at cost
  • GMROI = gross margin ÷ average inventory
  • Turnover = cost of goods sold ÷ average inventory
  • Days of inventory = 365 ÷ turnover

Example

A shop sells $1,200,000 of goods that cost $780,000 during the year, so the gross margin is $420,000, or 35%. Its inventory is $160,000 at the start and $200,000 at the end, an average of $180,000. GMROI is 420,000 ÷ 180,000 = 2.33: each dollar tied up in stock returned $2.33 of gross margin. Turnover is 4.33 times a year, which is about 84 days of inventory.

Why it matters

A product with a thick margin can still be a poor use of cash if it sits on the shelf for a year. A low-margin item that turns over fast can earn more. GMROI shows which lines deserve more space and purchasing budget, and which should be marked down or dropped. Buyers also use it to set targets for each department.

Good to know

Use the same period for sales, cost and inventory, and use a longer average for seasonal businesses, such as the 12 monthly month-end stocks instead of just two. GMROI ignores the cost of running the store, such as rent and wages, so a good value does not guarantee a profit. It also depends on the product mix, so compare similar categories.

The inventory turnover calculator isolates the speed of rotation, the gross margin calculator works from the selling price, and the EOQ calculator finds the order size that balances ordering and holding costs.

Frequently asked questions

What is GMROI?

Gross margin return on inventory investment shows how many dollars of gross margin each dollar invested in inventory produces over a period. It is the gross margin divided by the average inventory at cost.

What is a good GMROI?

Above 1 means the inventory pays for itself. Many retailers aim for 2 to 3 or more, though the right level depends on the trade: grocery stores run high turnover with low margins, jewellery stores the opposite.

How does GMROI relate to turnover?

GMROI equals the gross margin percentage times the turnover, divided by one minus the margin percentage. Either a higher margin or faster stock rotation raises it, which is why it is used to compare very different product lines.

Should inventory be at cost or at retail?

At cost. The goal is to measure the return on the money actually invested in stock, so use the purchase price or the carrying cost, not the selling price.

Was this calculator helpful?

Thanks for your feedback!

Results are estimates provided for information purposes. They do not replace professional advice.