Route Optimization

Objective

A Diary Company currently manages a fleet of approximately 200 trucks of different vendors. The trucks are used to collect the milk production at different milk producers. Each truck contains a milk meter that measures and registers the amount of milk collected at each milk-manufacturing facility. The data registered by the milk meter is used in order to make payments to each milk producer. During milk collection, the truck driver enters data manually such as truck’s ID, driver, farm, among others, in the milk meter. 

This manual entry of data by the truck driver during collections and the data entered to legacy system is error-prone and must be subjected to subsequent verification. Additionally, causes delays and implies lots of work for data verification. 

Challenge

Since no GPS information is available, it is not possible to know the actual route and number of kilometers travelled by each truck. It is also impossible to detect unexpected stops or the actual time of the route and its sections. In general, lack of information and the fact that it is not available digitally make it difficult to take the necessary actions to optimize the integral management of the activity. 

Solution

Result

Optimize the milk collection process, reducing costs and collection times. 

Automate the milk collection data entry in its systems. 

Have real-time telemetries for the position of each truck and the amount of milk contained in the tank and its temperature. 

Stack

Azure IoT Hub, Azure App Service, Azure Event Hub, Azure Functions, Azure SQL Database.

Google Maps Services, React, .Net Web API, SQL Server Integration Services