Sensitivity Analysis in Optimizing Coffee Production Profit Using Linear Programming with Simplex Method (Case Study: Komocha Coffee Home Industry)

Abstract

Bengkulu Province is the third largest coffee producing province in Indonesia, which is mostly dominated by the Robusta coffee type. One of the businesses engaged in the coffee production process is the Komocha coffee home industry. However, the industry has profit constraints that are not yet optimal. One method that can be used in solving optimization problems is linear programming (simplex method). The purpose of this research is to optimize the profit of coffee production and determine the results of sensitivity analysis using linear programming with simplex method. Based on the calculation results, the profit per production is IDR 2,061,836 by producing 101 pcs of bitter melon seed variant coffee, 60 pcs of premium variant and 54 pcs of regular variant. The results of the sensitivity analysis of the Komocha coffee home industry are that it can produce coffee with a minimum raw material usage limit of 28 kg and a maximum of 32 kg. Limits for packaging costs are at least IDR 430,717.9. Then, for minimum labor costs of IDR 239,038.5 per person and for minimum machine working hours of 34 hours and minimum operational costs of IDR 2,482,139 per production.