Make sound equipment replacement decisions with a simple equipment replacement model decision optimization tool

Low Cost Excel Spreadsheet Equipment Replacement Decision Model lets You Make the Optimal Equipment Replacement Decision

The equipment replacement model lets you review your equipment replacement strategies and make equipment replacement decisions optimised to your actual site equipment maintenance costs and equipment failure history.

A Microsoft Excel equipment replacement model used to select optimal equipment replacement time periods. The replacement modelling tool allows you to use historic equipment failure mode data to model a Weibull distribution plot for the equipment. The equipment replacement interval optimisation tool lets you use site specific information to conduct 'what-if' analysis for minimising your equipment operating life maintenance costs.

Optimize Plant and Equipment Replacement Decision Modelling Tool
(MS Excel Spreadsheet for Weibull modelling equipment replacement intervals that minimise
both maintenance costs and the number of equipment failures)

Equipment Replacement Modelling Tool - AU$19.99

How to Use the Modelling Software

The equipment modelled in the image below had five failures to-date during its operating life. It had also been overhauled periodically between the recorded failures. A new equipment item, or an 'as good as new' rebuild would cost $10,000. The business-wide costs of a breakdown are $25,000. The failure data points (noted as non-parametric) are plotted over a Weibull distribution and the fit is workable for the situation being investigated. Based on the failure data the model advises the optimal period to replace the equipment with new, or completely overhaul it with new parts throughout, is every 26 months (2.2 years). Over time this strategy would minimise business-wide breakdown costs to about $8,000 per year with the least number of failures.

The necessary requirement is that the equipment is always replaced with new equipment, or totally rebuilt 'as good as new' and not mearly overhauled and returned to service. Overhauls mix old and new parts during the refurbishment and the old parts, already having had a prior life, failure prematurely. That is why overhauled equipment always fails sooner than new equipment in the same service. Complete 'as good as new' replacement ensures all parts start in a brand new condition with maximum operating life.

This equipment restoration/replacement optimization modelling tool was developed by Howard Witt, a professional reliability engineer with over 25 years hands-on industry experience, including nuclear facilities and industrial process plants.

View a PDF document showing the use of the Equipment Replacement Optimization Model
Plant and Equipment Replacement Optimization Model Example

View a PDF document of the first few pages from the User Guide for the Equipment Replacement Optimization Model
Extract of Equipment Replacement Optimization User Guide

100% Money Back, No Questions Asked Guarantee

If you are not satisfied with your purchase we will promptly and pleasantly refund your money in-full with no questions asked. And you can keep the purchase as compensation for the problems caused to you.

Disclaimer

Because it is unknowable how applications will be used, their Developer and Lifetime Reliability Solutions take no responsibility for correctly modelling the situation, or for the outcomes of using an application.

It is recommended that you understand well the theory behind the application you use, so you can confidently judge whether it applies to the situation under investigation and if its output is sufficiently accurate in the circumstances. Remember the warning that applies to all equipment replacement decision modelling methods — 'garbage in, garbage out'.