Web-Based F&B Lazatto Product Sales and Stock Prediction System with Double Moving Average (DMA) Method

This study aims to develop a web-based sales and stock prediction system for Lazatto, a Food and Beverage (F&B) company, using the Double Moving Average (DMA) method. The background of this research is based on issues stock requirement planning is still done conventionally, where the head of the restaurant places stock orders solely based on personal experience and intuition, without utilizing past sales data as a basis for decision-making, which often result in overstocking or stockouts. By implementing a web-based forecasting information system, the company can obtain real-time and structured data. This study uses sales data from April 2024 to March 2025. The prediction results show a downward trend in sales for the "Kentang" (Potato) product, with a forecasted value of 107.33 for April 2025, compared to an actual value of 95. Model evaluation indicates an average MAPE of 21.19%, which is considered a "fair" level of forecasting accuracy. Additionally, the time required for weekly stock planning was reduced, and interviews with staff revealed increased user satisfaction and ease of use. The developed system has proven to support more accurate and efficient decision-making in inventory management.

Authors

Institutions

Publication Details

Journal
Journal of Applied Informatics and Computing
Published
2025-08-07
DOI
https://doi.org/10.30871/jaic.v9i4.10012
Primary Topic
Management and Optimization Techniques
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
article

Web-Based F&B Lazatto Product Sales and Stock Prediction System with Double Moving Average (DMA) Method

Muhamad Alda, Dzira Faza Zarasky
1 links
Journal of Applied Informatics and Computing
Management and Optimization Techniques
article

Web-Based F&B Lazatto Product Sales and Stock Prediction System with Double Moving Average (DMA) Method

Muhamad Alda, Dzira Faza Zarasky
article en

Abstract

This study aims to develop a web-based sales and stock prediction system for Lazatto, a Food and Beverage (F&B) company, using the Double Moving Average (DMA) method. The background of this research is based on issues stock requirement planning is still done conventionally, where the head of the restaurant places stock orders solely based on personal experience and intuition, without utilizing past sales data as a basis for decision-making, which often result in overstocking or stockouts. By implementing a web-based forecasting information system, the company can obtain real-time and structured data. This study uses sales data from April 2024 to March 2025. The prediction results show a downward trend in sales for the "Kentang" (Potato) product, with a forecasted value of 107.33 for April 2025, compared to an actual value of 95. Model evaluation indicates an average MAPE of 21.19%, which is considered a "fair" level of forecasting accuracy. Additionally, the time required for weekly stock planning was reduced, and interviews with staff revealed increased user satisfaction and ease of use. The developed system has proven to support more accurate and efficient decision-making in inventory management.

Journal of Applied Informatics and ComputingVol. 9(4)
Universitas Islam Negeri Sumatera Utara (ID)
Openalex Percentile: Top 65%
Management and Optimization Techniques
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.