Cloud-Based Inventory System for Effective Management of Under and Over-stock Hazards

Abstract

Modern inventory system is now taking an advanced step to overcome under or overstock. However, it is observed that the One-Stop Centre OSCent at Kulliyyah of Engineering, International Islamic University Malaysia faces the problem of managing its inventory as the members in OSCent are students on a shift basis, as well as using the manual inventory system. Unrecorded item sold, mismanagement, overstock or even understock are the results of a manual system. We proposed a Cloud-Based Integrated Inventory System which uses the application of PHP and MySQL as the database. Interface design is constructed by using HTML, JavaScript, and Cascading Style Sheets. The complete system has been released to OSCent rated according to its functionality, interface, security level and performance. 55 per cent of the respondents rated the system to be very good, 23 per cent believe it is good while 17 per cent rated it average. In addition, 67 per cent admits that the interface is well designed by optimising the available pages and arrange the pages according to their main function. Efficiency was tested based on timing, OscentiS recorded 95 per cent faster than the manual method. While similar solutions for the inventory system is already available in the commercial market, the proposed system provides open-source software and low cost-solution that are affordable for OSCent specifically.