Production dashboard template: metrics and checks

A production dashboard template gives you a repeatable workbook for output, downtime, scrap, and target attainment from production exports. Separate the imported records from formulas and summary cells so a reviewer can trace each result back to the run that produced it. The layout below can be copied into your workbook; it is not a downloadable file.

Set up the workbook tabs

Use distinct sheets for inputs, definitions, summaries, and checks. That separation makes a corrected production record visible without overwriting the calculations built around it.

This is a production workbook rather than a complete plant management report. Use the manufacturing dashboard template when you need the wider plant review. The production dashboards guide explains how to interpret production comparisons once the workbook reconciles.

Copy the input column layout

On Runs, place these headers in row 1. The example uses one US plant, one line, and one product measured in individual components. Both runs took place on October 21, 2026. Each completed component has a final disposition of good or scrap.

Keep source file names and export timestamps in the Definitions sheet. Preserve original run IDs even if the workbook also uses a readable description. When a run spans shifts, split both its production and planned time using an agreed rule; copying the full run into both shifts duplicates it.

If stops arrive as individual events, total their nonoverlapping minutes by run before filling column I. If targets are daily line targets, allocate them to runs once or summarize production to the daily line level. Never attach the full daily target to every run.

Add the calculation columns

Place these headers in M:R. Enter the expression beginning with = in row 2 and copy it to each production row.

Format O:Q as percentages with one decimal place. Keep full precision in the cells. A zero denominator produces an unavailable result here so a missing target or unscheduled period is reviewed rather than reported as successful performance.

In Excel, a table can carry formulas to new records and use column names in formulas. Microsoft's structured-reference documentation explains that table references adjust when rows are added or removed. For a table named Production, the good-units formula would be =[@[Total units]]-[@[Scrap units]].

The M formula assumes all units are good or scrap. Add separate rework and hold columns if the real export requires them; agree whether good means first-pass accepted or eventually accepted before modifying the calculations.

Build a summary that divides totals

The summary should first show the inputs that explain its rates. The example totals are:

Use these summary formulas for the displayed example:

=SUM(Runs!M2:M3)/SUM(Runs!L2:L3)
=SUM(Runs!K2:K3)/SUM(Runs!J2:J3)
=SUM(Runs!I2:I3)/SUM(Runs!H2:H3)

For a plant selected in B1 on the Summary sheet, good units can be filtered with:

=SUMIFS(Runs!M2:M3,Runs!C2:C3,B1)

Microsoft documents SUMIFS for sums subject to criteria. Apply identical criteria to target units before dividing. For a larger workbook, add date, line, and unit criteria to every measure and extend the ranges consistently. Covirage is not affiliated with Microsoft.

If you add a production share column, label its denominator explicitly. A line's share of company output does not measure whether it reached its own production target.

Complete the Checks sheet

The disposition check is 1502 + 58 − 1560 = 0 units. The time check is 790 + 110 − 900 = 0 minutes. Both are exact; percentage rounding has no role in these checks.

These identities confirm internal consistency because good units and run time were calculated by subtraction. They do not independently prove the imported numbers. Tie total output to the production register, scrap to the quality disposition export, planned minutes to the approved schedule, and stop totals to the event register.

Check each Run ID for duplicates. Confirm every expected shift appears, including shifts with no output. Flag blank quantities separately from numeric zero. Keep a visible exception list and resolve it before using the summary in an operating review. The OEE dashboard method adds ideal-cycle-time checks when equipment effectiveness is the next question.

Where it goes wrong

• Pasting over formulas. Keep the input and calculation columns visually separate, and protect calculation cells when sharing the workbook.
• Averaging the rate columns. Rebuild each summary rate from its summed numerator and denominator.
• Adding daily targets to every run. Align the target record with the production grain before calculating attainment.
• Treating blanks as zero. Missing scrap or downtime means an incomplete record until the source owner confirms otherwise.
• Using corrected targets without a version. Preserve the approved schedule and document any authorized correction so comparisons remain explainable.

Check your production workbook in Covirage

Bring a sample of your own production workbook or Google Sheet: Covirage maps the columns, and its tools compute and check the output, downtime, scrap, and target figures. 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 your file.

See Covirage's Excel analysis approach for the supporting workflow.