DESIGN AND IMPLEMENTATION OF A COMPUTERISED BILL OF MATERIAL PROCESSING SYSTEM.

4000.00

ABSTRACT

The process of keeping the cost of all the raw materials used in producing any product in ANAMMCO is not an easy task. The concept of COMPUTERIZED BILL OF MATERIAL PROCESSING has been in existence in many organizations though in a traditional of (manual) approach. But the introduction of computer and more structured software will greatly improve reliability, validity accuracy and processing of data. This project work extensively discussed the existing system takes care of the materials and cost of the materials used in constructing a particular costing reports which could described detailing materials, labour and over head cost, gross-profit or loss, actual cost and quantities and time. Prior to the computerized database, the processes are put into computer control that is more efficient than the former. The new system will take care of the following vital financial and operating control of materials. Elimination of stocking items that are not needed. Elimination of production delay Proper cost accounting for materials etc.

 

CHAPTER ONE

INTRODUCTION

1.1    Background to the study

Ever the creation of man, there have been a continual quest by man to improve on his welfare, though the conception of computer has built confidence in man towards eradication of loop holes encouraged by his traditional approach to different life problems. But the basic need, still suggests that more should be done especially in production companies for more stress free life. The concept of material requirement planning (MRP), which embraces the computerized bill of material processing system (COMBOMP) have been in existence in many organization though in a traditional approach and in anticipation. I believe that the introduction of computer into the scene may greatly improve reliability, validity, accuracy and timely processing of data.

The initial stage in every engineering process is to conceive an idea and then transcribe this imagenation/mental pictures on paper, and the material involved in the production are studied and the computerized bill of quantity are determined in a manual form, but in the new system the computer are used to translate the master production schedule into a detailed plan for all materials required to produce scheduled products. The material subsystem  for each product computerized bill of material) is multiplied by the number of units scheduled to be produced. The amount of material on hand, the materials needed to be purchased and a schedule of purchase are then calculated. This helps to minimize investment in material inventories while still adhering to the master production schedule.

The industrial age in moving into  a dramatic form of computer development every organization is trying to be computerized because of the reliability and validity of information derived from the database. Though most organizations are lagging behind and it pams us to observe that COMPUTERIZED BILL OF MATERIALS has not been computerized in most of our manufacturing companies. In spite of this, we believe that this research work, which is properly probed and compiled, will serve as a stepping-stone on how to rectify the anomaly of manual processing. The developed system has the capacity of receiving, editing and deleting information about COMPUTERIZED BILL OF MATERIAL PROCESSING and it’s application is vital to ANAMMCO and any other production industries.

1.2    Statement of problem

This work is targeted to consider of the problems that render the already existing system inefficient in running their daily activities as regards to production of a  1414 Mercedes product. The number of quantity and amount of material and sub-assembly needed to produce a product cannot be traceable because of the glaring disadvantages stated below.

1. Inefficient system of processing and storing information about COMPUTERIZED BILL OF MATERIAL.

2. For the fact that records are stored on paper makes it easily accessible for vandalization by unauthorized persons.

3. Using filling cabinet filing cabinet is used to organize different types of files which might not be benevolent in organizing files.

Thus, it may lead to record or file loss. Record can easily slip off. If the filing cabinet is not placed in a decent environment, it leads to termites eating off papers and other documentaries.

4. It takes a long time in accessing record in manual system that is in filing cabinet than automated system.

5. Inaccuracy of data due to negligence and also repetitive nature of work. Negligence does occur as a result of over looking of some relevant information.

6. Because of inaccuracy of data, management decisions are always obscured and also forecasting could not be well determined. To be more precise these problems were jacked off by the introduction of computer. Computer made ON-LINE-BILL OF MATERIALS mode of operations such as permanent storage retrieval and processing of information to be easily for establishment.

1.3    Purpose of study

This project is geared towards eradication of all the deformities and loopholes of the manual of COMPUTERIZED BILLS OF MATERIAL PROCESSING. Thus, developing a new system to handle all the Jobs/works, involved in (COMBOMP) electronically, supplying all the deficiencies of the existing system. Consequently upon the elimination of the deficiencies and rectifying the anomalies encountered in the existing system, overshadowing its operational in capacitations by developing a computer-based solution of storing information for billing. Investigation has presented some of the problems and deficiencies of the method such as difficulty in editing already filed document using correction fluid which makes it appear unity and rough, time wasting in searching for file or retrieving of information habitual ways of stealing and hoarding materials in shop/ware house because of lack of documentation of materials used in production and knowing the cost of each material involved in production considering the above problem and difficulties, the researcher considered it better to introduce computerized form which may be better than the manual if well designed and implemented. This is to enable the level of job enrichment and to produce increased administrative efficiency. Application of computer in the COMPUTERIZED BILLS OF MATERIALS PROCESSING will make for quick, and easy collection, processing, storage and retrieval of information as regards to the (Combomp) in ANAMMCO.

1.4    Aims and objectives

In an organization whether manufacturing or merchandising, where the competitors and the objectives of the organization are at the top list of their endeavor especially meeting the labour market, there is always a focus on the organizational goal which might not be the goal of the sbu-system to avoid sub-optimality working toward individual benefits.

The aims of this project include:

1. To work toward the elimination of ineffective modes of operation. It centered on the user to having a conducive atmosphere for work thereby minimizing stress.

2.  As a means of safeguarding information, which will serve as reference for making management decision, forecasting and also budget management decision expenditure against production processing, which includes: ON-LINE-BILLS-OF-MATERIAL as its emphasis.

3. The target/objective from the creator of the proposal is geared towards combating all the aims and problems being discovered on the existing system.

4. Among the objectives include finding out the requirements needed to build the new system which serve as the messiah for the old system.

5.  The type of database to be produced to suit the user of the software, would be based on the sequential or random or index mode of operation?

1.5  SCOPE OF STUDY

The scope of this project work covers all the areas of (Combomp) systems which include the cost of individual material responsible for production, the stock control or inventory area in which materials are being stored and s well contains reports each of these have different fields that make up the record, which could be expanded a little to form what is called file. These files give room for editing/updating and retrieving of information as its need. Some of the field are items description, quantity total requirement, re-ordering point, labour cost, overhead cost, profit, power cost etc. this project is focused on the entire information recorded on COMPUTERIZED BILLS OF MATERIALS PROCESSING FOR ANAMMCO NIGERIA LTD EMENE, ENUGU.