In this scenario, we will use MRP and Finite Capacity Scheduling of Asprova – how to import the manufacturing order for the production and inventory from TSV files and how to auto-replenish the manufacturing order for parts and schedules.
After importing the manufacturing order for the production and inventory of parts, the manufacturing order for “A” will be created automatically by MRP. It is important to input the manufacturing order for Item “A” from ERP. But first, we need to know the inventory of “A” in order to run the MRP.
Open the file “25.04 Scenario 2 – Use MRP and finite capacity scheduling of Asprova” as shown in the figure below.
The table below shows the data settings for inventory of “A”.
The contents of the TSV file for planned order is the same as Scenario 1.
The order code is “Inventory 1”. The item code is “A”. The due date is June 3rd. The quantity is 1000.
Open the Order table and import the TSV file. The inventory order can be seen in the order table. The Order code is “Inventory 1” and the Order type is set as “Inventory (absolute)”.
The order type can be changed to “Inventory (absolute)” by Import property conversion expression in the Data I/O table.
You may refer to the Online Help if you want to know the details about expressions.
In the Item table, switch the Auto-replenish flag of “A” to “Yes”. Then, run the Reschedule button.
You will then see that a manufacturing order has been auto-created in the Order table. The order quantity for Item “A” is 5000.
Check the Resource Gantt chart to see the results. This Inventory order is seen in the chart below. 1000 items will be used in Order 2. The shortage of 2000 items will be supplied by an auto-replenished manufacturing order.
Go to the Inventory Graph – the inventory of Item “A” is displayed.
It is 1000 at first, and increases to 6000. Then 3000 items will be used and the quantity will be decreased to 3000.
Please refer to this page to find the details about auto-replenishment.
To learn more about Asprova specific to this sample demonstration, you may visit Asprova’s online help and its e-Learning videos at http://lib.asprova.com/ (see 25. ERP Interface).