How Get a Poisson Value

Anonymous — Fri, 13 Apr 2018 15:09:21 GMT

Hello everyone,

I have a problem to solve, but I can't solve:

I Have a Table with the values

ID | #PARTS USED IN YEAR | # PARTS FOR LEAD TIME 7 DAYS |

P1 624 11,97

P2 15 0,29

P3 145 2,78

With the POISSON formula in excel =POISSON(10;11.97;TRUE) I get that value 35,07%

=POISSON( NUMBER DELIVERED OF PARTS ; PARTS FOR LEAD TIME 7 DAYS;TRUE)

The result is a number of parts (10) that I need to deliver to have an availability of the 35,07%

And I have a variable vAvailability that I input the Availability goal that I wish.

Ex: If I wish a minimum 95% of availability, I must delivery 18 Part Numbers

=POISSON(18;624;TRUE) = 96,34%

I looking a formula that give me the number of parts I need to maintain the availability up to vAvailability variable.

* PARTS FOR LEAD TIME 7 DAYS = 624 / ( 365 / 7 )

Re: How Get a Poisson Value

sunny_talwar — Fri, 13 Apr 2018 17:03:53 GMT

Check here