Multiply depending on level to find Total Qty in Bill of Materials

Hi all

I have a problem that i cannot seem to wrap my head around.

When we extract a Bill of Material from our PLM software to Excel, it is only able to tell us the quantity of the specific item - hence if the item is part of a sub-assembly of which we need 3, then it cannot tell the 'total quanntity'.

I have included an example, which also contains an example of the values needed.

Thanks in advance!

Br, Mike