PROJECT TOPIC: DESIGN AND IMPLEMENTATION OF COMPUTERIZED STOCK CONTROL SYSTEM (A CASE STUDY OF GLOBAL SUPERMARKET UYO, NO 23, NEPA LINE, UYO AKWA IBOM STATE)

CHAPTER ONE

GENERAL INTRODUCTION

10       INTRODUCTION

Various organizations need management for effective,efficient planning and operation of the system. Accurate stock control system is essential to all retailers, wholesalers or distributors who stock a wide range of items, goods are sometimes sold at the same price which they were brought, at time goods are sold less than the cost price, this could be due to poor information about the goods or poor manual stock control account this give birth to the computerized stock control system.  Computerized stock control system is a software design for management and inventory control of goods, items and raw materials. it includes the various aspect of controlling the amount of stock on the shelves and in the stock room and how the users to maintain and keep track of the material’s no matter where they are located and provide some information when the supplies is running low. This software also contains a point of sales (POS). This means a place where retail transaction. It is a point where customer makes payments to the cashier in exchange of goods and services. This is where the amount is calculated and receipt issued for the transaction and where the bar code of the product are scanned using bar code scanner which is used to read bar code and the information encoded by the bar code is read by the machine, this information is then traced by a central computer system. The supermarket detailed real time stock level information that the system uses to place reorder through the electronic data interchange (EDI) computerized stock control system make it possible to integrate the various functional subsystems that are part of stock management into a single cohesive system.

• STATEMENT OF THE PROBLEM

The global supermarket Uyo reveal the following problem.

1. Data inconsistency
2. No good data security system
3. Lack of accuracy in stock recording
4. The long list of supply orders waiting to be attended to on daily basics
5. Lack of stock history on every item sold or ordered.

Therefore it is important to embrace and accept the introduction of a new stock control system which is more flexible and information is easier to retrieve it is also cost effective and also time saving.

• OBJECTIVES OF THE STUDY

The objective of the study is as follows:

1. To design and implement a computerized stock control system for global supermarket, uyo.
2. To develop an interactive software for record keeping, storage and retrieved of stock control.
3. To aid strategic managers to forecast for the growth of the business.

1.3        SCOPE OF THE STUDY

The implementation of this project is delimit to computerized stock control and point of sales with the framework of the following

1. Day-to-day sales
2. Cash flow
3. Minimum re-order level

1.4      LIMITATIONS OF THE STUDY

This project was constrained by the following factors.

1. Time Constrained: Looking at the interval between then resumption and vocation 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.
2. Non-Availability of Materials: During this project, it was noticed that required materials needed for the project are not documented. Those that were documented lacked storage facilities where they can be reached.
3. Restriction of information form the staff of global supermarket: During this project, it was noticed that the required information is limited which cannot be extent.

1.5      SIGNIFICANCE OF THE STUDY

The significance of the study is as follows:

1. The research on this project topic will be a great help to management and staff of global supermarket as well as to other business enterprises who desire product and profit in their business.
2. This research work will serve as a source of reference material for researchers in computer science and relevant academic fields who intend to further research on this topic.

• This research will also be a great help to the management by keeping timely and reliable backup of information

1. This research will provide storage and allow for retrieval of information when needed in the global supermarket

1.6      DEFINITIONS OF TERMS

Stock: The goods kept on the premises of a business or warehouse that are available for sale or distribution

Control system: Is the system or set of devices that manages, commands, directs or regulates the behavior of other systems.

Warehouse: This is commercial building for storage of goods; it is used by the manufacturers, importers, exporters, whole sales and transport business.

System: A set of computer components functioning together.

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, letter, special characters or a combination of any of the above categories.

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

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

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

Process: Carry out a task or a task preformed by a computer

POS (Point of Sales): this a place where retail transaction is completed, appoint where customers makes payment to the cashier in exchange of goods or services