Design and implementation of stock management system for supermarket

Project Abstract

The implementation of a stock management system for supermarkets is crucial in ensuring efficient operations and customer satisfaction. This research project focuses on the design and implementation of a comprehensive stock management system tailored specifically for supermarkets. The system aims to streamline inventory tracking, ordering, and restocking processes while providing real-time data on stock levels and sales trends. The stock management system will incorporate features such as barcode scanning for easy product identification, automatic reordering of products based on preset thresholds, and integration with point-of-sale systems for seamless stock updates. Additionally, the system will include reporting functionalities to analyze sales performance, monitor stock turnover rates, and identify popular products. The design phase of the project will involve creating a user-friendly interface that allows supermarket staff to easily navigate the system and perform tasks such as adding new products, updating stock levels, and generating reports. The system will be designed to be scalable, allowing for future expansion and integration with other business systems. The implementation phase will involve installing the stock management system in the supermarket environment, configuring it to meet the specific needs of the business, and providing training to staff on how to use the system effectively. Continuous support and maintenance will be provided to ensure the smooth operation of the system and address any issues that may arise. Overall, the design and implementation of a stock management system for supermarkets will bring numerous benefits, including improved inventory accuracy, reduced stockouts, optimized ordering processes, and increased productivity. By providing real-time visibility into stock levels and sales data, the system will enable supermarkets to make informed decisions that drive profitability and enhance customer satisfaction.

Project Overview

<p> </p><div><p><strong>INTRODUCTION</strong></p><p>The range of items and materials – stocks – which might be held in Stores is huge. The variety and quantity of items and materials held in the Store of a particular enterprise will depend on its size and on its range of activities [1]. What we refer to as stock control 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, <em>“</em>first in first out<em>”, </em>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 <strong>is </strong>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.</p><p>For optimal sales and inventory management process, robust functionality is needed for managing stocks. Warehouse management functions for inventory control cover internal warehouse movements and storage and its support helps in the recording and tracking of materials on basis of both quantity and value [1].</p><p></p></div><div><p><strong>1.1 Theoretical Background</strong></p><p>The technology used for the development of the system is database management technology.. Visual Basic 6.0 programming language was used for the interface. Below is an example of source code and rendering:</p><p>Private Sub Command1_Click()</p><p>‘Add new record code</p><p>Adodc1.Recordset.AddNew</p><p>Text1.Text = Date$</p><p>End Sub</p><p>Private Sub Command2_Click()</p><p>‘save record</p><p>Adodc1.Recordset.Update</p><p>MsgBox “SAVED”</p><p>Adodc1.Recordset.MoveFirst</p><p>End Sub</p><p>Private Sub Command3_Click()</p><p>‘delete record</p><p>On Error GoTo AB</p><p>Adodc1.Recordset.Delete</p><p>AB:</p><p>End Sub</p><p>Private Sub Command4_Click()</p><p>‘move to next record</p><p>On Error GoTo AB</p><p>Adodc1.Recordset.MoveNext</p><p>AB:</p><p>End Sub</p><p>Private Sub Command5_Click()</p><p>‘Move to previous record</p><p>On Error GoTo AB</p><p>Adodc1.Recordset.MovePrevious</p><p>AB:</p><p>End Sub</p><p>Private Sub Command6_Click()</p><p>‘close form</p><p>Unload Me</p><p>End Sub</p><p>Fig 1.1: Stock Registration form</p><p><strong>1.2 Statement of the Problem</strong></p><p>Beverly Hill supermarket in Ikot Ekpene does not have an automated system to manage stock and this raises a number of problems such as:</p><ol><li>The recording of sales and cash received are done manually on a book that appears rough.</li><li>It is difficult to know when certain items need to be re-stocked. Thus, the books are exposed to physical damage, information can be lost.</li><li>There is a long list of stock orders waiting to be attended to on daily basis.</li></ol><p><strong>1.3 Aim and Objectives of the Study</strong></p><p>The aim of the study is to design and implement a stock management system that will aid track inventory level as stocks are being sold.</p><p>The following are the objectives of the study:</p><ol><li>To track stocks as they are being sold so as to know when to re-order or re-stock</li><li>To update stock level on a daily basis</li><li>To generate daily report of inventory when needed.</li></ol><p><strong>1.4 Significance of the Study</strong></p><p>The significance of the study are:</p><ol><li>It will help in monitoring stock level so that the firm does not run out of stock.</li><li>It will aid easy updating of inventory.</li><li>It will serve as a useful reference material to other scholars.</li></ol><p><strong>1.5 Scope of the Study</strong></p><p>This research work covers design and implementation of stock management system for supermarket using Beverly Hills super market Ikot Ekpene as a case study.</p><p><strong>1.6 Organization of the Research</strong></p><p>This research work is organized into five chapters. 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.</p><p>Chapter two focuses on the literature review, the contributions of other scholars on the subject matter is discussed.</p><p>Chapter three is concerned with the system analysis and design. It presents the research methodology used in the development of the system, 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.</p><p>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.</p><p>Chapter five focuses on the summary, constraints of the study, conclusion and recommendations are provided in this chapter based on the study carried out</p></div> <br><p></p>