Order Assignment Problem

[Badjoras]

Hello!


I need to solve an order assignment problem. I think I can solve this using integer programming, but I need some tips to start the model.


1) A warehouse has to complete the picking of orders. Each order includes a list of products.


2) There is 1 working station and that station can prepare a maximum of 5 orders each time.


3) Definition of "task" = 1 station prepares 1 product (maximum of 5 picks in each task)


4) The objective is to maximize the KPI = Number of picks/Number of tasks.


I tried to arrange the Excel file the best I could so you can understand what is needed... if you have any doubts, please tell me!


This is my idea... I think I'm doing the right way, but I don't know how to "convert" it into a VBA code :\

f34f.jpg


Can anyone help me? Thank you!

[Badjoras]

I tried to create a simplification:

[SamT]

It is a national three day holiday in the USA. Some of our regulars won't be here until Tuesday. Don't worry, we have other regulars all over the Globe.