DESIGN AND IMPLEMENTATION OF A COMPUTER-DRIVEN STOCK MANAGEMENT SYSTEM FOR SMALL BUSINESSES RECORD KEEPING AND TRACKING

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:

1. Slow data processing
2. Lot of paper work
3. Time consuming
4. Less accurate
5. Less efficient
6. Lot of paper work
7. Slow data processing
8. Not user friendly environment
9. Difficult to keep old records
   • AIMS OF THE STUDY

The aims of the study include the following:

1. To design a computer driven stock management system
2. To make sure there is good and accurate record
3. To enhance the effectiveness of staff
4. To generate report on every goods in stock
5. 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:

1. Design a computer – driven stock management system to keep record and track materials on the basis of both quantity and value.
2. To generate reports on all the activities
3. 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:

1. Financial records specific to a single component, or groups of components. Service records for all components in the stock management system.
2. Up-to-date information about data processing resources through the creation and archiving of records in a centralized repository.
3. 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:

1. 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.
2. 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.
3. 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  

1. AUDIT: An official inspection of an organization’s accounts, typically by an independent body.
2. STOCK: The goods or merchandise kept on the premises of a shop or warehouse and available for sale or distribution.
3. MANAGEMENT: The process of dealing with or controlling things or people.
4. SYSTEM: A set of principles or procedures according to which something is done; an organized scheme or method.
5. 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.”
6. 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”

DOWNLOAD THE FULL WORK

DISCLAIMER: All project works, files and documents posted on this website, UniProjectTopics.com are the property/copyright of their respective owners. They are for research reference/guidance purposes only and some of the works may be crowd-sourced. Please don’t submit someone’s work as your own to avoid plagiarism and its consequences. Use it as a reference/citation/guidance purpose only and not copy the work word for word (verbatim). The paper should be used as a guide or framework for your own paper. The contents of this paper should be able to help you in generating new ideas and thoughts for your own study. UniProjectTopics.com is a repository of research works where works are uploaded for research guidance. Our aim of providing this work is to help you eradicate the stress of going from one school library to another in search of research materials. This is a legal service because all tertiary institutions permit their students to read previous works, projects, books, articles, journals or papers while developing their own works. This is where the need for literature review comes in. “What a good artist understands is that nothing comes from nowhere. All creative work builds on what came before. Nothing is completely original.” - Austin Kleon. The paid subscription on UniProjectTopics.com is a means by which the website is maintained to support Open Education. If you see your work posted here by any means, and you want it to be removed/credited, please contact us with the web address link to the work. We will reply to and honour every request. Please notice it may take up to 24 – 48 hours to process your request.