PERANCANGAN SISTEM INFORMASI PENENTUAN URUTAN DISTRIBUSI BBM BERBASIS MACRO VISUAL BASIC FOR APPLICATION (VBA) DAN ALGORITMA EXHAUSTIVE SEARCH PADA PERTAMINA INTEGRATED TERMINAL SEMARANG

Abstract

Abstrak

Integrated Terminal Semarang adalah bagian dari PT Pertamina Patra Niaga yang berlokasi di Jalan
Pengapon Semarang, Integrated Terminal Semarang memiliki tiga fungsi utala, yaitu sebagai tempat
penerimaan, penimbunan dan pendistribusian bahan bakar minyak (BBM) untuk daerah Jawa
Tengah. Dalam fungsi pendistribusian, Pertamina Integrated Terminal Semarang merupakan
penyalur BBM utama di area Jawa Tengah. Namun ternayata tidak ada arahan dari Pertamina
Integrated Terminal kepada AMT (Awak Mobil Tangki) mengenai urutan pengiriman SPBU yang
harus dilalui. Oleh karena itu dilakukan penelitian untuk merancang suatu sistem informasi berbasis
Visual Basic for Aplication dan Algoritma Exhaustive Search untuk mendapatkan urutan pengiriman
paling optimal. Data yang digunakan adalah data jarak dari 21 SPBU di kota semarang yang lalu
akan diolah menggunakan algoritma Exhaustive Search dan didapatkan sebuah prototype sistem
informasi berupa file excel.

Kata kunci: TSP, Exhaustive Search, Visual Basic for Application

Abstrak

Information System Development For Determining Fuel Distribution Order Based On Macro
Visual Basic For Application (VBA) And Exhaustive Search Algorithm At Pertamina Integrated
Terminal Semarang. Integrated Terminal Semarang is part of PT Pertamina Patra Niaga located on
Jalan Pengapon Semarang, Integrated Terminal Semarang has three main functions, namely as a
place to receive, hoard and distribute fuel oil (BBM) for the Central Java area. In the distribution
function, Pertamina Integrated Terminal Semarang is the main fuel distributor in the Central Java
area. However, there is no direction from Pertamina Integrated Terminal to AMT (Tank Car Crew)
regarding the order of gas station delivery that must be passed. Therefore, research was conducted to
design an information system based on Visual Basic for Application and exhaustive search Algorithm
to obtain the most optimal delivery order. The data used is distance data from 21 gas stations in
Semarang which will then be processed using a exhaustive search algorithm and obtained a prototype
information system in the form of an excel file.

Keywords: TSP, exhaustive search, Visual Basic for Application