• Home
    • About DBI
    • Award Winning Diver BI Software
    • Customer Commendations
    • The Team
    • DBI Privacy Policy
  • Articles
    • News
    • Accolades
    • Blog
  • Products
    • Diver | BI
      • Diver Workbench
      • Videos
      • Case Studies
    • Gap 360 Sales Analysis
      • Diver on demand in the Cloud
  • Applications
    • Property
      • Property Prices Ireland
    • Supply Chain
      • Retail
      • Wholesale
      • Distributor
      • Produce
      • Manufacturing
      • Autoparts
      • Transport
      • Beverage Alcohol Suppliers
      • Beverage Alcohol Distributors
      • DI Program Advisor
    • Diversity
      • Waste management
      • Telecom Brokerage
      • Colleges & Universities
      • Economic Trends
      • Maps
      • Travel & Tourism
      • Parking
      • Smart Meters
      • Carbon Emissions Management
    • Healthcare
      • Healthcare
      • Pharma Applications of Diver
      • DI Surgery Advisor
      • DI Physician Performance Advisor
    • Finance
      • Finance
      • DI GL Advisor
    • Mobile
      • DiveTab Mobile BI
  • Partners
    • Dimensional Insight
    • Diver BI Group
      • Envisage
      • Chartwell IT
      • Cloud-works Solutions Ltd
      • Data Management Business Insight
      • Manitex
      • Equiniti ICS
      • Pinnula
      • Formell
      • IBI
    • Zight – Partner for Transport
    • 24/7 Uptime
    • ID Technology (Brazil)
    • Infotool (Nordic Countries)
    • BIMAXIS – DI France
    • KDE Group (Israel)
  • Services
    • SaaS
    • Training
    • Support
    • Software Development
    • Consultancy
  • Contact

DBI Dynamic
Business
Informatics

Home Articles Inventory Analytics: Four Key Sales-Related Metrics to Watch

Inventory Analytics: Four Key Sales-Related Metrics to Watch

Thursday 19th January 2023

 

wholesaler

by Mike Brockway

Reading Time: 5 minutes

The ever-increasing digitization of the distribution business is generating ever-increasing amounts of data – and making it harder to discern which metrics are the most important for profitability and growth. For distributors, inventory is one of the most important drivers of success, thus underlining the need for insightful and actionable inventory analytics.

In my last blog, I presented key metrics that track inventory alone and the interplay of inventory and employees. Today I will focus on inventory and sales numbers. Here are four metrics related to inventory and sales that will help distributors up their game.

Inventory and sales metrics

  • Gross Margin Return on Investment (GMROI)
  • Rate of return
  • Sell through rate
  • Lost sales

For each of these measurements, businesses should track them alongside a goal. It can be a goal generated by your own company or an industry-wide goal. Within many industries, these metrics are tracked and published by trade associations and private companies, including ReferenceUSA, BizStats, and Risk Management Association, among others.

As with all analytics, these metrics are most useful when they are presented in ways that are simple, clear, and actionable, allowing the user to dive into the details behind each measurement.

GMROI

GMROI stands for “gross margin return on investment” and it is a very important number to track. This is an inventory profitability evaluation ratio that measures a firm’s ability to turn inventory into cash above the cost of inventory. Here is how you calculate your GMROI:

Gross margin = (gain from investment – cost of inventory)

GM% = gross margin / gain from investment

GMROI = gross margin / average inventory cost

Let’s say your gross margin is $55,000 and your average inventory cost is $30,000. Your GMROI is 1.83, which means you earn $1.83 for every dollar in inventory.

Companies want their GIMROI to be as high as possible. A low GIMROI – 1 or below – signals a company running into danger, one that may not be making enough money to recoup its investment or to buy more inventory. As a benchmark, the average GIMROI in retail is 3.2. Remember that all profit comes out of your gross margin, so it needs to be large enough to cover your payroll and other operating expenses.

GMROI should be displayed against both gross margin and gross margin percentage, along with the goal.

Rate of return

Returned goods cost a company money, so it is wise the track and analyze them. Costs associated with returns include picking up the goods, bringing them back to warehouse, counting them, restocking them, and adjusting inventory in the computer.

It is also smart to track the reasons behind returns. Were the items damaged? Did you send the wrong goods, or the right goods at the wrong price, or deliver them on a wrong day? Or did the customer receive something they never ordered? Monitoring the reasons for returns can reveal potential problems in your supply chain or operations as well as opportunities to address those problems.

Businesses should track the percentage of orders that are returned and display the numbers over time. The goal is a zero rate of returns – both because returns cost you money and because any return indicates a dissatisfied customer. The formula is simply returned goods divided by total orders.

Sell through rate

Now let’s look at your sell through rate. This is a comparison of the amount of inventory you received against what is actually sold. It is a good way to assess whether you have the right amount of stock on hand and how well your investment is returning. The sell through rate is usually measured one month at a time. To calculate your sell through rate as a percentage, divide the sales during a certain period by the stock on hand.

Healthy sell through rates vary by industry, but in general, the average goal is 60%. A sell through rate of 5% means you probably have too much stock on hand to support those sales. Or it could indicate your prices are too high. In comparison, a sell through rate of 80% means you have too little inventory on hand and run the risk of running out since your sales are so strong. It also could signal you are priced too low.

Lost sales

Finally, let’s take a look at lost sales and how to get a handle on how much money you are potentially losing when you do not have the right inventory. In order to track lost sales, your system must be configured to track and retain order line items that are fully or partially out of stock. Then you can assess how much money you are losing when an item is out of stock, represented as a dollar value over a period of time. To calculate this, you’ll need to know the average profit margin for every day the item is in stock. Multiply the number of days it was out of stock by the average profit margin when the item is in stock.

The result is best displayed as a straight number, with a graph showing the value over time. Some lost sales are OK, as you will not have your inventory full to 100% capacity all the time. However, distribution companies certainly do not want this lost sales number to get too high.

Final thoughts

There is no doubt that inventory analytics can help distributors makes better-informed buying decisions while revealing potential problems in the supply chain, operations, and pricing. But today’s abundance of data may leave distributors feeling bombarded at times, unsure which data points are most important or how to make them useful.To learn more about how analytics can optimize your inventory management, check out Dimensional Insight’s Inventory Advisor™.

 

Mike Brockway
Mike Brockway is Dimensional Insight’s Consulting Director. He’s also the developer of our Program Advisor and Pricing Advisor applications. Mike presented at the MDM Analytics Summit in September 2018 on inventory analytics.
Avatar photo

Debbie Lonsdale, DBI

Contact Debbie

Previous PostNext Post

Latest News from DBI

  • Dynamic Business Informatics Holiday Message
  • What’s New in Diver 7.2?
  • Dimensional Insight Named an Overall Leader by Dresner Advisory Services in 2022 Industry Excellence Awards
  • Top Logistics Trends for 2022
  • Take a Look at the DIUC22 Agenda

DBI Accolades

  • Dimensional Insight Named an Overall Leader by Dresner Advisory Services in 2022 Industry Excellence Awards
  • Dresner Wisdom of Crowds 2022 – Best in Class Results
  • Klas 2022 – A Grades for Dimensional Insight
  • Dimensional Insight Earns Top Marks in 2021 Wisdom of Crowds Business Intelligence Market Study
  • Best in Klas 2021

Dynamic Business Informatics Ltd

UK & Ireland Distributor of The Diver Solution, providing business consultancy services, products and applications derived from the Diver Solution.
14 Mellifont Avenue
Dun Laoghaire
Co. Dublin

+353 1 2302022

10 Kenyon Street
Nenagh
Co Tipperary

+353 67 43309

Contact Us

We would love to hear from you! Please submit your query and we will get in touch with you shortly.

Email addresses are never sold, rented, or shared. Please see our Privacy Policy.

  • This field is for validation purposes and should be left unchanged.

DBI Blog

How a Growth Mindset Can Help You in Analytics

What are some characteristics of a growth mindset and how can having this frame of mind benefit people who work in analytics? Here are three ways.More

  • How Organizations Can Use Analytics for Supply Chain Agility
  • Inventory Analytics: Four Key Sales-Related Metrics to Watch
  • Inventory Analytics: Two Sets of Metrics that Really Matter
  • 5 Data Trends for 2023

More Blog Posts

Copyright © 2014–2023 DBI · Privacy Policy · website by cubecolour

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.


What Are Cookies?


As is common practice with almost all professional websites this site uses cookies, which are tiny files that are downloaded to your computer, to improve your experience. This page describes what information they gather, how we use it and why we sometimes need to store these cookies. We will also share how you can prevent these cookies from being stored however this may downgrade or 'break' certain elements of the sites functionality.


For more general information on cookies, please read "What Are Cookies".


How We Use Cookies


We use cookies for a variety of reasons detailed below. Unfortunately in most cases there are no industry standard options for disabling cookies without completely disabling the functionality and features they add to this site. It is recommended that you leave on all cookies if you are not sure whether you need them or not in case they are used to provide a service that you use.


Disabling Cookies


You can prevent the setting of cookies by adjusting the settings on your browser (see your browser Help for how to do this). Be aware that disabling cookies will affect the functionality of this and many other websites that you visit. Disabling cookies will usually result in also disabling certain functionality and features of the this site. Therefore it is recommended that you do not disable cookies.


The Cookies We Set




  • Account related cookies


    If you create an account with us then we will use cookies for the management of the signup process and general administration. These cookies will usually be deleted when you log out however in some cases they may remain afterwards to remember your site preferences when logged out.




  • Login related cookies


    We use cookies when you are logged in so that we can remember this fact. This prevents you from having to log in every single time you visit a new page. These cookies are typically removed or cleared when you log out to ensure that you can only access restricted features and areas when logged in.




  • Forms related cookies


    When you submit data to through a form such as those found on contact pages or comment forms cookies may be set to remember your user details for future correspondence.




  • Site preferences cookies


    In order to provide you with a great experience on this site we provide the functionality to set your preferences for how this site runs when you use it. In order to remember your preferences we need to set cookies so that this information can be called whenever you interact with a page is affected by your preferences.




Third Party Cookies


In some special cases we also use cookies provided by trusted third parties. The following section details which third party cookies you might encounter through this site.




  • This site uses Google Analytics which is one of the most widespread and trusted analytics solution on the web for helping us to understand how you use the site and ways that we can improve your experience. These cookies may track things such as how long you spend on the site and the pages that you visit so we can continue to produce engaging content.


    For more information on Google Analytics cookies, see the official Google Analytics page.




More Information


Hopefully that has clarified things for you and as was previously mentioned if there is something that you aren't sure whether you need or not it's usually safer to leave cookies enabled in case it does interact with one of the features you use on our site.


However if you are still looking for more information then you can contact us through our contact page

Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT