DESIGN AND IMPLEMENTATION OF A WEB BASED SYSTEM FOR SALES AND INVENTORY MANAGEMENT
ABSTRACT
A sales and inventory system is a software-based business solution used to simultaneously track sales activity and inventory. Computerized sales and inventory systems save time for businesses by speeding up transactions while raising accuracy. The aim of the study is to design and implement a web based application that will manage the sales and inventory on goods and services. In achieving this aim, the following specific objectives were laid out to create a database that will help store sales records and develop an independent user application software. The motivation that led to the implementation of the proposed system is that the recording of sales and cash received are done manually on the book that appear rough, inaccuracies in record keeping due to human errors and difficulty involved in knowing when certain items need to be restocked. The methodology adopted in this study is the structure system analysis and design methodology (SSADM) which is a technical approach for analyzing and designing an application or system by applying object oriented programming as well as visual modeling throughout the software development. The programming language used is HTML, CSS, JAVASCRIPT, PHP, SQL and JQUERY. The reason why web programming languages was used is because, it is platform independent and it is a web based application. The significance of this study is to Beverly Hills that will provide easy-to-use and easy accessed system thus transactions will be more reliable and faster that they do not have to hire another employer to do the job. It gives more accurate and secure records of sales and list of products. Based on the findings of this study, recommendations made are that constant monitoring of the activities with the designated sales and inventory management software application, it is necessary to determine their level of compliance while adequate training should be provided for the recruitment of staff to enhance their efficiency and productivity. The expected result is A Web Based System for Sales and Inventory Management that will capture the sales and inventory activities and automate sales and inventory task/activities.
CHAPTER ONE
1.1 Introduction
A sales and inventory system is a software-based business solution used to simultaneously track sales activity and inventory. Manufacturers and trade resellers can both benefit from a thorough solution, where single transaction entry records necessary details on the customer, products purchased, price and date while also updating inventory levels. Computerized sales and inventory systems allow for much greater accuracy in stocking and product management. They encourage ease of interaction between employees and shoppers as transactions are processed and items move from the business to the consumer. Computerized sales help provide better insight into which products are most popular. It also allows for enhanced marketing, stocking and oversight of critical sales objectives. Computerized sales and inventory systems save time for businesses by speeding up transactions while raising accuracy. This allows for confidence in accounting and accountability among employees as it is easy to verify how much money and what time transactions took place.
As a prelude to other parts of this study, this chapter will discuss the background upon which this study was initiated, the statement of problems that led to this study, the Aim and Objectives of the study. Others are Significance of the study, Scope of work, Limitations of the Study and Definition of technical terms.
1.2 Background of the Study
The company Beverly Hills Supermarket is a small store that is managed by one person, the owner. The business sells different items or products like household equipment, drinks, grocery and other items that we can see everywhere. Like some other convenience store, the business does their physical counting of stocks manually. Technically, Beverly Hills Supermarket is only using a manual system that may cause to duplication of documents and work redundancy. The business is just depending on their manual listing of products and inputs of data which is possible to commit errors. The business cannot view their proper records of sales or income in a given time of the year. It also does not have its proper listings of product. In some instances, lost items are just being ignored by the owner. Beverly Hills Supermarket does not have any extra employee today. But before, the business had one cashier on that time. And basically, introduced the income and force to remove employees. How, the owner is the one who does all work in the business.
Computerized sales and inventory systems save time for businesses by speeding up transactions while raising accuracy. This allows for confidence in accounting and accountability among employees as it is easy to verify how much money and what time transactions took place. They also allow for consistent experiences in terms of customer service. People know there is always a uniform interaction at the register that requires tendering payment, taking a receipt and transition of ownership of products and services. This generates confidence in a business and ensures ongoing consumer relationships. Computerized systems are the most common method of inventory control and sales processing in retail markets.
1.3 Statement of the Problem
Investigation revealed the problems of the existing Sales and Inventory Management system which is stated as follows:
- The recording of sales and cash received are done manually on the book that appear rough.
- It is difficult to know when certain items need to be restocked
- The manual system of inventory system is stressful and time consuming
- Inaccuracies in record keeping due to human errors.
1.4 Aim and Objectives of the Study
The aim of the study is to design and implement a web based application that will manage the sales and inventory on goods and services. In achieving this aim, the following specific objectives were laid out as follows:
- To create a database that will help store sales records
- To develop an independent user application software
- To capture the sales and inventory activities
- To automate sales and inventory task/activities.
1.5 Scope of the Study
The scope of the study focuses on the Design and Implementation of a Web Based System for Sales and Inventory Management. The system is targeted to the small or medium organization which does not have proper record of their product as Beverly Hills supermarket.
1.6 Significance of the Study
The significance of this study is to Beverly Hills that will provide easy-to-use and easy accessed system thus transactions will be more reliable and faster that they do not have to hire another employer to do the job. It gives more accurate and secure records of sales and list of products.
Admin: manages the adding of stocks, updating the inventory, and determining the users of the system.
Customers: have the benefits of the printed receipts right after purchasing an item.
Future Researchers: would see the possibilities of upgrading the system.
Researcher: student, teacher, programmer and web-developer can benefit in this system through a detailed document
1.7 Limitations of the Study
Some of the constraints encountered during this project design include the following:
- Financial constraint: The design was achieved but not without some financial involvement. One had to pay for the computer time. Also the typing and planning of the work has its own financial involvements.
- High programming technique: The programming aspect of this project posed a lot of problematic bugs that took us some days to solve. Problem such as database connections using PHP, MySql, posed a lot of challenging.
- Time: The time frame given for the research in this semester was short and combining it with studies was tedious.
1.8 Definition of Terms
Customers: a person who buys goods or services from a shop or business.
Hardware: the physical tangible parts or component of a computer such as the cabinet, central processing unit, speakers and motherboard.
Inventory: is the goods and materials that a business holds for the ultimate goal of resale.
Inventory management: a discipline primarily about specifying the shape and placement of stocked goods.
Inventory Management system: the combination of technology(hardware and software) and processes and procedure that oversees the monitoring and maintenance of stocked products.
CHAPTER TWO
2.0 Literature Review
2.1 Introduction
The review of relevant literature is the main topic of this chapter. A literature review covers theoretical and methodological contributions to a certain issue in addition to the state of knowledge at the time of writing. It provides information about the state of the art in relation to the subject you are writing about. It examines the body of work on the chosen subject. The literature evaluation in this study comprises the …
Procedure for Downloading the PDF (Docx) Material
Design and Implementation of a Web Based System for Sales and Inventory Management (A Case Study of Beverly Hills Supermarket) can be downloaded by requesting the full set of materials at the project or seminar cost. The document will be sent via Microsoft Word (MS-Word) format via WhatsApp (e-mail) following payment confirmation.
| Seminar Material Cost ₦3,000 | Project Material Cost ₦5,000 |
Request Complete Material
 | Click here to request the Complete Material via WhatsApp including;
|
TABLE OF CONTENTSPRELIMINARY PAGES
- Title page
- Approval page
- Dedication
- Acknowledgement
- Table of Contents
- Abstract
INTRODUCTION
- 1.1 Introduction
- 1.2 Background of the Study
- 1.3 Statement of the Problem
- 1.4 Aim and Objectives of the Study
- 1.5 Scope of the Study
- 1.6 Significance of the Study
- 1.7 Limitations of the Study
- 1.8 Definition of Terms
LITERATURE REVIEW
- 2.1 Introduction
- 2.2 Theoretical Framework
- 2.2.1 Sales and Inventory Management
- 2.2.2 Motivation for Sales and Inventory Management System
- 2.2.3 Relevance of Inventory System
- 2.2.4 Types of Inventory
- 2.2.5 Inventory Classification Models
- 2.2.5.1 ABC analysis
- 2.2.6 Inventory Cost
- 2.2.8 Advantages of Sales and Inventory System
- 2.2.9 Disadvantages of Sales and Inventory System
- 2.3 Literature Survey
- 2.4 Summary of Knowledge Gaps
SYSTEM ANALYSIS AND DESIGN
- 3.1 Methodology Adopted
- 3.2 System Analysis
- 3.2.1 Analysis of the Existing System
- 3.2.2 Advantages of the New System
- 3.2.3 Weakness of the Existing System
- 3.4 Analysis of the New System
- 3.4.1 Advantages of the Proposed System
- 3.5 Justification of the Proposed System
- 3.6 High Level Model of the Proposed System
SYSTEM DESIGN AND IMPLEMENTATION
- 4.1 Objectives of the Design
- 4.2 Control Center / Overall Dataflow Diagram
- 4.3 The Submenus / Subsystems
- 4.4 System Specification
- 4.4.1 Database Design Specification
- 4.4.2 Input and Output Format
- 4.4.2 Algorithm
- 4.4.3 Data Dictionary
- 4.5 System Flow
- 4.6 System Implementation
- 4.6.1 Proposed System Requirement
- 4.7.1.1 Hardware Requirements
- 4.7.1.2 Software Requirements
- 4.7.2 Program Development
- 4.7.2.1 Choice of programming environment
- 4.7.3 System Testing
- 4.7.3.1 Test Plan
- 4.7.3.2 Test Data
- 4.7.3.3 Actual Test Result Versus Expected Test Result
- 4.7.3.4 Performance Evaluation
- 4.7.3.5 Limitation of the System
- 4.7.4 System Security
- 4.7.5 Training
- 4.7.6 Documentation
- 4.7.7 System Conversion
- 4.7.7.1 Changeover Procedure
- 4.7.7.2 Recommended Procedure
SUMMARY, CONCLUSION AND RECOMMENDATION
- 5.1 Introduction
- 5.2 Summary
- 5.3 Conclusion
- 5.3 Recommendation
- 5.3.1 Application Areas
- 5.3.2 Suggestion for Further Research
- 5.4 Contribution to Knowledge
REFERENCES
APPENDIX A - “SOURCE CODE”
APPENDIX B - “OBJECT PROGRAM”
Disclaimer for Complete Material Utilization
The displayed research work titled "Design and Implementation of a Web Based System for Sales and Inventory Management" is stated as a research guideline towards accomplishing your assigned project / seminar research work. All the research materials on this website are ONLY for research purposes and should be used as a guideline in developing your research work. For no reason should you copy word for word as projectlist.com.ng will not be liable for any who copied the material. By ordering the complete research guideline, it signifies that you've accepted our terms of service.
PRELIMINARY PAGES
- Title page
- Approval page
- Dedication
- Acknowledgement
- Table of Contents
- Abstract
INTRODUCTION
- 1.1 Introduction
- 1.2 Background of the Study
- 1.3 Statement of the Problem
- 1.4 Aim and Objectives of the Study
- 1.5 Scope of the Study
- 1.6 Significance of the Study
- 1.7 Limitations of the Study
- 1.8 Definition of Terms
LITERATURE REVIEW
- 2.1 Introduction
- 2.2 Theoretical Framework
- 2.2.1 Sales and Inventory Management
- 2.2.2 Motivation for Sales and Inventory Management System
- 2.2.3 Relevance of Inventory System
- 2.2.4 Types of Inventory
- 2.2.5 Inventory Classification Models
- 2.2.5.1 ABC analysis
- 2.2.6 Inventory Cost
- 2.2.8 Advantages of Sales and Inventory System
- 2.2.9 Disadvantages of Sales and Inventory System
- 2.3 Literature Survey
- 2.4 Summary of Knowledge Gaps
SYSTEM ANALYSIS AND DESIGN
- 3.1 Methodology Adopted
- 3.2 System Analysis
- 3.2.1 Analysis of the Existing System
- 3.2.2 Advantages of the New System
- 3.2.3 Weakness of the Existing System
- 3.4 Analysis of the New System
- 3.4.1 Advantages of the Proposed System
- 3.5 Justification of the Proposed System
- 3.6 High Level Model of the Proposed System
SYSTEM DESIGN AND IMPLEMENTATION
- 4.1 Objectives of the Design
- 4.2 Control Center / Overall Dataflow Diagram
- 4.3 The Submenus / Subsystems
- 4.4 System Specification
- 4.4.1 Database Design Specification
- 4.4.2 Input and Output Format
- 4.4.2 Algorithm
- 4.4.3 Data Dictionary
- 4.5 System Flow
- 4.6 System Implementation
- 4.6.1 Proposed System Requirement
- 4.7.1.1 Hardware Requirements
- 4.7.1.2 Software Requirements
- 4.7.2 Program Development
- 4.7.2.1 Choice of programming environment
- 4.7.3 System Testing
- 4.7.3.1 Test Plan
- 4.7.3.2 Test Data
- 4.7.3.3 Actual Test Result Versus Expected Test Result
- 4.7.3.4 Performance Evaluation
- 4.7.3.5 Limitation of the System
- 4.7.4 System Security
- 4.7.5 Training
- 4.7.6 Documentation
- 4.7.7 System Conversion
- 4.7.7.1 Changeover Procedure
- 4.7.7.2 Recommended Procedure
SUMMARY, CONCLUSION AND RECOMMENDATION
- 5.1 Introduction
- 5.2 Summary
- 5.3 Conclusion
- 5.3 Recommendation
- 5.3.1 Application Areas
- 5.3.2 Suggestion for Further Research
- 5.4 Contribution to Knowledge
REFERENCES
APPENDIX A - “SOURCE CODE”
APPENDIX B - “OBJECT PROGRAM”
Disclaimer for Complete Material Utilization
The displayed research work titled "Design and Implementation of a Web Based System for Sales and Inventory Management" is stated as a research guideline towards accomplishing your assigned project / seminar research work. All the research materials on this website are ONLY for research purposes and should be used as a guideline in developing your research work. For no reason should you copy word for word as projectlist.com.ng will not be liable for any who copied the material. By ordering the complete research guideline, it signifies that you've accepted our terms of service.
Frequently Asked Questions (FAQ)
Can the material for “An Assessment of the Impact of Poverty Reduction Programmes in Nigeria as a Development Strategy” be used as a guide for Public Administration (PA) Project?
Yes it can be used — This study assessed the impact of poverty reduction programmes as a development strategy in Nigeria. The study first of all examined issues of poverty and underdevelopment in Nigeria, attributing it to lack of employment, high rate of illiteracy among the citizenry, poor infrastructure, inadequate access to micro credit facilities, mismanagement of public funds, bad governance, instability of the governments and its policies. The study also examined the efforts made by different governments in poverty alleviation within this period. A total number of 120 respondents were selected and administered with questionnaires, and their responses collated and analyzed. The chi-square statistical technique and percentages were used in analyzing the collated data, and testing of the research hypothesis. Results revealed that poverty alleviation …
Can this topic “Design and Implementation of Academic Transcript Management System” be used for Computer Science (CS) Project?
Yes it can be utilized for research — Students’ transcript is the summary of each of the two-year performance either in (OND) ordinary National Diploma or (HND) higher national diploma. The aim of this study is to design and implement an Academic Transcript Management System. In achieving this aim, the following specific objectives were laid out as follows to design and develop an application software that will record and reports of students will be easily retrieved with increased data security, and reduce in the amount of resources, which in turn will lower the cost of processing of student’s transcripts, since information will be stored in a database with reduced data Redundancy. The motivation that led to the implementation of the proposed system is as a result of the …
Can the material for “Trade Unionism and Its Influence on Management Policies Implementation” be used as a guide for Business Administration and Management (BAM) Project?
Yes it can be used — This research is carried out in order to determine how trade unionism influence the management policies of selected firms in onitsha. The outstanding objective pf this study were to determine what actually may lead to employers grievance in work situation, to dictate and identify the possible management policies that are commonly influenced by the trade union activities and also determine the effects of trade unionism on the implementation of the policies. Reviews of some related literature that are common with trade unionism and discussed in the chapter two of this work. The research methodology used and adopted was clearly descriptive, having questionnaire as tools. A total number of 400 workers of the organization were used for the study. Data collection …
Can the material for “Causes and Effect of Erosion” be used as a guide for Agricultural Engineering (AE) Project?
Yes it can be used — This research work was designed to examine the causes and effect of soil erosion in Ovia North East Local Government Area of Edo State. Five (5) research questions were formulated and questionnaires were administered to one hundred (100) respondents in order to gather data for the research. Results showed that agricultural activities lead to soil erosion, improper soil management cause erosion, deforestation lead to erosion etc. Recommendations were made and it include that; Sustainable soil management systems must be developed to reduce further degradation and restore the productivity of the eroded land. The management options to reduce the soil loss are to implement conservation measures and/or to change the crop to be planted. Soil conservation methods including terraces and bunds as well as …
Can the material for “Private Enterprises and Rural Development” be used as a guide for Public Administration (PA) Project?
Yes it can be used — This work centered on private enterprises and rural development in Anambra state. The objectives include: to ascertain the extent to which private enterprises have contributed to rural development in Anambra state; to find out the challenges facing private enterprises in rural development in Anambra state; to examine the measures to enhance participation of private enterprises in rural development in Anambra state.It is a survey type of research since it investigated what happened in the researcher’s absence. It is also explanatory in nature; having tried to explain the role played by private enterprises in Anambra state. In sampling, stratified random sampling technique was applied where the researcher created strata to represent different interests within the population. Also, purposive sampling was applied …
Can the material for “The Effect of Socio- Economic Background of Students on Their Performance in Secondary School Certificate Examination” be used as a guide for Sociology Project?
Yes it can be used — Parent’s status has a problem which has faced the academic performance of the students as a matter of facts this study focused on the effect of socio-economic background of student on their performance in secondary school certificate examination economics. Hence the effects of socio-economic background on student performance were strictly analyzed by and large the result of the study indicated that socio-economic background has effect or academic performance of the learner. …
Can the material for “Strategic Management Practice of Cooperative Societies as a Form of Business Organization” be used as a guide for Business Management Project?
Yes it can be used — This research work intends to explore an appraisal of purchasing function in the public sector in Imo State (Ministry of Agriculture and Natural Resources). I deemed it necessary since this research topic is unique to public sector in Imo state. An environmental practice research was carried out in ministry of agriculture and Natural Resources which was used to generalize the project objective. This research work cannot be said, to be exhaustive due to changing nature of public sector and is not designed to replace other view or subsequent research on these study objectives but has gone a long way in highlighting the ways to the much advocated efficient purchasing practices and techniques which has eluded our society. …
Can the material for “The Assessment of Flooding Problems” be used as a guide for Environmental Science Project?
Yes it can be used — This study focused on the assessment of flooding problems in makoko area of Lagos state. The aim and objective was to identify and asses the drainage channel in the study area, the effects of flooding in the study area, to examine the causes of flooding in the study area and to examine past efforts of curbing flooding problems in the study area. Both primary and secondary sources of data were employed with focus on the residents of the study area in order to capture their views on the effects of flooding on their environment.The research looks Makoko through the view point of the inhabitants, with the aim of finding out what the inhabitants want, need and would want to have, in …
Can the material for “Design and Implementation of a Sales Forecasting System Using Linear Regression Model” be used as a guide for Computer Science (CS) Project?
Yes it can be used — The paper aims at designing and implementing a simple and concise system that collects opinions of university students concerning a subject matter via simple voting. The quest to voice out one’s opinion or thoughts on an issue in an effective, anonymous and faster method remains a challenge for most tertiary institutions in Nigeria. This online opinion poll system aims at bridging the gap between the students and management of schools in a simpler and interactive manner. The administrator of the online poll has the user privilege of presenting issues concerning the students in form of questions. The students log on to the portal and vote for the most preferred choice or option. The system is designed with PHP, bootstrap, CSS …
Is the topic “A Sociological Analysis of Coping Strategies of Samaru Residents on Poor Water Supply” recommended for Sociology Project?
Yes it is highly recommended — The research is an in-depth analysis on a sociological analysis of coping strategies of Samaru residents on poor water supply. The study examined the effect, consequences and ways of tackling the issue of poor water supply in the community as a whole with particular reference to examining the existing causes and effects of diseases in the society. The instrument for data collection used for this research was questionnaire. The sampling techniques used for this study was cross- sectional survey research design. One hundred and seventeen (117) respondents were randomly selected. The data collected were analysed using tables and percentages. From the analysis of the data, it was found that due to the poor water supply to the community, the residents were …