Versions Compared

Old Version 7

changes.mady.by.user Miriam Luttrin

Saved on

compared with

New Version Current

changes.mady.by.user Breteau-laurent, Laure

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.






Image Removed

Info
titleSupply Chain Excellence
Jose-Pablo Leyva
Info
titleD&PS Expert
Miriam Luttrin

General Description

These KPIs allow you to evaluate the performance of hauliers at two specific moments:
  • At delivery at the customer place. Please read the Warning hereunder for the
calcultion
  • calculation. This KPI is measure only for some orders.
  • At shipment from the plant, all orders are concerned because the data is in the system.
For the two KPI, you can track the performance by Forwarding agent.
KPIs:
  • Hauliers On Time Delivery (%)
  • Number of Shipments (with available Actual Delivery Date)
  • Hauliers On Time Shipment (%)
  • Total Number of Shipments
Calculations:
  • Hauliers On Time Delivery (%) = This indicator compares the Actual Arrival date to the Planned Arrival Date.
  • Hauliers On Time Shipment (%) = This indicator compares the Actual Shipment Completion date to the Planned one defined in the shipment file.
Granularity:
Forwarding Agent
Currently there is no value of data quality (= % shipments with a real arrival date) for HOTD in the dashboard but it can be found in TIERS. In the core query, we can find this value of data quality under the name of Number of shipments relevant for transit time calculation.


Warning
titlePerimeter
In the dashboard, we use the same HOTD definition as Z1T_HAULIER which considers that if there is no real arrival date then the shipment is not included in the calculation. We only consider the orders that have a real delivery date (= the haulier enters in the system the achieved delivery date).
Info
iconfalse
titleTarget Users
  • Supply Chain Managers
    • Supply Chain Operational
  • Supply Chain Excellence
  • Logistics
  • Customer Service
  • Account Managers
    • Info
    iconfalse
    titleAuthorization & 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.





    Technical Documentation
    Source:
    TIERS - QVSCE_BW_QRY_MVSDTR01_0012
    Update:
    Daily
    Query filters applied:

    Image Modified

    Dimensions:
    Global Overview of Dimensions


    HOTD & HOTS

    Global Filters
    Period
    Month Year
    Ship Actual for Ship [C_SHIPNU2__C_COMPMON]
    Organization
    GBU
    BFC GBU [C_SUBACT2__CPFCTR1_2]
    Group of Activity
    [C_SUBACT2__CPFCTR2_2] BFC Group of activities
    Sub-Activity
    Sub-activity [C_MATPNT2__0G_CWWE01] Attribute/ BFC Activity 1 [C_MAGNUTU]
    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
    Ship Dest Geo Zone [C_PNTDS3__C_ZONE]
    Country
    Ship Dest Country [C_PNTDS3__0COUNTRY]
    Corporate Group
    Delivery [MVSDTR017 / Del Ship to Party [C_SHIPTID] / Corporate Group [C_CORPGR]
    Ship Destination
    Ship Destination Point [C_PNTDS3]
    Product
    Product Hierarchy
    Material Hierarchy [C_MATNR2__0PROD_HIER]
    Product
    Commercial Product [C_MATNR2__C_PROD]
    Bulk/Packed
    Transportation Group [C_MATNR2__C_BULKPAC]
    Transport Mode
    Ship Transportation [C_SHIPNU2__C_TR_MODE]
    Specific Filters

    Packaging Type
    [C_MATNR2] Material\Attributes\[C_PACKAG]
    Forward Agent
    Forward Agent [C_FWDAGID]
    Partner Type
    PARTNER [MVSDTR014] \ [C_PNTY3PY] 3rd Party Type