Design and Implementation of Fixed Assets Management System A Case Study of IMT Enugu

Design and Implementation of Fixed Assets Management System

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

DEDICATION

This research work titled "Design and Implementation of Fixed Assets Management System (A Case Study of IMT Enugu)" is dedicated to God for his enabling grace and to all computer enthusiasts who help to make life a pleasant experience.

ACKNOWLEDGEMENT

I owe my indebtedness 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/related research material for your moral support that facilitated the successful completion of my (Tertiary Institution level). I am grateful to God Almighty and my parent for their financial support in my career. I really appreciate you all for everything, Thank you very much.


Design and Implementation of Fixed Assets Management System (A Case Study of IMT Enugu)

TABLE OF CONTENTS

PRELIMINARY PAGES


CHAPTER ONE

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

CHAPTER TWO

LITERATURE REVIEW

  • 2.1 Introduction
  • 2.2 Conceptual Review of Fixed Assets Management
  • 2.3 Theoretical Framework of Asset Management
  • 2.3.1 Classification of Fixed Assets
  • 2.3.2 Barcode Technology and Fixed Assets
  • 2.3.3 Advantages of Fixed Assets Management
  • 2.3.4 Challenges of Fixed Assets Management
  • 2.3.5 Fixed Assets Management Web Portal
  • 2.3.5.1 Types of Fixed Assets Management Web Portals
  • 2.4 Review of Related Literature

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

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”

ABSTRACT

Fixed assets management is an accounting process that seeks to track fixed assets for the purposes of financial accounting, preventive maintenance, and theft deterrence. The aim of the study is to design and implement a Fixed Assets Management System. In achieving this aim, the following specific objectives were laid out as follows to develop an application software that will facilitate an online recording and modifying of assets using electronic keyboard and enhance automatic depreciation of an asset, proper storage and speedy retrieval any asset value. The motivation that led to the implementation of the proposed system is as a result of improper accounting for school assets, illegal use of the institutional assets, inefficient recording keeping of institutional assets. Also, there is limited number of staff working in the account department which makes the existing asset account to be delegated to some staff by their departmental heads at the end of each period. 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. This study will be of immense benefit to Enterprises, Shopping Malls/Supermarkets, many large companies and other researchers who intend to know more on this study and can also be used by non-researchers to build more on their research work. The expected result is an online Fixed Assets Management System that will accurately record assets and assist staff in planning and decision-making and provide management with various reports on depreciation expenses and accumulated depreciation at the end of every period.


Design and Implementation of Fixed Assets Management System (A Case Study of IMT Enugu)

CHAPTER ONE

1.1 Introduction

Fixed assets management is an accounting process that seeks to track fixed assets for the purposes of financial accounting, preventive maintenance, and theft deterrence. Many organizations face a significant challenge to track the location, quantity, condition, maintenance and depreciation status of their fixed assets. A popular approach to tracking fixed assets utilizes serial numbered Asset Tags, often with bar codes for easy and accurate reading. Periodically, the owner of the assets can take inventory with a mobile barcode reader and then produce a report. Off-the-shelf software packages for fixed asset management are marketed to businesses small and large. Some Enterprise Resource Planning systems are available with fixed assets modules. Some tracking methods automate the process, such as by using fixed scanners to read bar codes on railway freight cars or by attaching a radio-frequency identification (RFID) tag to an asset.

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

With advancements in technology, asset tracking software is now available that will help any size business track valuable assets such as equipment and supplies. According to a study issued in December, 2005 by the ARC Advisory Group, the worldwide market for Enterprise Asset Management (EAM) was then at an estimated $2.2 billion and was expected to grow at about 5.0 percent per year reaching $2.8 billion in 2010.

Tracking assets is an important concern of every company, regardless of size. Fixed assets are defined as any ‘permanent’ object that a business uses internally including but not limited to computers, tools, software, or office equipment. While employees may utilize a specific tool or tools, the asset ultimately belongs to the company and must be returned. And therefore without an accurate method of keeping track of these assets it would be very easy for a company to lose control of them.

Fixed asset management information system is a sub-operation in financial accounting that take care of the degeneration of asset usefulness because of this responsibility. Asset management and depreciation is very important in any organization. Asset management and deprecation is a content of every balance sheet and then proper attention should be given on how asset are depreciated to provide complete and accurate information that will assist management in planning and policy making. This is why it is important to design a fixed asset management information system.

Asset tracking software allows companies to track what assets it owns, where each is located, who has it, when it was checked out, when it is due for return, when it is scheduled for maintenance, and the cost and depreciation of each asset. The reporting option that is built into most asset tracking solutions provides pre-built reports, including assets by category and department, check-in/check-out, net book value of assets, assets past due, audit history, and transactions.

All of this information is captured in one program and can be used on PCs as well as mobile devices. As a result, companies reduce expenses through loss prevention and improved equipment maintenance. They reduce new and unnecessary equipment purchases, and they can more accurately calculate taxes based on depreciation schedules. The most commonly tracked assets are: Office Equipment, Evidence, Medical Equipment, IT Equipment, for example laptops, Vehicles, Files, Maintenance supplies, Educational materials, Software licenses, Videos and Tools.


1.3 Statement of Problem

Investigation revealed that there is limited number of staff working in the account department which makes the existing asset account to be delegated to some staff by their departmental heads at the end of each period. The handling of Asset Account by numerous staff creates positing error omission error and inaccurate calculated results.

Apart from that, there is no adequate record storage and disposal system which resulting in non-documentation of some existing asset are as well as continuous recording of scrapes. However, the method of asset depreciation being used in the existing system is ineffective.

In fact, the researcher shall by the end of this project provide a suitable solution to the pressing problems of fixed asset value and depreciation.


1.4 Aim and Objectives of the Study

The aim of the study is to design and implement a Fixed Assets Management System using IMT Enugu as a case study. In achieving this aim, the following specific objectives were laid out as follows to develop an application software that will:

  1. Facilitate an online recording and modifying of assets using electronic keyboard.
  2. Enhance automatic depreciation of an asset, proper storage and speedy retrieval any asset value.
  3. Accurately record assets and assist staff in planning and decision-making.
  4. Provide management with various reports on depreciation expenses and accumulated depreciation at the end of every period.

1.5 Significance of Study

This study will be of immense benefit to Enterprises, Shopping Malls/Supermarkets, many large companies and other researchers who intend to know more on this study and can also be used by non-researchers to build more on their research work. This study contributes to knowledge and could serve as a guide for other study.


1.6 Scope of Study

The scope of the research is focused on the Design and Implementation of Fixed Assets Management System using IMT Enugu as a case study.


1.7 Limitations of the Study

During the course of this study, many things militated against its completion, some of which are:

  1. 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.
  2. Establishment Policies: Establishment policies posed a serious limitation as most staffs are not ready to release information needed for this project work. There were lots of information needed from the staffs of this institution to enhance the study which took them time to release or they did not release at all for security purposes, hence the scope was reduced.
  3. Research material: availability of research material is a major setback to the scope of the study.
  4. Frequent power failure: This made the researcher append more money on fuel to ensure sustainable power.
  5. 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

Asset Management: It is defined as something that is systematic and coordinates activities through practice so that an organization can optimally regulate its physical assets and show their performance in accordance with the organization's strategic planning (NSW Department of Local Government, 2006).

Registration: This means to keep records received from the management for reference purposes.

Management: It is the co-ordination of all the resources of an Organization through the process of planning, Organization, directing and controlling

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 Fixed Assets Management System