SCE Dashboard - OTS-IF

OTS-IF (On Time Shipment In Full) 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.

			OTS-IF
			BI4 PPS QV_CORPORATE_OTIF_ANALYSIS_ SCE_CWWPPS_RO001	BW OBAS QVSCE_BW_QRY_MVSDSO10_0001
Global Filters	Period	Month Year	Delivery Actual Goods Issue Date	[C_ACT_GI] Actual GI date (Year/Month)
	Geography	Zone	Plant geographical zone	[C_PLANT] Plant\Attributes\[C_GZONE] Geographie/Zone
	Geography	Country	Plant country	[C_PLANT__0COUNTRY] Plant Country
	Organization	GBU	BFC GBU	[C_TECHBA__CPFCTR1_2] BFC GBU
		BU	BFC BU	[C_TECHBA__CPFCTR2_2] BFC Group of activities
		Legal Entity	Legal Company	[C_COMPCDE] Company code
		Plant	Plant & Transcoding table	[C_PLANT] Plant
Specific Filters	Transportation	Transport Mode	Transportation mode	[C_SHIPCD2__C_TR_MODE] Transportation mode
	Destination	Ship To Point	Ship to town & Ship to	[C_SHIPID__0CITY] ShipTo City & [C_SHIPID] ShipTo
		Ship To Country	Ship to country	[C_SHIPID__0COUNTRY] ShipTo Country
		Ship To Zone	Ship to Zone	[C_SHIPID__C_GZONE] ShipTo Zone
		Partner	Ship To KA
	Product	Material Division	Material Division (SA)	[C_MATNR2__0DIVISION] Material Division
		Commercial Product	Product	[C_MATNR2__C_MAT_GRP] Material group
		Product Hierarchy	Not available	[C_MATNR2__0PROD_HIER] Prod.hierarchy

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

- Incl. Advanced Storage

Samples
Return flows
Toll
Pipe deliveries

Reference date:

Actual Good Issue date

KPI:

OTS-IF Requested & OTS-IF 1^st Confirmed & OTS-IF 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

Formula:

3 OTS-IF

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

OTS-IF 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

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

Solvay performance	Reference	Comments
Respect of Customer requirements	Last Requested (by customer) Shipment Date & Quantity	OTS-IF ‘Requested’ (Gross OTS-IF)
Respect of our first commitments	1st Confirmed (by Solvay) Shipment Date & Quantity	OTS-IF ‘1st Confirmed’ (Net OTS-IF)
Respect of our last commitments	Last Confirmed (by Solvay) Shipment date & Quantity	OTS-IF ‘Last Confirmed’

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.

Page tree