Flevy Blog is an online business magazine covering Business Strategies, Business Theories, & Business Stories.

Inventory Management. How to Do It Right.

Editor's Note: Take a look at our featured best practice, Inventory Management Template - Inventory Tracker (Excel workbook). Inventory Management Template Introducing our powerful and user-friendly inventory template! Our template is designed to help you efficiently manage your inventory and stay on top of your stock levels. With features such as automatic updates, interactive reports, and easy-to-use input fields, [read more]

* * * *

Editor’s Note: Vishnu Rayapeddi is a recognized pioneer of Lean Management and founder of Productivity Solutions.   You can view all of his Supply Chain training materials on Flevy here.

* * * *

FEMA_-_24316_-_Photograph_by_Liz_Roll_taken_on_05-11-2006_in_TexasFor accountants “inventory is an asset” and it is shown that way on balance sheets! Is inventory really an asset?

Inventory is an “idle resource” and takes up space, consumes money and needs a lot of time to manage it! In Lean thinking, inventory is categorised as a “waste” and is depicted with a “tomb stone” icon in Value Stream Mapping by Toyota!

But, as a matter of fact, inventory is required in most businesses to satisfy their customers. So, the question is how much to keep? The answer depends on the type of industry you are in and what level of customer service level (DIFOT) you would like to achieve. Is 100% DIFOT practical? May be or may be not! Again it depends on the type of industry you are in. But, surely you would the DIFOT to be closer to 100%. The more inventory you keep, the better is the customer service level. In essence it is a balancing act.

The question as to how much inventory to keep also depends on the type of environment your business works in, i.e., “Make to Stock,” “Make to Order,” “Assemble to Order,” and “Engineered to Order” and the expected Lead Times by your customers.

Inventory Management and Inventory Control are the most widely discussed topics globally. Though businesses have been using computerised systems such as MRP, we still seem to get it wrong even today with advanced technology and ERP systems. The reason is simple…we don’t stick to the basics!

The fundamentals of MRP haven’t changed in decades and MRP is still the heart of every ERP system along with many added bells and whistles.

How does MRP work?

The inputs to MRP are:

  1. Stock on Hand,
  1. Forecasts or Customer Orders,
  1. Master Data and Inventory Parameters such as
    • Bills of materials
    • Economic Order Quantities
    • Lead Times
    • Minimum Maximum Stock Levels
    • Safety Stock and
    • Re-order Point

The outputs of MRP are:

  1. What to Order
  1. When to Order
  1. How much to order

Doesn’t it look very straight forward? If it is so straight forward, why do we get it wrong? That’s because we lack discipline! Just the way we need to maintain our body on a regular basis with food, water and exercise, we need to maintain the computer system.  What it means is that we need to ensure that the data is accurate, which means we need to review it on a regular basis and make amendments as required as everything around us keeps changing.

10  Tips for Your Inventory Control and Management

  1. Work on getting the end-to-end “Visibility” in your supply chain;
  1. If making to forecasts, ensure that the forecasts are as accurate as possible with input from your sales & marketing teams;
  1. To ensure the “Stock On Hand” is accurate, introduce Cycle Counts and make sure the book / system stock and physical stock match within a +/- 2% accuracy;
  1. Ensure stock rotation is done. In many businesses the raw materials and finished goods have certain shelf-life. To ensure you are using the correct shelf-life materials, use FIFO (First In First Out) or the items which are expiring first;
  1. Ensure that all your Bills of Materials are accurate and if you are using “back flush” function, make sure you add a small “wastage %”;
  1. Ensure that the inventory parameters (items 3b to 3f in the inputs to MRP above) are reviewed and adjusted at least every 6 months;
  1. Conduct an ABC Analysis and manage your inventory accordingly, i.e., keep a close eye on the A items, have less stock of them and procure frequently as they cost a lot to keep in inventory;
    • A inventory accounts for about 20% of the items and 80% of the dollar usage;
    • B inventory accounts for about 30% of the items and 15% of the dollar usage;
    • C inventory accounts for about 50% of the items and 5% of the dollar usage;
  1. Store the materials as per ABC categories, i.e., Here the ABC’s refer to Fast Moving, Medium Moving and Slow Moving. Keep the A’s closer to the exit to reduce transportation and minimise damages and C at the far end of the warehouse;
  1. Introduce 5S in the warehouse and implement “A Place for Everything and Everything in it’s Place”. In case your computer determines randomly the storage area, ensure that the records are accurate, i.e., if you physically move the items ensure to make amendments to your system. This would reduce your searching time hugely and increases productivity;
  1. Introduce Kanban systems where appropriate.

The Important KPIs / Metrics for Inventory Management

  1. Inventory Turns (Cost of Goods Sold / Average Inventory Value)
  1. Stock accuracy
69-slide PowerPoint presentation
The Supply Chain Fundamentals Series has 5 modules in all as below: Module 1 - Forecasting - 73 Slides Module 2 - Aggregate Planning - 28 Slides Module 3 - Materials Requirement Planning - 36 Slides Module 4 - Scheduling - 43 Slides Module 5 - Inventory Management - 69 Slides The 5th Module [read more]

Do You Want to Implement Business Best Practices?

You can download in-depth presentations on Inventory Management and 100s of management topics from the FlevyPro Library. FlevyPro is trusted and utilized by 1000s of management consultants and corporate executives.

For even more best practices available on Flevy, have a look at our top 100 lists:

These best practices are of the same as those leveraged by top-tier management consulting firms, like McKinsey, BCG, Bain, and Accenture. Improve the growth and efficiency of your organization by utilizing these best practice frameworks, templates, and tools. Most were developed by seasoned executives and consultants with over 20+ years of experience.

Readers of This Article Are Interested in These Resources

Excel workbook
If you are an inventory manager and what a quick spreadsheet tool that tells you what items are likely to need reordering in priority of days until reorder point, this tool should help. This template is designed to keep track of many inventory SKUs. The main benefit is in organization and logic [read more]

113-slide PowerPoint presentation
Excel workbook

About Vishnu Rayapeddi

Vishnu Rayapeddi is a Lean Manufacturing & Supply Chain Operations Specialist, who works as a volunteer Executive Committee Member of NZPICS, the only Premier Channel Partner of APICS in New Zealand. NZPICS Offers the following courses in Supply Chain in affiliation with APICS: CPIM (Certified in Production & Inventory Management, CSCP (Certified Supply Chain Professional) and Principles of Operations Management, which is a fully customizable solution to businesses. Vishnu also is a leading contributor on Flevy of Lean Six Sigma training materials, which can be found here.

, , ,

Complimentary Business Training Guides

Many companies develop robust strategies, but struggle with operationalizing their strategies into implementable steps. This presentation from flevy introduces 12 powerful business frameworks spanning both Strategy Development and Strategy Execution. [Learn more]

  This 48-page whitepaper, authored by consultancy Envisioning, provides the frameworks, tools, and insights needed to manage serious Change—under the backdrop of the business lifecycle. These lifecycle stages are each marked by distinct attributes, challenges, and behaviors. [Learn more]

We've developed a very comprehensive collection of Strategy & Transformation PowerPoint templates for you to use in your own business presentations, spanning topics from Growth Strategy to Brand Development to Innovation to Customer Experience to Strategic Management. [Learn more]

  We have compiled a collection of 10 Lean Six Sigma templates (Excel) and Operational Excellence guides (PowerPoint) by a multitude of LSS experts. These tools cover topics including 8 Disciplines (8D), 5 Why's, 7 Wastes, Value Stream Mapping (VSM), and DMAIC. [Learn more]
Recent Articles by Corporate Function






The Flevy Business Blog (https://flevy.com/blog) is a leading source of information on business strategies, business theories, and business stories. Most of our articles are authored by management consultants and industry executives with over 20 years of experience.

Flevy (https://flevy.com) is the marketplace for business best practices, such as management frameworks, presentation templates, and financial models. Our best practice documents are of the same caliber as those produced by top-tier consulting firms (like McKinsey, Bain, Accenture, BCG, and Deloitte) and used by Fortune 100 organizations. Learn more about Flevy here.

Flevy Marketplace: Top 100
· Strategy & Transformation
· Digital Transformation
· Operational Excellence
· Organization & Change
· Financial Models
· Consulting Frameworks
· PowerPoint Templates
FlevyPro (Subscription Service)
KPI Library
Streams (Functional Bundles)
Flevy Executive Learning (FEL)
PowerPoint Services

FREE Resources

About Flevy
Management Topics
Marcus (AI-Powered Consultant)
Partner Program
LinkedIn Influencer Marketing
FAQ / Terms / Privacy / Blog
Contact Us: support@flevy.com

Acquisition Strategy
Artificial Intelligence
Balanced Scorecard
Best Practices
Big Data
Breakout Strategy
Business Continuity Planning
Business Plan Financial Model
Business Transformation
Change Management
Communications Strategy
Company Financial Model
Competitive Advantage
Competitive Analysis
Consulting Frameworks
Continuous Improvement
Core Competencies
Corporate Culture
Cost Reduction Assessment
Customer Experience

Strategy, Transformation, & Innovation
Digital Transformation
Operational Excellence and LSS
Organization, Change, & HR
Management Consulting

Customer Journey
Customer Service
Cyber Security
Data Privacy
Decision Making
Digital Marketing Strategy
Digital Transformation
Digital Transformation Strategy
Due Diligence
Employee Engagement
Employee Training
Enterprise Architecture
Growth Strategy
HR Strategy
Hoshin Kanri
ISO 27001
Information Technology
Innovation Management
Integrated Financial Model
Key Performance Indicators

Business Strategy Frameworks
Case Studies
Consulting Training Guides
COVID-19 Trend Data
Digital Transformation
Financial Advising Services (FAS)

Knowledge Management
Lean Manufacturing
M&A (Mergers & Acquisitions)
Market Research
Marketing Plan Development
Maturity Model
McKinsey PowerPoint
McKinsey Templates
Operational Excellence
Organizational Change
Organizational Design
Performance Management
Post-merger Integration
Pricing Strategy
Process Improvement
Process Maps
Procurement Strategy
Product Launch Strategy
Product Strategy
Project Management
Quality Management

Free Resources
KPI Library
Lean Management
Lean Six Sigma Training Guides
Marcus Insights
Operational Excellence

Real Estate
Remote Work
Risk Management
Robotic Process Automation
Service Design
Six Sigma Project
Social Media Strategy
Strategic Planning
Strategic Thinking
Strategy Development
Supply Chain Analysis
Target Operating Model
Team Management
Total Productive Maintenance
Value Chain Analysis
Value Creation
Value Stream Mapping
Visual Workplace
Workplace Safety

Product Strategy
Small Business Owner
Startup Resources
Strategic Planning
Strategic Planning Process
Value Innovation Strategy

© 2012-2024 Copyright. Flevy LLC. All Rights Reserved.