STOCK MANAGEMENT SYSTEM

Abstract

Most existing stock management system has several drawbacks which includes technical issues and downtime, some systems need intensive training of employees in order to use the software effectively which takes time, some system rely on data storage and processing, raising concerns about data security and privacy. Some are not portable and so create a dependency on technology and difficulty in keeping old records. This study aims to develop a Stock Management System that utilizes a client-server model and a connected database to track the sale of items, interpret data, and support multiple stores and warehouses. The system plays a crucial role in controlling material movement, storage, and transactions within a warehouse, including shipping, receiving, put away, and picking. It optimizes warehouse utilization and helps determine the economic order quantity and reorder point for each product, enabling cost-cutting measures during economic slowdowns. The proposed system implements a web application for warehouse management and product performance tracking, facilitating accurate reordering, forecasting, and demand analysis. The system ensures proper inventory management by effectively tracking incoming and outgoing inventories. This will enable decision makers to initiate accurate re-order and make forecast and demand of the product at any point in time and a proper management of inventories.