Supply distribution maximizing transshipment hub utilization while optimizing supply, demand, cost and transshipment capacity
This Micro App takes 7 inputs and generates the output plan with the following outputs:
- "Allocated" supply by location, item, demand ID, demand type, date and priority
- "Short" demand quantity that cannot be allocated by location, item, demand ID, demand type, date and priority
- Inventory "On-Hand" projection (inventory plan) based on the supply-demand pegging
- "Transfer out Qty/Cost" - this is the quantity that will shipped out from source location to meet the demand at destination
- "Transfer in Qty/Cost" - this is the quantity that will received at least cost, at destionation location from external supply/source
- "Safety Warning" - When on-hand quantity is below safety stock level
- "Excess Warning" - When on-hand quantity exceeds cycle stock level
Run Time: up to 5 minutes (depends on input file sizes)
Sample Demand.csv Sample Onhand.csv
Sample Supply.csv Sample Routing.csv Sample TransShipment Capacity.csv
All the form inputs are mandatory (limited to 25,000 rows of data in each file). Sample files are provided above to generate the input files.
The following features are being worked on for the next version of this App:
1. Additional error handling with intuitive responses
2. Min, incremental lot constraints
3. Distribution with lead times and distribution BOM
4. Production with production parameters including build ahead/late, BOM, lead time, etc.
5. Analytics/graphical representation