Automated Price Adjustment System

Automated Price Adjustment System

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

DEDICATION

This research material titled “Automated Price Adjustment 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 “Automated Price Adjustment 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”


    Automated Price Adjustment System

    CHAPTER ONE

    1.0 Introduction

    The phenomenon of price adjustment is central in economics for several reasons. First, at the microeconomic level, since price adjustment is considered the main market clearing mechanism, whether prices adjust or not can have important implications for the efficiency of resulting allocations. Therefore, having a better understanding of the price change process can provide insights on issues like: how rigid are prices of individual products; how fast are costs passed-through onto prices; how long it takes prices to adjust to changes in market conditions such as changes in supply and demand, etc. Second, at the managerial level of an individual business, pricing and price adjustment play a critical role as it determines the bottom line profitability. For example, questions such as: how to adjust prices of individual products in response to temporary cost increases, how to adjust prices to competitors’ price changes, how to adjust prices of sale and non-sale items, how frequently to change prices, etc., are all questions pricing managers and retail sellers face on a daily basis. Third, there are variety of markets (e.g. different types of auction markets, non-auction markets such as markets with posted prices, etc.), and understanding the specific characteristics of these institutions may help us better understand and predict the outcomes observed at these markets. Given the importance of the price adjustment mechanism, it is not surprising that the issue has received considerable theoretical as well as empirical attention.

    1.1 Theoretical Background

    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 adjustment 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.

    Most supermarket chains carry thousands of items in different categories, operate scores of stores, constantly adjust prices on a weekly basis due to changes in demand, supply, and competition, and may manage wholesale and retail operations. Price adjustment systems are meant to help managers make decisions, but they also serve to help automate decision making. Pricing specialists agree that businesses should price products based on value. Yet, many companies set prices based on the cost of their product (Ulaga, 2001; Hinterhuber, 2008). Alternatively, they set prices based on the prices of competing products, without fully accounting for the worth of performance differences between their product and the reference products.

    In a research study aimed at identifying specific obstacles that prevent companies from implementing value-based pricing strategies Hinterhuber (2008) found that the number one obstacle was the ability to conduct an accurate value assessment. One respondent commented that his business team just did not have the tools to attach a financial value to their differentiated product.


    1.2 Statement of Problem

    Many supermarket owners do not have an effective method of adjusting price tags such that they increase their revenue and attract customers. There are many competitors in the market place and this influences the level of patronage especially if they are good in managing prices. In addition, the situation of charging higher than normal may also reduce demand and consequently bring about loss. This situation brings about the need for a price adjustment software system that can enable the adjustment of price of each product such that there is no loss or excess profit and also to provide avenue for updating price of items.


    1.3 Aim and Objectives of the Study

    The aim of the study is to develop an automated price adjustment system for supermarket. The following are the specific objectives:

    1. To develop an automated price adjustment system that can aid in the adjustment of prices of products.
    2. To develop a system that will allow the easy storage, retrieval and updating of prices of each registered product.
    3. To develop a system that will replace the manual way of managing prices of products
    4. To implement a system that the database can be queried easily.

    1.4 Scope of the Study

    This study covers automated price adjustment system for supermarket, a case study of NTEPS supermarket.


    1.5 Significance of the Study

    The significance of the study is that it will provide solution to the problem of adjusting price of products in NTEPS supermarket, it will serve as a management information system for super market owners. The study will also serve as a useful reference material to other researchers seeking information on the subject.


    1.6 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, theoretical 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.7 Definition of Terms


    Adjust:

    To make slight changes in something to make it fit or function better


    Management:

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


    Price:

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

    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 Automated Price Adjustment System