andersen_yunan
New Member
- Joined
- Feb 7, 2018
- Messages
- 36
Hi All,
Currently, I'm trying to resolve TSP problem regarding number of people need to cover stores in a day.
What I'm thinking currently is to setup a constraint and actual working minutes & velocity to travel to stores as per current below.
However, I'm stuck with the formula on how can I put a cumulative value that would stop once sales 1 reach a target either working time and distance travel.
Is there any formula that could help with this to get the value below?
Thanks in advance!
<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>
Currently, I'm trying to resolve TSP problem regarding number of people need to cover stores in a day.
What I'm thinking currently is to setup a constraint and actual working minutes & velocity to travel to stores as per current below.
However, I'm stuck with the formula on how can I put a cumulative value that would stop once sales 1 reach a target either working time and distance travel.
Is there any formula that could help with this to get the value below?
Thanks in advance!
| Adjustable* | Constraint | Adjustable* | ||
| Time in Store (Minutes) | 30 | Working Time (Minutes) | 420 | |
| Velocity (km/hr) | 20 | Distance Travel (km) | 80 | |
| Customer | Distance From HQ (km) | CML-Working Time (Minutes) | CML-Distance | Sales |
| A | 40 | 150 | 40 | 1 |
| B | 50 | 330 | 90 | 1 |
| C | 20 | 90 | 20 | 2 |
| D | 30 | 210 | 50 | 2 |
| E | 20 | 300 | 70 | 2 |
| F | 60 | 210 | 60 | 3 |
<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>
