Sugarcane Allocation for Sugar Mills in East Java Province: Spatial Distribution and Transportation Method Approach Aunur Rofiq Mulyarto*, Siti Aminah, Retno Astuti, Imam Santoso, Sucipto, Sri Suhartini
Department of Agroindustrial Technology, Faculty of Agricultural Technology, Universitas Brawijaya
*aunurrm[at]ub.ac.id
Abstract
East Java is the province with the largest sugar production in Indonesia, supported by a large sugarcane plantation area to meet the raw material needs of sugar factories. However, the latest data shows that there is a difference between the amount of sugarcane supply and the demand for raw materials by sugar factories. This study aims to determine the distribution map of sugarcane against sugar factory demand, and determine the optimal sugarcane allocation for sugar factories in East Java using the transportation method approach. The spatial distribution of sugarcane production and sugar factory demand was built using QGIS 3.34.4 software. Meanwhile, the optimization of sugarcane allocation using the transportation method approach was completed with the help of OpenSolver on the Microsoft Excel platform. The results of the analysis show that there are 29 sugar factories and sugarcane plantations spread across 424 sub-districts in East Java. The total demand for sugarcane by sugar factories is greater than the total sugarcane production, with a difference of 4,375,804 tons. Or theoretically, there is an imbalance between sugarcane supply and demand. Therefore, there are two proposed scenarios. First, finding the optimal solution using a dummy. Second, the search for optimal solutions by adjusting the demand of sugar factories proportionally based on the difference between demand and sugarcane supply. The first scenario produces a total transportation cost of Rp 747,275,819,472, - with 9 sugar factories getting supplies from the dummy. The second optimization scenario produces a total transportation cost of Rp 842,750,679,416, -.
