OTIF

General Description

OTIF-Customer (Delivered) : (On Time In Full)

This KPI measures our capacity to deliver our customers at destination at the right time, with the right quantity. It evaluates Customer satisfaction.

The result of this KPI can be both related to internal and external factors.

OTIF-Departure Plant: (On Time Shipment In Full)

This KPI measures our capacity to make the products available at departure location at the right time, with the right quantity. It evaluates our ability to meet and deliver according to customer requirements. The result of this KPI is only related to internal reasons (eg: product not available)

Exception: if the carrier is 2 days late, the actual Good Issue Date will also be delayed even if the product is available.

KPI:

OTIF Customer - Requested , 1^st Confirmed & Last Confirmed

Granularity:

Order Lines

Classification:

OTIF / NOT ON TIME /NOT IN FULL / NOT ON TIME & NOT IN FULL
NOT ON TIME by 4 classes of delay

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.

Perimeter:

Included in calculation

Excluded from calculation

Outbound deliveries to Customers. This includes :

- Deliveries to final customer

- Customer Pick-up

- Deliveries to warehouses / storages as long as

the inventory belongs to the customer

Inter-GBU flows
Swap
Intra-GBU flows

- Advanced Storage

Samples
Return flows
Toll
Pipe delive

Formula

OTIF Customer - Requested: we compare the Delivery date and the the Requested GI date ^(b) + we compare the requested quantity and the delivered quantity

OTIF Customer - 1st Confirmed: we compare the Delivery date and the 1st confirmed GI date ^(b) + we compare the confirmed quantity and the delivered quantity

OTIF Customer - Last Confirmed: we compare the Delivery date and the Last confirmed GI date ^(b) + we compare the confirmed quantity and the delivered quantity

___________________________________________________________________________________________________

OTIF Departure Plant - Requested: we compare the Achieved shipment date ^(a) and the Requested GI date ^(b) + we compare the requested quantity and the delivered quantity

OTIF Departure Plant - 1st Confirmed: we compare the Achieved shipment date ^(a) and the 1st confirmed GI date ^(b) + we compare the confirmed quantity and the delivered quantity

OTIF Departure Plant - Last confirmed: we compare the Achieved shipment date ^(a) and the Last confirmed GI date ^(b) + we compare the confirmed quantity and the delivered quantity

^(a) Achieved shipment date:

For “PICK UP” transportation mode : Last transfer order confirmation date for the order line if it is a date and Last Good Issue date for the order line if there is no transfer order (should normally never be in RCS).

For other transportation mode: The last “Actual Good Issue” date

^(b) Requested/1^st Confirmed/Last Confirmed Good Issue date:

For OTS-IF Last requested, First Confirmed and Last Confirmed, the customer’s request doesn’t exist.

Requested GI date = Requested Delivery date ^(c) – standard transit time of the route
First Confirmed GI date = 1^st Confirmed Delivery date ^(c) – standard transit time of the route
Last Confirmed GI date = Last Confirmed Delivery date ^(c) – standard transit time of the route

^(c) Achieved delivery date:

For “PICK UP” transportation mode : Last transfer order confirmation date for the order line if it is a date and Last Good Issue date for the order line if there is no transfer order (should normally never be in RCS).

For other transportation mode: The last “Actual Shipment end” if it exists, else the last “Planned shipment end” (automatically filled in at planning step of shipment, using planned shipment completion + transit time from the SAP ROUTE or updated manually at shipment completion) if it exists and else the last “Actual Good Issue” date (normally should not happen).

Tolerances:

For In Full tolerances, if there is a tolerance defined in the order then we consider it else it's +/- 0%.

On Time - Criteria	Tolerance SCE
Road	+/- 1 days
Rail	+/- 3 days
Sea	+/- 7 days
Barge	+/- 3 days
Multimodal	+/- 2 days
Air	+/- 0 days

Reprocessing root causes:

reason codes OTIF and Pick-up date non-respected by customer – when used it forces the order line status to On Time.

Technical Documentation

Source:

Global Sales - QVSCE_BW_QRY_MVSDSO51_0001

Update:

Daily

Dimensions:

Global Overview of Dimensions

			OTIF Customer & OTIF Departure
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

Page tree

Jose-Pablo Leyva

Miriam Luttrin

KPI:

Granularity:

Classification:

Supply Chain Managers

Supply Chain Operational