Abstract:
This thesis studied supplier evaluation system and database management system of purchasing department for packaging industry. The purpose of the thesis was to manage data originated in purchasing department and develop system for evaluating suppliers. The current rating supplier system was not standardized because it was dependent on buyer's experiences, judgments and satisfactions. The process of evaluation was considerably time-consuming starting from gathering data that are essential for assessing the supplier performance. Also the data-collecting process produced lots of errors such as data duplication and misspelling. A Supplier Evaluation Team from relevant departments involving with in making evaluation was appointed to establish a formalized supplier evaluation system and set performance criteria in assessment. The research started with the analysis and design of the work procedures, following with the information requirement forms that the users. The supplier evaluation system applied the weight-point method for making assessment, which are based on major supplier's performance criteria, covering quality, delivery, price, service and reliability. After forming data, the structures of database and program application are designed. Finally the designed system is developed to be prototype software for supplier evaluation. The proposed system was developed on the base of Microsoft Visual Basic 6.0 program, used Microsoft Access version 2000 as the database management system and Crystal report 9.0 as the reports. The expected results of the proposed program, after implementing in the firm during the observation period are time reduction and standardization in evaluating process. Additionally, the information is likely to be more correct and complete.