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.

Inventory, Appointment, Sales Management

1. Herlina, H., Hamied, Z. R., Hidayat, R., Mutakin, A. H., Lestari, N. S., & Hermawaty, H. (2023). Web-Based Inventory Management Application Using PHP and MySQL. International Journal of Computer and Information System (IJCIS), 4(2). https://www.ijcis.net/index.php/ijcis/article/vie w/194IJCIS [Google Scholar] [Crossref]

2. Liu, N., van de Ven, P. M., & Zhang, B. (2016). Managing Appointment Booking under Customer Choices. arXiv preprint arXiv:1609.05064. https://arxiv.org/abs/1609.05064arXiv [Google Scholar] [Crossref]

3. Zhang, Z. (2023). Sales Prediction Based on ARIMA Time Series and Multifactorial Linear Model. Highlights in Science, Engineering and Technology, 38, 5680.https://doi.org/10.54097/hset.v38i.5680 [Google Scholar] [Crossref]

4. Guleria, S. (2023, June 11). Web-based inventory management: A complete guide. Lio Blog. https://blog.lio.io/web-based-inventorymanagement/ [Google Scholar] [Crossref]

5. Guest Contributor. (2024, July 5). Improving accuracy: The benefits of digital tools in scheduling workflow. Cal.com. https://cal.com/blog/improving-accuracy-thebenefits-of-digital-tools-in-schedulingworkflow [Google Scholar] [Crossref]

6. Garcia, J. (2023). The Art of Sales Forecasting: How to Predict and Optimize your revenue. Improvitz Formerly Impactum. https://impactum.mx/the-art-of-salesforecasting-how-to-predict-and-optimize-yourrevenue/ [Google Scholar] [Crossref]

7. Issitt, M. (2024). General systems theory. EBSCO Research Starters. https://www.ebsco.com/researchstarters/history/general-systems-theory [Google Scholar] [Crossref]

8. Schwarz, L. (2024, January 30). What are inventory management controls? NetSuite. https://www.netsuite.com/portal/resource/articles/inventory-management/what-are-inventorymanagement-controls.shtml [Google Scholar] [Crossref]

9. Suresh, D., & Sivakumar, A. (2019, October). Impact of schedule management plan on project management effectiveness. International Journal of Engineering and Advanced Technology, 9(1), 3350–3355. https://doi.org/10.35940/ijeat.A1515.109119 [Google Scholar] [Crossref]

10. Chen, Keyi & Dong, Laya & Wang, Linxinyi. (2022). Linear Regression Model for Business Strategy: A Case Study of SMARTFOOD Company. https://www.researchgate.net/publication/3633 55010_Linear_Regression_Model_for_Business_Strategy_A_Case_Study_of_SMARTFOO D_Company [Google Scholar] [Crossref]

11. Anusha S. Rai A, & R. Srinivasa Rao Kunte. (2024). A Systematic Review of SaaS: A Case Study of Zoho Corporation and Its Products. In [Google Scholar] [Crossref]

12. Tech Horizon 2023, Advancing Frontiers in Computer Science & Information Technology (Version 1, Vol. 1, Number 1, pp. 23–41). Srinivas University. https://doi.org/10.5281/zenodo.10509137 [Google Scholar] [Crossref]

• Smart Iot Device for Weather And Health
• Merlarchive: A Web-Based Academic Hub for UDM With AI-Powered Natural Language Processing
• Enhanced Social Network Security System: Integrating Biometric Authentication for Improved User Verification and Privacy Protection
• Smart Budget Allocation in Public Policy: A Data-Driven Approach for Equitable Resource Distribution
• Decision Support System for Faculty Selection, Promotion, and Reclassification Using Predictive Analytics