nixz
02-25-2016, 01:32 AM
Can anyone help me with this problem?
I have 4 factories, F1, F2, F3, F4 with maximum load 100, 100, 80, 60 tons at a time respectively. F1 and F2 can produce 6 different products namely a, b, c, d, e, f while F3 can produce a, b, c, d, e and F4 can produce only a, b, c, d The products a, b, c, d, e & f are having different production times and weights say
a 2days, 1ton
b 3days, 2ton
c 5days, 4ton
d 7days, 6ton
e 7days, 7ton
f 10days, 9ton
Now I got an order to produce 300 products.
a x 80, b x 30, c x 15, d x 4, e x 7, f x 3.
I need a vba code to distribute these products to different factories so that the total production is completed in almost the same time in 4 factories. More close enough.The code should also work if I get an order for 3 different products only like (a x 10, e x 10, f x 10).
If any one can help me in solving the above problem, its greatly appreciated.
I have 4 factories, F1, F2, F3, F4 with maximum load 100, 100, 80, 60 tons at a time respectively. F1 and F2 can produce 6 different products namely a, b, c, d, e, f while F3 can produce a, b, c, d, e and F4 can produce only a, b, c, d The products a, b, c, d, e & f are having different production times and weights say
a 2days, 1ton
b 3days, 2ton
c 5days, 4ton
d 7days, 6ton
e 7days, 7ton
f 10days, 9ton
Now I got an order to produce 300 products.
a x 80, b x 30, c x 15, d x 4, e x 7, f x 3.
I need a vba code to distribute these products to different factories so that the total production is completed in almost the same time in 4 factories. More close enough.The code should also work if I get an order for 3 different products only like (a x 10, e x 10, f x 10).
If any one can help me in solving the above problem, its greatly appreciated.