Setup Multi Variable in Excel

[andersen_yunan]

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!

[TABLE="width: 765"]
<colgroup><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD][/TD]
[TD="align: right"]Adjustable*[/TD]
[TD][/TD]
[TD]Constraint[/TD]
[TD="align: right"]

Adjustable*​

[/TD]
[/TR]
[TR]
[TD]Time in Store (Minutes)[/TD]
[TD="align: right"]30[/TD]
[TD][/TD]
[TD]Working Time (Minutes)[/TD]
[TD="align: right"]420[/TD]
[/TR]
[TR]
[TD]Velocity (km/hr)[/TD]
[TD="align: right"]20[/TD]
[TD][/TD]
[TD]Distance Travel (km)[/TD]
[TD="align: right"]80[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]Customer[/TD]
[TD="align: center"]Distance From HQ (km)[/TD]
[TD="align: center"]CML-Working Time (Minutes)[/TD]
[TD="align: center"]CML-Distance[/TD]
[TD="align: center"]Sales[/TD]
[/TR]
[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]150[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]B[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]330[/TD]
[TD="align: center"]90[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]C[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]90[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]D[/TD]
[TD="align: center"]30[/TD]
[TD="align: center"]210[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]E[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]300[/TD]
[TD="align: center"]70[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]F[/TD]
[TD="align: center"]60[/TD]
[TD="align: center"]210[/TD]
[TD="align: center"]60[/TD]
[TD="align: center"]3[/TD]
[/TR]
</tbody>[/TABLE]