• Home
  • Diver BI Group
    • Diver | BI
    • Customer Commendations
    • Videos
    • Case Studies & Customers
    • Documents and Brochures
    • Diver BI Group Privacy Policy
  • Articles
    • News
    • Accolades
    • Blog
    • Ask Anthony
  • The Team
    • Key Experts
    • Members
      • Dynamic Business Informatics
      • Envisage
      • Chartwell IT
      • Data Management Business Insight
      • Manitex
      • Equiniti ICS
      • Pinnula
      • Dataweave Solutions
    • Partners
      • Dimensional Insight US
      • Dimensional Insight EU
      • Dimensional Insight Asia
      • DI Panama
      • ID Technology (Brazil)
      • Infotool (Nordic Countries)
      • BIMAXIS – DI France
      • Vision IT
      • Zight -Partner for Transport
  • Applications
    • Property
      • Property Prices Portal
    • Supply Chain
      • Retail
      • Distributor
      • Wholesale
      • Manufacturing
      • Produce
      • Beverage Alcohol Suppliers
      • Beverage Alcohol Distributors
      • Autoparts
      • Transport
      • Public Transport
      • DI Program Advisor
    • Healthcare
      • Healthcare
      • DI Surgery Advisor
      • Pharma BI Applications of Diver
    • Finance
      • Finance
      • DI GL Advisor
    • Mobile & SaaS
      • Diver BI SaaS
      • SaaS for Sales Gap Analysis
      • BI designed for Tablet
      • DiveTab – Mobile BI
    • Diversity
      • Travel & Tourism
      • Colleges & Universities
      • Waste Management
      • Parking
      • Telecom Brokerage
      • Economic Trends
      • Maps
      • Smart Meters
      • Carbon Emissions Management
  • Workbench
  • Contact
    • Free Consultation with One of Our Experts
    • Add a New Revenue Stream as a Partner

DiverBIGroup

Business Intelligence Experts

Diver BI Group Blog Using Data and Analytics to Manage Inventory

Using Data and Analytics to Manage Inventory

23rd March 2023

by John Sucich

Reading Time: 4 minutes

A retailer’s goal is to sell what it has in stock. It may sound simple, but as in any aspect of business, there are complications to that formula. If a retailer buys more of an item than customers want, it might have to mark down that item in order to unload it. The more that happens, the farther the retailer gets from its monetary goals.

Couple that with an uncertain economic time for customers, and it can be even more difficult for retailers to forecast what they need to buy. That’s where data and analytics come in. Here’s how companies can use the numbers to make the right call when it comes to inventory.

Importance of a nimble supply chain

The pandemic made a lot of companies much more aware of their supply chains from top to bottom, but it isn’t the only type of disruption that organizations have to take into account. From labor availability to sustainability issues to Mother Nature, there are many factors that could force a company to have to pivot its operations. Supply chain flexibility can benefit the company in two ways – both in getting a product where it needs to be, and in unloading a product as well.

If an unexpected winter storm hits a warm weather area, for example, a chain that sells winter weather clothing could quickly move product to that area if it has the right infrastructure in place. That same flexibility could help the company bypass issues the storm creates when it comes to shipping those items. Similarly, the easier a company makes it for a customer to return an item, the easier it is for the company to re-sell it. If it can create a simple pathway for the customer, the company will benefit. Rather than having the product sitting at the customer’s home until it’s convenient to bring it back, and possibly going out of style, it can be back on store shelves immediately, before it has to be marked down or becomes irrelevant.

How a retailer can go wrong

Returns can contribute to the type of problem that can plague a retailer: too much inventory. An inventory glut can also result from purchasing too much. That’s what caused a down year for Kohl’s in 2022. The company ended up marking down so much of its products at the end of the year that it was impossible to turn a profit.

The plan for Kohl’s in 2023 is to cut down on inventory. One way the company plans on doing this is to only add inventory when needed to meet customer demand. It will also more closely monitor slow-moving items, and introduce markdowns more evenly throughout the year rather than waiting until the ends of seasons. These are the types of insights data can provide that can help an organization make decisions.

What Macy’s got right

Macy’s is an example of a company that is increasingly using data and analytics to make these types of decisions in a proactive way, rather than as a reaction to bad news. In fact, in an earnings call in early March, the company reported that its inventory levels were down 3% in 2022 and 18% overall compared to 2019. Macy’s executives also said that more than two-thirds of its $1.3 billion in capital expenditures in 2022 went toward data analytics and other supply chain modernization projects, as employees have used data and analytics more to calculate pricing and to forecast sales demand.

Macy’s initiatives covered many aspects of the supply chain, including getting the product to customers. It considered pick-up in store, faster delivery to customers’ homes, package consolidation, so one order doesn’t result in many packages if customers order online, and the company even looked at creating efficiencies in the return process.

Another metric that the company watches closely is related to its customers’ buying: how often they use credit, how quickly they repay, and what debt levels look like. If, based on that information, it looks like the economy is slumping, Macy’s won’t expect as many sales as other years. Macy’s has been credited with a ‘disciplined’ approach to inventory, and it is a model that other companies are likely to try to follow based on its success.

It’s also an approach that is not limited to retailers. Companies across all types of industries are looking at these types of efficiencies, especially since March of 2020. From just-in-time manufacturing to finding enough warehouse storage if they decide to stock up on product, having the right analytics solution in place can help an organization make the right decisions based on its individual situation and needs.

John SucichJohn Sucich
John has more than a decade of experience in education as a teacher, board member, and communicator. He also spent several years in sports journalism. John graduated from Boston University with a bachelor’s degree in broadcast journalism and from Lesley University with a master’s degree in elementary education.

Tags: Dimensional Insight, Retail Inventory, Supply Chain;Supply chain analytics

Articles

  • News
  • Accolades
  • Blog
  • Ask Anthony
  • Diver | BI
  • Customer Commendations
  • Videos
  • Case Studies & Customers
  • Documents and Brochures
  • Diver BI Group Privacy Policy

Dynamic Business Informatics Ltd

Distributors of The Diver Platform, providing business consultancy services, products and applications derived from Diver Gateway & Diver Platform.
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. See our Privacy Policy.

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

Accolades

  • Best in Klas Report 2023 – Straight A Grades for Dimensional Insight
  • 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

Copyright © 2023 Diver BI Group · 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