Manufacturing dashboard: output, downtime, and cost

A manufacturing dashboard compares plant output, downtime, scrap, and production cost with the operating plan. Build a periodic view from completed exports and preserve the records behind each result. The aim is to identify which line needs investigation and who owns the next action.

Define the production scope

Choose one period and a comparable unit of output. Finished units work when the products require similar effort; mixed products may need separate families or an agreed equivalent-unit definition. Do not add unlike pieces and interpret the total as a productivity measure.

Set the time boundary before calculating downtime. In this example, scheduled minutes mean planned production time, and recorded downtime is the stopped time within that schedule. Planned exclusions have already been removed from scheduled time. A different definition can work, but the numerator must remain inside its stated denominator.

Keep product quality monitoring separate from the operating target comparison. NIST's control-chart guidance discusses control limits and patterns used to investigate process behavior. A dashboard target records an operating commitment; it is not a statistically estimated control limit. Use the manufacturing SPC dashboard guide for that neighboring question.

Assemble compatible exports

Ask production for processed and good units by line and shift, quality for final scrap disposition, maintenance for stopped minutes and causes, and finance for production costs. Use the approved plan for good output and spending. Retain period, plant, line, and product identifiers in each file.

Avoid combining raw detailed files in a way that repeats amounts. Several downtime events can belong to one production shift, while several cost entries can belong to the same line. Summarize each file to the agreed review level before comparing totals. Check that no production amount is multiplied by the number of maintenance events.

The manufacturing dashboard template covers the reusable layout. Here the emphasis is the calculation from completed operating records.

Work one plant review from its rows

A US components manufacturer reviews a completed production day. Both lines make comparable units, all units have a final disposition, and no rework remains unresolved. Production cost includes the same defined direct and allocated manufacturing costs on both lines.

Put these columns in A through I, with a header in row 1 and data in rows 2 and 3:

The following Google Sheets formulas use the displayed columns. Output attainment in J2, scrap rate in K2, downtime rate in L2, and cost per good unit in M2 are:

=IFERROR(C2/H2,"No output plan")
=IFERROR(D2/B2,"No processed units")
=IFERROR(F2/E2,"No scheduled time")
=IFERROR(G2/C2,"No good output")

Fill down for line B. Google documents IFERROR as returning an alternative when a calculation errors. Here text preserves the distinction between an undefined ratio and a genuine zero; investigate other source errors before presenting the results.

For a larger file, total line A production cost using the line identifier in A and cost in G:

=SUMIFS($G$2:$G$1000,$A$2:$A$1000,"A")

SUMIFS applies criteria to the rows being summed. Apply the same period and plant selection to each measure when your file contains more than this day's records.

Covirage is not affiliated with Google or Microsoft.

Compare actual output with plan

Calculate the plant ratios from summed amounts rather than averages of line rates:

=SUM(C2:C3)/SUM(H2:H3)
=SUM(D2:D3)/SUM(B2:B3)
=SUM(F2:F3)/SUM(E2:E3)
=SUM(G2:G3)/SUM(C2:C3)

Rates and unit costs are rounded to two decimals after calculation. The plant produced 1,670 / 1,800 = 92.78% of planned good output. Spending is $2,700 below plan, but output also fell. Line B's cost per good unit is $21.25 against its planned $20.00, despite its lower total spending.

That makes line B the first operating investigation: inspect the downtime causes and scrap disposition rows together. The table does not prove that downtime caused scrap or that either caused the cost variance. Product sequence, labor allocation, and maintenance activity may also matter.

Prove the figures and assign the follow-up

First, reconcile physical output. Line A has 950 good plus 50 scrap units, matching 1,000 processed; line B has 720 plus 80, matching 800. Plant good units plus scrap are 1,670 + 130 = 1,800. This identity applies because the example has no unresolved work or rework.

Next, reconcile time. Line A has 480 − 60 = 420 running minutes and line B has 480 − 120 = 360. Together, 780 running minutes plus 180 downtime minutes equal 960 scheduled minutes. Overlapping downtime events must be resolved before adding durations.

Finally, tie $33,300 of production cost to the included cost-center accounts and their allocation policy. Production owns output, quality owns dispositions, maintenance owns stop causes, and finance owns the cost tie. The plant manager agrees the action and review date after these owners validate their records.

Use the manufacturing article collection for related business questions beyond this plant review.

Where it goes wrong

• Scrap counted twice. A rejected unit appears both as final scrap and as rework in progress. Keep final dispositions explicit.
• Downtime outside the denominator. Stops outside scheduled production inflate the rate unless the schedule definition includes that time.
• Unlike output added together. Product mix can move unit costs even when each process is unchanged.
• Lower spending called efficiency. Review cost per good unit and output attainment alongside the spending variance.
• Incomplete shifts compared with full plans. Match the source cutoff to the planned period before assigning an exception.

Review your plant exports in Covirage

Bring your completed production, quality, downtime, and cost files with compatible line and period identifiers. Covirage maps the columns, and its tools compute and check the figures; 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 data.

See Covirage for industrial manufacturers for the supporting industry context.