How to use Excel to determine cutting and reusing stock to fill or
 

Hello,
we have a customer that requires we cut stock to different lengths. I've
seen the cutting stock programs, but they don't address my needs. After
determining the number of cuts I also have to combine the remaining material
to make units.

Example:
I have a 16" piece stock, which can be cut into 4" segments.

Customer requires:
5 units that are 40" 2X16" and adding an 8" piece
3 units that are 36" 2X16" and adding a 4" piece
4 units that are 32" 2X16"
1 unit 28" 1X16" and 1X12" piece
2 units 4" 2X4" pieces

I've been able to determine how many 16" pieces I need to start with, but I
run out of steam when trying to work through using the remaining pieces after
the 1st cut.
thanks
--
Joe