Forecast Accuracy (SC)

General Description
The KPI Forecast Accuracy (FA) evaluates the ability to get a visibility on customer's demand. As an input of S&OP process, reliable forecasts constitute the major way to improve the customer satisfaction via an optimized planning of operations. The forecast Accuracy in this dashboard is calculated based on the Final Forecast and Gross History (Actual Sales). For a particular month, the Forecast Accuracy is calculated over the last 5 months forecast (M-1 ... M-5); allowing the possibility to evaluate the accuracy of the forecast at several periods ahead. Calculations:
Aggregated: Forecast Accuracy at an aggregated level =
Weighted: Forecast Accuracy taking into account the volumes delivered at the level Ship-to x DC (if any) x Material level =
Bias: Average deviation of forecast from actuals. = ABS \| FF - GH \|

Target Users

Global Supply Chain Managers
Regional Supply Chain
Local Supply Chain
Supply Chain Analyst
S&OP Manager
Purchasing Manager / Buyers
Supply Chain Excellence
Account Managers

Authorization & Rights

All the accesses must be validated by:

Supply Chain Excellence

Click here for the Access form to get access to the Global Supply Chain Dashboard.

Naming convention by Source System (Dynasys vs APO)

Dynasys	APO (WP1)	APO (PF1)
GH / Gross History	Demand History	History
FF / Final Forecast	PreSOIP Plan	Consensus Forecast

Forecast Accuracy : how does it work ?

The forecast Accuracy is calculated at 2 levels, based on Gross History (GH) from last month :

at detailed level : material, Distribution Channel, Ship-to and weighted
at aggregated level : at the level required by the user (dynamic calculation at displayed level)
Snapshots : every 6th of each month, a snapshot is taken for each month in the future up to 5 months. This will allow to calculate FA for periods M-1, M-2, M-3, M-4, and M-5.

Exemple : For June, the FA M is the picture taken the 6th of July for the month of June (to capture the changes made on June). M-1 will the the picture taken the 6th of June for June (to capture the changes made on May). M-2 the picture taken the 6th of May for June (to capture the changes made on April).

Technical Documentation

Source:

DYNASYS / APO (WP1) / APO (PF1) - QV_BW_QRY_MVDYN11_0005

Update:

Daily

Technical BW Documentation

BW - DP - Forecast Accuracy (Core Query)

Dimensions:

Global Overview of Dimensions

			Forecast Accuracy
Global Filters	Period	Month Year	Calendar Year/Month [0CALMONTH]
	Organization	GBU	BFC GBU [CPFCTR1_2]
		Group of Activity	BFC Group of activ [C_DYN_010__CPFCTR2_2]
		Sub-Activity	BFC Activity 1 [0G_CWWE01_C_MAGNITU]
		Company	[C_DYN_018__C_COMPCDE] Company code
	Plant	Zone	Geographie/Zone [C_DYN_018__C_MPPLANT__C_GZONE]
		Country	Country [C_DYN_018__C_MPPLANT__C_0COUNTRY]
		Plant	Main Shipping Plant [C_DYN_018__C_MPPLANT]
	Ship Destination	Zone	BFC Geographie/Zone [C_SHIPTID__C_ZONE]
		Country	Country [C_SHIPTID__C_0COUNTRY]
		Corporate Group	Corporate group [C_SHIPTID__C_CORPGR]
		Ship Destination	Ship-to [C_SHIPTID]
	Product	Product Hierarchy	Prod.hierarchy [C_MATNR2__0PROD_HIER]
		Product	Com Prod / Mat Grp [C_MATNR2__C_PROD]
		Bulk/Packed	N/A
		Transport Mode	N/A
Specific Filters		Material Group	Material Group [C_MATNR2__C_MAT_GRP]
		Material	Material [C_MATNR2]
		Distribution Channel	Distribution Channel [0DISTR_CHAN]
		Product Family	[C_MATNR2] Material\Attributes\[C_FMPRD] Product Family Code
		Product Group (PGMI)	Product Group (PGMI) [C_DYN_005__C_GRPPGMI]
		Product Line 00	[C_MATNR2] Material\Attributes\[C_LPROD] Product line 00

Page tree

Pilar Gamboa

Miriam Luttrin

Calculations:

Global Supply Chain Managers

Regional Supply Chain

Local Supply Chain

Supply Chain Analyst

S&OP Manager

Purchasing Manager / Buyers