Sheets
6
Decision flow separated
Free Download
Equipment Repair or Replace Decision Analyzer
Consultation
We can help decide what should stay in Excel and what should move to a web system, based on site count, owners, dashboard needs, notification rules, and history tracking requirements. We can also adjust only the columns you actually need in your current workbook.
We can tune the columns to match your current workbook.
A free Excel template for comparing continued repair costs with replacement costs before a facility asset becomes a budget issue. The same page also shows the matching web system flow.
asset register
repair history
cost comparison
budget report
Decision
Repair or replace
Cost comparison
Output
Budget-ready
One-page report
Input example
Turn repair history into a replacement decision
The workbook compares repair cost rate, equipment age, downtime loss, and replacement cost so managers can decide with numbers.
Review date
2026-05-05
Asset
Main chiller CH-02
Indicator
Repair cost rate 34%
Recommendation
Plan replacement
Free Download
See what is inside the Excel version first
A free Excel template for comparing continued repair costs with replacement costs before a facility asset becomes a budget issue. Align parameters, owners, categories, and status rules before entering site data.
File
facility_management_equipment_repair_replace_lcc_template_en.xlsx
Sheets
9 sheets
Purpose
Asset register, scenario assumptions, lifecycle cost calculation, decision matrix, approval and execution tracking
Includes a dashboard, assumptions, scenarios, asset register, LCC calculation, decision matrix, scenario analysis, data dictionary, and approval tracking.
Calculates repair and replacement lifecycle cost from repair cost, downtime loss, energy difference, residual value, and budget limits.
Carries the final recommendation into budget, approval, procurement, downtime-window, acceptance, and closure tracking.
Align parameters, owners, categories, and status rules before entering site data.
How Excel is used
How repair or replace decisions work in Excel
The workbook is designed so source records, assumptions, analysis, dashboard, and report pages lead to a management decision.
Step 1
Register asset basics
Enter asset ID, category, start date, purchase cost, expected life, current replacement cost, and risk level.
Step 2
Import repair history
Add repair dates, cost, downtime hours, repeat failure flags, and production or service impact.
Step 3
Compare two options
Review continued repair cost, replacement cost, savings, residual value, and the decision ratio.
Step 4
Prepare the budget note
Use the one-page report to explain why the asset should be repaired, watched, or replaced.