Calculate Your Gross Margin Return On Inventory Investment (GMROI)

Are You Getting What You Need From Your Merchandise?

Man writes mathematical equations on chalkboard
Justin Lewis/ Stone/ Getty Images

One of the biggest things I learned in my 30 years of retail, is that the majority of my money (cash) was tied up in inventory. It was my biggest asset and my biggest liability at the same time. Retailers underestimate the cost of inventory in their stores. They often fail to realize that a product on the shelf that's not selling (turning) actually costs you money. 

An important tool in analyzing inventory, sales and profitability is GMROI (also known as GMROII) which stands for Gross Margin Return On Inventory Investment.

The GMROI calculations assist storeowners and buyers in evaluating whether a sufficient gross margin is being earned by the products purchased, compared to the investment in inventory required to generate those gross margin dollars.

Understanding GMROI

What does all that mean? Let's look at an example. Let's say that within the same year, Madeline's Shoe Store sells boots for $100, which she purchases for $75. Her gross margin is $25, and the inventory's median value throughout the year is $20. Her GMROI then, is $25 divided by $20, or 1.25 percent. 

Gross margin return on investment, or GMROI, demonstrates whether a retailer is able to make a profit on his inventory. As in the above example, GMROI is calculated by dividing gross margin by the inventory cost. And keep in mind what gross margin is: the net sale of goods minus the cost of goods sold.

As long as the GMROI  is higher than 1, (i.e. not in the negative), the company in question is selling its merchandise for more than its cost.

So in Joe's case, the revenue he earns on those boots is 125 percent of his cost.

Why GMROI Matters for Retailers

Retailers need to be well aware of the GMROI on their merchandise, because it lets them determine how much they're earning on for every dollar they invest. If inventory isn't selling, it may be priced too high, but marking it down too much will lead to a smaller gross margin.

 

Of course, if Madeline's Shoe Store wants to increase its GMROI on those boots, she could try selling them for $200. But then she runs the risk of overpricing them, and hurting his potential sales. It's not worth the risk if the boots are a good seller at that price, but may be worth it if they're slowing down a bit, or, if the demand is so great that Madeline thinks his customers would pay more.

How Do I Calculate GMROI?

Find the average inventory at cost. Average inventory is Item price minus discounts, plus freight and taxes. The average is found by adding the beginning cost inventory for each month plus the ending cost inventory for the last month of the period in question. If calculating for a season, divide by 7. If calculating for a year, divide by 13.

Calculate the gross margin of the item. This is the difference between what an item costs and what it sells for. It's also known as the gross percentage of profit, or the margin. 

Divide the sales by the average cost of inventory and times that by the gross margin % to get GMROI.

The result is a ratio indicating the inventory investment 's return on gross margin.

Here's how that looks:

Annual Sales = $150,000    Avg Inventory Cost = $65,000    Gross Margin = 49%

$150,000 / $65,000 X 49% = $1.13

So in this scenario, the retailer is making $1.13 and for every $1.00 invested in inventory. Not very good. Can you see how GMROI highlighted an issue here? We might look at 49% gross margin and think we are doing well. But the numbers show us we are not. 

GMROI calculation can be used to measure the performance the entire store, but it is more effective if used for a particular department or category of merchandise. For example, Madeline would check GMROI for boots and shoes and accessories individually to ensure she is getting the most return on her investment. In my stores, I found that calculating GMROI by category was powerful because overall my numbers looked good, but if I dug deeper, I could find products that were a "drain" on my investment. And then I could take action to resolve it.