Using Forecasting Methods to Increase the Accuracy of Container Demand Requirement: An Indonesian Case Study

Yelita Anggiane Iskandar; Niko Andri Purba

doi:10.31334/logistik.v8i1.4124

Using Forecasting Methods to Increase the Accuracy of Container Demand Requirement: An Indonesian Case Study

Yelita Anggiane Iskandar, Niko Andri Purba

Abstract

PT Crieta Logistics ships goods in containers. In carrying out its business, the company often experiences lost sales which are caused by the unavailability of containers so that the orders can be fulfilled. From January to July 2022, PT Crieta Logistics experienced lost sales of 21, 9, 12, 34, 19, 4 and 2 TEUs respectively. Therefore, in this study forecasting the number of requests for containers at PT Crieta Logistics conducted to make decisions related to handling demand for containers in the coming period. This forecasting result served as a basic input to establish policies of container availability, such as whether to reorganize contracts with vendors or others. The forecasting is done using 3 methods, namely linear, quadratic, and exponential regression with historical data of 2 years from July 2020 to July 2022. In determining the most accurate forecasting method, the error value is calculated using the mean absolute percentage error (MAPE) method. In the linear regression method, the MAPE value is 9.5%, while in the quadratic method, the MAPE value is 9%, and in the exponential method, the MAPE value is 9.2%. The quadratic method was chosen as the method suitably used in forecasting the next 12 periods because it has the smallest MAPE value. Forecasting demand using the quadratic method produces 12,631 units of containers for the next 12 periods, from August 2022 - July 2023.

Keywords

Full Text:

PDF

References

Rr. A. Y. Widyastuti, “BPS: Pertumbuhan Ekonomi Sepanjang Tahun 2021 Capai 3,69 Persen,” https://bisnis.tempo.co/read/1558217/bps-pertumbuhan-ekonomi-sepanjang-tahun-2021-capai-369-persen.

J.-F. Arvis et al., Connecting to Compete 2018: Trade Logistics in the Global Economy. World Bank, Washington, DC, 2018. doi: 10.1596/29971.

M. Reza, “The Relationship between Logistics and Economic Development in Indonesia: Analysis of Time Series Data,” Jurnal Teknik Industri, vol. 15, no. 2, Dec. 2013, doi: 10.9744/jti.15.2.119-124.

B. J. Cudahy, Box Boats: How Container Ships Changed The World. Fordham Univ Press, 2007.

B. Wirjodirdjo, A. G. Budianto, I. N. Pujawan, and I. Maflahah, “Container Yard Planning Layout Model Considering Demand and Lost Sale Container,” in Proceedings of the 2020 2nd international conference on management science and industrial engineering, 2020, pp. 314–318.

K. K. Lai, K. Lam, and W. K. Chan, “Shipping Container Logistics and Allocation,” Journal of the Operational Research Society, vol. 46, no. 6, pp. 687–697, 1995.

S. Gupta and M. K. Starr, Production and Operations Management Systems, vol. 4. CRC Press Boca Raton, 2014.

N. Luh et al., “Peramalan Permintaan Produk Perak Menggunakan Metode Simple Moving Average dan Exponential Smoothing,” 2014.

C. Andrade, “A Student’s Guide to the Classification and Operationalization of Variables in the Conceptualization and Design of a Clinical Study: Part 1,” Indian J Psychol Med, vol. 43, no. 2, pp. 177–179, Mar. 2021, doi: 10.1177/0253717621994334.

A. Ubaidillah and S. I. Kholida, “Forecasting of Computer Network Performance with Quadratic Equation,” MATEC Web of Conferences, 2016, doi: 10.1051/conf/2016.

K. Nurfadilah, A. Sauddin, and W. Saputri, “Rice Production Forecasting Using Exponential Smoothing Method,” Eigen Mathematics Journal, pp. 21–26, Jun. 2022, doi: 10.29303/emj.v5i1.127.

C. Kasemset, N. Sae-Haew, and A. Sopadang, “Multiple Regression Model for Forecasting Quantity of Supply of Off-season Longan,” Chiang Mai University Journal of Natural Sciences, vol. 13, no. 3, pp. 391–402, 2014, doi: 10.12982/cmujns.2014.0044.

J. J. Montaño Moreno, A. Palmer Pol, A. Sesé Abad, and B. Cajal Blasco, “Using The R-MAPE Index as A Resistant Measure of Forecast Accuracy,” Psicothema, vol. 25, no. 4, pp. 500–506, 2013, doi: 10.7334/psicothema2013.23.

M. Sari and I. Iftadi, “Selecting The Best Forecasting Method at PT Indaco Warna Dunia,” 2023.

A. Raharja, W. Angraeni, and R. A. Vinarti, “Penerapan Metode Exponential Smoothing untuk Peramalan Penggunaan Waktu Telepon di PT Telkomsel Divre3 Surabaya,” Jurnal Sistem Informasi SISFO, vol. 14, no. 2, pp. 1–9, 2010.

DOI: https://doi.org/10.31334/logistik.v8i1.4124