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

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.