Vitaloka, Made Rully Anjani (2025) Optimasi Rute Dan Alokasi Sales Representative Pada Jaringan Logistik Pedesaan Menggunakan Pendekatan Cluster First Route Second Dengan Visual Basic Applications. Other thesis, Institut Teknologi Sepuluh Nopember.
![[thumbnail of 5010211018-Undergraduate_Thesis.pdf]](http://repository.its.ac.id/style/images/fileicons/text.png) |
Text
5010211018-Undergraduate_Thesis.pdf Download (3MB) |
Abstract
Distribusi barang di wilayah pedesaan menghadapi berbagai tantangan, seperti ketidakefisienan rute pengiriman, ketidakseimbangan beban kerja antar Sales representative (SR), serta tingginya biaya operasional. Untuk mengatasi permasalahan tersebut, penelitian ini mengusulkan model optimasi menggunakan pendekatan Cluster First Route Second (CFRS) yang diimplementasikan dalam Visual Basic for Applications (VBA) Excel untuk meningkatkan kinerja jaringan logistik pedesaan. Model ini terdiri dari dua tahap utama, yaitu (1) pengelompokan titik pengiriman menggunakan Nearest Neighbor Clustering untuk membentuk zona distribusi yang lebih terstruktur, dan (2) penentuan urutan kunjungan optimal dalam setiap klaster menggunakan algoritma Traveling Salesman Problem (TSP) dengan pendekatan Nearest Neighbor. Simulasi dilakukan pada enam skenario, dengan skenario kelima teridentifikasi sebagai alternatif dengan kinerja terbaik. Dibandingkan dengan kondisi eksisting perusahaan yang masih menggunakan perencanaan rute manual, skenario optimasi ini mampu meningkatkan waktu kerja rata-rata sebesar 2,86%, meningkatkan utilisasi waktu kerja sebesar 52,11%, menurunkan jarak tempuh sebesar 6,80%, mengurangi biaya distribusi sebesar 33,33%, serta memangkas waktu tidak terpakai sebesar 56,57%. Model ini juga terbukti robust terhadap perubahan parameter, seperti jumlah pelanggan dan durasi layanan. Temuan ini menunjukkan bahwa model CFRS yang diusulkan mampu meningkatkan efisiensi operasional, pemerataan beban kerja, dan menurunkan biaya logistik dalam sistem distribusi pedesaan. Pendekatan ini diharapkan dapat mendukung efektivitas rantai pasok dalam konteks distribusi mikro.
======================================================================================================================================
The distribution of goods in rural areas presents several challenges, such as inefficient delivery routes, unbalanced workload among sales representatives, and high operational costs. To address these issues, this study proposes an optimization model using the Cluster First Route Second (CFRS) approach, implemented in Visual Basic for Applications (VBA) Excel, to improve the performance of rural logistics networks. The model consists of two stages: (1) clustering delivery points using Nearest Neighbor Clustering to define structured regional zones, and (2) determining the optimal visit sequence within each cluster using the Traveling Salesman Problem (TSP) with a Nearest Neighbor heuristic. The simulation was conducted across six scenarios, with the 5th scenario emerging as the best-performing alternative. Compared to the company’s manual route planning (existing condition), the optimized scenario achieved a 2.86% increase in average working time, a 52.11% increase in time utilization, a 6.80% reduction in travel distance, a 33.33% reduction in delivery costs, and a 56.57% decrease in non-utilized time. The model also demonstrated robustness under parameter changes, including variations in the number of customers and service time. These findings indicate that the proposed CFRS model can significantly improve operational efficiency, balance workload distribution, and reduce logistics costs in rural distribution systems. This approach is expected to support more effective supply chain operations in micro-distribution settings.
| Item Type: | Thesis (Other) |
|---|---|
| Uncontrolled Keywords: | Distribusi Pedesaan, Rute Sales representative, Cluster First Route Second, Visual Basic Applications, Rural Distribution, Sales representative Route |
| Subjects: | Q Science Q Science > QA Mathematics Q Science > QA Mathematics > QA278.55 Cluster analysis Q Science > QA Mathematics > QA402.6 Transportation problems (Programming) Q Science > QA Mathematics > QA76.76.A63 Application program interfaces |
| Divisions: | Faculty of Industrial Technology > Industrial Engineering > 26201-(S1) Undergraduate Thesis |
| Depositing User: | Made Rully Anjani Vitaloka |
| Date Deposited: | 25 Jul 2025 06:24 |
| Last Modified: | 25 Jul 2025 06:24 |
| URI: | http://repository.its.ac.id/id/eprint/121484 |
Actions (login required)
 |
View Item |