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

Abstract 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.