MRP
Material Requirement Planning (MRP) defines what raw materials, components are needed, how much are needed and when they are needed.
​
Python is applied into Planned Order Release calculation.
​
Some factors are taken into account: shelf life, MOQ, raw items are stored at multiple sites
Apply Python in Planned Order Release calculation (P1)
Shelf life
This part takes shelf life into calculation. Shelf life divided my calculation into 3 parts:
- Item has shelf life: Allocate Stock On Hand according to shelf life to each demand period
- Item has shelf life but there is not stock having appropriate expiry date to use in some demand periods
- Item has no shelf life
First part is explained in this post. The following two are in the next post.
Apply Python in Planned Order Release calculation (P2)
PO pending, No shelf life
Taking into account these sources to calculate final Planned Receipt
- PO Pending, stock of raw items having no shelf life
- Net demand of items after allocation (explained in first part) & Demand which is not yet included
Apply Python in Planned Order Release calculation (P3)
Leadtime delivery, MOQ
Based on Planned Receipt, calculate Planned Order Release (urgent order included) and Order under MOQ constraints.
