Predictive Sales and Inventory System with Customer Segmentation for Enhance Customer Relationship Management

This study presents the design and development of a Predictive Sales and Inventory System with Customer Segmentation for Enhanced Customer Relationship Management. The system addresses operational inefficiencies in small retail businesses by integrating predictive analytics and clustering techniques. Linear regression was applied for sales forecasting, while K-means clustering was used for customer segmentation to support data-driven decision-making and personalized customer engagement. The platform automates sales transactions, inventory monitoring, and membership management, and supports RFID-based cashless payments. Development followed the Agile Scrum methodology, with modules including product management, transaction processing, analytics, reporting, and backup management. User Acceptance Testing based on the Technology Acceptance Model (TAM) yielded an overall weighted mean score of 4.68, indicating strong user acceptance, with one establishment expressing intent to adopt the system. System evaluation based on ISO/IEC 25010 quality standards produced an overall weighted mean score of 4.18, reflecting satisfactory performance in functionality, reliability, usability, and security. Results demonstrate that the system provides an efficient, browser-based, data-driven POS solution that improves transaction speed, operational accuracy, and business insight generation for Spot777 Coffee.

Agile Scrum, Predictive Analytics, K-Means Clustering, Customer Relationship Management

1. H. P. S. M. F. I. Ghorban Tanhaei, "Predictive analytics in customer behavior: Anticipating trends and preferences," vol. 17, 2024. [Google Scholar] [Crossref]

2. O. N. Akande, H. B. Akande, E. O. Asani and B. T. Dautare, "Customer Segmentation through RFM Analysis and K-means Clustering: Leveraging Data-Driven Insights for Effective Marketing Strategy," 2024. [Google Scholar] [Crossref]

3. S. R. &. L. Vuyyuru, "Unlocking future consumer insights: Using predictive analytics and AI to shape proactive retail strategies," European Journal of Advances in Engineering and Technology, p. 110–115, 2023. [Google Scholar] [Crossref]

4. J. Tang, "Unlocking Retail insights: predictive modeling and customer segmentation through data analytics," Journal of Theoretical and Applied Electronic Commerce Research, vol. 2, no. 20, p. 59, 2025. [Google Scholar] [Crossref]

5. R. K. &. N. N. Koppichetti, " Customer Retention with Predictive Analytics in the Retail Industry," International Journal of Multidisciplinary Research and Growth Evaluation, vol. 03, p. 776, 2022. [Google Scholar] [Crossref]

6. M. Z. Rodriguez et al., "Clustering algorithms: A comparative approach," PLoS One, 2019. [Google Scholar] [Crossref]

7. A. R. Mendoza, "POINT OF SALE SYSTEM WITH INVENTORY FOR ARM’S FOOD AND DELICACIES," International Journal of Advanced Research in Computer Science, vol. 14, no. 1, p. 1371, 2019. [Google Scholar] [Crossref]

8. Proceedings of the 2018 IEEE 10th International Conference on Humanoid, Nanotechnology, Information Technology, Communication and Control, Environment and Management, 2018. [Google Scholar] [Crossref]

• What the Desert Fathers Teach Data Scientists: Ancient Ascetic Principles for Ethical Machine-Learning Practice
• Comparative Analysis of Some Machine Learning Algorithms for the Classification of Ransomware
• Comparative Performance Analysis of Some Priority Queue Variants in Dijkstra’s Algorithm
• Transfer Learning in Detecting E-Assessment Malpractice from a Proctored Video Recordings.
• Dual-Modal Detection of Parkinson’s Disease: A Clinical Framework and Deep Learning Approach Using NeuroParkNet