When you know which Raw materials are needed for a Component, you can use multiple VLOOKUP's to gather the total price for the Components.
This would solve the first 4 points.
Point 5 I don't understand. What different path? You are using multiple sheets in one file, right?
6. ???, You would like to rename the components and raw material?