Sistem Prediksi Penggunaan Bahan Baku Berbasis Odoo pada UMKM Permak dan Jahit Hafizh menggunakan Metode Least Square

Micro, Small, and Medium Enterprises (MSMEs) play a significant role in economic development, especially in developing countries like Indonesia. In addition to supporting the economy, MSMEs help alleviate unemployment. Hafizh Permak and Jahit, an MSME in Semarang City, faces challenges in managing raw material usage, which can increase production costs and the risk of overstocking or understocking. This study aims to develop a web-based raw material usage prediction system using Odoo and the least square method, based on raw material usage data from Hafizh Permak and Jahit from January 2022 to December 2023. The least square method is applied to 20 types of raw materials. The study results demonstrate the ability to predict raw material usage with an average MAPE of 8.2%, indicating excellent predictive accuracy. Besides predicting raw material usage, this research supports stock management and guides the raw material purchasing process for Hafizh Permak and Jahit in subsequent months.