Perancangan Aplikasi VBA untuk BOM Buy Off dan BOM Converter di PT. PCI Elektronik Internasional

Noviandi, Anugrah Tri (2020) Perancangan Aplikasi VBA untuk BOM Buy Off dan BOM Converter di PT. PCI Elektronik Internasional. Project Report. Universitas Internasional Batam. (Submitted)

Preview	Text k-1721022-abstract-en.pdf Download (197kB) | Preview
Preview	Text k-1721022-abstract-id.pdf Download (204kB) | Preview
	Text k-1721022-bibliography.pdf Download (286B)
Preview	Text k-1721022-chapter1.pdf Download (412kB) | Preview
Preview	Text k-1721022-chapter2.pdf Download (881kB) | Preview
Preview	Text k-1721022-chapter3.pdf Download (284kB) | Preview
Preview	Text k-1721022-chapter4.pdf Download (1MB) | Preview
	Text k-1721022-chapter5.pdf Restricted to Repository staff only Download (1MB) | Request a copy
	Text k-1721022-chapter6.pdf Restricted to Repository staff only Download (371kB) | Request a copy
Preview	Text k-1721022-chapter7.pdf Download (270kB) | Preview
Preview	Text k-1721022-cover-id.pdf Download (108kB) | Preview

Abstract

PT. PCI Elektronik Internasional sebagai kontraktor yang menawarkan jasa untuk Original Equipment Manufacturer (OEM). Dalam proses manufaktur produk customer, PCI selalu menerima Bill of Material (BOM) melalui Engineering Change Order (ECO) dari customer sebagai salah satu informasi paling penting tentang suatu produk. Product Engineer (PE) PCI bertanggung jawab untuk meng-upload BOM ke sistem SAP PCI dan memastikan tidak ada kesalahan dalam pembuatan BOM. Peroses pengecekan BOM masih dilakukan secara manual sehingga memerlukan waktu yang lebih lama dan memungkinkan terjadinya error. Selain itu BOM yang diterima dari customer memiliki format yang berbeda dengan BOM PCI sehingga perlu dikonversi terlebih dahulu. Untuk mengatasi hal ini perlu dirancang aplikasi VBA untuk BOM Buy Off dan BOM Converter. Aplikasi BOM Converter digunakan untuk mengkonversi format BOM customer untuk disesuaikan dengan format BOM PCI. Sedangkan aplikasi BOM Buy Off digunakan untuk membandingkan BOM PCI dengan BOM customer. Keluaran dari BOM Buy Off adalah perbedaan-perbedaan yang ditemukan antara kedua BOM dan rekomendasi untuk memperbaiki BOM PCI agar sesuai dengan BOM customer. Dengan menggunakan aplikasi BOM Buy Off, proses pengecekan adalah sekitar 15 menit sedangkan ketika dilakukan secara manual proses pengecekan sekitar 45 menit. Aplikasi BOM Buy Off juga menyederhanakan tahapan pengecekan sehingga target penyelesaian BOM Buy Off bisa dipercepat dari 2 hari menjadi 1 hari setelah BOM di-upload oleh PE. Sedangkan dengan menggunakan aplikasi BOM Converter, proses konversi BOM menjadi lebih cepat dari 1 jam menjadi 5 menit. ********************************************************************** PT. PCI Elektronik Internasional as contractor serve for Original Equipment Manufacturer (OEM). In manufacturing Process of customer product, PCI get used to receive Bill of Material (BOM) that included in Engineering Change Order (ECO) from customer as one of the most important document related to the product. Product Engineer (PE) of PCI is responsible to upload the BOM into PCI SAP System and ensure there is no error during BOM creation. The checking process of the BOM is still done manually so that take more times and has chance to cause error. In other hand the BOM received form customer has different format to BOM of PCI then need to be converted. In order to solve these problems VBA application of BOM Buy Off and BOM Converter need to be designed. Application of BOM Converter is used to convert the format of customer BOM to be matched with the format of PCI BOM. Whereas application of BOM Buy Off is used to compare the PCI BOM and customer BOM. Output of BOM Buy Off is discrepancy found between the two BOMs and recommend to revise the PCI BOM so that match with customer BOM. By using this application of BOM Buy Off, the checking process is about 15 minutes while when it was done manually is about 45 minutes. Application of BOM Buy Off also simplify the checking work flow then the target to finish the BOM Buy Off can be expedited from 2 days become 1 day after the BOM uploaded by the PE. Whereas by using the application of BOM Converter, the converting process become faster which is from 1 hour to be 5 minutes.

Actions (login required)

View Item