Supply Control Of Oil Filter Spareparts Using EOQ And Min-Max Methods Based On Sales Forecast (Case Study: PT Astra International Tbk Soekarno Hatta)

https://doi.org/10.47194/ijgor.v5i1.284

Authors

Keywords:

Inventory Control, Economic Order Quantity, Min-Max, Forecasting

Abstract

Planning and controlling product inventory is very important for a company to ensure demand is met and maximize profits from sales effectively and efficiently. In addition, inventory planning and control are carried out to prevent excess or shortage of inventory. This study aims to predict sales and calculate inventory control to overcome excess stock and increased inventory costs on oil filter spare parts. The forecasting method used is Holt's Double Exponential Smoothing method to determine the number of sales of the four types of oil filter spare parts in the future and overcome the problem of oil filter spare parts inventory using the EOQ and Min-Max methods. Based on the research results, the resulting forecasting is accurate and the EOQ method results in a lower total inventory cost than the Min-Max method.

References

Fithri, P., Hasan, A., & Asri, F. M. (2019). Analysis of Inventory Control by Using Economic Order Quantity Model – A Case Study in PT Semen Padang. Jurnal Optimasi Sistem Industri, 116-124.

Kinanthi, A. P., Herlina, D., & Mahardika, F. A. (2016). Analisis Pengendalian Persediaa Bahan Baku Menggunakan Metode Min-Max (Studi Kasus PT. Djitoe Indonesia Tobacco). Peforma, 87-92.

Lesmana, E., Subartini, B., & Jabar, D. A. (2018, March). Analysis of forcasting and inventory control of raw material supplies in PT INDAC INT'L. In IOP Conference Series: Materials Science and Engineering (Vol. 332, No. 1, p.012015). IOP Publishing.

Makridakis, S., & Wheelwright, S. C. (2003). Forecasting Methods and Applications. The Forecasting Perspective.

Rizqi, Z. U., & Khairunisa, A. (2020). Integration of deterministic and probabilistic inventory methods to optimize the balance between overstock and stockout. In IOP Conference Series: Materials Science and Engineering (Vol. 722, No. 1, p. 012060). IOP Publishing.

Robayo-Salazar, R., Mejía-Arcila, J., de Gutiérrez, R. M., & Martínez, E. (2018). Life cycle assessment (LCA) of an alkali-activated binary concrete based on natural volcanic pozzolan: A comparative analysis to OPC concrete. Construction and Building Materials, 176, 103-111.

Roslin, N. E., Abdul Razak, S. N., Bahrom, M. Z., & Abd Rahman, M. A. (2015). A Conceptual Model of Inventory Management System using an EOQ Technique - A Case Study in Automotive Service Industry. Journal of Science & Engineering Technology.

Åženses, S. (2021). Development of a multi-scenario simulation model for spare parts inventory optimization in mining operations (Master's thesis, Middle East Technical University).

Siregar, M. J. (2021). Pengendalian Stock Spareparts Mobil dengan Metode EOQ dan Min-Max Inventory. Serambi Engineering, 2096-2101.

Syifahati, T., Triska, A., & Nahar, J. (2023). Forecasting the Indonesian Coffee Production and Consumption Using The Exponential Smoothing Methods with Modified Golden Section Search to Estimate the Smoothing Parameters. Jurnal Matematika Integratif, 41-54.

Published

2024-02-27