#### Preet Inder

##### New Member

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.