Claim Missing Document
Check
Articles

Found 1 Documents
Search

Application of Economic Order Quantity (EOQ) for Controlling Raw Material Inventory of Paper Packaging Based on Sales Data Processing Sabella Nur Afni; Handoyo Widi Nugroho
Journal of Research in Social Science and Humanities Vol 6, No 2 (2026)
Publisher : Utan Kayu Publishing

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.47679/jrssh.v6i2.660

Abstract

Efficient inventory control is essential in the competitive packaging industry to minimize costs amid fluctuating sales demand. Prior studies, such as the manual application of Economic Order Quantity (EOQ) to soybean raw-material inventory in Jember tofu factories, demonstrated substantial cost reductions but lacked integration with information technology, sales-data analytics, and demand forecasting. This research addresses the gap by applying IT-based EOQ analysis to real salesdata.Salestransaction data (August 2022–November 2023) were processed in Python via GoogleColabfollowing the research flow: data cleaning and product-name normalization, descriptive statistics, monthly-trend visualization, Holt’s Linear Trend exponential smoothing for three-month demand forecasting, and EOQ calculation for the top-selling product using actual ordering and holding costs.Dupleks310 emerged as the top product, followed by CraftLaminasi290, Ivory230, Dupleks350, and FoodpakMatte245. Monthly sales peaked at approximately Rp 260 million in July 2023. Holt’s model forecasted continued demand growth; EOQ produced an optimal order quantity that minimizes total inventory costs compared with current practices.Integrating information technology, sales-data visualization, forecasting, and EOQ provides a scalable, data-driven framework that overcomes the limitations of manual EOQ applications. The approach delivers significant cost savings and supports sustainable decision-making for SMEs.