Manufacturing dashboard template: inputs and KPI checks

A manufacturing dashboard template compares each plant's accepted output with its approved target, then shows the scrap and downtime behind the result. Build it around a fixed reporting period and a shared unit definition. The layout below is a workbook specification you can reproduce in your own spreadsheet.

Set up the workbook around the plant review

Use separate worksheets for definitions, targets, operating records, and the review. The definitions sheet records what counts as production, accepted output, scrap, scheduled time, and downtime. It also names the owners of those definitions.

This page focuses on the plant workbook. The broader manufacturing dashboard guide covers how to choose the review questions, while the production dashboard template covers the production-level layout.

Keep output and quality together. NIST describes the manufacturing decision objective as minimizing downtime while maintaining or maximizing production quality. A workbook that rewards volume alone can miss the scrap needed to achieve it.

Copy these input columns

An illustrative US components company reviews the week ending October 16, 2026. Ohio and Indiana make the same standard component, measured in individual pieces. This example has no work in process or unresolved quality holds at the cutoff, so every produced unit is either accepted or scrapped.

Use these columns in the Review sheet. Targets refer to accepted units, rather than gross units produced.

Put Ohio on row 2 and Indiana on row 3. Keep plant identifiers as text and minute fields as numbers. If your export records hours, convert the entire field to minutes before combining it with minute-based records.

Match targets using plant, week, and product group. Never match on plant alone when several periods are present. If operating detail contains multiple shifts, aggregate it to the target's grain first; otherwise the weekly target will repeat against every shift.

Add the formulas beside the inputs

The following formulas use the column positions above. Fill row 2 down to row 3. Blank rates deliberately indicate an absent or nonpositive denominator; an input check should flag that condition for review.

Format K through M as percentages. Keep unit and time differences as signed numbers. A negative variance means accepted output is below plan; a positive reconciliation difference means some units or minutes have not been explained.

The scrap denominator here is gross units produced. It differs from an inspection failure rate, whose numerator includes every failed unit whether reworked or scrapped. NIST's definition of proportion nonconforming counts nonconforming items against the relevant population; the numerator and population must match the question being answered.

Read the worked review

Rates below are rounded to two decimal places after calculating from the original inputs.

Ohio's calculations are 9,600 − 10,000 = −400 accepted units, 9,600 / 10,000 = 96.00% attainment, 200 / 9,800 = 2.04% scrap, and 96 / 960 = 10.00% downtime. Indiana uses the same formulas: 7,200 − 8,000 = −800, 7,200 / 8,000 = 90.00%, 400 / 7,600 = 5.26%, and 144 / 960 = 15.00%.

The combined row sums the inputs first:

Combined attainment is 16,800 / 18,000 = 93.33%; scrap is 600 / 17,400 = 3.45%; downtime is 240 / 1,920 = 12.50%. Do not average the displayed plant percentages.

Complete the checks before assigning causes

The count check is 17,400 produced = 16,800 accepted + 600 scrapped. The time check is 1,920 scheduled = 240 downtime + 1,680 running minutes. Because accepted units and running minutes come from independent records, these checks can expose missing dispositions or overlapping time.

Reconcile the source worksheet totals before and after matching targets. A match that multiplies a production row can still generate plausible percentages while doubling counts. Compare the distinct plant-period keys with the approved review scope and inspect unmatched records explicitly.

Indiana has the larger output shortfall and higher scrap and downtime rates. Those facts justify reviewing its scrap reasons and downtime events first. They do not prove that downtime caused the whole shortfall: the workbook does not yet include product speed, staffing, or material shortages. Add those supporting records only when needed for the decision. The manufacturing KPI template covers a broader measure set.

Where it goes wrong

• Gross targets against accepted output. Make the target and actual use the same definition before calculating attainment.
• Mixed product units. Keep unlike items in separate groups unless there is an approved conversion basis.
• Overlapping downtime. An equipment event and a line event may describe the same lost minutes. Count the review unit's time once.
• Unfinished dispositions. If holds or work in process exist, add them to the count reconciliation instead of forcing them into scrap.
• Changing the schedule after the event. Preserve the calendar and target versions used for the review so the denominator remains auditable.

Analyze your plant workbook in Covirage

Bring the workbook with its approved targets, production dispositions, and time records to Covirage. Covirage maps the columns; its tools compute and check the figures, and the external AI model explains the differences with every figure traced to its rows. Create a free Covirage account, set up your business, and bring a sample of your own data.

See Covirage for industrial manufacturers for related manufacturing analysis.