Operations and Logistics KPIs: Complete Guide with Power BI
By Franco Gallegos · January 7, 2026 · 5 min read
Operations and logistics are the physical heart of any company that produces, distributes, or delivers goods. And yet, it is one of the areas where data-driven measurement is still most underdeveloped: many industrial and distribution companies still depend on manually built weekly reports, with no real-time visibility into what is happening on the plant floor, in the warehouse, or on the last mile. Operations and logistics KPIs, visualized in a Power BI dashboard connected to operational systems, transform that reality.
In this guide we cover the most relevant indicators for operational management, with their formulas, reference benchmarks, and an integrated analysis model to identify bottlenecks before they generate losses.
Why operational KPIs are strategic
In an environment where margins are tight and competitive pressure is constant, operational inefficiencies that go unmeasured are inefficiencies that repeat themselves. A team with 60% plant efficiency that brings it up to 75% can increase productive capacity without capital investment. A logistics team that reduces late deliveries from 15% to 5% improves customer experience and reduces re-delivery and compensation costs.
Power BI connects to ERP, MES (Manufacturing Execution Systems), and WMS (Warehouse Management Systems) to consolidate all this data into a single dashboard with automatic updates. The operations team no longer relies on periodic reports but has constant visibility into the state of the plant, inventory, and delivery.
The most important operations and logistics KPIs
Below are twelve key indicators for any operational area.
1. OEE – Overall Equipment Effectiveness
The most comprehensive efficiency indicator for manufacturing operations. It combines availability, performance, and quality to express what percentage of the planned productive time was actually used to generate conforming products.
Formula: Availability × Performance × Quality (each component expressed as a percentage)
2. On-Time Delivery (OTD)
The percentage of orders delivered to the customer on the committed date. The compliance KPI most directly linked to customer experience and one of the most monitored in logistics.
Formula: (Orders delivered on time / Total orders delivered) × 100
3. Fill rate
What percentage of order lines were delivered complete (without stock shortages). A low fill rate indicates inventory or production planning problems that directly impact customer satisfaction.
Formula: (Units delivered / Units ordered) × 100
4. Inventory turnover
How many times inventory is renewed per period. High turnover indicates efficient working capital management; low turnover may indicate overstock or slow-moving products that tie up capital.
Formula: Cost of goods sold in period / Average inventory for period
5. Days of supply
How many days of demand current inventory can cover without replenishment. Allows anticipating stockouts and optimizing inventory levels.
Formula: Current inventory / Average daily demand
6. Logistics cost as a percentage of sales
The share of revenue absorbed by total logistics costs (transportation, warehousing, inventory management). A structural indicator of supply chain efficiency.
Formula: (Total logistics costs / Revenue) × 100
7. Production lead time
The total time elapsed from when a production order is initiated to when the product is ready for dispatch. A shorter lead time improves responsiveness to demand.
Formula: Completion date – Start date of production order (average)
8. Defect rate
The percentage of produced units that do not meet quality standards. Includes both internal rejects (detected before dispatch) and external claims (detected by the customer).
Formula: (Defective units / Total units produced) × 100
9. Cost per unit produced
The total cost of producing one unit of product, including direct materials, direct labor, and manufacturing overhead. The most direct economic efficiency indicator of the production operation.
Formula: Total production costs for period / Units produced
10. Workplace accident rate
The frequency of workplace accidents relative to hours worked. A safety KPI with direct impact on operational continuity, compensation costs, and organizational culture.
Formula: (Number of accidents / Hours worked) × 1,000,000 (frequency per million hours)
11. OTIF (On Time In Full)
The combination of OTD and fill rate in a single indicator: the percentage of orders delivered on time AND complete. The most demanding customer service KPI and the standard required by many retailers and corporate clients.
Formula: (Orders delivered on time and complete / Total orders) × 100
12. Maintenance cost as a percentage of fixed assets
The proportion of fixed asset value allocated to maintenance (preventive and corrective). An indicator of maintenance program maturity and equipment fleet age.
Formula: (Maintenance costs / Fixed asset value) × 100
Reference table: KPIs, formulas, and benchmarks
| KPI | Simplified formula | Reference benchmark |
|---|---|---|
| OEE | Availability × Performance × Quality | > 85% (world class) |
| OTD | On-time deliveries / Total deliveries × 100 | > 95% |
| Fill rate | Units delivered / Units ordered × 100 | > 98% |
| Inventory turnover | COGS / Average inventory | Varies: 4–12x/year by industry |
| Days of supply | Inventory / Daily demand | 15–45 days (by sector) |
| Logistics cost / sales | Logistics costs / Revenue × 100 | 5–10% (efficient distribution) |
| Production lead time | Average days per order | Depends on product and process |
| Defect rate | Defective units / Total × 100 | < 1% (quality manufacturing) |
| Cost per unit | Total costs / Units produced | Downward trend |
| Accident rate | Accidents / Hours × 1,000,000 | Trend toward 0 |
| OTIF | On-time and complete / Total × 100 | > 95% |
| Maintenance cost | Maintenance cost / Assets × 100 | 2–5% of asset value |
How to build the operations dashboard in Power BI
Power BI can connect directly to the most widely used operational systems: SAP PP/WM, Oracle SCM, Microsoft Dynamics, proprietary MES systems, and production SQL databases. For companies with simpler systems, data can come from structured spreadsheets or warehouse management system APIs.
Cross-filtering is especially valuable in operations because it allows analyzing any KPI segmented by plant, production line, shift, product, or period. When the operations manager filters the dashboard by a specific plant, all indicators — OEE, OTD, defect rate, days of supply — automatically recalculate to show only that plant's data. Adding a shift filter can identify whether quality or productivity issues are specific to that shift, that line, or that product-machine combination. That level of granularity, without building separate reports, is what makes Power BI so powerful for operational management.
The recommended dashboard structure includes: a production panel (OEE, lead time, defect rate), an inventory panel (turnover, days of supply, fill rate), a logistics panel (OTD, OTIF, logistics cost), and an operating costs panel (cost per unit, maintenance, energy efficiency).
You can see how our dashboard is structured at operations products for Power BI.
How operations KPIs relate to each other
Operations and logistics KPIs are highly interconnected:
- A low OEE directly impacts production lead time: if the plant does not produce at planned efficiency, orders are delayed and OTD drops.
- A high defect rate not only raises the cost per unit (through rework and scrap) but also reduces fill rate if defective units are deducted from available stock.
- A low fill rate combined with high days of supply may indicate an inventory mix problem: there is stock, but not of the products customers are ordering.
- Low inventory turnover drives up logistics cost as a percentage of sales: more immobilized inventory means higher storage costs per unit sold.
Want real-time visibility into your operations?
Explore our operations dashboard for Power BI, with OEE, OTD, inventory, and logistics in a single integrated panel.
See the Operations Dashboard →Frequently Asked Questions
- What is OEE and why is it the most important KPI in operations?
- OEE (Overall Equipment Effectiveness) is the most comprehensive efficiency indicator for manufacturing operations. It combines three factors: equipment availability, production performance, and product quality. An OEE above 85% is considered world class, and tracking it allows identifying exactly which of the three components is generating productivity losses.
- What is the difference between OTD and OTIF?
- OTD (On-Time Delivery) measures the percentage of orders delivered on the committed date, regardless of whether they were complete. OTIF (On Time In Full) is more demanding: it requires the order to arrive both on time and complete. OTIF is the standard required by many retailers and corporate clients, and is the most widely used customer service KPI in supply chain management.
- How does Power BI help manage operations KPIs?
- Power BI connects to ERP, MES, and WMS systems to consolidate production, inventory, and logistics data in a single automatically updated dashboard. Its cross-filtering capability allows segmenting all KPIs by plant, production line, shift, or product with a single click, quickly identifying where operational problems are concentrated without building separate reports.