Abstract:
PT. AB Indonesia is a multinational company that located in Cikarang area. One of the products of this company is fashion dolls. In PT. AB Indonesia, soft goods engineering is a division that responsible and produce the costume of the toy. Before the production process begins, there are several documents that need to be made by the soft goods engineer. One of them is flowchart data. Flowchart data is a data that contains yield number of materials, process name and code, machine hour, and etc. In PT. AB Indonesia flowchart data is saved in AS400, the integrated system that PT. AB Indonesia used. Unfortunately, there are several cases of incorrect data of flowchart data in AS400. The flowchart data in AS400 is different compared to the working order sheet. Working order sheet is a base data for engineer to input flowchart data to AS400. These incorrect data are caused by typo during input process, since the input process still be done manually. There are total 5 cases of incorrect data from May 2019 until August 2019. To solve the problem, the new system is created by using System Development Life Cycle (SDLC) methodology, which consists of 5 stages; system planning, system analysis, system design, implementation, and system support. After determined the user requirements and have done the analysis of the current and the proposed system, the system is created by using VBA in Microsoft Excel. The proposed system is implemented from September 2019 until December 2019 and the result of the implementation is there are no more incorrect data in flowchart data and it also reduces the time needed to input the data to AS400. The current system took 8.4 min and the proposed system only took 1.8 min. It means that the proposed system is successfully reach the objective of this research.
