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
- Muhammad Arif Harnisa
- Mulkan Aziman
- Nazia Putri Aulia
- Muhammad Rafi Islami
Institutions
- Sriwijaya University (ID)
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