DESIGN AND IMPLEMENTATION OF A COMPUTERIZED WAREHOUSE INVENTORY CONTROL SYSTEM A CASE STUDY OF ALBERTINA COMPANY NBC ENUGU

0
801

ABSTRACT

The purpose of this study is to computerize the warehousing information system (A case study of NBC – Enugu) and to develop a computer package, whereby the techniques observed from the manual method can be improved upon.  It is a known fact that the manual method of warehousing information system has been associated with lots of inaccuracy in warehousing information system.  This has led to some set back that has cost some obstruction on some parts, when in service.

The software, when developed will facilitate and enhance the more and methods of warehousing information system which enables accuracy and also saves time when services and rendered.

There is no intention here, to treat modules separately, hence the entire project is menu driven, to cover most of the facilities present.

Lastly, it is optimistic that at the end of going through the work, one should be able to;

  1. Have a clear idea of the project
  2. Improve it to suit other organization with regard to other sources and problems.
  3. Know what it achieves.

TABLE OF CONTENT

COVER PAGE

TITLE PAGE

CERTIFICATION

DEDICATION

ACKNOWLEDGEMENT

ABSTRACT

TABLE OF CONTENT

CHAPTER ONE:    

INTRODUCTION

  1. BACKGROUND OF THE STUDY
    1. STATEMENT OF PROBLEM
    1. PURPOSE OF STUDY
    1. AIMS AND OBJECTIVES
    1. SIGNIFICANCE OF THE STUDY
    1. SCOPE AND PRELIMITATION
    1. LIMITATIONS OR CONSTRAINTS
    1. ASSUMPTION OF STODY
    1. DEFINITION OF TERMS

CHAPTER TWO

LITERATURE REVIEW

CHAPTER THREE

DESCRIPTION AND ANALYSIS OF EXISTING SYSTEM

3.1       FACT FINDINGS METHOD USED

  • ORGANISATIONAL STUDY
    • INPUT, PROCESS AND OUTPUT ANALYSIS
    • PROBLEMS OF THE EXISTING SYSTEM
    • JUSTIFICATION OF THE NEW SYSTEM
    • INFORMATION FLOW DIAGRAM

CHAPTER FOUR

DESIGN OF THE NEW SYSTEM

4.1       OUTPUT SPECIFICATION AND DESIGN

  • INPUT SPECIFICATION AND DESIGN
    • FILE DESIGN
    • SYSTEM FLOW CHAR AND REQUIREMENT
    • PROCEDURE CHART

CHAPTER FIVE

  • IMPLEMENTATION
    • PROGRAM DESIGN
    • PROGRAM FLOW CHART

CHAPTER SIX

DOCUMENTATION

CHAPTER SEVEN

7.0       RECOMMENDATION AND CONCLUSION

  • BIBLIOGRAPHY


CHAPTER ONE

INTRODUCTION

A Warehouse management system, or WMS, is a key part of the supply chain and primarily aims to control the movement and storage of materials within a Warehouse and process the associated transactions, including shipping, receiving, putaway and picking. The systems also direct and optimize stock putaway based on real-time information about the status of bin utilization.

Warehouse management systems often utilize Auto ID Data Capture (AIDC) technology, such as barcode scanners, mobile computers, wireless LANs and potentially Radio-frequency identification (RFID) to efficiently monitor the flow of products. Once data has been collected, there is either a batch synchronization with, or a real-time wireless transmission to a central database. The database can then provide useful reports about the status of goods in the Warehouse.

In its simplest form, the WMS can data track products during the production process and act as an interpreter and message buffer between existing ERP and WMS systems. Warehouse Management is not just managing within the boundaries of a Warehouse today, it is much wider and goes beyond the physical boundaries. Inventory management,inventory planning, cost management, IT applications & communication technology to be used are all related to Warehouse management. The container storage, loading and unloading are also covered by Warehouse management today.Warehouse management today is part of SCM and demand management. Even production management is to a great extent dependent on Warehouse management. Efficient Warehouse management gives a cutting edge to a retail chain distribution company. Warehouse management does not just start with receipt of material but it actually starts with actual initial planning when container design is made for a product. Warehouse design and process design within the Warehouse (e.g. Wave Picking) is also part of Warehouse management. Warehouse management is part of Logistics and SCM.

Warehouse Management monitors the progress of products through the Warehouse. It involves the physical Warehouse infrastructure, tracking systems, and communication between product stations.

Warehouse management deals with receipt, storage and movement of goods, normally finished goods, to intermediate storage locations or to final customer. In the multi-echelon model for distribution, there are levels of Warehouses, starting with the Central Warehouse(s), regional Warehouses services by the central Warehouses and retail Warehouses at the third level services by the regional Warehouses and so on. The objective of warehousing management is to help in optimal cost of timely order fulfillment by managing the resources economically. Warehouse management = “Management of storage of products and services rendered on the products within the four wall of a Warehouse”

1.1       BACKGROUND OF THE STUDY

Nigerian Breweries Plc, incorporated in 1946, is the pioneer and largest brewing company in Nigeria. Its first bottle of beer, STAR Lager, rolled off the bottling lines of its Lagos Brewery in June 1949. Other breweries were subsequently commissioned by the company, including Aba Brewery in 1957, Kaduna Brewery in 1963, and Ibadan Brewery in 1982. In September 1993, the company acquired its fifth brewery in Enugu state, and in October 2003, its sixth brewery, sited at Ama in Enugu. Ama Brewery is the largest brewery in Nigeria and one of the most modern worldwide. Operations at Enugu brewery were discontinued in 2004, leaving the company with five operational breweries.

The company has a portfolio of high-quality brands, including Star Lager Beer (launched in 1949); Gulder Lager Beer (1970); Maltina (1976), which now has three varieties, namely Maltina Classic, Maltina Strawberry, and Maltina with Pineapple; Maltina Sip-it (2005), which was packaged in Tetrapaks; Legend Extra Stout (1992); and Amstel Malta (1994). The company also relaunched Heineken Lager into the Nigerian market in June 1998.

Nigerian Breweries operates many related companies, including beverage-related manufacturing companies making corks, labels, bottles, packing crates; and a logistics network, including transport companies, warehousing companies and retail sales management. The company’s head offices are located in Lagos

1.2       STATEMENT OF THE PROBLEM

The processing of billing papers for clearance of goods, with manual method has led to omission of many records that ought to be included.  This is caused by inaccuracy of the manual billing process.

Due to the inefficiency in manual billing process, billing papers are carried from post to post, waiting for who is in charge, thereby delaying the goods that suppose to be delivered.

More so, goods are not delivered on time, due to the fact, that goods that takes about two weeks to get into the country, still takes another two weeks to be cleared.

DESIGN AND IMPLEMENTATION OF A COMPUTERIZED WAREHOUSE INVENTORY CONTROL SYSTEM A CASE STUDY OF ALBERTINA COMPANY NBC ENUGU