EAM analytics: compare maintenance costs and downtime

EAM analytics compares the maintenance cost, downtime, and availability of physical equipment using enterprise asset management exports. The useful question is which assets consume maintenance resources while failing to provide the hours the business needs. Read cost and operating time together, with each figure tied to its work orders or downtime records.

Set the scope before comparing assets

Start with a plant, an asset group, and a closed reporting period. Compare equipment with similar duties, production schedules, and cost definitions. A lightly used spare and a heavily used production press need different operating context even when their purchase descriptions match.

Keep planned and corrective work separate. The Department of Energy distinguishes reactive maintenance from time-based preventive maintenance. That distinction helps explain spending: a scheduled service and an emergency repair can have similar dollar costs but very different effects on production.

This review uses recorded work orders, costs, and downtime. It does not infer equipment condition or predict failures. For the broader set of reliability and backlog measures, use asset maintenance KPIs; here the job is to compare the cost and availability evidence already in the files.

Bring costs and time from separate records

The work-order export needs order ID, asset ID, work type, reporting date, labor cost, parts cost, outside-service cost, and status. Decide whether the period follows posting date or completion date. Posting date usually makes a spending reconciliation easier; completion date describes finished jobs. Keep the choice visible.

The time records need asset ID, scheduled production hours, and the start and end of each unavailable interval. Clip intervals at the reporting boundary. Merge overlapping intervals for the same asset before adding hours, so simultaneous work orders do not count the same stopped hour twice.

Use asset IDs to connect the records. Check unmatched IDs separately instead of attaching costs to an asset with a similar name. Keep the schedule at one row per asset and period; repeating scheduled hours on every order would inflate the denominator.

Agree on these measures:

Maintenance cost = Labor cost + Parts cost + Outside-service cost

Available scheduled hours = Scheduled hours − Maintenance downtime within those hours

Availability = Available scheduled hours / Scheduled hours

Maintenance cost per scheduled hour = Maintenance cost / Scheduled hours

This is maintenance-related availability within the stated schedule. Other causes of unavailability need their own recorded intervals if the business wants a wider operational measure.

A worked comparison at a US manufacturer

An illustrative Ohio manufacturer reviews two similar presses for September 2026. Each press was scheduled for 160 hours. All recorded maintenance outages below fall inside that schedule, do not overlap, and relate to the listed orders. Labor, parts, and outside services use the same posting-period basis.

First add each order's cost. WO101 is 800 + 400 + 0 = $1,200; WO102 is 2,400 + 1,800 + 600 = $4,800. WO103 is 1,200 + 600 + 0 = $1,800; WO104 is 600 + 300 + 300 = $1,200.

Then aggregate to the asset before calculating availability or cost per scheduled hour:

Press A's cost is 1,200 + 4,800 = $6,000. Its available time is 160 − 16 = 144 hours, and 144 / 160 = 90.0%. Press B's available time is 160 − 8 = 152 hours, giving 152 / 160 = 95.0%.

The combined availability is 296 / 320 = 92.5%. Cost per scheduled hour is 9,000 / 320 = $28.125, displayed as $28.13. Percentages are shown to one decimal place and dollar rates to two; calculations retain their unrounded values.

Prove the comparison before interpreting it

The cost check is 5,000 + 3,100 + 900 = $9,000, equal to the asset total of 6,000 + 3,000. Reconcile that amount to the included maintenance cost accounts, documenting any timing differences or excluded capital work. An order missing its final outside-service invoice should remain a visible incomplete-cost exception.

The time check is 296 available hours + 24 unavailable hours = 320 scheduled hours. Reconcile the unavailable intervals to the production log, including outages without a work order. A downtime dashboard can present the resulting trend, but a display cannot repair missing intervals.

Corrective orders cost 4,800 + 1,200 = $6,000, or 6,000 / 9,000 = 66.7% of maintenance spending. They account for 12 + 2 = 14 downtime hours, or 14 / 24 = 58.3% of maintenance downtime. The cost share and time share answer different questions; neither proves that all corrective work could have been prevented.

Turn the evidence into an owned decision

Press A deserves the first investigation: it has higher spending and lower availability on the same scheduled hours. The maintenance manager should inspect WO102, checking the failure description, parts availability, repair scope, and whether the problem recurred. Operations should confirm whether those unavailable hours constrained actual production.

Finance owns the cost boundary and ledger reconciliation. The maintenance planner owns order classifications and completeness. Operations owns the schedule and outage confirmation. Assign a named owner to the follow-up and review the same definitions next period.

Track actual results against the action expected to improve them. ENERGY STAR recommends recording equipment performance against expected performance, including procedures for addressing deficiencies. For a budget comparison, use cost variance alongside this review so spending changes have an explicit baseline.

Where it goes wrong

• Labor hours treated as downtime. Crew effort and elapsed equipment unavailability are different records.
• Overlapping orders added together. Several repairs during one outage do not create several separate blocks of lost production time.
• Schedule changes hidden. Availability can move because the required hours changed, even when the asset's stopped hours did not.
• Incomplete costs ranked as efficient. Open invoices, missing parts issues, or inconsistent overhead treatment can make an asset look cheaper.
• Downtime priced as lost sales. A stopped asset does not automatically create lost revenue. Capacity elsewhere, inventory, and customer demand affect the commercial consequence.

Compare your own EAM files in Covirage

Bring your work-order cost export, asset schedule, and prepared downtime records to Covirage; it maps the supplied columns, and its tools compute and check the comparisons. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.

See Covirage for industrial manufacturers for the wider operating review.