Generating an optimized bill of material report

Greeting all! I am sure that what I am after exists somewhere already. I have seen several videos on generating a bill of materials as well as cut lists. What I am after is a little more specific. I am using Sketchup Pro 2021 and also utilizing the Quantifier Pro extension and it works to an extent. Example: I build a wall and get my stud, jacks, cripples and plate lengths etc. What is missing adding some intelligence to set available material sizes such as 2x4 lengths being 8’,10’,12’ etc so that if my cut length is 9’-7" my report would know to use a 10’ length and secondly when there are shorter lengths used combine the total lengths to generate a LF value and specific length material. Same concept for sheet goods.

Any direction here is greatly appreciated!