DESIGN AND IMPLEMENTATION OF A COMPUTERIZED INVENTORY CONTROL SYSTEM (A CASE STUDY OF NIGERIAN BREWERIES PLC)


CLICK HERE TO GET THE COMPLETE PROJECT »

DESIGN AND IMPLEMENTATION OF A COMPUTERIZED INVENTORY CONTROL SYSTEM (A CASE STUDY OF NIGERIAN BREWERIES PLC)

ABSTRACT:              This research work is concise and generally summarizes the activities duly carried out in the design and implementation of a computerized inventory control system for a manufacturing organization. The system is designed to efficiently handle the movement and tracking of goods through the replacement of human workers by technology. The manual method or intervention is labour intensive, costly, and error prone and cannot ensure the inventory remains up-to-date due to oversight and internal shrinkage. With the proposed new system, inventory can be updated in real time without product movement, scanning, or human involvement. The automated system allows inventory status to be determined and shipping and receiving documents to be generated automatically triggering automatic orders for products that are low in inventory. The study outlines the main concepts of the analysis and design methodology of the proposed system, compares it to the existing and goes further to explain the design and implementation of the system using Visual Basic 6.0 for the database. The fact finding techniques employed is interview, observation, online and library research.TABLE OF CONTENTSTitle pageApproval PageCertification PageDedicationAcknowledgementAbstractTable of ContentsList of FiguresList of TablesCHAPTER ONE    i1.0    Introduction         11.1    Background of the Study         21.2    Statement of the Problem         31.3    Purpose of the Study         41.4    Significance of the Study         41.5    Objectives of the Study         41.6    Scope of the Study         51.7    Limitations of the Study         61.8    Definition of Basic Concepts         6CHAPTER TWO2.0    Literature Review         92.1    Comprehensive Overview         92.1.1    Purpose         102.2    Types of Inventory Control Systems    -    -    -    -    102.2.1    Four types of inventory control systems    -    -    -    -    112.2.1.1    Manual Inventory Management System -    -    -    112.2.1.2    Barcode Technology         122.2.1.3    Radio Frequency Identification (RFID)    -    -    -    132.2.1.4    Warehouse Management System    -    -    -    -    142.3    How Inventory Control Systems Really Work    -    -    162.4    What Industries Use Inventory Control Systems    -    -    192.4.1    Application of Inventory Control Systems -    -    -    202.4.2    Importance of Inventory Control Systems -    -    -    - 212.5    Warehouse Management Systems    -    -    -    -    222.5.1    Warehouse Management Rules Engine    -    -    -    242.5.1.1    Rules Workbench         252.5.1.2    Warehouse Management System Strategy -    -    -    252.5.2    Importance of Warehouse Management Systems -    -    252.5.3    Inventory Control Systems vs. Warehouse Mgt Systems -    272.6    Automated Inventory Control System Software    -    -    -    28CHAPTER THREE3.0 SYSTEM ANALYSIS AND DESIGN3.1 METHODOLOGY 3.2 DATA COLLECTION 3.3 ANALYSIS OF THE EXISTING SYSTEM 3.4 LIMITATION OF THE EXISTING SYSTEM 3.5 SYSTEM DESIGN TRANSACTION/MOVEMENT FILES: 3.6 DATA BASE DESIGN 3.6.1 TRANSACTION TABLE; SUPPLY FORM3.6.2 SALES TABLE3.6.3 CUSTOMERS TABLE3.7.1 ACTIVITY DIAGRAM3.7.2 CLASS CASE DIAGRAM3.7.3 USE CASE DIAGRAM 3.8 SYSTEM FLOWCHART3.10 JUSTIFICATION OF THE NEW SYSTEMREFERENCECHAPTER FOUR4.0 IMPLEMENTATION, TESTING AND PACKAGING 4.1 CHOICE OF DEVELOPMENT TOOLS 4.2 SYSTEM REQUIREMENTS4.2.1 Software Requirements4.2.2 Hardware Requirements For effective operation of the newly designed 4.3 TOP-DOWN DESIGN DIAGRAM4.4 IMPLEMENTATION4.3.6 IMPLEMENTATION OF THE LOGIN FORM4.3.7 IMPLEMENTATION OF THE MAIN MENU FORM4.3.8 IMPLEMENTATION OF THE RECEIVE SUPPLY FORM4.3.9 IMPLEMENTATION OF SALES FORM4.5 IMPLEMENTATION OF SUPPLIER RECORD FORM4.6 TESTING4.6.1 Unit Test4.6.2 System Test 4.7 PACKAGING (INTEGRATION) CHAPTER FIVE5.0 SUMMARY, LIMITATIONS, RECOMMENDATIONS, BEME AND CONCLUSION 5.1 SUMMARY 5.2 LIMITATION 5.3 RECOMMENDATION5.4 BILL OF ENGINEERING MEASUREMENT AND EVALUATION (BEME) 5.5 CONCLUSIONREFERENCESAPPENDIXCHAPTER ONE1.0 INTRODUCTIONAn 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 method1.1 BACKGROUND OF THE STUDYThe Nigerian Breweries PLC was established in the year 1946. It aims at providing satisfaction and nourishment to the Nigerian population through the distribution of drinks like beer, coca-cola, fanta, sprite etc. 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 Nigerian Breweries PLC is presently carried out using people, pens, and paper to control stock and inventory.The design and development of a computerizedinventory 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 PROBLEMThe Nigerian Breweries PLC is to an extent manually operated and reveals a number of problems.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.    The long list of supply orders waiting to be attended to on daily basis.    The control system is time consuming, less accurate and less efficient, and the environment is not user friendly.    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 PURPOSE OF THE STUDYThe 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 STUDYThis 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 a computerizedinventory control system.1.5 OBJECTIVES OF THE STUDYThe main objective of this study is to develop a computerised inventory control management system. Others include;i.    It provides total asset visibility.ii.    It allows reduced inventory stocking levels giving full inventory history.iii.    It reduces lead time, shelf space, and errors due to damage, fatigue of staff and overall cost of operations.iv.    It facilitates “just in time” deliveries.v.    It provides full process control for products.vi.    It provides higher level security as the system would be passworded to prevent unauthorised access.vii.    It shortens cross docking time and speeds up sort/pick up rate.viii.    It helps the management plan, monitor, optimize resources and ascertain their financial position at any time.1.6 SCOPE OF THE STUDYThe scope of this study covers the Nigerian Breweries PLC as a whole, and its customers which include retailers, distributors and the general public.1.7 LIMITATIONS OF THE STUDYThis project was constrained by the following factors:(a)    Financial ConstraintsBearing 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 ConstraintsLooking 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 MaterialDuring 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 BASIC CONCEPTSAutomation: 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.

.

DESIGN AND IMPLEMENTATION OF A COMPUTERIZED INVENTORY CONTROL SYSTEM (A CASE STUDY OF NIGERIAN BREWERIES PLC)


CLICK HERE TO GET THE COMPLETE PROJECT »


TESTIMONIES FROM OUR CLIENTS


Please feel free to carefully review some written and captured responses from our satisfied clients.

  • "I love what you guys are doing, your material guided me well through my research. Thank you for helping me achieve academic success."

    Sampson, University of Nigeria, Nsukka.
  • "researchwap.com is God-sent! I got good grades in my seminar and project with the help of your service, thank you soooooo much."

    Cynthia, Akwa Ibom State University .
  • "Sorry, it was in my spam folder all along, I should have looked it up properly first. Please keep up the good work, your team is quite commited. Am grateful...I will certainly refer my friends too."

    Elizabeth, Obafemi Awolowo University
  • "Am happy the defense went well, thanks to your articles. I may not be able to express how grateful I am for all your assistance, but on my honour, I owe you guys a good number of referrals. Thank you once again."

    Ali Olanrewaju, Lagos State University.
  • "My Dear Researchwap, initially I never believed one can actually do honest business transactions with Nigerians online until i stumbled into your website. You have broken a new legacy of record as far as am concerned. Keep up the good work!"

    Willie Ekereobong, University of Port Harcourt.
  • "WOW, SO IT'S TRUE??!! I can't believe I got this quality work for just 3k...I thought it was scam ooo. I wouldn't mind if it goes for over 5k, its worth it. Thank you!"

    Theressa, Igbinedion University.
  • "I did not see my project topic on your website so I decided to call your customer care number, the attention I got was epic! I got help from the beginning to the end of my project in just 3 days, they even taught me how to defend my project and I got a 'B' at the end. Thank you so much researchwap.com, infact, I owe my graduating well today to you guys...."

    Joseph, Abia state Polytechnic.
  • "My friend told me about ResearchWap website, I doubted her until I saw her receive her full project in less than 15 miniutes, I tried mine too and got it same, right now, am telling everyone in my school about researchwap.com, no one has to suffer any more writing their project. Thank you for making life easy for me and my fellow students... Keep up the good work"

    Christiana, Landmark University .
  • "I wish I knew you guys when I wrote my first degree project, it took so much time and effort then. Now, with just a click of a button, I got my complete project in less than 15 minutes. You guys are too amazing!."

    Musa, Federal University of Technology Minna
  • "I was scared at first when I saw your website but I decided to risk my last 3k and surprisingly I got my complete project in my email box instantly. This is so nice!!!."

    Ali Obafemi, Ibrahim Badamasi Babangida University, Niger State.
  • To contribute to our success story, send us a feedback or please kindly call 2348037664978.
    Then your comment and contact will be published here also with your consent.

    Thank you for choosing researchwap.com.