Process Yield Calculator

Process yield measures are metrics used to better understand process yield. These metrics should be able to reveal even the smallest inefficiencies in the process in to order to improve process efficiency and capability. The primary objective of process yield measures is to assess the ratio of good product units to the total units that enter the process. Typically, two key metrics are used to measure the total process yield: final yield and rolled throughput yield.

This process yield worksheet can be used to calculate both final yield and rolled throughput yield. Final yield will only look at the volume of the produced units at the end of the process. Rolled throughput yield on the other hand will be calculated at each process step, making it considerably lower than final yield. It provides a better insight of defect, rework rates, and the overall process performance.

This calculator runs in Microsoft Excel, and you can use and modify it to suit your specific needs. For example, you may want to add additional process step fields if your process involves more steps. You may also want to consider the calculation of rework rates and other relevant measures.

This worksheet is supported by two process capability tables: one for the long-term capability and another for the short-term capability. Other capability metrics can be calculated based on the entered data, such as Sigma level, Defects Per Million Opportunities (DPMO), and Process Capability Index (CpK).