Ganit's Route Optimization Solution Enables DTDC to Attain 100% SLA and Optimal Resource Management

INDUSTRY OVERVIEW

Large Players in the logistics space have SLAs attached in contracts with their customers. These SLAs usually come with a penalty clause attached which are invoked if the SLA is not met.

THE PROBLEM

The company's current route optimization process was manual and time-consuming. Employees would spend hours manually planning routes, and they would often make mistakes. This resulted in missed deliveries, which were costly for the company.

OUR ROLE

We identifed the need for data-driven approach in daily route planning, number of vehicles required and optimal assignment of shipments.

METHODOLOGY

Guidelines

• What are the top 2-3 problems / gaps we identified to help solve the problem?
• What kind of data sets were used? E.g. POS data, Product Master, etc.
• What solution(s) was delivered to the client?
• How did the client use the solution? Talk about frequency and application

SOLUTION

Ganit proposed a cloud-based architecture leveraging AWS services, providing scalability, flexibility, and cost-effectiveness. AWS Redshift was chosen as the central data warehousing tool, offering high-performance, columnar storage, and distributed query processing capabilities. S3 was utilized as the source repository for data, allowing for scalable storage and easy accessibility. Ganit implemented Glue jobs and Lambda functions for efficient data ingestion, transforming raw data into a suitable format for analysis.

OUR IMPACTs

There was a 15% savings in cost with zero missed deliveries. The delivery team no longer had to strech to meet the deadlines. Number of vehicles used for delivery was brought down by 25% on average.The company was able to improve customer satisfaction by delivering packages on time and in good condition.