Best practice for supply chain route planning?




I am building a supply chain planning system, which has different order types. Depending on the specific order type it has to hit only specific workcenters in a specific sequence with specific lead times.


I have created a list with the different order combinations, e.g. "ProductA_Wood_Black"

And also a list with the workcenters available throughout the chain, e.g. "Design" "Manufacturing" "Quality Control"


Furthermore I have created a module with the different order combinations as rows and the workcenters columns, for which the line item is lead time in the amount of weeks as well as a boolean line item, that just says "true" if the given item has a lead time stated for it.


I have a weekly demand overview of the different order types that enter the chain in specific weeks, and from there I then need to calculate a forecast for each workcenter in terms of how much is taken in, is in process and is outputted on a weekly basis for every workcenter from start to finish.


I have not found any apps or posts that hint at a best practice solution for accomplishing this. As we frequently have changes (addition/deletion) to the workcenters and the routing throughout them I would like to make the system as smart/flexible as it can possibly be done. Does anyone have any ideas and/or know of a model/source where I can see how to handle this type of challenge? E.g. can I do this in óne module alone? Or do I need modules for each of the workcenters?


Best Answer