Automated real-time reporting on carriers, deliveries, and SLA delays, with an enhanced OTIF reporting model
A unified criteria reporting system introduced to all carriers
Introducing and calculating “On time” and “In full” KPIs
Efficient monitoring of SLA delays
Problem
A global medical device manufacturing company has a presence in most countries across the world and needs to send products from their central manufacturing sites across the globe using a number of different logistics providers. Due to the nature of their business, these deliveries are extremely time-sensitive. However, because of the different systems used by the carriers, the process of gathering data from them was mostly manual. The company was not able to calculate the service-level agreement (SLA) delays automatically, because of the inconsistencies in data.
.
Solution
One of the significant challenges of the project was that each of the carriers has a different CRM interface with its specifics on how the information is tracked and provided to their customers, making the gathered data very different in format and analysis potential. Additionally, there was a varying frequency of data export capabilities and integration to the client ERP interface – all causing delays in reporting of performance analysis. We suggested the development of a unified checklist of data required from each carrier. Our team provided the technical expertise and our consultants communicated with the different vendors until we organized and delivered a unified data set. We created an automated dashboard that does hourly data updates and eliminates the need for manual data export and transformations.
Success
We enabled our client to switch to a new model of reporting – On Time and In Full (OTIF), which gave them visibility to the delivery time as well as the quality of the received packages (in full, goods condition, etc.). To keep track of the OTIF metrics, we created a multifunctional application, which provides the management team with a one-single source of data for the whole logistical process, to identify areas of improvement and optimization. Furthermore, based on the collected data and the OTIF model, our client can now easily perform even more in-depth analyses with access through different devices – phone or tablet reports.