Joëlle Hilaire


Diogo Paiva


EMEA: Emma Glasson
NAM/LAM: Karina Tsuji
APAC: Lilian Cheong



General Description

This indicator explores the time taken to confirm in the system an order to the customer from the order creation and the confirmation date given by the Back Office & Planners (Plant). The targeted KPI is 48 hrs.
KPI:
Order Confirmation Time
Scope:
    • Exclusion of material types services and packaging (i.e. units in KWH): PF1/Z703  WP1/ZDIE WP1/ZVER WP1/ZUNB
    • Exclusion of SOLD entities (consolidation method = SOLD)
    • Filter on Sales Order Types, same as OTIF scope


KPI Name
Calculation
<= 2 Days
Time to take the order confirmation is <= 2 daysIf Variation Days Confirmed <=2; Nb SO Confirmed; if Variation Days Confirmed > 2; 0
3 to 9 Days
Time to take the order confirmation is between 3 and 9 daysIf 3 <= Variation Days Confirmed <= 9; Nb SO Confirmed; if Variation Days Confirmed< 3 or Variation Days Confirmed >9;0
>= 10 days
Time to take the order confirmation is >= 10 daysIf Variation Days Confirmed >=10; Nb SO Confirmed; if Variation Days Confirmed < 10; 0

_____________

Process of order promissing:

Promising Split: Each order line is categorized in 6 possible Confirmation Status. We are supposed to confirm and order line within 2 business days. In this case, we are good, otherwise, we failed.
Good < 2 days
Order line was confirmed  =< 2 business days
Failed 3-9 days
Order line confirmation date is  between 3 and 9 business days
Failed 10-30 days
Order line confirmation date is  between 10 and 30 business days
Failed > 30 days
Order line confirmation date is more than 30 business days
Failed with allocation
  • For WP1: if order line has failed to be confirmed within 2 business days and has ever had ZPEN flag on order line level (supply issue)
  • For PF1: there is no common process, therefore this category is not defined for PF1 GBUs



KPI NameCalculation
Order Promising ratio
# of GOOD confirmed <= 2 business day
——————————————————————
# total orders lines
Confirmed within 2 business days
Order Promising Cycle Time
Number of business days between Order line creation date and the first ATP confirmation date
  • In case of credit block the KPI measures: Number of business days between the first credit release  and the 1st ATP confirmation date
  • If the order hasn’t been confirmed yet we calculate number of business days with today’s date
  • [A COMPLETER le cas de confirmation date des order line supprimés et recréees]
Failed Orders
Total of orders with a Failed Confirmation Status
# of Confirmations
Count how many times the order has been confirmed in the change log (after quantity or requested date change) 
If order line was confirmed immediately and no confirmation in the change log, then count as 1 confirmation and use order line creation date in cycle time.
Stability
Stable Y = 1 confirmation  
Stable N = more than 1 confirmation
No GI date = if the order has no GI date, it is considered not possible to calculate the KPI.



  • Supply Chain Managers
  • Supply Chain Operational
  • Supply Chain Excellence
  • Logistics
  • Customer Service
  • 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.



Technical Documentation
Source:
(CORE - BW_QRY_MVSDCH01_0002 )
CORE -  BW_QRY_CPSDCH01_0001
QV - QVBW_QRY_MVSDCH01_0002
Update: Daily
Query filters applied:
Source Information:
Filters
BWQVBW_QRY_MVSDSO57_0001
Exclusion of material types: Services & Packaging (i.e. units in KWH): PF1/Z703  WP1/ZDIE WP1/ZVER WP1/ZUNB
Exclusion of SOLD entities (consolidation method = SOLD)
Dimensions:
Global Overview of Dimensions



Order Confirmation Time
Global Filters
Period
Month Year
Order line Creation Month
Organization
GBU
[CPFCTR1_2] BFC GBU
Group of Activity
C_SUBACT2__CPFCTR2_2 - BFC Group of activities
Sub-Activity
C_SUBACT2__C_MAGNITU - BFC Activity 1
Company
[C_COMPCDE] Company_code
Plant
Zone
[C_PLANT] Plant\Attributes\[C_GZONE] Geographie/Zone
Country
[C_PLANT] Plant\Attributes\[0COUNTRY] Country key
Plant
[C_PLANT] Plant
Ship Destination
Zone
[C_SHIPTID] Ship-to party\Attributes\[C_GZONE] Geographie/Zone
Country
[C_SHIPTID] Ship-to party\Attributes\[0COUNTRY] Country key
Corporate Group
[C_SHIPTID] Ship-to party\Attributes\[C_CORPGR] CRM Customer Corp. Group (PRS)
Ship Destination
[C_SHIPTID] Ship-to
Product
Product Hierarchy
[C_MATNR2] Material\Attributes\[0PROD_HIER] Product Hierarchy
Product
[C_MATNR2] Material\Attributes\[C_PROD] Coimmercial Product / Material Group
Bulk/Packed
[C_MATNR2] Material\Attributes\[C_BULKPAC] Transportation Group
Packaging Type
[C_MATNR2] Material\Attributes\[C_PACKAG] Packaging type
Transport Mode
[C_SHIPCD2__C_TR_MODE] Transportation mode
Specific Filters

Sales Office
[C_SAL_OFF] Sales Office
CSR
[C_CUSTSAL__C_ZIPART] CSR (Sold-to)
Sales Office

Ship Destination Zone

Ship Destination

Product