Displays

Bar Graphic

The OTIF-A is displayed as a bar/line combination chart that’s shows by period (Period can be month, quarter or year):

• The bar size represents the number of order lines considered.
• The color of the bar shows what is OTIF (light blue) and what is not-OTIF (dark blue)
• A line shows the % of OTIF (number of OTIF order items/total number of order items)
• Target is shown as a straight dotted line.

Overall Indicator

On the top right corner there is an overall indicator.

This indicator shows the total indicator for the selected period:

• The % of OTIF in the full period
• The number of OTIF-A order lines in the full period
• The number of order lines considered in the full period.

Difference with the graphic is that this display shows the indicators for the total period, not month by month.

By default the period is the last 6 months, but the number of months considered can be changed by moving the selection bar:

Detail table

The OTIF detail is shown as a pivot table with the period (Month, Quarter or year) in column as well as several indicators:

• Number of orders (otif or not).
• % of orders which are OTIF

The row analysis can be changed between several axes by using the Cyclic selection.

Time dimension

The time dimension (month, quarter, and year) is based on the Order First ATP Good issue Date as below (in the sales order).

In the sales order (VA03) item view:

Other dimensions

The following dimensions are available to filter. Not all are available in the cyclic (to display):

Calculation Rules

Exclusions

Not all orders are taken into account for the OTIF:

• Excludes Intercompany deliveries.
• Excludes the below order types:

In practice this means including only TA (Standard Orders) and ZOR (Immediate Delivery)

• Excludes order lines for samples and commodities materials (see list on the main documentation page).
• Excludes deleted order lines.

Main rule

The OTIF is displayed as a % of Order Items that are OTIF. The calculation is done for each order

In Full

Order items will be in full if the confirmed quantity is equal (more or less tolerances) to the delivered quantity. Both conditions have to be met:

• [Dispatched Quantity] <=  [Quantity Confirmed] +  [Quantity Confirmed] * [Overdelivered Tolerence %]
• [Dispatched Quantity] =>   [Quantity Confirmed] -  [Quantity Confirmed] * [Underdelivered Tolerence %]

On time

Orders items are considered on time if the order first ATP goods issue date is equal to (more or less tolerances) the actual goods issue date. On time if:

Order [First ATP good issue date - DD/MM/YY] =   [Despatch actual good issue DD/MM/YY]

If an order is delivered in several deliveries, we take the LAST one.

The First ATP goods issue date can be seen in either the Sales Order view (VA03):

The Actual Despatch Goods Issue date (=Shipment Completion Date) can be seen in the delivery:

OTIF

Order item is On Time In Full if it’s both On Time and In Full.

Tolerance

The On Time and In Full calculations take into account some tolerances:

• Tolerance in Quantities: Consistent with the tolerances in the sales order or RCS Customer card, reflecting Customer requirements.

• Tolerance in Days:
  Road: +/- 1 day
  Air Freight: +/- 3 days
  Sea: +/- 7 days
  Rail: +/- 7 days
  Other : No tolerance

Exceptions

Some cases are considered as exceptions:

• Sales orders with the below * on OTIF Codes are always considered OTIF*:

• For all customer PICK UP orders if Transfer Confirmation Date <= Last requested date by customer, then OTIF (Even if without GI Date). Otherwise, not OTIF.

Customer pick up corresponds to all orders with the following incoterms:

• EXW – Ex-Works

• FCA – Free Carrier
• COL – Collect

Target

Target for the OTIC-A can be shown or hidden using the “Show Target” flag.

Target is defined by the Dashboard Owner via an excel file.

Getting the detail

Details for this indicator can be seen by using the following BO Query:

• Folder: “2 – PPS/PPE Enterprise reports” – “Rare Earth – A210”.
• Report: “OTIF_C_REPORT_RESWWPPS_XXX” (XXX being the version number).