International Journal of Aviation Science and Engineering
Vol 2, No 2: (Dec, 2020)

The Development of a Quantitative RCM/MSG Application using Microsoft Office

R Sianturi (Faculty of Mechanical and Aerospace Engineering, Institute of Technology Bandung, Jl. Ganesha 10 Bandung 40132)
E Suwondo (Faculty of Mechanical and Aerospace Engineering, Institute of Technology Bandung, Jl. Ganesha 10 Bandung 40132)



Article Info

Publish Date
16 Mar 2021

Abstract

The number of small to medium scale industries makes the development of a low cost and easy to use application to support maintenance programs development is necessary. Besides for industries, the developed application can be used also in the academic field for research. For cost reasons, the application is developed using Microsoft Access and Microsoft Excel. The development of the application is carried out in three steps, i.e. the determination of application specifications, the programming in Microsoft Access and Microsoft Excel, and the validation and user-friendly test. The application is developed by considering the relationship between the risk quantification of a failure effect and the selection of a maintenance task and its interval. The effectiveness assessments are based on the failure risk reduction up to an acceptable level. The developed application is named "Quantitative RCM/MSG". The application can conduct a database management according to the steps of the RCM/MSG method. The application can determine the required maintenance tasks and intervals for the category of evident and hidden failure effects by taking the safety and financial aspects into account. This application does its functions correctly and easy to use. For further application development, application can be developed using series and combination systems. Application with module redesign on default action

Copyrights © 2020






Journal Info

Abbrev

jav

Publisher

Subject

Aerospace Engineering Automotive Engineering Electrical & Electronics Engineering Mechanical Engineering Transportation

Description

AVIA : International Journal of Aviation Science and Engineering is published by Faculty of Mechanical and Aerospace Engineering, FTMD Institut Teknologi Bandung, Indonesia - in cooperation with Faculty of Engineering, Universitas Lampung and Java Scientific Academy, Indonesia. International Journal ...