computerizedmaintenancemanagementsystem-经营管理系.pptVIP

Fault analyses for maintenance strategy /*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*/ Search from MMS database for estimating equipment troubleshooting job that needs unspecified inventory (預測設備相同元件損壞頻率) 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 CMMS can also function on sharing KM maintenance knowledge, which has never been measured by computer before. The hands-on experience sharing has rapidly enhanced the technician’s ability, resulting in 4 out of 72 workforce being saved. 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. Evaluate CMMS for Knowledge Management 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 maint