Material Requirement Planning Information System: Prototype And Lead Time Analysis
Abstract
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.
Abstract views: 2006 times
Download PDF: 1095 times
Copyright (c) 2023 Journal of Information Systems and Informatics
This work is licensed under a Creative Commons Attribution 4.0 International License.
- I certify that I have read, understand and agreed to the Journal of Information Systems and Informatics (Journal-ISI) submission guidelines, policies and submission declaration. Submission already using the provided template.
- I certify that all authors have approved the publication of this and there is no conflict of interest.
- I confirm that the manuscript is the authors' original work and the manuscript has not received prior publication and is not under consideration for publication elsewhere and has not been previously published.
- I 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.
- I confirm that the paper now submitted is not copied or plagiarized version of some other published work.
- I declare that I shall not submit the paper for publication in any other Journal or Magazine till the decision is made by journal editors.
- If the paper is finally accepted by the journal for publication, I confirm that I will either publish the paper immediately or withdraw it according to withdrawal policies
- I Agree that the paper published by this journal, I transfer copyright or assign exclusive rights to the publisher (including commercial rights)
_1.png){kind=logo}
