導入資訊管理系統對設備保養管理之影響 The Impact of Implementing MIS on

導入資訊管理系統對設備保養管理之影響 The Impact of Implementing MIS on Maintenance Management 報告人 ﹕ 游禎平 2007/12/11

Management Information System Efrain Turban, R. Kelly Rainer and Richard E. Potter, 2003 l Typically, a functional MIS provides periodic reports about such topics operational efficiency(經營效率 ) effectiveness (效益 ) productivity (生產力 ) l It prepares the reports by extracting information from the corporate database and processing it according to the needs of the users (依據使用者需要從公司的資料庫萃取產生報

Table of Contents 1. Introduction: Maintenance Management 2. Development of Computerized maintenance management system (CMMS): Procedure, Structure, Tool 3. CMMS Application and Evaluation: Case study 4. Conclusions and Directions for Future Research

1. Maintenance Management 故障保養預防保養生產保養全員生產保養預知保養全員生產管理

2. Maintenance/asset management strategy Maintenance/Asset Strategy (保養策略 ) Continuous Improvement (持續改善 ) Total Productive Maintenance Preventive Maintenance Stores and Procurement Financial Optimization Operations Involvement Work Flow System Reliability Centered Maintenance CMMS/ Enterprise Asset Management Productive Management(生產管理 ) Technical and Interpersonal Training

Table of Contents 1. Introduction: Maintenance Management 2. Development of Computerized maintenance management system (CMMS): Procedure, Structure, Tool 3. CMMS Application and Evaluation: Case study 4. Conclusion and Directions for Future Researches

Computerized Maintenance Management System 稽核訓練組織計畫時程診斷標準設備履歷控制報表

Objectives 1. To reduce equipment breakdown. (降低設備故障 ) 2. To promote productive efficiency. (提升生產效率 ) 3. To reduce equipment maintenance cost. (降低維修成本 4. To reduce inventory cost and achieve reasonable inventory (service level). (降低備品庫存 ) 5. To build knowledge management, troubleshooting technique and repair experience can share. (建立故障檢修知識庫 ) 6. To develop human resource, promote(開發人力資源 ) maintenance technical personnel efficiency.

1. Structure of Maintenance Management System machine PLC Control System Active. X Controls e. g. , RSView, VB data collection Link (communication tool) Reporting web-based report Reporting data collection Production Server data collection Database (SQL Server or Oracle) Reporting CMMS Client

2. Procedures of Maintenance Management System (1). Definition HMI SCADA. (定義人機介面 ) (2). Build equipment maintenance database. . (建立設備保養資料庫 ) (3). Computerized maintenance management system. (設備保養管理電腦化 ) Then, System evaluation and analysis.

(1) Definition HMI SCADA l The software about HMI, it designed for manufacturing efficiency, convenient operation and production quality, etc. l HMI is very useful, and we can define the HMI for equipment maintenance by technician also. l The HMI has many brands. There are many software available. This research adopts RS-view which is made by Rockwell Automation Company.

(1) Definition HMI SCADA

(1) Definition HMI SCADA Define Tag Number ( Mapping PLC address) Build Graphics Modify Graphics

(1) Definition HMI SCADA

(2) Build equipment maintenance database

(3) Computerized maintenance management system DEMO

MMS in the past (1992~2002) 設備故障 When Equipment breakdown 主管派 Supervisor detach repair worksheet (by manual) Preventive maintenance job Make decision for maintenance period by supervisor with Look up for troubleshooting by technician 進行維修 Maintenance activity 填寫紀錄 Technicians make notes in worksheet For instance: fault describe, labor and materials 重點轉記 Supervisors write ponders able fault to paper, collect to equipment’s curriculum vitae document. (can not analysis real-time) 文件歸檔 Store up maintenance document for reference, by future troubleshooting 保養履歷 Supervisors refer to equipment’s curriculum vitae document. Make decision to maintenance policy. For instance: decision period, replacement, training, inventory, and efficiency.

Develop new CMMS (2004) Analysis from DBMS by computerized 建立資料庫 , 方便就源輸入 !! When Equipment breakdown HMI definition Preventive maintenance Predicative maintenance Supervisor detach repair job from MIS print worksheet, technician make equipment's rounds of inspection. Maintenance activity Reference from DBMS Technicians make notes in worksheet For instance: fault describe, labor and materials Supervisor/ technician entry notes to maintenance management system database. Automatic transfer to maintenance document in database for reference, by future troubleshooting Supervisor refer and analysis from database. Make decision to maintenance policy. For instance (decision period, replacement, training, inventory, and efficiency) 機台自動蒐集故障訊息

E-R diagram for maintenance management database

Maintenance Management Database DEMO

Table of Contents 1. Introduction: Maintenance Management 2. Development of Computerized maintenance management system (CMMS): Procedure, Structure, Tool 3. CMMS Application and Evaluation: Case study 4. Conclusion and Directions for Future Researches

The background of case study l This thesis collects seven months, November 2004 to May 2005, electrical equipment fault event data from a chemical manufacturing firm, about 3200 jobs being analyzed. l The case study company, an ISO 9001 and ISO 14000 certificated company, produces polyester fiber. l The company was established in October, 1967, and is a full-processing manufacturer of polyester filament and staple fiber. l In terms of capacity, the case study company is the second largest polyester producer all over the world, and is number one in Taiwan.

Access supports a variety of query types (Access 支援各種查詢功能 ) l These queries return data from one or more tables and display the results in a result table. l The table is updateable, which means that we can change the data in the table and the changes will be reflected in the underlying tables. l Selected queries can also be used to group rows and calculate sums, counts, averages, and other types of totals for these groups.

Search from maintenance management database for estimating same equipment troubleshooting times. (估計相同設備異常次數 ) /*Access SQL language */ SELECT [Factory], [System], [Machine], [Date], [Fault describe] FROM search MMS duplicate WHERE [Factory] In (SELECT [Factory] FROM [search MMS duplicate] As Tmp GROUP BY [Factory], [System], [Machine] HAVING Count(*)>1 And [System] = [search MMS duplicate]. [System] And [Machine] = [search MMS duplicate]. [Machine]) ORDER BY [Factory], [System], [Machine]; /*END*/

Establish maintenance cycle

Search database forecasting equipments fault from MMS (預測設備相同異常次數 ) /*Access SQL language*/ The SQL SELECT MMS. Date, MMS. [Fault describe], MMS. Factory, MMS. System, MMS. Machine FROM MMS WHERE (((MMS. Date) In (SELECT [Date] FROM [MMS] As Tmp GROUP BY [Date], [Fault descript] HAVING Count(*)>1 And [Fault descript] = [MMS]. [Fault descript]))) ORDER BY MMS. Date, MMS. [Fault descript]; /*END*/

Fault analyses for maintenance strategy

Search from MMS database for estimating equipment troubleshooting job that needs unspecified inventory (預測設備相同元件損壞頻率 ) /*Access SQL language*/ SELECT [MMS SEARCH COMPOENT]. Component, [MMS SEARCH COMPOENT]. [Job No], [MMS SEARCH COMPOENT]. Date, [MMS SEARCH COMPOENT]. Factory, [MMS SEARCH COMPOENT]. System, [MMS SEARCH COMPOENT]. Machine, [MMS SEARCH COMPOENT]. [Maintenance Note], [MMS SEARCH COMPOENT]. Analysis, [MMS SEARCH COMPOENT]. Strategy, [MMS SEARCH COMPOENT]. Classifies FROM [MMS SEARCH COMPOENT] WHERE ((([MMS SEARCH COMPOENT]. Component) In (SELECT [Component] FROM [MMS SEARCH COMPOENT] As Tmp GROUP BY [Component] HAVING Count(*)>1 ))) ORDER BY [MMS SEARCH COMPOENT]. Component; /*END*/

Analysis of maintenance material requirement DEMO

Inventory Management Database DEMO

Factory equipment breakdown ratio

Comparisons of breakdown ratio, with/without CMMS

Comparisons of factory maintenance fees, with/without CMMS

Comparisons of all factories maintenance fee with/without CMMS

3. Knowledge Management

Knowledge Management Database

Evaluate CMMS for Knowledge Management DEMO

Evaluate CMMS for Knowledge Management l CMMS can also function on sharing KM maintenance knowledge, which has never been measured by computer before. l The hands-on experience sharing has rapidly enhanced the technician’s ability, resulting in 4 out of 72 workforce being saved. l The cost for cultivating a technician is about NT$68, 000/per month; the adoption of CMMS system has saved NT$ 272, 000/per month for the case study company.

Apply this CMMS to link MIS of enterprise. We perform maintenance management well. Refer to the following description: 1. Define Maintenance Tasks (定義保養作 ) 2. Plan Maintenance Work (計畫保養作 ) 3. Update Work Order (更新派 ) 4. Get Work Done in a Certain Period(限定完期限 ) 5. List of Parts Re-Ordered (庫存備品採購 ) 6. For Conducting Training (員訓練 )

Table of Contents 1. Introduction: Maintenance Management 2. Development of Computerized maintenance management system (CMMS): Procedure, Structure, Tool 3. CMMS Application and Evaluation: Case study 4. Conclusions and Directions for Future Research

4. 1 Conclusion l The goal of maintenance activity is to provide high quality, low cost maintenance. (達成高品質低成本的目標 ) l A good maintenance management will definitely reduce productive loss. (可減少生產損失 ) l Adoption of CMMS enhances the performance of maintenance, inspection, monitoring, inventory, and training, etc. (採用電腦化維修管理可以增強保養執行 ) l By integrating with Enterprise Resources Planning (ERP) or MIS, we can perform better to maintenance management. (採用電腦化維修管理方便與 MIS整合 ) l CMMS, predictive and maintenance tracking systems are now a necessary in managing and controlling assets, plant and equipment maintenance in modern manufacturing. (採用電腦化維修管理對現代製造業是必須的 )

4. 2 Directions for Future Researches 1. Re-manufacture, repair, and exchange services for equipments and reliable parts; repair the third party’s parts (low cost) and evaluate the using validity. (開發對抗品 , 低價位可靠的備品 ) 2. Reduce the associated costs on site management of parts inventories, and increase working time to ensure that users have the right replacement parts. 3. (降低維修備品成本 ) 3. Combine CMMS systems with the existing or planning control systems to increase real-time monitoring capabilities. (結合 CMMS增強即時監視能力 ) 4. Remote diagnostic services to increase facility uptime and reduce overall labor expenses. (遠端維修減少人力浪費 )

4. 2 Directions for Future Research 5. Consult professionals and expertise to implement EAM solutions without developing additional in-house expertise. (委外顧問及專家 ) 6. Establish the predictive maintenance practices, which display more effective than that of breakdown maintenance techniques. (建立預知保養執行 ) 7. Ensure all HMI will automatically transform to maintenance management database, in order to achieve real-time trusty. (HMI自動轉換到維修管理系統 ) 8. Maintain Database for data security. (database維護及安全 )

Thanks and giving suggestions

導入資訊管理系統對設備保養管理之 影響 The Impact of Implementing MIS on

導入資訊管理系統對設備保養管理之影響 The Impact of Implementing MIS on