Automated Truck Scheduling

Key Highlights

The previous application was completed by 5-member team within 3 months. I reimplemented the algorithm using Python, and complete within 2 months.

While having 700% more accuracy than previous SAAS-based application, the application also reduce processing time from 10 minutes to 12 seconds.

I also sucessfully delivered as sole Software Engineer.

Overview

Every day, PT Pertamina is required to distribute Gasoline to smaller gas stations.

Each day, every partner requests the product and quantity, so it can be fulfilled in the next day.

It became tedious task as manual assignment was required to have next-day preparation.

This application automate the process to manage truck assignment by considering several constraints below :

#	Domain	Constraints
1.	Sales request	Sales quantity
2.	Delivery	Shift and Schedule
3.	Delivery	Prioritization related to stock level
4.	Delivery	Distance between station
5.	Truck list	Truck Availability
6.	Truck list	Truck size variety

Constraints

Further optimization

to reduce round trip, we should minimize under utilization and arrange truck to have multiple drop points.

Sample output

Daily summary

Truck optimization

Technology used

Backend

As a small module from larger systems, this Python apps triggered via HTTP Request, and read input / write output to PostgreSQL

Python

Python - Pandas

Python - XLSXWriter

PostgreSQL