There is a version of logistics performance management that involves pulling data from three systems every Monday morning, copying it into a spreadsheet, calculating the metrics by hand, and emailing a summary to the management team. It works, after a fashion. It produces a report that is two days old by the time anyone reads it, and it consumes an hour that could be spent on the operational decisions the report is supposed to inform.
There is a better version. Dynamics 365 Business Central holds the underlying data for most logistics KPIs as a by-product of normal operational activity. Power BI connected to that data produces live dashboards that update automatically. This article covers the metrics worth measuring and how to access them without manual effort.
The Metrics That Matter in Logistics Operations
On Time In Full (OTIF)
OTIF is the primary service level metric in logistics. It measures the percentage of orders delivered both on the agreed date and in the full quantity ordered. An order that arrives on time but short of the ordered quantity is an OTIF failure. An order that arrives with the correct quantity but a day late is also an OTIF failure. Measuring both conditions together gives a complete picture of how reliably the business is meeting its delivery promises.
Most distribution businesses that begin tracking OTIF discover their actual performance is below their assumed performance. The gap between what feels like normal service and what the data shows is frequently larger than expected.
Cost per drop
Cost per drop measures the total cost of making a single delivery, calculated by dividing the total cost of running a route or fleet by the number of successful deliveries made. When tracked by route, vehicle or customer segment, it reveals where delivery cost is disproportionate to order value and informs decisions about pricing, minimum order values and route consolidation.
Stock turn rate
Stock turn measures how many times the inventory is sold and replaced in a period. A high turn rate indicates that capital is being used efficiently; a low turn rate against specific lines or locations indicates slow-moving stock that is tying up working capital and warehouse space. In a distribution business with a large SKU range, turn rate by SKU quickly identifies the items that need attention.
Order pick accuracy rate
The percentage of orders picked without errors, measured against customer returns and credit notes raised for incorrect items. Poor pick accuracy generates downstream cost: customer returns, re-picks, credit notes, and customer service time. Tracking it by picker or by pick zone identifies where errors are concentrating.
Warehouse utilisation
The percentage of available warehouse capacity in use at any point. Businesses that do not measure this often discover they are either running out of space in one area while underutilising another, or carrying significantly more space than their actual throughput requires. Both conditions have a cost that becomes visible when utilisation is measured.
Supplier OTIF
The outbound OTIF delivered to customers depends partly on the inbound performance of suppliers. Measuring supplier OTIF, the percentage of purchase orders received on the agreed date and in the full quantity, identifies which supply relationships are creating operational risk in the fulfilment chain.
Vehicle utilisation rate
The percentage of vehicle payload capacity used across all delivery runs. Vehicles running significantly below capacity are an efficiency problem: the overhead of operating that vehicle is being spread across fewer units than it should be. Improving load utilisation, through better route consolidation and minimum order management, directly reduces cost per drop.
Why These Metrics Need to Be Automatic
A KPI that requires manual calculation each period will be produced inconsistently, will consume resource that should be elsewhere, and will often be delayed past the point where it can influence the decisions it is supposed to inform. The value of operational metrics is highest when they are current, which means they need to update continuously from live operational data rather than being compiled retrospectively.
Business Central records the events that produce these metrics as a natural by-product of operation: order confirmations, goods receipts, despatch records, vehicle assignments, stock transactions. Power BI converts those records into the metrics and visualises them in dashboards that update on a schedule without human intervention.
Building the Reporting Infrastructure
The initial configuration work involves connecting Power BI to the Business Central data model, defining the calculations for each metric, and designing dashboards that present the information in a format that is useful for operational decision-making rather than financial reporting.
Advantage works with logistics and distribution businesses to build this reporting infrastructure as part of a Business Central implementation or as a standalone reporting engagement. Our Power BI for Logistics guide covers the specific dashboards that replace manual spreadsheet reporting in distribution operations.
Talk to Our Logistics Team
If your operational KPIs are still produced manually, or if you are managing a logistics business without live visibility of the metrics that matter, speak to our team.
Contact Advantage today or call 020 3004 4600.
Related Resources
- Power BI for Logistics: The 6 Dashboards That Replace Your Spreadsheets
- Power BI Reporting and Dashboards
- Unified Data and Business Visibility
- Dynamics 365 Business Central
- Real-Time Stock Visibility for Logistics and Distribution
Frequently Asked Questions
What is OTIF and why is it important for logistics businesses?
OTIF stands for On Time In Full. It measures the percentage of customer orders delivered both on the agreed date and in the full quantity ordered, expressed as a single combined metric. It is the most important service level indicator in logistics because it captures the complete delivery promise from the customer's perspective. An order delivered on time but short-shipped counts as an OTIF failure.
How is cost per drop calculated in a distribution business?
Cost per drop is calculated by dividing the total cost of operating delivery runs over a period by the number of successful delivery drops completed in that period. Total cost should include driver wages, fuel, vehicle depreciation or lease cost, and any subcontractor carrier costs. Cost per drop is most useful when tracked by route, vehicle or customer segment rather than as a single business-wide average.
Can Business Central calculate these KPIs automatically?
Business Central holds the underlying data for most logistics KPIs: order dates, despatch dates, quantities, costs, and customer records. Power BI connected to Business Central can calculate and visualise these metrics automatically, refreshing the data on a defined schedule without manual intervention. Setting up the initial data model and report design is a one-time configuration task.
What is a reasonable OTIF target for a UK distribution SME?
OTIF targets vary by sector and customer expectation. Most UK distribution SMEs should be targeting 95 per cent or above for planned deliveries. Businesses serving major retail or food service customers with contractual SLAs often face OTIF targets of 97 to 99 per cent with financial penalties for underperformance. The appropriate target depends on what has been committed to customers contractually.
