Operational Cost Efficiency in Tobacco Industry Distribution Using Integer Programming via Excel Solver
JOKI: Journal of Computing and Informatics · 2025
DOI: 10.65678/joki.v2i1.157 ↗Kurz gefasst
Fachartikel in der Zeitschrift JOKI: Journal of Computing and Informatics, 2025. Verfasst von M. Fadhilurrahman und 2 weiteren Autor:innen. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).
Abstract (Originalsprache)
Efficient transportation management plays a vital role in minimizing operational costs in the tobacco manufacturing industry. This study presents the application of Integer Programming using Excel Solver to optimize distribution logistics and reduce transportation expenses in a cigarette factory. The research employs a quantitative descriptive approach using simulated data representing production capacities and regional demand. A linear programming model is constructed to minimize total transportation costs while considering constraints such as factory capacity, regional demand, and non-negativity of shipment volumes. Excel Solver, as an accessible and widely adopted optimization tool, is utilized to determine the optimal allocation of product deliveries from factories to various distribution zones. The results indicate that Solver provides a cost-effective and practical solution for identifying optimal transport routes, reducing overall distribution costs, and improving operational efficiency. Furthermore, sensitivity analysis reveals the robustness of the model in responding to changes in cost parameters and capacity constraints. The study highlights the strategic potential of spreadsheet-based decision support systems in enhancing supply chain efficiency within the tobacco industry and similar manufacturing sectors..
Zitieren
APA
Fadhilurrahman, M., Khairi, A., & Uye, E. E. (2025). Operational Cost Efficiency in Tobacco Industry Distribution Using Integer Programming via Excel Solver. JOKI: Journal of Computing and Informatics. https://doi.org/10.65678/joki.v2i1.157
Vancouver
Fadhilurrahman M, Khairi A, Uye EE. Operational Cost Efficiency in Tobacco Industry Distribution Using Integer Programming via Excel Solver. JOKI: Journal of Computing and Informatics. 2025. doi:10.65678/joki.v2i1.157
BibTeX
@article{Fadhilurrahman2025,
author = {Fadhilurrahman, M. and Khairi, Ahmad and Uye, Emmanuel E.},
title = {Operational Cost Efficiency in Tobacco Industry Distribution Using Integer Programming via Excel Solver},
journal = {JOKI: Journal of Computing and Informatics},
year = {2025},
doi = {10.65678/joki.v2i1.157}
}
EUVIMED