Hello everyone,
I have raw goods that come into my plant in lengths of 20' and 24'.
Each day I need to cut the raw goods into pieces to fulfill an order.
For example, today I needed the following quantities and lengths...
2 ea. 6'
1 ea. 7'
4 ea. 8'
10 ea. 2'
I am trying to find a way for excel to fulfill this order, given the raw goods lengths, while minimizing the amount of waste. Basically, I want excell to tell me how many raw goods pieces I need to pull and what combination of cuts would lead to the least amount of leftover.
Any thoughts?
Bookmarks