Pilar Gamboa


Miriam Luttrin



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 (actuals).


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:

Standard: 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: = ABS | FF - GH |



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


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















PeriodMonth YearCalendar 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

PlantZoneGeographie/Zone [C_DYN_018__C_MPPLANT__C_GZONE]
CountryCountry [C_DYN_018__C_MPPLANT__C_0COUNTRY]
Plant

Main Shipping Plant [C_DYN_018__C_MPPLANT]


Ship DestinationZoneBFC Geographie/Zone [C_SHIPTID__C_ZONE]
CountryCountry [C_SHIPTID__C_0COUNTRY]
Corporate GroupCorporate group [C_SHIPTID__C_CORPGR]
Ship DestinationShip-to [C_SHIPTID]
ProductProduct HierarchyProd.hierarchy [C_MATNR2__0PROD_HIER]
ProductCom Prod / Mat Grp [C_MATNR2__C_PROD]
Bulk/PackedN/A
Transport ModeN/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