Akses terbuka
Jurnal
SINTA 1
Comparative analysis of the least squares method and double moving average technique for forecasting product inventory
Teknomekanik · Vol. 7 No. 1 (2024) · hlm. 74–84
ISSN 2621-8720, 2621-9980
Terbit 2024-06-27
Penerbit Universitas Negeri Padang
Bahasa eng
Abstrak
The cosmetics industry necessitates efficient inventory management to balance customer demand with stock control. This case study explores how Liza Cosmetics Shop optimized inventory for Lip Cream Implora 01, a popular product, using data-driven forecasting techniques. Traditional trend-based methods often resulted in inaccurate forecasts. This study proposed implementing the SDLC Waterfall Model to apply two forecasting techniques: Least Squares and Double Moving Average. Historical sales data (April 2021 - June 2022) was analyzed to identify demand patterns, seasonality, and trends. The Least Squares method was chosen for its suitability in capturing stable, linear relationships between sales and time, while the Double Moving Average method catered to data exhibiting both long-term trends and short-term fluctuations. Rigorous testing using white-box and black-box methods ensured the accurate functionality and system behavior of the implemented models. The Mean Absolute Percentage Error (MAPE) determined the method best suited for predicting July 2022 demand. This case study contributes insights into data-driven inventory management in cosmetics, highlighting benefits such as optimized stock levels, reduced costs, and enhanced customer satisfaction through improved demand fulfillment. This studys’ limitations including unforeseen marketing campaigns and economic fluctuations impacting forecasts were acknowledged. Despite these challenges, the study emphasizes the potential of data-driven techniques to optimize inventory management and meet customer demands effectively.
Jaringan kolaborasi para penulis
12 penulis ·
28 tautan kepenulisan bersama
· 7 lintas organisasi
Arahkan kursor atau ketuk sebuah nama untuk menyorot rekan penulisnya. Klik dua kali untuk membuka halaman penulis.
Politeknik Negeri Padang Universitas Airlangga University of Bangka Belitung
Organisasi berbeda
Organisasi sama
Afiliasi tidak diketahui
Garis lebih tebal = lebih banyak artikel bersama · lingkaran lebih besar = lebih banyak artikel
Tampilkan sebagai tabel
Afiliasi berasal dari OpenAlex; metadata OAI-PMH jurnal tidak memuatnya. Penulis tanpa ID OpenAlex dicocokkan berdasarkan nama, sehingga dua orang bisa tergabung atau satu orang bisa terpisah.
Sumber metadata: OAI-PMH (metadata jurnal) http://teknomekanik.ppj.unp.ac.id/index.php/teknomekanik/oai, pertama di-harvest 10 Nov 2026, terakhir terlihat 10 Nov 2026.
Metadata asli (oai_dc)
<oai_dc:dc xmlns="http://www.openarchives.org/OAI/2.0/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:oai_dc="http://www.openarchives.org/OAI/2.0/oai_dc/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.openarchives.org/OAI/2.0/oai_dc/ http://www.openarchives.org/OAI/2.0/oai_dc.xsd">
<dc:title xml:lang="en">Comparative analysis of the least squares method and double moving average technique for forecasting product inventory</dc:title>
<dc:creator xml:lang="en">Yondri, Surfa</dc:creator>
<dc:creator xml:lang="en">Meidelfi, Dwiny</dc:creator>
<dc:creator xml:lang="en">Lestari, Tri</dc:creator>
<dc:creator xml:lang="en">Sukma, Fanni</dc:creator>
<dc:creator xml:lang="en">Mutia, I.S</dc:creator>
<dc:subject xml:lang="en">Industry, innovation and infrastructure</dc:subject>
<dc:subject xml:lang="en">Cosmetics industry</dc:subject>
<dc:subject xml:lang="en">Management production</dc:subject>
<dc:subject xml:lang="en">Demand prediction</dc:subject>
<dc:description xml:lang="en">The cosmetics industry necessitates efficient inventory management to balance customer demand with stock control. This case study explores how Liza Cosmetics Shop optimized inventory for Lip Cream Implora 01, a popular product, using data-driven forecasting techniques. Traditional trend-based methods often resulted in inaccurate forecasts. This study proposed implementing the SDLC Waterfall Model to apply two forecasting techniques: Least Squares and Double Moving Average. Historical sales data (April 2021 - June 2022) was analyzed to identify demand patterns, seasonality, and trends. The Least Squares method was chosen for its suitability in capturing stable, linear relationships between sales and time, while the Double Moving Average method catered to data exhibiting both long-term trends and short-term fluctuations. Rigorous testing using white-box and black-box methods ensured the accurate functionality and system behavior of the implemented models. The Mean Absolute Percentage Error (MAPE) determined the method best suited for predicting July 2022 demand. This case study contributes insights into data-driven inventory management in cosmetics, highlighting benefits such as optimized stock levels, reduced costs, and enhanced customer satisfaction through improved demand fulfillment. This studys’ limitations including unforeseen marketing campaigns and economic fluctuations impacting forecasts were acknowledged. Despite these challenges, the study emphasizes the potential of data-driven techniques to optimize inventory management and meet customer demands effectively.</dc:description>
<dc:publisher xml:lang="en">Universitas Negeri Padang</dc:publisher>
<dc:date>2024-06-27</dc:date>
<dc:type>info:eu-repo/semantics/article</dc:type>
<dc:type>info:eu-repo/semantics/publishedVersion</dc:type>
<dc:format>application/pdf</dc:format>
<dc:identifier>http://teknomekanik.ppj.unp.ac.id/index.php/teknomekanik/article/view/296</dc:identifier>
<dc:identifier>10.24036/teknomekanik.v7i1.29672</dc:identifier>
<dc:source xml:lang="en">Teknomekanik; Vol. 7 No. 1 (2024): Regular Issue; 74-84</dc:source>
<dc:source>2621-8720</dc:source>
<dc:source>2621-9980</dc:source>
<dc:language>eng</dc:language>
<dc:relation>http://teknomekanik.ppj.unp.ac.id/index.php/teknomekanik/article/view/296/83</dc:relation>
<dc:rights xml:lang="en">Copyright (c) 2024 Surfa Yondri, Dwiny Meidelfi, Tri Lestari, Fanni Sukma, I.S Mutia (Author)</dc:rights>
<dc:rights xml:lang="en">http://creativecommons.org/licenses/by/4.0</dc:rights>
</oai_dc:dc>
Sitasi dan pengindeksan
OpenAlex
Terindeks
lewat DOI
1 sitasi
Crossref
Belum diperiksa
Jumlah menurut tiap indeks pada 13 Nov 2026; setiap indeks menghitung sitasi dengan cara berbeda.
OpenAlex juga mencatat karya ini di: crossref.
Sitasi artikel ini
APA 7
Yondri, S., Meidelfi, D., Lestari, T., Sukma, F., & Mutia, I. (2024). Comparative analysis of the least squares method and double moving average technique for forecasting product inventory. Teknomekanik, 7(1), 74–84. https://doi.org/10.24036/teknomekanik.v7i1.29672
Salin
IEEE
S. Yondri, D. Meidelfi, T. Lestari, F. Sukma, and I. Mutia, “Comparative analysis of the least squares method and double moving average technique for forecasting product inventory,” Teknomekanik, vol. 7, no. 1, pp. 74–84, 2024, doi: 10.24036/teknomekanik.v7i1.29672.
Salin
Dibuat dari metadata jurnal; periksa nama penulis sebelum dipakai.