General Store Management System

Abstract

As the world is continuously advancing and software to automate everything is available already. General stores are a very basic need of every citizen as they provide a variety of services like stationary, grocery, daily necessities etc. So, an efficient way to manage and run a general store is very important. Also, the paper bills are not very handy and are not reliable as well as they degrade overtime, stock calculations get unmanageable and hard to keep records of, the retailer also faces hardships on employee tracking.

Introduction

I. INTRODUCTION

General Stores are an important and basic utility for the citizens as they provide all sorts of needs/items to the customers. But mostly it happens that the item is available, and the employee/manager is not able to find/locate the item, this problem is almost faces in every general store and it also causes great inconvenience to the customers as well, In the business world customer satisfaction is very important but, in such scenarios, it is ruined completely. By using this general store management system, you can avoid these conditions by a great margin thus increasing the management of the store and the customer satisfaction which increases the stores popularity as well.

II. FUNCTIONALITY

Following are the functionalities provided by the General Store Management System

1. Create User ID: In this the user will create his/her profile and the priority is high
2. Login: In this the user will enter the credentials set by him/her during the create user ID functionality and the priority is high
3. Manage Stock: Through this the user can manage all the stocks and the priority is medium
4. Add Stock: Through this the user can add the stocks and the priority is medium
5. Remove Stock: Through this the user can remove the stocks and the priority is medium
6. Manage Employee: Through this the user can manage all the employees and the priority is medium
7. Add Employee: Through this the user can add an employee and the priority is medium
8. Remove Employee: Through this the user can remove an employee and the priority is medium
9. Report Generation: Through this the user can generate the report of the stocks & employee and the priority is medium
10. QR code Scanning: For instant product identification and easy tracking, QR codes are used.
11. Application should me made using C/C++ and java only to increase speed and security of the software
12. Desktop purpose only
13. Minimum requirement should be at least windows 7
14. Should be available 24/7.
15. At most 5 employees should be able to use the software at once

III. OBJECTIVE

1. Material Availability: Ensure the availability of all kinds of material whenever they are needed.
2. Keeping Loses to a Minimum: When there is no monitoring at the store the chances of losing/misplacing an item are more which is not good in terms of customer satisfaction and economically too.
3. Maintaining Sufficient Stocks: Stocks should be maintained properly to ensure the availability of the item every time the customer asks about it.
4. Cost effective Storage: The storage of the extra stocks should be proper and space efficient as it will reduce the total cost of storing the stocks.
5. Optimizing Product Sales: Sales are the most important aspect of a general store without there is no meaning of the general store, the software will understand the volume of sales occasionally and then it will automatically maintain the stocks according to previous sales and will also make assumptions on the future sales as well.

IV. SCOPE

The scopes of this project are:

1. All the small-scale General Store owners
2. All the large-scale General Store owners
3. Can be used in the management of the items kept at warehouses

V. PROJECT DESCRIPTION

The General Store Management System will manage the stocks and the flow of money and will the store employees to control and keep track of the goods they buy and sell. It will contain many modules to ensure the proper coordination between the user and the software.

VI. METHODOLOGY

For this project development we’ll use Incremental model and develop the project in iterations as this is not a very large project so the iteration model will be good in terms of development and will also provide faster results.

VII. EXPECTED OUTCOME

The outcomes of this project are:

1. Increase in the efficiency of the management system of the store
2. increases in the workflow of the store.
3. Will increase the overall profit of the store by increasing the workflow and management of the system.
4. User friendly interface.
5. Will provide a user friend experience to the Store employee.

VIII. RESOURCES AND LIMITATIONS

The requirement of the resources for designing and developing the proposed system must be given. The resources might be in form of the hardware / software or the data from the industry. The limitations of the proposed system in respect of a larger and comprehensive system must be given.

A. Software Requirements

a. Will work on all windows prior to Windows 7.

b. Database MySQL.

c. Excel for reports

B. Hardware Requirements

a. CPU: Intel core 2 duo (minimum).

b. Ram: 512 megabytes.

c. Display with any type of output/input.

d. Input device such as keyboard and mouse.

e. Storage: 256 gigabytes (any type: hard disk/SSD).

IX. ESTIMATION OF PROJECT METRICS

A. Basic COCOMO Model

Using COCOMO model we declare this project as “Semi-detached” as the team consist of inexperienced members as well as one experienced mentor/member. Based on the study of the existing project the size of this project could be around 2500 lines of code. We will assume this for the estimation of the project metrics using basic COCOMO model.

B. Calculating Efforts and Time

As this project is categorized as “Semi-detached” the values of a, b and c are 3.0, 1.12 and 0.35

XI. DATA FLOW DIAGRAM

For this project development we’ll use Incremental model and develop the project in iterations as this is not a very large project so the iteration model will be good in terms of development and will also provide faster results.

1. Level 0 DFD of General Store Management System

XIII. IDENTIFYING DOMAIN CLASSES

As the world is continuously advancing and software to automate everything is available already. General stores are a very basic need of every citizen as they provide a variety of services like stationary, grocery, daily necessities etc. So, an efficient way to manage and run a general store is very important. Also, the paper bills are not very handy and are not reliable as well as they degrade overtime, stock calculations get unmanageable and hard to keep records of, the retailer also faces hardships on employee tracking.

From the given problem statement, we can identify the following nouns and noun phrases:

1. General Store
2. Software Engineering
3. Manager
4. Admin
5. Owner
6. Customer
7. System
8. Records
9. Application
10. Software
11. Information
12. Password
13. Profile
14. Stock Management
15. Employee
16. Details
17. Registration
18. Login

Let us put the above into different categories:

a. People

• Manager
• Admin
• Owner
• Customer
• Employee

b. Places

• General Store

c. Things

• System
• Stocks

d. Concepts

• Records
• Information
• Password
• Profile
• Software Engineering

e. Events

• Registration
• Login

The nouns and noun phrases in the problem in the problem statement gives us a list of 18 potential classes. However, all of them may not be relevant. if we filter these entities, we might find that the following set of classes directly relate to the activity of General Store management system:

• User
• Stock
• Employee
• Generate Report

XIV. State Chart and Activity Modelling

The figure below is State Chart diagram for General Store Management System

XV. MODELLING UML DIAGRAM

Based on conceptual modelling and domain knowledge we already had identified a list of classes:

1. User
2. Stock
3. Employee
4. Generate Report

XVI. MODELLING UML SEQUENCE DIAGRAM

It represents the behavioural aspects of a system. Sequence diagram shows the interactions between the objects by means of passing messages from one object to another with respect to time in a system. Figure 12.1 shows Sequence Diagram for Report Generation and Figure 12.2 shows Sequence Diagram for Add Employee

Conclusion

General Stores are the very essential part of individual’s life. So, the presence of effective general store management application/system is necessary as it will help in reducing the human labour by organizing the stocks and will increase the cash flow which will ultimately help the customers and the store owners as well. It also checks the availability of the materials and if they are not available then the software will give warning and will ask the user to refill the stocks this will help the store managers to maintain the stocks. It will also manage the proper storage of the extra stocks and will provide space efficient storage as it will reduce the total cost of storing the stocks.

References

[1] Y?ng F?n, “Devel??ment of Inventory management System”, Information Management ?nd Engineering (I?IME), 2010 The 2nd IEEE International ??nferen?e ?n: ?hengdu. [2] S.AngelRaphella, S.Gomathi Nathan and G.Chitra, “Inventory Management- A Case Study”, International Journal of Emerging Research in Management &Technology, ISSN: 2278-9359, Vol.3 (3) June 2014, pp.94-102. [3] Wikipedia (2013), Inventory Management Software Retrieved 22 Jun 2013 from http://en.wikipedia.org/wiki/Inventory_management_software [4] H?k?n ERDEN,“The Agricultural Inventory Management System“,?gr?-Ge?inf?rm?ti?s(?gr?e?inf?rm?ti?s), 2015 Fourth International ??nferen?e on Istanbul

Copyright

Copyright © 2022 Jatin Jangid, Prof. Sushma Khatri. This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.