New to the forum so hi everyone.
Im trying to put together a predictive stock usage spreadsheet as per attached, but cant help thinking this isnt the best way of doing it.
Just to give you an idea, I have the days of the month across the top and then the following
Row 3 is simply the days of the month
Row 4 are averaged sales based on the actual sales.
Row 5 are the actual sales on that day of the month.
Row 7 again are days of the month
Row 8 are actual physical stocks
Row 10 are days of the month
Row 11 are predicted stock levels based on predicted sales from row 4.
Am I missing a trick somewhere along the line and there is a far easier way of doing this?
I realise I havent accounted for stocks in yet, but thats simple enough. Im just wondering if there is a better way excel can handle forecasts or predictive sales etc?
Many thanks in advance for anyone who offers any help and advice on this.
Pickle.
Bookmarks