DESIGN AND IMPLEMENTATION OF INVENTORY MANAGEMENT SYSTEM

CHAPTER ONE

1.0 INTRODUCTION

An inventory control system contains a list of orders to be filled and then prompts workers to pick the necessary items, and provides them with packaging and shipping information. Inventory control may be used to automate sales order fulfilment process and also manage in and outward material of hardware. Automation is the replacement of human workers by technology. For optimal sales and inventory management process, robust functionality is needed for managing logistics facilities. Warehouse management functions for inventory control cover internal warehouse movements and storage and its support helps in the recording and tracking of materials on basis of both quantity and value.

This application takes care of all supply orders reducing cost for warehousing, transportation while improving customer service. It significantly improves inventory turns, optimizes flow of goods. It also improves cash flow, visibility and decision making. It provides efficient execution of tasks using this fast and reliable computerized method.

1.1 Background of Study

SunnyBenz Auto Nig. Ltd is a car Parts dealing company established in the year 2004, it is located at block 11 shop R120, Gudu market beside diamond bank, Abuja, Nigeria Abuja, Fct-Abuja 112122 Nigeria. It aims at providing satisfactory, comfortable and Sound automobile parts to the Nigerian population through the stocking of several kinds of automobiles parts. It is second to none and for this reason, the demand is high and the company responds to the increasing demand by stabilizing supply to strike a balance.

Justifiably, the company has the problem of keeping adequate record of goods transfer and since it is done manually, associated problems of insecurity, high cost of operation and delay in supply arise. Data processing in SunnyBenz Auto Nig. Ltd is presently carried out using people, pens, and paper to control stock and inventory.

The design and development of an automated inventory control system for the Sunny Benz Auto Nig. ltd will no doubt bring immeasurable relief from the problems associated with the manual system.

1.2 Statement of Problem

SunnyBenz Auto Nig.S ltd basically operates manually and have several problems facing them and which reveals a number of problems.

1. The recording of sales and cash received are done manually on a book that appears rough. Thus, the books are exposed to physical damage, information can be lost and dust particles are accumulated.

2. The control system is time consuming, less accurate and less efficient, and the environment is not user friendly.

3. Inaccuracies often ensue from human error.

The manual system is quite tedious and can be reduced or eliminated with the introduction of the proposed system.

1.3 Aim of the study

The purpose of this study is to design and implementation of an automated inventory system for Sunnybenz Auto Nig. ltd

Objective of the study

The main objective of this study is to Design and Implementation of Autoshop inventory management system. Others include;

1. Calculate the bill.

2. Give the bill to the customer.

3. Store how many products are sold.

4. Store products and their prices and with other information.

5. Set the rates of taxes and commission on the products.

6. Can see the report of the product in a fix period of time.

7. Change the Graphical User Interface of the system.

8. It provides higher level security as the system would be passworded to prevent unauthorized access.

But can’t:

1. Calculate of the salaries of the employees.

2. Calculate the expanses on the product.

1.4 Significant of study

This study is primarily aimed at increasing efficiency in operations, reducing maintenance and running cost, monitoring the supply of goods and its distribution and increase profit in the Nigerian Breweries PLC by introducing an automated inventory control system.

1.5 Scope of the Project

The scope of this study includes:

1. Users Management

2. Inventory of Products

3. Suppliers Management

4. Purchases and Other

5. Report generation

6. Point of sales

1.6 Limitation of the project

This project was constrained by the following factors:

(a) Financial Constraints

Bearing in mind the economic state of the nation, it was found difficult in making both ends meet, because of the exorbitant nature of things nowadays in travelling for the collection of data needed for the project.

(b) Time Constraints

Looking at the interval between the resumption and vacation of the final semester for the project to be completed, the time given seemed to be short for the collection of required information for better work to be done.

(c) Non-Availability of Material

During this project, it was noticed that the required materials needed for the project are not documented. Those that were documented lacked storage facilities where they can be reached.

1.7 Definition of basic terms and concepts

Automation: This is the use of technology or computers to control and process data reducing the need for human intervention.

Database: This refers to a large store of related data on a computer that a user can access and modify.

Password: This is a secret code that must be entered into a computer to enable access to its applications. It is made up of numbers, letters, special characters or a combination of any of the above categories.

Inventory Control System: A list of orders to be filled, and prompts workers to pick the necessary items and provides them with packaging and shipping information.

Computerization: This is the conversion of a manually operated system to a controlled, organized and automated system.

Research: A careful study of a subject to discover facts, establish a theory or develop a plan of action based on the facts discovered.

System: A set of computer components functioning together.

Technology: The study of techniques of mobilizing resources such as information for accomplishing objectives that benefit man and his environment.

Software: A computer program or set of instructions that direct a computer to perform processing functions.

Information System: A collection of procedures, people, instructions and equipment to produce information in a useful form.

Processing: This is dealing with something according to an established procedure.