PETROLEUM PRODUCT INVENTORY MANAGEMENT SYSTEM

0
1271

ABSTRACT

This research study focused on Petroleum product inventory management system a case study of Geogal and Chucks Filling Station, Ikot Ekpene. The problems that necessitated the development of the study are: It is difficult to accurately keep record of petroleum product inventory and sales information from the fuel dispensers using only a manual recording system. Most filling stations run out of fuel because they cannot quickly know inventory record of litres sold unless they check manually. In view of these problems, the objectives of the study include: to create a database system that will keep inventory record of petroleum product dispensed daily, to create a system that will enable management of the filling station to know when they should order for more petroleum products. The software development methodology used is object oriented analysis and development model. The programming language used is Visual BASIC 6.0.

TABLE OF CONTENTS

Title Page             –        –        –        –        –        –        –        –        i 

Certification         –        –        –        –        –        –        –        –        –        ii

Dedication            –        –        –        –        –        –        –        –        iii

Acknowledgment –        –        –        –        –        –        –        –        iv

Abstract               –        –        –        –        –        –        –        –        v

Table of Contents –        –        –        –        –        –        –        –         vi-viii

CHAPTER ONE: INTRODUCTION

1.0     Introduction         –        –        –        –        –        –        –        1       

1.1     Background of the Study        –        –        –        –        –        –        2-3

1.2     Statement of Problem              –        –        –        –        –        3

1.3     Aim and Objectives of the Study                –        –        –        4

1.4     Scope of the Study        –        –        –        –        –        –        –        4

1.5     Significance of the Study         –        –        –        –        –        –        5

1.6     Organization of the Research  –        —       –        –        –        5-6

1.7     Definition of Terms       –        –        –        –        –        –        6-7

CHAPTER TWO: LITERATURE REVIEW

2.1 Introduction   –        –        –        –        –        –        –        –        8

2.2 Overview of Petroleum Product Record Management system    8-11

2.3 Automated Fuel Management Systems –        –        –        –        11-13

2.4 Strategic Planning For Petroleum Product Distribution

Management                  –        –        –        –        –        –        13-14

2.4.1 Petroleum Product Depot Management      –        –        –        15-16

CHAPTER THREE: SYSTEM ANALYSIS AND DESIGN

3.0     Introduction         –        –        –        –        –        –        –        –        17     

3.1     Research Methodology            –        –        –        –        –        17

3.2  Analysis of the Existing System          –        –        –        –        –        18

3.2.1  Disadvantages of the Existing System        –        –        –        –        18-19

3.3     Analysis of the Proposed System-    —       –        –        –        19

3.3.1 Advantages of the Proposed System –        –        –        –        19

3.4     System Design     –        –        –        –        –        –        –        20

3.4.1  Input Layout        –        –        –        –        –        –        20

3.4.2  Output Layout     –        –        –        –        –        –        20

3.4.3  Algorithm   –        –        –        –        –        –        –        21

3.4.4  Program Flowchart        –        –        –        –        –        22-24

3.4.5  Database Design  –        –        –        –        –        –        25

CHAPTER FOUR: SYSTEM IMPLEMENTATION AND DOCUMENTATION

4.0     Introduction                  –        –        –        –        –        –        –        26

4.1     System Design Diagram –        –        –        –        –        –        26     

4.2     Choice of Programming Language              –        –        –        27

4.3     Analysis of Modules               –        –        –        –        –        27     

4.4     Programming Environment     –        –        –        –        –        28

4.4.1 Hardware Requirements –        –        –        –        –        –        28

4.4.2Software Requirements   –        –        –        –        –        –        28

4.5     Implementation              –        –        –        –        –        –        29

CHAPTER FIVE: SUMMARY, CONCLUSIONAND RECOMMENDATIONS

5.0     Introduction         –        –        –        –        –        –        –        –        30

5.1     Constraints of the Study         –        –        –        –        –        –        30

5.2     Summary                       –        –        –        –        –        –        31     

5.3     Conclusion                     –        –        –        –        –        –        31

5.4     Recommendations                   –        –        –        –        –        –        32

          References                      –        –        –        –        –        –        33-34

           Appendix A (Source Code)-   –        –        –        –        –       35-38

           Appendix B (Output)                        –      –        –        –       39-41

CHAPTER ONE

INTRODUCTION

1.0 Introduction

This chapter presents the introduction to petroleum product inventory management system. It presents the introduction, background of the study, statement of problem, aim/objectives of the study, the significance of the study, scope of the study, and organization of the research.

A petroleum product inventory management system is an automated system that can be used to keep inventory record of stock level of petroleum products on a daily basis. The system enables the owners of filling station to calculate daily sales and determine number of litres of petroleum product left so as to easily know when to re-order. Also, a petroleum product inventory management system is an automated system that will aid easy management of petroleum sales and inventory record in filling station so that needed reports can be presented when needed. A filling station, gas station or petrol station is an establishment that sells fuel and lubricants usually gasoline (petrol) or diesel fuel. Some stations carry fuels like liquefied petroleum gas (LPG), natural gas, or kerosene. In recent times, filling stations have added shops to their primary business and convenience stores are now a familiar sight alongside pumps (Abdulahi, 2004).

1.1 Background of the Study

The term “gas station” or filling station is mostly particular to the United State and Canada, where petrol is known as “gas” or “gasoline”. Elsewhere in the English-speaking world the form “petrol station”, “petrol pump”, or the old fashioned term “petrol garage” is used. In the United Kingdom, the single noun “Garage” is still commonly used even though the station being referred to may have no services/maintenance facilities which would justify this description. In Nigeria, the term “petrol station” or „filling station” is used.The difference in mode of operation constitutes a big problem for the major distributors who have to ensure that the retailing stations effectively disburse their allocation and still maintain the corporate image of the oil companies and at the same, maximizing the profit of both parties. To ensure maximum profitability of the major distributor in the industry, they have to ensure that the retailing station not only has a wide reach for marketing their products, but they market those products effectively and be fully accountable. This has led them to provide transportation services for the conveyance of the products from the depots to the respective filling stations (Christopher and Adepoju, 2012).

At the filling station, there is need for petroleum product sales management system to enable the management of the filling station to have adequate record of the inventory of petroleum product dispensed daily. It is in view of this necessity that demanded this research.

PETROLEUM PRODUCT INVENTORY MANAGEMENT SYSTEM