Mastering Inventory Management In Supply Chain World

Unlocking Efficiency through Strategic Inventory Control with READY EXCEL templates for inventory Analysis !

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

Requirements

English Language

Software used to read PDF documents (Like Adobe)

Microsoft Excel Basic awareness

Learning & attentive mindset

Description

Background of the courseThis 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· Introductiono What is inventoryo Types and of inventory· Activities involved in Inventory Management function· Understanding Inventory Costs: A Comprehensive Overviewo Ordering Costo Carrying or holding costo Shortage or stock out costo Spoilage costo Other costso Tabular examples of the costs· Need for effective inventory management today - From Burden to Opportunityo Contribution of Inventory in working capitalo Research studies about inventory contribution in company’s working capital.o Inventory contribution in retail, manufacturing and service companies.o Role of inventory holding costo Research studies on contribution of holding cost in inventory costs.· Benefits of well managed inventory - From Chaos to Controlo Cost optimization & Cash flow managemento Customer Satisfactiono Improved supply chain efficiency.o Profit maximizationModule 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 Inventoryo What is VMIo How it is different from traditional inventory replenishmento Process flow in VMI & traditional inventory replenishmento Benefits of VMIo 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 & Exampleo 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 & OTIFModule 5 - Bonus Module: Supply Chain Planning processes that deals with Inventory Control· Master Production Schedule (MPS)o What is MPS , Its interlink with Demand Plano Example how to run MPSo Inputs & Outputs of MPSo Bill of Material & Example.· Materials Requirement Planning (MRP)o What is MRP , Its interlink with MPSo Objectives of MRPo Inputs & Outputs of MRPo Example & Calculation of MRP with examples· MPS Vs MRPo Dependent demand Vs Independent demando Difference between MPS & MRP.

Overview

Section 1: Introduction to Inventory Management

Lecture 1 Inventory meaning, types and what is Inventory Management in a business context

Lecture 2 Activities involved in Inventory Management function

Lecture 3 Understanding Inventory Costs: A Comprehensive Overview

Lecture 4 Need for effective inventory management today - From Burden to Opportunity

Lecture 5 Benefits of well managed inventory - From Chaos to Control

Section 2: Selective Inventory control methods & Analysis in Excel

Lecture 6 All about Selective Inventory Control, Its need & Benefit to the business

Lecture 7 9 Selective Inventory Control Techniques widely used - Quick Overview.

Lecture 8 ABC Analysis - Meaning, Logic, Examples and Uses

Lecture 9 ABC Analysis in MS Excel - Ready excel template for ABC analysis in a minute.

Lecture 10 XYZ Analysis - Meaning, Logic, Examples and Uses

Lecture 11 XYZ Analysis in MS Excel - Ready excel template for XYZ analysis in a minute.

Lecture 12 ABC - XYZ Combination Analysis in Excel, Ready excel sheet for ABCXYZ Analysis

Lecture 13 FSN Analysis - Meaning, Logic, Examples and Uses

Lecture 14 HML Analysis - Meaning, Logic, Examples and Uses

Lecture 15 VED Analysis - Meaning, Logic, Examples and Uses

Lecture 16 SDE Analysis - Meaning, Logic, Examples and Uses

Lecture 17 GOLF Analysis - Meaning, Logic, Examples and Uses

Lecture 18 S-OS Analysis - Meaning, Logic, Examples and Uses

Lecture 19 PQR Analysis - Meaning, Logic, Examples and Uses

Lecture 20 HML, PQR Analysis in Excel & Brief on other analysis techniques

Section 3: Inventory Replenishment planning methods

Lecture 21 Inventory replenishment Methods

Lecture 22 Safety Stock - What is it, Why it is needed?

Lecture 23 Calculation of Safety Stock,Reorder Point,Economic Order Qty & Min max in excel

Lecture 24 Planning strategies in Business environments - MTO, MTS, ATO & ETO

Lecture 25 Vendor Managed Inventory (VMI), Benefits & top companies using VMI

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

Section 4: Inventory Management Key Performance Indicators- Meaning & Calculation in Excel

Lecture 27 Introduction to Key Performance Indicators & its impact for Inventory function

Lecture 28 KPI 1 - Average Inventory - Formula and example

Lecture 29 KPI 2 - Cost of Goods Sold (COGS) - Formula & Example

Lecture 30 KPI 3 - Inventory Turnover Ratio (ITR) - Formula & example

Lecture 31 KPI 4 - Days On Hand (DOH) - Formula & Example

Lecture 32 KPI 5 - Gross Margin Return on Inventory Investment (GMROI) - Formula & example

Lecture 33 KPI 6 - Inventory Accuracy - Formula & example

Lecture 34 KPI 7 - Excess & Obsolete Inventory (E&O) - Formula & examples

Lecture 35 KPI 8 - On Time Delivery (OTD) & On time in Full (OTIF) - Formula & examples

Lecture 36 KPI 9 - Days of Supply - Formula & examples

Lecture 37 Excel Calculation for Average Inventory, ITR, DOH, DOS, GMROII

Lecture 38 Excel Calculation for Excess & Obsolete Inventory

Lecture 39 Excel Calculation for OTD & OTIF

Section 5: Supply Chain Planning processes that deals with Inventory Control

Lecture 40 Master Production Schedule (MPS)

Lecture 41 Materials Requirement Planning (MRP)

Lecture 42 MPS Vs MRP

Section 6: Quiz

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.