Development of an Excel Based Spreadsheet of Analytical Hierarchy Process And Decision Making Grid For Maintenance Policy Decision

Maintenance policies are created to fulfill the company needs to ensure smooth and continuous operation. In Lean Manufacturing, the importance of an effective maintenance program cannot be overlooked. Since most of the industries used machinery in their plant, of course there must be proper maintenance to ensure continuous production and smooth operation. Maintenance policies such as Preventive Maintenance (PM), Corrective Maintenance (CM) and Condition Based Maintenance (CBM) are widely used as a way to solve maintenance problems. Maintenance selection can be very hard and complex when there are a lot of criteria that need to be considered since their importance are nearly significant to each other. Selecting the proper maintenance strategy can ensure high system’s reliability and availability. Decision Making Grid (DMG) and Analytical Hierarchy Process (AHP) are often used to identify strategies for maintenance decision. Automation using these methods through specialized software is very costly. Therefore, a cheaper alternative is needed. Two Excel spread sheets are developed by applying the formula for calculating AHP and DMG. One of the main objective of this project is to produce an integrated decision making tool depending on available data and depth of analysis. Validation is done by inserting data from selected research papers then compared to their actual value which is obtained from the datum. For DMG model, after inserting the inputs, the results are displayed on the DMG grid view. Based from the validation of data using case studies, it can be found that some of the actual data from the paper has inaccurate and incorrect results due to mistakes in calculations. Others are validated and both the tools and case studies produced the same result. Therefore, the tools are ready to use. If all of the steps for the development of the spread sheet are followed, the best maintenance policy can be selected by using both of these models. The user can select either to choose AHP or DMG as their decision making tool.