Maintenance Dashboard: Downtime, Backlog, and Cost

A maintenance dashboard compares recorded asset downtime, open work orders, and maintenance costs at a stated cutoff. Build it from the work-order export you already have, then reconcile the figures before deciding which assets need attention. Keep period activity separate from the unfinished work present at the cutoff.

Set the period and the backlog date

Use a retrospective export for this review. A maintenance manager needs to answer different questions: what disruption and spending occurred during the period, and what work remains at its end?

For the example below, a US manufacturer's activity period is October 1 through October 23, 2026. Status and remaining hours are measured at the end of October 23. Orders opened before October remain eligible for backlog; an old opening date is no reason to exclude unfinished work.

The Department of Energy's maintenance guidance explains how maintenance KPIs help identify areas for improvement. Choose measures around the decision you need to make, rather than displaying every available field.

Prepare an export with consistent rows

Use one row per work order after consolidating its cost transactions. Preserve the order ID and asset ID so the summary can be traced back. If an order has several cost lines, sum them first and attach its downtime only once.

Columns A through I contain the following data. Downtime and costs cover only the activity period; remaining hours are estimates at the cutoff. The example has no overlapping outage intervals for the same asset, and all open orders remain eligible for scheduling.

A zero means the value was confirmed as zero. Leave missing costs flagged for review rather than quietly replacing them with zeros. Keep canceled work outside this table, and document the exclusion.

Calculate cost and open-order age

These formulas work in Excel and Google Sheets with US locale settings. Put total period cost in J2 and copy down through J7:

=SUM(F2:H2)

Set M1 to the cutoff using =DATE(2026,10,23). Put open-order age in K2 and copy down:

=IF(C2="Open",$M$1-D2,"")

The open orders are 13, 24, and 2 calendar days old. Age describes how long each order has been open; it does not tell you whether work is overdue. That requires its agreed due date or priority rule.

Keep imported values and calculations in the same workbook for this method. Microsoft documents a closed-workbook reference limitation affecting conditional sum and count functions in Excel.

Summarize the assets

Put an asset name, such as Press, in N2. Calculate its downtime with:

=SUMIFS($E$2:$E$7,$B$2:$B$7,N2)

Its open-order count is:

=COUNTIFS($B$2:$B$7,N2,$C$2:$C$7,"Open")

Its remaining hours and period cost are:

=SUMIFS($I$2:$I$7,$B$2:$B$7,N2,$C$2:$C$7,"Open")
=SUMIFS($J$2:$J$7,$B$2:$B$7,N2)

Google's documentation describes SUMIFS as a conditional sum and COUNTIFS as a count meeting multiple criteria. Keep the criteria ranges aligned with the rows being summed or counted.

All values are exact; no rounding is needed. The press has the most recorded downtime, while the conveyor has the largest remaining workload. Equal work-order counts conceal that difference.

For presentation in an existing reporting environment, see the Power BI maintenance dashboard. The calculation definitions should remain consistent across displays.

Prove the totals before the review

The asset costs must equal the source cost components: labor of $1,520 plus parts of $2,030 plus contractors of $800 equals $4,350. The order population also reconciles: 3 closed plus 3 open equals 6 exported orders. Remaining hours are 5 + 9 + 6 = 20.

Tie cost components to the corresponding ledger or maintenance cost report on the same posting basis. Tie downtime to the approved incident records. Summing across assets gives asset-hours; simultaneous stoppages on different machines do not establish the production line's elapsed downtime.

Assign the maintenance manager the backlog review and finance the cost reconciliation. If an existing dashboard already supplies the visuals, consider analytics alongside existing BI; responsibility for maintaining definitions still needs an owner, as explained in managed analytics or self-service SaaS.

Where it goes wrong

• Current status applied to an old cutoff. A job closed later must remain open in the earlier snapshot.
• Labor hours treated as downtime. Several technicians can work during the same outage; their combined effort is a different measure.
• Duplicate outage records. Multiple work orders covering the same asset stoppage can overstate downtime.
• Lifetime costs mixed with period costs. An old order can belong in backlog without bringing its earlier spending into this month's total.

Covirage is not affiliated with Microsoft or Google.

Review your maintenance export in Covirage

Upload your work-order file or Google Sheet with the reporting period and cutoff clearly identified. Covirage maps the columns, its tools compute and check the figures, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own export.

See Covirage for industrial manufacturers for the supporting industry context.