An Excel checklist for auditing one manufacturing process in depth, at the machine or cell, against its control plan, PFMEA and work instructions. Sixteen questions are pre-filled and grouped by process element. Mark each one C, NC, OFI or N/A, and the sheet counts results, flags the lines that need an action and works out the conformance percentage.
Tip: Start at the machine, not in the office. Pick a part in process and trace it backward to its material and forward to its inspection record; most gaps show up along that trail.
Header
Process, line or cell, part and revision, shift, date, auditor, process owner and document revisions used
Questions
16 pre-filled questions grouped as inputs, method, people, resources, measures and outputs, plus blank rows
Evidence and result
Requirement reference, evidence reviewed and the result: C, NC, OFI or N/A
Action needed
Calculated Yes for NC and OFI lines, with a finding number and owner
Summary
Counts of each result, conformance % and the number of actions to raise
Example Process audit at Example Precision Co., a fictional machine shop, of CNC turning cell 4 on day shift. The part, documents and results are invented for illustration.
| Process / cell | CNC turning, cell 4, day shift |
|---|---|
| Part / revision | SHF-118 rev B |
| Documents used | Control plan CP-118 rev C, PFMEA PF-118 rev B, WI-118 rev D |
| Auditor | Internal auditor from the assembly area (independent of the cell) |
| # | Element | Question | Evidence reviewed | Result |
|---|---|---|---|---|
| 1 | Inputs | Material matches the router (grade, heat lot)? | Heat number on the tag matches the cert | C |
| 2 | Inputs | Previous operation complete and signed off? | Traveler signed for op 10 | C |
| 3 | Method | Work instruction at the cell is current? | WI-118 rev D at the cell; master list shows rev D | C |
| 4 | Method | Setup sheet values match the machine? | Offsets and feeds match setup sheet | C |
| 5 | Method | Operator follows the WI sequence? | Observed one full cycle | C |
| 6 | Measures | Control plan checks done at the stated frequency? | Plan says OD every 10 parts; log shows 1 in 25 for two hours | NC |
| 7 | Measures | Gauges calibrated and the type the plan specifies? | Micrometer M-112 in calibration | C |
| 8 | Measures | SPC chart kept and out-of-control points acted on? | No SPC characteristic on this part | N/A |
| 9 | People | Operator trained on this WI? | Skills matrix shows trained | C |
| 10 | Resources | Preventive maintenance current for the machine? | Maintenance log: last PM within interval | C |
| 11 | Outputs | Good, suspect and scrap parts separated? | Labeled containers in use | C |
| 12 | Outputs | PFMEA reaction plan matches the one in use? | WI reaction plan more detailed than the PFMEA | OFI |
| C / NC / OFI / N/A | 9 / 1 / 1 / 1 |
|---|---|
| Conformance | 90.0% |
| Actions to raise | 2 (one corrective action, one improvement) |
| Field | What to enter | Example |
|---|---|---|
| Process / line / shift | One process, on one shift. Audit other shifts separately; they often run differently. | CNC turning, cell 4, day shift |
| Documents used | The revisions of the control plan, PFMEA and work instruction you audited against, so the result can be traced. | CP-118 rev C, PF-118 rev B, WI-118 rev D |
| Auditor | Someone who does not work in the process, so the audit is impartial. | Internal auditor from assembly |
| Process element | Inputs, method, people, resources, measures or outputs. Grouping questions this way makes sure every side of the process is covered. | Measures |
| Requirement / reference | The document and section the question tests, such as a control plan line or WI step. | CP-118 line 3 |
| Evidence reviewed | What you saw or sampled: record numbers, times, part counts. Required for every result, including C. | Log shows 1 in 25 for two hours |
| Result | C, NC, OFI or N/A, typed exactly. NC needs a requirement that was not met; OFI is a suggestion where the requirement is met. | NC |
| Action needed | Calculated: Yes for NC and OFI, No for C and N/A. Do not type over it. | Yes |
| Conformance % | Calculated: C ÷ (C + NC) × 100. OFI and N/A lines are left out. Use it to compare audits of the same process over time, not to grade operators. | 90.0% |
A process audit is an in-depth review of one process by a trained, independent auditor, usually on a schedule of months. A layered process audit is a short checklist done often, by people at several management levels, to confirm key controls every day or week.
A turtle diagram maps a process’s inputs, outputs, resources, people, methods and measures. You do not need one to use this checklist, but the questions follow the same elements, so a turtle diagram is a useful way to prepare.
A process audit checks how the work is done against the control plan and instructions. A product audit checks finished or in-process parts against their specifications. Both can be done in the same visit.
Conforming results divided by conforming plus nonconforming results, times 100. OFI and N/A lines are left out because they are not a pass or fail. In the Example, 9 ÷ 10 × 100 = 90.0%.
Anyone trained as an auditor who does not work in the process being audited. Knowing the manufacturing method helps, so many plants pair an auditor with an engineer from another area.
COPLAIN AI PLATFORM
When an audit shows operators working around an unclear instruction, Coplain’s Procedure Simplifier rewrites it into short, shop-floor-ready steps for you to review.
Generate yours automatically with Coplain →Related Tools & Templates