Pengendalian Persediaan Pakan Lele dengan Metode Forecasting dan Economic Order Quantity pada Easy Farm Indonesia

Abstract

Easy Farm Indonesia menghadapi risiko overstock dan outstock yang mengganggu produksi serta efisiensi biaya. Penelitian ini meramalkan kebutuhan pakan, menentukan jumlah pemesanan ekonomis (EOQ), Safety Stock, Reorder Point, frekuensi dan waktu pemesanan optimal, serta menganalisis biaya persediaan menggunakan Trend Analysis, EOQ, Total Inventory Cost, dan otomatisasi perhitungan VBA Excel. Hasil peramalan menunjukkan kebutuhan pakan 2025 sebesar 84.579,94 kg. Penerapan EOQ menurunkan total biaya persediaan dari Rp21.315.980 menjadi Rp11.976.306 (efisiensi 44%), mengurangi frekuensi pemesanan dari 17 menjadi 6 kali per tahun, dan meningkatkan laba bersih 6%. Model ini menjadi acuan strategis untuk efisiensi, menjaga ketersediaan stok, dan mendukung keberlanjutan usaha.

Easy Farm Indonesia faces the risk of overstock and outstock, which can disrupt production and reduce cost efficiency. This study aims to forecast feed requirements, determine the Economic Order Quantity (EOQ), Safety Stock, Reorder Point, and the optimal ordering frequency and timing, as well as analyze inventory costs. The methods employed include Trend Analysis, EOQ, Total Inventory Cost, and automated calculations using VBA in Microsoft Excel. The 2025 feed requirement is projected at 84.579,94 kg. Implementing the EOQ model reduced total inventory costs from Rp21.315.980 to Rp11.976.306 (44% efficiency), decreased the ordering frequency from 17 to 6 times per year, and increased net profit by 6%. This inventory management model provides a strategic reference for improving efficiency, ensuring stock availability, and supporting the sustainability of Easy Farm Indonesia operations.