Claim Missing Document
Check
Articles

Found 1 Documents
Search
Journal : Teknomekanik

Comparative analysis of the least squares method and double moving average technique for forecasting product inventory Yondri, Surfa; Meidelfi, Dwiny; Lestari, Tri; Sukma, Fanni; Mutia, I.S
Teknomekanik Vol. 7 No. 1 (2024): Regular Issue
Publisher : Universitas Negeri Padang

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.24036/teknomekanik.v7i1.29672

Abstract

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.
Co-Authors - Yulherniwati - Zurnawita -, Juandi -, Nofrizal . Zulfan Abdullah, Noryusliza Ade Irma Suryani Adnin, Sandri Afdal Afrima Deki - Afrizal Fauzi Afrizal Yuhanef Alde Alanda, Alde Aldo Erianda Aldo Erianda Aldo Erianda Aldo Erianda, Aldo Andre F Kasmar Andre Febrian Kasmar Anggie Meifriyan Pratama Anggie Meyfrian Pratama Azmi, Haryuni Cecilya Hamedeko Cindy Klaudya Putri Danny Athaya Deddy Prayama Defni, - Deni Wahyuni Dikky Chandra Dion Setiawan Eliyanora Fanni Sukma Fanni Sukma Fanni Sukma Fanni Sukma Farhan Rinsky Mulya Fikri Maulana, Fikri Firdaus, - Hanriyawan Adnan Mooduto Hanriyawan Adnan Moodutor Hendrick Heru Samudera Hidra Amnur Hind Ra'ad Ebraheem Humaira, Humaira Huriati, Putri Indri Rahmayuni Jihan Fadhilah Jonas, Anna Hendri Soleliza Kamaludin, Hazalila Kharisma, Srintika Yunni Lathifah Hanum M. Ikhsan Gumanof Marisa Ayu Saphira Maulidani, Farhan Meri Azmi Meri Azmi Meri Azmi Meza Silvana Mohammad Aljanabi Mohd Arfian Ismail Mohd Farhan Md Fudzee Moodutor, Hanriyawan Adnan Muhammad Ariq Hendry Muhammad Ilham Muhlis, Farid Alfajr Mursydan, Arif Mutia, I.S Nazirah, Nurul Ain Novi Novri Novri Novri Rahmat Hidayat Ramadhani, - Rasyidah, - Richy Azura Rika Idmayanti Rika Idmayanti Rika Idmayanti Rinaldi Rinaldi Rino Sukma Rita Afriyenni Ronal Hadi Rusfandi, - Safar, Noor Zuraidin Mohd Salman Alfarissy Salsabila Delaisya Permana Sandri Adnin Shahreen Kasim Shahreen Kasim, Shahreen Sitepu, Dana Bahari Sri Yusnita Sri Yusnita Sukma, Fanni Surfa Yondri Taufik Hidayat Tri Lestari Tri Lestari Vienne Anggelica Kurnia Vivi Hasti Mayanti Wahid, Norfaradilla Wahyudi, Eri Wati, Yenni Wina Rahma Fitri Yance Sonatha Yee, Lee Ruo Yulherniwati Yulherniwati, - Yulindon Zahraa Faiz Hussain Zahri Hasanati Zazkia, Rahmi Zulfitri, Alvin Faiz