DESIGN AND IMPLEMENTATION OF COMPUTER BASED MARKETING INFORMATION SYSTEM (A CASE STUDY OF GUNIESS NIG. PLC)

ABSTRACT

Most marketing, production, and manufacturing firms have the basic problem of information flow between the various departments within the organization.

This research is intended to highlight the role of a computerized marketing information system in Guinness (Nig) Plc Compare to the manual system of marketing.

To identify the various problems involve in the existing marketing information system of Guinness (Nig) Plc is the purpose of this research and to the proffer solutions to them.

Data were collected both by interview methods and observation method.  Marketing models had developed in this research as well as marketing system.  Secondly, the study also investigates how Guinness (Nig) Plc manages the marketing information system.

Finally computer based marketing information system is suggested as a solution to more structured, efficient and effective marketing control. 

ORGANISATION OF WORK

This work is divided into seven chapters.  Chapter one is the introduction, chapter two examines the literature.  Description of the existing system is in chapter three while chapter four examines the design of the new system.  Chapter five is base on implementation of the new system while chapter six is documentation.  Finally, in chapter seven, a summary is made, recommendation is offered and conclusion is also drawn.

TABLE OF FIGURE

Organizational structure

Information flow diagram

Good receive note

Store ledger card

Daily record form

Random file access process

Goods received note file

Store ledger form file

Daily record form file

Procedure chart

System flow chart

Program flow chart

TABLE OF CONTENT

TITLE PAGE

ABSTRACT

ORGANISATION OF WORK

TABLE OF FIGURE

TABLE OF CONTENT

CHAPTER ONE

1.0       INTRODUCTION

1.1              STATEMENT OF PROBLEM

1.2              PURPOSE OF THE STUDY

1.3              AIMS AND OBJECTIVES

1.4              SCOPE OF THE STUDY

1.5              LIMITATION

1.6              ASSUMPTION

1.7              DEFINITION OF TERM

2.0              LITERATURE REVIEW

3.0              DESCRIPTION AND ANALYSIS OF THE EXISTING SYSTEM

3.1       FACT FINDING METHOD USED

3.2              ORGANISATIONAL STRUCTURE

3.3              OBJECTIVE OF THE EXISITNG SYSTEM

3.4              INPUT, PROCESS, OUTPUT ANALYSIS

3.5              INFORMATION FLOW DIAGRAM

3.6              PROBLEM OF THE EXISTING SYSTEM

3.7              JUSTIFICATION FOR THE NEW SYSTEME

4.0              DESIGN OF THE NEW SYSTEM

4.1       OUTPUT SPECIFICATION AND DESIGN

4.2              INPUT SPECIFICATION AND DESIGN

4.3              FILE DESIGN

4.4              PROCEDURE CHART

4.5              SYSTEM FLOW CHART

4.6              SYSTEM REQUIREMENTS

5.0              IMPLEMENTATION

5.1       PROGRAM DESIGN

5.2              PROGRAM FLOW CHART

5.3              PSEUDOCODE

5.4              SOURCE PROGRAM

5.5              TEST RUN

6.0              DOCUMENTATION

7.0              RECOMMENDATION

7.1       CONCLUSION

            REFERENCE

CHAPTER ONE

1.0              INTRODUCTION

The ultimate aim of manufacturers is to produce goods they can sell to users immediately at a profit. An interaction between the producer and the consumer tales place.  This interaction is initiated, developed, and managed by producer’s marketing staff.  The business function of marketing is concerned with the planning, promotion, and sale of existing products in the existing markets and development of new products and new markets to better serve present and potential customers.

 Today marketing performs a vital function in the operation of a business enterprises i.e. (as the primary interface between the manufacturer and the customer).  Performing the marketing function in business has become a much difficult assignment because of the dynamic environment of today’s activities which includes:

-                      Rapidly changing market demands

-                      Steadily increasing consumers pressure

-                      Proliferation of new products

-                      Intensified competition

-                      Growing government regulations.

Business firms have increasingly turned to the computer to help them perform the vital marketing functions in the face of the rapid changes of today’s environment.  Computer, therefore, because of its speed, memory capacity, versatility and accuracy, has been the catalyst in the development of marketing information system, which integrate the information flow required by the many marketing activities.  Computer is also used to make business decision involving millions of naira and so saves man from a tremendous amount of time consuming work.

Today computer is used as a control system for controlling marketing costs, diagnosis of poor sales performance.  Nevertheless, computer is also used as research system for advertising strategy, pricing strategy and evaluation of advertising expenditure and continuous experiment.

This project work, computer based marketing information system is taken to critically analyse and fashion out ways of implementing computer in Guinness (Nig) Plc.  

In this chapter, the researcher established the aim, limitation and purpose of the study, scope, statement of the problems, assumption and definition of terms.

1.1       STATEMENT OF THE PROBLEM

The Guinness (Nig) Plc produces and markets over four different brands of alcoholic drinks.  These products are sent to the various stored and other branches or deport with the country.  The large volume of stock coupled with the vast distribution not work creates some control and management problems.

The operation of the Enugu deport presently is completely manual and lacks some degree of information retrieval facilities.  So, obtaining, storing and updating information on each of the items is not an easy task.  It takes hours and at times, days, to locate any information acquired due to the volume of files involved.

1.2              PURPOSE OF THE STUDY

The purpose of the study is to design a computer based marketing information system for Guinness (Nig) Plc.

1.3              AIMS OF OBJECTIVE

The aim of this research is geared towards finding the procedure employed by the management of Guinness (Nig) Plc in obtaining information from the marketing department and to keep track records of available items when needed, its re-order, and to indicate the product that are not selling in order not to waste money in keeping stock of the quantity of good purchases, sold, and produced.

The project objective is to find solution to the misinformation of the flow of data between the marketing procedure and the management decision, by introducing a computer based marketing information system which will reduce the misinformation, be faster, accurate, reliable and improve output report that will help the management in her plans and decision making.

Because of the above problem highlighted in the old system, it becomes necessary that a new computer based data base management system may be designed to handle the duties.

1.4              SCOPE OF THE STUDY

The study is attempted to analyse the marketing concept of the Guinness (Nig) Plc and the ways of improving its effectiveness with the aid of computer.

The study is limited to Guinness (Nig) Plc Enugu depot with research from the marketing department.