KPIs for COOs and Operations Managers
These are the KPIs a COO or operations manager tracks for delivery, quality, cost and capacity. They show where the operation is losing time, money or customers' goodwill.
The KPIs to track
OTIF is the share of orders delivered both on time and with the complete quantity ordered.
Formula and SQL query on the On-Time In-Full (OTIF) page.
Perfect order rate is the share of orders that arrive on time, complete, undamaged and correctly invoiced.
Formula and SQL query on the Perfect Order Rate page.
Order cycle time is the average time from a customer placing an order to receiving it.
Formula and SQL query on the Order Cycle Time page.
Supplier lead time is the time between placing a purchase order and receiving the goods.
Formula and SQL query on the Supplier Lead Time page.
Capacity utilisation is the percentage of available capacity that is actually used.
Formula and SQL query on the Capacity Utilisation page.
Defect rate is the percentage of produced or inspected units that fail quality standards.
Formula and SQL query on the Defect Rate page.
Overall Equipment Effectiveness (OEE)
OEE measures how well manufacturing equipment is used by combining availability, performance and quality.
Formula and SQL query on the Overall Equipment Effectiveness (OEE) page.
Freight cost per unit is the average shipping cost attached to each unit shipped.
Formula and SQL query on the Freight Cost per Unit page.
Where the data usually lives
An ERP or order management system, warehouse and transport systems, production logs and quality records.
Measurement mistakes to avoid
- On-time needs a promise date agreed at order; use the same one for every report.
- Averages across sites with different volumes hide poor sites; recompute from totals.
- A metric that is easy to hit (partial deliveries counted as complete) hides the real service level.
Questions to ask your data
You can type these as plain questions. SchemaChat turns each one into SQL against your connected database or uploaded file, runs it, and shows the SQL and the figures it used so you can check the answer before you share it. Check that the result matches how your business defines each KPI.
- What share of orders were delivered on time and in full last month?
- Where is the longest delay in our order cycle?
- Which sites have the lowest capacity utilisation?
- What is our defect rate by product and by supplier?