I have an issue that I cannot wrap my head around. I am looking for ordering volatility within a certain time frame. So to explain, the contract has an annual demand qty. (ADQ), we are to keep half of that ADQ on hand, according to contract. From time to time, the customer will order in chunks that exceed that half of demand qty. What I am trying to find, is a formula that will look through all 36000 orders since inception of contract, and isolate qty's that exceed half of the ADQ, within a 6 month period or less. I have uploaded my example to show what I am talking about that I did manually, but when I go to manage attachments, the paper clip, it does not show up
Edit: I see that it did show up. So the highlighted section in red, is customer volatility, ordering more than half ADQ within a one day period, but it could be as large as a six month period. Hope that makes sense.
Bookmarks