You may already be aware of this, but the problem you describe is a common one in steel service centers and its commonly referred to as "remnants". There are several software publishers focused on this industry and most of them offer specific functionality for managing remnants. If you search for something like "steel service center software" or "remnant management software" you will find some of these offerings. You may be able to glean some ideas from what those specialized publishers are doing to address this challenge. Good luck.
If you've found this thread useful, dive deeper into User Group community content by role