Optimization production model and financial feasibility analysis on planning of integrated lontar sugar industry in Rote Ndao District, East Nusa Province, Indonesia




Abstract. Fahrizal, Jasman, Nggadung Y, Kartiwan. 2020. Optimization production model and financial feasibility analysis on planning of integrated lontar sugar industry in Rote Ndao, East Nusa Tenggara, Indonesia. Trop Drylands 21: 25-30. In general, lontar (Borassus flabellifer) sugar consists of molded sugar and crystal sugar produced from lontar sap. Both types of sugar can be produced together in one business unit, but in fact, most home industries produce them partially. This research aimed to obtain an optimization of production model and financial feasibility of integrated lontar sugar industry. The linear programming optimization method was used to determine the optimal amount of molded and crystal lontar sugar production with the objective function of profit maximization. The model was validated on lontar sugar home industry in Rote Ndao District, East Nusa Tenggara Province, Indonesia. Scenario of price change and interest rates were used to measure the level of sensitivity of financial feasibility. The results showed that a maximum profit of IDR 186,741 was obtained by producing 47.25 kgs of molded sugar and 57.93 kgs of crystal sugar every day. The financial feasibility analysis of IRR, NPV, and BC indicators showed that the project was still feasible when the sugar price fall down by 10%, the price of lontar sap increased by 20%, and interest rates rose to the level of 24%.



Abbas, BS, Indriani, W. 2010. Optimasi proses produksi untuk produk makanan dengan metode Integer Linear programming (ILP) pada PT PSA. INASEA 11(1): 45-57. [Indonesian]
Budiasa, IW, Ambarawati, IG. Mega, IM, Budiasa IKM. 2012. Optimizing integrated farming systems to maximize farmer's income. Journal of Agribusinees and Agritourism 1(2):96-105.
Cohen, KJ. Cyert RM. 1976. Theory of The Firm: Resource allocation in a market economy. New Delhi: Prentice-Hall of India Private Limited (2nd).
Forest Research and Development Center. Ministry of Forestry Republic of Indonesia. 2010. Lontar (Borrasus Flabellifer) sebagai Sumber Energi Bioetanol Potensial. Forest Research and Development Centre, Bogor. [Indonesian]
Fahrizal 2015. Dry Land Sugarcane Agroindustrial Planning at East Nusa Tenggara Province. Dissertation. Bogor. Bogor Agricultural University. [Indonesian]
Fahrizal, Marimin, Yani M, Purwanto MYJ, Sumaryanto. 2014. Decision support model for sugar cane agroindustrial development (A case study at East Nusa Tenggara Province. J Tek Ind Pert. 24(3): 189-199. [Indonesian]
Fahrizal, Jasman, Yeheskial N, Kartiwan. 2019. Formulating strategies for development of lontar sugar industry in Rote Ndao District, East Nusa Tenggara Province, Indonesia. Tropical Drylands 3(2):41-48.
Gradiz, L. Sugimoto, A. Ujihara, K. Fukuhara, S. dan Kahi, AK. 2007. Beef cow-calf production system integrated with sugarcane production: Simulation Model Development and Application in Japan. Agricultural Systems 94:750-762.
Jonsson, P. 2008. Logistics and supply chain management. McGraw-Hill Education. Shoppenhangers Road Berkshire.
Kusumastuti TA., Sarim, Masyhuri. 2015. Integrated farming model of small ruminants in Deli Serdang, North Sumatra-Indonesia. J. Indonesian Trop Anim. Agric. 40(2):115-120
National Standardization Agency of Indonesia. 1995. SNI 01-3743-1995 Standar Nasional Indonesia Gula Palma. Jakarta.[Indonesian]
Priyanto, D. 2008. Farming system model on integrated cocoa and goat to increase farmer’s income. Wartazoa 18(1): 46-56.
Soedjana, TJ. 2007. Sistem usaha tani terintegrasi tanaman-ternak sebagai respon petani terhadap faktor risiko. Jurnal Litbang Pertanian 26(2):82-87 [Indonesian]
Sukanteri, NP. Tenaya, MN. dan Budiasa, IW. 2013. Optimization analysis of integrated farming system: linear programming approach. Jurnal Manajemen Agribisnis. 1(1):1-15
Taha, H.A. 2003. Operations Research: An Introduction. 7th Edition. Prentice Hall Inc.
Toledo, RT. 2007. Fundamentals of food process engineering. Third Edition. Springer. University of Georgia, Athens, Georgia.