- Can get the location wise stock analysis of the items sold, or item wise across locations.
- Based on the Minimum stock level in the respective location, can identify the best transfer location to get the stocks from.
- As the stocks arrive in the location the inventory would be adjusted.
- All operations can be done via click of button.
- Done similar inventory management.
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- Extensively the macros/VBA to automate:
- Data camparision using formulas, lookups and summaries.,
- Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells
- Data camparision using formulas, lookups and bringing up summaries.,