Material Requirement Planning Information System: Prototype And Lead Time Analysis

  • Mikhael Billy Tanaga Universitas Multimedia Nusantara, Indonesia
  • Raymond Sunardi Oetama Universitas Multimedia Nusantara, Indonesia
Keywords: Web Application, User Acceptance Testing, Scheduling, Reporting, Material requirement planning


In the pharmaceutical manufacturing industry, efficient and accurate production processes ensure quality products and meet customer demands. However, many companies still rely on manual systems, such as Microsoft Excel, which can lead to challenges and inefficiencies. The problems identified include a lack of integration between product data and manufacturing documents, error-prone manual data entry, document mix-ups, and time-consuming processes. The study aimed to design and implement a web-based material requirement planning system to address the challenges of a manual manufacturing system in a pharmaceutical company. The objectives were to improve integration, streamline production processes, and reduce lead time for enhanced operational efficiency. The study employed a prototyping approach to design and develop a web-based material requirement planning system. User feedback and requirements guided iterative design cycles, while User Acceptance Testing evaluated system performance and usability. The impact on operational efficiency was assessed by measuring lead time before and after implementation. The implemented web-based material requirement planning system successfully resolved integration issues, reduced manual data entry errors, and minimized document mix-ups within the pharmaceutical manufacturing company. User Acceptance Testing achieved a 100% average percentage. The lead time was improved from 207-251 minutes to 122-159 minutes, demonstrating enhanced operational efficiency.


Download data is not yet available.


G. Tsaramirsis et al., "A modern approach towards an industry 4.0 model: From driving technologies to management," J. Sensors, vol. 2022, pp. 1–18, 2022.

P. Yosevine, R. S. Oetama, J. Setiawan, and E. Princes, "Enterprise Resource Planning (ERP) Evaluation and Implementation: A Case Study," J. Multidiscip. Issues, vol. 1, no. 1, pp. 49–66, 2021, doi: 10.53748/jmis.v1i1.10.

I. Jackson, J. Tolujevs, and Z. Kegenbekov, "Review of inventory control models: a classification based on methods of obtaining optimal control parameters," Transp. Telecommun., vol. 21, no. 3, pp. 191–202, 2020.

O. El Hairech and A. Lyhyaoui, "The New Generation of ERP in the Era of Artificial Intelligence and Industry 4.0," in International Conference on Advanced Intelligent Systems for Sustainable Development, 2020, pp. 1086–1094.

M. N. Salur and W. K. Kattar, "The impact of enterprise resource planning (ERP) on the audit in the context of emerging technologies," Ekon. Maliye İşletme Derg., vol. 4, no. 2, pp. 115–123, 2021.

M. Al-Amin, T. Hossain, J. Islam, and S. K. Biwas, "History, Features, Challenges, and Critical Success Factors of Enterprise Resource Planning (ERP) in The Era of Industry 4.0," Eur. Sci. Journal, ESJ, vol. 19, no. 6, p. 31, 2023.

A. Faccia and P. Petratos, "Blockchain, enterprise resource planning (ERP) and accounting information systems (AIS): Research on e-procurement and system integration," Appl. Sci., vol. 11, no. 15, p. 6792, 2021.

J. K. F. Sitanggang and I. Muda, "The Conversion Cycle: Review of Material Requirements Planning (MRP)," in ICSST 2021: Proceedings of the 1st International Conference on Social, Science, and Technology, ICSST 2021, 25 November 2021, Tangerang, Indonesia, 2022, p. 151.

V. A. Budiono, L. Gozali, and I. W. Sukania, "Production and Capacity Planning as well as Inventory and Distribution Control in Snack Packaging Companies Using Open Source ERP Simulation," in 2023 19th IEEE International Colloquium on Signal Processing & Its Applications (CSPA), 2023, pp. 64–69.

J. B. Munyaka and V. S. S. Yadavalli, "Inventory management concepts and implementations: a systematic review," South African J. Ind. Eng., vol. 33, no. 2, pp. 15–36, 2022.

N. Hasanati, E. Permatasari, N. Nurhasanah, and S. Hidayat, "Implementation of material requirement planning (MRP) on raw material order planning system for garment industry," in IOP Conference Series: Materials Science and Engineering, 2019, vol. 528, no. 1, p. 12064.

J. Saravanan and J. J. Thakkar, "An integrated approach for lead time reduction of military aircraft major overhaul: A case of ABC Company," Int. J. Qual. Reliab. Manag., vol. 35, no. 1, pp. 2–33, 2018, doi: 10.1108/IJQRM-07-2015-0102.

G. Rajesh, "Implementation of a Lean Model in Manufacturing Industry," Int. J. Ind. Eng., vol. 2, no. 1, pp. 10–14, 2015, doi: 10.14445/23499362/ijie-v2i2p103.

A. Palange and P. Dhatrak, "Lean manufacturing a vital tool to enhance productivity in manufacturing," Mater. Today Proc., vol. 46, pp. 729–736, 2021.

N. M. Modak and P. Kelle, "Managing a dual-channel supply chain under price and delivery-time dependent stochastic demand," Eur. J. Oper. Res., vol. 272, no. 1, pp. 147–161, 2019, doi: 10.1016/j.ejor.2018.05.067.

A. L. Hananto, B. Priyatna, and A. Haris, "Application of prototype method on student monitoring system based on WEB," Buana Inf. Technol. Comput. Sci. (BIT CS), vol. 1, no. 1, pp. 1–4, 2020.

M. Meloni et al., "Engineering origami: A comprehensive review of recent applications, design methods, and tools," Adv. Sci., vol. 8, no. 13, p. 2000636, 2021.

D. A. N. Wulandari, A. A. H. Bahar, M. G. Arfananda, and H. Apriyani, “Prototyping Model In Information System Development Of Al-Ruhamaa’Bogor Yatim Center Foundation,” J. Pilar Nusa Mandiri, vol. 17, no. 2, pp. 127–136, 2021.

J. Wiratama and F. A. T. Tobing, "Analysis and Design of an Web-Based Ticketing Service Helpdesk at Food and Packaging Machinery Company," Ultim. InfoSys J. Ilmu Sist. Inf., vol. 13, no. 1, pp. 19–28, 2022, doi: 10.31937/si.v13i1.2656.

Z. Ajab Mohideen, A. Sheikh, and K. Kaur, "Developing an open source mobile app in library services: the case of a national university in Malaysia," Digit. Libr. Perspect., vol. 38, no. 3, pp. 283–300, 2022.

M. A. Sellitto, "Lead-time, inventory, and safety stock calculation in job-shop manufacturing," Acta Polytech., vol. 58, no. 6, pp. 395–401, 2018.

S. H. Arnob, R. I. Atik, M. A. Ahmed, and S. M. Hassan, "Lead Time Optimization of RMG Sector Supply Chain in," Supply Chain Insid. ISSN 2617-7420, vol. 04, no. 01, pp. 5–11, 2020.

Abstract views: 75 times
Download PDF: 78 times
How to Cite
Tanaga, M., & Oetama, R. (2023). Material Requirement Planning Information System: Prototype And Lead Time Analysis. Journal of Information Systems and Informatics, 5(3), 848-859.