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)
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.
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'.
LIFETIME RELIABILITY SOLUTIONS CONSULTANTS
Creators of the Enterprise Wellness Way to Business Excellence
Creators of the Accuracy Controlled Enterprise (ACE) 3T Quality Management System
Creators of the Plant Wellness Way to World Class Reliability and Operational Excellence
Providing World Wide, Independent, Licensed Maintenance Consulting, Enterprise Asset Management
Consultant, ISO 9001 Consultant, Lean Manufacturing and Lean Business Improvement Consulting Services