• Twitter
  • Youtube
  • LinkedIn
  • Pinterest
  • Facebook
premier google partner agency microsoft partner advertising agency(234) 380-1650 Contact Us
Hedges & Company
  • Our Work
    • Case Studies
    • Blog Articles
    • About Us
    • Results
  • Digital Marketing
    • Digital Marketing Overview
    • Pay Per Click PPC
    • SEO Plans
    • Programmatic Advertising
    • Website Audit
    • Results
  • Research
    • Automotive Market Research
    • Vehicle Registration Statistics
    • Vehicle Registration FAQs
  • Mailing Lists
    • Automotive Mailing Lists
    • Buy a Motorcycle Mailing List
    • Automotive B2B Lists
    • Automotive SIC, NAICS Codes
    • Mailing List FAQs
    • Mailing Lists >
      • BMW Owners Mailing List
      • Camaro Mailing List
      • Corvette Owners List
      • Electric Car Companies and Hybrid EV Lists for Direct Mail
      • Ford F-Truck Mailing List
      • Ford Mustang List
      • Harley-Davidson Mailing List
      • Jeep Owners Mailing List
      • Volkswagen Audi Recall List
      • Dodge Chrysler Jeep Recall List
      • Kia Recall List
  • Email Services
    • Email Prospecting
    • Email Lists
  • Careers
  • Menu Menu

How to Calculate Gross Profit Margin Return on Investment (GMROI) to Manage Inventory

Marketing Articles
4.2
(6)

Learn calculate GMROI (Gross Margin Return on Investment) in Excel. The Turn Earn Index and GMROI formula are two simple ways to help manage your inventory and run your business. Need to know the GMROI formula? Read on!

GMROI formula definition:

GMROI (Gross Margin Return on Investment) evaluates profitability of inventory with a ratio. It analyzes a company’s ability to turn inventory into cash, above the cost of the inventory.

GMROI formula to manage inventory

I found the formula to calculate #GMROI: GMROI = #GrossMargin $ / Avg Inventory Investment Click To TweetGross Margin Return on Investment, or GMROI, is a way to manage inventory. The GMROI formula uses the gross profit earned for each dollar of your investment in inventory. The calculation is (gross margin $$)/(average inventory investment $$). For example, let’s say your annual gross margin dollars, or your annual gross profit, is $250,000 and your average inventory value is $200,000, then your GMROI is 1.25 (sometimes GMROI is multiplied by 100, and in this case would be 125). Retailers or distributors typically use GMROI to evaluate inventory. Manufacturers use it, too, but not as often.

Manufacturers tend to have a more difficult time connecting raw materials with finished goods. Raw material inventory can be used on many different products. On the other hand, it’s very straight-forward for a retailer, reseller or distributor to use GMROI because it’s simpler to connect purchase expense with inventory turns and gross margin.

A number or ratio higher than 1 indicates a company is selling its inventory at a higher value than it paid for the inventory. A general rule of thumb for retail stores is to have a GMROI of 3.2 or greater.

GMROI impact on products with lower gross margin

Opponents of using GMROI point to it being biased because it overstates the performance for products that have a lower gross margin. On the other hand, it understates products that have a high gross margin. Opponents also point to the two components, gross margin and inventory turns, having equal impact on the formula. They would argue that gross margin is a more important variable. We won’t get sidetracked into arguing for or against in this article, we’re simply showing the calculation and the formula.

GMROI Gross Margin Return on Investment calculation example

turn earn index Excel formula GMROI

This article shows the GMROI formula in Excel, and the Turn and Earn ratio in Excel. You can also scroll down to the end of the article or click the “More on this topic” button.

The GMROI formula tells you how many dollars of gross profit are earned from each dollar you have in inventory. In the above example, we’re producing $1.25 in gross profit for every $1 invested in inventory.

GMROI measures inventory differently than the Turn/Earn Index (see below) and neither is “better.” It’s like 12 inches is not “better” than 30.5 centimeters because they’re essentially the same length.

Definition: Turn and Earn Index

The turn and earn index analyzes inventory turnover and gross margin using a ratio. To calculate turn and earn, multiply inventory turns by gross margin percentage.

Using the Turn and Earn Index vs. GMROI to manage inventory

I found the formula to calculate the Turn Earn Index = #GrossMargin x Inventory Turns #accounting Click To TweetIf you’re a purchasing manager or accountant you may want to justify selling of stocking a SKU (stock keeping unit) with the Turn/Earn Index. It’s also known as the Turn/Earn ratio or Turn/Earn formula, or simply as Turn and Earn. It’s a simple way to help manage inventory and you can evaluate your entire inventory or just a part number to see if it is worth stocking or selling.

Calculate the Turn/Earn index for your inventory by multiplying gross margin x turnover. “Turnover” is simply your inventory turns. Scroll down for a definition of inventory turns.

For an example of Turn/Earn, if your inventory turns 5 times in a year and you have a 35% margin your Turn/Earn index is 175 (35 x 5 = 175).

To calculate the Turn/Earn index for an individual part number or SKU, simply multiply gross margin x turnover (units sold per year). For example a product with a gross margin of 35% that sells 5 per year would have a Turn/Earn Index of 175 (35 x 5 = 175).

Companies typically look for a minimum Index of 100 to 150. There are a lot of reasons for higher or lower numbers and a lot of it depends on whether you are a manufacturer, distributor or a retailer.

A manufacturing company might shoot for a lower minimum index of 100 for an individual part number. Reasons might be that part number is required to support a broader product line, or it is necessary to support replacement parts or components, or it needed to address demand from specific market segments that might be new for the manufacturer.

A retail store might have a higher Index goal of 150 for a SKU. There are reasons to have a higher Turn/Earn Index number. These include limited shelf space, catering to a specialized retail market or keeping inventory low to conserve cash.

Definition: Inventory Turns

Inventory turns is a measurement of how many times inventory is sold or consumed in a given time period, usually one year. Calculate it by cost of goods sold (COGS) divided by inventory cost.

How to calculate inventory turns in Excel

The traditional way to measure SKUs over time is by “turns,” or how many times the inventory turns over each year.

One long formula for inventory turns (written here in ‘Excel spreadsheet-friendly’ format) is:
(($ beginning inventory + purchases over a defined period – ending inventory)/(ending inventory)) x (number of time periods).
The number of time periods is typically 12 months.

A shorter formula to measure inventory turns (again, in ‘Excel-friendly’ format) is:
(Cost of goods from inventory over 12 months)/(Average inventory investment over 12 months).

Learn more:

Use benchmarking to measure key performance indicators and compare your business against peer companies. Hedges & Company managed the SEMA Financial Benchmarking program for seven years, a free member benefit for SEMA members.

Another related article: read about how price increases/decreases and unit sales affect gross profit.

How to Calculate Gross Profit Margin Return on Investment (GMROI) to Manage Inventory was last modified: February 11th, 2021 by admin

How useful was this post?

Click on a star to rate it!

Average rating 4.2 / 5. Vote count: 6

No votes so far! Be the first to rate this post.

Since you thought this post was useful...

Follow us on social media!

We are sorry that this post wasn't useful for you!

Let us improve this post!

Tell us how we can improve this post?

October 15, 2010/6 Comments/by admin
Tags: Automotive Aftermarket, Automotive Aftermarket Market Research, Automotive Marketing, Inventory management
Share this entry
  • Share on Facebook
  • Share on Twitter
  • Share on LinkedIn
  • Share by Mail
6 replies
  1. commercial radiator says:
    February 8, 2012 at 2:06 pm

    I like the helpful info you supply to your articles. I’ll bookmark your blog and come here regularly. I am rather sure I’ll learn plenty of new stuff right here! Best of luck and thanks!

  2. Lesley Chisholm says:
    May 27, 2013 at 3:08 am

    Hi! I’ve been reading your website for some time now and finally got the bravery to go ahead and give you a shout out from Houston Texas! Just wanted to mention keep up the good work!

  3. Desiree Esquivel says:
    June 20, 2013 at 8:03 am

    Hurrah, that’s what I was searching for! What a present here at this website, thanks admin of this web page.

  4. Kavin says:
    April 1, 2014 at 10:03 pm

    Hi i am kavin, its my first time to commenting anywhere, when i
    read this article i thought i could also create comment due to this brilliant article.

Trackbacks & Pingbacks

  1. Using the Pareto 80/20 Principle to Analyze your Business and Increase Profits | Hedges & Company Aftermarket Marketing and Market Research Blog says:
    May 25, 2013 at 11:28 am

    […] you curious about using Turn/Earn to manage your inventory? More information is here in another blog […]

  2. How Price Increase/Decrease Affects Gross Profit vs. Unit Sales | Hedges & Company Automotive Marketing and Market Research Blog says:
    November 22, 2011 at 3:51 pm

    […] article: Read about the Turn/Earn Index. Share this:ShareEmailFacebookDiggTags: automotive aftermarket industry, gross profit, strategic […]

Comments are closed.

Hedges & Company blog

BLOG HOME

Driven by results.
Powered by knowledge.

Blog Categories

  • Aftermarket Analysis (129)
  • Market Research (105)
  • Marketing Articles (113)

Our Latest Articles

  • In With Audience Buying, Out With Media Buying. In With Audience Planning, Out With Media PlanningJanuary 21, 2021 - 4:25 pm
  • Automotive Email Marketing Trends 2021January 14, 2021 - 4:11 pm
  • What is Programmatic Marketing?December 18, 2020 - 2:00 pm

Location

Hedges & Company
5603 Darrow Road, Suite 100
Hudson OH 44236-5015
(234) 380-1650
Hours: 8:30am-5:00pm EST Mon.-Fri.
All company names, brand names, trademarks and logos are the property of their respective owners. BuyerZoom™ and BrandZoom™ are trademarks of Hedges & Company. Copyright 2021 Hedges & Company.

Our Services

  • Digital Marketing
  • Research
  • Mailing Lists
  • Email Services
  • Vehicle Recall Lists
  • In-Market Lists
  • Automotive Direct Mail Advertising

About Us

  • About Us
  • Our Team
  • Careers
  • Case Studies
  • News
  • Privacy & Legal

Our Blog

  • Blog Home Page
  • Aftermarket Trends & Analysis
  • Automotive Market Research
  • Aftermarket Marketing Articles
Stages of Business Growth: Learn the Growth Stages of a Company Hedges & Company focuses on automotive market research. How will 2011 be for the Automotive Aftermarket Industry?
Scroll to top
Fast Quote


    Search Engine Optimization (SEO) on Google or BingPaid Search (PPC) on Google or BingDisplay ads & banner adsEmail marketingGoogle ShoppingNot sure (You can describe what you need at the bottom of the page)


    Immediate! Please get back to me right awayWithin a month1 or 2 monthsJust gathering information for now


    Not being managed, or not doing online marketingManaging in-houseOutside agency


    Having positive ROI: sales vs. budgetIncreasing traffic to my websiteIncreasing brand awarenessCompeting with Amazon or eBayOther (please explain below)


    $5,000 or less$5,000 to $7,500$7,500 to $10,000$10,000 or more

    This form uses Akismet, reCAPTCHA and this quiz to prevent spam and bot submissions.

    Website Audit


      Website SEO AuditDigital Marketing Audit


      Immediate! Please get back to me right awayWithin a month1 or 2 monthsJust gathering information for now

      This form uses Akismet, reCAPTCHA and this quiz to prevent spam and bot submissions.

      SEO Quote


        Base SEO PlanSEO Leader Plan


        Immediate! Please get back to me right awayWithin a month1 or 2 monthsJust gathering information for now

        This form uses Akismet, reCAPTCHA and this quiz to prevent spam and bot submissions.

        Mailing List Quote


          Postal listEmail listOnline digital audience

          This form uses Akismet, reCAPTCHA and this quiz to prevent spam and bot submissions.

          Paid Search


            Google Shopping PlanBasic Paid Search PlaneCommerce LeaderNative or Programmatic Advertising


            Immediate! Please get back to me right awayWithin a month1 or 2 monthsJust gathering information for now

            This form uses Akismet, reCAPTCHA and this quiz to prevent spam and bot submissions.