Hi Catalin,
I need your help about an issue.
I want to efficiently distribute some numbers into a maximum value.
Let's say I have a stick with 6meters long, then I want to efficiently use every stick with certain values of cutting sizes so there will not be many scrap.
I want to know how many sticks I will need for that and how is the distribution of cutting sizes in each stick.
Is it possible to make it in excel?
I hope my explanation is clear.
Hi Nur,
Cutting optimization is a complex problem, it's not just a formula. A complex algorithm is needed, see a problem description here: https://www.researchgate.net/publication/228526625_Cutting_optimization_with_variable-sized_stock_and_inventory_status_data
There are a few solution, not all free, like this one: http://www.optimalon.com/length_cutting_excel.htm
Or: https://www.lindo.com/lsmodels/Controller/doSelect.php?action=2&name=CUTTING_STOCK.xls
