PERFUME SALES FORECAST USING THE METHOD WEIGHTED MOVING AVERAGE AND SINGLE MOVING AVERAGE
JURNAL TEKNISI · 2026
DOI: 10.54314/pwvv9x30 ↗Kurz gefasst
Fachartikel in der Zeitschrift JURNAL TEKNISI, 2026. Verfasst von Astuti Br. Mangunsong und 5 weiteren Autor:innen. Die Arbeit nennt 10 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY-SA 4.0).
Abstract (Originalsprache)
Sales forecasting is an important activity in business management because it helps companies estimate future sales conditions. This study aims to analyze perfume sales forecasting using the Weighted Moving Average (WMA) and Single Moving Average (SMA) methods based on monthly sales data from June 2025 to May 2026. The forecasting process was carried out using Microsoft Excel. The results showed that the Weighted Moving Average method produced better forecasting accuracy because it prioritizes the latest data through weighting calculations. Forecasting accuracy was measured using MAD, MSE, and MAPE. Based on the calculation results, the WMA method produced smaller error values than SMA, making it more suitable for perfume sales forecasting. Keywords: forecasting; perfume sales; SMA; WMA Abstrak: Peramalan penjualan merupakan kegiatan penting dalam manajemen bisnis karena membantu perusahaan memperkirakan kondisi penjualan di masa mendatang. Penelitian ini bertujuan untuk menganalisis peramalam penjualan parfum menggunakan metode Weighted Moving Average (WMA) dan Single Moving Average (SMA) berdasarkan data penjualan bulanan periode Juni 2025 sampai Mei 2026. Proses perhitungan peramalan dilakukan menggunakan Microsoft Excel. Hasil penelitian menunjukkan bahwa metode Weighted Moving Average menghasilkan tingkat akurasi yang lebih baik karena lebih memprioritaskan data terbaru melalui pembobotan perhitungan. Tingkat akurasi peramalan diukur menggunakan MAD, MSE, dan MAPE. Berdasarkan hasil perhitungan, metode WMA menghasilkan nilai error yang lebih kecil dibandingkan metode SMA sehingga lebih sesuai digunakan dalam peramalan penjualan parfum. Kata kunci: peramalan; penjualan parfum; SMA; WMA
Zitieren
APA
Mangunsong, A. B., Amanda, J., Maitsa, N. A., Sari, N., Irawan, P. L., & Tanjung, R. M. (2026). PERFUME SALES FORECAST USING THE METHOD WEIGHTED MOVING AVERAGE AND SINGLE MOVING AVERAGE. JURNAL TEKNISI. https://doi.org/10.54314/pwvv9x30
Vancouver
Mangunsong AB, Amanda J, Maitsa NA, Sari N, Irawan PL, Tanjung RM. PERFUME SALES FORECAST USING THE METHOD WEIGHTED MOVING AVERAGE AND SINGLE MOVING AVERAGE. JURNAL TEKNISI. 2026. doi:10.54314/pwvv9x30
BibTeX
@article{Mangunsong2026,
author = {Mangunsong, Astuti Br. and Amanda, Juli and Maitsa, Nabiila Alya and Sari, Nurnilam and Irawan, Putri Lia and Tanjung, Riska Maulida},
title = {PERFUME SALES FORECAST USING THE METHOD WEIGHTED MOVING AVERAGE AND SINGLE MOVING AVERAGE},
journal = {JURNAL TEKNISI},
year = {2026},
doi = {10.54314/pwvv9x30}
}
EUVIMED