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..
Appreciate the help.
Bookmarks