- Definition
- Orders received on time and in full ÷ orders delivered.
- Formula
DIVIDE ( [OTIF orders], [Orders delivered] )- Grain
- One order, not one line: by line it gave 96.0%.
- Filters
- The 3 warehouses · no transport costs.
- Owner
- Operations manager · every Monday · target 94%.
- Source and freshness
fct_despachosin BigQuery · daily load.
Document
So nobody has to ask me.
What comes in
OTIF 92.4%
A bare number on the dashboard.
- On time according to whom?
- By line or by order?
- Who owns it?
What goes out
OTIF %Metric card
- On timethe customer gets it, in full
- Grainone order, not one line
- Owneroperations manager
What isn’t written down gets asked. Or AI makes it up.
Five things. Not everything.
The OTIF card, field by field.
- 1DefinitionOrders received on time and in full ÷ orders delivered.
- 2Formula
DIVIDE ( [OTIF orders], [Orders delivered] ) - 3GrainOne order, not one line: by line it gave 96.0%.
- 4OwnerOperations manager · checked every Monday.
- 5Source and freshness
fct_despachosin BigQuery · daily load.
I don’t document
The obvious: “a warehouse is a warehouse”.
What changes every week.
I do documentWhat someone would ask.
Next to the data, not in a separate document.
Written once, it travels.
columns:
- name: otif
description:
Order received on time and in full.persist_docs
otif · BOOL description: Order received on time and in full.
///
/// Order received on time and in full.
measure 'OTIF %' =
DIVIDE ( … )A separate document, OTIF_definition_final.docx: nobody opens it, and it goes stale.
AI drafts. I check it against the source.
Without a description
What’s OTIF?
94.1%It used Logistics’ definition.
With the description
What’s OTIF?
92.4%Same as the dashboard.
- 1AI drafts
- 2I check the data note
- 3I test three questions
- ↺
The full card, with its history.
- wk 40Customer definition wins: 92.4%, not 94.1%.Operations manager
- wk 41Grain: order, not line.Diego
- wk 42Card published in dbt, BigQuery and Power BI.Diego
Done when nobody has to ask me.
What’s OTIF?
→OTIF %on time, in full ÷ delivered
Someone new answers what OTIF is, alone.
Dashboard92.4%
=AI92.4%
AI gives the same answer as the dashboard.
wk 40manager
wk 41Diego
wk 42Diego
Every change has a date and an owner.





