Hey everyone... I am hoping someone knows of an easy way to accomplish this via vba.
I have many orders where there are 1-6 items in the order.
Here is an array of items for an order.
SKU , Supplier , Cost
Sku1,supplier1, 20
sku1,supplier3, 3.2
sku2,supplier2, 2
sku2,supplier1, 3
sku2,supplier3, 4
sku3,supplier1, 4.1
sku4,supplier1, 4
sku4, supplier2, 5
The result I would hope to have the lowest possible cost of groups by supplier with list of skus. Sku can only belong to 1 group. Each group adds 5 to the total cost.
Some of the results would be like this
Supplier1
Sku1,sku2,sku3,sku4 = 31.1 + 5 = 36.1
or
Supplier1 + Supplier3
(Supplier1 sku2,sku3,sku4 = 11.1) + (Supplier3 Sku1 = 3.2) = 14.3 + 5 + 5 = 24.3
and so on for every possible supplier solution. Anyone help me with this or point me in the right direction?
I have many orders where there are 1-6 items in the order.
Here is an array of items for an order.
SKU , Supplier , Cost
Sku1,supplier1, 20
sku1,supplier3, 3.2
sku2,supplier2, 2
sku2,supplier1, 3
sku2,supplier3, 4
sku3,supplier1, 4.1
sku4,supplier1, 4
sku4, supplier2, 5
The result I would hope to have the lowest possible cost of groups by supplier with list of skus. Sku can only belong to 1 group. Each group adds 5 to the total cost.
Some of the results would be like this
Supplier1
Sku1,sku2,sku3,sku4 = 31.1 + 5 = 36.1
or
Supplier1 + Supplier3
(Supplier1 sku2,sku3,sku4 = 11.1) + (Supplier3 Sku1 = 3.2) = 14.3 + 5 + 5 = 24.3
and so on for every possible supplier solution. Anyone help me with this or point me in the right direction?
