Hi,
i have a need to calculate some component requirements based on bill of materials, and this for many materials and plants at same time. Finished good materials can have multi level bill of materials, which means components themselves have their own BOM.
I have read forum messages on this topic, especially the challenge 81 and its solutions, tried on my own to adapt what had been done with iterative macro but couldn't come to and end as it was slightly differnt starting point. Notably here i don't know at first which bill of material is level 1, 2, 3 4 etc.
i have attached a sample to explain the problematic. "as is" sheet is how it is extracted from the source system. "Production needs" is the hypothesis of production volume required for each finished goods. "expectation" is the output i'd like to get as a list, so that we can see how much quantity of components is required in total and also which finished good material has contributed to this(in my example no component comes twice but this could be the case multiple times, some are uniques, some are recurrent).
Wonder if you could help me buid the logic needed to achieve this(
thanks
