Preet Inder
New Member
Hi, there is a situation where i am stuck at calculating %achievement vs target on daily basis. Please see the example below:
Product A and B are received from a Supplier on dates 1,2,3 June ( received qty / target qty )
Total Requirement of Product A: 150 and Product B 200
Received: Product A: 145 and Product B: 180
So, on day 1 for Product A % achievement is 50% & on day 2 it is 100% ( not more than 100% as the plan was for 50 pcs only )
So, this is how we calculate:
Actual Calculation ( how it is supposed to be done )
Avg. Achievement is 56.66%
Now if i try to apply formula and calculate in excel by totaling the received qty against targeted qty the % achievement for each day comes out to be
Avg: 138.88% ( WHICH IS WRONG )
Please guide how should I apply the formula
Thanks in Advance.
Product A and B are received from a Supplier on dates 1,2,3 June ( received qty / target qty )
Total Requirement of Product A: 150 and Product B 200
Received: Product A: 145 and Product B: 180
1 | 2 | 3 | |
A (recvd qty / target qty ) | 25/50 | 60/50 | 60/50 |
B (recvd qty / target qty ) | 0/100 | 90/0 | 90/100 |
So, on day 1 for Product A % achievement is 50% & on day 2 it is 100% ( not more than 100% as the plan was for 50 pcs only )
So, this is how we calculate:
Actual Calculation ( how it is supposed to be done )
1 June | 2 June | 3 June | ||
Product A | 50 % | 100 % | 100% | |
Product B | 0 | 0 | 90% | |
Average: | 25% | 50% | 95% |
Avg. Achievement is 56.66%
Now if i try to apply formula and calculate in excel by totaling the received qty against targeted qty the % achievement for each day comes out to be
1 | 2 | 3 |
16.66 % | 300% | 100% |
Avg: 138.88% ( WHICH IS WRONG )
Please guide how should I apply the formula
Thanks in Advance.