Supply Chain Forecast Accurately To Sell More Daily

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

Last updated 2022-01-10 | 4.2

- 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.

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.

* 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.

Course content

3 sections • 38 lectures

Introduction Preview 01:58

Building Unconstrained Demand Preview 06:29

Demand versus Forecast Preview 01:02

Regression Analysis Preview 01:40

Regression Analysis Exercise Preview 06:51

Exponential Smoothing Preview 01:28

Exponential Smoothing Exercise Preview 06:02

What is Sales Forecast? Preview 01:15

Forecasting Techniques- QUALITATIVE & QUANTITATIVE Preview 05:02

Forecasting Approaches-TOP-DOWN & BOTTOM-DOWN Preview 01:48

Balanced Forecast Preview 03:45

Strike the Balance-Example Preview 04:21

Integrating Supply & Demand Components Preview 03:44

Rolling Forecast Preview 03:59

Rolling Forecast & C/D Ratio Exercise Preview 08:02

Rolling Forecast & C/D Ratio- Seasonal Exercise Preview 06:08

Time Fence Policy Preview 02:56

Time Fence Policy Exercise Preview 06:11

Sales Forecast Variance Exercise Preview 05:02

Sales Forecast Accuracy Exercise Preview 11:17

Mape Denominator Exercise Preview 07:04

Forecast Accuracy Significance Preview 02:44

Forecast Improvement Process Preview 08:29

Missed Sales Forecast Preview 00:13

Excel Files Preview 00: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