Forecasting Sales: A Comprehensive Analysis of Forecasting Techniques for Sales Budget Determination
DOI:
https://doi.org/10.32897/ajib.2023.2.2.3217Keywords:
Forecasting, Semi average method, Standard Error of Forecasting, Parameter X valueAbstract
This research endeavors to employ sales forecasting techniques on historical sales data for the purpose of determining the sales budget. The application of forecasting is based on sales data from the preceding period, utilizing a descriptive qualitative method. The analysis employs the half-average trend method, generating an estimated sales figure for the upcoming period. This estimate serves as a reference for both inventory planning and the formulation of the sales budget. Within this research, the half-average trend method involves the selection of two X parameter values, namely 0.5 and 0. To determine the superior value, a calculation of SKF (Standard Error of Forecasting) is executed. The analysis results reveal that utilizing the value 0 yields an SKF value of 4,166.6, while the value 0.5 produces a lower SKF value of 3,941.6. This implies that the estimated sales number with the X value of 0.5 is smaller than that with the X value of 0. Conclusively, the application of the half-average trend method in this research provides sales estimates for the next three months, contributing valuable insights for effective planning and budgeting processes.
References
Tarigan Vb, Nurhayati N. Penerapan Anggaran Penjualan Dalam Memperkirakan Penjualan. J Bus Econ Res. 2022;3(3):399–407.
Rahayu M. Analisis Penentuan Metode Peramalan Penjualan (Sales Forecast) Terhadap Penyusunan Anggaran Penjualan Lateks Pekat Dan Rubber Smoke Sheet (Rss) Pada Pt Huma Indah Mekar Tulang Bawang. J Manaj Dan Keuang. 2011;9(1):1–30.
Hariri Fr, Mashuri C. Sistem Informasi Peramalan Penjualan Dengan Menerapkan Metode Double Exponential Smoothing Berbasis Web. Gener J. 2022;6(1):68–77.
Mulyani S, Hayati D, Sari An. Analisis Metode Peramalan (Forecasting) Penjualan Sepeda Motor Honda Dalam Menyusun Anggaran Penjualan Pada Pt Trio Motor Martadinata Banjarmasin. Din Ekon Ekon Dan Bisnis. 2021;14(1):178–88.
Hariri Fr, Sari W, Mashuri C. Perbandingan Metode Double Exponential Smoothing Dan Simple Moving Average Pada Kasus Peramalan Penjualan. Teknol J Ilm Sist Inf. 2021;11(2):93–100.
Ginantra Nlwsr, Anandita Ibg. Penerapan Metode Single Exponential Smoothing Dalam Peramalan Penjualan Barang. J-Sakti (Jurnal Sains Komput Dan Inform. 2019;3(2):433–41.
Satria W. Jaringan Syaraf Tiruan Backpropagation Untuk Peramalan Penjualan Produk (Studi Kasus Di Metro Electronic Dan Furniture). Djtechno J Teknol Inf. 2020;1(1):14–9.
Amrullah A, Affandi E, Riansyah W, Sobirin S. Peramalan Penjualan Bulanan Menggunakan Metode Trend Moment Pada Toko Suamzu Boutique. J Saintikom (Jurnal Sains Manaj Inform Dan Komputer). 2020;19(2):46–53.
Saryanti Igad, Sidhiantari Igapi. Analisis Perancangan Aplikasi Peramalan Persediaan Barang Dagang Sederhana Dengan Metode Semi Average Method. J Tek Elektro Dan Komput. 2020;9(3):205–12.
Rizqiyani A, Langgeng A, Maulidah H. Analisis Peramalan Penjualan Menggunakan Metode Semi Average Dan Metode Least Square Pada Outlet Bumbu Ireng Yu San Cabang Adiwerna Kabupaten Tegal. Politeknik Harapan Bersama Tegal; 2021.
Diana M, Pruyudo B, Rukhviyanti N. Evaluating Financial Statement Presentation Compliance And Auditor Opinion Based On Bpk-Ri Examination: A Case Study In West Java Local Governments. J Audit Pajak, Akunt Publik. 2023;2(1):36–44.
Bhattacharya H. Total Management By Ratios: An Analytic Approach To Management Control And Stock Market Valuations. Sage Publications India; 2007.
Machfiroh Is, Sur Waa, Pangestu Rt. Trend Semi Average And Least Square In Forecasting Yamaha Motorcycle Sales. Barekeng J Ilmu Mat Dan Terap. 2022;16(1):343–54.
Miharja Sa, Santoso Ra. Analisis Anggaran Biaya Produksi Sebagai Alat Untuk Meningkatkan Efektivitas Pengendalian Biaya Produksi Di Cv Megasari Inti Sinergi. J Ilm Mhs. 2023;1(1):1–15.
Yusanto Y. Ragam Pendekatan Penelitian Kualitatif. J Sci Commun. 2020;1(1).
Lasendo R. Ta: Analisis Pertumbuhan Dan Peramalan Penjualan Produk Turunan Kelapa Sawit Dan Gula Pada Pt Tbl Tahun 2017-2021. Politeknik Negeri Lampung; 2022.
Anisa Sn, Agustin R, Santoso Ra. Analisis Anggaran Biaya Bahan Baku Pada Industri Rumah Tangga Pia Latief Kediri.
Mccloskey Dn, Ziliak St. The Standard Error Of Regressions. J Econ Lit. 1996;34(1):97–114.
Santoso Ra, Masitoh I. Analisis Kompetensi Sdm Dan Independensi Audit Internal Terhadap Kualitas Laporan Audit. J Audit Pajak, Akunt Publik. 2022;1(1):46–51.
Priyantini N, Santoso Ra, Wulandari E, Octaviani J. Analisa Anggaran Dan Realisasi Penjualan Perkebunan Kelapa Sawit Ptpn Iv Tahun 2022.
Downloads
Published
Issue
Section
License
Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution 4.0 International License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
