Supply chain planning is an important activity in any supply chain. This is where organizations get an idea of the upcoming demand, realize if they have the capacity to meet the demand, and determine how to realize these demands. In this course, we will explore how to use data science to conduct demand and supply planning, how to constrain the forecast, and how to measure the results. As we walk through this process, we will also explore how to use Excel to quantify each step.
Overview
Syllabus
- Demand Planning
- Welcome to Module 1, Demand Planning. In this module, we will explore demand planning, how to identify influencing factors, how to differentiate between the three simple statistical forecast types, and how to compute a few forecast values.
- Supply Planning
- Welcome to Module 2, Supply Planning. In this module, we will discuss the basics of supply planning, how to confirm internal & external capacity, how to confirm material availability, and the importance of communication and data sharing to supply planning.
- Constrained Forecast
- Welcome to Module 3, Constrained Forecast. In this module, we will discuss constrained forecasts and consensus meetings. Specifically, we will cover the purpose and creation of constrained forecasts and how consensus meetings are utilized to reach organizational goals.
- Measure Results
- Welcome to Module 4, Measure Results. In this module, we will discuss measuring results through collecting actual performance results and calculating forecast errors. Specifically, we will discuss the purpose of measuring results, the types of metrics used when measuring results, and common error measurements and their advantages and disadvantages.
Taught by
Paul Jan
