To decide whether to repair or replace a machine, use its work orders to compare what each option will cost from today onward, over the same period and at the same required output. Estimate how many production hours you could still lose after the repair. That figure can change the answer. A work order that stayed open for two days may describe a stoppage that lasted only an hour.
Find the work orders for the right machine
Suppose a repair quote lands on your desk for a conveyor that has already held up the packing line. Gather a read-only export from your computerized maintenance management system (CMMS) or ERP, the line log, the repair quote and an installed replacement price. A spreadsheet is sufficient. Allow time for the maintenance lead and production supervisor to reconcile the records together.
- Match the asset. Filter by equipment or serial number. Two conveyors can share the same description. Keep the work-order numbers so someone else can check the source.
- Reconstruct each stoppage. Record when the line went down, when production resumed, the shifts affected, the work performed and any confirmed cause. Keep labour hours in a separate column. Two mechanics working for three hours book six labour hours.
- Check lost capacity. Use the production log to group orders linked to one interruption. Mark time the line was scheduled to run, work done outside the shift and any orders you made up later.
A CMMS can track scheduled and unscheduled work by asset and keep a searchable work-order history. Chapter 4 of the US Department of Energy’s guide describes these capabilities. Operations & Maintenance Best Practices Guide (PDF).
Turn work orders into lost production hours
Illustrative example. Over the past 24 months, the line log confirms three separate stoppages of 6, 8 and 10 production hours for the same conveyor. A fourth order records three hours of electrical work within the eight-hour stoppage. The total is 24 hours. Adding up all four entries would count part of that stoppage twice.
Paid invoices can help you estimate future maintenance. Leave those past payments out of both options. Ask the maintenance lead which fault the proposed repair addresses, which failures could recur and whether the machine now runs more shifts. Use a range if a return-to-service time is missing. Enter zero only when someone can confirm there was no production loss.
Price both options over the next 24 months
In this example either conveyor can meet the same production requirement. Each unrecoverable production hour costs the plant CAD 200 in contribution margin. If an order can be made up on overtime, use the additional cost of catching up. Charging both lost margin and recovery costs against the same units would overstate the loss.
| Cost item | Repair | Replace |
|---|---|---|
| Quoted work, including installation | $5,400 | $22,000 |
| Net proceeds from selling the old machine today | $0 | −$2,000 |
| Future maintenance | $3,600 | $1,600 |
| Expected lost production, including the changeover or repair | 24 h × $200 | 10 h × $200 |
| Estimated net resale value at month 24 | −$1,200 | −$10,000 |
| Net cost over 24 months | $12,600 | $13,600 |
The month-24 value belongs to the machine you would own at that point. It gives credit for its remaining useful life. Check the trade-in allowance, warranty, delivery date and parts availability. A quote that already includes a trade-in needs no second deduction for selling the old asset. The Treasury Board of Canada Secretariat sets out the cost categories and residual value in its estimating guide. Guideline on Cost Estimation for Capital Asset Acquisitions (PDF).
Find the break-even number of hours
The repair option costs $7,800 before lost production. To find when it reaches the $13,600 replacement total, calculate ($13,600 − $7,800) ÷ $200 = 29 hours. At 24 expected hours, repairing costs $1,000 less. At 29 hours the options tie. At 34 hours the repair option reaches $14,600 and replacement costs $1,000 less.
Test another assumption before placing the order. If the replacement machine would sell for $2,000 less at month 24, its net cost rises to $15,600 and the threshold moves to 39 hours. Record a source, date and owner for each estimate. After the decision, compare actual stoppages and invoices against the scenario you selected.
When the numbers cannot settle the decision
Have qualified maintenance staff confirm that a repair is technically acceptable and the machine can operate safely. An unavailable critical part, uncertain warranty coverage or delivery after peak season can rule out an option. The illustration assumes equal energy costs and constant dollars, with no discounting. For a longer horizon, different energy use or financing, ask your finance lead to include those differences and the timing of cash flows.
Connect maintenance records to the ERP
Give each stoppage an identifier and keep a link to its original work orders. Flag missing fields for the person reviewing the export. If your CMMS and ERP use different asset codes, a reviewed mapping keeps two similar machines apart. This is also a practical use for an integration that eliminates duplicate entry.
Where AI can help with handwritten or free-text notes
Once the notes are available as text, a tool can suggest consistent labels and show the source beside each suggestion. NIST’s Nestor project illustrates this kind of assisted annotation. To evaluate a pilot, use previously checked orders and measure time spent finding and correcting records, matches to the right asset and hours that remain unverified. Maintenance staff retain responsibility for the technical decision. NIST Nestor documentation.
Before approving the spend
- Match each stoppage to the right asset and combine overlapping intervals.
- Compare both quotes at the same required output and over the same period.
- Document the assumptions for maintenance, downtime and resale separately.
- Have a second person reproduce the threshold and confirm technical feasibility.
If your team has to reconcile the same work orders, invoices and line logs every month, Services Hamdi can help connect your maintenance and business systems.

