Predictive LPG Inventory Management System with Real-time Analytics 

The Predictive LPG Inventory Management System with Real-time Analytics is a web-based platform that helps households manage cooking gas cylinders by forecasting consumption patterns and automating reordering. Using a 5-day moving average algorithm, the system analyzes daily usage history to calculate remaining gas days and triggers automated email alerts when levels become critical (≤3 days remaining). The platform supports dual-role access: Users can record consumption, view real-time cylinder status, request bookings, and generate PDF/Excel reports; Administrators manage user approvals, track booking statuses (PENDING→BOOKED→SHIPPING→DELIVERED), and access system analytics. Built with Spring Boot, MySQL, JPA/Hibernate, React, and integrated with Gmail SMTP for email notifications, the system demonstrates practical application of predictive analytics in household resource management. Key outcomes include elimination of unexpected gas shortages, improved consumption awareness, streamlined inventory oversight, and data-driven replenishment decisions.

Keywords: Predictive LPG Inventory Management; Real-time Analytics; Moving Average Prediction; Cylinder Consumption Tracking; Spring Boot; Automated Booking Alerts; Role-based Access Control; PDF/Excel Report Generation; Threshold-based Notification System.