All Case StudiesSupply Chain
Aligning vending machine stock
Two systems, two realities. They needed to talk to each other.
Two separate data sources: the SAP inventory on Infrabel's side, and the actual stock reported by the dispenser supplier's portal.
01
The problem
After extracting the SAP inventory and the machine stock from the supplier's portal, no one was really comparing the two. There was no reliable way to know where replenishment was actually needed, or where stock errors were hiding.
02
The solution
I built a tool that automatically cross-checks both extracts, detects discrepancies and replenishment errors, identifies actual needs, and then drafts the email to send to the carrier to schedule returns.
03
How it works
- Automatic cross-check between SAP and supplier portal extracts
- Detection of discrepancies and replenishment errors
- Identification of actual replenishment needs
- Automatic drafting of the carrier email
04
The results
- Stock discrepancies detected automatically
- Replenishment needs identified without re-entering data
- Automated carrier communication
05
What this project demonstrates
Data analysisSupply ChainSAPAutomation
Tools: Advanced Excel · Power Query · SAP