WEB-BASED EMPLOYMENT SCREENING MANAGEMENT SYSTEM A CASE STUDY OF FEDERAL GIRLS COLLEGE, IKOT OBIO ITONG

Abstract

This research work is focused on the development of a Sales and Inventory management system for fast food restaurant using Oliver Tweets supermarket, Ikot Ekpene as a case study. The system is an online system that aids the management of sales record, monitoring of the stock level of each item as they are sold, so that the inventory and stock available can be updated easily and saved to a server database, online for reliable management of sales and inventory records. Fast food restaurants managers are faced with the challenge of not knowing when they run out of stock and reports of daily sales cannot be instantly presented. The manual system of obtaining and recording sales and inventory management information is ineffective. It is in view of these challenges that sales and inventory management system is needed to effectively and efficiently handle sales records, and update the inventory. The proposed software development methodology and programming language used to develop the system are object oriented analysis and design, pHp and MySql database. Use case diagram is also utilized to model the proposed system.

TABLE OF CONTENTS

Title Page             –        –        –        –        –        –        –        –        i

Certification         –        –        –        –        –        –        –        –        –          ii

Approval Page     –        –        –        –        –        –        –        –        iii

Dedication            –        –        –        –        –        –        –        –        iv

Acknowledgment –        –        –        –        –        –        –        –        v

Abstract               –        –        –        –        –        –        –        –        vi

Table of Contents –        –        –        –        –        –        –        –        vii-ix

List of Figures      –        –        –        –        –        –        –        –        x

List of Tables       –        –        –        –        –        –                  –        xi

CHAPTER ONE: INTRODUCTION

1.0     Introduction         –        –        –        –        –        –        –        1

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

1.2     Statement of Problem              –        –        –        –        –        3

1.3     Aim and Objectives of the Study-     –        –        –        –        3

1.4     Significance of the Study         –        –        –        –        –        –        3-4

1.5     Scope of the Study        –        –        –        –        –        –        –        4

1.6     Organization of Research        –        –        –        –        –        –        4-5

1.7     Definition of Terms       –        –        –        –        –        –        5

CHAPTER TWO: LITERATURE REVIEW

•    Introduction –        –        –        –        –        –        –        –        6

2.1 Theoretical Background    –        –        –        –        –        –        6-9

2.2. The Concept of Inventory Management        –        –        –        –        10

2.3  Inventory Documentation/ Stock Record      –        –        –        –        10-11

2.4 Difficulties in the Manual Inventory System  –        –        –        11-12

2.5 Reasons for Carrying Out Sales and Inventory Management-    12-14

CHAPTER THREE: SYSTEM ANALYSIS AND DESIGN

3.0 Introduction   –        –        –        –        –        –        –        –        15

3.1 Research Methodology      –        –        –        –        –        –        15

3.2 Analysis of the Existing System –        –        –        –        –        15

3.2.1 Advantages of the Existing System   –        –        –        –        16

3.2.2 Disadvantages of the Existing System        –        –        –        –        16

3.3 Analysis of the Proposed System         –        –        –        –        –        16

3.3.1 Advantages of the Proposed System –        –        –        –        16-17

3.4 System  –        –        –                  –        –        –        –        –        17

3.4.1 Input Layout         –        –        –        –        –        –        –        –        17-19

3.4.2 Output Layout      –        –        –        –        –        –        –        20

3.4.3 Algorithm    –        –        –        –        –        –        –        –        21

3.4.4 Program Flowchart        –        –        –        –        –        –        –        22-27

3.4.5  Database Design  –        –        –        –        –        –        –        28

3.4.6 System Architecture       –        –        –        –        –        –        28

3.4.7 Use Case Model/Class Diagram        –        –        –        –        –        29-31

CHAPTER FOUR: SYSTEM IMPLEMENTATION AND DOCUMENTATION

4.0     Introduction                  –        –        –        –        –        –        –        32     

4.1     System Design Diagram –        –        –        –        –        –        32     

4.2     Choice of Programming Language              –        –        –        32

4.3     Analysis of Modules               –        –        –        –        –        32-33

4.4     Programming Environment     –        –        –        –        –        33

4.4.1  Hardware Requirements          –        –        –        –        –        33-34

4.4.2  Software Requirements  –                  –        –        –        34

4.5     Implementation    –        –        –        –        –        –        –        34     

4.6     Software Testing  –        –        –        –        –        –        –        34-35

CHAPTER FIVE: SUMMARY, RECOMMENDATION AND CONCLUSION

5.0     Introduction                   –        –        –        –        –        –        –        36

5.1     Constraints of the Study         –        –        –        –        –        –        36

5.2     Summary                       –        –        –        –        –        –        36-37

5.3     Conclusion                     –        –        –        –        –        –        37

5.4     Recommendations                   –        –        –        –        –        –        37

References                    –        –        –        –        –        –        38

          Appendix A         (Source Code)     –        –        –        –        –        39-47

          Appendix B         (Output)     –        –        –        –        –        –        48-53

LIST OF TABLES

                                                                                                Page Number

Table 3.1: Stock registration output layout         –        –        –        22

Table 3.2:  Sales output layout         –        –        –        –        –        22

Table 3.3: Stock Registration database design     –        –        28

Table 3.4: Sales Database Design     –        –        –        –        28

LIST OF FIGURES

                                                                             Page Number

Fig. 2.1: Stock registration data capture     –        –        –        9

Fig 3.1: Stock registration input layout      –        –        –        17

Fig 3.2: Sales Input Layout     –        –        –        –        –        18

Fig 3.3: Stock update input layout   –        –        –        –        19

Fig. 3.4: Login flowchart                   –        –        –        –        –        22

Fig 3.5: Home page flowchart –        –        –        –        –        23

Fig 3.6: Stock registration flowchart –        –        –        –        24

Fig 3.7: Sales flowchart                    –        –        –        –        25

Fig 3.8:Update Inventory flowchart  –        –        –        –        26

Fig 3.9: Database Flowchart   –        –        –        –        –        27

Fig 3.10: System Architecture –        –        –        –        –        28

Fig 3.11: Use case model         –        –        –        –        –        –        29

Fig 3.12: Class Diagram          –        –        –        –        –        –        30

CHAPTER ONE

INTRODUCTION

1.0 Introduction

This chapter presents the introduction to web basedsales and inventory management system for fast food restaurant. It presents the following: introduction, background of the study, statement of the problem, aim and objectives of the study, significance of the study, scope of the study, organization of the research and definition of terms.

1.1 Background of the Study

Sales and inventory management is one of the basic problems of business organizations that need to effectively manage their financial information and stock records. It may cause a lot of paper work, if there is no automated system available. Inventory management is the process of efficiently overseeing the constant flow of units into and out of an existing stock of goods. This process usually involves controlling the transfer units in order to prevent the inventory from becoming too high or dwindling to levels that could put the operation of the company into jeopardy (Bailey and Farmer, 2012).

Inventory management is primarily about specifying the size and placement of stocked goods. It is an activity specifying the shape and percentage of stocked goods. Inventory management is required at different locations within a facility or within multiple supply network to protect the regular and planned course of production against the random disturbance of running out of materials or goods. The scope of inventory management also concerns the fine lines between replenishment and lead time, carrying cost of inventory, asset management, inventory forecasting, inventory valuation, inventory visibility, future inventory price forecasting, physical inventory, available physical space for inventory, quality management, replenishment, returns, defective goods and demand forecasting (Dobler & Burt, 2016). Planning and controlling of inventory management is concerned with the following basic questions:

1. Which items and how much of them should be on stock?
2. Where to store them?
3. How is the re-order point defined?

To compete more effectively in a global market place, it is important that firms understand the issue of inventory control and align their purchasing to the diverse environments in which they operate. It is a paradox to note that the organizations often complain of the non-availability of some items to meet their requirement and finance department is facing the problem of increasing locked up capital in assorted inventory (Burton, 2011). Inventory constitutes the most significant part of current asset in organizations. Because of the relative largeness of inventories maintained in business organizations, a considerable sum of an organization’s fund is being committed to them. It thus becomes absolutely imperative to manage inventories effectively so as to avoid unnecessary cost and ensure high level of customer service (Dobler & Burt, 2016).

In fast food restaurants, sales are done regularly and as the stock level of each product are sold, the stock reduces and this affects the inventory level. In order for the management of fast food restaurant to be able to get reports of the inventory level and reports of daily sales, a web-based sales and inventory management system is needed to aid the manager of the fast food restaurant to know when they should re-order more stock, update inventory and also view sales financial information report.

DOWNLOAD PROJECT