Forum Discussion
Rolled Throughput Yield (Not First Time Yield)
Hello,
I am new to Power BI and this is my first post.
How can I calculate Rolled Throughput Yield as shown in the example?
| Routing | Operation | Sum of Expected Qty | Sum of Accept Qty | Sum of Reject Qty | FTY | RTY |
| ROUTING 1 | 10 | 500 | 490 | 10 | 98.00% | 98.00% |
| ROUTING 1 | 20 | 490 | 490 | 0 | 100.00% | 98.00% |
| ROUTING 1 | 30 | 490 | 475 | 15 | 96.94% | 95.00% |
| ROUTING 1 | 40 | 475 | 423 | 52 | 89.05% | 84.60% |
| ROUTING 1 | 50 | 423 | 422 | 1 | 99.76% | 84.40% |
This needs to be done in a report visual.
RTY is found by multiplying the Yields of each process step (First Time Yield)
I managed to do FTY, seems to work.
But cannot figure out how to do RTY?
For the FTY my measure is written as:
Thanks
3 Replies
Anonymous , not able to find/understand Yield and process.
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.Hi amitchandak
I am trying to show how many items are output from each operation in the routing.
Then, using this information we can calculate the First Time Yield which is the % of units that were output.
On operation 1, if we expected to output 10 items and only 9 were successful, this is a first time yield of 90% for operation 1.
On operation 2 we have 9 available to start, but only 8 were completed. On operation 2 the first time yield is therefore 88.9%.
The rolled throughput yield is calculated at each stage of the manufacturing process, on each operation. It is a product of the first time yield of each operation up to that point.
In the above example, rolled throughput yield is as follows:
Operation 1 = 90%
Operation 2 = 90% x 88.9% = 80.0%
