Desain dan Implementasi Aplikasi Monitoring Tender Berbasis Excel Visual Basic di PT XYZ

Anisa Fitriawan; Harmon Chaniago

doi:10.36526/tekiba.v5i2.5361

Authors

Anisa Fitriawan Politeknik Negeri Bandung
Harmon Chaniago Politeknik Negeri Bandung

DOI:

https://doi.org/10.36526/tekiba.v5i2.5361

Keywords:

Design, Implementation, Monitoring, Sales Marketing, Microsoft Excel VBA

Abstract

The Marketing and Sales Division of PT XYZ faces challenges in managing tender data due to the lack of an integrated and structured system. The dispersion of data across multiple locations complicates the monitoring process, particularly when the company participates in multiple tenders simultaneously. This project aims to address the issue by identifying initial problems, designing, and implementing a tender monitoring application within the division. The development process employed the waterfall methodology. Data were collected through direct observation and interviews with administrative staff as primary sources, while secondary data were obtained from relevant documentation. The results showed that the administrative staff in the marketing and sales division were significantly assisted in managing tender data, particularly in terms of processing speed. Previously, data management was performed manually using Excel documents without automation, taking around 10 minutes. After the implementation of this application, the tender data processing time was significantly reduced, with an average speed improvement of 89%. This solution contributes to enhancing the efficiency, structure, and accuracy of tender information management, facilitates progress monitoring, and supports the creation of tender reports within the Marketing and Sales Division of PT XYZ.

References

[1] Tazkiyah S, Arifin A. Perancangan Ui/Ux Pada Website Laboratorium Energy Menggunakan Aplikasi Figma. Jurnal Teknologi Terpadu 2022:72–8. https://doi.org/https://doi.org/10.54914/jtt.v8i2.513

[2] Surya AA, Haromain I. Rancang Bangun Website Lelang Mobil Menggunakan Framework Codeigniter 3 Pada PT.ABC. Jurnal Teknologi Terpadu 2023:133–42. https://doi.org/https://doi.org/10.54914/jtt.v9i2.1031

[3] Pemerintah Republik Indonesia. Peraturan Presiden Republik Indonesia Nomor 16 Tahun 2018 tentang Pengadaan Barang/Jasa Pemerintah. Indonesia: https://www.kemhan.go.id/pothan/wp-content/uploads/2018/12/Perpres-No-16-Tahun-2018.pdf. 2018.

[4] Nakanishi Y. Determinants of the number of bidders and win-reserve ratio in open competitive tendering: Relationship-specific investments and incomplete contracts. Japan World Econ 2022;63. https://doi.org/10.1016/j.japwor.2022.101147

[5] Restu Mukti A, Pratama A, Dali Purwanto T. Perancangan Aplikasi Sijaspro Di Jasdam II Sriwijaya Berbasis Kodular. Jurnal Pengabdian Kepada Masyarakat Bina Darma 2023; 4:43–9. https://doi.org/https://doi.org/10.33557/pengabdian.v4i1.2881

[6] Panie GJ, Megawati S. Penerapan Aplikasi Monitoring Lelang (Monpela) Di Biro Layanan Pengadaan Dan Pengelolaan Barang Milik Negara (Lppbmn) Kementerian Perhubungan. Publika 2022; 11:2315–25. https://doi.org/https://doi.org/10.26740/publika.v11n3.p2315-2325

[7] Poetra AA, Nandika R, Wijaya TK, et al. Prototipe Sistem Monitoring Ketinggian Air Pada Tangki Berbasis Internet Of Things. Sigma Teknika 2023; 6:97–108. https://doi.org/https://doi.org/10.33373/sigmateknika.v6i1.5148

[8] Chaniago H. Investigation of Entrepreneurial Leadership and Digital Transformation: Achieving Business Success in Uncertain Economic Conditions. J Technol Manag Innov 2023 2023; 18:18. https://doi.org/https://doi.org/10.4067/S0718-27242023000200018

[9] Li H, Wu Y, Cao D, et al. Organizational mindfulness towards digital transformation as a prerequisite of information processing capability to achieve market agility. J Bus Res 2021; 122:700–12. https://doi.org/10.1016/j.jbusres.2019.10.036

[10] Suhirman S, Hidayat AT, Saputra WA, et al. Website-Based E-Pharmacy Application Development to Improve Sales Services Using Waterfall Method. International Journal of Advances in Data and Information Systems 2021; 2:114–29. https://doi.org/10.25008/ijadis.v2i2.1226

[11] Sholikhah U, Rosyadi B, Wahzuni SR, et al. Perancangan Sistem Informasi Sekolah Berbasis Website Pada Mi Manbail Futuh Jenu Tuban. IJIS Indonesian Journal on Information System 2024; 9:120–31. https://doi.org/https://doi.org/10.36549/ijis.v9i2.324

[12] Sari IP, Sulaiman OK, Al-Khowarizmi A-K, et al. Perancangan Sistem Informasi Pelayanan Masyarakat pada Kelurahan Sipagimbar dengan Metode Prototype Berbasis Web. Blend Sains Jurnal Teknik 2023; 2:125–34. https://doi.org/10.56211/blendsains.v2i2.288

[13] Handriyatma R, Anwar M. Rancang Bangun Aplikasi Augmented Reality Pada Komponen Komputer Sebagai Media Pembelajaran Berbasis Mobile. Ranah Research: Journal of Multidisciplinary Research and Development 2021; 3:123–30. https://doi.org/10.38035/rrj.v3i2

[14] Rolansa F. Pengembangan interaktif dashboard kemahasiswaan di program studi teknik informatika dengan teknologi big data. Jurnal Pendidikan Informatika Dan Sains 2021; 10:110–8. https://doi.org/10.31571/saintek.v10i2.2190

[15] Riyanti A, Putro Dirgantoro G, Made Agus Oka Gunawan I. Development of Rental Application using Prototyping Method. vol. 1. 2024. https://doi.org/https://doi.org/10.52432/technovate.1.2.2024.69-80

[16] Hijriah S, Irawan D, Jl Jenderal Ahmad Yani No D, et al. Analisis Website E-Government Kecamatan Menggunakan Metode Usability Testing ZONAsi. vol. 5. 2023. https://doi.org/10.31849/zn.v5i3.15798

[17] Aditya F, Dwi Putra A, Surahman A. Rancang Bangun Aplikasi Penjualan Berbasis Android (Studi Kasus: Pada Toko Murah Jaya Alumunium). Jurnal Informatika Dan Rekayasa Perangkat Lunak (JATIKA) 2022; 3:316–29. https://doi.org/https://doi.org/10.33365/jatika.v3i3.2037

[18] Wantoro A, Samsugi S, Joko Suharyanto M. Sistem Monitoring Perawatan dan Perbaikan Fasilitas PT PLN (Studi Kasus: Kota Metro Lampung). Jurnal TEKNO KOMPAK 2021; 15:116–30. https://doi.org/https://doi.org/10.33365/jtk.v15i1.903

[19] Novita D, Prihatini Sihotang F, Khairani S. Pelatihan Penggunaan Microsoft Excel Untuk Mengolah Data Bagi Siswa/I Smk Bina Cipta Palembang. Jurnal Pengabdian Kepada Masyarakat Fordicate (Informatics Engineering Dedication) 2023; 2:109–18. https://doi.org/10.35957/fordicate.v2i1

[20] Siregar ET, Alfina O, Puspita D, et al. Pelatihan Penginputan Data Secara Otomatis di Microsoft Excel Menggunakan Data Form Dan Macro Vba (Basic for Aplication) Di Sma It Unggul Al-Munadi Medan. Jurnal Pengabdian Pada Masyarakat METHABDI 2023;3. https://doi.org/10.46880/methabdi.Vol3No2.pp150-154

[21] Sazaki Y, Putra P, Putera A, et al. Aplikasi Pembayaran Quota Siswa Berbasis VBA Macro Excel pada SMA Negeri 3 Banyuasin III Sumatera Selatan. Jurnal Pendidikan Sains Dan Komputer 2023; 3:130–44. https://doi.org/10.47709/jpsk.v3i01.2582