Abstract

Core Transaction 2–Restaurant Management System was developed to enhance restaurant operations under Project Soliera through digital integration. This study focused exclusively on the restaurant component, addressing operational challenges such as inefficient order processing, inaccurate billing, weak inventory control, and limited access to sales data. The system automates essential restaurant functions to improve workflow efficiency and support data-driven managerial decisions. A key feature is the integration of Metabase business intelligence, used solely for restaurant sales analytics to generate dashboards, visual insights, and exportable reports for monitoring revenue and performance. The study followed a system development approach consisting of planning, design, development, and testing phases. The system includes modules for table and event reservations, point-of-sale (POS) and billing, menu management, kitchen order ticketing (KOT), table turnover monitoring, wait staff management, customer reviews, and user management. An inventory module tracks stock levels, estimates inventory lifespan based on consumption rates, and projects restocking costs in Philippine Peso. Metabase was integrated exclusively for restaurant sales data analysis. Functional testing was conducted to ensure accuracy, reliability, and usability. Functional testing indicated that the system supported ordering, billing, inventory monitoring, kitchen-order coordination, and restaurant sales reporting. The predictive inventory function estimated stock lifespan and projected restocking costs, while Metabase dashboards displayed revenue trends and peak sales periods. The system integrates core restaurant-management functions and provides revenue-focused dashboards and reports.