You have chosen to sponsor your bid up to a maximum amount of .
I require a excel spreadsheet to be designed for stock control.It needs to be multiple page format with the information to be able to be read from multiple pages to create a master sheet.
We have 100 products that need to have costings, sale price and profit margins and sales assigned against.
Each Month we will have an opening stock and then 3-4 times a month we receive stock that needs to be entered in bulk
At the end of the month we then do a stocktake that will be entered
From this stock take we will gather a closing stock balance and $ amount as well as a sales amount and $ figure
The spreadsheet will cover multiple pages and be of a neat design and simple to read and use