Spreadsheet Based Business Decision Making System (Case Study In Bonorowo Land, Laren, Lamongan)

Irawati, Desrina Yusi and Andrian, David and Dewantoro, Albertus Daru (2020) Spreadsheet Based Business Decision Making System (Case Study In Bonorowo Land, Laren, Lamongan). Spektrum Industri, 18 (2). pp. 195-202. ISSN 2442-2630

[img] Text
Spektrum/article/view/16967 - Published Version

Download (40kB)
Official URL: http://journal.uad.ac.id/index.php/Spektrum/articl...


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.

Item Type: Article
Research team headIrawati, Desrina Yusi0723128802desrina.yusi@gmail.com
Uncontrolled Keywords: Feasibility ; NPV ; IRR ; IP
Subjects: Q Science > QA Mathematics
Q Science > QA Mathematics > QA75 Electronic computers. Computer science
Q Science > QA Mathematics > QA76 Computer software
Divisions: Fakultas Teknik > Prodi Teknik Industri
Depositing User: Desrina Yusi Irawati
Date Deposited: 02 Dec 2020 09:00
Last Modified: 19 Apr 2022 04:37
URI: http://repositori.ukdc.ac.id/id/eprint/462

Actions (login required)

View Item View Item