Residual Distribution System in Excel (VBA)
Desktop Apps
Task: Create from zero and automatize the mathematical residual re-distribution algorithm between trade facilities for equalization of goods.
The main complexity: to write the logic of how much and where to take and where to take, taking into account the economic essence (the smallest number of movements on collection, transportation)
Volume: up to 500 SKU at the same time, more than a hundred trading facilities.
There are additional settings, a step-by-step calculation is possible (to optimize the distribution manually)
Result: Create files to send to each network store with instructions
#Excel #Macros #VBA #VisualBasicForApplications
The main complexity: to write the logic of how much and where to take and where to take, taking into account the economic essence (the smallest number of movements on collection, transportation)
Volume: up to 500 SKU at the same time, more than a hundred trading facilities.
There are additional settings, a step-by-step calculation is possible (to optimize the distribution manually)
Result: Create files to send to each network store with instructions
#Excel #Macros #VBA #VisualBasicForApplications