DESIGN AND IMPLEMENTATION OF A COMPUTERISED STOCK MANAGEMENT SYSTEM


DESIGN AND IMPLEMENTATION OF A COMPUTERISED STOCK MANAGEMENT SYSTEM

ABSTRACT:      

A stock management system is a key part of the supply chain and primarily aims to control the movement and storage of materials within a warehouse and process the associated transactions, including shipping, receiving, put away and picking. The systems also direct and optimize warehouse put away based on real-time information about the status of bin utilization.

In times of economic slowdown, cutting costs is the major strategy used by the companies. There is a need to track the performance of each product in terms of demands to determine how much to order and when to order. The parameters that are required to answer these questions are economic order quantity and the reorder point. The annual cost of each product is obtained to determine the best deal for the invoices received for the product. This project implements a warehouse management system and tracks the performance of each product using a web application. This will help decision makers to initiate accurate re-order and make forecast and demand of the product at any point in time.

Stock management system is an essential activity that must be undertaken in an organization to ensure proper management of inventories. In other to ensure for the proper management of inventories, systems and software has to be put in place. System has to be developed to keep proper track of all in-coming and out-going inventories.

The stock management system is basically designed to capture and automate all shipping of products into the warehouse of NUGAB Resources limited and to keep records of all products sold out, with the main objective of the software being to bring efficiency into EffisonLimitedlimited.

TABLE OF CONTENT

Title Page

Certification

Dedication

Acknowledgement

Table of content

Abstract

CHAPTER 1: INTRODUCTION

1.1    INTRODUCTION-----------------------------------------------------------------------------------6

1.2    PROJECT OVERVIEW----------------------------------------------------------------------------7

1.3    PROBLEM STATEMENT-------------------------------------------------------------------------8

1.4    OBJECTIVES----------------------------------------------------------------------------------------8

1.5    SCOPE OF STUDY --------------------------------------------------------------------------------9

CHAPTER 2: LITERATURE REVIEW

2.1 REVIEW TOPIC------------------------------------------------------------------------------------10

CHAPTER 3: SOFTWARE ANALYSIS REQUIREMENT

3.1 EXISTING SYSTEM------------------------------------------------------------------------------16

3.2 PROPOSED SYSTEM-----------------------------------------------------------------------------16

3.3 SOFTWARE REQUIREMENT------------------------------------------------------------------17

3.4 HARDWARE REQUIREMENT-----------------------------------------------------------------19

CHAPTER 4: DATA DESIGN

4.1 NORMALIZATION-------------------------------------------------------------------------------20

4.2 DATAFLOW DIAGRAM------------------------------------------------------------------------22

4.3 CONTEXT ANALYSIS DIAGRAM-----------------------------------------------------------24

4.4 DECISION TREE/TABLE-----------------------------------------------------------------------24

4.5 ENTITY RELATIONSHIP DIAGRAM-------------------------------------------------------26

CHAPTER 5: TESTING AND EXPERIMENTAL RESULTS

5.1 TESTING METHOD-----------------------------------------------------------------------------29

5.2 SAMPLE DATA RESULT----------------------------------------------------------------------32

5.3 SECURITY----------------------------------------------------------------------------------------36

CHAPTER 6: CONCLUSION

6.1 INTRODUCTION--------------------------------------------------------------------------------38

6.2 SUMMARY OF WORK ------------------------------------------------------------------------39

6.3 ADVANTAGES OF THE SYSTEM-----------------------------------------------------------39

6.4 LIMITATIONS------------------------------------------------------------------------------------39

6.5 FUTURE ENHANCEMENT--------------------------------------------------------------------40

6.6 CONCLUSION------------------------------------------------------------------------------------40

GLOSSARY--------------------------------------------------------------------------------------------42

SAMPLE CODE---------------------------------------------------------------------------------------43

USER MANUAL--------------------------------------------------------------------------------------66

REFERENCE-------------------------------------------------------------------------------------------72

CHAPTER 1

1.1 Introduction

A stock management system is a key part of the supply chain and primarily aims to control the movement and storage of materials within a warehouse and process the associated transactions, including shipping, receiving, put away and picking. The systems also direct and optimize warehouse put away based on real-time information about the status of bin utilization.

The objective of a stock management system is to provide a set of computerized procedures to handle the receipt of warehouse and returns into a warehouse facility, model and manage the logical representation of the physical storage facilities (e.g. racking etc), manage the warehouse within the facility and enable a seamless link to order processing and logistics management in order to pick, pack and ship product out of the facility.

In its simplest form, the stock management system can data track products during the production process and act as an interpreter and message buffer between existing ERP (Enterprise resource planning) and stock management systems. Stock Management is not just managing within the boundaries of a warehouse today; it is much wider and goes beyond the physical boundaries. Inventory management, inventory planning, cost management, IT applications & communication technology to be used are all related to warehouse management. The container storage, loading and unloading are also covered by warehouse management today. Even production management is to a great extent dependent on stock management. Efficient stock management gives a cutting edge to a retail chain distribution company. Warehouse management does not just start with receipt of material but it actually starts with actual initial planning when container design is made for a product. Warehouse design and process design within the warehouse (e.g. Wave Picking) is also part of warehouse management. Warehouse management is part of Logistics and SCM.

Warehouse Management monitors the progress of products through the warehouse. It involves the physical warehouse infrastructure, tracking systems, and communication between product stations.

Warehouse management deals with receipt, storage and movement of goods, normally finished goods, to intermediate storage locations or to final customer. In the multi-echelon model for distribution, there are levels of warehouses, starting with the Central Warehouse(s), regional warehouses services by the central warehouses and retail warehouses at the third level services by the regional warehouses and so on. The objective of warehousing management is to help in optimal cost of timely order fulfillment by managing the resources economically.

1.2 Project Overview

This project gives a company the convenience of controlling the activity in the warehouse and thereby giving information to managers to assist in proper decision making the company. This project is pursued with Effison Limited as the focus of impact.  The major modules of the project are:

User login module:

This module would be the first to appear when a user launches the proposed system. These would help to ensure that un-authorized user don’t have access to the system. At start-up users would be required to login with their username and password.

Reports module

This module would be used for managerial staff for proper decision making in the day- to – day activity of the company.

Customer module

This module would be responsible in registering a customer into the company database. This information used during the registration process would then be used during shipping to direct goods to the appropriate customer

New item module

This would be responsible for the acknowledgment of goods into the warehouse.

Warehouse update module

This module would be used during the process of updating the quantity of a particular good in the warehouse.

1.3 Problem Statement

The majority of the problems that occur in the warehouse occur because of a lack of control: a lack of inventory control, operational control and or management control. To become a dynamic, consistent organization, all the operation must be under control. In order to achieve this control, all the tools and technology available has to be used to get control and manage the warehouse operation. A control system is a means, mechanism or procedure by which we manage these operations

In Effison Limited the method used in tracking goods involves the traditional record keeping and identifying products according to written labels. Inventory management and distribution typically relies on a traditional process of taking a physical inventory of products and manually ordering refills, while also eliminating product that is nearing or passed its expiry.

In the recording of a transaction only a single employee at a time is able to enter the record on a ledger book and furthermore some goods are not entered in the book but sold directly. Reports are not generated daily, weekly or monthly but only on a yearly basis and this cause mishandling of funds among the employees. The warehouse does not have a backup and recovery for the products of transactions journals made for the inventory items. Security is not there because the users and the administrators both perform the same tasks.

1.4 Objectives

stock management within warehouses is a challenge given the characteristic value specific nature of the products. Global visibility of finished and semi-finished products can greatly improve both inventory turnover and maximize production efficiency. One of the major goals in Stock Management is to track, store and move goods and materials efficiently; keeping inventory levels down while still always having enough products on hand. Picking and packing, controlling logistics documents, and in and outbound monitoring are all part of this process. The operations of this software include the following:

⦁    Lowering Working Capital

⦁    Increase inventory turns

⦁    Managing Fixed Assets & Resources

⦁    Improve physical inventory process,

⦁    Prevent selling expired products.

⦁    To keep track of all transaction to prevent any losses.

⦁    To conduct casual analysis to identify common trends in transaction by means of reports.

⦁    To prevent the company from running out of warehouses.

1.5 Scope of the study

The Stock management system is intended to cover all the operations of the company. The scope and tasks of the research project include finding out the scale of implementation of stock management system and perceived barriers for adoption, evaluating the strengths and weaknesses of warehouse management system currently adopted by the industry as a whole

.

DESIGN AND IMPLEMENTATION OF A COMPUTERISED STOCK MANAGEMENT SYSTEM



TYPE IN YOUR TOPIC AND CLICK SEARCH.






RESEARCHWAP.ORG

Researchwap.org 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.org 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.org 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.org" and God bless you and your business! ."

    Debby Henry George, Massachusetts Institute of Technology (MIT), Cambridge, USA.
  • "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.
  • "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 .
  • "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.