Implementation of classification and coding system in machine spare part manufacturing

Abstract

The first objective of the thesis is to develop classification and coding system for machine spare parts. The second objective is to establish computer program used to provide convenience to user in classification and coding process and product data management. At present, processing time is one of important factors that most manufacturers concern. In machine spare part manufacturing where competition continuously increases, manufacturing time and qualtiy becomes competitive edge for all firm. Manufacturers are now trying to reduce every operation time before a product is launched in order to attract customers. To decrease operation time, production plan is normally used to uncover unnecessary processing time. To establish production plan, one of the most important things is produc satndard time which can be determined from using past production data. However, since company does not have competent data management, most data are missing or damaged. Therefore the thesis will pay attention to develop efficient product data management. To develop the sustem, classification and coding can be used to increase more effectiveness since products having similar attributes are classified and coded, which helps users acquire the target data easily and quickly. To establish the system, the thesis congregates the concepts of Group technology, Cataloguing, and Classification, while concepts of Product Data Managment are used to build up the computer program. The program will join classification and coding system and database management system together by using concept of SQL server, which is large and popular system presently.