Material Requirement Planning Information System: Prototype And Lead Time Analysis
DOI:
https://doi.org/10.51519/journalisi.v5i3.535Keywords:
Web Application, User Acceptance Testing, Scheduling, Reporting, Material requirement planningAbstract
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.
Downloads
References
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.
Downloads
Published
Issue
Section
License
Authors Declaration
- The Authors certify that they have read, understood, and agreed to the Journal of Information Systems and Informatics (JournalISI) submission guidelines, policies, and submission declaration. The submission has been prepared using the provided template.
- The Authors certify that all authors have approved the publication of this manuscript and that there is no conflict of interest.
- The Authors confirm that the manuscript is their original work, has not received prior publication, is not under consideration for publication elsewhere, and has not been previously published.
- The Authors confirm that all authors listed on the title page have contributed significantly to the work, have read the manuscript, attest to the validity and legitimacy of the data and its interpretation, and agree to its submission.
- The Authors confirm that the manuscript is not copied from or plagiarized from any other published work.
- The Authors declare that the manuscript will not be submitted for publication in any other journal or magazine until a decision is made by the journal editors.
- If the manuscript is finally accepted for publication, the Authors confirm that they will either proceed with publication immediately or withdraw the manuscript in accordance with the journal’s withdrawal policies.
- The Authors agree that, upon publication of the manuscript in this journal, they transfer copyright or assign exclusive rights to the publisher, including commercial rights
