Hi everyone
it is my first thread on this site
I am stuck with an issue and I hope you can help
here is the file attached
basically it's about stocking products between 3 warehouses.
warehouse1
warehouse2
warehouse3
stock of 42 references
each warehouse contains rooms in which there must be quantities provided for each item
ENTREPOT1.1
ENTREPOT1.2
ENTREPOT1.3
ENTREPOT1.4
ENTREPOT2.1
ENTREPOT2.2
ENTREPOT3.1
ENTREPOT3.2
ENTREPOT3.3
ENTREPOT3.4
you will find the quantities REQUIRED in columns Z to AI for each room per warehouse per article.
you will find the quantities PRESENTES in columns C to L for each rooms by warehouse per article.
in column N to P, you will see additional stocks per warehouse.
OBJECTIVE: is to have all rooms with items and quantity as required.
So needed to transfer parts between sites to meet the demand.
of course some parts will have to stay on their site because some parts have not yet been supplied as an example F2 by N2
example that works: from N13: move 1 quantity towards G13 and 4 towards L13
I hope it's pretty much clear
here is a trap:
line 27: article 26: from warehouse 1: I can only transfer 1 quantity to another enterepot because 16 are required on this site. ====> ANSWERING THE NEED OF THE SITE ON WHICH THE PARTS ARE REQUIRED PASSES BEFORE TRANSFERING THESE PARTS TO ANOTHER SITE WHICH IS LOGIC. so on this item lenterpot 1 will keep 16 units. warehouse 2 and 3 will keep their own quantity which makes sense
here I hope I have been clear
Thank you
it is my first thread on this site
I am stuck with an issue and I hope you can help
here is the file attached
basically it's about stocking products between 3 warehouses.
warehouse1
warehouse2
warehouse3
stock of 42 references
each warehouse contains rooms in which there must be quantities provided for each item
ENTREPOT1.1
ENTREPOT1.2
ENTREPOT1.3
ENTREPOT1.4
ENTREPOT2.1
ENTREPOT2.2
ENTREPOT3.1
ENTREPOT3.2
ENTREPOT3.3
ENTREPOT3.4
you will find the quantities REQUIRED in columns Z to AI for each room per warehouse per article.
you will find the quantities PRESENTES in columns C to L for each rooms by warehouse per article.
in column N to P, you will see additional stocks per warehouse.
OBJECTIVE: is to have all rooms with items and quantity as required.
So needed to transfer parts between sites to meet the demand.
of course some parts will have to stay on their site because some parts have not yet been supplied as an example F2 by N2
example that works: from N13: move 1 quantity towards G13 and 4 towards L13
I hope it's pretty much clear
here is a trap:
line 27: article 26: from warehouse 1: I can only transfer 1 quantity to another enterepot because 16 are required on this site. ====> ANSWERING THE NEED OF THE SITE ON WHICH THE PARTS ARE REQUIRED PASSES BEFORE TRANSFERING THESE PARTS TO ANOTHER SITE WHICH IS LOGIC. so on this item lenterpot 1 will keep 16 units. warehouse 2 and 3 will keep their own quantity which makes sense
here I hope I have been clear
Thank you
