Sales Recording And Report Management System For Supermarket

Computer Science Project Material with Source Code Included

Computer Science Project Material with Source Code Included


The research work is focused on sales recording and report management system for supermarket, a case study of Bonanza supermarket, Ikot Ekpene. The essence of the sales recording and report system is to aid in managing the financial and stock information of items in the supermarket. The problem that necessitated the development of the system are: difficulties in instantly getting needed reports of sales made daily, errors in computation and inability to monitor the stock level of items sold in the supermarket. Therefore, the aim is that there should be a system that can provide sales report information when needed. The system, facilitates quick report generation whenever it is needed. It is recommended that supermarket owners should make use of automated management systems to manage their operations. In conclusion, stock management for supermarket is a very important information system for managing inventory level of stock. Use case model was adopted to represent the components of the system. The software methodology used is spiral model and the programming language used in Visual BASIC 6.0.

Chapter One


1.0 Introduction

A sales recording and reporting management system for supermarket is a computerized system that will aid the easy management of financial and inventory aspects of the supermarket so that reports can be presented when needed. The range of items and materials which might be held in supermarkets is huge. The variety and quantity of items and materials held in a supermarket will depend on its size and on its range of activities. Since the items in a supermarket are meant for sales, there is therefore need for a sales recording and report management system. Every item in a supermarket constitutes to the generality of the stock in the supermarket. As sales are being made, the stock levels of the items are reducing thereby making stock control a vital aspect of supermarket sales management.

Stock control in supermarket comprises mainly the clerical and administrative functions of stock control involves the following: Ensuring that the right types and qualities of items needed for production, sale and distribution, are always available when required, ensuring that stock is issued in the correct sequence, that is, “first in first out”, so that “older” stock is not allowed to deteriorate by being kept too long in the Store, for instance because it has been hidden from view by more recently received stock, maintaining records showing the “movement” of items into and out of the Store, controlling and monitoring those movements and maintaining full records of the items in the Store, ensuring that the correct “stock levels” of the various items are set and are maintained, that orders and reorders are made (or requested to be made) in good time, and that what is ordered is received, checking, counting or otherwise measuring stock to ensure that records are accurate and that no losses are occurring due to pilfering, theft, damage or poor storage, pricing and valuing the items in the Store.

For optimal supermarket sales and inventory management process, robust functionality is needed for managing the stocks in the supermarket. This will enable the management of the supermarket to easily record and keep track of sales made, the items sold and other valuable report needed to monitor the income and expenses in the supermarket daily.

1.1 Statement of the Problem

The following problems were identified in the existing system at Bonanza supermarket in Ikot Ekpene:

  1. It is difficult to obtain reports about the financial details of the sales made daily.
  2. There is error most times in the computation of items sold.
  3. The stock level of items cannot be easily monitored as they are being sold.

1.2 Aim and Objectives of the Study

The aim of the study is to develop a sales recording and report management system for supermarket. The following are the specific objectives of the study:

  1. To design a software system. To accurately compute sales record.
  2. To implement a system that will save sales record to database for future reports purpose
  3. To design a system that will update inventory level of the items sold to database.

1.3 Scope of the Study

This research work covers Sales recording and report management system for supermarket a case study of Bonanza supermarket, Ikot Ekpene. It is limited to the recording of daily sales and managing of the stock level (inventory) of items sold

1.4 Significance of the Study

The significance of the study are:

  1. It will provide a system that will facilitate accurate recording of sales in a supermarket.
  2. It will help in monitoring the daily sales record of the supermarket through querying of the database records.
  3. It will provide a system that can be used to perform computation of the items sold in the supermarket.
  4. It will serve as a useful reference material to other scholars.

1.5 Organization of the Research

This research work is organized into five chapters.

  1. Chapter one is concerned with the introduction of the research study and it presents the preliminaries, theoretical background, 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.
  2. Chapter two focuses on the literature review, the contributions of other scholars on the subject matter is discussed.
  3. Chapter three is concerned with the system analysis and design. It analyzes the present system to identify the problems and provides information on the advantages and disadvantages of the proposed system. The system design is also presented in this chapter.
  4. Chapter four presents the system implementation and documentation. The choice of programming language, analysis of modules, choice of programming language and system requirements for implementation.
  5. Chapter five focuses on the summary, conclusion and recommendations are provided in this chapter based on the study carried out.

1.6 Definition of Terms

Sales Management:

Sales management is a business discipline which is focused on the practical application of sales techniques and the management of a firm’s sales operations. It is an important business function as net sales through the sale of products and services and resulting profit drive most commercial business.


Inventory is the raw materials, work-in-process products and finished goods that are considered to be the portion of a business’s assets that are ready or will be ready for sale.


The goods or merchandise kept on the premises of a shop or warehouse and available for sale or distribution.

Chapter Five

Summary, Conclusion and Recommendations

5.0 Introduction

This chapter presents the summary, conclusion, constraints of the study and offers useful recommendations.

5.1 Constraints of the study

In carrying out the research work, some challenges were faced that limited the study such as:


The time given for the completion of the research work was too short hence the researcher had speed up the research work to meet up and this has an impact on the study.

Limited Materials:

Few materials were found pertaining to the research area and this limited the bulk of the literature review.


The high cost of textbooks, internet browsing and transportation to different libraries to gather materials stood as a constraint to the research work.

5.2 Summary

A sales recording and reporting management system is an automated system that aids store keepers to maintain proper record of sales and inventory so that reports can be retrieved when needed without a proper database system to manage supermarket records, it will be difficult to get reports of daily sales.

5.3 Conclusion

A sales recording and reporting management system aids supermarket managers to properly manage their financial record of sales. It aids the accurate computation and recording of sales information. the system serves as a management information system to the management of the supermarket.

5.4 Recommendation

The following recommendations are offered based on the study:

  1. Supermarket managers should implement a computerized stock recording and reporting management system for supermarket.
  2. More research should be encouraged in the area of the development of stock recording and reporting management system.
  3. Personnel of supermarkets should be trained to be computer literate

Project Material Download

5,000 5000

The Complete Material Will Be Sent to You in Just 2 Steps

Quick & Simple…

Step One Purchase

Make Payment (Through Transfer) of ₦5,000 to Any of the Account Below

Access Bank PlcAcc No: 0811003731
Samphina Academy
Current Account
Zenith BankAcc No: 1225513212
Samphina Academy
Current Account

Or CLICK HERE To Pay With Debit Card

CLICK HERE To Purchase Material ($15)
Make Payment of 120 GHS to 0553978005 | Douglas Cloud Osabutey | MTN MoMo

Step Two Purchase

Send the Following Details on WhatsApp ( 08143831497) After Payment

  1. Payment Details

  2. TOPIC: Sales Recording And Report Management System For Supermarket

The Complete Material Will Be Sent To You On WhatsApp After Receiving Your Details
T & C Apply

  Contact Our Help Desk

Need a Different Topic? Perform a Quick Search

List of Related Works

Click on Any Topic to Preview the Content

Samphina Academy

Samphina Academy is an Online Educational Resource Center that is aimed at providing students with quality information and materials to aid them in succeeding in their academic pursuit.