If it is more than 500 mm then we can consider that same pieces will be utilized for other project.So minimum wastage is the goal.' 'During cutting if remaining Pieces length is less then 500 mm then it is a wastage. RE: Optimized cutting of steel angles using EXCEL nitin36537 (Civil/Environmental) Since the solutions are all very close together optimization is more difficult to determine. Your solution uses 70 pieces of stock, but mine uses 67. Seems like minimum utilization of stock is actually the most desirable, as that preserves inventory. The OP needs to chime in about what the end goal is lower cost or lower wastage. Not clear whether this is the way to go, or whether your approach is the way to go. This was done by hand, of course, since it looked like there was no simple way program something like that, and it wasn't even clear whether the OP had any groundrules about that. It looks like your sheet treats P1-P4 as separate entities, which is why my attempt can't be replicated, since I combined different Px's to try and get better utilization of the stock. I'm not sure if there's a 'simple' way to do the optimization it would seem likely that a brute-force multi-combination testing approach would have to be undertaken.
