DA Coffee Sales Forecasting and Descriptive Analytics System for Data-driven Decisions

Abstract

This study focuses on the development of an offline Android application titled DA Coffee Sales Forecasting and Descriptive Analytics System for Data-Driven Decisions, designed to address the challenges of manual sales tracking and inventory monitoring in small enterprises. The system aims to improve operational efficiency by automating sales recording, visualizing top-selling products, and generating data-based insights to support smarter decision-making.The project utilizes descriptive analytics to interpret historical sales data and basic forecasting to anticipate short-term sales trends. These analytics are presented through bar and line charts, helping the business shift from intuition-based management to data-informed decisions. Developed using Flutter, Dart, Android Studio, and SQLite, the system provides a lightweight and fully offline mobile platform suitable for areas with limited internet access. It ensures smooth transaction recording, secure local data storage, and clear data visualization through the fl_chart library. The study employed a Developmental Research Design using the Waterfall Model of the System Development Life Cycle (SDLC). Fifty respondents—composed of 30 users and 20 technical experts—evaluated the system’s quality and performance based on ISO 25010 software standards. Results showed that both respondent groups rated the system “Agree” in functionality, reliability, efficiency, and usability, proving it effective, user-friendly, and responsive. However, both groups rated portability as “Disagree,” indicating compatibility issues on certain Android devices.
The study concludes that the DA Coffee system significantly improves sales management by enabling faster, more accurate, and organized data handling even offline. It demonstrates how descriptive analytics and basic forecasting can transform small business operations into data-driven decision-making processes. Future improvements should focus on enhancing portability, expanding forecasting models, and adding cloud synchronization features for broader usability.