Small Business Inventory Consumption Forcast Spreadsheet
Budget: £20 – £250 GBP
I am looking for a spreadsheet where I can input my daily sales on each tab for say up to 30 days (30 tabs) using custom SKU e.g. Product A, Product B etc. Each product will have sold mutltiple times during the day which mean Product A could be on Line 1, 5, 20 etc with a quantity sold for that transaction.
On the last/first tab I need it to show how many products (SKU) we have sold during those days I've inputted data, then work out a projection based on the daily average a product has sold.
e.g. if I input Product A each day 5 times for 30 days that would mean 150 sold during those 30 days combined.
I then can work out the daily average of 5 based over 30 days of selling etc.
Kind Regards
On the last/first tab I need it to show how many products (SKU) we have sold during those days I've inputted data, then work out a projection based on the daily average a product has sold.
e.g. if I input Product A each day 5 times for 30 days that would mean 150 sold during those 30 days combined.
I then can work out the daily average of 5 based over 30 days of selling etc.
Kind Regards