I would like to set up an excel file which automatically calculates the inventory stock of different items at different locations, knowing that some items maybe retired from the rotation, or written-off from the rotation and that some items may also be non-returnable upon delivery. This file should include some historical chart displaying the evolution of the time it takes for the stock to be returned to the main location from any secondary (client) location.
Inputs should only be made in the movement sheet.
Please, do ask any question necessary before you quote.
7 freelancers are bidding on average $150 for this job
I have sound knowledge about invertory management and inventory counting along with proper excel expertise. Hopefully my knowledge will help to get the work properly.