SPREADSHEET BASED BUSINESS DECISION MAKING SYSTEM (CASE STUDY IN BONOROWO LAND, LAREN, LAMONGAN)

Desrina Yusi Irawati, David Andrian, Albertus Daru Dewantoro

Abstract


Bonorowo land in Laren Subdistricts, Lamongan Districts, is one of the areas that uses its land for rice, corn and kenaf cultivation. The agricultural sector in Laren does not yet have a detailed economic analysis. Farmers ignore the importance of considering initial capital and some “small†costs in this activities. Therefore, in this study, the calculation of business feasibility was carried out on rice, kenaf, and corn farmer groups in Bonorowo land, West Laren. Business feasibility analysis is conducted through calculation of the value of NPV, IRR, and IP. The calculation system uses a Microsoft Excel spreadsheet formula. The NPV, IRR, and PI values of corn cultivation are Rp. 524,182.40; 144.43%; and 2,9. The NPV, IRR, and PI values for kenaf cultivation are Rp. 1,145,532.39; 266.43%; and 5.15. The NPV, IRR, and PI values for rice cultivation are Rp. -495,085.78; -25.18%; and -0.79. The results of the economic analysis of the cultivation of rice, corn, and kenaf in Bonorowo land, Laren Subdistrict, show that rice cultivation has caused losses and is not feasible to continue.

Keywords


Feasibility; NPV; IRR; IP

Full Text:

PDF

References


Abdelrhman, H.A., Shahwahid, M., Paridah, M.T., Ara, S., Maaei, H., Ogeri, A. (2016). Financial and technical assessment of kenaf cultivation for producing fiber utilized in automotive components. Business and Economics Journal, 7(4), 1-8.

Adamtey, N., Musyoka, M.W., Zundel, C., Cobo, J.G. (2016). Productivity, profitability, and partial nutrient balance in maize-based conventional and organic farming systems in Kenya. Agriculture, Ecosystems, & Environment, 235, 61-79.

Ammani, A.A. (2015). Costs and returns analysis for small-scale irrigated crop production in Kaduna State, Nigeria. Scientia Agriculturae, 10(2), 64-69.

Bajracharya, M., Sapkota, M., Dhungana, S.M. (2016). Socio-economic analysis of maize seed production in Arghakhanchi District of Nepal. Journal of Maize Research and Development, 2(1), 144–150.

Bwala, M.A., Aniobi, U.J. (2018). Profitability analysis of paddy production: a case of agricultural zone 1, Niger State Nigeria. Journal Bangladesh Agricultural University, 16(1), 88-92.

Chaiyaput, S., Bergado, D.T., Artidteang, S. (2014). Measured and simulated results of a kenaf Limited Life Geosynthetics (LLGS) reinforced test embankment on soft clay. Geotextiles and Geomembranes, 42(1), 39–47.

Ding, Z., Shi, S.Q., Zhang, H., Cai, L. (2015). Electromagnetic shielding properties of iron oxide impregnated kenaf bast fiberboard. Composites Part B: Engineering, 78, 266–271.

Ediwodjojo, S.P., Ginting, I.R. (2018). Analisis investasi dengan perhitungan NPV, IRR dan payback period pada produksiikan presto gita pindang Desa Kalitengah Kecamatan Gombong. Jurnal E-Bis, 2(1), 7-15.

Hassan, F., Rozli, Z., Mariyam, J.G., Che, H.A. (2017). Kenaf fiber composite in automotive industry: an overview, international journal on advanced science. Engineering and Information Technology, 7(1), 315-321.

Haider, M.Z., Akter, R. (2018). Shrimp-paddy conflict in the South-West Coastal Region of Bangladesh. Internasional Journal of Agricultural Economics, 3(1), 9-13.

Irawati, D.Y., Wulandari, L.M.C. (2019). Life cycle assessment analysis of kenaf cultivation in bonorowo land, Laren Lamongan. Jurnal Sistem dan Manajemen Industri, 3(2), 89-97.

Islam, M.Z., Begum, R., Sharmin, S., Khan, M.A. (2017). Profitability and productivity of rice production in selected coastal area of Satkhira District in Bangladesh. International Journal Business, Management and Social Research, 3(1), 148-153.

Lukman, M. (2019). Analisa Aplikasi Mata Kuliah Ekonomi Teknik Studi Kasus Industri Kecil Eka Surya Jaya Mandiri. Seminar Nasional Teknologi dan Rekayasa (SENTRA) 2019, 4, 102-109.

Nguyen, T.T., Indraratna, B. (2017). Experimental and numerical investigations into hydraulic behaviour of coir fibre drain. Canadian Geotechnical Journal, 54(1), 75–87.

Nuryanti, D.M., Niken, N.K. (2017). Analisis pendapatan usahatani pola rotasi tanaman padi-jagung manis di Desa Mulyasari Kecamatan Sukamaju. Journal TABARO, 1(2), 95-104.

Nuswardhani, S.K. (2017). Struktur biaya dan profitabilitas usahatani tanaman pangan (padi, jagung, dan keledai). Jurnal Agromix, 8(1), 64-74.

Nwalieji, H.U. (2016). Comparative profit analysis of rice production enterprise among farmers in Anambra and Ebonyi States, Nigeria. Asian Journal of Agricultural Extension, Economics & Sociology, 8(3), 1-11.

Ohen, S.B., Ajah, E.A. (2015). Cost and return analysis in small scale rice production in cross river state, Nigeria. International Research Journal of Agricultural Science and Soil Science, 5(1), 22-27.

Paridah, M.T., Abdelrhman, H.A., Shahwahid, M. (2017). Cost benefit analysis of kenaf cultivation for producing fiber in Malaysia. Arabian Journal of Business and ar A Management Review, 7(4), 1-4.

Saba, N., Paridah, M.T., Jawaid, M. (2015). Mechanical properties of kenaf fibre reinforced polymer composite: a review. Construction and Building Materials, 76, 87–96.

Ghimire, S., Sherchan, D.P., Andersen, P., Pokhre, C., Khanal, D. (2016). Effect of variety and practice of cultivation on yield of spring maize in Terai of Nepal. Agrotechnol, 5(2),1-6.

Saediman, H., Mustika, Nalefo, L., Tufaila, M., Zani, M. (2019). Cost and return analysis of rice farming adn brick making in South Konawe District of Southeast Sulawesi. International Journal of Scientific & Technology Research, 8(10), 835-839.

Sekumade, A.B. (2017). Economic effect of organic and inorganic fertilizers on the yield of maize in Oyo State, Nigeria. International Journal of Agricultural Economics, 2(3), 63-68.

Shirazi, M.G., Rashid, A.S.A., Nazir, R.B., Rashid, A.H.A, Kassima, A., Horpibulsuk, S. (2019). Investigation of tensile strength on alkaline treated and untreated kenaf geotextile under dry and wet conditions. Geotextiles and Geomembranes, 47, 522-529.

Silitonga, P.Y, Hartoyo, S., Sinaga, B.M., Rusastra, I.W. (2016). Analisis efisiensi usahatani jagung pada lahan kering melalui penerapan pengelolaan tanaman terpadu (PTT) di provinsi Jawa Barat. Informatika Pertanian, 25(2), 199-214.

Soegiyanto, Gunawan, T., Rijanta, R., Suprayogi, S. (2015). Strategi penghidupan masyarakat dalam menghadapi genangan banjir bonorowo di Kabupaten Lamongan provinsi Jawa Timur. Disertasi. Yogyakarta: Geografi, Ilmu Geografi, Universitas Gadjah Mada.

Sujan, M.H.K, Islam, F., Azad, M.J., Rayhan, S.J. (2017). Financial profitability and resource use efficiency of boro rice cultivation in some selected area of Bangladesh. African Journal of Agricultural Research, 12(29), 2404-2411.

Susinto, A.C. (2017). Perhitungan kelayakan investasi special purpose machine pada pengerjaan produk pipe di PT DPM. Laporan Kerja Praktek. Jakarta: Program Studi Teknik Industri Fakultas Teknik Universitas Mercu Buana.

SUTAS2018, Tim. (2018). Hasil Survei Pertanian Antar Sensus (SUTAS) 2018-The Result Of Inter-Census Agricultural Survey. Jakarta: Badan Pusat Statistik.

Verma, D., Sharma, S. (2017). Green biocomposites: a prospective utilization in automobile industry. Green Energy and Technology, 167–191.

Wismaningrum, K.E.P., Ismail, Fitri, A.D.P. (2013). Analisis finansial usaha penangkapan one day fishing dengan alat tangkap multigear di PPP Tawang Kabupaten Kendal. Journal of Fisheries Resources Utilization Management and Technology, 2(3), 263-272.

Yarni, Y., Miswar, E., Marwan, C. (2017). Analisis kelayakan finansial usaha penangkapan ikan dengan jaring insang (gillnet) di Kecamatan Singkil, Kabupaten Aceh Singkil. Jurnal Ilmiah Mahasiswa Kelautan dan Perikanan Unsyiah, 2(3), 438-443.

Zhou, C., Shi, S. Q., Chen, Z., Cai, L., Smith, L. (2018). Comparative environmental life cycle assessment of fiber reinforced cement panel between kenaf and glass fibers. Journal of Cleaner Production, 200, 196–204.




DOI: http://dx.doi.org/10.12928/si.v18i2.16967

Refbacks

  • There are currently no refbacks.


Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Jurnal SPEKTRUM INDUSTRI Indexed by:

View Spektrum Industri Stats

Lisensi Creative Commons

Ciptaan disebarluaskan di bawah Lisensi Creative Commons Atribusi-BerbagiSerupa 4.0 Internasional