Journal of Research in Social Science and Humanities
Vol 6, No 2 (2026)

Application of Economic Order Quantity (EOQ) for Controlling Raw Material Inventory of Paper Packaging Based on Sales Data Processing

Sabella Nur Afni (Fakultas Ekonomi dan Bisnis, Institut Informatika dan Bisnis Darmajaya, Kota Bandar Lampung)
Handoyo Widi Nugroho (Fakultas Ekonomi dan Bisnis, Institut Informatika dan Bisnis Darmajaya, Kota Bandar Lampung)



Article Info

Publish Date
20 Jun 2026

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.

Copyrights © 2026






Journal Info

Abbrev

jrssh

Publisher

Subject

Religion Arts Humanities Economics, Econometrics & Finance Education Languange, Linguistic, Communication & Media Law, Crime, Criminology & Criminal Justice Library & Information Science Mathematics Social Sciences Other

Description

Journal Research of social science and Humanities is a peer-reviewed, international, and intercultural journal. It promotes interdisciplinary research with a primary focus on original research or reviews in humanities and social sciences. Articles are welcome in the following seven sections: ...