DESIGN AND IMPLEMENTATION OF A COMPUTERIZED OFFICE INVENTORY SYSTEM

Thesis Overview

INTRODUCTION In an organization, it is very essential and need greater attention towards effort made to achieve and mandation an economic balance between the cost incurred and saved, by holding material in stock. This process can be obtained by ensuring that the acquisition, storage, handling and usage of raw material are fully controlled at all times. This process is considered under the study of office inventory system which embraces, the total raw material to be used, work in progress and the stock counting of the finished goods. Inventory then means the measured amount of goods, which varies in quantity overtime in response to “demand” process, which operates to diminish the stock and an “repleshement” process, which operates to increase it. Due to fluctuating market prices of material in store, two system of valuation of issued of an inventory are adopted by most Due to fluctuating market prices of material in store, two system of valuation of issued of an inventory are adopted by most organization periodic and office system, which was defined by new lexicon Webster dictionary as records maintained for a manufacturing business so that, they show a continuous inventory of such items as raw materials and goods in process.For further implementation of this study, reference will be made to offices when the problems faced with inventory management is proposed to be narrowed down with the aid of computer to make work easier and to achieve accurate results, when updating files and also assessment of files.1.1 STATEMENT OF PROBLEM Generally, in inventory system, some of the problem encountered in relation to office inventory system are considered in three stages. (1) The planning stage in how the raw material needed for production are gotten, what kind of raw materials needed too. (2) Production stage (3) The finished goods product. Before a product, the company or the organization encountered the problem of: a) Seeking for the consent of the marketing manager of the company on how profitable the particular product to be produced is in the market. b) Consumption pattern: This depends in the quality of the product, the quantity and the purchasing power. c) Problem of working off-take, this is the estimated quantity of product to be produced at a given period in time problem. d) Head – time problem. e) Not providing a competent coverage for the raw materials ordered for. f) Purchase of sub-standard materials, which could result to wastage and low quantity product, damaging of machine and will eventually affect the profitability of the organization. g) Having an unrealistic supplier. (2) PROBLEM ASSOCIATED WITH THE PRODUCTION (1) The percentage permulation of the product, it should not be determined by assumption. (2) Individual mistake (3) Not putting the shelf of the product into consideration (3) PROBLEM ASSOCIATED WITH THE FUNISHED GOODS. (1) The order level of the production or stock level or consumption. (2) The price of the product: It depends on the availability of capital and the opportunity to acquire item at low price. (3) The risk of obsolenscence and determination. (4) The cost of stage and space available. (5) Insurance cost (6) Government regulation (7) Transport cost.