Inventory ERP Excel Designer

We require a specialist Excel developer capable of designing an ERP worksheet that can facilitate efficient inventory management. Notably, this will be identified through its ability to:

- Track product movements (Received from Dock, Moved to Location, Picked, RTS)
- Forecast demand accurately
- Calculate reorder points precisely (Flag Products that are low in stock)
- Distribute picklists to employees (Generate a picklist and have employees confirm Picking them)
- Picked parts must be scanned out of inventory once employee picks qty
- All picking will be archived on weekly basis to reduce worksheet size
- Layout the worksheet to match our IR Scanning format
- Ex. When picking (Scan out Sequens is Location, Part, QTY)
- Ensure daily inventory updates are possible (Inventory has to be LIVE)
- Add a dashboard for visual view of KPI's and results

The ideal candidate will have proven experience in ERP Excel design, particularly within the field of inventory management. Expertise in IR Scanning layout will be strongly favored.

Knowledge needed.
- Excel Formula Mastery
- Pivots Tables
- VBA
- Power BI