Requesting a report with stock value and the retail price with the stock levels for decision making

I need to report on where our big stock value is in the business so that I can make decisions for marketing. The product stock level report is great for the in-stock items (I just wish we could somehow also see the retail inclusive price tier as well), but I also need to report on the availability of potential assemblies for our kits. What report can I use for that? The availability report doesn't seem customizable (I can't filter just BOM products or specific locations), I want to see a summary of just the BOM based products, how many assemblies could be made in total across all specified locations.