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 )
