The BOMs work well on complex products - but what I find is - say a product has 2 listed as the stock. The BOM is around 150 lines long [and from various suppliers].

How do I know what is about to cause the product to go out of stock? Ie. once 2 are bought I will then know as the material will show as red rather than green. But I want to know in advance - could we have a column that shows 'current warehouse stock' here?
https://www.chainsawbars.co.uk/product-category/panther-chainsaw-mills/

How do I do it now? I have to 'fiddle' each quantity up until it flashes at me 'putting this quantity will make this product out of stock' which is well fiddly!