Abstract
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:
- Which items and how much of them should be on stock?
- Where to store them?
- 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.