I am looking for someone with plenty of Excel experience to create a working spreadsheet for me.
Currently my warehouse logs each days sales of each product (both website sale and retail) in a new column.
In order to help me predict my stock levels and furture manufacture orders I would like to use this info to create a new spread sheet that does the following:
- Tally’s up how many of each product is sold each week (both website sales and retail, plus over all total)
- Looks at the current total stock to hand – divides it by the average number of product sold per week (agrigated) and estimates how many weeks stock we have to hand.
- Takes into account Cost of Goods – subtracts from both website sales and retail sales, so I can easily see how much each weeks sales have cost me and what the gross profit is on those sales.
I would love to be able to easily see those 3 bits of information, across 3 different sheets on a separate spreadsheet.
As the original data spreadsheet is predominantly for the warehouse, I don’t want them to have access to the extra info. Therefore I would like to pull the info from their working spreadsheet and create a new one.
The spreadsheet is currently shared via Dropbox. Happy to request the info be stored on Google or One Drive if it needs to be??
Let me know if you think you can help, and how many hours this creation will take.
Sarah – [url removed, login to view]
sarah@[url removed, login to view]