Materials ordered in bulk and cut to different lengths for assemblies

Example context: order a bulk reel of tubing, then cut to different lengths for use in various places in an assembly.

2 needs:

- Be able to roll up individual lengths of each component in assembly, to have a total length used in assembly for ordering/stocking purposes.

- Be able to search for supplier ID of bulk tubing, then see where used given there will be different CPNs for different lengths (at the moment, validation prevents same MPN being used twice, so one would have to include suffixes etc)

Duro has a post here related to this:

https://duro.zendesk.com/hc/en-us/articles/9183113260052-Specifying-Quantity-Bulk-Materials-in-a-BOM

However, it is limited due to above points.