June 26th - 27th 2025.Data Analysis and Demand Planning for SCM

[Data Analysis and Demand Planning for SCM]

Date: June 26th - 27th 2025

Location: Shanghai

 


  •  Program Background

Somebody says the truth of SCM is quantitative analysis, it is true, In addition to collaboration,  data processing and consequent decision-making is the most important part for SCM employees in their daily work, so data processing is the basic skills for them, no matter for the beginners or senior managers, customer management or supplier management, demand planning, production scheduling, inventory management, logistics network optimization. SCM professionals dealing a large amount of data processing. Only based on the accurate and right data, management measurement can be taken correctly and effectively, the decisions can be made correctly. Currently, for data processing and analysis, inevitably EXCEL must be used and exerted, good EXCEL skills can help us solve most of our daily business data processing and analysis, even more, highly improve our working efficiency, strong EXCEL skills can also help us to analyze the data from different perspectives, review the business in a deep and comprehensive view, get the hidden issues. The training includes demand management, forecasting with EXCEL model such as moving average, exponential smoothing method, forecast comparison, evaluate the risk for the forecast dynamical change, forecast accuracy assessment; actual shipment analysis, on time delivery calculation, on time fulfillment, actual customer synthetical lead time analysis versus standard lead time; all these analysis will help us find the weak areas we must improve. Master production scheduling evaluation table and capacity assessment, material and inventory analysis, and so on.

  • Program Agenda
Day 1 | Thursday (09:00 -17:30)08:30-09:00 Sign In

09:00-09:05 Opening

I. The Essential of Supply Chain Management

——The challenges of SCM and Demand Forecasting.

——Why Demand Management is important to SCM?

——The elements and patterns of Demand Management

——The importance of Demand Planner

II. Forecasting Technology

——Forecasting Preparation

——Data Cleansing

——Forecast Accuracy Assessment

——Data pattern of time series

——The classifications of Forecast

——Qualitative and Quantitative Forecasting

——Qualitative Forecasting

▪ Moving Averages

▪ Exponential Smoothing: Simple, Trend, Trend & Seasonal

▪ How to Calculate Seasonal Index

▪ Decomposition

▪ Linear Programming

—— Advanced Forecast Models: ARIMA &SARIM

—— Application for Forecasting Modeling

—— Application and Case study for Forecasting Technology

—— Apps – Minitab, SPSS

—— Forecasting for promotion

—— Forecasting for New Production Introduction

10:45-11:00 Coffee break

12:30-13:30 Lunch
15:15-15:30 Coffee break

Day 2 | Friday (09:00 -17:30)

III.The introduction of AI forecasting models

——LLM and AI Forecasting Models

——The differences for AI and Regular Models

——How the AI Forecasting Models work for the Organization?

Ⅳ. B2B Forecasting Method and Demand Sensing

——B2B Forecasting Method

——Demand Sensing

——What to do when Forecasting Models don’t works?

Ⅴ. S&OP and Demand Plan

——S&OP process and key factors

——DP role in S&OP process

——The input and output of each step in S&OP process

▪ New Product Forecast and Demand Plan

▪ Demand Forecasting for Demand Plan in S&OP

▪ Supply Plan Evaluation

——The key elements to success for S&OP process

Ⅵ. Material Analysis

——MRP and Procurement Strategy

——ABC-XYZ analysis

——Safety Stock Strategy and Models

——The development of EOQs models and some useful models

——Practice and Exercise: EXCEL skills for ABC-XYZ analysis and Safety Strategy

10:45-11:00 Coffee break

12:30-13:30 Lunch
15:15-15:30 Coffee break
16:00 -16:30 Q&A
  • Trainer Info
Mr. Frank XIAO(肖余庆)
SCM Expert Consultant / Senior Trainer
FICOSA China:China Supply Chain Director
C.D. Walzholz New Material: Senior supply Chain Manager
Sauer-Danfoss:Supply Chain Manager, S&OP Manager
He has 20+ years supply chain management and consulting experience, including end-to-end supply chain system and processes building and consulting, KPI measurements designing, proficient in demand planning, S&OP, Master Planning, procurement strategy, MRP, the full supply chain planning function system. Specialize in inventory management, data analysis and quantitative modeling, planning tools applicated with ERP system.  Help diagnose MRP practice problems and provide optimizing solutions.
  •  Who Should Attend
All the employees who work related to sales, marketing, customer service, supply chain, planning, sourcing, production etc.

议睿专业培训

〖供应链数据量化分析与需求计划〗

时间:2025年6月26日-27日

地点:上海星级酒店

  • 课程背景
当今社会发展迅速,技术日益更新换代,而且技术步伐也日益加快,应用到各行各业中,社会的快速变革发展使供应链面临越来越多的困难,越来越大的挑战,最明显的例子是订单周期日益缩短,需求越来越难以预测,不可预测的因素增多,产品生命周期越来越短,而产品的长尾效应更加明显等等。面对这样的挑战,企业必须要有更好的应对对策,需要让相关的需求计划人员很好的掌握预测技术这项专业技能,提高预测准确率,以指导后端的供应链运营,如主生产计划、生产和采购的准确性,在精准预测的基础上大大提高供应链的运营效率。在加强需求管理的基础上实行科学的库存补货策略,加强库存控制,降低库存的同时,有效管控风险,从而提高供应链的整体运营管理水平,使企业在竞争中处于不败之地。

本课程主要分享从分析需求管理与需求计划流程入手,介绍预测技术,及预测准确率分析、评估方法和标准,等。旨在帮助相关供应链专业人员的提高预测和需求管理的业务水平。还包括安全分析和课堂练习,以让学员充分掌握预测的相关知识和技能。

  • 课程纲要
第一天 | 6月26日 09:00-17:30(周四)

I. 供应链管理基础:需求管理

——新形势下企业面临的供应链挑战与需求预测的难点

——供应链为什么要管理需求及需求管理的重要性

——需求管理的要素与模式

——需求计划职能的重要性

II. 预测技术

——预测的准备

——数据清洗

——如何评估预测准确率

——认识预测的数据形态及评判

——预测的分类

——定性预测与定量预测

——定量预测模型

▪ 移动平均

▪ 指数平滑:简单,趋势,季节与趋势

▪ 季节指数的算法

▪ 经典分解法

▪ 线性回归

——ARIMA及SARIMA模型:高级复杂预测应

——预测技术与模型的实际应用及操作演练

——预测技术应用案例分析

——预测技术工具应用

——促销预测管理

——新品预测管理

第二天 | 6月27日09:00-17:30(周五)

III. AI预测模型介绍(通过AI学习获得的深度学习结果)

——AI预测模型简介以及应用场景

——AI预测模型与常规的预测模型的不同点

——企业能否使用AI预测模型

Ⅳ. B2B预测方法与需求感知(通过AI学习获得的深度学习结果)

——B2B行业的预测方法:

——针对需求不稳定,定制化需求的2B行业预测或者需求感知技术应用

——客户订单或者预测无法使用模型该如何破局?

Ⅴ. 产销协同与需求计划

——产销协同流程及关键要素

——产销协同预测会议的职责划

——产销协同各个环节的重要输入与输出

a. 产品计划与新品导入

b. 需求计划的编制与录

c. 供应计划的评估

——产销协同成功的关键要素

Ⅵ. 物料计划分析评估

——物料需求计划与采购策略

——物料结构分析ABC-XYZ法

——安全库存策略与模型

——EOQ模型的历史发展变革与一些可用模型(通过AI学习获得的深度学习结果)

——课程练习:利用EXCEL进行ABC-XYZ分析,及统计安全库存计算和分析

  • 讲师介绍
Mr. Frank XIAO(肖余庆)
供应链管理专家顾问/高级讲师
前法可赛(中国)供应链总监
前威尔斯新材料供应链经理
前萨澳-丹佛斯(上海)供应链经理
20多年供应链管理与运营经验,对端到端的供应链体系的设计与构架、流程制定和KPI考核设计、产销协同,EPR/MRP供应链计划体系流程方案设计规划,企业MRP痛点问题诊断、解决方案设计及提升优化,有丰富的实践和咨询经验。
拥有工程机械、快消,消费电子,汽车制造、原材料加工、物流运输等多个行业的实践经验,参与及管理过多个大型客户的管理咨询项目,如康师傅、美的、如新、拓邦电子等等。
  • 培训对象
建议由销售,市场,客服,供应链,计划,采购,生产等相关职能参与
  • 费用
价格: RMB 7,800 / 人
包含:教材、午餐、茶歇等
  • 报名与咨询/Contact Info
上海议睿会展服务有限公司
Shanghai MFG Event Co., Ltd
Tel: 021-62153526
E-mail: info@mfgevent.com.cn
Website: www.mfgevent.com
WeChat Official Account: mfgevent
  • 企业信息 / Company Info

MFGEvent为上海议睿会展服务有限公司旗下面向中国制造业供应链高级经理人的知名专业服务品牌,议睿拥有一支了解制造型企业不同行业特点的专家团队,专注并致力于向客户提供专业化的供应链解决方案,议睿运用良好的网络资源优势、专家背景优势和强大的社会资源优势,帮助企业解决生产运营难题,是业内公认的制造业资源服务平台。