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.

Equipment Replacement Optimization Model Tool

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)
We accept MasterCardWe accept Visapaypal


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.


Equipment Replacement Optimization Model Example 1

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.



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


Making A Purchase

OPTION 1: Use the automated card payment system. Once you check-out and pay you receive a confirmation email listing the purchase details. We get a notification email of your purchase. After your payment is approved (which is usually immediately) you get an email with a link from where you can download your goods. YOU HAVE 24 HOURS TO DOWNLOAD YOUR PURCHASE. Please check if the download notification email goes to your junk mail folder. To use the automated payment system, just click the ADD TO CART button on each product page when you want to order. Click the VIEW CART button to see your full order or to check-out.

OPTION 2: If preferred, you can order manually. In which case the order will be processed and sent to you as an email attachment or a download link is provided once payment is approved. Please print-off the Product Order Form and complete it with your product choices then fax or post it to us. Payment options for manual ordering are explained on the order form and must be received prior to shipment.