Difference between revisions of "Inventory Management System"

From MIT Technology Roadmapping
Jump to navigation Jump to search
 
(77 intermediate revisions by 2 users not shown)
Line 1: Line 1:
Roadmap Creators: [https://www.linkedin.com/in/albert-youngjin-chun | Albert Chun]  [https://www.linkedin.com/in/fmgroman/ | Matthew Guevarra Roman]
Time Stamp: 5 December 2023
=Technology Roadmap=
=Technology Roadmap=


==Roadmap Overview==
==Roadmap Overview==


Inventory management system is a critical component of business operations' supply chain management that ensures efficient flows of materials and products from vendors to customers.  
Inventory management system (IMS) is a critical component of business operations' supply chain management that ensures efficient flows of materials and products from vendors to customers.  An effective inventory management system is essential for businesses to operate smoothly, reduce costs, optimize operations, and meet customer demands. It's a fundamental aspect of supply chain management, impacting various aspects of the business from profitability to customer satisfaction.


‎Key Goals of the SCM – inventory management system are:  
‎Key Goals of IMS are:  


* Providing timely, complete, and accurate inventory levels to managements  
* Providing timely, complete, and accurate inventory levels to managements  
Line 18: Line 24:
‎<br />
‎<br />
Effective management systems provide the right products at the right time and place to meet growing customer demand. It is a critical aspect of modern business operations and plays a crucial role in achieving profitability and customer satisfaction.
Effective management systems provide the right products at the right time and place to meet growing customer demand. It is a critical aspect of modern business operations and plays a crucial role in achieving profitability and customer satisfaction.
IMS can be traced back to ancient civilizations (e.g., Mesopotamia and Egypt), where traders and merchants used rudimentary ledger systems to keep track of their animals and products. Clay tablets and papyrus scrolls were used to record information about inventory levels, transactions, and trade. Over time, IMS developed into more accurate and complex systems for record keeping with the development of more rigorous accounting method, mass production of goods during Industrial Revolution and development of computers and software applications.
[[File:Timeline_v2.png|1000px|frameless|center|]]


[[File:Invt System Overview 2.png|550px|frameless|center|(https://jelvix.com/blog/automated-inventory-management-system]]
[[File:Invt System Overview 2.png|550px|frameless|center|(https://jelvix.com/blog/automated-inventory-management-system]]
Line 24: Line 34:


==Design Structure Matrix (DSM) Allocation==
==Design Structure Matrix (DSM) Allocation==
Positive and negative scope of an IM System as of publication of this roadmap. Figure shows that in Enterprise Resource Planning (ERP) and Supply Chain Management (SCM) systems, some modules can overlap with an IM System, however, wherein IM systems are purchased standalone, below are what is currently considered core IM modules.
[[File:IMSScope.png|frameless|center|750px|Inventory Management System Scope]]


DSM of the Inventory Management System:  
DSM of the Inventory Management System:  
Line 29: Line 44:
[[File:DSM v1.png|frameless|center|750px|Inventory Management System DSM (under Supply Chain Management (SCM) System]]
[[File:DSM v1.png|frameless|center|750px|Inventory Management System DSM (under Supply Chain Management (SCM) System]]


The tree structure of the Inventory Management System. This roadmap focuses on the Inventory Management System.  
The tree structure of the Inventory Management System.  


[[File:DSM List v1.png|frameless|center|600px|Inventory Management System]]
[[File:DSM List v1.png|frameless|center|600px|Inventory Management System]]
Line 36: Line 51:
This OPM represents the Inventory Management System:  
This OPM represents the Inventory Management System:  


[[File:Invt System OPM.png|frame|center]]


==Figures of Merit (FOM)==
[[File:Invt System OPM.png|900px|frameless|center]]
The table below show a list of FOMs by which can assess a Payment System:  
 
 
[[File:OPL 1.png|600px|frameless|center]]
 
[[File:OPL 2.png|600px|frameless|center]]
 
==Figures of Merit (FoM)==
The table below show a list of FOMs by which can assess an Inventory Management System technology:
 
[[File:FoM_Table_1.png|700px|frameless| center]]
 
 
 
==== Examples of FOM performance ====
 
Over the last 52 years, inventory management system was improved by about 7% annualized growth based on the FoM trend indicated below:
 
This is an indirect approach to track technological progress as there is only limited data available related to inventory variances, time to report, % automation, etc. This information is company specific and not generally publicly available. As such, we selected the Total trade (export) value (in USD) per person with two assumptions: (1) all reported “Trade (export) value” were processed and consolidated using supply chain management systems – included in the figure means that the transactions were recorded and processed; and (2) improvements in the system can be represented with fewer resources (people) needed to process and consolidate the same amount of data. Said differently, technological progress and rate of improvement can be supported by one person processing more transaction volumes. Note that year-over-year export values can be influenced by various economic statuses.
 
[[File:FoM Trend 1.png|700px|frameless|center]]
 
[[File:FoM Rate of Improvement Trade Value over population.png|500px|frameless|center|Global Export Value in USD vs. Total Global Population (1950-2022)]]
 
==Company Strategic Objectives==
Historically, FOMs of Inventory Management Systems were constrained by and therefore packaged with hardware components and their interconnectivity. Transaction storage, responsiveness of reports, and data access times mostly depended on the infrastructure platform it was being run. However, as cloud technologies have become the norm, wherein enterprise IMS systems now run off IaaS offerings and SMB IMS systems run as SaaS, hardware constraints have become virtually unlimited. Even with billions of records, Big Data platforms now exist that enable IMS reporting to be extremely capable.  Because of this, FOMs for IMS have become business-centric instead of technology-centric.
 
From an investment perspective, financial considerations focus on the Total Cost of Ownership (TCO) FoM, which could be decomposed into: license costs, deployment costs, servicing costs, support costs, training costs. TCO is often mapped at a 5-15 time horizon.
 
From an operational perspective, FoMs center around efficiency improvements enabled by the IMS.  Such as “Time to process” wherein existing systems are compared to new proposed systems where they measure how much time it will take a processor (end-user) to complete the same process on the two systems.  These processing efficiencies can be decomposed with standard queue analytics such as the ones below:
 
[[File:FoMs and business drivers.png|thumb|500px|center]]
 
 


{| class="wikitable"
{| class="wikitable"
|-
|-
! Class !! Figure of Merit !! Units !! Metric
! Strategic Objective !! Alignment and Targets  
|-
|-
| Performance
| To develop a real-time cross-location inventory state management to make more timely business decisions.
| Value of transactions processed per annum
| We are targeting real-time inventory visibility and management across all branches with an SLO-driven response time of < 1 second. This visibility and control should be available from HQ to branch and branch to branch with proper management and permissions using an Identity Access Management system (IAM).
| [US$]
| Monetary value of all transactions processed per annum.
|-
|-
| rowspan="2" | Productivity
| To develop a stock flow management module with the ability to visualize historical and forecasted stock movements for more data-driven decisions.
| Number of transactions processed per annum
| Visibility and proactive pattern management of stock flow from warehouses, distribution centers, and branches. With improved IMS pattern recognition, we aim to lower cost of overage and underage of stock by 5% to give a return on switching costs.
| # of transactions processed per country, per individual or business client type
| Count of the number of transactions processed per annum.
|-
|-
| Machine learning accuracy
| To enable our system to perform predictive analysis of our stock cycles to minimize holding and landed costs.
| Weighted False Positive ratio
| Lower holding and landed costs of products by 2% based on branch-level stock cycle monitoring as opposed to current-state consolidated stock cycle monitoring.
| <math>\sum_{i=1}^{Systems} Weight_i \frac{FalsePositives_i}{(FalsePositives_i + TrueNegatives_i)} </math>
|-
|-
| rowspan="2" | Efficiency
| To enable our system to timely identify correlation on stock demands and outages of complementary products to prevent stock shortage.
| Average cost per transaction
| Identify correlation on stock demand and stock outages of complementary products with at least 60% accuracy.  
| [US cents]
 
| The total Earnings Before Interest and Tax (Tax) divided by the Number of transactions processed per annum
 
|-
 
| '''Transaction settlement period'''
| '''[Seconds]'''
| The time lag between the payment initiation of the payment order and its final settlement.  
|-
| rowspan="3" | Sustainability
| System downtime per year
| [Seconds]
| The seconds in a year is that the system is not online and processing successfully, i.e., not “up and running”.
|-
| Payment conversion rate
| [%]
| # of settled transactions per annum / # of attempted transactions per annum
|-
| Fraud prevention
| [%]
| # of fraudulent transactions / # approved transactions
|}
|}


==== Examples of FOM performance ====
==Positioning of Company vs. Competition==
[[File:FOMimprovement v1.png|500px|frameless|center|History of Value of Transactions and Number of Transactions Figures of Merit]]
 
As mentioned above, FoMs that businesses look at when purchasing an IMS are not dependent on the raw technical capability of the technology but on it’s net impact in driving business metrics for the company’s operations.  Such impact is measured in terms of queue and inventory analytics for operations and metrics for finance. Below are samples of such metrics measured in order to compare and contrast the competitive landscape of ERP IMS systems.
 
[[File:Competitive Positions.png|thumb|700px|center]]
Source: Aberdeen Group
 
==Technical model==
The following morphological model shows two primary options businesses face when implementing inventory management systems: cloud vs on-premise.
 
Selecting the top 3 ERPs with Inventory Management Systems, we compared critical functionalities that customers need today from these IMS which not involve not just stock monitoring but stock flow management and forecasting.  These functionalities are very dependent on connectivity, which we highlighted as a critical technological constraint above.
 
We also showed the implementation and alternatives needed to implement such features based on cloud vs on-premise.
 
 
[[File:Technical Model.png|700px|thumb|center]]
 
==Financial model==
 
For developing a new "Inventory Management System (IMS)", the development cost of $10MM will be spent in the first year to the following areas.  Please note that the $ amounts herein are NPV demonstrative purpose only as there is a wide range of IMS's with limited public information available. 
 
 
[[File:FM1.png|800px|thumb|center|Summary of initial development costs]]
 
[[File: FM2.png|800px|thumb|centre|right|DCF of expected cash flows]]
 
[[File: FM3.png|800px|thumb|centre|right|DCF of expected cash flows]]
 
==R&D Projects==
Examples of R&D/R&T Project for Inventory Management:
 
:a. AI-Powered Inventory Management - AI-powered system as a demonstrator project to predict inventory demand, taking into account factors such as historical sales data, seasonality, and market trends. The aim was to showcase the ability to reduce overstock and understock scenarios, thus optimizing inventory levels and reducing costs.
 
:b. RFID-based Inventory Management - RFID (Radio Frequency Identification) system for inventory tracking and management. The system aimed to prove real-time visibility into inventory, improve tracking accuracy compared to traditional manual tracking methods, and offer precise data for better decision making.
 
:c. IoT-based Cold Chain Management - cold chain logistics space implementation of an IoT-based inventory management system. The goal was to prove its potential in maintaining temperature consistency, predict equipment failures, and improving overall inventory quality control.
 
:d. Blockchain for Supply Chain Transparency - implementation of a blockchain-based system providing transparency and traceability within the inventory management for sectors where chain-of-custoday tracking is critical, such as pharmaceuticals or food safety.
 
:e. Autonomous Robots for Warehouse Management – introduction of autonomous mobile robots in a warehouse. Aimed to validate the advantages of automation in inventory management, like increased picking accuracy, safety, and efficiency.
 
==Patents and papers==
As inventory management system is a vital part of today’s supply chain management, there are vast number of publications and patents available:
Extensive information is available pertaining to "payment systems":
* 100,000+  “Inventory Management” results from Google Patents
* 200,000+  “Inventory Management System” results from Google Scholar
 
===Examples of patents:===
 
[[File:Patents.png|600px|thumb|center]]
 
Source:
*(1) https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/20230341847
*(2) https://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/20230342705
 
===Examples of papers:===
 
[[File:Publication.png|600px|thumb|center]]
 
<br />
 
Source:
*(1) https://www.sciencedirect.com/science/article/pii/S2212827115012019
*(2) https://ejournal.lucp.net/index.php/ijrtbt/article/view/749
 
 
==Technology Strategy Statement==
 
Inventory management systems will continue to evolve by integrating business technology advancements into their ecosystem of functionality.  We project that IMS manufacturers will be more closely adopting newer versions of their software to better integrate with AI, Blockchain, and Autonomous Vehicles and Drones. Better integration with ERP systems will enable more ubiquitous inventory management across different systems and channels. Also, a drive in supply chain resiliency, efficiency, and sustainability will change how inventory systems operate as newer and better best practices are developed by management and supply chain researchers.
 
 
[[File:IMS Swoosh.png|980px|thumb|center]]
''Projected development of inventory management systems strategies from 2023 to 2030.''

Latest revision as of 01:35, 5 December 2023

Roadmap Creators: | Albert Chun | Matthew Guevarra Roman

Time Stamp: 5 December 2023


Technology Roadmap

Roadmap Overview

Inventory management system (IMS) is a critical component of business operations' supply chain management that ensures efficient flows of materials and products from vendors to customers. An effective inventory management system is essential for businesses to operate smoothly, reduce costs, optimize operations, and meet customer demands. It's a fundamental aspect of supply chain management, impacting various aspects of the business from profitability to customer satisfaction.

‎Key Goals of IMS are:

  • Providing timely, complete, and accurate inventory levels to managements
  • Minimizing carrying costs while ensuring product availability.
  • Reducing stockouts and overstock situations.
  • Enhancing supply chain visibility and responsiveness.
  • Streamlining operations and reducing inefficiencies.
  • Lowering costs while maintaining service levels.
  • Meeting customer demand accurately and on time.
  • Adapting to changes in demand, supply, and market conditions.


Effective management systems provide the right products at the right time and place to meet growing customer demand. It is a critical aspect of modern business operations and plays a crucial role in achieving profitability and customer satisfaction.

IMS can be traced back to ancient civilizations (e.g., Mesopotamia and Egypt), where traders and merchants used rudimentary ledger systems to keep track of their animals and products. Clay tablets and papyrus scrolls were used to record information about inventory levels, transactions, and trade. Over time, IMS developed into more accurate and complex systems for record keeping with the development of more rigorous accounting method, mass production of goods during Industrial Revolution and development of computers and software applications.

Timeline v2.png
(https://jelvix.com/blog/automated-inventory-management-system

*image-source - https://jelvix.com/blog/automated-inventory-management-system

Design Structure Matrix (DSM) Allocation

Positive and negative scope of an IM System as of publication of this roadmap. Figure shows that in Enterprise Resource Planning (ERP) and Supply Chain Management (SCM) systems, some modules can overlap with an IM System, however, wherein IM systems are purchased standalone, below are what is currently considered core IM modules.

Inventory Management System Scope


DSM of the Inventory Management System:

Inventory Management System DSM (under Supply Chain Management (SCM) System

The tree structure of the Inventory Management System.

Inventory Management System

Object Process Model (OPM)

This OPM represents the Inventory Management System:


Invt System OPM.png


OPL 1.png
OPL 2.png

Figures of Merit (FoM)

The table below show a list of FOMs by which can assess an Inventory Management System technology:

FoM Table 1.png


Examples of FOM performance

Over the last 52 years, inventory management system was improved by about 7% annualized growth based on the FoM trend indicated below:

This is an indirect approach to track technological progress as there is only limited data available related to inventory variances, time to report, % automation, etc. This information is company specific and not generally publicly available. As such, we selected the Total trade (export) value (in USD) per person with two assumptions: (1) all reported “Trade (export) value” were processed and consolidated using supply chain management systems – included in the figure means that the transactions were recorded and processed; and (2) improvements in the system can be represented with fewer resources (people) needed to process and consolidate the same amount of data. Said differently, technological progress and rate of improvement can be supported by one person processing more transaction volumes. Note that year-over-year export values can be influenced by various economic statuses.

FoM Trend 1.png
Global Export Value in USD vs. Total Global Population (1950-2022)

Company Strategic Objectives

Historically, FOMs of Inventory Management Systems were constrained by and therefore packaged with hardware components and their interconnectivity. Transaction storage, responsiveness of reports, and data access times mostly depended on the infrastructure platform it was being run. However, as cloud technologies have become the norm, wherein enterprise IMS systems now run off IaaS offerings and SMB IMS systems run as SaaS, hardware constraints have become virtually unlimited. Even with billions of records, Big Data platforms now exist that enable IMS reporting to be extremely capable. Because of this, FOMs for IMS have become business-centric instead of technology-centric.

From an investment perspective, financial considerations focus on the Total Cost of Ownership (TCO) FoM, which could be decomposed into: license costs, deployment costs, servicing costs, support costs, training costs. TCO is often mapped at a 5-15 time horizon.

From an operational perspective, FoMs center around efficiency improvements enabled by the IMS. Such as “Time to process” wherein existing systems are compared to new proposed systems where they measure how much time it will take a processor (end-user) to complete the same process on the two systems. These processing efficiencies can be decomposed with standard queue analytics such as the ones below:

FoMs and business drivers.png


Strategic Objective Alignment and Targets
To develop a real-time cross-location inventory state management to make more timely business decisions. We are targeting real-time inventory visibility and management across all branches with an SLO-driven response time of < 1 second. This visibility and control should be available from HQ to branch and branch to branch with proper management and permissions using an Identity Access Management system (IAM).
To develop a stock flow management module with the ability to visualize historical and forecasted stock movements for more data-driven decisions. Visibility and proactive pattern management of stock flow from warehouses, distribution centers, and branches. With improved IMS pattern recognition, we aim to lower cost of overage and underage of stock by 5% to give a return on switching costs.
To enable our system to perform predictive analysis of our stock cycles to minimize holding and landed costs. Lower holding and landed costs of products by 2% based on branch-level stock cycle monitoring as opposed to current-state consolidated stock cycle monitoring.
To enable our system to timely identify correlation on stock demands and outages of complementary products to prevent stock shortage. Identify correlation on stock demand and stock outages of complementary products with at least 60% accuracy.


Positioning of Company vs. Competition

As mentioned above, FoMs that businesses look at when purchasing an IMS are not dependent on the raw technical capability of the technology but on it’s net impact in driving business metrics for the company’s operations. Such impact is measured in terms of queue and inventory analytics for operations and metrics for finance. Below are samples of such metrics measured in order to compare and contrast the competitive landscape of ERP IMS systems.

Competitive Positions.png

Source: Aberdeen Group

Technical model

The following morphological model shows two primary options businesses face when implementing inventory management systems: cloud vs on-premise.

Selecting the top 3 ERPs with Inventory Management Systems, we compared critical functionalities that customers need today from these IMS which not involve not just stock monitoring but stock flow management and forecasting. These functionalities are very dependent on connectivity, which we highlighted as a critical technological constraint above.

We also showed the implementation and alternatives needed to implement such features based on cloud vs on-premise.


Technical Model.png

Financial model

For developing a new "Inventory Management System (IMS)", the development cost of $10MM will be spent in the first year to the following areas. Please note that the $ amounts herein are NPV demonstrative purpose only as there is a wide range of IMS's with limited public information available.


Summary of initial development costs
DCF of expected cash flows
DCF of expected cash flows

R&D Projects

Examples of R&D/R&T Project for Inventory Management:

a. AI-Powered Inventory Management - AI-powered system as a demonstrator project to predict inventory demand, taking into account factors such as historical sales data, seasonality, and market trends. The aim was to showcase the ability to reduce overstock and understock scenarios, thus optimizing inventory levels and reducing costs.
b. RFID-based Inventory Management - RFID (Radio Frequency Identification) system for inventory tracking and management. The system aimed to prove real-time visibility into inventory, improve tracking accuracy compared to traditional manual tracking methods, and offer precise data for better decision making.
c. IoT-based Cold Chain Management - cold chain logistics space implementation of an IoT-based inventory management system. The goal was to prove its potential in maintaining temperature consistency, predict equipment failures, and improving overall inventory quality control.
d. Blockchain for Supply Chain Transparency - implementation of a blockchain-based system providing transparency and traceability within the inventory management for sectors where chain-of-custoday tracking is critical, such as pharmaceuticals or food safety.
e. Autonomous Robots for Warehouse Management – introduction of autonomous mobile robots in a warehouse. Aimed to validate the advantages of automation in inventory management, like increased picking accuracy, safety, and efficiency.

Patents and papers

As inventory management system is a vital part of today’s supply chain management, there are vast number of publications and patents available: Extensive information is available pertaining to "payment systems":

  • 100,000+ “Inventory Management” results from Google Patents
  • 200,000+ “Inventory Management System” results from Google Scholar

Examples of patents:

Patents.png

Source:

Examples of papers:

Publication.png


Source:


Technology Strategy Statement

Inventory management systems will continue to evolve by integrating business technology advancements into their ecosystem of functionality. We project that IMS manufacturers will be more closely adopting newer versions of their software to better integrate with AI, Blockchain, and Autonomous Vehicles and Drones. Better integration with ERP systems will enable more ubiquitous inventory management across different systems and channels. Also, a drive in supply chain resiliency, efficiency, and sustainability will change how inventory systems operate as newer and better best practices are developed by management and supply chain researchers.


IMS Swoosh.png

Projected development of inventory management systems strategies from 2023 to 2030.