KPI-board connected supply chain at a leading freight forwarding company
An international freight forwarding company was selected by an OEM as a pilot freight forwarder for a project called “Connected Supply Chain”. The aim of this project was to provide the OEM with an ETA (estimated time of arrival) of the delivering trucks every 5 minutes based on GPS data. The OEM divided the project into three phases, the hypercare phase, stabilisation phase and series operation, which lasted a total of 16 weeks. To ensure process and data quality, approx. 30 key performance indicators (KPIs) were defined for these phases, e.g. each status message transmitted by a truck should contain a geo-location. To do so, BLSG’s experts developed a KPI board in cooperation with the client. The data recorded by the trucks was accessed by means of various SQL queries. To be able to influence the KPIs, one or more reports were created for each KPI. These reports provided detailed information that was used to derive subsequent measures.