Routing with capacity criteria
Good afternoon everyone, how are you?
Following the challenge of creating a route simulator in knime, I found a possibility that could suit me and that will be easier to manipulate and create.
I have 4 tables that needed to be crossed to get the final result.
Important points:
The route can have up to 17 stops.
Maximum vehicle capacity
Whichever comes first
1° I need to define the vehicle profile for each route. We have the “Collection points” table with all the stop information ( Shop_id ), and the number of cars available table with the number of cars available per region and the table a
Example :
The BIRIGUI region has 1 TRUCK available, and its capacity (P90) is 7253, I need us to have a route with either 17 stops or up to the value of the “orders_pickup” column
" reach this value.
Points of attention, the Collection points table is ranked, we can consider the next 17 SHOP_ID, as long as it is from the same SOC. However, for the vehicle’s capacity, we need to understand which one makes the most sense for each route, because there are routes that will have a larger volume and others that will have a smaller volume.
NOTE: If there is no vehicle to travel the route, you can include more as long as the profile has the largest quantity.
Example: there are 44 vehicles available in Birigui, 26 of which are vans in Birigui. If we need 47 routes, the additional 3 must use a van as a profile.
Follow the flow below, thanks in advance for your help