Design and Implementation of an Electronic Store Price Management System

Design and Implementation of an Electronic Store Price Management System

Project / Seminar Material
Reference ID: PS-5733-TM

DEDICATION

This research material titled “Design and Implementation of an Electronic Store Price Management System” is dedicated to God for his enabling grace, and to all computer enthusiasts who contributed to make life a pleasant experience during my research documentation.

ACKNOWLEDGEMENT

I extend my sincere gratitude to all those who contributed to the completion of this project. Special thanks to my Supervisor (Name of your Supervisor), the Head of Department (Name of your HOD), the Lecturers in the department of Computer Science (CS), Book Authors and Profound Scholars of existing or related project material on “Design and Implementation of an Electronic Store Price Management System” for their invaluable guidance, support, and expertise throughout the journey.

I am also grateful to your study area (mention any funding organizations, if applicable) for their financial assistance. This research would not have been possible without the encouragement and assistance of some stakeholders (mention any mentors, teachers, or colleagues). Additionally, I would like to acknowledge the understanding and patience of my family and friends during this endeavor. Your unwavering support has been a constant source of motivation. Thank you all for being part of this meaningful endeavor.

TABLE OF CONTENTS

PRELIMINARY PAGES


CHAPTER ONE

INTRODUCTION


    CHAPTER TWO

    LITERATURE REVIEW

    • 2.1 Introduction

    CHAPTER THREE

    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 Feasibility Study
    • 3.3.1 Economic Feasibility
    • 3.3.2 Technical Feasibility
    • 3.3.3 Operational Feasibility
    • 3.4 Analysis of the Proposed System
    • 3.4.1 Data Flow Diagram of the Proposed System
    • 3.4.2 Advantages of the Proposed System
    • 3.4.3 Justification of the Proposed System
    • 3.5 Functional Requirements
    • 3.5.1 Use Case Diagram Of The Admin / User Privileges
    • 3.6 Data Requirements
    • 3.7 High Level Model of the Proposed System

    CHAPTER FOUR

    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.7.1 System Testing
    • 4.8 Programming Module Specification
    • 4.8.1 Installation
    • 4.9 Computer Hardware Minimum Requirement
    • 4.10 Software Requirement
    • 4.11 Personnel / User Training
    • 4.12 File Maintenance Module

    CHAPTER FIVE

    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”


    Design and Implementation of an Electronic Store Price Management System

    CHAPTER ONE

    1.0 Introduction

    This chapter presents the introduction of price management system. It contains theoretical background, aim and objectives of the study, statement of the problem, purpose of the study, aim and objectives of the study, research questions, scope and significance of the study, organization of the research and definition of terms.

    1.1 Theoretical Background

    According to Marn and Rosiello (2014), the fastest and most effective way for a company to realize its maximum profit is to get its pricing right. The right price can boost profit faster than increasing volume will; the wrong price can shrink it just as quickly. Yet many otherwise tough-minded managers shy away from initiatives to improve price for fear that they will alienate or lose customers. The result of not managing price performance, however, is far more damaging. Getting the price right is one of the most fundamental and important management functions; it should be one of a manager’s first responsibilities, a nuts and bolts kind of job that determines the dollar and cents performance of the company.

    Pricing issues are seldom simple and isolated; usually they are diverse, intricate, and linked to many aspects of a business. But while most managers have a handle on the bulk of pricing issues, many overlook a key aspect of this most basic management discipline: transaction price management. Without realizing it, many managers are leaving significant amounts of money-potential profit-on the table at the transaction level, the point where the product meets the consumer. Most companies use invoice price as a reporting measure, hut the differences between invoice and actual transaction price can mean significant reductions to bottom line profit. Some companies that have identified this problem are handling it by applying two basic concepts: the pocket price waterfall and the pocket price band. Reduced to their essentials, these concepts show companies where their products’ prices erode between invoice price and actual transaction price, and they help companies capture untapped opportunities at that level. Nagel, Hogan, and Zale, (2006).

    The theory of supply and demand takes into consideration the influence on prices of such factors as an increase or decrease in the cost of production, but regards that influence as an indirect one, because it affects prices only by causing a change in supply, demand, or both. Other factors indirectly affecting prices include changes in consumption habits (for example, a shift from natural silk to artificial silk fabrics) and the restrictive practices of monopolies, trusts, and cartels. In the view of many economists, the multiplicity of such indirect factors is so great that the terms supply and demand are inclusive categories of economic forces affecting prices, rather than precise, primary causal factors. The price-determining mechanism of supply and demand is operative only in economic systems in which competition is largely unfettered. Increasing recourse, in recent times, to governmental regulation of the economy has tended to restrict the scope of the operation of the supply-and-demand mechanism.

    The introduction of computerized technology into the retail environment over the past two decades has resulted in new opportunities for retailer managers. For example, demand based management uses statistical models to predict consumer price response using historical information. The most prevalent type of information in retail markets is transaction data collected using optical bar code scanners which track every item purchased by a consumer at the point-of-sale. This data could potentially contain a wealth of information about how consumers respond to price and promotions. A price determinant management system is a computerized system that aids in adjusting the price of products based on different variables such as cost price, transportation, taxes and commissions on products and competitors prices. This is done such that an optimal price is ascertained that still brings about a certain percentage of profit.


    1.2 Statement of Problem

    Many companies do not have an effective method of managing price of their products such that they maximize profit. When customers lack perfect information about prices they may also have imperfect knowledge of quality. Price tag management is intended to create the perception of a low price and increase demand. Many variables are usually involved from the purchasing of the product to marketing it and many business persons that are not conversant with how to set a price tag may end up running at a loss. In addition, the situation of increased price of the product may also reduce demand. There is therefore need for an effective software system that can aid in the determination of optimal price such that there is no loss or excess profit and also to provide room for updating price tag of items when needed.


    1.3 Aim and Objectives of the Study

    The aim of the study is to develop a price management system for electronics store, that will aid the easy determination and updating of price tags of products in the store.

    The following are the specific objectives:

    1. To develop a price management system that can aid in the determination of prices of products.
    2. To develop a system that will allow the easy updating of prices
    3. To develop a system that will replace the manual way of determining prices
    4. To implement a system that can hold a database of prices such that the price of any product can be retrieved easily.

    1.4 Research Questions

    The following research questions were formulated to guide the researcher:

    1. What is a price management system?
    2. How is price management carried out?
    3. What are the features/modules of a price management system?

    1.5 Significance of the Study

    The significance of the study is that it will provide a possible solution to the problem of determining the price of products, it will serve as a decision support system and also as an information system to managers of Assure Electronics. The study will also serve as a useful reference material to other researchers seeking related information.


    1.6 Scope of the Study

    This study covers price management system for electronics store using Assure electronics Uyo as a case study.


    1.7 Organization of the Research

    This research work is organized into five chapters.

    Chapter one is concerned with the introduction of the research study and it presents the preliminaries, theortical 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.

    Chapter two focuses on the literature review, the contributions of other scholars on the subject matter is discussed.

    Chapter three is concerned with the system analysis and design. 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.

    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.

    Chapter five focuses on the summary, conclusion and recommendations are provided in this chapter based on the study carried out.


    1.8 Definition of Terms


    Price:

    The amount, usually of money, that is offered or asked for when something is bought or sold


    Price Tag:

    Label saying what something costs also a small label attached to an item that is for sale, with the price written or printed on it.


    Management:

    The organizing and controlling of the affairs of a business or a sector of a business

    CHAPTER TWO

    2.0 Literature Review

    2.1 Introduction

    This chapter focuses on the review of related literature. A literature review includes the current knowledge as well as theoretical and methodological contributions to a particular topic. It documents the state of the art with respect to the topic you are writing. It surveys the literature in the topic selected. In this research work the literature review includes the …

    Summary Headlines for Design and Implementation of an Electronic Store Price Management System