Hello,
Thank you for helping me on the below:
I have to produce 6 items for example (item 1 to item 6). I have 3 lines of production (line 1,2,3) that can produce these 6 items. I have a table that shows me the time needed for every item to be produced on these lines. How can I do a simulation that gives me a result of which item with which other item should I produce on each line so that all 3 lines are equally functional with the same amount of time.
In the example below, ill explain better:
Thank you,
Thank you for helping me on the below:
I have to produce 6 items for example (item 1 to item 6). I have 3 lines of production (line 1,2,3) that can produce these 6 items. I have a table that shows me the time needed for every item to be produced on these lines. How can I do a simulation that gives me a result of which item with which other item should I produce on each line so that all 3 lines are equally functional with the same amount of time.
In the example below, ill explain better:
Thank you,
Time to produce in minutes | ||
Item 1 | 10 | |
Item 2 | 20 | |
Item 3 | 30 | |
Item 4 | 20 | |
Item 5 | 25 | |
Item 6 | 15 | |
Simulation result: (what I want from Excel to give me) | ||
Line 1 | Item 1 + Item 3 | 40 minutes |
Line 2 | Item 2 + Item 4 | 40 minutes |
Line 3 | Item 5 + Item 6 | 40 minutes |