Automated Stock Control And Sales System

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 providing efficient execution of tasks using this fast and reliable computerised method

1.1 Background of the Study

In business reactions, stocks are the assets of the organization in terms of materials, goods products that need to be replenished at its re-ordered level. Therefore, stock control process is the operation of continuously arranging receipts and documents relating to the materials to ensure that stock balance are adequate to support the current rate of consumption with one regards to economy. There are some problems associated with stock process of organizations, which include inadequate control of information, that is, there was no free flow of information relating to the stock, also accuracy in the financial information status, and as a result of these problems therefore calls for the computerized approach to stock keeping, monitoring and sales analysis..

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 Nigerian Breweries PLC 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 Nigerian Breweries PLC will no doubt bring immeasurable relief from the problems associated with the manual system.

1.2 Statement of the Problem

The following are the specification statement of the problem that necessitated the project:

Customers time is wasted during search for an item in stock.

Fraud and arithmetic error normally occurs in the use of bin card.

Therefore, using a computerized approach for stock keeping, monitoring and sales analysis, it will helps in reducing customer’s complains.

1.3 Purpose of the Project

The purpose of this study is to improve current operational process in the Nigerian Breweries PLC to its full capacity by developing efficient computer software that can handle inventory in a computerised fashion.

1.4 Significance of the Project

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 Objectives of the Study

The main objective of this study is to develop a computerised inventory control management system. Others include;

Here are objectives of the project:

To reduce the lost of processing each unit of item

To ensure that goods in stock are made know to the approach department

To ensure that stock are replenished at re-order level as at when due.

1.6 Scope of the Project

The following are the scope of the project:

It considers how the customer consumes goods.

It cores the sues record of stock in store.

It considers how goods are collected and received the store.

1.7 Limitations 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.8 Definition of Terms

(1) Stock Record:

These are the documents which record, from day to day, full particulars of individual’s receipts, and issues balances of stock.

(2) Stock Taking/Checking:

This is the process of physical verification of the quantities and condition of goods.

(3) Re-Order level:

This is the quantity between the maximum and minimum stock figuring at which it is necessary imitate Porsches requirement for new supplies.

(4) Maximum Stock Level:

Is the level at which stock should not be allowed to increase. In fixing this level, the best possible excepted conditions are used.

(5) Minimum Stock Level:

Is the level at which stock should not be allowed to full. The level must be wait watched with cure because it is an indication of real change of Stock but which may result into production of sales stoppage.