Date of Publication :29th June 2023

Abstract: The study aimed to develop a web-based decision support system for sales monitoring and trend analysis of a restaurant in the Philippines. It was developed using Hypertext Pre-processor (PHP), Hyper Text Markup Language (HTML), Java Scripting, Bootstrap and Sublime editor for the designing and MySQL for the database. Decision Tree Algorithm using Python was used to analyze the customer’s preferences and sales trend forecast. Users’ acceptance and Information System impact was evaluated based on a five-point Likert scale by the end-users. The result exhibited that the system’s individual impact, organizational impact, system quality, and information quality met the needs of each users as it was able to perform tasks and input data from the individual users; capable of increasing performance and productivity by streamlining processes through converting manual to digitized transactions, and eliminate redundant processes as it produce reports from sales, customer orders, and inventory of products which improves performance and cost-effectiveness; and provide data accurately with forecasting and predictive analysis and can run both on web and mobile-based applications. Nonetheless, the system should be used as it met the needs of each users and provide the business a competitive advantage.

Reference :