# GMROI Calculator: Gross Margin Return on Inventory for Distributors

> Source: https://netray.co/tools/distributor-gmroi-inventory-turns-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Calculate GMROI, inventory turns and days of inventory for a branch, vendor line or product group, and see how inventory levels move the return.

## Category

cost-finance

## Erp

Epicor Prophet 21

## Industry

Wholesale Distribution

## Audience

- Distribution controller
- CFO
- Inventory manager

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### Annual net sales

**Key:** sales

**Type:** number

**Default:** 25000000

**Min:** 0

**Step:** 500000

**Unit:** $

#### Gross margin

**Key:** gm_pct

**Type:** number

**Default:** 24

**Min:** 0

**Max:** 90

**Step:** 0.5

**Unit:** %

#### Average inventory at cost

**Key:** avg_inv

**Type:** number

**Default:** 4500000

**Min:** 0

**Step:** 100000

**Unit:** $

**Help:** Use an average of several month-end values, not a single snapshot.

**Outputs:**

#### Gross margin dollars

**Key:** gm_dollars

**Expr:** sales * gm_pct / 100

**Format:** currency

#### Cost of goods sold

**Key:** cogs

**Expr:** sales - gm_dollars

**Format:** currency

#### Inventory turns

**Key:** turns

**Expr:** cogs / avg_inv

**Format:** decimal

**Primary:** true

#### Days of inventory on hand

**Key:** dio

**Expr:** if(gt(turns, 0), 365 / turns, 0)

**Format:** days

#### GMROI

**Key:** gmroi

**Expr:** gm_dollars / avg_inv

**Format:** decimal

**Primary:** true

**Description:** Dollars of gross margin earned per dollar of inventory at cost.

#### Turn and earn index

**Key:** turn_earn

**Expr:** turns * gm_pct

**Format:** decimal

**Description:** Turns times margin percent, a quick ranking measure.

**Chart:**

#### GMROI by average inventory

**Type:** line

**X:** avg_inv

**From:** 1000000

**To:** 8000000

**Steps:** 28

**Series:**

- gmroi

**Disclaimer:** Use consistent periods. Do not mix annual sales with a single-month inventory balance.

## Content

**Intro:** GMROI measures how many dollars of gross margin each dollar of inventory earns. It combines margin and turns in one number and is a better ranking tool than either alone.

**Sections:**

#### How to use it

**Body:** Enter annual net sales, your gross margin percent and average inventory at cost for the same group: a branch, a vendor line or a product category. Run it for several groups and compare. A line with a high margin but slow turns can earn less per inventory dollar than a thin-margin fast mover, and GMROI shows that directly.

**Bullets:**

- Use average inventory, not year-end, to avoid seasonal distortion.
- Compare within a product family, since norms differ by industry.
- Look at the chart to see how excess stock dilutes the return.

#### The formulas

**Body:** GMROI equals gross margin dollars divided by average inventory at cost. Turns equal cost of goods sold divided by average inventory. Days on hand equal 365 divided by turns. With 25 million in sales at 24 percent margin, margin is 6 million and COGS is 19 million. On 4.5 million in average inventory, turns are about 4.2, days on hand are about 86, and GMROI is about 1.33.

#### Reading the result

**Body:** A GMROI above 1.0 means the margin exceeds the cost of the inventory carried, but most distributors need more to cover operating cost and capital. Compare to your carrying cost rate: if GMROI is below your cost of carrying inventory plus allocated operating expense, the group is not paying its way.

#### Common mistakes

**Body:** Using sales instead of cost of goods sold in the turn calculation overstates turns. Another is measuring inventory at selling price, which breaks the ratio. Finally, comparing GMROI across very different businesses, such as bulk commodities and electronic components, is rarely meaningful.

**Cta:** Netray can help calculate GMROI by branch, vendor and product line directly from ERP sales and inventory history.

**Faq:**

#### What is a good GMROI?

**Answer:** It depends on your industry and operating cost. Many distributors aim for a GMROI of 2 or more at the line level. Compare against your own carrying cost and expenses rather than a published average.

#### How is GMROI different from turns?

**Answer:** Turns only measure speed. GMROI also includes margin, so it shows whether the stock that moves is actually profitable.

#### Which inventory value should I use?

**Answer:** Use average inventory at cost across the period, ideally the mean of month-end balances. Use the same cost basis as your COGS.

#### Can I run it for one item?

**Answer:** Yes, though the result can be noisy for slow movers. It is more reliable at product group, vendor or branch level.

## Search terms

gmroi calculator, gross margin return on inventory, gmroi formula distributor, inventory turns calculator distribution, days of inventory on hand, turn and earn calculator, distributor inventory productivity

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json