View Source

General Description

These indicators allows to evaluates the performance of hauliers.

xxxx - Jose Pablo Leyva

KPIs:

Hauliers On Time Delivery (%)

Number of Shipments (with available actual delivery date)

Hauliers On Time Shipment (%)

Number of Total Shipments

Calculation:

Hauliers On Time Delivery (%) - This indicator compares the Actual Arrival date to the Planned date.

Hauliers On Time Shipment (%) - This indicator compares the Actual Shipment Completion date to the Planned date defined in the shipment file.

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

Granularity:

Forwarding Agent

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:

Global Sales - QVSCE_BW_QRY_MVSDSO51_0001

Update:

Daily

Order Types included:

Query filters applied:

Dimensions:

Global Overview of Dimensions

			Rush Orders
Global Filters	Period	Month Year	Actual GI dt (month) [C_ACT_GI]
	Organization	GBU	BFC GBU [CPFCTR1_2]
		Group of Activity	BFC BU [CPFCTR2_2]
		Sub-Activity	BFC Activity 1 [0G_CWWE01_C_MAGNITU]
		Company	[C_COMPCDE] Company_code
	Plant	Zone	Plant Zone [C_GZONE]
		Country	Plant Country [0COUNTRY]
		Plant	IF Source System = PF1: [C_MATNR2] Material\Attributes\[C_MATGR1] Industrial origin IF Source System = WP1: [C_MATPNT2__C_PRPLANT] Production Plant
	Ship Destination	Zone	Ship-to Geo Zone [C_SHIPTID__C_GZONE]
		Country	Ship-to Country [C_SHIPTID__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	Comm. Prd / Material [C_MATNR2__C_PROD]
		Bulk/Packed	Transportation Group [C_MATNR2__C_BULPAC]
		Transport Mode	Transportation mode [C_SHIPCD2__C_TR_MODE]
Specific Filters		Intra-GBU	Intra-GBU Flag [C_ITM_GS__C_INGBUF2]
		Sales/Replenishment	QV Mapping
		Order Doc. Type	Order Document Type
		Cause	Non OTIF Family [C_AUGRU__C_NOTIFGP]
		Non-OTIF Reason	Non OTIF Reason [C_AUGRU]

Jose-Pablo Leyva

Miriam Luttrin

KPIs:

Calculation:

Granularity:

Supply Chain Managers

Supply Chain Operational