Optimizing supply chain strategically through Microsoft Excel based inventory management & planning.
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
Why take this course?
在您提供的课程大纲中，我可以帮助您理解每个模块的主要内容和目标。以下是对每个模块的详细说明：
Module 1 – Inventory Management Fundamentals
这个模块介绍了库存管理的基本概念，包括库存的类型（如直接与间接物料）、库存管理的重要性、以及好的库存管理如何帮助企业从混乱中恢复控制。它还讨论了成本优化、现金流管理、提高客户满意度、提升供应链效率以及利润最大化等方面的好处。
Module 2 – Selective Inventory control methods & Analysis in Excel
在这个模块中，您将了解选择性库存控制的概念，包括为什么它是必要的以及它带来的益处。此外，您将学习不同的库存分析方法（如ABC分析、XYZ分析等），并使用Excel进行计算和自动化处理这些分析。
‘;
}});
Module 3 – Inventory Replenishment planning methods
这个模块介绍了四种库存补充方法：安全库存（Safety Stock）、最小生产量（Economic Order Quantity，EOQ）、最小平均库存水平（Min-Max）和可变订单量（MOQ）。它还讨论了企业环境中的计划策略（如MTO、MTS、ATO和ETO）以及供应商管理的库存（VMI），包括其工作流程、差异和优势。
Module 4 – Inventory Performance Management through Metrics
在这个模块中，您将学习如何使用关键绩效指标（KPIs）来评估库存表现，包括平均库存、成本货币销售额（COGS）、库存周转率（ITR）、天数库存（DOH）、库存准确性等。您将使用Excel进行计算并获得预先制作的模板，以简化这些计算。
Module 5 – Bonus Module: Supply Chain Planning processes that deals with Inventory Control
最后一个奖励模块介绍了掌控生产计划（Master Production Schedule，MPS）和材料需求规划（Materials Requirement Planning，MRP）的过程，这些过程在库存控制中起着关键作用。您将学习MPS与需求计划之间的关系、如何运行MPS以及MRP的目标和输出。此外，您将了解MPS与MRP之间的区别，包括依赖性需求与独立要求的差异。
总结：这个课程旨在库存管理的全面理解和实施，涉到库存控制的基础知识、分析方法、计划策略以及关键绩效指标（KPIs）。它还包括了一套供应链（Supply Chain）的规划工具，这些都是现代企业在全球化背景下管理库存和生产计划的必经之。通过学习这些模块，您将能够更有效率地处理和优化库存和供应链的运作。
