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.
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?