Executive Program in Inventory Management - With Excel tools
Inventory management and Planning - safety stock, Reorder Point, EOQ, ABC, XYZ analysis, MPS & MRP Planning, KPI's
4.58 (300 reviews)
3 458
students
4.5 hours
content
May 2025
last update
$69.99
regular price
What you will 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 Gallery
Loading charts...
5450252
udemy ID
18/07/2023
course created date
08/09/2023
course indexed date
Bot
course submited by