Rolled Throughput Yield (Not First Time Yield)

[Anonymous]

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:

FTY = DIVIDE(SUM(ProdOrderRouting[Accept Qty]), SUM(ProdOrderRouting[Expected Qty]), 0)

Thanks

[Anonymous]

[amitchandak]

@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.

[Anonymous]

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%