Last-Mile Delivery Optimization Process

Start of the Workflow/Process.

Fetch all delivery entries with a status of 'Pending' or 'In Transit' from the Delivery Data Model.

Sum the available volume/weight capacity of all active vehicle entries in the Fleet Data Model.

Retrieve driver entries that are currently marked as 'On Duty' and have no active assignments.

Calculate the ratio of total delivery stops to total available vehicle capacity to determine optimization needs.

Create a new 'Route Plan' entry in the Route Data Model containing the assigned stops and driver ID.

Create a task for the identified Driver to review and accept the newly generated Route Plan.

Update the status of individual delivery entries from 'Pending' to 'Dispatched' once the route is confirmed.

Send an SMS to the customer's phone number informing them that their delivery is on its way.

Retrieve the 'Expected Delivery Window' from the Customer Order data model to ensure route alignment.

Create a task for the driver to upload a photo and signature upon completion of the delivery.

Update the original Order entry to 'Delivered' once the driver completes the task.

Send an automated email to the customer with the delivery summary and receipt.

Sum the estimated fuel costs for all routes within the current optimization batch.

Generate a report summarizing successful deliveries, delays, and total distance traveled for the day.

Delete route plan entries that were created but never activated or have passed their expiration timestamp.

End of the Workflow/Process.