GMROI Calculator

We designed this GMROI calculator to help you calculate your gross margin return on inventory.

Are you wondering about the efficiency with which your company transforms inventory into gross profit? Then you're at the right place. GMROI is a powerful performance measurement tool you can use to determine the profitability of your inventory. This article contains information about:

• What GMROI is;
• How to calculate GMROI;
• What is a good GMROI indicator;
• How to use the GMROI indicator; and more!

Gross margin return on investment (GMROI) is a widely used metric for evaluating the inventory's profitability. In other words, GMROI determines how efficiently you can leverage your company's inventory for gross profit.

How can you use the GMROI index? Companies, especially retail establishments, invest much of their capital in inventory. GMROI calculation will guide you to understand whether your inventory is profitable and decide if making changes (e.g., the price and quantity adjustment of the product) may increase your margins. Keep reading to find out what a good GMROI is.

In general, GMROI higher than one means that the company is making a profit on inventory. Consequently, the higher the GMROI indicator is, the better. Although, as the rule of thumb, some consider a GMROI of 3.2 a good indicator for retail stores. On the other hand, GMROI lower than one means that margins are too low. If you want to improve your inventory management, be sure to implement accounting methods presented at FIFO calculator or LIFO calculator.

The GMROI formula is quite simple. To compute the indicator, you need to perform the following calculations:

GMROI = gross profit / average inventory cost

Where:

• The gross profit equals net sales minus the cost of sold goods.
• The average inventory cost is the average of the beginning and ending inventory.

Let's bring an example of a hypothetical company, Alpha, with the following information:

• Gross profit: $150,000
• Average inventory cost: $50,000.

In this case, GMROI equals $150,000 / $50,000 = $3 . This means that the business makes $3 in gross profits for every dollar spent on inventory. We can also say this company earns gross profits of 300% of the inventory costs.

To get the 2021 GMROI of a retail company like Amazon:

1. Go to the company's public information and look for the Balance Sheet Statement. There, find the inventory values from 2020 and 2021 and calculate the average, which is 28,217,500,000.
2. Afterwards, go to the Income Statement and find a gross profit, in this case, 197,476,000,000.
3. Calculate GMROI by dividing gross profit by average inventory cost, which is approximately 6.99.

The gross margin return on investment (GMROI) is a valuable indicator to determine your company's inventory profitability and possibly adjust the assortment of goods or inventory that generates high margins and minimal turnover to increase the profit.

To calculate the GMROI index, you need to follow the next steps:

1. Calculate the average of the beginning and ending inventory.
2. Divide gross profit (net sales minus the cost of sold goods) by the average inventory cost.
3. That's all! You have now calculated the gross margin return on investment.

Generally, GMROI higher than one is a good indicator. On the other hand, if your GMROI measure is lower than one, inventory is not profitable; therefore, you may need to take steps such as decreasing inventory investment, increasing customer count and average sales, etc.

There are several ways to increase GMROI measure, some of which include:

• Raising the prices of your goods;
• Decreasing inventory investment;
• Minimizing your costs, such as raw material costs; and
• Improving your inventory turnover by keeping your inventory levels constant and increasing sales volume.

Days inventory outstanding (DIO) is a measure that indicates the duration necessary for a company to turn its inventory into sales. On the other hand, gross margin return on investment (GMROI) is a metric to determine how efficiently you can leverage your company's inventory for gross profit.