In my situation, I have the following procedure:
In one projects I have
+/- 400 workorders
+/- 300 BoM (Single use)
+/- 50 BoM (1 kg steel, 0.02 hours labor, 0.2 Kwh electricity, 0.1 Liter paint, 2 welding rods, dll)
+/- 5000 Items (single use)
Project A
workorder 1
BoM 1
Item (material)
Item (material)
Item (consumables)
Item (consumables)
Item (Labor)
Item (Labor)
BoM 2
Item (material)
Item (material)
Item (material)
Item (consumables)
Item (consumables)
Item (Labor)
----------------
workorder 2
BoM 1
Item (material)
Item (material)
Item (consumables)
Item (consumables)
Item (Labor)
Item (Labor)
BoM 2
Item (material)
Item (material)
Item (consumables)
Item (consumables)
Item (Labor)
Item (Labor)
----------------
Preferable:
workorder 3
BoM 1
Item (material)
BoM 5
Item (consumables)
Item (Labor)
Item (consumables)
Item (Labor)
BoM 2
Item (material)
BoM 5
Item (consumables)
Item (Labor)
BoM 6
Item (material)
Item (consumables)
Item (Labor)
Item (material)
Item (consumables)
Item (consumables)
Item (Labor)
Item (Labor)
Item (consumables) Real
Item (Labor) Real
----------------