Penggunaan Metode Time-Series Forecasting untuk Mengefisiensikan Manajemen Inventaris Perusahaan XYZ

Aurelie Handalia Hermawan, Gerald Garcia, Hulbert Noble Le Mayer, Inez Susanto, Muhammad Alfirya, Rahzel Ziya Nabigha, Safriyana Safriyana

Abstract


XYZ Company, a local perfume company in Indonesia, repeatedly faces problems in their monthly operations, such as stockout and overstock issues due to fluctuating demand and uncertain production lead times from manufacturers. This phenomenon risks reducing product availability, hindering cash flow, and lowering consumer trust and experience. To address this situation, the study evaluated four time-series forecasting methods (3-Period Moving Average, 5-Period Moving Average, Simple Exponential Smoothing, and Holt’s Double Exponential Smoothing) using sales data from the year 2024 until early 2025 and measured their accuracy using MAD, MSE, and MAPE. The results showed that the Simple Exponential Smoothing method produced the lowest error (MAD 185,92; MSE 78.207,25; MAPE 12,53%), making it most suitable for the characteristics of fluctuating short-term demand. Based on the forecast, XYZ company is advised to set a safety stock of 613 units and a reorder point of 2.109 units to maintain availability during lead time. Further recommendations include forecasting per variant category, consideration of marketing activities in demand projections, and negotiation of lead time commitments with manufacturers as risk mitigation.


Keywords


forecasting; inventory management; moving average; reorder point; safety stock; simple exponential smoothing

Full Text:

PDF

References


Abolghasemi, M., Beh, E., Tarr, G., & Gerlach, R. (2020). Demand Forecasting in Supply Chain: The Impact of Demand Volatility in The Presence of Promotion. Computers & Industrial Engineering, 142, 106380. https://doi.org/10.1016/j.cie.2020.106380.

Arsi, F., Nasirly, R., & Nurhikmah, N. (2025). Perbandingan Tiga Metode Peramalan Pada Permintaan CPO di PT. Inti Indosawit Subur. Jurnal Teknik Industri Terintegrasi (JUTIN), 8(1), 1451-1457.

Asynari, E., Wahyudi, D., & Aeni, Q. (2020). Analisis Peramalan Permintaan Pada Geprek Bensu Menggunakan Metode Time Series. JURTEKSI (Jurnal Teknologi dan Sistem Informasi), 6(3), 215-220.

Derbel, M., Aljuaid, A. M., & Hachicha, W. (2022). Empirical Safety Stock Estimation Using GARCH Model, Historical Simulation, and Extreme Value Theory: A Comparative Study. Applied Sciences, 12(19), 10023. https://doi.org/10.3390/app12191002.

Fildes, R., & Kingsman, B. (2011). Incorporating Demand Uncertainty and Forecast Error in Supply Chain Planning Models. The Journal of the Operational Research Society, 62(3), 483–500. https://www.jstor.org/stable/41058925.

Harly, J., Nababan, M., Bintang, L. H., Rizal, R. A., & Aisyah. (2023). Comparison of Single Exponential Smoothing Method with Double Exponential Smoothing Method Prediction of Salt Sales. Jurnal Sistem Informasi Dan Ilmu Komputer Prima (JUSIKOM PRIMA), 6(2), 1–5. https://doi.org/10.34012/jurnalsisteminformasidanilmukomputer.v6i2.336.

Hidayati, S., Suroso, E., & Sartika, D. (2020). Analisis Peramalan Permintaan dan Pengendalian Persediaan Bahan Baku Pembantu pada Industri Gula (Studi Kasus PT. XYZ Lampung Utara). Jurnal Penelitian Pertanian Terapan, 20(2), 148-160.

Hsu, M.-L., Li, H. H., & Li, S. T. (2025). ARIMA-Driven Memory Market Insights: Forecasting DRAM Spot Price. Asia Pacific Management Review. Advance online publication. https://doi.org/10.1016/j.apmrv.2024.03.003.

Hyndman, R. J., & Koehler, A. B. (2006). Another Look at Measures of Forecast Accuracy. International Journal of Forecasting, 22(4), 679–688. https://doi.org/10.1016/j.ijforecast.2006.03.001.

Kumar, L., Khedlekar, S., & Khedlekar, U. K. (2024). A Comparative Assessment of Holt Winter Exponential Smoothing and Autoregressive Integrated Moving Average for Inventory Optimization in Supply Chains. Supply Chain Analytics, 8, 100084. https://doi.org/10.1016/j.sca.2024.100084.

Lestari, L. D., & Dwijayanti, R. (2022). Pengaruh Fenomena HARBOLNAS (Hari Belanja Online Nasional) Pada E-commerce Shopee melalui Diskon dan Kemudahan Bertransaksi Terhadap Keputusan Pembelian. Jurnal Pendidikan Tata Niaga (JPTN), 10(1), 1482–1491. https://doi.org/10.26740/jptn.v10n1.p1482-1491.

Lusiana, A., & Yuliarty, P. (2020). Penerapan Metode Peramalan (Forecasting) Pada Permintaan Atap di PT X. Industri Inovatif: Jurnal Teknik Industri, 10(1), 11–20. https://doi.org/10.36040/industri.v10i1.2530.

Nemtajela, N., & Mbohwa, C. (2017). Relationship between Inventory Management and Uncertain Demand for Fast Moving Consumer Goods Organisations. Procedia Manufacturing, 8, 699–706. https://doi.org/10.1016/j.promfg.2017.02.090.

Peltz, E., Robbins, M., & McGovern, G. (2012). Supplier and Inventory Management Integration. In Integrating the Department of Defense Supply Chain (pp. 55–74). RAND Corporation. http://www.jstor.org/stable/10.7249/j.ctt1q60t9.14.

Pivac, J., Štimac, I., Bartulović, D., & Lonjak, I. (2025). Planning the Airport Terminal Facilities Based on Traffic Demand Forecast and Dominant Share of Airline Business Model: Case Study of Pula Airport. Applied Sciences, 15(5), 2547. https://doi.org/10.3390/app1505.

Putri, S. (2025). Proposed Business Process Improvement Using Lean Warehouse Approach at National Distribution Center of PT XYZ (Doctoral dissertation, Universitas Andalas).

Rachman, R. (2018). Penerapan Metode Moving Average dan Exponential Smoothing Pada Peramalan Produksi Industri Garment. Jurnal Informatika, 5(2), 211-220.

Russell, R. S., & Taylor, B. W. (2023). Operations and Supply Chain Management (11th ed.). Wiley Global Education US. https://bookshelf.vitalsource.com/books/9781119905622.

Saptaria, L. (2017). Analisis Peramalan Permintaan Produk Nata De Coco untuk Mendukung Perencanaan dan Pengendalian Produksi dalam Supply Chain dengan Model CPFR (Collaborative Planning, Forecasting, and Replenishment). Jurnal Nusantara Aplikasi Manajemen Bisnis, 2(2), 130-141.

Sidqi, F., & Sumitra, I. D. (2019). Forecasting Product Selling Using Single Exponential Smoothing and Double Exponential Smoothing Methods. IOP Conference Series: Materials Science and Engineering, 662(3), 032031. https://doi.org/10.1088/1757-899x/662/3/032031.

Sukolkit, N., Arunyanart, S., & Apichottanakul, A. (2024). An Open Innovative Inventory Management based Demand Forecasting Approach for The Steel Industry. Journal of Open Innovation: Technology, Market, and Complexity, 10(4), 100407. https://doi.org/10.1016/j.joitmc.2024.100407.

Syafriani, D., & Suendri, S. (2024). Perfume Sales Application using the Economic Order Quantity (EOQ) Method. SISTEMASI, 13(2), 420-431.

Wu, L., Liu, S., & Yang, Y. (2016). Grey Double Exponential Smoothing Model and Its Application on Pig Price Forecasting in China. Applied Soft Computing, 39, 117–123. https://doi.org/10.1016/j.asoc.2015.09.054.




DOI: https://doi.org/10.37058/jem.v11i2.17772

Refbacks

  • There are currently no refbacks.


Copyright (c) 2025 Jurnal Ekonomi Manajemen

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

Creative Commons License
Jurnal Ekonomi Manajemen by Program Studi Manajemen Fakultas Ekonomi Universitas Siliwangi is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Based on a work at http://jurnal.unsil.ac.id/index.php/jem.