Solver? to determine sequencing in inventory management problem

I've set up a solver model based on your uploaded file. There are certainly more combinations but in the end it boils down to the fact that you have orders
for 32962 units and you production is 35000 so all the best (min waste) solution will have an excess of 2038 units.

Advantage with the solver setup is that solver found a solution in less than 10 seconds.

Alf