Designing a Macro-VBA Excel-based Kit List Printing Application for the Supporting Department of PT XYZ


  • Marius Pribadi Industrial Engineering Universitas Ma Chung
  • Novenda Kartika Putrianto Industrial Engineering Universitas Ma Chung
  • Purnomo Purnomo Industrial Engineering Universitas Ma Chung



VBA Excel, Macro, Material Kitting, Information System


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.


Aryan, G, 2022, Excel Macros: All You Need to Know, [online] via Accessed on December 10, 2022.

Lee, C., 2012, Fungsi LookUp Canggih Excel 2007 dan 2010. Jakarta, PT.Elex Media Komputindo

Luwis, MS Excel Professional Panduan Lengkap Menguasai VBA MACRO, 1st ed. Yogyakarta: Penerbit Gava Media, 2021.

Madcoms, 2008, Microsoft Project 2007 Untuk Pemula. Penerbit : Andi Publisher.

Martono, R. V., 2019, Dasar-Dasar Manajemen Rantai Pasok, PT. Bumi Aksara, Jakarta, Indonesia.

M. Yang and B. Rahardjo, “Perancangan Aplikasi Macro Untuk Meningkatkan Efisiensi Perencanaan Produksi Divisi PPIC,” Vol. 6, no. 2, pp. 339–344, 2018.

Rheude, J., 2021. Guide to Product and Material Kitting. Accessed on December 11, 2022.

Syofyan, A., Rahmalina, D., & Sudiro, S. (2019). Metode kitting pada sistem umpan bahan untuk peningkatan output proses perakitan regulator arm. Jurnal Ilmiah TEKNOBIZ.

Tofik, M, 2012, Aplikasi Persediaan & Penjualan Siap Pakai Dengan Microsoft Office Excel. mediakita.

Wicaksono, Y, 2020, Membuat Aplikasi Stock Barang dengan VBA Macro Excel., Jakarta, PT. Elex Media Komputindo.