If you aren’t currently, sounds like you are ready to use an ERP to track such things and link your BOMs to suppliers and purchasing.

You could probably get a BOM into something like Odoo over a weekend to test it out.