aperocket

Hello, Thanks for the ideas. I'm still checking the possibilities for mathematical solution before applying it to filemaker.

Is this doable through simple script or field calculation? I don't know where to start but I'm hoping to exact solution about this. Here my example. I have a stock of 70", 100", 2pcs of 150" and 12pcs of 240". Also i have orders that needs 39", 88", 91", 106", 55", 55", 72", 72", 72", 144", 144", 144", 32", 66", 66", 66", 66", 144", 144", 144", 50", 50", 81", 81", 132", 132", 132", 168", 196". In the real world my goal is to minimize the wastage. So it will end up similar to this results. #1 - 70" = 66", with 4" wastage #2 - 100" = 66", 32" with 2" waste