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)
Is the topic “Effect of Lime-Stabilization on Strength Characteristics of Bricks” recommended for Building Technology (BT) Project?
Yes it is highly recommended — Clay soils have been used locally in Sokoto to make bricks without stabilizing the soil. The bricks usually experience structural failure such as cracking and seasonal swelling when used for the construction of wall. Collapsing of wall also occurs in the area where non-stabilized bricks are used for wall construction. This research aims to assess the effect of lime-stabilization on strength of bricks made with Sokoto Red Clay Soils with a view to determining the physical properties of the soil and the optimum level of lime-stabilization required in the case of Sokoto Red Clay Soil (RCS). RCS used in this research were stabilized by lime and the method adopted for the stabilization is additive method. The method involves addition of …
Can this topic “Perception of Students on Drug Use and Abuse on the Academic Performance of Students in Biology” be used for Education Project?
Yes it can be utilized for research — The use of drugs dates back into the pre-history of man. Such drugs were used to relieve pain or cure and control diseases. Drugs is any substance which taken by living organisms may modify the functions of living organism. The aim of the study is to examine in detail the Perception of Students on Drug Use and Abuse on the Academic Performance of Students in Biology among Senior Secondary School Students in Somolu Local Government Area, Lagos State. In achieving this aim, the following specific objectives were laid out as follows to: identify the most commonly abused substances and the factors that contribute to the use of these substances, find out the knowledge and perception of the health risk and …
Is the topic “Teachers and Students Perception of the Teaching of Sexuality Education in Secondary Schools” recommended for Environmental Science Project?
Yes it is highly recommended — The purpose of this study was to determine whether sexuality education should be inculcated into the secondary school curriculum and at what level of study.. The descriptive survey research method was used for the study. A total of one hundred (500) participants were selected through a simple random sampling technique which comprised the sample population. The research instrument used was a self-developed and validated questionnaire. Five (5) research questions and hypotheses were raised and tested in this study. Data analysis was with descriptive statistics of frequency counts, percentages and the inferential statistics chi-Square (X) statistics was used for Hypotheses testing. Results showed that all hypotheses were rejected. Findings revealed that there is a significant relationship between content of sex education, teachers …
Is the topic “Ukwuani and the Urhobo People Up to 1900 - a Study in Inter-Group Relations” recommended for History Project?
Yes it is highly recommended — Inter-group relations between Ukwuani and Urhobo peoples up to 1900. One aspect of Ukwuani and Urhobo history that has not received much attention from historians in recent times is the effect of inter-group relations between them. The aim of the study is to evaluate the Ukwuani and the Urhobo People Up to 1900 using Inter-group Relations as a Case Study. In achieving this aim, the following specific objectives were laid out to assess the Inter-group Relations of Ukwuani and the Urhobo People Up to 1900, find out about the Pre-Historic Origins of Urhobo Cultural Units, evaluate the Urhobo's Subcultures and the Conquest of Western Niger Delta’s Rainforests, find out about the Properties and Characteristics of Cultural Units of Urhobo Land, …
Can the material for “Design and Implementation of an Online Job Portal” be used as a guide for Computer Science (CS) Project?
Yes it can be used — Online job seeking applications become the most useful tools to access the information about job applicants and job applications are accessible at the press of a button. The aim of the study is to Design and Implement an Online Job Portal. In achieving this aim, the following specific objectives were laid out as follows to design and develop an application software that will Allow job seekers to search and select the availability of jobs suitable for their needs and create a quick search and advance search that the user will use during the recruitment process. The motivation that led to the implementation of the proposed system is that applicants are increasing day by day, and are putting in their application …
Can the material for “The Impact of Organizational Structure in Effective Management of Nigerian Organization” be used as a guide for Microbiology Project?
Yes it can be used — The topic of this study is Impact of Organizational Structure in Effective Management of Nigerian Organization (A study of Nigerian Brewery Plc, Enugu State. The researcher adopted the descriptive survey design. The researcher used both the primary, and secondary sources of Data in the course of the study. The primary data was sourced through the instrument of questionnaire and oral interview while secondary data was sourced through texts books, magazines, journals and internet. The Population of the study is eight hundred and ninety while the sample size is one hundred and thirty-three. The findings revealed among others that organizational structure has a great impact in the effective management of organizations. The researcher recommended among others that organizations should endeavour to …
Can the material for “The Effect of Advertising on the Sales of Consumer Goods” be used as a guide for Marketing (MKT) Project?
Yes it can be used — The study was carried out to identify the effects of advertisement on the sales of consumers goods. Advertising in this modern age of highly competitive market has become a push bottom word with a powerful communication force and a vital marketing tool helping to sell goods, services, images and ideas through channels of information and persuasion. Hardly exists anything that advertising has not been equated with the ability to sell. In fact, there exists a plethora of adjectives describing the power of advertising - alluring, dynamic, fascinating, indispensable, materialistic, obstructive, persuasive and ubiquitous, whatever the myths and half‚ truths spairwell around advertising, the fact is beyond contention that advertising has evolved as an indispensable tool for the marketing of goods, services …
Can the material for “Leadership Style and Organizational Commitment” be used as a guide for Political Science Education Project?
Yes it can be used — Leadership style refers to the ability to persuade others to seek defined objectives enthusiastically. The study investigated the Leadership Style and Organizational Commitment using Agip Oil Company in Port Harcourt as a case study.. In achieving this aim, the following specific objectives were laid out to examine the impact of leadership style of employee's Commitment on Organizational performance and evaluate effective leadership as the determinant factor of achieving organizational goals. Poor leadership style in an organization results in effective employee performance. The research design used in this report is descriptive design, utilizing questionnaire method to obtain information from the respondents for this project. A total of 180 (one hundred and eighty) respondents were selected for this study to represent the …
Is the topic “The Implication of Privatization on Nigeria Economy” recommended for Business Administration and Management (BAM) Project?
Yes it is highly recommended — This work the implication of privatization on Nigeria economy a case study of Nigeria national petroleum corporation (NNPC) is to know how privatization will affect the economy of the country and the citizen of the country at large. Chapter one introduce the topic and should us the general background of privatization the problems associated with the subject matter the problem (s) that the study and definition of some important terms Chapter two is the literature review the origin of the subject area school of through without the subject area the school of through relevant to the problems of study different method of studying the problems and summary Chapter three is conclusion data presentation highits of the study analysis of the reference and bibliography. …
Can the material for “Influence of Aurora Television Programme on Children” be used as a guide for Education Project?
Yes it can be used — The study investigates the influence of Television Programme on Children. In achieving this aim, the specific objectives were set out to explore dressing pattern contained in television programmes, determine how exposure to television programmes influence the dressing pattern of children, and determine how to dissuade child from indecent dressing projected on television programmes. The importance of television generally in promoting the culture of the society and influencing behavior of children either positively or negatively the researcher felt an obvious need for embarking on the study. The study will help in promoting a better understanding of the Nigerian primary school children behavior to the adult. It will help parents to know a better way of impacting morals, norms and values of …