DESIGN AND IMPLEMENTATION OF AN STOCK CONTROL SYSTEM

Diploma

                              ABSTRACT

This research work is concise and generally summarizes the activities duly carried out in the design and implementation of a stock control system in Federal Airport Authority of Nigeria Minna Niger State. The system is designed to efficiently handle the movement and tracking of goods through the replacement of human workers by technology. The manual method or intervention is labour intensive, costly, and error prone and cannot ensure the inventory remains up-to-date due to oversight and internal shrinkage. With the proposed new system, inventory can be updated in real time without product movement, scanning, or human involvement. The automated system allows stock status to be determined stock in, stock out and detail information about items and their owners. The study outlines the main concepts of the analysis and design methodology of the proposed system, compares it to the existing and goes further to explain the design and implementation of the system using Microsoft Access for the database. The fact finding techniques employed is interview, observation, online and library research.


                             BACKGROUND OF THE STUDY

Stock Control System is the process of managing inventory in order to meet customer demand at the lowest possible cost and with a minimum investment, Byoungho (2004). A successfully implemented stock control program takes into account such things as purchasing goods commensurate with demand, seasonal variation, changing usage patterns, and monitoring for pilferage, Ellram (1996). A preliminary step in the process of stock control is to determine the approximate costs of managing   inventory. According to Langabeer and Stoughton (2001), these costs include such expenses as storage costs, inventory risks, and the loss-of opportunity costs associated with tying up capital. Inventory management is a vital function to help ensure the success of manufacturing and distribution companies and lately retail stores. The effectiveness of inventory management systems is directly measurable by how successful a company is in providing high level of customer service, low inventory investment, maximum throughput and low costs, Ellram (1996). The challenge of productive inventory management is to support an upward trend in sales while keeping the investment at the lowest level consistent with adequate customer service. Control of inventory, which typically represents 45% to 90% of all expenses for business, is needed to ensure that the business has the right goods on hand to avoid stock-outs, to prevent shrinkage (spoilage/theft), and to provide proper accounting, Khan (2003).

Articles stored and later used in this way are known collectively as inventory. In large organizations, it is usual for inventory to be in tens, even hundreds of items valued at tens of millions of naira. Given this state, it has become natural to have inventory items represented in computer maintained files. Computer especially microcomputer has become an important tool in all types of business from one man operations up to large international business firms.

Every business manager need to know what is in the store, what goes out and what is remaining in the inventory. For this obvious reason, large, small and medium organizations, companies and government, as a whole need computerization of stock control. The speed at which the administrative and paper work in retail stores  increases on daily basis calls for a corresponding need for a quick and effective device to meet up with the demand. This project hopes to link stock control and computer system.


                        AIM OF THE PROJECT

The main aim of this project is to develop software that will automate the current manual inventory control system through incorporation of computer to eliminate errors relating to inventory control calculations and management.                    

                                OBJECTIVES

  1. To provide system that keeps  constant updates about total number of stock available in the store  and constantly each and every items in the stock that is going down low to out of stock, the system alert as soon as is due.
  2. To provide software that save time and reduces energy consumption by making complicated processing and inventory sales report easy and without delay.
  3. To be able to discover several goods in stock that are about to expire in stock. The software gives the flexibility to know every single item in the store, its Quantity and their expiry dates at just a click to the software.
  4. The software provide easy way to print out weekly/monthly summary reports, showing how much have been used for different stock items from a computerized stock system.