Jurnal Kewirausahaan dan Inovasi
Vol. 5 No. 2 (2026)

From Intuition to Optimization: Applying MRP to Reduce Feed Inventory Cost in Laying Hen Farms

Sheli Amanda, Dini (Unknown)



Article Info

Publish Date
20 Oct 2026

Abstract

Purpose – This study aims to describe the existing feed inventory system, design a Material Requirements Planning (MRP) system, evaluate its cost efficiency, and provide implementation recommendations for a small-to-medium-scale laying hen farm. The research seeks to improve inventory management and reduce feed-related costs, which constitute the largest component of production expenses. Design/Methodology/Approach – This study employs a descriptive quantitative approach with a problem-solving orientation. The research was conducted at a laying hen farm with approximately 11,500 chickens. Data were collected through interviews, non-participant observation, and industry-standard triangulation. The proposed inventory system utilizes a Material Requirements Planning (MRP) model incorporating dual-product optimization, shelf life-constrained Economic Order Quantity (EOQ), safety stock calculation, and reorder point analysis. Simulation was used to evaluate the efficiency of the proposed system. Findings – The findings indicate that the implementation of the proposed MRP system reduces total inventory costs by 31.9%, primarily through a 48% reduction in ordering costs, while maintaining zero stockouts. The results demonstrate that structured inventory planning using an Excel-based MRP system can significantly improve inventory efficiency and profitability without requiring specialized inventory management software. Originality/Value – This study contributes to operations and supply chain management literature by demonstrating the practical application of an Excel-based Material Requirements Planning (MRP) system integrated with shelf life-constrained EOQ, safety stock, and reorder point calculations in small-scale poultry farming. The proposed approach offers a low-cost, scalable, and replicable inventory management solution for agribusinesses seeking to enhance operational efficiency and profitability.

Copyrights © 2026






Journal Info

Abbrev

jki

Publisher

Subject

Decision Sciences, Operations Research & Management Environmental Science Social Sciences

Description

Publish all forms of quantitative and qualitative research articles and other scientific studies related to the field of Entrepreneurship Management and ...