ABSTRACT
This paper describes the Stock Management System sufficiently to determine the feasibility and usability of a finished system. The core concept is to track the sale of items from the cash registers with additional features for interpreting the data. It uses a client-server model with a connected database to allow multiple stores and warehouses to be connected. This allows for later expansion while still supporting the targeted small businesses.
TABLE OF CONTENT
PAGE NO.
Title page 1
Certification Page 2
Dedication 3
Acknowledgement 4
Abstract 5
Table of content 6 & 7
CHAPTER ONE
- Introduction 8
- Background of study 8
- Statement of problem 9
- Aim Of study 9
- Objective of study 10
- Significant of study 10
- Scope of study 10
- Limitation of the study 11
- Definition of terms 12
CHAPTER TWO
- Introduction 13
- Review of the Existing System 15
- Problem with the Existing System 15
- Justification of the new system 15
- Benefit of the new system 15
CHAPTER THREE
3.1 Introduction 17
- Analysis of Existing System 17
- Overview of the new system 18
- Functional Requirements 18
- Non-functional requirements 18
- Method of data collection 19
- System Design 19
- Input Design 19
- Output Design 25
- The system Flowchart 26
CHAPTER FOUR
4.1 Introduction 27
4.2 System Testing 27
4.3 System Requirement 27
4.3.1 Hardware Requirement 27
4.3.2 Software Requirement 28
4.4 Choice of Programming Language Used 28
4.5 System Documentation 28
4.5.1 Installation Procedure 36
4.5.2 Procedure on how to load software 36
4.5.3 System Maintenance 37
CHAPTER FIVE:
- Summary 38
- Recommendation 38
- Conclusion 38
References
Source code
CHAPTER ONE
- INTRODUCTION
The modern industrial world is very much advanced in technology and competition in the world is intense. The user of a computer is provided with the HARDWARE and SOFTWARE, the two source of the computer. Much of the software will be programs which facilities the fast automatic management of the computer system resource.
- BACKGROUND OF THE STUDY
“Stock Management System” is one can go into almost required solution regarding the stock. This software package provides guidance for all the stock management purpose, as a perfect guide, the current demand for such software became needful. This project will provide for computerization of a small enterprise whose main goal is to keep track on their inventory and stock process and wants to change from paper based transaction to computerized transaction.
For optimal stock management processes, you need robust functionality for managing your logistics facilities. Support for stock management helps you record and track materials on the basis of both quantity and value.
stock management functions cover internal warehouse movements and storage.
Using this software we can reduce costs for warehousing, transportation, order fulfillment, and material handling while improving customer service.
You can significantly improve inventory turns, optimize the flow of goods, and shorten routes within your warehouse or distribution center. Additional benefits of stock management include improved cash flow, visibility, and decision making.
This software is user friendly and hence easy to use.
Employees can plan, enter, and document warehouse and internal stock movements by goods issues, storage, picking and packing, physical stock transfers, and transfer postings.
1.2. STATEMENT OF THE PROBLEM
Manual system are quite tedious time consuming and less efficient and accurate in comparison to the computerized system.
So following are some disadvantages of the old system:
- Slow data processing
- Lot of paper work
- Time consuming
- Less accurate
- Less efficient
- Lot of paper work
- Slow data processing
- Not user friendly environment
- Difficult to keep old records
- AIMS OF THE STUDY
The aims of the study include the following:
- To design a computer driven stock management system
- To make sure there is good and accurate record
- To enhance the effectiveness of staff
- To generate report on every goods in stock
- To keep track of goods in terms of quantity
1.4 . OBJECTIVES OF THE STUDY
The project is designed to help in the stock control. The main objective of the new system includes:
- Design a computer – driven stock management system to keep record and track materials on the basis of both quantity and value.
- To generate reports on all the activities
- Design and develop a central database system that would serve as database, which will contain information all the stock.
1.5. SIGNIFICANCE OF THE STUDY
The new system designed for computer driven payroll system will among other things:
- Financial records specific to a single component, or groups of components. Service records for all components in the stock management system.
- Up-to-date information about data processing resources through the creation and archiving of records in a centralized repository.
- Data used to support configuration diagrams of the hardware and software components contained within specific locations, or the entire data processing environment.
1.6. SCOPE OF THE STUDY
The scope of this system is to provide user efficient working environment and more output can be generated through this. This system provides user friendly interface resulting in knowing each and every usability features of the system.
This system helps in tracking records so that past records can be verified through them and one can make decisions based on the past records. This system completes the work in a very less time resulting in less time consumption and high level of efficiency.
This system is developed in such a way that even a naïve user can also operate the system easily. The calculations are made very quickly and the records are directly saved into databases and the databases can be maintained for a longer period of time. Each record can be retrieved and can be verified for the future transactions.
Also this system provides high level of security for data leaking as only admin people can access the database no changes can be made in it until it verifies the user login id and password.
The research will be carried out using OGUN STATE INSTITUTE OF TECHNOLOGY, IGBESA AUDIT DEPARTMENT.
1.7. LIMITATIONS
The constraints encountered during this project design include the following:
- Financial Constraints: The design was achieved but not without some financial involvements. One had to pay for the computer time. Also the typing and planning of the work has its own financial involvements.
- High programming Technique: The programming aspect of this project posed a lot of problematic bugs that took us some days to solve. Problems such database connections using PHP and MYSQL database posed a lot of challenges.
- Few Literature Sources: The topic though seems to be a common term; it is not a popular topic to surf from the Internet. It had fewer literature sources.
1.8. DEFINATION OF TERMS
- AUDIT: An official inspection of an organization’s accounts, typically by an independent body.
- STOCK: The goods or merchandise kept on the premises of a shop or warehouse and available for sale or distribution.
- MANAGEMENT: The process of dealing with or controlling things or people.
- SYSTEM: A set of principles or procedures according to which something is done; an organized scheme or method.
- PHP: is a script language and interpreter that is freely available and used primarily on Linux Web servers. PHP, originally derived from Personal Home Page Tools, now stands for PHP: Hypertext Pre-processor, which the PHP FAQ describes as a “recursive acronym.”
- MY SQL: is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open-source web application software stack (and other “AMP” stacks). LAMP is an acronym for “Linux, Apache, MySQL, Perl/PHP/Python”
