COMPUTERIZED SUPERMARKET MANAGEMENT SYSTEM

Postgraduate

Abstract

Supermarket stock and inventory is one the largest priced asset of a business after the fixed asset. Keeping the inventory also means keeping a tab on the realizable value, market value of all the stocks, stock in production and finished stock. This project explores the challenges of manual inventory management system for supermarkets and infers solutions to the current challenges by designing a computerized supermarket management system to order and update the stocks. The main method used for this research work is interview. Data were collected from Bluemart supermarkets and used as a tool for obtaining facts. When the goods were supplied the update of the stocks were being taken from time to time. The finding shows the challenges facing the manual system of Supermarket management system; the manual system requires everyday counting of items in the inventory, human errors are very prevalent during counting and recording and in case of disaster like fire or flood or poor communication, all the manual inventory records will be damaged and irretrievable. Based on the findings this paper highlights the possible solutions to the above problems; a computerized Supermarket management system is designed to implement possible solutions to the order and update of goods and stocks in the supermarket.


  INTRODUCTION

With the rapid development of modern science and technology, computer technology has penetrated into all fields and becomes the necessary tools for various industries, especially the Internet technology promotion and the establishment of the information highway. It makes the IT industry increasingly shows its unique advantages in the market competition. Into the digital age, there is a huge data information waiting for processing and transmission, which makes the further development and use of the database is particularly urgent. As some small and medium-sized supermarkets in the domestic market, they are falling behind the large and medium-sized supermarkets during the informatization, but for these enterprises' resource management, information storage and processing also shows the urgent need. To adapt to market competition, it requires efficient handling and management methods, so it is indispensable that accelerate the process of the computerization of supermarket.

Small and medium-sized supermarkets have an important position in Nigeria economic development. At present, our country has a lot of small and medium-sized supermarkets, regions are widely distributed, and the information level of small and medium-sized supermarkets is still very low. With the development of the technology, the computer operation and management is increasingly simplified, computer knowledge is increasingly popularization. At the same time, the fast changing of market economy and intense competition, it is must become inevitable trend that the supermarket industry uses computer to manage inventory, sales, and many other links. As a small and medium-sized supermarket, their main business is selling products. But at present a lot of questions exist in the system operation, all sales orders are artificial fill, time-consuming and prone to errors; inventory is artificial bookkeeping and unable to keep track of the most accurate inventory situation; For sales data, it often spend a lot of time and energy to calculate the sales performance of each business membership and each good sales. In order to solve the above problems and improve the economic benefit, we will prepare for computerized management for the supermarket.

 

STATEMENT OF PROBLEM

Being a Computer Technology student we had to go into the business department to learn some basic sales and supermarket management topics to increase our intellectual understanding on the project at hand it was really tasking.

Building a standard Supermarket management system was not an easy task looking at the problems of existing manual system

The factors for these difficulties are:

1. Time Consumption: Manual systems are time consuming, as the business owner must keep track of Supermarket sales on a daily basis, while updating the system manually at the end of the day.

2. Poor Communication: A manual Supermarket system requires employees and managers to write down each time an item is removed from the Supermarket. If one employee forgets to mention that the last coffee product has been removed from the Supermarket, a manager expects the item to still be available for a customer during a sale. Compared with a technical Supermarket system, a manual Supermarket system does not help the communication in the workplace.

3. Physical Counts: A manual Supermarket system does not provide any number, as all numbers from the Supermarket are gained through physical Supermarket counts. One of the difficulties of running a manual Supermarket system is that physical Supermarket counts must be performed frequently to control the items in the Supermarket. This is time consuming and can cost the business money, if employees must come in to help out outside of business hours.

4. Daily Purchases: Keeping track of daily purchases is another difficult controlling measure with manual Supermarket systems. A manual Supermarket system requires the employees to write down the items sold during a single work day. This can be a difficult task, as one employee may lose the list of items sold or another may forget to write down a sale.

5. Ordering Supplies: A manual Supermarket system does not update at the end of the day with updated Supermarket

 AIMS AND OBJECTIVE OF STUDY

Aim of study is

To design a Computerized Supermarket Management System to ascertain stock level of a supermarket, when to order for more goods, keep status and updates of transactions, thereby helping progress level, stock taking and managerial decisions,.

The objective are 

1. To study the functions of Supermarket management system.

2. To explore the challenges being faced by the manual system.

3. To make a software fast in processing, with good user interface.

4.To ensure accurate statistics of product item.

5.  For Easy record of goods in store and proper identification.