Inform : Jurnal Ilmiah Bidang Teknologi Informasi dan Komunikasi Vol.
10 No.
2 July 2025.
P-ISSN : 2502-3470.
E-ISSN : 2581-0367 Development of Material Requisition System Application Using Rapid Application Development Methodology in Fast-Moving Consumer Goods Companies Anastasia Lidya Maukar1.
Catherina Maraya Palobo2 Industrial Engineering Department.
President University.
Indonesia almaukar@president.
id (*) palobo@student.
Received: 2025-01-20.
Accepted: 2025-04-29.
Published: 2025-01-06 AbstractAi Efficient material requisition and tracking are essential for manufacturing operations, particularly in high-volume production 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.
KeywordsAi Material Requisition.
Material Tracking Visibility.
Rapid Application Development.
ERP System.
System Integration.
Operational Efficiency.
Business Process Analysis.
transformation in materials management .
Although effective in improving supplier communication, the system did not provide real-time integration with ERP systems.
Similarly, .
proposed a First-in.
First-out (FIFO)-based raw material control system in the food manufacturing industry.
This system provided efficiency in stock management but was not designed to handle dynamic and real-time material requisition processes.
Meanwhile, highlighted the benefits of integrating Material Requirements Planning (MRP) with Enterprise Resource Planning (ERP) systems, particularly in strategic material requirements planning .
However, this approach did not focus on the direct material requisition process that is tactical and responsive to field needs, especially in the context of high-volume FMCG production.
This comparison reveals that no previous research has specifically developed a material requisition system that is directly integrated with an ERP, supports real-time tracking, and is tailored to the dynamic and complex FMCG operational Therefore, this research introduces a novel approach by developing a centralized ERP-based material request system that enables automatic data synchronization, digital approval, and end-to-end real-time request monitoring across departments.
This approach is expected to address the operational efficiency and data accuracy issues that have not been adequately addressed in previous studies.
The proposed system will be developed using the RAD
model due to the project's limited scope focusing only on the material requisition process in Raw Material Storage-Sub Store
to Production Hall area, the limited time of research, and the urgency to deploy within a short timeframe during peak
INTRODUCTION
Manufacturing industries are faced with intense competition and must continuously improve performance to enhance productivity .
significantly in a multinational Fast Moving Company Goods (FMCG) as a key player in the global economy due to the rapid consumption of products every day .
The Consumer Goods manufacturer located in Cikarang.
Indonesia, has quite a high operational complexity.
There are three production technologies, including moulded, extruded, and cup cone, operated through 17 production lines.
This factory can produce up to 100,000 pieces of product per daily Efficient material requisition and tracking are crucial for managing delays in material supply within the production line, which can be caused by additional material requirements resulting from machine breakdowns, preparation for the next production cycle, changeovers, and oversupply.
Currently, the material requisition process is based on a non-standard request WhatsApp communication lacks real-time visibility, making it difficult to track the location and status of materials .
Additionally, the administrator must manually input requests from WhatsApp into the Enterprise Resource Planning (ERP) system, resulting in production delays while waiting for the transfer order to be processed by the ERP system.
It also results in inaccuracies in inventory and production data .
and carries security risks because WhatsApp is designed for handling critical industrial data .
Despite ERP implementation, the existing system does not fully address the specific needs of real-time requirements in the FMCG environment.
Several studies have explored digital DOI : https://doi.
org/10.
25139/inform.
Inform : Jurnal Ilmiah Bidang Teknologi Informasi dan Komunikasi Vol.
10 No.
2 July 2025.
P-ISSN : 2502-3470.
E-ISSN : 2581-0367 operations from WE 23 until WE 26 at Line A and Line B during peak season, and this method is suitable for user-driven during the implementation .
Additionally.
Business Process Analysis (BPA) helps understand the flow of the material requisition process.
It identifies processes that need improvement .
Literature Review Several literature reviews support this research using the RAD model, as illustrated in Fig.
project requirements.
While RAD is applied in a general software development context, the study extends the RAD approach to a more specific and demanding environment: the fast-paced and operationally complex FMCG sector.
Integrating RAD with business process analysis and ERP system synchronization, it addresses real-time material demand Fig.
RAD Model .
Microsoft PowerApps: Power Apps is a service, connector, and data platform that provides a fast development environment for building custom applications tailored to business needs.
Using Power Apps enables businesses to design simple mobile apps or web apps without requiring a deep understanding of programming fundamentals.
Users can quickly create custom business applications that connect to data stored on the underlying data platform (Microsoft Datavers.
or across various online and on-premises data sources .
uch as SharePoint.
Microsoft 365.
Dynamics 365.
SQL Server, and so With PowerApps, company employees can create applications similar to those in Microsoft Office.
PowerApps provides a variety of design templates that can be customized to meet specific needs.
The apps that PowerApps generates are also not platform-limited.
The manufacturing process does involve a personal computer (PC), but the result can be an iOS.
Android, or Windows Phone application.
The distribution process only includes a link, and users can collaborate with other employees .
Material Requisition: A material requisition serves as the basis for material procurement, supporting operations and production within a business or manufacturing process.
This function identifies material needs, such as raw materials, packaging, or other supporting goods, including the type of material based on the quantity and timing of the material requirement .
The material requisition process is pivotal in ensuring the smooth operation of the supply chain, as the availability of materials directly impacts the efficient production and timely distribution of products in time-sensitive companies .
Operations in a project or production line are usually allocated for material procurement.
Therefore, an efficient and structured procurement system is needed to minimize waste and ensure the sustainability of the production process .
Flowchart: The flowchart illustrates the steps, sequences, and decisions in a process within a system.
Flowcharts use symbols to show activities, conditions, and logical flows.
The primary function of flowcharts is to document, plan, and communicate complex processes into diagrams .
Flowcharts are created using standard symbols that have their meanings.
Business Process Analysis: Business process analysis, the first key to total cost management, is a fundamental technique for understanding, analyzing, and improving business unit performance.
The business unit as a collection of processes rather than a collection of individual functions .
Apart from focusing on customer satisfaction, this technique also aims to shorten waiting times and minimize costs.
The analysis begins with developing a business process model, creating an activity definition, and then conducting a process value analysis to make an improvement plan .
System Integration and Real-time Visibility: Integrating the material requisition system with the ERP system allows FMCG companies to achieve real-time visibility by utilizing order transfer and goods movement data .
The system can display real-time information such as material location and delivery status.
In this way, companies can optimize material flow and increase efficiency .
Rapid Application Development (RAD): RAD is a software development model that emphasizes a short development cycle .
Fig.
1 shows the process or stages involved in the RAD model.
It is divided into four stages, including the Quick Design Build.
Demonstrate.
Refine, and Launch/Completion phases.
Recent developments in software engineering have demonstrated the increasing relevance of the RAD model when combined with modern development platforms.
A recent study .
introduces the RE4NCD framework, which illustrates how RAD principles can be effectively applied in a no-code environment to accelerate development cycles and enhance stakeholder The framework supports rapid prototyping, user feedback, and rapid iteration, which aligns with dynamic .
Impact-Effort Matrix: The Impact and Effort Matrix quadrant in Fig.
2 serves as a decision-making aid to prioritize projects and manage time more efficiently.
It can be applied to groups of ideas, strategies, and projects to evaluate and prioritize them based on the effort required and potential positive benefits.
Lean Six Sigma teams utilize the matrix to make informed decisions when faced with various options for solving business problems .
This matrix is often used to set project priorities at the start of a project.
Reference .