M
MACRE0
Situation: Our clients are on consignment which means they already hav
a bunch of our product ready to be used. When they use some thos
products are reordered and received 5 days from that point. If 1
orders occur per month, I am interested to know how often overlap
occur - the percent of time a second, third, four, and fifth order wil
be placed within those 5 days. (obvious the vast majority of the tim
there will be 2 orders within 5 days of one another). I understan
there are some excel functions that can help me with this. Does anyon
know what they are or are they familiar with the math behind such
senerio.
I can make a program to average the percentage of time this occurs bu
I'm looking for the math behind it, or a 1 step function.
Thanks.
-MACR
a bunch of our product ready to be used. When they use some thos
products are reordered and received 5 days from that point. If 1
orders occur per month, I am interested to know how often overlap
occur - the percent of time a second, third, four, and fifth order wil
be placed within those 5 days. (obvious the vast majority of the tim
there will be 2 orders within 5 days of one another). I understan
there are some excel functions that can help me with this. Does anyon
know what they are or are they familiar with the math behind such
senerio.
I can make a program to average the percentage of time this occurs bu
I'm looking for the math behind it, or a 1 step function.
Thanks.
-MACR