Development of Material Requisition System Application Using Rapid Application Development Methodology in Fast-Moving Consumer Goods Companies

Authors

  • Anastasia Lidya Maukar
  • Catherina Maraya Palobo

DOI:

https://doi.org/10.25139/inform.v10i2.9647

Keywords:

Material Requisition, Material Tracking Visibility, Rapid Application Development, ERP System, System Integration, Operational Efficiency, Business Process Analysis

Abstract

Efficient material requisition and tracking are essential for manufacturing operations, particularly in high-volume production environments. Currently, at a Consumer Goods manufacturer in Cikarang, Indonesia, the material requisition process is based on a non-standard request process through WhatsApp communication, lacks real-time tracking visibility, and requires manual data entry into the ERP system, leading to an average processing time of 9,122 seconds for material requests and 8,681 seconds for material returns. This research aims to develop a centralized Material Requisition System that is integrated with the existing company ERP system, while enhancing real-time material tracking and monitoring. The system is developed using the Rapid Application Development (RAD) methodology, Business Process Analysis (BPA), and an impact-effort matrix, incorporating problem mapping and field observations, as well as user interviews, to ensure alignment with operational requirements. The implemented system demonstrated a 49% reduction in material request processing time, decreasing from 9,122 seconds to 4,675 seconds, and a 75% reduction in material return processing time, reducing from 8,681 seconds to 2,189 seconds. The system eliminated manual data entry into the ERP system and provided end-to-end visibility of materials tracking across the material requisition process. These results highlight the effectiveness of automated and integrated systems in improving operational efficiency within FMCG manufacturing.

References

O. O. David, E. N. Ekene, C. O. Onyeka, and E. U. Chinonye, "Strategic Operations Management in FMCG: a Comprehensive Review of Best Practices and Innovations," International Journal of Management & Entrepreneurship Research, vol. 6, no. 3, pp. 780–794, Mar. 2024, doi: 10.51594/ijmer.v6i3.935.

U. S. Nwabekee, O. Y. Abdul-Azeez, E. E. Agu, and T. I. Ijomah, "Innovative sustainability initiatives in the FMCG industry: A review of challenges and successes," International Journal of Applied Research in Social Sciences, vol. 6, no. 9, pp. 1990–2017, Sep. 2024, doi: 10.51594/ijarss.v6i9.1539.

A. E. Adegbola, M. D. Adegbola, P. Amajuoyi, L. B. Benjamin, and Kudirat Bukola Adeusi, "Advanced financial modeling techniques for reducing inventory costs: A review of strategies and their effectiveness in manufacturing," Finance & Accounting Research Journal, vol. 6, no. 6, pp. 801–824, Jun. 2024, doi: 10.51594/farj.v6i6.1180.

S. Fauziyah, M. N. Sholeh, B. Dharmo, P. Purba, and Sutanto, "Material tracking system of the supply chain in engineering procurement construction (EPC)," AIP Conf Proc, vol. 2114, no. 1, pp. 1–8, 2019, doi: 10.1063/1.5112411.

T. V. Estefania, L. Samir, P. Robert, D. Patrice, and M. Alexandre, "The integration of ERP and inter-intra organizational information systems: A Literature Review," IFAC-PapersOnLine, vol. 51, no. 11, pp. 1212–1217, 2018, doi: 10.1016/j.ifacol.2018.08.425.

O. O. Oluwaseun and S. O. Dagogo, "WhatsApp Data Policy, Data Security and Users' Vulnerability," International Journal of Innovative Research and Development, vol. 12, no. 4, pp. 45–52, May 2023, doi: 10.24940/ijird/2023/v12/i4/APR23021.

A. P. U. Siahaan, R. Rahim, S. Aryza, H. Djanggih, N. Kurniasih, and A. P. Buana, "Insecure Whatsapp Chat History, Data Storage and Proposed Security," International Journal of Pure and Applied Mathematics, vol. 119, no. 16, pp. 2481–2486, Jul. 2018, doi: 10.31227/osf.io/2sbfc.

A. O. Adedeji, A. Y. S., and A. Oluwafikunmi, "Web-based material requisition system in the supply chain of construction businesses," International Journal of Electrical and Computer Engineering (IJECE), vol. 11, no. 2, pp. 1531–1538, Apr. 2021, doi: 10.11591/ijece.v11i2.pp1531-1538.

I. Hakim, Asdi, E. Sutisman, M. Rizki, and P. A. Cakranegara, "Implementation of Raw Material Control Management System in Food Factories. Enrichment : Journal of Management," Enrichment : Journal of Management, vol. 12, no. 5, pp. 3965–3974, 2022.

SAP, 'What is MRP? The Key to Efficient Manufacturing | SAP,." Accessed: Apr. 13, 2025.

N. Singh and A. Hussain, "Rapid Application Development in Cloud Computing with IoT," in IoT and AI Technologies for Sustainable Living, Boca Raton: CRC Press, 2022, pp. 1–28. doi: 10.1201/9781003051022-1.

Q. Wu, Z. He, H. Wang, L. Wen, and T. Yu, "A Business Process Analysis Methodology Based on Process Mining for Complaint Handling Service Processes," Applied Sciences, vol. 9, no. 16, pp. 1–21, Aug. 2019, doi: 10.3390/app9163313.

M. A. Yulianto, Y. Hadi, and S. Noya, “Perancangan Sistem Order Material pada Supporting Department di PT XYZ dengan Metode System Development Life Cycle,” Jurnal Sains dan Aplikasi Keilmuan Teknik Industri (SAKTI), vol. 3, no. 2, pp. 109–120, Dec. 2023, doi: 10.33479/jtiumc.v3i2.69.

E. A. Kelvin and O. Chiyem, "Materials Management and Productivity of Fast Moving Consumer Goods Companies in Nigeria: A canonical Correlation Approach," Journal of Management and Social Science Research, vol. 1, no. 1/2, pp. 34–42, 2020, doi: 10.47524/jmssr.11.5.

I. Lukyanova, A. Haddud, and A. Khare, "Types of ERP Systems and Their Impacts on the Supply Chains in the Humanitarian and Private Sectors," Sustainability, vol. 14, no. 20, p. 13054, Oct. 2022, doi: 10.3390/su142013054.

S. Alansari and A. Mishra, "Inventory System Transition Towards ERP," 2019 1st International Informatics and Software Engineering Conference (UBMYK), vol. 19, no. 1, pp. 1–6, Nov. 2019, doi: 10.1109/UBMYK48245.2019.8965516.

Y. A. Singgalen, "Coastal and Marine Tourism Monitoring System Design using Rapid Application Development (RAD)," Journal of Information System Research, vol. 5, no. 2, pp. 468–479, 2024, doi: 10.47065/josh.v5i2.4720.

Y. Yumhi, D. Dharmawan, W. Desty Febrian, A. J. Sutisna, and Syahribulan, "Application of Rapid Application Development Method in Designing a Knowledge Management System to Improve Employee Performance in National Construction Company," Jurnal Informasi dan Teknologi, vol. 6, no. 1, pp. 155–160, Jan. 2024, doi: 10.60083/jidt.v6i1.491.

M. Levy and I. Hadar, "Requirements Engineering for No-Code Development (RE4NCD)," Springer, vol. 14588, pp. 322–329, 2024, doi: 10.1007/978-3-031-57327-9_20.

Tapanm-Msft, "What is Power Apps? - Power Apps." [Online]. Available: https://learn.microsoft.com/en-us/power-apps/powerapps-overview

Z. U. Armaya'u, M. M. Gumel, and H. S. Tuge, "Comparing Flowchart and Swim Lane Activity Diagram for Aiding Transitioning to Object-Oriented Implementation," American Journal of Education and Technology, vol. 1, no. 2, pp. 88–106, Sep. 2022, doi: 10.54536/ajet.v1i2.612.

A. Hoang, K. Van Phan, and V. K. Solanki, "Research Trends on Business Process Management in Higher Education and Recommendations for Vietnam," International Journal of Information Technology and Web Engineering, vol. 17, no. 1, pp. 1–21, Dec. 2022, doi: 10.4018/IJITWE.315609.

J. Antony, R. Snee, and R. Hoerl, "Lean Six Sigma: yesterday, today and tomorrow," International Journal of Quality & Reliability Management, vol. 34, no. 7, pp. 1073–1093, Aug. 2017, doi: 10.1108/IJQRM-03-2016-0035.

E. Ilbahar, C. Kahraman, and S. Cebi, "Evaluation of sustainable energy planning scenarios with a new approach based on FCM, WASPAS and impact effort matrix," Environ Dev Sustain, vol. 25, no. 10, pp. 11931–11955, Oct. 2023, doi: 10.1007/s10668-022-02560-8.

H. C. Hasni and S. Suhaimi, "Pet Feeding System," International Journal of Recent Technology and Applied Science, vol. 4, no. 2, pp. 112–119, Sep. 2022, doi: 10.36079/lamintang.ijortas-0402.400.

I. W. R. Taifa and T. N. Vhora, "Cycle time reduction for productivity improvement in the manufacturing industry," JIEMS Journal of Industrial Engineering and Management Studies, vol. 6, no. 2, pp. 147–164, 2019, doi: 10.22116/JIEMS.2019.93495.

Z. Hui, "Research on Performance Testing Technology Based on Scenario Design," J Phys Conf Ser, vol. 1883, no. 1, pp. 1–6, Apr. 2021, doi: 10.1088/1742-6596/1883/1/012044.

O. Abdul-Azeez, A. O. Ihechere, and C. Idemudia, "Enhancing business performance: The role of data-driven analytics in strategic decision-making," International Journal of Management & Entrepreneurship Research, vol. 6, no. 7, pp. 2066–2081, Jul. 2024, doi: 10.51594/ijmer.v6i7.1257.

Downloads

Published

2025-07-06

How to Cite

Maukar, A. L. ., & Palobo, C. M. (2025). Development of Material Requisition System Application Using Rapid Application Development Methodology in Fast-Moving Consumer Goods Companies. Inform : Jurnal Ilmiah Bidang Teknologi Informasi Dan Komunikasi, 10(2), 136–145. https://doi.org/10.25139/inform.v10i2.9647

Issue

Vol. 10 No. 2 (2025)

Section

Articles

License

Authors who publish with Inform: Jurnal Ilmiah Bidang Teknologi Informasi dan Komunikasi agree to the following terms:

  1. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License (CC BY-SA 4.0) that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal. 

  2. 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.

  3. 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.