Pemanfaatan Microsoft Excel Sebagai Sistem Pendukung Keputusan Ekonomi Budidaya Cabai Rawit Merah
Year: 2026
Type: article
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.
Institution: Sriwijaya University
Language: English
Domain: Life Sciences
SDG: Zero hunger
Open Access status: diamond
OpenAlex ID: W7236407758
