# Process Flow Diagram Worksheet

> Source: https://netray.co/tools/process-flow-diagram-worksheet-excel
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Tabulate each process step with symbol type, equipment, characteristics and cycle time ahead of PFMEA and control plan work.

## Category

quality

## Audience

- Process engineer
- Quality engineer
- Manufacturing engineer

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Op no.

**Key:** op

**Type:** text

#### Operation description

**Key:** desc

**Type:** text

#### Step type

**Key:** type

**Type:** select

**Options:**

- Operation
- Inspection
- Transport
- Delay
- Storage
- Rework

#### Machine / equipment

**Key:** equip

**Type:** text

#### Input / material

**Key:** input

**Type:** text

#### Output / product characteristic

**Key:** output

**Type:** text

#### Special characteristic

**Key:** special

**Type:** select

**Options:**

- None
- Critical
- Significant

#### Cycle time (s)

**Key:** ct

**Type:** number

#### Wait / queue (min)

**Key:** wait

**Type:** number

#### Cycle (min)

**Key:** cycle_min

**Type:** number

**Expr:** ct / 60

**Format:** decimal

**Rows:**

**Op:** 10

**Desc:** Receive and inspect bar stock

**Type:** Inspection

**Equip:** Receiving bench

**Input:** Steel bar 40 mm

**Output:** Material certificate matches

**Special:** None

**Ct:** 120

**Wait:** 240

**Op:** 20

**Desc:** CNC turn outer diameter and bore

**Type:** Operation

**Equip:** Lathe L-04

**Input:** Cut blank

**Output:** Bore diameter

**Special:** Critical

**Ct:** 95

**Wait:** 60

**Op:** 30

**Desc:** Deburr cross holes

**Type:** Operation

**Equip:** Deburr cell

**Input:** Turned part

**Output:** Burr-free cross holes

**Special:** None

**Ct:** 40

**Wait:** 30

**Op:** 40

**Desc:** Wash and dry

**Type:** Operation

**Equip:** Wash line

**Input:** Deburred part

**Output:** Cleanliness level

**Special:** Significant

**Ct:** 60

**Wait:** 20

**Op:** 50

**Desc:** Final inspection and pack

**Type:** Inspection

**Equip:** CMM and pack bench

**Input:** Clean part

**Output:** Dimensions per drawing

**Special:** None

**Ct:** 150

**Wait:** 45

**Totals:**

#### Total cycle time (s)

**Key:** ct

**Agg:** sum

**Format:** integer

#### Total wait (min)

**Key:** wait

**Agg:** sum

**Format:** integer

#### Steps

**Key:** op

**Agg:** count

**Format:** integer

**Summary:**

#### Touch time (min)

**Key:** touch_min

**Expr:** sum_ct / 60

**Format:** decimal

#### Touch plus wait (min)

**Key:** lead_min

**Expr:** sum_ct / 60 + sum_wait

**Format:** decimal

**Description:** Rough lead time through the steps listed.

#### Touch time share of lead time

**Key:** value_ratio

**Expr:** if(gt(sum_ct / 60 + sum_wait, 0), (sum_ct / 60) / (sum_ct / 60 + sum_wait) * 100, 0)

**Format:** percent

**Notes:** Number steps to match the routing and PFMEA operation numbers. Mark special characteristics so they flow to the control plan. Cycle times are per piece in this sheet.

## Content

**Intro:** A process flow diagram is the starting point for a PFMEA and control plan: it lists every step from receiving to shipping. This worksheet captures the same information as a table, adds cycle and wait times, and exports to Excel so you can feed the rest of your APQP package.

**Sections:**

#### How to use the worksheet

**Body:** List each step in the order the product moves, including inspections, transport, waiting and rework loops. Classify each step, name the machine, the input and the product characteristic created. Mark special characteristics so they carry into the PFMEA and control plan. Enter cycle time per piece in seconds and the typical wait before the step in minutes. The summary shows total touch time, rough lead time and the share of time the product is being worked.

**Bullets:**

- Include rework and scrap paths, not only the ideal flow
- Use the same operation numbers as your routing
- Show outsourced steps such as heat treatment or plating
- Record the characteristic produced at each step

#### Why the flow comes first

**Body:** A PFMEA rates failure modes for each process step, so an incomplete flow means missing risks. Teams that start the PFMEA from memory usually forget transport damage, storage conditions or rework operations. Customers reviewing a PPAP package also expect the flow, PFMEA and control plan to match step for step. Build and walk the flow on the shop floor before the workshop, with an operator present.

#### Reading the result

**Body:** The touch time share shows how much of the lead time is value-adding work and how much is waiting. Low percentages point to queue and batching problems rather than machine speed. Look at the steps with the longest waits, the special characteristics and any step with many incoming inputs, because these often hide the biggest risks. Use the numbers as a rough map, not a replacement for a proper time study.

#### Common mistakes and ERP links

**Body:** Frequent errors are drawing the intended flow instead of the actual one, merging many operations into one box, and not revising the flow after a change. Compare the worksheet with the ERP routing: any step on the floor that is not in the routing is a data gap, and any routing step that nobody performs is clutter. Keep revision control so the PFMEA and control plan always reference the current flow.

**Cta:** If you want to compare shop-floor flow against ERP routings automatically, Netray can discuss a read-only review. This worksheet works on its own.

**Faq:**

#### Is a process flow diagram required for PPAP?

**Answer:** Yes. A process flow diagram is one of the standard PPAP elements, and customers expect it to match the PFMEA and control plan. It can be a drawn diagram or a clear tabular flow like this worksheet.

#### Should I include inspection steps?

**Answer:** Yes. Inspections, tests, transport, storage and rework loops are part of the process and each can introduce or catch defects, so they belong in the flow and the PFMEA.

#### What symbols should I use?

**Answer:** There is no mandatory set. Many teams use operation, inspection, transport, delay and storage symbols. This worksheet records the same idea in the step type column.

#### Can I draw the diagram from this table?

**Answer:** Export to Excel or PDF and use the rows to build a visual flow in your diagram tool. The table keeps the data consistent while the picture is a presentation.

## Search terms

process flow diagram template, process flow chart manufacturing template, apqp process flow diagram, process flow diagram excel, pfmea process flow, process flow worksheet, manufacturing process flow example, ppap process flow diagram

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json