Quality Management Report: Defects, Cost, and Actions

A quality management report shows where defects are increasing, what scrap and rework cost, and which corrective actions remain unresolved. Build it from a common reporting cutoff, then reconcile the counts and dollars before ranking sites. The useful output is a short decision list backed by inspection and cost records.

Set the scope of the review

Use a monthly period for inspection and cost activity and a dated snapshot for open actions. The quality manager owns inspection definitions and action status; site operations owns process explanations; finance confirms the cost boundary. The broader management reporting package explains where this review fits beside financial and operating results.

Keep the report focused on exceptions rather than repeating every measure in the manufacturing KPI list. Define whether the population is all inspected units, a specific product family, or selected lots. An inspection sample is not automatically the entire site's production.

For the example below, scrap cost is the assigned cost of discarded units. Rework cost is additional labor and materials needed to bring accepted units into specification. These are selected internal failure costs, not the full cost of quality: prevention, inspection, warranty, and customer returns are outside this example.

Assemble the source rows

Export inspection ID, unit or lot ID, site, inspection date, inspected quantity, defective quantity, primary defect category, and final disposition. Add cost detail with transaction ID, period, site, defect reference, cost type, and amount. Keep the action register separate, with action ID, site, category, opened date, due date, owner, and status.

Summarize inspection and cost records before comparing them with actions. Joining every inspection to every related action can repeat both counts and costs. Preserve the detail that lets a reviewer move from a site total to the underlying records.

Work the defect and cost comparison

An illustrative Ohio component manufacturer reviews September 2026. Each defective unit below has one primary category and one final disposition: scrapped or successfully reworked. No unit is awaiting disposition at the cutoff.

Place the table headers in row 1, with site in A and combined cost in H. In H2, fill down:

=F2+G2

On a site summary sheet, with the site name in A2, aggregate combined cost:

=SUMIFS(Detail!$H$2:$H$5,Detail!$A$2:$A$5,A2)

Microsoft documents SUMIFS as summing rows that meet specified criteria. Both sites have $2,700 of combined cost, but the category mix differs. That distinction determines which process owner should investigate.

Add the inspection denominator and prior period before judging performance:

| Site | August inspected | August defective | September inspected | September defective | August rate | September rate | Change (percentage points) | |---|---:|---:|---:|---:|---:|---:|---:|---:| | Cleveland | 4,000 | 80 | 4,000 | 100 | 2.00% | 2.50% | +0.50 | | Toledo | 6,000 | 90 | 6,000 | 100 | 1.50% | 1.67% | +0.17 | | Total | 10,000 | 170 | 10,000 | 200 | 1.70% | 2.00% | +0.30 |

With these columns in A:H, enter the following in F2:H2 and fill down:

=C2/B2
=E2/D2
=(G2-F2)*100

Format F and G as percentages. Display rates and percentage-point changes to two decimals, retaining unrounded calculations. The company rate is 200 / 10,000 = 2.00%; averaging site percentages would give the smaller inspection population too much weight.

Attach the unresolved actions

Use September 30, 2026, as the cutoff. The following register contains all open actions in this example.

Put the cutoff in J1 as =DATE(2026,9,30). With opened date in C and due date in D, the age and overdue formulas are:

=$J$1-C2
=MAX(0,$J$1-D2)

These formulas apply to this open-action snapshot; report missing dates separately. Do not substitute today's date when rebuilding a historical report.

Cleveland's dimension defects and overdue CA-11 belong in the same management discussion. Toledo's finish costs and overdue CA-13 warrant a separate review. Neither association proves the cause of a defect. NIST's process-improvement guidance describes quality improvement in terms of identifying and removing causes of defects; the report identifies where that investigation should start.

If an action requires a separate capital project, put its schedule and spending in the project management report, while keeping the quality evidence here.

Reconcile before issuing the report

The disposition check is 120 scrapped + 80 reworked = 200 defective units. Category totals must equal the distinct affected-unit population under the stated primary-category rule. Cost checks are 3,600 + 1,800 = $5,400 and 2,700 + 2,700 = $5,400.

Tie the cost total to the selected ledger accounts or document the bridge from operational estimates. Invoice timing can differ from the inspection month; the accrual versus cash guide explains that period distinction. Confirm each overdue action is still open and assign its decision to a named owner.

Where it goes wrong

• Counting observations as units. Several defects on one item inflate the defective-unit rate unless the unit is counted once.
• Adding rework twice. Separate incremental rework cost from the original unit cost carried into inventory.
• Changing inspection coverage. More intensive inspection can change observed rates without a comparable change in the underlying process.
• Closing an action without evidence. Administrative completion and a sustained process improvement are different findings.

Covirage is not affiliated with Microsoft.

Review your quality exports in Covirage

Bring your inspection export, scrap and rework cost detail, and dated action register. 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.