Trying to minimize leftovers to be as close as possible to 0 but not negative by shifting inventories around
Inventory qty can only move horizontally (i.e., Inventory 1 can't move to inventory 2 or 3)
Inventory qty is already given, each qty is treated as a whole and can't be combined or merged or added or removed

From this:
2pa05o7qa8y21.png

To this:
r2dh9n02n8y21.png

It's like taking a snapshot of inventory and relocating them so that the leftovers for each month is as close to 0 as possible.

I've tried something like this but it doesn't seems to work because it's merging the inventories together by adding the qty and it's only moving to the right..

Please Login or Register  to view this content.
Appreciate the help.