Supply planning and distribution based on cost and availability, to maximize demand fulfilment
This Micro App takes 6 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
Run Time: up to 1 minute (depends on input file sizes)
Sample Demand.csv Sample Onhand.csv
Sample Supply.csv Sample Routing.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