You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

Supply Chain Excellence

Jose-Pablo Leyva

D&PS Expert

Miriam Luttrin


General Description

These KPIs allow you to evaluate 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 (%)

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.


Perimeter

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

Target Users

  • Supply Chain Managers
  • Supply Chain Operational
  • Supply Chain Excellence
  • Logistics
  • Customer Service
  • Account Managers

Authorization & 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:

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

Not able to find the solution? Contact SBS Support.

Page viewed times
#trackbackRdf ($trackbackUtils.getContentIdentifier($page) $page.title $trackbackUtils.getPingUrl($page))
  • No labels