Integrated Information System of Material Resource Planning and Supply Chain Procurement
Keywords:
Material Resource Planning (MRP), Supply Chain, Bill of Material (BoM), Algorithm, Information SystemAbstract
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.
References
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: https://www.mendeley.com/catalogue/c606d322-95d8-34ab-a77b-25775a2de553/?utm_source=desktop&utm_medium=1.19.8&utm_campaign=open_catalog&userDocumentId=%7B47bd9b29-cb19-32d9-8245-c931f71f07aa%7D.
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.
Published
Issue
Section
License
Copyright (c) 2022 Santo Wijaya, Marta H.R.S.R. Sari, Yeyeh Supriatna

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Authors who publish with this journal agree to the following terms:
a. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License - Share Alike that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
b. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
c. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.
USER RIGHTS
All articles published Open Access will be immediately and permanently free for everyone to read and download. We are continuously working with our author communities to select the best choice of license options, currently being defined for this journal as follows: Creative Commons Attribution-Share Alike (CC BY-SA)