Quote:
Originally Posted by SteveG[_2_]
This leaves me confused ...
|
Dear Steve, Dear all,
This leaves me confused too!
I guess I'm faced with a simular problem as yours. I am trying to estimate the number of spare parts required to keep in stock to give me a 90% Service level (protection level).
At the moment, the reverse calculation for demand with normal distribution is no problem ( x = NORMSINV ("ServiceLevel") ) however I could not find such for Poisson demand. So, simular to your earlier question;
input = Service level and Mean demand (cumulative = True)
and output the number of spare parts required?
I follow your reasoning and I fully agree with your conclusion;
Quote:
Originally Posted by SteveG[_2_]
I still see the degrees of freedom
or Alpha parameters as inputs when they contain the x number of
spares.
|
Unfortunately, in my version of Excel, I can not find anything close to the "crit_poisson(B70,D70)" that you SteveG are using. My version of Excel is "Excel 2010".
Can anyone help me to solve this using Excel 2010 and/or by not using the "crit_poisson()" function? Thanks a lot! KRG Erik