The purpose of Material Requirements Planning (MRP) in the model is the timely inventory replenishment based on the forecasted inventory and safety stock levels.
To plan a replenishment order, the MRP policy makes certain calculations and prepares a special daily report table, which allows it to define if a facility needs to place an order:
Note: The table below is a graphical representation of how MRP policy works. This table is not available in ALX interface. All calculations are done in the background. Further details are provided for clarification purposes only.
Estimating inventory replenishment
e.g. If Expected lead time is set to 5, and day N is the day with index 7, then the replenishment order is expected to be placed on day with index 7 - 5 = 2.
The inventory forecast is made for the number of days specified in the Days for report creation parameter except the report creation day (day index: 0).
It is calculated as:
Note: Inventory for the previous day (as well as for any other day) is the inventory level at the beginning of the day before demand forecast is appliedSafety stock estimation
Safety stock is estimated for each day of the report. It is based on the forecast and MRP Policy parameters.
There are two options of safety stock estimation:
Safety stock = Round((Forecast for safety stock horizon/Safety stock horizon) * Days of safety stock),
MRP policy estimates the size of the replenishment order by:
The policy calculates the day on which the replenishment order must be placed only if such order is required, i.e. if the N day has been forecasted.The order placement day is calculated as N day less ELT days, where:
If calculations show that the order must be placed today (the day, when calculations are made) or any day before today, the policy will tell the facility to place the real replenishment order for the required amount. Otherwise, the order will not be placed.
The policy can aggregate orders for the number of days specified in the Aggregation period, days parameter.
Having defined the order placement day, the policy will consider the Aggregation period, days parameter to see if order aggregation is required. If the parameter's value is greater than zero the policy will aggregate all orders within the specified number of days.Orders aggregation
E.g. If the parameter's value is 5, the policy will aggregate all orders that are expected to be placed within 5 days (i.e. today and the next four days) to place one big order today.
Having prepared the aggregated order, the policy sets the number of orders for each day of the aggregated period to 0 to not consider them again when processing data for the next ordering day.
Finally, the policy moves on to the next order placement day to proceed from step 2 of this scenario.
MRP policy example
MRP policy example with aggregation of orders