Design And Implementation Of A Computerized Quality Control System For A Manufacturing Organisation

Project and Seminar Material for Computer Science and Computer Engineering

Design And Implementation Of A Computerized Quality Control System For A Manufacturing Organisation


The purpose of the study is to computerize quality control system for manufacturing organization (A case study of S.E.D.I Enugu) and to develop a computer package whereby the techniques observed from the manual method can be improved on. It is known fact that the manual method of quality control system in production has been associated with lots in inaccuracy in quality control and this has lead to early break down of parts when in service. The software with developed will facilitate and enhanced the mode and methods of quality control in spare production of S.E.D.I Enugu.

Chapter One


1.1 Introduction

A quality control system in production management is a qualitative technique with strong financial implication having direct relationships with production, marketing, purchasing and financial policies.

Also, it is a system used in the management of manufacturing held by any organization as it concern addition to, storage and removal from the trading organization with appropriate record keeping.

S.E.D.I. Ltd, Enugu as an assembly plant maintains a large amount of stick vehicle spare parts which are imported from any of her vendor, Viz:- MBAG-Mercedes – Benz AG Germany, MBBRAS-Mercedes- Benz Brazil or MBE-Mercedes-Benz Espana for the production line or sales to distributions or authorized agents/dealers.

These stocks are held for various reasons among which are:

  1. To ensure unit sufficient goods are available to meet anticipated demand.
  2. To provide a buffer between production processes. This is applicable to work in progress stocks effectively decouple operation.
  3. To meet possible shortages in the future.

All these spare part, which may similar menu by description, varies greatly among themselves depending on the type of model of vehicle using them. Thus, the management and operation of stores functions and the control of stock can only be performed in an efficient manner when there is an appropriate means of upturning and storing information and the facility of the analysis and use of this information.

In the light of the above S.E.D.I. Ltd Enugu maintains a visible records system return to as KARDEX, As a prerequisite in any quality control system ANAMCO Ltd maintains a peculiar but unique coding system such that all the numerous spare parts are each uniquely coded and identified for accurate and specific information on them.

The operation of the KARDEX was of ten prove to redundancy or duplication of items when ever there is mistitling, it requires a lot of paper work with their possible variation or discrepancies during documentation; it involves, so many people thereby wasting a lot of man hours; increased cost of procurement storage of non-moving or obsolete items leads to customer dissatisfaction due to time wasting and unavailability of information. Thus, the efficiency of the system is greatly depending on human factor and as such accuracy.

So, it is an attempt to rectify and modify the above inadequacies that we have decided to develop and implement an integrated computerized stock control system so as to maximize the operation efficiency, ensure customers satisfaction based on quick services, minimize the non-hour requirement involved reduce the running costs, guarantee accuracy and at the same time generate report that assist management in her decision making as it concerns planning organizing and controlling.

1.2 Background of the Study (MB-S.E.D.I LTD ENUGU)

Sequel to the recommendation of the fourth (4th) National Development plan in 1975 to increase the number of automobile plants in Nigeria in order to address the problem of transportation a Mercedes Benz plant was chosen. Other reasons for establishing the plant being to

  1. Transfer of technology
  2. Manufacture and assembly of indigenous man-power training
  3. Modernisation of industrial workers and
  4. Diversification and rapid industrialization of the Nigeria Economy.

MB-S.E.D.I. Ltd, as it is famously known and called means Mercedes-Benz Anambra Motor Manufacturing Company Limited Enugu. The company is strategically located along IBB-Airport Link Road Enugu Industrial Layout Enugu.

The pliant is a joint owned by the government and people of the Federal Republic of Nigeria and Daimier-Benz AG of Germany. Their share equity is in the ratio of 60% to Nigeria and 40% to Daimier-Benz AG Germany.

Therefore Mercedes-Ben S.E.D.I. Ltd. Enugu was licensed to manufacture Mercedes-Benz commercial vehicle in Nigeria. The company was incorporated in Nigeria as a Private Limited Company.

On the 17th day of January 1997. On the 12th day of May 1978, its foundation stone was laid by Colonel John Atom Kpera then the military Governor of the thin ANAMBRA STATE (NOW, ENUGU and ANAMBRA). Later, on the 8th day of June 1980 Mercedes-Benz ANAMCO LTD, wad commissioned by Alhaji; Shehu Usman Aliju Shangari, then the President Head of State Commander in Chief of the Nigeria Armed forces S.E.D.I. LTDM commenced production officially on January 1981, ever since the n her services work has spread throughout Nigeria. The company uses foreign and local contents in the manufacture of the Mercedes-Benz commercial vehicles.

1.3 Statement of the Problems

It is a common knowledge that decision makers in any organization requires, Information to perform the great functions of planning. Therefore, it is necessary to discover an adequate means of making the information available in making everyone concerned. This is because, for decision to be made correctly. The information must be consistent, accurate, time and reliable.

Thus, this work is aimed at developing and implementing an integrated computerized quality control system in production of an automobile firm (Case study S.E.D.I Enugu Nigeria

1.4 Problems of the Study

  1. The problem encountered when carrying out this study are that obtaining this necessary information from the staff of S.E.D.I. was not easy because some of their information are regarded as company secret.
  2. There is competition of the way few pass personal computer, which has DBASE 111, plus application because many students make use of them in missing their project program.
  3. Production of spare part on manual approaches has been very difficult.
  4. Problem of fund a lot of money is been incurred in carry out this project.
  5. There may be inadequate or not existent stock records.
  6. Obsolete items are retained in stock, which makes in difficult for one to know the overall items in stock.

1.5 The Purpose of the Study

The objectives of this work include the following

  1. To ensure appropriate stock quality control coding with a view to minimizing stock redundancy or duplication inherent in the manual system of quality control system in production.
  2. To ensure operational efficiency thereby martimasing the customer services level with increased accuracy.
  3. To generate consistent accurate timely and reliable reports that consist the management in her decision as it affects the stock and the organization for affective planning, organization and controlling.

1.6 Scope

Even though that Mercedes-Benz S.E.D.I. Ltd is the case study with her diverse inventories this work is only continued to the administration of spare parts (finished good type of inventory) as it concerns ordering, receipts, sales and reports. Therefore, it excludes the W.I.P work-in-progress) and other forms of quality stock control. It also excludes other automobile firms.

1.7 Aims and Objectives

The aims and objectives of this work is that when the system becomes operational, it will:

  1. Permit on-line time data storage and information retrieval.
  2. Save the production time per section and as such ensure customer satisfaction.
  3. Increase the operation efficiency and accuracy
  4. Reduce stock redundancy or duplication inherent in manual system.
  5. Reduce the operational cost.

1.8 Limitation of the Study

Many factors hindered the realizations objectives of this work. Among this are:

  1. Competition of the very few PCS (Personal Computers). In the computer centre the Institute, which has the National D basics application, which used in running the programs. This is because over Eighty (80) students make use of them in running their project programs as well.
  2. Obtaining necessary information and approval from the production manager of the central spare parts department was not easy for me at most of his information required are regarded as company secrets.

This work is financially oriented as I am of ten forced to go to private computer firms to run my programs because of the competition in the computer center. The amount of money involved in transporting myself to and from such computer firms plus the amount paid for the computer time is usually environs.

1.9 Definition of Terms

(1) Lend or Procurement Time:

This is the period of time expressed in days, weeks, months etc. between ordering and replenishment in when goods are available for use.

(2) Demand:

This is the required by sales production etc. Pre week, month or year etc.

(3) Economic Ordering Quantity (EOQ):

This is the calculated ordering quantity which minimize the balance of costs between inventory holding costs and recorder costs.

(4) Physical Stock:

This is the number of items physically in stock at a given time.

(5) Minimum or Safety Stock:

This is a stock allowance to cover errors in fire casting the lead time or demand during the leas time.

(6) Maximum Stock Level:

This is the stock level selected as maximum desirable which is used as an indicator to show that stock have risen to high.

(7) Reorder Level:

This is the level of stock at which further replenishment order should be proud. It is dependent upon the lend time and the demand during the lead-time.

(8) Reorder Quality:

This is the quality of the replenishment order. In some types of inventory control system, it is EOQ.

  • To absorb seasonal fluctuations in usage or demand.
  • To enable production processes to flow smoothly and efficiently.
  • As a necessary part of the production process.

All these are logical and are based on deliberate decision. Yet, stock accumulate due to the less promise worthy reasons which are:

  • Obsolete items are retained in stock.
  • Poor or non-existing inventory control resulting in over large orders, replenishment orders being out of phase with production. Etc.
  • Inadequate or non-existing stock records.
  • Marketing department.

Whether as a deliberate policy or not, represents an investment by the organization. Thus, as with any other investment, the cost of holding stocks most be related to the benefit to be gains. To do this effectively the cost must be identified and this can be done in the three categories:

  • Cost of obtaining stock
  • Cost of holding stock
  • Stock out costs.

Complete Material Available

Get Complete Project Material

5,000 5000

The Complete Material Will Be Sent to You in Just 2 Steps

Quick & Simple…

Step One Purchase

Make Payment (Through Transfer) of ₦5,000 to the Account Below

Zenith BankAcc No: 1225513212
Samphina Academy
Current Account

Or CLICK HERE To Pay With Debit Card

CLICK HERE To Purchase Material ($15)

Step Two Purchase

Send the Following Details on WhatsApp ( 08143831497) After Payment

  1. Payment Details

  2. TOPIC: Design And Implementation Of A Computerized Quality Control System For A Manufacturing Organisation

The Complete Material Will Be Sent To You On WhatsApp After Receiving Your Details
T & C Apply

  Contact Our Help Desk

Need a Different Topic? Perform a Quick Search

List of Related Works

Click on Any Topic to Preview the Content


Any quality controls system whether manual or computerized. If properly managed should be able to:

  1. Show at any time the production started
  2. Record all issues and receipt of material completely and exactly.
  3. Continuously ascertain and maintain the consumption figures statistically.
  4. Enable product replenishment to be at the right time.
  5. Show the different stages involved in the production.
  6. Give an early indication of less quality turnover of certain parts to prevent the documentation of dead product and connected double profits.

The sole aim of this work was to develop and implement an integrated computerized quality control system that can handle the above requirement in a lesser time with greater accuracy, reliability and reduced cost. Thus, the new system was developed based on the finding of the strength and weakness of the existing system of S.E.D.I Enugu Nigeria.

A computerized on the operation of the menu against the proposed integrated computerized quality control system through analysis and evaluation indicated that the control should firm particularly in S.E.D.I Enugu and for other forms of inventory.

In other to ensure optimum operational efficiency and full utilization of the computerized system, the following recommendations are necessary for S.E.D.I Enugu.

  1. To establish an electronic data processing centre that can effectively and efficiently takes over their manual system of quality control.
  2. To employ qualified personnel’s of computer science to oversee the administration and operations of the centre;
  3. To establish a standard database management system (D.B.M.S) that can maintain the data in the system
  4. To organize training for staff users of the proposed system who will be directly involved in the spare parts inventory control.
  5. To take up an insurance policy against give are theft to cover the new system.
  6. To provide adequate physical security for the electronic data processing centre.
  7. To provide back-ups of the system programs and data against accidental loss of important data.

Samphina Academy

Samphina Academy is an Online Educational Resource Center that is aimed at providing students with quality information and materials to aid them in succeeding in their academic pursuit.