DESIGN AND IMPLEMENTATION OF AN AUTOMATED COMPUTER BASED HOUSEHOLD INVENTORY SYSTEM


DESIGN AND IMPLEMENTATION OF A COMPUTERISED HOUSEHOLD INVENTORY SYSTEM

                                                                                  ABSTRACT:            

This project was centered on computer based household inventory system. The current process of keeping records of properties, equipments and other items owned by the hotel is being operated manually and due to this procedure numerous problem are been encountered. A design was taken to computerize the manual process in order to check this problem. The problems were identified after series of interviews and examination of documents after which analysis was made and a computerized procedure recommended. This project will also suggest how to successfully implement the computerized procedure and to overcome the obstacle that would hinder the successful implementation of the system. The new system was designed using PHP and MySQL programming language. This language was chosen because of its easy syntax and features for developing windows based applications.

TABLE OF CONTENTS

Title Page    -    -    -    -    -    -    -    -    -    i

Approval Page    -    -    -    -    -    -    -    -    ii

Declaration    -    -    -    -    -    -    -    -    iii

Dedication    -    -    -    -    -    -    -    -    -    iv

Acknowledgement    -    -    -    -    -    -    -    v

Abstract    -    -    -    -    -    -    -    -    -    vi

Table of Contents    -    -    -    -    -    -    -    vii

CHAPTER ONE – INTRODUCTION

1.1    Background of the Study    -    -    -    -    -    1

1.2    Statement of  the Problem        -    -    -    -    5

1.3    Objectives of the Study-    -    -    -    -    -    6

1.4    Research Questions    -    -    -    -    -    -    6

1.5    Significance of the Study    -    -    -    -    -    7

1.6    Scope of the Study    -    -    -    -    -    -    8

1.7    Definition of Terms    -    -    -    -    -    -    8

CHAPTER TWO – REVIEW OF RELATED LITERATURE

2.1    Introduction    -    -    -    -    -    -    -    10

2.2    Concept of Inventory System-    -    -    -    -    11

2.3    Types of Inventory System    -    -    -    -    -    14

2.4    Advantages of Inventory System-        -    -    -    16

2.5    Automated Inventory Control System Software    -    16

2.6    Importance of Inventory Sysytem-    -    -    -    17

CHAPTER THREE – RESEARCH METHODOLOGY

3.1    Introduction    -    -    -    -    -    -    -    32

3.2    System Requirement Specification-    -    -    -    32

3.3    System Design        -    -    -    -    -    -    32

3.4    Logical Design    -    -    -    -    -    -    -    33

CHAPTER FOUR – DATA PRESENTATION AND ANALYSIS

4.0    Introduction    -    -    -    -    -    -    -    36

4.1    Features of Implementation Language    -    -    -    36

4.2    System Testing Strategies    -    -    -    -    -    36

4.3    Target Computer System Requirement    -    -    39

4.4    Software Maintenance Issues    -    -    -    -    46

CHAPTER FIVE – SUMMARY, CONCLUSION AND RECOMMENDATION

5.1    Summary    -    -    -    -    -    -    -    -    54

5.2    Conclusion    -    -    -    -    -    -    -    -    57

5.3    Recommendations    -    -    -    -    -    -    58

    References -    -    -    -    -    -    -    -    61

Appendix    -    -    -    -    -    -    -    -    62

CHAPTER ONE

INTRODUCTION

1.1    BACKGROUND OF STUDY

A household inventory is a documentation of every item in your home so that you have this in the event of disaster, such as burglary or fire outbreak. It usually consists of a list of the items and/or a videotaped walkthrough of your home which captures images of the items. Household inventory can be very useful when dealing with insurance companies, as it provides documentation of the items that you own, thus helping your case for an insurance settlement.

Computerized household inventory system today encompasses either directly or indirectly, a field of activity both private and public that revolves around the ownership possession and use of the inventory system.The term “inventory varies from establishment to establishment and household to household and hence can be defined in three different ways;

⦁    Inventory for the household daily transaction.

⦁    In the ordinary course of business and expenditures.

⦁    Are used in the process of consumption record keeping.

In other words, it does not necessarily refer to tangible merchandize on a shelf. The system then help to checks if the desired household items are in stock,if the items are available for adequate use and consumption and the number of itemsof inventory balance. The daily transaction consumptions are recorded by the transaction processing system which must account for the fact that a business transaction has just taken place.

Besides monitoring control system automatically, almost all inventory control system generates an assortment of report for management. The report may perhaps include;

(a)    Ordering of goods in economic quantity and prevention of         large build up to non-essential goods.      

(b)    Reduction of losses due to inadequate inspection, damage of         material, deterioration, obsolescence and pilferages.

(c)   Provision of accurate bases for cost accounting for the          management and control of inventory (Rubin, 2007).

More so, extra care should be taken to avoid pilferage, errors and manipulations. The possibility of any of these happening lies on the fact that unlike other asset whose values are visible from book of account. The values of all classes of household inventory are derivable by physical check on balance sheet data. They are stated at lower of cost or net reliable values. Many household maintained a high level of stock which is the prerequisite for the discharge of their function at the balancing level. It is essential for the survival of a household, yet efficient control of that supply and its accompanying cost is equally crucial to success. Efficient management of inventory can mean the difference between profit and loss, success and failure. As the country is presently facing galloping inflation there is absolute need for the control of inventory in each household to ensure optimal result.

1.2    STATEMENT OF THE PROBLEM

The importance of household inventory system cannot be readily appreciated unless its value is clearly stated by a figure. Although the value of any household inventory differs from place to place and time to time but the basic of each valuation is relatively the same at the same instance and time.

The problem of manual household inventory ranges from inaccuracy to under stocking or overstocking which has actually affected the growth of some household as they cannot dictate item that have fallen beyond the minimum re-order level.Because of over dependent in paper work, many household suffer unnecessary financial and items loss and misappropriation of their items (Zenz, 2004).

1.3    OBJECTIVES OF THE STUDY

The research study is aimed at eliminating the manual system of household inventory system; specifically,the study sought to;

1.    Design and implement computerbased household inventory system.

2.    Enhanceeffective management information system in most computer based enterprises through computer based household inventory system.

3.    Examine the need for household inventory system.

4.    Examine the challenges faced by the families in the management of manual inventory.

5.    Determine the means of improving the standard of living in the household through automated inventory system

1.4    RESEARCH QUESTIONS

1.    How can manual system of household inventory be eliminated?

2.    Can computer based household inventory system enhance the effectiveness of management information?

3.    What is the need for household inventory system?

4.    What are the challenges faced by the families in the management of manual inventory?

5.    How can the standard of living of the family be improved through the introduction of the automated household inventory system?

1.5    SIGNIFICANCE OF THE STUDY

Obviously, the designing of this computer based inventory system is expected to enhance efficiency in households, companies and industries. It will help to guide against pilferage. This means that some stock keepers who may have the intention of defrauding the store may be discourage since every items is regulated by the computer screen. The automated of stock control will help to restore clients goodwill about the store. Every information is stored in the computer memory so that a press of the button provides all the necessary information. This study will no doubt evaluate all problems of overstocking and understocking which are very rampant with manual inventory control. The computer system will determine “when” and “how much” to order a minimum quality (ordering quantity) and a maximum quantity (ordering point) should be established for each item in the house.  Furthermore, this study will help to alleviate the problem of inaccuracy of financial accountancy, this problem of result due to the unreliability of human brain couple with clerical errors. Human intelligent can never be compared to computer’s brain in terms of accuracy and speed. Moreso, this research work will solve the problem of overcrowded working environment associated with some households. It was discovered that the majority of problems encountered by households are caused by the inability of having an inventory control system. Therefore, the use of stock control automated certainly solves these problems.

1.6    SCOPE OF THE STUDY

This studyis ondesign and implementation of computerized household inventory system using selected hotels in Lagos as a case study.

1.7    LIMITATIONS OF THE STUDY

1.    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, questionnaire and interview).

2.    Time constraint- The researcher will simultaneously engage in this study with other academic work. This consequently will cut down on the time devoted for the research work.

1.8    DEFINITION OF TERMS

Automated: These are program that control the operation of the computer system.

Computer:    An electronic device which is capable of accepting data through its input unit and given its result through its output unit.

Manual: The use of human effort in carrying out a specific process.

Loading: his is the process of putting people or luggage’s in a given system.

Software: These are program the control the operation of the computer system.

.


TYPE IN YOUR TOPIC AND CLICK SEARCH.






RESEARCHWAP.COM

Researchwap.com is an online repository for free project topics and research materials, articles and custom writing of research works. We’re an online resource centre that provides a vast database for students to access numerous research project topics and materials. Researchwap.com guides and assist Postgraduate, Undergraduate and Final Year Students with well researched and quality project topics, topic ideas, research guides and project materials. We’re reliable and trustworthy, and we really understand what is called “time factor”, that is why we’ve simplified the process so that students can get their research projects ready on time. Our platform provides more educational services, such as hiring a writer, research analysis, and software for computer science research and we also seriously adhere to a timely delivery.

TESTIMONIES FROM OUR CLIENTS


Please feel free to carefully review some written and captured responses from our satisfied clients.

  • "Exceptionally outstanding. Highly recommend for all who wish to have effective and excellent project defence. Easily Accessable, Affordable, Effective and effective."

    Debby Henry George, Massachusetts Institute of Technology (MIT), Cambridge, USA.
  • "I saw this website on facebook page and I did not even bother since I was in a hurry to complete my project. But I am totally amazed that when I visited the website and saw the topic I was looking for and I decided to give a try and now I have received it within an hour after ordering the material. Am grateful guys!"

    Hilary Yusuf, United States International University Africa, Nairobi, Kenya.
  • "Researchwap.com is a website I recommend to all student and researchers within and outside the country. The web owners are doing great job and I appreciate them for that. Once again, thank you very much "researchwap.com" and God bless you and your business! ."

    Debby Henry George, Massachusetts Institute of Technology (MIT), Cambridge, USA.
  • "I love what you guys are doing, your material guided me well through my research. Thank you for helping me achieve academic success."

    Sampson, University of Nigeria, Nsukka.
  • "researchwap.com is God-sent! I got good grades in my seminar and project with the help of your service, thank you soooooo much."

    Cynthia, Akwa Ibom State University .
  • "Great User Experience, Nice flows and Superb functionalities.The app is indeed a great tech innovation for greasing the wheels of final year, research and other pedagogical related project works. A trial would definitely convince you."

    Lamilare Valentine, Kwame Nkrumah University, Kumasi, Ghana.
  • "Sorry, it was in my spam folder all along, I should have looked it up properly first. Please keep up the good work, your team is quite commited. Am grateful...I will certainly refer my friends too."

    Elizabeth, Obafemi Awolowo University
  • "Am happy the defense went well, thanks to your articles. I may not be able to express how grateful I am for all your assistance, but on my honour, I owe you guys a good number of referrals. Thank you once again."

    Ali Olanrewaju, Lagos State University.
  • "My Dear Researchwap, initially I never believed one can actually do honest business transactions with Nigerians online until i stumbled into your website. You have broken a new legacy of record as far as am concerned. Keep up the good work!"

    Willie Ekereobong, University of Port Harcourt.
  • "WOW, SO IT'S TRUE??!! I can't believe I got this quality work for just 3k...I thought it was scam ooo. I wouldn't mind if it goes for over 5k, its worth it. Thank you!"

    Theressa, Igbinedion University.
  • "I did not see my project topic on your website so I decided to call your customer care number, the attention I got was epic! I got help from the beginning to the end of my project in just 3 days, they even taught me how to defend my project and I got a 'B' at the end. Thank you so much researchwap.com, infact, I owe my graduating well today to you guys...."

    Joseph, Abia state Polytechnic.
  • "My friend told me about ResearchWap website, I doubted her until I saw her receive her full project in less than 15 miniutes, I tried mine too and got it same, right now, am telling everyone in my school about researchwap.com, no one has to suffer any more writing their project. Thank you for making life easy for me and my fellow students... Keep up the good work"

    Christiana, Landmark University .
  • "I wish I knew you guys when I wrote my first degree project, it took so much time and effort then. Now, with just a click of a button, I got my complete project in less than 15 minutes. You guys are too amazing!."

    Musa, Federal University of Technology Minna
  • "I was scared at first when I saw your website but I decided to risk my last 3k and surprisingly I got my complete project in my email box instantly. This is so nice!!!."

    Ali Obafemi, Ibrahim Badamasi Babangida University, Niger State.
  • To contribute to our success story, send us a feedback or please kindly call 2348037664978.
    Then your comment and contact will be published here also with your consent.

    Thank you for choosing researchwap.com.