We require a custom excel stocksheet which allows us to manage our stock levels. This will require an excellent knowledge of Excel. We need a spreadsheet which will allow us to do the following tasks:
- View stock currently in warehouse.
- Enter stock arriving on a monthly basis to calculate the stock on hand after each given delivery.
- Enter pre orders to automatically subtract stock as orders come in.
Please only apply if you have done this before and have an excellent understanding of excel.