Process Yield Calculator

Process Yield Calculator
Click to see an example

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. Process yield measures are basically obtained by dividing good product units produced by the number of total units entered the process. Many companies use two metrics 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, and consequently, it substantially less than final yield. Rolled throughput yield provides a better insight of defect and rework rates, and considered an accurate reflection of the process performance.

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

This worksheet is supported by two process capability tables; one for the long-term capability and the other for the short-term capability. Other capability metrics can be calculated based on the entered data, such as Sigma level, DPMO and CpK.

Related Templates