I need to show actual variances in delivery volumes as a forecast for the next available delivery date. So if a store has a delivery on Monday and Thursday and on Monday they are -100 cases I need to show +100 cases on Thursday.
This is made more complicated as stores have different delivery dates and no. of deliveries per week. I have attached a spreadsheet with more information to help - if anyone can help that would be appreciated.
Thanks,
Sahil
Bookmarks