Melola Discovery

← Melola Discovery

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

DOI
10.24036/teknomekanik.v7i1.29672
ISSN
2621-8720, 2621-9980
Terbit
2024-06-27
Penerbit
Universitas Negeri Padang
Bahasa
eng
Lisensi
creativecommons.org/licenses/by/4.0

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.

Kata kunci

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
Rekan penulisOrganisasiArtikel bersama
Eries Dyah MustikariniUniversity of Bangka Belitung1
Yuditia Arta KencanaUniversity of Bangka Belitung1
Ratna DamayantiUniversitas Airlangga1
Ratih Novita PrajaUniversitas Airlangga1
Ragil Angga PrastiyaUniversitas Airlangga1
Prima Ayu WibawatiUniversitas Airlangga1
Boedi SetiawanUniversitas Airlangga1

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>