We sell a product through eCommerce that is manufactured. Our manufacturing lead time is very short.

Our B2B customers buy in large quantities and would like to know our stock levels for the product.  We wish to calculate and display on the website a theoretical maximum stock quantity for the sold product based upon the quantity of components we have that are used in the BOM. 

Does any partner have a solution for this? We are using attributes and variants to mange different colours so knowing how many of a given colour we can make would be even more useful. 

We are using Odoo v17.0 Enterprise