DESIGN AND IMPLEMENTATION OF PRODUCT PRICE FORECASTING SYSTEM
ABSTRACT
Product Price Forecasting is the ability to forecast future product price base on past months sales. Product Price Forecasting system uses several proven models such as qualitative versus quantitative model and linear regression mode, these model are proven models use over the years by different financial institutes. The aim of the study is to design and implement a Product Price Forecasting System. In achieving this aim, the following specific objectives were laid out as follows to design and develop an application software that will manage and forecast product price, automate customer, product, and supplier management on the system and Manage every users of the system. The motivation that led to the implementation of the proposed system is that the conventional method poses lots of constraint on Product Price Forecasting as it takes lots of time forecasting product price using which ever model is adopted by the sales manager or accountant or financial adviser. The methodology adopted in this study is the structured system analysis and design methodology (SSADM) which is a technical approach for analyzing and designing an application or system by applying object throughout the software development process. 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 proposed system will help organization to Predict achievable sales revenue, efficiently allocate resources, Plan for future growth etc. This project will be of benefit to: Enterprises, Shopping Malls/Supermarkets and many large companies like; waste companies, and Power holding companies. The expected result is an electronic billing system that will process customer’s selected items in a shopping mall or supermarket, and the system will be able to forecast product prices base on the previous sales.
CHAPTER ONE
1.1 Introduction
Product Price Forecasting is the ability to forecast future product price base on past months sales. Product Price Forecasting system uses several proven models such as qualitative versus quantitative model, average approach model, casual /econometrics forecasting model, linear regression model etc., these model are proven models use over the years by different financial institutes. Forecasting is the process of making predictions of the future based on past and present data and analysis of trends. Computerization of the store can remove wastage, guarantee quick service at service points of vital importance to the public and improve productivity. Such computerization effort often costs for less than the money and time it will save both the public and the organization.
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 Study
Forecasting is fundamental in any planning effort (Chase, R. (2014). In the short term, forecast is needed to predict the material, products, services or other resources to respond to changes in demand. A forecast allows adjusting schedules and varying labor and materials. In the long run, it is required to predict the basis for strategic changes, such as the development of new markets, new products or services and expand or build new facilities.
Effective planning, in short and long term, depends on demand forecasts for the company products (Heizer, J. (2009). Good forecasts are crucial to all business aspects: Demand forecast is the only useful data until the actual demand is known. Therefore, demand forecasts guide decisions in many areas: human resources, capacity management and supply chain.
Sales and operations planning is a process that helps to provide better customer service, handling of lower inventories, offer shorter delivery time to customers, stabilize production rates and facilitate management business. It does not matter that, owing to changing markets, the chemicals supplying enterprises have troubles with operations scheduling and inventories management; they are a fundamental component in the national economy.
The chemicals supplying enterprises demands are highly variable in volume and presentation; their customers vary from a small hardware store, up to an auto assembler factory, passing through: pharmaceutical, chemical, petrochemical and polymer companies, paints and varnishes manufacturers, etc. In some companies, they handled up to 500 different materials and have up to 1000 clients; all of this complicates their operations planning.
Because of the above chemicals supplying enterprises problems, a system to forecast their sales with the best possible accuracy is proposed. The system, (algorithm and software) for the yearly or monthly sales prediction, calculates a possible sales number for each product using five techniques, evaluates the error of each of them and selects the lowest error technique; from which the sales forecast for each product is proposed. The goal is to make effective plans in order to properly satisfy the customer demands.
1.3 Statement of Problem
This research work was undertaken to uncover some of the problems with conventional Product Price Forecasting management systems, where accountant has to calculate using a specific sales model formula in forecasting on a regular basis. Using these conventional method poses lots of constraint on Product Price Forecasting as it takes lots of time forecasting using which ever model is adopted by the sales manager or accountant or financial adviser.
In every organization (ROBAN STORES) encounter numerous problems, which include keeping goods, maintaining, checking and having goods account records for gods in stock.
Despite the good maintenance in the manual stock control system at ROBAN STORES, there will arise great inefficiency in its accounting system, as well as its record updating system.
However, the main aim of this study is to incorporate computer into the daily operations of the store with reference to mainly it’s accounting system, as well as its stock control system and its day to day commercial operations. With introduction and application of computer into the operations of the STORE the organization will be able to improve dramatically on its daily information and accounting system.
The above problems discovered therefore prompted to a software design to be able to add to existing stock and delete goods in stock collectively referred to as updating, as well as producing an accurate accounting system for the STORE.
1.4 Aim and Objectives of the Study
The aim of the study is to design and implement a Product Price Forecasting System. In achieving this aim, the following specific objectives were laid out as follows to design and develop an application software that will:
- Manage and forecast product price
- Automate customer, product, and supplier management on the system
- Manage system access and roles on the system
- Manage every users of the system
1.5 Significance of Study
In this research work will provide a reliable way of handling product price forecasting to forecast product prices in and financial institution. Furthermore, it will aids structural document representation and eliminates the tedium of performing monotonous transaction. This research will also contribute to existing literature in this area and will serve as a guild or blueprint for an undergraduate student. Product Price Forecasting system help organization to Predict achievable sales revenue, efficiently allocate resources, Plan for future growth etc. As your business grows, sales forecasts continue to be an important measurement of a company’s health. Wall Street measures the success of a company by how well it meets its quarterly sales forecasts and the overall effect of accurate Product Price Forecasting is a business that runs more efficiently, saving money on excess inventory, increasing profit and serving its customers better.
1.6 Scope of Study
The study focuses on the Design and Implementation of Product Price Forecasting System. The system will not incorporate in its development all the models use for product price forecasting but will focus only on the aforementioned models and functionalities. The system will not be responsible for any loss of data if its environment (network/system installed on) is corrupt.
1.7 Limitations of the Study
During the course of this study, many things militated against its completion, some of which are:
- Time Constraint: The time frame given to accomplish this project was very short due to school academic calendar and it was carried out under pressure which made the researcher not to implement some necessary features.
- Research material: availability of research material is a major setback to the scope of the study.
- Frequent power failure: This made the researcher append more money on fuel to ensure sustainable power.
- Financial Constraint: Insufficient fund tends to impede the efficiency of the researcher in sourcing for the relevant materials, literature or information and in the process of data collection (internet).
1.8 Definition of Terms
Algorithm: A logical of instructions, which are carried out in a fixed order to find the solution to a problem.
Computer: A system software package that converts a problem oriented language to the language a computer understands. It’s an electronic data processing machine which can store and process information at very high speeds.
Computerization: The use of computer to control an operation or system.
Data: These are units of observation which do not curvy any meaning
DOS: An operating system that uses disk devices for permanent storage.
Information: Consists of facts resulting from processed data, providing knowledge relating to events or situation.
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 Product Price Forecasting System 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 Study
- 1.3 Statement of Problem
- 1.4 Aim and Objectives of the Study
- 1.5 Significance of Study
- 1.6 Scope of Study
- 1.7 Limitations of the Study
- 1.8 Definition of Terms
LITERATURE REVIEW
- 2.1 Introduction
- 2.2 Theoretical Review
- 2.3 Related Literature of Price Forecasting System
- 2.4 Advantages of Price Forecasting System
- 2.5 Concept of Product Registration
- 2.5.1 Online Product Registration
- 2.5.2 Usage of Online Product Registration Forms
- 2.6 Web Portal for Price Forecasting System
- 2.6.1 Types of Web Portals
- 2.7 Database for Price Forecasting System
- 2.7.1 Merits of Integrating Databases in Web Applications
- 2.7.2 Roles of a Database Administrator
- 2.7.3 Database Query system
SYSTEM ANALYSIS AND DESIGN
- 3.1 Methodology Adopted
- 3.1.1 Problem Identification Using SSADM
- 3.2 Analysis of the Existing System
- 3.2.1 Dataflow of the Existing System
- 3.2.2 Disadvantages Of The Existing System
- 3.2.3 Weakness of the existing System
- 3.3 Analysis of the Proposed System
- 3.3.1 Data Flow Diagram of the Proposed System
- 3.3.2 Advantages of the Proposed System
- 3.3.3 Justification of the Proposed System
- 3.4 Functional Requirements
- 3.4.1 Use Case Diagram Of The Admin / User Privileges
- 3.5 Data Requirements
- 3.6 High Level Model of the Proposed System
SYSTEM DESIGN AND IMPLEMENTATION
- 4.1 Objectives of the Design
- 4.2 Cohesion and Decomposition High level Model
- 4.3 Control Center / Overall Dataflow Diagram
- 4.3.1 Proposed System Operation Flowchart
- 4.4 System Specification and Design
- 4.4.1 Input and Output Specification
- 4.4.2 Database Specification and Design
- 4.4.3 Data Dictionary
- 4.5 Choice and Justification of Programming Language
- 4.6 Program Documentation
- 4.7 Implementation Techniques
- 4.8 Programming Module Specification
- 4.8.1 Installation
- 4.8.2 Security Design Specification
- 4.8.3 System Architecture
- 4.9 Computer Hardware Minimum Requirement
- 4.10 Software Requirement
- 4.11 Personnel / User Training
SUMMARY, CONCLUSION AND RECOMMENDATION
- 5.1 Introduction
- 5.2 Summary
- 5.3 Conclusion
- 5.4 Recommendation
REFERENCES
APPENDIX A - “SOURCE CODE”
APPENDIX B - “OBJECT PROGRAM”
Disclaimer for Complete Material Utilization
The displayed research work titled "Design and Implementation of Product Price Forecasting System" 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 Study
- 1.3 Statement of Problem
- 1.4 Aim and Objectives of the Study
- 1.5 Significance of Study
- 1.6 Scope of Study
- 1.7 Limitations of the Study
- 1.8 Definition of Terms
LITERATURE REVIEW
- 2.1 Introduction
- 2.2 Theoretical Review
- 2.3 Related Literature of Price Forecasting System
- 2.4 Advantages of Price Forecasting System
- 2.5 Concept of Product Registration
- 2.5.1 Online Product Registration
- 2.5.2 Usage of Online Product Registration Forms
- 2.6 Web Portal for Price Forecasting System
- 2.6.1 Types of Web Portals
- 2.7 Database for Price Forecasting System
- 2.7.1 Merits of Integrating Databases in Web Applications
- 2.7.2 Roles of a Database Administrator
- 2.7.3 Database Query system
SYSTEM ANALYSIS AND DESIGN
- 3.1 Methodology Adopted
- 3.1.1 Problem Identification Using SSADM
- 3.2 Analysis of the Existing System
- 3.2.1 Dataflow of the Existing System
- 3.2.2 Disadvantages Of The Existing System
- 3.2.3 Weakness of the existing System
- 3.3 Analysis of the Proposed System
- 3.3.1 Data Flow Diagram of the Proposed System
- 3.3.2 Advantages of the Proposed System
- 3.3.3 Justification of the Proposed System
- 3.4 Functional Requirements
- 3.4.1 Use Case Diagram Of The Admin / User Privileges
- 3.5 Data Requirements
- 3.6 High Level Model of the Proposed System
SYSTEM DESIGN AND IMPLEMENTATION
- 4.1 Objectives of the Design
- 4.2 Cohesion and Decomposition High level Model
- 4.3 Control Center / Overall Dataflow Diagram
- 4.3.1 Proposed System Operation Flowchart
- 4.4 System Specification and Design
- 4.4.1 Input and Output Specification
- 4.4.2 Database Specification and Design
- 4.4.3 Data Dictionary
- 4.5 Choice and Justification of Programming Language
- 4.6 Program Documentation
- 4.7 Implementation Techniques
- 4.8 Programming Module Specification
- 4.8.1 Installation
- 4.8.2 Security Design Specification
- 4.8.3 System Architecture
- 4.9 Computer Hardware Minimum Requirement
- 4.10 Software Requirement
- 4.11 Personnel / User Training
SUMMARY, CONCLUSION AND RECOMMENDATION
- 5.1 Introduction
- 5.2 Summary
- 5.3 Conclusion
- 5.4 Recommendation
REFERENCES
APPENDIX A - “SOURCE CODE”
APPENDIX B - “OBJECT PROGRAM”
Disclaimer for Complete Material Utilization
The displayed research work titled "Design and Implementation of Product Price Forecasting System" 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 “The Role of Financial Institutions in Agricultural Development (1990-2015)” be used as a guide for Entrepreneurship Project?
Yes it can be used — This study examined the role of financial institutions in agricultural development.( A case study of Nigeria Agricultural Cooperative and Rural Development Bank) with a view to make useful suggestions and recommendations as way of enhancing the development of agricultural sector. The population of the study includes large and small scale farmers and the sampling method adopted for the study is the stratified random sampling in order to ensure adequate representation of the population. In order to achieve the objective of making useful suggestions that would improve the agricultural sector, a number of hypotheses were made and tested. Samples of one hundred and eighty responses were collected and analyzed using the chi-square (ײ).It was discovered that bank credit loan scheme is …
Can the material for “Role of Capital Market in Industrial Growth and Development in Nigeria” be used as a guide for Microbiology Project?
Yes it can be used — This research work examined the role of capital market in industrial growth and development in Nigeria. Secondary data were used in this research work. The hypothesis was tested to examine the significance of relationship that exists between capital market and industrial growth in Nigeria. The analytical techniques used were the simple regression analysis while Ordinary Least Square (OLS) R-2¬ and f-statistic was used for the test. From the test, it was observed that a positive relationship existed with negative relationship exist between the variables. Hence the researcher concluded that capital market is an efficient tool for industrial economic growth and development in Nigeria. …
Can this topic “Antibacterial Effect of Honey against Some Bacterial from Wound Infection” be used for Microbiology Project?
Yes it can be utilized for research — The study identifies the Antibacterial Effect of Honey against Some Bacterial from Wound Infection. In achieving this aim, the following specific objectives were laid out identify the Wound Infection mitigated by Honey and determine the antibacterial activity of honey against Gram-Negative bacteria. Honey is one of the most products has been used as an antimicrobial agent since the ancient times. The potential antimicrobial activity of honey is arise from its physiochemical proprieties such as high osmotic pressure, low pH, in addition to other factors and enzymes that work as antimicrobial agents. All these components and characteristics of honey led to consider it as one of the most efficient, useful and natural antimicrobial agents. The study included some of both gram-positive …
Can the material for “An Empirical Study of Mortgage Banks Contributions to Housing Development in Nigeria” be used as a guide for Banking and Finance (BF) Project?
Yes it can be used — This research work as believed is another contribution to mortgage banking literature which will be very usefully particularly to future researchers on this topic and those already engaged in the banking industry. The idea behind this project research work entitled Mortgage Banks contribution to Housing Development in Nigeria is inherent from the crucial and very important nature of housing to every right thinking human being. Professor Abraham Maslow in his “hierarchy of needs − a most widely accepted description of human needs of the general population classified food, shelter and clothing as the basic needs of every man. Every human being is a born land lord: therefore house ownership is a birthright that must be enjoyed by every man. The contributions …
Can the material for “Impact Assessment of Employee Motivation on Workers Performance” be used as a guide for Public Administration (PA) Project?
Yes it can be used — This study assessed the impact of employee motivation on workers performance in Nigeria Communications Commission. The objectives of the study were to examine the relationship between training and increased competence for staff of Nigeria Communications Commission, examine the relationship between financial incentives and work habits for staff of Nigeria Communications Commission and determine the effects of recognition on successful completion of task. The survey research design was used as the methodology. The sample size of the study consisted of one hundred (100) respondents representing 64% of the population of the study. Data for the study were obtained with the aid of self designed questionnaires. Simple percentage was used in the analyses of data obtained. The hypotheses were tested with the aid …
Can the material for “Possible Effects of Electromagnetic Fields (EMF) on Human Health” be used as a guide for Physics Project?
Yes it can be used — The Scientific Committee on Emerging and Newly Identified Health Risks (SCENIHR) has updated the previous opinion on “Possible effects of Electromagnetic Fields (EMF), Radio Frequency Fields (RF) and Microwave Radiation on human health” by the Scientific Committee on Toxicity, Ecotoxicity and the Environment (CSTEE) from 2001, with respect to whether or not exposure to electromagnetic fields (EMF) is a cause of disease or other health effects. The opinion is primarily based on scientific articles, published in English language peer-reviewed scientific journals. Only studies that are considered relevant for the task are cited and commented upon in the opinion. The opinion is divided into frequency (f) bands, namely: radio frequency (RF) (100 kHz < f ‰¤ 300 GHz), intermediate frequency (IF) (300 …
Can this topic “Motivation as a Tool for Productivity Improvement” be used for Business Administration and Management (BAM) Project?
Yes it can be utilized for research — The purpose of this study is to attempt an evaluation of the effect of motivation on productivity improvement. It is a case study of Nigeria’s oldest and major security documents corporation, the Nigerian Security Printing and Minting Company Plc. The manner in which an organization selects its employees and the reward system adopted to compensate them, total pay and benefits paid, opportunities for personal development on the job as well as the recognition they enjoy in terms of enhanced pay, status and prestige can go a very long way in enhancing their morale and satisfaction on the job. Performing employees can fast track the growth and development of their organization. In this study, three hypothesis were posed and tested. It …
Can the material for “Establishment and Management of a Small Scale Poultry farm” be used as a guide for Business Administration and Management (BAM) Project?
Yes it can be used — This work has its main objectives as the determination of investment potentials in poultry farming at Omuma. To the best of the researcher’s knowledge, this is the first conscious attempts to address this issue as it affects the suitability at Omuma for poultry farm. Chapter one is the introduction. It covers such preliminary information like the General Background of the study, Problems associated with the study, Problems that the study will be concerned, the importance of studying area. Definition of important terms. Chapter two is literature review. Literature is reviewed under six major headings: the origin of the study matters. The school of thought to the problem study, different method of solving the problem of the study, summary and references. Chapter three is …
Can this topic “Federalism and Nation-Building in Nigeria: Challenges and Prospects” be used for Political Science Project?
Yes it can be utilized for research — This study is on federalism and nation building: the challenges and prospect. The total population for the study is 200 staff of National assembly, Abuja. The researcher used questionnaires as the instrument for the data collection. Descriptive Survey research design was adopted for this study. A total of 133 respondents made supervisors, computer operators, senior staffs and junior staff were used for the study. The data collected were presented in tables and analyzed using simple percentages and frequencies …
Can this topic “Effect of Cashless Policy on the Nigerian Economy” be used for Economics Project?
Yes it can be utilized for research — Cashless policy is the process of designating of financial transactions handled by means of credit cards, bank transfers and cheques, with no money handed from person to person. The study was carried out to investigate the Effect of Cashless Policy on the Nigerian Economy. In achieving this aim, the following specific objectives were laid out to determine the degree of the relationship between cashless policy and Nigerian economy and ascertain empirically the impact of cashless policy on Nigeria economic growth. 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 300 (three hundred) respondents were selected for this study to represent the entire population of …