Supply Chain Control Tower

Program

Commodity

Site

Supplier

Start Need-by

End Need-by

Records: —

OTIF %

—

On-time AND in-full

Past Due $

—

Open qty × unit price (need-by < today)

Expedite Spend

—

Freight cost where expedite_flag = true

Avg Commit Slip

—

Delivery date − promise date

Reschedule Rate

—

% lines with reschedule_count > 0

Quality Hold Rate

—

% lines with quality_hold_flag = true

Weekly OTIF + Past Due + Expedite

PO Line	Program	Phase	Supplier	Commodity	Tier	Site	Need-by	Delivery	Past Due $	Reschedules	Expedite	Q Hold	Delay Code

Data source: data/processed/fact_supply_chain_flat.csv (replace with your real export anytime — keep headers).