Claim Missing Document
Check
Articles

Development of Sales Forecasting and Stock Optimization System Using Least Square and Safety Stock Andika Gosal; Agung Brastama Putra; Seftin Fitri Ana Wati
bit-Tech Vol. 8 No. 3 (2026): bit-Tech
Publisher : Komunitas Dosen Indonesia

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.32877/bt.v8i3.3388

Abstract

The ongoing digital transformation across business sectors has encouraged micro and small enterprises to adopt information systems that enable accurate data processing and more strategic decision-making. CV. Ragam Jaya is one such business that still depends on manual processes for recording sales transactions and monitoring inventory, resulting in inconsistent stock data, delayed reporting, and limited capability to analyze demand patterns. To address these challenges, this study develops a web-based forecasting and inventory optimization system that integrates Least Square–based demand prediction with Safety Stock calculations. The Rapid Application Development (RAD) framework is utilized to accelerate system construction through iterative prototyping and continuous user involvement. Data were collected through interviews and direct observations to capture operational issues in the existing workflow. The system provides automated forecasting, inventory management, and stock buffer recommendations, enabling users to interpret demand trends more effectively. Experimental evaluation shows that the forecasting module achieves stable trend estimation with an average deviation of less than 8% from historical sales data, indicating strong alignment with actual demand behavior. Blackbox testing was conducted on core modules transactions, forecasting, reporting, and stock optimization and all tests achieved a 100% pass rate, demonstrating consistent system reliability and robustness. The integration of Least Square forecasting and Safety Stock significantly improves inventory planning accuracy by reducing manual discrepancies and supporting timely replenishment decisions. Overall, the developed system is effective in enhancing operational efficiency, minimizing human error, and improving stock control for small distribution businesses seeking to transition toward digitalized management practices.
Co-Authors Abdul Rezha Efrat Najaf Agung Brastama Putra Agussalim Agussalim Agussalim Agussalim, Agussalim Aisha Safa Asy'ari Akbar Izdihar Alfiansyah Adi Pranata Amalia Anjani Arifiyanti Amalia Putri Amanda Salsabilla Hidayah Anastasia Lidya Maukar Anastasia Lidya Maukar Anastasia Lidya Maukar Andika Gosal Anik Vega Vitianingsih Anik Vega Vitianingsih Anik Vega Vitianingsih Anik Yuesti Anindo Saka Fitri Anita Wulansari Anita Wulansari Anita Wulansari Anita Wulansari Anita Wulansari, S.Kom., M.Kom Annisa Lusyani Zahra Apol Pribadi Arsya Amalia Ristias Asyari, Aisha Safa Athallah Bariq Hidayat Brillyan Putra Pradana Carisca Rizky Sanyoko Carissa Renatasari Cendana Putri Aulia Condro Widodo, S.E., M.S.A Daud Arya Rafa Dayu Renita Dea Puspita Anggraeni Dhian Satria Yuda Kartika Dhian Satria Yudha Kartika Diah Hari Suryaningrum Diarany Sucahyati Dinda Adisty Yudianto Putri Ditha Lozera Devi Dwi Shahita Efriza Cahya Narendra Eliezer M Putra S Eristya Maya Safitri Eristya Maya Safitri Eristya Maya Safitri Eristya Maya Safitri Farhan Setiyo Darusman Feby Dwiputra Setyawan Fitri, Anindo Saka Hafiz Ilham Ardana Helmy Wahyu Sukiswo Heni Lusiana Dewi I Gusti Ayu Sri Deviyanti Icha Sinaga Ignathia Martha Hendrati Imam Ghozali Indrawati Yuhertiana Intania Rachman Martapura Izra Noor Zahara Aliya Kesya Sakha Nesya Arimawan Khalid Rijaluddin Litafira Syahadiyanti Mahadevi Katarina Sabila Mariska Regina RahmaPutri Moch. Syaiful Riza Mochammad Syaiful Riza Moh raihan Romadhoni Moh Rifqi Zamzami Moh Riswandha Imawan Moh. Azzam Priyanto Mohamad Ilham Praditya Arifatul Nesta Mohammad Farizd Muhammad Faiq Al Abiyyi Nani Astuti Triana Nasywa Zahira Ramadhani Nurhaba Djiha Patrisius Ando Duran Paulina April Romaito Pakpahan Permatasari, Reisa Prasasti Karunia Farista Ananto Prisa Marga Kusumantara Priyandini Pramithasari Putu Anggi Suryantari Raden Muhammad Syah Arief Atmaja Wijaya Ratih Aisyah Ravino Rahman Rendi Panca Wijanarko Rima Tsaniyah Amilatus Sholihah Rizka Hadiwiyanti Rudy Andree Hermawan Sesilia Tiara Rahayu Ada Syachla Malikha Tarisa Kamilia Tarisa Kamilia Venira Citra Sabrina Wahyuni, Eka Dyar Wibowo, Nur Cahyo Wilma Cordelia Izaak