Executive Program in Inventory Management (With MS Excel)
Inventory management & Inventory Control to optimize supply chain & warehouse management - Best for CPIM Preparation.
4.55 (275 reviews)
2,975
students
4 hours
content
Dec 2024
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
Screenshots
5450252
udemy ID
7/18/2023
course created date
9/8/2023
course indexed date
Bot
course submited by