Integrated Information System of Material Resource Planning and Supply Chain Procurement



Material Resource Planning (MRP), Supply Chain, Bill of Material (BoM), Algorithm, Information System


This paper presents the design and implementation of an integrated information system of Material Resource Planning (MRP) and Supply Chain Procurement (SCP). It considers the process business in a local automotive component manufacturer. Due to the mass customization and complex supply chain, which must be considered in the MRP explosion calculation and the SCP distribution of sales orders, human errors are inevitable. Such errors lead to supply chain procurement problems with the subject company. Based on the Pareto of the problems, there were three major issues (wrong entry of sales orders, wrong entry of purchase orders, wrong calculation of order distribution). These significant issues contributed to 50.0% of the problems on average. The objective of this study was to solve the issues in the subject company through the design and implementation integrated information system with an open-source software platform, which utilizes generic Bill-of-Materials (BoM) and supply chain distribution algorithms. This approach ensures a valid calculation of efficient supply chain processes. The combined approach in the subjected business process yielded satisfactory results with reduced significant issues to 12.5% for the stated problems. Hence, the design objective was achieved.


Author Biographies

Santo Wijaya, Politeknik Meta Industri Cikarang

Department of Computer Engineering

Marta H.R.S.R. Sari, Politeknik Meta Industri Cikarang

Department of Industrial Engineering

Yeyeh Supriatna, PT. Trimitra Chitrahasta

Department of Purchasing


S. Wijaya, S. Hariyadi, F. Debora, and G. Supriadi, “Design and Implementation of Poka-Yoke System in Stationary Spot-Welding Production Line Utilizing Internet-of-Things Platform,” J. ICT Res. Appl., vol. 14, no. 1, p. 34, Jul. 2020, doi: 10.5614/itbj.ict.res.appl.2020.14.1.3.

I. M. Ambe and J. A. Badenhorst-Weiss, “An automotive supply chain model for a demand-driven environment,” J. Transp. Supply Chain Manag., vol. 5, no. 1, pp. 1–22, 2011, doi: 10.4102/jtscm.v5i1.18.

B. Swiecki and R. J. Gerth, “Collaboration in the Automotive Supply Chain - Realizing the Full Potential of a Powerful Tool,” 2008, Accessed: Jun. 24, 2021. [Online]. Available:

Stevenson, Operations management, 10th ed. Boston: McGraw-Hill, 2009.

A. O. Aydin and A. Güngör, “Effective relational database approach to represent bills-of-materials,” Int. J. Prod. Res., vol. 43, no. 6, pp. 1143–1170, 2005, doi: 10.1080/00207540512331336528.

G. Da Silveira, D. Borenstein, and F. S. Fogliatto, “Mass customization: Literature review and research directions,” Int. J. Prod. Econ., vol. 72, no. 1, pp. 1–13, 2001, doi: 10.1016/S0925-5273(00)00079-7.

K. A. Olsen, P. Sætre, and A. Thorstenson, “A procedure-oriented generic Bill of Materials,” Comput. Ind. Eng., vol. 32, no. 1, pp. 29–45, 1997, doi: 10.1016/s0360-8352(96)00058-7.

F. K. Pil, “InQSEEL Linking Product to Order-Fulfillment,” Strategies, vol. 34, no. 5, pp. 394–403, 2012.

C. Chatras, V. Giard, and M. Sali, “High variety impacts on Bill of Materials structure: Carmakers case study,” IFAC-PapersOnLine, vol. 28, no. 3, pp. 1067–1072, 2015, doi: 10.1016/j.ifacol.2015.06.225.

B. N. Sari, O. Komarudin, T. N. Padilah, and M. Nurhusaeni, “Bill of Material in Bonded Zone Inventory for Material Movement Tracking,” Ilk. J. Ilm., vol. 10, no. 3, pp. 323–330, 2018, doi: 10.33096/ilkom.v10i3.381.323-330.

D. Cahyono, “Standard Bill of Material Quantity Genset Information System at PT Conductorjasa Suryapersada,” J. Inf., vol. 2, no. 2, pp. 1–5, 2017, doi: 10.25139/ojsinf.v2i1.404.

S. Wijaya, G. Supriadi, F. Debora, and P. Y. D. Arliyanto, “Inhouse Quality Check System Improvement with Kanban System and Analysis Quality Control Circle,” Oper. Excell., vol. 13, no. 1, pp. 22–35, 2021, doi: 10.22441/oe.2021.v13.i1.003.

I. Taufan and A. Santoso, “Information System Design for Tracking and Tracing in Warehouse using QR Technology,” J@Ti Undip, vol. 16, no. 2, pp. 102–108, 2021, doi: 10.14710/jati.16.2.102-108.

M. Dani Chairudin, N. B. Ginting, and H. Fajri, “Information System for Selection of Production Line for Plastic Item Injection Machine Number A36 Using Priority Scheduling Method,” INTENSIF, vol. 4, no. 2, pp. 232–246, 2020.

A. Schwegmann and M. Laske, “As-is Modeling and Process Analysis,” in Process Management, Springer Berlin Heidelberg, 2003, pp. 107–133.

A. Lodhi, G. Kassem, V. K̈ppen, and G. Saake, “Building AS-IS process models from task descriptions,” Proc. 8th Int. Conf. Front. Inf. Technol. FIT’10, 2010, doi: 10.1145/1943628.1943642.

S. Chung, D. Won, S. H. Baeg, and S. Park, “Service-oriented reverse reengineering: 5W1H model-driven re-documentation and candidate services identification,” in IEEE International Conference on Service-Oriented Computing and Applications, SOCA’ 09, 2009, pp. 178–183, doi: 10.1109/SOCA.2009.5410445.

H. Zhang, “Development of cost management and aided decision system for casting enterprises based on ERP,” ITM Web Conf., vol. 17, p. 03010, 2018, doi: 10.1051/itmconf/20181703010.

J. Jiao, M. M. Tseng, Q. Ma, and Y. Zou, “Generic Bill-of-Materials-and-Operations for High-Variety Production Management,” Concurr. Eng. Res. Appl., vol. 8, no. 4, pp. 297–321, 2000, doi: 10.1177/1063293x0000800404.

A. Michael Schwarz, “Trends in the Automotive Industry Implications on Supply Chain Management,” 2008.

C. Lizette Garay-Rondero, J. Luis Martinez-Flores, N. R. Smith, S. Omar Caballero Morales, and A. Aldrette-Malacara, “Digital supply chain model in Industry 4.0 DSC model in Industry 4.0,” J. Manuf. Technol. Manag., vol. 31, no. 5, pp. 1741–1779, 2020, doi: 10.1108/JMTM-08-2018-0280.

S. Wijaya, F. Debora, G. Supriadi, and I. Ramadhan, “A Framework of e-Kanban System for Indonesia Automotive Mixed-Model Production Line,” Int. J. Sci. Res., vol. 8, no. 6, pp. 2109–2117, 2019.

S. Nidhra, “Black Box and White Box Testing Techniques - A Literature Review,” Int. J. Embed. Syst. Appl., vol. 2, no. 2, pp. 29–50, 2012, doi: 10.5121/ijesa.2012.2204.


Abstract 61  .