Calculator
D3
KPI Design for End-to-End Logistics Performance (OTD%, TAT, Stockpile Utilization %)
KPIs for logistics performance measure how reliably and efficiently materials move from the mine pit all the way to the export port — like tracking whether trucks arrive on time, how long stockpiles sit idle, and how fast railcars get loaded and shipped.
Industry Scale
Global iron ore export corridors handle 1.2–1.8 Bt/yr; typical KPI reporting granularity is 15-min intervals
Regulatory Context
Australian Rail Safety National Law (RSNL) mandates TAT tracking for heavy-haul networks; IMO Annex VI requires port interface timing for emissions reporting
Data Provenance Standard
ISO 55000-aligned asset data lineage required for KPI auditability in ASX-listed mining firms
Digital Twin Integration
Top-tier operators feed OTD%/TAT/SU% into Siemens Desigo CC or AVEVA Unified Operations Center for prescriptive control
⚠️ Why It Matters
1
Inaccurate OTD% definition
↓
2
Misattribution of delay responsibility (mine vs. rail vs. port)
↓
3
Suboptimal resource allocation (e.g., over-provisioned rail fleet)
↓
4
Chronic stockpile overflow or underutilization
↓
5
Penalty clauses triggered in export contracts
↓
6
Loss of charterer confidence and reduced freight rate leverage
📘 Definition
KPI Design for End-to-End Logistics Performance is the systematic engineering practice of defining, calibrating, validating, and operationalizing quantitative metrics—specifically On-Time Delivery % (OTD%), Turnaround Time (TAT), and Stockpile Utilization %—to monitor, diagnose, and optimize integrated material flow across mining, rail, port, and documentation systems. These KPIs must be traceable to physical constraints (e.g., stockpile capacity, rail slot windows, berth availability), statistically robust (with defined sampling frequency and data provenance), and aligned with contractual SLAs and throughput targets.
🎨 Concept Diagram
AI-generated illustration for visual understanding
💡 Engineering Insight
OTD% is not a standalone metric—it’s a symptom. Diagnosing its variance requires decomposing it into upstream TAT components and correlating with stockpile state transitions. A 5% OTD improvement achieved solely by adding railcars without reducing TAT increases CAPEX without improving system throughput; true optimization occurs only when KPIs are co-designed with physical infrastructure limits and process physics.
📖 Detailed Explanation
At its core, end-to-end logistics KPI design begins with treating the supply chain not as a series of siloed operations—but as one continuous material flow governed by conservation of mass and time. OTD%, TAT, and Stockpile Utilization % are interdependent: stockpile dynamics buffer variability between mining and rail, while rail TAT determines how frequently stockpiles can be replenished, which in turn affects OTD reliability at port handover.
Deeper analysis reveals these KPIs must be anchored to engineering realities—not just business goals. For example, TAT cannot be reduced below the sum of minimum physical cycle times: railcar uncoupling (2.5 min), empty inspection (3.0 min), loading (45–90 min depending on conveyor rate), coupling (2.0 min), and documentation clearance (5–15 min). Any KPI target violating this lower bound misrepresents system capability and invites operational gaming.
Advanced implementation requires probabilistic modeling: Stockpile Utilization % must account for grade segregation coefficients and moisture-induced compaction; OTD% must incorporate stochastic port slot availability modeled via Markov chains; and TAT must integrate equipment reliability (MTBF/MTTR) and human factor latency distributions. The most mature operators embed these KPIs within digital twin frameworks where each metric feeds closed-loop optimization—e.g., real-time TAT prediction adjusts next-hour pit dispatch volumes to maintain optimal stockpile grade bands.
Deeper analysis reveals these KPIs must be anchored to engineering realities—not just business goals. For example, TAT cannot be reduced below the sum of minimum physical cycle times: railcar uncoupling (2.5 min), empty inspection (3.0 min), loading (45–90 min depending on conveyor rate), coupling (2.0 min), and documentation clearance (5–15 min). Any KPI target violating this lower bound misrepresents system capability and invites operational gaming.
Advanced implementation requires probabilistic modeling: Stockpile Utilization % must account for grade segregation coefficients and moisture-induced compaction; OTD% must incorporate stochastic port slot availability modeled via Markov chains; and TAT must integrate equipment reliability (MTBF/MTTR) and human factor latency distributions. The most mature operators embed these KPIs within digital twin frameworks where each metric feeds closed-loop optimization—e.g., real-time TAT prediction adjusts next-hour pit dispatch volumes to maintain optimal stockpile grade bands.
🔄 Engineering Workflow
Step 1
Step 1: Map end-to-end material flow with time-stamped event logs (GPS, RFID, SCADA, ERP timestamps)
→
Step 2
Step 2: Identify critical path constraints (e.g., single-point rail loading bay, shared port berth, manual customs clearance)
→
Step 3
Step 3: Define KPIs with explicit start/end triggers, data sources, and exception handling rules (e.g., 'OTD% starts at pit dump gate timestamp, ends at port gate-in timestamp')
→
Step 4
Step 4: Calibrate baselines using 90-day representative operational history, excluding planned shutdowns and force majeure
→
Step 5
Step 5: Embed KPIs into control room dashboards with root-cause drill-down (e.g., 'OTD delay → drill into rail delay → identify yard shunting bottleneck')
→
Step 6
Step 6: Link KPI thresholds to automated response protocols (e.g., if Stockpile Utilization > 88% for >4 hrs → trigger priority reclaim sequence)
→
Step 7
Step 7: Quarterly KPI validation audit against physical inventory reconciliation and third-party logistics logs
📋 Decision Guide
| Rock/Field Condition | Recommended Design Action |
|---|---|
| OTD% < 75% with TAT > 10 hrs & Stockpile Utilization > 92% | Prioritize railcar TAT reduction via automated loading control + pre-clearance documentation; implement dynamic stockpile zoning to decouple blending from reclaim |
| OTD% > 88% but Port Slot Adherence < 78% and Stockpile Utilization < 55% | Re-optimize port slot allocation using stochastic berth simulation; consolidate low-grade stockpiles to free capacity and improve reclaim velocity |
| TAT stable at 6.2 hrs but OTD% volatile (σ > 22 min) and Stockpile Utilization oscillates 45–88% | Deploy real-time stockpile thermal/grade mapping + predictive reclaim scheduling to dampen grade-driven dispatch variability |
📊 Key Properties & Parameters
OTD% Baseline Window
±15–60 min (rail: ±30 min; port berth: ±15 min; truck dispatch: ±10 min)The maximum allowable time deviation (in minutes) from scheduled arrival/departure used to classify a movement as 'on-time'
⚡ Engineering Impact:
Too narrow a window inflates perceived failure rate; too wide masks systemic scheduling drift and erodes accountability.
Stockpile Utilization %
65–85% (optimal); <50% indicates underinvestment or poor blending planning; >90% risks segregation, spillage, and reclaim bottlenecksRatio of active (flow-through) stockpile volume to total engineered storage capacity, excluding dead zones and segregation buffers
⚡ Engineering Impact:
Directly governs reclaim efficiency, blend consistency, and risk of forced stockpile turnover during weather events or maintenance outages.
TAT (Railcar Turnaround Time)
4.5–12.0 hours (dry bulk; includes unloading, inspection, cleaning, loading, documentation, and yard movement)Elapsed time from railcar arrival at loading facility to departure fully loaded and cleared for port transit
⚡ Engineering Impact:
Drives required railcar fleet size; every 1-hour reduction in median TAT reduces capital tied up in rolling stock by ~3–5%.
Port Interface Slot Adherence %
72–91% (global benchmark: ≥85% for Tier-1 export terminals)Percentage of scheduled vessel berthing/unberthing events that occur within their allocated ±30-minute time window
⚡ Engineering Impact:
Below 80% triggers demurrage penalties and constrains annual export volume due to berth congestion cascades.
📐 Key Formulas
On-Time Delivery % (OTD%)
OTD% = (N_on_time / N_total) × 100Percentage of scheduled material movements arriving/departing within baseline time window
Variables:
| Symbol | Name | Unit | Description |
|---|---|---|---|
| OTD% | On-Time Delivery Percentage | % | Percentage of scheduled material movements arriving/departing within baseline time window |
| N_on_time | Number of On-Time Movements | count | Count of material movements that arrived/departed within the baseline time window |
| N_total | Total Number of Scheduled Movements | count | Total count of scheduled material movements |
Typical Ranges:
Iron ore export rail-to-port
82–93%
Coal export with multiple port options
78–89%
Copper concentrate with small vessel slots
70–84%
⚠️ Contractual minimum: ≥85%; operational alarm threshold: <82% for >3 consecutive days
Stockpile Utilization %
SU% = (V_active / V_capacity) × 100Ratio of physically usable stockpile volume to total engineered capacity
Variables:
| Symbol | Name | Unit | Description |
|---|---|---|---|
| SU% | Stockpile Utilization Percentage | % | Ratio of physically usable stockpile volume to total engineered capacity |
| V_active | Active Stockpile Volume | m3 | Physically usable stockpile volume |
| V_capacity | Stockpile Capacity | m3 | Total engineered stockpile capacity |
Typical Ranges:
Dry, free-flowing iron ore
68–83%
Moist, cohesive coal blend
55–72%
Fine phosphate concentrate
48–65%
⚠️ Upper limit: ≤85% (prevents segregation & reclaim jamming); lower limit: ≥60% (ensures blend homogeneity)
Railcar Turnaround Time (TAT)
TAT = t_departure − t_arrivalTotal elapsed time for railcar processing at loading facility
Variables:
| Symbol | Name | Unit | Description |
|---|---|---|---|
| TAT | Railcar Turnaround Time | time unit (e.g., hours) | Total elapsed time for railcar processing at loading facility |
| t_departure | Departure Time | time unit (e.g., hours) | Time when railcar departs the loading facility |
| t_arrival | Arrival Time | time unit (e.g., hours) | Time when railcar arrives at the loading facility |
Typical Ranges:
Automated high-capacity iron ore loading
4.5–7.0 hrs
Manual-assisted coal loading with inspection
7.5–11.0 hrs
Export concentrate with lab assay hold
9.0–14.0 hrs
⚠️ Target median: ≤6.5 hrs; 95th percentile: ≤10.0 hrs
🏭 Engineering Example
Roy Hill Iron Ore Project, Pilbara, Western Australia
Banded Iron Formation (BIF) hematite oreOTD%
89.3%
TAT (median)
6.8 hrs
Railcar Fleet Size
2,240 units
Port Slot Adherence %
86.7%
Stockpile Reclaim Rate
12,500 t/h (per stacker-reclaimer)
Stockpile Utilization %
76.2%
🏗️ Applications
- Iron ore export from Pilbara to China/Japan/Korea
- Coal export from Bowen Basin to India/Vietnam
- Copper concentrate export from Andes to Rotterdam/Chilean ports
🔧 Try It: Interactive Calculator
📋 Real Project Case
Chilean Iron Ore Export Corridor Optimization
Major iron ore mine exporting via Antofagasta port
Challenge: Chronic rail delays causing port demurrage penalties and stockpile overflow
Read full case study →
❓ Frequently Asked Questions
Why are OTD%, TAT, and Stockpile Utilization % specifically chosen as core KPIs for end-to-end logistics in mining-to-port operations?
These three KPIs collectively capture critical performance dimensions across the value chain: OTD% measures contractual delivery reliability from mine to port; TAT quantifies process efficiency at bottleneck nodes (e.g., rail loading, vessel berthing, customs clearance); and Stockpile Utilization % reflects inventory health and capacity utilization—directly linking physical constraints (e.g., stockpile volume limits, reclaim rate) to throughput risk. Together, they enable root-cause diagnosis across interdependent systems rather than siloed operational metrics.
How is On-Time Delivery % (OTD%) defined and validated in an end-to-end context where handoffs span multiple operators (mine, rail, port)?
OTD% is defined as the percentage of shipments delivered to the export port within the agreed SLA window (e.g., ±24 hours of scheduled arrival), anchored to a single end-to-end timeline—from mine departure timestamp to vessel loading completion. Validation requires synchronized, auditable timestamps from ERP, GPS telematics, rail dispatch logs, and port TOS (Terminal Operating System), with reconciliation protocols for data gaps and exception handling (e.g., force majeure). Sampling frequency is daily, with monthly statistical validation against physical shipment records.
What does 'statistical robustness' mean for Turnaround Time (TAT), and how is it ensured across variable conditions like weather or berth congestion?
Statistical robustness for TAT means defining a stable, repeatable measurement protocol—including precise start/end event triggers (e.g., TAT for railcars starts at gate-in and ends at train departure confirmation), outlier filtering rules (e.g., excluding delays >95th percentile due to unplanned maintenance), and stratified baselines (e.g., separate TAT targets for dry vs. wet season, or by commodity type). Data provenance is enforced via API-integrated source systems, with version-controlled calculation logic and quarterly bias audits against ground-truth observations.
How is Stockpile Utilization % calculated—and why is it not simply 'current volume / max capacity'?
Stockpile Utilization % is calculated as (Active Working Volume / Effective Usable Capacity) × 100, where 'Active Working Volume' excludes segregated, non-reclaimable, or quality-impacted stock (e.g., blended ore layers awaiting assay), and 'Effective Usable Capacity' deducts safety margins, segregation buffers, and reclaim equipment reach limitations—not just nominal cubic volume. This ensures the KPI reflects *operational* availability for throughput planning, not theoretical storage headroom, and is updated hourly via laser scanning + LIDAR integration with the stockyard management system.
How do these KPIs align with contractual SLAs and regulatory reporting requirements in cross-border mining logistics?
Each KPI maps directly to enforceable SLA clauses: OTD% ties to demurrage/despatch calculations in shipping contracts; TAT benchmarks underpin rail access agreements and port service level commitments; and Stockpile Utilization % informs government-mandated export quota compliance and environmental stockpile cap reporting. Calibration includes legal review of definitions, alignment with ISO 20785 (bulk material logistics) and IMO/UNCTAD port performance guidelines, and automated audit trails for regulatory submissions (e.g., customs, port authority dashboards).
🎨 Technical Diagrams
📚 References
[1]
Guidelines for Performance Monitoring in Bulk Materials Handling Systems
— International Organization for Standardization (ISO)
[2]
Mine-to-Market Optimization Handbook
— Australian Centre for Geomechanics (ACG)
[3]
Railway Freight Operations Manual
— International Union of Railways (UIC)
[4]
Port Performance Benchmarking Guidelines
— World Association for Waterborne Transport Infrastructure (PIANC)