I created a pretty awesome excel macro that I'm willing to sell to other teams. It automates 90% of the Cost Report and adds features like weight roll up.
The only real work required is organizing your eBOM structure
The macro will automatically create files based on your eBOM structure, will let you know if you have files that don't have a corresponding entry in the eBOM.
Values are automatically imported into the eBOM for 100% accuracy.
It will save you tons of time and money.
Please check it out here.