Spreadsheet modeling of optimal maintenance schedule for components in wear-out phase

K. B. Artana, K. Ishida

Research output: Contribution to journalArticlepeer-review

23 Citations (Scopus)


This paper addresses a method for determining the optimum maintenance schedule for components in the wear-out phase. The interval between maintenance for the components is optimized by minimizing the total cost. This consists of maintenance cost, operational cost, downtime cost and penalty cost. A decision to replace a component must also be taken when a component cannot attain the minimum reliability and availability index requirement. Premium solver platform, a spreadsheet-modeling tool, is utilized to model the optimization problem. Constraints, which are the considerations to be fulfilled, become the director of this process. A minimum and a maximum value are set on each constraint so as to give the working area of the optimization process. The optimization process investigates n-equally spaced maintenance at an interval of Tr. The increase in operational and maintenance costs due to the deterioration of the components is taken into account. This paper also performs a case study and sensitivity analysis on a liquid ring primer of a ship's bilge system.

Original languageEnglish
Pages (from-to)81-91
Number of pages11
JournalReliability Engineering and System Safety
Issue number1
Publication statusPublished - Jul 2002
Externally publishedYes


  • Availability
  • Maintenance schedule
  • Reliability
  • Spreadsheet modeling
  • Wear-out


Dive into the research topics of 'Spreadsheet modeling of optimal maintenance schedule for components in wear-out phase'. Together they form a unique fingerprint.

Cite this