RELTRACK: A Web-based System for Inventory, Appointments, and Sales Forecasting Based on Predictive Analytics and Linear Regression for REL Glass and Aluminum Works

A web-based inventory management systems have emerged as a powerful tool that enable businesses to streamline operations, enhance efficiency and increase overall productivity. in the context of business, scheduling an appointment for a service-based company is important to gain potential clients and gain profit. digital scheduling tools has benefits such as real-time updates and automated reminders. sales forecasting is the process of predicting future revenue based on market trends, historical data, and other relevant factors, has always been an essential tool for leading strategic decisions and business success. this study implies that a linear regression model effectively forecasts sales performance by identifying relationships between key variables. the findings demonstrated that linear regression not only predicts future revenue but also guides strategic business decisions. the company rel glass and aluminum works focuses on selling glass and aluminum products and offers different services such as installation, repair, measurement and consultation. it was established in 2021 and was founded by the lo family. This study uses an applied research and developmental research design. the researcher proposed a web-system that aims to solve the issues of rel glass and aluminum. the developers will create a web-system that handles inventory such as tracking stock-in and stockout real-time, appointment tracker which is designed to list all client schedules and a sales forecasting module helps the business owner to be guided on business decision making. the researchers will use surveys, interviews and observation to collect data. the sdlc methodology chosen is agile model. agile model is a flexible and easy to execute project planning guide for developing the software system of reltrack. the agile model can be broken into 6 stages which consist of requirements gathering, design, development, testing, implementation and maintenance. the study involves 2 respondent groups which includes 80 users and 20 it experts, making a total of 100 participants in the study. the system is evaluated using iso 25010 includes functional suitability, usability, reliability, performance efficiency, security and portability. The reltrack system was developed by researchers to help rel glass and aluminum works change its manual record management into a web-based inventory, appointment, and sales management system. the system integrates multiple business functions in order to manage clients, suppliers, and inventory all in one place. it also has built-in sales prediction features that help stakeholders make better decisions. The system met the iso 25010 software quality standards in all six categories. according to the evaluation findings from 100 respondents which are grouped into two, users and technical experts. the technical experts show a significantly lower mean score of 3.4 compared to the user's total mean score which is 3.6 the weighted means across the two groups range from 3.2 to 3.8. for future researchers, the system requires further improvement. reltrack system does not provide customer booking functionality, the current system solely rely on linear regression as the predictive model. reltrack is recommended to consider cloud migration for scalability of the business and could also consider modules for customer sentiment analysis, automated appointment reminders, and ai-based pricing optimization. lastly, continuous improvement to the system's interface and scalability is needed.