Production Reports for Management: Plan vs Actual

Production reports for management compare the approved output plan with good units, scrap, downtime, and cost by line or shift. Start with the plan and production export, then reconcile physical quantities before explaining a missed target. Add spending and operating time so management can see which exception needs attention.

Define the report's unit and cutoff

Use the same product unit across planned and actual output. Cases, pounds, and individual pieces cannot be added together without a documented conversion. State whether good units mean units accepted at final inspection, packed units, or shipments; this example uses final accepted units.

Freeze the approved plan version before the period starts. Preserve later revisions separately so the report does not erase a missed target by replacing the baseline with actual output.

This article assembles and checks the management deliverable. The manufacturing KPI list covers measure definitions, while the manufacturing dashboard covers the recurring visual layout. The report adds the reconciled exception and the decision behind it.

Bring the exports together

Use production date, shift ID, line ID, product ID, work-order ID, planned quantity, accepted quantity, scrap quantity, and unfinished quantity. Bring a separate time log with scheduled minutes and downtime intervals, plus cost detail with posting period, cost center, work-order reference, account, amount, and document ID.

Agree a shift boundary before grouping records. An overnight shift belongs to one stated production date. A finished unit passing through several work centers contributes once to finished output, even though its labor and processing records appear in several places.

Summarize the plan, quantity, time, and cost records to the same line-shift grain before combining totals. Repeating a shift's total cost beside every downtime event would multiply the spending figure.

A worked line-and-shift report

An illustrative US packaging plant reviews three runs producing the same unit. The plan contains all units released for these runs. There is no opening work in process, unplanned production, or transfer between runs; unfinished units include work not yet started or accepted at the cutoff.

The budget is the approved cost for the planned runs, not a budget adjusted to actual volume. Actual cost includes the defined labor, materials, and conversion expenses for those runs. It is a management cost comparison, not a calculation of inventory value.

With headers in row 1 and the run in A, add the following in J2:N2 and fill down:

=C2-B2
=B2-C2-D2-E2
=F2-G2
=I2-H2
=IF(C2=0,"No good units",I2/C2)

The columns are output variance, quantity reconciliation difference, running minutes, spending variance, and cost per good unit. A negative output variance means a shortfall; a positive spending variance means spending above budget.

Costs per good unit are rounded to two decimals after calculation. The total is 28,000 / 2,630 = $10.65, calculated from totals rather than an average of the displayed shift ratios.

To summarize actual cost by line from a cost sheet with line in B and amount in E, put the desired line name in Q2:

=SUMIFS(Costs!$E$2:$E$1000,Costs!$B$2:$B$1000,Q2)

Microsoft's SUMIFS documentation explains how matching criteria select rows for summation. Apply the same period boundary to the cost export before using this formula.

Prove the totals before interpreting them

The physical check is 2,630 good + 90 scrap + 80 unfinished = 2,800 planned units. The good-unit shortfall is 2,800 - 2,630 = 170 units, explained by 90 scrap + 80 unfinished. In a real plant with opening work in process or unplanned output, add those movements explicitly instead of forcing this simplified identity.

The time check is 1,300 running + 140 downtime = 1,440 scheduled minutes. Downtime must contain only intervals inside scheduled time, and overlapping stops must be counted once. Parallel equipment time cannot be added to line time unless the report clearly uses equipment-minutes.

The spending check is 28,000 - 27,200 = $800 above budget. Tie actual cost to the selected ledger or job-cost accounts and retain a bridge for missing postings. The accrual versus cash guide explains why paid invoices alone do not establish the period's cost.

Turn the exceptions into management decisions

Line A's night shift has the largest good-unit shortfall, downtime, and spending variance in this example. Review its stop records, scrap reasons, staffing, and product conditions before assigning a cause. Downtime minutes alone do not establish how many units a stop prevented; that requires a valid production-rate assumption.

NIST describes value stream mapping as a way to uncover waste and diagnose process problems. Use the report to select the area for investigation, then examine that process rather than assuming the shift with the weakest result has the weakest team.

Give each major exception an owner, a proposed action, and a decision date. The management reporting guide explains how to place that decision beside the broader monthly results. If a building or service constraint is involved, link the supporting facility management report.

Where it goes wrong

• Mixing units. Report unlike products separately or use a documented conversion before aggregating quantities.
• Counting rework as new output. Track a unit's final disposition once; rework activity belongs in separate effort and cost records.
• Ignoring late cost postings. An apparently inexpensive shift can simply have incomplete labor or materials charges.
• Treating budget variance as efficiency. A fixed budget against lower output does not isolate price, volume, or usage effects.

Covirage is not affiliated with Microsoft.

Build the review from your own production files

Bring your frozen plan, production quantities, downtime log, and cost export. Covirage maps the 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 manufacturing context.