To create pareto charts

Pareto charts are used to identify the item characteristics that contribute most to non-conformance, and therefore require more improvement.

To plot this chart you must select the combination of item or item/supplier, inspection source, aspect/characteristic and the relevant time period. This chart is based only on actual inspection results.

Example:

The total percentage is not 100 percent. Example 3 Characteristics with all the same number of rejects will be 3 times 33 percent. However, it is not possible to round off one result to 34 percent

Pareto chart data

The data is saved in the Reject Statistics by Characteristic (qmptc1545m000). You can modify/create data based on the following rules:

  • Create/Update a record only when there is a recommended reject quantity for the order inspection.
  • Create/Update the entire reject quantity. When the result of the inspection order line is rejected for a characteristic, the total order quantity is considered as reject quantity.

The below example explains how data is entered in the Reject Statistics by Characteristic (qmptc1545m000) session.

Batch Batch Qty Rejected Qty Characteristic Sample Sample Good Sample Bad Pareto Analysis
1 1000 1000 C1 10 7 3 75% (3/4)
      C2 10 10 0 0% (0/4)
      C3 10 9 1 25% (1/4)
2 1000 0 C1 10 10 0 0% (0/1)
      C2 10 8 1 100% (1/1)
      C3 10 5 0 0% (0/1)
Total 2000 2000 C1 20 17 3 60% (3/5)
      C2 20 18 1 20% (1/5)
      C3 20 14 1 20% (1/5)
    4000   60 49 5  
  • For Batch 1, the results are: C1 - 75%, C3 - 25%, C2 - 0% (batch 1 rejected)
  • For Batch 2, the results are: C2 - 100%, C1 - 0%, C3 - 0% (batch 2 accepted)
  • For the item (total in the period), the results are: C1 - 60%, C2 - 20%, C3 - 20% (total of both batches).
Order Inspection Item Recommended Accepted Quantity Recommended Rejected Quantity
ORD001 Item001 100 0
ORD002 Item002 0 100
ORD003 Item003 80 20

The inspection orders and lines data is:

Order Inspection Inspection Order Line Aspect/Characteristic Result
ORD001 INS001 10 Width Accepted
ORD001 INS002 20 Weight Accepted
ORD002 INS003 10 Width Accepted
ORD002 INS004 20 Weight Rejected
ORD003 INS005 10 Width Accepted
ORD003 INS006 20 Weight Rejected
Note: When the accepted and rejected quantity is entered for Order Inspection ORD003, the Standard Test Procedure option can be set to either Continuous or 100 percent.

The following reject statistics is generated:

Item Aspect/Characteristic Rejected Cumulative
Item002 Weight 100
Item003 Weight 20
Note: Statistics is not generated for item001 because there is no reject quantity for the item.