Forecast sales volume of aviation fuel in Jakarta using ARIMA Method to support inventory control
DOI:
https://doi.org/10.55324/ijoms.v3i4.804Keywords:
Arima forecasting, safety inventory, management inventoryAbstract
The civil aviation industry in Indonesia experienced a significant increase from 2009-2018. The increase occurred in passenger and cargo activities. However, the situation changed drastically when the Covid-19 pandemic occurred throughout the world in 2019. PT xyz as a company need to adapt and optimize the business process. Inventory management is something that can be optimized. The aim of this research was to forecast aviation fuel demand in Jakarta and utilize the forecast result as a basis for inventory management. This research utilizes time series data on aviation fuel sales to determine demand estimates for the following month. The method used to forecast is the Autoregressive Integrated Moving Average. Furthermore, the forecast data is combined with information on storage capacity and historical data on product supply arrivals as input data in calculating safety stock to obtain more economical inventory management. The result of this research is that the best forecast avtur demand in Jakarta is using Arima (1,1,1). Safety inventory calculation based on demand forecasting with 90% cycle service level for Jakarta is 42,495 kiloLiter and PT xyz still can reduce products in their storage worth IDR. 341.8 M in Jakarta to maintain the same cycle service level.
References
Achkar, V. G., Brunaud, B. B., Pérez, H. D., Musa, R., Méndez, C. A., & Grossmann, I. E. (2024). Extensions to the guaranteed service model for industrial applications of multi-echelon inventory optimization. European Journal of Operational Research, 313(1). https://doi.org/10.1016/j.ejor.2023.08.013
BPS. (2019). Statistik Transportasi Udara 2019.
Cardós, M., Babiloni, E., Palmer, M. E., & Albarracín, J. M. (2009). Effects on undershoots and lost sales on the cycle service level forperiodic and continuous review policies. 2009 International Conference on Computers and Industrial Engineering, CIE 2009. https://doi.org/10.1109/iccie.2009.5223854
Chopra, S., & Meindl, P. (2013). Supply chain management: Strategy, planning, and operation. Pearson.
Dey, B., Roy, B., Datta, S., & Ustun, T. S. (2023). Forecasting ethanol demand in India to meet future blending targets: A comparison of ARIMA and various regression models. Energy Reports, 9. https://doi.org/10.1016/j.egyr.2022.11.038
Direktorat Statistik Distribusi. (2019). Statistik Transportasi Udara 2018.
Fattah, J., Ezzine, L., Aman, Z., El Moussami, H., & Lachhab, A. (2018). Forecasting of demand using ARIMA model. International Journal of Engineering Business Management, 10. https://doi.org/10.1177/1847979018808673
Garcia-Buendia, N., Moyano-Fuentes, J., & Maqueira-Marín, J. M. (2021). Lean supply chain management and performance relationships: what has been done and what is left to do. CIRP Journal of Manufacturing Science and Technology, 32. https://doi.org/10.1016/j.cirpj.2021.01.016
Goltsos, T. E., Syntetos, A. A., Glock, C. H., & Ioannou, G. (2022). Inventory – forecasting: Mind the gap. European Journal of Operational Research, 299(2). https://doi.org/10.1016/j.ejor.2021.07.040
Gupta, A., & Maranas, C. D. (2003). Managing demand uncertainty in supply chain planning. Computers and Chemical Engineering, 27(8–9). https://doi.org/10.1016/S0098-1354(03)00048-6
Kourentzes, N., Trapero, J. R., & Barrow, D. K. (2020). Optimising forecasting models for inventory planning. International Journal of Production Economics, 225. https://doi.org/10.1016/j.ijpe.2019.107597
Makridakis, S., Wheelwright, S. C., & Hyndman, R. J. (1998). Forecasting methods and applications. McGraw Hill.
Pasaribu, J. S. (2021). Development of a Web Based Inventory Information System. International Journal of Engineering, Science and Information Technology, 1(2). https://doi.org/10.52088/ijesty.v1i2.51
Reyes, J., Mula, J., & Díaz-Madroñero, M. (2023). Development of a conceptual model for lean supply chain planning in industry 4.0: multidimensional analysis for operations management. Production Planning and Control, 34(12). https://doi.org/10.1080/09537287.2021.1993373
Santoso, M. H. (2021). Application of Association Rule Method Using Apriori Algorithm to Find Sales Patterns Case Study of Indomaret Tanjung Anom. Brilliance: Research of Artificial Intelligence, 1(2). https://doi.org/10.47709/brilliance.v1i2.1228
Singha, K., Buddhakulsomsiri, J., & Parthanadee, P. (2018). Optimal Cycle Service Level for Continuous Stocked Items with Limited Storage Capacity. KnE Life Sciences, 4(2). https://doi.org/10.18502/kls.v4i2.1659
Wibowo, W., Dwijantari, S., & Hartati, A. (2017). Time series machine learning: Implementing ARIMA and hybrid ARIMA-ANN for electricity forecasting modeling. Communications in Computer and Information Science, 788. https://doi.org/10.1007/978-981-10-7242-0_11
Downloads
Published
Issue
Section
License
Copyright (c) 2024 Ary Putra Setiyawan, Wahyu Wibowo, R. Mohamad Atok
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution-ShareAlike 4.0 International (CC-BY-SA). that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.
