I want t know if there is a way to leverage network analyst to create weekly or monthly plans for a sales person.
For example i have a a sales person who is assigned 50 orders. There is a weekly visiting frequency for each order, some being served once a week, some twice a week and some once every alternate week.
Is there a way i can get a weekly plan so that salesperson fulfils the following
- maximum hour to travel should not be more that 9 hours a day
- maximum visit he can make in a day cannot be more than 10
- also by the end of the week visiting frequency per order is fulfilled.
Any help or way to achieve this will be appreciated. Also if this is not possible with network analyst is there any other tool or combination of the tools i can use.
This is a periodic routing type problem that can be solved using the Vehicle Routeing Problem solver. Although the VRP solver isn't directly set up for periodic routing the process can be implemented with some work. Here is a link to a similar question on the periodic routing. Take a look at this answer and see if it helps you understand how to model your case. If you have more questions let me know.