How Get a Poisson Value

[Anonymous]

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 )

[sunny_talwar]

Check here

Poisson Distribution in Qlik Sense ?