I am working on a large Vehicle Routing Problem (VRP) for a number of depots and orders all across Michigan. Thus far I have been manually doing the VRP, adding Routes manually via 'Add Item' and changing its specifics. The sheer number of Routes and Route Renewals makes the task of doing this across all of Michigan essentially impossible.
I have some minor experience with ModelBuilder, but I am having difficulty automating the process.
Ideally, the computer would automatically add a number of Routes and Renewals based on values in the attribute table of the Depot (some have only 1 truck for deliveries, some have multiple, etc).
Is it possible to do what I need with ModelBuilder, or is another tool better?
How should I go about doing this?
Thank you in advance.