# GMROI Calculator for Wholesale Distributors

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

## Short answer

Calculate gross margin return on inventory investment, inventory turns and days of inventory, and see how GMROI changes as average inventory grows.

## Category

supply-chain

## Erp

Epicor Prophet 21

## Industry

Wholesale Distribution

## Audience

- Inventory manager
- Controller
- Owner

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### Annual net sales

**Key:** sales

**Type:** number

**Default:** 12000000

**Min:** 0

**Step:** 50000

**Unit:** $

**Help:** Net of returns and discounts.

#### Annual cost of goods sold

**Key:** cogs

**Type:** number

**Default:** 9000000

**Min:** 0

**Step:** 50000

**Unit:** $

#### Average inventory at cost

**Key:** avg_inv

**Type:** number

**Default:** 2400000

**Min:** 1

**Step:** 25000

**Unit:** $

**Help:** Average of month-end balances is better than a single snapshot.

#### Annual carrying cost rate

**Key:** carry

**Type:** slider

**Default:** 22

**Min:** 8

**Max:** 40

**Step:** 1

**Unit:** %

**Help:** Capital, storage, insurance, shrink and obsolescence.

**Outputs:**

#### Gross margin

**Key:** gm

**Expr:** sales - cogs

**Format:** currency

#### Gross margin percent

**Key:** gm_pct

**Expr:** if(gt(sales,0), gm / sales * 100, 0)

**Format:** percent

#### GMROI

**Key:** gmroi

**Expr:** gm / avg_inv

**Format:** decimal

**Primary:** true

**Description:** Gross margin dollars earned per dollar of average inventory at cost.

#### Inventory turns

**Key:** turns

**Expr:** cogs / avg_inv

**Format:** decimal

#### Days of inventory

**Key:** days

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

**Format:** days

#### Annual carrying cost

**Key:** carry_cost

**Expr:** avg_inv * carry / 100

**Format:** currency

#### Gross margin after carrying cost

**Key:** net_after_carry

**Expr:** gm - carry_cost

**Format:** currency

**Primary:** true

**Chart:**

#### GMROI as average inventory grows

**Type:** line

**X:** avg_inv

**From:** 1200000

**To:** 4800000

**Steps:** 24

**Series:**

- gmroi

**Disclaimer:** GMROI is a ratio of gross margin to inventory at cost. Use it to compare product lines and branches, and pair it with service level so you do not cut stock that customers need.

## Content

**Intro:** GMROI tells you how much gross margin each dollar of inventory earns in a year. Two product lines with the same margin percent can differ sharply in GMROI if one turns four times and the other twice. This calculator shows the ratio, the turns behind it and the carrying cost.

**Sections:**

#### How to use the calculator

**Body:** Enter annual net sales and cost of goods sold, then average inventory at cost. The result shows gross margin, GMROI, turns and days of inventory. Run it for the whole company first, then for each product line or branch by entering that group's figures. Use the carrying cost slider to see the margin left after the cost of holding inventory.

**Bullets:**

- Use average inventory, not year-end
- Use cost, not selling value, for inventory
- Compare like with like, such as one product line to another
- Revisit quarterly

#### The formula

**Body:** GMROI equals gross margin dollars divided by average inventory at cost. It can also be written as gross margin percent multiplied by sales divided by average inventory. In the default example, gross margin is 3,000,000 and average inventory 2,400,000, so GMROI is 1.25. Turns are cost of goods divided by average inventory, 3.75 here, which is about 97 days of inventory.

#### Reading the result

**Body:** A GMROI above 1.0 means the gross margin more than covers the inventory investment, but the real hurdle is your carrying cost rate. At 22 percent, the example carries about 528,000 a year, so the gross margin after carrying cost is still positive. Lines with GMROI below the carrying rate destroy value, they are candidates for tighter stocking or exit. Use the chart to see how adding stock reduces the ratio.

#### Common mistakes

**Body:** Using year-end inventory when stock was seasonally low or high, mixing retail value and cost, and comparing categories with different natural turn rates. Also remember that cutting inventory improves GMROI only if sales hold. Watch fill rate alongside the ratio.

**Cta:** If you want GMROI by product line and branch calculated from your ERP inventory and sales data, with a human reviewing the result, we can discuss a read-only analysis.

**Faq:**

#### What is a good GMROI for a distributor?

**Answer:** It varies by industry and product mix. Many distributors look for a GMROI comfortably above their carrying cost rate, and often 2.0 or higher for healthy lines. Compare your own lines and trend over time rather than relying on a single number.

#### Why use average inventory?

**Answer:** A single snapshot can be inflated or depressed by timing. Averaging month-end balances smooths seasonal swings and gives a fairer picture of the capital tied up during the year.

#### How is GMROI different from inventory turns?

**Answer:** Turns measure speed, GMROI measures profit per inventory dollar. A fast-turning, low-margin line may have the same GMROI as a slow, high-margin one. GMROI is the better guide for stocking decisions because it includes both.

#### What carrying cost rate should I use?

**Answer:** Finance usually sets it. Components include the cost of capital, storage, insurance, taxes, shrink and obsolescence. Rates between 15 and 30 percent are commonly cited, but use your own figure.

## Search terms

gmroi calculator, gross margin return on inventory, gmroi formula distributor, inventory turns calculator, days inventory outstanding distributor, gmroi by product line, inventory productivity, turn and earn index

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