Executive Program in Inventory Management (With MS Excel)

Inventory management & Inventory Control to optimize supply chain & warehouse management - Top on Cherry for CPIM study.

Created by: Sitmi Academy
Management Consulting and Expertise

What Will I 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

Target audience

• 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.