# Internal or External PPM form or template wanted

#### Marc

##### Fully vaccinated are you?
Are you looking for a formula for a spreadsheet or an entire generic spreadsheet?

D

#### dbzman

I also need this. I have been asked to develop PPM KPI for my facility. I have never used the PPM method. I have always looked at %.

I was looking at using work orders and determining how many we have that are defective. It is hard to use parts since we batch process the parts. Work orders would be more appropriate.

Thanks!

#### E Wall

##### Just Me!
Trusted Information Resource
I was looking at using work orders and determining how many we have that are defective. It is hard to use parts since we batch process the parts. Work orders would be more appropriate.
It's simple math to calculate: Defective Qty / produced = % x 1,000,000

If you use batch numbers, you would then have to indicate the entire batch as an issue. For example say each batch represents 25,000 parts and you have produced 500,000 parts in whatever period you're covering. Then lets presume you have 5 defective parts total ocurring in all produced but they only ocurred from two of the batches.

If you calculate by parts PPM = 10; however if calculate by batch PPM = 100,000

if you break out by batch:
2 of 25,000 is PPM = 80 (and 3 defects would be 120) but this is an incomplete picture of total production unless you point to two batches out of 20 which would look really bad (numerically). We have a customer that expects the PPM for their products to be less than 50 which equates to failure rate of 0.005%.

Last edited:
D

#### dbzman

It's simple math to calculate: Defective Qty / produced = % x 1,000,000

If you use batch numbers, you would then have to indicate the entire batch as an issue. For example say each batch represents 25,000 parts and you have produced 500,000 parts in whatever period you're covering. Then lets presume you have 5 defective parts total ocurring in all produced but they only ocurred from two of the batches.

If you calculate by parts PPM = 10; however if calculate by batch PPM = 100,000
if you break out by batch:
2 of 25,000 is PPM = 80 (and 3 defects would be 120) but this is an incomplete picture of total production unless you point to two batches out of 20 which would look really bad (numerically). We have a customer that expects the PPM for their products to be less than 50 which equates to failure rate of 0.005%.

We will have anywhere from 500 to a 1,000 invoices per month. Say that the average batch per invoice is 2, since the number of batches per invoice can vary. That gives us a maximum of 2,000 batches. I cannot say how many parts are in each batch because it varies from 1 to a few hundred; depending on the part size and weight per customer.
Each batch of parts are put into a furnace and processed. If we have a batch that has even one defective tested the total batch is rejected. Using parts as a measure would also be misleading since we could have two parts in one batch for a customer versus 200 parts in another batch for a different customer. Rework/defective is determined by the batch.
Batch/Total Batches = % X 1,000,000
If we process 2,000 batches per month and have 7 batches rejected we would have 3,500 PPM rejected. A large number compared to what I have seen in other posts.

A little confusing for me.

#### E Wall

##### Just Me!
Trusted Information Resource
A large number compared to what I have seen in other posts.
Because most do not use batch info for PPM, rather they use part production totals for the calculation.

From your statement you are rejecting the batch for further inspection/rework/scrap. IMHO the data from the batch inspection should be used against the actual part numbers in for your determination using rework/scrap numbers combined to identify those that didn't pass first-time-thru.

V PPM - Internal PPM / External PPM Quality Manager and Management Related Issues 4
Z Predicting External PPM Capability from Internal PPM Capability, Accuracy and Stability - Processes, Machines, etc. 1
P How do you decide what is an acceptable Internal and External PPM number? IATF 16949 - Automotive Quality Systems Standard 17
Internal and external communication procedure for Food Safety Food Safety - ISO 22000, HACCP (21 CFR 120) 2
Internal and external auditor competency to CSR's IATF 16949 - Automotive Quality Systems Standard 20
Using external FDA and ISO 13485 audit as internal audit Internal Auditing 6
External Auditor issue with Internal Audits Internal Auditing 7
D Necessity of external watchdog next to internal watchdog ISO 14971 - Medical Device Risk Management 1
How to determine the internal and external issues in ISO 45001 standard? Occupational Health & Safety Management Standards 2
T Relevant internal and external communication - ISO 9001:2015 section 7.4 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
O Examples of the external and internal issues and their risks and opportunities IATF 16949 - Automotive Quality Systems Standard 2
Y ISO 9001:2015 Cl. 4.1 Note 1 - External and Internal issues ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
External/internal issues removed as well? ISO 9001:2015 Cl. 4.1 ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
M How to Document Internal & External Communications - Suggestions/examples pls IATF 16949 - Automotive Quality Systems Standard 3
Q Managing Internal/External RNC and Complaints in same Format ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
M Metric/Way to show how Internal DPPM and External DPPM relate to each other Nonconformance and Corrective Action 1
P Is Internal and external audit of Account Department applicable to any ISO standard Internal Auditing 5
R Can a external auditor raise a finding that is already identified in Internal Audit ? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 11
M Internal Audit finding versus External Audit finding General Auditing Discussions 2
G Scope of External & Internal Audits General Auditing Discussions 10
D Combining Internal & External Corrective Action Requests Nonconformance and Corrective Action 5
K Free from any Undue Internal and External Pressures - 4.1.5b clarification General Measurement Device and Calibration Topics 2
T ISO 17025 - 4.1.5b Internal/External commercial, financial, and other pressures ISO 17025 related Discussions 3
G Internal vs. External PFMEA Severity Rankings FMEA and Control Plans 12
J Can An External Auditor Also Write The Same Non-Conformance As An Internal Auditor? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
Most Common Internal/External Audit Observations on Risk Management ISO 14971 - Medical Device Risk Management 4
S Internal and External Audit Programme Implementation Internal Auditing 6
S How to quantify the Benefits of Internal and External OHS audits? Occupational Health & Safety Management Standards 4
K Can I join External or Online Internal Auditor Courses Apart from my Company...? Training - Internal, External, Online and Distance Learning 4
M Internal and External Customer Survey Procedure and Form examples wanted ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
B Critical Action Limits (CAL) for All Internal and External Audit Findings General Auditing Discussions 17
D External Parties performing Internal Audits? TS 16949 Clause 8.2.2 IATF 16949 - Automotive Quality Systems Standard 15
S External Auditor Findings when an Internal Audit found a Nonconformance Yesterday Document Control Systems, Procedures, Forms and Templates 11
S External or Internal Design Change and Responsibilities Document Control Systems, Procedures, Forms and Templates 3
R ISO 9001 Internal Quality Audit by Consultants (External agency) Internal Auditing 5
Can External Audits by Customer be treated As Internal Audits AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 21
7.6.3 Internal or External Laboratory? Measuring instruments used in production IATF 16949 - Automotive Quality Systems Standard 9
E First external audit coming up, do I need to have performed Internal Audits already? Internal Auditing 15
P External Contract Auditor for Internal Quality Audit Internal Auditing 25
C Document Control for External and Internal Projects (overseas projects) ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
A Audit Database that captures internal, external audits - Prime Part 21 manufacturer Quality Assurance and Compliance Software Tools and Solutions 12
P Internal vs. external audit training course differences? Internal Auditing 18
H Internal / External Auditors from the same Field / Section / Group? Internal Auditing 2
External Consultant as Internal Auditor - Can NC be issued by TS Auditor? Internal Auditing 18
R ISO 9001 Internal & External Communication Requirements ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 11
N Handling External Audits with Internal Vacations General Auditing Discussions 101
A External Audit CAR when Internal Audit CAR is in process? General Auditing Discussions 34
F The difference between External Records vs. Internal Records Records and Data - Quality, Legal and Other Evidence 11
N "For Reference Only" - Internal and External Documents Document Control Systems, Procedures, Forms and Templates 14
B Internal Audits save you from Non-Conformances on external audits? General Auditing Discussions 16