An Excel work book having two sheets, one is for entering daily transaction of items i.e. receipts and despatched.
in sheet1 just code of the item will be entered, upon doing this name of the item will be automatically shown.
In sheet2 stock of every item is updated after each transaction. If stock quantity becomes lower than reorder level (pre-defined) than stock report will show it.
Sheet2 is entirely protected and sheet1 is partially protect but any body can check the results of the project.
114 freelancers are bidding on average $270 for this job
I will provide you the project data as the way you would like to find. I will work daily from 7 pm to 12 pm. I will make sure you get the quality work. I hope you will prefer quality instead of quantity.