Streamlining Inventory Forecasting with Weighted Moving Average Method at Parta Trading Companies

Kadek Suryadana,Ida Bagus Gede Sarasvananda
DOI: https://doi.org/10.70103/galaksi.v1i1.2
2024-05-31
Abstract:The process that is currently running at Parta trading companies, along with its development, problems that often occur in the warehouse section arise, namely the accumulation of stock of goods, there are even some stock items that are not available in the warehouse. This happens because the demand for goods from consumers is uncertain at any time, because the warehouse staff still use manual methods, namely making guesses in controlling stock checks and resulting in orders for stock of goods to be purchased that do not match the number of consumer needs at any time. In overcoming the problems experienced by Parta trading companies, the author built an inventory forecasting information system, where this system can assist in the inventory forecasting process which can calculate the estimated number of goods to be purchased based on previous sales data. Based on Black Box Testing, this system runs as expected. From the problems and solutions described above, a website-based inventory forecasting system was created with the ability to predict a product or item in the future, where this system plays a very important role in being used for stock availability in the warehouse at Parta trading companies. This result of forecasting test was carried out by analyzing the sales of ceramic products sold at Parta trading companies for a period of 1 year and 12 months, where in the test using the 3-month method in month 12, the MAD error value was 100.66666666667, in the 4-month method in month 12, the MAD error value was 186, in the 5-month method in month 12, the MAD error value was 166.2, the 6-month method in month 12, the MAD error value was 160.619048.
What problem does this paper attempt to address?