How do build up measure for complex relations data

I have three data table like the Pictre, first table is demand  for Chassis and PCA, second is Chassis BOM (shows how many PCA in this Chassis), Third is PCA BOM for lower level component. Is t...