آموزش زنجیره تأمین - برنامه‌ریزی تقاضا، پیش‌بینی و S&OP با اکسل - آخرین آپدیت

سرفصل ها و درس ها

Supply Chain & Business Planning Fundamentals

• Introduction to Course - Learning Objectives

• Introduction to Business - Manufacturing & Service Operations for Supply Chain

• Demand vs Supply in Supply Chain Management – Concepts, Gaps, and Examples

• Demand, Sales, and Forecast Explained – Key Differences for Planners

• Determinants of Demand in Supply Chain and Demand Planning

• Long-Term, Mid-Term, and Short-Term Business Planning in Supply Chain

• Role of S&OP in Business Planning and Execution

Sales & Operations Planning (S&OP) – End-to-End Overview

• History and Evolution of Sales and Operations Planning (S&OP)

• 5 Steps of S&OP Explained with Real Business Flow

• Step 1- New Product Planning & Data Collection- With S&OP Meeting Live Scenario

• Step 2 - Demand Planning in S&OP - With S&OP Meeting Live Scenario

• Step 3 - Supply Planning - With S&OP Meeting Live Scenario

• Step 4 - Pre S&OP or Financial Reconciliation - With S&OP Meeting Live Scenario

• Step 5 - Executive S&OP Review - With S&OP Meeting Live Scenario

• Benefits of Sales and Operations Planning (S&OP)

• Characteristics of Matured S&OP Process

• Responsibilities of S&OP Steps (RASCI Matrix)

Forecasting & Demand Planning Fundamentals

• What is Forecasting in Supply Chain, Forecasting Vs Demand Planning

• Benefits of Forecasting and Demand Planning for Business Performance

• Benefits of Forecasting and Demand Planning - Real World Case Studies

• Constrained vs Unconstrained Demand Planning in S&OP

• Types of Forecasting Methods - Part 1 - Qualitative Forecasting Methods

• Types of Forecasting Methods - Part 2 - Quantitative Forecasting Methods

• Types of Forecasting Methods - Part 3 - Quantitative Forecasting Methods

• Key Characteristics of a Forecasting

• Forecast Horizon & Frozen Period in Short, Medium, and Long Term Forecasting

• Top-Down vs Bottom-Up Forecasting Approaches

Forecasting Methods With Real Examples

• Introduction to Forecasting Methods & Learning ObjectIves

• NAIVE Forecasting Method with Examples

• MOVING AVERAGE Forecasting Method with Examples

• WEIGHTED MOVING AVERAGE Forecasting Method with Examples

• EXPONENTIAL SMOOTHING Forecasting Method with Examples

Forecasting Methods Using MS Excel

• Introduction to Topic

• Forecasting Methods in Excel - Part 1

• Forecasting Methods in Excel - Part 2

• Forecasting Methods in Excel - Part 3

• Advanced Forecasting Methods within MS Excel

• FORECAST SHEET Function within MS EXCEL

• Forecasting with Seasonality Index Method

S&OP KPI"s in each Step

• S&OP KPI's in Step 1

• S&OP KPI's in Step 2

• S&OP KPI's in Step 3

• S&OP KPI's in Step 4

• S&OP KPI's in Step 5

• S&OP- Demand Planning KPI's calculation in EXCEL

Integrated Business Planning (IBP)

• Introduction to Integrated Business Planning (IBP)

• Sales & Operations Planning (S&OP) Vs Integrated Business Planning (IBP)

• Key Steps to Transform S&OP into IBP

• Best Practices in S&OP - For every Supply Chain Management Professional

• Role of AI & ML in S&OP & Top Industry tools

• Real world Case studies of AI & ML in S&OP within Industry

• Final Conclusion of S&OP Mastery Course - Congratulations for making this happen

Practice Test - QUIZ - S&OP

• Practice Test