DECISION SUPPORT SYSTEM FOR OPTIMIZING FINISHED GOODS INVENTORY AT PT. HESED INDONESIA USING THE EOQ (ECONOMIC ORDER QUANTITY) METHOD

Keysa Kalina Elbaraka, Yoannes Romando Sipayung

Abstract


This study aims to design and implement a Decision Support System (DSS) to optimize the management of finished goods inventory at PT. Hesed Indonesia using the Economic Order Quantity (EOQ) method. In the manufacturing industry, one of the main challenges in the supply chain is maintaining the availability of finished goods at optimal levels to avoid overstocking which results in excessive storage costs and understocking, which can impede distribution processes. To address this challenge, the EOQ method is employed for its effectiveness in determining optimal order quantities, annual demand, and per-unit storage costs. This research adopts a case study approach with a quantitative methodology. The data collected includes annual demand for finished goods, ordering costs, and storage costs provided by the company. The processed data using the EOQ formula serves as the basis for developing a system capable of generating recommendations for optimal order quantities and ordering frequencies. The DSS is designed to deliver timely and accurate information to assist managerial decision-making regarding inventory control. The results demonstrate that the implementation of the EOQ-based DSS significantly reduces total inventory costs and enhances the company’s operational efficiency. Moreover, the system facilitates data-driven decision-making and minimizes subjectivity in inventory management. With the implementation of this system, PT. Hesed Indonesia is expected to manage its finished goods inventory more effectively and adaptively in response to market demand fluctuations.


References


A. H. Jan and F. Tumewu, “Analisis Economic Order Quantity (Eoq) Pengendalian Persediaan Bahan Baku Kopi Pada Pt. Fortuna Inti Alam,” J. EMBA J. Ris. Ekon. Manajemen, Bisnis dan Akunt., vol. 7, no. 1, 2019, doi: 10.35794/emba.v7i1.22263.

M. Tamba, “Menggunakan Metode Moving Average Berbasis Client Server Pada Pt . Union,” vol. VIII, no. 1, pp. 1–18, 2019.

Hani Nurrohmah and Widya Retno Prasinta, “Penerapan Metode EOQ (Economic Order Quantity) dalam Meningkatkan Efisiensi Manajemen Inventori : Studi Kasus pada Toko Pakaian Lenkka di Majalengka,” Ekon. Jurnal Ilm. Manajemen, Ekon. Bisnis, Kewirausahaan, vol. 12, no. 1, pp. 1036–1050, 2024, doi: 10.30640/ekonomika45.v12i1.3685.

G. G. Prabawa, I. G. M. Darmawiguna, and I. M. A. Wirawan, “Pengembangan Sistem Pendukung Keputusan Pengendalian Persediaan Barang Menggunakan Metode Economic Order Quantity (Eoq) Dan Min-Max Berbasis Web (Studi Kasus : Apotek Sahabat Qita),” J. Nas. Pendidik. Tek. Inform., vol. 7, no. 2, p. 107, 2019, doi: 10.23887/janapati.v7i2.12221.

N. Juni, S. Pengendalian, I. Di, P. T. Sinergi, and K. Utama, “Implementasi Metode Economic Order Quantity (Eoq) Dalam Sistem Pengendalian Inventory Di Pt Sinergi Kreasi Utama,” J. Ilm. M-Progress, vol. 13, no. 2, pp. 137–149, 2023, doi: 10.35968/m-pu.v13i2.1067.

M. Alnahhal, B. L. Aylak, M. Al Hazza, and A. Sakhrieh, “Economic Order Quantity: A State-of-the-Art in the Era of Uncertain Supply Chains,” Sustainability, vol. 16, no. 14, p. 5965, 2024, doi: https://doi.org/10.3390/su16145965.

H. J. Zietsman and J. H. van Vuuren, “A generic decision support framework for inventory procurement planning in distribution centres,” Comput. Ind. Eng., vol. 177, p. 109057, 2023, doi: https://doi.org/10.1016/j.cie.2023.109057.

A. Cantini, M. Peron, F. De Carlo, and F. Sgarbossa, “A decision support system for configuring spare parts supply chains considering different manufacturing technologies,” Int. J. Prod. Res., vol. 62, no. 8, pp. 3023–43, 2022, doi: https://doi.org/10.1080/00207543.2022.2041757.

M. Y. Jaber and J. Peltokorpi, “Economic order/production quantity (EOQ/EPQ) models with product recovery: A review of mathematical modeling (1967–2022),” Appl. Math. Model., vol. 129, pp. 655–672, 2024, doi: https://doi.org/10.1016/j.apm.2024.02.022.

C. Singh and G. R. Ambedkar, “Optimizing EOQ model for expiring items with stock, selling cost and lifetime dependent demand under inflation,” OPSEARCH, vol. 60, no. 1, pp. 174–187, 2023, doi: https://doi.org/10.1007/s12597-022-00616-x.

E. L. Hutahaean, M. Safii, and B. E. Damanik, “Implementasi Algoritma Apriori Pada Sistem Persediaan Barang,” JIKO (Jurnal Inform. dan Komputer), vol. 3, no. 3, pp. 173–180, 2020, doi: https://doi.org/10.33387/jiko.

R. Dwinanto, P. Moengin, and S. Adisuwiryo, “Perancangan Sistem Pendukung Keputusan Untuk Pengendalian Persediaan Bahan Baku Pada Pt. Batarasura Mulia,” J. Tek. Ind., vol. 7, no. 3, 2018, doi: 10.25105/jti.v7i3.3140.

D. A. Septiana, R. Transistari, and J. Angela, “Optimasi Persediaan Bahan Baku Kain Produk Garmen dengan Metode Economic Order Quantity,” Cakrawangsa Bisnis J. Ilm. Mhs., vol. 3, no. 1, pp. 45–66, 2022, doi: 10.35917/cb.v3i1.297.

M. Andiana and G. Pawitan, “Aplikasi Metode EOQ Dalam Pengendalian Persediaan Bahan Baku PT X,” J. Akunt. Maranatha, vol. 10, no. 1, pp. 30–40, 2018, doi: 10.28932/jam.v10i1.926.

H. L. Nararya, A. N. Daulay, and S. Aisyah, “Implementasi Metode Activity Based Costing (Abc) Dan Economic Order Quantity (Eoq) Dalam Pengendalian Bahan Baku Di Konfeksi Erstore Medan,” J. Manaj. Terap. dan Keuang., vol. 13, no. 02, pp. 350–362, 2024, doi: 10.22437/jmk.v13i02.33002.

A. P. Putra, J. Arifin, and D. Parlindungan, “Aplikasi Metode EOQ Dalam Efisiensi Total Biaya Persediaan dan Optimasi Pengendalian Persediaan Bahan Baku Thinner di PT. XYZ,” J. Serambi Eng., vol. 8, no. 3, pp. 6680–6687, 2023, doi: 10.32672/jse.v8i3.6296.




DOI: https://doi.org/10.33387/jiko.v8i3.10725

Refbacks

  • There are currently no refbacks.