Case Study
AHS Route Optimiser
A full-stack scheduling and route optimisation tool that centralises client and job data, balances weekly rosters, clusters jobs geographically, and integrates third-party routing and mapping APIs to generate optimised daily routes and calendar exports.
Web App Interface
A minimal interface to easily navigate to the database or creation of new rosters.
Client Data Management
Centralised local storage database using MySQL and the UI to show client details, job locations, service notes, and constraints (e.g., time windows) to reduce duplicated admin work.
Roster Setup - (1/2)
Create roster for the week through adding client jobs and letting the system organise and balance total hours for each day.
Roster Setup - (2/2)
Customise the teams and members for the week considering the hours per employee to finish by 5:00 PM.
Job Cluster - (1/2)
System will use algorithms and the RouteXL API to cluster the jobs per day separated by area to reduce driving times for each team.
Job Cluster - (2/2)
Visualise jobs on a map and generate an ordered stop list with estimated travel times to reduce inefficiency and improve throughput.
Scheduler Page
RouteXL API will generate a route and visually displayed from the Leaflet Map API. Driving time estimates will be calculated and routes are adjustable by click and drag to re-organise easily.
Calendar Export (ICS)
Generate a calendar-compatible export so schedules can be imported into Google Calendar without retyping addresses, times, or notes.