Apllication Of The Moving Average Forecasting Method In Masonry Concrete Sales


Penerapan Metode Peramalan Moving Average Untuk Peramalan Penjualan Beton Masonry


  • (1) * Mochammad Romi            Universitas Muhammadiyah Sidoarjo  
            Indonesia

  • (2)  Boy Isma Putra            Universitas Muhammadiyah Sidoarjo  
            Indonesia

    (*) Corresponding Author

Abstract

This study aims to create a concrete sales forecasting system using the moving average method to predict sales for the next month in order to determine the amount of production that must be supplied in the next period. The study uses the moving average method which is widely used and has accuracy in forecasting. The results obtained mean error of 32630.95, MAD of 224532, MSE of 80977550000, standard error of 318154, Mape of 12.621% and average forecast of 1960074.0. The study implies that the moving average method is an effective tool for sales forecasting and can be used to make informed decisions about production planning and estimating future growth

Highlight :

  • The study aims to create a concrete sales forecasting system using the moving average method.
  • The moving average method is an effective tool for sales forecasting and can be used to make informed decisions about production planning and estimating future growth.
  • The study provides statistical measures such as mean error, MAD, MSE, standard error, and MAPE to evaluate the accuracy of the moving average method.

Keywords: Sales forecasting, Moving average method, Production planning, Accuracy, Informed decisions.

Downloads

Download data is not yet available.

References

M. Rizal, D. R. Indah, and R. Meutia, "Analisis Peramalan Produksi Menggunakan Trend Moment pada Kilang Padi Do‟a Ibu Diperlak Kecamatan Peureulak," J. Samudra Ekon., vol. 5, no. 2, pp. 161–168, 2021. DOI: https://doi.org/10.33059/jse.v5i2.4274

T. Baroto, "Perencanaan dan Pengendalian Produksi," 2002.

N. Hudaningsih, S. F. Utami, and W. A. A. Jabbar, "Perbandingan Peramalan Penjualan Produk Aknil PT. Sunthi Sepurimennguanakan Metode Single Moving Average dan Single Exponential Smoothing," JINTEKS, vol. 2, no. 1, pp. 15–22, 2020. DOI: https://doi.org/10.51401/jinteks.v2i1.554

Suseno and S. Wibowo, "Penerapan Metode ARIMA dan SARIMA pada Peramalan Penjualan Telur Ayam pada PT Agromix Lestari Group," JTMIT, vol. 2, no. 1, pp. 33–40, 2023. DOI: https://doi.org/10.55826/tmit.v2iI.85

Hernadewita, Y. K. Hadi, M. J. Syaputra, and D. Setiawan, "Peramalan Penjualan Obat Generik Melalui Time Series Forecasting Model pada Perusahaan Farmasi di Tangerang: Studi Kasus," JIEMAR, vol. 1, no. 2, pp. 35–49, 2020.

Saefudin, D. Susandi, and F. Nafis, "Sistem Peramalan Penjualan Paving Block Menggunakan Metode Single," JSII, vol. 8, no. 2, pp. 75–81, 2021. DOI: https://doi.org/10.30656/jsii.v8i2.3727

S. H. Santosa, A. P. Hidayat, and R. Siskandar, "Analisis Permintaan Telur Ayam Menggunakan Metode Peramalan Kuantitatif, Studi Kasus: Agen Telur ABC Chicken Egg Demand Analysis Using Quantitative Forecasting Method, Case Study: ABC Egg Agent," Indones. J. Sci., vol. 3, no. 1, pp. 1–9, 2022. [Online]. Available: http://journal.pusatsains.com/index.php/jsi

A. Kumila, B. Sholihah, E. Evizia, N. Safitri, and S. Fitri, "Perbandingan Metode Moving Average dan Metode Naïve dalam Peramalan Data Kemiskinan," JTAM | J. Teor. dan Apl. Mat., vol. 3, no. 1, p. 65, 2019, doi: 10.31764/jtam.v3i1.764. DOI: https://doi.org/10.31764/jtam.v3i1.764

M. K. Mollah and A. D. Saputra, "Penerapan Peramalan Penjualan Menggunakan Aplikasi POM QM pada Produk Gula di CV. Pabrik Gula Candi Baru Sidoarjo," Semin. Nas. Teknol. Ind. Berkelanjutan II (SENASTITAN II), vol. 2, pp. 449–458, 2022.

A. R. Pardosi and I. Iriani, "Analisis Perencanaan Peramalan dan Safety Stock Sprite 250ML dengan Metode Time Series di PT. XYZ Universitas Pembangunan Nasional 'Veteran' Jawa Timur Service Level & Out of Stock Warehouse, Dimana Project Tersebut Tujuan Utamanya Adalah Tersebut Dip," JUPITER, vol. 2, no. 2, pp. 10–21, 2024.

Picture in here are illustration from public domain image (License) or provided by the author, as part of their works
Published
2024-02-20
 
How to Cite
[1]
M. Romi and B. I. Putra, “Apllication Of The Moving Average Forecasting Method In Masonry Concrete Sales”, PELS, vol. 5, pp. 27-31, Feb. 2024.