Products Tracking

 Hi ,

in our site we are facing problems with Manufacturing levels ,

some products are Manufactured in three or more levels to become finished product .

the problem is : each one of these levels is separated recipe , so in the last level , we can't link between all these levels .

for example 

the first product is empty bottle = x  ==>  [ separated recipe with separated batches ]

the second level is liquid bulk  =  y   ==>  [ separated recipe with separated batches ]

the last level [filling] =  x + y + other ingredients == > [ separated recipe with separated batches ]

in this last level i want to know my consumption from all ingredients from all levels .