Implementation Packs / Supply Chain

SC-23 · Supply Chain

Co-Packing OTIF

Monthly ↑ Higher is better Control Lagging

OTIF performance for co-manufacturing partners

See what's inside
Built from a real Implementation Pack — every number on this card is extracted, not illustrative.
Co-Packing OTIF Implementation Pack

Everything required to build the KPI

Production-ready
Power BI fileWorking implementation
Fact-and-dimension modelFacts, dimensions & relationships
DAX measuresKPI logic & supporting calculations
Sample data + targetsStructured & ready to explore
50+DAX measures
7Dim. tables
9Report pages
60,000Demo rows

What it measures

OTIF performance for co-manufacturing partners

Lagging indicator

OTIF measures service failures after the delivery attempt; the consequence (retailer penalty, lost sale) is already locked in before the score is calculated.

Business impact

  • Increased 'chaos tax' from firefighting: premium freight to cover shortages, customer service overtime managing complaints, and planning team hours spent re-allocating scarce stock.
  • Unreliable co-packer performance forces higher safety stock levels across the network, bloating the inventory position, tying up cash, and increasing the risk of write-offs due to shelf-life pressure.
  • Sustained underperformance from a key co-packer triggers a formal retailer service improvement plan — the structured final warning before range removal and delisting.

Formula

(Conforming co-man delivery lines / Total delivery lines) x 100

Grain

One row per outbound delivery line — plant × product × customer × date

Supply Chain

Inside the Implementation Pack

A preview of what's actually built for this KPI — extracted from the real Implementation Pack, not a mockup.

50+DAX measures
7dimension tables
9report pages
60,000row demo dataset
The real DAX measure SC-23 DAX measure from the Implementation Pack

This is the primary ratio the pack's other measures build on — trend, rank, and period-comparison variants, all on Fact_Outbound_Delivery_Line. It guards against missing dates and values with NOT ISBLANK checks.

Data you need
  • Fact_Outbound_Delivery_Line — 10 mandatory columns — actual arrival date key, qty ordered, ...
  • Dim_Batch — batch_key + batch_nbr
  • Dim_Carrier — key + name
  • Dim_Customer — key + name
  • Dim_Plant — key + name
  • Dim_Product — key + name
  • Dim_Route — key + name
  • Dim_Date — Auto-generated calendar table — no customer data required

Full field-by-field data contract, in 4 SQL dialects (SQL Server, Snowflake, Databricks, BigQuery), ships in the pack.

Editable thresholds
Target0.97 — performance considered compliant at or above this line
Warning0.92 — amber alert — triggers a review

Both live in one Excel tab — change them, refresh the report, done. No DAX editing needed.

Supply Chain $149

Everything you need to build Co-Packing OTIF in Power BI — dimensional model, DAX measures, SQL views, and a food-industry demo dataset.

Reviewed by the FoodBevKPIs team · Benchmarks last verified September 1, 2026 · Spotted something out of date?

Request access

SC-23 — Co-Packing OTIF · $149 for the full Implementation Pack. Only email is required — everything else helps us prioritize, and costs you nothing to skip.