Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Supply Chain & Inventory Optimization Models with MS Excel

Name: Supply Chain & Inventory Optimization Models with MS Excel
Rating: 4.4 (575 reviews)

Supply Chain and Inventory Optimization with Excel Tools| EOQ • Safety Stock • ABC/XYZ • VMI • MPS/MRP • KPI Dashboards

Created bySitmi Academy

Last updated 1/2026

English

English [Auto],Chinese (Simplified) [Auto],

What you'll learn

Deep understanding of the Inventory management function..
Activities involved in Inventory Management function
Understanding Inventory Costs: A Comprehensive Overview
Need of best inventory management today - From Burden to Opportunity : Unleashing the Hidden Value of Inventory Management
Benefits of well managed inventory - From Chaos to Control Unleashing the Potential of well managed inventory
What is meaning of Selective Inventory Control Methods
9 Selective Inventory Control Methods - Categorization logic & uses (ABC, XYZ, FSN, HML, SDE, VED, S-OS, GOLF, PQR)
Overview & Excel Calculation for ABC, XYZ, HML, FSN, S-OS, VED, SDE, PQR, GOLF Analysis.
Categorizing Selective Inventory Control Methods in Microsoft Excel - Ready sheets for analysis in minutes.
Inventory Replenishment planning methods
Four Inventory replenishment Methods
What is Safety Stock, Why it is needed?
Calculation of Safety Stock in Excel & Ready excel sheet for quick calculation
Calculation of Reorder Point (ROP) in Excel & Ready excel sheet for quick calculation
Calculation of Economic Order Quantity (EOQ) in Excel & Ready excel sheet for quick calculation
Calculation of Min Max levels in Excel & Ready excel sheet for quick calculation
Planning strategies in Business environments – All about MTO, MTS ATO & ETO.
Vendor Managed Inventory, VMI Vs traditional methods, Process Flow, Benefits of VMI, Top Companies using VMI
VMI Case study of big retail giant Wal-Mart (Unlocking Efficiency & Profits)
Inventory Performance Management through Metrics
Overview of Average inventory – Meaning, Calculation & Example
Overview of Cost of Goods Sold (COGS) – Meaning, Calculation & Example, Exclusion & Inclusions in COGS costs.
Overview of Inventory turnover ratio (ITR)– Meaning, Calculation & Example
Overview of Days on Hand (DOH)– Meaning, Calculation & Example
Overview of Inventory Accuracy – Meaning, Calculation & Example
Overview of Gross Margin return on inventory investment (GMROII)– Meaning, Calculation & Example.
Overview of Days of Sales (DOS)– Meaning, Calculation & Example.
Overview of Excess & Obsolete Inventory (E&O) - Meaning, Calculation & Example.
Overview of on time delivery (OTD) - Meaning, Calculation & Example.
Overview of on time in full (OTIF) - Meaning, Calculation & Example.
Excel calculation & ready template for calculation of average inventory, ITR, DOH, DOS, GMROII, E&O, OTD & OTIF
Bonus Module: Supply Chain Planning processes that deals with Inventory Control
Master Production Schedule (MPS), Interlink with demand plan , Inputs & Outputs to MPS, BOM
Materials Requirement Planning (MRP), Interlink with MPS, Inputs & Outputs of MRP, Example & Calculation of MRP with examples
MPS Vs MRP

Course content

6 sections • 45 lectures • 4h 18m total length

What Is Inventory? Types & Importance in Business6:02
Core Inventory Management Activities Explained4:31
Inventory Cost Overview & Breakdown5:39
Turning Inventory from a Burden into a Strategic Asset6:22
Top Benefits of Effective Inventory Control6:55

Selective Inventory Control: What It Is & Why It Matters6:37
Prioritize high-impact products with selective inventory control to optimize resources, improve cash flow, and reduce carrying costs through targeted demand forecasting and streamlined replenishment.
Top 9 Inventory Classification Techniques Overview4:33
Covers eight selective inventory control techniques, including ABC analysis, X-Y-Z analysis, FSN, high/medium/low value, vital, essential, and desirable, scarce, difficult and easy, Golf analysis, and seasonality of products.
Mastering ABC Analysis: Purpose, Examples & Use Cases8:43
ABC Analysis in MS Excel - Ready excel template for ABC analysis in a minute.12:20
Download this Excel file for automated calculation of selective inventory control methods. Save time, ensure accuracy, and analyze data for informed decision-making.
XYZ Analysis: Meaning, Logic & Applications6:23
XYZ Analysis in MS Excel - Ready excel template for XYZ analysis in a minute.7:52
Unlock XYZ analysis with an Excel template, grouping items into X, Y, and Z by demand patterns using coefficient of variance, guiding safety stock decisions.
ABC - XYZ Combination Analysis in Excel, Ready excel sheet for ABCXYZ Analysis8:35
FSN Analysis: Fast‑Slow‑Non‑Moving Inventory Strategy5:27
Explore fsn analysis, classifying items into fast moving, slow moving, and non-moving by consumption rates, and apply it to inventory optimization, working capital, demand forecasting, and obsolescence management.
HML Analysis for High‑Medium‑Low Value Inventory2:38
Apply HML analysis to classify items by unit value into high, medium, and low categories, guiding inventory optimization, demand forecasting, and obsolescence management through promotions to reduce overstock.
VED Analysis: Vital, Essential & Desirable Inventory Control Method5:36
Classify inventory with ved analysis to prioritize vital, essential, and desirable items and guide purchasing policies and stocking requirements.
SDE Analysis - Meaning, Logic, Examples and Uses3:09
GOLF Analysis - Meaning, Logic, Examples and Uses3:17
S-OS Analysis - Meaning, Logic, Examples and Uses1:28
Analyze seasonal and off-season inventory through s-os analysis, recognizing umbrellas and raincoats as seasonal and nuts, bolts, and steel as off-season, then stock accordingly for peak demand.
PQR Analysis - Meaning, Logic, Examples and Uses1:42
Excel Guide: HML, PQR, and Other Inventory Techniques6:53
Learn HML and PCA analyses in Excel to classify inventory by price and shelf life, integrate with ABC, XYZ, and FSN methods, and improve inventory optimization and demand forecasting.

Inventory Replenishment Methods Explained6:47
Explore four inventory replenishment methods—periodic ordering, reorder point, demand-based replenishment, and top-up—and learn to balance stock levels, minimize costs, and meet customer demand.
Safety Stock - What is it, Why it is needed?5:58
Safety stock acts as a buffer against demand variation and supply disruptions. Calculate it from standard deviation of monthly demand, monthly lead time, and the z-factor service level.
Calculation of Safety Stock,Reorder Point,Economic Order Qty & Min max in excel18:39
Download this Excel file for automated calculation of Safety stock, Reorder Point (ROP), EOQ & Min max levels.
Save time, ensure accuracy, and analyze data for informed decision-making.
Planning strategies in Business environments - MTO, MTS, ATO & ETO9:09
Explore four planning strategies—make-to-stock, assemble-to-order, make-to-order, and engineer-to-order. Discover how each approach impacts inventory, delivery lead times, and customization.
Vendor Managed Inventory (VMI), Benefits & top companies using VMI8:55
Explore vendor managed inventory (VMI) as an alternative to traditional replenishment, highlighting benefits like improved inventory accuracy, reduced stockouts, and collaboration with Walmart, Procter & Gamble, Coca-Cola, and Dell.
Important Short Notes on Vendor Managed Inventory - VMI1:14
VMI Case study of big retail giant Wal-Mart (Unlocking Efficiency & Profits)4:28
Walmart leverages vendor managed inventory with RFID and CPFR to enable real-time data flow to suppliers, cutting replenishment lead time from 21 days to under 11 days.
Podcast on VMI Concept - Must listen for better understanding.10:10

Introduction to Key Performance Indicators & its impact for Inventory function2:00
KPI 1 - Average Inventory - Formula and example2:03
Calculate average inventory, a KPI used in metrics like turnover and days on hand. Use the formula (beginning inventory plus end inventory) divided by two, applied to a chosen period.
KPI 2 - Cost of Goods Sold (COGS) - Formula & Example5:48
Understand cost of goods sold (COGS), its three components—direct material cost, direct labour cost, and manufacturing overheads—and the formula beginning inventory plus purchases minus ending inventory.
KPI 3 - Inventory Turnover Ratio (ITR) - Formula & example2:02
Define the inventory turnover ratio as cost of goods sold divided by average inventory. Illustrate COGS 54,000 and average inventory 13,000 to yield 4.15, showing higher turnover signals better performance.
KPI 4 - Days On Hand (DOH) - Formula & Example3:02
KPI 5 - Gross Margin Return on Inventory Investment (GMROI) - Formula & example4:52
Learn how gmroi measures gross margin return on inventory investment by dividing gross margin by average inventory. Use product examples A001–A005 to spot performance differences and guide inventory decisions.
KPI 6 - Inventory Accuracy - Formula & example4:22
Explore inventory accuracy via cycle counting, using the formula one minus (physical minus system) divided by physical, times 100. See how planning benefits from higher accuracy and ABC-based tolerance.
KPI 7 - Excess & Obsolete Inventory (E&O) - Formula & examples4:49
KPI 8 - On Time Delivery (OTD) & On time in Full (OTIF) - Formula & examples3:45
KPI 9 - Days of Supply - Formula & examples1:28
Calculate days of supply by dividing on hand inventory by average daily usage to show how many days demand is covered, a key KPI.
Excel Calculation for Average Inventory, ITR, DOH, DOS, GMROII12:03
Excel Calculation for Excess & Obsolete Inventory5:10
Learn how to calculate excess and obsolete inventory in Excel using on hand stock, past sales, and future demand, identify excess and obsolete quantities, and compute inventory value.
Excel Calculation for OTD & OTIF5:19
Compute on-time delivery at the quantity level and on-time in full at the line level in Excel, using due dates and delivered versus ordered quantities, via the three-by-three formula.

Master Production Schedule (MPS)6:30
Materials Requirement Planning (MRP)3:59
Materials requirement planning uses a master production schedule and bill of materials, incorporates design changes and inventory records with ordering policies to generate purchase and manufacturing plans and exception reports.
MPS Vs MRP2:13
Distinguish MPS from MRP by linking independent demand for finished goods to MPS and dependent demand for raw materials to MRP; MPS is weekly, MRP daily.
Manufacturing Environment - MTO, MTS, ETO, ATO9:09
Explore four manufacturing planning strategies, make to stock, assemble to order, make to order, and engineer to order. See how stock, subassemblies, and design choices affect delivery lead times.

Requirements

English Language
Software used to read PDF documents (Like Adobe)
Microsoft Excel Basic awareness
Learning & attentive mindset

Description

Unlock Your Supply Chain Potential with this Course focused on Supply chain planning with Excel based practice models and ready to use templates.

Inefficient inventory management can lead to a domino effect, negatively impacting people, processes, and systems within the organization. Any mismanaged inventory disrupts the entire business ecosystem... Are your supply chain professional keeping you up at night?

Unleash the power of strategic inventory management and revolutionize your business operations today!

| Master the Art of Inventory Optimization | Boost Efficiency & Reduce Costs | Seamlessly Integrate Supply Chain Tactics | Elevate Your Career with In-Demand Skills

We realized that Efficient inventory optimization, demand planning, and stock replenishment are crucial for supply chain success, All this is well covered in this course with practical Excel templates, automations, and interactive KPI dashboards.

Join our exclusive Udemy course and gain the expertise to streamline your inventory processes, enhance customer satisfaction, and supercharge your business growth.
What You'll Learn:

- Inventory Planning

- Inventory Costs and Impact

- Selective Inventory control Techniques

- Inventory Replenishment methods

- Inventory KPI’s

- Entire Inventory analysis in Excel with readymade templates

Enroll Now and Enjoy:

- On-Demand Video Lessons - Learn at Your Pace

- Interactive Quizzes - Reinforce Your Knowledge

- Lifetime Access - Stay Updated Always

- Expert Q&A - Get Your Questions Answered

- Certificate of Completion - Showcase Your Skills

Whom this course is designed for?

Inventory Managers

Supply Chain Managers
Operations Managers
Warehouse Managers
Procurement Specialists
Business Analysts / Supply Chain Analysts
MBA Students
Executives in manufacturing, retail, or distribution industries

Invest in your future. Transform your supply chain. Enroll in "Strategic Inventory Management" now!

Background of the course

This course will help you drastically improve your knowledge and skills in Inventory Management practices through a series of must know concepts, practical cases, case studies, calculations, examples and Ready Excel Templates for numerous inventory analysis in few minutes. This course is designed by Academic & Industry experts in the field for everyone who is in Supply Chain / Inventory / Demand planning role or wanted to make their career in the field. This course is designed for Supply Chain Managers, Inventory Managers, Supply Chain Analysts, Buyers, Demand Planners, Inventory planners, Transportation, warehousing & Logistics planners & even supply chain leaders.

What this course covers?

This course covers extensive content in a simple explanations and covers all must know topics within inventory management practices in five key modules as below.

Module 1 - Introduction to Inventory Management

· Introduction

o What is inventory

o Types and of inventory

· Activities involved in Inventory Management function

· Understanding Inventory Costs: A Comprehensive Overview

o Ordering Cost

o Carrying or holding cost

o Shortage or stock out cost

o Spoilage cost

o Other costs

o Tabular examples of the costs

· Need for effective inventory management today - From Burden to Opportunity

o Contribution of Inventory in working capital

o Research studies about inventory contribution in company’s working capital.

o Inventory contribution in retail, manufacturing and service companies.

o Role of inventory holding cost

o Research studies on contribution of holding cost in inventory costs.

· Benefits of well managed inventory - From Chaos to Control

o Cost optimization & Cash flow management

o Customer Satisfaction

o Improved supply chain efficiency.

o Profit maximization

Module 2 - Selective Inventory control methods & Analysis in Excel

· Overview of Selective inventory control

· Why Selective inventory control?

· What are benefits of selective inventory control?

· Overview of ABC Analysis - Meaning, Logics & Uses.

· Overview of XYZ Analysis - Meaning, Logics & Uses.

· Overview of HML Analysis - Meaning, Logics & Uses.

· Overview of FSN Analysis - Meaning, Logics & Uses.

· Overview of VED Analysis - Meaning, Logics & Uses.

· Overview of SDE Analysis - Meaning, Logics & Uses.

· Overview of S-OS Analysis - Meaning, Logics & Uses.

· Overview of GOLF Analysis - Meaning, Logics & Uses.

· Overview of PQR Analysis - Meaning, Logics & Uses.

· Excel Calculation & Automated calculation sheet for ABC, XYZ, HML, FSN, PQR, ABC-XYZ analysis.

Module 3- Inventory Replenishment planning methods

· Four Inventory replenishment Methods

· What is Safety Stock, Why it is needed?

· Calculation of Safety Stock in Excel & Ready excel sheet for quick calculation

· Calculation of Reorder Point (ROP) in Excel & Ready excel sheet for quick calculation

· Calculation of Economic Order Quantity (EOQ) in Excel & Ready excel sheet for quick calculation

· Calculation of Min Max levels in Excel & Ready excel sheet for quick calculation

· Planning strategies in Business environments – All about MTO, MTS ATO & ETO.

· Vendor Managed Inventory

o What is VMI

o How it is different from traditional inventory replenishment

o Process flow in VMI & traditional inventory replenishment

o Benefits of VMI

o Top Companies who uses VMI in their businesses

· VMI Case study of big retail giant Wal-Mart (Unlocking Efficiency & Profits)

Module 4 - Inventory Performance Management through Metrics

· Overview of Average inventory – Meaning, Calculation & Example

· Overview of Cost of Goods Sold (COGS) – Meaning, Calculation & Example

o Exclusion & Inclusions in COGS costs.

· Overview of Inventory turnover ratio (ITR)– Meaning, Calculation & Example

· Overview of Days on Hand (DOH)– Meaning, Calculation & Example

· Overview of Inventory Accuracy – Meaning, Calculation & Example

· Overview of Gross Margin return on inventory investment (GMROII)– Meaning, Calculation & Example.

· Overview of Days of Sales (DOS)– Meaning, Calculation & Example.

· Overview of Excess & Obsolete Inventory (E&O) - Meaning, Calculation & Example.

· Overview of on time delivery (OTD) - Meaning, Calculation & Example.

· Overview of on time in full (OTIF) - Meaning, Calculation & Example.

· Excel calculation & ready template for calculation of average inventory, ITR, DOH, DOS, GMROII

· Excel calculation & ready template for E&O Inventory

· Excel calculation & ready template for OTD & OTIF

Module 5 - Bonus Module: Supply Chain Planning processes that deals with Inventory Control

· Master Production Schedule (MPS)

o What is MPS , Its interlink with Demand Plan

o Example how to run MPS

o Inputs & Outputs of MPS

o Bill of Material & Example.

· Materials Requirement Planning (MRP)

o What is MRP , Its interlink with MPS

o Objectives of MRP

o Inputs & Outputs of MRP

o Example & Calculation of MRP with examples

· MPS Vs MRP

o Dependent demand Vs Independent demand

o Difference between MPS & MRP.

What you will learn at end of the course?

Inventory Management System
safety stock & Stock Management
Warehouse Management
inventory optimization
Beginner’s to experts Guide for Inventory Control
Ultimate Inventory Optimization
Advanced Inventory Planning
Comprehensive Inventory Management
Inventory Planning & control through Microsoft Excel
How to Optimize inventory, reduce costs, and enhance profitability with expert planning and Excel skills.

Key Learnings:

Inventory Management
Inventory Control
Supply Chain Management
Warehouse Management
MS Excel
ABC Analysis
XYZ Analysis
Safety Stock
Reorder Point
Economic Order Quantity (EOQ)
Min-Max Inventory
Inventory Replenishment
Inventory Planning
Inventory Optimization
Inventory Costs
Inventory Analysis
KPIs (Key Performance Indicators)
Inventory Turnover
Days on Hand (DOH)
CPIM (Certified in Production and Inventory Management) Preparation.
Demand Forecasting
Vendor Managed Inventory (VMI)
Lean Inventory
Inventory Cost Reduction
Inventory Analysis in Excel

Summary:

- **Inventory Cost Analysis** (EOQ, Holding Cost, Stockouts)

- **Selective Control Techniques** (ABC, XYZ, FSN, HML, VMI)

- **Demand Replenishment & Forecasting** (Safety Stock, ROP, Min‑Max)

- **Supply Chain Planning Integration** (MPS, MRP, Production Strategies)

- **Performance Measurement** (KPIs: ITR, DOH, GMROI, OTIF)

- **Excel-based Templates & Case Studies**

Course connects dot between multiple area's of supply chain like

Demand Planning
Supply Chain Analytics
Inventory Forecasting
Lean Inventory
Replenishment Strategies

We are well acknowledged by CPIM Preparation participants for this course, As they could find “real-world case studies,” “hands-on Excel models,” and “downloadable templates.”

Enroll Now !!

Who this course is for:

Professionals - Like Buyers, Demand Planners, Logistics Planners, Inventory Planners, Supply Chain Managers, Supply Chain Analysts.
Professionals looking to make their career or switch their careen in Supply Chain field.

Supply Chain & Inventory Optimization Models with MS Excel

What you'll learn

Explore related topics

Course content

Inventory Management5 lectures • 29min

Selective Inventory Control Methods with Excel Templates15 lectures • 1hr 25min

Excel-Based Inventory Replenishment Techniques: EOQ, ROP, Min-Max8 lectures • 1hr 5min

Inventory KPIs & Metrics with(Plug & Play) Excel templates & ready made Formulas13 lectures • 57min

Supply Chain Planning: MPS, MRP, and Inventory Control Linkages4 lectures • 22min

Quiz !0

Requirements

Description

Who this course is for: