Supply Chain: Demand Planning (Sales Forecasting and S&OP)

Name: Supply Chain: Demand Planning (Sales Forecasting and S&OP)
Rating: 4.4 (8280 reviews)

S&OP: Generate Unconstrained Demand & Measure Sales Forecast Accuracy

Bestseller

Created byYasin Bin Abdul Quader

Last updated 11/2018

English

What you'll learn

Reflect reality of market demand and then drive a balanced sales forecast.
Measure forecast accuracy & apply forecasting improvement steps.
Generate rolling forecast for wider horizons for business growth & capacity planning.
Apply time fence policy of forecasting to draw the line between supply & demand teams.

Course content

3 sections • 25 lectures • 1h 47m total length

Introduction1:58
Building Unconstrained Demand6:29
Collaborate across finance, marketing, R&D, and supply chain to build unconstrained demand using diverse forecasting methods, evaluating cannibalization, new initiatives, and marketing activities to drive accurate, feasible sales projections.
Demand versus Forecast1:02

Regression Analysis1:40
Regression Analysis Exercise6:51
Exponential Smoothing1:28
Exponential smoothing uses historical data to reveal long-term seasonality by smoothing fluctuations and weighting relevant data, producing forecasts with F_{t+1}=αD_t+(1−α)F_t, ideal for seasonal data.
Exponential Smoothing Exercise6:02
What is Sales Forecast?1:15
A sales forecast projects the expected bookings at the end of a measurement period, typically weekly to quarterly, using qualitative and quantitative techniques, including top-down or bottom-up approaches.
Forecasting Techniques- QUALITATIVE & QUANTITATIVE5:02
Forecasting Approaches-TOP-DOWN & BOTTOM-DOWN1:48
Compare top-down and bottom-up forecasting: macro-driven board decisions versus micro, territory-based sales data, considering population growth, customer preferences, and supply capabilities to build SKU-level forecasts.
Balanced Forecast3:45
Strike the Balance-Example4:21

Integrating Supply & Demand Components3:44
Integrate supply and demand planning by aligning intersection points, shared building blocks, and overlap areas. Improve unconstrained demand handling, forecast accuracy, and inventory control through cross-functional collaboration.
Rolling Forecast3:59
Adopt a rolling forecast to replace static budgets, maintaining a constant horizon of five quarters or 15 months through add drop updates, enabling driver-based, project-based planning for timely decisions.
Rolling Forecast & C/D Ratio Exercise8:02
Rolling Forecast & C/D Ratio- Seasonal Exercise6:08
Time Fence Policy2:56
Time Fence Policy Exercise6:11
Sales Forecast Variance Exercise5:02
Sales Forecast Accuracy Exercise11:17
Mape Denominator Exercise7:04
Forecast Accuracy Significance2:44
Improve forecast accuracy for sales forecasts by enabling an enterprise wide data flow, reducing inventory and carrying costs, and strengthening cash flow and revenue through better demand planning.
Forecast Improvement Process8:29
Missed Sales Forecast0:13
Excel Files0:02
Regression Analysis
Sales Forecast Accuracy
Demand Variability
Seasonality Effect
Demand Forecasting
Quantitative Forecasting
Forecasting Technique
Seasonality Effect
Exponential Smoothing
Exponential Smoothing
Building Forecast
Promotion Impact
Demand Variability

Requirements

Basic knowldge of excel formulas

Description

This is a unique training course in its likelihood of implementation. Firstly, the course will teach you how to make mirror reflection of market demand by applying effective solution of developing sales forecast.

There will be horizontal techniques & vertical approaches which are constraining the forecasts figures to be at equilibrium phase.

Fundamental components to integrate demand with supply will be demonstrated as well in order to have high level of effective sales & operation planning (S&OP). These are; rolling forecast, time fence policy, forecast variances, etc.

Forecasting accuracy methodologies will be explained as well, to drive assurance of having high level accurate sales forecasting figures and to operate at optimum cost of operation.

The course is explaining each concept by an exercise and this is what differentiating this course and making it unique one.

Each exercise is in a plug-and-play format, using Microsoft Excel to present information from a conceptual point of view. From this, it should be easy to compare the information presented to your current ERP system.

Who this course is for:

Anyone from beginners & intermediate students who loves to learn step by step Demand(Sales Forecasting) Planning.

Supply Chain: Demand Planning (Sales Forecasting and S&OP)

What you'll learn

Explore related topics

Course content

Demand Management3 lectures • 9min

Sales Forecasting9 lectures • 32min

Integrating Supply & Demand Planning13 lectures • 1hr 6min

Requirements

Description

Who this course is for: