Hello Friends,
I need little help with code or just logic I am unable to build a process flow for the below task; where I need to assign drivers to packages for drop off.
I have a list of package delivery locations where Delivery Area 1 is closer to Delivery Area 2 and 2 to 3 and so on....and I also have a driver list with their range of packages From min that's the min they should have and max is the max they can have. And I'd like to assign drivers to drop the packages considering its range and delivery load.
If there are 3 deliveries for Area 1 and 5 deliveries for Area 2, both these area are closer to each other so driver 1 who has 5 - 10 limit should be assigned to this and so on but this driver cant get Area 1 and Area 3 because those areas are far off.
If there are not enough packages to fill everyone's minimum we can call off remaining drivers if there are extra packages we will request for more drivers
Please guide with logic or code...this needs to be done using VBA
Thanks
Bookmarks