Jose-Pablo Leyva


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


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




  • 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:

TIERS - QVSCE_BW_QRY_MVSDTR01_0012

Update:

Daily

Query filters applied:

Dimensions:

Global Overview of Dimensions



HOTD & HOTS

Global Filters
















PeriodMonth YearShip 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
PlantZone[C_PLANT] Plant\Attributes\[C_GZONE] Geographie/Zone
Country[C_PLANT] Plant\Attributes\[0COUNTRY] Country key
Plant[C_PLANT] Plant
Ship DestinationZoneShip Dest Geo Zone [C_PNTDS3__C_ZONE]
CountryShip Dest Country [C_PNTDS3__0COUNTRY]
Corporate GroupDelivery [MVSDTR017 / Del Ship to Party [C_SHIPTID] / Corporate Group [C_CORPGR]
Ship DestinationShip Destination Point [C_PNTDS3]
ProductProduct HierarchyMaterial Hierarchy [C_MATNR2__0PROD_HIER]
ProductCommercial Product [C_MATNR2__C_PROD]
Bulk/PackedTransportation 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