Welcome To UTPedia

We would like to introduce you, the new knowledge repository product called UTPedia. The UTP Electronic and Digital Intellectual Asset. It stores digitized version of thesis, dissertation, final year project reports and past year examination questions.

Browse content of UTPedia using Year, Subject, Department and Author and Search for required document using Searching facilities included in UTPedia. UTPedia with full text are accessible for all registered users, whereas only the physical information and metadata can be retrieved by public users. UTPedia collaborating and connecting peoples with university’s intellectual works from anywhere.

Disclaimer - Universiti Teknologi PETRONAS shall not be liable for any loss or damage caused by the usage of any information obtained from this web site.Best viewed using Mozilla Firefox 3 or IE 7 with resolution 1024 x 768.

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

Sallahuddin, Ahmad Nadzrin Shah (2013) Development of an Excel Based Spreadsheet of Analytical Hierarchy Process And Decision Making Grid For Maintenance Policy Decision. Universiti Teknologi Petronas. (Unpublished)

Download (2316Kb) | Preview


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.

Item Type: Final Year Project
Academic Subject : Academic Department - Mechanical Engineering - Materials - Engineering materials - Metals alloys - Fabrication
Subject: T Technology > TJ Mechanical engineering and machinery
Divisions: Engineering > Mechanical
Depositing User: Users 2053 not found.
Date Deposited: 01 Apr 2014 16:08
Last Modified: 25 Jan 2017 09:38
URI: http://utpedia.utp.edu.my/id/eprint/13781

Actions (login required)

View Item View Item

Document Downloads

More statistics for this item...