Hi All, I have various delivery trucks each which can take the same load (for example 10 orders), data is listed similar to below TruckLoad110210310410510610710 All orders must be assigned to a delivery truck, some have already been automatically assigned. The remaining orders must be assigned to a delivery truck with Order Priority in Descending order (i.e. High -> Medium -> Low) and Order No Ascending. Order NoVulnerable CustomerPriorityAssigned Truck1TrueHigh12TrueHigh73FalseMedium 4FalseLow 5FalseLow 6TrueHigh17FalseLow 8FalseLow 9FalseLow 10TrueHigh111FalseMedium 12FalseLow 13FalseLow This is just a condensed example, the actual data contains hundreds of cases Open to ideas on the best way to allocate this🙂 Thank you in advance!

Assigning Delivery Orders

Hi All,

I have various delivery trucks each which can take the same load (for example 10 orders), data is listed similar to below

Truck	Load
1	10
2	10
3	10
4	10
5	10
6	10
7	10

All orders must be assigned to a delivery truck, some have already been automatically assigned. The remaining orders must be assigned to a delivery truck with Order Priority in Descending order (i.e. High -> Medium -> Low) and Order No Ascending.

Order No	Vulnerable Customer	Priority	Assigned Truck
1	True	High	1
2	True	High	7
3	False	Medium
4	False	Low
5	False	Low
6	True	High	1
7	False	Low
8	False	Low
9	False	Low
10	True	High	1
11	False	Medium
12	False	Low
13	False	Low