FINAL YEAR PROJECT REPORT [FYP] - EXPI-STOCK: Business Inventory Management System: CT203: DEC 2025

NUREFAHUDA, KHAIRULL HAFIZ (2025) FINAL YEAR PROJECT REPORT [FYP] - EXPI-STOCK: Business Inventory Management System: CT203: DEC 2025. Project Report. UPTM.

Text NUREFAHUDA BINTI KHAIRULL HAFIZ (AM2311015223).pdf Download (11MB)

Abstract

Wardah Baiduri is a Malaysian retail enterprise that currently faces significant operational challenges in managing product expiry dates and inventory rotation, relying heavily on manual Excel-based tracking methods that result in substantial financial losses. The shop experiences approximately RM25,000 in annual losses due to expired products, with 8-12 products being missed monthly through current manual checking processes. With these critical issues in mind, this initiative is aimed to develop a comprehensive web-based inventory management system called EXPI-STOCK, which will provide automated expiry tracking, proactive alert notifications, and efficient FIFO (First-In, First-Out) and FEFO (First Expired, First Out) priority displays to enhance operational effectiveness and reduce product waste. The given system comprises two distinct user roles: administrators and staff members, each with role- based access control. The system offers essential functions such as automated batch tracking with unique identifiers, multi-interval alert notifications at 30, 7, and 3 days before expiry, color-coded FIFO/FEFO priority displays with visual urgency indicators using red for critical status, yellow for warning status, and green for safe status, mobile-responsive interfaces for on-the-go access, and comprehensive reporting capabilities for inventory analytics. The dashboard utilized by administrators enables authorized personnel to manage products, create batches, configure alert thresholds, generate reports, and oversee user accounts, while staff members can view product lists, update batch quantities, monitor FIFO and FEFO priorities, and respond to expiration alerts with minimal training requirements. The system also provides responsive web design ensuring accessibility across desktop computers and mobile devices, maintaining consistent functionality throughout different operational contexts in the retail environment. The Waterfall methodology is employed within the scope of this project through six sequential phases: requirements analysis gathering stakeholder needs through interviews and questionnaires achieving 0.89 Cronbach's Alpha reliability, system design creating UI/UX mockups and database architecture, implementation using HTML5, CSS3, and JavaScript for frontend with PHP and MySQL for backend operations, comprehensive testing including unit, integration, system, and user acceptance testing with 100% positive staff endorsement, deployment to web server with automated backup procedures, and ongoing maintenance with continuous monitoring and enhancement capabilities. The development tools involve Visual Studio Code as the primary IDE, Git and GitHub for version control, Figma for interface design, and Firebase platform for authentication and cloud hosting services. The functional requirements were validated through systematic data gathering from 12 staff respondents revealing 95% preference for FIFO and FEFO priority displays, 90% demand for automated alerts, and 91.7% definite interest in system adoption. It is demonstrated that this project provides substantial business value by modernizing inventory processes with expected 60-70% reduction in expired product losses saving RM15,000-17,000 annually, 70-80% reduction in administrative time from 10 hours to 2-3 hours weekly, and establishing scalable infrastructure supporting future multi-location expansion while contributing to advancement of inventory management practices in Malaysia's retail sector.RetryClaude can make mistakes. Please double-check responses.

Item Type:	Monograph (Project Report)
Uncontrolled Keywords:	EXPI-STOCK: Business Inventory Management System, CT203
Divisions:	Faculty of Computing and Multimedia (FCOM)
Depositing User:	Library3 UPTM
Date Deposited:	20 May 2026 08:49
Last Modified:	20 May 2026 08:49
URI:	http://eprints.uptm.edu.my/id/eprint/5631

Actions (login required)

View Item