In this example we will assume that one of the sites of your supply chain is using the Material Requirements Planning policy to timely replenish its inventory.
All further calculations will be based on the MRP policy, which is configured in the following way:
Note: Policy parameters are described here.
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:
A report period in this case is the period of time for which the policy evaluates the risk of inventory dropping below the safety stock level. The policy checks the Days for report creation parameter, which is set to 10 in our case. This means that the policy will create a report for 10 days.
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.
Current inventory level
The current inventory level is what the facility has in stock on the day when the report is made (by default day index: 0). As you can see on the table extract below, the current inventory constitutes 52.
The inventory for the first day of the report is taken as it is, while for the rest of the days inventory forecasting is required.
On the current step the inventory is calculated in the following way:
day #1 inventory = day #0 inventory - day #0 demand forecast
Safety stock calculation
Since the Safety stock quantity parameter is set to 0, the policy will have to estimate the safety stock for each day.
The safety stock is estimated by the following formula:
Safety stock = Round (( Forecast for safety stock horizon / Safety stock horizon ) * Days of safety stock )
Let us have a closer look at the safety stock estimation for day #1:
Having forecasted the inventory and estimated the safety stock for each day, the policy can define the day on which the replenishment is required. This is done by comparing such values of each day.
If you look at the table extract below, you will see that the inventory is expected to be less than the safety stock on day with index 4.
Order size estimation
Having detected the day on which the replenishment must be received, the policy estimates the amount that must be ordered:
Order size = Demand forecast + Safety stock – Inventory
Let us have a closer look at the order size estimation for day #4:
The report table will be updated with the received data:
Placing replenishment order
Now that it is clear how much to order and when the order is expected to arrive, the policy estimates the day on which the order must be placed.
If calculations show that the order must be placed today (the day with index 0) or any day before today, the policy will tell the facility to place the real replenishment order for the required amount.
In our case the order will not be placed, since calcualtions show that it must be placed on day with index 1, which is tomorrow in terms of our report:
N day less ELT days = 4 - 3 = 1
Aggregation of orders
With the last step the policy checks if it is required to combine orders within the defined period of time into one big order.
In our case aggregation is not required since the Aggregation period, days parameter is not defined.
Note: To learn more about aggregation of orders refer here.
Having completed the required calculations, the MRP policy switches to the next day to calculate the possible safety stock violation in the same way.
MRP policy example with aggregation of orders
MRP policy. How it works