Article Per Year (5 Year)
p-Index From 2020 - 2025
0.23
P-Index
This Author published in this journals
All Journal Jurnal Sains dan Aplikasi Keilmuan Teknik Industri
Pribadi, Marius
Unknown Affiliation
Decision Sciences, Operations Research & Management Economics, Econometrics & Finance Environmental Science Industrial & Manufacturing Engineering Transportation

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

 1 
Designing a Macro-VBA Excel-based Kit List Printing Application for the Supporting Department of PT XYZ Pribadi, Marius; Putrianto, Novenda Kartika; Purnomo, Purnomo
Jurnal Sains dan Aplikasi Keilmuan Teknik Industri (SAKTI) Vol. 3 No. 1 (2023): June 2023
Publisher : Teknik Industri Universitas Ma Chung

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.33479/jtiumc.v3i1.46

Abstract

The recording of raw material orders in PT.XYZ must be done through the embedded ERP system in the company, Microsoft Dynamics GP. However, the system is not perfect as it is not suitable for workers who follow traditional practices. To avoid losing goods, PT XYZ has started implementing kit recording, but a shortage of workers who enter KIT data can lead to human error. To overcome this, PT XYZ can automate the printing of KIT using VBA in Microsoft Excel. VBA allows applications to work more efficiently by easily manipulating object models. Excel macros support VBA programming and enhance the flexibility of the programming language. A well-organized VBA Excel application can produce a KIT list by pulling data from the production order sheet attached to the bus chassis as it moves on the production line. Once the specifications for a bus body to be produced are obtained, the user can edit and click one button to get the KIT that is suitable for that bus. Therefore, VBA in Excel can help PT XYZ improve the recording of raw material orders and reduce human errors that can cause financial losses.
Co-Authors Purnomo Purnomo Putrianto, Novenda Kartika