This comprehensive course provides a practical, hands-on guide to inventory management and supply chain optimization using real-world examples in Excel. Learners will explore key techniques such as ABC and XYZ analysis, economic order quantity (EOQ), safety stock calculation, and inventory turnover ratio formulas, helping organizations track, analyze, and manage inventory efficiently.
The course also covers advanced topics such as lead time optimization, forecasting sales for new products, slow-moving & obsolete inventory (SLOB) management, and inventory target planning, giving you the tools to plan, budget, and maintain optimal stock levels.
With step-by-step Excel tutorials for 500+ products and real-world case studies, learners gain actionable skills for inventory accuracy, cost reduction, and operational efficiency. Additional guidance is provided on inventory valuation methods, stocktake accuracy, and inventory reduction strategies, enabling both students and professionals to enhance their supply chain knowledge and achieve measurable business impact.
By the end of this course, learners will confidently analyze, optimize, and forecast inventory, ensuring improved service levels, reduced waste, and stronger supply chain performance.
