An Adaptive Web-Based Inventory Control System for Universities

Abstract

Managing inventories is one of the major challenges that organizations such as tertiary institutions are facing. Most of the stocks kept in organizations are characterized by excessive inventory on hand, raw materials losing their quality, improper sourcing methods, poor personnel management skills, etc. There also exists a lack of accurate and timely information. In order to arrest these deficiencies, an adaptive web-based inventory control system was developed. The current inventory in the storage unit of Olusegun Agagu University of Science and Technology (OAUSTECH), Okitipupa was captured. Collection of data from the Procurement and Store Unit was done through interviews, observation of record books, and some printable data. The system was implemented using PHP, HTML files, BOOTSTRAP, and MySQL. The outcomes are the generation of timely alert messages and reports to management when the inventory level reaches an out-of-stock threshold, computation of various inventory analyses such as price levels, lead-time analysis, replenishment period demand analysis, vendors' delivery performance, and generation of low-cost stock recommender system.