Determining the Shortest Path for Souvenir Delivery to Tourist Attractions in Pamekasan Using Excel Solver
Article Sidebar
-
Excel Solver, Distribution, Phortest Path
Abstract
Pamekasan, as one of the districts in East Java, is famous for its various interesting tourist attractions. As the number of tourists increases, the need for typical Pamekasan souvenirs also increases. This encourages souvenir craftsmen to look for efficient ways to distribute their products to tourist attractions. One method that can be used is to use Solver Excel to determine the shortest path for sending souvenirs. This research aims to determine the shortest path for sending souvenirs from production sites to tourist attractions in Pamekasan using Solver Excel. The research method used is quantitative using Excel Solver. The data used is data on the distance between production sites and tourist attractions in Pamekasan. This data was obtained from the Pamekasan Regency Tourism and Culture Office. The research results show that Solver Excel can be used to determine the shortest route for sending souvenirs from production sites to tourist attractions in Pamekasan so that it can help souvenir craftsmen to save time and costs in distributing their products.
Full text article
References
Adejumobi, I. A. (2019). Efficient Utilization of Industrial Power: Demand Side Management Approach. IEEE PES/IAS PowerAfrica Conference: Power Economics and Energy Innovation in Africa, PowerAfrica 2019, Query date: 2024-07-21 12:06:14, 677–681. https://doi.org/10.1109/PowerAfrica.2019.8928817
Ahmed, M. Z. (2022). Estimation of Weibull Distribution Parameters by Using Excel Solver Tool for Wind Speed Data at Al-Aziziyah, Libya. ELECOM 2022 - Proceedings of the 2022 4th IEEE International Conference on Emerging Trends in Electrical, Electronic and Communications Engineering, Query date: 2024-07-21 12:06:14. https://doi.org/10.1109/ELECOM54934.2022.9965234
Begen, M. A. (2019). Development of an operational and tactical decision support tool for a Canadian beverage firm: A case study. European Journal of Industrial Engineering, 13(2), 245–263. https://doi.org/10.1504/EJIE.2019.098515
Birch, C. C. (2022). Optimizing cut-off grade considering grade estimation uncertainty—A case study of Witwatersrand gold-producing areas. Journal of the Southern African Institute of Mining and Metallurgy, 122(7), 337–346. https://doi.org/10.17159/2411-9717/1403/2022
Bravo-Sepúlveda, M. (2023). A STOCHASTIC MODEL TO QUANTIFY AND OPTIMIZE THE IMPACT OF OPERATIONAL RISKS ON CORPORATE SUSTAINABILITY USING MONTE CARLO SIMULATION. Polish Journal of Management Studies, 28(2), 59–75. https://doi.org/10.17512/pjms.2023.28.2.04
Manish, G. V. (2023). Identification of Hotspot of Rape Cases in NCT of Delhi: A Data Science Perspective. Lecture Notes in Networks and Systems, 521(Query date: 2024-07-21 12:06:14), 485–496. https://doi.org/10.1007/978-3-031-13150-9_39
Massaro, F. (2021). An Algorithm for Optimal Sizing of BESS in Smart Islands Energy Communities: The Case of Pantelleria. 21st IEEE International Conference on Environment and Electrical Engineering and 2021 5th IEEE Industrial and Commercial Power System Europe, EEEIC / I and CPS Europe 2021 - Proceedings, Query date: 2024-07-21 12:06:14. https://doi.org/10.1109/EEEIC/ICPSEurope51590.2021.9584620
Mohanraj, R. (2023). Bending and Contact Stress Analysis of Helical Gear: A Comparative Study. Lecture Notes in Mechanical Engineering, Query date: 2024-07-21 12:06:14, 509–518. https://doi.org/10.1007/978-981-99-1288-9_53
Sharifian, M. (2024). Feedback control strategy of Fischer–Tropsch process in a micro-GtL plant. Chemical Engineering Research and Design, 204(Query date: 2024-07-21 12:06:14), 354–370. https://doi.org/10.1016/j.cherd.2024.02.046
Stoilova, K. (2020). Optimization of Urban Traffic in City Network. ACM International Conference Proceeding Series, Query date: 2024-07-21 12:06:14, 180–185. https://doi.org/10.1145/3407982.3407998
Tokgoz, E. (2019). Undergraduate industrial engineering majors’ software preferences for solving statistical process control and operations research questions. ASEE Annual Conference and Exposition, Conference Proceedings, Query date: 2024-07-21 12:06:14. https://api.elsevier.com/content/abstract/scopus_id/85078721648
Vairavel, P. (2021). Residence time distribution studies and modeling of rotating biological contactor reactor for decolorization of congo red from synthetic dye wastewater. Desalination and Water Treatment, 220(Query date: 2024-07-21 12:06:14), 380–391. https://doi.org/10.5004/dwt.2021.26982
Vamsikrishna, A. (2021). Cost Optimization for Transportation Using Linear Programming. Lecture Notes in Mechanical Engineering, Query date: 2024-07-21 12:06:14, 11–20. https://doi.org/10.1007/978-981-16-0976-3_2
Wu, M. H. (2021). A NEW APPROACH FOR MODELING EARTHQUAKE MAGNITUDE PROBABILITY DISTRIBUTION. Journal of GeoEngineering, 16(4), 145–154. https://doi.org/10.6310/jog.202112_16(4).3
Zhang, Y. (2021). Particle size distributions following chewing: Transformation of two-dimensional outcome from optical scanning to volume outcome from sieving. Journal of Food Engineering, 309(Query date: 2024-07-21 12:06:14). https://doi.org/10.1016/j.jfoodeng.2021.110663
Authors
Copyright (c) 2024 Badrud Tamam, Motik Arisca Dyana
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.