Can anyone share their process of how they forecast "Sell In" from "Sell Out" data and "Stock In Hand" where the stock in hand may be fluctuating?
Great question. Two ideas for you:
Let me know if either of these meets your use case. Happy to pivot a different direction if you need.
Thanks for the reply.
It will be option 1 that we are considering. I think the mechanics are fine it was more a case of how people account for fluctuating inventory levels which I guess is an adjustment such as Returns as you mention in your reply. I guess it may be as simple as creating a parameter to apply to the Stock In Hand levels to erode the levels.
Sell Out will be the harder of the two because it all depends on whether the retailer provides their sales and inventory. If they don't, then yeah, you'll have to rely on what you sold-in to the channel and look at the frequency and volume of their purchases.
Not sure if this article will help you or not, but it goes into a lot more detail about how to plan the inventory.
Anxious to hear what you end up doing!