Badjoras
05-28-2016, 07:01 AM
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 :\
16285
Can anyone help me? Thank you!
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 :\
16285
Can anyone help me? Thank you!