PriceVisionPriceVisionReal-Time Price Monitoring for Farmers, Consumers & Sellers in Panabo City
PriceVision is a data-driven system developed at Davao del Norte State College and deployed at the City Agriculture Office (CAGRO) of Panabo City. It delivers real-time price tracking, trend visualization, and short-term forecasting for agricultural commodities.
PriceVision is a market intelligence and commodity price monitoring system designed to promote transparency in agricultural and basic commodity pricing in Panabo City, Davao del Norte. It addresses the long-standing problem of inconsistent, manually-collected, and delayed market data in local public markets.
The system was developed by fourth-year BSIT students of the Institute of Computing, Davao del Norte State College and is implemented at the City Agriculture Office (CAGRO) of Panabo City. It supports farmers, traders, consumers, and policymakers in making timely, well-informed decisions on pricing, production, and inventory management.
PriceVision is built for every participant in Panabo City's agricultural supply chain.
Gain accurate price forecasts and trend insights to plan harvest timing, negotiate better selling prices, and anticipate demand fluctuations.
Monitor grocery price changes, identify affordable buying periods, report price gouging, and make smarter household budgeting decisions.
Track competitor pricing, adjust retail strategies, and manage inventory using reliable, up-to-date market data from CAGRO Panabo.
The City Agriculture Office uses system data for evidence-based policy development, market intervention planning, and price regulation.
The system's methodology, data models, and architecture serve as a reference for future innovations in agricultural price monitoring.
Access aggregated market intelligence and forecasting outputs to support food security initiatives and anti-price-gouging enforcement.
Everything needed to monitor, analyze, and forecast commodity prices — all in one platform.
Interactive charts display historical minimum, maximum, and average prices across commodity categories, making complex data easy to understand.
Weekly price forecasting using SARIMA, Holt-Winters, and Prophet to predict the next four weeks with measurable accuracy metrics (MAE, RMSE, MAPE).
Customers submit reports of unusually high prices with store details and photo proof. Admins receive real-time notifications to act quickly.
Category-based browsing across Staple Foods, Vegetables, Fruits, Meat & Fish, and Pantry Items with live search to locate any commodity instantly.
Generate and export monthly market price records as Excel or PDF files for data archiving, regulatory reporting, and offline analysis.
Role-based access for Admins and Staff. Admins manage accounts, data, and reports. All access is protected by secure login authentication.
Three industry-grade statistical models were tested. SARIMA was selected as the primary model based on accuracy benchmarks.
Excels when long historical datasets with predictable seasonal cycles are available. Highly interpretable and produced the lowest error metrics in PRICEVISION evaluations.
Requires minimal computing power and delivers accurate short-to-medium-term forecasts. Widely used in retail analytics and agricultural market monitoring.
Breaks time-series data into trend, seasonality, and holiday effects. Resilient to missing data and sudden market shifts — a strong candidate for future integration.
Three standard metrics are used: MAE (Mean Absolute Error), RMSE (Root Mean Squared Error), and MAPE (Mean Absolute Percentage Error). Lower values across all three indicate a more accurate forecast.
Evaluated using the ISO/IEC 25010 Software Quality Model. All characteristics received "Strongly Agree" ratings from admin and staff users.
Price data, forecasting & monitoring meet user needs.
Fast retrieval, minimal lag, efficient resource use.
Intuitive interface, clear navigation, easy labels.
Consistent performance, quick error recovery.
Protected accounts, secure auth, data privacy.
Easy to update; supports future improvements.
Works across devices, browsers, and screen sizes.
Accessible online anytime, easy to deploy.
Interpreted as "Strongly Agree" — indicating high user satisfaction and system effectiveness across all ISO 25010 quality characteristics.
A modern full-stack combination ensuring reliability, performance, and scalability.
Server-side scripting & database integration
Centralized database for prices & reports
Dynamic dashboards & chart visualizations
SARIMA, Holt-Winters & Prophet models
Local Apache + MySQL + PHP environment
Primary code editor for the full project
PriceVision was successfully presented, deployed, and implemented at the City Agriculture Office — recognized with an official Certificate of Completion.
The City Agriculture Office of Panabo City issued a Certificate of Completion certifying that Carl Andre Y. Arquilita, Jay Mark M. Gegremosa, Jenver J. Lara, and Adriane Hanz L. Taporco — fourth-year BSIT students of the Institute of Computing, Davao del Norte State College — successfully presented, deployed, and implemented PriceVision at their office.
The PriceVision team with CAGRO Panabo staff during system handover and certificate awarding.
We extend our deepest gratitude to the City Agriculture Office of Panabo City for their trust, guidance, and support throughout the development and deployment of PriceVision. This system is dedicated to the farmers, consumers, and vendors of Panabo City.
PriceVision was developed by students of the Institute of Computing, Davao del Norte State College, New Visayas, Panabo City.
Leads discussions, decision-making, and overall project direction.
Responsible for frontend and backend development of the system.
Oversees planning, requirements analysis, and system architecture.
Conducts research and interviews to define system requirements.
Project Adviser: John Jefferson L. Dela Cruz, MIT | Institute of Computing, Davao del Norte State College · May 2026