DESIGN AND DEVELOPMENT OF A COMPUTER-BASED INVENTORY MANAGEMENT SYSTEM

CHAPTER ONE: INTRODUCTION
1.1 Background of the Study
Inventory management plays a vital role in the efficient operation of any organisation that deals with goods and materials. Effective inventory management ensures that the right quantity of products is available at the right time, in the right place, and at the right cost. It is a critical function that directly impacts customer satisfaction, operational efficiency, and profitability.
In today's competitive business environment, organisations must implement reliable systems to monitor inventory levels, process transactions, and ensure seamless operations. The rapid advancement of information technology has transformed how businesses manage their inventory, moving from traditional manual methods to sophisticated computer-based systems.
Traditional inventory management methods, such as paper records and spreadsheets, have proven inadequate in modern business environments. These methods are often:
• Error-prone: Manual data entry leads to inaccuracies and data loss.
• Inefficient: Time-consuming processes delay decision-making.
• Lack real-time visibility: Delayed updates prevent timely responses to stock fluctuations.
• Limited analytical capability: Difficulty in generating meaningful reports and insights.
The emergence of computer-based inventory management systems has revolutionised how organisations track and control their inventory. These systems provide real-time data processing, efficient report generation, and secure data storage. They enable organisations to automate key inventory operations, reduce human error, save time, and enhance decision-making.
For small and medium-sized enterprises (SMEs), which often operate with limited resources, the transition from manual to digital inventory management is particularly critical. Many SMEs still rely on manual tools like Excel, which become troublesome in terms of time and may lead to complications. However, commercial solutions like Zoho Inventory and QuickBooks Commerce are often complex and expensive for SMEs. This creates a pressing need for affordable, simplified, and user-tested inventory systems specifically designed for small-scale businesses.
1.2 Statement of the Problem
Despite the availability of information technology solutions, many organisations—particularly SMEs in developing regions—continue to rely on manual inventory management methods. The consequences of this reliance are significant:
1. Inaccurate Stock Records: Manual methods are prone to human error, leading to discrepancies between actual and recorded stock levels. This results in stock-outs (lost sales) or overstocking (tied-up capital).
2. Inefficient Operations: Manual processes are time-consuming, delaying order processing, stock updates, and decision-making.
3. Poor Decision-Making: Without accurate, real-time data, managers cannot make informed decisions about purchasing, pricing, or stock levels.
4. Data Loss and Security Issues: Paper records can be lost, damaged, or accessed by unauthorised personnel.
5. Lack of Automated Alerts: Without automated notifications, reorder points are often missed, leading to stock-outs.
6. Limited Reporting Capability: Generating meaningful reports from manual records is difficult and time-consuming.
7. Inability to Scale: Manual methods do not scale effectively as business grows.
There is therefore an urgent need for a computer-based inventory management system that is affordable, user-friendly, scalable, and capable of addressing these challenges.
1.3 Aim and Objectives
Aim:
To design and develop a computer-based inventory management system that automates inventory tracking, improves stock control efficiency, and supports data-driven decision-making.
Specific Objectives:
1. To analyse the requirements of a computer-based inventory management system through stakeholder consultation and existing system evaluation.
2. To design a scalable system architecture comprising presentation, business logic, and data layers.
3. To develop a database schema for efficient storage and retrieval of inventory data.
4. To implement core inventory management functionalities including product management, stock tracking, supplier and customer management, order processing, and automated reorder alerts.
5. To develop a user-friendly web-based interface for easy system access and operation.
6. To implement reporting and analytics features for informed decision-making.
7. To evaluate the system's performance in terms of accuracy, usability, and efficiency.
1.4 Research Questions
1. What are the key requirements for a computer-based inventory management system for SMEs?
2. What is an appropriate system architecture for a cost-effective inventory management system?
3. What database design is optimal for efficient inventory data storage and retrieval?
4. How can the system automate key inventory operations such as stock tracking, reorder alerts, and report generation?
5. What features should the user interface include to ensure usability for non-technical users?
6. How does the computer-based system improve inventory management efficiency compared to manual methods?
1.5 Significance of the Study
Theoretical Significance:
• Contributes to the body of knowledge on information systems applications in inventory management.
• Provides a framework for understanding the integration of database technology, web development, and business processes for inventory control.
• Advances understanding of affordable, scalable approaches to inventory management for SMEs.
Practical Significance:
• Offers a practical, affordable solution for computerised inventory management for organisations transitioning from manual methods.
• Enables real-time stock visibility, reducing stock-outs and overstocking.
• Automates routine tasks, saving time and reducing errors.
• Provides data-driven insights for better decision-making.
Economic Significance:
• Reduces operational costs through improved efficiency.
• Minimises capital tied up in excess inventory.
• Reduces losses from stock-outs and expired products.
• Studies have shown that web-based inventory systems can significantly improve inventory control, including real-time tracking and reduced manual recording errors.
Policy Significance:
• Supports the digital transformation of SMEs.
• Contributes to economic development through improved business efficiency.
• Aligns with national policies promoting ICT adoption in business.
1.6 Scope of the Study
• Content Scope: The project covers the analysis, design, development, and evaluation of a computer-based inventory management system. This includes requirements gathering, system design, database design, frontend and backend development, testing, and deployment.
• Functional Scope: The system includes the following modules:
o User Management: Registration, login, role-based access control
o Product Management: Add, view, update, delete products; category management
o Stock Management: Real-time stock tracking, stock adjustment, transfer
o Supplier Management: Supplier registration and management
o Customer Management: Customer registration and management
o Purchase Order Management: Create, view, update purchase orders; goods receipt
o Sales Order Management: Create, view, update sales orders; delivery
o Automated Reorder Alerts: Threshold-based notifications for low stock
o Reporting: Stock reports, sales reports, purchase reports, profit/loss analysis
• Technical Scope: The system is developed as a web-based application using:
o Frontend: HTML5, CSS3, JavaScript (with optional framework like React/Vue.js)
o Backend: PHP/Python/Node.js
o Database: MySQL/PostgreSQL
o Server: Apache/Nginx
• Geographical Scope: The system is designed for deployment in any organisational setting, with specific consideration for the Nigerian SME context.
1.7 Definition of Key Terms
• Inventory Management: The process of ordering, storing, using, and selling a company's inventory, including the management of raw materials, components, and finished products.
• Stock-Out: A situation where inventory is depleted and unavailable to meet customer demand.
• Reorder Point (ROP): The inventory level at which a new order should be placed to replenish stock before it runs out.
• Economic Order Quantity (EOQ): The optimal order quantity that minimises total inventory holding costs and ordering costs.
• Computer-Based System: A system that uses computer hardware and software to perform functions that were previously done manually.
• Small and Medium Enterprise (SME): A business with a limited number of employees and revenue, typically defined differently across countries.
• Real-Time Tracking: The immediate updating of inventory records as transactions occur, providing up-to-the-minute stock visibility.
1.8 Organisation of the Study
This report is structured into five chapters:
• Chapter One (Introduction): Presents the background, problem statement, objectives, research questions, significance, scope, and key definitions.
• Chapter Two (Literature Review): Reviews relevant literature on inventory management, computer-based systems, development methodologies, and existing solutions.
• Chapter Three (Methodology): Describes the system analysis, design approach, development methodology, and evaluation methods.
• Chapter Four (System Design and Implementation): Presents the detailed system architecture, database design, module implementation, and testing results.
• Chapter Five (Conclusion and Recommendations): Discusses findings, draws conclusions, and offers recommendations for future work.
________________________________________
CHAPTER TWO: LITERATURE REVIEW
2.1 Introduction
This chapter reviews the existing literature on inventory management and computer-based inventory management systems. It covers the theoretical foundations of inventory management, the evolution of inventory systems, development methodologies, and existing implementations. The review establishes the theoretical foundation for the project and identifies research gaps that this study addresses.
2.2 Theoretical Framework
2.2.1 Inventory Management Concepts
Inventory management involves the supervision of non-capitalised assets (inventory) and stock items. It encompasses the planning and controlling of inventory levels to ensure that the right products are available at the right time, in the right quantities, and at the right cost.
Key Inventory Management Concepts:
1. Economic Order Quantity (EOQ): A formula that determines the optimal order quantity that minimises total inventory costs, including ordering and holding costs.
2. Reorder Point (ROP): The inventory level at which a new order should be placed. It is calculated based on lead time demand and safety stock.
3. Safety Stock: Extra inventory held to protect against uncertainties in demand and supply.
4. Lead Time: The time between placing an order and receiving the goods.
5. ABC Analysis: A method of categorising inventory items based on their value and importance.
2.2.2 Evolution of Inventory Management Systems
Inventory management has evolved through several phases:
1. Manual Inventory Management: Paper-based records, manual counting, and spreadsheet tracking. Characterised by high error rates, inefficiency, and lack of real-time visibility.
2. Standalone Computerised Systems: Desktop applications that automate basic inventory functions but lack integration and remote access.
3. Web-Based Inventory Systems: Browser-based applications that provide real-time access, integration, and scalability.
4. Integrated ERP Systems: Comprehensive systems that integrate inventory with other business functions such as finance, HR, and procurement.
5. Smart Inventory Systems: Systems incorporating IoT, AI, and machine learning for predictive analytics and automation.
2.2.3 Inventory Management Models
Just-In-Time (JIT) : An inventory strategy aimed at reducing holding costs by receiving goods only as they are needed in the production process.
Material Requirements Planning (MRP) : A production planning and inventory control system used to manage manufacturing processes.
Vendor-Managed Inventory (VMI) : An arrangement where the supplier manages the inventory levels of the buyer.

    Date: 2026-09-04 00:00:00.000000