Pemanfaatan Microsoft Excel Sebagai Sistem Pendukung Keputusan Ekonomi Budidaya Cabai Rawit Merah

This study aims to develop a Microsoft Excel-based model to support decision-making in the cultivation of red bird's-eye chili. A quantitative descriptive approach was employed, utilizing secondary data from Indonesian journal articles. Total production costs, average yield, and average selling price served as inputs for representative scenarios. The model calculates revenue, profit, the revenue-to-cost (R/C) ratio, as well as break-even price and production levels. A sensitivity analysis compares the baseline condition against four scenarios: a 10% decrease in selling price, a 10% decrease in yield, a 10% increase in costs, and a combination of all three. The baseline condition yields a profit of IDR 36,955,088 per hectare per growing season, with an R/C ratio of 1.65. All scenarios remain profitable. The combined scenario results in the lowest profit—approximately IDR 13,407,466 per hectare per growing season—with an R/C ratio of 1.21, representing a 63.72% decline from the baseline. The model provides calculations, scenario comparisons, and break-even information for economic evaluation. These findings are limited by the use of aggregate data and simulation assumptions; the effectiveness of the model for actual farmer decision-making has not yet been tested.

Authors

Institutions

Publication Details

Journal
Jurnal Ekonomi Pertanian dan Agribisnis
Published
2026-11-18
DOI
https://doi.org/10.62379/jepag.v4i1.5437
Primary Topic
Agriculture and Agroindustry Studies
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
article

Pemanfaatan Microsoft Excel Sebagai Sistem Pendukung Keputusan Ekonomi Budidaya Cabai Rawit Merah

Muhammad Arif Harnisa, Mulkan Aziman, Nazia Putri Aulia, Muhammad Rafi Islami
Jurnal Ekonomi Pertanian dan Agribisnis
Agriculture and Agroindustry Studies
article

Pemanfaatan Microsoft Excel Sebagai Sistem Pendukung Keputusan Ekonomi Budidaya Cabai Rawit Merah

Muhammad Arif Harnisa, Mulkan Aziman, Nazia Putri Aulia, Muhammad Rafi Islami
article en

Abstract

This study aims to develop a Microsoft Excel-based model to support decision-making in the cultivation of red bird's-eye chili. A quantitative descriptive approach was employed, utilizing secondary data from Indonesian journal articles. Total production costs, average yield, and average selling price served as inputs for representative scenarios. The model calculates revenue, profit, the revenue-to-cost (R/C) ratio, as well as break-even price and production levels. A sensitivity analysis compares the baseline condition against four scenarios: a 10% decrease in selling price, a 10% decrease in yield, a 10% increase in costs, and a combination of all three. The baseline condition yields a profit of IDR 36,955,088 per hectare per growing season, with an R/C ratio of 1.65. All scenarios remain profitable. The combined scenario results in the lowest profit—approximately IDR 13,407,466 per hectare per growing season—with an R/C ratio of 1.21, representing a 63.72% decline from the baseline. The model provides calculations, scenario comparisons, and break-even information for economic evaluation. These findings are limited by the use of aggregate data and simulation assumptions; the effectiveness of the model for actual farmer decision-making has not yet been tested.

Jurnal Ekonomi Pertanian dan AgribisnisVol. 4(1)
Sriwijaya University (ID)
Zero hunger
Agriculture and Agroindustry Studies
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.

Laika access coming soon