aaron.reese,

tldr; Thanks. I think I implemented something very close to what you are suggesting though my implementation has certain flaws.

Your understanding of the problem is correct...

Drew,

My expected results are contained in the two temporary tables #ItemResults and #SurplusResults.  They represent the results after having offset order quantities with available surplus quantities. If there...