Operations and logistics metrics: formulas and SQL
Metrics for delivery, cost, capacity and quality. Missing timestamps and partial periods are the most common reasons these numbers are wrong.
- On-Time Delivery RateOn-time delivery rate is the percentage of deliveries that arrived on or before the promised date.
- On-Time In-Full (OTIF)OTIF is the share of orders delivered both on time and with the complete quantity ordered.
- Order Fill RateOrder fill rate is the percentage of ordered quantity that was shipped from stock on the first attempt.
- Cost per MileCost per mile is the average transport cost for each mile driven, a core measure in fleet and freight operations.
- Capacity UtilisationCapacity utilisation is the percentage of available capacity that is actually used.
- Order Cycle TimeOrder cycle time is the average time from a customer placing an order to receiving it.
- Supplier Lead TimeSupplier lead time is the time between placing a purchase order and receiving the goods.
- Perfect Order RatePerfect order rate is the share of orders that arrive on time, complete, undamaged and correctly invoiced.
- Defect RateDefect rate is the percentage of produced or inspected units that fail quality standards.
- First Pass YieldFirst pass yield is the percentage of units that pass quality checks the first time, without rework or scrap.
- Overall Equipment Effectiveness (OEE)OEE measures how well manufacturing equipment is used by combining availability, performance and quality.
- ThroughputThroughput is the number of units a process completes in a given time.
- Backorder RateBackorder rate is the percentage of orders or lines that could not be filled from stock when ordered.
- Freight Cost per UnitFreight cost per unit is the average shipping cost attached to each unit shipped.